[PHP] Deletion inactive players.

[Ronaldino]

Hello.

I request a script for deletion inactive players (also skills, guilds etc.) some days ago I got this one but now I lost it. I know AFS-CMS got that function but it wont delete guilds etcs.

 

[KaczooH]

I would it find it useful also, signed.

 

[Jester]

Don't you believe would be more effective an executed command on mysql? (Don't have one)

 

[KaczooH]

What do you mean?

 

[LoLaNdUs MoRmOr]

I believe he ment that it would be more efficient for you to manually enter a command in the MySQL prompt.

However, such a script as requested is very easy to do, I even recommend yourself to give it a shot. What you need to do, is to basically check a players lastlogin field. You should convert it to proper time by using mktime, then you simply check for any users which are older than x days and if it is, simply remove all the requested fields by using the MySQL command; delete.

Then if you still cannot do it, get in contact with me through PM (or post here, might check it out once in a while).

 

[KaczooH]

We wishes full deletion - with storage values, items etc. If somebody has this code, simply share it I don't want to make mistake and delete more players that I wanted to

 

[LoLaNdUs MoRmOr]

Okay, so basically I would need the exact fields you'd like to remove (give me the proper MySQL names).

 

[Ronaldino]

I think its gonna be;

guilds
guild_invites
guild_ranks
accounts
bans
houses
house_lists
players
player_deaths
player_depotitems
player_items
player_skills
player_storage
player_viplist
tiles & tile_items [for cleaning items from cleaned houses]
And if someone using Gesior's Shop it will need to delete player name from database table "z_ots_comunication".

 

[Ronaldino]

aff... I dont belive its impossible... refresh at same.

 

[soul4soul]

i would rlly love this also

 

[Znote]

Get AFS-CMS They got a feature like this where you can delete inactive players, or etc all players lvl 20- (or any other optional level)

 

[KaczooH]

Thanks Znote I uploaded mine and used this feature. Works nice.

 

[Ronaldino]

Get AFS-CMS They got a feature like this where you can delete inactive players, or etc all players lvl 20- (or any other optional level)

But man, Avarians script is nothing special... deleting only players, and what about guilds/skills/houses/invites eh ?

 

[Azi]

post table's structure from your database.