Battle Tent

[The Ace]

Hmm, I made a Battle Tent Bot, no problem. Then, when I went to add another, it just replaced the first one! :x The first NPC is still in the user list, but not in the Battle Tent. :(

Here is my Battle Tent code: (could someone please help me, I don't know where to look today!!!)

 

<?php
include "globals.php";
print "<h3>Battle Tent</h3>
[b]Welcome to the battle tent! Here you can challenge NPCs for money.[/b]
<table width=100% cellspacing=1 class='table'><tr style='background: gray; '><th>Bot Name</th><th>Level</th><th>Times Owned</th><th>Ready To Be Challenged?</th><th>Location</th><th>Money Won</th><th>Challenge</th></tr>";
$q=$db->query("SELECT cb.*,u.*,c.npcid,cy.cityname FROM challengebots cb LEFT JOIN users u ON cb.cb_npcid=u.userid LEFT JOIN challengesbeaten c ON c.npcid=u.userid AND c.userid=$userid LEFT JOIN cities cy ON u.location=cy.cityid");
while($r=$db->fetch_row($q))
{
$earn=$r['cb_money'];
$v=$r['userid'];
$q=$db->query("SELECT count(*) FROM challengesbeaten WHERE npcid=$v");
$times=$db->fetch_single($q);
print "<tr><td>{$r['username']}</td><td>{$r['level']}</td><td>$times</td><td>";
if($r['hp'] >= $r['maxhp']/2 and $r['location']==$ir['location'] and !$ir['hospital'] and !$ir['jail'] and !$r['hospital'] and !$r['jail']) { print "<font color=green>Yes</font>"; } else { print "<font color=red>No</font>"; }
print "</td><td>{$r['cityname']}</td><td>$earn</td><td>";
if($r['npcid'])
{
print "[i]Already[/i]";
}
else
{
print "[url='attack.php?ID={$r[']Challenge[/url]";
}
print "</td></tr>";
}
print "</table>";
$h->endpage();
?>

 

I'm really lost today! lol. :-P

[ShizzleNizzle]

Re: Battle Tent

There is a fix in this post http://criminalexistence.com/ceforums/i ... ic=21758.0

[The Ace]

Re: Battle Tent

Tehe, thanks mate. ;)

I kinda forgot to use the helpful search function! (Clear sign I'm not with it!) lol. :D