BF2S Forums Ban database

Originally posted on www.bf2cc.com
<?php

/*
LogHash.php
Created by Mugzy
email: Mugzy@mugzy.org

--Usage--
This script will connect to your BF2 server and record the hashes to a MySQL DB.

--Setup--
Create a new MySQL database and run the following SQL to create the required table:
CREATE TABLE `bf2hash` (
  `iname` varchar(255) NOT NULL default '',
  `hash` varchar(255) NOT NULL default '',
  `date` datetime default NULL
) TYPE=MyISAM;

--Configuration--
Enter your servers ip, port, and rcon password.
Enter the database server, username, password, and database name.
*/

session_start();
putenv("TZ=US/Eastern");

buildlist("ip","rconport","rconpassword");

function buildlist($server, $port, $password)
{
   ob_start();

   $dbserver = "ip";
   $dbuser = "user";
   $dbPass = "pass";
   $dbName = "dbname";
   $dbTable = "bf2hash";
   $link = mysql_connect ($dbserver, $dbuser, $dbPass)
        or die ("Could not connect");
   $results = mysql_select_db($dbName,$link)
      or die('failed because '.mysql_error());
   $timeout = 5;

   if(!$handle = @fsockopen($server, $port, $errno, $errstr, $timeout))
      {
         echo "Could not connect to server: " . $server . "<br>";
         ob_end_flush();
         flush();
      }
      else
      {
         socket_set_timeout($handle, $timeout);
         @fread($handle,128);
         $keyzeile = @fread($handle,33);
         $key = str_replace("### Digest seed: ", "", $keyzeile);
         $pass_send = "login " . digest($key, $password) . "\n";

         @fwrite($handle, $pass_send);
         @fgets($handle);
         @fgets($handle);
         $antwort = @fgets($handle);
         if(substr_count($antwort, "failed"))
           {
              echo "Login failed<br>";
              ob_end_flush();
              flush();
              return;
           }

         $cmd = "exec admin.listPlayers\n";
         @fwrite($handle, $cmd);
         $eofplist = false;
         echo "Building Player List...<br>";
         flush();
         while( !$eofplist )
            {
               $result = @fgets($handle);

               if(trim($result) == "")
               {
                  return;
                  $eofplist = true;
               }
               else
               {
                  $result = str_replace("  ", " ", $result);
        $columns = explode(" ", trim($result));
        if(count($columns)==10)$columns[3]=$columns[3]." ".$columns[4]; // add this line
        $result2 = @fgets($handle);
        $columns2 = explode(" ", trim($result2));
                  $ipcolumn = explode(":", $columns[7]);
                     {
                        $sql="select count(hash) as cnt, hash from $dbTable where iname = '$columns[3]' group by iname";
                        $result=MySQL_query($sql,$link) or die('failed because '.mysql_error());

                        $myrow=MySQL_fetch_array($result);
                        if($myrow['cnt'] > 0)
                           {
                              echo "$columns[3] is already in database<br>";
                           }
                           else
                           {
                              echo "Adding " . $columns[3] . " " . $columns2[2] . " to database<br>";
                              mysql_select_db($dbName,$link);
                              $sql="insert into $dbTable (iname, hash, date) VALUES('$columns[3]', '$columns2[2]', SYSDATE())";
                              $result=MySQL_query($sql,$link) or die('failed because '.mysql_error());

                              flush();
                           }
                        }
                  }
            }
      }
}

function digest($seed, $pw)
{
   $m = md5($seed . $pw);
   return $m;
}

?>

Originally posted on www.bf2cc.com
<?php
/*
Findhash.php
Created by Mugzy
email: Mugzy@mugzy.org

Usage: This script will allow you to lookup players by name or hash.

Configuration: Just enter the database server, username, and database name.
*/

session_start();
putenv("TZ=US/Eastern");

//---Configuration for database where hashes are stored.---

$dbserver = "ip";
$dbuser = "user";
$dbPass = "pass";
$dbName = "dbname";
$dbTable = "bf2hash";

//---End configuration---


//...connect to the database...
$link = mysql_connect ($dbserver, $dbuser, $dbPass)
        or die ("Could not connect");
mysql_select_db($dbName,$link);


echo "<title>BF2 Hash Lookup</title><strong><font size=5 face=Arial, Helvetica, sans-serif>BF2 Hash Lookup<br></font></strong>Created by <A href=mailto:mugzy@mugzy.org>Mugzy</a><p>";


if ($name == "") //...If $name is empty, we display the form...
   {
      $sql="select count(*) as count from $dbTable"; //...Get a count of records in the database...
      $result=MySQL_query($sql,$link);
      $row = mysql_fetch_array($result);
      echo "This system currently has the CD hash value for <b>" . $row['count'] . "</b> players.<br>";
      echo "<form method=get>Enter part of a player's name or CD hash:<br><input type=text name=name><br><input type=radio name=type value=name checked>Name        <input type=radio name=type value=hash>Hash<br><br><input type=submit value=Submit></form>";
   }
   else
   {
      if(strlen($name) < 3) //..Make them enter at least 3 characters of a name to search on.
         {
            echo "Error, you must enter at least 3 characters!<br>";
            echo "<a href=?>Back</a>";
            exit();
         }

      if ($type == "name")  //...If they searched for a name..
         {
            $sql="select * from $dbTable where iname like '%". $name ."%' order by iname";
         }
         else //..They searched for a hash...
         {
            $sql="select * from $dbTable where hash like '%". $name ."%' order by iname";
         }

      $result=MySQL_query($sql,$link) or die('failed because '.mysql_error());
          echo "<a href=?>Back</a>";

//...Lets build the results table...
      echo "<table cellpadding=3 bordercolor=black border=2><tr><td><b>Name</b></td><td><b>Hash</b></td><td><b>Date Added</b></td></tr>";

      while($myrow=MySQL_fetch_array($result))
         {
            echo "<tr><td>" . $myrow['iname'] . "</td><td>" . $myrow['hash'] . "</td><td>" . $myrow['date'] . "</td>";
            echo "</tr>";
            $x1 = 1;
         }
         if($x1 != 1)
            {
               echo "<tr><td colspan=5><b>No records found for " . $name . ".</b></td></tr>";
            }
         echo "</table>";
   }
?>

Last edited by RealBomber (2007-01-27 18:14:13)