Log in

View Full Version : Sortable Spotlights?


Elgin Clock
01-05-2004, 04:28
Is there any way to make THIS (http://www.chiefdelphi.com/forums/spotlightlist.php?) page sortable by the username who the spotlight is written by?

Also is there anyway to see who nominated it to be a spotlight post as well?

Ryan M.
01-05-2004, 08:31
Is there any way to make THIS (http://www.chiefdelphi.com/forums/spotlightlist.php?) page sortable by the username who the spotlight is written by?

Also is there anyway to see who nominated it to be a spotlight post as well?
And is there anyway to search it? :)

Bharat Nain
01-05-2004, 11:09
And is there anyway to search it? :)
And is it fully updated?

Brandon Martus
01-05-2004, 11:31
Ok guys. What is this? Make Brandon work day? :) j/k
I'm bored. I guess I will re-vamp the spotlight page this morning.


Is there any way to make THIS (http://www.chiefdelphi.com/forums/spotlightlist.php?) page sortable by the username who the spotlight is written by?Yes. I will do that now.


Also is there anyway to see who nominated it to be a spotlight post as well?At first I didn't keep track of this. I started doing so a few weeks ago. I suppose I can show that data now..


And is there anyway to search it? :)Not yet. I can make that happen now, I guess.


And is it fully updated?Yes. I made an admin page (finally) and gave 3-4 moderators approve capabilities. Your spotlights should show up within 1 day, rather than 3 weeks later.

Bharat Nain
01-05-2004, 12:12
Sweet! You rock Brandon.

Brandon Martus
01-05-2004, 13:26
Sortable: Done.
See who suggested: Done (older ones wont have that info listed)
Searchable: Not without 2+ hours of work. I didn't design it correctly 2 years ago. I can't do that today.

MikeDubreuil
01-05-2004, 13:32
Sortable: Done.
See who suggested: Done (older ones wont have that info listed)
Searchable: Not without 2+ hours of work. I didn't design it correctly 2 years ago. I can't do that today.

Added By column displays usernames and links, but the link doesn't have a userid causing an error.

Brandon Martus
01-05-2004, 13:47
Thanks, fixed.

Elgin Clock
01-05-2004, 15:51
Ok guys. What is this? Make Brandon work day? :) j/k
Sorry Brandon.. When I looked at the main page on CD this morning and saw I was the only registered user on the forums along with about 6 guests and 13 spiders, I went looking for new features on CD, mainly the spotlight page.

BandChick
01-05-2004, 16:00
Thanks for all your help Brandon (I don't spend nearly enough time looking at the site extras) but now that the Spotlight is better and customizeable, I will be!

Brandon Martus
01-05-2004, 18:02
Hahah, don't worry about it. I was totally kidding.

Brandon Martus
02-05-2004, 14:23
Searchable: Not without 2+ hours of work. I didn't design it correctly 2 years ago. I can't do that today.LIAR! It only took about an hour and a half.

So now you can search the spotlights. It uses a boolean-mode fulltext search (http://dev.mysql.com/doc/mysql/en/Fulltext_Boolean.html) (you can use *, quotes, +, -, etc). Basically, use it as you would google or yahoo, if that doesn't make sense.

I had to do the whole redesign so the moderators could edit/delete past spotlights, so I figured I'd throw some searching in there as well.

Let me know if you find any bugs.

Tom Bottiglieri
02-05-2004, 16:08
now that i can look at who added the spotlight, Jessica Boucher must go crazy with the "spotlight post" button. She has like 29872984

mtrawls
02-05-2004, 17:13
Added By column displays usernames and links, but the link doesn't have a userid causing an error.
Thanks, fixed.

Is it? The "Username" column works correctly ... but on clicking a link in the "Added By" column, the link produces an error. And on examining the URL, it is indeed missing a userid value, e.g.,

http://www.chiefdelphi.com/forums/member.php?action=getinfo&userid=

Brandon Martus
02-05-2004, 18:10
Is it? It was until I essentially re-wrote it all this morning, to allow for editing, deleting, searching, and better moderating. Should be fixed now (again). Thanks.

Jessica Boucher
02-05-2004, 20:43
now that i can look at who added the spotlight, Jessica Boucher must go crazy with the "spotlight post" button. She has like 29872984

Yeah, yeah...those who aren't spotlit, spotlight....

I know Im part of the problem, but at least I'm helping with the solution!

Because of the craziness of the schedules of the spotlight mods at this moment in time, don't expect to see a major weeding until the end of May, when we can all get together and do a consensus-driven weeding. If there's one that bothers you immensely and can't wait, drop me a pm and I'll take care of it. :)

Elgin Clock
04-05-2004, 05:28
now that i can look at who added the spotlight, Jessica Boucher must go crazy with the "spotlight post" button. She has like 29872984
Yeah, I feel bad for Jess. She has spotlighted people many times, but has not been spotlighted at all. Well, I guess that enormous amount of rep points that she has makes up for it huh?? lol

Ryan M.
04-05-2004, 06:53
Hey, I didn't know I had been spotlighted (spotlit? illuminated?). :)

Thanks for the searching Brandon. See, I knew it wasn't that hard... ;)

Tom Bottiglieri
04-05-2004, 07:01
I still haven't been spotlit.. I'm hoping someone will see this and spotlight this post. :)

Ryan M.
06-05-2004, 07:03
Is there any way to make THIS (http://www.chiefdelphi.com/forums/spotlightlist.php?) page sortable by the username who the spotlight is written by?

Also is there anyway to see who nominated it to be a spotlight post as well?How do you get to the forum spotlight page anyway? (without this link... or memorizing the address...)

Joe Ross
06-05-2004, 07:12
How do you get to the forum spotlight page anyway? (without this link... or memorizing the address...)

Click on quick links on the menu bar, then extras at the bottom of that drop down then spotlight list on that page.

Brandon Martus
06-05-2004, 08:32
I've also added a 'more' link, similar to the countdown one.

Click on quick links on the menu bar, then extras at the bottom of that drop down then spotlight list on that page.