Пример #1
0
 public static function ListAll()
 {
     $res = db_query("\tSELECT id, resource_id, user_id, comments, creation_timestamp, type\n\t\t\t\t\t\tFROM resourcereports\n\t\t\t\t\t\tORDER BY status, creation_timestamp DESC", $comment_id);
     return db_get_list_of_assoc($res);
 }
Пример #2
0
 public static function ListAllForPage($comment_id)
 {
     $res = db_query("\tSELECT id, comment_id, creation_timestamp\n\t\t\t\t\t\tFROM pageviews\n\t\t\t\t\t\tWHERE comment_id='%d'\n\t\t\t\t\t\tORDER BY creation_timestamp DESC", $comment_id);
     return db_get_list_of_assoc($res);
 }
Пример #3
0
 public static function ListAllStartingWithName($name)
 {
     $res = db_query("SELECT * FROM users\n\t\t\t\t\t\t\tWHERE name REGEXP '^%s.*'\n\t\t\t\t\t\t\tORDER BY creation_timestamp", $name);
     $ret = array();
     if (!$res) {
         Error::generate('debug', 'Could not query database in static::ListAllStartingWithName');
         return array();
     }
     return db_get_list_of_assoc($res);
 }
Пример #4
0
 function getSimilar()
 {
     $res = db_query("\n\t\t\tSELECT crs.id AS crsid, similarity.val AS similarityval, crs.cid AS crscid\n\t\t\t\tFROM\tsimilarities\tAS similarity,\n\t\t\t\t\t\tcoursedefns\t\tAS crs\n\t\t\t\tWHERE\tsimilarity.cid1 = '%d'\n\t\t\t\t\tAND\tsimilarity.val >= 0.2\n\t\t\t\t\tAND crs.cid = similarity.cid2\n\t\t\t\t\tAND crs.university = '%d' ", $this->cid, $this->university);
     $ret = db_get_list_of_assoc($res);
     if ($ret) {
         $fin = array();
         foreach ($ret as $k => $v) {
             $fin[$v['crscid']] = $v['similarityval'];
         }
         return $fin;
     } else {
         return array();
     }
 }