Page 4 of 12

Re: Video#7

Posted: Thu Jan 07, 2010 8:02 pm
by zolacat999
just me being thick can you elaborate on 'indexed' not fully sure what it means

Re: Video#7

Posted: Thu Jan 07, 2010 8:54 pm
by OldRod
When you're looking at your table in phpMyAdmin, down towards the bottom of the screen you should see "+details"

Click the "+" to open that up and you'll see more info about the table, including indexes. If there is an index on your table, remove it and see if that fixes the problem.

Re: Video#7

Posted: Thu Jan 07, 2010 9:12 pm
by zolacat999
ah got it thanks :)

Re: Video#7

Posted: Sat Jan 09, 2010 4:57 pm
by roah235
hello all

I seem to be having some trouble getting my potions to actually heal me.
Ive examined the php and my database for errors to no avail.

can anyone help?

Re: Video#7

Posted: Sat Jan 09, 2010 7:09 pm
by hallsofvallhalla
lets see your code.

Re: Video#7

Posted: Sun Jan 10, 2010 8:43 pm
by roah235
here it is

Code: Select all

<?php

include_once 'connect.php';
session_start();

if (isset($_SESSION['player']))
{
  $player=$_SESSION['player'];
}
else
{
  echo "Not Logged in <br><br> <A href='login.php'>Login</a>";
  exit;
}

$creature=$_GET['creature'];

$playerinfo="SELECT * from players where name='$player'";
$playerinfo2=mysql_query($playerinfo) or die("could not get player stats!");
$playerinfo3=mysql_fetch_array($playerinfo2);

$playerid = $playerinfo3['id'];

$counter = 0;
echo "<small>";
      print "<center>";
      print "<table border='0' width='70%' cellspacing='20'>";
      print "<tr><td width='25%' valign='top'>";
      print "</td>";
      print "<td valign='top' width='75%'>";
      $invinfo="SELECT * from inventory where id='$playerid'";
      $invinfo2=mysql_query($invinfo) or die("could not select player inventory");
      print "<table border='1' bordercolor='white' bgcolor='#ffffff'>";
      print "<tr><td>Name<font color='ffffff'>________________</font></td><td>Stat<font color='ffffff'>______</td><td>Stat Add<font color='ffffff'>______</td><td>Type<font color='ffffff'>______</td><td><font color='ffffff'>________________</td></tr>";
      while($invinfo3=mysql_fetch_array($invinfo2))
      {
      print "<tr><td>$invinfo3[name]</td><td>$invinfo3[stats]</td><td>$invinfo3[statadd]</td><td>$invinfo3[type]</td><td><A href='battle.php?randid=$invinfo3[randid]&creature=$creature'>Use Item</td></tr>";
       $counter = 1;

      }

      print "</table>";
      print "</td></tr></table>";
      print "</center>";
       echo "</small>";

      if ($counter == 0)
      {
            echo "<center>You have Nothing in your inventory!<br>";
            echo "<a href='battle.php?creature=$creature'>Go Back</center>";
            exit;
      }

    echo "<center><a href='battle.php?creature=$creature'>NeverMind</center>";
   
    ?>

Re: Video#7

Posted: Sun Jan 10, 2010 8:44 pm
by roah235
thats "useitem.php" btw

Re: Video#7

Posted: Sun Jan 10, 2010 8:52 pm
by ZeroComp
heres mine if that helps any

Code: Select all

<?php

include_once 'connect.php';
 session_start();
 include_once 'logo.php';
 ?>
 <link href="style.css" rel="stylesheet" type="text/css" />
 <?php

if (isset($_SESSION['player']))
{
  $player=$_SESSION['player'];
}
else
{
  echo "Not Logged in <br><br> <A href='login.php'>Login</a>";
  exit;
}



$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';
$playerid = $playerinfo3['id'];

$counter = 0;
 echo "<small>";
      print "<center>";
      print "<table border='0' width='70%' cellspacing='20'>";
      print "<tr><td width='25%' valign='top'>";
      print "</td>";
      print "<td valign='top' width='75%'>";
      $invinfo="SELECT * from inventory where id='$playerid'";
      $invinfo2=mysql_query($invinfo) or die("could not select player inventory");
      print "<table border='1' bordercolor='Black' bgcolor='#ffffff'>";
      print "<tr><td>Name<font color='ffffff'>________________</font></td><td>Stat<font color='ffffff'>______</td><td>Stat Add<font color='ffffff'>______</td><td>Type<font color='ffffff'>______</td><td><font color='ffffff'>________________</td></tr>";
      while($invinfo3=mysql_fetch_array($invinfo2))
      {
      print "<tr><td>$invinfo3[name]</td><td>$invinfo3[stats]</td><td>$invinfo3[statadd]</td><td>$invinfo3[type]</td><td><A href='battle.php?randid=$invinfo3[randid]'>Use Item</td></tr>";
       $counter = 1;

      }

      print "</table>";
      print "</td></tr></table>";
      print "</center>";
		 echo "</small>";

      if ($counter == 0)
      {
            echo "<center>You have Nothing in your inventory!<br>";
            echo "<a href='battle.php'>Go Back</center>";
            exit;
      }

    ?>

Re: Video#7

Posted: Mon Jan 11, 2010 2:58 pm
by hallsofvallhalla
its actually battle.php that i need to see.

Re: Video#7

Posted: Tue Jan 12, 2010 1:28 am
by roah235
oh fail.... item use is handled in battle.php. That helps :D

i found my issue. Thanks