Author |
Topic |
cripto9t
Average Member
USA
881 Posts |
Posted - 13 October 2004 : 13:47:46
|
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 |
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 14 October 2004 : 02:45:25
|
Thank you for the MOD, cripto9t!
Looks like a great idea!
|
|
|
Jorrit787
Average Member
Netherlands
681 Posts |
Posted - 09 December 2004 : 14:35:19
|
This would make an extremely useful MOD - Please keep working on it |
eXtremeGossip |
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 10 December 2004 : 08:23:44
|
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\-_ |
|
|
ken derringer
Starting Member
40 Posts |
Posted - 10 December 2004 : 09:21:22
|
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 |
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 10 December 2004 : 17:07:23
|
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\-_ |
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 11 December 2004 : 07:55:27
|
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\-_ |
|
|
ken derringer
Starting Member
40 Posts |
Posted - 13 December 2004 : 05:55:14
|
Ok. Now it works! I wait for the fix about counter. Thanks. |
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 19 December 2004 : 11:01:48
|
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\-_ |
|
|
ken derringer
Starting Member
40 Posts |
Posted - 20 December 2004 : 04:44:15
|
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
|
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 20 December 2004 : 11:17:02
|
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\-_ |
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 22 December 2004 : 10:39:21
|
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\-_ |
|
|
bitwise2000
Starting Member
38 Posts |
Posted - 22 December 2004 : 12:34:48
|
Anyone done this on 3.4.03 ? I see a couple issues... |
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 22 December 2004 : 15:03:23
|
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\-_ |
|
|
bitwise2000
Starting Member
38 Posts |
Posted - 22 December 2004 : 15:53:40
|
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? |
|
|
Topic |
|