HELP lol npc's doing strange things

[jackthripper]

just compiled and started a new server. i start up the realm and when i enter a new town or area ... literaly half of the npc's start walking south west until they end up walking into a tree or vanish totally. they have no way points. i have never seen this before. as funny as it is, but not good none the less. how does one stop this?


plz help me out. i will +Rep the one that can solve this dilemma.

[jackthripper]

anyone? lol

[Algorithm]

which core?

[jackthripper]

ArcEmu just compiled yesterday and same with rival db all fresh svn checkouts

[Algorithm]

make sure you ran these sql updates

ALTER TABLE `creature_proto` ADD `can_ranged` INT(11) unsigned NOT NULL DEFAULT '0' AFTER `maxdamage`;

alter table `creature_proto` drop column `equipinfo1`, drop column `equipslot1`, drop column `equipinfo2`, drop column `equipslot2`, drop column `equipinfo3`, drop column `equipslot3`;
alter table `creature_proto` change `equipmodel1` `slot1item` int(30) UNSIGNED DEFAULT '0' NOT NULL, change `equipmodel2` `slot2item` int(30) UNSIGNED DEFAULT '0' NOT NULL, change `equipmodel3` `slot3item` int(30) UNSIGNED DEFAULT '0' NOT NULL;

ALTER TABLE `creature_spawns` ADD COLUMN `mountdisplayid` int UNSIGNED DEFAULT '0' NOT NULL after `standstate`, ADD COLUMN `slot1item` int UNSIGNED DEFAULT '0' NOT NULL after `mountdisplayid`, ADD COLUMN `slot2item` int UNSIGNED DEFAULT '0' NOT NULL after `slot1item`, ADD COLUMN `slot3item` int UNSIGNED DEFAULT '0' NOT NULL after `slot2item`;
UPDATE `creature_spawns` SET `mountdisplayid` = (SELECT `mountdisplayid` FROM `creature_proto` WHERE `creature_proto`.`entry` = `creature_spawns`.`entry`);
UPDATE `creature_spawns` SET `slot1item` = (SELECT `slot1item` FROM `creature_proto` WHERE `creature_proto`.`entry` = `creature_spawns`.`entry`);
UPDATE `creature_spawns` SET `slot2item` = (SELECT `slot2item` FROM `creature_proto` WHERE `creature_proto`.`entry` = `creature_spawns`.`entry`);
UPDATE `creature_spawns` SET `slot3item` = (SELECT `slot3item` FROM `creature_proto` WHERE `creature_proto`.`entry` = `creature_spawns`.`entry`);
ALTER TABLE `creature_proto` DROP COLUMN `mountdisplayid`,DROP COLUMN `slot1item`,DROP COLUMN `slot2item`,DROP COLUMN `slot3item`;

[jackthripper]

ill give those a try right now

[jackthripper]

1. dulicate colum name 'can ranged'
2. cant drop 'equipinfo 1' check to see if colum/key exists
3. duplicate colum name 'mountdisplayid'

[tylert40]

1. dulicate colum name 'can ranged'
2. cant drop 'equipinfo 1' check to see if colum/key exists
3. duplicate colum name 'mountdisplayid'

looks like u ran them then -.-

[Algorithm]

1. dulicate colum name 'can ranged'
2. cant drop 'equipinfo 1' check to see if colum/key exists
3. duplicate colum name 'mountdisplayid'

Ok it looks like the updates are already executed,, okey,. can you post your Waypoints, creature_proto and creature_spawns structure? Dont post the whole table dump just the structure. And i will see if you missing something there.,

[jackthripper]

if you mean the table structures for those tables in the world database... i dont seem to have a waypoints table. and ive noticed that there is not one npc moving in the whole server exept of course the ones that are walking to the west and into oblivion and i have also noticed none of the npcs have any waypoints at all

[Algorithm]

well if you do not have creature_waypoints that can be the problem lol

[jackthripper]

oops wait, im on crack... yes i have it. ive been up since 7am working on tuts and my server ill see if i can post the structure

[Herleybob]

I had this same problem... But my NPCS would swim away with blue glow around them... i then switched to Aspire...

[jackthripper]

I just noticed i only have 35-40 id's/entry's in those 3 tables (waypoints, proto and spawns... isnt there supposed to be a lot more than that??

[Algorithm]

I just noticed i only have 35-40 id's/entry's in those 3 tables (waypoints, proto and spawns... isnt there supposed to be a lot more than that??

way more..