Four MODs - Reviews Requested - Posted (2924 Views)
Advanced Member
Etymon
Posts: 2396
2396

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. smile
<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! cool
<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).
 Sort direction, for dates DESC means newest first  
 Page size 
Posted
Advanced Member
Etymon
Posts: 2396
2396
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.<
Posted
Junior Member
RArch
Posts: 103
103
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? <
Posted
Advanced Member
Etymon
Posts: 2396
2396
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
<
Posted
Senior Member
tribaliztic
Posts: 1532
1532
Has anyone tested the un-archive mod with mysql? =)

<
/Tribaliztic
- www.gotlandrace.se -
Posted
Advanced Member
Etymon
Posts: 2396
2396
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. smile<
Posted
Senior Member
tribaliztic
Posts: 1532
1532
Cool, thanks alot =)
<
/Tribaliztic
- www.gotlandrace.se -
Posted
Advanced Member
Etymon
Posts: 2396
2396
Originally posted by tribaliztic
Cool, thanks alot =)


You're welcome. smile
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.
<
Posted
Advanced Member
Etymon
Posts: 2396
2396
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. tongue I'll see how the change might effect the nature of the existing code.
More on this later.
Etymon
<
Posted
Advanced Member
Etymon
Posts: 2396
2396
Topic paging added for all three options. smile
I still have to clean up the code before I can release it as a MOD.
Etymon
<
Posted
Senior Member
tribaliztic
Posts: 1532
1532
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 -
You Must enter a message