Roifok's Mall Vendor

[roifok]

Hey Emudevs community !

I'm a new user on your forums but i already found a lot of usefull stuff, so here is my first little contribution for you : some vendors for TrinityCore 4.3.4 latest rev.

So what is released today ?

_ S9 PvP Gear : 999910
_ S9 PvP Weapons : 999911
_ S10 PvP Gear : 999918
_ S10 PvP Weapons : 999919
_ S11 PvP Gear : 999905
_ S11 PvP Weapons : 999904
_ T11 Pve Gear : 999915
_ T11 Pve Weapons : 999917
_ T11 Pve Offsets : 999914
_ T12 Normal Pve Gear : 999922
_ T12 Heroic Pve Gear : 999906
_ T12 Pve Offset : 999908
_ T12.5 Pve Offset : 999903
_ T13 Normal Pve Gear : 999900
_ T13 Heroic Pve Gear : 999902
_ T13 Pve Offset : 999926
_ Pve Weapons 359 - 365 : 999917
_ Pve Weapons 372 - 378 : 999907
_ Pve Weapons 384 - 391 : 999924
_ Pve Weapons 397 - 403 : 999923
_ Pve Weapons 406 - 416 : 999901
_ Legendary Weapons : 999909
_ Mounts : 999927
_ Rare Mounts : 999928
_ Prestige Mounts : 999929
_ Gems : 999912
_ Enchants : 999913
_ Miscellaneous (Poisons, cookies ...) : 999916

All theses NPC are ordered by equipment slot to be clearer in-game. The goal was to have less NPC as possible with all the stuff.

Example : The S10 PvP Gear NPC contains all the set for all the class + all the offset + all the trinkets. Your players won't have to talk to a tons of NPC and it will be faster for them to find what they want.

For the missing stuffs, they'll be released as soon as possible since it takes me a long time ordering all the item by slot and category.


How to install ?

Very simple :

_ Download the .rar file.
_ Extract the two files in a folder.
_ Open your favorite SQL tool and execute in your world DB "creature_template.sql" and "npc_vendor.sql".
_ Be carefull, execute creature_template.sql in first or you'll get an error.
_ Restart your world server and start spawning npc.
_ Enjoy.

If you got any error message when executing queries, make sure you have all the latest update from trinitycore repo.

If you got any message like

SQL Error (1136): Column count doesn't match value count at row 1

Its because your world db isn't up to date.

Solution : go to your creature_template table in world db. Select any npc and copy paste it. Modify the npc_flag to 129 to make it a vendor and customize it to your feels. You're done. Repeat this for every npc.

Feel free to post any other issue or any suggestion and i'll try to help you.

Some screens :

Download Here !

Best Regards

 

[Tommy]

Awesome! Thanks for sharing this with us!

 

[roifok]

Thank you master !

Everyone feel free to ask me for more npc if you need it and i'll make it as soon as possible !

 

[Xcynic]

Thanks for this!

 

[tiikerikissa]

hi i need moor vendors for 4.3.4 trinity core

i need moor vendor i need raid sets 1-10 and heirloom vendors and levelin gears for levels 20-70 can u create this for me ? thanks

 

[roifok]

i need moor vendor i need raid sets 1-10 and heirloom vendors and levelin gears for levels 20-70 can u create this for me ? thanks

Since i'm making a transmog npc, i'm going to add every raid set and every pvp set (t1 - t10 & s1 - s8).

Leveling gear for level 20 - 70 will be harder for me but i'll try to do something..

 

[ramazan198]

please new beginner this game how spawn npc

tnx

ok ok solved

 

[Ladrek]

do i need to make my own npc? b.c both of them didnt work at all

 

[Rochet2]

do i need to make my own npc? b.c both of them didnt work at all

There has been multiple changes to the creature_template and other structures.
The thread is one year old.

So yes, you should probably try make your own NPC at least. Or try tweak the SQLs to work. Usually removing the erroring columns and their values is enough.

 

[Ladrek]

hmmmm