Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function Login( player, password )
- {
- try
- {
- local query = QuerySQL(db, "SELECT * FROM Accounts WHERE Name = '"+player.Name+"'" );
- if ( GetSQLColumnData( query, 0 ) != null )
- {
- status[ player.ID ].Kills = GetSQLColumnData( query, 4 );
- status[ player.ID ].Level = GetSQLColumnData( query, 2 );
- status[ player.ID ].Deaths = GetSQLColumnData( query, 5 );
- status[ player.ID ].Cash = GetSQLColumnData( query, 6 );
- status[ player.ID ].Bank = GetSQLColumnData( query, 7 );
- status[ player.ID ].Joins = GetSQLColumnData( query, 8 );
- status[ player.ID ].Randspawn = GetSQLColumnData( query, 10 );
- status[ player.ID ].Nogoto = GetSQLColumnData( query, 11 );
- status[ player.ID ].VIPLevel = GetSQLColumnData( query, 12 );
- status[ player.ID ].phone = GetSQLColumnData( query, 14 );
- status[ player.ID ].ptime = GetSQLColumnData( query, 15 );
- if ( status[ player.ID ].ptime > 0 )
- {
- status[ player.ID ].ptime = time() + status[ player.ID ].ptime;
- }
- else status[ player.ID ].ptime = time();
- }
- status[ player.ID ].Registered = true;
- status[ player.ID ].Logged = true;
- status[ player.ID ].LastIPUsed = player.IP;
- status[ player.ID ].Joins++;
- QuerySQL(db, "UPDATE Accounts SET LastIPUsed='" + player.IP + "' WHERE Name='" + player.Name + "'");
- player.Cash = status[ player.ID ].Cash;
- SendMessage( "[#008000][SUCCESS] - [#FFFFFF]You have been successfully logged in the community.", player );
- SendMessage( "[#008000][INFORMATION] - [#FFFFFF]Nick: [ " +player.Name+ " ], Level: [ " +GetLevel( player )+ " ], Last IP: [ " +LastIP( player )+ " ].", player );
- ServerMessage( "[LOGIN] - [#8000FF]" +player.Name+ " has been identified as level (" +GetLevel( player )+ ")." );
- EchoMessage( ICOL_GREY+"[LOGIN] "+ICOL_PURPLE+" - " +player.Name+ " has been identified as level (" +GetLevel( player )+ ")." );
- FreeSQLQuery( query );
- }
- catch(e) print( "login function Error: " + e );
- }
Add Comment
Please, Sign In to add comment