Page 10 of 13
Re: Video #20
Posted: Thu Jan 20, 2011 3:59 am
by 62896dude
ok, two main problems i still have and can't quite figure out:
( ! ) Notice: Undefined index: pclass in C:\wamp\www\HPMMORPG\statpanel.php on line 4
Call Stack
# Time Memory Function Location
1 0.0115 399624 {main}( ) ..\battle.php:0
2 0.0239 423720 include_once( 'C:\wamp\www\HPMMORPG\statpanel.php' ) ..\battle.php:32
an excerpt from my statpanel.php:
Code: Select all
<div id="lpanel">
<?php
echo "<u><b> " . $playerinfo3['name'] . "</b></u><br>";
echo $playerinfo3['pclass'] . "<br>";
//////////////new for 17
echo "Level " . $playerinfo3['level'] . "<br>";
echo "Attack = " . $playerinfo3['attack'] . "<br>";
echo "Defense = " . $playerinfo3['defense'] . "<br>";
echo "Hit Points<br>";
echo "Spell Points<br><br>";
echo "<b><big><u>Gold</u></big></b><br>";
echo $playerinfo3['gold'];
?>
<?php
echo "<br><br>";
echo "<a href='equipment.php'>Equipment<br></a>";
////////////////////////new for video 17////////////////
echo"<br>";
$expneeded = ($playerinfo3[level] * 100) * $playerinfo3[level];
if ($playerinfo3[exper] >= $expneeded)
{ echo "<br><a href='levelup.php'>Level Up!!</a>";}
?>
</div>
Also, this is common:
( ! ) Notice: Use of undefined constant level - assumed 'level' in C:\wamp\www\HPMMORPG\statpanel.php on line 22
Call Stack
# Time Memory Function Location
1 0.0115 399624 {main}( ) ..\battle.php:0
2 0.0239 423720 include_once( 'C:\wamp\www\HPMMORPG\statpanel.php' ) ..\battle.php:32
( ! ) Notice: Use of undefined constant exper - assumed 'exper' in C:\wamp\www\HPMMORPG\statpanel.php on line 23
Call Stack
# Time Memory Function Location
1 0.0115 399624 {main}( ) ..\battle.php:0
2 0.0239 423720 include_once( 'C:\wamp\www\HPMMORPG\statpanel.php' ) ..\battle.php:32
all of those have to do with the statpanel.php, and the excerpt i provided has all of the said problemed lines in it, please help!
Re: Video #20
Posted: Thu Jan 20, 2011 6:11 am
by PaxBritannia
Code: Select all
( ! ) Notice: Undefined index: pclass in C:\wamp\www\HPMMORPG\statpanel.php on line 4
For the first error, it's because $playerinfo3['pclass'] isn't defined, that is, you haven't set it.
I can't work out anything else from the small except you've given me, so if you want me to help you more, you'll have to show me the whole script.
And next time, could you please post the whole code in code tags?
[/code]
It helps a lot with finding the errors, thank.
pax.
p.s. (Sorry for the late reply. My internet got disconnected after I finished typing my message, so although I didn't lose anything I typed, I could only submit it just now (along with my other post on getting help))
Re: Video #20
Posted: Mon Jan 24, 2011 4:31 pm
by hallsofvallhalla
fixed the code and quotes
add ' ' in your variables
should be
do not do this inside of " " though, like in your queries.
Re: Video #20
Posted: Wed Jan 26, 2011 1:09 am
by 62896dude
awesome, where can i find them?
and also, are you planning on posting any more vids for this topic?
-62896dude
Re: Video #20
Posted: Wed Jan 26, 2011 3:06 am
by PaxBritannia
The missing quotations are at the very bottom of the script.
pax.
Re: Video #20
Posted: Sun Feb 27, 2011 9:56 pm
by 62896dude
Hello again! So I spent a very long time figuring out all of my errosrs, and finally, no more error messages!!

however, whenever I enter the arena, there isn't a monster that appears at all.. here is my attack and battle source..
Attack.php:
Code: Select all
<?php
include_once 'connect.php';
session_start();
include_once 'logo.php';
?>
<link href="style.css" rel="stylesheet" type="text/css" />
<div id="login2" div align="center">
<?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'];
?>
</div>
<div id="table">
<?php
$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
{
echo "<a href='battle.php'>No Creature selected. Go Back!";
exit;
}
$playerhp = $playerinfo3['hpoints'];
$playerattack = $playerinfo3['attack'];
$playerdefense = $playerinfo3['defense'];
$playerpass = 0;
$creature = $creatureinfo3['name'];
$creaturehp = $creatureinfo3['hpoints'];
$creatureattack = $creatureinfo3['attack'];
$creaturedefense = $creatureinfo3['defense'];
$cid = $creatureinfo3['id']
?>
</div>
<div id="player">
<?php
///////////////////////players turn////////////////////
echo "<center><u> " . $playerinfo3['name'] . "'s Attack</u><br>";
if (isset($_GET['sid']))
{
$sid=$_GET['sid'];
$spellinfo="SELECT * from playermagic where sid='$sid' AND pid='$pid'";
$spellinfo2=mysql_query( $spellinfo) or die("could not get spell!");
$spellinfo3=mysql_fetch_array( $spellinfo2);
$sname = $spellinfo3['name'];
if ($spellinfo3['type'] == "combat")
{
if ($spellinfo3['scost'] > $playerinfo3['spoints'])
{
echo "You do not have enough Spell Points for this spell.<br>";
echo "<a href='battle.php'>Go Back";
exit;
}
else
{
$spoints = $spellinfo3['scost'];
$moddamage = $spellinfo3['svalue'] / 10;
$moddamage = (int)$moddamage;
$sdamage = $spellinfo3['svalue'];
$randdamage = rand(0, $sdamage);
$sdamage = $randdamage + $moddamage;
echo " You Cast " . $sname . " and do " . $sdamage . " points of damage";
$playerpass = 1;
$updateplayer="update players set spoints=spoints-'$spoints' where name='$player'";
mysql_query($updateplayer) or die("Could not update player");
}}
}
if ($playerpass != 1)
{
$weaponinfo="SELECT * from playerweapons where equip=1 AND pid='$pid'";
$weaponinfo2=mysql_query( $weaponinfo) or die("could not get player weapon!");
$weaponinfo3=mysql_fetch_array( $weaponinfo2);
$playerattack = rand(1,20) + $playerattack + $weaponinfo3['rating'];
//////////////////////////////////////////////////////
$creaturedefense = rand(1,20) + $creaturedefense;
echo $playerinfo3['name'] . "'s Attack roll is " . $playerattack . "<br>";
echo $creature . "'s defense roll is " . $creaturedefense. "<br>";
if ($playerattack > $creaturedefense)
{
echo $playerinfo3['name'] . " " . $weaponinfo3['hittext'] . " and hits!<br>";
$weapdamage = $weaponinfo3['damage'];
$halfdamage = $weaponinfo3['damage'] / 2;
$playerdamage = rand($halfdamage,$weapdamage);
$newcreaturehp = $creaturehp - $playerdamage;
echo "For " . $playerdamage . " points of damage. <br>";
if ($newcreaturehp < 1)
{
echo "The " . $creature . " has been killed";
$crmaxhp=$creatureinfo3['maxhpoints'];
$updatecreature="update creatures set hpoints='$crmaxhp' where name='$creature' limit 1";
mysql_query($updatecreature) or die("Could not update creature");
if ($playerinfo3['level'] > $creatureinfo3['level'])
{
$firstmod = $playerinfo3['level'] - $creatureinfo3['level'];
$secondmod = $firstmod * 10 ;
if ($secondmod > 90){$secondmod = 90;}
$thirdmod = ($secondmod / 100) * $creatureinfo3['exper'];
$totalexper =$creatureinfo3['exper'] - $thirdmod;
}
else
{
$firstmod = $creatureinfo3['level'] - $playerinfo3['level'];
$secondmod = $firstmod * 10 ;
if ($secondmod > 90){$secondmod = 90;}
$thirdmod = ($secondmod / 100) * $creatureinfo3['exper'];
$totalexper =$creatureinfo3['exper'] + $thirdmod;
}
$totalexper = (int)$totalexper;
echo "<br><b><big>You gain " . $totalexper . " experience.</b></big><br>";
$updateplayer="update players set exper=exper+'$totalexper',creature=0 where name='$player'";
mysql_query($updateplayer) or die("Could not update player");
echo "<a href='battle.php'>Go Back";
exit;
}
$updatecreature="update creatures set hpoints='$newcreaturehp' where name='$creature' limit 1";
mysql_query($updatecreature) or die("Could not update creature");
}
else
{
echo $playerinfo3['name'] . " " . $weaponinfo3['hittext'] . " and misses!";
}}
?>
</div>
<div id="creature">
<?php
//////////////////////creatures turn //////////////////
echo "<center><u> " . $creature . "'s Attack</u><br>";
///////hit location//////////////////////////////////////
$randlocation = rand(0,100);
if ($randlocation <= 15)
{$location = "arms";}
elseif ($randlocation <= 70)
{$location = "chest";}
elseif ($randlocation <= 90)
{$location = "legs";}
elseif ($randlocation <= 100)
{$location = "head";}
$playerarmor="SELECT * from playerarmor where pid='$pid' AND location='$location' AND equip=1";
$playerarmor2=mysql_query($playerarmor) or die("Could not get player armmor");
$playerarmor3=mysql_fetch_array($playerarmor2);
$noarmor = 0;
if(is_null($playerarmor3['rating']))
{
$playerarmor3['rating'] = 0;
$noarmor = 1;
}
////////////////////////////////////
$creatureattack = rand(1,20) + $creatureattack;
$playerdefense = rand(1,20) + $playerdefense + $playerarmor3['rating'];
echo $creature . "'s Attack roll is " . $creatureattack . "<br>";
echo $playerinfo3['name'] . "'s defense roll is " . $playerdefense . "<br>";
if ($creatureattack > $playerdefense)
{
echo $creature . " hits for a strike to the " . $location . "<br>";
$creaturedamage = rand(1,6);
$newplayerhp = $playerhp - $creaturedamage;
echo "For " . $creaturedamage . " points of damage. <br>";
if ($noarmor == 1)
{
echo "You are not wearing armor on your " . $location . ".<br>";
$extradamage = rand(1,3);
echo "You take an additional " . $extradamage . " points of damage.<br>";
$newplayerhp = $newplayerhp - $extradamage;
}
if ($newplayerhp < 1)
{
echo $playerinfo3['name'] . " has been killed<br>";
echo "<a href='gameover.php>Continue'";
exit;
}
$updateplayer="update players set hpoints='$newplayerhp' where name='$player'";
mysql_query($updateplayer) or die("Could not update player");
}
else
{
echo $creature . " misses!";
}
echo "<br><br><a href='battle.php?creature=$creature'>Keep Fighting!</a>";
echo "<br><br><a href='index.php'>Run Away!</a>";
?>
</div>
----------------------------------------------------------------------------------------------------------
Battle.php:
Code: Select all
<?php
include_once 'connect.php';
session_start();
include_once 'logo.php';
?>
<link href="style.css" rel="stylesheet" type="text/css" />
<div id="login2" div align="center">
<?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'];
$playerattack = $playerinfo3['attack'];
$playerdefense = $playerinfo3['defense'];
$pllocation = $playerinfo3['location']
?>
<div id="table">
<?php
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 ($type == "healing")
{
$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>";
}
}}
$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
$arenainfo="SELECT * from locations where location='$pllocation' AND type='arena'";
$arenainfo2=mysql_query($arenainfo) or die("could not get arena");
$arenainfo3=mysql_fetch_array($arenainfo2);
$arenalevel = $arenainfo3['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'];
?>
</div>
<div id="player">
<?php
/////player info
echo "<u> " . $playerinfo3['name'] . "</u><br>";
echo "Hit points = " . $playerhp . "<br>";
echo "Attack = " . $playerattack . "<br>";
echo "Defense = " . $playerdefense . "<br><br><br>";
?>
</div>
<div id="creature">
<?php
///////creature info
echo "<u> " . $creatureinfo3['name'] . "</u><br>";
echo "Hit points = " . $creaturehp . "<br>";
echo "Attack = " . $creatureattack . "<br>";
echo "Defense = " . $creaturedefense . "<br><br><br>";
echo "<a href='attack.php'>Attack</a>";
echo "<br><a href='usemagic.php'>Use Magic</a>";
echo "<br><a href='useitem.php'>Use Item</a>";
echo "<br><a href='index.php'>Exit Arena</a>";
?>
</div>
<div id="logout">
<?php
echo "<br><a href='logout.php'><img src='logout.gif'>";
?>
</div>
Thank you!
-62896dude
Re: Video #20
Posted: Thu Mar 24, 2011 2:34 am
by Realitycheck
i had that issue.
check to make sure you have 'location' field in your player database. and that it updates when moving map.
Re: Video #20
Posted: Thu Mar 24, 2011 3:06 am
by 62896dude
I already got it, thanks for the help though!

Re: Video #20
Posted: Fri Apr 01, 2011 2:47 pm
by drewcasey24
Resolved
Re: Video #20
Posted: Wed May 18, 2011 6:38 am
by aim
how do you import the sql file. Also on the uploaded file you changed the line from connect to $db = mysql_connect("localhost","root","NEWPASSWORD") or die("Could not connect to db"); from $db = mysql_connect("localhost","root","") or die("Could not connect to db");
I'm not sure if this was done purposely or what needs to be done to make it work. But i can only get mine to work by erasing NEWPASSWORD out of the line.
Thanks for any help have a great day