[ASCENT][VENDORS] Custom Vendors [Rev106] [S4 Vendor+Items] [ShoppingHall]

Custom Vendors
Hello and welcome to the CV project.
On this topic you can find daily updated vendors,when there comes a new ascent core and your old vendorsdont work anymore you can download the new updated here.

Information:
CV project made it very easy to update/import your new vendors.
It haves a little tool included that will import your vendors in less then a minute.
If you dont know how to use the tool you can open the HOW-TO-USE.txt
file that is included in the CV map.

Latest Revisions:
- Rev108 (2.4x)
- Rev107 (2.4x)
- Rev106 (2.4x)
- Rev105 (2.4x)
- Rev104 (2.4x)
- Rev103 (2.4x)
- Rev102 (2.4x)
- Rev101 (2.4x)
- Rev100 (2.4x)

ID's:
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
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
50065 - Arena Season 3
50066 - Arena Season 4

Patch notes:

Rev108:

Code:

---

- Updated to latest DB, the old importing files are still in the importer.

---

Rev107:

Code:

---

- Fixed the Off-Hand vendor it won't give an error anymore (Thanks to ghazul)

---

Rev106:

Code:

---

- Deleted that every item will be 0 buyprice.
* The extend cost is still entry 0

---

Rev105:

Code:

---

- Changed Max_amount table from items to vendors

---

Rev104:

Code:

---

- Sell price of ALL items changed to blizzlike.

---

Rev103:

Code:

---

- Now T6 vendor is also a vendor and changed size 0.5
- Changed ID of the off-hand vendor from 50028 to 50027
- Added new tool in script 'Spawn Vendors' this will spawn the vendors in Orgrimmar or Stormwind
- Added new tool in script 'Delete Spawns' this will delete the vendor spawns in Orgrimmar of Stormwind

---

Rev102:

Code:

---

- Fixed duplicate error when you already used the tool once
- Added appart S4 vendor with all brutal items in it
- Brutal Gladiator items added in the script
- Changed the size of vendors to 0,5

---

Rev101:

Code:

---

- Fixed that the NPC's are vendors now.
- Rogue Poison NPC subname changed.
- Shaman totem vendor subname changed.

---

Rev100:

Code:

---

- Added Dungeon set 1-3 [ID: 50000-50002]
- Added Tier set 1-6 (Inc. Boots, Wrist and Belt) [ID: 50003-50008]
- Added Necklace vendor [ID: 50020]
- Added Rings vendor [ID: 50021]
- Added Trinket vendor [ID: 50022]
- Added Shirt vendor [ID: 50024
- Added Tabard vendor [ID: 50025]
- Added Miscellaneous vendor [ID: 50026]
- Added Off-hand vendor [ID: 50028]
- Added Season I vendor [ID: 50030-50032]
- Added Season II vendor [ID: 50033-50035]
- Added Season III vendor [ID: 50065]
- Added Mount vendor [ID: 50042 & 50043]
- Added Projectiles vendor [ID: 50044]
- Added Bags vendor [ID: 50045]
- Added Enchantment vendor [ID: 50047]
- Added Key vendor [ID: 50048]
- Added Currency vendor [ID: 50049]
- Added Cloak vendor [ID: 50050]
- Added Weapon vendor [ID: 50051]
- Added Shield vendor [ID: 50052]
- Added Libram/Idols/Totems vendor [ID: 50053]
- Added Shaman Totems [ID: 50054]
- Added Rogue Poisons [ID: 50055]
- Added Gem vendor [ID: 50056]
- Added Food & Drink vendor [ID: 50057]
- Added Scroll vendor [ID: 50058]
- Added Flasks vendor [ID: 50059]
- Added Elixirs vendor [ID: 50060]
- Added Potion vendor [ID: 50061]
- Added Feet vendor [ID: 50062]
- Added Wrist vendor [ID: 50063]
- Added Belt vendor [ID: 50064]

---

Code:

---

---

Shopping Mall pictures:
http://unfair.nl/WoWScrnShot_051308_011928.jpg
http://unfair.nl/WoWScrnShot_051308_010536.jpg
http://unfair.nl/WoWScrnShot_051308_010547.jpg
http://unfair.nl/WoWScrnShot_051308_010601.jpg
http://unfair.nl/WoWScrnShot_051308_011845.jpg
http://unfair.nl/WoWScrnShot_051308_011909.jpg

Extra:
- All items are free, no currency, no gold and also no sellprice.
- Dont forget to delete your cache folder first after importing this to make it 100% work!

Disclaimer:
- If you find a bug or something in this file please reply this topic.
- Thanks to Ascent Team

Should be realy great if someone can send me a SQL file of Brutal Gladiator set so i can
import it in the files so people cant actualy see Brutal Gladiator things in vendors.

BTW!: if you have installed Brutal Gladiator already and you install this file,
then your Brutal Gladiator items will be shown in Weapon vendor and some other vendor.
Also in Libram/Totem/Idol vendor.

i can't sell any thing form vendors :(

This tool will decrease ALL extend cost / gold cost / sell cost to 0

[EDIT:] If you want to be able to sell something i can help you.
Open notepad type this in notepad:

Code:

---

Update `items` set `sellprice` = '(Sellprice)' where `entry` between '1' and '9999999';

---

Where you see (Sellprice) put the sellprice you want for example 1.
Then everything in the world will be for 1 copper sell able.

If you just want to hold the blizzlike sellprice you need to wait for Rev1004 (uploaded tonight)
this will include this **fix** because i dont think is realy helpfull.

Quote:

---

Originally Posted by nokhba

i can't sell any thing form vendors :(

---

If you dont know how to use the tool you can open the HOW-TO-USE.txt
file that is included in the CV map.

Don't see it in the download?
thank's in advance =)

The HOW-TO-USE.txt is in the main map.
http://unfair.nl/giffys.gif

where is brutal gladiator ?

Normally you already needed to install it but now im uploading Rev101 with some updates and fixed. But with Rev101 (Tonight uploaded i guess)
there will be Brutal Gladiator items included + Vendor.

Quote:

---

Originally Posted by Wolfspring

where is brutal gladiator ?

---

Okey Rev102 is launched and will include the Brutal Gladiator items.
No worry if you already installed the tool will delete your old Brutal Gladiator items and import my one (blizzlike) and also fixed the duplicate error.
You only was getting the duplicate error if you installed rev100 and then install rev101.

For information rev 106 is released and will include just this fix:
- The buyprice of all items wont be set to 0 it will be blizzlike

Buyprice fix needed but otherwise nice good work!

erm.. whenever i try to execute your vendors it says weird duplicate error ...... this happens on all revision....but vendors are in DB anyways,but few of them got error:No sell items ,report to devs. Or something like that,in other words,vendors did not have items in them.(this happened to few vendors such as necklace and other .....)

Thanks for the release am not going to use but thanks m8

50027 - Off-hand

this npc doesnt work :( and can u make npcs for ingredance i mean for enchancing,scrolls and ingredance but for all profesions thanks !

ammm no sell template found.... ;/ what shall i do? all vendors exept tier1-6 report me this ;/

is it only for me or can no one download it?

i don't think this is updated with the newest OpenAscent creature_proto stuff

*Delete*

I get following error when I try to import it:

Code:

---

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `creature_proto` VALUES ('50000', '70', '70', '35', '303', '303', '0', '0.5', '4224', '1910', '0', '21', '27.09', '0', '0', '0', '0', '7439', '50267138', '781', '0', '0', '0', '0', '0', '0', '360000', '518', '0', '0', '0', '0', '0', '0', '1.5', '0.208', '0', '0', '0', '0', '0', '2.5', '8', '14', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

---

Using WhyDB with OpenAscent atm.

Updating it for newest creature_proto stuff would be nice.

i can probably add some stuff to creature_proto so it will work... dunno i'll try it, if i win i'll upload on Filebeam...

Alright, sorry for the double post... but use the vendor.sql insted of the one in the .rar pack


http://filebeam.com/4accb6199f143e7d054465550919876d

There you go, the vendor.sql is fixed... Run the sql in my folder insted of the one in
Astrup's
Just a fix nothing more

Seems to work fine, thank you. :)

EDIT:
I got this error when I try to talk with Off-hand Vendor:

Code:

---

No sell template found. Report this to devs: 50027 (Off-hand)

---

So I checked the code and noticed there are no

Code:

---

insert into `vendors` (`entry`, `item`, `amount`, `max_amount`, `inctime`) values(

---

for the 50027 ID (Off-Hand Vendor).
Could you please fix this?

EDIT:
Download link for the fixed file below.

Disculpen Si Estoy Hablando En Espa

Hey again, I'll upload my fixed release of the vendors.sql here.
I used BrantX's fix with creature_proto stuff and fixed the Off-Hand Vendor myself. Feel free to download and use.
So yeah, it'll will work, even the Off-Hand Vendor!

http://filebeam.com/85f7c088634d7c8634b7857169217e91

Thanks i changed it didnt know there were any bugs.
Thinked i tested all vendors, but looks like i didnt.
Thanks for the tip.

Quote:

---

Originally Posted by ghazul

Hey again, I'll upload my fixed release of the vendors.sql here.
I used BrantX's fix with creature_proto stuff and fixed the Off-Hand Vendor myself. Feel free to download and use.
So yeah, it'll will work, even the Off-Hand Vendor!

http://filebeam.com/85f7c088634d7c8634b7857169217e91

---