Retromud

tazliel · Posted: Sat Jan 26, 2008 1:42 am Post subject: RetroEq on Spheral

Since Froggy is planning to stop hosting and maintaining RetroEq, I offered him to host it here.
Some things are not working yet :
- Login : I will integrate RetroEq login with this forum, it will be easy to register here and access both section.
- Plaques : need to get and set up the various scripts that update the plaques.

I am probably missing stuff so feel free to post here for debugging remarks.

If you are skilled in php, I may use your help to improve further the wonderful tool created by Froggy.

As always contact me here or thru Mudmail
_________________
Damn you Kruggurk !!!

tazliel · Posted: Sun Jan 27, 2008 10:25 pm Post subject:

What should be working :
- Eq search
- Simple Query
- For Sale
- Search NPC
- Races
- Retro Docs Search (updated today 2008/01/2 Cool

- Diseases
- Areas
- Level calculator

What is NOT working yet
- Login (will work something to integrate with this forum)
- Players plaque (hmmm)
- Search Skills (hmm hmmm)
_________________
Damn you Kruggurk !!!

tazliel · Posted: Tue Jan 29, 2008 7:58 pm Post subject:

Login is working (kinda)
just enter your character name and *any* password.
not perfect but until I have the time to do something more complete, it should do.

Players Plaques is working
Need to gather some data before the summary really mean anything.
The GRAPH function is NOT working as of yet.
Not sure it is really needed and have quite an impact on the server. Let me know.

Next hurdle : skills and spells search!
_________________
Damn you Kruggurk !!!

Syndic · Posted: Wed Mar 12, 2008 9:26 am Post subject:

I just noticed... I'm able to update items, but not monsters.

when I try, I get this:

xyzzyn · Posted: Mon Mar 24, 2008 1:27 pm Post subject:

Same thing with adding areas.

tazliel · Posted: Mon Mar 24, 2008 8:29 pm Post subject:

Adding mobs and area should be working fine now.
_________________
Damn you Kruggurk !!!

tazliel · Posted: Sun Apr 06, 2008 10:45 am Post subject:

WTB / FS and Personal Eq function are working ok now.
Slightly changed Simple Query to have more (hopefully useful) links and a different look.
_________________
Damn you Kruggurk !!!

tryphiodorus · Posted: Sat Apr 26, 2008 1:43 am Post subject: items with "'" in the description

It looks like creating or updating items with a single quote (') in their description fails; the exact error is below. It appears that the escaping isn't work properly; standard SQL escape for a quote is '' (two single quotes) rather than \'.

Error using query UPDATE items SET item_name='The Rahl of the Celestial Moon Dragon',owner_id=282,item_align='',item_gender='',item_str=0,item_con=0,item_dex=0,
item_agi=0,item_wis=0,item_intel=0,item_per=0,item_cha=0,item_luk=0,item_hpr=14,
item_spr=13,item_epr=6,item_crafted=0,item_indest=0,item_cursed=0,item_light=2,
item_pv=0,item_bulk=NULL,item_popularity=5,item_in_game=1,item_notes='Each Overlord Borgreffin carries a single Rahl. ',item_description='This glowing lump of energy has substance and emits a small bit of light. Representing a portion of the Rahl, or life force energy of one of the Celestial Dragons, it is a manifestation of the Dragon\\'s spirit. Recovered from Cindar and his minions, this Rahl will slow Cindar\\'s attempts to restart the grid and the energy crystals that hover over Wysoom. In addition this Rahl-Pir may have other uses for stopping Cindar. Its recovery also marks a brief respite for the Celestial Dragon from the control of Cindar.',item_updated_by='tryphiodorus',item_updated_date=NOW() WHERE item_id=3943:

(slightly edited query by inserting line breaks).

tryphiodorus

Thanks for fixing the ' issue; that was helpful. A couple more things that probably should be looked at:

1) Items names containing " aren't escaped properly on the homepage, the simple view, and the update page. Specifically, you can set the item name to be something like "<script>alert('Test')</script> and said Javascript will execute for everyone who visits (was doing XSS fixes at works, which is why I thought of it).

2) Item deletions don't seem to work; the message I got when trying to remove my test item was

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'spheral'@'localhost' (using password: NO) in /home/spheral/public_html/retromud/retroeq/delete_item.php on line 13
Unable to connect to database server localhost user : Access denied for user 'spheral'@'localhost' (using password: NO)

tazliel · Posted: Tue May 06, 2008 7:27 pm Post subject:

Item deletion now should work properly.
I added cleaning up of unwanted tags in item name, desc and notes. Should close that nasty security hole.

Thanks Tryph for pointing it out.
_________________
Damn you Kruggurk !!!

Agrona · Posted: Fri May 09, 2008 1:48 pm Post subject:

Hey taz.

I'd love to see the graphs working (you commented you may not want to add them).

Alternatively, is there a way I can get the data in CSV format or something so I can make my own graphs in Excel or whatever?

THanks,

Agrona

tryphiodorus · Posted: Fri May 09, 2008 11:55 pm Post subject: One more minor issue

In the EQ summary box, if there are multiple items which all grant the same ability, it doesn't deduplicate, so you can end up with things like:

Grants: see in dark, see in light, see in ultra dark, see in ultra light, see in dark, see in dark, see in ultra dark, see in dark, see in light, see in ultra dark, see in ultra light, mindsight, see in dark, see in ultra dark, mindsight, see in dark, see in ultra dark, see in dark, see in ultra dark, see in dark, see in light, see in ultra dark, see in ultra light, see in dark

Doesn't prevent you from doing anything, but a bit annoying.

reklaw_3 · Posted: Sun Aug 31, 2008 10:01 pm Post subject:

Think we could get a new tab on items that are unique? Something like the alignment or lighting tabs. Maybe a search option to go along with it.

tazliel · Posted: Sat Sep 27, 2008 12:49 am Post subject: Unique and Threaded

Unique and Threaded fields have been added Smile

Time to update eq.

I will need help to update the race lists with the new remorts

The structure table for races is as follow, feel free to send me a sql file with the proper values

jjustice · Posted: Sat Oct 04, 2008 7:13 pm Post subject:

The issue with single quotes for items that tryphiodorus mentioned in Apr 2008 is also occurring for monsters in both the monster name and monster description fields.

See for instance the entries I just added for "Bua hai" (monsters.monster_id='1603') and "a stealthy arekla" (monsters.monster_id='1605') -- Bua hai should have an apostrophe in between the two words, and the desc for the arekla should say "raccoon's", not "raccoon`s" (e.g. not backquote).

-- Joseph