Jump to content
MakeWebGames

[V2] Help needed with staff_items2.php please

Iumadder

By Iumadder
in General Discussion

 Share

Recommended Posts

Iumadder Newbie

Iumadder

Posted
Posted

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;
}
Iumadder Newbie

Iumadder

Posted
  • Author
Posted

Re: [V2] Help needed with staff_items2.php please

Error I get when trying to submit a new item:

QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1, 1, crID='5', itmbuyprice='65000', itmsellprice='50000', '0', 'a:4:{s:4:"stat' at line 1

Query was INSERT INTO items SET itmname='Test Item', itmdesc='test desc', itmtype='1', itmclass='1', itmspec='1', itmfreq='1', sockets='0', 1, 1, crID='5', itmbuyprice='65000', itmsellprice='50000', '0', 'a:4:{s:4:"stat";s:9:"fortitude";s:3:"dir";s:3:"pos";s:8:"inc_type";s:7:"percent";s:10:"inc_amount";i:0;}', '0', 'a:4:{s:4:"stat";s:9:"fortitude";s:3:"dir";s:3:"pos";s:8:"inc_type";s:6:"figure";s:10:"inc_amount";i:0;}' weapon='5', armor='6'

  • 1 month later...
D T K Newbie

D T K

Posted
Posted

Re: [V2] Help needed with staff_items2.php please

I would like to know this too.... My friends game got hacked and ive been through his code TONs of times and cant see the Error. If someone would help id be really greatful

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...