Indie-Resource.com

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>";

        ?>

Code: Select all

$SQL = "INSERT into players(name, password, email, level, exper, attack, defence, hpoints, maxhp)
             VALUES 
            ('$player','$password','$email','1','0','5','5','30','30')";

Code: Select all

$SQL = "INSERT into players(name, password, email, level, exper, attack, defence, hpoints, maxhp, spoints, maxspoints) VALUES ('$player','$password','$email','1','0','$classquery3[attack]','$classquery3[defence]','$classquery3[hpoints]','$classquery3[spoints]',
'$classquery3[maxspoints]')";
mysql_query($SQL) or die("could not register");

Code: Select all

$classquery="SELECT * from classes where name='$classchoice'";
  $classquery2=mysql_query($classquery) or die("Could not query classes");
  $classquery3=mysql_fetch_array($classquery2);

$SQL = "INSERT into players(name, password, email, level, exper, attack, defence, hpoints, maxhp, spoints, maxspoints) VALUES ('$player','$password','$email','1','0','$classquery3[attack]','$classquery3[defence]','$classquery3[hpoints]','$classquery3[maxhp]','$classquery3[spoints]','$classquery3[maxspoints]')";
mysql_query($SQL) or die("could not register");

Code: Select all

-- --------------------------------------------------------

--
-- Table structure for table `classes`
--

CREATE TABLE IF NOT EXISTS `classes` (
  `name` varchar(30) NOT NULL,
  `attack` smallint(3) NOT NULL,
  `defence` smallint(3) NOT NULL,
  `hpoints` smallint(3) NOT NULL,
  `spoints` int(6) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `classes`
--

INSERT INTO `classes` (`name`, `attack`, `defence`, `hpoints`, `spoints`) VALUES
('warrier', 8, 8, 15, 3),
('wizard', 4, 4, 10, 15),
('assasion', 5, 4, 10, 8),
('knight', 5, 6, 12, 8);

Code: Select all

CREATE TABLE IF NOT EXISTS `players` (
  `id` int(9) NOT NULL AUTO_INCREMENT,
  `name` varchar(21) NOT NULL,
  `password` varchar(32) NOT NULL,
  `email` varchar(32) NOT NULL,
  `level` int(3) NOT NULL,
  `exper` int(11) NOT NULL,
  `attack` mediumint(3) NOT NULL,
  `defence` mediumint(3) NOT NULL,
  `hpoints` mediumint(3) NOT NULL,
  `maxhp` int(6) NOT NULL,
  `spoints` int(6) NOT NULL,
  `maxspoints` mediumint(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `players`
--

INSERT INTO `players` (`id`, `name`, `password`, `email`, `level`, `exper`, `attack`, `defence`, `hpoints`, `maxhp`, `spoints`, `maxspoints`) VALUES

(8, 'me', 'ab86a1e1ef70dff97959067b723c5c24', 'email', 1, 0, 0, 0, 0, 0, 0, 0),
(9, 'me', 'ab86a1e1ef70dff97959067b723c5c24', 'email', 1, 0, 0, 0, 0, 0, 0, 0);