That worked great!aceconcepts wrote:In that case then:
Code: Select all
$itemcheck = mysql_query("SELECT * FROM items WHERE player_id='$option_name1'"); if(mysql_num_rows($itemcheck)==0) { //INSERT PLAYER OR WEAPON ETC... } else { while($row = mysql_fetch_array($itemcheck)) { if ( $item_number == "1") { $itemtype = 10; if ($row['item_id'] == $itemtype) { $updateweapon = mysql_query("UPDATE items SET quantity = quantity + '15' Where player_id = '$option_name1' and item_id = '$itemtype'"); } else { $insertweapon = mysql_query("INSERT into items(player_id,item_id,status)values('$option_name1','$itemtype','unequipped')"); } } }
thank you.
I just removed that second insert since I don't need it anymore.
So when I start creating other donation packs, would I just create an elseif and copy
if ( $item_number == "1")
{
changing the $item_number to whatever it is?
And do that for each donation pack? Or is there a better way?