MOD: mark "important" topics (beta)

Snitz™ Forums 2000
https://forum.snitz.com/forumTopic/Posts/61194?pagenum=1
05 November 2025, 05:22

Topic

eauxvives
MOD: mark "important" topics (beta)
28 February 2006, 12:06


this is a followup on the discussion here:
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=61093
as suggested by tribaliztic, I am making the code available to everyone.
The purpose of this small MOD is to allow moderators and admins to "mark" certain topics which then can be retrieved using a SQL query and for example be displayed on the site's home page (or forum) as 'webmaster's picks'.
IMPORTANT, PLEASE NOTE:
1. this is my first MOD (after having used Snitz for 7 years, I'm proud!)
2. I am very far from being an ASP/Snitz expert.
3. I have initially made the modifications on already heavily modded pages, so I hope I have not made mistakes in finding the changes and locating the proper places where to apply the changes on 'clean' pages. 4. English is not my native language

So, consider this as beta! I am waiting for the specialist's advice and suggestions on this, so please do not add this to your forum unless you're really sure what you're doing
So, here it is:
http://www.eauxvives.org/forum/mark_topic_help.htm

<

 

Replies ...

Jezmeister
28 February 2006, 13:35


I havent tested it but a few things that might make it easier for people:
Create a zip file containing the image files, readme and a dbs file... eg:

dbs_ImportantTopics.asp
Code for file:
Code:
DBS File For Important Topics Mod
[ALTER]
TOPICS
ADD#T_FLAG#int#NULL#
[END]

Also you might want to note that it's not MySql friendly asis, I'll have a go at installing it later - looks good!<
modifichicci
28 February 2006, 13:45


Don't forget to update A_TOPICS and admin_forums also, to let archive functions working...<
tribaliztic
01 March 2006, 05:25


Originally posted by Jezmeister

Also you might want to note that it's not MySql friendly asis, I'll have a go at installing it later - looks good!

AAAAAHH!!! Not MySQL-friendly? =)
What would cause problems? Can anyone do the required changes to make it work with MySQL? <
eauxvives
01 March 2006, 05:49


Originally posted by modifichicci
Don't forget to update A_TOPICS and admin_forums also, to let archive functions working...
don't know if anyone would want to 'mark' topic that are archived ? (i.e. 'old' )<
modifichicci
01 March 2006, 09:12


Not to archive that topic, but all topic will have a new field that must be also in A_ table.. or the routine of archiviation could fail.<
Jezmeister
01 March 2006, 14:17


Originally posted by Jezmeister

Also you might want to note that it's not MySql friendly asis, I'll have a go at installing it later - looks good!

AAAAAHH!!! Not MySQL-friendly? =)
What would cause problems? Can anyone do the required changes to make it work with MySQL?

well the specific thing I noticed was that you used "TOP" in your query - MySql doesn't support that... eg if you added this into inc_header.asp instead you could call the code from any part of the site:
Code:
if strDBType = "mysql" then
strITop2 = "select * from " & strTablePrefix & "topics where t_flag >0 order by t_flag desc"
strITop2 = strITop2 & " LIMIT 10 "
else
strITop2 = "select top 10 * from " & strTablePrefix & "topics where t_flag >0 order by t_flag desc"
end if
Set strITop = my_Conn.Execute(strITop2)
<
eauxvives
02 March 2006, 00:33


OK, i'll fix this
another suggestion I got is to add the icons also in active.asp, not only forum.asp
any other suggestions ?<
tribaliztic
02 March 2006, 05:15


Ah, the old TOP =) I thought it was more to it than that =)
<
OneWayMule
02 March 2006, 05:31


Originally posted by Jezmeister
AAAAAHH!!! Not MySQL-friendly? =)
What would cause problems? Can anyone do the required changes to make it work with MySQL?
well the specific thing I noticed was that you used "TOP" in your query - MySql doesn't support that... eg if you added this into inc_header.asp instead you could call the code from any part of the site:
Code:
if strDBType = "mysql" then
strITop2 = "select * from " & strTablePrefix & "topics where t_flag >0 order by t_flag desc"
strITop2 = strITop2 & " LIMIT 10 "
else
strITop2 = "select top 10 * from " & strTablePrefix & "topics where t_flag >0 order by t_flag desc"
end if
Set strITop = my_Conn.Execute(strITop2)
That's what the TopSQL funcion from inc_func_common.asp is for...
So instead of
Code:
if strDBType = "mysql" then
strITop2 = "select * from " & strTablePrefix & "topics where t_flag >0 order by t_flag desc"
strITop2 = strITop2 & " LIMIT 10 "
else
strITop2 = "select top 10 * from " & strTablePrefix & "topics where t_flag >0 order by t_flag desc"
end if
Set strITop = my_Conn.Execute(strITop2)
you can use
Code:
strITop2 = "SELECT FROM " & strTablePrefix & "TOPIC WHERE T_FLAG > 0 ORDER BY T_FLAG DESC"
strITop2 = TopSQL(strITop,10)
Set strITop = my_Conn.Execute(strITop2)
<
tribaliztic
02 March 2006, 05:42


Nice, there are some good stuff in the inc_func-files.. =)
btw, is there a list of all functions and how they could be used? <
OneWayMule
02 March 2006, 05:50


Such a list is being worked on.<
tribaliztic
02 March 2006, 05:57


Great!! I've discovered some of the functions while working on mods and they are a BIG help once you understand what they're doing =)

Offtopic: I've posted a couple of questions at your site OWM =)
<
Jezmeister
02 March 2006, 07:39


Originally posted by OneWayMule

That's what the TopSQL funcion from inc_func_common.asp is for...[/code]

I have to say I've never noticed that before... guess it's worth remembering smile ty.<
OneWayMule
02 March 2006, 13:29


No prob! smile<
eauxvives
02 March 2006, 15:41


I'm impressed to see how smart are the snitz team guys :-)))<
© 2000-2021 Snitz™ Communications