local days = 30*3600*24
local nowtime = os.date("*t")

function onStartup()
	local result = db.getResult("SELECT `id`, `fp_id`, `sp_id`, `date`,  `prize`  FROM `bounty_hunters` ORDER by `date` ASC;")
    if(result:getID() ~= -1) then
        while(true) do
            local id = result:getDataInt("id")
            local date = result:getDataInt("date")
            local player = result:getDataInt("fp_id")
            local prize = result:getDataInt("prize")

			local expire_time = date + days

			if nowtime <= expire_time then
				-- send money back
                local tid = getPlayerByGUID(buy:getDataInt("player"))
                if(isPlayer(tid)) then
                    doPlayerSetBalance(tid, getPlayerBalance(tid) + prize)
                else
                    db.executeQuery("UPDATE `players` SET `balance` = `balance` + " .. prize .. " WHERE `id` = " .. buy:getDataInt("player") .. ";")
                end
                -- delete item
                db.executeQuery("DELETE FROM `auction_system` WHERE `id` = '".. id .."';")
            end
            if not(result:next()) then
                break
            end
        end
        result:free()
    end
end