[Release] Unique Logger (Source included)

how it works ?
-it reads daily logs and updates uniques who killed, spawn time etc. like old rev6
how to setup ?
1-run this query on shard db

Spoiler

2-extract uniquelogger.exe to your server files folder (gameserver's folder)

3-edit config.ini with your db settings

4-run & enjoy !

download : [Only registered and activated users can see links. Click Here To Register...]

simple php script for reading logs from db :

PHP Code:


			
<?



    $host     = "db_server";

    $user     = "db_id";

    $pass     = "db_pw";

    $db      = "db_name";

$sConn = odbc_connect("Driver={SQL Server};Server={".$host."}; Database={".$db."}", "".$user."", "".$pass."") or die("<center><b style=\"border:1px dashed #FF0000;\">".str_replace("[Microsoft][ODBC SQL Server Driver][SQL Server]", "", odbc_errormsg())."</b></center>");



$query = odbc_exec($sConn,"SELECT * FROM UniqueStatus ORDER BY ID");

echo '<table border=1>

<tr>

<th>Unique</th>

<th>Spawned Time</th>

<th>Killer</th>

<th>Killed Time</th>

</tr>';

while($row = odbc_fetch_array($query))

{

    echo '

    <tr>

    <td>'.$row['Unique'].'</td>

    <td>'.$row['SpawnTime'].'</td>

    <td>'.$row['Killer'].'</td>

    <td>'.$row['KilledTime'].'</td>

    </tr>

    ';

}

echo '</table>';

?>

Personally I would do this via PHP :)

PHP Code:


			
$fullpath = 'path to gameserver.exe' . "\\" . 'file name of fatallog.txt. 

You have to choose the latest one.'; // Be careful using slashes



$fileArray = file($fullpath);      

 foreach($fileArray as $key => $value)

{

    if(stristr($value, "UNIQUE MONSTER KILLED") !== FALSE)

    {

        $explodearray = explode("\t", $value);

        $time = $explodearray[0] . " " . $explodearray[1];

        $alltext = str_replace("Unique Monster Killed! UNIQUE[", "", $explodearray[3]);

        $exploded = explode("] by [", $alltext);                                                              

        $uniquename = $exploded[0];

        $killername11 = str_replace("]", "", $exploded[1]);

        $killername = trim($killername11);

                            

        writetodb($uniquename, $killername, $time);

          // your own function to write into database

    }

}