citywebshop_cms/application/models/admin_settings_model.php

<?php

class admin_settings_model extends Model {
    
    
    public function getSettings() {
        $result = $this->query("select * from azonics_settings where setting_status<>'0';");
        return $result;
    }
    
    
    public function loadSettings() {
        $setting_id = $this->escapeString($_REQUEST['id']);
        $row = $this->query("select * from azonics_settings where setting_id='".$setting_id."';");
        return $row[0];
    }
    
    
    public function saveSettings() {
        $data = $this->escapeArray($_REQUEST);
        if ($data['setting_id']!='') {
            $this->execute("update azonics_settings set "
                    . "setting_name='".$data['setting_name']."', "
                    . "setting_value_text='".$data['setting_value_text']."', "
                    . "setting_value_text_en='".$data['setting_value_text_en']."', "
                    . "setting_value_num='".$data['setting_value_num']."', "
                    . "setting_value_list='".$data['setting_value_list']."' where setting_id='".$data['setting_id']."';");
            
            return true;
        }
        else {
            $checkAlredy = $this->query("select * from azonics_settings where "
                    . "setting_name='".$data['setting_name']."' and "
                    . "setting_status='1';");
            
            if (sizeof($checkAlredy)>0) {
                return false;
            }
            else {
                $this->execute("insert into azonics_settings set "
                    . "setting_name='".$data['setting_name']."', "
                    . "setting_value_text='".$data['setting_value_text']."', "
                    . "setting_value_text_en='".$data['setting_value_text_en']."', "
                    . "setting_value_num='".$data['setting_value_num']."', "
                    . "setting_value_list='".$data['setting_value_list']."', "
                    . "setting_status='1', "
                    . "setting_user_id='".$_SESSION['admin_user']->admin_id."';");
            
                return true;
            }
        }
    }
    
    
    public function deleteSettings() {
        $setting_id = $this->escapeString($_REQUEST['id']);
        $this->execute("update azonics_settings set setting_status='0' where setting_id='".$setting_id."';");
        return true;
    }
    
    
}