Clean House

[Sir Gabriiel]

UPDATE

I want a script like this:
> Will clean houses of inactive players every time your server starts and move their items to their depots.
> I want you to NOT clean the Guildhall.
> I use MySql ...

Clean every 14 days

 

[Sir Gabriiel]

help me please
bump

 

[Fec]

Create talkactions\scripts\cleanHouses.lua: and add:

-- clean all houses except guildhouses 
-- Created by fec/layflette/3dzio/shtako

function onSay(cid, words, param)
	local GOD_ACCESS = 6 -- change to your god access
	if getPlayerAccess(cid) < GOD_ACCESS then
		return FALSE
	end
	local count = 0
	local houses_list = db.getResult("SELECT `id` FROM `houses` WHERE `guild` = 0")
	if houses_list:getID() ~= -1 then
		while true do
			local houseid = houses_list:getDataInt('id')
			 if doCleanHouse(houseid) then
				count = count + 1
			 else
				 doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, 'Cannot clean house with id = ' .. houseid)
			 end
			 if not houses_list:next() then break end
		end
	end
	doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, 'Total cleaned: ' .. count)
	doSaveServer() -- if server will lag a lot, delete this line and save in-game.?
return TRUE
end

In talkactions.xml add:

<talkaction words="!cleanHouses" script="cleanHouses.lua"/>

So, this script will clear all your houses in serv except guildhouses.

So you need "houses" table in your MySQL tables. Script not tested !

 

[Sir Gabriiel]

UPDATE

I want a script like this:
> Will clean houses of inactive players every time your server starts and move their items to their depots.
> I want you to NOT clean the Guildhall.
> I use MySql ...

Clean every 14 days

 

[Sir Gabriiel]

bump

 

[Sir Gabriiel]

BUMP!
UPDATE

I want a script like this:
> Will clean houses of inactive players every time your server starts and move their items to their depots.
> I want you to NOT clean the Guildhall.
> I use MySql ...

Clean every 14 days

 

[Sir Gabriiel]

bump

 

[Sir Gabriiel]

bump

 

[Sir Gabriiel]

bump