示例#1
0
 static function latest($start, $num)
 {
     DB::prepare_query($query, "SELECT * FROM `submission` ORDER BY `time` DESC LIMIT " . (int) $start . "," . (int) $num);
     $query->execute(array());
     DB::check_errors($query);
     return Submission::fetch_all($query);
 }
示例#2
0
文件: User.php 项目: jlsa/justitia
 function submissions_to($entity)
 {
     if (!$entity->submitable()) {
         return array();
     }
     static $query;
     DB::prepare_query($query, "SELECT * FROM `user_submission` LEFT JOIN `submission` ON `user_submission`.`submissionid` = `submission`.`submissionid`" . " WHERE `userid`=? AND `entity_path`=?" . " ORDER BY `time` DESC");
     $query->execute(array($this->userid, $entity->path()));
     return Submission::fetch_all($query);
 }
示例#3
0
文件: Entity.php 项目: jlsa/justitia
 function submissions_after($latest_submissionid)
 {
     static $query;
     DB::prepare_query($query, "SELECT * FROM `submission` WHERE `entity_path` LIKE ? AND `time` > (SELECT `time` FROM `submission` WHERE `submissionid` = ?) ORDER BY `time` DESC");
     $query->execute(array($this->path() . '%', $latest_submissionid));
     return Submission::fetch_all($query);
 }