Snitz™ Forums 2000
https://forum.snitz.com/forumTopic/Posts/62840?pagenum=1
04 November 2025, 21:39
Topic
Davio
Merge Topic Mod BETA 2
21 September 2006, 20:12
Mod Name: Merge Topic Mod Version: Beta 2 Snitz Forums Tested with: 3.4.05 and newer (should be able to work with all 3.4 versions) Database support: All database types supported Author: Davio Last Updated: September 25, 2006.
Description: This mod allows you to merge 2 topics together, along with all of their replies. Replies will be ordered by their post date.
Download: Primary site: http://www.snitzbitz.com/mods/details.asp?Version=All&mid=233
To-Do: - Add feature to email author that his topic was merged with another.
- Handling of subscriptions need to be dealt with for both topics being merged.
- Maybe get a better icon to use?
- Fix bugs!
Known Bugs: - When merging 2 topics between 2 different forums, the merged topic ends up in the wrong forum. FIXED in beta 2 You guys have been asking me for this code for the longest while. So here it is.
It is not fully ready for prime time. There is still some things left on the To-Do list and some bugs to iron out. But hoping with your help, we can get it there more quickly, instead of waiting on me. Please don't use this on your live forum as yet. If you do, don't come and blame anyone here that your topics got messed up.
Please post your bug reports, errors, suggestions in this thread.<
Replies ...
sachin
21 September 2006, 22:01
Thnx a lot Davio... will test it soon :)<
Davio
22 September 2006, 16:52
Ok, I see the logic of my coding in the post_info.asp file needs a little more working on.
I'm using the older topic, the topic that has the older date, as the target topic. But when you merging between 2 forums, there is no way to find out which topic the mod/admin wants to merge with, using this logic. Because he could be merging an older topic with a newer topic.
So it will need a little recoding there.
Identify the topic mod/admin wants to merge with, then after, sort out which topic is older and let it remain as the main topic. The replies can come afterwards.
Did you all get that?
This thing is busting my brains. lol<
rasure
23 September 2006, 16:57
Hi Davio, I get this error when merging 2 topic in the same forum
if lcase(strEmail) = "1" then 'Send mail to author letting him know his topic was merged with another.
'DoAutoMoveEmail(allRec(Topic_ID, intOlderTopic)) strSql = "SELECT M.MEMBER_ID, M.M_NAME, M.M_EMAIL, T.FORUM_ID, T.T_SUBJECT " strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS M, " & strActivePrefix & "TOPICS T " strSql = strSql & " WHERE M.MEMBER_ID = T.T_AUTHOR " strSql = strSql & " AND T.TOPIC_ID = " & TopicNum 'Response.Write strSql 'Response.End line 1833 set rs2 = my_Conn.Execute (strSql)
not sure if that's related to your above post, btw I also have your split topic mod installed on an already moded snitz, and I used the complete url to the topic to merge to, not sure if that's the correct way of doing it.<
Davio
25 September 2006, 02:21
Yes, that part of the code is on the to-do list. Has to do with sending an email out to the author about what is happening with his topic. Can comment out that part of the code or change the 1 in this line " if lcase(strEmail) = "1" then" to 0. That will effectively turn off that section of the code.
Still busting my brains with the code when merging topics from different forums. Works if the topic is in the same forum though.<
Davio
25 September 2006, 05:39
Ok, lets move on to BETA 2!
I think I fixed the bug with merging topics across forums. Only thing changed was the Merge Topic Mod code in post_info.asp. So copy the code from lines 957 - 1313 in post_info.asp to update to BETA 2.
Things you can test.
1. Merge topics in same forum.
2. Merge topics from different forums.
3. Merge topics and give it a new subject.
4. Do #1 and monitor the Topic and Replies count on default.asp 5. Do #2 and monitor the Topic and Replies count on default.asp 6. Merge topics with no replies.
7. Merge topics with replies.
8. Make sure the last post links point to the last posted reply or topic.
I have disabled the subscription section of the code, so you won't run into any errors while testing.<
OneWayMule
26 September 2006, 05:15
Will take a look at it!
I attempted such a MOD some time ago but never finished it.<
OneWayMule
26 September 2006, 07:22
1. Merge topics in same forum. Worked
2. Merge topics from different forums. Worked
3. Merge topics and give it a new subject. Worked
4. Do #1 and monitor the Topic and Replies count on default.asp Worked
5. Do #2 and monitor the Topic and Replies count on default.asp Worked
6. Merge topics with no replies. Worked
7. Merge topics with replies. Worked
8. Make sure the last post links point to the last posted reply or topic. Worked As you can see, I had no problems so far... tested with and without locked forums, seems to work well.
Will give it some more testing with a live forum I'm running and get back to you with more info. <
Davio
26 September 2006, 09:46
Excellent! Thanks OneWay! Whew! Glad I got the main part working.
But it's not feature complete yet. Need to alert authors when moving their topics around. They will be totally lost without it.
Also need to take care when merging with moderated topics/replies.
And to email subscribers that there are new replies to the topic they subscribed to.<
Davio
26 September 2006, 10:06
OneWay, just out of curiosity, I checked the snitzbitz site a while ago and it showed the mod was downloaded 0 times since I uploaded it. How was it you downloaded the mod and the counter didn't increase?
I just downloaded it and it increased by 1. Strange.<
OneWayMule
27 September 2006, 02:16
Good question... I got merge_topic_mod-34-BETA_10.zip, if I download it now I get a different file name... might be the reason. <
Davio
27 September 2006, 02:50
So was it beta 1 you tested or beta 2? Cause beta 1 was still buggy. lol<
OneWayMule
27 September 2006, 03:04
Hehehe, umm... the zip file says Beta 1, the files in the zip are the same as those in Beta 2 though...
(And I only read this topic after you posted about Beta 2)<
rasure
28 September 2006, 01:09
Sorry been a little busy with work, will download and test latest version later, many thanks for your hard work davio<
blackinwhite
25 November 2006, 07:51
1. Merge topics in same forum. ok 2. Merge topics from different forums. ok 3. Merge topics and give it a new subject. ok 4. Do #1 and monitor the Topic and Replies count on default.asp ok 5. Do #2 and monitor the Topic and Replies count on default.asp ok 6. Merge topics with no replies. ok 7. Merge topics with replies. ok 8. Make sure the last post links point to the last posted reply or topic. ok
AS you already say it, only problem I see is the lack of subscription function.
Dou you have any plan to work on subscriptions or should i start to write my own?
thanks for the great work, I really appreciate it.<
blackinwhite
25 November 2006, 14:47
and about icon :) thre reverse version of split topic icon will do the work ;)<
Davio
25 November 2006, 15:45
You are free to work on the subscriptions part. I haven't looked at the code for a little while. Been busy. But if you do work on it, would appreciate it if you shared it with me, so I couldn't probably use it in the mod. <
CalloftheHauntedMaster
07 December 2006, 16:52
Is this thing still in beta testing? Cause I'd like to try it on my live forum...<
Davio
07 December 2006, 18:00
Yes it is. From all indications, the main core of the mod works. That is, it merges posts topics. Just that some features are not done yet, as seen in the first post.
If these things are not trivial to you, you can give it a whirl. Otherwise, would suggest holding off on it.<
CalloftheHauntedMaster
07 December 2006, 18:16
Well, I do not use subscriptions anywhere nor do I have the "email member of moved post" feature turned on. Therefore, these issues don't affect my forum in any pertinent way.
Guess I'll try it out.
Maybe you should make an auto-merge double post mod next, eh? <
Davio
07 December 2006, 18:22
Auto-merge? lol Umm, sounds like trouble.
I think there are somethings left for moderators to do. <
CalloftheHauntedMaster
07 December 2006, 18:38
Nah, it seems simple (http://forum.snitz.com/forum/topic.asp?TOPIC_ID=63497)
Besides, why let moderators do it when you've already written 2 awesome mods. Go for 3 out of 3. <
MarkJH
16 January 2007, 14:17
Was going to install this MOD then noticed how easy it was for a moderator to delete the wrong topic.
Is there no easier way of doing this than having to type the URL of the topic you'd like to merge with another? Anything involving typing URLs or deleting topics has DANGER written all over it! Even the most on-the-ball mod or admin could still make mistakes.<
CalloftheHauntedMaster
16 January 2007, 15:01
Your worries seem unfounded Mark. The topics are merged and then the second topic is deleted. You can't accidentally delete a topic because this mod will specifically combine them into one. Ergo, no danger of losing a topic.
And if the wrong ones are merged, use the split topic mod to correct this problem. That's why I have them both installed and working flawlessly. <
Davio
16 January 2007, 18:15
Not sure how deleting topics comes into play here, unless you mean, on your own forum, mods delete topics by mistake too easily?
Is there no easier way of doing this than having to type the URL of the topic you'd like to merge with another?
Sure. The merge page could list all topics that have been posted and you could choose which topic to merge with. How does that sound? That is, if you don't mind waiting for 100, or 1,000, or 10,000 or 50,000 topics to load. Might be on that merge page all day.
You also could have check boxes beside the topics on the forum.asp page and active.asp pages and select two topics and then click the merge topic icon. But then again, adding that code might be a little more difficult for users to add to the files. I kept the amount of code you needed to add, to make it less difficult to install.
But if you have a better idea, let me know.<
MarkJH
16 January 2007, 18:44
Sure. The merge page could list all topics that have been posted and you could choose which topic to merge with. How does that sound?
I know, I know. I can't think of an easier way, either. Just wondering really if anybody has any experience with other forum software to see if they've found a simpler way of doing this.<
Davio
16 January 2007, 19:40
I know, I know. I can't think of an easier way, either. Just wondering really if anybody has any experience with other forum software to see if they've found a simpler way of doing this.
Sure. This whole idea came from using vBulletin. The thing is, they have check boxes beside all their posts and threads, making it much much easier to do mod tasks on multiple threads/posts. But alas, adding check boxes beside our own topics/replies will take a bit of modding, which won't be too easy for the casual snitz admin.
Hence, why the url option is used. With today's browsers using tab's, it makes it easier to find the topic in another tab, while having the merge topic page in another.<
CalloftheHauntedMaster
16 January 2007, 20:05
vBulletin is pretty cool in general. What I like about it most is the searching. It's superb. Actually, HuwR's .net forums have the same search structure.
Oh, and Davio, if you recall, I brought up a mod that would prevent double posting. Looks like I found one in the archives: http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=55795<
Davio
16 January 2007, 21:25
You like the searching? I actually dislike it, more so that you can't search for any word shorter than 4 letters. So I wouldn't be able to search for 'mod' and other 3 letter abbreviations.
Ah well.<
MarkJH
17 January 2007, 13:02
Found a bug.
If you move a topic into a stickied topic, it becomes unsticky.
Would there be a simple fix?<
Davio
17 January 2007, 16:27
Would there be a simple fix?
I dunno, I haven't looked at it yet. Not sure why it would do that though. It doesn't create a topic, nor does it touches the Sticky option in the topic table. It just updates the last post info in the topic table.
Are you sure you set the right topic to be the target topic? Maybe you had moved the sticky topic into the non-sticky topic?<
MarkJH
17 January 2007, 16:48
Nope, I did it the correct way around. Copied the URL of the topic I wanted to move into the sticky topic then merged them via the sticky.
Okay, just did some investigation.
This only happens when you merge a topic into another topic when the topic you are merging is older than the topic you are merging it into... if that makes sense. <
Davio
17 January 2007, 17:25
lol No that did not make sense at all. lol
Ok so you have the sticky topic open, clicked the merge icon and entered the url of the non-sticky topic, and clicked merge, correct?
And which topic was older (not the last post date. the date of the topic.)? The sticky topic or the non-sticky topic?<
Davio
17 January 2007, 17:29
Ok I see. Because the non-sticky topic is older, then it will because the first post in the thread, meaning the sticky topic will be merged with the non-sticky topic.
Alrighty, will see what I can do.<
AnonJr
17 January 2007, 17:32
Glad you understood... <
MarkJH
17 January 2007, 17:37
Cheers, Davio.<
Davio
17 January 2007, 18:13
Originally posted by AnonJr Glad you understood...
LoL! You should try writing this mod. That's all I kept singing in my head. I'm telling you, I wanted to sit in a nice white room wrapped in those white suit they put those crazy people in. Would have been relaxing for me. <
AnonJr
18 January 2007, 08:31
I work at a hospital... I think something can be arranged. But not until this MOD is finished.... <
MarkJH
24 January 2007, 14:05
Anything on this, Davio?<
AnonJr
24 January 2007, 22:11
He's probably "wrapped up" by now... <
HuwR
25 January 2007, 05:32
I was actually thinking of maybe implementing this for the .net version, but to be honest I can't fathom out why you would actually want or need to do this, so if someone could maybe enlighten me as to the thinking behind merging topics I would be most grateful<
ruirib
25 January 2007, 05:44
Well I guess this is just meant to organize a board, joining multiple threads on the same issue. Quite often people post in more than a thread about the same issue, so such a tool can reduce the number of threads on similar issues.
This has been the foremost reason for people requiring such a mod.<
HuwR
25 January 2007, 06:07
ok, I see that, but my understanding of how it works, would indicate that all the replies in such a merge would get jumbled up together as it is still order by reply date, so replies would appear completely out of context, or am I missing something ?<
ruirib
25 January 2007, 06:19
Well I guess the hope is that if the subject is the same, replies will be clear enough. Of course, using this one with the split topic mod can allow you all the flexibility you need to manage any situation.<
HuwR
25 January 2007, 07:11
Ok, I just thought that maybe I had missed something and had got the wrong end of the stick so to speak. anyway, enough digressing, will leave the topic for it's intended purpose <
AnonJr
25 January 2007, 08:52
Originally posted by HuwR ok, I see that, but my understanding of how it works, would indicate that all the replies in such a merge would get jumbled up together as it is still order by reply date, so replies would appear completely out of context, or am I missing something ?
You mean thread conversations never get jumbled up naturally? <
HuwR
25 January 2007, 09:03
Originally posted by HuwR ok, I see that, but my understanding of how it works, would indicate that all the replies in such a merge would get jumbled up together as it is still order by reply date, so replies would appear completely out of context, or am I missing something ?
You mean thread conversations never get jumbled up naturally?
No, I don't mean that, but it would certainly confuse the hell out of me if I came back tomorrow and there were a whole heap of replies stuffed in this topic that weren't there today I'm getting old you know and my brain is easily fuddled these days <
AnonJr
25 January 2007, 09:22
You're only as old as you feel. And you certainly seem as sharp as ever, but I can see where it could get confusing if not done right. I'll bet merging two topics is probably one of those things you'd want to catch early on to reduce any other issues.<
HuwR
25 January 2007, 09:42
Originally posted by AnonJr You're only as old as you feel.
That's ok for you to say, you are still in your twenties I think I can see the benefits of the MOD if it is used sparingly, will have to download the code and take a look.<
MarkJH
25 January 2007, 11:38
Originally posted by AnonJr He's probably "wrapped up" by now...
I had to explain this MOD to my moderators. I don't think I've used the word 'topic' so many times in one sentence! Just wondering... is there a way (maybe SQL) of changing the post date of a topic? The moderator of my promotions forum (also known as 'spam drop'... the forum, not moderator!) is doing some major cleaning up in there, organising topics into stickies such as "Show us your MySpace", "Post here if you are promoting a gig", that kind of thing. Now, if those topics could have the date changed to say 01/01/2000, then there would be no issues with topics being merged in and appearing above the topic starter post.
ps. Is there nothing easy to explain relating to this MOD? <
HuwR
25 January 2007, 11:49
you would have to write a mod to change the topic date, but there is nothing stopping you from doing it, other than having to change all the reply dates as well <
MarkJH
25 January 2007, 12:27
but there is nothing stopping you from doing it
Only my ineptitude!<
HuwR
25 January 2007, 12:43
the problem is that in doing so you may actually reduce the chances of someone finding something I often use the dates to work out how to search for something, and if you just go changing dates topics won't appear in the search results as you would expect them to, if I kenw someone had posted something in the last six months and you had changed the date to 01/01/2000 I'm going to have a difficult time trying to locate it efficiently.<
MarkJH
25 January 2007, 12:52
That's a very good point.
I guess 95% of the time, this MOD is great and serves a real purpose. For what I've got to do... maybe I should install the sub-forums MOD instead.<
pianomagic
08 February 2007, 03:06
Originally posted by Davio Mod Name: Merge Topic Mod Version: Beta 2 Snitz Forums Tested with: 3.4.05 and newer (should be able to work with all 3.4 versions) Database support: All database types supported Author: Davio Last Updated: September 25, 2006......
......Please don't use this on your live forum as yet. If you do, don't come and blame anyone here that your topics got messed up.
Hi Davio,
I am using this on my 'live forum', and I love it! I feel the need to personally THANK YOU for all the work I KNOW you have done. I teach piano online, and the majority of my students know ZILCH when they become members of my site.
Comparing myself with my students, I know far less info about ASP than anybody knows about music...but following the guidelines in the 'READ ME' file of your SPLIT TOPIC MOD, I was able to install MERGE TOPIC MOD with ease! On my FIRST try, the MERGE TOPIC MOD worked GREAT!
THANK YOU!
The only problem I notice occurs when merging topics; I use a PROFILE SIGNATURE with hyperlinks, but the first post merged screws up the part with hyperlinks.
You should also know I use version 3.4.03. I hesitate to upgrade, because it took me a very looooooooooong time to figure out how to install many of the mods my members use and rely upon. I'm not smart enough to upgrade without jeopardizing my previous successes. Even so, YOUR MODS are working beautifully for me (in spite of the 'signature problem' which I can manually correct) and I sincerely appreciate your work!
You are one of my heroes!
THANK YOU!
Mike
www.pianomagic.com<
Davio
08 February 2007, 04:47
Wow. Such praises and adoration.
I'm not worthy! I'll look into that problem you posted.
Mark, I haven't forgotten about you. Been really busy past 2 weeks and gonna be busy still for the next 2. You will just have to work around it in the mean time.<
MarkJH
08 February 2007, 05:50
Mark, I haven't forgotten about you.
It's okay, just a minor quibble in the grand scheme of things. Cheers, Davio. <
modifichicci
10 October 2007, 14:54
Working well.
I have add some modifications:
in merge.asp at line 281
I have adde strForumUrl and Topicid, so you need only to insert the topic number
if not(chkForumAccess(ForumID,Usernum,false)) then strMessage = strMessage & "Has been removed from public display. If you have any questions regarding this, please contact the Administrator of the forum" & vbNewLine else strMessage = strMessage & "Has been moved to a new forum, You can view it at " & vbNewLine & Left(Request.Form("refer"), InstrRev(Request.Form("refer"), "/")) & "topic.asp?TOPIC_ID=" & allRec(TopicID, intOlderTopic) & vbNewLine end if %> <!--#INCLUDE FILE="inc_mail.asp" --> <% end if
and delete the same lines a little below.<
m_r
30 January 2008, 18:19
What is the way to add to my copy What can I file for amendment The adjustment method http://www.snitzbitz.com/mods/details.asp?Version=All&mid=233<
muzishun
01 February 2008, 17:34
m_r, read my and AnonJr's responses in the other thread.<
AnonJr
04 February 2008, 09:07
If you search the files for "Merge Topic Mod" the changes are outlined. Its still in beta, which is probably why a proper "ReadMe" hasn't been made.<
richfed
30 August 2008, 09:54
So, as of the moment, is this MOD considered fairly stable? I could make use of it on my forum, but am hesitant if it's really not ready.<
AnonJr
30 August 2008, 10:58
I've not seen anything that indicates otherwise. It seems a number of people have been using it without any major problems - lack of a readme not withstanding.<
Davio
30 August 2008, 14:39
Originally posted by richfed So, as of the moment, is this MOD considered fairly stable? I could make use of it on my forum, but am hesitant if it's really not ready.
Yeah it's stable enough. Apart from a readme file. <
modifichicci
30 August 2008, 15:40
It works well, with some fixes I have posted. No problems till now in our distribution that include that mod.<
richfed
31 August 2008, 08:42
Okie dokie, then ... I'll give it a try.<
m_r
12 October 2008, 12:56
http://www.snitzbitz.com/mods/details.asp?Version=All&mid=233 There is no Readme how Added<
HuwR
12 October 2008, 13:14
Originally posted by AnonJr If you search the files for "Merge Topic Mod" the changes are outlined. Its still in beta, which is probably why a proper "ReadMe" hasn't been made.
<
pierretopping
13 March 2011, 14:39
Hi All,
Was a readme file for the Merge Topic Mod mod every posted somewhere ?
Looking to give it a go in a test forum.
Thanks,
Pierre
Davio
13 March 2011, 23:40
If you read the previous post before yours, it should answer your question.
If you need help with it, just ask away.