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)
 Archive Flag - Archive/UnArchive Topic 3.4 beta
 New Topic  Topic Locked
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 4

cripto9t
Average Member

USA
881 Posts

Posted - 13 October 2004 :  13:47:46  Show Profile
Author: cripto9t

Tested on Snitz 3.4.04 with MySql

12/11/04 Download Update: Made changes in all files to work with Access db (still needs testing).
12/19/04 Download Update: Post counts repaired in pop_flag.asp. Replace pop_flag with the updated version.
12/22/04 Download Update: Made changes in pop_flag.asp and added admin_forums.asp to the modified files. Readme updated.
01/13/05 Download Update: Did some tweaking in pop_flag.asp and Added a new html readme.
02/02/05 Download Update: 3.4.02 beta - Replace pop_flag.asp with new version. Unarchived topic and replies get new IDs instead of using old ones so there's no possibility (that I know of )of duplicate IDs.
03/09/05 Download Update: Added Topic Archiving. Readme updated with changes made in "forum.asp" and "topic.asp" that add an icon for archiving. I completely redid pop_flag.asp, so it will need replaced. Again this only works in mySql. I added some code for msSql but I am unable to test it.


Download:Right click and save
Mod allows admins and moderators to flag topics from being archived.
i.e. When a forum is archived, flagged topic will remain active.
Also allows you to archive/unarchive individual topics.
If you have added fields to the (TOPICS and A_TOPICS) or (REPLY and A_REPLY) database tables, you will need to add them to the forum Sqls' in the "archive/unarchive" portion of "pop_flag.asp".

This mod is beta and needs testing. If you do test and find a bug or a bug fix, let me know here so I can update the download.

Needs testing with Access and Sql databases.

    _-/Cripto9t\-_

Edited by - cripto9t on 09 March 2005 09:37:13

cripto9t
Average Member

USA
881 Posts

Posted - 13 October 2004 :  13:55:05  Show Profile
I found this today in this forums archives http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=41670&SearchTerms=replies.
I thought I had did the unarchiving for nothing.
But from what I can see this goes alot more indepth and doesn't unarchive individual topics. So maybe I did a good thing .

    _-/Cripto9t\-_
Go to Top of Page

Etymon
Advanced Member

United States
2385 Posts

Posted - 14 October 2004 :  02:45:25  Show Profile  Visit Etymon's Homepage
Thank you for the MOD, cripto9t!

Looks like a great idea!

Go to Top of Page

Jorrit787
Average Member

Netherlands
681 Posts

Posted - 09 December 2004 :  14:35:19  Show Profile  Visit Jorrit787's Homepage  Send Jorrit787 an AOL message  Send Jorrit787 a Yahoo! Message
This would make an extremely useful MOD - Please keep working on it

eXtremeGossip
Go to Top of Page

cripto9t
Average Member

USA
881 Posts

Posted - 10 December 2004 :  08:23:44  Show Profile
Download updated to work with Access db.

I had to redo the mod code in forum.asp and topic.asp. Also made a slight change in pop_flag.asp.

Jorrit787, I'd like to work on it till it's bug free , but I need feedback from from the folks that try it out. As you can see it's been up for two months and I just found out it didn't work with Acccess .

    _-/Cripto9t\-_
Go to Top of Page

ken derringer
Starting Member

40 Posts

Posted - 10 December 2004 :  09:21:22  Show Profile
I have do some test.
The flagged topic are not archived correcty but I can't restore topic. I always receive the error:

Microsoft JET Database Engine error '80040e07'

Data type mismatch in criteria expression.

/forumgdr/pop_flag.asp, line 173

Edited by - ken derringer on 10 December 2004 09:21:54
Go to Top of Page

cripto9t
Average Member

USA
881 Posts

Posted - 10 December 2004 :  17:07:23  Show Profile
quote:
Originally posted by ken derringer

I always receive the error:

Microsoft JET Database Engine error '80040e07'

Data type mismatch in criteria expression.

/forumgdr/pop_flag.asp, line 173



Sorry about that Ken. It worked for me yesterday but not today .
That's the same error I'm getting.

My Access site went down and I can't test at this time.
I think if you replace this line in pop_flag.asp it might fix that error. But there may be others. It's just a little before line 173.
strTValues = strTValues & ", '" & tLasteditby & "'"

with this
strTValues = strTValues & ", " & tLasteditby


    _-/Cripto9t\-_
Go to Top of Page

cripto9t
Average Member

USA
881 Posts

Posted - 11 December 2004 :  07:55:27  Show Profile
It works for me with the change I mentioned above.
The download has been updated.

I see another bug. The replies aren't being counted right. I'll work on this.

    _-/Cripto9t\-_
Go to Top of Page

ken derringer
Starting Member

40 Posts

Posted - 13 December 2004 :  05:55:14  Show Profile
Ok. Now it works!
I wait for the fix about counter.
Thanks.
Go to Top of Page

cripto9t
Average Member

USA
881 Posts

Posted - 19 December 2004 :  11:01:48  Show Profile
Sorry about the wait.
I just updated the download with some post count fixes in pop_flag.asp.
Just replace pop_flag with the new update.

    _-/Cripto9t\-_
Go to Top of Page

ken derringer
Starting Member

40 Posts

Posted - 20 December 2004 :  04:44:15  Show Profile
Hi. I have changed my pop_flag.asp.
All working fine.
But..
I have try to unarchive a topic with a moderator user. He can't unarchive topic.
No message error here, but the password is not recognized. I'm sure that the password is ok. The moderator user can't unarchive.

Other problem:
When I unarchive a topic all work fine. But if I try to archive again the forum with this topic, I receive this error message:

Microsoft JET Database Engine error '80040e14'

Syntax error in INSERT INTO statement.

/newforum/admin_forums.asp, line 646
Go to Top of Page

cripto9t
Average Member

USA
881 Posts

Posted - 20 December 2004 :  11:17:02  Show Profile
This should fix the moderator thing.

In pop.asp find this code
if (chkForumModerator(Forum_ID, strDBNTFUserName) = "1") or mLev > 0 then  '## is Member
                        if (mLev = 4) then

Replace it with this
if mLev > 0 then  '## is Member
                        if (mLev = 4) or (chkForumModerator(Forum_ID, strDBNTFUserName) = "1") then

Will allow moderators to unarchive topics in thier forums.

I have one forum where everything works fine I unarchive and then return a topic to the archives.
In another forum I am recieving an error messege, but it's different from yours.
It's not deleting the replies from the reply table. Therefore I have the same replies in the reply table and the a_reply table.
I think it has something to do with NULL values in the "last_edit_by" and "last_edit" fields.
I'll have to work on this.

    _-/Cripto9t\-_
Go to Top of Page

cripto9t
Average Member

USA
881 Posts

Posted - 22 December 2004 :  10:39:21  Show Profile
Download has been updated 12/22/04.

Fixed an archiving/unarchiving bug.
This bug may cause duplicate posts in the REPLY and A_REPLY table which will give an error msg when you try to archive the duplicate reply. You will need to delete the duplicate replies in the REPLY table if you recieve this message.

Anyone testing this mod needs to replace pop.asp with updated version and I have made some code changes in admin_forums.asp (previously unmodified). Readme also updated.

    _-/Cripto9t\-_
Go to Top of Page

bitwise2000
Starting Member

38 Posts

Posted - 22 December 2004 :  12:34:48  Show Profile
Anyone done this on 3.4.03 ? I see a couple issues...
Go to Top of Page

cripto9t
Average Member

USA
881 Posts

Posted - 22 December 2004 :  15:03:23  Show Profile
quote:
Originally posted by bitwise2000

Anyone done this on 3.4.03 ? I see a couple issues...


This mod is still beta and needs more testing. Don't use it on a live forum.
I think it's safe to say that the flag/unflag portion is ok and should work on all versions of Snitz 3.4.
The unarchive portion seems to be working fine after the last bug fix, but more bugs may pop up with more testing.

    _-/Cripto9t\-_
Go to Top of Page

bitwise2000
Starting Member

38 Posts

Posted - 22 December 2004 :  15:53:40  Show Profile
Thanks... in the readme, the changes specified for default.asp puzzle me. I don't find that code in 3.4.03. Is that sub AdminOptions() specific to 3.4.05?
Go to Top of Page
Page: of 4 Previous Topic Topic Next Topic  
Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.13 seconds. Powered By: Snitz Forums 2000 Version 3.4.07