Advertisement
Guest User

Untitled

a guest
May 20th, 2018
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Lua 0.80 KB | None | 0 0
  1. local ESX = nil
  2. -- ESX
  3. TriggerEvent('esx:getSharedObject', function(obj) ESX = obj end)
  4.  
  5. -- Open ID card
  6. RegisterServerEvent('jsfour-legitimation:open')
  7. AddEventHandler('jsfour-legitimation:open', function(ID, targetID)
  8.     local identifier = ESX.GetPlayerFromId(ID).identifier
  9.     local _source = ESX.GetPlayerFromId(targetID).source
  10.  
  11.     MySQL.Async.fetchAll('SELECT firstname, lastname, dateofbirth, sex, height, lastdigits FROM users WHERE identifier = @identifier', {['@identifier'] = identifier},
  12.     function (result)
  13.         if (result[1] ~= nil) then
  14.           playerData = {firstname = result[1].firstname, lastname = result[1].lastname, dateofbirth = result[1].dateofbirth, sex = result[1].sex, height = result[1].height}
  15.           TriggerClientEvent('jsfour-legitimation:open', _source, playerData)
  16.         end
  17.     end)
  18. end)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement