Most visitors online was 12720 , on 2 May 2024
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature currently requires accessing the site using the built-in Safari browser.
Your work is good! I am happy! Thx you!Actually, those reagents are supposed to be for sale in the first place? Look at wowhead, these vendors are meant for GMs. If you're using them for players I've already done a lot to work along with that, if you're gonna complain about details, I might as well not do anything for it at all.
Be happy with what you get... if you're not happy with it, go fix it yourself.
UPDATE items SET buyprice = (sellprice/5) WHERE entry IN (SELECT itemguid FROM vendors WHERE vendorguid BETWEEN '50000' AND '50080');
oh... is there any way to make them free that i don't have to pay anything?Do you have the correct "items" to buy T6? If you look closely at the T6 gear, they have a piece of armor you need in order to buy it. You can get those in the Misc Currency vendor.
So from what table do i edit them? : Dcool great work...
not sure about answering your quest...i think u need to set the 'ItemExtendedCost; to 0 for those items..i might be wrong...
For me it freezes aswell but i w8'd for a wile then i should be ready. so if it freezes let it be then it'll be ready after a wile. : Dyes, me too, the item sell price query freezes the entire SQLYog and even worse, it deletes all the vendors...
a while? are you kidding me? i waited over 1/2 an hour! AND I HAVE 2GB RAM. ??? whats up with this?For me it freezes aswell but i w8'd for a wile then i should be ready. so if it freezes let it be then it'll be ready after a wile. : D
Channel_49 i have TNDB 8 And custom vendors 7.1 but in T4-6 vendors when i try to buy something it says that item not found. Could you pls advise what to do coz i have tried to drag the items to bag and right clicked but it says item not found?
UPDATE items SET itemextendedcost = '0' WHERE entry IN (SELECT itemguid FROM vendors WHERE vendorguid BETWEEN '50000' AND '50080';
a while? are you kidding me? i waited over 1/2 an hour! AND I HAVE 2GB RAM. ??? whats up with this?
Yes... Please help to us... :S It freeze my computer PLEASE
For me it freezes aswell but i w8'd for a wile then i should be ready. so if it freezes let it be then it'll be ready after a wile. : D
when i Run query its just UPDATE items SET buyprice = (sellprice/5) WHERE entry IN (SELECT itemguid FROM vendors WHERE vendorguid BETWEEN '50000' AND '50080'); then i get Processing and it is stuck i think