[ASCENT][CUSTOM] GM Vendors

[[Shon3m]]

For version 3.0a to work, you have to get ascent 1132 or higher!

Ascent 1132 requires you to update your tables:

ALTER TABLE creature_proto CHANGE health minhealth int(30) unsigned NOT NULL;
ALTER TABLE creature_proto ADD column maxhealth int(30) unsigned NOT NULL AFTER minhealth;
UPDATE creature_proto SET maxhealth = minhealth;
ALTER TABLE creature_proto CHANGE level minlevel int(30) unsigned NOT NULL;
ALTER TABLE creature_proto ADD column maxlevel int(30) unsigned NOT NULL AFTER minlevel;
UPDATE creature_proto SET maxlevel = minlevel;
ALTER TABLE creature_proto ADD column invisibility_type int(30) unsigned NOT NULL;
ALTER TABLE creature_proto ADD column death_state int(30) unsigned NOT NULL;

Requirements:
Ascent Core 1132 or higher: http://forum.ragezone.com/f114/lates...atabase-287088
NCDB


Installation:
1) Download and install an Ascent database.
2) Download and extract the attached zip file in this post.
3) Go to your sql manager, such as Navicat or SQLyog.
4) Right click your database and Execute Batch File (Navicat) or Restore From Sql Dump (SQLyog).
5) Run the extracted .sql file as a query.
6) After installing all these, restart your server.
7) Navigate to your WoW folder, and delete the cache folder.
Once ingame, type .npc spawn (ID) to spawn the vendors at your location.
9) The npc IDs can be found in this post, if you scroll down.
Remember to delete CACHE folder from wow client after installing.

Changelog:

Version 2.7:
Changed displayids to blood elves >.>.
Added keys vendor.

Version 2.8:
Resized vendors to same size as normal npcs.
All vendors have been spawns in the HOUSE of GM Island.
Added custom_shop_spawn.sql.

WARNING: the spawn query will first delete ALL spawn of
GM vendors, make sure you either back them up or just
delete the first line of the query.

Version 2.9:
Added custom_shop_buyprice_extend.sql so people can get rid of itemextendedcost.
Revised custom_shop_buyprice.sql so now it should run fast, and
you won't get anymore freezes or wait time.

Version 2.9a:
Fixed a tiny bug in the custom_shop_buyprice_extend query.

Version 3.0:
Changed a few spawns around, removed recipe/reagent from spawns
because they are taking too much space inside the house for future
spawns. Not a lot of people need vendors that specific anyways, so
if you want them spawn them yourself.
Made vendors compatible with latest ascent core (1132 and higher),
you will have to update your database with the query posted above.
Added enchantment and off-hands vendors.

Version 3.0a:
Always forget that damn table name in spawn query, added.
Added in custom_shop_display.sql, change your own displayids.



Vendors (71):
50000 Armor Dungeon I
50001 Armor Dungeon II
50002 Armor Dungeon III
50003 Armor Raid Tier I
50004 Armor Raid Tier II
50005 Armor Raid Tier III
50006 Armor Raid Tier IV
50007 Armor Raid Tier V
50008 Armor Raid Tier VI
50009 Armor Wrist
50010 Armor Waist
50011 Armor Feet
50012 Armor Shield
50015 Weapon Level 50+
50016 Weapon Level 60+
50017 Weapon Level 65+
50018 Weapon Level 75+
50019 Weapon Level 100+
50020 Armor Necklace
50021 Armor Rings
50022 Armor Trinket
50023 Armor Cloak
50024 Armor Shirt
50025 Armor Tabard
50026 Armor Miscellaneous
50028 Armor Off-Hands
50029 Armor Libram/Idol/Totem
50030 Arena Season I
50031 Arena Season I
50032 Arena Season I
50033 Arena Season II
50034 Arena Season II
50035 Arena Season II
50040 Misc Gemstone I
50041 Misc Gemstone II
50042 Misc Mount I
50043 Misc Mount II
50044 Misc Projectile
50045 Misc Container
50047 Misc Enchantment
50048 Misc Key
50049 Misc Currency
50050 Recipe Book A-Z
50051 Recipe Leather A-F
50052 Recipe Leather G-R
50053 Recipe Leather S-Z
50054 Recipe Tailor A-G
50055 Recipe Tailor H-Z
50056 Recipe Engineer A-Z
50057 Recipe Blacksmith A-F
50058 Recipe Blacksmith G-R
50059 Recipe Blacksmith S-Z
50060 Recipe Cooking A-Z
50061 Recipe Alchemy A-Z
50062 Recipe Enchant A-G
50063 Recipe Enchant H-Z
50064 Recipe Jeweler A-K
50065 Recipe Jeweler L-Z
50066 Reagent Leather I
50067 Reagent Leather II
50068 Reagent Tailor I
50069 Reagent Tailor II
50070 Reagent Engineer I
50071 Reagent Engineer II
50072 Reagent Blacksmith I
50073 Reagent Blacksmith II
50074 Reagent Cooking
50075 Reagent Alchemy
50076 Reagent Enchant
50077 Reagent Jeweler
50078 Reagent Miscellaneous

 
custom.shop.2.7.zip (23.1 KB, 706 views)custom.shop.2.8.zip (24.3 KB, 342 views)custom.shop.2.9a.zip (47.3 KB, 639 views)custom.shop.3.0a.zip (48.0 KB, 1687 views)

Credits:
Credits partially to AMVendor creators for their concept and
Dungeon Set 1-3 and Tier 1-6, everything else (rings,
trinkets, weapons, etc) I re-did or added, even the organization of
the armor sets I revamped. I also moved the vendor IDs to 50000+
to avoid taking up important NPC ids, and changed other details.

Also Props Go To Channel_49 Good Work Man

[Remahlól]

Very nice Soularis. (Give it Fr00gle, I want to see that at the server^^)

[Entr0py]

mmm
looks pretty hawt
btw were u get that butsecks thing?utemontheglass:

[KRAZY2K7]

Hey,

Awesome vendors but i get error when using on newer ascent rev & db. Cant figure it out, tried updating query for latest rev etc but no joy.



Ascent r1602 : NCDB Milestone 0.2

[[Shon3m]]

i know a fix is coming soon

[Chase]

really cool guide, i'll have to try this

[viper1745]

how can i get these GM Vendors?

[jobba7]

Looks good im gonna have to try this.

[30480]

DOnt these come with all the databses?

[[Shon3m]]

Not all the DB's....Froogle Has A fix For The BtW

[Fatjoe]

could you uploade it somewhere else please?