Solved [GESIOR] Bounty Hunters.php

[Sentinel3]

Hi otlanders,

Got this error on my website when I add bounty hunter system, something wrong in .php file?

Warning: Invalid argument supplied for foreach() in /home/otsmanager/www/public_html/pages/bounty-hunters.php on line 41

Bounty-hunters.php

<?php
$main_content .= '
    <TABLE BORDER=0 CELLPADDING=4 CELLSPACING=1 WIDTH=100%>
        <TR>
            <TD style="text-align:center;"><H2>Bounty Hunters</H2></TD>
        </TR>
        <TR BGCOLOR="'.$config['site']['vdarkborder'].'">
            <TD><CENTER><FONT COLOR=WHITE SIZE=2><b>How to use...</b></FONT></CENTER></TD>
        </TR>
        <TR BGCOLOR="'.$config['site']['darkborder'].'">
            <TD style="text-align:center;"><b>!hunt prize,nick</b>
       <br><font color="red">It is important to right exactly like this <b>prize,nick</b> with no spaces after the comma.</font>
            <br><i>Example: !hunt 100,MrJohn
            <br> Will Pay 100 gold coins for the Player who Kills Player_name.</i>
<br><b><font color="green">Money is added to your bank account automatically if you get a Bounty Kill.</font></b></TD>
        </TR>
</TABLE><br><br><table>
';
$main_content .= '
        <TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>
            <TR BGCOLOR="#505050">
                <TD CLASS=white width=28%>
                    <center><B>Hunted by</B></center>
                </TD>
                <TD CLASS=white width=14%>
                    <center><B>Reward</B></center>
                </TD>
                <TD CLASS=white width=28%>
                    <center><B>Player hunted</B></center>
                </TD>
        <TD CLASS=white><b>Outfit</b></TD>
                <TD CLASS=white width=28%>
                    <center><B>Killed by</B></center>
                </TD>
            </TR>';
foreach($SQL->query('SELECT A.* , B.name AS hunted_by, C.name AS player_hunted, D.name AS killed_by
                        FROM bounty_hunters AS A
                        LEFT JOIN players AS B ON A.fp_id = B.id
                        LEFT JOIN players AS C ON A.sp_id = C.id
                        LEFT JOIN players AS D ON A.k_id = D.id
                        ORDER BY A.killed,A.prize DESC') as $bounty) {
        if($num%2 == 0){$color=$config['site']['darkborder'];}else{$color=$config['site']['lightborder'];}
        if ($bounty['killed_by']){
                $killed_by = '<a href="?subtopic=characters&name='.$bounty['killed_by'].'">'.$bounty['killed_by'].'</a>';
        } else {
                $killed_by = 'still alive';
        }
    $b = round($bounty[prize] / 1000000,2);
    $skill = $SQL->query('SELECT * FROM '.$SQL->tableName('players').' WHERE '.$SQL->fieldName('id').' = '.$bounty['sp_id'].'')->fetch();
        $main_content .= '
                <TR BGCOLOR="'.$color.'">
                    <TD><center><b><a href="?subtopic=characters&name='.$bounty['hunted_by'].'">'.$bounty['hunted_by'].'</a></b></center></TD>
                    <TD><center><b>'.$b.'  kk</b></center></TD>
                    <TD><center><b><a href="?subtopic=characters&name='.$bounty['player_hunted'].'">'.$bounty['player_hunted'].'</a></b></center></TD>
           <TD><div style="position: relative; width: 32px; height: 32px;"><div style="background-image: url(\'http://outfit-images.ots.me/outfit.php?id='.$skill['looktype'].'&addons='.$skill['lookaddons'].'&head='.$skill['lookhead'].'&body='.$skill['lookbody'].'&legs='.$skill['looklegs'].'&feet='.$skill['lookfeet'].'\'); position: absolute; width: 64px; height: 80px; background-position: bottom right; background-repeat: no-repeat; right: 0px; bottom: 0px;"></div></div></TD>
                    <TD><center><b>'.$killed_by.'</b></center></TD>
                </TR>';
        $num++;
}
if($num == 0){
        $main_content.='<TR BGCOLOR="'.$color.'"><TD colspan=4><center>Currently there are not any bounty hunter offer.</center></TD></TR>';
}
    $main_content .='</TABLE></table>';
?>

 

[Sentinel3]

Bump

 

[53701688]

Mostly that error happens if he tries to fetch a value that doesnt exist inside the table getting it from. maybe check the query and the tables and see if it does match.

 

[Sentinel3]

@53701688 I can't understand you exactly, I know where can I find the Query and Tables. But how can I fix the .php file?
I should search another script? Or maybe change something in script?
Becouse my experience in Gesior is == null

 

[53701688]

Everyones knowledge of gesior == null did you see the codes? ^^

 

[Sentinel3]

Yes but I'm not editing lua right now. I need to fix the .php file, can you help me?

 

[Sentinel3]

Bump

 

[imkingran]

Did you already add the tables?

CREATE TABLE IF NOT EXISTS `bounty_hunters` (
  `id` int(11) NOT NULL auto_increment,
  `fp_id` int(11) NOT NULL,
  `sp_id` int(11) NOT NULL,
  `k_id` int(11) NOT NULL,
  `added` int(15) NOT NULL,
  `prize` bigint(20) NOT NULL,
  `killed` int(11) NOT NULL,
  `kill_time` int(15) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

It would have been better if you posted this problem on the main thread: http://otland.net/threads/tfs-1-0-bounty-hunter-system.213135/, so that other players who maybe a similar problem could find it on the same thread as well. (but no worries, just for next time )

 

[Sentinel3]

Alright I'm so sorry, I miss the table! Thank you for answer me.


<Solved>