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