I am trying to keep people from multipuly equiping stuff on my game. For example: They can wear more than one Chest Armour and leggings and mittens and hats. So any idea how to fix this. I can't really think of anything.
Here is what I have on the script right now if it helps at all.
inventory.php
//-----------------------------
<?php
include 'connect.php';
include 'header.php';
if(!isset($_COOKIE['member_id']))
die('Not logged in, please <a href=\"index.php\">login</a>');
$Player=$_COOKIE['member_id'];
$Query="SELECT * from Users where ID='$Player'";
$Query2=mysql_query($Query) or die("Could not get user stats");
$User=mysql_fetch_array($Query2);
$Equip=$_POST['equip'];
$Unequip=$_POST['unequip'];
$SpellID=$_GET['id'];
$ID=$_POST['ItemId'];
$Droparm=$_POST['Droparm'];
$Dropwep=$_POST['Dropwep'];
$Equipment=array($User['Weapon'],$User['Helm'],$User['Chest'],$User['Legs'],$User['Hands']);
if($Equip)
{
$Query=mysql_query("Select * from Items where ID='$ID'") or die("Could not get item1");
$Item=mysql_fetch_array($Query);
if($Item['ItemClass']=="Long weapon"||$Item['ItemClass']=="Short weapon")
$Query=mysql_query("Select * from Items where Owner='$Player' AND ItemClass='Long weapon' AND Equipped='yes' OR Owner='$Player' AND ItemClass='Short weapon' AND Equipped='yes'") or die("Could not get item2");
if($Item['ItemClass']=="Chest armour")
$Query=mysql_query("Select * from Items where Owner='$Player' AND ItemClass='Chest armour' AND Equipped='yes'") or die("Could not get item4");
if($Item['ItemClass']=="Leg armour")
$Query=mysql_query("Select * from Items where Owner='$Player' AND ItemClass='Leg armour' AND Equipped='yes'") or die("Could not get item5");
if($Item['ItemClass']=="Gloves")
$Query=mysql_query("Select * from Items where Owner='$Player' AND ItemClass='Gloves' AND Equipped='yes'") or die("Could not get item6");
if($Item['ItemClass']=="Helmet")
$Query=mysql_query("Select * from Items where Owner='$Player' AND ItemClass='Helmet' AND Equipped='yes'") or die("Could not get item");
$EItem=mysql_fetch_array($Query);
if(isset($EItem))
{
$Strength2=$EItem['Strength'];
$Constitution2=$EItem['Constitution'];
$Dexterity2=$EItem['Dexterity'];
$Concentration2=$EItem['Concentration'];
$Intelligence2=$EItem['Intelligence'];
$Query1="Update Users set Strength=Strength-'$Strength2', Constitution=Constitution-'$Constitution2', Dexterity=Dexterity-'$Dexterity2', Intelligence=Intelligence-'$Intelligence2', Concentration=Concentration-'$Concentration2' where ID='$Player'";
$Query2="Update Items set Equipped='no' where ID='$EItem[ID]'";
mysql_query($Query1) or die("Couldn't change weapon");
mysql_query($Query2) or die("Couldn't change weapon");
}
$Strength=$Item['Strength'];
$Constitution=$Item['Constitution'];
$Dexterity=$Item['Dexterity'];
$Concentration=$Item['Concentration'];
$Intelligence=$Item['Intelligence'];
$Query3="Update Users set Strength=Strength+'$Strength', Constitution=Constitution+'$Constitution', Dexterity=Dexterity+'$Dexterity', Intelligence=Intelligence+'$Intelligence', Concentration=Concentration+'$Concentration' where ID='$Player'";
$Query4="Update Items set Equipped='yes' where ID='$Item[ID]'";
mysql_query($Query3) or die("Could not update player stats");
mysql_query($Query4) or die("Could not update item stats");
echo "<b>Item equipped</b><br />";
}
elseif($Unequip)
{
$Query=mysql_query("Select * from Items where ID='$ID'") or die("Could not get item7");
$Item=mysql_fetch_array($Query);
$Strength2=$Item['Strength'];
$Constitution2=$Item['Constitution'];
$Dexterity2=$Item['Dexterity'];
$Concentration2=$Item['Concentration'];
$Intelligence2=$Item['Intelligence'];
$Query2="Update Users set Strength=Strength-'$Strength2', Constitution=Constitution-'$Constitution2', Dexterity=Dexterity-'$Dexterity2', Intelligence=Intelligence-'$Intelligence2', Concentration=Concentration-'$Concentration2' where ID='$Player'";
$Query3="Update Items set Equipped='no' where ID='$Item[ID]'";
mysql_query($Query2) or die("Couldn't remove weapno");
mysql_query($Query3) or die("Couldn't change weapon");
echo "<b>Item unequipped</b><br />";
}
if($Droparm){
mysql_query("delete from Items where ID='$Droparm'") or die("Could not remove spell");
echo "Item dropped!<br />";
}
if($Dropwep){
mysql_query("delete from Items where ID='$Dropwep'") or die("Could not remove spell");
echo "Item dropped!<br />";
}
if($SpellID)
{
mysql_query("delete from UserSpells where ID='$SpellID'") or die("Could not remove spell");
echo "<div>Spell dropped!<br /></div>";
}
//equipped
$Query=mysql_query("select * from Items where Owner='$Player' AND Equipped='yes' ") or die("Could not get inventory");
echo "Equipped:<br /><table id=\"table\">";
echo "<tr><td>Name</td><td>Worth</td><td>Class</td><td>Strength</td><td>Constitution</td><td>Dexterity</td><td>Intelligence</td><td>Concentration</td><td>equip</td></tr>";
while($Item=mysql_fetch_array($Query))
{
echo "<tr><td>$Item[Name]</td><td>$Item[Worth]</td><td>$Item[ItemClass]</td><td>+$Item[Strength]</td><td>+$Item[Constitution]</td><td>+$Item[Dexterity]</td><td>+$Item[Intelligence]</td><td>+$Item[Concentration]</td><td><form action=\"inventory.php\" method=\"post\"><input class=\"noborderbutton\" type=\"submit\" name=\"unequip\" value=\"unequip\" /><input type=\"hidden\" value=\"$Item[ID]\" name=\"ItemId\" /></form></td></tr>";
}
echo "</table><br />";
//weapons
$Query=mysql_query("select * from Items where Owner='$Player' AND ItemClass='Short weapon' OR Owner='$Player' AND ItemClass='Long weapon'") or die("Could not get inventory");
echo "Weapons:<br /><table id=\"table\">";
echo "<tr><td>Name</td><td>Worth</td><td>Class</td><td>Strength</td><td>Constitution</td><td>Dexterity</td><td>Intelligence</td><td>Concentration</td><td>equip</td><td>Drop?</td></tr>";
while($Item=mysql_fetch_array($Query))
{
if($Item['Equipped']=="yes")
{
$Item['Name']="$Item[Name] {Equipped}";
}
echo "<tr><td>$Item[Name]</td><td>$Item[Worth]</td><td>$Item[ItemClass]</td><td>+$Item[Strength]</td><td>+$Item[Constitution]</td><td>+$Item[Dexterity]</td><td>+$Item[Intelligence]</td><td>+$Item[Concentration]</td><td><form action=\"inventory.php\" method=\"post\"><input class=\"noborderbutton\" type=\"submit\" name=\"equip\" value=\"equip\" /><input type=\"hidden\" value=\"$Item[ID]\" name=\"ItemId\" /></form></td><td><form action=\"inventory.php\" method=\"post\"><input class=\"noborderbutton\" type=\"submit\" name=\"drop\" value=\"drop\" /><input type=\"hidden\" value=\"$Item[ID]\" name=\"Dropwep\" /></form></td></tr>";
}
echo "</table><br />";
//armour
$Query=mysql_query("select * from Items where Owner='$Player' AND ItemClass='Chest armour'") or die("Could not get inventory");
$Query2=mysql_query("select * from Items where Owner='$Player' AND ItemClass='Leg armour'") or die("Could not get inventory");
$Query3=mysql_query("select * from Items where Owner='$Player' AND ItemClass='Helmet'") or die("Could not get inventory");
$Query4=mysql_query("select * from Items where Owner='$Player' AND ItemClass='Gloves'") or die("Could not get inventory");
echo "Armour:<br /><table id=\"table\">";
echo "<tr><td>Name</td><td>Worth</td><td>Class</td><td>Strength</td><td>Constitution</td><td>Dexterity</td><td>Intelligence</td><td>Concentration</td><td>equip</td><td>Drop?</td></tr>";
while($Item=mysql_fetch_array($Query))
{
if($Item['Equipped']=="yes")
$Item['Name']="$Item[Name] {Equipped}";
echo "<tr><td>$Item[Name]</td><td>$Item[Worth]</td><td>$Item[ItemClass]</td><td>+$Item[Strength]</td><td>+$Item[Constitution]</td><td>+$Item[Dexterity]</td><td>+$Item[Intelligence]</td><td>+$Item[Concentration]</td><td><form action=\"inventory.php\" method=\"post\"><input class=\"noborderbutton\" type=\"submit\" name=\"equip\" value=\"equip\" /><input type=\"hidden\" value=\"$Item[ID]\" name=\"ItemId\" /></form></td><td><form action=\"inventory.php\" method=\"post\"><input class=\"noborderbutton\" type=\"submit\" name=\"drop\" value=\"drop\" /><input type=\"hidden\" value=\"$Item[ID]\" name=\"Droparm\" /></form></td></tr>";
}
while($Item=mysql_fetch_array($Query2))
{
if($Item['Equipped']=="yes")
$Item['Name']="$Item[Name] {Equipped}";
echo "<tr><td>$Item[Name]</td><td>$Item[Worth]</td><td>$Item[ItemClass]</td><td>+$Item[Strength]</td><td>+$Item[Constitution]</td><td>+$Item[Dexterity]</td><td>+$Item[Intelligence]</td><td>+$Item[Concentration]</td><td><form action=\"inventory.php\" method=\"post\"><input class=\"noborderbutton\" type=\"submit\" name=\"equip\" value=\"equip\" /><input type=\"hidden\" value=\"$Item[ID]\" name=\"ItemId\" /></form></td><td><form action=\"inventory.php\" method=\"post\"><input class=\"noborderbutton\" type=\"submit\" name=\"drop\" value=\"drop\" /><input type=\"hidden\" value=\"$Item[ID]\" name=\"Droparm\" /></form></td></tr>";
}
while($Item=mysql_fetch_array($Query3))
{
if($Item['Equipped']=="yes")
$Item['Name']="$Item[Name] {Equipped}";
echo "<tr><td>$Item[Name]</td><td>$Item[Worth]</td><td>$Item[ItemClass]</td><td>+$Item[Strength]</td><td>+$Item[Constitution]</td><td>+$Item[Dexterity]</td><td>+$Item[Intelligence]</td><td>+$Item[Concentration]</td><td><form action=\"inventory.php\" method=\"post\"><input class=\"noborderbutton\" type=\"submit\" name=\"equip\" value=\"equip\" /><input type=\"hidden\" value=\"$Item[ID]\" name=\"ItemId\" /></form></td><td><form action=\"inventory.php\" method=\"post\"><input class=\"noborderbutton\" type=\"submit\" name=\"drop\" value=\"drop\" /><input type=\"hidden\" value=\"$Item[ID]\" name=\"Droparm\" /></form></td></tr>";
}
?>
