Problem with some vendor

[iceman-twitch]

I have a problem with the valor quatermaster because he selling nothing and with the Conqeust quatermasters the elite and the normal conquest queatermaster they are only selling some item but not everything.

[Bootz]

Please give more info: there is numerous npc's that can possibility fit your report... save us the difficulties and the waste our time searching for whom ingame your typing about, ;) :8ball:

[iceman-twitch]

Ok I will paste the ID of the npcs who has some missing items from the npc_vendor tabel

[iceman-twitch]

But first I have to start the Worldserver.exe but I cant :(

[iceman-twitch]

I am always getting errro

[SkyFire]

PEBKAC.

[iceman-twitch]

this npc at stormwind 44245 selling nothing because he has to sell the t11 parts and the other items for valor :D and than the heirloom seller is missing from Stormwind http://www.wowhead.com/npc=52027#sells and the other is missing to who is selling heirloom items but it is pvp items from Stormwind http://www.wowhead.com/npc=52030 .I will check later Orgrimmar

[iceman-twitch]

It isnt to find the 406 db files of the npc_vendor because I searched for some repack and nowhered made the item to the npc_vendor and I dont know the extend cost of these items and some npxc is missing

[iceman-twitch]

I found the problem for a valor quatermaster https://github.com/Arkania/ArkCORE/blob/master/sql/updates/world/already_applied/12_04_25_npc_vendor_01.sql this is for the horde valor quatermaster but we only have to change it if we want to add it to the alliance valor quatermaster :D

[iceman-twitch]

Here is the allaince valor quatermaster npc_vendor table https://github.com/Demigodess/ArkaniaDatabase/blob/master/NPCs/00_NPC_Valor_Point_Alliance.sql

[ImageDev]

Stormwind

(im not a horde player, these areas unconfirmed by me)

we're missing a npc here, for heirlooms valorous tables missing (justice is fine)

and these guys are right Conquest tables are in, but glorious conquest tables missing

and one not mentioned above, guild vendor tables are missing

[iceman-twitch]

I know

[iceman-twitch]

I will search for the heirloom vendor creature_template and for the guild and the other vendor table :-)

[Bootz]

Query results: 535 row(s) affected

Execution Time : 00:00:00:062 Transfer Time : 00:00:00:000

Total Time : 00:00:00:062

468 row(s) affected

Execution Time : 00:00:00:031 Transfer Time : 00:00:00:000

Total Time : 00:00:00:031

seems something is lighter in Saifai's imports to what we had... 535 deleted, 468 imported ?? just saying a diff might need to be made to see what is lost.

[iceman-twitch]

wait test the first with the horde and than with the allaince change the entry :D

[Bootz]

i don't do the horde, but for alliance this was good. plus because of factions that way cant be done... just changing entries, you'll be given horde vendors alliance gear or versa

[iceman-twitch]

HERE https://github.com/Demigodess/ArkaniaDatabase/blob/master/NPCs/00_NPC_Valor_Point_Alliance.sql https://github.com/Demigodess/ArkaniaDatabase/blob/master/NPCs/01_NPC_Valor_Point_Horde.sql

[Bootz]

what i find odd.. is these effect more then one npc, example: for alliance, fixes the guy in command center and in champion's hall... with using one entry ::confusing how that works, but it did::

[iceman-twitch]

I cpoy these things from a arkania database because the arkania and the skyfire is compatible XD

[Bootz]

but arkania has been known to run custom items, from other patch sets such as 4.2(+) which do not belong in our 406a. just need to make sure these don't exist, and that the values are correct (extend-cost)

[iceman-twitch]

Yee I dont know the extend cost I only can copy paste :-)

[Bootz]

as i said i checked all these. AlterEgo has a big push coming he says so wait...

[iceman-twitch]

ok