[Release] 2.4.2 Vendors + Season 4 (WhyDB Compatible)

[God-Of-War]

Hi everyone!

First things first.. i didn't make these from scratch i just edited them so that it can be used on WhyDB!

Original = http://www.mmowned.com/forums/emulat...dor-items.html)
And probably some other DB too

Ok i will make a little mini guide for you

1: Download:

• Filebeam - Free Fast File Hosting
• Save it in a folder, you can call it what ever you want jsut remember

2: Extract:

• Right click the file you just downloaded
• Chose extract here
  

3: Execute in DB:

• You can do this two ways:
• Use the Tool.bat
  
• Do it manualy!

3a: Tool.bat:

• Right click the tool.bat
  
• Select edit (or open it with notepad)
• Edit so it fits your mysql info like this:

@ECHO off
color 3
REM ############################################################################
REM #
REM # [Configuration]
REM #
REM # user - MYSQL username
REM # pass - MYSQL password
REM # wdb - Name of World database
REM #
REM ############################################################################
set user=Your MySQL Username
set pass=Your MySQL Password
set wdb=Your World Database
REM ############################################################################
REM #
REM # Server-side configuration.
REM # (Do not need to edit)
REM #
REM ############################################################################
set port=3306
set server=localhost
set pubpath=.
set devpath=.vendor
set mysqlpath=.MYSQL
REM ############################################################################
REM #
REM # IN ORDER FOR THIS TOOL.BAT TO WORK, DO NOT EDIT PAST THIS POINT.
REM #
REM ############################################################################
if %user% == USERNAME GOTO failure
if %pass% == PASSWORD GOTO failure
:menu
cls...

• Change all in red to your info.
• Run the tool and follow the onscreen info

3b: Manuel Execute:

• Go inside navicat (Or whatever program you use.)
• Right click your world database and select execute batch file
• Browse to the vendor.sql file you extracted before and select start

4: Spawn:

• Go inside wow and spawn your vendors
• Use the ".npc spawn" command and use the following ids
  

Spawn IDs:

50000 - Dungeon 1
50001 - Dungeon 2
50002 - Dungeon 3
50003 - Tier 1
50004 - Tier 2
50005 - Tier 3
50006 - Tier 4
50007 - Tier 5
50008 - Tier 6
50020 - Necklace
50021 - Rings
50022 - Trinket
50024 - Shirt
50025 - Tabard
50026 - Miscellaneous
50027 - Off-hand
50030 - Arena Season 1
50031 - Arena Season 1
50032 - Arena Season 1
50033 - Arena Season 2
50034 - Arena Season 2
50035 - Arena Season 2
50065 - Arena Season 3
50066 - Arena Season 4
50042 - Mount 1 Regular
50043 - Mount 2 Flying
50044 - Projectiles
50045 - Bags
50047 - Enchantment
50048 - Keys
50049 - Currency
50050 - Cloak
50051 - Weapon
50052 - Shield
50053 - Libram/Idols/Totems
50054 - Totem
50055 - Rogue Poisons
50056 - Gems
50057 - Food & Drink
50058 - Scroll
50059 - Flasks
50060 - Elixirs
50061 - Potion
50062 - Feet
50063 - Wrist
50064 - Belt


Credits:
The vendors and everything: Hephaestus: MMOwned - World of Warcraft Exploits, Hacks, Bots and Guides - View Profile: Hephaestus
Editing (WhyDB Compatible): Me

Please +Rep Hephaestus for the great vendors!

[soul02]

+rep for u.. but i wont be using this cos i have like 98% of 2.4.2 items on our server

[God-Of-War]

ok thanks for the rep.. i'm running whydb and that includes all 2.4.2 items and i use these vendors and it works perfect

[God-Of-War]

lol.. 48 download and only one person bothered to leave a comment.. Thanks guys

[Entr0py]

rofl, im prolly gonna use it, thx for taking the trouble t make it
i was going to but...u best me 2 it
bastard
lol
+Repx2

[ElronSurion]

Scuse me, I'm importing the file into my wdb on Heidi and it says
SQL Error: Column count doesn't match value count at row 1

Being a noob at this stuff I don't know what ta do. Think you can help me?

[Fuynuns93]

Weird Season 3 says Recipe <Jeweler L-Z> and Season 4 says Reagent <Leather A-L>
but they sell the right stuff.

EDIT: Same thing with Totems, Libram/Idols/Totems, Cloaks, Weapons, and Sheilds

[ElronSurion]

Can anyone help me please? >.<

[God-Of-War]

Sure i can help..
Elron: what DB do you use? this sould work with the newest WhyDB..
Fuynuns: did you have any other vendors before this? and if i understand you problem right it displays the wrong name?

[God-Of-War]

i know how to fix your problem now.. go into your WoW folder and Delete the folder called cache and then it will get the original names

[jay08]

thanks for the release

[God-Of-War]

no problem just trying to help

[ElronSurion]

Sure i can help..
Elron: what DB do you use? this sould work with the newest WhyDB..
Fuynuns: did you have any other vendors before this? and if i understand you problem right it displays the wrong name?

Ascent

Sorry for not replying in a while been kinda busy

[God-Of-War]

database not core

[Laokon]

Thanks, everything seems to work.

I made my own little mall in Hyjal.

The only 2 Vendors that arent working is the s4 Vendor and the offhand Vendor.

The offhand Vendor has no loot template and the s4 vendor is crashing wow all the time if i speak to him

And there are no s3 weapons?