Forum Settings
       
« Previous 1 2 3
Reply To Thread

Break meFollow

#1 Mar 24 2006 at 10:46 AM Rating: Excellent
Code Monkey
Avatar
****
7,476 posts
Ever forgotten when you first contacted your loved one over a PM?
Wanted to reminice about your first Cyb0ring on Allakhazam.com?
Want to track down every message some as[cyan][/cyan]shole sent you so you can find them and shoot them?

If so, feel free to test out my new PM Name Searcher!

Now you can go and find out every time your favorite admin has yelled at you helped you out with technical problems!
____________________________
Do what now?
#2 Mar 24 2006 at 10:55 AM Rating: Decent
***
1,254 posts
I broke it.

Quote:
weedle<a href=


Leads to some sort of broken linky thing. Not that anyone would want to do that.
#3 Mar 24 2006 at 10:55 AM Rating: Good
nifty!

I did a search for a name with over 128 chars (including specials)...the search took 47 seconds to complete, but it didn't error. May want to set the maxlength property of the textbox though.

Quote:
Leads to some sort of broken linky thing.


Confirmed.

Edited, Fri Mar 24 11:00:45 2006 by Frakkor
#4 Mar 24 2006 at 10:57 AM Rating: Excellent
Code Monkey
Avatar
****
7,476 posts
AngryUndead wrote:
I broke it.

Quote:
weedle<a href=


Leads to some sort of broken linky thing. Not that anyone would want to do that.


Ah yeah, fixed that, thanks. I had hardened it against malicious code... then added another display before that... oops!
____________________________
Do what now?
#5 Mar 24 2006 at 11:00 AM Rating: Good
****
4,596 posts
It just reminded me that I never get any PMs. Does that make me a L00s3r?
____________________________
Nicroll 65 Assassin
Teltorid 52 Druid
Aude Sapere

Oh hell camp me all you want f**kers. I own this site and thus I own you. - Allakhazam
#6 Mar 24 2006 at 11:01 AM Rating: Excellent
Code Monkey
Avatar
****
7,476 posts
The One and Only Frakkor wrote:
I did a search for a name with over 128 chars (including specials)...the search took 47 seconds to complete, but it didn't error. May want to set the maxlength property of the textbox though.


Good call. Changed it to 30 since that's our max username length.
____________________________
Do what now?
#7 Mar 24 2006 at 11:02 AM Rating: Good
***
3,053 posts
Looks like I don't get enough pm's to break it.

I just don't cyper like I used to.
____________________________
In the place of a Dark Lord you would have a Queen! Not dark but beautiful and terrible as the Morn! Treacherous as the Seas! Stronger than the foundations of the Earth! All shall love me and despair! -ElneClare

This Post is written in Elnese, If it was an actual Post, it would make sense.
#8 Mar 24 2006 at 11:03 AM Rating: Good
***
3,118 posts
I think you broke it again. It doesn't come back with results the first time I click the button, but it does the second time with the same uname in the text box.

Also, it doesn't seem to search for partial names. I can't be ***** to remember peoples names, let alone the exact spelling of them.
#9 Mar 24 2006 at 11:05 AM Rating: Excellent
Code Monkey
Avatar
****
7,476 posts
ew, partials! If you don't know somebody's name, too damn bad!

Well, for now at least.

anyone else getting no results for queries? It could just have been a fluke from a stuck query.
____________________________
Do what now?
#11 Mar 24 2006 at 11:16 AM Rating: Excellent
Code Monkey
Avatar
****
7,476 posts
Baron von AngstyCoder wrote:
How does this work with ignored users? I don't have any to test.


It doens't even look at the ignored users list. I'm assuming that if you want to look up all messages by person X, you want to look them up whether they're on ignore or not!
____________________________
Do what now?
#12 Mar 24 2006 at 11:18 AM Rating: Decent
***
1,254 posts
If I search for kao* or kao% I get a "No user by that name" message.

If I search for plain "kao" I get the following (pic linky)

Confirmed that the eariler link bug is fixed.
#13 Mar 24 2006 at 11:23 AM Rating: Excellent
Code Monkey
Avatar
****
7,476 posts
I'm doing a straight up SQL = statement, so wildcards aren't gonna do you any good. And there is a user named "kao".

You can click on the username after the TO or FROM to go to their poster.html page.
____________________________
Do what now?
#14 Mar 24 2006 at 12:01 PM Rating: Good
change your SQL = to a SQL like. We'll try to break it again.
#15 Mar 24 2006 at 12:02 PM Rating: Excellent
Code Monkey
Avatar
****
7,476 posts
Meh. I guess I'd just return the first result. Unless you really think you want a list and choices.
____________________________
Do what now?
#17 Mar 24 2006 at 12:09 PM Rating: Excellent
Code Monkey
Avatar
****
7,476 posts
Yeah, LIKE works fast enough. Think I need to explain the whole % syntax thing to people?

Or just let those "in the know" use it that way? =P

Edited, Fri Mar 24 12:13:03 2006 by Danalog
____________________________
Do what now?
#18 Mar 24 2006 at 12:46 PM Rating: Good
Avatar
*****
10,802 posts
I don't get many PMs but I searched for Tavarde. He asked me to stop flaming him on a thread and I wanted to read his PMs again for my chuckle for the day.
#19 Mar 24 2006 at 1:10 PM Rating: Good
Quote:
Yeah, LIKE works fast enough. Think I need to explain the whole % syntax thing to people?

Or just let those "in the know" use it that way? =P


In the past, I've just built the wildcards into the query. Depends on if you ALWAYS want them in.

I would not return a list of choices, just the list of results...IMHO.
#20 Mar 24 2006 at 1:20 PM Rating: Excellent
Code Monkey
Avatar
****
7,476 posts
I wanted it to be as speedy as possible. I guess I could build it in though, I don't think that would really be too much of a performance hit...

Just wondering though, say there's user Kao and user Kaolian, and Kaolian is first in the database, if you search "Kao%" will the first match be Kaolian? If so, I really don't want to auto assume %
____________________________
Do what now?
#21 Mar 24 2006 at 1:22 PM Rating: Good
Kao should be the first result if sorted by name, but yeah, assuming % is something that you'll need to decide to do.

For my projects in the past it made sense.

Perhaps an checkbox that will add in the % if full name isn't known?

Edited, Fri Mar 24 13:26:12 2006 by Frakkor
#22 Mar 24 2006 at 1:23 PM Rating: Excellent
Code Monkey
Avatar
****
7,476 posts
I guess I could add a Fuzzy Search checkbox, but I wanted to keep it as simple as possible
____________________________
Do what now?
#23 Mar 24 2006 at 1:23 PM Rating: Good
then no LIKE.

geesh, you could've said that from the beginning! Smiley: sly
#25 Mar 24 2006 at 1:24 PM Rating: Good
***
3,118 posts
Danalog the Vengeful Programmer wrote:
I wanted it to be as speedy as possible. I guess I could build it in though, I don't think that would really be too much of a performance hit...

Just wondering though, say there's user Kao and user Kaolian, and Kaolian is first in the database, if you search "Kao%" will the first match be Kaolian? If so, I really don't want to auto assume %
I'm pretty sure that depends entirely on if/how you have the database indexed or if/how you have the results sorted.

The checkbox might be a convenient work around for partial name searches.
#26 Mar 24 2006 at 1:24 PM Rating: Excellent
Code Monkey
Avatar
****
7,476 posts
because I wanted a damn search page!
____________________________
Do what now?
« Previous 1 2 3
Reply To Thread

Colors Smileys Quote OriginalQuote Checked Help

 

Recent Visitors: 232 All times are in CST
Anonymous Guests (232)