Advertisement
Guest User

Untitled

a guest
Nov 17th, 2019
146
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Lua 0.84 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-idcard:open')
  7. AddEventHandler('jsfour-idcard:open', function(ID, targetID, type)
  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 FROM users WHERE identifier = @identifier', {['@identifier'] = identifier},
  12.     function (user)
  13.         if (user[1] ~= nil) then
  14.             MySQL.Async.fetchAll('SELECT type FROM user_licenses WHERE owner = @identifier', {['@identifier'] = identifier},
  15.             function (licenses)
  16.                 local array = {
  17.                     user = user,
  18.                     licenses = licenses,
  19.                     type = type
  20.                 }
  21.                 TriggerClientEvent('jsfour-idcard:open', _source, array, type)
  22.             end)
  23.         end
  24.     end)
  25. end)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement