help to delete all acc from donate

[gege2900]

i need to delete all accs in donation rank
can any1 tell me how plz (look at pic )

[PraDevil[ELITE]]

delete from my.cq_donation_dynasort_rec;
update cq_user set donation = 0;
update cq_user set nobility_rank = 0;

[magewarior2]

Originally Posted by PraDevil

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.

[King_Arthur]

Originally Posted by magewarior2

Wasn`t it also in the cq_donation_dynasort_rec?

Delete Name`s from there

my.cq_donation_dynasort_rec is the same thing as cq_donation_dynasort_rec. The "my." part means inside the "my" database.

[.Ash]

Originally Posted by PraDevil

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

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

[~WARNING~]

actually i believe it would be something like this

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

[PraDevil[ELITE]]

i think gege want "delete all acc from donate" not one ,two, three, four..hehe..

[evilminded1981]

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