[ASCENT]It fails

[yrref]

Now my server works, but every trader says: make this inn ur home..
I use:
Ascent Rev2303
NCDB_Rev661
2.2.3
How can i fix this
?
Thxx

 

[gmaze]

UPDATE creature_proto SET npcflags = 135296 WHERE npcflags = 16644;
UPDATE creature_proto SET npcflags = 4243 WHERE npcflags = 16407;
UPDATE creature_proto SET npcflags= 4241 WHERE npcflags = 16405;
UPDATE creature_proto SET npcflags = 4112 WHERE npcflags = 16400;
UPDATE creature_proto SET npcflags = 4227 WHERE npcflags = 16391;
UPDATE creature_proto SET npcflags = 4226 WHERE npcflags = 16390;
UPDATE creature_proto SET npcflags = 4225 WHERE npcflags = 16389;
UPDATE creature_proto SET npcflags = 4224 WHERE npcflags = 16388;
UPDATE creature_proto SET npcflags = 4099 WHERE npcflags = 16387;
UPDATE creature_proto SET npcflags = 4096 WHERE npcflags = 16384;
UPDATE creature_proto SET npcflags = 4194307 WHERE npcflags = 8195;
UPDATE creature_proto SET npcflags = 4194305 WHERE npcflags = 8193;
UPDATE creature_proto SET npcflags = 4194304 WHERE npcflags = 8192;
UPDATE creature_proto SET npcflags = 2097152 WHERE npcflags = 4096;
UPDATE creature_proto SET npcflags = 1048577 WHERE npcflags = 2049;
-- UPDATE creature_proto SET npcflags = 262145 WHERE npcflags = 1537;
-- UPDATE creature_proto SET npcflags = 262144 WHERE npcflags = 1536;
UPDATE creature_proto SET npcflags = 524417 WHERE npcflags = 1029;
UPDATE creature_proto SET npcflags = 524416 WHERE npcflags = 1028;
UPDATE creature_proto SET npcflags = 524288 WHERE npcflags = 1024;
UPDATE creature_proto SET npcflags = 131075 WHERE npcflags = 259;
UPDATE creature_proto SET npcflags = 131073 WHERE npcflags = 257;
UPDATE creature_proto SET npcflags = 131072 WHERE npcflags = 256;
UPDATE creature_proto SET npcflags = 65667 WHERE npcflags = 135;
UPDATE creature_proto SET npcflags = 65665 WHERE npcflags = 133;
UPDATE creature_proto SET npcflags = 65664 WHERE npcflags = 132;
UPDATE creature_proto SET npcflags = 65539 WHERE npcflags = 131;
UPDATE creature_proto SET npcflags = 65537 WHERE npcflags = 129;
-- UPDATE creature_proto SET npcflags = ??? WHERE npcflags = 64;
UPDATE creature_proto SET npcflags = 32769 WHERE npcflags = 33;
UPDATE creature_proto SET npcflags = 32768 WHERE npcflags = 32;
UPDATE creature_proto SET npcflags = 147 WHERE npcflags = 23;
UPDATE creature_proto SET npcflags = 145 WHERE npcflags = 21;
UPDATE creature_proto SET npcflags = 8195 WHERE npcflags = 11;
UPDATE creature_proto SET npcflags = 8194 WHERE npcflags = 10;
UPDATE creature_proto SET npcflags = 8193 WHERE npcflags = 9;
UPDATE creature_proto SET npcflags = 8192 WHERE npcflags = 8;
UPDATE creature_proto SET npcflags = 130 WHERE npcflags = 6;
UPDATE creature_proto SET npcflags = 129 WHERE npcflags = 5;
UPDATE creature_proto SET npcflags = 128 WHERE npcflags = 4;

 

[yrref]

What?? explain xD

 

[gmaze]

this sql will update vendors so they work.....just execute it on your database

 

[yrref]

I tried it
Copied all the text into a file, saved it as SQL.
Booted up my server, teleported to ANvilmar. And still ''make this inn yarr home''?
Help

 

[gmaze]

Hmm, no sense....I did this, tele'd to anvilmar, and works for me
also used these 2 codes to fix trainers and weps master, but the above works for me....don't believe this is a 100% fix, more like a 85%

UPDATE `creature_proto` SET `npcflags`='16' WHERE `entry`='11867';
UPDATE `creature_spawns` SET `flags`='16' WHERE `entry`='11867';
#Set UNIT_NPC_FLAG_TRAINER flag for ALL weapon masters
UPDATE `creature_proto`
SET `npcflags` = 16
WHERE `entry` in (select `entry` from `creature_names` where `subname` like '%weapon master%');

 

[yrref]

Right. Ok thats odd..
What revision/dbc/world do u use?
--Also if u have msn, add me:
still doesnt work
[email protected]

 

[gmaze]

I'm on ascent rev 2379, i think.
NCDB rev 66 something, lol, don't remember.
Running wow 2.3

 

[yrref]

Ok
Well updated to rev 2401
Ima try that one now