Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Help] Account removal 100%

Newbie Spellweaver
Joined
Mar 8, 2008
Messages
6
Reaction score
0
Was wondering if anyone could give me a hand completely removing an account or 3, need the login ID removed, all characters attached to account ID gone aswell. So as the same account id can be reused to make a new account + new chars.

Have been searching, so if I missed it my bad.

Any help appreciated
 
Newbie Spellweaver
Joined
Feb 23, 2006
Messages
25
Reaction score
0
If you can't do that by yourself, /quit now please.

How hard it is to track down all account info and delete rows related?
or make a small simple script using delete from sql ?
I just lol'd.
 
Experienced Elementalist
Joined
Jan 3, 2008
Messages
299
Reaction score
1
Using:

Account ID : accountname
Character ID #1 : character1
Character ID #2 : character2
Character ID #3 : character3

Code:
delete from tb_user where straccountid = 'accountname'
delete from account_char where straccountid = 'accountname'
delete from account_nation_check where straccountid = 'accountname'
update battle set strusername = 'NULL' where strusername = 'character1'
update battle set strusername = 'NULL' where strusername = 'character2'
update battle set strusername = 'NULL' where strusername = 'character3'
delete from currentuser where straccountid = 'accountname'
delete from friend_list where struserid = 'character1'
delete from friend_list where struserid = 'character2'
delete from friend_list where struserid = 'character3'
update hero_user set struserid = 'NULL' where struserid = 'character1'
update hero_user set struserid = 'NULL' where struserid = 'character2'
update hero_user set struserid = 'NULL' where struserid = 'character3'
update king_system set strkingname = 'NULL' where strkingname = 'character1'
update king_system set strkingname = 'NULL' where strkingname = 'character2'
update king_system set strkingname = 'NULL' where strkingname = 'character3'
delete from king_ballot_box where straccountid = 'accountname'
update king_candidacy_notice_board set struserid = 'NULL' where struserid = 'character1'
update king_candidacy_notice_board set struserid = 'NULL' where struserid = 'character2'
update king_candidacy_notice_board set struserid = 'NULL' where struserid = 'character3'
update king_election_list set strname = 'NULL' where strname = 'Character1'
update king_election_list set strname = 'NULL' where strname = 'Character2'
update king_election_list set strname = 'NULL' where strname = 'Character3'
delete from knights where chief = 'character1'
delete from knights where chief = 'character2'
delete from knights where chief = 'character3'
update knights set vicechief_1 = 'NULL' where vicechief_1 = 'Character1'
update knights set vicechief_1 = 'NULL' where vicechief_1 = 'Character2'
update knights set vicechief_1 = 'NULL' where vicechief_1 = 'Character3'
update knights set vicechief_2 = 'NULL' where vicechief_2 = 'Character1'
update knights set vicechief_2 = 'NULL' where vicechief_2 = 'Character2'
update knights set vicechief_2 = 'NULL' where vicechief_2 = 'Character3'
update knights set vicechief_3 = 'NULL' where vicechief_3 = 'Character1'
update knights set vicechief_3 = 'NULL' where vicechief_3 = 'Character2'
update knights set vicechief_3 = 'NULL' where vicechief_3 = 'Character3'
delete from knights_user where struserid = 'character1'
delete from knights_user where struserid = 'character2'
delete from knights_user where struserid = 'character3'
update user_knights_rank set strelmouserid = 'NULL', strelmoknightsname = 'NULL' where strelmouserid = 'CHARACTER1'
update user_knights_rank set strelmouserid = 'NULL', strelmoknightsname = 'NULL' where strelmouserid = 'CHARACTER2'
update user_knights_rank set strelmouserid = 'NULL', strelmoknightsname = 'NULL' where strelmouserid = 'CHARACTER3'
update user_knights_rank set strkarususerid = 'NULL', strkarusknightsname = 'NULL' where strelmouserid = 'CHARACTER1'
update user_knights_rank set strkarususerid = 'NULL', strkarusknightsname = 'NULL' where strelmouserid = 'CHARACTER2'
update user_knights_rank set strkarususerid = 'NULL', strkarusknightsname = 'NULL' where strelmouserid = 'CHARACTER3'
delete from userdata where struserid = 'character1'
delete from userdata where struserid = 'character2'
delete from userdata where struserid = 'character3'
delete from warehouse where straccountid = 'accountname'

P.S. Didn't do all of it, just the relevant ones.

Actually, I just got lazy.
 
Newbie Spellweaver
Joined
Mar 8, 2008
Messages
6
Reaction score
0
Using:

Account ID : accountname
Character ID #1 : character1
Character ID #2 : character2
Character ID #3 : character3

Code:
delete from tb_user where straccountid = 'accountname'
delete from account_char where straccountid = 'accountname'
delete from account_nation_check where straccountid = 'accountname'
update battle set strusername = 'NULL' where strusername = 'character1'
update battle set strusername = 'NULL' where strusername = 'character2'
update battle set strusername = 'NULL' where strusername = 'character3'
delete from currentuser where straccountid = 'accountname'
delete from friend_list where struserid = 'character1'
delete from friend_list where struserid = 'character2'
delete from friend_list where struserid = 'character3'
update hero_user set struserid = 'NULL' where struserid = 'character1'
update hero_user set struserid = 'NULL' where struserid = 'character2'
update hero_user set struserid = 'NULL' where struserid = 'character3'
update king_system set strkingname = 'NULL' where strkingname = 'character1'
update king_system set strkingname = 'NULL' where strkingname = 'character2'
update king_system set strkingname = 'NULL' where strkingname = 'character3'
delete from king_ballot_box where straccountid = 'accountname'
update king_candidacy_notice_board set struserid = 'NULL' where struserid = 'character1'
update king_candidacy_notice_board set struserid = 'NULL' where struserid = 'character2'
update king_candidacy_notice_board set struserid = 'NULL' where struserid = 'character3'
update king_election_list set strname = 'NULL' where strname = 'Character1'
update king_election_list set strname = 'NULL' where strname = 'Character2'
update king_election_list set strname = 'NULL' where strname = 'Character3'
delete from knights where chief = 'character1'
delete from knights where chief = 'character2'
delete from knights where chief = 'character3'
update knights set vicechief_1 = 'NULL' where vicechief_1 = 'Character1'
update knights set vicechief_1 = 'NULL' where vicechief_1 = 'Character2'
update knights set vicechief_1 = 'NULL' where vicechief_1 = 'Character3'
update knights set vicechief_2 = 'NULL' where vicechief_2 = 'Character1'
update knights set vicechief_2 = 'NULL' where vicechief_2 = 'Character2'
update knights set vicechief_2 = 'NULL' where vicechief_2 = 'Character3'
update knights set vicechief_3 = 'NULL' where vicechief_3 = 'Character1'
update knights set vicechief_3 = 'NULL' where vicechief_3 = 'Character2'
update knights set vicechief_3 = 'NULL' where vicechief_3 = 'Character3'
delete from knights_user where struserid = 'character1'
delete from knights_user where struserid = 'character2'
delete from knights_user where struserid = 'character3'
update user_knights_rank set strelmouserid = 'NULL', strelmoknightsname = 'NULL' where strelmouserid = 'CHARACTER1'
update user_knights_rank set strelmouserid = 'NULL', strelmoknightsname = 'NULL' where strelmouserid = 'CHARACTER2'
update user_knights_rank set strelmouserid = 'NULL', strelmoknightsname = 'NULL' where strelmouserid = 'CHARACTER3'
update user_knights_rank set strkarususerid = 'NULL', strkarusknightsname = 'NULL' where strelmouserid = 'CHARACTER1'
update user_knights_rank set strkarususerid = 'NULL', strkarusknightsname = 'NULL' where strelmouserid = 'CHARACTER2'
update user_knights_rank set strkarususerid = 'NULL', strkarusknightsname = 'NULL' where strelmouserid = 'CHARACTER3'
delete from userdata where struserid = 'character1'
delete from userdata where struserid = 'character2'
delete from userdata where struserid = 'character3'
delete from warehouse where straccountid = 'accountname'
P.S. Didn't do all of it, just the relevant ones.

Actually, I just got lazy.

Thanks for taking a bit of time out of your day to help me understand the procedures involved.
new to the KO dev community. catch u around! thanks.
 
Last edited:
Back
Top