Subversion-Projekte lars-tiefland.ci

Revision

Revision 2234 | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 2234 Revision 2383
Zeile 11... Zeile 11...
11 
 * Liest die Bilder von Artikeln oder Kategorien aus
 11 
 * Liest die Bilder von Artikeln oder Kategorien aus
12 
 *
12 
 *
13 
 * @package WebanOS CI
 13 
 * @package WebanOS CI
14 
 * @author Lars Tiefland
 14 
 * @author Lars Tiefland
15 
 * @copyright 2016
 15 
 * @copyright 2016
16 
 * @version $Id: Medien_model.php 2234 2017-12-23 22:54:44Z lars $
 16 
 * @version $Id: Medien_model.php 2383 2018-10-05 17:37:09Z lars $
17 
 * @access public
 17 
 * @access public
18 
 */
 18 
 */
19 
class Medien_model extends CI_Model
 19 
class Medien_model extends CI_Model
20 
{
 20 
{
21 
	private $sql;
 21 
	private $sql;
Zeile 149... Zeile 149...
149 
			"nein",
 149 
			"nein",
150 
			"ja",
 150 
			"ja",
151 
			);
 151 
			);
152 
		$this->smarty->assign("aehnlich", $aehnlich);
 152 
		$this->smarty->assign("aehnlich", $aehnlich);
153 
		$this->sql["medien"]["list"] = "SELECT
 153 
		$this->sql["medien"]["list"] = "SELECT
154 
                *
 154 
				*
155 
            FROM
 155 
			FROM
156 
                medien
 156 
				medien
157 
            WHERE
 157 
			WHERE
158 
                folder=?
 158 
				folder=?
159 
            AND
 159 
			AND
160 
                typ!=3
 160 
				typ!=3
161 
        ";
 161 
		";
Zeile 162... Zeile 162...
162 
 
 162 
 
163 
		$this->sql["medien"]["artikel_add"] = "INSERT INTO
 163 
		$this->sql["medien"]["artikel_add"] = "INSERT INTO
164 
                artikel_medien
 164 
				artikel_medien
165 
            SET
 165 
			SET
166 
                medien_id=?,
 166 
				medien_id=?,
167 
                artikel_id=?,
 167 
				artikel_id=?,
168 
                rang=?,
 168 
				rang=?,
169 
                aehnlich=0
 169 
				aehnlich=0
170 
        ";
 170 
		";
171 
		$this->sql["medien"]["directory_add"] = "INSERT INTO
 171 
		$this->sql["medien"]["directory_add"] = "INSERT INTO
172 
                directory_medien
 172 
				directory_medien
173 
            SET
 173 
			SET
174 
                medien_id=?,
 174 
				medien_id=?,
175 
                directory_id=?,
 175 
				directory_id=?,
176 
                rang=?,
 176 
				rang=?,
177 
                aehnlich=0
 177 
				aehnlich=0
178 
        ";
 178 
		";
Zeile 179... Zeile 179...
179 
	}
 179 
	}
180 
 
 180 
 
181 
	/**
 181 
	/**
Zeile 341... Zeile 341...
341 
		$l_type = $this->input->get("l_type");
 341 
		$l_type = $this->input->get("l_type");
342 
		$l_id = $this->input->get("l_id");
 342 
		$l_id = $this->input->get("l_id");
343 
		switch ($l_type) {
 343 
		switch ($l_type) {
344 
			case "a":
 344 
			case "a":
345 
				$sql = "SELECT
 345 
				$sql = "SELECT
346 
                        MAX(rang) AS rang
 346 
						MAX(rang) AS rang
347 
                    FROM
 347 
					FROM
348 
                        artikel_medien
 348 
						artikel_medien
349 
                    WHERE
 349 
					WHERE
350 
                        artikel_id=" . $l_id . "
 350 
						artikel_id=" . $l_id . "
351 
                ";
 351 
				";
352 
				$addSql = $this->sql["medien"]["artikel_add"];
 352 
				$addSql = $this->sql["medien"]["artikel_add"];
353 
				break;
 353 
				break;
354 
			case "d":
 354 
			case "d":
355 
				$sql = "SELECT
 355 
				$sql = "SELECT
356 
                        MAX(rang) AS rang
 356 
						MAX(rang) AS rang
357 
                    FROM
 357 
					FROM
358 
                        directory_medien
 358 
						directory_medien
359 
                    WHERE
 359 
					WHERE
360 
                        directory_id=" . $l_id . "
 360 
						directory_id=" . $l_id . "
361 
                ";
 361 
				";
362 
				$addSql = $this->sql["medien"]["directory_add"];
 362 
				$addSql = $this->sql["medien"]["directory_add"];
363 
				break;
 363 
				break;
364 
		}
 364 
		}
365 
		$res = $this->db->query($sql);
 365 
		$res = $this->db->query($sql);
366 
		$row = $res->unbuffered_row("array");
 366 
		$row = $res->unbuffered_row("array");