예제 #1
0
 public static function get_newest($num = 10)
 {
     return DigiplayDB::select("* FROM audio WHERE type = " . AudioTypes::get("Jingle")->get_id() . " ORDER BY id DESC LIMIT " . $num . ";", "Track", true);
 }
예제 #2
0
 public static function get_censored($limit = 0, $offset = 0)
 {
     $limit = $limit > 0 ? " LIMIT " . $limit : "";
     $offset = $offset > 0 ? " OFFSET " . $offset : "";
     return DigiplayDB::select("* FROM audio WHERE type = " . AudioTypes::get("Track")->get_id() . " AND censor = 't' ORDER BY id DESC" . $limit . $offset, "Track", true);
 }