Subversion-Projekte lars-tiefland.ci

<?php

class Design_model extends CI_Model
{
        private $upd_settings = "";
        public function __construct()
        {
                parent::__construct();
                $this->upd_settings = "UPDATE
                                web_settings
                        SET
                                inhalt=?,
                                letzte_aenderung_von='".$_SESSION["username"]."'
                        WHERE
                                id=?
                        AND
                                bestellart_id=1
                        AND
                                shops_id=".$GLOBALS["INI"]["shops_ID"]."
                ";
        }
        public function get_list()
        {
                $sql = "SELECT
                                *
                        FROM
                                web_settings
                        WHERE
                                shops_id=".$GLOBALS["INI"]["shops_ID"]."
                        AND
                                typ IN ('varchar','text','static','date','select')
                        AND
                                bestellart_id=1
                        ORDER BY
                                id
                ";
                $res = $this->db->query($sql);
                $dirs = $res->result_array();
                return $dirs;
        }

        public function get($id)
        {
        }

        public function save()
        {
                $daten = $this->input->post('setting');
                foreach ($daten as $id => $row)
                {
                        $this->db->query($this->upd_settings, array(
                                $row,
                                $id,
                                ));
                }
        }

        public function del($id)
        {
        }

}