Advertisement
Guest User

Untitled

a guest
Jun 26th, 2017
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Lua 1.32 KB | None | 0 0
  1.     local function entryCheckQuery( results )
  2.  
  3.         if results[1].error then fp_sqlError( results[1].error ) return end
  4.  
  5.         if results[1].affected > 0 then
  6.  
  7.             ply:SetNWInt( "guncraft_materials", results[1].data[1].materials )
  8.             ply:SetNWInt( "guncraft_experience", results[1].data[1].experience )
  9.             ply:SetNWInt( "guncraft_weapons_crafted", results[1].data[1].weapons_crafted )
  10.             ply:SetNWInt( "guncraft_shipments_crafted", results[1].data[1].shipments_crafted )
  11.  
  12.             if results[1].data[1].name ~= ply:Name() then
  13.  
  14.                 local function nameUpdateQuery( results )
  15.  
  16.                     if results[1].error then fp_sqlError( results[1].error )
  17.  
  18.                         return
  19.  
  20.                     end
  21.  
  22.                 end
  23.                 database:Query( string.format( "UPDATE guncraft_player SET name = '%s' WHERE steamid = '%s'", database:Escape( ply:Name() ), ply:SteamID() ), nameUpdateQuery )
  24.  
  25.             end
  26.  
  27.         else
  28.  
  29.             local function newEntryQuery( results )
  30.  
  31.                 if results[1].error then fp_sqlError( results[1].error ) return end
  32.  
  33.             end
  34.             database:Query( string.format( "INSERT INTO guncraft_player VALUES ('%s', '%s', 0, 0, 0, 0)", ply:SteamID(), database:Escape( ply:Name() ) ), newEntryQuery )
  35.  
  36.         end
  37.  
  38.     end
  39.     database:Query( string.format( "SELECT name, experience, materials, weapons_crafted, shipments_crafted FROM guncraft_player WHERE steamid = '%s'", ply:SteamID() ), entryCheckQuery )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement