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
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 4

cripto9t
Average Member

USA
881 Posts

Posted - 22 December 2004 :  18:46:11  Show Profile
quote:
Originally posted by bitwise2000

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?


A readme bug . The Default.asp changes should be made in Topic.asp. I'll fix the pronto

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

ken derringer
Starting Member

40 Posts

Posted - 23 December 2004 :  04:17:04  Show Profile
Nothing to do.
I have updated the pop_flag.asp.
I try to modified my admin_forums.asp but i have always the same error:

All replies to Topics older than 11/23/2004 10:07:47 AM were archived


Microsoft JET Database Engine error '80040e14'

Syntax error in INSERT INTO statement.

/forumgdr/admin_forums.asp, line 646


Edited by - ken derringer on 23 December 2004 09:44:06
Go to Top of Page

cripto9t
Average Member

USA
881 Posts

Posted - 23 December 2004 :  08:02:11  Show Profile
Ken I made a copy of your admin_forums, could you edit your last post and remove it so we don't have to scroll down as much .
It's always better to post a link to files or just a few lines above the error.

I'll take a guess and say it's the poll mod.
quote:
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 "unarchive" portion of "pop_flag.asp".


It needs to be added to pop.flag.asp.

Remove the comments ' from the code in red.
Then archive the forum and post the results.


		       		strsql = "INSERT INTO " & strArchiveTablePrefix & "TOPICS (CAT_ID, FORUM_ID, TOPIC_ID, T_STATUS, T_SUBJECT, T_MESSAGE, T_AUTHOR, T_REPLIES, T_UREPLIES, T_VIEW_COUNT, T_LAST_POST, T_DATE, T_LAST_POSTER, T_IP, T_LAST_POST_AUTHOR, T_LAST_POST_REPLY_ID, T_LAST_EDIT, T_LAST_EDITBY, T_STICKY, T_SIG)"
				strsql = strsql & " VALUES (" & strsqlvalues & ")"
				'Response.Write strSql
				'Response.End

Needs to look like
		       		strsql = "INSERT INTO " & strArchiveTablePrefix & "TOPICS (CAT_ID, FORUM_ID, TOPIC_ID, T_STATUS, T_SUBJECT, T_MESSAGE, T_AUTHOR, T_REPLIES, T_UREPLIES, T_VIEW_COUNT, T_LAST_POST, T_DATE, T_LAST_POSTER, T_IP, T_LAST_POST_AUTHOR, T_LAST_POST_REPLY_ID, T_LAST_EDIT, T_LAST_EDITBY, T_STICKY, T_SIG)"
				strsql = strsql & " VALUES (" & strsqlvalues & ")"
				Response.Write strSql
				Response.End

Also don't unarchive any more posts until polls have been added to your pop_flag.asp.

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

ken derringer
Starting Member

40 Posts

Posted - 23 December 2004 :  09:56:11  Show Profile
THis is the result of the admin_forum.asp:

All replies to Topics older than 11/23/2004 3:48:15 PM were archived

.

Topic exists, Stats Updated......
.

Topic exists, Stats Updated......
.

Topic exists, Stats Updated......
.

Topic exists, Stats Updated......
INSERT INTO FORUM_A_TOPICS (CAT_ID, FORUM_ID, TOPIC_ID, T_STATUS, T_SUBJECT, T_MESSAGE, T_AUTHOR, T_REPLIES, T_UREPLIES, T_VIEW_COUNT, T_LAST_POST, T_DATE, T_LAST_POSTER, T_IP, T_LAST_POST_AUTHOR, T_LAST_POST_REPLY_ID, T_LAST_EDIT, T_LAST_EDITBY, T_STICKY, T_ISPOLL, T_POLLSTATUS, T_SIG) VALUES (1, 1, 1740, 0, 'Manowar vs Blind Guardian', 'Caro Zac, come ti permetti di definire i mitici MANOWAR "merda" , occupano il monolocale del mio cuore insieme ai grandissimi bardi di Krefeld ed ai bambini terribili di Bodom. Hai provato ad ascoltare canzoni immortali come "Heart of Steel" piuttosto che "Battle Hymns" o ancora "Blood of the Kings", "Sign of the Hammer", la lista potrebbe essere ancora lunga. Ignoranti! Arroganti!, ascoltati "Kings of Metal" e poi "Warriors of the world" e poi parla! Sono gli unici che reggono il confronto con i quattro del guardiano cieco! "We don''t turn down for anyone we do what the **** we please!" P.s. Sarebbe un''accopiata vincente! Nick', 557, 74, 0, 1088, '20040919193144', '20040712143756', 0, '82.48.120.109', 369, 56120, '', NULL, 0, , 0, 0 )
Go to Top of Page

cripto9t
Average Member

USA
881 Posts

Posted - 23 December 2004 :  12:04:50  Show Profile
One of the poll fields is empty.

I Added Davios' poll to pop_flag.asp. I'll post it in a seperate post.
You will need to make those changes and you still need to make the changes to admin_forums.asp, if you haven't already.

I'll see if I can write something temporary to fix that post.

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

cripto9t
Average Member

USA
881 Posts

Posted - 23 December 2004 :  12:05:57  Show Profile
Adding Davios' Poll Mod

All these changes are in pop.asp


  • Find this code (line 43)
    strSql = strSql & " T_LAST_EDIT, T_LAST_EDITBY, T_STICKY, T_SIG, T_MESSAGE"

    ADD ",T_ISPOLL " so it looks like this
    strSql = strSql & " T_LAST_EDIT, T_LAST_EDITBY, T_STICKY, T_ISPOLL, T_SIG, T_MESSAGE"


  • Find this code (line 70)
    tLastedit = rsChk("T_LAST_EDIT")
                    tLasteditby = rsChk("T_LAST_EDITBY")
                    tSticky = rsChk("T_STICKY")

    ADD this line under that
    tIspoll = rsChk("T_ISPOLL")

  • Find this code (line 142)
    strTValues = strTValues & ", " & 0
                                    strTValues = strTValues & ", " & tLastedit
                                    strTValues = strTValues & ", " & tLasteditby
                                    strTValues = strTValues & ", " & tSticky

    ADD this code under that
    strTValues = strTValues & ", " & tIspoll
                                    strTValues = strTValues & ", " & 0

  • Find this code line (166)
    strSql = strSql & ", T_ARCHIVE_FLAG"
                                    strSql = strSql & ", T_LAST_EDIT"
                                    strSql = strSql & ", T_LAST_EDITBY"
                                    strSql = strSql & ", T_STICKY"

    ADD this code under that
    strSql = strSql & ", T_ISPOLL"
                                    strSql = strSql & ", T_POLLSTATUS"



That's it

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

cripto9t
Average Member

USA
881 Posts

Posted - 23 December 2004 :  12:38:58  Show Profile
Ken the easiest way to archive that forum would be to delete the topics you unarchived.
If you want to save the posts you can try the following:
Are any of the topics you unarchived polls?
If not you can add this bit of code, I think you will be able to archive that forum.

Find this in admin_forums.asp
strSQL = "SELECT TOPIC_ID FROM " & strArchiveTablePrefix & "TOPICS WHERE TOPIC_ID=" & drs("TOPIC_ID")
			set rsTcheck = my_conn.execute(strSQL)

			if isnull(drs("T_LAST_EDITBY")) then
				intT_LAST_EDITBY = "NULL"
			else
				intT_LAST_EDITBY = drs("T_LAST_EDITBY")
			end if
			if isnull(drs("T_LAST_POST_REPLY_ID")) then
				intT_LAST_POST_REPLY_ID = "NULL"
			else
				intT_LAST_POST_REPLY_ID = drs("T_LAST_POST_REPLY_ID")
			end if
			if isnull(drs("T_UREPLIES")) then
				intT_UREPLIES = "NULL"
				intT_UREPLIEScnt = 0
			else
				intT_UREPLIES = drs("T_UREPLIES")
				intT_UREPLIEScnt = drs("T_UREPLIES")
			end if

ADD this code under that
'## temporary code to fill empty field in topics table
                        if trim(drs("T_ISPOLL")) = "" then
                                drs("T_ISPOLL") = 0
                        end if

Then add the comments back to
'Response.Write strSql
'Response.End

Then archive the forum again.

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

bitwise2000
Starting Member

38 Posts

Posted - 27 December 2004 :  16:08:28  Show Profile
Cripto9t; this a very nice, useful mod. However, the instructions in the readme don't nearly match the code changes specified in the sample files you provide. The latter are correct, making the changes as described in the readme will result in trouble. Otherwise, good work!
Go to Top of Page

cripto9t
Average Member

USA
881 Posts

Posted - 27 December 2004 :  17:48:44  Show Profile
quote:
Originally posted by bitwise2000

making the changes as described in the readme will result in trouble. Otherwise, good work!


Thanks bitwise, I appreciate your input. I usually do a fresh install useing only the readme, so I can find the mistakes.
However I don't recall doing that with this mod .
I'll install it useing only the readme and try to work out the mistakes.

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

ken derringer
Starting Member

40 Posts

Posted - 10 January 2005 :  04:48:13  Show Profile
Ok, Now it works.
Thanks! If I have other problem, i write you!
Go to Top of Page

ken derringer
Starting Member

40 Posts

Posted - 10 January 2005 :  05:18:31  Show Profile
Ok. I have found a problem!
Don't hate me...
I see that I don't have the flag/unflagh icons, if the topic is "stickly".
The topic is archived, and I can't unarchive that. I can unarchive that only if I unstickly the topic...
Go to Top of Page

cripto9t
Average Member

USA
881 Posts

Posted - 10 January 2005 :  11:36:49  Show Profile
Ken that's the way it should work.

The icons shouldn't show if a topic is "sticky". Sticky topics are flagged from archiving.

As for the unarchiving, I didn't realise you could make a topic sticky in the archives until I read your post .
I think it should stay as is.
A topic must be "unstuck" before it can be unarchived just as it has to be "unstuck" for archiving.

I hope this all makes sense .

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

ppehrson
Starting Member

14 Posts

Posted - 10 January 2005 :  16:40:15  Show Profile
Maybe I'm just a *** but it is Topic.asp you need to edit. NOT default.asp as stated in the readme.

-peter
Go to Top of Page

cripto9t
Average Member

USA
881 Posts

Posted - 13 January 2005 :  09:57:23  Show Profile
Download updated. I made a few changes in pop_flag.asp concerning count updates. The old file worked fine but this one looks neater.

I also added a new HTML readme. It's easier to read. I used it to do a clean install, so the readme mistakes should be corrected.

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

skwayb
Starting Member

17 Posts

Posted - 01 February 2005 :  16:58:34  Show Profile
Got the mod installed and through testing I am running into this error on MSSQL when I try to unarchive a message.
quote:
Microsoft OLE DB Provider for SQL Server error '80040e14'

Cannot insert explicit value for identity column in table 'FORUM_TOPICS' when IDENTITY_INSERT is set to OFF.

/forum/pop_flag.asp, line 173

Looks like I need to add
quote:
SET IDENTITY_INSERT FORUM_TOPICS ON

Before the insert statement and then turn IDENTITY_INSERT off after it is done so the same thing can be done for the FORUM_REPLY table before the insert.

Any ideas? Or does that look like the only option since both the Reply_ID and Topic_ID are identities.



Edited by - skwayb on 01 February 2005 17:02:12
Go to Top of Page
Page: of 4 Previous Topic Topic Next Topic  
Previous Page | 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.16 seconds. Powered By: Snitz Forums 2000 Version 3.4.07