/ban - banned offline player

[Laron25]

Hi, I want to do that if the player is offline it also banned. Someone can help me?

function onSay(cid, words, param)
	local t = string.explode(string.lower(param), ",")
	if not t[1] then
                doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Command requires param.") return true
	end
        local player = getPlayerByNameWildcard(t[1]) 
        if(not player)then 
                doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Player not found.") return true 
        end
        local hours,comment = not tonumber(t[2]) and 24 or tonumber(t[2]),not t[3] and "No Reason" or t[3]
		doBroadcastMessage(getCreatureName(player).." was banned by "..getCreatureName(cid).." for "..comment)
			doAddAccountBanishment(getPlayerAccountId(player), target, os.time() + hours*3600*24, 5, 2,comment, 0)
			doRemoveCreature(player)
	return true
end

Thanks for help
LAron

PS: I have a query to the database

db.getResult('SELECT `accounts`.`id` FROM `accounts`, `players` WHERE `accounts`.`id` = `players`.`account_id` AND `players`.`name` = ' .. db.escapeString(player) .. ';')

 

[gigastar]

your db string should look somthing like this...

function getOfflinePlayerId(player)
local res = db.getResult('SELECT `id` FROM `accounts` WHERE `name`= ' .. db.escapeString(player) .. ';')
return res
end


function getOfflinePlayerName(player)
local res = db.getResult('SELECT `name` FROM `accounts` WHERE `name`= ' .. db.escapeString(player) .. ';')
return res
end


Then you can do

if step then
doPlayerAddBanishment(getOfflinePlayerId(cid))
end

 

[Laron25]

Tommorow I'll try, thanks.

- - - Updated - - -

Sorry, dosen't work ;(
Only kick player.

 

[Laron25]

~~bump

- - - Updated - - -

No one know how do this?

 

[Laron25]

~~bump~~

- - - Updated - - -

Guys, I need this shit ;/

 

[Laron25]

Guys

 

[gigastar]

You need to get get a database string that works, then try the script. I cannot check because I am at school...

 

[Laron25]

If you check I would be grateful. ^^