| Author |
 Topic  |
|
SouthtownWarrior
Starting Member
USA
3 Posts |
 Posted - 30 August 2001 : 12:00:46
|
Thanks, that seemed to fix the problem ... BUT, I had to make one small modification.
I took these lines:
rsUserExists.close
set rsUserExists = nothing
And Moved them to line #148, after these lines:
else
' LETS UPDATE THE TABLE SO IT SHOWS THERE LAST ACTIVE VISIT AND NEW IP ADDRESS
strSql = "UPDATE " & strTablePrefix & "ONLINE SET M_BROWSE='" & strOnlineLocation & "' , LastChecked='" & strOnlineCheckInTime & "' , UserIP='" & strOnlineUserIP & "' WHERE UserID='" & strOnlineUser & "'"
end if
Thanks for you help ... I will let you know if I have anymore problems.
--Michael George
www.thesouthtown.com
|
 |
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 30 August 2001 : 12:14:48
|
Yes! That is correct. Those two statements should be there.
Share A Square at forumSquare
GauravBhabu
There is only one miracle...That is LIFE! |
|
|
|
GBurch
Junior Member
United Kingdom
107 Posts |
|
|
SalmanKhana
Average Member
USA
961 Posts |
Posted - 30 August 2001 : 13:27:41
|
thanx for emailing me the password GB.
just wanna know if the updates have been made to what these users were having problems about ?
|
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 30 August 2001 : 14:21:19
|
Yes! the files have been updated.
Share A Square at forumSquare
GauravBhabu
There is only one miracle...That is LIFE! |
|
|
|
GBurch
Junior Member
United Kingdom
107 Posts |
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 30 August 2001 : 18:16:00
|
GBurch,
Seems You are downloading the wrong file. You need to download the v3.4. However i have sent you the while ZIp File. Check your Email.
Share A Square at forumSquare
GauravBhabu
There is only one miracle...That is LIFE! |
|
|
|
RDoGG™
Junior Member
USA
329 Posts |
Posted - 30 August 2001 : 22:42:22
|
GB, i have a question.
i d/l'ed richard's activeusers MOD for v3.3.
what is the difference b/w this and that?
also, i read in some other forum (Help: MOD Implentation or something) that you and Richard agreed that there was some redundant queries? has this been taken care of?
also, you gave a fix to the same user / multiple IP's problem. is that in this code?
awaiting your replies.
RDoGG™ |
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 30 August 2001 : 22:53:39
|
See the first post in this topic. It includes all the fixes mentioned there. And also includes the fixes for the errors posted in this thread. The download files are upto date.
Share A Square at forumSquare
GauravBhabu
There is only one miracle...That is LIFE! |
|
|
|
RDoGG™
Junior Member
USA
329 Posts |
Posted - 30 August 2001 : 23:08:23
|
ok...one more thing...i'm not exactly sure why all four recordsets are closed at the end of the scripts?
isn't it proven that closing recordsets quicker help performance?
if u need some value from a recordset, put it in some temp. variable
this should be fixed and also that M_BROWSE should allow values of 255+ chars.
someone reported a bug where if the url was over 255 chars (like post.asp, whose URL includes topic title, topic ID, etc.), an error would come up. i hope this has been fixed.
thanks for the MOD, GB.
RDoGG™ |
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 30 August 2001 : 23:27:03
|
I did not close them originally. SouthtownWarrior (see earlier in the thread) was having problems, so I changed it. On my site, I am using the file without closing recordsets.
Even I am not closing the connection in inc_footer.asp. I have had no problems.
I will update the dbs files for M_BROWSE.
Share A Square at forumSquare
GauravBhabu
There is only one miracle...That is LIFE!
Edited by - GauravBhabu on 30 August 2001 23:27:52 |
|
|
|
GBurch
Junior Member
United Kingdom
107 Posts |
Posted - 31 August 2001 : 03:11:19
|
The file you sent me is the same as to one I was downloading, except that it has the setup file in it (thank you).
But, I installed it, and got this on the Active Users Page
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'WriteFooter'
/forum/active_users.asp, line 156
http://www.captgb.dabsol.co.uk
http://www.slipstreamservices.com |
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 31 August 2001 : 03:13:00
|
What version of snitz you are using?
Share A Square at forumSquare
GauravBhabu
There is only one miracle...That is LIFE! |
|
|
|
GBurch
Junior Member
United Kingdom
107 Posts |
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 31 August 2001 : 03:58:17
|
Here is the solution:
You will see the following statements around line 156 in active_users.asp
<%
WriteFooter (line 156)
sub Paging()
Remove the statement WriteFooter
And just above the <% tag add the following statement
<!--#INCLUDE FILE="inc_footer.asp"-->
After changes it will look similar as below
<!--#INCLUDE FILE="inc_footer.asp"-->
<%
sub Paging()
Save and it will be OKay
Share A Square at forumSquare
GauravBhabu
There is only one miracle...That is LIFE!
Edited by - GauravBhabu on 31 August 2001 03:59:20 |
|
|
|
Topic |
|
Topic Locked
