File Manager

X7ROOT File Manager

Current Path: /home/jurarevi/beta.jurareview.ro/application/models

home / jurarevi / beta.jurareview.ro / application / models /

📁 ..
📄 announcements_model.php(1.01 KB)
📄 chapters_model.php(5.22 KB)
📄 headerfooter_model.php(1.05 KB)
📄 index.html(114 B)
📄 menu_model.php(2.28 KB)
📄 miscconfig_model.php(1.98 KB)
📄 pagini_model.php(1.22 KB)
📄 sidebars_model.php(873 B)
📄 volumes_model.php(3.9 KB)

Editing: miscconfig_model.php

<?php

class MiscConfig_Model extends MY_Model {

public function getConfigByCategory($category)
    {
        $sql = "
			SELECT
				*
			FROM MiscConfig 
			WHERE `category` = '" . $category . "'
		";
        $query = $this->db->query($sql);
        return $query->result_array();
    }

public function getConfigList()
    {
        $sql = "
			SELECT
				*
			FROM MiscConfig 
		";
        $query = $this->db->query($sql);
        return $query->result_array();
    }

public function getConfig($id)
    {
        $sql = "
			SELECT
				*
			FROM MiscConfig 
			WHERE `Type` = '" . $id . "'
		";
        $query = $this->db->query($sql);
        return $query->row_array();
    }

public function updadeConfigFirstInt($id, $firstInt)
    {
        $sql = "
            UPDATE MiscConfig
            SET 
              `fistInt` = " . $firstInt ."
            WHERE `id` = '" . $id . "'
        ";

$query = $this->db->query($sql);
        return true;
    }

public function updadeConfigSecondInt($id, $secondInt)
    {
        $sql = "
            UPDATE MiscConfig
            SET 
              `secondInt` = " . $secondInt .",
            WHERE `id` = '" . $id . "'
        ";

$query = $this->db->query($sql);
        return true;
    }

public function updadeConfigFirstText($id, $firstText)
    {
        $sql = "
            UPDATE MiscConfig
            SET 
              `firstText` = '" . mysql_real_escape_string($firstText) ."'
            WHERE `id` = '" . $id . "'
        ";

$query = $this->db->query($sql);
        return true;
    }

public function updadeConfigSecondText($id,$secondText)
    {
        $sql = "
            UPDATE MiscConfig
            SET 
              `secondText` = '" . mysql_real_escape_string($secondText) ."'
            WHERE `id` = '" . $id . "'
        ";

$query = $this->db->query($sql);
        return true;
    }

}

X7ROOT File Manager

Editing: miscconfig_model.php

Upload File

Create Folder