henoireil

Untitled

Aug 17th, 2017
360
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Lua 1.08 KB | None | 0 0
  1. function isIdentifierBanned(id)
  2.     local result = MySQL.Sync.fetchAll("SELECT expires,reason,timestamp FROM bans WHERE banned = @name", {['@name'] = id})
  3.     if(result)then
  4.         for k, v in pairs(result) do
  5.             local expire = tostring(v.expires)
  6.             expire = expire:sub(1, -4)
  7.             expire = tonumber(expire)
  8.             if expire > os.time() then
  9.                 return true
  10.             else
  11.                 MySQL.Sync.execute("DELETE FROM bans WHERE banned = @banned",{['@banned'] = id})
  12.             end
  13.         end
  14.     end
  15.  
  16.     return false
  17. end
  18.  
  19. function GetBannedReason(id)
  20.     local result = MySQL.Sync.fetchAll("SELECT expires,reason,timestamp FROM bans WHERE banned = @name", {['@name'] = id})
  21.     if(result)then
  22.         for k,v in ipairs(result)do
  23.             return result[1].reason
  24.         end
  25.     end
  26.     return "No reason"
  27. end
  28.  
  29. AddEventHandler('playerConnecting', function(name, setCallback)
  30.     local identifier = GetPlayerIdentifiers(source)[1]
  31.     print('Checking user ban: ' .. identifier .. " (" .. name .. ")")
  32.  
  33.     local banned = isIdentifierBanned(identifier)
  34.     if(banned)then
  35.         local reason = GetBannedReason(identifier)
  36.         setCallback(reason)
  37.         CancelEvent()
  38.     end
  39. end)
Advertisement
Add Comment
Please, Sign In to add comment