Advertisement
Guest User

Untitled

a guest
Feb 27th, 2017
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. function levelup.database.init()
  2. if not sql.TableExists( "levelup_players" ) then
  3. levelup.database.query( "CREATE TABLE levelup_players ( id INTEGER, level INTEGER, experience INTEGER )" )
  4. end
  5. end
  6.  
  7. function levelup.database.fetch( ply )
  8. return levelup.database.query( "SELECT * FROM levelup_players WHERE id = " .. ply:UniqueID() )
  9. end
  10.  
  11. function levelup.database.add( ply )
  12. levelup.database.query( "INSERT INTO levelup_players ( id, level, experience ) VALUES ( " .. ply:UniqueID() .. ", 0, 0 )" )
  13. end
  14.  
  15. function levelup.database.save( ply )
  16. levelup.database.query( "UPDATE levelup_players SET level = " .. ply.levelup.level .. ", experience = " .. ply.levelup.experience .. " WHERE id = " .. ply:UniqueID() )
  17. end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement