Iumadder

Re: [V2] Help needed with staff_items2.php please Error I get when trying to submit a new item:

So, this is my first time posting here after browsing around the forums for a few days, and being a new coder, I could use a little assistance with staff_items2.php The issue that I am running into with creating a new item during the submit function, it doesnt like what I have for the "Item buyable", "item craftable" and the 2 item effects. The function additem_submit is from lines 109-120. Any help that can be provided with clearing up my issue would be appreciated. I have already made all appropriate changes in the sql tables as well. Thank you. Here is my file below: <?php include "sglobals.php"; if($ir['user_level'] != 2) { die("403"); } switch($_GET['action']) { case 'additem': additem(); break; case 'additemsub': additem_submit(); break; case 'edititem': edititem(); break; case 'edititemsub': edititem_submit(); break; case 'delitem': delitem(); break; case 'delitemsub': delitem_submit(); break; case 'additemtype': additemtype(); break; case 'additemtypesub': additemtype_submit(); break; case 'additemclass': additemclass(); break; case 'additemclasssub': additemclass_submit(); break; case 'additemspec': additemspec(); break; case 'additemspecsub': additemspec_submit(); break; case 'additemfreq': additemfreq(); break; case 'additemfreqsub': additemfreq_submit(); break; default: print "Error: This script requires an action."; break; } function additem() { global $ir, $c, $db; print "Creating a new item <form action='staff_items2.php?action=additemsub' method='post'> Item Name: <input type='text' name='name' /> Description: <input type='text' name='desc' /> Item Type: ".itemtype_dropdown($c,'itmtype')." Item Classificaton: ".itemclass_dropdown($c,'itmclass')." Item Special: ".itemspec_dropdown($c,'itmspec')." Item Rarity: ".itemfreq_dropdown($c,'itmfreq')." Item Sockets: <input type='text' name='sockets' /> Item Buyable: <input type='checkbox' name='itmbuyable' checked='checked' /> Item Craftable: <input type='checkbox' name='itmcraftable' checked='checked' /> Course Reqired: ".course_dropdown($c,'crID')." Purchase Price: <input type='text' name='itmbuyprice' /> Sell Price: <input type='text' name='itmsellprice' /> <hr /> [b]Usage Form[/b]<hr /> [b]<u>Effect 1</u>[/b] On? <input type='radio' name='effect1on' value='1' /> Yes <input type='radio' name='effect1on' value='0' checked='checked' /> No Stat: <select name='effect1stat' type='dropdown'> <option value='fortitude'>Fortitude</option> <option value='disposition'>Disposition</option> <option value='stamina'>Stamina</option> <option value='vitality'>Vitality</option> <option value='favor'>Favor</option> <option value='appetite'>Appetite</option> <option value='brawn'>Brawn</option> <option value='reflexes'>Reflexes</option> <option value='prec'>Precison</option> <option value='resilience'>Resilience</option> <option value='exertion'>Exertion</option> <option value='reason'>Reason</option> <option value='infirmary'>Infirmary Time</option> <option value='dungeon'>Dungeon Time</option> <option value='money'>Money</option> <option value='emblem'>Emblems</option> <option value='cdays'>Education Days Left</option> <option value='treasmoney'>Treasury Money</option> <option value='taskxp'>Task XP</option> </select> Direction: <select name='effect1dir' type='dropdown'> <option value='pos'>Increase</option> <option value='neg'>Decrease</option> </select> Amount: <input type='text' name='effect1amount' value='0' /> <select name='effect1type' type='dropdown'> <option value='figure'>Value</option> <option value='percent'>Percent</option> </select><hr /> [b]<u>Effect 2</u>[/b] On? <input type='radio' name='effect2on' value='1' /> Yes <input type='radio' name='effect2on' value='0' checked='checked' /> No Stat: <select name='effect2stat' type='dropdown'> <option value='fortitude'>Fortitude</option> <option value='disposition'>Disposition</option> <option value='stamina'>Stamina</option> <option value='vitality'>Vitality</option> <option value='favor'>Favor</option> <option value='appetite'>Appetite</option> <option value='brawn'>Brawn</option> <option value='reflexes'>Reflexes</option> <option value='prec'>Precison</option> <option value='resilience'>Resilience</option> <option value='exertion'>Exertion</option> <option value='reason'>Reason</option> <option value='infirmary'>Infirmary Time</option> <option value='dungeon'>Dungeon Time</option> <option value='money'>Money</option> <option value='emblem'>Emblems</option> <option value='cdays'>Education Days Left</option> <option value='treasmoney'>Treasury Money</option> <option value='taskxp'>Task XP</option> </select> Direction: <select name='effect2dir' type='dropdown'> <option value='pos'>Increase</option> <option value='neg'>Decrease</option> </select> Amount: <input type='text' name='effect2amount' value='0' /> <select name='effect2type' type='dropdown'> <option value='figure'>Value</option> <option value='percent'>Percent</option> </select><hr /> [b]Combat Usage[/b] Weapon Power: <input type='text' name='weapon' value='0' /> Armor Defense: <input type='text' name='armor' value='0' /><hr /> <input type='submit' value='Create Item' /></form>"; } function additem_submit() { global $db,$ir,$c,$h; if($_POST['itmbuyable'] == 'on') { $itmbuy=1; } else { $itmbuy=0; } if($_POST['itmcraftable'] == 'on') { $itmcraft=1; } else { $itmcraft=0; } $efx1=$db->escape(serialize(array("stat" => $_POST['effect1stat'], "dir" => $_POST['effect1dir'], "inc_type" => $_POST['effect1type'], "inc_amount" => abs((int) $_POST['effect1amount'])))); $efx2=$db->escape(serialize(array("stat" => $_POST['effect2stat'], "dir" => $_POST['effect2dir'], "inc_type" => $_POST['effect2type'], "inc_amount" => abs((int) $_POST['effect2amount'])))); $db->query("INSERT INTO items SET itmname='{$_POST['name']}', itmdesc='{$_POST['desc']}', itmtype='{$_POST['itmtype']}', itmclass='{$_POST['itmclass']}', itmspec='{$_POST['itmspec']}', itmfreq='{$_POST['itmfreq']}', sockets='{$_POST['sockets']}', $itmbuy, $itmcraft, crID='{$_POST['crID']}', itmbuyprice='{$_POST['itmbuyprice']}', itmsellprice='{$_POST['itmsellprice']}', '{$_POST['effect1on']}', '$efx1', '{$_POST['effect2on']}', '$efx2' weapon='{$_POST['weapon']}', armor='{$_POST['armor']}'"); print "Item created!"; stafflog_add("Created Item: {$_POST['name']}"); } function edititem() { global $ir, $c, $db; print "Editing Item <form action='staff_items2.php?action=edititemsub' method='post'> Current Item: ".item_dropdown($c,'itmID')." New Item Name: <input type='text' name='name' /> New Description: <input type='text' name='desc' /> New Item Type: ".itemtype_dropdown($c,'itmtype')." New Item Classificaton: ".itemclass_dropdown($c,'itmclass')." New Item Special: ".itemspec_dropdown($c,'itmspec')." New Item Rarity: ".itemfreq_dropdown($c,'itmfreq')." New Item Sockets: <input type='text' name='sockets' /> New Item Buyable: <input type='checkbox' name='itmbuyable' checked='checked' /> New Item Craftable: <input type='checkbox' name='itmcraftable' checked='checked' /> New Course Reqired: ".course_dropdown($c,'crID')." New Purchase Price: <input type='text' name='itmbuyprice' /> New Sell Price: <input type='text' name='itmsellprice' /> <hr /> [b]Usage Form[/b]<hr /> [b]<u>Effect 1</u>[/b] On? <input type='radio' name='effect1on' value='1' /> Yes <input type='radio' name='effect1on' value='0' checked='checked' /> No Stat: <select name='effect1stat' type='dropdown'> <option value='fortitude'>Fortitude</option> <option value='disposition'>Disposition</option> <option value='stamina'>Stamina</option> <option value='vitality'>Vitality</option> <option value='favor'>Favor</option> <option value='appetite'>Appetite</option> <option value='brawn'>Brawn</option> <option value='reflexes'>Reflexes</option> <option value='prec'>Precison</option> <option value='resilience'>Resilience</option> <option value='exertion'>Exertion</option> <option value='reason'>Reason</option> <option value='infirmary'>Infirmary Time</option> <option value='dungeon'>Dungeon Time</option> <option value='money'>Money</option> <option value='emblem'>Emblems</option> <option value='cdays'>Education Days Left</option> <option value='treasmoney'>Treasury Money</option> <option value='taskxp'>Task XP</option> </select> Direction: <select name='effect1dir' type='dropdown'> <option value='pos'>Increase</option> <option value='neg'>Decrease</option> </select> Amount: <input type='text' name='effect1amount' value='0' /> <select name='effect1type' type='dropdown'> <option value='figure'>Value</option> <option value='percent'>Percent</option> </select><hr /> [b]<u>Effect 2</u>[/b] On? <input type='radio' name='effect2on' value='1' /> Yes <input type='radio' name='effect2on' value='0' checked='checked' /> No Stat: <select name='effect2stat' type='dropdown'> <option value='fortitude'>Fortitude</option> <option value='disposition'>Disposition</option> <option value='stamina'>Stamina</option> <option value='vitality'>Vitality</option> <option value='favor'>Favor</option> <option value='appetite'>Appetite</option> <option value='brawn'>Brawn</option> <option value='reflexes'>Reflexes</option> <option value='prec'>Precison</option> <option value='resilience'>Resilience</option> <option value='exertion'>Exertion</option> <option value='reason'>Reason</option> <option value='infirmary'>Infirmary Time</option> <option value='dungeon'>Dungeon Time</option> <option value='money'>Money</option> <option value='emblem'>Emblems</option> <option value='cdays'>Education Days Left</option> <option value='treasmoney'>Treasury Money</option> <option value='taskxp'>Task XP</option> </select> Direction: <select name='effect2dir' type='dropdown'> <option value='pos'>Increase</option> <option value='neg'>Decrease</option> </select> Amount: <input type='text' name='effect2amount' value='0' /> <select name='effect2type' type='dropdown'> <option value='figure'>Value</option> <option value='percent'>Percent</option> </select><hr /> [b]Combat Usage[/b] Weapon Power: <input type='text' name='weapon' value='0' /> Armor Defense: <input type='text' name='armor' value='0' /><hr /> <input type='submit' value='Edit Item' /></form>"; } function edititem_submit() { global $ir,$c,$userid, $db; $efx1=$db->escape(serialize(array("stat" => $_POST['effect1stat'], "dir" => $_POST['effect1dir'], "inc_type" => $_POST['effect1type'], "inc_amount" => abs((int) $_POST['effect1amount'])))); $efx2=$db->escape(serialize(array("stat" => $_POST['effect2stat'], "dir" => $_POST['effect2dir'], "inc_type" => $_POST['effect2type'], "inc_amount" => abs((int) $_POST['effect2amount'])))); $db->query("UPDATE items SET (itmname, itmdesc, itmtype, itmclass, itmspec, itmfreq, sockets, itmbuyable, itmcraftable, crID, itmbuyprice, itmsellprice, $efx1, $efx2, weapon, armor) VALUES( '{$_POST['name']}', '{$_POST['desc']}', '{$_POST['itmtype']}', '{$_POST['itmclass']}', '{$_POST['itmspec']}', '{$_POST['itmfreq']}', '{$_POST['sockets']}', '{$_POST['itmbuyable']}', '{$_POST['itmcraftable']}', '{$_POST['crID']}', '{$_POST['itmbuyprice']}', '{$_POST['itmsellprice']}', '{$_POST['efx1']}', '{$_POST['efx2']}', '{$_POST['weapon']}', '{$_POST['armor']}',)"); print "Item edited!"; stafflog_add("Edited Item: {$_POST['name']}"); } function delitem() { global $ir, $c, $db; print "Deleting Item. <form action='staff_items2.php?action=delitemsub' method='post'> Item ID: ".item_dropdown($c,'itmid')." <input type='submit' value='Delete Item' /></form>"; } function delitem_submit() { global $ir,$c,$userid, $db; $db->query("DELETE FROM items WHERE itmid={$_POST['itmid']}"); print "Deleted Item!"; stafflog_add("Deleted Item ID: {$_POST['itmid']}"); } function additemtype() { global $ir, $c, $db; print "Creating a new item type <form action='staff_items2.php?action=additemtypesub' method='post'> Item Type Name: <input type='text' name='name' /> <input type='submit' value='Create Item Type' /></form>"; } function additemtype_submit() { global $ir,$c,$userid, $db; $db->query("INSERT INTO itemtypes VALUES(NULL, '{$_POST['name']}')");; print "Item Type Created!"; stafflog_add("Created Item Type: {$_POST['name']}"); } function additemclass() { global $ir, $c, $db; print "Creating a new item classification <form action='staff_items2.php?action=additemclasssub' method='post'> Item Type Name: <input type='text' name='name' /> <input type='submit' value='Create Item Classification' /></form>"; } function additemclass_submit() { global $ir,$c,$userid, $db; $db->query("INSERT INTO itemclass VALUES(NULL, '{$_POST['name']}')");; print "Item Classification Created!"; stafflog_add("Created Item Classification: {$_POST['name']}"); } function additemspec() { global $ir, $c, $db; print "Creating a new item special. <form action='staff_items2.php?action=additemspecsub' method='post'> Item Type Name: <input type='text' name='name' /> <input type='submit' value='Create Item Special' /></form>"; } function additemspec_submit() { global $ir,$c,$userid, $db; $db->query("INSERT INTO itemspec VALUES(NULL, '{$_POST['name']}')");; print "Item Special Created!"; stafflog_add("Created Item Special: {$_POST['name']}"); } function additemfreq() { global $ir, $c, $db; print "Creating a new item rarity <form action='staff_items2.php?action=additemfreqsub' method='post'> Item Type Name: <input type='text' name='name' /> <input type='submit' value='Create Item Rarity' /></form>"; } function additemfreq_submit() { global $ir,$c,$userid, $db; $db->query("INSERT INTO itemfreq VALUES(NULL, '{$_POST['name']}')");; print "Item Rarity Created!"; stafflog_add("Created Item Rarity: {$_POST['name']}"); } $h->endpage(); ?>   And the edits that I made to global_func.php for the appropriate dropdown menus: function itemclass_dropdown($connection,$ddname="itemclass",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT * FROM itemclass ORDER BY itmclassname ASC"); if($selected == -1) { $first=0; } else { $first=1; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['itmclassid']}'"; if ($selected == $r['itmclassid'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.= ">{$r['itmclassname']}</option>"; } $ret.="\n</select>"; return $ret; } function itemspec_dropdown($connection,$ddname="itemspec",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT * FROM itemspec ORDER BY itmspecname ASC"); if($selected == -1) { $first=0; } else { $first=1; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['itmspecid']}'"; if ($selected == $r['itmspecid'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.= ">{$r['itmspecname']}</option>"; } $ret.="\n</select>"; return $ret; } function itemfreq_dropdown($connection,$ddname="itemfreq",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT * FROM itemfreq ORDER BY itmfreqname ASC"); if($selected == -1) { $first=0; } else { $first=1; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['itmfreqid']}'"; if ($selected == $r['itmfreqid'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.= ">{$r['itmfreqname']}</option>"; } $ret.="\n</select>"; return $ret; }