| Author |
 Topic  |
|
|
SalmanKhana
Average Member
USA
961 Posts |
|
|
Pouyan
New Member
91 Posts |
 Posted - 11 August 2002 : 02:43:28
|
Your topic is "Someone please explain what this mod does", well it lets you pull content out of specific forums for display on non-forum pages with many great features & different display formats. It is basically Snitz Content Management solution, similar to all the other content management applications available in the market. Let's you use your forum as a central content management source for your site.
Now if you wanna know how to get it to work, that's a DIFFERENT story. I need this mod too, but I haven't been able to get it to work yet. Finally gave up on Rob's old Display Content Mod V2 after struggling with it & running around for a while, someone seriously needs to pick this mod up and update it to the new version. It looks like such an awesome mod with many great features, unfortunately almost impossible to install for dummies like me 
quote:
Basically it would be nice if someone could explain this for me http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&whichpage=1&TOPIC_ID=12878
Basically it is telling you that you have to create a table in your database and go around looking for all the dependencies of this mod (some of them are included in 3.3, some of them are not) some of them don't exist anymore, some of them aren't compatible with 3.3. Now once you get all the dependencies installed, there are a million posts of people saying they haven't been able to get it to work with Access database, even the author says he isn't sure about Access. You can try e-mailing GauravBhabu (Rakesh) as I did, apparantly he knows and has worked on this mod. He's gonna tell you "the file in the zip is the correct file".
Good luck man !
You might wanna check out the new News Forum Mod:
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=31088
It is doing the job for me, at least until I SOMEHOW get the Display Content Mod to work. |
Edited by - Pouyan on 11 August 2002 02:57:56 |
 |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 11 August 2002 : 03:00:15
|
Why not just create your own?
The below code is all you need to "strip" a post out of a forum, just add your own HTML and your good to go.
intforumID is the Forum ID
intCount is the number of topics to pull from the DB.
sub DisplayForum(intForumID,intCount)
strSql = "SELECT TOP " & intCount & " "
strSql = strSql & strTablePrefix & "TOPICS.T_SUBJECT, "
strSql = strSql & strTablePrefix & "TOPICS.T_MESSAGE, "
strSql = strSql & strTablePrefix & "TOPICS.T_DATE, "
strSql = strSql & strTablePrefix & "TOPICS.T_AUTHOR, "
strSql = strSql & strTablePrefix & "MEMBERS.MEMBER_ID, "
strSql = strSql & strTablePrefix & "MEMBERS.M_NAME "
strSql = strSql & " FROM ((" & strTablePrefix & "FORUM "
strSql = strSql & "INNER JOIN " & strTablePrefix & "TOPICS ON "
strSql = strSql & strTablePrefix & "FORUM.FORUM_ID = "
strSql = strSql & strTablePrefix & "TOPICS.FORUM_ID) "
strSql = strSql & "INNER JOIN " & strTablePrefix & "MEMBERS ON "
strSql = strSql & strTablePrefix & "TOPICS.T_AUTHOR = "
strSql = strSql & strTablePrefix & "MEMBERS.MEMBER_ID) "
strSql = strSql & " WHERE " & strTablePrefix & "TOPICS.FORUM_ID = " & intForumId
strSql = strSql & " ORDER BY " & strTablePrefix & "TOPICS.T_DATE DESC "
set rs = my_Conn.execute(strSql)
while not rs.EOF
%>
<!-- You HTML Goes here to display the post -->
%>
rs.MoveNext()
wend
rs.close
set rs = nothing
End Sub
%>
The following Information is retrieved for Each post
rs("T_MESSAGE") = Topic Message Contents
rs("T_SUBJECT") = Topic Subject
rs("T_DATE") = Topic Post Date/Time
rs("T_AUTHOR") = Topic Authors Member Id
rs("M_NAME") = Topic Authors Name
Selection is done in descending date order, so calling the sub with say DisplayForum(6,10) would show the lastest 10 topics from forum Id = 6
|
Kiwihosting.Net - The Forum Hosting Specialists
|
Edited by - Gremlin on 11 August 2002 03:04:52 |
|
|
|
Pouyan
New Member
91 Posts |
Posted - 11 August 2002 : 03:03:45
|
Gremlin,
This is exactly what the News Forum Mod does right ? Yeah it is useful if 'display a certain number of characters' is not required. I even got the News Forum Mod to display part of the content with a [Read More] link. |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 11 August 2002 : 03:06:28
|
If you want to display a certain number of charaters, then simple change the sub to include an option for number of characters ie
sub DisplayForum(intForumID,intCount,CharCount)
And then when outputting the message simply use
Response.Write Left(formatStr(rs("T_MESSAGE")),CharCount)
|
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
SalmanKhana
Average Member
USA
961 Posts |
Posted - 11 August 2002 : 03:24:53
|
Thanks Pouyan, that was a very quick informative post..
Gremlin i owe u man! that was great  .. i will try make it work............ if it does, then i'm very happy!
|
_______________________
Tribute to the best hosting company I've known so far http://www.reddi-web.com  + |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 11 August 2002 : 03:29:23
|
| Just let me know if you want help SalmanKhana. If you look at the front page of my site you'll see that all of those "news" posts there are basically just using that sub I posted above. |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
SalmanKhana
Average Member
USA
961 Posts |
Posted - 11 August 2002 : 03:33:03
|
o great ! . thanks for the heads up.
i am interesting in making snitz as a content management system in my resource site and also upcoming jokes site.. do u think this is a good idea ? |
_______________________
Tribute to the best hosting company I've known so far http://www.reddi-web.com + |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 11 August 2002 : 03:42:05
|
| Yeah Snitz works pretty well as a Content System. Rob's Mod above was great but awfully painfull to install, personally I think you'll find it easier just building what you specifically need from the ground up. |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
SalmanKhana
Average Member
USA
961 Posts |
Posted - 11 August 2002 : 03:58:35
|
Gremlin, i agree that would be much easier but i am not very familiar with asp yet  . |
_______________________
Tribute to the best hosting company I've known so far http://www.reddi-web.com + |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 11 August 2002 : 04:18:46
|
A great opportunity to pick up a little more knowledge then :)
Snitz is great becuase most of the hardstuff is already done for you in on the content management side of things, all you need is to create the "display" side of it :) |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
SalmanKhana
Average Member
USA
961 Posts |
Posted - 11 August 2002 : 04:27:07
|
your right :-) and thats what i am trying to do.. i occasionally go to 4guys site if i dont understand some statements in snitz code and learn why it is so..
so now with your help, i will at the end be able to do alot in asp
Thank! |
_______________________
Tribute to the best hosting company I've known so far http://www.reddi-web.com + |
|
|
| |
Topic |
|
Topic Locked
