I have found the following within the property mod globals, which is an included file.
function get_house_name($id) {
global $db;
$get = $db->query("SELECT `name` FROM `property_mod` WHERE `id`={$id}");
return $db->fetch_single($get);
}
function get_house_name_by_row($row) {
global $db;
$get = $db->query("SELECT `name` FROM `property_mod` WHERE `id` IN (SELECT `houseid` FROM `properties_mod_user` WHERE `id`={$row})");
return $db->fetch_single($get);
}
This is out of the global func file.
}
function get_rank($stat, $mykey)
{
global $db;
global $ir,$userid,$c;
$q=$db->query("SELECT count(*) FROM userstats us LEFT JOIN users u ON us.userid=u.userid WHERE us.$mykey > $stat AND us.userid != $userid AND u.user_level != 0") ;
return $db->fetch_single($q)+1;
}
function item_add($user, $itemid, $qty, $notid=0)
{
global $db;
if($notid > 0)
{