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

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
Wasn`t it also in the cq_donation_dynasort_rec?
Quote:
Originally Posted by PraDevil
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

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