vendors help!

[quickmasta]

Hi guys!

I use 2.3 stable Rev with 2.2.3 character database and 2.2.3 world database.
I have a problem with vendors, they're all Innkeepers.
What should I do?

Ill post a screenshot later..

[MentaL]

[Paco44]

Vendors are have a special flag ID. I'm at school so I cannot tell you exactly what number, but I think 4224.

[quickmasta]

thanks Ill Try.. :)

[gmaze]

here is a sql i used....fixed most of my vendors

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;

[quickmasta]

lol silly question but what should I do with that..

[gmaze]

using w/e tool u use for sql queries, execute that query on your database....it will change the flags of vendors to match 2.3......for your info, 2.3 cores and 2.2 rest of stuff has MAJOR issues, you should go entirely one or the other, IMO

[quickmasta]

whats that query name

[gmaze]

well, i use sqlyog or phpmyadmin for database editing/updating.

so open sqlyog, find your db and select it, then find execute batch file and click it, browse to the sql file to use, select it, then click execute. It will import and edit all the necessary stuff

[quickmasta]

Lol why you hadnt told me that i had to update creatures_proto.sql only ? :D

[jab416171]

LOL
here's the ID's

This should be the new Flags

2.3.0 stuff
1 = guide
2 = questgiver
16 = trainer (class)
128 = vendor
4096 = repairer
8192 = taxi
16384 = trainer (profession)32768 = spirit healer
65536 = binder
131072 = banker
262144 = charter vendor
524288 = tabard vendor
1048576 = battle master
2097152 = auction house
4194304 = stabler
8388608 = guild bank

The old flags:

npcflags

npcflags=00 / 0 Nothing
npcflags=01 / 1 Gossip
npcflags=02 / 2 Quest
npcflags=03 / 3 Gossip + Quest
npcflags=04 / 4 Vendor
npcflags=05 / 5 Gossip + Vendor
npcflags=06 / 6 Quest + Vendor
npcflags=07 / 7 Gossip + Quest + Vendor
npcflags=08 / 8 Taxi
npcflags=09 / 9 Gossip + Taxi
npcflags=0A / 10 Quest + Taxi
npcflags=0B / 11 Gossip + Quest + Taxi
npcflags=0C / 12 Vendor + Taxi
npcflags=0D / 13 Gossip + Vendor + Taxi
npcflags=0E / 14 Quest + Vendor + Taxi
npcflags=0F / 15 Gossip + Quest + Vendor + Taxi
npcflags=010 / 16 Trainer
npcflags=011 / 17 Gossip + Trainer
npcflags=012 / 18 Quest + Trainer
npcflags=013 / 19 Gossip + Quest + Trainer
npcflags=014 / 20 Vendor + Trainer
npcflags=015 / 21 Gossip + Vendor + Trainer
npcflags=016 / 22 Quest + Vendor + Trainer
npcflags=017 / 23 Gossip + Quest + Vendor + Trainer
npcflags=018 / 24 Taxi + Trainer
npcflags=019 / 25 Gossip + Taxi + Trainer
npcflags=01A / 26 Quest + Taxi + Trainer
npcflags=01B / 27 Gossip + Quest + Taxi + Trainer
npcflags=01C / 28 Vendor + Taxi + Trainer
npcflags=01D / 29 Gossip + Vendor + Taxi + Trainer
npcflags=01E / 30 Quest + Vendor + Taxi + Trainer
npcflags=01F / 31 Gossip + Quest + Vendor + Taxi + Trainer
npcflags=020 / 32 Healer
npcflags=021 / 33 Gossip + Healer

++ add

npcflags=080 / 128 Innkeeper
npcflags=0100 / 256 Banker / BagSlotVendor
npcflags=0200 / 512 GuildMaster (use 0600)
npcflags=0400 / 1024 TabardDesigner
npcflags=0600 / 1536 Petition
npcflags=0800 / 2048 BattleMaster
npcflags=01000 / 4096 Auctioneer
npcflags=02000 / 8192 StableMaster (use 05)
npcflags=04000 / 16384 Repairer

[rong626]

thx for the list