[Release] Wrath of the Lich King Vendors

[PaikProductions]

Hello guys :D,

I made some vendors, soon coming more!
These are very usefull for a mall.
If you want some screenshots just ask me and i gonna work on it!
The tier 7 is the REAL blizzard tier!
All classes are added at vendors.
The download file includes Readme!!!

Vendors at the moment:
900005 - Tier 7
900006 - Tier 7
900007 - Weapons 200+ [Frostmourne include]
900008 - Trinkets
900009 - Rings
900010 - Necklace
900011 - Shield
900012 - Tabard
900013 - Season 5
900014 - Relics
900015 - Cloak
900016 - Container
900017 - Glyph I
900018 - Glyph II
900019 - Wrist
900020 - Book A-Z
900021 - Leather A-Z
900022 - Jewelcrafting A-Z
900023 - Engineering/Enchanting A-Z
900024 - Alchemy/Blacksmithing/Tailoring
900025 - Waist
900026 - Feet
900027 - Heirloom
900028 - Ground Mounts
900029 - Flying Mounts
900030 - Item Enhancement (Permanent)
900031 - Item Enhancement (Temporary)
900032 - Reagent [ Enchanting ]
900033 - Reagent [ Leatherworking ]
900034 - Reagent [ Blacksmithing ]
900035 - Reagent [ Inscription ]
900036 - Reagent [ Engineering ]
900037 - Reagent [ Alchemy ]
900038 - Reagent [ Tailoring ]
900039 - General Goods
900040 - Shirt
900041 - Quiver, AmmoPouch, Projectile
900042 - Offhand
900043 - Currency
900044 - Gemstone I
900045 - Gemstone II
900046 - Gemstone III
900047 - Armor Tokens
900048 - Keys

Filebeam:
Download Vendors (http://filebeam.com/19f82c7705d8ff78681a38bfcc42969b) <-- Updated: Keys - ArcEmu

Soon:


Finished:

Recipe A-Z (100%)
Reagent A-Z (100%)
Item Enhancements (100%)
Season 5 (100%)
Weapon 200+ (100%)
Trinket (100%)
Tier 7 (100%)
Rings (100%)
Shield (100%)
Necklace (100%)
Tabard (100%)
General Goods (100%)
Relics (100%)
Keys (100%)
Cloak (100%)
Currency (100%)
Container (100%)
Wrist (100%)
Feet (100%)
Gemstone I (100%)
Gemstone II (100%)
Gemstone III (100%) Waist (100%)
Heirloom (100%)
Glyph (100%)
Armor Tokens (100%)
Offhand (100%)
Shirt (100%)
Mount (100%)
Flying Mount (100%)
Quiver, AmmoPouch, Projectile (100%)


If you don't got frostmourne then put this in your DB:
INSERT INTO items VALUES
('46609',2,8,-1,'Frostmourne','Frostmourne','Frostmourne','Frost mourne','46609',6,0,0,0,17,-1,-1,189,80,0,0,0,0,0,0,0,2,1,0,4,100,7,200,5,150,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,'0','0','597','896',0,'0' ,'0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0 ,4000,0,'0',7600,1,0,0,0,0,34696,2,0,0,0,0,35844,1 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'You will become the new lich king!',0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,1,0,2,0 ,1585,0,0,0,'0');


Gemstone II UPDATED! Reason, item got wrong vendor ID!
INSERT INTO vendors VALUES ('900045','41335',0,0,'0',0);

Instance Vendors:

Finished:

Instance Vendor - The Nexus (100%) ***NEW***


__________________________________________________

Download Instance Vendors (http://www.mediafire.com/?uttmmzo2qgy) <-- Updated: Instance Vendors - The Nexus

__________________________________________________

Instance Vendors At the Moment:
900049 - Instance Vendor - The Nexus

Twink Vendors:

Soon:

*Twink Level 29 Vendor
*Twink Level 39 Vendor
*Unique Costum Twink Vendor!!!

Finished:

*Twink Level 19 Vendor ***NEW***

Twink Vendors:
[Level 19]
700000 - Twink Weapons - Daggers
700001 - Twink Weapons - One Handed Axes
700002 - Twink Weapons - One Handed Swords
700003 - Twink Weapons - One Handed Maces
700004 - Twink Weapons - Staves
700005 - Twink Weapons - Two Handed Axes
700006 - Twink Weapons - Two Handed Swords
700007 - Twink Weapons - Two Handed Maces
700008 - Twink Weapons - Range
700009 - Twink Armor - Cloth Armor
700010 - Twink Armor - Leather Armor
700011 - Twink Armor - Mail Armor
700012 - Twink Armor - Cloacks
700013 - Twink Armor - Shields
700014 - Twink Jewels - Neck
700015 - Twink Jewels - Rings
700016 - Twink Weapons - Off Hands
700017 - Twink Bags
_______________________________

Download Twink Vendors Level 19 (http://www.mediafire.com/?tzdn0nmmtno) <-- Updated: Level 19 Twink Vendors

MaNGOS Vendors:

Credits:

-PaikProductions
-faddix for making them ArcEmu
-Ontox for the season 5

[Mutopendon]

Ah, i see why you changed thread: for title hea?
well thx for the other vendors!

[Clay]

900007 - Weapons 200+ [Frostmourne include]

Is this a Custom Made Frostmourne or the real one? :P

[PaikProductions]

real one!

[pantryboy]

I think there is something wrong with your code; It shouldn't have the Quotes - at least, thats what my Navicat and HeidiSQL said. If your using Tsoforever's repack (like me :3), then get rid of

"mountdisplayid", "equipmodel1", "equipinfo1", "equipslot1", "equipmodel2", "equipinfo2", "equipslot2", "equipmodel3", "equipinfo3", "equipslot3",

and their values. This is because it isn't in the database, and Navicat/HeidiSQL/SQLyog will flame you for it ^^

[comrad]

Awesome work mate! +rep(i just dont know how to do it :) )

[PaikProductions]

I think there is something wrong with your code; It shouldn't have the Quotes - at least, thats what my Navicat and HeidiSQL said. If your using Tsoforever's repack (like me :3), then get rid of



and their values. This is because it isn't in the database, and Navicat/HeidiSQL/SQLyog will flame you for it ^^

Use the ArcEmu one that one works.

Awesome work mate! +rep(i just dont know how to do it )


On the right at the permalink

[zeal_aiz]

This seem nice. Nice for making own fun server +rep pal. ;)

Btw, Is it for other emu for Mediafire and Rapidshare link? If it is, what emu?
and ArcEmu one is at Arcemu link right?

[PaikProductions]

Well use the ArcEmu one please, the other ones sucks :P i will delete them later. ArcEmu is newest core! Latest revision.

[Untaman]

thx!

[PaikProductions]

Thanks untaman, Working now atm Mount vendor! + belt and Boots! coming soon!

[birdofdeath]

Very Nice work man. Great Job!

[faddix]

Thanks untaman, Working now atm Mount vendor! + belt and Boots! coming soon!

...thought that you was forgotten us...:p
great job...

-----------------------------------------------------------------------

[Speachless]

I'm in credits :D now everybody gief rep! jk ;p

real one!

I'm sorry m8 but blizzard didnt release the real one yet, teher are some "Blizzlike"Frostmournes around with Retail-like stats but not the real frostmourne, still nice :)

[PaikProductions]

Ontox you right but its better than this fake one: The Hungering Cold - Item - World of Warcraft (http://www.wowhead.com/?item=23577) the frostmourne i got is like the same in the icecrown trailer :D!

[Gnome]

Waist vendor? (Belt)

[PaikProductions]

Ye waist is belt :P

[lordrob2k3]

Good work man looks nice !

[PaikProductions]

Thanks, Feet vendor almost done!

[Grisscon]

This is awesome :D Nice Work!

[PaikProductions]

UPDATED: Feet vendor added!

EDIT: Who is intrested in Heirloom vendor? please comment!

[faddix]

UPDATED: Feet vendor added!

EDIT: Who is intrested in Heirloom vendor? please comment!

i am interested...

and btw, here is the update for ArcEmu:

--> DOWNLOAD NOW! (http://filebeam.com/02f590f57054cc6babd0e2c42e01c5ab) <-- update Feet

-------------------------------------------------------------------------

[Gnome]

Ye waist is belt :P


Yeah i know, thats why i posted it, you're missing Belt aka Waist Vendor.

And yeah we're intrested in a Heirloom Vendor ^^

[PaikProductions]

Oke good gonna work on it :D!

[Gnome]

Thanks, I was going to make vendors like this but you were before so if i make some now they' will be able here some days after lol :P

[armoryh]

I LOVE you, not kidding :D +rep!

KEEP GOING!

[PaikProductions]

I LOVE you, not kidding :D +rep!

KEEP GOING!

Thanks :D

UPDATED: Waist vendor now added, rapidshare and mediafire are now fully of ArcEmu!!

[Arthasfear]

Awesome vendors for sure!!!

[PaikProductions]

Thanks for voting already guys, good everyone till now likes it :D Keep voting!
If you got some suggestions for a vendor, feel free to post it :D!

[Meanox]

WOOOOOT!!! You created Heirloom VENDOR!!! 1st one ever! (i think never seen another one :P) Thx 1000 times!!

[PaikProductions]

WOOOOOT!!! You created Heirloom VENDOR!!! 1st one ever! (i think never seen another one :P) Thx 1000 times!!

Thx you were faster than me to say update :D
__________________________________________________ _____________

UPDATED: Heirloom vendor now added! ;)

[faddix]

UPDATED: Heirloom vendor now added! ;)

fantastic!!! ...
+rep...

------------------------------------------------------------------------

[Arthasfear]

WOAH Heirloom NICE!

[Speachless]

Paik what do you still need, i can make some if its alot more.

[Hurkulez]

Are you keeping original post current?

OBTW +Rep

[PaikProductions]

Paik what do you still need, i can make some if its alot more.

Ontox no help needed mate, but anyway thanks for asking :D

[Graphic]

I just want to say OWNAGE WORK :D

[PaikProductions]

I just want to say OWNAGE WORK :D

Thank you :D

__________________________________________________ ________

UPDATED: Ground and Flying mount vendor now added!

[Gnome]

Omg, i just made Ground and Flying Mount Vendors for my Server... xD

Thanks for the Vendor, i repped you some times.

[PaikProductions]

Thanks gnome :D !

[Universemariner]

Awesome vendors! +rep and keep going :D

[PaikProductions]

Thank you, working on Item Enhancements atm!

EDIT: Who is intrested in PaikProductions Custom Armor Vendor?

[balrog603]

by me it says MySQL error: column row1 or something

[faddix]

Thank you, working on Item Enhancements atm!
EDIT: Who is intrested in PaikProductions Custom Armor Vendor?

i think that we are all interested of course...
but maybe is better to finish Enchants, Reagents, Books/Idols/Totems, POtions/Food first...:D
no rush, just suggesting...

by me it says MySQL error: column row1 or something

you have outdated database, this is for recent ArcEmu updates database....

--------------------------------------------------------------------------------------------------

[PaikProductions]

i think that we are all interested of course...
but maybe is better to finish Enchants, Reagents, Books/Idols/Totems, POtions/Food first...:D
no rush, just suggesting...


--------------------------------------------------------------------------------------------------

as you wish faddix :D

EDIT: Books/Idols/Totems already added ;)

[Mutopendon]

lol 1 bad why that ...
Anyway thx for updating them all the time, i use them for my server !! please keep up going with this work, this is epic :D!

[PaikProductions]

Thanks :D, fine you using it for your server ;)

________________________________________

UPDATED: Item Enhancement now added to vendors :D

[Lamora]

I'm running a Mangos server for wotlk 3.0.3, you think you can make these vendors for mangos? pleeease? =)

would be nice if you could!

[PaikProductions]

I don't use mangos, but maybe i give it a try ;)

[Gnome]

Nice Update, Im the first one to download it :)

[faddix]

Thanks :D, fine you using it for your server ;)

________________________________________

UPDATED: Item Enhancement now added to vendors :D

thanks for update...
in your ArcEmu download change name of the file "list_of_vendors.sql" to "list_of_vendors.txt"... :D

----------------------------------------------------------------------------

[PaikProductions]

Hehe^^ please say what vendor you want! and i will make it.

EDIT: Thanks faddix , will do!

[faddix]

Hehe^^ please say what vendor you want! and i will make it.

can you make it something like this?
-Reagent Leather
-Reagent Tailor
-Reagent Engineer
-Reagent Blacksmith
-Reagent Cooking
-Reagent Alchemy
-Reagent Enchant
-Reagent Jeweler
-Reagent Miscellaneous

but only for all new reagents addded in 3.x.x +...
thanks...

-----------------------------------------------------------------------

[PaikProductions]

Faddix, gonna work on it :D!

[faddix]

thanks...and if you need any help just PM me...

------------------------------------------------------------------------

[PaikProductions]

Oke, thx for help :D

[balrog603]

i dont got out dated database because i can put other vendors in my SQL

[PaikProductions]

What's the problem then?

[faddix]

hmmm...i found some funny thing here...
in Vendor 900031 - Item Enhancement (Temporary), on my database(NCDB_46)
list is empty when I click on him...so this items are still not added in NCDB?? :D...

--------------------------------------------------------------------------

[PaikProductions]

UPDATED: Reagents now added!

gonna work on it faddix :P

EDIT: they arent NCDB yet :(

[faddix]

wooooow....reagents are here...nice job PaikProductions...
+ rep...(when I spread some first :( )

------------------------------------------------------------------------

[R3dW3r3W0lf]

I Swear to god piak is like a lifesaver for The NPC's that we would need. +Rep!

[PaikProductions]

Thanks guys :D!!

Working on shirt and general goods vendor atm :)

will updated a Cooking + Miscellaneous later!

EDIT: Gemstones coming soon when NCDB added them xD :(!

[Gnome]

Nice

[PaikProductions]

UPDATED: General Goods now added to vendors!

[Lamora]

niceely done man! thanks anyways =)

[PaikProductions]

good you like it!

EDIT: how sad someone on mmowned thinks i stole this from a repack, i said give link then he didnt know it. then someone said that he was 100% sure i didn't make this! people how sad is that?! you guys know i made it myself isn't it?
'

[faddix]

EDIT: how sad someone on mmowned thinks i stole this from a repack, i said give link then he didnt know it. then someone said that he was 100% sure i didn't make this! people how sad is that?! you guys know i made it myself isn't it?
'

we know that this is yours vendors, who cares about mmowned...
just keep your good work and don't worry...
on mmowned they we're stole my compiles, repacks and reposted my posts about 100 times and never give credits for that...

------------------------------------------------------------------------

[birdofdeath]

For anyone having a problem with the Mounts:
The Chopper and Mammoth where attacking enemy players in my mall <Which is Non-PVP>

Fix (this wasn't Paik's Fault, its how blizzard made the mount...)

-open database:
-open creature_proto:
-Edit the following NPC's factions to '35'
-32286
-32263

[PaikProductions]

any suggestions for a vendors? please post it here!

[Gnome]

Yeah, to finish the other vendors. ^^

For anyone having a problem with the Mounts:
The Chopper and Mammoth where attacking enemy players in my mall <Which is Non-PVP>

Fix (this wasn't Paik's Fault, its how blizzard made the mount...)

-open database:
-open creature_proto:
-Edit the following NPC's factions to '35'
-32286
-32263

UPDATE creature_proto set faction = 35 where entry = 32286;
UPDATE creature_proto set faction = 35 where entry = 32263;

[PaikProductions]

Shirt and pre-made enchant under construction!

[Gnome]

Gief Gems also :D

Lols

The Wotlk Gems are imba, like 42 Stamina :O

[PaikProductions]

NCDB didnt add them yet so i can't make it atm!

[Lamora]

how about some trainers? like Tailoring trainer, skinning trainer, mining trainer, etc etc (just a suggestion)

[faddix]

some suggestions...

*Quivers/Ammo Pouches
*Projectiles (Arrows/Bullets)
*Armor Tokens (some servers have extended cost in vendors :) )
*Gems (when NCDB finish them)

-----------------------------------------------------------------------

[PaikProductions]

Shirt done in some seconds, working on the things you ask faddix :D!

EDIT: UPDATED: Shirt vendor now added!

[statoil]

hmmm im woundering if it is possible to create the litch king's armour too :O that would be aweasom :D

[PaikProductions]

hmmm im woundering if it is possible to create the litch king's armour too :O that would be aweasom :D

Send me pic of armor please don't know what you mean with Lich King Armor xD.

__________________________________________________ ______________

UPDATED: Quiver, AmmoPouch, Projectile vendor is now added to list!

__________________________________________________ ______________

EDIT: UPDATED: Offhand now added to list!

[Arthasfear]

Man you working so ****** fast, Great job!

[PaikProductions]

Thx :D i am working on currency vendor :)

[zeal_aiz]

Nice work Paik:D

Can i use this for my GM Island spawn which later on i edit to adapt ArcEmu and Aspire. Of course i will mention u name in credit and rep u as much as i can:P

+rep:)

[PaikProductions]

I would realy like that :D Its no problem! Do your job ;) and good luck!

[zeal_aiz]

Thx u so much :o

EDIT: Paik checkout my new thread. Thx to u I been able to merge ur WotLK items with my vendor
HERE (http://www.ac-web.org/forum/releases/42066-release-full-gmi-vendor-mall-v4-0-a.html)

[PaikProductions]

Great job mate, no problem :D!

[nickp2011]

Sweet great. i cant wait to add these. im testing out some good malls now :0

+rep

[Lamora]

but, you think you can make like, a Riding trainer & professions trainers? =) would be nice!

[Gnome]

Lol there are already trainers in added in Wotlk.

[PaikProductions]

UPDATED: Currency vendor now added to list :D!

[Gnome]

Yay!

[Drakkus]

Is this a Custom Made Frostmourne or the real one? :P

There is no real frostmourne on wow..

Lich king raid hasn't even been released rofl

[PaikProductions]

Hehe drakkus we already explained him :P but anyway thx to say it again :D!

[Gnome]

Bump! :D

[PaikProductions]

Hehe^^

[Gnome]

Soon:

Recipe A-Z (100%)
Reagent A-Z (100%)
Item Enhancements (100%)
Season 5 (100%)
Weapon 200+ (100%)
Trinket (100%)
Tier 7 (100%)
Rings (100%)
Shield (100%)
Necklace (100%)
Tabard (100%)
General Goods (100%)
Relics (100%)
Cloak (100%)
Currency (100%)
Container (100%)
Wrist (100%)
Feet (100%)
Waist (100%)
Heirloom (100%)
Gemstone I (0%)
Gemstone II (0%)
Glyph (100%)
Offhand (100%)
Shirt (100%)
Mount (100%)
Flying Mount (100%)
Quiver, AmmoPouch, Projectile (100%)
Pre made Enchants! (74%)

Aren't the ones that says 100% Done already? or you got like 1 more item to add? ^^

Then complete them with 100% Soon, before making the other ones. :p

[PaikProductions]

100% is finished :D

[Gnome]

ah, i thought you mean "Soon xxx is finished 100%"

Make a list for Finished then ^^

[PaikProductions]

Thx for suggestion:D +rep

[Gnome]

No, +Rep to you for bringing these Vendors ^^

EDIT: need to spread :P

But i gave ya some other days also

[PaikProductions]

Oke :) no problem!

[Gnome]

Hmm... Gief Gem Vendor! :D

I made Normal Gems and Meta / Prismatic Gem on my server :D

[PaikProductions]

Oke so they are added on NCDB, Good working on it right now!

[faddix]

Oke so they are added on NCDB, Good working on it right now!

great!!!
i am waiting for update :D

----------------------------------------------------------------------

[Gnome]

:D +Rep to both of you for having awesome vendors and compiles. ^^

Edit: 1 sec must spread some

[faddix]

:D +Rep to both of you for having awesome vendors and compiles. ^^

thanks...

and Paik,
grats on SENIOR rank!! Keep it up!!! :D

----------------------------------------------------------------

[PaikProductions]

:D +Rep to both of you for having awesome vendors and compiles. ^^

Edit: 1 sec must spread some
Thx!

thanks...

and Paik,
grats on SENIOR rank!! Keep it up!!! :D

----------------------------------------------------------------

Thx guys:D!!!!

UPDATED: Gemstone I, Gemstone II, Gemstone III now added to list!

EDIT: UPDATED: Armor Tokens is now added to list!

[Untaman]

WoW EPIC updated man!!!! +rep

[Universemariner]

Yep untaman is right, this is a epic update ;)

[Gnome]

Woot!! Epic!

[PaikProductions]

WoW EPIC updated man!!!! +rep
Hehe Thx!
Yep untaman is right, this is a epic update ;)
Thanks :D
Woot!! Epic!

3 times THX! :P

EDIT: Working on Key vendor at the moment!

[faddix]

i found one little mistake you made in Gemstone vendors,
in entry of vendor you put 900035 and i think it must be 900045,
so make corrections or gem will go to
900035 - Reagent [ Inscription ] vendor :D ...

-------------------------------------------------------------------------

[PaikProductions]

Thx for report faddix :D updating atm!

EDIT: Gemstone II UPDATED! Reason item had wrong vendor ID! now fixed!

[Meanox]

PaikProductions, as you said before could you make your PaikProductions Custom Gear Vendor? that would be great for my donations :D!

[PaikProductions]

Oke, will work on it :D!

[ithal]

ITS CUSTOM MADE FROSTMOURNE doh
theres no frostmourne in real game yet, it comes in 3.2 patch

[PaikProductions]

thats already said 3 times now, we understand oke...!

But anyway thx for report??

[Lamora]

Lol there are already trainers in added in Wotlk.

Yea, but then i have to place several trainers... =P but its not necessary anymore =)

[Meanox]

lol.^^ paik you right in this thread already 3 times said that frostmourne is custom but looklike the real one xD. read first then ask question!

[PaikProductions]

Thats true Meanox.

[Ubbelol]

I love this release, very nicely done Paik! +rep ^_^

[birdofdeath]

2 of the gem vendors (1 and 3) dont work :/

[PaikProductions]

new rev?...

[Mes]

Great job mate! Love it! Just one thing, might be a noobish question but when I try to put the vendors into the database via HeidiSQL and I hit the play button it says, "SQL Error: Column doesn't match value count at row 1."

Any help?

Thanks! :D

[Exaiphnes]

I'm quite new to this! I recently grew interested in the activities of these forums and just last night got my server up and running using Alphy's amazing tutorial here http://www.ac-web.org/forum/tutorials/42571-tutorial-creating-3-0-3-server-making-open-public.html

The readme of this vendor pack is just within my reach of new knowledge with navicat, can anyone recommend a tutorial already written here on the forums to adding vendors and such much like this? Thanks :D

Edit: I think I got it working. Is it the same way as described in zeal's gm mall?
http://www.ac-web.org/forum/releases/42066-release-full-gmi-vendor-mall-v4-0-a.html

[PaikProductions]

Great job mate! Love it! Just one thing, might be a noobish question but when I try to put the vendors into the database via HeidiSQL and I hit the play button it says, "SQL Error: Column doesn't match value count at row 1."

Any help?

Thanks! :D

You using mangos?

I'm quite new to this! I recently grew interested in the activities of these forums and just last night got my server up and running using Alphy's amazing tutorial here http://www.ac-web.org/forum/tutorials/42571-tutorial-creating-3-0-3-server-making-open-public.html

The readme of this vendor pack is just within my reach of new knowledge with navicat, can anyone recommend a tutorial already written here on the forums to adding vendors and such much like this? Thanks :D

Edit: I think I got it working. Is it the same way as described in zeal's gm mall?
http://www.ac-web.org/forum/releases/42066-release-full-gmi-vendor-mall-v4-0-a.html


He asked for my promision to put my vendors in his release :)

[Mutopendon]

bump!

[PaikProductions]

Thanks for the bump mutopendon :D!

[skreem]

PaikProductions your great dude, loved your vendors on my repack keep up the good work! +rep well If I could =p already have givin u rep though =p xD

[PaikProductions]

Thanks skreem, i am now taking requests for Custom vendors or other vendors.

[kaji95]

Hello guys :D,

I made some vendors, soon coming more!
These are very usefull for a mall.
If you want some screenshots just ask me and i gonna work on it!
The tier 7 is the REAL blizzard tier!
All classes are added at vendors.
The download file includes Readme!!!

Vendors at the moment:
900005 - Tier 7
900006 - Tier 7
900007 - Weapons 200+ [Frostmourne include]
900008 - Trinkets
900009 - Rings
900010 - Necklace
900011 - Shield
900012 - Tabard
900013 - Season 5
900014 - Relics
900015 - Cloak
900016 - Container
900017 - Glyph I
900018 - Glyph II
900019 - Wrist
900020 - Book A-Z
900021 - Leather A-Z
900022 - Jewelcrafting A-Z
900023 - Engineering/Enchanting A-Z
900024 - Alchemy/Blacksmithing/Tailoring
900025 - Waist
900026 - Feet
900027 - Heirloom
900028 - Ground Mounts
900029 - Flying Mounts
900030 - Item Enhancement (Permanent)
900031 - Item Enhancement (Temporary)
900032 - Reagent [ Enchanting ]
900033 - Reagent [ Leatherworking ]
900034 - Reagent [ Blacksmithing ]
900035 - Reagent [ Inscription ]
900036 - Reagent [ Engineering ]
900037 - Reagent [ Alchemy ]
900038 - Reagent [ Tailoring ]
900039 - General Goods
900040 - Shirt
900041 - Quiver, AmmoPouch, Projectile
900042 - Offhand
900043 - Currency
900044 - Gemstone I
900045 - Gemstone II
900046 - Gemstone III
900047 - Armor Tokens

Filebeam:
Download Vendors (http://filebeam.com/7a6308534cd36b9acdd7639a265f4f79) <-- Updated: Armor Tokens - ArcEmu

INSERT INTO "creature_names" ("entry", "name", "subname", "info_str", "Flags1", "type", "family", "rank", "unk4", "spelldataid", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "civilian", "leader") VALUES
('900005','Tier 7',' PaikProductions 1','','4096','7','0','0','0','0',28000,0,0,0,'1',' 1',NULL,NULL);
INSERT INTO "creature_names" ("entry", "name", "subname", "info_str", "Flags1", "type", "family", "rank", "unk4", "spelldataid", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "civilian", "leader") VALUES
('900006','Tier 7',' PaikProductions 2','','4096','7','0','1','0','0',28000,0,0,0,'1',' 1',NULL,NULL);
INSERT INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "mountdisplayid", "equipmodel1", "equipinfo1", "equipslot1", "equipmodel2", "equipinfo2", "equipslot2", "equipmodel3", "equipinfo3", "equipslot3", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags", "spell1", "spell2", "spell3", "spell4", "spell_flags", "modImmunities") VALUES
('900005','80','80','1741','200000000','200000000' ,'50000000','1','130','2000',0,'450','1000','68',' 426','0','0','0','0','0','0','0','0','0','0','0',' 0','20000','0','0','0','0','0','0','1.5','0.347',' 0','0',5000,'0','0','4','8','14',0,0,0,0,0,0,'0');
INSERT INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "mountdisplayid", "equipmodel1", "equipinfo1", "equipslot1", "equipmodel2", "equipinfo2", "equipslot2", "equipmodel3", "equipinfo3", "equipslot3", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags", "spell1", "spell2", "spell3", "spell4", "spell_flags", "modImmunities") VALUES
('900006','80','80','1741','200000000','200000000' ,'50000000','1','130','2000',0,'450','1000','68',' 426','0','0','0','0','0','0','0','0','0','0','0',' 0','20000','0','0','0','0','0','0','1.5','0.347',' ','0',5000,'0','0','4','8','14',0,0,0,0,0,0,'0');
INSERT INTO "creature_spawns" ("id", "entry", "map", "position_x", "position_y", "position_z", "orientation", "movetype", "displayid", "faction", "flags", "bytes0", "bytes1", "bytes2", "emote_state", "npc_respawn_link", "channel_spell", "channel_target_sqlid", "channel_target_sqlid_creature", "standstate") VALUES
('900005',11365,309,'11535.4','1620.98','61.5083', '1.30558',0,'633',28,9,16908544,0,0,0,0,0,0,0,0);
INSERT INTO "creature_spawns" ("id", "entry", "map", "position_x", "position_y", "position_z", "orientation", "movetype", "displayid", "faction", "flags", "bytes0", "bytes1", "bytes2", "emote_state", "npc_respawn_link", "channel_spell", "channel_target_sqlid", "channel_target_sqlid_creature", "standstate") VALUES
('900006',11365,309,'11535.4','1620.98','62.5083', '1.30558',0,'633',28,9,16908544,0,0,0,0,0,0,0,0);
Put these in your DB!
For additing of other Vendors, please change ID to vendor ID

Soon:

Pre made Enchants! (74%)
Keys (4%) <-- Currently working on!

Finished:

Recipe A-Z (100%)
Reagent A-Z (100%)
Item Enhancements (100%)
Season 5 (100%)
Weapon 200+ (100%)
Trinket (100%)
Tier 7 (100%)
Rings (100%)
Shield (100%)
Necklace (100%)
Tabard (100%)
General Goods (100%)
Relics (100%)
Cloak (100%)
Currency (100%)
Container (100%)
Wrist (100%)
Feet (100%)
Gemstone I (100%) ***NEW***
Gemstone II (100%) ***NEW***
Gemstone III (100%) ***NEW***
Waist (100%)
Heirloom (100%)
Glyph (100%)
Armor Tokens (100%) ***NEW***
Offhand (100%)
Shirt (100%)
Mount (100%)
Flying Mount (100%)
Quiver, AmmoPouch, Projectile (100%)


If you don't got frostmourne then put this in your DB:
INSERT INTO items VALUES
('46609',2,8,-1,'Frostmourne','Frostmourne','Frostmourne','Frost mourne','46609',6,0,0,0,17,-1,-1,189,80,0,0,0,0,0,0,0,2,1,0,4,100,7,200,5,150,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,'0','0','597','896',0,'0' ,'0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0 ,4000,0,'0',7600,1,0,0,0,0,34696,2,0,0,0,0,35844,1 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'You will become the new lich king!',0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,1,0,2,0 ,1585,0,0,0,'0');


Gemstone II UPDATED! Reason, item got wrong vendor ID!
INSERT INTO vendors VALUES ('900045','41335',0,0,'0',0);

Please leave a comment :D

Credits:

-PaikProductions
-faddix for making them ArcEmu
-Ontox for the season 5




Where can i get a download for flying trainer?If you have one please let me know and also, my server is instant 80...but my players have no talents how oculd i fix that?


Kind Regards,
Ichiru

[PaikProductions]

Here are the trainers :D : http://www.ac-web.org/forum/releases/42265-release-full-global-trainer-v4-0-a.html

[netko]

hey PaikProductions can you help us some vendors do crazy things like:

1) You cannot talk to most vendors - Nothing happens
1) The wrist vendor just appears and then he disappear again
3) Some of the vendors are doing weird spells like blizzard etc

i download your they do that i download http://www.ac-web.org/forum/releases/42066-release-full-gmi-vendor-mall-v4-0-a.html they do that too

can you help us??? pls

i using last arcemu rev

[faddix]

1) You cannot talk to most vendors - Nothing happens
1) The wrist vendor just appears and then he disappear again
3) Some of the vendors are doing weird spells like blizzard etc

you database is screwed...use latest NCDB r47...

---------------------------------------------------------------------
btw...

BUMP!!!

-----------------------------------------------------------------------

[teeplyr]

Takes some time to load but still very nice, +Rep
------------------------------------------------
BUMP^

[PaikProductions]

you database is screwed...use latest NCDB r47...

---------------------------------------------------------------------
btw...

BUMP!!!

-----------------------------------------------------------------------

Takes some time to load but still very nice, +Rep
------------------------------------------------
BUMP^

Thanks guys :P

[netko]

faddix i use latest NCDB

[PaikProductions]

UPDATED: Keys Vendor now added to list!

To come: Special Unknown Vendors never seen on any server!!!!

[faddix]

updated: Keys vendor now added to list!

to come: Special unknown vendors never seen on any server!!!!

bump!!!

------------------------------------------------------------------

[PaikProductions]

Finaly UPDATED: New Section added: Instance Vendors!
Finaly UPDATED: New Vendor added: Instance Vendor - The Nexus!

Enjoy the new Vendors! - Soon more Instance Vendors will be added!!!

[Arthasfear]

WOAWWW! Instance Vendors to perfect man Great job +rep.!

[PaikProductions]

WOAWWW! Instance Vendors to perfect man Great job +rep.!


Hehe Thanks, more to come like Naxxramas Vendor I have to add 300+ Items in the Vendors :D! Working on it atm!

[lordcranberry3]

looks cool i am gonna try these.

[PaikProductions]

soon Naxxramas vendor will be added!, 1 little problem came up, Wowhead isn't working perfectly so its gonna take longer than normal. Sorry for this but can't help it :(. Please comment and give some suggestions for vendors you need for your server ;).

[conker789]

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO creature_names VALUES ('900045','Gemstone II','PaikProductions','','' at line 2
[Err] INSERT INTO creature_names VALUES ('900044','Gemstone I','PaikProductions','','4096','7','0','1','0',NUL L,28000,0,0,0,'1','1',NULL,NULL),
INSERT INTO creature_names VALUES ('900045','Gemstone II','PaikProductions','','4096','7','0','1','0',NU LL,28000,0,0,0,'1','1',NULL,NULL),
INSERT INTO creature_names VALUES ('900046','Gemstone III','PaikProductions','','4096','7','0','1','0',N ULL,28000,0,0,0,'1','1',NULL,NULL);
[Msg] Finished - Unsuccessfully


ughh i've been looking at this and trying to figure it out please help

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `items` VALUES ('46609', '2', '8', '-1', 'Frostmourne', 'Frostmourne', 'Frostmourne', 'Frostmourne', '46609', '6', '0', '0', '0', '17', '-1', '-1', '189', '80', '0', '0', '0', '0', '0', '0', '0', '2', '1', '0', '4', '100', '7', '200', '5', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '597', '896', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4000', '0', '0', '7600', '1', '0', '0', '0', '0', '34696', '2', '0', '0', '0', '0', '35844', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'You will become the new lich king!', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '2', '0', '1585', '0', '0', '0', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[PaikProductions]

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO creature_names VALUES ('900045','Gemstone II','PaikProductions','','' at line 2
[Err] INSERT INTO creature_names VALUES ('900044','Gemstone I','PaikProductions','','4096','7','0','1','0',NUL L,28000,0,0,0,'1','1',NULL,NULL);
INSERT INTO creature_names VALUES
('900045','Gemstone II','PaikProductions','','4096','7','0','1','0',NU LL,28000,0,0,0,'1','1',NULL,NULL);
INSERT INTO creature_names VALUES ('900046','Gemstone III','PaikProductions','','4096','7','0','1','0',N ULL,28000,0,0,0,'1','1',NULL,NULL);
[Msg] Finished - Unsuccessfully


ughh i've been looking at this and trying to figure it out please help

UPDATE Them with these:
INSERT INTO creature_names VALUES ('900044','Gemstone I','PaikProductions','0','4096','7','0','1','0',NU LL,'28000','0','0','0','1','1',NULL,NULL);
INSERT INTO creature_names VALUES ('900045','Gemstone II','PaikProductions','0','4096','7','0','1','0',N ULL,'28000','0','0','0','1','1',NULL,NULL);
INSERT INTO creature_names VALUES ('900046','Gemstone III','PaikProductions','0','4096','7','0','1','0', NULL,'28000','0','0','0','1','1',NULL,NULL);


Frostmourne Outdated!

[faddix]

Finaly UPDATED: New Section added: Instance Vendors!
Finaly UPDATED: New Vendor added: Instance Vendor - The Nexus!

Enjoy the new Vendors! - Soon more Instance Vendors will be added!!!

soon Naxxramas vendor will be added!, 1 little problem came up, Wowhead isn't working perfectly so its gonna take longer than normal. Sorry for this but can't help it :(. Please comment and give some suggestions for vendors you need for your server ;).

great idea...i am waiting for update then... :D
nice job as always...

------------------------------------------------------------------------

[testdrive]

i have gems & keys error. all the rest run fine.

[PaikProductions]

Gemstone I the gems arent added in the DB, and Keys vendor must run. it works at mine.

[Arthasfear]

Bump / awesome Twink Vendors just what i needed for my server! +rep

[PaikProductions]

UPDATED: [Level 19]
700000 - Twink Weapons - Daggers
700001 - Twink Weapons - One Handed Axes
700002 - Twink Weapons - One Handed Swords
700003 - Twink Weapons - One Handed Maces
700004 - Twink Weapons - Staves
700005 - Twink Weapons - Two Handed Axes
700006 - Twink Weapons - Two Handed Swords
700007 - Twink Weapons - Two Handed Maces
700008 - Twink Weapons - Range
700009 - Twink Armor - Cloth Armor
700010 - Twink Armor - Leather Armor
700011 - Twink Armor - Mail Armor
700012 - Twink Armor - Cloacks
700013 - Twink Armor - Shields
700014 - Twink Jewels - Neck
700015 - Twink Jewels - Rings
700016 - Twink Weapons - Off Hands
700017 - Twink Bags

Are added to list!

[A Pretty Face]

Yay, updated! ^^ +rep!

Bump! ^_^

[PaikProductions]

Thanks :D!

[RohBang]

900044 - Gemstone I
900045 - Gemstone II
900046 - Gemstone III
900048 - Keys
frostmourne

sql error

[PaikProductions]

They should not give an error, only the frostmoure.

Give the error pls.

[skreem]

Nice update.
+rep for the update

[PaikProductions]

Thanks skreem, good your back :D!

[QQrofl]

Zomg a update? Nice! Lol. :P

<---Is lazy to make his own vendors!--->

[PaikProductions]

Hehe^^ thanks qqrofl :D!

[skreem]

<3 Paikproductions!

[eMaTriKs]

Gemstone I, Gemstone II and Gemstone III is bugged in rdb rev151 (Version Rival, no faddix).

[PaikProductions]

That is possible. the items arent added in the DB yet then.

[eMaTriKs]

How can I add?

[onlykl]

BuMp! ;) +Rep

[skreem]

Bump =)
And as for the items you can add them into your datbase if you know how to make a socket (very simple) and just find the sockets u want on those vendors or in game and look them up on wowhead.com. They sockets will have a spell id and u can put that on it.
You can even make a socket give u mongoose =p

[PaikProductions]

Bump :D!

[eMaTriKs]

Do not add, it's like.. I will custom..

[skreem]

Best vendors out there.
Bump

[PaikProductions]

thanks skreem :)

[Speachless]

Bump, Nice Paik ;)

[PaikProductions]

bumpage, thanks Ontox!

[beast420]

so i have a ? do i download all of of the vendors if i just download the 1st one or do i have to download every one of the download spots?

[Starsunder]

1136 - Column count doesn't match Value count at Row 1

Is what I get when I try to add in Frostmourne

[PaikProductions]

1136 - Column count doesn't match Value count at Row 1

Is what I get when I try to add in Frostmourne


Frostmourne doesnt work, I will make new one.

[skreem]

Most likely doesn't work due to the the databases updating alot of the tables.
Good work Paiky =)
Your vendors are being used on my current repack in develop.
Amazing vendors.

[PaikProductions]

Thanks skreem, and cool you using them on your repack :D!

[skreem]

Wouldn't use anything else =)

[treetree]

Ty paik,for your good venders I think I know how to
make them work now. I just put that sql in the db
and put in the number in the gm addon or .additem 9000005
and I have a vender guy. or maybe there are scripts for them to
that go into the scripts folder.nope no scripts,because they
only do one thing. Only the npc's that talk and do things have
scripts I think. well I can get a repack now and have venders
and alot of object things like stairs,bubbly things and people
things. I know I sound like an idiot,but I am happy to learn
something.

hahahahahahahahah

treetree. :D:D

[PaikProductions]

Hehe, good treetree :D!

[onlykl]

BUMP Mate ;) +Rep... Soon first Conquer Team Release :)))

[Raistlin77]

Thanks, it's obvious you've put quite a lot of work into these. It's good to see keys are back, that's one I was missing (many instances require them just to get in after all, and it's a pain adding them manually).

And treetree, don't worry about sounding like an idiot. If you don't ask you don't learn. At least you want to learn, and that's what's important.

[PaikProductions]

Thank you guys ;)!

[xX EPIC Xx]

Fail = No
Succsed = Yes
hehe :P Bump

[PaikProductions]

hehe thanks :D!

[nemo202]

Anyone here have all the vendors but a T7 vendor for each class instead of all classes put into 2 vendors?

[PaikProductions]

Why is that a problem, ooh nvm

Bmp!

[kadava]

Hey! just an idea... anything about a Dk vendor! like armor ? as when you start at lvl 55 with no money, no talents (unless you give them) there is no decent armor for a dk class! people on my server constantly ask me this! so im just passing on many peoples thoughts!

Thanks man, and good work!

[PaikProductions]

Thanks for the idea kadava maybe release soon ;)!

[martin197]

thank you dude :P

[PaikProductions]

Thanks, but I am not a dude.

[bloodshed2007]

how can i make it so if im playing my warrior and I go to a Tier 7 vendor it only shows warrior t7?

great vendors though ;)

[PaikProductions]

Make separate vendors or use LUA!

[bloodshed2007]

what lua?

[Diablothein]

Make one for Hearthstone plox

[Shuang]

U make 1 for harthstone lazy fuck?

[PaikProductions]

Haha, thanks administrator ;), and yes Diablothein I maybe gonna create hearthstone vendors :P!

[ZCFC]

I have sent u a private message but i willl write on here as wel. i cannot get them to run on navicat as it keeps saying collumn count doesnt match value count at row 1

[PaikProductions]

Its for arcemu not hearthstone :P!

[ZCFC]

are you making hearthstone version

if u just made a few vendors i would be happy. +rep btw for telling me

[PaikProductions]

Yes, I am starting to make hearthstone 3.1.1 version!

[ZCFC]

kool have u done any yet

[arjo112]

hey can you put ur aspire version on here need the realy bad.
Edit: didn't read page before me :)
ur working on it :D

[PaikProductions]

Oke after some thinking I decided to not create hearthstone vendors!

This is for this reasons:

- I love ArcEmu
- If ArcEmu is on 3.1.1 hearthstone will go back where it was ( sorry for this :P )

PaikProductions!

[arjo112]

Well, thats true but still to bad, now i need to make them my selve. which i already did with T8 :D and their shared on the site here ,but they need a test since i can't get my server running.

[ZCFC]

I also love arcemu but it isnt out yet and i needed a private server up so i had to use heartstone but i really need some hearthstone custom vendors, nos ite i know you can even make them on

[Blyitgen]

Well i will make a ArcEmu 3.1.0 repack i think :D With HybridDB. Now Paiki just needs to make T8 and Ulduar vendors for ArcEmu.

[arjo112]

Gues what there is a 3.1.1 arcemu!
http://www.ac-web.org/forums/repacks/54405-arcemu-3-1-x.html#post451853
gonne test it now!

[PaikProductions]

Oke, people I am creating T8 vendors now!!, Also because of nadskap I gonna create Ulduar Vendor!

to arjo112: That repack got so many bugs!

[Blyitgen]

And? It is that ArcEmu im gonna use for my repack ;)

Vendors must be HybridDB structure (ArcEmu)

[PaikProductions]

HybridDB is a very nice DB! :P

[Blyitgen]

Yeah.

[arjo112]

Yeh thats true paik, btw check out
http://www.ac-web.org/forums/sql-querys/55952-soon-all-non-t8-ulduar-armor-vendors.html
and
http://www.ac-web.org/forums/sql-querys/55939-t8-vendors-needing-test.html
i accidently made it arcemu i think so if it works you can use them :D

[PaikProductions]

That would be great nice work arjo112 :)!

[ZCFC]

;( - "crying face" noone makes damn hearthstone aspire and there are no stable or decent arcemu 3.1.1 and i have requested any everything and i cant get my own to work ;( all i need is like 3 vendors will do tier 8, weapons 200+, and season 5. ;( ;( plz paik can u make some ;(

[PaikProductions]

Well, oke then.

Here you go: HearthstoneVendors.sql (http://www.mediafire.com/?zn5myno0ymn)

[ZCFC]

bumb +rep still having trouble. but getting better everytime ty so much!

[PaikProductions]

No problem ;), hearthstone vendors are on the main thread.

[arjo112]

The hearthstone download aint working im getting:
Invalid File. This error has been forwarded to MediaFire's development team.

The key you provided for file download was invalid. This is usually caused because the file is no longer stored on Mediafire. This occurs when the file is removed by the originating user or Mediafire.

[PaikProductions]

Download working now xD~

[skreem]

Bump for paiki.

[PaikProductions]

Thanks skreemi ;)!

[skreem]

Paiki, pop on my vent =p
bump

[skreem]

Best vendors to use btw.

[Hurkulez]

Paik can you do these for mangos or direct me to a mangos link, Thx in advance +rep again...

[Jolies]

Hey, im new to ac-web but this seems +rep worthy , + rep from me :)

xxx, Jolies

Edit: ohh my brother, arjo112:P, just said the hearthstone vendors ain't working.
Theyr factions are evil, atleast to gnomes.. (why! is my bro a gnome!)
and if he changes his faction to theirs they dont sell anything

[PaikProductions]

Hmm strange they are working for me.. Will have a look. And Hurkulez, maybe soon for Mangos ;)!

[madzkull]

I can't wait for MaNGOS version of this ;) thanks for opening up of the development for MaNGOS version..

[ZCFC]

I have the same problem with every faction and now when i run the sql half way through it says it has problems with the second vendor,(season 5). then when i change the flags of the NPC ingame of the first vendor,(Weapons 100+), it says no template found.

Also Quick request could you do a Frostmourne sql for hearthstone like you did for arcemu please :)

[Breakdown6]

I was wondering if you create a item enchant vendor, like Weapon Enchants, Bracers, Gloves, Shields, ect?

EDIT: Perhaps it might be in the 'Temporary Enchant Vendor' But for me that vendor does not seem to work.

[Vliro]

Paik,as in the 3.1.2 patch its most heartstone.So can you continue making the heartstone vendors?

[PaikProductions]

Maybe.

[RakkorZ - ZxoxZ]

Paik, I found a bug at your Gemstone Vendors, and I repair it.

And I change the EntryIDs, I used them at my server. New EntryIDS: 80023 - 80024 - 80025. You can open it with Notepad, and press: Ctrl + H, and replace from 80023 to your id, 80024 to your id, 80025 to your id.

~!-Download PaikProductions - Sockets - Gems Vendors-~! (http://filebeam.com/d511102c1e157930ec415729d2226f73)

Thanks,
Zxoxz.

[remuss]

Nice vendors Paik :) Always a great release when its from you.

keep it up! oh, and btw.. +rep d;

[PaikProductions]

Thank you so much remuss.

[RakkorZ - ZxoxZ]

You don't thanks me? :(

[Ooberstan]

/Thanks Rakkorz - ZxoxZ

[Hurkulez]

Hurkulez, maybe soon for Mangos ;)!

Thx Paik, U Rock....

[PaikProductions]

*Starting MaNGOS vendors!!!

[punkiblodet16]

some 1know a repack that is like normal wow ? no costume things on it :P

[BigFatLord]

MAN! It's awesome! All of you MUST to put it on your server! (If you have a funserver ofcourse)

[st23]

fascinating.

[PaikProductions]

Thanks people, and Punkiblodet16 you can use my repack at repack section: paikproductions blizzlike repack!

[NitroMan]

yo paik i have a problem . i really want your gemstone vendors but i cant add them .. this is what it gives :

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO creature_names VALUES ('900045','Gemstone II','PaikProductions','','' at line 2
[Err] INSERT INTO creature_names VALUES ('900044','Gemstone I','PaikProductions','','4096','7','0','1','0',NUL L,28000,0,0,0,'1','1',NULL,NULL),
INSERT INTO creature_names VALUES ('900045','Gemstone II','PaikProductions','','4096','7','0','1','0',NU LL,28000,0,0,0,'1','1',NULL,NULL),
INSERT INTO creature_names VALUES ('900046','Gemstone III','PaikProductions','','4096','7','0','1','0',N ULL,28000,0,0,0,'1','1',NULL,NULL);
[Msg] Finished - Unsuccessfully
--------------------------------------------------

please fix or tell me how to fix it :P thanks in advance :D +rep if you do

[yezzy]

This looks nice !

[PaikProductions]

Thanks, yezzy.

@NitroMan:

('900045','Gemstone II','PaikProductions','','4096','7','0','1','0',NU LL,28000,0,0,0,'1','1',NULL,NULL),

Look at the NULL it got a space in it just reset it to NULL.

[bbishop93]

i got same problem but my nulls are fine

- [SQL] INSERT INTO creature_names VALUES ('900044','Gemstone I','PaikProductions','','4096','7','0','1','0',NUL L,28000,0,0,0,'1','1',NULL,NULL),
INSERT INTO creature_names VALUES ('900045','Gemstone II','PaikProductions','','4096','7','0','1','0',NU LL,28000,0,0,0,'1','1',NULL,NULL),
INSERT INTO creature_names VALUES ('900046','Gemstone III','PaikProductions','','4096','7','0','1','0',N ULL,28000,0,0,0,'1','1',NULL,NULL);
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO creature_names VALUES ('900045','Gemstone II','PaikProductions','','' at line 2

mayb not when i copy it their spaced thats wierd in the query their not spaced

Ok nvm again im stil getting same problem and i retyped null

[Zellcorp]

I would +rep you but you need to fix up some of your SQL errors in gemstones, keys and frostmorne then re-repost

[Brianplast]

Nice:p

[Zellcorp]

Your trainers seemed to be bugged they keep freezing my server I had to remove them and they come up with alot of missing spells on console startup

[kosmic15]

this is so sweet +rep :)

[PaikProductions]

Thanks kosmic15 :D, Zellcorp the server freeez is not because of my vendors xD.