Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Ascent [ASCENT][CUSTOM] GM Vendors

Skilled Illusionist
Joined
Jun 6, 2007
Messages
380
Reaction score
0
Version 3.1a
Server I am now working for: http://forum.ragezone.com/showthread.php?t=405096


Contact:
MSN: channel.49@gmail.com | Email: channel.49@gmail.com


Requirements:
Ascent Core and NCDB 1158+


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.
8) 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 3.1:
Compatible with new database structure.
Content update will come soon.

Version 3.1a:
Attempt to fix the vendor access bug.

Added buyprice query, this only makes items have 5x sellprice as buyprice.
Anything that have 0 sellprice obviously won't get a buyprice.

Added tier buyprice query, this allows you to make raid tier 1-6 items cost gold.
Default settings are T1: 100g, T2: 125g, T3: 150g, T4: 175g, T5: 200g, T6: 250g.


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


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.
 

Attachments

You must be registered for see attachments list
Last edited:
Junior Spellweaver
Joined
Jun 21, 2007
Messages
126
Reaction score
0
Well I still look forward to your once and a while release. :D
 
Newbie Spellweaver
Joined
Jul 2, 2007
Messages
47
Reaction score
0
I assume you will still be taking and evaluating suggestions for these vendors?
 
Skilled Illusionist
Joined
Jun 6, 2007
Messages
380
Reaction score
0
I am also making a list of new features that should be implemented in the next release, and it would help
if anyone has ideas and will post here.

Yes, I'll be taking suggestions and possible new features for the vendors.
 
Last edited:
Junior Spellweaver
Joined
Jun 21, 2007
Messages
126
Reaction score
0
Yah Channel Here is an Idea Change the Display ID's those Vendors Are annoying.
 
Skilled Illusionist
Joined
Jun 6, 2007
Messages
380
Reaction score
0
Gimme another "neutral" npc that isnt involved in either side and i'll change it to that displayid. I put it as naaru cuz of that.
 
Last edited:
Initiate Mage
Joined
Aug 9, 2007
Messages
4
Reaction score
0
hmm when i spawn a vendow and click to buy something, nothing happens. I hover the mouse over it, the cursor changes to the brown bag and when I go to click on it, nothing happens. Any ideas?

EDIT: This occurred after I installed the vendors
 
Last edited:
Skilled Illusionist
Joined
Jun 6, 2007
Messages
380
Reaction score
0
I havn't exacted tested this with the latest ascent cores. I'll do it soon.
 
Last edited:
Initiate Mage
Joined
Aug 9, 2007
Messages
4
Reaction score
0
ok ty, also to note my char's start out naked.

In the mean time ill downgrade my core so this will work

EDIT: Tried a different core and still nothing, also tried a random vendor in a main city and received same error as I did earlier so I'll try redo'n my db and see if this works
EDIT: 2.61.zip crashes my comp
EDIT: nvm 2.61 works installing but in game couldn't add the vendors, and they were in my db so re installing db 2.5 first, test that then update to 2.61
EDIT: sigh nvm everything works, kept doing .npc add >.>
 
Last edited:
Skilled Illusionist
Joined
Jun 6, 2007
Messages
380
Reaction score
0
2.61 was messed and meant for rev7, so heres 2.62 for rev8.

I still need more ideas before I release a next version, just keys is too little.
 
Last edited:
Newbie Spellweaver
Joined
Aug 9, 2007
Messages
8
Reaction score
0
2.62 for rev 8 does not have any prices put in for anything on any vendors. please can you fix this ?
 
Skilled Illusionist
Joined
Jun 6, 2007
Messages
380
Reaction score
0
If you have rev8 it shouldn't be.
 
Last edited:
Newbie Spellweaver
Joined
Aug 9, 2007
Messages
8
Reaction score
0
I installed rev 8 with no other patches then did you 2.62 with no other modifications and no prices what so ever are listed. I used your links as well for Rev 8 and your file.
 
Newbie Spellweaver
Joined
Aug 9, 2007
Messages
8
Reaction score
0
Ok, double checked.

Total dump and deletion of my database again, nothing left, recreated ascent db imported REV 8 then missing character tables. then imported your 2.62 file.

lauched ascent, logged in .npc spawn 50020 no prices, 50021 no prices did a few others all not a single price what so ever.

something is missing.

update: my friend tried it on his server, got same problem I have, no prices for anything, he dropped and redid his database just to make sure as well and same issue is on his as it is on mine.

Any possible fixes ?


Update: tried Rev7 with 2.5 works beautiful.. no issues, upgrade that database to rev8 with 2.62 dead no go no prices. something messed up for sure. trying rev 7 db with 2.62 for the hell of it lol.


OK, REV7 with 2.62 works, all vendors have prices and seem to work fine, try it out thanks again main love it ... well after lots of testing outlands instances dont work now.. ports you out.
 
Last edited:
Newbie Spellweaver
Joined
Aug 9, 2007
Messages
56
Reaction score
0
Could you send me the database with the vendors and items and stuff included in it coz somehow i just cant execute the vendor sql file into the database? : D
 
Skilled Illusionist
Joined
Jun 6, 2007
Messages
380
Reaction score
0
I found why the prices weren't working. I have totally forgot I revamped the rev8 buyprices to fit to official, which means items that arnt suppose to be in the vendor shouldn't have a buyprice, according to wowhead vendor values. However, I included a query that should possibly fix items in the custom GM vendor, this was the original query which I took out, but now put back in. I seperated it because when you run this query it will take a very long time, so I put it in a different file.
 
Last edited:
Initiate Mage
Joined
Feb 18, 2007
Messages
3
Reaction score
0
The price of purchase of reagents at GM sellers in 5 times below what sale of these reagents it. A quite good way to grow rich for players!!! How it to correct?

Sorry for my bad english....
 
Back
Top