hey im makine a new server and id like to restart the database like delete all the legions and all that .... if you can help me it would be nice i dont feel like deleting it all one by one
DELETE from account.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;