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/O Code)
 Jump to Last Post Permalink
 New Topic  Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 5

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 27 September 2005 :  09:32:00  Show Profile  Send ruirib a Yahoo! Message  Reply with Quote
Ok, previous problem gone, but it still does not jump to the last page. Redirects to default.asp. Will try to figure out why later.<


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 27 September 2005 :  09:43:09  Show Profile  Reply with Quote
*Scratches head* Obviously there's a typo I'm missing somewhere. A response.write on the redirect URI may reveal the problem.

<

Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 27 September 2005 :  11:35:03  Show Profile  Send ruirib a Yahoo! Message  Reply with Quote
quote:
Originally posted by Shaggy

*Scratches head* Obviously there's a typo I'm missing somewhere. A response.write on the redirect URI may reveal the problem.




I did it. Seemed ok to me. Will have to do it step by step, to find out where the redirect is ocurring.<


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 27 September 2005 :  11:36:30  Show Profile  Reply with Quote
Appreciate it, Rui Sorry to be bugging you with all these tests, really gotta get around to setting up a clean test forum meself

<

Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 27 September 2005 :  11:47:32  Show Profile  Send ruirib a Yahoo! Message  Reply with Quote
No problem. Give this a bump if I forget it.<


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 29 September 2005 :  06:46:07  Show Profile  Reply with Quote
Quick thought, Rui, are there any &amp;s in the URI when you response.write it?

<

Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 29 September 2005 :  06:52:52  Show Profile  Send ruirib a Yahoo! Message  Reply with Quote
No Shaggy, didn't find any. Hope to have a go at this tonight.<


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 29 September 2005 :  07:02:57  Show Profile  Reply with Quote
Feck! Was hoping that'd be it!

<

Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 02 January 2006 :  06:25:27  Show Profile  Reply with Quote
A quick bump for tomorrow so's I don't forget this.

<

Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”

Edited by - Shaggy on 02 January 2006 06:28:48
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 07 March 2006 :  10:17:18  Show Profile  Reply with Quote
Just resurrecting this one to see if anyone has any further thoughts on the problem we're encoutering above.

<

Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 07 March 2006 :  10:24:20  Show Profile  Send ruirib a Yahoo! Message  Reply with Quote
Ah, you're ressurrecting it then .
<


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 07 March 2006 :  10:50:17  Show Profile  Send ruirib a Yahoo! Message  Reply with Quote
I can confirm the issue persists. Just tested it.<


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 07 March 2006 :  11:06:07  Show Profile  Send ruirib a Yahoo! Message  Reply with Quote
Ok, found the answer. There was a small detail missing. Here is the line that needs changing:


response.redirect("topic.asp?"&ArchiveLink&strwhichpage&"TOPIC_ID="&Topic_ID&SearchLink&"&#"&LastPostReplyID)

In red that's what I added. I also removed the last two double quotes.

With the previous two fixes for intPageNumber and this one, it works with SQL Server.<


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 07 March 2006 :  20:18:58  Show Profile  Send ruirib a Yahoo! Message  Reply with Quote
Ok, here is the whole code:

if mypage=-1 then
	strSql="SELECT REPLY_ID  FROM "&strActivePrefix&"REPLY WHERE TOPIC_ID="&Topic_ID
	if AdminAllowed=0 then
		strSql=strSql&" AND (R_STATUS<"
		if Moderation="Y" then strSql=strSql&"2" else strSql=strSql&"3"
		strSql=strSql&" OR R_AUTHOR="&MemberID&")"
	end if
	strSql=strSql&" ORDER BY R_DATE ASC"
	set rsReplies=server.createobject("ADODB.Recordset")
	rsReplies.open strSql,my_Conn,adOpenStatic,adLockReadOnly,adCmdText
	if not rsReplies.eof then
		arrReplyData=rsReplies.getrows(adGetRowsRest)
		iReplyCount=ubound(arrReplyData,2)
		if len(request.querystring("REPLY_ID"))>0 then
			LastPostReplyID=clng(request.querystring("REPLY_ID"))
			for iReply=0 to iReplyCount
				intReplyID=arrReplyData(0,iReply)
				if LastPostReplyID=intReplyID then
					intPageNumber=((iReply+1)\strPageSize)
					if intPageNumber>clng(intPageNumber) then intPageNumber=clng(intPageNumber)+1
					strwhichpage="whichpage="&intPageNumber&"&"
					exit for
				end if
			next
		else
			LastPostReplyID=arrReplyData(0,iReplyCount)
			intPageNumber=((iReplyCount+1)\strPageSize)
			if intPageNumber>clng(intPageNumber) then intPageNumber=clng(intPageNumber)+1
			strwhichpage="whichpage="&intPageNumber&"&"
		end if
	else
		strWhichpage=""
	end if
	rsReplies.close
	set rsReplies=nothing
	my_Conn.close
	set my_Conn=nothing
	response.redirect("topic.asp?"&ArchiveLink&strwhichpage&"TOPIC_ID="&Topic_ID&SearchLink"&#"&LastPostReplyID)
	response.end
end if


This code replaces lines#202-271 in an unchanged Snitz 3.4.05 topic.asp.<


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 08 March 2006 :  06:28:33  Show Profile  Reply with Quote
Gah! That bloody &! Gets me every time!

Good man, Rui, well spotted

Gonna do a bit more work on this over lunch, see if I can't try and get it to pick up last edited post without any additional queries. Don't think it's going to be possible, but worth a look any way.

<

Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page
Page: of 5 Previous Topic Topic Next Topic  
Previous Page | 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.18 seconds. Powered By: Snitz Forums 2000 Version 3.4.07