arena error

[darspire]

when i go to the arena it doesnt load a monster. here is the creature part of my battle.php

Code: Select all

$creature = $playerinfo3['creature'];
 if ($creature != 0)
{
 $creatureinfo="SELECT * from creatures where id = '$cid'";
$creatureinfo2=mysql_query($creatureinfo) or die("could not get the creature you were fighting!");
$creatureinfo3=mysql_fetch_array($creatureinfo2);

}
else
{
////////////////////new for video 20
$areaninfo="SELECT * from locations where location='$pllocation' AND type='arena'";
$areaninfo2=mysql_query($areaninfo) or die("could not get arena");
$areaninfo3=mysql_fetch_array($areaninfo2);
$arenalevel = $areaninfo3['level'];

  $creatureinfo="SELECT * from creatures where level <= '$arenalevel' order by rand() limit 1";
$creatureinfo2=mysql_query($creatureinfo) or die("could get a creature!");
$creatureinfo3=mysql_fetch_array($creatureinfo2);
$cid = $creatureinfo3['id'];
$updateplayer="update players set creature='$cid' where name='$name'";
  mysql_query($updateplayer) or die("Could not update player");
}

$creature = $creatureinfo3['name'];
$creaturehp = $creatureinfo3['hpoints'];
$creatureattack = $creatureinfo3['attack'];
$creaturedefense = $creatureinfo3['defense'];

[hallsofvallhalla]

do you have creatures in the database that are lower or equal level to you?

[darspire]

yes

[hallsofvallhalla]

so after going to page look into DB under players, what does the creature field show?

if 0 then you don't have a creature suitable.

put this in and see what it prints

Code: Select all

echo  $pllocation . " " . '$arenalevel;

[vitinho444]

i know that error, its because the game cant check your location.

[hallsofvallhalla]

ah so just remove the location

Code: Select all

$areaninfo="SELECT * from locations where type='arena'"

;

or better yet

Code: Select all

$creatureinfo="SELECT * from creatures where level <= '$playerinfo3['level'] order by rand() limit 1";

i will look into this as I have some more videos coming soon

[darspire]

i tried all of the responses. none of them worked

[hallsofvallhalla]

my last response should have fixed it, do you get an error?

[darspire]

no. its just that no monster shows in the arena.

[vitinho444]

well here u have my battle.php (i changed it to get monsters of a certain lvl) but u can check whats wrong with yours (its working now)

Code: Select all

<?php

include_once 'connect.php';

session_start();

	$min = 5;
	$max = 10;
include_once 'logo.php';

?>

<link href="style.css" rel="stylesheet" type="text/css" />

<div id="login2" div align="center">


<title>

The Legend of Kanisys

</title>


<?php









if (isset($_SESSION['player']))

{

  $player=$_SESSION['player'];

}

else

{

  echo "Not Logged in <br><br> <A href='login.php'>Login</a>";

  exit;

}

?>

</div>

<?php

$playerinfo="SELECT * from players where name='$player'";

$playerinfo2=mysql_query($playerinfo) or die("could not get player stats!");

$playerinfo3=mysql_fetch_array($playerinfo2);



include_once 'statpanel.php';



$pid = $playerinfo3['id'];

$name = $playerinfo3['name'];

$playerhp = $playerinfo3['hpoints'];

$playersp = $playerinfo3['spoints'];

$playerattack = $playerinfo3['attack'];

$playerdefense = $playerinfo3['defense'];



?>

<div id="table">

<?php
$plevel=$playerinfo3['level'];


if (isset($_GET['randid']))

{

   $randid=$_GET['randid'];

   $iteminfo="SELECT * from inventory where randid='$randid' AND id ='$pid'";

$iteminfo2=mysql_query($iteminfo) or die("could not get item stats!");

$iteminfo3=mysql_fetch_array($iteminfo2);



if (!$iteminfo3['name'])

{

}

else

{



$iname = $iteminfo3['name'];

$stats = $iteminfo3['stats'];

$statadd = $iteminfo3['statadd'];

$type = $iteminfo3['type'];





   if ($stats == "hpoints"){

   $newhp = $statadd + $playerhp;

   if ($newhp > $playerinfo3['maxhp'])

   {

    $newhp = $playerinfo3['maxhp'];

   }

   

    $updateplayer="update players set hpoints='$newhp' where id='$pid'";

  mysql_query($updateplayer) or die("Could not update player");



    $updateitem="DELETE from inventory where id='$pid' AND randid='$randid' limit 1";

  mysql_query($updateitem) or die("Could not delete item");

   

   $playerhp = $newhp;

 

  echo "Used " . $iname . " and recovered " . $statadd . ".<br>";

}



if ($stats == "spoints"){

$newsp = $statadd + $playersp;

if ($newsp > $playerinfo['maxspoints'])

{

$newsp = $playerinfo3['maxspoints'];

}

$updateplayersp="update players set spoints='$newsp' where id='$pid'";

  mysql_query($updateplayersp) or die("Could not update player");



    $updatesppot="DELETE from inventory where id='$pid' AND randid='$randid' limit 1";

  mysql_query($updatesppot) or die("Could not delete item");

   

   $playersp = $newsp;

 

  echo "Used " . $iname . " and recovered " . $statadd . ".<br>";

}

  }



}











    $creature = $playerinfo3['creature'];

    if ($creature != 0)

    {

    $creatureinfo="SELECT * from creatures where id='$creature'";

    $creatureinfo2=mysql_query($creatureinfo) or die("could not get the creature you were fighting!");

    $creatureinfo3=mysql_fetch_array($creatureinfo2);

    }

    else

    {

    ////////////////////new for video 20

    if (isset($_GET['pllocation'])){

	

    $playerinfo3=$_GET['pllocation'];
	
	$plevel=$playerinfo3['level'];

    $arenainfo="SELECT * from locations where location='$pllocation' AND type='arena'";

    $arenainfo2=mysql_query($arenainfo) or die("Could not get arena");

    $areaninfo3=mysql_fetch_array($arenainfo2);

        $arenalevel = $arenainfo3['level'];
      $creatureselect = $playerinfo['level'];

            $creatureinfo="SELECT * from creatures where level = '$level' order by rand() limit 1";


            }else{
			

            $creatureinfo="SELECT * FROM creatures WHERE level BETWEEN '$min' AND '$max' ORDER BY RAND() limit 1 ";

            }    

        $creatureinfo2=mysql_query($creatureinfo) or die("Could get a creature!");

    $creatureinfo3=mysql_fetch_array($creatureinfo2);

    $cid = $creatureinfo3['id'];

   

    $updateplayer="update players set creature='$cid' where name='$name'";

      mysql_query($updateplayer) or die("Could not update player");

    }









?>

</div>

<div id="player">

<?php

/////player info

echo "<h4><u> " . $playerinfo3['name'] . "</u><br>";

echo "Level = " . $playerinfo3['level'] . "<br>";

echo "Health = " . $playerhp . "<br>";

echo "Attack = " . $playerattack . "<br>";

echo "Defense = " . $playerdefense . "<br><br><br>";

?>

</div>

<div id="creature">

<?php

///////creature info

echo "<h4><u> " . $creatureinfo3['name'] . "</u><br>";

echo "Level = " . $creatureinfo3['level'] . "<br>";

echo "Health = " . $creatureinfo3['hpoints'] . "<br>";

echo "Attack = " . $creatureinfo3['attack'] . "<br>";

echo "Defense = " . $creatureinfo3['defense'] . "<br><br><br>";



echo "<a href='attack.php'><img src='images/attack.png'></a>";

echo "<br><a href='usemagic.php'><img src='images/usemagic.png'></a>";

echo "<br><a href='useitem.php'><img src='images/usepotion.png'></a>";

echo "<br><a href='run.php'><img src='images/back.png'></a>";





?>

</div>



<div id="logout">

<?php

echo "<br><a href='logout.php'><img src='images/logout.png'>";

?>

</div>