Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 Four MODs - Reviews Requested
 New Topic  Reply to Topic
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

Etymon
Advanced Member

United States
2385 Posts

Posted - 04 December 2006 :  07:39:27  Show Profile  Visit Etymon's Homepage  Reply with Quote

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  Show Profile  Visit Etymon's Homepage  Reply with Quote
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
Go to Top of Page

RArch
Junior Member

United Kingdom
103 Posts

Posted - 04 December 2006 :  08:21:39  Show Profile  Reply with Quote
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?
<
Go to Top of Page

Etymon
Advanced Member

United States
2385 Posts

Posted - 04 December 2006 :  09:16:28  Show Profile  Visit Etymon's Homepage  Reply with Quote
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
Go to Top of Page

tribaliztic
Senior Member

Sweden
1532 Posts

Posted - 11 December 2006 :  05:38:03  Show Profile  Visit tribaliztic's Homepage  Send tribaliztic an ICQ Message  Reply with Quote
Has anyone tested the un-archive mod with mysql? =)

<

/Tribaliztic
- www.gotlandrace.se -
Go to Top of Page

Etymon
Advanced Member

United States
2385 Posts

Posted - 11 December 2006 :  08:44:16  Show Profile  Visit Etymon's Homepage  Reply with Quote
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. <
Go to Top of Page

tribaliztic
Senior Member

Sweden
1532 Posts

Posted - 12 December 2006 :  02:26:33  Show Profile  Visit tribaliztic's Homepage  Send tribaliztic an ICQ Message  Reply with Quote
Cool, thanks alot =)
<

/Tribaliztic
- www.gotlandrace.se -
Go to Top of Page

Etymon
Advanced Member

United States
2385 Posts

Posted - 12 December 2006 :  03:28:13  Show Profile  Visit Etymon's Homepage  Reply with Quote
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
Go to Top of Page

Etymon
Advanced Member

United States
2385 Posts

Posted - 12 December 2006 :  22:51:10  Show Profile  Visit Etymon's Homepage  Reply with Quote
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
<
Go to Top of Page

Etymon
Advanced Member

United States
2385 Posts

Posted - 13 December 2006 :  05:19:14  Show Profile  Visit Etymon's Homepage  Reply with Quote
Topic paging added for all three options.

I still have to clean up the code before I can release it as a MOD.

Etymon
<
Go to Top of Page

tribaliztic
Senior Member

Sweden
1532 Posts

Posted - 13 December 2006 :  06:02:35  Show Profile  Visit tribaliztic's Homepage  Send tribaliztic an ICQ Message  Reply with Quote
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 -
Go to Top of Page

Etymon
Advanced Member

United States
2385 Posts

Posted - 13 December 2006 :  10:24:47  Show Profile  Visit Etymon's Homepage  Reply with Quote
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
<
Go to Top of Page

skellyx
Starting Member

24 Posts

Posted - 14 December 2006 :  16:18:46  Show Profile  Reply with Quote
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!
Go to Top of Page

Etymon
Advanced Member

United States
2385 Posts

Posted - 14 December 2006 :  23:17:34  Show Profile  Visit Etymon's Homepage  Reply with Quote
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
<
Go to Top of Page

skellyx
Starting Member

24 Posts

Posted - 15 December 2006 :  05:28:31  Show Profile  Reply with Quote
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!
Go to Top of Page

Etymon
Advanced Member

United States
2385 Posts

Posted - 18 December 2006 :  09:31:02  Show Profile  Visit Etymon's Homepage  Reply with Quote
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
<
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.17 seconds. Powered By: Snitz Forums 2000 Version 3.4.07