Advertisement
Guest User

Untitled

a guest
Oct 18th, 2017
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.67 KB | None | 0 0
  1. else if ( cmd == "!baninfo" )
  2. {
  3. local q = QuerySQL(db, "SELECT * FROM Bans WHERE Nome='" + text + "'" );
  4. local q2 = QuerySQL(db, "SELECT * FROM Banned WHERE ban_nick='" + text + "'" );
  5. local q3 = QuerySQL(db, "SELECT * FROM BansWarns WHERE Nome='" + text + "'" );
  6. if ( !text ) return EchoMessage( "9[Sintaxe] - !baninfo <Nick Completo>");
  7. if ( GetSQLColumnData( q, 0 ) != text && GetSQLColumnData( q2, 0 ) != text && GetSQLColumnData( q3, 0 ) != text ) return EchoMessage( "4[Erro] - " + text + " nao esta banido." );
  8. else
  9. {
  10. if ( GetSQLColumnData( q, 0 ) == text )
  11. {
  12. 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 ) + "." );
  13. }
  14. else if ( GetSQLColumnData( q2, 0 ) == text )
  15. {
  16. local Time_Left = TimeRem( GetSQLColumnData( q, 3 ).tointeger(), GetSQLColumnData( q, 5 ) );
  17. 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 + "." );
  18. }
  19. else if ( GetSQLColumnData( q3, 0 ) == text )
  20. {
  21. 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 ) + "." );
  22. }
  23. }
  24. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement