MuhammadZeeshan

asdgas sdg sdfgh asdfh

Dec 19th, 2016
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.90 KB | None | 0 0
  1. function Login( player, password )
  2. {
  3. try
  4. {
  5. local query = QuerySQL(db, "SELECT * FROM Accounts WHERE Name = '"+player.Name+"'" );
  6. if ( GetSQLColumnData( query, 0 ) != null )
  7. {
  8. status[ player.ID ].Kills = GetSQLColumnData( query, 4 );
  9. status[ player.ID ].Level = GetSQLColumnData( query, 2 );
  10. status[ player.ID ].Deaths = GetSQLColumnData( query, 5 );
  11. status[ player.ID ].Cash = GetSQLColumnData( query, 6 );
  12. status[ player.ID ].Bank = GetSQLColumnData( query, 7 );
  13. status[ player.ID ].Joins = GetSQLColumnData( query, 8 );
  14. status[ player.ID ].Randspawn = GetSQLColumnData( query, 10 );
  15. status[ player.ID ].Nogoto = GetSQLColumnData( query, 11 );
  16. status[ player.ID ].VIPLevel = GetSQLColumnData( query, 12 );
  17. status[ player.ID ].phone = GetSQLColumnData( query, 14 );
  18. status[ player.ID ].ptime = GetSQLColumnData( query, 15 );
  19. if ( status[ player.ID ].ptime > 0 )
  20. {
  21. status[ player.ID ].ptime = time() + status[ player.ID ].ptime;
  22. }
  23. else status[ player.ID ].ptime = time();
  24. }
  25.  
  26. status[ player.ID ].Registered = true;
  27. status[ player.ID ].Logged = true;
  28. status[ player.ID ].LastIPUsed = player.IP;
  29. status[ player.ID ].Joins++;
  30. QuerySQL(db, "UPDATE Accounts SET LastIPUsed='" + player.IP + "' WHERE Name='" + player.Name + "'");
  31. player.Cash = status[ player.ID ].Cash;
  32. SendMessage( "[#008000][SUCCESS] - [#FFFFFF]You have been successfully logged in the community.", player );
  33. SendMessage( "[#008000][INFORMATION] - [#FFFFFF]Nick: [ " +player.Name+ " ], Level: [ " +GetLevel( player )+ " ], Last IP: [ " +LastIP( player )+ " ].", player );
  34. ServerMessage( "[LOGIN] - [#8000FF]" +player.Name+ " has been identified as level (" +GetLevel( player )+ ")." );
  35. EchoMessage( ICOL_GREY+"[LOGIN] "+ICOL_PURPLE+" - " +player.Name+ " has been identified as level (" +GetLevel( player )+ ")." );
  36. FreeSQLQuery( query );
  37. }
  38. catch(e) print( "login function Error: " + e );
  39.  
  40. }
Add Comment
Please, Sign In to add comment