|
|
|
![]() |
|
|||||||
|
||||||||
|
|
Thread Tools | Rate Thread | Display Modes |
|
#6
|
|||||
|
|||||
|
come on here brandon
![]() ok.. don't really know the setup of the spotlight table.. but I'd guess there's some autoindex. (1-x) So.... SELECT max(spotlight_id) FROM spotlight_list vB query... $pick_this_one = rand(0, $spotlight_id_max); SELECT * FROM spotlight_list WHERE spotlight_id = $pick_this_one Yup... there ya go. ![]() or... I guess you could base it on session time or system time. (IE: total_spotlights % some_value) yeah... i know... i needs 2 queries ![]() OR... assumeing that vB has some "master config" table which takes all the fields/rows and dumps it into an array, you could have a config value max_spotlight. That's like 100 extra bytes and only requires to be run when a post is spotlighted. Jack PS: FYI to anyone.. Brandon really doesn't need the big roadmap i gave him .. I just wanted to have some funedit: the perfict way to bring down cd. Add a field to the user table which is updated every page refresh to the next spotlight_id - Would never get repeates thoLast edited by Jack : 29-04-2003 at 23:42. |
| Thread Tools | |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| External Spotlights | Brandon Martus | CD Forum Support | 17 | 04-12-2003 21:38 |
| how random are the spotlights? | Joe Ross | CD Forum Support | 7 | 11-01-2003 23:27 |