querying sql using sqlyog
hi ...i don't post very much and when i do post its usually after extensive research on my own ...
i have searched all over this forum and haven't found it...
But, what i need is to learn how to query in sqlyog to change cool times for potions and delay times for weapons.
Yes, i could do it one at a time but that is very extensive work not that i mind that except for i forget which i have changed and which i have opted to leave alone.
i play the server by myself so i want to learn how to query not have it done for me as i feel its more fun learning than actually playing the game ...so if you could please tell me how i should type this into the query window to change specific fields all help appreciated thx everyone :tongue:
thx for the help anyway i know you guys are busy but i found it in an old post and FTR: i will post what i found so others can see
to change specific fields in a batch type command just type
update "field name" (without quotes) set "field name" = arguement
example UPDATE item_template SET delay = delay /2 it should be similar to that
where delay would be divided in half ...that is the attack speed of weapons by the way ...well some of them anyway