| Author |
 Topic  |
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
 Posted - 05 January 2002 : 19:41:37
|
Umm, they do exactly what i said to do, except they then built the tree using a stored procedure and a temporary table.
|
 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 05 January 2002 : 19:54:41
|
Actually, i think this is more in tune with what we are talking about
http://www.sqlteam.com/Item.asp?ItemID=1353
it adds a parent_id and a thread id to the reply table
where parent_id is the message you have replied to, and thread_id is the originale reply/topic for the tree, looks pretty simple, and could be done with some minor query additions to populate thread_id and parent_id.
|
|
|
|
Spooky
Development Team Member
New Zealand
320 Posts |
Posted - 05 January 2002 : 20:52:02
|
Huwr, certainly what we were talking about was 1/2 of the equation :)
Before looking more carefully, it certainly looks like a way of sorting what you meant.
Both of those resources look real useful, now to see if time allows :)
When can we add sp's to Snitz? :)
===============
www.outfront.net
Edited by - Spooky on 05 January 2002 20:53:55 |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 06 January 2002 : 00:04:00
|
[quote]When can we add sp's to Snitz? :)[/quote]
When we want to drop support for Access and MySQL databases.
======
Doug G
====== |
|
|
|
Spooky
Development Team Member
New Zealand
320 Posts |
Posted - 06 January 2002 : 00:42:09
|
I knew that was coming ;)
===============
www.outfront.net |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 06 January 2002 : 03:40:40
|
he he, you should be able to do it with a couple of small queries/functions instead.
|
|
|
|
xstream
Junior Member
242 Posts |
Posted - 06 January 2002 : 13:31:01
|
Are you guys going to try and implement this soon? Just wondering, because this is a feature we are looking for on our board. We currently are using Ezboard and have this option but would like to switch to something more customizable like Snitz.
X
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 06 January 2002 : 13:40:49
|
| Only as a MOD, not included in the base code. Snitz Forums 2000 is a Flat View Forum, not a threaded Forum. |
|
|
|
Spooky
Development Team Member
New Zealand
320 Posts |
Posted - 06 January 2002 : 14:39:10
|
Check out the link further up xStream, if you want a mod thats ready to go.
This discussion should have really been in the mod section too.
I left it here because it was tied in with some work I was doing with getrows.
===============
www.outfront.net |
|
|
|
xstream
Junior Member
242 Posts |
Posted - 06 January 2002 : 15:00:58
|
Thanks Spooky, but the mod that's out only shows the thread after you click on the topic. I'm needing something that displays all the topics in threaded view after clicking on the forum. Like here: http://pub76.ezboard.com/fpiestacticsgeneraldiscussion
X
|
|
|
|
Spooky
Development Team Member
New Zealand
320 Posts |
Posted - 06 January 2002 : 15:10:45
|
Its more along the lines I was thinking too.
My first preference is to show topics heading only and make it "thread" collapseable.
Similar to what I do on my forum (www.frontpagewebmaster.com) but with the thread, not just the topic text.
If I ever get around to doing it as a mod, Id probably only aim to do it as SQL only - but as part of doing that, you could see where the possibilities lay for other databases.
===============
www.outfront.net |
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 07 January 2002 : 13:55:41
|
How about using bookmarks and filter. I have had a partial success in getting to display the threads using bookmarks. Just added a field THREAD_ID in Table REPLY. Whenever there is a Reply with quote I insert the REPLY_ID (of the quoted message) to The THREAD_ID column of new post.
It is working okay going deep into the threads. I still have to fix it getting back to the top level.
Blue - Got the threads to show.
Red - Still to be fixed.
1
1.1
1.1.1
1.1.1.1
1.1.1.2
1.1.2
1.1.3
1.2
1.2.1
1.2.2
1.2
1.3
1.4
www.forumSquare.com - GauravBhabu - It is difficult to IMPROVE on Perfection, There is no harm in Keep Trying. |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 07 January 2002 : 20:46:38
|
Don't forget to levels past 10, you'll probably find ordering problems.
1.1
10.1
11.1
2.1
3.1
======
Doug G
====== |
|
|
|
Spooky
Development Team Member
New Zealand
320 Posts |
Posted - 07 January 2002 : 23:15:49
|
I think thats why I like a text version with "padded" values - each will be 5 (or 6) values
00001-00001
00001-00001-00002
00001-00002
The sort will always be correct.
Both of the SQL resources do something similar, I may try one or both :)
===============
www.outfront.net |
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 08 January 2002 : 02:46:41
|
I am not having any ordering problems. And having further success using bookmark. Hopefully i will be able to complete it during this week.
Below is how I am looping through the recordset. Using the subs just to display the thread link and do some formatting. I might use filter. However, This is the basic structure.
What I got so far is here
do until rs.EOF
CColor = "First"
if intI = 0 then CColor = "Alt"
if ThreadExists then
rs.find "THREAD_ID =" & intMainParent,0,1,MainParentBookMark
intThreadLvl = 0
intThreadCount = 0
Call WriteThreads()
rs.bookmark = MainParentBookMark
rs.MoveNext
end if
if rs("THREAD_ID") > 0 then
if blnThreadOpen and rs("THREAD_ID") = intMainParent then
if rs("THREAD_ID") = intMainParent then intThreadLvl = 0
if ThreadExists then
ThreadExists = false
if CheckLastThread(rs.bookmark) then Response.Write "-Ln 346: " & rs("REPLY_ID")
else
Call WriteNewParent()
end if
ParentBookMark = rs.bookmark
rs.bookmark = ParentBookMark
end if
else
if rs("THREAD_ID") = 0 and rs("REPLY_ID") <> intMainParent then
if blnThreadOpen then Call CloseThread()
Call OpenThread()
intMainParent = rs("REPLY_ID")
MainParentBookMark = rs.bookmark 'Mark this as MainParent
ThreadExists = True
if CheckLastThread(MainParentBookMark) then ThreadExists = false
Call WriteParent() 'This is Main Parent below Topic
end if
end if
rs.MoveNext
intI = intI + 1
if intI = 2 then intI = 0
loop
if blnThreadOpen then Call CloseThread()
rs.close
set rs = nothing
www.forumSquare.com - GauravBhabu - It is difficult to IMPROVE on Perfection, There is no harm in Keep Trying.
Edited by - GauravBhabu on 08 January 2002 13:11:12 |
|
|
|
Topic |
|
Topic Locked
