Editing MYSQL... Need command

[Enxorix]

Hello!
We maked a new bolt in our server. (Replaced piercing bolt) and then we forgotten to take away "Conjure piercing bolt" what a mess...:blink:
Is it any command that will set all that got over 1 bolt to 1

So if anybody got 100 bolts in his depot it will turn in to 1 bolt.. same in player backpack..
When i set only 1 item.. if i search and only change the "Count" this command will pop up:huh:

UPDATE `otserv`.`player_items` SET `count` = '1' WHERE `player_items`.`player_id` =311 AND `player_items`.`pid` =124 AND `player_items`.`sid` =135 AND `player_items`.`itemtype` =7363 AND `player_items`.`count` =100 AND `player_items`.`attributes` LIKE 0x0f64 LIMIT 1 ;

and it's many guys that got over Count 100.. so it's really hard to sit and change all this by hand...

Could some 1 get an command that will turn all the "Stacks in to count 1" in depot/Backpack??

Sorry for my bad english xD

 

[Don Daniello]

Backup database and execute:

UPDATE `otserv`.`player_items` SET `player_items`.`count` = '1' WHERE `player_items`.`itemtype` = 7363;

This will (should) change every piercing bolt (or sth with its id) to count 1.

 

[EvulMastah]

Why not just delete all of them:

DELETE FROM `player_items` WHERE `itemtype` = 7363;

 

[Don Daniello]

Because he doesn't want to ?
He wrote

 

[Enxorix]

thanks i just want to change all counts to 1..

 

[Enxorix]

Depotitems

UPDATE `otserv`.`player_items` SET `player_items`.`count` = '1' WHERE `player_items`.`itemtype` = 7363;

i want it to change in player_depotitems also. can't se an "depot" word anywhere in that code xD
is it just to change the Player_items to player_depotitems Like this

UPDATE `otserv`.`player_depotitems` SET `player_depotitems`.`count` = '1' WHERE `player_depotitems`.`itemtype` = 7363;

 

[Don Daniello]

yes it is