Cleaning my DB and maybe Game

[newhere 0]

Hey, i have a simple Question.

I bought game and db long time ago.

There were some Accounts/Players at the beginning i deleted manual (no code) only in player/player etc.

is there a way to check or clean stuff like this?

i mean how can i clean a db?

[lollipotter 3]

At the normal way you can clean your database manual or with SQL-Statements.

If you have to do it often, you can write a script or an application which checks and deletes.

For showing the data inside the tables you want to clean just use the SELECT statement.

For deleting just rows in a table you can use the DELETE FROM Statement with specyfying what to delete.

If you want to clear a whole table you can use the TRUNCATE Statement if you have no foreign keys to other tables.

I hope this was what you want to hear.

I dont know if there is already some script or application which does this, because normally its not this much work to clean the database manually.

 

Edit: Please make sure you clean the Guild Mark symbols also, that you dont have guild symbols from old guilds of old servers into your new guilds.

[newhere 0]

Thanks for your answer. This will help me a lot cause im noob at this part.

 

The thing with the Guild mark symbols is a good example for what i asked

[tierrilopes 447]

Some stuff to clean your db:

TRUNCATE TABLE account.account;
TRUNCATE TABLE common.gmlist;
TRUNCATE TABLE log.attr_transfer;
TRUNCATE TABLE log.bootlog;
TRUNCATE TABLE log.change_name;
TRUNCATE TABLE log.command_log;
TRUNCATE TABLE log.cube;
TRUNCATE TABLE log.dragon_slay_log;
TRUNCATE TABLE log.dragonlair_dungeon;
TRUNCATE TABLE log.exo_bank_log;
TRUNCATE TABLE log.fish_log;
TRUNCATE TABLE log.gmhost;
TRUNCATE TABLE log.gmlist;
TRUNCATE TABLE log.goldlog;
TRUNCATE TABLE log.hack_crc_log;
TRUNCATE TABLE log.hack_log;
TRUNCATE TABLE log.ingame_ban_log;
TRUNCATE TABLE log.levellog;
TRUNCATE TABLE log.locale;
TRUNCATE TABLE log.locale_bug;
TRUNCATE TABLE log.log;
TRUNCATE TABLE log.loginlog;
TRUNCATE TABLE log.loginlog2;
TRUNCATE TABLE log.meley_dungeon;
TRUNCATE TABLE log.money_log;
TRUNCATE TABLE log.okay_event;
TRUNCATE TABLE log.pcbang_loginlog;
TRUNCATE TABLE log.quest_reward_log;
TRUNCATE TABLE log.refinelog;
TRUNCATE TABLE log.sash;
TRUNCATE TABLE log.shout_log;
TRUNCATE TABLE log.speed_hack;
TRUNCATE TABLE log.voucher_log;
TRUNCATE TABLE log.whisper_log;
TRUNCATE TABLE player.affect;
TRUNCATE TABLE player.guild;
TRUNCATE TABLE player.guild_comment;
TRUNCATE TABLE player.guild_grade;
TRUNCATE TABLE player.guild_member;
TRUNCATE TABLE player.guild_war;
TRUNCATE TABLE player.guild_war_bet;
TRUNCATE TABLE player.guild_war_reservation;
TRUNCATE TABLE player.horse_name;
TRUNCATE TABLE player.item;
TRUNCATE TABLE player.item_award;
TRUNCATE TABLE player.marriage;
TRUNCATE TABLE player.messenger_list;
TRUNCATE TABLE player.player;
TRUNCATE TABLE player.player_deleted;
TRUNCATE TABLE player.player_index;
TRUNCATE TABLE player.quest;
TRUNCATE TABLE player.safebox;

Your log tables may differ.