[ASCENT][CUSTOM] GM Vendors

Quote:

---

Originally Posted by channel_49

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');

---

---

it doesn't work :|
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND vendorguid = '50005')' at line 1
(0 ms taken) any suggestions ? i think the code si bad the db has no problems

Sorry... bad query :P

Code:

---

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

---

when i run the querys it block my sqlyog when i try to close it it says
"query are executing. could not close connection" what should i do?
can someone test this for me please :-s

use navicat it doesnt crash, i have had this problem and so have others

thanks

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);

---

---

Sheesh, calm... I wasn't trying to be smart, unsure how you came to that conclusion unless you think that trying to help out is being some sort of smart ass?
I like your work, so thought to repay by helping out. I use SQL everyday among other things (unfortunate carer choice) I didn't have the TDDB setup here at work but I'll look to install it locally on my laptop (SQL2000) to keep me right for referencing any help I give

Apologies bad query, I did looked at the wrong DBC...

Quote:

---

Originally Posted by seg

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

---

Ahh okay then you also want to run this piece as well. http://forum.ragezone.com/f114/ascen...update-290271/ I'm using Ascent core 1141, holding up really well so far

abc

Use the new cores with all the patches, 1071, 1132, etc.

Quote:

---

Originally Posted by channel_49

Use the new cores with all the patches, 1071, 1132, etc.

---

From what version and above are the new cores channel?

1132 has all the new table updates

Channel,
have you ever thought of adding a totem vendor?
and in the next version add the blacksmith hammer to the reagent vendor as i manually dun it on the 3.0a version when some1 on my server was asking were it was

Hi Is there a vendor that sells enchants (that everyone can use without being a enchanter ) ... like in the afgan warriors repack for 1.12 casue that would be sweet ;) It came in a package that tad the required rod needed, the mats and a stone that you clicked on to enchant the particular enchant.

Use permenant enchants.

How come whenever I put your custom items in my DB whenever i log on all the monsters are x1000 bigger?!?!?


I tried it with every single DB I knew of and all the versions of antrix... STILL it doesn't work!