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)
 New feature: How many using your forum now
 New Topic  Topic Locked
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 6

redbrad0
Advanced Member

USA
3725 Posts

Posted - 16 December 2000 :  12:24:34  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
One thing I found that needed to be fixed, is the lines of code you put into your form.asp file you need to add the table prefix to the table before you excute it.

There are two lines...

SQL = "UPDATE " & strTablePrefix & "FORUM_ONLINE SET M_BROWSE = '" & OnlineLocation & "' , DateCreated = '" & Date & "' WHERE UserID = '" & User & "'"


SQL = "DELETE FROM " & strTablePrefix & "FORUM_ONLINE WHERE CheckedIn < '" & TimedOut & "'"

Brad
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 16 December 2000 :  14:09:36  Show Profile
Brad, have you tested those changes you suggest?

adding strTablePrefix like you have shown will result in : FORUM_FORUM_ONLINE

The table name is: FORUM_ONLINE
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts

Posted - 16 December 2000 :  14:16:53  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
Ops Sorry, I forgot to take out one part...remove whats in bold. This way it will go along with every other table. I am writting a better script, in my opinion and it should be done in 30 mins to an hour. :O) will post it when its done.

SQL = "DELETE FROM " & strTablePrefix & "<b>FORUM_</b>ONLINE WHERE CheckedIn < '" & TimedOut & "'"

change to

SQL = "DELETE FROM " & strTablePrefix & "ONLINE WHERE CheckedIn < '" & TimedOut & "'"

This way

Brad
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts

Posted - 16 December 2000 :  14:26:20  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
Quick question.....

what tiemout does this line give it?

TimedOut = CheckInTime - 3600 'time out the user

does this set allow them to be inactive for 36 minutes?



Brad
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 16 December 2000 :  14:44:05  Show Profile
that # is expressed in seconds: 3600 = 60 minutes

I have mine set to 180 (3 minutes)
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts

Posted - 16 December 2000 :  15:55:58  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
I started a new topic with a new version of active users i posted view it here....

http://forum.snitz.com/forum/link.asp?TOPIC_ID=2903

Brad
Go to Top of Page
Page: of 6 Previous Topic Topic Next Topic  
Previous 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.08 seconds. Powered By: Snitz Forums 2000 Version 3.4.07