Can anyone fix these:
<p>
1) As mentioned in the TO DO list, clone listing still does not work. Is this an impossibility with the scripting?
<p>
2) # Option on the top menu does not return any hits.
<p>
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.
<p>
Regards,
Q.T.Quazar
--
qan@home.com
Broken Things at MARP
Moderator: Chad
-
Chad
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.
<p>
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.
<p>
Bonus) this is probably very doable, if zwaxy has enough time.
--
churritz@cts.com
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.
<p>
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.
<p>
Bonus) this is probably very doable, if zwaxy has enough time.
--
churritz@cts.com
-
Chad
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)';
<p>
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.
--
churritz@cts.com
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)';
<p>
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.
--
churritz@cts.com
-
Chris Moore
Chad,
<P>
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
<P>
short_name RLIKE '(pacman|puckman)'
<P>
or
<P>
short_name = 'pacman' or shortname = 'puckman'
<P>
I imagine the second one would be quicker, and would require some
changes to the Python scripts.
<P>
Chris.
--
chr1s@mail.com
<P>
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
<P>
short_name RLIKE '(pacman|puckman)'
<P>
or
<P>
short_name = 'pacman' or shortname = 'puckman'
<P>
I imagine the second one would be quicker, and would require some
changes to the Python scripts.
<P>
Chris.
--
chr1s@mail.com