TalkAction Perfect Bounty Hunters System with PHP for M-AAC (TFS 0.4)

[djtuca]

My php for gesior.

<?php
@mysql_connect("localhost","USERDATABASE","PASSDATABASE");
@mysql_select_db("NAMEOFDATABASE");

$main_content .= '<P ALIGN=CENTER>
    <br>
    <FONT SIZE=5 COLOR=#505050>
        Como Usar o Hunted System...
    </FONT>
    <br>
    <br>
    <FONT SIZE=2 COLOR=#505050>
    * !hunted [preço],[nome] :
        <FONT SIZE=1 COLOR=#505050>
            Automaticamente é enviada uma mensagem para todos.<br>
            Exemplo: !hunted 1000,NOMEDOPLAYER
        </FONT><br>
    </FONT>
</P>
<br>
<br>
    <center>
        <h1>
            Hunted System
        </h1>
    </center>
        <TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>
            <TR BGCOLOR="#505050">

                <TD CLASS=white width=30%>
                    <center><B>Valor</B></center>
                </TD>
                <TD CLASS=white width=30%>
                    <center><B>Hunted</B></center>
                </TD>
                <TD CLASS=white width=10%>
                    <center><B>Quem Matou</B></center>
                </TD>
            </TR>';
 $inv = @mysql_query("SELECT * FROM `bounty_hunters` ORDER BY `added` DESC");
$num = 0;
$color=$config['site']['darkborder'];
while($tab = @mysql_fetch_array($inv)){
if($num%2 == 0){$color=$config['site']['darkborder'];}else{$color=$config['site']['lightborder'];}
$pid = $tab['fp_id'];
$sid = $tab['sp_id'];
$kid = $tab['k_id'];
$killed = $tab['killed'];
$prize = $tab['prize'];
if($killed == 0){
$kill = '<font color="red">Ninguém!</font>';
}else{
$k = @mysql_query("SELECT * FROM `players` WHERE `id` = ".$kid."");
$k1 = @mysql_fetch_array($k);
$kill_name = $k1['name'];
$kill = '<a href="index.php?subtopic=characters&name='.$kill_name.'">'.$kill_name.'</a>';
}
$f = @mysql_query("SELECT * FROM `players` WHERE `id` = ".$pid."");
$f1 = @mysql_fetch_array($f);
$s = @mysql_query("SELECT * FROM `players` WHERE `id` = ".$sid."");
$s1 = @mysql_fetch_array($s);
$fn = $f1['name'];
$sn = $s1['name'];

$main_content .= '

            <TD>
                <center>
                    <b>
                        '.$prize.' gp
                    </b>
                </center>
            </TD>
            <TD>
                <center>
                    <b>
                        <a href="index.php?subtopic=characters&name='.$sn.'">'.$sn.'</a>
                    </b>
                </center>
            </TD>
            <TD>
                <center>
                    <b>
                        '.$kill.'
                    </b>
                </center>
            </TD>
        </TR>';
$num++;
}
if($num == 0){
        $main_content.='<TR BGCOLOR="'.$color.'">
            <TD colspan=4>
                <center>
                    Atualmente não tem nenhuma oferta para killar player.
                </center>
            </TD>
        </TR>';
}
        $main_content .='</TABLE><div align="right">Codec & Fixed:Hk.</div>';
?>

In my code, not show hunter player, only hunted and price.

 

[simson361]

is there a way to make a command thats like !bountylist and it will show Everyonewho has a bounty, prize, and the person who put the bounty out ?
So example
!bountylist
Mastermind, 100000gp, Issued by Jill

 

[HappyFeet]

what to change to make the script for tfs 1.0?

 

[CyCu91]

Can creat for znote aac ??

 

[Archera]

Znote page PLZ!!