How would I go about...

[Supah]

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

[rahburt33]

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)

[Supah]

well i know u can make a sql script that does it but what exactly would it look like..

[rahburt33]

That i can't help you with, (can't remember) you could just go into navicat and manually press 0 in each column

[Supah]

do you know how many items there are ...?

[Vision1000]

making all items buy and sell for free through navicat

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.

Edit: also how would i make all spells from trainers freeeeeeee

UPDATE `trainer_spells` SET `spellcost` = 0 WHERE `entry` > 0

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

[Supah]

ty so much i knew the script was simple just wasnt quite sure exactly how it went but ya +Rep