PHP Simple Item Editor

[gernblan]

Originally Posted by sdabbs65

Thats also a bug but it also inserts the new item above max_item_id 's limit.

Ok, but since you quoted me I thought you were commenting on what I said specifically.

[Theeper]

This can be confusing sometimes if magic_quotes_gpc are enabled in PHP. This setting automagically escapes single and double quotes on POSTed data, but doesn't actually insert the escape characters into the DB. So, the data will post properly, but will need escaped when echoing into the form HTML.

On the other hand, if magic_quotes_gpc is off on your system, the single quotes might be breaking your insert query string, so the data isn't making it to the DB properly.

Either way, using double quotes to delimit your string values in the HTML form is an easy way to deal with single quotes. This is, of course if you don't plan on ever having strings that have double quotes in them. If you do, you could always do some str_replace()'s with ascii values for quotes.

[gernblan]

So yeah, until that is addressed and fixed I cannot recommend this excellent script to anyone.

...and that sucks.

I'd fix it, honest I would, if I only had time. I'm so buried in the upkeep of my own server and the other projects I've already taken on. :(

[Lalolyen]

Does your server happen to be down.. I've been getting ping timeouts for the past 2 hours =S

[Ueguvil]

Anyone mind hosting this?

[gernblan]

Here:

http://stash.buttwrenching.com/itemeditor.zip

...but like I said in its current form it can corrupt the db, due to improper string handling so I don't recommend you actually use it as it is now.

IF someone fixes it, e-mail the fix to gernblanATgmailDOTcom and I will host that version for everyone instead.

[Lalolyen]

spsst!

function edititem
	(
	$id,
	$name,
	$lore,
	$idfile,
	$ac,
	$hp,
	$mana,
	$endur,
	$str,
	$sta,
	$agi,
	$dex,
	$cha,
	$int,
	$wis,
	$cr,
	$dr,
	$fr,
	$mr,
	$pr,
	$damage,
	$delay,
	$range,
	$reqlevel,
	$reclevel,
	$price,
	$clicktype,
	$clickeffect,
	$clicklevel,
	$clicklevel2,
	$stackable,
	$stacksize,
	$loregroup,
	$classes,
	$deity,
	$races,
	$nodrop,
	$bookid,
	$bookfilename,
	$proctype,
	$proceffect,
	$proclevel,
	$proclevel2,
	$worntype,
	$worneffect,
	$wornlevel,
	$wornlevel2,
	$regen,
	$manaregen,
	$focustype,
	$focuseffect,
	$focuslevel,
	$focuslevel2,
	$haste,
	$itemtype,
	$casttime,
	$icon,
	$slotcharm,
	$slotear1,
	$slothead,
	$slotface,
	$slotear2,
	$slotneck,
	$slotshoulder,
	$slotarms,
	$slotback,
	$slotbracer1,
	$slotbracer2,
	$slotrange,
	$slothands,
	$slotprimary,
	$slotsecondary,
	$slotring1,
	$slotring2,
	$slotchest,
	$slotlegs,
	$slotfeet,
	$slotwaist,
	$slotammo,
	$warrior,
	$cleric,
	$paladin,
	$ranger,
	$shadowknight,
	$druid,
	$monk,
	$bard,
	$rogue,
	$shaman,
	$necromancer,
	$wizard,
	$magician,
	$enchanter,
	$beastlord,
	$berserker,
	$human,
	$barbarian,
	$erudite,
	$woodelf,
	$highelf,
	$darkelf,
	$halfelf,
	$dwarf,
	$troll,
	$ogre,
	$halfling,
	$gnome,
	$iksar,
	$vahshir,
	$froglok,
	$deity1,
	$deity2,
	$deity3,
	$deity4,
	$deity5,
	$deity6,
	$deity7,
	$deity8,
	$deity9,
	$deity10,
	$deity11,
	$deity12,
	$deity13,
	$deity14,
	$deity15,
	$deity16,
	$deity17,
	$magic,
	$artifactflag,
	$norent,
	$procrate
	)

{

	if ($slotcharm == "on") { $slotcharm = 1; } else { $slotcharm = 0; };
	if ($slotear1 == "on") { $slotear1 = 1; } else { $slotear1 = 0; };
        if ($slothead == "on") { $slothead = 1; } else { $slothead = 0; };
        if ($slotface == "on") { $slotface = 1; } else { $slotface = 0; };
        if ($slotear2 == "on") { $slotear2 = 1; } else { $slotear2 = 0; };
        if ($slotneck == "on") { $slotneck = 1; } else { $slotneck = 0; };
        if ($slotshoulder == "on") { $slotshoulder = 1; } else { $slotshoulder = 0; };
        if ($slotarms == "on") { $slotarms = 1; } else { $slotarms = 0; };
        if ($slotback == "on") { $slotback = 1; } else { $slotback = 0; };
        if ($slotbracer1 == "on") { $slotbracer1 = 1; } else { $slotbracer1 = 0; };
        if ($slotbracer2 == "on") { $slotbracer2 = 1; } else { $slotbracer2 = 0; };
        if ($slotrange == "on") { $slotrange = 1; } else { $slotrange = 0; };
        if ($slothands == "on") { $slothands = 1; } else { $slothands = 0; };
        if ($slotprimary == "on") { $slotprimary = 1; } else { $slotprimary = 0; };
        if ($slotsecondary == "on") { $slotsecondary = 1; } else { $slotsecondary = 0; };
        if ($slotring1 == "on") { $slotring1 = 1; } else { $slotring1 = 0; };
        if ($slotring2 == "on") { $slotring2 = 1; } else { $slotring2 = 0; };
        if ($slotchest == "on") { $slotchest = 1; } else { $slotchest = 0; };
        if ($slotlegs == "on") { $slotlegs = 1; } else { $slotlegs = 0; };
        if ($slotfeet == "on") { $slotfeet = 1; } else { $slotfeet = 0; };
        if ($slotwaist == "on") { $slotwaist = 1; } else { $slotwaist = 0; };
        if ($slotammo == "on") { $slotammo = 1; } else { $slotammo = 0; };

Can be trimmed down to:

function edititem($postitem,$value)
{
if ($value == "on")
   {
   $ret_val = 1;
   } else {
   $ret_val = 0;
   }
$postitem = $ret_val;
return $postitem;
}

[Lalolyen]

BTW, this is why I would like to create an EQEMU mirror =)

Also to call that function while the array results with that function in it... such as...

while ($somearray['ID'] > 0)
 {
 $convert = edititem($thisItem,$andItsValue);
 echo ($convert);
 }