Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- else if ( cmd == "!baninfo" )
- {
- local q = QuerySQL(db, "SELECT * FROM Bans WHERE Nome='" + text + "'" );
- local q2 = QuerySQL(db, "SELECT * FROM Banned WHERE ban_nick='" + text + "'" );
- local q3 = QuerySQL(db, "SELECT * FROM BansWarns WHERE Nome='" + text + "'" );
- if ( !text ) return EchoMessage( "9[Sintaxe] - !baninfo <Nick Completo>");
- if ( GetSQLColumnData( q, 0 ) != text && GetSQLColumnData( q2, 0 ) != text && GetSQLColumnData( q3, 0 ) != text ) return EchoMessage( "4[Erro] - " + text + " nao esta banido." );
- else
- {
- if ( GetSQLColumnData( q, 0 ) == text )
- {
- EchoMessage("1[4Baninfo1] - 7Nome3: " + GetSQLColumnData( q, 0 ) + " 4|| 7Admin Que baniu3: " + GetSQLColumnData( q, 2 ) + " 4|| 7 Motivo3: " + GetSQLColumnData( q, 3 ) + " 4|| 7 Data3: " + GetSQLColumnData( q, 4 ) + "." );
- }
- else if ( GetSQLColumnData( q2, 0 ) == text )
- {
- local Time_Left = TimeRem( GetSQLColumnData( q, 3 ).tointeger(), GetSQLColumnData( q, 5 ) );
- EchoMessage("1[4Baninfo1] - 7Nome3: " + GetSQLColumnData( q2, 0 ) + " 4|| 7Admin Que baniu3: " + GetSQLColumnData( q2, 5 ) + " 4|| 7 Motivo3: " + GetSQLColumnData( q2, 6 ) + " 4|| 7 Data3: " + GetSQLColumnData( q2, 2 ) + " 4|| 7 Expira em3: " + Time_Left + "." );
- }
- else if ( GetSQLColumnData( q3, 0 ) == text )
- {
- EchoMessage("1[4Baninfo1] - 7Nome3: " + GetSQLColumnData( q3, 0 ) + " 4|| 7Admin Que baniu3: " + GetSQLColumnData( q3, 2 ) + " 4|| 7 Motivo3: " + GetSQLColumnData( q3, 3 ) + " 4|| 7 Data3: " + GetSQLColumnData( q3, 4 ) + "." );
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement