[Modern ACC]Having problems with Creature Killer Page

[pwner123]

http://otland.net/f118/modern-aac-page-most-creature-killers-82768/

Hello everyone, I have the ingame count of monsters working, but the modernaac page won't even load. http://immortalsot.no-ip.biz//index.php/p/v/creaturekillers is proof.

<?PHP


/* Scrip by zonet */
/* Modern Aac version by Kavvson */
/* Kill configuration */
$kills = array('dragon' => 9541, 'dragon lord' => 9542, 'frost dragon' => 9543, 'wyrm' => 9544, 'demon' => 9545, 'rotworm' => 9546, 'vampire' => 9547, 'draken elite' => 9548, 'draken abomination' => 9549, 'draken warmaster' => 9550, 'nightmare' => 9551, 'nightmare scion' => 9552, 'grim reaper' => 9553, 'juggernaut' => 9554, 'behemoth' => 9555, 'hellhound' => 9556, 'hero' => 9557, 'warlock' => 9558, 'lich' => 9559, 'dark torturer' => 9560, 'diabolic imp' => 9561, 'destroyer' => 9562, 'hand of cursed fate' => 9563, 'plaguesmith' => 9564, 'undead dragon' => 9565, 'ghastly dragon' => 9566, 'bog raider' => 9567, 'draken spellweaver' => 9568, 'lizard chosen' => 9569, 'lizard dragon priest' => 9570, 'lizard high guard' => 9571, 'lizard legionnaire' => 9572, 'lizard sentinel' => 9573, 'lizard snakecharmer' => 9574, 'lizard templar' => 9575, 'lizard zaogun' => 9576, 'lizard magistratus' => 9577, 'lizard noble' => 9578, 'banshee' => 9579, 'spectre' => 9580, 'blightwalker' => 9581, 'quara constrictor' => 9582, 'quara hydromancer' => 9583, 'quara mantassin' => 9584, 'quara pincher' => 9585, 'quara predator' => 9586, 'black knight' => 9587 'phantasm' => 9588);
$limit= 5;
/* Color config */
$color1 = "#a46f00" ;

ECHO '<table border="0px" cellspacing="1px" cellpadding="4px" width="100%">
            <tr bgcolor="'.$color1.'" style="color: white;"><th width="10%">Creature</th><th>Creature name</th><th>Most Killer ( '.$limit.' )</th></tr>';
$row = 1;
    foreach($kills as $name => $storage) {
    $qa = $SQL->query('SELECT `player_storage`.`player_id`, `player_storage`.`key`, `player_storage`.`value` AS `value`, `players`.`id`, `players`.`name` AS `name` FROM `player_storage` LEFT JOIN `players` ON `player_storage`.`player_id` = `players`.`id` WHERE `player_storage`.`key` = '.$storage.' ORDER BY ABS(value) DESC LIMIT '.$limit)->fetchAll();
  /* Color config */
  $color = ( $row % 2 ? "#e5cc97" : "#eeddb9" );
   $row++;
    ECHO '<tr bgcolor="'.$color.'"><td><img src="/monsters/'.(str_replace("></td><td width="20%" style="font-size: 13pt; font-weight: bold; color: darkorange;"><center>'.(ucfirst($name)).'</center></td><br /><td>';
        $a = 0;
        foreach( $qa as $q )
        {
            $a++;
            if($a == 1)
                ECHO '<font color="green">';
            if($a == $limit)
                ECHO '<font color="red">';
            if($a == $limit/2)
                ECHO '<font color="darkorange">';

            ECHO '<b>'.$a.'. Name:</b> <a href="'.WEBSITE.'/index.php/character/view/'.$q['name'].'">'.$q['nam<br />e'].'</a> (Kills:  '.$q['value'].') </font></font></font><br />';
        }
    }
    ECHO '</td></table>';
?>

 

[Ninja]

<?PHP
/* Scrip by zonet */
/* Modern Aac version by Kavvson */
/* Kill configuration */
$kills = array('dragon' => 9541, 'dragon lord' => 9542, 'frost dragon' => 9543, 'wyrm' => 9544, 'demon' => 9545, 'rotworm' => 9546, 'vampire' => 9547, 'draken elite' => 9548, 'draken abomination' => 9549, 'draken warmaster' => 9550, 'nightmare' => 9551, 'nightmare scion' => 9552, 'grim reaper' => 9553, 'juggernaut' => 9554, 'behemoth' => 9555, 'hellhound' => 9556, 'hero' => 9557, 'warlock' => 9558, 'lich' => 9559, 'dark torturer' => 9560, 'diabolic imp' => 9561, 'destroyer' => 9562, 'hand of cursed fate' => 9563, 'plaguesmith' => 9564, 'undead dragon' => 9565, 'ghastly dragon' => 9566, 'bog raider' => 9567, 'draken spellweaver' => 9568, 'lizard chosen' => 9569, 'lizard dragon priest' => 9570, 'lizard high guard' => 9571, 'lizard legionnaire' => 9572, 'lizard sentinel' => 9573, 'lizard snakecharmer' => 9574, 'lizard templar' => 9575, 'lizard zaogun' => 9576, 'lizard magistratus' => 9577, 'lizard noble' => 9578, 'banshee' => 9579, 'spectre' => 9580, 'blightwalker' => 9581, 'quara constrictor' => 9582, 'quara hydromancer' => 9583, 'quara mantassin' => 9584, 'quara pincher' => 9585, 'quara predator' => 9586, 'black knight' => 9587, 'phantasm' => 9588); 
$limit= 5;
require("config.php");
$ots = POT::getInstance();
$ots->connect(POT::DB_MYSQL, connection());
$SQL = $ots->getDBHandle();
/* Color config */
$color1 = "#a46f00" ;

ECHO '<table border="0px" cellspacing="1px" cellpadding="4px" width="100%">
            <tr bgcolor="'.$color1.'" style="color: white;"><th width="10%">Creature</th><th>Creature name</th><th>Most Killer ( '.$limit.' )</th></tr>';
$row = 1;
    foreach($kills as $name => $storage) {
    $qa = $SQL->query('SELECT `player_storage`.`player_id`, `player_storage`.`key`, `player_storage`.`value` AS `value`, `players`.`id`, `players`.`name` AS `name` FROM `player_storage` LEFT JOIN `players` ON `player_storage`.`player_id` = `players`.`id` WHERE `player_storage`.`key` = '.$storage.' ORDER BY ABS(value) DESC LIMIT '.$limit)->fetchAll();
  /* Color config */
  $color = ( $row % 2 ? "#e5cc97" : "#eeddb9" );
   $row++;
    ECHO '<tr bgcolor="'.$color.'"><td><img src="/monsters/'.(str_replace(" ", "" , $name)).'.gif"></td><td width="20%" style="font-size: 13pt; font-weight: bold; color: darkorange;"><center>'.(ucfirst($name)).'</center></td><td>';
        $a = 0;
        foreach( $qa as $q )
        {
            $a++;
            if($a == 1)
                ECHO '<font color="green">';
            if($a == $limit)
                ECHO '<font color="red">';
            if($a == $limit/2)
                ECHO '<font color="darkorange">';

            ECHO '<b>'.$a.'. Name:</b> <a href="'.WEBSITE.'/index.php/character/view/'.$q['name'].'">'.$q['name'].'</a> (Kills:  '.$q['value'].') </font></font></font><br />';
        }
    }
    ECHO '</td></table>';
?>

 

[pwner123]

Same result with that script.

- - - Updated - - -

Still having this issue. Help please?

 

[pwner123]

bump

 

[Ninja]

I suggest that you add this to your index, so you could find out where the error is located at.

error_reporting(E_ALL ^ E_STRICT ^ E_NOTICE);
ini_set( 'display_errors', 1 );

 

[pwner123]

"Parse error: syntax error, unexpected ':' in systempathwouldbehere/creaturekillers.php on line 9" is the result when I add that which would refer to this line"$ots->connect(POT:B_MYSQL, connection());

 

[Ninja]

​Replace that line with this.

$ots->connect(POT::DB_MYSQL, connection());

 

[pwner123]

"Parse error: syntax error, unexpected '20' (T_LNUMBER) in systempathhere\creaturekillers.php on line 23" ECHO '<tr bgcolor="'.$color.'"><td><img src="/monsters/'.(str_replace("></td><td width="20%" style="font-size: 13pt; font-weight: bold; color: darkorange;"><center>'.(ucfirst($name)).'</center></td><td>'; is line 23

 

[pwner123]

bump.

 

[Ninja]

There is nothing wrong with it though since it's loading perfectly for me.

 

[pwner123]

All I see is a white page with that error on it.