PHP Simple Item Editor

inkubus · #1 08-06-2007, 02:48 PM

Hi all,

http://www.ageofkunark.com/itemeditor.zip

I thought I'd post this as I made it for use on my server and find it's a great help for fast production of items. It's dirty (oh so dirty) so don't get mad if it doesn't do what you want!

Couple of things to note before you start using it:
* I use autonumber on my items table - you will need to do the same to use this tool (make sure you don't go over your server item limit!
* For the sake of all that is good make sure you password protect your eqie folder using something like .htaccess. I didn't waste time building a login system.

Enjoy, I hope it's more understandable for you php coders out there (but like I say it's slightly messy)

Have fun

Bolly

**TheLieka** · #2 08-30-2007, 05:30 AM

Nice tool. Thanks for the hard work.

sdabbs65 · #3 08-30-2007, 11:18 PM

Good job.
been waiting a few months for something like this.
I been getting a lot of request for custom items and this does the trick.
you made quite a few people happy.

gernblan · #4 08-31-2007, 11:39 PM

Yes, very nice! Thank you!

gernblan · #5 09-01-2007, 08:02 PM

This is great!

One thing I may report? You need to escape out single quotes, as some items have a ' in their name.

The way the editor is now, it breaks if you try to edit any item (or lore) with an apostrophe.

sdabbs65 · #6 09-09-2007, 12:34 PM

Quote:

Originally Posted by gernblan

This is great!

One thing I may report? You need to escape out single quotes, as some items have a ' in their name.

The way the editor is now, it breaks if you try to edit any item (or lore) with an apostrophe.

Treid it last night...seems it inserts above max_id and crashes the server
so you wantto watch what you duplacate for now.

gernblan · #7 09-18-2007, 11:41 AM

I'm referring to the fact that anything with an apostrophe needs an "escape" a \ before the ' to be read correctly.

The code is stripping them out (no logic to handle the escapes), which is cutting off anything in a name past the '

It's a show stopping bug because it can corrupt item names with an apostrophe in them.

sdabbs65 · #8 09-18-2007, 12:00 PM

Quote:

Originally Posted by gernblan

I'm referring to the fact that anything with an apostrophe needs an "escape" a \ before the ' to be read correctly.

The code is stripping them out (no logic to handle the escapes), which is cutting off anything in a name past the '

It's a show stopping bug because it can corrupt item names with an apostrophe in them.

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

gernblan · #9 09-18-2007, 12:26 PM

See:

http://www.tizag.com/phpT/strings.php

gernblan · #10 09-18-2007, 12:26 PM

Quote:

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 · #11 09-20-2007, 12:10 PM

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 · #12 09-26-2007, 06:55 AM

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 · #13 09-29-2007, 10:29 PM

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

Ueguvil · #14 09-30-2007, 11:05 AM

Anyone mind hosting this?

gernblan · #15 10-02-2007, 08:42 AM

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.