public function Get_One_Level() { global $templates; $this->id = $_GET['id']; $this->level_position = $_POST['level_position']; $sql = "select id,level_position,level_info from manage_level where id='{$this->id}' or level_position='{$this->level_position}' limit 1 ;"; return parent::one($sql); }
public function getOneComment() { $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\t\tid \n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\t\tcms_comment\n\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\t\tid='{$this->id}' \n\t\t\t\t\t\t\t\tLIMIT \n\t\t\t\t\t\t\t\t\t\t\t1"; return parent::one($_sql); }
public static function getByATD($alumn, $team, $date_at) { $sql = "select * from " . self::$tablename . " where alumn_id={$alumn} and team_id={$team} and date_at=\"{$date_at}\""; $query = Executor::doit($sql); return Model::one($query[0], new BlockData()); }
public static function getById($id) { $sql = "select * from " . self::$tablename . " where id={$id}"; $query = Executor::doit($sql); return Model::one($query[0], new ClientData()); }
public static function getFriendship($user_id, $friend_id) { $sql = "select * from " . self::$tablename . " where (sender_id={$user_id} and receptor_id={$friend_id}) or (receptor_id={$user_id} and sender_id={$friend_id}) "; $query = Executor::doit($sql); return Model::one($query[0], new FriendData()); }
public static function getReceptorId($id) { $sql = "select receptor_ref_id,author_ref_id from " . self::$tablename . " where id={$id}"; $query = Executor::doit($sql); return Model::one($query[0], new PostData()); }
public function Get_One_User() { $sql = "select * from user where id='{$this->id}' limit 1 ;"; return parent::one($sql); }
public function getOneManage() { $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\tid,\n\t\t\t\t\t\t\t\t\t\tadmin_user,\n\t\t\t\t\t\t\t\t\t\tadmin_pass,\n\t\t\t\t\t\t\t\t\t\tlevel \n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\tcms_manage \n\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\tid='{$this->id}' \n\t\t\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\t\t\t\tadmin_user='******'\n\t\t\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\t\t\t\tlevel='{$this->level}'\n\t\t\t\t\t\t\t\tLIMIT \n\t\t\t\t\t\t\t\t\t\t1"; return parent::one($_sql); }
public function Get_Title_Info() { $sql = "select \r\n\t\t\t\t\t\t\t\tcon.title,\r\n\t\t\t\t\t\t\t\tcon.info\r\n\t\t\t\t\t\tfrom\r\n\t\t\t\t\t\t\t\tcontent as con\r\n\t\t\t\t\t\tleft join\r\n\t\t\t\t\t\t\t\tcomment as com\r\n\t\t\t\t\t\ton\r\n\t\t\t\t\t\t\t\tcom.cid = con.id \r\n\t\t\t\t\t\twhere\r\n\t\t\t\t\t\t\t\tcom.cid ='{$this->cid}'\r\n\t\t\t\t\t\tlimit 1"; return parent::one($sql); }
public function getOneTag() { $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\t\tid \n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\t\tcms_tag \n\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\t\ttagname='{$this->tagname}'"; return parent::one($_sql); }
public function getOneContent() { $_sql = "select id, title, nav, attr, content, info, date, count, author, source, thumbnail, tag, color, keyword, sort, readlimit, commend, gold from cms_content where id='{$this->id}';"; return parent::one($_sql); }
public static function getAll() { $sql = "select * from " . self::$tablename; $query = Executor::doit($sql); return Model::one($query[0], new NotificationTypeData()); }
public function getParam() { $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\tparam1,\n\t\t\t\t\t\t\t\t\t\tparam2,\n\t\t\t\t\t\t\t\t\t\tparam3\n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\ttg_module\n\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\tmid='{$this->mid}'\n\t\t\t\t\t\t\t\tLIMIT 1"; return parent::one($_sql); }
public static function getByBA($block, $alumn) { $sql = "select * from " . self::$tablename . " where alumn_id={$alumn} and block_id={$block}"; $query = Executor::doit($sql); return Model::one($query[0], new CalificationData()); }
public static function countByUserId($id) { $sql = "select count(*) as c from " . self::$tablename . " where user_id={$id}"; $query = Executor::doit($sql); return Model::one($query[0], new TeamData()); }
public function getOneManage() { $_sql = "select admin_user,admin_pass,level from cms_manage where id='{$this->id}' limit 0,1"; return parent::one($_sql); }
public static function getByName($name) { $sql = "select * from " . self::$tablename . " where name=\"{$name}\""; $query = Executor::doit($sql); return Model::one($query[0], new ChannelData()); }
public function checkLogin() { $_sql = "select id, user, pass, face from cms_user where user='******' and pass='******' limit 1;"; return parent::one($_sql); }
public function getOneLevel() { $_sql = "select id, level_name, level_info from cms_level where id='{$this->id}' or level_name='{$this->level_name}' limit 1;"; return parent::one($_sql); }
public static function countUnReadsByUC($uid, $id) { $sql = "select count(*) as c from " . self::$tablename . " where is_readed=0 and user_id!={$uid} and conversation_id={$id}"; $query = Executor::doit($sql); return Model::one($query[0], new MessageData()); }
public static function getLogin($email, $password) { $sql = "select * from " . self::$tablename . " where email=\"{$email}\" and password=\"{$password}\""; $query = Executor::doit($sql); return Model::one($query[0], new UserData()); }
public function getOneNav() { $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\tn1.id,\n\t\t\t\t\t\t\t\t\t\tn1.nav_name,\n\t\t\t\t\t\t\t\t\t\tn1.nav_info,\n\t\t\t\t\t\t\t\t\t\tn2.id iid,\n\t\t\t\t\t\t\t\t\t\tn2.nav_name nnav_name\n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\tcms_nav n1\n\t\t\t\t\t\t\tLEFT JOIN\n\t\t\t\t\t\t\t\t\t\tcms_nav n2\t\n\t\t\t\t\t\t\t\t\tON\n\t\t\t\t\t\t\t\t\t\tn1.pid=n2.id\n\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\tn1.id='{$this->id}'\n\t\t\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\t\t\t\tn1.nav_name='{$this->nav_name}'\n\t\t\t\t\t\t\t\tLIMIT \n\t\t\t\t\t\t\t\t\t\t1"; return parent::one($_sql); }
public static function getByAT($a, $t) { $sql = "select * from " . self::$tablename . " where alumn_id={$a} and team_id={$t}"; $query = Executor::doit($sql); return Model::one($query[0], new AlumnTeamData()); }
public function getOneComment() { $_sql = "select id from cms_comment where id='{$this->id}' limit 1;"; return parent::one($_sql); }
public function checkLogin() { $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\tid,\n\t\t\t\t\t\t\t\t\t\tuser,\n\t\t\t\t\t\t\t\t\t\tpass,\n\t\t\t\t\t\t\t\t\t\tface \n\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\tcms_user \n\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\tuser='******' \n\t\t\t\t\t\t\t\tAND \n\t\t\t\t\t\t\t\t\t\tpass='******'\n\t\t\t\t\t\t\tLIMIT \n\t\t\t\t\t\t\t\t\t\t1"; return parent::one($_sql); }
public function Get_id_from_content() { $sql = "select \r\n\t\t\t\t\t\t\tnav.id,\r\n\t\t\t\t\t\t\tnav.parid,\r\n\t\t\t\t\t\t\tnav.name\r\n\t\t\t\t\tfrom\r\n\t\t\t\t\t\t\tnav,content\r\n\t\t\t\t\twhere\r\n\t\t\t\t\t\t\tcontent.nav=nav.id \r\n\t\t\t\t\tand \r\n\t\t\t\t\t\t\tcontent.id='{$this->id}'"; return parent::one($sql); }
public static function getByMail($mail) { $sql = "select * from " . self::$tablename . " where mail=\"{$mail}\""; $query = Executor::doit($sql); return Model::one($query[0], new EventData()); }
public static function countByRT($r, $t) { $sql = "select count(*) as c from " . self::$tablename . " where ref_id={$r} and type_id={$t}"; $query = Executor::doit($sql); return Model::one($query[0], new CommentData()); }
public static function getByPreffix($id) { $sql = "select * from " . self::$tablename . " where short_name=\"{$id}\""; $query = Executor::doit($sql); return Model::one($query[0], new StatusData()); }
public function getOnePremission() { $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\t\tid,\n\t\t\t\t\t\t\t\t\t\t\tname,\n\t\t\t\t\t\t\t\t\t\t\tinfo\n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\t\tcms_premission \n\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\t\tid='{$this->id}'\n\t\t\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\t\t\t\t\tname='{$this->name}'\n\t\t\t\t\t\t\t\tLIMIT\t \n\t\t\t\t\t\t\t\t\t\t\t1"; return parent::one($_sql); }