Can anyone fix these:

1) As mentioned in the TO DO list, clone listing still does not work. Is this an impossibility with the scripting?

2) # Option on the top menu does not return any hits.

Bonus) Is there a way that a "Last Active" feature could be added to the leaderboard, letting players know when the last time another player uploaded to MARP was? And is there any way of bringing back the movement arrows to the leaderboard? I always thought that they were kinda cool.

Regards, Q.T.Quazar

-- Q.T.Quazar (qan@home.com), April 17, 2000

Answers

Chad,

I've tried using RLIKE before, but it's considerably slower than LIKE. That's what's stopped me from fixing the clone listing bug until now. I need to do some testing to determine whether it's quicker to say

short_name RLIKE '(pacman|puckman)'

or

short_name = 'pacman' or shortname = 'puckman'

I imagine the second one would be quicker, and would require some changes to the Python scripts.

Chris.

-- Chris Moore (chr1s@mail.com), April 19, 2000.

1) is a regular expression problem with mysql, i think all that is needed to fix this is the proper escape sequence for the '(' and '|' characters. the slash '\' isn't enough or the right special escape character. I thought i had a possible fix for this but i forgot it, i'll try to look at the mysql docs and return.

2) This is a similar regular expression problem. "^[0-9]" should return all games that start with numbers but the '[' and ']' characters aren't being recognised as special characters. The problem could be that you need to give a special sql statement to look for regular expressions in that particular collumn.

Bonus) this is probably very doable, if zwaxy has enough time.

-- Chad (churritz@cts.com), April 17, 2000.

WOOHOO! I think i've found a solution to 1 and 2. Zwaxy, use "RLIKE" instead of "LIKE" when constructing the where clauses for the select statements, i think this is a pure regular expression search, instead of the psuedo one we're using (at least in the last python source you sent.) select * from games where long_name rlike '(pacman|pacmanm)';

I don't even think the slashes are necessary... but you should try some examples first. I'd imagine you'd want to use regular expression searching for all short game name searches, long name searches might still want to be psuedo regular expressions because you'd have to escape parathesis.

-- Chad (churritz@cts.com), April 18, 2000.