| Author |
 Topic  |
|
alex042
Average Member
USA
631 Posts |
 Posted - 07 September 2002 : 16:24:25
|
This is an update of Dan Martin's News Forum MOD.
Screenshots
Features
This MOD allows you to target one forum as your News forum and present the latest news anywhere you want. You can use the inc_news.asp where ever you'd like.
This MOD supports moderated topics. If you'd like to allow everyone to post news, make your News Forum moderated. The news posted by non-Moderators will not show up until it is moderated.
Version History
v1.1.0 09/07/02 - Initial Release
v1.1.1 09/11/02 - Bug Fixes: recordset closes
v1.1.2 09/16/02 - Bug Fixes: dbs database setup
v1.1.3 09/20/02 - Bug Fixes: recordset open/close
v1.1.3 09/22/02 - *Available to previous MOD author*
|
Edited by - alex042 on 22 September 2002 23:20:06 |
|
|
Lydecker
Junior Member
United Kingdom
297 Posts |
Posted - 07 September 2002 : 17:34:54
|
Cool - I've been waiting for this one - is there a demo anywhere?
THanks |
 |
|
|
alex042
Average Member
USA
631 Posts |
Posted - 07 September 2002 : 17:41:14
|
quote:
Cool - I've been waiting for this one - is there a demo anywhere?
You can check it out on my site here.
|
|
|
|
ajhvdb
Junior Member
Netherlands
392 Posts |
Posted - 07 September 2002 : 19:11:42
|
| Nice one, will try it. |
|
|
|
Lydecker
Junior Member
United Kingdom
297 Posts |
Posted - 07 September 2002 : 20:40:15
|
| So is it possible to set settings in snitz to allow all users to view the forum, but to only allow selected members to post in it (without moderation) - please can you refresh my memory? Thanks ;) |
Edited by - Lydecker on 07 September 2002 20:40:40 |
|
|
|
alex042
Average Member
USA
631 Posts |
Posted - 07 September 2002 : 21:08:32
|
quote:
So is it possible to set settings in snitz to allow all users to view the forum, but to only allow selected members to post in it (without moderation) - please can you refresh my memory? Thanks ;)
This MOD basically posts topics (not replies) from a specific forum to a news page. People would post in that forum per normal forum posting rules, so in this case, you could set up an allowed member list and select the members you want to have access to that forum. Those topics should then show up on the news page for all members. In this case though, members wouldn't have access to the forum directly, but would have access to see the topics posted there.
There are several options available based on how forum posting is setup. As you've probably noticed, I have mine setup so anyone can post to that forum, but since the forum is moderated, only approved topics get displayed. That way any member could post news as long as its approved.
|
Edited by - alex042 on 07 September 2002 21:17:41 |
|
|
|
auditude
Starting Member
USA
37 Posts |
Posted - 08 September 2002 : 22:44:15
|
I'm getting this error with this MOD. Any thoughts on how to troubleshoot??
ADODB.Recordset.1 error '80004005'
SQLState: 42000
Native Error Code: 1064
[TCX][MyODBC]You have an error in your SQL syntax near '' at line 1
/forum/inc_news.asp, line 13
|
|
|
|
sy
Average Member
United Kingdom
638 Posts |
Posted - 11 September 2002 : 05:40:44
|
Hi all,
I installed this mod and also get this same error using MS ACCESS
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/desk/techguy/inc_news.asp, line 13
Any advice?
|
The pessimist complains about the wind; the optimist expects it to change; the realist adjusts the sails
|
|
|
|
alex042
Average Member
USA
631 Posts |
Posted - 11 September 2002 : 18:47:48
|
quote:
/inc_news.asp, line 13
Make sure you've set a forum in your admin panel. The default forum is 1, but it's possible you may have deleted that one. If that doesn't fix it, do the following:
right above line 13, where is says rs.open strsql, my_conn,3 , add the following: response.write strsql
Paste the results here.
|
Edited by - alex042 on 11 September 2002 18:50:44 |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 16 September 2002 : 01:34:36
|
SQL2000 Error During Setup:
-2147217900 | The name 'STRNEWSFORUM_ID' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
|
 |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 16 September 2002 : 01:43:39
|
dbs_News_Forum.asp has a syntax error. it is missing a single quote before STRNEWSFORUM_ID as identified in the code below:
News Forum Refreshed MOD v1.1.1
[INSERT]
CONFIG_NEW
(C_VARIABLE,C_VALUE)#('STRNEWSFORUM_ID','1')
(C_VARIABLE,C_VALUE)#('STRNEWSTOPICCOUNT','5')
[END]
|
|
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 16 September 2002 : 01:52:08
|
| another question, if you pick a private forum and select it as the NEWS page, it will show to ALL members. is this intentional? |
|
|
|
|
alex042
Average Member
USA
631 Posts |
Posted - 16 September 2002 : 08:05:17
|
quote:
(C_VARIABLE,C_VALUE)#('STRNEWSFORUM_ID','1')
Thanks. I must've accidentally deleted that when I changed the variable to all caps.
quote:
another question, if you pick a private forum and select it as the NEWS page, it will show to ALL members. is this intentional?
I believe thats the way it was originally setup. I just updated this MOD so it would work with v3.4, but didn't do much with the logic. I was aware of this issue, but not sure if its a feature or a bug. I guess it depends on how you look at it.
|
|
|
|
Lydecker
Junior Member
United Kingdom
297 Posts |
Posted - 18 September 2002 : 22:09:24
|
This MOD dosent seem to happy clappy with 3.4.0.3.
I get:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
ODBC driver does not support the requested properties.
/24/content/inc_news.asp, line 33
When trying to run homepage.asp |
|
|
|
alex042
Average Member
USA
631 Posts |
Posted - 18 September 2002 : 22:20:54
|
quote:
/24/content/inc_news.asp, line 33
Try removing the ', 3' from line 33.
from:
rs.open strSql, my_conn, 3
to:
rs.open strSql, my_conn
This may be an issue specific to the ODBC drivers that may not be an issue with the OLE drivers.
|
|
|
|
Lydecker
Junior Member
United Kingdom
297 Posts |
Posted - 19 September 2002 : 06:37:44
|
This has b=no effect :(
(I am using a MySQL database) |
|
|
|
Topic |
|
Topic Locked
