making all items buy and sell for free through navicat
also i have rivalDB
Edit: also how would i make all spells from trainers freeeeeeee
Another Edit: How do i make talent reset free
All Help Appreciated
making all items buy and sell for free through navicat
also i have rivalDB
Edit: also how would i make all spells from trainers freeeeeeee
Another Edit: How do i make talent reset free
All Help Appreciated
Last edited by Supah; 07-01-2009 at 08:53 PM.
Make an sql script that does that, or go through and set the buy and sell price to 0 in the database (im guessing there is a buy and sell column)
well i know u can make a sql script that does it but what exactly would it look like..
That i can't help you with, (can't remember) you could just go into navicat and manually press 0 in each column
do you know how many items there are ...?
UPDATE `items` SET `sellprice` = 0 WHERE `entry` > 0
UPDATE `items` SET `buyprice` = 0 WHERE `entry` > 0
Although i think you get an error where "The merchant does not want that item", Due to the sell price being the same as the buy price, or something.
If you do get that error ingame, just set sellprice to 1 instead.
UPDATE `trainer_spells` SET `spellcost` = 0 WHERE `entry` > 0Edit: also how would i make all spells from trainers freeeeeeee
Or something like that. might get a syntax error.
Another Edit: How do i make talent reset free
I think this is something you have to edit in the core? :S
ty so much i knew the script was simple just wasnt quite sure exactly how it went but ya +Rep