[Release] Unique Logger (Source included)

qoaway · 04/03/2012, 20:19

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 :

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>'; 
?>

Santiago2 · 06/01/2012, 06:47

Its a good info with a great job. really in a web site for more need to a best data base function, I used these all query for my data base. thanks you again.

qoaway · 06/02/2012, 14:52

~~BestOnWorld~~ · 06/02/2012, 20:48

thanks

~~Mr.Anonymous~~ · 06/02/2012, 20:49

Thanks dude

nice job

dark_man00 · 06/03/2012, 20:59

i get this error

while i run uniquelogger.exe

Syinea · 06/09/2012, 13:14

Works fine Thanks

~~ღ•Imagine•~~ · 06/11/2012, 08:50

useful thanks i will use it later

eminem5 · 06/11/2012, 11:37

great working !

~~ღ•Imagine•~~ · 06/11/2012, 12:13

tested and working good thank you ..

sarkoplata · 06/12/2012, 01:26

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 
    } 
}

yehiarekaby · 06/28/2012, 00:13

I really don't know where is that DB and i don't know where to put It plz answer me

noenergy · 08/14/2012, 15:38

hay i get an error when i run uniquequeloger.exe ...

Line 3235(File "C......"):

Error: Array variable has incorrct number of subscripts or subscript dimension range exeeded

what i must do?

spinal2 · 09/01/2012, 21:06

Quote:

Originally Posted by noenergy

hay i get an error when i run uniquequeloger.exe ...

Line 3235(File "C......"):

Error: Array variable has incorrct number of subscripts or subscript dimension range exeeded

what i must do?

Some Error Here .. So can make this without execute uniquelogger.exe ?

mamlaka · 08/29/2015, 15:13

SAME