| Author |
 Topic  |
|
Lord Predator
Starting Member
Italy
6 Posts |
 Posted - 13 September 2002 : 13:06:03
|
Hi there. I just getted active users 4.0, bu t i have a problem. I can't find the lines that i need to modify!! i cant download aranea 'cause i'm on a mac. Some1 knows a text editor that have the same function?
thx |
Lord Pred@tor
http://www.aoe2tournament.net/aoe2tforum/ |
 |
|
|
masterao
Senior Member
Sweden
1678 Posts |
|
|
ustcatgccaa
Starting Member
22 Posts |
Posted - 14 September 2002 : 00:44:41
|
I just installed 40_17 and followed the instruction to the tee. I get the following error message:
------- error msg --------
Microsoft JET Database Engine error '80040e37'
The Microsoft Jet database engine cannot find the input table or query 'FORUM_ACTIVE_USERS'. Make sure it exists and that its name is spelled correctly.
/dev/inc_func_common.asp, line 162
-------end of msg --------
does anyone know how I can troubleshoot this?
thx.
/armand |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 14 September 2002 : 02:48:39
|
Hi Armand!
You haven't created that table in your database. To fix that error, you must run the dbs_activeusers.asp in Mod Setup.
|
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
Webguy
New Member
Australia
65 Posts |
Posted - 14 September 2002 : 06:45:15
|
| My problem with it is as follows. It will only show guests and totally ignores members who are logged in. V4.0.17. Installed after removing the 3.5 Version. No errors. But just refuses to show members. |
"Special bulletin: There is still no news from New Zealand. If they ever have any, we'll be sure to let you know." |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 14 September 2002 : 07:19:15
|
Webguy, that sounds like you have missed to add/replace a piece of code (or part of a block of code). Recheck that you have added/replaced the code in the right places.
|
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
ustcatgccaa
Starting Member
22 Posts |
Posted - 14 September 2002 : 09:33:38
|
quote:
Originally posted by ustcatgccaa
I just installed 40_17 and followed the instruction to the tee. I get the following error message:
------- error msg --------
Microsoft JET Database Engine error '80040e37'
The Microsoft Jet database engine cannot find the input table or query 'FORUM_ACTIVE_USERS'. Make sure it exists and that its name is spelled correctly.
/dev/inc_func_common.asp, line 162
-------end of msg --------
does anyone know how I can troubleshoot this?
thx.
/armand
...never mind...
i found where the problem is...
i reformatted the instruction and left out a piece (running audbsetup.asp). went back to the original instruction and re-did everything. |
|
|
|
MrNik
Starting Member
Italy
49 Posts |
Posted - 15 September 2002 : 13:50:14
|
In file LangMODS_Ls3kAU4.asp six forgotten to you to write the symbol # the line :
case "1033" 'English
%><!--INCLUDE FILE="LangMODS_Ls3kAU4_1033.asp" --><%
and in all the other lines.
replace the original value with :
select case strLangLCID
case "1030" 'Danish
%><!--INCLUDE FILE="LangMODS_Ls3kAU4_1030.asp" --><%
case "1033" 'English
%><!--INCLUDE FILE="LangMODS_Ls3kAU4_1033.asp" --><%
case "1034" 'Spanish
%><!--INCLUDE FILE="LangMODS_Ls3kAU4_1034.asp" --><%
case "1036" 'French
%><!--INCLUDE FILE="LangMODS_Ls3kAU4_1036.asp" --><%
case "1037" 'Hebrew
%><!--INCLUDE FILE="LangMODS_Ls3kAU4_1037.asp" --><%
case "1041" 'Japanese
%><!--INCLUDE FILE="LangMODS_Ls3kAU4_1041.asp" --><%
case "1043" 'Dutch
%><!--INCLUDE FILE="LangMODS_Ls3kAU4_1043.asp" --><%
case "1046" 'Portuguese - Brazil
%><!--INCLUDE FILE="LangMODS_Ls3kAU4_1046.asp" --><%
case "1053" 'Sweedish
%><!--INCLUDE FILE="LangMODS_Ls3kAU4_1053.asp" --><%
case "2070" 'Portuguese - Portugal
%><!--INCLUDE FILE="LangMODS_Ls3kAU4_2070.asp" --><%
case else
%><!--#INCLUDE FILE="LangMODS_Ls3kAU4_1033.asp" --><%
end select
%>
P.s. : Great Mod, good work  |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 15 September 2002 : 14:27:42
|
I was going to comment on all these includes. using select case does
not prevent all of these files from needing to be read. they will
in fact read them regardless but use only the section that is true.
I've taken all the ones out that I don't need using only the
English one. this should give a smidgen of increased performance.
|
 |
Edited by - dayve on 15 September 2002 14:27:58 |
|
|
|
gareth_moore_2000
Junior Member
United Kingdom
262 Posts |
Posted - 15 September 2002 : 18:11:27
|
for ****s sake- has this ghost guest problem going to be resolved or not ?
I am past caring now ! |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 15 September 2002 : 18:46:15
|
quote:
Originally posted by gareth_moore_2000
for ****s sake- has this ghost guest problem going to be resolved or not ?
I am past caring now !
yes it has. In fact the info is IN THIS THREAD if you go through it you can find it, but I will graciously post it here for you.
In inc_func_common.asp, look for the code below. Add the code marked red.
else 'Is a new user, make new record
If strLoginStatus = 0 then
strSql = "INSERT INTO " & strTablePrefix & "ACTIVE_USERS (" & _
"MEMBER_ID, AU_IP, AU_LOGINTIME, AU_LASTACTIVETIME, " & _
"AU_LASTPAGE, AU_QUERYSTRING, AU_USER_AGENT) VALUES(" & _
MemberID & ", " & _
"'" & Chkstring(strUserIP, "SQLString") & "', " & _
"'" & Chkstring(strCurrentTime, "SQLString") & "', " & _
"'" & Chkstring(strCurrentTime, "SQLString") & "', " & _
"'" & Chkstring(strScriptName, "SQLString") & "', " & _
"'" & Chkstring(strQueryString, "SQLString") & "', " & _
"'" & Chkstring(strUserAgent, "SQLString") & "')"
my_conn.execute (strSql)
endd if
end if
end sub
|
|
Edited by - dayve on 15 September 2002 18:47:08 |
|
|
|
GenerationEdge
Junior Member
105 Posts |
Posted - 16 September 2002 : 19:19:42
|
quote:
Originally posted by dayve
else 'Is a new user, make new record
If strLoginStatus = 0 then
strSql = "INSERT INTO " & strTablePrefix & "ACTIVE_USERS (" & _
"MEMBER_ID, AU_IP, AU_LOGINTIME, AU_LASTACTIVETIME, " & _
"AU_LASTPAGE, AU_QUERYSTRING, AU_USER_AGENT) VALUES(" & _
MemberID & ", " & _
"'" & Chkstring(strUserIP, "SQLString") & "', " & _
"'" & Chkstring(strCurrentTime, "SQLString") & "', " & _
"'" & Chkstring(strCurrentTime, "SQLString") & "', " & _
"'" & Chkstring(strScriptName, "SQLString") & "', " & _
"'" & Chkstring(strQueryString, "SQLString") & "', " & _
"'" & Chkstring(strUserAgent, "SQLString") & "')"
my_conn.execute (strSql)
endd if
end if
end sub
I think that should be end if and not endd if correct?  |
Jason |
|
|
|
nathansym
Junior Member
163 Posts |
Posted - 16 September 2002 : 19:47:51
|
I get the following error on admin_home.asp
-------------
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'fLang'
/admin_home.asp, line 131
-------------------
here is the code
-------------------
Response.Write " <LI><span class=""spnMessageText""><a href=""admin_config_members.asp"">Member Details Configuration</a></span></LI>" & vbNewLine & _
" <LI><span class=""spnMessageText""><a href=""admin_config_ranks.asp"">Ranking Configuration</a></span></LI>" & vbNewLine & _
" <LI><span class=""spnMessageText""><a href=""admin_config_datetime.asp"">Server Date/Time Configuration</a></span></LI>" & vbNewLine & _
" <LI><span class=""spnMessageText""><a href=""admin_config_email.asp"">Email Server Configuration</a></span></LI>" & vbNewLine & _
" <LI><span class=""spnMessageText""><a href=""admin_config_colors.asp"">Font/Table Color Code Configuration</a></span></LI>" & vbNewLine & _
" <LI><span class=""spnMessageText""><a href=""javascript:openWindow3('admin_config_badwords.asp')"">Bad Word Filter Configuration</a></span></LI>" & vbNewLine & _
" <LI><span class=""spnMessageText""><a href=""javascript:openWindow3('admin_config_namefilter.asp')"">UserName Filter Configuration</a></span></LI>" & vbNewLine & _
" <LI><span class=""spnMessageText""><a href=""javascript:openWindow3('admin_config_order.asp')"">Category/Forum Order Configuration</a></span></LI>" & vbNewLine & _
" <LI><span class=""spnMessageText""><a href=""admin_config_activeusers.asp"">" & fLang(strLangMOD_Ls3kAU_05000) & "</a></span></LI>" & vbNewLine & _
" </UL></p>" & vbNewLine & _
" </font></td>" & vbNewLine & _
" <td bgcolor=""" & strForumCellColor & """ valign=""top""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strForumFontColor & """>" & vbNewLine & _
" <p><b>Other Configuration Options and Features:</b>" & vbNewLine & _
" <UL>" & vbNewLine
-------------------------------
I see the "flang()' statement in there but dont know what to do ... can anyone help |
- Thanks
- Nathan
- www.gunslackers.com |
Edited by - nathansym on 16 September 2002 19:50:12 |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 16 September 2002 : 19:58:14
|
nathansym, you need to add the fLang function to config.asp. Recheck the instructions in the readme-file for the language files (it's at the bottom of the readme).
|
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
nathansym
Junior Member
163 Posts |
Posted - 16 September 2002 : 19:58:44
|
| nvmd .... got answer here |
- Thanks
- Nathan
- www.gunslackers.com |
Edited by - nathansym on 16 September 2002 20:00:14 |
|
|
|
Topic |
|
Topic Locked
