Question about resetting or wipe out database custome

[Checkmate]

Hi all... As state above, i would like to ask how to do that..
I want to reset all item in database but want to left an account only...
Is there any cmd or anything that i can run in my database query to make this thing work?..?

And is there any consequences if we doing this?..?

 

[LearningRO]

1 hour ago, CheckMate said:

Hi all... As state above, i would like to ask how to do that..
I want to reset all item in database but want to left an account only...
Is there any cmd or anything that i can run in my database query to make this thing work?..?

And is there any consequences if we doing this?..?

 

just truncate database inventory,char,storage,cart_inventory,mail,storage_guild

[Checkmate]

Just now, melv0 said:

just truncate database inventory,char,storage,cart_inventory,mail,storage_guild

Yup.. already found it and actually it was so easy... Thx cuz highlight this... all was inside our database,..

[sader1992]

`acc_reg_num`

`acc_reg_str`

`achievement`

`auction`

`bonus_script`

`buyingstores`

`char_reg_num`

`char_reg_str`

`global_acc_reg_num`

`global_acc_reg_str`

`guild_member`

`guild_skill`

`guild_storage`

`homunculus`

`mail`

`memo`

`mercenary_owner`

`pet`

`quest`

`vendings`

those too

anything related to char_id and account_id and variables too

[Checkmate]

On 12/3/2017 at 10:36 PM, sader1992 said:

`acc_reg_num`

`acc_reg_str`

`achievement`

`auction`

`bonus_script`

`buyingstores`

`char_reg_num`

`char_reg_str`

`global_acc_reg_num`

`global_acc_reg_str`

`guild_member`

`guild_skill`

`guild_storage`

`homunculus`

`mail`

`memo`

`mercenary_owner`

`pet`

`quest`

`vendings`

those too

anything related to char_id and account_id and variables too

Yes.. Seen that .. Thx