Ascent [ASCENT][CUSTOM] GM Vendors

[COPZone]

channel_49 pls answer me...

Whether there is an opportunity to make so that all recipes which have no price of purchase (them much) would become with by?

 

[channel_49]

 UPDATE items SET buyprice = '0' WHERE entry in (SELECT itemguid FROM vendors WHERE vendorguid BETWEEN '50000' and '50080');

That makes all items in custom shop free.

 

[KingXCrosses]

EDIT:nvm.....
i also suggest using Navicat, works better

 

[channel_49]

EDIT:nvm.....
i also suggest using Navicat, works better

Yea, definately

 

[kirbysayshi]

Well, I guess it must be from when I update to rev8 from rev7 then, and not the custom vendors.

 

[Frantt]

@Frantt: Err spirithealers? What db are u using.

I was useing the terranet DB rev8 but that didnt work so i switched out to use the wow.rockon.no database and added your custon vendors and it still didnt work.

Could it be a problem with the DBC files?

 

[KingXCrosses]

what npc entry did you type when u spawn them?
for example .npc spawn *****
what did you put in the ***** part?

 

[channel_49]

Could indeed be missing dbc or older dbc, try 2.1.3 dbc files.

 

[KingXCrosses]

btw....check out a little vendor area i made

good job channel_49

 

[Frantt]

can one of u guys make a dump of your Item.sql ?

 

[channel_49]

If anyone can spawn the vendors perfectly on gm island I think I can include a spawn list in the release.

 

[KingXCrosses]

what do you mean channel?
(btw frantt, i posted 2 dump files on ur other topic)

 

[channel_49]

If someone can spawn them perfectly in gm island, I'll include it in the next release (the spawns) and give credit.

 

[KingXCrosses]

how can i give you those? i made 2 platforms above GM island, (in case someone wants to use the building for something else) and put all the vendors on them, but idunno how to get and give you the files :\

p.s. i can give you it in a few hours, i gtg somewhere

 

[channel_49]

Spawn them in the house or something

 

[KingXCrosses]

but how can i send you them? cuz idk how to do that

anyways, heres a screenshot of the whole vendor area with closer screenshots

 

[channel_49]

Yea but I dont have those platforms and a lot of other people dont either, so if u can spawn them on the standard gm island, possibly in the house, and use this query:

Select * from creature_spawns where entry between '50000' and '50080';

But either way, I can do it myself.

 

[SirKhan]

sorry to go off topic, but kingxcrosses what is the id for the platform you that you used for gm shops? = )

p.s. i know there are private messages but sometimes people dont check those...

 

[channel_49]

I put these vendors on svn in a custom content folder for TNDB, not sure if we would want to pack them with TNDB, but we'll see, I guess its always convient to include some custom features that the users can manually add to the clean db after installation, since the two are seperate.

 

[DEMONZ]

great job as usual channel. i changed the display id's of the vendors to A'dal, that huge crystal thing in shattrath lol. i like the blood elves but they kinda creeped me out