Roifok's Mall Vendor for TrinityCore 4.3.4

**Wise** · 26-10-13, 01:34 PM

So what is released today ?

Code:

_ 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
_ Legendary Weapons : 999909
_ Gems : 999912
_ Enchants : 999913

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.

Download Here !

Credits :
Roifik

› See More: Roifok's Mall Vendor for TrinityCore 4.3.4

**chronic7** · 28-01-14, 07:57 AM

This is perfect for what I am doing with my server. Much appreciated +like!

**themagicfreak** · 01-06-14, 11:17 AM

i have a problem with this in creature_template:

Query: INSERT INTO `creature_template` VALUES (999904, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'S11 PvP Weapons', 'Vendor', NULL, 0, 1, 1, 0, 0,...

Error Code: 1136
Column count doesn't match value count at row 1

Execution Time : 0 sec
Transfer Time : 0 sec
Total Time : 0.001 sec

**Suraf** · 09-06-14, 08:43 PM

Originally Posted by themagicfreak

i have a problem with this in creature_template:

Query: INSERT INTO `creature_template` VALUES (999904, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'S11 PvP Weapons', 'Vendor', NULL, 0, 1, 1, 0, 0,...

Error Code: 1136
Column count doesn't match value count at row 1

Execution Time : 0 sec
Transfer Time : 0 sec
Total Time : 0.001 sec

The creature_template was change alot, like the merging of 'faction_A' and 'faction_h'. You'll have to just manually add it in.

**Venetica** · 23-06-14, 04:06 AM

I have the TDB Update 355.53

When I try batch the file I get the error!

npc_vendor
[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `npc_vendor` VALUES (999913, 9, 71720, 0, 0, 0, 1);

creature_template.sql
[Err] INSERT INTO `creature_template` VALUES (999904, 0, 0, 0, 0, 0, 21277, 0, 0, 0, 'S11 PvP Weapons', 'Vendor', NULL, 0, 1, 1, 0, 0, 35, 35, 129, 1, 1.14286, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', 1);
[Msg] Finished - Unsuccessfully

The TDB 4.3.4 5 Update is successful.
But when i start the Server with TDB4.3.4 5 Update world become Error:
DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at TrinityCore Home - TrinityCore - KPsN Collaboration Platform
Cannot connect to world database localhost;3306;root;ascent;world

What am I doing wrong?

Sorry for my bad English, i from Germany!