[help] Shop flags and Castles owners

[zspider]

can any one right script to remove shop flags and castles old owners i tried every rest DB script here and non one of them work for that can any one tell me
thank you

[Knight^Hawk]

sure i will when i get home from my walk.


Edit: couldnt figure out how to make a easy UPDATE script lol but here it is.

[King_Arthur]

Did you try this?

Originally Posted by King_Arthur

Update cq_dynanpc set datastr = 'None', owner_name = default_owner_name, ownerid = 0, price = initial_price, deposit = 0 where ownerid > 9999;

[Knight^Hawk]

wouldnt u hav to do one for every ID king?

[King_Arthur]

Originally Posted by Knight^Hawk

wouldnt u hav to do one for every ID king?

Nope mines all in one. It finds anything owned by a player (where ownerid > 9999)

[Knight^Hawk]

did not know that u can use > or < in a query ^^

[King_Arthur]

Originally Posted by Knight^Hawk

did not know that u can use > or < in a query ^^

*tip toes slightly off topic* Yes there are plenty of operators available in mysql:

[Knight^Hawk]

Update cq_dynanpc set datastr = 'None', owner_name = 'None', default_owner_name = 'None', ownerid = '0' where name ='Castle'; 

or 
for every id

Update cq_dynanpc set datastr = 'None', owner_name = 'None', default_owner_name = 'None', ownerid = '0' where id < 99999999;

these might be more useful to ur needings zspider

some credits go to King_Arthur

[zspider]

ok guys all this script just change the owners name of Shop flag and castles from owner name to None and don't remove it's prize how to remove it's old prize and make with normal prize

[King_Arthur]

Originally Posted by zspider

ok guys all this script just change the owners name of Shop flag and castles from owner name to None and don't remove it's prize how to remove it's old prize and make with normal prize

I never thought of that! Thanks.

Updated script:

Update cq_dynanpc set datastr = 'None', owner_name = default_owner_name, ownerid = 0, price = initial_price, deposit = 0 where ownerid > 9999;