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); }
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); }
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); }
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(); } }