Unique Ranking [PHP]

[sefa76]

Hey Guys,
This My First Release :)

Now Starting :)

I <3 Ragezone :)
Table Codes :)

CREATE TABLE [dbo].[killl](
	[name] [varchar](50) NULL,
	[uniq] [varchar](50) NULL,
	[tarih] [varchar](50) NULL
) ON [PRIMARY]

<?php

// Here Mssql Connects 



    $sqltb = "dbo.Killl"; // Table Name
    $query = $mssql->dbQuery("TRUNCATE TABLE $sqltb");


$todaydate=@date("Y-m-d");

$dosya = fopen("c:\\Users\\Administrator\\Desktop\\BlackRogue+Package\\server\\Server\\".$todaydate."_FatalLog.txt", "r");
// Here Server Path :) or Gameserver Path




while( ! feof($dosya) ) {

$yaz = fgets($dosya);
$server=substr($yaz,20,15);

    if($server=="[SR_GameServer]"){
    $uniquekilled=substr($yaz,36,22);
        if($uniquekilled=="Unique Monster Killed!"){
        $uniquekilleds=substr($yaz,36,22);
           if($uniquekilleds=="Unique Monster Killed!"){
            $data=substr($yaz,0,10);
            $hora=substr($yaz,11,8);
            
            $minutos=substr($hora,3,2);
            $hora=substr($hora,0,2);
            $minutos=(int)$minutos+(60*(int)$hora);
            $passou=$agoram-$minutos;
            $fimpos=strrpos($yaz,"]",66);
            $fimpos=$fimpos-66;
            $uniquestr=substr($line,66,$fimpos);
            $fimpos=strrpos($uniquestr,"]");
            $unique=substr($uniquestr,0,$fimpos);
            $fimpos+=6;
            $char=substr($uniquestr,$fimpos,20);
          list($tarih, $saat , $game, $uniq, $monster, $killed, $uniqadi, $by, $kill) = explode(" ", $yaz);
          $uniqueadi = explode(" ",$yaz);
          list ($perf, $log) = explode("[", $killed);
list ($perfs, $logs) = explode("]", $log);
list ($tarihh, $game, $zaman, $time) = explode("[SR_GameServer]", $tarih);
list ($tarihp, $saat) = explode("$todaydate", $tarihh);


if ($uniq == "UNIQUE[MOB_RM_TAHOMET]"){

$uniq = "Demon Shaitan";

$query = $mssql->dbQuery("INSERT INTO $sqltb(name,uniq,tarih) VALUES('".$perfs."','".$uniq."','".$saat."')");
}elseif ($uniq == "UNIQUE[MOB_TK_BONELORD]"){

$uniq = "Lord Yarkan";

$query = $mssql->dbQuery("INSERT INTO $sqltb(name,uniq,tarih) VALUES('".$perfs."','".$uniq."','".$saat."')");
}elseif ($uniq == "UNIQUE[MOB_AM_IVY]"){

$uniq = "Captain IVY";

$query = $mssql->dbQuery("INSERT INTO $sqltb(name,uniq,tarih) VALUES('".$perfs."','".$uniq."','".$saat."')");

}elseif ($uniq == "UNIQUE[MOB_OA_URUCHI]"){

$uniq = "Uruchi";

$query = $mssql->dbQuery("INSERT INTO $sqltb(name,uniq,tarih) VALUES('".$perfs."','".$uniq."','".$saat."')");
}elseif ($uniq == "UNIQUE[MOB_EU_KERBEROS]"){

$uniq = "Cerberus";

$query = $mssql->dbQuery("INSERT INTO $sqltb(name,uniq,tarih) VALUES('".$perfs."','".$uniq."','".$saat."')");
}
elseif ($uniq == "UNIQUE[MOB_KK_ISYUTARU]"){

$uniq = "Isyutaru";

$query = $mssql->dbQuery("INSERT INTO $sqltb(name,uniq,tarih) VALUES('".$perfs."','".$uniq."','".$saat."')");
}elseif ($uniq == "UNIQUE[MOB_CH_TIGERWOMAN]"){

$uniq = "Tiger Girl";

$query = $mssql->dbQuery("INSERT INTO $sqltb(name,uniq,tarih) VALUES('".$perfs."','".$uniq."','".$saat."')");
}elseif($uniq == "UNIQUE[MOB_FW_TAESE_100]"){

$uniq = "Tai Sui(100 LvL)";

$query = $mssql->dbQuery("INSERT INTO $sqltb(name,uniq,tarih) VALUES('".$perfs."','".$uniq."','".$saat."')");
}


}}





}}





fclose($dosya);?>
<div class="page-body newsblock">
    <div class="news-title">
        Unique Ranking
    </div>
    <table style="border:1px solid #3f3f3f; border-radius: 8px 8px 8px 8px;padding: 4px;background-color:rgba(50,50,50,0.55);text-align:center;color: #fff;font-weight: bold; font-family: Arial, Helvetica, sans-serif;font-size:12px;" width="100%" cellpadding="0" cellspacing="0">
        <tr>
            <td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);"></td>
            <td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);">Killer</td>
            <td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);">Uniq Name</td>
            <td style="border:1px solid #3f3f3f;background:rgba(0,0,0,0.55);">Date</td>
        </tr>
        <?php
            $rank = $mssql->dbQuery("SELECT top 50 * FROM $sqltb ORDER BY tarih desc");
            $place = 1;
            while($row = sqlsrv_fetch_array($rank, SQLSRV_FETCH_ASSOC)) {
                echo '<tr>';
                echo '<td style="border:1px solid #3f3f3f;">'.$place.'</td>';
                echo '<td style="border:1px solid #3f3f3f;">'.$row['name'].'</td>';
                echo '<td style="border:1px solid #3f3f3f;">'.$row['uniq'].'</td>';    
                echo '<td style="border:1px solid #3f3f3f;">'.$row['tarih'].'</td>';
                echo '</tr>';
                $place ++;
            }
            sqlsrv_free_stmt($rank);
        ?>
    </table>

[MentaL]

[badibatu]

nice one keep it up

[LastThief]

actually this means when each one go on that page it will get executed and the player will get new points lol you're making it too complex here is snippet of code

if($server=="[SR_GameServer]"){
$uniquekilled=substr($line,36,22);
if($uniquekilled=="Unique Monster Killed!"){
$pos=strrpos($line,"]",66);
$pos=$pos-66;
$uniquestr=substr($line,66,$pos);
$pos=strrpos($uniquestr,"]");
$unique=substr($uniquestr,0,$pos);
$pos+=6;
$char=substr($uniquestr,$pos,20);
getUniqueKills($unique,$char);

}

}

[NoMore]

Fatal error: Call to a member function dbQuery() on a non-object in C:\AppServ\www\uniqueranking.php on line 8

Line 8= $query = $mssql->dbQuery("TRUNCATE TABLE $sqltb");

[nonesense1]

this is working good (the rank itself)
but i get those :

Notice: Undefined variable: agoram in C:\xampp\htdocs\mod\uniquekill.php on line 32

Notice: Undefined variable: line in C:\xampp\htdocs\mod\uniquekill.php on line 35

Notice: Undefined offset: 8 in C:\xampp\htdocs\mod\uniquekill.php on line 40

Notice: Undefined offset: 7 in C:\xampp\htdocs\mod\uniquekill.php on line 40

Notice: Undefined offset: 6 in C:\xampp\htdocs\mod\uniquekill.php on line 40

hundreds of those.. and in the bottom the ranking (does work!)

anyway to remove those errors ?

[nlginsane]

to remove php errors fix them or dirty-fix them by putting this into your script:

error_reporting(0);

have fun =)

[nonesense1]

well , that's what i did - but still those errors not coming from no where.. , they must be there because something is **** up..

i would love to know how to fix them :D

i already got rid for few of them by removing not decleared data.

[asi]

help error

Fatal error: Call to a member function dbQuery() on a non-object in C:\AppServ\www\index.php on line 8

[ajan005]

Warning: mssql_query() [function.mssql-query]: Unable to connect to server: (null) in C:\AppServ\www\rank\rank.php on line 7

Warning: mssql_query() [function.mssql-query]: A link to the server could not be established in C:\AppServ\www\rank\rank.php on line 7

Warning: mssql_query() [function.mssql-query]: Unable to connect to server: (null) in C:\AppServ\www\rank\rank.php on line 59

Warning: mssql_query() [function.mssql-query]: A link to the server could not be established in C:\AppServ\www\rank\rank.php on line 59

Warning: mssql_query() [function.mssql-query]: Unable to connect to server: (null) in C:\AppServ\www\rank\rank.php on line 75

Warning: mssql_query() [function.mssql-query]: A link to the server could not be established in C:\AppServ\www\rank\rank.php on line 75

Fatal error: Maximum execution time of 30 seconds exceeded in C:\AppServ\www\rank\rank.php on line 75



Guys help to fix this lines.
Whats the wrongs with php codes?

[stanler]

Fatal error: Call to a member function dbQuery() on a non-object in C:\AppServ\www\index.php on line 8

how can i fix this?

[anikan1985]

its not working for me :(

[Murderer05]

I need Asp Versiyon pls help me

[stanler]

so almost work now... change the "$mssql->dbQuery" to "mssql_query" and the db errors gone. One thing i can't understand. What is this: Notice: Undefined variable: line? "$line" is not defined? o.O