| Author |
 Topic  |
|
Etymon
Advanced Member
United States
2385 Posts |
 Posted - 04 December 2006 : 07:39:27
|
I've created a few MODs and bundled them together. I will be separating each into separate MODs later if anyone is interested. Presently, I am using a the first two to show you how the second two work. This means all four MODs are all intertwined at the moment for demonstration purposes.
The <font color="red">first MOD</font id="red"> is called the <font color="red"><b>strRevealSQL MOD</b></font id="red">.
The <font color="blue">second MOD</font id="blue"> is called the <font color="blue"><b>RevealSQL MOD</b></font id="blue">.
In the links below, you will not be able to distinquish the two apart. In short, <font color="red"><b>strRevealSQL</b></font id="red"> is designed to work across the site [created for offline production testing], and <font color="blue"><b>RevealSQL</b></font id="blue"> is designed to work on a page by page basis [created for online emergency testing and offline production testing].
You will see the <font color="red">first</font id="red"> and the <font color="blue">second</font id="blue"> MODs at work when you test the <font color="orange">third</font id="orange"> and <font color="green">fourth</font id="green"> MODs below.
The <font color="orange">third MOD</font id="orange"> is called <font color="orange"><b>Archive One Topic MOD</b></font id="orange">. It's a fun little MOD. It is basically a rip off of admin_forums.asp with a bit of alterations applied.
The <font color="green">fourth MOD</font id="green"> is called <font color="green"><b>Un-Archive One Topic MOD</b></font id="green">. It's a VERY fun little MOD. It also is basically a rip off of admin_forums.asp with a bit more alterations applied.
For application purposes, both the <font color="orange">third</font id="orange"> and <font color="green">fourth</font id="green"> MODs should be considered as one application and will be released later as the "<b><font color="purple">Archive/Un-Archive One Topic MOD</font id="purple"></b>".
The beauty of the <b><font color="green">Un-Archive One Topic MOD</font id="green"></b> is that when it un-archives a topic, both the new topic id and the new un-archived topic id are stored in a new table. It is designed this way for bookmarking purposes.
When a visitor (human or bot) to your site has bookmarked a current topic id, and then, later, after the topic id has been archived and then un-archived, the new table redirects the user to the new topic id via the new table.
In the same sense, when a visitor (human or bot) to your site has bookmarked an <i><u>archived</u></i> topic ID, and then, later, after the topic id has been un-archived, the new table still redirects the user to the new topic id via the new table.
Subscriptions should function normally.
Posting replies to the new topic id goes on as normal.
One of the fun things is that the same topic can be archived and un-archived again and again (if needed), and the redirect will follow the archivial path until it reaches the current new topic id. If the topic id no longer exists, then the user will be redirected to default.asp. 
<b>Side Note</b>: There is a further modification that you will see on admin_topics.asp where you can delete one topic as well if needed. It is there for convenience sake.
<b>Additional Note</b>: Paging has not been added as of yet. For larger forums this will have to be implemented.
<b>PLEASE DO NOT DELETE</b> the "<font color="red"><b><u>Welcome to Snitz Forums 2000</u></b></font id="red">" topic because I am using it here for reference so everyone can see how the MOD works. Thanks! 
<b>However, feel free to post your one topics/replies and have fun testing the MODs.</b>
<b>Test Link</b>: http://carolina.kiwi73.kiwihosting.net/forum/topic.asp?TOPIC_ID=1
(Follow the link above and look at it as it appears in the Address bar of your browser. You should see it change from TOPIC_ID=1 to the newest topic id.)
<b>Admin Link</b>: http://carolina.kiwi73.kiwihosting.net/forum/admin_topics.asp
<b>Username</b>: admin
<b>Password</b>: admin
<b>MOD list</b>:
<font color="red"><b>strRevealSQL MOD</b></font id="red">
<font color="blue"><b>RevealSQL MOD</b></font id="blue">
<font color="orange"><b>Archive One Topic MOD</b></font id="orange">
<font color="green"><b>Un-Archive One Topic MOD</b></font id="green">
<b>Testing Applications</b>: These MODs were developed using <b>MS Access 2000</b> and <b>Internet Explorer 6</b> (SP1).
|
Edited by - Etymon on 14 December 2008 03:08:44 |
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 04 December 2006 : 08:11:42
|
I noticed that I still need to add some more code for the F_LAST_POST_TOPIC_ID field in the FORUM table because the current topic id does not show correctly on default.asp for the jump icon and in the stats.
Fix Applied.< |
Edited by - Etymon on 04 December 2006 08:46:08 |
 |
|
|
RArch
Junior Member
United Kingdom
103 Posts |
Posted - 04 December 2006 : 08:21:39
|
Seems to work great, well done.
Why after picking the topic in Step #1 for archiving is the topic name in a drop down at Step #2: Submit the Topic to be Archived ?
I'm not familiar with the archiving process but why is necessary to renumber the topics and replies when they are restored?
< |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 04 December 2006 : 09:16:28
|
quote:
Originally posted by RArch
Seems to work great, well done.
Thanks! 
quote:
Why after picking the topic in Step #1 for archiving is the topic name in a drop down at Step #2: Submit the Topic to be Archived?
I was working off of admin_forums.asp and just followed the code format. As I was developing the MODs, my future plans were to make it so that the user could choose a forum from a link list instead of a topic from a topic list in Step #1 (as it is now), and then from the choice selected in the topic list, the next page would display a drop down of a list of topics rather than just one topic in Step #2 (as it is now), and then Step #3 would be as it is now.
When testing the code (as it is now), Step #2 has been quite a bother for me since the fewer things to click the better. Though admin_topics.asp was a rip from admin_forums.asp it was quite a challenge to juggle all of the factors around. That is partly why I created the first two MODs strRevealSQL and RevealSQL ... to help me keep my mind sane. I'll look into changing the Step process as mentioned above since paging is already needed.
quote:
I'm not familiar with the archiving process but why is necessary to renumber the topics and replies when they are restored?
UPDATE - Dec.20.2006:
It was brought to my attention that there was a way of preserving the original topic id.
When I first starting coding this MOD, I overlooked something because I tried it the way suggested and an error was produced. That is why I did it the other way.
The MOD has been updated, and the download for version 1.0b and later versions will reinstate the original topic id, while the download for version 1.0a will issue a new topic id.
I used MS Access 2000 to develop the Archive/Un-Archive One Topic MOD. For the FORUM_TOPICS table and the FORUM_REPLY table ... they both AutoNumber the TOPIC_ID and the REPLY_ID values. Even with the standard admin_forums.asp, whether you archive a TOPIC_ID with REPLY_ID(s) or just a TOPIC_ID by itself, the old TOPIC_ID and the old REPLY_ID for each reply is deleted forever, and their values are not allowed by the database to be used again.
To compensate for this, I created a new table FORUM_UA_TOPICS with two fields in it ... UA_TOPIC_ID and TOPIC_ID.
When a TOPIC_ID is used in a querystring in topic.asp (such as http://carolina.kiwi73.kiwihosting.net/forum/topic.asp?TOPIC_ID=1) the TOPIC_ID is passed through a query in topic.asp to find if it is current, archived, or un-archived. If it is un-archived, then its UA_TOPIC_ID is matched with its old TOPIC_ID, and then the browser is redirected using the new TOPIC_ID.
For all un-archived topics, the UA_TOPIC_ID is the same as its new TOPIC_ID since its old TOPIC_ID no longer exists in the FORUM_TOPICS table or any table other than the FORUM_UA_TOPICS table.
UPDATE - Dec.21.2006:
See this reply for more information: Reply #354022
< |
Edited by - Etymon on 21 December 2006 15:17:47 |
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 11 December 2006 : 05:38:03
|
Has anyone tested the un-archive mod with mysql? =)
< |
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 11 December 2006 : 08:44:16
|
| I've run into a hickup here at home. I should be able to release the MODs soon (I hope), then we can find out about MySQL. < |
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 12 December 2006 : 02:26:33
|
Cool, thanks alot =)
< |
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 12 December 2006 : 03:28:13
|
quote:
Originally posted by tribaliztic
Cool, thanks alot =)
You're welcome.
Ok, I had some free time last night, so I updated the Step process. I changed the list of all topics available to a list of all forums available in Step #1 and then in Step #2 you can make a choice from a drop-down list of topics within the forum that was chosen in Step #1.
I also updated the Delete One Archived Topic.
I still need to add paging for the topics in Step #2. This will help those with larger forums.
< |
Edited by - Etymon on 12 December 2006 03:29:08 |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 12 December 2006 : 22:51:10
|
I may have to move to a link list rather than a drop down for the paging aspect as it is a bit of trick to page a drop down menu.  I'll see how the change might effect the nature of the existing code.
More on this later.
Etymon
< |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 13 December 2006 : 05:19:14
|
Topic paging added for all three options.
I still have to clean up the code before I can release it as a MOD.
Etymon
< |
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 13 December 2006 : 06:02:35
|
it's nice to see you're making progress on this one =)
One question, I'm only looking for the unarchive stuff, is this really four mods or do I have to install all of them as one?
< |
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 13 December 2006 : 10:24:47
|
quote:
Originally posted by tribaliztic
it's nice to see you're making progress on this one =)
One question, I'm only looking for the unarchive stuff, is this really four mods or do I have to install all of them as one?
The archive, un-archive, and delete archive "stuff" is all one MOD. The other two MODs are for trouble-shooting/learning purposes. It does seem confusing. I'll separate them later as independent MODs.
Etymon
< |
|
|
|
skellyx
Starting Member
24 Posts |
Posted - 14 December 2006 : 16:18:46
|
hi,
sorry where I can download these mods ?
Thank< |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 14 December 2006 : 23:17:34
|
Hi Skelly,
I haven't released them as of yet. I'll try to get them out before the first of next week. It's 2 1/2 hours before Friday starts from where I am sitting right now.
Etymon
< |
|
|
|
skellyx
Starting Member
24 Posts |
Posted - 15 December 2006 : 05:28:31
|
Thank Etymon you make us a beautiful gift of native 
excuse for the English I hope it is understood 
hi< |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 18 December 2006 : 09:31:02
|
The Archive One Topic MOD is available at this topic.
I had to rename the MOD from Archive/Un-Archive One Topic MOD to Archive One Topic MOD due to the / in the title.
Enjoy!
Etymon
< |
|
|
|
Topic |
|
Four MODs - Reviews Requested
