GlobalEvent Automated Database Cleanup 1.1, the solution for inactive players

[darkjav]

thx bro :*

 

[Stewie]

can create 1 for me for SQLite ?

Thx

 

[anotapreta]

i must hav edited it bad

for i = 1, #cleanup do
        db.executeQuery("DELETE FROM `players` WHERE `level` < ".. cleanup[i].level .." AND `id` > 6 AND `group_id` < 2 AND `lastlogin` < UNIX_TIMESTAMP() - ".. cleanup[i].time ..";")
    end

edit: AND `id` > 6

Google tradu...
There are people who deleted the acc Samples without either and now the ID is not more than 6 then you better put thus:

147 is my account_id of Samples ..

Existem pessoas que deletaram sem quer os acc Samples e agora o ID não é mais < 6 então é melhor colocar assim:

147 é o meu account_id dos Samples..

 for i = 1, #cleanup do
        db.executeQuery("DELETE FROM `players` WHERE `level` < ".. cleanup[i].level .." AND `account_id` ~= 147 AND `group_id` < 2 AND `lastlogin` < UNIX_TIMESTAMP() - ".. cleanup[i].time ..";")
    end

Correct me if I'm wrong.
Me corrija se eu estiver errado.

OR

    for i = 1, #cleanup do
        db.executeQuery("DELETE FROM `players` WHERE `level` < ".. cleanup[i].level .." AND `account_id` > 147 AND `account_id` < 147 AND `group_id` < 2 AND `lastlogin` < UNIX_TIMESTAMP() - ".. cleanup[i].time ..";")
    end

My otServer is: http://mundinho.sytes.net:8090/
Meu otServer é: http://mundinho.sytes.net:8090/

 

[hodleo]

@up
AND `id` > 146 AND `id` < 152
???

 

[kito2]

Cybershot, could you take a loot at this script?

http://otland.net/f132/mod-globalevents-guild-clean-88002/#post901230

It is like the same as this, but cleans guilds.

 

[Darkhaos]

        print("" .. text .. "")

Can be:

        print(text)

 

[kito2]

[21 april 2010 13:17:27 ] >> [dbcleanup] 19 inactive players have been deleted from database.
[21 april 2010 13:24:34 ] >> [dbcleanup] 3 inactive players have been deleted from database.
[21 april 2010 13:37:52 ] >> [dbcleanup] 9 inactive players have been deleted from database.
[21 april 2010 19:13:34 ] >> [dbcleanup] 128 inactive players have been deleted from database.
[20 june 2010 03:09:40 ] >> [dbcleanup] 3302 inactive players have been deleted from database.
[20 june 2010 03:41:17 ] >> [dbcleanup] 2 inactive players have been deleted from database.
[20 june 2010 15:10:16 ] >> [dbcleanup] 25 inactive players have been deleted from database.
[20 june 2010 17:27:19 ] >> [dbcleanup] 7 inactive players have been deleted from database.
[20 june 2010 17:59:43 ] >> [dbcleanup] 6 inactive players have been deleted from database.
[21 june 2010 01:46:44 ] >> [dbcleanup] 35 inactive players have been deleted from database.
[21 june 2010 10:21:08 ] >> [dbcleanup] 1 inactive players have been deleted from database.
[21 june 2010 13:50:23 ] >> [dbcleanup] 17 inactive players have been deleted from database.
[21 june 2010 16:34:35 ] >> [dbcleanup] 9 inactive players have been deleted from database.
[21 june 2010 21:15:10 ] >> [dbcleanup] 24 inactive players have been deleted from database.
[22 june 2010 00:05:13 ] >> [dbcleanup] 6 inactive players have been deleted from database.
[22 june 2010 16:35:09 ] >> [dbcleanup] 15 inactive players have been deleted from database.
[22 june 2010 19:49:25 ] >> [dbcleanup] 21 inactive players have been deleted from database.
[22 june 2010 20:23:38 ] >> [dbcleanup] 3 inactive players have been deleted from database.
[22 june 2010 21:44:16 ] >> [dbcleanup] 8 inactive players have been deleted from database.
[23 june 2010 08:01:28 ] >> [dbcleanup] 10 inactive players have been deleted from database.
[24 june 2010 07:41:43 ] >> [dbcleanup] 64 inactive players have been deleted from database.
[24 june 2010 19:40:47 ] >> [dbcleanup] 33 inactive players have been deleted from database.
[25 june 2010 13:36:48 ] >> [dbcleanup] 26 inactive players have been deleted from database.
[25 june 2010 15:35:49 ] >> [dbcleanup] 10 inactive players have been deleted from database.
[25 june 2010 16:52:09 ] >> [dbcleanup] 4 inactive players have been deleted from database.
[26 june 2010 04:32:52 ] >> [dbcleanup] 43 inactive players have been deleted from database.
[26 june 2010 13:51:20 ] >> [dbcleanup] 26 inactive players have been deleted from database.
[26 june 2010 13:58:49 ] >> [dbcleanup] 2 inactive players have been deleted from database.
[26 june 2010 14:04:08 ] >> [dbcleanup] 3 inactive players have been deleted from database.
[26 june 2010 15:44:27 ] >> [dbcleanup] 7 inactive players have been deleted from database.
[26 june 2010 16:42:01 ] >> [dbcleanup] 5 inactive players have been deleted from database.
[03 july 2010 01:56:06 ] >> [dbcleanup] 85 inactive players have been deleted from database.
[04 july 2010 04:01:54 ] >> [dbcleanup] 76 inactive players have been deleted from database.
[04 july 2010 05:57:02 ] >> [dbcleanup] 2 inactive players have been deleted from database.
[05 july 2010 00:27:14 ] >> [dbcleanup] 59 inactive players have been deleted from database.
[05 july 2010 01:02:20 ] >> [dbcleanup] 1 inactive players have been deleted from database.
[06 july 2010 18:31:52 ] >> [dbcleanup] 99 inactive players have been deleted from database.
[07 july 2010 02:18:45 ] >> [dbcleanup] 27 inactive players have been deleted from database.
[10 july 2010 16:27:01 ] >> [dbcleanup] 240 inactive players have been deleted from database.
[13 july 2010 04:44:01 ] >> [dbcleanup] 141 inactive players have been deleted from database.
[14 july 2010 07:14:36 ] >> [dbcleanup] 46 inactive players have been deleted from database.
[15 july 2010 02:27:31 ] >> [dbcleanup] 37 inactive players have been deleted from database.
[15 july 2010 10:56:55 ] >> [dbcleanup] 7 inactive players have been deleted from database.
[16 july 2010 03:28:10 ] >> [dbcleanup] 47 inactive players have been deleted from database.
[18 july 2010 18:23:42 ] >> [dbcleanup] 32 inactive players have been deleted from database.
[19 july 2010 03:55:05 ] >> [dbcleanup] 78 inactive players have been deleted from database.
[19 july 2010 14:25:28 ] >> [dbcleanup] 69 inactive players have been deleted from database.
[20 july 2010 04:30:05 ] >> [dbcleanup] 118 inactive players have been deleted from database.
[21 july 2010 05:41:50 ] >> [dbcleanup] 101 inactive players have been deleted from database.
[21 july 2010 19:54:03 ] >> [dbcleanup] 43 inactive players have been deleted from database.
[22 july 2010 04:58:53 ] >> [dbcleanup] 42 inactive players have been deleted from database.
[24 july 2010 00:44:20 ] >> [dbcleanup] 165 inactive players have been deleted from database.
[24 july 2010 23:53:57 ] >> [dbcleanup] 24 inactive players have been deleted from database.
[25 july 2010 05:30:00 ] >> [dbcleanup] 8 inactive players have been deleted from database.
[25 july 2010 23:17:46 ] >> [dbcleanup] 50 inactive players have been deleted from database.
[26 july 2010 14:09:54 ] >> [dbcleanup] 42 inactive players have been deleted from database.
[27 july 2010 03:36:26 ] >> [dbcleanup] 97 inactive players have been deleted from database.
[27 july 2010 12:30:37 ] >> [dbcleanup] 19 inactive players have been deleted from database.
[27 july 2010 22:41:26 ] >> [dbcleanup] 88 inactive players have been deleted from database.
[28 july 2010 07:59:04 ] >> [dbcleanup] 35 inactive players have been deleted from database.
[28 july 2010 21:12:04 ] >> [dbcleanup] 67 inactive players have been deleted from database.
[29 july 2010 22:43:50 ] >> [dbcleanup] 154 inactive players have been deleted from database.
[30 july 2010 21:49:15 ] >> [dbcleanup] 119 inactive players have been deleted from database.
[31 july 2010 05:28:25 ] >> [dbcleanup] 18 inactive players have been deleted from database.
[01 august 2010 02:44:54 ] >> [dbcleanup] 87 inactive players have been deleted from database.
[01 august 2010 23:43:01 ] >> [dbcleanup] 118 inactive players have been deleted from database.
[02 august 2010 21:59:29 ] >> [dbcleanup] 163 inactive players have been deleted from database.
[03 august 2010 21:31:54 ] >> [dbcleanup] 113 inactive players have been deleted from database.
[04 august 2010 07:59:23 ] >> [dbcleanup] 35 inactive players have been deleted from database.
[04 august 2010 22:53:27 ] >> [dbcleanup] 128 inactive players have been deleted from database.
[05 august 2010 13:25:40 ] >> [dbcleanup] 41 inactive players have been deleted from database.
[05 august 2010 23:11:42 ] >> [dbcleanup] 106 inactive players have been deleted from database.
[06 august 2010 17:52:57 ] >> [dbcleanup] 107 inactive players have been deleted from database.
[06 august 2010 18:36:33 ] >> [dbcleanup] 16 inactive players have been deleted from database.
[07 august 2010 15:25:02 ] >> [dbcleanup] 95 inactive players have been deleted from database.
[08 august 2010 03:28:13 ] >> [dbcleanup] 92 inactive players have been deleted from database.
[09 august 2010 21:01:05 ] >> [dbcleanup] 218 inactive players have been deleted from database.
[10 august 2010 09:54:42 ] >> [dbcleanup] 29 inactive players have been deleted from database.
[10 august 2010 23:12:38 ] >> [dbcleanup] 92 inactive players have been deleted from database.
[11 august 2010 23:50:28 ] >> [dbcleanup] 154 inactive players have been deleted from database.
[12 august 2010 17:43:18 ] >> [dbcleanup] 92 inactive players have been deleted from database.
[13 august 2010 17:11:46 ] >> [dbcleanup] 153 inactive players have been deleted from database.
[16 august 2010 00:27:51 ] >> [dbcleanup] 441 inactive players have been deleted from database.
[16 august 2010 00:30:35 ] >> [dbcleanup] 1 inactive players have been deleted from database.
[16 august 2010 01:04:37 ] >> [dbcleanup] 3 inactive players have been deleted from database.
[16 august 2010 08:05:22 ] >> [dbcleanup] 6 inactive players have been deleted from database.
[16 august 2010 12:05:59 ] >> [dbcleanup] 1 inactive players have been deleted from database.
[17 august 2010 05:47:33 ] >> [dbcleanup] 85 inactive players have been deleted from database.
[17 august 2010 09:07:28 ] >> [dbcleanup] 1 inactive players have been deleted from database.
[17 august 2010 09:21:51 ] >> [dbcleanup] 1 inactive players have been deleted from database.
[18 august 2010 07:29:03 ] >> [dbcleanup] 146 inactive players have been deleted from database.
[19 august 2010 11:32:25 ] >> [dbcleanup] 169 inactive players have been deleted from database.
[19 august 2010 12:30:35 ] >> [dbcleanup] 6 inactive players have been deleted from database.
[20 august 2010 07:13:37 ] >> [dbcleanup] 102 inactive players have been deleted from database.
[20 august 2010 18:37:33 ] >> [dbcleanup] 62 inactive players have been deleted from database.
[22 august 2010 23:57:55 ] >> [dbcleanup] 413 inactive players have been deleted from database.
[23 august 2010 17:59:29 ] >> [dbcleanup] 63 inactive players have been deleted from database.
[24 august 2010 01:08:13 ] >> [dbcleanup] 60 inactive players have been deleted from database.
[24 august 2010 17:46:16 ] >> [dbcleanup] 73 inactive players have been deleted from database.

hahahahahhaa!

 

[hodleo]

wat the shouldn't be like that
i guess i have to update this too <_<

 

[Evil Puncker]

waiting for update then

 

[hodleo]

this isn't for sqlite btw

 

[Evil Puncker]

if a player is deleted and he are leader of a guild the guild get disbanded?

 

[hodleo]

i guess i should make it like that

 

[Evil Puncker]

and maybe u can change:

db.executeQuery("DELETE FROM `players` WHERE `level` < ".. cleanup.level .." AND `id` > 6 AND `group_id` < 2 AND `lastlogin` < UNIX_TIMESTAMP() - ".. cleanup.time ..";")

to:

db.executeQuery("DELETE FROM `players` WHERE `level` < ".. cleanup.level .." AND `id` > 6 AND `group_id` < 2 AND `name` != "Account Manager" AND `name` NOT LIKE "%Sample" AND `lastlogin` < UNIX_TIMESTAMP() - ".. cleanup.time ..";")


So it wont delete acc manager nor samples characteres? just an idea

 

[hodleo]

dont worry about that i've found a perfect way to not use the ids:

..AND name NOT LIKE "%Sample" AND name != "Account Manager"

so it won't need the ids

 

[Evil Puncker]

ok then I'll wait for the update xD

 

[hodleo]

and this one deletes empty accounts(acc with no characters created or all chars deleted)

DELETE * FROM `accounts` WHERE NOT EXISTS (SELECT `id` FROM `players` WHERE `accounts.id` = `players.account_id`);

 

[Evil Puncker]

nice one
so when u will update the main script?

 

[RobsonDias]

nice script cybershot

 

[Evil Puncker]

so when u will update the main script?

 

[hodleo]

i never give dates they're innacurate