Vendor Fix!!!! verry easy!

[sadgonewild]

Go into sqljog\\\\Ascent db

then exicute


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;


problem solved.

still looking for a guild master fix.

but every thing else seems to work!

[sadgonewild]

srry for double post

UPDATE creature_proto SET npcflags = 1048576 WHERE npcflags = 2048;


that will fix your guild master problem

[Ebon]

Nice job dude, it worked, +Rep!

Edit - Not sure if I gave you Repuation or not... it say's I can't give it to the same post twice... hmm... Sorry bud! !

[kristian92]

what does this update do?

[jkhmonkey]

It lets you buy stuff from vendors using 2.3 repacks

[Herleybob]

I have updated my repack to fix this stuff, just run the Program in the Databases folder and type "N" and it will fix the NPC's

[sadgonewild]

I have updated my repack to fix this stuff, just run the Program in the Databases folder and type "N" and it will fix the NPC's

good work mate,

maybe that will stop me having to post this same thread every god dam page in ur guide

[matistic]

Well I've run the code and also tried the N option and while many vendors now work, not all do. I can't buy a horse mount, I can't get flight masters to let me go anywhere and I can't finish some quests because of the problems. Any ideas?

[Priscila]

Hello, I have MySQL instead of SQLyod, can you please tell me where I might excute these commands? thanks for thos rocking fix!

[Priscila]

ANd also... once it's fixed...
I am not really sure about how .npc vendoradditem works

How do I designate the price for the item or maybe the requiement of pvp-points obained in order to get the item

and under which catatory should I be modifying these things?

Is it under "items" in the database?



thanks!

[sadgonewild]

Hello, I have MySQL instead of SQLyod, can you please tell me where I might excute these commands? thanks for thos rocking fix!

open up SQLJog and log into it ect so u can see your databases. once you can see them you should be able to see the white box on the right hand side. copy and paste into that box and press control A then press F5 and its done.

[Durand44]

thanks for that good jobe. i really needed

[Priscila]

My T6 vendor still doesnt work, for the warriors T6 (Onslaughter's) works, but the rest of the gears for other classes don't.

Thanks!

[sadgonewild]

My T6 vendor still doesnt work, for the warriors T6 (Onslaughter's) works, but the rest of the gears for other classes don't.

Thanks!

how can you be able to buy one set from the vendor and not all?

did u check u had tokens for all of them???

[Priscila]

Yes, I did check them all. It seems that all are working, but priest's set


I have the token, but there is no image of token showing on the gears, meaning that I can't trade them ~