help to delete all acc from donate

03/08/2010 09:39 gege2900#1
i need to delete all accs in donation rank
can any1 tell me how plz (look at pic )
03/08/2010 10:19 PraDevil[ELITE]#2
Code:
delete from my.cq_donation_dynasort_rec;
update cq_user set donation = 0;
update cq_user set nobility_rank = 0;
03/08/2010 22:25 magewarior2#3
Quote:
Originally Posted by PraDevil View Post
Code:
delete from my.cq_donation_dynasort_rec;
update cq_user set donation = 0;
update cq_user set nobility_rank = 0;

Wasn`t it also in the cq_donation_dynasort_rec?

Delete Name`s from there. :bandit:
03/08/2010 22:31 King_Arthur#4
Quote:
Originally Posted by magewarior2 View Post
Wasn`t it also in the cq_donation_dynasort_rec?
Quote:
Originally Posted by PraDevil View Post
Code:
delete from my.cq_donation_dynasort_rec;
update cq_user set donation = 0;
update cq_user set nobility_rank = 0;
Delete Name`s from there :bandit:
my.cq_donation_dynasort_rec is the same thing as cq_donation_dynasort_rec. The "my." part means inside the "my" database.
03/08/2010 22:31 .Ash#5
Quote:
Originally Posted by PraDevil View Post
Code:
delete from my.cq_donation_dynasort_rec;
update cq_user set donation = 0;
update cq_user set nobility_rank = 0;
Or if you want to do it for specific person, its

Code:
update cq_user set donation = 0 where id='ID';
update cq_user set nobility_rank = 0 where id='ID';

Cant test right now.. Dont have a DB..O_O
03/08/2010 22:37 ~WARNING~#6
actually i believe it would be something like this

Code:
update cq_user set donation = 0 where name='USERNAME';
update cq_user set nobility_rank = 0 where name='USERNAME';
makes it easier because you don't have to find their ID
03/09/2010 06:21 PraDevil[ELITE]#7
i think gege want "delete all acc from donate" not one ,two, three, four..hehe..
03/09/2010 10:48 evilminded1981#8
if u are still the only one on the server and want to clear them all right click on cq_donation_dynasort_rec and empty table. That will clear them all but if u have accounts in it and ur not the only one then u would want to do the query that they have gave u then do it. An to be truth full u dont have to delte the records in user name. But doing so makes it more creditable and u want