| Author |
 Topic  |
|
|
eauxvives
Junior Member
Bhutan
145 Posts |
 Posted - 20 February 2006 : 04:00:29
|
hello all
here is what we would like to do: we would like to be able to display on our website home page a series of 'webmaster's pick' of what we believe are the 10 or so most 'interesting' recent topics from our snitz forum. So what we would need is to be able to 'mark' such topics in the forum (option available to mods/admins) after which we would just have to write the proper query for the home page. Ideally, this 'marking' would be done by clicking on an icon (e.g. similar to that for sticky topics)
has this been done before? I've searched the forum and could not find it. apparently the bookmark mod is different (and anyway I can't get it to work)< |
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 20 February 2006 : 06:40:13
|
Just rip the code for "sticky topics" and create a new field in the db. Then do a select on all topics with that mark and display them via a modded "show ten latest topic"-code. Shouldn't be that hard I think.
< |
/Tribaliztic
- www.gotlandrace.se -
|
 |
|
|
eauxvives
Junior Member
Bhutan
145 Posts |
Posted - 20 February 2006 : 08:19:01
|
quote:
Originally posted by tribaliztic
Just rip the code for "sticky topics" and create a new field in the db. Then do a select on all topics with that mark and display them via a modded "show ten latest topic"-code. Shouldn't be that hard I think.
yep, will do.< |
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 20 February 2006 : 10:21:12
|
That's how I do it anyways =)
< |
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
eauxvives
Junior Member
Bhutan
145 Posts |
Posted - 27 February 2006 : 09:29:41
|
OK,
- I added a field in forum_topics table, i.e. T_FLAG,
- T_flag is set to 1 by pop_lock.asp, modified by reusing the code for setting a topic as sticky (haven't yet changed pop_open.asp to 'unmark' the marked topics, i.e. set t_flag back to 0)
- change forum.asp to add a new icon on each line , next to the sticky icon, that calls pop_lock.asp to mark the topic
however at this point I am stuck. I would like to display the 'mark topic' icon only when the topic is not yet marked (and later add a 'unmark' icon when the topic is marked). But how do I test (in forum.asp) whether a topic is marked or not? I have tried to play around the similar code for sticky topics but got lost
< |
|
|
|
eauxvives
Junior Member
Bhutan
145 Posts |
Posted - 27 February 2006 : 12:56:34
|
OK I figured it out myself
If there are people interested, I'll try to describe exactly the changes I've applied
< |
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 28 February 2006 : 04:20:53
|
It would be nice to see what you did, maybe someone else could use the code!
Glad to hear that you fixed it!
< |
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
eauxvives
Junior Member
Bhutan
145 Posts |
Posted - 28 February 2006 : 12:07:47
|
quote:
Originally posted by tribaliztic
It would be nice to see what you did, maybe someone else could use the code!
Glad to hear that you fixed it!
done!
I started a new thread here http://forum.snitz.com/forum/topic.asp?TOPIC_ID=61194< |
|
|
| |
Topic |
|
mark 'important' topics?
