GlobalEvent Automated Database Cleanup 1.1, the solution for inactive players

[hodleo]

is globalevent or creaturescript? because when i test, appear error in my console because o interval...

globalevent, as the title says it

 

[Snow]

can you make it work on sqlite?

 

[hodleo]

Shall be later, I have to find the time function for SQlite

 

[Jixxufi]

it works wit 0.3.4 pl2?

 

[hodleo]

it works wit 0.3.4 pl2?

if 0.3.4pl2 accepts globalevents with function onStartup() then it has to work

 

[FeragonOnline]

but it delete the next tables?
player death
player items
etc?

 

[hodleo]

but it delete the next tables?
player death
player items
etc?

Good script.

I think the database automatically deletes items that do not belong to any player, so if you delete player item get deleted too after save or restart+save

i was told that yes

 

[GuHB]

great! veery usefull

 

[hodleo]

i make unique scripts:thumbup:

 

[Hermes]

Nice idea, but I think that deleting players with level > 50 is stupid for low exp servers. Also, most of the servers are too small to have databases so large that they might need character cleanups to quicken everything :d

But I like it, thanks for releasing

Btw. You can add a note in script, that all things concerned with certain player are cleaned thanks to triggers in database

 

[hodleo]

i know ^^
just showing my ideas

 

[kkk111]

it lacked shows the name and level ;\

[08 February 2010 19:14:13 ] >> [DBCLEANUP] 2 inactive players [(name1, level),(name2, level)] have been deleted from database.

 

[zuffo]

Noob Question,
As for SAMPLES?
also excludes the players samples?

 

[hodleo]

Noob Question,
As for SAMPLES?
also excludes the players samples?

yes, no risks

AND `id` > 6 AND `group_id` < 2 A

nor samples neither cms, gms, gods, acc manager

 

[Printer]

i got this on tfs 0,3,5

[05/03/2010 12:18:40] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (DELETE FROM "players" WHERE "level" < 900 AND "id" > 6 AND "group_id" < 2 AND "lastlogin" < UNIX_TIMESTAMP() - 1
[05/03/2010 12:18:40] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (DELETE FROM "players" WHERE "level" < 100 AND "id" > 6 AND "group_id" < 2 AND "lastlogin" < UNIX_TIMESTAMP() - 0
[05/03/2010 12:18:40] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (DELETE FROM "players" WHERE "level" < 50 AND "id" > 6 AND "group_id" < 2 AND "lastlogin" < UNIX_TIMESTAMP() - 2592000
[05/03/2010 12:18:40] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (DELETE FROM "players" WHERE "level" < 100 AND "id" > 6 AND "group_id" < 2 AND "lastlogin" < UNIX_TIMESTAMP() - 5184000
[05/03/2010 12:18:40] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (DELETE FROM "players" WHERE "level" < 150 AND "id" > 6 AND "group_id" < 2 AND "lastlogin" < UNIX_TIMESTAMP() - 7776000

 

[hodleo]

@up atm it doesnt work with sqlite

 

[klekSu]

You should also add deletion of player_items, _depotitems, _storage, _skills, that would rock.

 

[Evil Mark]

Nice

 

[richux]

You should also add deletion of player_items, _depotitems, _storage, _skills, that would rock.

+ 1

 

[hodleo]

You should also add deletion of player_items, _depotitems, _storage, _skills, that would rock.

sure, coming up :wub: