PHP Code:
quest ban begin
state start begin
function check_exist(uName)
local player = mysql_query("SELECT COUNT(name) FROM player.player WHERE name='"..uName.."';")[1][1]
if player == false or player == 0 or player == nil or player == "" then
syschat(string.format("Der Spieler %d existiert nicht.", uName))
return false
else
return true
end
end
function get_account_name(uName)
if ban.check_exist() == false then
return
end
local accountid = mysql_query("SELECT account_id FROM player.player WHERE name='"..uName.."';")[1][1]
return accountid
end
function is_gm(uName)
if ban.check_exist() == false then
return
end
local isGM = mysql_query("SELECT count(mAccount) FROM common.gmlist WHERE mAccount='"..ban.get_account_id(uName).."';")[1][1]
if isGM == 0 or isGM == nil or isGM == false or isGM == "" then
return false
else
return true
end
end
function ban(uName)
local c = mysql_query("UPDATE account.account SET status='BLOCK' WHERE login='"..ban.get_account_id(uName).."';")
if c == false or c == "" or c == 0 or c == nil then
syschat("Query fehlerhaft.")
return false
else
return true
end
end
when login with pc.is_gm() begin
send_letter("Spieler bannen")
end
when button or info begin
say_title("Spieler bannen")
say("[ENTER]Bitte gebe den Spielernamen ein:")
local uName = input()
if ban.check_exist(uName) == false then
return
end
if ban.is_gm(uName) == true then
syschat("Du kannst keinen bannen, der in der GM-List eingetragen ist.")
return
end
end
end
end
#untested
