$value) { if($this->in_string($trigger, $string, true)) { return $value; } } return "Unknown"; } function GetRaidEventFromString($string) { global $lua_set_EventTriggers; foreach($lua_set_EventTriggers as $trigger => $value) { if($this->in_string($trigger, $string, true)) { return $value; } } return "Unknown Event"; } function GetItemName($itemid) { global $gitemlist, $itemidtoname; if(empty($gitemlist) && file_exists("itemlist.xml")) { $itemlisthandle = fopen("itemlist.xml", "r"); while(!feof($itemlisthandle)) { $itemlistbuffer = fgets($itemlisthandle, 1024); preg_match_all("//s", $itemlistbuffer, $itemlista, PREG_SET_ORDER); foreach($itemlista as $itemlistdata) { $gitemlist[$itemlistdata[2]] = $itemlistdata[1]; } } fclose($itemlisthandle); } if(function_exists("GetItemName"))// Just ignore this, it's my part to get the itemname from my database { $altitemname = @GetItemName($itemid, $lang = "en"); } if(!empty($altitemname)) { return $altitemname; } elseif(!empty($gitemlist[$itemid])) { return $gitemlist[$itemid]; } elseif(!empty($itemidtoname[$itemid])) { return $itemidtoname[$itemid]; } else { return false; } } function ConvertTimestringToTimestamp($timestring) { $parts = preg_split('/[\/ :]/', $timestring); return mktime($parts[3], $parts[4], $parts[5], $parts[0], $parts[1], $parts[2]); } function in_string($needle, $haystack, $insensitive = false) { if($insensitive) { $haystack = strtolower($haystack); $needle = strtolower($needle); } return(false !== strpos($haystack, $needle)) ? true : false; } function GetMainItemId($itemid) { $itemid = trim($itemid, "item:"); $itemid = preg_split("/:/", $itemid); return $itemid[0]; } function GetItemQualityByColor($color) { $color = strtolower($color); if($color == "ffa335ee") { return 4; } elseif($color == "ff0070dd") { return 3; } elseif($color == "ff1eff00") { return 2; } elseif($color == "ffffffff") { return 1; } elseif($color == "ff9d9d9d") { return 0; } else { return -1; } } function GetDkpValue($item) { global $db; $value = $db->query("SELECT MIN(`item_value`) as minval FROM ".ITEMS_TABLE." WHERE `item_name` = '".mysql_escape_string($item)."';"); $value = $db->fetch_record($value); return $value['minval']; } function GetClassIdByClassNameLevel($classname, $level) { global $db; $value = $db->query("SELECT `class_id` FROM ".CLASS_TABLE." WHERE `class_name` = '".mysql_escape_string($classname)."' AND `class_min_level` <= '".mysql_escape_string($level)."' AND `class_max_level` >= '".mysql_escape_string($level)."' ORDER by class_min_level DESC;"); if($db->num_rows($value) >= 1) { $value = $db->fetch_record($value); return $value['class_id']; } else { return 0; } } function GetRaceIdByRaceName($racename) { global $db; if($racename == "Scourge") { $racename = "Undead"; } elseif($racename == "NightElf") { $racename = "Night Elf"; } $value = $db->query("SELECT `race_id` FROM ".RACE_TABLE." WHERE `race_name` = '".mysql_escape_string($racename)."';"); if($db->num_rows($value) >= 1) { $value = $db->fetch_record($value); return $value['race_id']; } else { return 0; } } function GetRankIdByRankName($rankname) { global $db; $value = $db->query("SELECT `rank_id` FROM ".MEMBER_RANKS_TABLE." WHERE `rank_name` = '".mysql_escape_string($rankname)."';"); if($db->num_rows($value) >= 1) { $value = $db->fetch_record($value); return $value['rank_id']; } else { return 0; } } function GetClassNameByClassId($classid) { global $db; $value = $db->query("SELECT `class_name` FROM ".CLASS_TABLE." WHERE `class_id` = '".mysql_escape_string($classid)."';"); if($db->num_rows($value) >= 1) { $value = $db->fetch_record($value); return $value['class_name']; } else { return "Unknown"; } } function GetRaceNameByRaceId($raceid) { global $db; $value = $db->query("SELECT `race_name` FROM ".RACE_TABLE." WHERE `race_id` = '".mysql_escape_string($raceid)."';"); if($db->num_rows($value) >= 1) { $value = $db->fetch_record($value); return $value['race_name']; } else { return "Unknown"; } } function GetRankNameByRankId($rankid) { global $db; $value = $db->query("SELECT `rank_name` FROM ".MEMBER_RANKS_TABLE." WHERE `rank_id` = '".mysql_escape_string($rankid)."';"); if($db->num_rows($value) >= 1) { $value = $db->fetch_record($value); if(!empty($value['rank_name'])) { return $value['rank_name']; } else { return "None"; } } else { return "None"; } } function GenerateUniqId() { return md5(uniqid(rand(), true)); } function StripUniqIdFromString($string) { return preg_replace("/(.*?)-[a-z0-9]{32}-(.*?)/", "\\1\\2", $string); } function StripSpecialChars($string) { $string = strtr($string, "\xA1\xAA\xBA\xBF\xC0\xC1\xC2\xC3\xC5\xC7\xC8\xC9\xCA\xCB\xCC\xCD\xCE\xCF\xD0\xD1\xD2\xD3\xD4\xD5\xD8\xD9\xDA\xDB\xDD\xE0\xE1\xE2\xE3\xE5\xE7\xE8\xE9\xEA\xEB\xEC\xED\xEE\xEF\xF0\xF1\xF2\xF3\xF4\xF5\xF8\xF9\xFA\xFB\xFD\xFF", "!ao?AAAAACEEEEIIIIDNOOOOOUUUYaaaaaceeeeiiiidnooooouuuyy"); $string = strtr($string, array("\xC4"=>"Ae", "\xC6"=>"AE", "\xD6"=>"Oe", "\xDC"=>"Ue", "\xDE"=>"TH", "\xDF"=>"ss", "\xE4"=>"ae", "\xE6"=>"ae", "\xF6"=>"oe", "\xFC"=>"ue", "\xFE"=>"th")); return($string); } ?>