Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- local function entryCheckQuery( results )
- if results[1].error then fp_sqlError( results[1].error ) return end
- if results[1].affected > 0 then
- ply:SetNWInt( "guncraft_materials", results[1].data[1].materials )
- ply:SetNWInt( "guncraft_experience", results[1].data[1].experience )
- ply:SetNWInt( "guncraft_weapons_crafted", results[1].data[1].weapons_crafted )
- ply:SetNWInt( "guncraft_shipments_crafted", results[1].data[1].shipments_crafted )
- if results[1].data[1].name ~= ply:Name() then
- local function nameUpdateQuery( results )
- if results[1].error then fp_sqlError( results[1].error )
- return
- end
- end
- database:Query( string.format( "UPDATE guncraft_player SET name = '%s' WHERE steamid = '%s'", database:Escape( ply:Name() ), ply:SteamID() ), nameUpdateQuery )
- end
- else
- local function newEntryQuery( results )
- if results[1].error then fp_sqlError( results[1].error ) return end
- end
- database:Query( string.format( "INSERT INTO guncraft_player VALUES ('%s', '%s', 0, 0, 0, 0)", ply:SteamID(), database:Escape( ply:Name() ) ), newEntryQuery )
- end
- end
- 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