| Author |
 Topic  |
|
GauravBhabu
Advanced Member
4288 Posts |
 Posted - 18 November 2001 : 06:13:38
|
Mod WhoIsInside
Author: IronHeart
Modified By: Rakesh Jain(GauravBhabu)
Uploaded: Jan 18, 2002
Last Update: Jan 18, 2002 12:35:00
Download Link 1:Who is Inside
Download Link 2:Who is Inside
Support Forum: Installation Help
Demo:Topic
Demo: Forum
Read whoisinside.txt included in the zip for implementation
Installation Level: Easy
Compatibility: May be used with versions 3.1SR4, 3.03 or 4.xbeta with slight Modifications for language strings.
GauravBhabu
There is only one miracle...That is LIFE! | It is difficult to IMPROVE on Perfection, There is no harm in Keep Trying.
Edited by - GauravBhabu on 22 January 2002 10:15:26 |
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
|
|
blackinwhite
Average Member
Turkey
657 Posts |
Posted - 18 November 2001 : 09:34:03
|
could anyone managed to work it with 3.1sr4. I get lost in inc_active _users.asp
____
"I am a legal alien" |
 |
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 18 November 2001 : 09:40:04
|
inc_activeusers.asp.
Make a backup of your inc_activeusers.asp and use the one provided in the zip. It should work without any major problem.
GauravBhabu
There is only one miracle...That is LIFE! | It is difficult to IMPROVE on Perfection, There is no harm in Keep Trying. |
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 18 November 2001 : 10:24:19
|
GauravBhabu anyway to show what you changed in the inc_activeusers.asp file? Mine is nowhere even Close
to what you have in this zip...
Test Site:
EastPasco running on Huw's Code 3.3.10 SQL 2000
Need a Snitz MOD? Click Here: Snitz Mod Resource |
|
|
|
blackinwhite
Average Member
Turkey
657 Posts |
Posted - 18 November 2001 : 10:32:27
|
I have replaced mine, with yours. It gave me this error:
-2147217900|The INSERT INTO statement contains the following unknown field name: 'insFORUMID'. Make sure you have typed the name correctly, and try the operation again.
I think the problem is with other active_users files since I haven't upgrade it. (it's Ricahrd K's code)
thank you anyway :)
____
"I am a legal alien" |
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 18 November 2001 : 10:33:37
|
Have you added the required field to the database. Other files need no changes. Just replace your inc_activeusers.asp file with the one in the zip. keep a copy of the old one.
GauravBhabu
There is only one miracle...That is LIFE! | It is difficult to IMPROVE on Perfection, There is no harm in Keep Trying.
Edited by - GauravBhabu on 18 November 2001 10:36:03 |
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 18 November 2001 : 10:34:21
|
quote:
GauravBhabu anyway to show what you changed in the inc_activeusers.asp file? Mine is nowhere even Close
to what you have in this zip...
Test Site:
EastPasco running on Huw's Code 3.3.10 SQL 2000
Need a Snitz MOD? Click Here: Snitz Mod Resource
Changes are marked in inc_activeusers.asp. You might be using the older version of inc_activeusers.asp. Backup yours and use the one in the zip file.
GauravBhabu
There is only one miracle...That is LIFE! | It is difficult to IMPROVE on Perfection, There is no harm in Keep Trying.
Edited by - GauravBhabu on 18 November 2001 10:37:59 |
|
|
|
Intrepidone
Average Member
Canada
515 Posts |
Posted - 18 November 2001 : 10:40:01
|
I am not getting this to work in v3.03
I have basically the same inc_activeusers.asp file that you have (must of got it from one of your MODS) but I am getting this error
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/forum/inc_activeusers.asp, line 184
One other thing, in the instructions you say to do the following
Database modification - Snitz Version 3.1SR4 and 3.03
-------------------------------------------------------
Add two new fields to following Table
FORUM_ONLINE
1. insFORUMID - AllowZeroLength, integer, Default=0
2 insTOPICID - AllowZeroLength, integer, Default=0
now are we suppose to add those or do they get added when we run the dbsetup? When I ran the dbsetup it did add the 2 fields to FORUM_ONLINE but there is no zerolength and the integer was set to long. How do we add AllowZeroLength?
(I know this should have went to the support forum but since you just release it...well .... 
Intrepidone
Information Technology Technician |
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 18 November 2001 : 10:52:05
|
quote:
I am not getting this to work in v3.03
I have basically the same inc_activeusers.asp file that you have (must of got it from one of your MODS) but I am getting this error
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/forum/inc_activeusers.asp, line 184
What you have on Line 180 -184?
quote:
are we suppose to add those or do they get added when we run the dbsetup? When I ran the dbsetup it did add the 2 fields to FORUM_ONLINE but there is no zerolength and the integer was set to long. How do we add AllowZeroLength?
(I know this should have went to the support forum but since you just release it...well ....
The fields get added when you run the Dbsetup. Are you using Access or sql server.
GauravBhabu
There is only one miracle...That is LIFE! | It is difficult to IMPROVE on Perfection, There is no harm in Keep Trying. |
|
|
|
blackinwhite
Average Member
Turkey
657 Posts |
Posted - 18 November 2001 : 10:52:59
|
quote:
Have you added the required field to the database. Other files need no changes. Just replace your inc_activeusers.asp file with the one in the zip. keep a copy of the old one.
GauravBhabu
There is only one miracle...That is LIFE! | It is difficult to IMPROVE on Perfection, There is no harm in Keep Trying.
Edited by - GauravBhabu on 18 November 2001 10:36:03
yes, I am using an older version of it. I have created the necessaet db fields,and replaced the inc file, it gave me this error this time:
-2147217913|Data type mismatch in criteria expression.
____
"I am a legal alien" |
|
|
|
Intrepidone
Average Member
Canada
515 Posts |
Posted - 18 November 2001 : 11:00:53
|
This is what I have on lines 180 - 184
' LETS UPDATE THE TABLE SO IT SHOWS THERE LAST ACTIVE VISIT
'##### Modified for Mod WhoIsInside - 11172001
strSql = "UPDATE " & strTablePrefix & "ONLINE SET M_BROWSE='" & strOnlineLocation & "' , insFORUMID='" & iOnlineForumID & "', insTOPICID='" & iOnlineTopicID & "', LastChecked='" & strOnlineCheckInTime & "' WHERE UserID='" & strOnlineUser & "' AND " & strTablePrefix & "ONLINE.UserIP='" & strOnlineUserIP & "'"
'##### Mod WhoIsInside - 11172001
my_Conn.Execute (strSql)
and I am using Access2000 but it does not add the AllowZeroLength
Even if I use your inc_activeusers.asp I get the same error
Intrepidone
Information Technology Technician
Edited by - Intrepidone on 18 November 2001 11:02:09 |
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 18 November 2001 : 11:06:58
|
Open the database in Access and Set Value for AllowZeroLength to Yes for the fields insFORUMID and insTOPICID. Let me know if it works with that.
GauravBhabu
There is only one miracle...That is LIFE! | It is difficult to IMPROVE on Perfection, There is no harm in Keep Trying. |
|
|
|
Intrepidone
Average Member
Canada
515 Posts |
Posted - 18 November 2001 : 11:17:08
|
There is no place for it to allow me to add 'AllowZeroLength'
And if I can add 'AllowZeroLength' how do I do it?
Intrepidone
Information Technology Technician |
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 18 November 2001 : 11:27:51
|
okay Never Mind. The Zero Length is for Text fields only. Change the field to integer. let us seeif it resolves the error. Else I have one more check.
GauravBhabu
There is only one miracle...That is LIFE! | It is difficult to IMPROVE on Perfection, There is no harm in Keep Trying. |
|
|
|
Intrepidone
Average Member
Canada
515 Posts |
Posted - 18 November 2001 : 12:00:47
|
Same results if I set it to 'Integer'
Now, if I do not add the very last change in inc_active_users.asp I do not get any errors (so the fault may be in the very last code on line # 180-184)
Also, for the code in forum.asp, the one that you have for around line 365, there is an extra " at the end of this response.write
Response.Write "<i><font face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """>""
Intrepidone
Information Technology Technician |
|
|
|
Topic |
|
Topic Locked
