Advertisement
Guest User

My Function

a guest
Nov 10th, 2016
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Lua 1.18 KB | None | 0 0
  1. My Function:
  2.  
  3.     function searchTable(SID)
  4.         local queryQ = DATABASE:query("SELECT * FROM `database` WHERE steamid = '" .. SID .. "'")
  5.         queryQ.onData = function(Q,D)
  6.             --queryQ.onSuccess = function(q)
  7.                 Reason = D.reason
  8.                 BannedTill = D.to_date
  9.                 BannedFrom = D.from_date
  10.                 bool_var = true
  11.                 PrintTable(D)
  12.             --end
  13.         end
  14.         queryQ.onError = function(Q,E) print("Q1") print(E)
  15.                 Reason = nil
  16.                 BannedTill = nil
  17.                 BannedFrom = nil
  18.                 bool_var = false
  19.         end
  20.         queryQ:start()
  21.         queryQ:wait()
  22.         return Reason, SID, bool_var, BannedFrom, BannedTill
  23.     end
  24.  
  25. The Function which uses it:
  26.  
  27. function checkForPrisoner(sid64)
  28.     reason, steamid, trueorfalse, bannedfrom, bannedtill = searchTable(sid64)
  29.     if(trueorfalse)then
  30.         return false , "You got Banned for: "..reason.."\n You are Banned untill:"..os.date( "%H:%M:%S - %d/%m/%Y" , bannedtill )
  31.     else
  32.         print("Player:"..sid64.." is not Banned")
  33.         return true
  34.     end
  35. end
  36.  
  37. Expected Returns:
  38.  
  39. reason = "Reason"
  40. steamid = my64bitsteamid
  41. trueorfalse = true
  42. bannedfrom = UnixTime
  43. bannedtill = UnixTime
  44.  
  45. Actual Returns:
  46.  
  47. reason = "Reason"
  48. steamid = nil
  49. trueorfalse = nil
  50. bannedfrom = nil
  51. bannedtill = nil
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement