2010-06-08 17:59:24 MaNGOS/0.16.0 (* * Revision 10018 - *) for Linux_x64 (little-endian) [world-daemon] 2010-06-08 17:59:24 to stop. MM MM MM MM MMMMM MMMM MMMMM MM MM MM MM MMM MMM MM MM MMM MMM MMM MMM MMM MM MMM MMM MM MM MMM MM M MM MMMM MM MMM MM MM MMM MM M MM MMMMM MM MMMM MMM MM MM MMM MM M MM M MMM MM MMM MMMMMMM MM MM MMM MM MM MMM MM MM MM MMM MM MM MMM MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM MM MM MM MMM MM MM MMMMMM MMMM MMMMM MM MMM http://getmangos.com MMMMMM 2010-06-08 17:59:24 Using configuration file /home/ivan/gotovoe/config/mangosd.conf. 2010-06-08 17:59:24 OpenSSL 1.0.0 29 Mar 2010 (Library: OpenSSL 0.9.8k 25 Mar 2009) 2010-06-08 17:59:24 Using ACE: 5.6.6 2010-06-08 17:59:24 Daemon PID: 14799 2010-06-08 17:59:24 World Database: 127.0.0.1;3306;user;pass;mangos 2010-06-08 17:59:24 Connected to MySQL database at 127.0.0.1 2010-06-08 17:59:24 MySQL client library: 5.1.41 2010-06-08 17:59:24 MySQL server ver: 5.1.41-3ubuntu12.1 2010-06-08 17:59:24 AUTOCOMMIT SUCCESSFULLY SET TO 1 2010-06-08 17:59:24 [1 ms] SQL: SELECT required_10017_01_mangos_spell_proc_event FROM db_version LIMIT 1 2010-06-08 17:59:24 Character Database: 127.0.0.1;3306;user;pass;characters 2010-06-08 17:59:24 Connected to MySQL database at 127.0.0.1 2010-06-08 17:59:24 MySQL client library: 5.1.41 2010-06-08 17:59:24 MySQL server ver: 5.1.41-3ubuntu12.1 2010-06-08 17:59:24 AUTOCOMMIT SUCCESSFULLY SET TO 1 2010-06-08 17:59:24 [0 ms] SQL: SELECT required_10007_01_characters_pet_aura FROM character_db_version LIMIT 1 2010-06-08 17:59:24 Login Database: 127.0.0.1;3306;user;pass;realmd 2010-06-08 17:59:24 Connected to MySQL database at 127.0.0.1 2010-06-08 17:59:24 MySQL client library: 5.1.41 2010-06-08 17:59:24 MySQL server ver: 5.1.41-3ubuntu12.1 2010-06-08 17:59:24 AUTOCOMMIT SUCCESSFULLY SET TO 1 2010-06-08 17:59:24 [0 ms] SQL: SELECT required_10008_01_realmd_realmd_db_version FROM realmd_db_version LIMIT 1 2010-06-08 17:59:24 Realm running as realm ID 1 2010-06-08 17:59:24 [0 ms] SQL: SELECT version, creature_ai_version, cache_id FROM db_version LIMIT 1 2010-06-08 17:59:24 Using World DB: YTDB_0.13.5_R550_MaNGOS_R10023_SD2_R1706_ACID_R304_RuDB_R37.7 2010-06-08 17:59:24 Using creature EventAI: ACID 3.0.4 - Final Release for Mangos (3.3.2 Client) 2010-06-08 17:59:24 Using DataDir /home/ivan/gotovoe/bin/ 2010-06-08 17:59:24 WORLD: VMap support included. LineOfSight:0, getHeight:0 2010-06-08 17:59:24 WORLD: VMap data directory is: /home/ivan/gotovoe/bin/vmaps 2010-06-08 17:59:24 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds 2010-06-08 17:59:24 [1 ms] SQL: SELECT MAX(guid) FROM characters 2010-06-08 17:59:24 [0 ms] SQL: SET NAMES `utf8` 2010-06-08 17:59:24 [0 ms] SQL: SET CHARACTER SET `utf8` 2010-06-08 17:59:24 [0 ms] SQL: SELECT MAX(guid) FROM creature 2010-06-08 17:59:24 [0 ms] SQL: SET NAMES `utf8` 2010-06-08 17:59:24 [0 ms] SQL: SET CHARACTER SET `utf8` 2010-06-08 17:59:24 [13 ms] SQL: SELECT MAX(guid) FROM item_instance 2010-06-08 17:59:24 [0 ms] SQL: SET NAMES `utf8` 2010-06-08 17:59:24 [0 ms] SQL: SET CHARACTER SET `utf8` 2010-06-08 17:59:24 [0 ms] SQL: UPDATE characters SET online = 0 WHERE online<>0 2010-06-08 17:59:24 [0 ms] SQL: UPDATE character_battleground_data SET instance_id = 0 2010-06-08 17:59:24 [0 ms] SQL: SELECT MAX(guid) FROM gameobject 2010-06-08 17:59:24 [8 ms] SQL: UPDATE account SET active_realm_id = 0 WHERE active_realm_id = '1' 2010-06-08 17:59:24 [0 ms] SQL: SELECT MAX(id) FROM auctionhouse 2010-06-08 17:59:24 [1 ms] SQL: UPDATE realmlist SET allowedSecurityLevel = '0' WHERE id = '1' 2010-06-08 17:59:24 [1 ms] SQL: SELECT MAX(id) FROM mail 2010-06-08 17:59:24 [0 ms] SQL: SELECT MAX(guid) FROM corpse 2010-06-08 17:59:24 [0 ms] SQL: SELECT MAX(arenateamid) FROM arena_team 2010-06-08 17:59:24 [0 ms] SQL: SELECT MAX(setguid) FROM character_equipmentsets 2010-06-08 17:59:24 [0 ms] SQL: SELECT MAX(guildid) FROM guild 2010-06-08 17:59:24 [0 ms] SQL: SELECT MAX(groupId) FROM groups 2010-06-08 17:59:24 [123 ms] SQL: DELETE FROM character_inventory WHERE item >= '1' 2010-06-08 17:59:24 [1 ms] SQL: DELETE FROM mail_items WHERE item_guid >= '1' 2010-06-08 17:59:24 [0 ms] SQL: DELETE FROM auctionhouse WHERE itemguid >= '1' 2010-06-08 17:59:24 [1 ms] SQL: DELETE FROM guild_bank_item WHERE item_guid >= '1' 2010-06-08 17:59:24 2010-06-08 17:59:24 Loading MaNGOS strings... 2010-06-08 17:59:24 [0 ms] SQL: SELECT entry,content_default,content_loc1,content_loc2,content_loc3,content_loc4,content_loc5,content_loc6,content_loc7,content_loc8 FROM mangos_string 2010-06-08 17:59:24 2010-06-08 17:59:24 >> Loaded 801 MaNGOS strings from table mangos_string 2010-06-08 17:59:24 Initialize data stores... 2010-06-08 17:59:24 [1 ms] SQL: DELETE FROM corpse WHERE corpse_type = '0' OR time < (UNIX_TIMESTAMP()-'259200') 2010-06-08 17:59:24 [0 ms] SQL: UPDATE realmlist SET icon = 1, timezone = 1 WHERE id = '1' 2010-06-08 17:59:26 2010-06-08 17:59:26 >> Initialized 85 data stores 2010-06-08 17:59:26 Using ruRU DBC Locale as default. All available DBC locales: ruRU 2010-06-08 17:59:26 2010-06-08 17:59:26 Loading Script Names... 2010-06-08 17:59:26 [0 ms] SQL: SELECT DISTINCT(ScriptName) FROM creature_template WHERE ScriptName <> '' UNION SELECT DISTINCT(ScriptName) FROM gameobject_template WHERE ScriptName <> '' UNION SELECT DISTINCT(ScriptName) FROM item_template WHERE ScriptName <> '' UNION SELECT DISTINCT(ScriptName) FROM areatrigger_scripts WHERE ScriptName <> '' UNION SELECT DISTINCT(script) FROM instance_template WHERE script <> '' 2010-06-08 17:59:26 2010-06-08 17:59:26 >> Loaded 891 Script Names 2010-06-08 17:59:26 Loading InstanceTemplate... 2010-06-08 17:59:26 [0 ms] SQL: SELECT MAX(map) FROM instance_template 2010-06-08 17:59:26 [1 ms] SQL: SELECT COUNT(*) FROM instance_template 2010-06-08 17:59:26 [0 ms] SQL: SELECT * FROM instance_template 2010-06-08 17:59:26 >> Loaded 120 Instance Template definitions 2010-06-08 17:59:26 2010-06-08 17:59:26 Loading SkillLineAbilityMultiMap Data... 2010-06-08 17:59:26 2010-06-08 17:59:26 >> Loaded 10217 SkillLineAbility MultiMap Data 2010-06-08 17:59:26 Cleaning up instances... 2010-06-08 17:59:26 [0 ms] SQL: SELECT id, map, difficulty, resettime FROM instance WHERE resettime > 0 2010-06-08 17:59:26 [0 ms] SQL: SELECT mapid, difficulty, resettime FROM instance_reset 2010-06-08 17:59:26 [11 ms] SQL: SELECT id, map, instance.difficulty FROM instance LEFT JOIN instance_reset ON mapid = map AND instance.difficulty = instance_reset.difficulty WHERE (instance.resettime < '1276005566' AND instance.resettime > '0') OR (NOT instance_reset.resettime IS NULL AND instance_reset.resettime < '1276005566') 2010-06-08 17:59:26 [0 ms] SQL: SELECT character_instance.guid, instance FROM character_instance LEFT JOIN characters ON character_instance.guid = characters.guid WHERE characters.guid IS NULL 2010-06-08 17:59:26 [1 ms] SQL: SELECT group_instance.leaderGuid, instance FROM group_instance LEFT JOIN characters ON group_instance.leaderGuid = characters.guid LEFT JOIN groups ON group_instance.leaderGuid = groups.leaderGuid WHERE characters.guid IS NULL OR groups.leaderGuid IS NULL 2010-06-08 17:59:26 [0 ms] SQL: SELECT id, map, difficulty FROM instance LEFT JOIN character_instance ON character_instance.instance = id LEFT JOIN group_instance ON group_instance.instance = id WHERE character_instance.instance IS NULL AND group_instance.instance IS NULL 2010-06-08 17:59:26 [0 ms] SQL: SELECT character_instance.guid, instance FROM character_instance LEFT JOIN instance ON character_instance.instance = instance.id WHERE instance.id IS NULL 2010-06-08 17:59:26 [0 ms] SQL: SELECT group_instance.leaderGuid, instance FROM group_instance LEFT JOIN instance ON group_instance.instance = instance.id WHERE instance.id IS NULL 2010-06-08 17:59:26 [0 ms] SQL: SELECT id FROM instance 2010-06-08 17:59:26 [0 ms] SQL: SELECT DISTINCT(instance) FROM creature_respawn WHERE instance <> 0 2010-06-08 17:59:26 [0 ms] SQL: SELECT DISTINCT(instance) FROM gameobject_respawn WHERE instance <> 0 2010-06-08 17:59:26 2010-06-08 17:59:26 >> Initialized 0 instances 2010-06-08 17:59:26 Packing instances... 2010-06-08 17:59:26 [0 ms] SQL: SELECT id FROM instance 2010-06-08 17:59:26 >> Instance numbers remapped, next instance id is 1 2010-06-08 17:59:26 2010-06-08 17:59:26 Packing groups... 2010-06-08 17:59:26 [0 ms] SQL: SELECT groupId FROM groups 2010-06-08 17:59:26 >> Group Ids remapped, next group id is 1 2010-06-08 17:59:26 2010-06-08 17:59:26 2010-06-08 17:59:26 Loading Localization strings... 2010-06-08 17:59:26 [19 ms] SQL: SELECT entry,name_loc1,subname_loc1,name_loc2,subname_loc2,name_loc3,subname_loc3,name_loc4,subname_loc4,name_loc5,subname_loc5,name_loc6,subname_loc6,name_loc7,subname_loc7,name_loc8,subname_loc8 FROM locales_creature 2010-06-08 17:59:26 2010-06-08 17:59:26 >> Loaded 21991 creature locale strings 2010-06-08 17:59:26 [1 ms] SQL: SELECT entry,name_loc1,name_loc2,name_loc3,name_loc4,name_loc5,name_loc6,name_loc7,name_loc8,castbarcaption_loc1,castbarcaption_loc2,castbarcaption_loc3,castbarcaption_loc4,castbarcaption_loc5,castbarcaption_loc6,castbarcaption_loc7,castbarcaption_loc8 FROM locales_gameobject 2010-06-08 17:59:26 2010-06-08 17:59:26 >> Loaded 17806 gameobject locale strings 2010-06-08 17:59:26 [33 ms] SQL: SELECT entry,name_loc1,description_loc1,name_loc2,description_loc2,name_loc3,description_loc3,name_loc4,description_loc4,name_loc5,description_loc5,name_loc6,description_loc6,name_loc7,description_loc7,name_loc8,description_loc8 FROM locales_item 2010-06-08 17:59:26 2010-06-08 17:59:26 >> Loaded 36953 Item locale strings 2010-06-08 17:59:26 [9 ms] SQL: SELECT entry,Title_loc1,Details_loc1,Objectives_loc1,OfferRewardText_loc1,RequestItemsText_loc1,EndText_loc1,CompletedText_loc1,ObjectiveText1_loc1,ObjectiveText2_loc1,ObjectiveText3_loc1,ObjectiveText4_loc1,Title_loc2,Details_loc2,Objectives_loc2,OfferRewardText_loc2,RequestItemsText_loc2,EndText_loc2,CompletedText_loc2,ObjectiveText1_loc2,ObjectiveText2_loc2,ObjectiveText3_loc2,ObjectiveText4_loc2,Title_loc3,Details_loc3,Objectives_loc3,OfferRewardText_loc3,RequestItemsText_loc3,EndText_loc3,CompletedText_loc3,ObjectiveText1_loc3,ObjectiveText2_loc3,ObjectiveText3_loc3,ObjectiveText4_loc3,Title_loc4,Details_loc4,Objectives_loc4,OfferRewardText_loc4,RequestItemsText_loc4,EndText_loc4,CompletedText_loc4,ObjectiveText1_loc4,ObjectiveText2_loc4,ObjectiveText3_loc4,ObjectiveText4_loc4,Title_loc5,Details_loc5,Objectives_loc5,OfferRewardText_loc5,RequestItemsText_loc5,EndText_loc5,CompletedText_loc5,ObjectiveText1_loc5,ObjectiveText2_loc5,ObjectiveText3_loc5,ObjectiveText4_loc5,Title_loc6,Details_loc6,Objectives_loc6,OfferRewardText_loc6,RequestItemsText_loc6,EndText_loc6,CompletedText_loc6,ObjectiveText1_loc6,ObjectiveText2_loc6,ObjectiveText3_loc6,ObjectiveText4_loc6,Title_loc7,Details_loc7,Objectives_loc7,OfferRewardText_loc7,RequestItemsText_loc7,EndText_loc7,CompletedText_loc7,ObjectiveText1_loc7,ObjectiveText2_loc7,ObjectiveText3_loc7,ObjectiveText4_loc7,Title_loc8,Details_loc8,Objectives_loc8,OfferRewardText_loc8,RequestItemsText_loc8,EndText_loc8,CompletedText_loc8,ObjectiveText1_loc8,ObjectiveText2_loc8,ObjectiveText3_loc8,ObjectiveText4_loc8 FROM locales_quest 2010-06-08 17:59:27 2010-06-08 17:59:27 >> Loaded 9453 Quest locale strings 2010-06-08 17:59:27 [1 ms] SQL: SELECT entry,Text0_0_loc1,Text0_1_loc1,Text1_0_loc1,Text1_1_loc1,Text2_0_loc1,Text2_1_loc1,Text3_0_loc1,Text3_1_loc1,Text4_0_loc1,Text4_1_loc1,Text5_0_loc1,Text5_1_loc1,Text6_0_loc1,Text6_1_loc1,Text7_0_loc1,Text7_1_loc1,Text0_0_loc2,Text0_1_loc2,Text1_0_loc2,Text1_1_loc2,Text2_0_loc2,Text2_1_loc2,Text3_0_loc2,Text3_1_loc1,Text4_0_loc2,Text4_1_loc2,Text5_0_loc2,Text5_1_loc2,Text6_0_loc2,Text6_1_loc2,Text7_0_loc2,Text7_1_loc2,Text0_0_loc3,Text0_1_loc3,Text1_0_loc3,Text1_1_loc3,Text2_0_loc3,Text2_1_loc3,Text3_0_loc3,Text3_1_loc1,Text4_0_loc3,Text4_1_loc3,Text5_0_loc3,Text5_1_loc3,Text6_0_loc3,Text6_1_loc3,Text7_0_loc3,Text7_1_loc3,Text0_0_loc4,Text0_1_loc4,Text1_0_loc4,Text1_1_loc4,Text2_0_loc4,Text2_1_loc4,Text3_0_loc4,Text3_1_loc1,Text4_0_loc4,Text4_1_loc4,Text5_0_loc4,Text5_1_loc4,Text6_0_loc4,Text6_1_loc4,Text7_0_loc4,Text7_1_loc4,Text0_0_loc5,Text0_1_loc5,Text1_0_loc5,Text1_1_loc5,Text2_0_loc5,Text2_1_loc5,Text3_0_loc5,Text3_1_loc1,Text4_0_loc5,Text4_1_loc5,Text5_0_loc5,Text5_1_loc5,Text6_0_loc5,Text6_1_loc5,Text7_0_loc5,Text7_1_loc5,Text0_0_loc6,Text0_1_loc6,Text1_0_loc6,Text1_1_loc6,Text2_0_loc6,Text2_1_loc6,Text3_0_loc6,Text3_1_loc1,Text4_0_loc6,Text4_1_loc6,Text5_0_loc6,Text5_1_loc6,Text6_0_loc6,Text6_1_loc6,Text7_0_loc6,Text7_1_loc6,Text0_0_loc7,Text0_1_loc7,Text1_0_loc7,Text1_1_loc7,Text2_0_loc7,Text2_1_loc7,Text3_0_loc7,Text3_1_loc1,Text4_0_loc7,Text4_1_loc7,Text5_0_loc7,Text5_1_loc7,Text6_0_loc7,Text6_1_loc7,Text7_0_loc7,Text7_1_loc7, Text0_0_loc8,Text0_1_loc8,Text1_0_loc8,Text1_1_loc8,Text2_0_loc8,Text2_1_loc8,Text3_0_loc8,Text3_1_loc1,Text4_0_loc8,Text4_1_loc8,Text5_0_loc8,Text5_1_loc8,Text6_0_loc8,Text6_1_loc8,Text7_0_loc8,Text7_1_loc8 FROM locales_npc_text 2010-06-08 17:59:27 2010-06-08 17:59:27 >> Loaded 4815 NpcText locale strings 2010-06-08 17:59:27 [1 ms] SQL: SELECT entry,text_loc1,text_loc2,text_loc3,text_loc4,text_loc5,text_loc6,text_loc7,text_loc8 FROM locales_page_text 2010-06-08 17:59:27 2010-06-08 17:59:27 >> Loaded 1649 PageText locale strings 2010-06-08 17:59:27 [0 ms] SQL: SELECT menu_id,id,option_text_loc1,box_text_loc1,option_text_loc2,box_text_loc2,option_text_loc3,box_text_loc3,option_text_loc4,box_text_loc4,option_text_loc5,box_text_loc5,option_text_loc6,box_text_loc6,option_text_loc7,box_text_loc7,option_text_loc8,box_text_loc8 FROM locales_gossip_menu_option 2010-06-08 17:59:27 2010-06-08 17:59:27 >> Loaded 1580 gossip_menu_option locale strings 2010-06-08 17:59:27 [0 ms] SQL: SELECT entry,icon_name_loc1,icon_name_loc2,icon_name_loc3,icon_name_loc4,icon_name_loc5,icon_name_loc6,icon_name_loc7,icon_name_loc8 FROM locales_points_of_interest 2010-06-08 17:59:27 2010-06-08 17:59:27 >> Loaded 540 points_of_interest locale strings 2010-06-08 17:59:27 >>> Localization strings loaded 2010-06-08 17:59:27 2010-06-08 17:59:27 Loading Page Texts... 2010-06-08 17:59:27 [0 ms] SQL: SELECT MAX(entry) FROM page_text 2010-06-08 17:59:27 [0 ms] SQL: SELECT COUNT(*) FROM page_text 2010-06-08 17:59:27 [0 ms] SQL: SELECT * FROM page_text 2010-06-08 17:59:27 >> Loaded 1862 page texts 2010-06-08 17:59:27 2010-06-08 17:59:27 Loading Game Object Templates... 2010-06-08 17:59:27 [1 ms] SQL: SELECT MAX(entry) FROM gameobject_template 2010-06-08 17:59:27 [0 ms] SQL: SELECT COUNT(*) FROM gameobject_template 2010-06-08 17:59:27 [2 ms] SQL: SELECT * FROM gameobject_template 2010-06-08 17:59:27 >> Loaded 19222 game object templates 2010-06-08 17:59:27 2010-06-08 17:59:27 Loading Spell Chain Data... 2010-06-08 17:59:27 [0 ms] SQL: SELECT spell_id, prev_spell, first_spell, rank, req_spell FROM spell_chain 2010-06-08 17:59:27 2010-06-08 17:59:27 >> Loaded 2597 spell chain records 2010-06-08 17:59:27 Loading Spell Elixir types... 2010-06-08 17:59:27 [0 ms] SQL: SELECT entry, mask FROM spell_elixir 2010-06-08 17:59:27 2010-06-08 17:59:27 >> Loaded 132 spell elixir definitions 2010-06-08 17:59:27 Loading Spell Learn Skills... 2010-06-08 17:59:27 2010-06-08 17:59:27 >> Loaded 99 Spell Learn Skills from DBC 2010-06-08 17:59:27 Loading Spell Learn Spells... 2010-06-08 17:59:27 [0 ms] SQL: SELECT entry, SpellID, Active FROM spell_learn_spell 2010-06-08 17:59:27 2010-06-08 17:59:27 >> Loaded 19 spell learn spells + 572 found in DBC 2010-06-08 17:59:27 Loading Spell Proc Event conditions... 2010-06-08 17:59:27 [0 ms] SQL: SELECT entry, SchoolMask, SpellFamilyName, SpellFamilyMask0, SpellFamilyMask1, SpellFamilyMask2, procFlags, procEx, ppmRate, CustomChance, Cooldown FROM spell_proc_event 2010-06-08 17:59:27 2010-06-08 17:59:27 >> Loaded 748 extra spell proc event conditions +87 custom 2010-06-08 17:59:27 Loading Spell Bonus Data... 2010-06-08 17:59:27 [0 ms] SQL: SELECT entry, direct_bonus, dot_bonus, ap_bonus FROM spell_bonus_data 2010-06-08 17:59:27 2010-06-08 17:59:27 >> Loaded 126 extra spell bonus data 2010-06-08 17:59:27 Loading Spell Proc Item Enchant... 2010-06-08 17:59:27 [0 ms] SQL: SELECT entry, ppmRate FROM spell_proc_item_enchant 2010-06-08 17:59:27 2010-06-08 17:59:27 >> Loaded 3 proc item enchant definitions 2010-06-08 17:59:27 Loading Aggro Spells Definitions... 2010-06-08 17:59:27 [0 ms] SQL: SELECT entry, Threat FROM spell_threat 2010-06-08 17:59:27 2010-06-08 17:59:27 >> Loaded 126 aggro generating spells 2010-06-08 17:59:27 Loading NPC Texts... 2010-06-08 17:59:27 [27 ms] SQL: SELECT * FROM npc_text 2010-06-08 17:59:27 2010-06-08 17:59:27 >> Loaded 5934 npc texts 2010-06-08 17:59:27 Loading Item Random Enchantments Table... 2010-06-08 17:59:27 [1 ms] SQL: SELECT entry, ench, chance FROM item_enchantment_template 2010-06-08 17:59:27 2010-06-08 17:59:27 >> Loaded 28691 Item Enchantment definitions 2010-06-08 17:59:27 Loading Items... 2010-06-08 17:59:27 [0 ms] SQL: SELECT MAX(entry) FROM item_template 2010-06-08 17:59:27 [0 ms] SQL: SELECT COUNT(*) FROM item_template 2010-06-08 17:59:27 [1 ms] SQL: SELECT * FROM item_template 2010-06-08 17:59:29 >> Loaded 37177 item prototypes 2010-06-08 17:59:29 2010-06-08 17:59:29 Loading Creature Model Based Info Data... 2010-06-08 17:59:29 [0 ms] SQL: SELECT MAX(modelid) FROM creature_model_info 2010-06-08 17:59:29 [0 ms] SQL: SELECT COUNT(*) FROM creature_model_info 2010-06-08 17:59:29 [0 ms] SQL: SELECT * FROM creature_model_info 2010-06-08 17:59:29 >> Loaded 23900 creature model based info 2010-06-08 17:59:29 2010-06-08 17:59:29 Loading Equipment templates... 2010-06-08 17:59:29 [0 ms] SQL: SELECT MAX(entry) FROM creature_equip_template 2010-06-08 17:59:29 [0 ms] SQL: SELECT COUNT(*) FROM creature_equip_template 2010-06-08 17:59:29 [1 ms] SQL: SELECT * FROM creature_equip_template 2010-06-08 17:59:29 >> Loaded 4000 equipment template 2010-06-08 17:59:29 2010-06-08 17:59:29 Loading Creature templates... 2010-06-08 17:59:29 [0 ms] SQL: SELECT MAX(entry) FROM creature_template 2010-06-08 17:59:29 [1 ms] SQL: SELECT COUNT(*) FROM creature_template 2010-06-08 17:59:30 [16 ms] SQL: SELECT * FROM creature_template 2010-06-08 17:59:31 >> Loaded 29347 creature definitions 2010-06-08 17:59:31 2010-06-08 17:59:31 Loading SpellsScriptTarget... 2010-06-08 17:59:31 [0 ms] SQL: SELECT entry,type,targetEntry FROM spell_script_target 2010-06-08 17:59:31 2010-06-08 17:59:31 >> Loaded 1256 Spell Script Targets 2010-06-08 17:59:31 Loading ItemRequiredTarget... 2010-06-08 17:59:31 [0 ms] SQL: SELECT entry,type,targetEntry FROM item_required_target 2010-06-08 17:59:31 2010-06-08 17:59:31 >> Loaded 252 Item required targets 2010-06-08 17:59:31 Loading Creature Reputation OnKill Data... 2010-06-08 17:59:31 [0 ms] SQL: SELECT creature_id, RewOnKillRepFaction1, RewOnKillRepFaction2,IsTeamAward1, MaxStanding1, RewOnKillRepValue1, IsTeamAward2, MaxStanding2, RewOnKillRepValue2, TeamDependent FROM creature_onkill_reputation 2010-06-08 17:59:31 2010-06-08 17:59:31 >> Loaded 2254 creature award reputation definitions 2010-06-08 17:59:31 Loading Points Of Interest Data... 2010-06-08 17:59:31 [0 ms] SQL: SELECT entry, x, y, icon, flags, data, icon_name FROM points_of_interest 2010-06-08 17:59:31 2010-06-08 17:59:31 >> Loaded 488 Points of Interest definitions 2010-06-08 17:59:31 Loading Creature Data... 2010-06-08 17:59:31 [127 ms] SQL: SELECT creature.guid, id, map, modelid,equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint,curhealth, curmana, DeathState, MovementType, spawnMask, phaseMask, event, pool_entry FROM creature LEFT OUTER JOIN game_event_creature ON creature.guid = game_event_creature.guid LEFT OUTER JOIN pool_creature ON creature.guid = pool_creature.guid 2010-06-08 17:59:33 2010-06-08 17:59:33 >> Loaded 138705 creatures 2010-06-08 17:59:33 Loading pet levelup spells... 2010-06-08 17:59:33 2010-06-08 17:59:33 >> Loaded 1634 pet levelup and default spells for 39 families 2010-06-08 17:59:33 Loading pet default spell additional to levelup spells... 2010-06-08 17:59:33 2010-06-08 17:59:33 >> Loaded addition spells for 102 pet spell data entries and 667 summonable creature templates 2010-06-08 17:59:33 Loading Creature Addon Data... 2010-06-08 17:59:33 2010-06-08 17:59:33 [0 ms] SQL: SELECT MAX(entry) FROM creature_template_addon 2010-06-08 17:59:33 [0 ms] SQL: SELECT COUNT(*) FROM creature_template_addon 2010-06-08 17:59:33 [0 ms] SQL: SELECT * FROM creature_template_addon 2010-06-08 17:59:33 >> Loaded 8215 creature template addons 2010-06-08 17:59:33 2010-06-08 17:59:33 [0 ms] SQL: SELECT MAX(guid) FROM creature_addon 2010-06-08 17:59:33 [0 ms] SQL: SELECT COUNT(*) FROM creature_addon 2010-06-08 17:59:33 [1 ms] SQL: SELECT * FROM creature_addon 2010-06-08 17:59:33 >> Loaded 26478 creature addons 2010-06-08 17:59:33 2010-06-08 17:59:33 >>> Creature Addon Data loaded 2010-06-08 17:59:33 2010-06-08 17:59:33 Loading Creature Respawn Data... 2010-06-08 17:59:33 [0 ms] SQL: DELETE FROM creature_respawn WHERE respawntime <= UNIX_TIMESTAMP(NOW()) 2010-06-08 17:59:33 [1 ms] SQL: SELECT guid,respawntime,instance FROM creature_respawn 2010-06-08 17:59:33 2010-06-08 17:59:33 >> Loaded 0 creature respawn time. 2010-06-08 17:59:33 Loading Gameobject Data... 2010-06-08 17:59:33 [53 ms] SQL: SELECT gameobject.guid, id, map, position_x, position_y, position_z, orientation,rotation0, rotation1, rotation2, rotation3, spawntimesecs, animprogress, state, spawnMask, phaseMask, event, pool_entry FROM gameobject LEFT OUTER JOIN game_event_gameobject ON gameobject.guid = game_event_gameobject.guid LEFT OUTER JOIN pool_gameobject ON gameobject.guid = pool_gameobject.guid 2010-06-08 17:59:35 2010-06-08 17:59:35 >> Loaded 88754 gameobjects 2010-06-08 17:59:35 Loading Gameobject Respawn Data... 2010-06-08 17:59:35 [15 ms] SQL: DELETE FROM gameobject_respawn WHERE respawntime <= UNIX_TIMESTAMP(NOW()) 2010-06-08 17:59:35 [0 ms] SQL: SELECT guid,respawntime,instance FROM gameobject_respawn 2010-06-08 17:59:35 2010-06-08 17:59:35 >> Loaded 0 gameobject respawn time. 2010-06-08 17:59:35 Loading Objects Pooling Data... 2010-06-08 17:59:35 [0 ms] SQL: SELECT MAX(entry) FROM pool_template 2010-06-08 17:59:35 [0 ms] SQL: SELECT entry,max_limit FROM pool_template 2010-06-08 17:59:35 2010-06-08 17:59:35 >> Loaded 12887 objects pools 2010-06-08 17:59:35 [0 ms] SQL: SELECT guid, pool_entry, chance FROM pool_creature 2010-06-08 17:59:35 2010-06-08 17:59:35 >> Loaded 1238 creatures in pools 2010-06-08 17:59:35 [0 ms] SQL: SELECT guid, pool_entry, chance FROM pool_gameobject 2010-06-08 17:59:35 2010-06-08 17:59:35 >> Loaded 32699 gameobject in pools 2010-06-08 17:59:35 [0 ms] SQL: SELECT pool_id, mother_pool, chance FROM pool_pool 2010-06-08 17:59:35 2010-06-08 17:59:35 >> Loaded 7328 pools in mother pools 2010-06-08 17:59:35 Loading Game Event Data... 2010-06-08 17:59:35 2010-06-08 17:59:35 [0 ms] SQL: SELECT MAX(entry) FROM game_event 2010-06-08 17:59:35 [0 ms] SQL: SELECT entry,UNIX_TIMESTAMP(start_time),UNIX_TIMESTAMP(end_time),occurence,length,holiday,description FROM game_event 2010-06-08 17:59:35 2010-06-08 17:59:35 >> Loaded 43 game events 2010-06-08 17:59:35 [0 ms] SQL: SELECT creature.guid, game_event_creature.event FROM creature JOIN game_event_creature ON creature.guid = game_event_creature.guid 2010-06-08 17:59:35 2010-06-08 17:59:35 >> Loaded 6521 creatures in game events 2010-06-08 17:59:35 [0 ms] SQL: SELECT gameobject.guid, game_event_gameobject.event FROM gameobject JOIN game_event_gameobject ON gameobject.guid=game_event_gameobject.guid 2010-06-08 17:59:35 2010-06-08 17:59:35 >> Loaded 21562 gameobjects in game events 2010-06-08 17:59:35 [1 ms] SQL: SELECT creature.guid, game_event_model_equip.event, game_event_model_equip.modelid,game_event_model_equip.equipment_id FROM creature JOIN game_event_model_equip ON creature.guid=game_event_model_equip.guid 2010-06-08 17:59:35 2010-06-08 17:59:35 >> Loaded 886 model/equipment changes in game events 2010-06-08 17:59:35 [1 ms] SQL: SELECT id, quest, event FROM game_event_creature_quest 2010-06-08 17:59:35 2010-06-08 17:59:35 >> Loaded 140 quests additions in game events 2010-06-08 17:59:35 [0 ms] SQL: SELECT pool_template.entry, game_event_pool.event FROM pool_template JOIN game_event_pool ON pool_template.entry = game_event_pool.pool_entry 2010-06-08 17:59:35 2010-06-08 17:59:35 >> Loaded 1 pools in game events 2010-06-08 17:59:35 >>> Game Event Data loaded 2010-06-08 17:59:35 2010-06-08 17:59:35 Loading Weather Data... 2010-06-08 17:59:35 [0 ms] SQL: SELECT zone, spring_rain_chance, spring_snow_chance, spring_storm_chance, summer_rain_chance, summer_snow_chance, summer_storm_chance, fall_rain_chance, fall_snow_chance, fall_storm_chance, winter_rain_chance, winter_snow_chance, winter_storm_chance FROM game_weather 2010-06-08 17:59:35 2010-06-08 17:59:35 >> Loaded 41 weather definitions 2010-06-08 17:59:35 Loading Quests... 2010-06-08 17:59:35 [23 ms] SQL: SELECT entry, Method, ZoneOrSort, SkillOrClass, MinLevel, QuestLevel, Type, RequiredRaces, RequiredSkillValue,RepObjectiveFaction, RepObjectiveValue, RequiredMinRepFaction, RequiredMinRepValue, RequiredMaxRepFaction, RequiredMaxRepValue, SuggestedPlayers, LimitTime,QuestFlags, SpecialFlags, CharTitleId, PlayersSlain, BonusTalents, PrevQuestId, NextQuestId, ExclusiveGroup, NextQuestInChain,RewXPId, SrcItemId, SrcItemCount, SrcSpell,Title, Details, Objectives, OfferRewardText, RequestItemsText, EndText, CompletedText, ObjectiveText1, ObjectiveText2, ObjectiveText3, ObjectiveText4,ReqItemId1, ReqItemId2, ReqItemId3, ReqItemId4, ReqItemId5, ReqItemId6, ReqItemCount1, ReqItemCount2, ReqItemCount3, ReqItemCount4, ReqItemCount5, ReqItemCount6,ReqSourceId1, ReqSourceId2, ReqSourceId3, ReqSourceId4, ReqSourceCount1, ReqSourceCount2, ReqSourceCount3, ReqSourceCount4,ReqCreatureOrGOId1, ReqCreatureOrGOId2, ReqCreatureOrGOId3, ReqCreatureOrGOId4, ReqCreatureOrGOCount1, ReqCreatureOrGOCount2, ReqCreatureOrGOCount3, ReqCreatureOrGOCount4,ReqSpellCast1, ReqSpellCast2, ReqSpellCast3, ReqSpellCast4,RewChoiceItemId1, RewChoiceItemId2, RewChoiceItemId3, RewChoiceItemId4, RewChoiceItemId5, RewChoiceItemId6,RewChoiceItemCount1, RewChoiceItemCount2, RewChoiceItemCount3, RewChoiceItemCount4, RewChoiceItemCount5, RewChoiceItemCount6,RewItemId1, RewItemId2, RewItemId3, RewItemId4, RewItemCount1, RewItemCount2, RewItemCount3, RewItemCount4,RewRepFaction1, RewRepFaction2, RewRepFaction3, RewRepFaction4, RewRepFaction5,RewRepValueId1, RewRepValueId2, RewRepValueId3, RewRepValueId4, RewRepValueId5,RewRepValue1, RewRepValue2, RewRepValue3, RewRepValue4, RewRepValue5,RewHonorAddition, RewHonorMultiplier, RewOrReqMoney, RewMoneyMaxLevel, RewSpell, RewSpellCast,RewMailTemplateId, RewMailDelaySecs, PointMapId, PointX, PointY, PointOpt,DetailsEmote1, DetailsEmote2, DetailsEmote3, DetailsEmote4, DetailsEmoteDelay1, DetailsEmoteDelay2, DetailsEmoteDelay3, DetailsEmoteDelay4,IncompleteEmote, CompleteEmote, OfferRewardEmote1, OfferRewardEmote2, OfferRewardEmote3, OfferRewardEmote4,OfferRewardEmoteDelay1, OfferRewardEmoteDelay2, OfferRewardEmoteDelay3, OfferRewardEmoteDelay4,StartScript, CompleteScript FROM quest_template 2010-06-08 17:59:35 2010-06-08 17:59:35 >> Loaded 9402 quests definitions 2010-06-08 17:59:35 Loading Quest POI 2010-06-08 17:59:35 [0 ms] SQL: SELECT questId, poiId, objIndex, mapId, mapAreaId, floorId, unk3, unk4 FROM quest_poi 2010-06-08 17:59:36 [4 ms] SQL: SELECT questId, poiId, x, y FROM quest_poi_points 2010-06-08 17:59:36 2010-06-08 17:59:36 >> Loaded 18734 quest POI definitions 2010-06-08 17:59:36 Loading Quests Relations... 2010-06-08 17:59:36 2010-06-08 17:59:36 [0 ms] SQL: SELECT id,quest FROM gameobject_questrelation 2010-06-08 17:59:36 2010-06-08 17:59:36 >> Loaded 535 quest relations from gameobject_questrelation 2010-06-08 17:59:36 [0 ms] SQL: SELECT id,quest FROM gameobject_involvedrelation 2010-06-08 17:59:36 2010-06-08 17:59:36 >> Loaded 449 quest relations from gameobject_involvedrelation 2010-06-08 17:59:36 [1 ms] SQL: SELECT id,quest FROM creature_questrelation 2010-06-08 17:59:36 2010-06-08 17:59:36 >> Loaded 7669 quest relations from creature_questrelation 2010-06-08 17:59:36 [0 ms] SQL: SELECT id,quest FROM creature_involvedrelation 2010-06-08 17:59:36 2010-06-08 17:59:36 >> Loaded 8181 quest relations from creature_involvedrelation 2010-06-08 17:59:36 >>> Quests Relations loaded 2010-06-08 17:59:36 2010-06-08 17:59:36 Loading UNIT_NPC_FLAG_SPELLCLICK Data... 2010-06-08 17:59:36 [1 ms] SQL: SELECT npc_entry, spell_id, quest_start, quest_start_active, quest_end, cast_flags FROM npc_spellclick_spells 2010-06-08 17:59:36 2010-06-08 17:59:36 >> Loaded 73 spellclick definitions 2010-06-08 17:59:36 Loading SpellArea Data... 2010-06-08 17:59:36 [0 ms] SQL: SELECT spell, area, quest_start, quest_start_active, quest_end, aura_spell, racemask, gender, autocast FROM spell_area 2010-06-08 17:59:36 2010-06-08 17:59:36 >> Loaded 257 spell area requirements 2010-06-08 17:59:36 Loading AreaTrigger definitions... 2010-06-08 17:59:36 [0 ms] SQL: SELECT id, required_level, required_item, required_item2, heroic_key, heroic_key2, required_quest_done, required_quest_done_heroic, required_failed_text, target_map, target_position_x, target_position_y, target_position_z, target_orientation FROM areatrigger_teleport 2010-06-08 17:59:36 2010-06-08 17:59:36 >> Loaded 252 area trigger teleport definitions 2010-06-08 17:59:36 Loading Quest Area Triggers... 2010-06-08 17:59:36 [1 ms] SQL: SELECT id,quest FROM areatrigger_involvedrelation 2010-06-08 17:59:36 2010-06-08 17:59:36 >> Loaded 58 quest trigger points 2010-06-08 17:59:36 Loading Tavern Area Triggers... 2010-06-08 17:59:36 [0 ms] SQL: SELECT id FROM areatrigger_tavern 2010-06-08 17:59:36 2010-06-08 17:59:36 >> Loaded 113 tavern triggers 2010-06-08 17:59:36 Loading AreaTrigger script names... 2010-06-08 17:59:36 [0 ms] SQL: SELECT entry, ScriptName FROM areatrigger_scripts 2010-06-08 17:59:36 2010-06-08 17:59:36 >> Loaded 27 areatrigger scripts 2010-06-08 17:59:36 Loading Graveyard-zone links... 2010-06-08 17:59:36 [0 ms] SQL: SELECT id,ghost_zone,faction FROM game_graveyard_zone 2010-06-08 17:59:36 2010-06-08 17:59:36 >> Loaded 553 graveyard-zone links 2010-06-08 17:59:36 Loading Spell target coordinates... 2010-06-08 17:59:36 [0 ms] SQL: SELECT id, target_map, target_position_x, target_position_y, target_position_z, target_orientation FROM spell_target_position 2010-06-08 17:59:36 2010-06-08 17:59:36 >> Loaded 420 spell teleport coordinates 2010-06-08 17:59:36 Loading spell pet auras... 2010-06-08 17:59:36 [0 ms] SQL: SELECT spell, effectId, pet, aura FROM spell_pet_auras 2010-06-08 17:59:36 2010-06-08 17:59:36 >> Loaded 45 spell pet auras 2010-06-08 17:59:36 Loading Player Create Info & Level Stats... 2010-06-08 17:59:36 2010-06-08 17:59:36 [0 ms] SQL: SELECT race, class, map, zone, position_x, position_y, position_z FROM playercreateinfo 2010-06-08 17:59:36 2010-06-08 17:59:36 >> Loaded 62 player create definitions 2010-06-08 17:59:36 [1 ms] SQL: SELECT race, class, itemid, amount FROM playercreateinfo_item 2010-06-08 17:59:36 2010-06-08 17:59:36 >> Loaded 0 custom player create items 2010-06-08 17:59:36 [0 ms] SQL: SELECT race, class, Spell FROM playercreateinfo_spell 2010-06-08 17:59:36 2010-06-08 17:59:36 >> Loaded 2828 player create spells 2010-06-08 17:59:36 [0 ms] SQL: SELECT race, class, button, action, type FROM playercreateinfo_action 2010-06-08 17:59:36 2010-06-08 17:59:36 >> Loaded 440 player create actions 2010-06-08 17:59:36 [0 ms] SQL: SELECT class, level, basehp, basemana FROM player_classlevelstats 2010-06-08 17:59:36 2010-06-08 17:59:36 >> Loaded 800 level health/mana definitions 2010-06-08 17:59:36 [1 ms] SQL: SELECT race, class, level, str, agi, sta, inte, spi FROM player_levelstats 2010-06-08 17:59:36 2010-06-08 17:59:36 >> Loaded 4960 level stats definitions 2010-06-08 17:59:36 [1 ms] SQL: SELECT lvl, xp_for_next_level FROM player_xp_for_level 2010-06-08 17:59:36 2010-06-08 17:59:36 >> Loaded 79 xp for level definitions 2010-06-08 17:59:36 >>> Player Create Info & Level Stats loaded 2010-06-08 17:59:36 2010-06-08 17:59:36 Loading Exploration BaseXP Data... 2010-06-08 17:59:36 [0 ms] SQL: SELECT level,basexp FROM exploration_basexp 2010-06-08 17:59:36 2010-06-08 17:59:36 >> Loaded 71 BaseXP definitions 2010-06-08 17:59:36 Loading Pet Name Parts... 2010-06-08 17:59:36 [1 ms] SQL: SELECT word,entry,half FROM pet_name_generation 2010-06-08 17:59:36 2010-06-08 17:59:36 >> Loaded 313 pet name parts 2010-06-08 17:59:36 Cleaning character database... 2010-06-08 17:59:36 [0 ms] SQL: SELECT cleaning_flags FROM saved_variables 2010-06-08 17:59:36 Loading the max pet number... 2010-06-08 17:59:36 [0 ms] SQL: SELECT MAX(id) FROM character_pet 2010-06-08 17:59:36 2010-06-08 17:59:36 >> Loaded the max pet number: 0 2010-06-08 17:59:36 Loading pet level stats... 2010-06-08 17:59:36 [0 ms] SQL: SELECT creature_entry, level, hp, mana, str, agi, sta, inte, spi, armor FROM pet_levelstats 2010-06-08 17:59:36 2010-06-08 17:59:36 >> Loaded 3040 level pet stats definitions 2010-06-08 17:59:36 Loading Player Corpses... 2010-06-08 17:59:36 [48 ms] SQL: UPDATE saved_variables SET cleaning_flags = 0 2010-06-08 17:59:36 [0 ms] SQL: SELECT corpse.guid, player, corpse.position_x, corpse.position_y, corpse.position_z, corpse.orientation, corpse.map, time, corpse_type, instance, phaseMask, gender, race, class, playerBytes, playerBytes2, equipmentCache, guildId, playerFlags FROM corpse JOIN characters ON player = characters.guid LEFT JOIN guild_member ON player=guild_member.guid WHERE corpse_type <> 0 2010-06-08 17:59:36 2010-06-08 17:59:36 >> Loaded 0 corpses 2010-06-08 17:59:36 Loading Player level dependent mail rewards... 2010-06-08 17:59:36 [0 ms] SQL: SELECT level, raceMask, mailTemplateId, senderEntry FROM mail_level_reward 2010-06-08 17:59:36 2010-06-08 17:59:36 >> Loaded 24 level dependent mail rewards, 2010-06-08 17:59:36 Loading Loot Tables... 2010-06-08 17:59:36 2010-06-08 17:59:36 creature_loot_template : 2010-06-08 17:59:36 [3 ms] SQL: SELECT entry, item, ChanceOrQuestChance, groupid, mincountOrRef, maxcount, lootcondition, condition_value1, condition_value2 FROM creature_loot_template 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 235402 loot definitions (7998 templates) 2010-06-08 17:59:37 fishing_loot_template : 2010-06-08 17:59:37 [1 ms] SQL: SELECT entry, item, ChanceOrQuestChance, groupid, mincountOrRef, maxcount, lootcondition, condition_value1, condition_value2 FROM fishing_loot_template 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 3625 loot definitions (472 templates) 2010-06-08 17:59:37 gameobject_loot_template : 2010-06-08 17:59:37 [0 ms] SQL: SELECT entry, item, ChanceOrQuestChance, groupid, mincountOrRef, maxcount, lootcondition, condition_value1, condition_value2 FROM gameobject_loot_template 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 8976 loot definitions (1300 templates) 2010-06-08 17:59:37 item_loot_template : 2010-06-08 17:59:37 [0 ms] SQL: SELECT entry, item, ChanceOrQuestChance, groupid, mincountOrRef, maxcount, lootcondition, condition_value1, condition_value2 FROM item_loot_template 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 3254 loot definitions (298 templates) 2010-06-08 17:59:37 mail_loot_template : 2010-06-08 17:59:37 [0 ms] SQL: SELECT entry, item, ChanceOrQuestChance, groupid, mincountOrRef, maxcount, lootcondition, condition_value1, condition_value2 FROM mail_loot_template 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 101 loot definitions (101 templates) 2010-06-08 17:59:37 milling_loot_template : 2010-06-08 17:59:37 [0 ms] SQL: SELECT entry, item, ChanceOrQuestChance, groupid, mincountOrRef, maxcount, lootcondition, condition_value1, condition_value2 FROM milling_loot_template 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 90 loot definitions (47 templates) 2010-06-08 17:59:37 pickpocketing_loot_template : 2010-06-08 17:59:37 [1 ms] SQL: SELECT entry, item, ChanceOrQuestChance, groupid, mincountOrRef, maxcount, lootcondition, condition_value1, condition_value2 FROM pickpocketing_loot_template 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 19369 loot definitions (3663 templates) 2010-06-08 17:59:37 skinning_loot_template : 2010-06-08 17:59:37 [1 ms] SQL: SELECT entry, item, ChanceOrQuestChance, groupid, mincountOrRef, maxcount, lootcondition, condition_value1, condition_value2 FROM skinning_loot_template 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 5665 loot definitions (1593 templates) 2010-06-08 17:59:37 disenchant_loot_template : 2010-06-08 17:59:37 [1 ms] SQL: SELECT entry, item, ChanceOrQuestChance, groupid, mincountOrRef, maxcount, lootcondition, condition_value1, condition_value2 FROM disenchant_loot_template 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 122 loot definitions (55 templates) 2010-06-08 17:59:37 prospecting_loot_template : 2010-06-08 17:59:37 [0 ms] SQL: SELECT entry, item, ChanceOrQuestChance, groupid, mincountOrRef, maxcount, lootcondition, condition_value1, condition_value2 FROM prospecting_loot_template 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 100 loot definitions (10 templates) 2010-06-08 17:59:37 spell_loot_template : 2010-06-08 17:59:37 [0 ms] SQL: SELECT entry, item, ChanceOrQuestChance, groupid, mincountOrRef, maxcount, lootcondition, condition_value1, condition_value2 FROM spell_loot_template 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 319 loot definitions (21 templates) 2010-06-08 17:59:37 reference_loot_template : 2010-06-08 17:59:37 [0 ms] SQL: SELECT entry, item, ChanceOrQuestChance, groupid, mincountOrRef, maxcount, lootcondition, condition_value1, condition_value2 FROM reference_loot_template 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 5843 loot definitions (359 templates) 2010-06-08 17:59:37 >>> Loot Tables loaded 2010-06-08 17:59:37 2010-06-08 17:59:37 Loading Skill Discovery Table... 2010-06-08 17:59:37 [0 ms] SQL: SELECT spellId, reqSpell, reqSkillValue, chance FROM skill_discovery_template 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 330 skill discovery definitions 2010-06-08 17:59:37 Loading Skill Extra Item Table... 2010-06-08 17:59:37 [0 ms] SQL: SELECT spellId, requiredSpecialization, additionalCreateChance, additionalMaxNum FROM skill_extra_item_template 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 226 spell specialization definitions 2010-06-08 17:59:37 Loading Skill Fishing base level requirements... 2010-06-08 17:59:37 [0 ms] SQL: SELECT entry,skill FROM skill_fishing_base_level 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 95 areas for fishing base skill level 2010-06-08 17:59:37 Loading Achievements... 2010-06-08 17:59:37 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 43 achievement references. 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 1097 achievement criteria. 2010-06-08 17:59:37 [0 ms] SQL: SELECT criteria_id, type, value1, value2 FROM achievement_criteria_requirement 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 2187 additional achievement criteria data (244 disabled). 2010-06-08 17:59:37 [0 ms] SQL: SELECT entry, gender, title_A, title_H, item, sender, subject, text FROM achievement_reward 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 98 achievement rewards 2010-06-08 17:59:37 [0 ms] SQL: SELECT entry,gender,subject_loc1,text_loc1,subject_loc2,text_loc2,subject_loc3,text_loc3,subject_loc4,text_loc4,subject_loc5,text_loc5,subject_loc6,text_loc6,subject_loc7,text_loc7,subject_loc8,text_loc8 FROM locales_achievement_reward 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 15 achievement reward locale strings 2010-06-08 17:59:37 [0 ms] SQL: SELECT achievement FROM character_achievement GROUP BY achievement 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 0 realm completed achievements . DB table `character_achievement` is empty. 2010-06-08 17:59:37 >>> Achievements loaded 2010-06-08 17:59:37 2010-06-08 17:59:37 Loading Auctions... 2010-06-08 17:59:37 2010-06-08 17:59:37 [0 ms] SQL: SELECT data,text,itemguid,item_template FROM auctionhouse JOIN item_instance ON itemguid = guid 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 0 auction items 2010-06-08 17:59:37 [0 ms] SQL: SELECT COUNT(*) FROM auctionhouse 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 0 auctions. DB table `auctionhouse` is empty. 2010-06-08 17:59:37 >>> Auctions loaded 2010-06-08 17:59:37 2010-06-08 17:59:37 Loading Guilds... 2010-06-08 17:59:37 [0 ms] SQL: SELECT guild.guildid,guild.name,leaderguid,EmblemStyle,EmblemColor,BorderStyle,BorderColor,BackgroundColor,info,motd,createdate,BankMoney,(SELECT COUNT(guild_bank_tab.guildid) FROM guild_bank_tab WHERE guild_bank_tab.guildid = guild.guildid) FROM guild ORDER BY guildid ASC 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 0 guild definitions 2010-06-08 17:59:37 Loading ArenaTeams... 2010-06-08 17:59:37 [0 ms] SQL: SELECT arena_team.arenateamid,name,captainguid,type,BackgroundColor,EmblemStyle,EmblemColor,BorderStyle,BorderColor, rating,games,wins,played,wins2,rank FROM arena_team LEFT JOIN arena_team_stats ON arena_team.arenateamid = arena_team_stats.arenateamid ORDER BY arena_team.arenateamid ASC 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 0 arenateam definitions 2010-06-08 17:59:37 Loading Groups... 2010-06-08 17:59:37 [0 ms] SQL: SELECT mainTank, mainAssistant, lootMethod, looterGuid, lootThreshold, icon1, icon2, icon3, icon4, icon5, icon6, icon7, icon8, groupType, difficulty, raiddifficulty, leaderGuid, groupId FROM groups 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 0 group definitions 2010-06-08 17:59:37 Loading ReservedNames... 2010-06-08 17:59:37 [0 ms] SQL: SELECT name FROM reserved_name 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 35 reserved player names 2010-06-08 17:59:37 Loading GameObjects for quests... 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 1125 GameObjects for quests 2010-06-08 17:59:37 Loading BattleMasters... 2010-06-08 17:59:37 [1 ms] SQL: SELECT entry,bg_template FROM battlemaster_entry 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 158 battlemaster entries 2010-06-08 17:59:37 Loading BattleGround event indexes... 2010-06-08 17:59:37 [1 ms] SQL: SELECT data.typ, data.guid1, data.ev1 AS ev1, data.ev2 AS ev2, data.map AS m, data.guid2, description.map, description.event1, description.event2, description.description FROM (SELECT '1' AS typ, a.guid AS guid1, a.event1 AS ev1, a.event2 AS ev2, b.map AS map, b.guid AS guid2 FROM gameobject_battleground AS a LEFT OUTER JOIN gameobject AS b ON a.guid = b.guid UNION SELECT '2' AS typ, a.guid AS guid1, a.event1 AS ev1, a.event2 AS ev2, b.map AS map, b.guid AS guid2 FROM creature_battleground AS a LEFT OUTER JOIN creature AS b ON a.guid = b.guid ) data RIGHT OUTER JOIN battleground_events AS description ON data.map = description.map AND data.ev1 = description.event1 AND data.ev2 = description.event2 UNION SELECT data.typ, data.guid1, data.ev1, data.ev2, data.map, data.guid2, description.map, description.event1, description.event2, description.description FROM (SELECT '1' AS typ, a.guid AS guid1, a.event1 AS ev1, a.event2 AS ev2, b.map AS map, b.guid AS guid2 FROM gameobject_battleground AS a LEFT OUTER JOIN gameobject AS b ON a.guid = b.guid UNION SELECT '2' AS typ, a.guid AS guid1, a.event1 AS ev1, a.event2 AS ev2, b.map AS map, b.guid AS guid2 FROM creature_battleground AS a LEFT OUTER JOIN creature AS b ON a.guid = b.guid ) data LEFT OUTER JOIN battleground_events AS description ON data.map = description.map AND data.ev1 = description.event1 AND data.ev2 = description.event2 ORDER BY m, ev1, ev2 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 1236 battleground eventindexes 2010-06-08 17:59:37 Loading GameTeleports... 2010-06-08 17:59:37 [0 ms] SQL: SELECT id, position_x, position_y, position_z, orientation, map, name FROM game_tele 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 1427 GameTeleports 2010-06-08 17:59:37 Loading Npc Text Id... 2010-06-08 17:59:37 [0 ms] SQL: SELECT npc_guid, textid FROM npc_gossip 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 1052 NpcTextId 2010-06-08 17:59:37 Loading Gossip scripts... 2010-06-08 17:59:37 gossip_scripts : 2010-06-08 17:59:37 [0 ms] SQL: SELECT id, delay, command, datalong, datalong2, datalong3, datalong4, data_flags, dataint, x, y, z, o FROM gossip_scripts 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 235 script definitions 2010-06-08 17:59:37 Loading Gossip menus... 2010-06-08 17:59:37 [1 ms] SQL: SELECT entry, text_id, cond_1, cond_1_val_1, cond_1_val_2, cond_2, cond_2_val_1, cond_2_val_2 FROM gossip_menu 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 2452 gossip_menu entries 2010-06-08 17:59:37 Loading Gossip menu options... 2010-06-08 17:59:37 [0 ms] SQL: SELECT menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, action_script_id, box_coded, box_money, box_text, cond_1, cond_1_val_1, cond_1_val_2, cond_2, cond_2_val_1, cond_2_val_2, cond_3, cond_3_val_1, cond_3_val_2 FROM gossip_menu_option 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 3332 gossip_menu_option entries 2010-06-08 17:59:37 Loading Vendors... 2010-06-08 17:59:37 [0 ms] SQL: SELECT entry, item, maxcount, incrtime, ExtendedCost FROM npc_vendor 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 35052 Vendors 2010-06-08 17:59:37 Loading Trainers... 2010-06-08 17:59:37 [14 ms] SQL: SELECT entry, spell,spellcost,reqskill,reqskillvalue,reqlevel FROM npc_trainer 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 75614 Trainers 2010-06-08 17:59:37 Loading Waypoint scripts... 2010-06-08 17:59:37 creature_movement_scripts : 2010-06-08 17:59:37 [0 ms] SQL: SELECT id, delay, command, datalong, datalong2, datalong3, datalong4, data_flags, dataint, x, y, z, o FROM creature_movement_scripts 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Loaded 1062 script definitions 2010-06-08 17:59:37 Loading Waypoints... 2010-06-08 17:59:37 2010-06-08 17:59:37 [0 ms] SQL: SELECT 1 from creature_movement As T WHERE point <> (SELECT COUNT(*) FROM creature_movement WHERE id = T.id AND point <= T.point) LIMIT 1 2010-06-08 17:59:37 [0 ms] SQL: SELECT id, COUNT(point) FROM creature_movement GROUP BY id 2010-06-08 17:59:37 2010-06-08 17:59:37 >> Paths loaded 2010-06-08 17:59:37 [1 ms] SQL: SELECT position_x, position_y, position_z, orientation, model1, model2,waittime, emote, spell, textid1, textid2, textid3, textid4, textid5, id, point, script_id FROM creature_movement 2010-06-08 17:59:38 2010-06-08 17:59:38 >> Waypoints and behaviors loaded 2010-06-08 17:59:38 2010-06-08 17:59:38 >>> Loaded 3867 paths, 46839 nodes and 783 behaviors 2010-06-08 17:59:38 Loading GM tickets... 2010-06-08 17:59:38 [0 ms] SQL: SELECT guid, ticket_text, response_text, UNIX_TIMESTAMP(ticket_lastchange) FROM character_ticket 2010-06-08 17:59:38 2010-06-08 17:59:38 >> Loaded `character_ticket`, table is empty. 2010-06-08 17:59:38 Returning old mails... 2010-06-08 17:59:38 Returning mails current time: hour: 17, minute: 59, second: 38 2010-06-08 17:59:38 [0 ms] SQL: SELECT id,messageType,sender,receiver,has_items,expire_time,cod,checked,mailTemplateId FROM mail WHERE expire_time < '1276005578' 2010-06-08 17:59:38 2010-06-08 17:59:38 >> Only expired mails (need to be return or delete) or DB table `mail` is empty. 2010-06-08 17:59:38 Loading Scripts... 2010-06-08 17:59:38 2010-06-08 17:59:38 quest_start_scripts : 2010-06-08 17:59:38 [0 ms] SQL: SELECT id, delay, command, datalong, datalong2, datalong3, datalong4, data_flags, dataint, x, y, z, o FROM quest_start_scripts 2010-06-08 17:59:38 [0 ms] SQL: DELETE FROM mail WHERE expire_time < '1276005578' AND has_items = '0' AND body = '' 2010-06-08 17:59:38 2010-06-08 17:59:38 >> Loaded 620 script definitions 2010-06-08 17:59:38 quest_end_scripts : 2010-06-08 17:59:38 [0 ms] SQL: SELECT id, delay, command, datalong, datalong2, datalong3, datalong4, data_flags, dataint, x, y, z, o FROM quest_end_scripts 2010-06-08 17:59:38 2010-06-08 17:59:38 >> Loaded 507 script definitions 2010-06-08 17:59:38 spell_scripts : 2010-06-08 17:59:38 [0 ms] SQL: SELECT id, delay, command, datalong, datalong2, datalong3, datalong4, data_flags, dataint, x, y, z, o FROM spell_scripts 2010-06-08 17:59:38 2010-06-08 17:59:38 >> Loaded 145 script definitions 2010-06-08 17:59:38 gameobject_scripts : 2010-06-08 17:59:38 [0 ms] SQL: SELECT id, delay, command, datalong, datalong2, datalong3, datalong4, data_flags, dataint, x, y, z, o FROM gameobject_scripts 2010-06-08 17:59:38 2010-06-08 17:59:38 >> Loaded 49 script definitions 2010-06-08 17:59:38 event_scripts : 2010-06-08 17:59:38 [0 ms] SQL: SELECT id, delay, command, datalong, datalong2, datalong3, datalong4, data_flags, dataint, x, y, z, o FROM event_scripts 2010-06-08 17:59:38 2010-06-08 17:59:38 >> Loaded 684 script definitions 2010-06-08 17:59:38 >>> Scripts loaded 2010-06-08 17:59:38 2010-06-08 17:59:38 Loading Scripts text locales... 2010-06-08 17:59:38 [1 ms] SQL: SELECT entry,content_default,content_loc1,content_loc2,content_loc3,content_loc4,content_loc5,content_loc6,content_loc7,content_loc8 FROM db_script_string 2010-06-08 17:59:38 2010-06-08 17:59:38 >> Loaded 453 string templates from db_script_string 2010-06-08 17:59:38 Loading CreatureEventAI Texts... 2010-06-08 17:59:38 [0 ms] SQL: SELECT entry,content_default,content_loc1,content_loc2,content_loc3,content_loc4,content_loc5,content_loc6,content_loc7,content_loc8 FROM creature_ai_texts 2010-06-08 17:59:38 2010-06-08 17:59:38 >> Loaded 1071 string templates from creature_ai_texts 2010-06-08 17:59:38 [0 ms] SQL: SELECT entry, sound, type, language, emote FROM creature_ai_texts 2010-06-08 17:59:38 Loading EventAI Texts additional data... 2010-06-08 17:59:38 2010-06-08 17:59:38 >> Loaded 1071 additional CreatureEventAI Texts data. 2010-06-08 17:59:38 Loading CreatureEventAI Summons... 2010-06-08 17:59:38 [0 ms] SQL: SELECT id, position_x, position_y, position_z, orientation, spawntimesecs FROM creature_ai_summons 2010-06-08 17:59:38 2010-06-08 17:59:38 >> Loaded 21 CreatureEventAI summon definitions 2010-06-08 17:59:38 Loading CreatureEventAI Scripts... 2010-06-08 17:59:38 [16 ms] SQL: SELECT id, creature_id, event_type, event_inverse_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action1_type, action1_param1, action1_param2, action1_param3, action2_type, action2_param1, action2_param2, action2_param3, action3_type, action3_param1, action3_param2, action3_param3 FROM creature_ai_scripts 2010-06-08 17:59:38 2010-06-08 17:59:38 >> Loaded 18524 CreatureEventAI scripts 2010-06-08 17:59:38 Initializing Scripts... 2010-06-08 17:59:38 2010-06-08 17:59:38 >>> Scripts Library libmangosscript.so was successfully loaded. 2010-06-08 17:59:38 2010-06-08 17:59:38 MMM MMM MM 2010-06-08 17:59:38 M MM M M M M 2010-06-08 17:59:38 MM M M M 2010-06-08 17:59:38 MMM M M M 2010-06-08 17:59:38 MM M M MMMM 2010-06-08 17:59:38 MM M M M 2010-06-08 17:59:38 MMM MMM http://www.scriptdev2.com 2010-06-08 17:59:38 2010-06-08 17:59:38 SD2: Using configuration file /home/ivan/gotovoe/config/scriptdev2.conf 2010-06-08 17:59:38 2010-06-08 17:59:38 Connected to MySQL database at 127.0.0.1 2010-06-08 17:59:38 MySQL client library: 5.1.41 2010-06-08 17:59:38 MySQL server ver: 5.1.41-3ubuntu12.1 2010-06-08 17:59:38 AUTOCOMMIT SUCCESSFULLY SET TO 1 2010-06-08 17:59:38 SD2: ScriptDev2 database at 127.0.0.1;3306;user;pass;scriptdev2 initialized. 2010-06-08 17:59:38 2010-06-08 17:59:38 [0 ms] SQL: SELECT version FROM sd2_db_version LIMIT 1 2010-06-08 17:59:38 Loading ScriptDev2 (for MaNGOS 9832+) 2010-06-08 17:59:38 2010-06-08 17:59:38 SD2: Loading Script Texts... 2010-06-08 17:59:38 [1 ms] SQL: SELECT entry,content_default,content_loc1,content_loc2,content_loc3,content_loc4,content_loc5,content_loc6,content_loc7,content_loc8 FROM script_texts 2010-06-08 17:59:38 2010-06-08 17:59:38 >> Loaded 2209 string templates from script_texts 2010-06-08 17:59:38 [32 ms] SQL: SELECT entry, sound, type, language, emote FROM script_texts 2010-06-08 17:59:38 SD2: Loading Script Texts additional data... 2010-06-08 17:59:38 [0 ms] SQL: SET NAMES `utf8` 2010-06-08 17:59:38 [0 ms] SQL: SET CHARACTER SET `utf8` 2010-06-08 17:59:38 2010-06-08 17:59:38 >> Loaded 2209 additional Script Texts data. 2010-06-08 17:59:38 SD2: Loading Custom Texts... 2010-06-08 17:59:38 [0 ms] SQL: SELECT entry,content_default,content_loc1,content_loc2,content_loc3,content_loc4,content_loc5,content_loc6,content_loc7,content_loc8 FROM custom_texts 2010-06-08 17:59:38 2010-06-08 17:59:38 >> Loaded 0 string templates. DB table `custom_texts` is empty. 2010-06-08 17:59:38 [0 ms] SQL: SELECT entry, sound, type, language, emote FROM custom_texts 2010-06-08 17:59:38 SD2: Loading Custom Texts additional data... 2010-06-08 17:59:38 2010-06-08 17:59:38 >> Loaded 0 additional Custom Texts data. DB table `custom_texts` is empty. 2010-06-08 17:59:38 [0 ms] SQL: SELECT COUNT(entry) FROM script_waypoint GROUP BY entry 2010-06-08 17:59:38 SD2: Loading Script Waypoints for 57 creature(s)... 2010-06-08 17:59:38 [0 ms] SQL: SELECT entry, pointid, location_x, location_y, location_z, waittime FROM script_waypoint ORDER BY pointid 2010-06-08 17:59:38 2010-06-08 17:59:38 >> Loaded 1534 Script Waypoint nodes. 2010-06-08 17:59:38 SD2: Loading C++ scripts 2010-06-08 17:59:38 2010-06-08 17:59:38 SD2: RegisterSelf, but script named example_creature does not have ScriptName assigned in database. 2010-06-08 17:59:38 SD2: RegisterSelf, but script named example_escort does not have ScriptName assigned in database. 2010-06-08 17:59:38 SD2: RegisterSelf, but script named example_gossip_codebox does not have ScriptName assigned in database. 2010-06-08 17:59:38 SD2: RegisterSelf, but script named example_areatrigger does not have ScriptName assigned in database. 2010-06-08 17:59:38 SD2: RegisterSelf, but script named example_item does not have ScriptName assigned in database. 2010-06-08 17:59:38 SD2: RegisterSelf, but script named example_go_teleporter does not have ScriptName assigned in database. 2010-06-08 17:59:38 SD2: RegisterSelf, but script named mob_parasitic_shadowfiend does not have ScriptName assigned in database. 2010-06-08 17:59:38 SD2: RegisterSelf, but script named mob_shadowy_construct does not have ScriptName assigned in database. 2010-06-08 17:59:38 >> Loaded 830 C++ Scripts. 2010-06-08 17:59:38 DEBUG:: Initialize game time and timers 2010-06-08 17:59:38 Mail timer set to: 780, mail return is called every 1440 minutes 2010-06-08 17:59:38 Starting Map System 2010-06-08 17:59:38 [0 ms] SQL: SELECT MAX(id) FROM instance 2010-06-08 17:59:38 Starting BattleGround System 2010-06-08 17:59:38 [0 ms] SQL: SELECT id, MinPlayersPerTeam,MaxPlayersPerTeam,AllianceStartLoc,AllianceStartO,HordeStartLoc,HordeStartO FROM battleground_template 2010-06-08 17:59:38 2010-06-08 17:59:38 >> Loaded 13 battlegrounds 2010-06-08 17:59:38 Loading Transports... 2010-06-08 17:59:38 [0 ms] SQL: SELECT entry, name, period FROM transports 2010-06-08 17:59:38 [1 ms] SQL: INSERT INTO uptime (realmid, starttime, startstring, uptime) VALUES('1', 1276005578, '2010-06-08 17:59:38', 0) 2010-06-08 17:59:38 2010-06-08 17:59:38 >> Loaded 29 transports 2010-06-08 17:59:38 [0 ms] SQL: SELECT gameobject.guid,gameobject.id,transports.name FROM gameobject,transports WHERE gameobject.id = transports.entry 2010-06-08 17:59:38 Deleting expired bans... 2010-06-08 17:59:38 Calculate next daily quest reset time... 2010-06-08 17:59:38 [0 ms] SQL: SELECT NextDailyQuestResetTime FROM saved_variables 2010-06-08 17:59:38 Calculate next weekly quest reset time... 2010-06-08 17:59:38 [0 ms] SQL: SELECT NextWeeklyQuestResetTime FROM saved_variables 2010-06-08 17:59:38 Starting objects Pooling system... 2010-06-08 17:59:38 [0 ms] SQL: SELECT DISTINCT pool_template.entry FROM pool_template LEFT JOIN game_event_pool ON pool_template.entry=game_event_pool.pool_entry LEFT JOIN pool_pool ON pool_template.entry=pool_pool.pool_id WHERE game_event_pool.pool_entry IS NULL AND pool_pool.pool_id IS NULL 2010-06-08 17:59:38 Pool handling system initialized, 5558 pools spawned. 2010-06-08 17:59:38 Starting Game Event system... 2010-06-08 17:59:38 GameEvent 31 "Darkmoon Faire Building (Elwynn Forest)" started. 2010-06-08 17:59:38 GameEvent 36 "Edge of Madness, Hazza'rah" started. 2010-06-08 17:59:38 GameEvent 44 "Thrallmar Demon Attack" started. 2010-06-08 17:59:38 Next game event check in 23 seconds. 2010-06-08 17:59:38 Game Event system initialized. 2010-06-08 17:59:38 Player::DeleteOldChars: Deleting all characters which have been deleted 30 days before... 2010-06-08 17:59:38 [11 ms] SQL: DELETE FROM ip_banned WHERE unbandate<=UNIX_TIMESTAMP() AND unbandate<>bandate 2010-06-08 17:59:38 [1 ms] SQL: SELECT guid, deleteInfos_Account FROM characters WHERE deleteDate IS NOT NULL AND deleteDate < '1273413578' 2010-06-08 17:59:38 WORLD: World initialized 2010-06-08 17:59:38 SERVER STARTUP TIME: 0 minutes 14 seconds 2010-06-08 17:59:38 2010-06-08 17:59:38 Max allowed socket connections 1024 2010-06-08 17:59:38 Network Thread Starting 2010-06-08 17:59:38 Network Thread Starting 2010-06-08 17:59:38 [1 ms] SQL: UPDATE realmlist SET realmflags = realmflags & ~(2), population = 0, realmbuilds = '11723 ' WHERE id = '1' 2010-06-08 17:59:38 Network Thread Exitting 2010-06-08 17:59:38 Network Thread Exitting 2010-06-08 17:59:38 [1 ms] SQL: UPDATE realmlist SET realmflags = realmflags | 2 WHERE id = '1' 2010-06-08 17:59:38 [0 ms] SQL: UPDATE account SET active_realm_id = 0 WHERE active_realm_id = '1' 2010-06-08 17:59:38 [0 ms] SQL: UPDATE characters SET online = 0 WHERE online<>0 2010-06-08 17:59:38 [1 ms] SQL: UPDATE character_battleground_data SET instance_id = 0 2010-06-08 17:59:38 Halting process...