function GetNebuliteInfo($itemid, $locale)
{
$db = ConnectCharacterDatabase($locale);
$key_name = 'data_nebulite_cache' . $itemid;
if (IsCachedObject($key_name, $locale)) {
return GetCachedObject($key_name, $locale);
}
$itemid += 3060000;
$data = array();
$q = $db->query("SELECT description, options FROM `phpvana_socket_info` WHERE `itemid` = " . intval($itemid));
$row = $q->fetch_row();
$data['description'] = $row[0];
$data['info'] = Explode2(';', '=', $row[1]);
SetCachedObject($key_name, $data, $locale);
return $data;
}
public static function GetQuest($character_id, $locale, $quest_id, $internal_quest)
{
$db = ConnectCharacterDatabase($locale);
$q = $db->query("\r\nSELECT\r\n\tquestid,\r\n\t`data`\r\nFROM\r\n\tquests_running" . ($internal_quest == true ? '_party' : '') . "\r\nWHERE\r\n\tcharacter_id = " . $character_id . "\r\n\tAND\r\n\tquestid = " . $quest_id);
if ($q->num_rows == 0) {
// Check if exists in completed quests
$q->free();
$q = $db->query("\r\nSELECT\r\n\tquestid,\r\n\tFROM_FILETIME(`time`) AS `completed`\r\nFROM\r\n\tquests_done" . ($internal_quest == true ? '_party' : '') . "\r\nWHERE\r\n\tcharacter_id = " . $character_id . "\r\n\tAND\r\n\tquestid = " . $quest_id);
if ($q->num_rows == 0) {
// Does not exist
$q->free();
return null;
}
$row = $q->fetch_assoc();
$q->free();
$quest = new Quest();
$quest->id = $row['questid'];
$quest->completion_time = $row['completed'];
return $quest;
}
$row = $q->fetch_assoc();
$q->free();
$quest = new Quest();
$quest->id = $row['questid'];
$quest->data = $row['data'];
$quest->completion_time = null;
$quest->data = Explode2(';', '=', $quest->data);
return $quest;
}
function GetSkillBuffs($internal_id, $locale)
{
$db = ConnectCharacterDatabase($locale);
$q = $db->query("\nSELECT\n\ts.skillid,\n\ts.level,\n\tst.value\nFROM\n\t`skills` s\nLEFT JOIN\n\t`strings` st\n\t\tON\n\tst.objectid = s.skillid\n\t\tAND\n\tst.key = 'buff'\nWHERE\n\ts.`character_id` = " . intval($internal_id) . "\n\t\tAND\n\tst.value IS NOT NULL\n");
$temp = array();
while ($row = $q->fetch_assoc()) {
$temp[$row['skillid']] = array('level' => $row['level'], 'data' => Explode2(';', '=', $row['value']));
}
$q->free();
return $temp;
}
