Looking for ban table like this
ban.php
Completely empty deleted entire code because it just wasnt working so there was no point to have it
ban.lua
ban table in phpmyadmin
Banned Player | Comment | Banned By | Added | Expires |
PLAYER NAME | Being a degenerate | [GM]DICK | 18/10/2020, 7:20:46 | 15/11/2020, 7:20:46 |
ban.php
Completely empty deleted entire code because it just wasnt working so there was no point to have it
ban.lua
Lua:
function onSay(player, words, param)
if not player:getGroup():getAccess() then
return true
end
local split = param:split(",")
local name = split[1]
local reason = tostring(split[2])
local bandays = tonumber(split[3])
local accountId = getAccountNumberByPlayerName(name)
if accountId == 0 then
player:sendCancelMessage("Usage: /Ban PlayerName, Reason, Days")
return false
end
local resultId = db.storeQuery("SELECT 1 FROM `account_bans` WHERE `account_id` = " .. accountId)
if resultId ~= false then
result.free(resultId)
return false
end
local timeNow = os.time()
db.query("INSERT INTO `account_bans` (`account_id`, `reason`, `banned_at`, `expires_at`, `banned_by`) VALUES (" ..
accountId .. ", " .. db.escapeString(reason) .. ", " .. timeNow .. ", " .. timeNow + (bandays * 86400) .. ", " .. player:getGuid() .. ")")
local target = Player(name)
if target ~= nil then
broadcastMessage("" .. split[1] .. " has been banned for" .. split[3] .. " days. Reason:" .. split[2] .. ".",MESSAGE_STATUS_WARNING)
target:remove()
else
player:sendTextMessage(MESSAGE_EVENT_ADVANCE, name .. " has been banned.")
end
end
ban table in phpmyadmin