Jump to content

Playerbot

Auntie Mangos

By Auntie Mangos
in OldCore modifications

 Share

Recommended Posts

Gitch Advanced Member

Gitch

Posted
Posted

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)

Link to comment
Share on other sites
  • Replies 799
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Gitch Advanced Member

Gitch

Posted
Posted

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

Link to comment
Share on other sites
blueboy Advanced Member

blueboy

Posted
Posted

Hi Gitch,

Thanks for your time testing this issue out. Sorry you might not have noticed that I edited my last post. I found the problem.

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

TrainerSpellData::Find(uint32 spellId) is called using either cSpell or tSpell pointers. With UDB data one of these had a NULL value, thus the crash. I have now revised the code to test both before they are used and assign the most appropriate. When I first created the command my choice of variable names was also poor

1. trainer_spell

2. trainer_spells

and this might have caused confusion. I have now renamed 'trainer_spells' to 'all_trainer_spells'. At present I'm just testing the patch with all repo code before pushing it. If you would like to try it before on your server, here's the patch (currently only tested on portal master code).

(N.B If your using windows save the pasted patch with 'unicode' encoding and newline at EOF)

diff --git a/src/game/playerbot/PlayerbotAI.cpp b/src/game/playerbot/PlayerbotAI.cpp
index 9107b82..20e77e4 100644
--- a/src/game/playerbot/PlayerbotAI.cpp
+++ b/src/game/playerbot/PlayerbotAI.cpp
@@ -7496,8 +7496,13 @@ void PlayerbotAI::_HandleCommandSkill(std::string &text, Player &fromPlayer)

        // check present spell in trainer spell list
        TrainerSpellData const* cSpells = creature->GetTrainerSpells();
-        TrainerSpellData const* tSpells = creature->GetTrainerTemplateSpells();
-        if (!cSpells && !tSpells)
+        TrainerSpellData const* tSpells = creature->GetTrainerTemplateSpells();
+
+        TrainerSpellData const* all_trainer_spells = cSpells;
+        if (!all_trainer_spells)
+           all_trainer_spells = tSpells;
+
+    if (!all_trainer_spells)
        {
            SendWhisper("No spells can be learnt from this trainer", fromPlayer);
            return;
@@ -7521,10 +7526,7 @@ void PlayerbotAI::_HandleCommandSkill(std::string &text, Player &fromPlayer)
                if (!spellId)
                    break;

-                TrainerSpell const* trainer_spell = cSpells->Find(spellId);
-                if (!trainer_spell)
-                    trainer_spell = tSpells->Find(spellId);
-
+                TrainerSpell const* trainer_spell = all_trainer_spells->Find(spellId);
                if (!trainer_spell || !trainer_spell->learnedSpell)
                    continue;

@@ -7583,11 +7585,7 @@ void PlayerbotAI::_HandleCommandSkill(std::string &text, Player &fromPlayer)
        {
            msg << "The spells I can learn and their cost:\\r";

-            TrainerSpellData const* trainer_spells = cSpells;
-            if (!trainer_spells)
-                trainer_spells = tSpells;
-
-            for (TrainerSpellMap::const_iterator itr =  trainer_spells->spellList.begin(); itr !=  trainer_spells->spellList.end(); ++itr)
+            for (TrainerSpellMap::const_iterator itr =  all_trainer_spells->spellList.begin(); itr !=  all_trainer_spells->spellList.end(); ++itr)
            {
                TrainerSpell const* tSpell = &itr->second;

EDIT@ Sorry Gitch I have been calling you 'Glitch' by mistake. I guess errors happen ;)

Hope this helps

Link to comment
Share on other sites
Gitch Advanced Member

Gitch

Posted
Posted

*****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 =)

Link to comment
Share on other sites
Gitch Advanced Member

Gitch

Posted
Posted

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?

Link to comment
Share on other sites
blueboy Advanced Member

blueboy

Posted
Posted
Is there any particular technical reasoning behind your choice to use YTDB instead of UDB, blueboy?

It may be there's just enough difference between the two databases to explain some Playerbot errors.

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.

The crash occured because the pointer 'cSpells' returned a NULL value.

TrainerSpellData const* cSpells = creature->GetTrainerSpells();

It just so happens that this does not occur with the YTDB data, but does for UDB. I should have built in a check on the validity of the cSpells value before using it here

TrainerSpell const* trainer_spell = cSpells->Find(spellId);

My bad, and not a crticism of either YTDB or UDB.

Link to comment
Share on other sites
Gitch Advanced Member

Gitch

Posted
Posted
Is there any particular technical reasoning behind your choice to use YTDB instead of UDB, blueboy?

It may be there's just enough difference between the two databases to explain some Playerbot errors.

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 ! =)

Link to comment
Share on other sites
Gitch Advanced Member

Gitch

Posted
Posted

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.

Link to comment
Share on other sites
Gitch Advanced Member

Gitch

Posted
Posted

@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

Link to comment
Share on other sites
blueboy Advanced Member

blueboy

Posted
Posted

Hi Gitch,

On the first post for this thread I have included a link to playerbot wiki. This resource provides scripts, documentation & information all about playerbot.

The gameobject collect feature created by BThallid works very well. Only quest items (and skinning objects, if bot has SKINNING) are collected automatically. All other items require manual training (i.e successfully collect an object once). You will also need to check that collect is configured to collect the particular object in 'playerbot.conf'. These provide the default settings that can be overridden in the game using

collect OBJECT Sets collect status, OBJECT = [ all | none | combat | loot | objects | profession* | quest ]

* profession refers to herb or mining collection. The 'skin' status override option is only available, if the bot has the skill

To initially locate example gameobjects,

/t botname or /p survey

To train collect,

/t botname or /p get [gameobject link]

If the bot fulfills the collection criteria (i.e can successfully collect - has skill) the gameobject will be added to the collection list, until you log out. When you log in again, all required quest objects will be added to this list, but you will again need to train collect for other items

Hope this helps

Link to comment
Share on other sites
Gitch Advanced Member

Gitch

Posted
Posted

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'm running the current portal version now + new-ai.

I love the wiki link :o

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.

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)

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.

Link to comment
Share on other sites
blueboy Advanced Member

blueboy

Posted
Posted

******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"

Thanks for the info on this. I'll check it out this evening and get back to you.

EDIT@ I see what you mean. I have created a patch for you to test out. It works on my server.

In game,

/t botname or /p use [Gnarlpine Necklace]

and 'Tallonkai's Jewel' will be placed in the bots inventory, destroying the 'Gnarlpine necklace' as it should.

diff --git a/src/game/playerbot/PlayerbotAI.cpp b/src/game/playerbot/PlayerbotAI.cpp
index 3bf733c..b438b94 100644
--- a/src/game/playerbot/PlayerbotAI.cpp
+++ b/src/game/playerbot/PlayerbotAI.cpp
@@ -5734,6 +5734,16 @@ void PlayerbotAI::UseItem(Item *item, uint32 targetFlag, ObjectGuid targetGUID)
        return;
    }

+    if (item->GetProto()->Class == ITEM_CLASS_QUEST)
+    {
+        // 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;
+    }
+
    uint32 spellId = 0;
    for (uint8 i = 0; i < MAX_ITEM_PROTO_SPELLS; ++i)
    {

Cheers

Link to comment
Share on other sites
Gitch Advanced Member

Gitch

Posted
Posted

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*

Link to comment
Share on other sites
Unkle Nuke Advanced Member

Unkle Nuke

Posted
Posted

Playerbot has always been a community project, with code contributed by many people. All you need to do is look back through the history of this thread, and the older threads going back to Playerbot's origin, to witness this. Playerbot has been around for quite some time, at least as old as Burning Crusade. Please do post any work... no matter how small. :)

blueboy was one of those contributors, but he had the heart and will to step forward to guide the project when the previous caretaker retired to pursue other things. Under his skilled hand, Playerbot has advanced in great leaps which encouraged other amazingly talented people to come forth and add some dazzling features.

If you should decide to become a community developer for Playerbot, I shall cheer you on as heartily as I have with blueboy and the rest! :D

Link to comment
Share on other sites
blueboy Advanced Member

blueboy

Posted
Posted

Hi Gitch,

Glad it works O.K. Keep an eye on the 'use' command just in case the fix causes it to misfire for other types of items. If you wish to get more involved, I can add you to our 'Collaborators List' for the repos. Then, once your settled with 'git' (if you have any particular queries, just ask. We all needed help with git initially) you can push your own code.

@UnkleNuke Thanks, I couldn't have put it better ;) Playerbot wouldn't be what it is today without the excellent contributions from numerous dedicated individuals, who love the mod as much as I do.

Cheers

Link to comment
Share on other sites
blueboy Advanced Member

blueboy

Posted
Posted

As I suspected.

You fix one thing and break another..

My fix was flawed, but it was 4 in the morning when I wrote it {)

The fix works fine for the quest 'Ferocitas the Dream Eater' to recover 'Tallonkai's Jewel', but it breaks the ability to fill phials for the 'Crown of the Earth' quests. Easily solved.

Gitch pointed out that

Bot whispers: Can't find spell entry for spell 0 on item 8049"

Quest items like those for the quest 'Crown of the Earth' do possess spell entries, so we need the reposition the patch in the function UseItem() to check for possible spellId.

Revised Patch

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()->Class == ITEM_CLASS_QUEST && 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;

EDIT@ I will be pushing this fix to the repos shortly. Hold fast, I found a different instance where this doesn't work. You maybe aware that the "Lunar Festival" quest is active at present. Each questgiver give a "Coin of Ancestry" and an email. The email includes a "Lucky Red Envelope". It's this that causes the problem. To resolve this I examined the data (item_template in World database) for each item causing issues.

Item Item (entry) Item (Flags) Item (spellid_1) bitwise (&)

Gnarlpine necklace 8049 2052 (0x00000804) 0 ITEM_FLAG_LOOTABLE

Tourmaline Phial 5621 64 (0x00000040) 6610 False

Lucky Red Envelope 21746 4 (0x00000004) 0 ITEM_FLAG_LOOTABLE

I have changed the patch condition from

+ if (item->GetProto()->Class == ITEM_CLASS_QUEST && spellId == 0)

to

+ if ((item->GetProto()->Flags & ITEM_FLAG_LOOTABLE) && spellId == 0)

so, revision 2 of the patch is

Revision 2

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;

Hope this helps

Link to comment
Share on other sites
kennumen Advanced Member

kennumen

Posted
Posted

Just to be a PITA and rub it in, I told you this 2.5 months ago :P

  • [feature] 'open' command: Was questing in Teldrassil, had a quest where I needed "Tallonkai's Jewel", gotten from killing a mob, looting "Gnarlpine Necklace", and then opening that necklace to loot the jewel. Couldn't find 'open' command. Pretty sure I tried 'use' and it didn't work.

Anyway, glad the list is getting shorter, and great job as always :) And props to Gitch for his much clearer description of the issue.

Link to comment
Share on other sites
Gitch Advanced Member

Gitch

Posted
Posted

if ((item->GetProto()->Flags & ITEM_FLAG_LOOTABLE) && spellId == 0)

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:

if ((item->GetProto()->Flags & ITEM_FLAG_LOOTABLE) && spellId == 0)

To this:

if (item->GetProto()->Flags & ITEM_FLAG_LOOTABLE && spellId == 0)

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.

Link to comment
Share on other sites
blueboy Advanced Member

blueboy

Posted
Posted

Hi All,

@kennumen Sorry for not fixing it before, but we got there eventually ;) I'll have to read the todo list again and see what else needs attention.

@Gitch

THE CASE OF MYSTERIOUS PARENTHESIS

I'm amazed it works without the parenthesis. Chances are your compiler will send out warnings as the code builds. It normally likes separate conditional expressions to be contained in parenthesis to satisfy logic.

I had similar problems with quest:Druid of the Claw. The server output was suggesting an inventory failure for me. I got the bots to drop some useless items and targeted the druids corpse. I Then,

/p use [Voodoo Charm]

and it then worked.

@hurrensohn Glad the MaNGOS One code is behaving itself ;)

Cheers

Link to comment
Share on other sites
Guest
This topic is now closed to further replies.
 Share
Go to topic listing

Contact Us

To contact us click here
You can also email us at [email protected]

Privacy Policy | Terms & Conditions

Repositories

The Link to the master list
of MaNGOS repositories:
Copyright © getMaNGOS. All rights Reserved.

This website is in no way associated with or endorsed by Blizzard Entertainment®
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use