Inventory

[Wuggy]

I have no idea how to make one, any suggestions?
Like weapons and stuff, what would I use? Could I do that in the database? Because I want just a list of the items that they own, and I could list and select them and so on, but I want it so you can have more than one weapon in your inventory, and when you equip it it sends it to the equipped weapon in the database. I can do all this easy but I need to figure out how to own more than one weapon :-. Any suggestions?

[Wuggy]

please?

[eriksmoen]

sample database:

[FONT=courier new]
+----+----------------------+------------+----------------------+
| ID | Weapon               | Quantity   | Owner                |
+----+----------------------+------------+----------------------+
|  1 | Assault Rifle        | 9          | johndoe              |
+----+----------------------+------------+----------------------+
|  2 | Pocket Knife         | 7          | alfred               |
+----+----------------------+------------+----------------------+

[/FONT]

sample code:

//to insert:
$qry = mysql_query("INSERT INTO weapons(Weapon,Quantity,Owner) VALUES('$weapon','$quantity','$owner')");

//to update:
$qry = mysql_query("UPDATE weapons SET Quantity = '$quantity' WHERE Weapon = '$weapon', Owner = '$owner'");

//to delete:
$qry = mysql_query("DELETE FROM weapons WHERE Weapon = '$weapon', Owner = '$owner'");

//to read:
$qry = mysql_query("SELECT Weapon,Quantity,Owner FROM weapons");
echo "<table>";
echo "<tr><th colspan=3>weapon list</th></tr>";
while($arr = mysql_fetch_array($qry)){
  echo "<tr><td>$arr[0]</td>";
  echo "<td>$arr[1]</td>";
  echo "<td>$arr[2]</td></tr>";
}
echo "</table>";

something like that should work i should think... hope that helps.

[Wuggy]

😃

[Wuggy]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/newbie/kiswebdesigns-www/wuggydesign/forum/house.php on line 143

thats what I get when I try to list the weapons :-\

the code is the same as what you gave me.
if(!($link_id = mysql_connect($db_host, $db_user, $db_password))) die(mysql_erorr());
mysql_select_db($db_name);
$qry = mysql_query("SELECT Weapon,Quantity,Owner FROM weapons");
echo "<table>";
echo "<tr><th colspan=3>weapon list</th></tr>";
while($arr = mysql_fetch_array($qry)){
echo "<tr><td>$arr[0]</td>";
echo "<td>$arr[1]</td>";
echo "<td>$arr[2]</td></tr>";
}
echo "</table>";

I played around with it and its still broken, anyone know the problem?

[eriksmoen]

maybe try this...

$link_id = mysql_connect($db_host, $db_user, $db_password) || die(mysql_error());
mysql_select_db($db_name);
$qry = mysql_query("SELECT Weapon,Quantity,Owner FROM weapons");
echo "<table>";
echo "<tr><th colspan=3>weapon list</th></tr>";
while($arr = mysql_fetch_array($qry)){
echo "<tr><td>$arr[0]</td>";
echo "<td>$arr[1]</td>";
echo "<td>$arr[2]</td></tr>";
}
echo "</table>"; 

[Wuggy]

:-\

[Wuggy]

thanks