Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function levelup.database.init()
- if not sql.TableExists( "levelup_players" ) then
- levelup.database.query( "CREATE TABLE levelup_players ( id INTEGER, level INTEGER, experience INTEGER )" )
- end
- end
- function levelup.database.fetch( ply )
- return levelup.database.query( "SELECT * FROM levelup_players WHERE id = " .. ply:UniqueID() )
- end
- function levelup.database.add( ply )
- levelup.database.query( "INSERT INTO levelup_players ( id, level, experience ) VALUES ( " .. ply:UniqueID() .. ", 0, 0 )" )
- end
- function levelup.database.save( ply )
- levelup.database.query( "UPDATE levelup_players SET level = " .. ply.levelup.level .. ", experience = " .. ply.levelup.experience .. " WHERE id = " .. ply:UniqueID() )
- end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement