• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

House cleaner

U

ugurdrahs

New Member
Joined
May 6, 2010
Messages
555
Reaction score
2
Location
Netherland
Hi,

someone have a house cleaner for rev 3858?

players that didnt login for 14 days, his/her house will be cleaned and items will be sended to his hometown DEPOT.

REPP+
 
Last edited:
Sort by date Sort by votes
search...

LUA: 
<?xml version="1.0" encoding="UTF-8"?>
<mod name="Clean houses mod" version="1.0" author="nsanee" contact="otland.net" enabled="yes">
    <description>
        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
        
            DO NOT remove doSaveServer() at the end, otherwise if your server happens to crash before the nearest server save you will regret it =)
    </description>

    <config name="cleanhouses_conf"><![CDATA[
    
        config = { 
            days = 7,
            log = true,
            file = getDataDir() .. "/logs/cleanhouses.txt"
        }
        
    ]]></config>
    <globalevent name="cleanhouses" type="start" event="buffer"><![CDATA[
        domodlib('cleanhouses_conf')
        local house = db.getResult("SELECT `owner` ,`id` FROM `houses` WHERE `owner` IN (SELECT `id` FROM `players` WHERE `lastlogin` < UNIX_TIMESTAMP() - "..config.days.. "*24*60*60)")
        local logs = " :: Houses cleaned:\n\n"
        if house:getID() ~= -1 then
            repeat
                logs = logs .. getHouseInfo(house:getDataInt('id')).name ..", owned by " .. getPlayerNameByGUID(house:getDataInt('owner')) .. "\n"
                setHouseOwner(house:getDataInt('id'), 0)
            until not house:next()
        else
            logs = logs .. "There were no houses to clean."
        end
        if config.log then
            doWriteLogFile(config.file, logs)
        end
        doSaveServer()
    ]]></globalevent>
</mod>
 
Upvote 0 Downvote
richux said:
search...

LUA: 
<?xml version="1.0" encoding="UTF-8"?>
<mod name="Clean houses mod" version="1.0" author="nsanee" contact="otland.net" enabled="yes">
    <description>
        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
        
            DO NOT remove doSaveServer() at the end, otherwise if your server happens to crash before the nearest server save you will regret it =)
    </description>

    <config name="cleanhouses_conf"><=!=[=C=D=A=T=A=[
    
        config = { 
            days = 7,
            log = true,
            file = getDataDir() .. "/logs/cleanhouses.txt"
        }
        
    ]=]=></config>
    <globalevent name="cleanhouses" type="start" event="buffer"><=!=[=C=D=A=T=A=[
        domodlib('cleanhouses_conf')
        local house = db.getResult("SELECT `owner` ,`id` FROM `houses` WHERE `owner` IN (SELECT `id` FROM `players` WHERE `lastlogin` < UNIX_TIMESTAMP() - "..config.days.. "*24*60*60)")
        local logs = " :: Houses cleaned:\n\n"
        if house:getID() ~= -1 then
            repeat
                logs = logs .. getHouseInfo(house:getDataInt('id')).name ..", owned by " .. getPlayerNameByGUID(house:getDataInt('owner')) .. "\n"
                setHouseOwner(house:getDataInt('id'), 0)
            until not house:next()
        else
            logs = logs .. "There were no houses to clean."
        end
        if config.log then
            doWriteLogFile(config.file, logs)
        end
        doSaveServer()
    ]=]=></globalevent>
</mod>
Click to expand...

I used this before

PHP: 
yup
<?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 = true
        }
		
		
		
        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 < (UNIX_TIMESTAMP() - ]] ..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>


This one didnt help,
ur sure urs will help?
 
Upvote 0 Downvote
richux said:
search...

LUA: 
<?xml version="1.0" encoding="UTF-8"?>
<mod name="Clean houses mod" version="1.0" author="nsanee" contact="otland.net" enabled="yes">
    <description>
        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
        
            DO NOT remove doSaveServer() at the end, otherwise if your server happens to crash before the nearest server save you will regret it =)
    </description>

    <config name="cleanhouses_conf"><=!=[=C=D=A=T=A=[
    
        config = { 
            days = 7,
            log = true,
            file = getDataDir() .. "/logs/cleanhouses.txt"
        }
        
    ]=]=></config>
    <globalevent name="cleanhouses" type="start" event="buffer"><=!=[=C=D=A=T=A=[
        domodlib('cleanhouses_conf')
        local house = db.getResult("SELECT `owner` ,`id` FROM `houses` WHERE `owner` IN (SELECT `id` FROM `players` WHERE `lastlogin` < UNIX_TIMESTAMP() - "..config.days.. "*24*60*60)")
        local logs = " :: Houses cleaned:\n\n"
        if house:getID() ~= -1 then
            repeat
                logs = logs .. getHouseInfo(house:getDataInt('id')).name ..", owned by " .. getPlayerNameByGUID(house:getDataInt('owner')) .. "\n"
                setHouseOwner(house:getDataInt('id'), 0)
            until not house:next()
        else
            logs = logs .. "There were no houses to clean."
        end
        if config.log then
            doWriteLogFile(config.file, logs)
        end
        doSaveServer()
    ]=]=></globalevent>
</mod>
Click to expand...

I tryed out this one,
and nop it doesnt work
 
Upvote 0 Downvote
it works, there's something you're missing

it executes on server start and removes house owners which didn't login for 7 days, did you test this properly?
 
Upvote 0 Downvote
Cykotitan said:
it works, there's something you're missing

it executes on server start and removes house owners which didn't login for 7 days, did you test this properly?
Click to expand...

Yes I did,
there are many people that owns a house in thais, that didnt login for more than 1 month.

Those houses dont get cleaned...


So, Theres something wrong with the script?

I use it on the mod folder and name it --> cleanhouses.xml

but it doesnt work.
 
Upvote 0 Downvote
Back
Top