[ASCENT][CUSTOM] GM Vendors

The vendors are spawns from 0-49 what is with the other vendors?

Quote:

---

Originally Posted by matei2me

can someone tell me the query for updating all items buyprice in a shop to 100g ... as the tier vendors don't have any prices.

---

hihi You'll need to do a bit of work here as you need to specify all the Item ID values in this...

Code:

---

UPDATE items SET itemextendedcost = '1000000' WHERE entry IN (ItemID, ItemID, ETC);

---

Or I'd try rerunning Channels script custom_shop_buyprice.sql again

Seg....

The error would seem to indicate that your table structure maybe wrong to import the dump file.

Have you run the query at the very start of this topic (page1) before attempting to run the custom shop stuff?

Quote:

---

Originally Posted by SERVER-X

The vendors are spawns from 0-49 what is with the other vendors?

---

I'm not following what you mean? Are the vendors 50 and upwards not spawning for you or is there some confusion that these vendors will be selling Recipes/Reagents

Only problem I have is when the NPC spawn they run around and try to kill stuff, but at least it works I guess.

Quote:

---

Originally Posted by Raptaur

hihi You'll need to do a bit of work here as you need to specify all the Item ID values in this...

Code:

---

UPDATE items SET itemextendedcost = '100' WHERE entry IN (ItemID, ItemID, ETC);

---

Or I'd try rerunning Channels script custom_shop_buyprice.sql again

---

for the UPDATE items SET itemextendedcost = '100' shouldnt it be 1000000....cause the 100 is the gold...you need to put in the silver and copper values in too. 100 would be 1s

100g 00s 00c

Quote:

---

Originally Posted by Bloodshed2007

for the UPDATE items SET itemextendedcost = '100' shouldnt it be 1000000....cause the 100 is the gold...you need to put in the silver and copper values in too. 100 would be 1s

100g 00s 00c

---

Thanks for the spot Blood, updated the code

Itemextendedcost refers to itemextendedcost.dbc, setting it 100 would correspond to... 100,0,0,24245,0,0x0,,,1,0,0,0,0, requirement of item 24245 to buy the item. Please don't try to be smart and set them like that... read itemextendedcost.dbc before making suggestions to people using my vendors, so that your info can atleast be accurate.

He wants everything to cost 100 gold or something, similar to a query like this:

Code:

---

UPDATE items SET buyprice = '1000000' WHERE entry IN (SELECT itemguid FROM vendors);

---

Quote:

---

Originally Posted by Raptaur

Seg....

The error would seem to indicate that your table structure maybe wrong to import the dump file.

Have you run the query at the very start of this topic (page1) before attempting to run the custom shop stuff?

---

yeap ... i did ... the thing is i use ascent 989 because any higher core will make at the start of ascent.exe to say that creature_loot is using old don't know ... and there are no npc on the server ... so i'm using this core with Rev 8 ... but that character erorr always appear


sorry for my bad english

Quote:

---

Originally Posted by channel_49

Itemextendedcost refers to itemextendedcost.dbc, setting it 100 would correspond to... 100,0,0,24245,0,0x0,,,1,0,0,0,0, requirement of item 24245 to buy the item. Please don't try to be smart and set them like that... read itemextendedcost.dbc before making suggestions to people using my vendors, so that your info can atleast be accurate.

He wants everything to cost 100 gold or something, similar to a query like this:

Code:

---

UPDATE items SET buyprice = '1000000' WHERE entry IN (SELECT itemguid FROM vendors);

---

---

thanks a lot i kinda knew this was it i just wanted to be sure.. anyone that can tell me all tier guids ?
the thing is i wanna make
1. all tier 3 pieces cost 40g
2. all tier 4 pieces cost 60g
3. all tier 5 pieces cost 80g
4. all tier 6 pieces cost 100g

i have to write 4 queries and put all guid items from that shop. does anyone did this before? si i don't have to work that much ? :-s :D

Here you go:

Code:

---

UPDATE items SET buyprice = '400000', itemextendedcost = '0' WHERE entry IN (SELECT itemguid FROM vendors AND vendorguid = '50005');
UPDATE items SET buyprice = '600000', itemextendedcost = '0' WHERE entry IN (SELECT itemguid FROM vendors AND vendorguid = '50006');
UPDATE items SET buyprice = '800000', itemextendedcost = '0' WHERE entry IN (SELECT itemguid FROM vendors AND vendorguid = '50007');
UPDATE items SET buyprice = '1000000', itemextendedcost = '0' WHERE entry IN (SELECT itemguid FROM vendors AND vendorguid = '50008');

---

thanks a lot.. this is very helpfull... i thought i had to update all items id to to buyprice which will have resulted in a lot of work.very good solution, change all items in a vendor :D.. thanks a lot

NEW ISSUE
how can i save a sql with the vendors that i spawn in-game as i delete the database very often to upgrade it..... i mean how can i make a sql batch file with my spawns form in-game... assuming i spawn them in game cause i don't know coordonates to use in vendor_custom_spawn.sql.... get it ?

Here:

Code:

---

SELECT * FROM creature_spawns WHERE entry BETWEEN '50000' AND '50080';

---

Then export, only problem is that when you spawn my vendors, theres a delete query, so just dont use my spawn query anymore if you have your own.

i'm just gonna delete

Code:

---

DELETE FROM creature_spawns WHERE entry BETWEEN '50000' AND '50080';

---

form u;r spawns as i would like them in gm island too .... thanks a lot

Channel_49
there is a bug in your change display query that comes with 3.0a.

You included creature_proto instead of creature_names.

It should look like this...

Code:

---

UPDATE creature_names SET displayid = '21178' WHERE entry between '50000' and '50080';
UPDATE creature_spawns SET displayid = '21178' WHERE entry between '50000' and '50080';

---