Subversion-Projekte lars-tiefland.ci

Revision

Revision 1733 | Revision 1745 | Zur aktuellen Revision | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 1733 Revision 1740
Zeile 4... Zeile 4...
4
{
4
{
5
	public function __construct()
5
	public function __construct()
6
	{
6
	{
7
		parent::__construct();
7
		parent::__construct();
8
		$this->load->model('preise_model', 'preise');
8
		$this->load->model('preise_model', 'preise');
-
 
9
		$this->load->model('metatags_model', 'metatags');
9
	}
10
	}
10
	public function get_list($dir = -1)
11
	public function get_list($dir = -1)
11
	{
12
	{
12
		$sql = "SELECT
13
		$sql = "SELECT
13
				*
14
				*
Zeile 33... Zeile 34...
33
				id=".$id."
34
				id=".$id."
34
		";
35
		";
35
		$res = $this->db->query($sql);
36
		$res = $this->db->query($sql);
36
		$row = $res->unbuffered_row('array');
37
		$row = $res->unbuffered_row('array');
37
		$row["preise"] = $this->preise->get($row["ID"]);
38
		$row["preise"] = $this->preise->get($row["ID"]);
38
		$sql = "SELECT
-
 
39
				meta_content,
-
 
40
				meta_type
-
 
41
			FROM
-
 
42
				metatags
-
 
43
			WHERE
-
 
44
				table_foreign='artikel'
-
 
45
			AND
-
 
46
				data_foreign=".$id."
-
 
47
		";
-
 
48
		$res = $this->db->query($sql);
-
 
49
		while ($metaRow = $res->unbuffered_row('array'))
-
 
50
		{
-
 
51
			$row[$metaRow["meta_type"]] = $metaRow["meta_content"];
39
		$row["metatags"] = $this->metatags->get($row["ID"], 'artikel');
52
		}
-
 
53
		return $row;
40
		return $row;
54
	}
41
	}
Zeile 55... Zeile 42...
55
 
42
 
56
	public function save($daten)
43
	public function save($daten)