public static function GetID($name) { $ret = db_query("SELECT country.id\n\t\t\t\t\tFROM\t\tcountries\t\tAS country\n\t\t\t\t\tWHERE\t\tSTRCMP(country.name,'%s')=0\n\t\t\t\t\tLIMIT\t\t0, 1\n\t\t\t\t\t", $name); if (!$ret) { Error::generate('debug', 'Could not query db in Country::GetID'); return array(); } $ret = db_get_result($ret); return $ret; }
public static function GetID($name, $country_id = false) { if ($country_id) { $country_constraint = "AND\tarea.country = '{$country_id}'"; } else { $country_constraint = ''; } $ret = db_query("SELECT area.id\n\t\t\t\t\tFROM\t\tareas\t\t\tAS area,\n\t\t\t\t\t\t\t\tcountries\t\tAS country\n\t\t\t\t\tWHERE\t\tSTRCMP(area.name,'%s')=0\n\t\t\t\t\t\t\t\t{$country_constraint}\n\t\t\t\t\tLIMIT\t\t0, 1\n\t\t\t\t\t", $name); if (!$ret) { Error::generate('debug', 'Could not query db in Area::GetID'); return array(); } $ret = db_get_result($ret); return $ret; }
public static function GetID($name, $area_id = false, $country_id = false) { if ($area_id) { $area_constraint = "AND area.id = '{$area_id}'"; } else { $area_constraint = ''; } if ($country_id) { $country_constraint = "AND country.id = '{$country_id}'"; } else { $country_constraint = ''; } $ret = db_query("SELECT uni.id\n\t\t\t\t\tFROM\t\tuniversities\tAS uni,\n\t\t\t\t\t\t\t\tareas\t\t\tAS area,\n\t\t\t\t\t\t\t\tcountries\t\tAS country\n\t\t\t\t\tWHERE\t\tSTRCMP(uni.name,'%s')=0\n\t\t\t\t\t\tAND\t\tuni.area = area.id\n\t\t\t\t\t\tAND\t\tarea.country = country.id\n\t\t\t\t\t\t\t\t{$area_constraint}\n\t\t\t\t\t\t\t\t{$country_constraint}\n\t\t\t\t\tLIMIT\t\t0, 1\n\t\t\t\t\t", $name); if (!$ret) { Error::generate('debug', 'Could not query db in University::GetID'); return array(); } $ret = db_get_result($ret); if (isset($_SESSION)) { $_SESSION['university'] = $ret; } return $ret; }
protected static function get_id($name) { $res = db_query("SELECT id FROM %ss WHERE name='%s'", static::subGetClass(), $name); if (!$res || !($ret = db_get_result($res))) { Error::generate('debug', 'Could not query database in get_id'); return false; } else { return intval($ret); } }
public static function GetReadCount($id) { db_query("SELECT\tCOUNT(*)\n\t\t\t\t\tFROM\tprivatemessages\n\t\t\t\t\tWHERE\tparent='%d'\n\t\t\t\t\t\tAND flags&1\n\t\t\t\t\t\tAND type='1'", $id); return db_get_result(); }