Gitch

Updated new branch "skillbot" When using the command /t skill or /p skill , the bot will also report their current/max skill for each proffesion, as well as weapon skills. My main thought behind this was not really for keeping up with what bots need to go train, but for keeping up with which bots need to raise what skill. Patch: diff --git a/src/game/playerbot/playerbotai.cpp b/src/game/playerbot/playerbotai.cpp index 3bf733c..c3edde4 100644 --- a/src/game/playerbot/playerbotai.cpp +++ b/src/game/playerbot/playerbotai.cpp @@ -8823,6 +8823,7 @@ void PlayerbotAI::_HandleCommandSkill(std::string &text, Player &fromPlayer) if (m_bot->GetSkillValue(*it) <= rank[sSpellMgr.GetSpellRank(skillLine->spellId)] && m_bot->HasSpell(skillLine->spellId)) { // DEBUG_LOG ("[PlayerbotAI]: HandleCommand - skill (%u)(%u)(%u):",skillLine->spellId, rank[sSpellMgr.GetSpellRank(skillLine->spellId)], m_bot->GetSkillValue(*it)); + msg << "\\n[" << m_bot->GetSkillValue(*it) << " / " << rank[sSpellMgr.GetSpellRank(skillLine->spellId)] << "]: "; MakeSpellLink(spellInfo, msg); break; } considered adding a reminder to train.. but still thinking on that. If its done each time the bot uses that skill (and needs trained) it would get annoying.. If its done along with the above.. well.. since you typed 'skill' and see the current/max skill levels.. you'll already know they need trained, or not. If you'd rather see it in 1 line rather than 2, im open to suggestions. @Rossage: Welcome back!

wow... Now thats a sticky if I ever saw one.... Thanks a ton! I had alot of those pieces floating around in my head already (from all the reading) but you just put them together nicely! In other words, it makes sense now =) ...well.. mostly haha. I'll yell if I run into any trouble. Again, thanks alot!

Hey blueboy, thanks for the reply! That was bugging me =) I have most of what i need figured out I think for now, except one thing I want to clarify: the path of information .. as I understand it atm, is: local repo -> git sub branch -> portal -> main git.. Is that close? And, if so, I am to pull from sub branch 'new-ai' and add my work to that, and push it back into a separate new sub branch (named by me)? Thanks again for your patience, I don't want to get messed up (or mess anyone else up)

Thanks Blueboy, I'm having trouble with this script.. trying to set things up more orderly on my end. #!/bin/bash -x git clone git://github.com/mangos/mangos.git playerbot cd playerbot git fetch git://github.com/playerbot/mangos.git master:playerbot git checkout playerbot HASH=`git log --pretty=oneline | grep -m 1 '\\[1[0-9]\\{4\\}]' | cut -d " " -f 1` git diff $HASH > playerbot.patch i get an error saying -m is not an option for grep. I copy/pasted it into Git. how can I save it to file, what format, and what command to execute it in Git bash? ***Edit*** and then I'll leave you alone Actually, I'll just go with merging it. Wanted to figure out the prepared patch method. What a way to spend a day off eh? Final Edit ***** Got the creation of patches figured out, and my repo looks alot better. thanks for your patience guys.

@blueboy, Done.

using the following: git pull [email protected]:blueboy/portal.git new-ai:master I get permission denied (publickey) using: git pull git://github.com/blueboy/portal.git new-ai:master seems to work.... is there a difference and what is it? sorry, git is more daunting than c++ =) want to make sure I'm getting the right code/branch.

@Kennumen: I havent tried/looked at the autobot code yet, but want to when I get things more settled. Don't want to wind up with a mess on my end =) @blueboy: Thanks for the links! I've got them bookmarked, along with a few other tidbits. In fact.. I have an Idea, *loud whirring noise, and a puff of smoke* also, yeah, the bot had the cash, and was standing there with the other bot when I took off. Also had completed the quest (first ride). I just tried riding hippos on my GM account, and it worked ok. I'll check to see whats up with that other char. It might not have taken the quest (its a draeni). @UnkleNuke: Thanks! Spotting playerbot is what got my attention again. From looking through the posts, I'd say the 'team' is a fair size. It takes all the ideas and testing as well as coding!

Is there a particular method of getting your bots to follow you on say a hippogryph? One bot does (first in group list) and other does not, but stays behind and I have to summon her. Ideas? ***Edit*** This addition will report the bot's profession skill level. It will be included if you ask for 'skill' in either /t or /p . I need to get my repo set up better.. and I'm still reading up on how to create patches.. soo.. if someone could lend some explaination I'd appreciate it. if (m_bot->GetSkillValue(*it) <= rank[sSpellMgr.GetSpellRank(skillLine->spellId)] && m_bot->HasSpell(skillLine->spellId)) { // DEBUG_LOG ("[PlayerbotAI]: HandleCommand - skill (%u)(%u)(%u):",skillLine->spellId, rank[sSpellMgr.GetSpellRank(skillLine->spellId)], m_bot->GetSkillValue(*it)); msg << "\\n" << m_bot->GetSkillValue(*it) << " / " << rank[sSpellMgr.GetSpellRank(skillLine->spellId)] << ": "; MakeSpellLink(spellInfo, msg); At approx. line 8837 in PlayerbotAI.cpp, I've inserted the code ( IN RED )for the skill report. its output is basically like this: 59 /75: [professional tradeskill] 1 /75: [professional tradeskill] I borrowed the idea from the Debug_log code on line 8836. BTW : I used newline for personal preference, the separation makes the output easier on my poor eyesight. If its preferred to be in one line, let me know. @UnkleNuke Hrm, good ideas. I'll take a look at it tomorrow.

@UnkleNuke Yeah, I've already had my sight on battlegrounds hehe. My server is already set up for 1v1 so when I get time I'd like to see what can be done. Would be interested in whats already done in that area as well. the last server I put together (long time ago) I populated the battlegrounds with NPC's from each side, which had a respawn of like.. 25 seconds or maybe less. Basically it required the player(s) to navigate a battle that was going on, to get the enemy flag or defend theirs. I never got around to writing the scripts to make it more interesting like keeping them from taking the flag etc. This code makes alot possible. ATM there are some minor things Im wondering about: for one, I'd like bots with professions to whisper their skill each time it goes up, or at the very least, report it with the 'skill' command. this would make e.g. herbalism a bit easier when gathering. So ya dont go that extra distance for that nice little patch of strangekelp, and find out their skill is 1 point too low =P From the todo list file in the root dir, it looks like the list is about done. wondered if there were other issues not listed there.

Before I start adding things to the list, is there a current wish/todo list?

@blueboy, Yeah, after the first patch, I manually removed the first code, and added the new where you see it positioned in your post. I'm going to chalk it up to something wierd on my end, it actually compiled this time. I'm just going to go bite the cat or something, I'll be back.

@blueboy, actually no errors, and have re-completed all the quests to make sure they work. Compiler would not complete with the original. Gave an error that 'spellId' was not declared. Thus game.lib wasnt created which caused the rest to fail. so... not sure what to say. maybe someone else can try the code and see if it works for them. if it's any prettier, this also works: if ((item->GetProto()->Flags & ITEM_FLAG_LOOTABLE) && (spellId == 0)) I know that logically, expressions should be separated in parenthesis, which is why I scratched my head all morning trying to get it compiled. No idea why it won't compile the initial way. Just tried it again and still the same declaration error. anyway, I'll leave it alone til you get it pushed. Maybe im missing something? **note** My programming experience with c++ is limited, ive mostly worked with various scripting languages and am pretty much self taught. too old to worry about taking classes =P While some principals are pretty common, I have to dig and work with trial and error in C++. I'll try to be more of a help than a hinderance =)

Would not compile (undeclared spelllid) **EDIT** Im brain dead this morning. The above isnt compiling for me, checking it out, disregard what I had put here already if you read it. ***EDIT #4!*** I told ya I was rusty lol. Didn't see this to begin with. THE CASE OF MYSTERIOUS PARENTHESIS From this: To this: Patch revision 3 diff --git a/src/game/playerbot/PlayerbotAI.cpp b/src/game/playerbot/PlayerbotAI.cpp index 3bf733c..c4b531d 100644 --- a/src/game/playerbot/PlayerbotAI.cpp +++ b/src/game/playerbot/PlayerbotAI.cpp @@ -5744,6 +5744,16 @@ void PlayerbotAI::UseItem(Item *item, uint32 targetFlag, ObjectGuid targetGUID) } } + if (item->GetProto()->Flags & ITEM_FLAG_LOOTABLE && spellId == 0) + { + // Open quest item in inventory, containing related items (e.g Gnarlpine necklace, containing Tallonkai's Jewel) + WorldPacket* const packet = new WorldPacket(CMSG_OPEN_ITEM, 2); + *packet << item->GetBagSlot(); + *packet << item->GetSlot(); + m_bot->GetSession()->QueuePacket(packet); // queue the packet to get around race condition + return; + } + WorldPacket *packet = new WorldPacket(CMSG_USE_ITEM, 28); *packet << bagIndex << slot << cast_count << spellId << item_guid << glyphIndex << unk_flags << targetFlag; Gnarlpine necklace works, checking to see if there are any other issues Lucky Red Envelope works, Tourmeline Phial works quest:Druid of the Claw was also broken last night but after this change it works now (unless i was doing something wrong) requires using item 8149 on Rageclaw's dead body. Last night they would use it and nothing happened, or they would use it even if rageclaws body wasnt targeted. Now they WONT use it if not targeted, and spell functions fine and quest can be completed. ***Edit 5**** NVM... when all else fails type .help lol. Overlook me, Im still getting used to the new features in 'new-ai' and such and didnt realize mail was in there. It seems the above patch is working fine so far.

Great catch blueboy! No I actually havent completed either of these yet =P I've also been testing my DB setup and tweaking it as I go. Adding patch now, will let ya know.

Works like a charm. Thanks blueboy! I'll let ya know if I find anything else. I don't want to just take liberty with your work, but if I come up with a solution to anything I'll post the patch/suggestions here for you to look over. There are a few things I may change just for my own preference, If thats okay with you.(just for my server) *I enjoy creating more than I do playing Lol*

Hey blueboy, and thanks. I had already read all your patches/merge examples, so I knew "how" but as I said I'm new to git, and knew absolutely nothing about what to do with those scripts/patches. Anyway, all sorted now! I love the wiki link I actually found it before I found you here! Really love what you've done with playerbot, I played with a group of 4 til about 3am my time without realizing how late it was lol.. Got Nil server progress done, but I was taking notes to mention here later. When I posted last night, I had only just started up the new-ai version of mangos and hadn't tested it. It's working. I'm running the portal version + new-ai now. ******New problem encountered******* Item 8049, Gnarlpine necklace; 1 of 3 items with 'flags' set to 2052 (just to help ya if you need to locate it) Can't find spell entry for spell %u on item %u" Bot whispers: Can't find spell entry for spell 0 on item 8049" This is a quest item that you "use" to receive final quest item. The bots try to cast a spell when told to use[LINK], but item has no spell, so it gets to line 5757 in playerbotAI.cpp and returns the error. Quest is: Ferocitas the Dream Eater (ID 2459) Previous Quest is: the Emerald Dreamcatcher (ID 2438) Quest giver: Tallonkai Swiftroot Quest Location: Dolanaar It looks like the code is watching for the following type items to 'use' consumables, start quest items, and items that cast a spell. Maybe IF (!spellinfo) IF (*not special item type*) give error and return. Just thinking out loud. My bots still have this item in inventory if you want me to test anything. Thats it for the moment.

@UnkleNuke yup I had found it! thanks! I'm running the current portal version now + new-ai. (should have done this to begin with duh, its the latest mangos version lol). Anyway, one thing I've meant to ask about: Are the bots supposed to loot herbs on their own? I have trained a bot as an herbalist(and alchemist) and she won't autoloot herbs. she will loot them if I tell her to get[LINK] . Just wondered. And yup, playerbot.conf is set up, and she tells me she is looting everything.(but she isnt looting herbs. I assume thats 'profession' items) I'll continue to run the beta + alpha and help test anyway I can. I'll be a while setting up my server, and this code is right down my alley for what I wanted to do! ps sorry for all the posts, this has been like holding a familiar handful of wires, but forgetting where all the ends were supposed to connect =P

Okay, one more note then I'll be quiet =P The issue with the script errors I mentioned is not because of UDB database, but because my playerbot server is using the compiled code from playerbot/mangos.git which is currently using version 11874. The latest UDB update (11876_creature_linking_templates.sql) which fixes the errors, is for the most recent mangos release which is 11878. so its a mangos version difference, not a database issue. sorry if this caused any confusion. I'm new to git, so I need to figure out how to merge the playerbot code with the newest mangos copy I have and the whole issue will be resolved... again sorry if any of this caused confusion, im trying to RE-wrap my head around this whole setup. Its been too long. Going back to my corner now.

No technical reason, just a personal preference I acknowledge that many users prefer UDB and this was why it was important to resolve the playerbot errors. Yeah so far I havent seen any other issues that could be linked to difference in DB providers. From what I can tell, it will be fine for UDB. Most people wont just use a stock install anyway, they'll tweak the DB and make their own changes. This is true even for the stock version mangos without bots, so no different with this. It would be hard to make it perfect for both DB's at the same time as different folks are working independantly on each, and the versions/updates will have different version requirements etc. Any additional tables/fields etc needed by playerbot is added anyway, so adding the playerbot updates to your favorite database should cause no issues and give playerbot what it needs to run. I'm hurrying so I hope I've been clear here ! =)

still working great. I'm going to backtrack and check somethings out next. I've also went back to using the copy of the DB I manually updated up to the 11876_01_mangos_creature_linking_template.sql (and then altered the db to lie to mangos about the version) Still fewer script errors this way, and its running smoothly. This could well be because I used the most current Acid sql (3.0.9) It may be depending on the 11876 sql. Which Acid update are you using?

*****Edit***** Patched/compiled .. It works! so far anyway. Will keep testing. Have trained 4 bots ( human war/NE druid/human mage/draeni clr) with no problems, nice! gLitch would be more appropriate more often than not im sure =) I havent got the new ai code yet, but will in a bit. Kinda distracted today by TODO's =)

Thanks Blueboy! Just saw your edit. I was glad for the chance to dig into the .cpp though, I havent done any programming in a while either. Looking forward to testing your patch!

Okay, just a couple things to note (may be common knowledge but here it is) my main server is running UDB patched to 11876_01 the bot server requires 11852 I got rid of most of the SD2 errors by patching the DB up to 11876 and lying about the DB version. (not sure why this worked, as i said, the new DB is alien to me atm) If this works well, might add an SQL to fix it, still testing. I'll be digging deeper into it later this evening when I have more time. using this new copy of the DB with playerbot seems to be okay, but the crash still happens when trying to train a bot. I noted the following: Last mangosd console report when I told bot to 'skill learn' was: CHAT: packet received. type 7, lang 1 Crash log was: Revision: * * 11874 * Date 21:1:2012. Time 12:18 //===================================================== *** Hardware *** Processor: AMD Athlon II P340 Dual-Core Processor Number Of Processors: 2 Physical Memory: 2881712 KB (Available: 1062588 KB) Commit Charge Limit: 4194303 KB *** Operation System *** Windows Vista or Windows Server 2008 Home Edition (Version 6.1, Build 7600) //===================================================== Exception code: C0000005 ACCESS_VIOLATION Fault address: 004E5DCE 01:000E4DCE C:\\wow\\mangos with bots\\mangosd.exe Registers: EAX:01762AC5 EBX:F5DACC08 ECX:00000000 EDX:01762AC5 ESI:00000000 EDI:00A3A430 CS:EIP:0023:004E5DCE SS:ESP:002B:0B3A5630 EBP:0B3A566C DS:002B ES:002B FS:0053 GS:002B Flags:00010206 Call stack: Address Frame Function SourceFile 004E5DCE 00000000 stdext::_Hash<std::tr1::_Umap_traits<unsigned int,TrainerSpell,stdext::_Hash_compare<unsigned int,std::tr1::hash<unsigned int>,std::equal_to<unsigned int> >,std::allocator<std::pair<unsigned int const ,TrainerSpell> >,0> >::lower_bound+1E 004D9E49 00000000 TrainerSpellData::Find+19 0056224D 00000000 PlayerbotAI::_HandleCommandSkill+45D 0055B4E3 00000000 PlayerbotAI::HandleCommand+EF3 009A7BDD 00000000 WorldSession::HandleMessagechatOpcode+9AD 0069B264 00000000 WorldSession::ExecuteOpcode+34 006976DE 00000000 WorldSession::Update+11E 006A49AA 00000000 World::UpdateSessions+FA 006A31E8 00000000 World::Update+3F8 00471D93 00000000 WorldRunnable::run+73 00A3A449 00000000 ACE_Based::Thread::ThreadTask+19 72832E34 00000000 __WSAFDIsSet+FFFFFFFFFFFCB20C 73473433 00000000 _endthreadex+44 734734C7 00000000 _endthreadex+D8 75253677 00000000 BaseThreadInitThunk+12 76EE9F02 00000000 RtlInitializeExceptionChain+63 76EE9ED5 00000000 RtlInitializeExceptionChain+36 ======================== Local Variables And Parameters Call stack: Address Frame Function SourceFile 004E5DCE 00000000 stdext::_Hash<std::tr1::_Umap_traits<unsigned int,TrainerSpell,stdext::_Hash_compare<unsigned int,std::tr1::hash<unsigned int>,std::equal_to<unsigned int> >,std::allocator<std::pair<unsigned int const ,TrainerSpell> >,0> >::lower_bound+1E Local <user defined> 'this' Local <user defined> '_Keyval' Local <user defined> '_Where' punting on symbol _Bucket 004D9E49 00000000 TrainerSpellData::Find+19 Local <user defined> 'this' punting on symbol spell_id Local <user defined> 'itr' 0056224D 00000000 PlayerbotAI::_HandleCommandSkill+45D Local <user defined> 'data' punting on symbol spellId Local <user defined> 'trainer_spell' punting on symbol cost Local <user defined> 'pSpellInfo' Local <user defined> 'it' punting on symbol visuals punting on symbol totalSpellLearnt Local <user defined> 'unit' Local <user defined> 'creature' punting on symbol totalCost punting on symbol fDiscountMod Local <user defined> 'cSpells' Local <user defined> 'tSpells' Local <user defined> 'this' Local <user defined> 'text' Local <user defined> 'fromPlayer' Local <user defined> 'rank' Local <user defined> 'msg' 0055B4E3 00000000 PlayerbotAI::HandleCommand+EF3 Local <user defined> 'this' Local <user defined> 'text' Local <user defined> 'fromPlayer' Local <user defined> 'input' 009A7BDD 00000000 WorldSession::HandleMessagechatOpcode+9AD punting on symbol tSecurity Local <user defined> 'msg' punting on symbol pSecurity Local <user defined> 'to' Local <user defined> 'player' Local <user defined> 'this' Local <user defined> 'recv_data' punting on symbol type punting on symbol lang Local <user defined> 'langDesc' 0069B264 00000000 WorldSession::ExecuteOpcode+34 Local <user defined> 'this' Local <user defined> 'opHandle' Local <user defined> 'packet' 006976DE 00000000 WorldSession::Update+11E Local <user defined> 'opHandle' Local <user defined> 'this' Local <user defined> 'updater' Local <user defined> 'packet' 006A49AA 00000000 World::UpdateSessions+FA Local <user defined> 'updater' Local <user defined> 'pSession' Local <user defined> 'next' Local <user defined> 'itr' Local <user defined> 'this' punting on symbol diff Local <user defined> 'sess' 006A31E8 00000000 World::Update+3F8 punting on symbol i Local <user defined> 'this' punting on symbol diff 00471D93 00000000 WorldRunnable::run+73 punting on symbol diff Local <user defined> 'this' punting on symbol realCurrTime punting on symbol realPrevTime punting on symbol prevSleepTime 00A3A449 00000000 ACE_Based::Thread::ThreadTask+19 punting on symbol param Local <user defined> '_task' 72832E34 00000000 __WSAFDIsSet+FFFFFFFFFFFCB20C 73473433 00000000 _endthreadex+44 734734C7 00000000 _endthreadex+D8 75253677 00000000 BaseThreadInitThunk+12 76EE9F02 00000000 RtlInitializeExceptionChain+63 76EE9ED5 00000000 RtlInitializeExceptionChain+36 ======================== Global Variables

NINJA EDIT: **edited to mention that I am using two copies of the following DB's, one for bot server and one for other: mangos and mangosb realmd and realmdb characters and charactersb I'm using one copy of the following databases for both (if thats a prob let me know): scriptdev2 ***end edit*** This is nothing more than a copy of my server log to show my startup, db, acid etc versions blah blah blah, I'm comparing it to my nonbot server to see what i can figure out. There are errors here I dont recall seeing on the other server (but may be there) a couple of the errors I know of (creature 10323 error is a manually spawned murkdeep that I forgot to set the spawndist, movetype etc on), (I miscounted the tradeskills duh... no biggy) the other changes I made were to pool_pool, and pool_gameobject but i see no errors there. also btw, as I said I've been away from this stuff for a long time, and to re-setup my server, I went by an old 3.3.5 guide by reaperx. If you need the link I can provide. I followed that guide to the dot(I also followed that guide in setting up the bot server as well , aside from the instructions on the playerbot page on getting the code from git) the versions of acid, mangos, and UDB that I'm using are the latest ones.. if there is an older version I should be using, let me know. While I did use the guide to set up the playerbot server, the server itself is simply the compiled git.com/playerbot/mangos.git master code (not a patched or merged version of mangos) anyway, I'm going to do some comparing with the server log from the other server etc, and I'll post it as well IF I find something or you want to see it yourself. 2012-01-21 00:54:20 MaNGOS/0.17.0-DEV (* * Revision 11874 - *) for Win32 (little-endian) [world-daemon] 2012-01-21 00:54:20 <Ctrl-C> to stop. 2012-01-21 00:54:20 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.eu MMMMMM 2012-01-21 00:54:20 Using configuration file mangosd.conf. 2012-01-21 00:54:20 World Database total connections: 2 2012-01-21 00:54:20 MySQL client library: 5.1.49 2012-01-21 00:54:20 MySQL server ver: 5.1.45-community 2012-01-21 00:54:20 MySQL client library: 5.1.49 2012-01-21 00:54:20 MySQL server ver: 5.1.45-community 2012-01-21 00:54:20 Character Database total connections: 2 2012-01-21 00:54:20 MySQL client library: 5.1.49 2012-01-21 00:54:20 MySQL server ver: 5.1.45-community 2012-01-21 00:54:20 MySQL client library: 5.1.49 2012-01-21 00:54:20 MySQL server ver: 5.1.45-community 2012-01-21 00:54:20 Login Database total connections: 2 2012-01-21 00:54:20 MySQL client library: 5.1.49 2012-01-21 00:54:20 MySQL server ver: 5.1.45-community 2012-01-21 00:54:20 MySQL client library: 5.1.49 2012-01-21 00:54:20 MySQL server ver: 5.1.45-community 2012-01-21 00:54:20 Realm running as realm ID 1 2012-01-21 00:54:20 Using World DB: UDB 0.12.2 (403) for MaNGOS 11840 with SD2 SQL for rev. 2326 2012-01-21 00:54:20 Using creature EventAI: ACID 3.0.9 'Streamlined Perfection' - Full Release for MaNGOS (3.3.5a Client) 2012-01-21 00:54:20 ERROR:MaxPrimaryTradeSkill (11) must be in range 0...10. Using 10 instead. 2012-01-21 00:54:20 Using DataDir c:\\wow\\data/ 2012-01-21 00:54:20 WORLD: VMap support included. LineOfSight:1, getHeight:1, indoorCheck:1 2012-01-21 00:54:20 WORLD: VMap data directory is: c:\\wow\\data/vmaps 2012-01-21 00:54:20 2012-01-21 00:54:20 Loading MaNGOS strings... 2012-01-21 00:54:21 2012-01-21 00:54:21 >> Loaded 825 MaNGOS strings from table mangos_string 2012-01-21 00:54:21 Initialize data stores... 2012-01-21 00:54:23 2012-01-21 00:54:23 >> Initialized 94 data stores 2012-01-21 00:54:23 Using enUS DBC Locale as default. All available DBC locales: enUS 2012-01-21 00:54:23 2012-01-21 00:54:23 Loading Script Names... 2012-01-21 00:54:24 2012-01-21 00:54:24 >> Loaded 870 Script Names 2012-01-21 00:54:24 Loading WorldTemplate... 2012-01-21 00:54:24 >> Loaded 4 World Template definitions 2012-01-21 00:54:24 2012-01-21 00:54:24 Loading InstanceTemplate... 2012-01-21 00:54:24 >> Loaded 83 Instance Template definitions 2012-01-21 00:54:24 2012-01-21 00:54:24 Loading SkillLineAbilityMultiMap Data... 2012-01-21 00:54:24 2012-01-21 00:54:24 >> Loaded 10219 SkillLineAbility MultiMap Data 2012-01-21 00:54:24 Loading SkillRaceClassInfoMultiMap Data... 2012-01-21 00:54:25 2012-01-21 00:54:25 >> Loaded 188 SkillRaceClassInfo MultiMap Data 2012-01-21 00:54:25 Cleaning up instances... 2012-01-21 00:54:25 2012-01-21 00:54:25 >> Instances cleaned up 2012-01-21 00:54:25 Packing instances... 2012-01-21 00:54:25 >> Instance numbers remapped, next instance id is 1 2012-01-21 00:54:25 2012-01-21 00:54:25 Packing groups... 2012-01-21 00:54:25 >> Group Ids remapped, next group id is 2 2012-01-21 00:54:25 2012-01-21 00:54:25 2012-01-21 00:54:25 Loading Page Texts... 2012-01-21 00:54:25 >> Loaded 1785 page texts 2012-01-21 00:54:25 2012-01-21 00:54:25 Loading Game Object Templates... 2012-01-21 00:54:26 >> Loaded 19004 game object templates 2012-01-21 00:54:26 2012-01-21 00:54:26 Loading Spell Chain Data... 2012-01-21 00:54:26 2012-01-21 00:54:26 >> Loaded 4637 spell chain records (2994 from DBC data with 2 req field updates, and 1643 loaded from table) 2012-01-21 00:54:26 Loading Spell Elixir types... 2012-01-21 00:54:26 2012-01-21 00:54:26 >> Loaded 133 spell elixir definitions 2012-01-21 00:54:26 Loading Spell Learn Skills... 2012-01-21 00:54:27 2012-01-21 00:54:27 >> Loaded 99 Spell Learn Skills from DBC 2012-01-21 00:54:27 Loading Spell Learn Spells... 2012-01-21 00:54:27 2012-01-21 00:54:27 >> Loaded 18 spell learn spells + 572 found in DBC 2012-01-21 00:54:27 Loading Spell Proc Event conditions... 2012-01-21 00:54:27 2012-01-21 00:54:27 >> Loaded 593 extra spell proc event conditions +72 custom proc (inc. +4 custom ranks) 2012-01-21 00:54:27 Loading Spell Bonus Data... 2012-01-21 00:54:27 2012-01-21 00:54:27 >> Loaded 147 extra spell bonus data 2012-01-21 00:54:27 Loading Spell Proc Item Enchant... 2012-01-21 00:54:27 2012-01-21 00:54:27 >> Loaded 8 proc item enchant definitions 2012-01-21 00:54:27 Loading Aggro Spells Definitions... 2012-01-21 00:54:28 2012-01-21 00:54:28 >> Loaded 110 spell threat entries 2012-01-21 00:54:28 Loading NPC Texts... 2012-01-21 00:54:28 2012-01-21 00:54:28 >> Loaded 5863 npc texts 2012-01-21 00:54:28 Loading Item Random Enchantments Table... 2012-01-21 00:54:28 2012-01-21 00:54:28 >> Loaded 28607 Item Enchantment definitions 2012-01-21 00:54:28 Loading Items... 2012-01-21 00:54:30 >> Loaded 36456 item prototypes 2012-01-21 00:54:30 2012-01-21 00:54:30 Loading Item converts... 2012-01-21 00:54:30 2012-01-21 00:54:30 >> Loaded 10 Item converts 2012-01-21 00:54:30 Loading Item expire converts... 2012-01-21 00:54:30 2012-01-21 00:54:30 >> Loaded 6 Item expire converts 2012-01-21 00:54:30 Loading Creature Model Based Info Data... 2012-01-21 00:54:31 >> Loaded 24155 creature model based info 2012-01-21 00:54:31 2012-01-21 00:54:31 Loading Equipment templates... 2012-01-21 00:54:31 >> Loaded 2334 equipment template 2012-01-21 00:54:31 2012-01-21 00:54:31 Loading Creature templates... 2012-01-21 00:54:32 >> Loaded 29920 creature definitions 2012-01-21 00:54:32 2012-01-21 00:54:32 Loading Creature Model for race... 2012-01-21 00:54:33 2012-01-21 00:54:33 >> Loaded 20 creature_model_race entries 2012-01-21 00:54:33 Loading SpellsScriptTarget... 2012-01-21 00:54:33 2012-01-21 00:54:33 >> Loaded 1770 Spell Script Targets 2012-01-21 00:54:33 Loading ItemRequiredTarget... 2012-01-21 00:54:33 2012-01-21 00:54:33 >> Loaded 169 Item required targets 2012-01-21 00:54:33 Loading Reputation Reward Rates... 2012-01-21 00:54:33 2012-01-21 00:54:33 >> Loaded 14 reputation_reward_rate 2012-01-21 00:54:33 Loading Creature Reputation OnKill Data... 2012-01-21 00:54:34 2012-01-21 00:54:34 >> Loaded 1664 creature award reputation definitions 2012-01-21 00:54:34 Loading Reputation Spillover Data... 2012-01-21 00:54:34 2012-01-21 00:54:34 >> Loaded 26 reputation_spillover_template 2012-01-21 00:54:34 Loading Points Of Interest Data... 2012-01-21 00:54:34 2012-01-21 00:54:34 >> Loaded 446 Points of Interest definitions 2012-01-21 00:54:34 Loading Creature Data... 2012-01-21 00:54:37 ERROR:Table `creature` have creature (GUID: 151032 Entry: 10323) with `MovementType`=0 (idle) have `spawndist`<>0, set to 0. 2012-01-21 00:54:37 2012-01-21 00:54:37 >> Loaded 140740 creatures 2012-01-21 00:54:37 Loading pet levelup spells... 2012-01-21 00:54:37 2012-01-21 00:54:37 >> Loaded 1634 pet levelup and default spells for 39 families 2012-01-21 00:54:37 Loading pet default spell additional to levelup spells... 2012-01-21 00:54:37 2012-01-21 00:54:37 >> Loaded addition spells for 111 pet spell data entries and 303 summonable creature templates 2012-01-21 00:54:37 Loading Creature Addon Data... 2012-01-21 00:54:37 2012-01-21 00:54:37 >> Loaded 13589 creature template addons 2012-01-21 00:54:37 2012-01-21 00:54:38 >> Loaded 17293 creature addons 2012-01-21 00:54:38 2012-01-21 00:54:38 >>> Creature Addon Data loaded 2012-01-21 00:54:38 2012-01-21 00:54:38 Loading Gameobject Data... 2012-01-21 00:54:41 2012-01-21 00:54:41 >> Loaded 101633 gameobjects 2012-01-21 00:54:41 Loading Gameobject Addon Data... 2012-01-21 00:54:41 >> Loaded 94 gameobject addons 2012-01-21 00:54:41 2012-01-21 00:54:41 Loading CreatureLinking Data... 2012-01-21 00:54:41 2012-01-21 00:54:41 >> Loaded creature linking for 29 creature-IDs 2012-01-21 00:54:41 Loading Objects Pooling Data... 2012-01-21 00:54:42 2012-01-21 00:54:42 >> Loaded 6043 objects pools 2012-01-21 00:54:42 2012-01-21 00:54:42 >> Loaded 23 creatures in pools from `pool_creature` 2012-01-21 00:54:42 2012-01-21 00:54:42 >> Loaded 721 creatures in pools from `pool_creature_template` 2012-01-21 00:54:42 2012-01-21 00:54:42 >> Loaded 34628 gameobject in pools from `pool_gameobject` 2012-01-21 00:54:43 2012-01-21 00:54:43 >> Loaded 141 gameobject in pools from `pool_gameobject_template` 2012-01-21 00:54:43 2012-01-21 00:54:43 >> Loaded 5479 pools in mother pools 2012-01-21 00:54:43 Loading Weather Data... 2012-01-21 00:54:43 2012-01-21 00:54:43 >> Loaded 35 weather definitions 2012-01-21 00:54:43 Loading Quests... 2012-01-21 00:54:44 ERROR:Spell (id: 33824) have SPELL_EFFECT_QUEST_COMPLETE for quest 10162 , but quest does not have SpecialFlags QUEST_SPECIAL_FLAG_EXPLORATION_OR_EVENT (2) set. Quest SpecialFlags should be corrected to enable this objective. 2012-01-21 00:54:44 2012-01-21 00:54:44 >> Loaded 9079 quests definitions 2012-01-21 00:54:44 Loading Quest POI 2012-01-21 00:54:44 2012-01-21 00:54:44 >> Loaded 18483 quest POI definitions 2012-01-21 00:54:44 Loading Quests Relations... 2012-01-21 00:54:44 2012-01-21 00:54:45 2012-01-21 00:54:45 >> Loaded 412 quest relations from gameobject_questrelation 2012-01-21 00:54:45 2012-01-21 00:54:45 >> Loaded 341 quest relations from gameobject_involvedrelation 2012-01-21 00:54:45 2012-01-21 00:54:45 >> Loaded 7680 quest relations from creature_questrelation 2012-01-21 00:54:45 2012-01-21 00:54:45 >> Loaded 7901 quest relations from creature_involvedrelation 2012-01-21 00:54:45 >>> Quests Relations loaded 2012-01-21 00:54:45 2012-01-21 00:54:45 Loading Game Event Data... 2012-01-21 00:54:45 2012-01-21 00:54:46 2012-01-21 00:54:46 >> Loaded 65 game events 2012-01-21 00:54:46 2012-01-21 00:54:46 >> Loaded 3376 creatures in game events 2012-01-21 00:54:46 2012-01-21 00:54:46 >> Loaded 24744 gameobjects in game events 2012-01-21 00:54:47 2012-01-21 00:54:47 >> Loaded 81 creature reactions at game events 2012-01-21 00:54:47 2012-01-21 00:54:47 >> Loaded 37 quest additions in game events 2012-01-21 00:54:47 2012-01-21 00:54:47 >> Loaded 24 start/end game event mails 2012-01-21 00:54:47 >>> Game Event Data loaded 2012-01-21 00:54:47 2012-01-21 00:54:47 Creating map persistent states for non-instanceable maps... 2012-01-21 00:54:47 Loading Creature Respawn Data... 2012-01-21 00:54:47 2012-01-21 00:54:47 >> Loaded 0 creature respawn time. 2012-01-21 00:54:47 Loading Gameobject Respawn Data... 2012-01-21 00:54:47 2012-01-21 00:54:47 >> Loaded 0 gameobject respawn time. 2012-01-21 00:54:47 Loading UNIT_NPC_FLAG_SPELLCLICK Data... 2012-01-21 00:54:47 2012-01-21 00:54:47 >> Loaded 23 spellclick definitions 2012-01-21 00:54:47 Loading SpellArea Data... 2012-01-21 00:54:47 2012-01-21 00:54:47 >> Loaded 248 spell area requirements 2012-01-21 00:54:47 Loading AreaTrigger definitions... 2012-01-21 00:54:48 2012-01-21 00:54:48 >> Loaded 228 area trigger teleport definitions 2012-01-21 00:54:48 Loading Quest Area Triggers... 2012-01-21 00:54:48 2012-01-21 00:54:48 >> Loaded 55 quest trigger points 2012-01-21 00:54:48 Loading Tavern Area Triggers... 2012-01-21 00:54:48 2012-01-21 00:54:48 >> Loaded 113 tavern triggers 2012-01-21 00:54:48 Loading AreaTrigger script names... 2012-01-21 00:54:48 2012-01-21 00:54:48 >> Loaded 39 areatrigger scripts 2012-01-21 00:54:48 Loading event id script names... 2012-01-21 00:54:49 2012-01-21 00:54:49 >> Loaded 23 scripted event id 2012-01-21 00:54:49 Loading Graveyard-zone links... 2012-01-21 00:54:49 2012-01-21 00:54:49 >> Loaded 705 graveyard-zone links 2012-01-21 00:54:49 Loading spell target destination coordinates... 2012-01-21 00:54:49 2012-01-21 00:54:49 >> Loaded 556 spell target destination coordinates 2012-01-21 00:54:49 Loading spell pet auras... 2012-01-21 00:54:49 2012-01-21 00:54:49 >> Loaded 45 spell pet auras 2012-01-21 00:54:49 Loading Player Create Info & Level Stats... 2012-01-21 00:54:49 2012-01-21 00:54:50 2012-01-21 00:54:50 >> Loaded 62 player create definitions 2012-01-21 00:54:50 2012-01-21 00:54:50 >> Loaded 0 custom player create items 2012-01-21 00:54:50 2012-01-21 00:54:50 >> Loaded 2851 player create spells 2012-01-21 00:54:50 2012-01-21 00:54:50 >> Loaded 355 player create actions 2012-01-21 00:54:51 2012-01-21 00:54:51 >> Loaded 800 level health/mana definitions 2012-01-21 00:54:51 2012-01-21 00:54:51 >> Loaded 4960 level stats definitions 2012-01-21 00:54:51 2012-01-21 00:54:51 >> Loaded 79 xp for level definitions 2012-01-21 00:54:51 >>> Player Create Info & Level Stats loaded 2012-01-21 00:54:51 2012-01-21 00:54:51 Loading Exploration BaseXP Data... 2012-01-21 00:54:51 2012-01-21 00:54:51 >> Loaded 71 BaseXP definitions 2012-01-21 00:54:51 Loading Pet Name Parts... 2012-01-21 00:54:52 2012-01-21 00:54:52 >> Loaded 313 pet name parts 2012-01-21 00:54:52 Cleaning character database... 2012-01-21 00:54:52 Loading the max pet number... 2012-01-21 00:54:52 2012-01-21 00:54:52 >> Loaded the max pet number: 0 2012-01-21 00:54:52 Loading pet level stats... 2012-01-21 00:54:52 2012-01-21 00:54:52 >> Loaded 2560 level pet stats definitions 2012-01-21 00:54:52 Loading Player Corpses... 2012-01-21 00:54:52 2012-01-21 00:54:52 >> Loaded 0 corpses 2012-01-21 00:54:52 Loading Player level dependent mail rewards... 2012-01-21 00:54:52 2012-01-21 00:54:52 >> Loaded 24 level dependent mail rewards, 2012-01-21 00:54:52 Loading Loot Tables... 2012-01-21 00:54:52 2012-01-21 00:54:52 creature_loot_template : 2012-01-21 00:54:54 2012-01-21 00:54:54 >> Loaded 262332 loot definitions (7908 templates) 2012-01-21 00:54:54 fishing_loot_template : 2012-01-21 00:54:54 2012-01-21 00:54:54 >> Loaded 256 loot definitions (217 templates) 2012-01-21 00:54:54 gameobject_loot_template : 2012-01-21 00:54:54 2012-01-21 00:54:54 >> Loaded 17997 loot definitions (1131 templates) 2012-01-21 00:54:54 item_loot_template : 2012-01-21 00:54:54 2012-01-21 00:54:54 >> Loaded 5048 loot definitions (284 templates) 2012-01-21 00:54:54 mail_loot_template : 2012-01-21 00:54:55 2012-01-21 00:54:55 >> Loaded 72 loot definitions (71 templates) 2012-01-21 00:54:55 milling_loot_template : 2012-01-21 00:54:55 2012-01-21 00:54:55 >> Loaded 45 loot definitions (45 templates) 2012-01-21 00:54:55 pickpocketing_loot_template : 2012-01-21 00:54:55 2012-01-21 00:54:55 >> Loaded 11001 loot definitions (2550 templates) 2012-01-21 00:54:55 skinning_loot_template : 2012-01-21 00:54:56 2012-01-21 00:54:56 >> Loaded 3382 loot definitions (948 templates) 2012-01-21 00:54:56 disenchant_loot_template : 2012-01-21 00:54:56 2012-01-21 00:54:56 >> Loaded 123 loot definitions (55 templates) 2012-01-21 00:54:56 prospecting_loot_template : 2012-01-21 00:54:56 2012-01-21 00:54:56 >> Loaded 103 loot definitions (10 templates) 2012-01-21 00:54:56 spell_loot_template : 2012-01-21 00:54:56 2012-01-21 00:54:56 >> Loaded 161 loot definitions (21 templates) 2012-01-21 00:54:56 reference_loot_template : 2012-01-21 00:54:57 2012-01-21 00:54:57 >> Loaded 10010 loot definitions (579 templates) 2012-01-21 00:54:57 >>> Loot Tables loaded 2012-01-21 00:54:57 2012-01-21 00:54:57 Loading Skill Discovery Table... 2012-01-21 00:54:57 2012-01-21 00:54:57 >> Loaded 348 skill discovery definitions 2012-01-21 00:54:57 Loading Skill Extra Item Table... 2012-01-21 00:54:57 2012-01-21 00:54:57 >> Loaded 206 spell specialization definitions 2012-01-21 00:54:57 Loading Skill Fishing base level requirements... 2012-01-21 00:54:58 2012-01-21 00:54:58 >> Loaded 93 areas for fishing base skill level 2012-01-21 00:54:58 Loading Achievements... 2012-01-21 00:54:58 2012-01-21 00:54:58 2012-01-21 00:54:58 >> Loaded 43 achievement references. 2012-01-21 00:54:58 2012-01-21 00:54:58 >> Loaded 1105 achievement criteria. 2012-01-21 00:54:58 2012-01-21 00:54:58 >> Loaded 2060 additional achievement criteria data (222 disabled). 2012-01-21 00:54:59 2012-01-21 00:54:59 >> Loaded 102 achievement rewards 2012-01-21 00:54:59 2012-01-21 00:54:59 >> Loaded 0 achievement reward locale strings. DB table `locales_achievement_reward` is empty. 2012-01-21 00:54:59 2012-01-21 00:54:59 >> Loaded 24 realm completed achievements. 2012-01-21 00:54:59 >>> Achievements loaded 2012-01-21 00:54:59 2012-01-21 00:54:59 Loading Instance encounters data... 2012-01-21 00:54:59 2012-01-21 00:54:59 >> Loaded 590 Instance Encounters 2012-01-21 00:54:59 Loading Npc Text Id... 2012-01-21 00:54:59 2012-01-21 00:54:59 >> Loaded 3364 NpcTextId 2012-01-21 00:54:59 Loading Gossip scripts... 2012-01-21 00:54:59 gossip_scripts : 2012-01-21 00:55:00 2012-01-21 00:55:00 >> Loaded 201 script definitions 2012-01-21 00:55:00 (Re)Loading Gossip menus... 2012-01-21 00:55:00 2012-01-21 00:55:00 >> Loaded 3401 gossip_menu entries 2012-01-21 00:55:00 (Re)Loading Gossip menu options... 2012-01-21 00:55:00 2012-01-21 00:55:00 >> Loaded 2749 gossip_menu_option entries 2012-01-21 00:55:00 Loading Vendors... 2012-01-21 00:55:00 2012-01-21 00:55:00 >> Loaded 23 vendor template items 2012-01-21 00:55:01 2012-01-21 00:55:01 >> Loaded 36047 vendor items 2012-01-21 00:55:01 Loading Trainers... 2012-01-21 00:55:01 2012-01-21 00:55:01 >> Loaded 2359 trainer template spells 2012-01-21 00:55:01 2012-01-21 00:55:01 >> Loaded 22208 trainer spells 2012-01-21 00:55:01 Loading Waypoint scripts... 2012-01-21 00:55:01 creature_movement_scripts : 2012-01-21 00:55:02 2012-01-21 00:55:02 >> Loaded 179 script definitions 2012-01-21 00:55:02 Loading Waypoints... 2012-01-21 00:55:02 2012-01-21 00:55:03 2012-01-21 00:55:03 >> Paths loaded 2012-01-21 00:55:04 2012-01-21 00:55:04 >> Waypoints and behaviors loaded 2012-01-21 00:55:04 2012-01-21 00:55:04 >>> Loaded 2398 paths, 50020 nodes and 750 behaviors 2012-01-21 00:55:05 2012-01-21 00:55:05 >> Path templates loaded 2012-01-21 00:55:05 2012-01-21 00:55:05 >> Waypoint templates loaded 2012-01-21 00:55:05 2012-01-21 00:55:05 >>> Loaded 69 path templates with 1975 nodes and 18 behaviors 2012-01-21 00:55:05 Loading Localization strings... 2012-01-21 00:55:05 2012-01-21 00:55:05 >> Loaded 0 creature locale strings. DB table `locales_creature` is empty. 2012-01-21 00:55:05 2012-01-21 00:55:05 >> Loaded 0 gameobject locale strings. DB table `locales_gameobject` is empty. 2012-01-21 00:55:05 2012-01-21 00:55:05 >> Loaded 0 Item locale strings. DB table `locales_item` is empty. 2012-01-21 00:55:05 2012-01-21 00:55:05 >> Loaded 0 Quest locale strings. DB table `locales_quest` is empty. 2012-01-21 00:55:05 2012-01-21 00:55:05 >> Loaded 0 Quest locale strings. DB table `locales_npc_text` is empty. 2012-01-21 00:55:05 2012-01-21 00:55:05 >> Loaded 0 PageText locale strings. DB table `locales_page_text` is empty. 2012-01-21 00:55:05 2012-01-21 00:55:05 >> Loaded 0 gossip_menu_option locale strings. DB table `locales_gossip_menu_option` is empty. 2012-01-21 00:55:05 2012-01-21 00:55:05 >> Loaded 0 points_of_interest locale strings. DB table `locales_points_of_interest` is empty. 2012-01-21 00:55:05 >>> Localization strings loaded 2012-01-21 00:55:05 2012-01-21 00:55:05 Loading Auctions... 2012-01-21 00:55:05 2012-01-21 00:55:05 2012-01-21 00:55:05 >> Loaded 0 auction items 2012-01-21 00:55:05 2012-01-21 00:55:05 >> Loaded 0 auctions. DB table `auction` is empty. 2012-01-21 00:55:05 >>> Auctions loaded 2012-01-21 00:55:05 2012-01-21 00:55:05 Loading Guilds... 2012-01-21 00:55:05 2012-01-21 00:55:05 >> Loaded 0 guild definitions 2012-01-21 00:55:05 Loading ArenaTeams... 2012-01-21 00:55:05 2012-01-21 00:55:05 >> Loaded 0 arenateam definitions 2012-01-21 00:55:05 Loading Groups... 2012-01-21 00:55:05 2012-01-21 00:55:05 >> Loaded 1 group definitions 2012-01-21 00:55:05 2012-01-21 00:55:05 >> Loaded 0 group-instance binds total 2012-01-21 00:55:05 2012-01-21 00:55:05 >> Loaded 0 group members total 2012-01-21 00:55:05 Loading ReservedNames... 2012-01-21 00:55:05 2012-01-21 00:55:05 >> Loaded 0 reserved player names 2012-01-21 00:55:05 Loading GameObjects for quests... 2012-01-21 00:55:05 2012-01-21 00:55:05 >> Loaded 1551 GameObjects for quests 2012-01-21 00:55:05 Loading BattleMasters... 2012-01-21 00:55:06 2012-01-21 00:55:06 >> Loaded 136 battlemaster entries 2012-01-21 00:55:06 Loading BattleGround event indexes... 2012-01-21 00:55:06 2012-01-21 00:55:06 >> Loaded 1236 battleground eventindexes 2012-01-21 00:55:06 Loading GameTeleports... 2012-01-21 00:55:06 2012-01-21 00:55:06 >> Loaded 1424 GameTeleports 2012-01-21 00:55:06 Loading GM tickets... 2012-01-21 00:55:06 2012-01-21 00:55:06 >> Loaded `character_ticket`, table is empty. 2012-01-21 00:55:06 Returning old mails... 2012-01-21 00:55:06 2012-01-21 00:55:06 >> Only expired mails (need to be return or delete) or DB table `mail` is empty. 2012-01-21 00:55:06 Loading Scripts... 2012-01-21 00:55:06 2012-01-21 00:55:06 quest_start_scripts : 2012-01-21 00:55:07 2012-01-21 00:55:07 >> Loaded 250 script definitions 2012-01-21 00:55:07 quest_end_scripts : 2012-01-21 00:55:07 2012-01-21 00:55:07 >> Loaded 375 script definitions 2012-01-21 00:55:07 spell_scripts : 2012-01-21 00:55:07 2012-01-21 00:55:07 >> Loaded 26 script definitions 2012-01-21 00:55:07 gameobject_scripts : 2012-01-21 00:55:07 2012-01-21 00:55:07 >> Loaded 54 script definitions 2012-01-21 00:55:07 event_scripts : 2012-01-21 00:55:08 2012-01-21 00:55:08 >> Loaded 483 script definitions 2012-01-21 00:55:08 >>> Scripts loaded 2012-01-21 00:55:08 2012-01-21 00:55:08 Loading Scripts text locales... 2012-01-21 00:55:08 2012-01-21 00:55:08 >> Loaded 494 string templates from db_script_string 2012-01-21 00:55:08 Loading CreatureEventAI Texts... 2012-01-21 00:55:08 2012-01-21 00:55:08 >> Loaded 1164 string templates from creature_ai_texts 2012-01-21 00:55:08 Loading EventAI Texts additional data... 2012-01-21 00:55:08 2012-01-21 00:55:08 >> Loaded 1164 additional CreatureEventAI Texts data. 2012-01-21 00:55:08 Loading CreatureEventAI Summons... 2012-01-21 00:55:09 2012-01-21 00:55:09 >> Loaded 19 CreatureEventAI summon definitions 2012-01-21 00:55:09 Loading CreatureEventAI Scripts... 2012-01-21 00:55:10 2012-01-21 00:55:10 >> Loaded 25292 CreatureEventAI scripts 2012-01-21 00:55:10 Initializing Scripts... 2012-01-21 00:55:10 2012-01-21 00:55:10 MMM MMM MM 2012-01-21 00:55:10 M MM M M M M 2012-01-21 00:55:10 MM M M M 2012-01-21 00:55:10 MMM M M M 2012-01-21 00:55:10 MM M M MMMM 2012-01-21 00:55:10 MM M M M 2012-01-21 00:55:10 MMM MMM http://www.scriptdev2.com 2012-01-21 00:55:10 2012-01-21 00:55:10 SD2: Using configuration file scriptdev2.conf 2012-01-21 00:55:10 2012-01-21 00:55:10 MySQL client library: 5.1.49 2012-01-21 00:55:10 MySQL server ver: 5.1.45-community 2012-01-21 00:55:10 MySQL client library: 5.1.49 2012-01-21 00:55:10 MySQL server ver: 5.1.45-community 2012-01-21 00:55:10 SD2: ScriptDev2 database at 127.0.0.1;3306;mangos;mangos;scriptdev2 initialized. 2012-01-21 00:55:10 2012-01-21 00:55:10 Loading ScriptDev2 (for MaNGOS 11812+) Revision [2403] (*) * * (Win32) 2012-01-21 00:55:10 2012-01-21 00:55:10 SD2: Loading Script Texts... 2012-01-21 00:55:10 2012-01-21 00:55:10 >> Loaded 3340 string templates from script_texts 2012-01-21 00:55:10 SD2: Loading Script Texts additional data... 2012-01-21 00:55:10 2012-01-21 00:55:10 >> Loaded 3340 additional Script Texts data. 2012-01-21 00:55:10 SD2: Loading Custom Texts... 2012-01-21 00:55:10 2012-01-21 00:55:10 >> Loaded 0 string templates. DB table `custom_texts` is empty. 2012-01-21 00:55:10 SD2: Loading Custom Texts additional data... 2012-01-21 00:55:10 2012-01-21 00:55:10 >> Loaded 0 additional Custom Texts data. DB table `custom_texts` is empty. 2012-01-21 00:55:10 SD2: Loading Gossip Texts... 2012-01-21 00:55:11 2012-01-21 00:55:11 >> Loaded 56 string templates from gossip_texts 2012-01-21 00:55:11 SD2: Loading Script Waypoints for 70 creature(s)... 2012-01-21 00:55:11 2012-01-21 00:55:11 >> Loaded 1964 Script Waypoint nodes. 2012-01-21 00:55:11 SD2: Loading C++ scripts 2012-01-21 00:55:11 2012-01-21 00:55:11 ERROR:SD2: Script registering but ScriptName spell_dummy_npc_brutallus_cloud is not assigned in database. Script will not be used. 2012-01-21 00:55:11 ERROR:SD2: Script registering but ScriptName boss_felmyst is not assigned in database. Script will not be used. 2012-01-21 00:55:11 ERROR:SD2: Script registering but ScriptName boss_kiljaeden is not assigned in database. Script will not be used. 2012-01-21 00:55:11 ERROR:SD2: Script registering but ScriptName npc_kiljaeden_controller is not assigned in database. Script will not be used. 2012-01-21 00:55:11 ERROR:SD2: Script registering but ScriptName boss_muru is not assigned in database. Script will not be used. 2012-01-21 00:55:11 ERROR:SD2: Script registering but ScriptName boss_entropius is not assigned in database. Script will not be used. 2012-01-21 00:55:11 ERROR:SD2: Script registering but ScriptName npc_portal_target is not assigned in database. Script will not be used. 2012-01-21 00:55:11 ERROR:SD2: Script registering but ScriptName npc_void_sentinel_summoner is not assigned in database. Script will not be used. 2012-01-21 00:55:11 ERROR:SD2: Script registering but ScriptName boss_ossirian is not assigned in database. Script will not be used. 2012-01-21 00:55:11 ERROR:SD2: Script registering but ScriptName go_ossirian_crystal is not assigned in database. Script will not be used. 2012-01-21 00:55:11 ERROR:SD2: Script registering but ScriptName boss_eregos is not assigned in database. Script will not be used. 2012-01-21 00:55:11 ERROR:SD2: Script registering but ScriptName boss_urom is not assigned in database. Script will not be used. 2012-01-21 00:55:11 ERROR:SD2: Script registering but ScriptName instance_oculus is not assigned in database. Script will not be used. 2012-01-21 00:55:11 ERROR:SD2: Script registering but ScriptName mob_shadowy_construct is not assigned in database. Script will not be used. 2012-01-21 00:55:11 ERROR:SD2: No script found for ScriptName 'go_field_repair_bot_74A'. 2012-01-21 00:55:11 ERROR:SD2: No script found for ScriptName 'go_orb_of_command'. 2012-01-21 00:55:11 ERROR:SD2: No script found for ScriptName 'go_spectral_rift'. 2012-01-21 00:55:11 ERROR:SD2: No script found for ScriptName 'npc_kalaran_windblade'. 2012-01-21 00:55:11 ERROR:SD2: No script found for ScriptName 'npc_lothos_riftwaker'. 2012-01-21 00:55:11 ERROR:SD2: No script found for ScriptName 'npc_lunaclaw_spirit'. 2012-01-21 00:55:11 ERROR:SD2: No script found for ScriptName 'npc_rogue_trainer'. 2012-01-21 00:55:11 ERROR:SD2: No script found for ScriptName 'npc_zamael_lunthistle'. 2012-01-21 00:55:11 >> Loaded 862 C++ Scripts. 2012-01-21 00:55:11 Scripting library loaded. 2012-01-21 00:55:11 DEBUG:: Initialize game time and timers 2012-01-21 00:55:11 Starting Map System 2012-01-21 00:55:11 Starting BattleGround System 2012-01-21 00:55:11 2012-01-21 00:55:11 >> Loaded 13 battlegrounds 2012-01-21 00:55:11 Loading Transports... 2012-01-21 00:55:11 2012-01-21 00:55:11 >> Loaded 20 transports 2012-01-21 00:55:11 Deleting expired bans... 2012-01-21 00:55:11 Calculate next daily quest reset time... 2012-01-21 00:55:11 Calculate next weekly quest reset time... 2012-01-21 00:55:11 Calculate next monthly quest reset time... 2012-01-21 00:55:11 Starting Game Event system... 2012-01-21 00:55:11 GameEvent 16 "Gurubashi Arena Booty Run" started. 2012-01-21 00:55:12 GameEvent 21 "Call to Arms: Eye of the Storm!" started. 2012-01-21 00:55:12 GameEvent 32 "Edge of Madness, Wushoolay" started. 2012-01-21 00:55:12 GameEvent 42 "Leader of Jin'Alai, Gawanil" started. 2012-01-21 00:55:12 GameEvent 45 "Brew of the Month, January" started. 2012-01-21 00:55:12 GameEvent 59 "World's End Tavern - L70ETC Concert Announce" started. 2012-01-21 00:55:12 Player::DeleteOldChars: Deleting all characters which have been deleted 30 days before... 2012-01-21 00:55:12 Playerbot: Using configuration file playerbot.conf 2012-01-21 00:55:12 Initialize AuctionHouseBot... 2012-01-21 00:55:12 AHBOT is Disabled. Unable to open configuration file(ahbot.conf). 2012-01-21 00:55:12 WORLD: World initialized 2012-01-21 00:55:12 SERVER STARTUP TIME: 0 minutes 51 seconds 2012-01-21 00:55:12 mangosd process priority class set to HIGH 2012-01-21 00:55:12 2012-01-21 00:55:12 2012-01-21 00:56:31 ERROR:SESSION: received not allowed opcode CMSG_LFG_GET_STATUS (0x0296) 2012-01-21 00:56:31 ERROR:SESSION: received not allowed opcode CMSG_LFG_GET_STATUS (0x0296) 2012-01-21 00:57:18 ERROR:SESSION: received not allowed opcode CMSG_LFG_GET_STATUS (0x0296) 2012-01-21 00:58:01 GameEvent 61 "Stormwind City - Stockades Jail Break" started. 2012-01-21 01:00:01 GameEvent 42 "Leader of Jin'Alai, Gawanil" removed. 2012-01-21 01:00:01 GameEvent 43 "Leader of Jin'Alai, Chulo" started. 2012-01-21 01:00:01 GameEvent 60 "World's End Tavern - L70ETC Concert" started. 2012-01-21 01:00:01 ERROR:SESSION: received not allowed opcode CMSG_LFG_GET_STATUS (0x0296)

@blueboy, I was tired.. the command in my version is 'skill learn' not 'skill train'. I may still try the new-ai branch of code. thanks for the heads up. Also, Update on the crash issue: I tried 'skill learn' with my GM acct, and instead of crashing.. mangos simply stopped...working.. yeah i know that sounds silly, but let me explain: mangos in appearance was fine, except it no longer showed any updates, while nothing happened in the client. When i closed my clients down, the mangos screen gave a message.. I thought how wierd that its locked up and still acknowledging the client leaving... so I tried logging back in.. well.. authenticated successfully, and mangos screen acknowledged the client login, but, client wouldnt go further than the realm select screen. I couldnt type anything in the mangos console window, but it wasnt frozen so to speak... I clicked on the red x, and away it went. so this was much different than when I do it on my normal account.. also, on my normal acct, i can add bots with the .bot add cmd but not with the menu now, the menu doesnt show up after the first 'skill learn' crash. Anyway, heres what little info I can provide about before, during and after that last crash (on GM account) Just before crash: WORLD: SMSG_UI_TIME WORLD: Time Lag/Synchronization Resent/Update CMSG_TIME_SYNC_RESP Time sync received: counter 26, client ticks 595897, time since last sync 10021 Our ticks: 596147, diff 250, latency 1 CMSG_TIME_SYNC_RESP Time sync received: counter 19, client ticks 596756, time since last sync 10055 Our ticks: 596806, diff 50, latency 2 CMSG_TIME_SYNC_RESP Time sync received: counter 27, client ticks 605921, time since last sync 10024 Our ticks: 606171, diff 250, latency 1 CMSG_TIME_SYNC_RESP Time sync received: counter 20, client ticks 606747, time since last sync 9991 Our ticks: 606800, diff 53, latency 3 CHAT: packet received. type 7, lang 1 That last bit of text in red would be the last chat sent to me bot that the server acknowledged (I think, perhaps not the cause, but the one prior to it) During the crash(non-functioning mangos): WorldSocket::handle_input: Peer has closed connection WorldSocket::handle_input: Peer has closed connection I logged both accounts out after the server stopped responding Next, is the list of text when I tried to log right back in: WorldSocket::HandleAuthSession: client build 12340, account 88888888, clientsee d E0A3607A [2 ms] SQL: SELECT id, gmlevel, sessionkey, last_ip, locked, v, s, expansion, mu tetime, locale FROM account WHERE username = '8888888' WorldSocket::HandleAuthSession: (s,v) check s: BD37F6DDFDD2F2E7209BE1537BE5B3A91 50C9BF7FE570790F627BB6F98DD2B09 v: 31C3850A0DD2333F676B707E040EC7B987BFA8648DEBA 62B695D853148C510C8 [1 ms] SQL: SELECT 1 FROM account_banned WHERE id = 5 AND active = 1 AND (unband ate > UNIX_TIMESTAMP() OR unbandate = bandate)UNION SELECT 1 FROM ip_banned WHER E (unbandate = bandate OR unbandate > UNIX_TIMESTAMP()) AND ip = '127.0.0.1' WorldSocket::HandleAuthSession: Client '88888888' authenticated successfully fr om 127.0.0.1. [1 ms] SQL: SELECT type, time, data FROM account_data WHERE account='5' [1 ms] SQL: SELECT tut0,tut1,tut2,tut3,tut4,tut5,tut6,tut7 FROM character_tutori al WHERE account = '5' ADDON: Name: Blizzard_AchievementUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x 0 ADDON: Name: Blizzard_ArenaUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0 ADDON: Name: Blizzard_AuctionUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0 ADDON: Name: Blizzard_BarbershopUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0 ADDON: Name: Blizzard_BattlefieldMinimap, Enabled: 0x1, CRC: 0x4c1c776d, Unknown 2: 0x0 ADDON: Name: Blizzard_BindingUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0 ADDON: Name: Blizzard_Calendar, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0 ADDON: Name: Blizzard_CombatLog, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0 ADDON: Name: Blizzard_CombatText, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0 ADDON: Name: Blizzard_DebugTools, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0 ADDON: Name: Blizzard_GMChatUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0 ADDON: Name: Blizzard_GMSurveyUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0 ADDON: Name: Blizzard_GlyphUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0 ADDON: Name: Blizzard_GuildBankUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0 ADDON: Name: Blizzard_InspectUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0 ADDON: Name: Blizzard_ItemSocketingUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0 ADDON: Name: Blizzard_MacroUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0 ADDON: Name: Blizzard_RaidUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0 ADDON: Name: Blizzard_TalentUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0 ADDON: Name: Blizzard_TimeManager, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0 ADDON: Name: Blizzard_TokenUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0 ADDON: Name: Blizzard_TradeSkillUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0 ADDON: Name: Blizzard_TrainerUI, Enabled: 0x1, CRC: 0x4c1c776d, Unknown2: 0x0 EDIT: hrm, I just checked my dberrors.txt from the bot server directory, and found an error that doesnt appear on my other server. the only diff in the servers is playerbot code. (unless I've done something stupid when I wasn't watching myself.. sometimes self can get into trouble): 2012-01-21 00:54:44 Spell (id: 33824) have SPELL_EFFECT_QUEST_COMPLETE for quest 10162 , but quest does not have SpecialFlags QUEST_SPECIAL_FLAG_EXPLORATION_OR_EVENT (2) set. Quest SpecialFlags should be corrected to enable this objective. I'm so rusty and the DB structure has changed so much its alien to me now lol, so im trying to figure it all out again. Off to see if I can figure out where this error come from. Thought something might catch yer eye, dunno. Anyway, I'll dig a bit deeper later today, wanted to toss that info up. cheers.