Bounty Hunters - Problem

Lava Titan · Nov 24, 2009

Can some1 help me in this PHP Script?
I'm using 0.3.5 pl1.

Script from:

http://layouts.4za.pl/pscripts/61-bounty-hunters-system-player-hunt-system.html

Problem:

PHP:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'user'@'localhost' (using password: YES) in C:\xampp\htdocs\bounty-hunters.php on line 2

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\bounty-hunters.php on line 45

Script:

PHP:

  <?
mysql_connect("localhost","user","password");
mysql_select_db("database");

$main_content .= '<P ALIGN=CENTER>
    <br>
    <FONT SIZE=5 COLOR=#CFF00C>
        How to use...
    </FONT>
    <br>
    <br>
    <FONT SIZE=2 COLOR=#CFF00C>
    * !hunt [prize],[nick] :
        <FONT SIZE=1 COLOR=#FCC33F>
            Wysyla ogloszenie o huncie dla postaci. Cena w tysiacach.<br>
            Przyklad: !hunt 100,Infinity
        </FONT><br>
    </FONT>
</P>
<br>
<br>
    <center>
        <h1>
            Bounty Hunters
        </h1>
    </center>
        <TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>
            <TR BGCOLOR="#505050">
                <TD CLASS=white width=30%>
                    <center><B>Zlecil</B></center>
                </TD>
                <TD CLASS=white width=30%>
                    <center><B>Nagroda</B></center>
                </TD>
                <TD CLASS=white width=30%>
                    <center><B>Ofiara</B></center>
                </TD>
                <TD CLASS=white width=10%>
                    <center><B>Zabity przez</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']*1000;
if($killed == 0){
$kill = '<font color="red">Nobody!</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 .= '
        <TR BGCOLOR="'.$color.'">
            <TD>
                <center>
                    <b>
                        <a href="index.php?subtopic=characters&name='.$fn.'">'.$fn.'</a>
                    </b>
                </center>
            </TD>
            <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>
                    Currently there are not any bounty hunter offer.
                </center>
            </TD>
        </TR>';
}
        $main_content .='</TABLE><div align="right">Copyright.</div>';
?>

Paxton · Nov 24, 2009

U see those lines?

mysql_connect("localhost","user","password");
mysql_select_db("database");

You need to fill them up.

Lava Titan · Nov 24, 2009

ah =s
fixed =D
rep++ for you =D

can you help me traduting to english the script?

Paxton · Nov 25, 2009

Here u go, in english

PHP:

<?
mysql_connect("localhost","user","password");
mysql_select_db("database");

$main_content .= '<P ALIGN=CENTER>
    <br>
    <FONT SIZE=5 COLOR=#CFF00C>
        How to use...
    </FONT>
    <br>
    <br>
    <FONT SIZE=2 COLOR=#CFF00C>
    * !hunt [prize],[nick] :
        <FONT SIZE=1 COLOR=#FCC33F>
            Sends annoucment about hunting of player. Price in thousands.<br>
            Example: !hunt 100,Infinity
        </FONT><br>
    </FONT>
</P>
<br>
<br>
    <center>
        <h1>
            Bounty Hunters
        </h1>
    </center>
        <TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>
            <TR BGCOLOR="#505050">
                <TD CLASS=white width=30%>
                    <center><B>Sender</B></center>
                </TD>
                <TD CLASS=white width=30%>
                    <center><B>Prize</B></center>
                </TD>
                <TD CLASS=white width=30%>
                    <center><B>Victim</B></center>
                </TD>
                <TD CLASS=white width=10%>
                    <center><B>Killed by</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']*1000;
if($killed == 0){
$kill = '<font color="red">Nobody!</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 .= '
        <TR BGCOLOR="'.$color.'">
            <TD>
                <center>
                    <b>
                        <a href="index.php?subtopic=characters&name='.$fn.'">'.$fn.'</a>
                    </b>
                </center>
            </TD>
            <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>
                    Currently there are not any bounty hunter offer.
                </center>
            </TD>
        </TR>';
}
        $main_content .='</TABLE><div align="right">Copyright.</div>';
?>

Kudzu · Jan 13, 2010

this script don't work for me

Archez · Jan 13, 2010

kudzu1988 said:
this script don't work for me

Error? Log? Tell us more about it!

Typos & XHTML fixes.

PHP:

   <?
mysql_connect("localhost","user","password");
mysql_select_db("database");

$main_content .= '<p align=\"center\">
    <br />
    <font size=\"5\" color=\"#CFF00C\">
        How to use...
    </font>
    <br />
    <br />
    <font size=\"2\" color=\"#CFF00C\">
    * !hunt [prize],[nick] :
        <font size=\"1\" color=\"#FCC33F\">
            Sends an announcement about hunting of player, price in thousands!<br />
            Example: !hunt 100,Infinity
        </font><br />
    </font>
</p>
<br />
<br />
    <center>
        <h1>
            Bounty Hunters
        </h1>
    </center>
        <table border=\"0\" cellspacing=\"1\" cellpadding=\"4\" width=\"100%\">
            <tr bgcolor=\""#505050"\">
                <td class=\"white\" width=\"30%\">
                    <center><b>Sender</b></center>
                </td>
                <td class=\"white\" width=\"30%\">
                    <center><b>Prize</b></center>
                </td>
                <td class=\"white\" width=\"30%\">
                    <center><b>Victim</b></center>
                </td>
                <td class=\"white\" width=\"10%\">
                    <center><b>Killer</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']*1000;
if($killed == 0){
$kill = '<font color="red">Nobody!</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 .= '
        <tr bgcolor=\""'.$color.'\">
            <td>
                <center>
                    <b>
                        <a href="index.php?subtopic=characters&name='.$fn.'">'.$fn.'</a>
                    </b>
                </center>
            </td>
            <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>
                    There are not any bounty hunter offers at the moment.
                </center>
            </td>
        </tr>';
}
        $main_content .='</table><div align="right">Copyright.<br />Script fixes by <a href=\"http://otarts.net/members/archez\">Archez</a> and <a href=\"http://otland.net/members/Paxton\">Paxton</a>.</div>';
?>

Kudzu · Jan 13, 2010

Sorry for that. I have this:

EvulMastah · Jan 13, 2010

You have to use <?php instead of <?. You can always change it in php.ini file (short_open_tag).

Kudzu · Jan 13, 2010

I have this

<?
mysql_connect("localhost","user","password");
mysql_select_db("database");

$main_content .= '
 

How to use...

 
 

* !hunt [prize],[nick] :

Sends an announcement about hunting of player, price in thousands! 
Example: !hunt 100,Infinity
 


 
 
<center>
<h1>
Bounty Hunters
</h1>
</center>
<table border=\"0\" cellspacing=\"1\" cellpadding=\"4\" width=\"100%\">
<tr bgcolor=\""#505050"\">
<td class=\"white\" width=\"30%\">
<center>Sender</center>
</td>
<td class=\"white\" width=\"30%\">
<center>Prize</center>
</td>
<td class=\"white\" width=\"30%\">
<center>Victim</center>
</td>
<td class=\"white\" width=\"10%\">
<center>Killer</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']*1000;
if($killed == 0){
$kill = 'Nobody!';
}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 .= '
<tr bgcolor=\""'.$color.'\">
<td>
<center>

<a href="index.php?subtopic=characters&name='.$fn.'">'.$fn.'</a>

</center>
</td>
<td>
<center>

'.$prize.' gp

</center>
</td>
<td>
<center>

<a href="index.php?subtopic=characters&name='.$sn.'">'.$sn.'</a>

</center>
</td>
<td>
<center>

'.$kill.'

</center>
</td>
</tr>';
$num++;
}
if($num == 0){
$main_content.='<tr bgcolor=\""'.$color.'"\">
<td colspan=4>
<center>
There are not any bounty hunter offers at the moment.
</center>
</td>
</tr>';
}
$main_content .='</table><div align="right">Copyright. Script fixes by <a href=\"http://otarts.net/members/archez\">Archez</a> and <a href=\"http://otland.net/members/Paxton\">Paxton</a>.</div>';
?>

trou · Jan 13, 2010

PHP:

<?php
mysql_connect("localhost","user","password");
mysql_select_db("database");

$main_content .= '<p align=\"center\">
<br />
<font size=\"5\" color=\"#CFF00C\">
How to use...
</font>
<br />
<br />
<font size=\"2\" color=\"#CFF00C\">
* !hunt [prize],[nick] :
<font size=\"1\" color=\"#FCC33F\">
Sends an announcement about hunting of player, price in thousands!<br />
Example: !hunt 100,Infinity
</font><br />
</font>
</p>
<br />
<br />
<center>
<h1>
Bounty Hunters
</h1>
</center>
<table border=\"0\" cellspacing=\"1\" cellpadding=\"4\" width=\"100%\">
<tr bgcolor=\""#505050"\">
<td class=\"white\" width=\"30%\">
<center><b>Sender</b></center>
</td>
<td class=\"white\" width=\"30%\">
<center><b>Prize</b></center>
</td>
<td class=\"white\" width=\"30%\">
<center><b>Victim</b></center>
</td>
<td class=\"white\" width=\"10%\">
<center><b>Killer</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']*1000;
if($killed == 0){
$kill = '<font color="red">Nobody!</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_n ame.'">'.$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 .= '
<tr bgcolor=\""'.$color.'\">
<td>
<center>
<b>
<a href="index.php?subtopic=characters&name='.$fn.'"> '.$fn.'</a>
</b>
</center>
</td>
<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>
There are not any bounty hunter offers at the moment.
</center>
</td>
</tr>';
}
$main_content .='</table><div align="right">Copyright.<br />Script fixes by <a href=\"http://otarts.net/members/archez\">Archez</a> and <a href=\"http://otland.net/members/Paxton\">Paxton</a>.</div>';
?>

Kudzu · Jan 13, 2010

Ymm.Fixed with error on line58.Thanks and rep!

Bounty Hunters - Problem

Lava Titan

Developer

Paxton

Banned User

Lava Titan

Developer

Paxton

Banned User

Kudzu

Active Member

Archez

'

Kudzu

Active Member

EvulMastah

๏̯͡๏﴿

Kudzu

Active Member

trou

ot revolution is comming

Kudzu

Active Member

Similar threads