Script that cleans inactive players houses for SQLITE

[Rozinx]

I've browsed the whole forum and couldn't find that script.

Assuming you've read the title, I'd really be glad if someone could write it, cause that one only works with MySql.

Thanks in advance

 

[Rozinx]

someone?

 

[narko]

in the script for mysql change ' << to "

 

[Rozinx]

First of all I have to change that unix function to this one

strftime('%s','now')

Then, after changing those ' to " I get

[0:1:02.716] sqlite3_step(): SQLITE ERROR: cannot rollback transaction - SQL sta
tements in progress
[0:1:02.717] sqlite3_step(): SQLITE ERROR: cannot start a transaction within a t
ransaction
[0:1:02.718] sqlite3_step(): SQLITE ERROR: cannot rollback transaction - SQL sta
tements in progress
[0:1:02.719] sqlite3_step(): SQLITE ERROR: cannot start a transaction within a t
ransaction
[0:1:02.719] sqlite3_step(): SQLITE ERROR: cannot rollback transaction - SQL sta
tements in progress
[0:1:02.720] sqlite3_step(): SQLITE ERROR: cannot start a transaction within a t
ransaction
[0:1:02.721] sqlite3_step(): SQLITE ERROR: cannot rollback transaction - SQL sta
tements in progress
[0:1:02.722] sqlite3_step(): SQLITE ERROR: cannot start a transaction within a t
ransaction
[0:1:02.723] sqlite3_step(): SQLITE ERROR: cannot rollback transaction - SQL sta
tements in progress

 

[narko]

lol get me your script

 

[Rozinx]

<?xml version="1.0" encoding="UTF-8"?>
<mod name="Cleanhouses" version="1.03" author="nsanee" contact="otland.net" enabled="yes">
    <description>
        v.1.03 - Added 'onlyNonPremium' configurable.
                 Removed modlib, since the script is run once anyway we don't need it loaded at all times.
                 It shouldn't now stop execution when a house is nameless.
				
		v.1.02 - now uses only one sql query, removed multiworld configurable  since it's not needed anymore
        v.1.01 - small fixes, optimized query + multiworld support.
       
		
        This mod will clean houses of inactive players and move their items to the depot.
        
        config explained:
            
            days - If the player hasn't logged in for this number of days his house will be freed.
            log - true/false, whether to enable logging of which houses have been cleaned.
            file - path to the log file, where logs will be stored. Ignored if 'log' set to false
            onlyNonPremium - if set to 'true', the script will clean only the houses of players who don't have any pacc days left.
			
		other notes:
			DO NOT remove doSaveServer() at the end, otherwise if your server happens to crash before the nearest server save you will regret it =)
    </description>

    <globalevent name="cleanhouses" type="start" event="buffer"><![CDATA[
	
	
        local config = { 
            days = 14,
            log = true,
            file = getDataDir() .. "/logs/cleanhouses.txt",
	    onlyNonPremium = false
        }
		
		
		
        local ns_query =[[ SELECT houses.owner, houses.id as hid, houses.name as house_name ,players.name FROM houses
            LEFT JOIN players ON players.id=houses.owner
            LEFT JOIN accounts ON players.account_id=accounts.id
            WHERE players.lastlogin < (strftime('%s','now') - ]] ..config.days.. [[*24*60*60)
            ]] ..(config.onlyNonPremium and " AND accounts.premdays=0 " or "")..[[
            AND	players.world_id =]] .. getConfigValue("worldId")
		
        local house = db.getResult(ns_query)
        local logs = " :: Houses cleaned:\n\n"
        if house:getID() ~= -1 then
            repeat
                logs = logs .. house:getDataString("house_name") ..", owned by " .. house:getDataString("name") .. "\n"
                setHouseOwner(house:getDataInt("hid"), 0)
            until not house:next()
            house:free()
        else
            logs = logs .. "There were no houses to clean."
        end
        if config.log then
            doWriteLogFile(config.file, logs)
        end
        addEvent(doSaveServer, 1000)
		
    ]]></globalevent>
</mod>

 

[Rozinx]

Damn, I'm willing to pay a few bucks for the one who writes me one.

 

[narko]

use in globalevents:

local config = { 
    days = 14,
    log = true,
    file = getDataDir() .. "/logs/cleanhouses.txt"
}    
local ns_query =[[ SELECT houses.owner,houses.id,players.name FROM houses
                LEFT JOIN players ON players.id=houses.owner
                WHERE players.lastlogin < (UNIX_TIMESTAMP() - ]] ..config.days.. [[*24*60*60)
                AND
                players.world_id =]] .. getConfigValue("worldId")
 
function onStartup(_time)
 
    local house = db.getResult(ns_query)
    local logs = " :: Houses cleaned:\n\n"
    if house:getID() ~= -1 then
        repeat
            logs = logs .. getHouseInfo(house:getDataInt('id')).name ..", owned by " .. house:getDataString('name') .. "\n"
            setHouseOwner(house:getDataInt('id'), 0)
        until not house:next()
        house:free()
    else
        logs = logs .. "There were no houses to clean."
    end
    if config.log then
        doWriteLogFile(config.file, logs)
    end
    addEvent(doSaveServer, 1000)
end

<globalevent name="cleanhouses" type="start" event="script" value="cleanhouses.lua"/>