Example #1
0
 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);
 }
Example #2
0
 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);
 }
Example #3
0
 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());
 }
Example #4
0
 public static function getById($id)
 {
     $sql = "select * from " . self::$tablename . " where id={$id}";
     $query = Executor::doit($sql);
     return Model::one($query[0], new ClientData());
 }
Example #5
0
 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());
 }
Example #6
0
 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());
 }
Example #7
0
 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);
 }
Example #10
0
 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());
 }
Example #15
0
 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());
 }
Example #16
0
 public function getOneManage()
 {
     $_sql = "select admin_user,admin_pass,level from cms_manage where id='{$this->id}' limit 0,1";
     return parent::one($_sql);
 }
Example #17
0
 public static function getByName($name)
 {
     $sql = "select * from " . self::$tablename . " where name=\"{$name}\"";
     $query = Executor::doit($sql);
     return Model::one($query[0], new ChannelData());
 }
Example #18
0
 public function checkLogin()
 {
     $_sql = "select id, user, pass, face from cms_user where user='******' and pass='******' limit 1;";
     return parent::one($_sql);
 }
Example #19
0
 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);
 }
Example #20
0
 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());
 }
Example #21
0
 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());
 }
Example #22
0
 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);
 }
Example #23
0
 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);
 }
Example #25
0
 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);
 }
Example #26
0
 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);
 }
Example #27
0
 public static function getByMail($mail)
 {
     $sql = "select * from " . self::$tablename . " where mail=\"{$mail}\"";
     $query = Executor::doit($sql);
     return Model::one($query[0], new EventData());
 }
Example #28
0
 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());
 }
Example #29
0
 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);
 }