MuhammadZeeshan

unwarn irc cmd

Dec 14th, 2016
45
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C++ 1.08 KB | None | 0 0
  1. else if ( cmd == "!unwarn" )
  2.     {
  3.         if ( level < 3 ) EchoNotice1( user, ICOL_RED + "Error - Your level is not high enough to use that command." );
  4.         else if ( !text ) EchoNotice1( user, ICOL_RED + "Error - Syntax: " + cmd + " <Nick/ID>");
  5.         else
  6.         {
  7.             local plr = FindPlayer(GetTok( text, " ", 1 ));
  8.             if(plr)
  9.             {
  10.                local q = QuerySQL( db, "SELECT * FROM Warning WHERE Name ='" + plr.Name + "'");
  11.                     if ( !GetSQLColumnData( q, 0 ) ) EchoNotice1( user, ICOL_RED + "Error - " + plr.Name + " didn't get any warns.");
  12.                     else if ( GetSQLColumnData( q, 0 ) == "0" ) EchoNotice1( user, ICOL_RED + "Error - " + plr.Name + " didn't get any warns.");
  13.                     else
  14.                     {
  15.                     local warntotal = "0";
  16.                     QuerySQL( db, "UPDATE Warning SET Totalwarns='" + warntotal + "' WHERE Name='" + plr.Name + "'")
  17.                     Message( RED+"Admin "+user+" has unwarned "+plr.Name+".");
  18.                     EchoMessage1( ICOL_RED+"Admin "+user+" has unwarned "+plr.Name+".");
  19.                    
  20.                     }
  21.                     FreeSQLQuery( q );
  22.                
  23.                
  24.             }
  25.             else EchoNotice1( user, ICOL_RED + "Error - Unknown Player");
  26.         }
  27.     }
Add Comment
Please, Sign In to add comment