Please help

04/11/2011 19:23 sharq#1
Please help
I need to explain how clean the database of all past users

I need code only and does not need any other code please who knows the code does not spare us its
04/11/2011 19:35 Jack Sparrow#2
Search!
Code:
DELETE from my.account;
DELETE from my.cq_user;
DELETE from my.cq_eudemon;
DELETE from my.cq_item;
DELETE from my.cq_ad_log;
DELETE from my.cq_announce;
DELETE from my.cq_castle;
DELETE from my.cq_castleitem;
DELETE from my.cq_castlemap;
DELETE from my.cq_deluser;
DELETE from my.cq_donation_dynasort_rec;
DELETE from my.cq_dyna_rank_rec;
DELETE from my.cq_enemy;
DELETE from my.cq_family;
DELETE from my.cq_flower;
DELETE from my.cq_friend;
DELETE from my.cq_magic;
DELETE from my.cq_partner;
DELETE from my.cq_pk_bonus;
DELETE from my.cq_shortcut_key;
DELETE from my.cq_special_status;
DELETE from my.cq_statistic;
DELETE from my.cq_synattr;
DELETE from my.cq_syndicate;
DELETE from my.cq_trade;
DELETE from my.cq_tutor;
DELETE from my.cq_tutor_contributions;
DELETE from my.e_money;
Update cq_dynanpc set datastr = 'None', owner_name = default_owner_name, ownerid = 0 where ownerid > 9999;
Update cq_dynanpc set datastr = 'None', owner_name = default_owner_name, ownerid = 0, price = initial_price, deposit = 0 where ownerid > 9999;
04/12/2011 08:22 sharq#3
Thank you for your interest in the topic
04/12/2011 10:16 javairc#4
Quote:
Originally Posted by sharq View Post
Thank you for your interest in the topic
Was
There are mistakes and I, a

ERROR 1146 : Table 'account.cq_dynanpc' doesn't exist
ERROR 1146 : Table 'account.cq_dynanpc' doesn't exist

What is the solution
Please attention
just put this query dont added account at front cq_dynanpc

Code:
Update cq_dynanpc set datastr = 'None', owner_name = default_owner_name, ownerid = 0 where ownerid > 9999;
Update cq_dynanpc set datastr = 'None', owner_name = default_owner_name, ownerid = 0, price = initial_price, deposit = 0 where ownerid > 9999;
04/13/2011 08:49 sharq#5
Thank you for your interest in the topic
04/13/2011 14:10 cruey#6
Quit spamming the forum -_-
04/13/2011 16:04 -+Sezzy+-#7
Search can be located here- [Only registered and activated users can see links. Click Here To Register...]