| Author |
 Topic  |
|
bugzy
Junior Member
USA
147 Posts |
 Posted - 28 November 2000 : 18:45:50
|
i think i ran through all the same problems as you guys
im using a SQL db ... and i used DSN names ...
but .. i forgot what i did to fix them ...
|
 |
|
|
xMANIGHTx
Junior Member
Italy
191 Posts |
Posted - 03 December 2000 : 10:58:14
|
RICHARD... sorry if I bug u, but I still haven't found a way to let the Who's online mod work! I got thru all the threads and posts. I download and coded... and now I dunno where to start again. I read you modified it to show directly the names of members + number of guests in the main statz too! Could you be so kind to put up a final (your version), with default.asp, forum.asp and all I need for version 3.1sr2! I know I'm asking much.. it would be very appreciated. I already launched who'sonline setup asp page and updated the DB. Thanx
<img src="http://www.audiopro.it/max.gif" border=0> Distractly yours... manight@audiopro.it |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 03 December 2000 : 11:03:40
|
| Is the who's online mod the only mod you have installed that would affect default.asp or forum.asp ? |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 03 December 2000 : 11:34:04
|
xMANIGHTx,
download this file: http://www1.domaindlx.com/dssdbs/files/whos2.zip
extract all files to your /forum directory. Since you said that you have already run the whos_online_setup.asp file you can delete that file, and you should be all set. |
|
|
|
xMANIGHTx
Junior Member
Italy
191 Posts |
Posted - 03 December 2000 : 16:50:46
|
Well I'm impressed by your kindness!!! Thanx Richard and... well it WORKS!!!!!
I'm an ASP coder too and I hope soon I have time to read all the snitz code to put my contribution in it.
I guess it would be nice for moderators or admin (or even all members) of the forum to have the IPs shown in the who's online detail PAGE. What do you think about it?
One last thing this is about general ASP coding ...I ask you here so u don't have to walk around ... it's about cookies managment. I thinks it's really an easy thing summthing like request.cookies("cookiename") or sumthing like that... I have 2 questions about it...
1) the asp "methods" for writing, reading and deleting cookies...
2) How does the forum use cookies. I mean using session variables would have been "easier" but it has many negative countersides (say session timeout for example). So how does the snitz interact with cookies? Does the first page put your cookies in the db as long as you stay logged in (togetther with your sessionID) and then does a SELECT on the DB on each page or what?
Thanx in advance <img src=icon_smile_big.gif border=0 align=middle>
<img src="http://www.audiopro.it/max.gif" border=0> Distractly yours... manight@audiopro.it |
|
|
|
xMANIGHTx
Junior Member
Italy
191 Posts |
Posted - 05 December 2000 : 05:29:49
|
I found a bug... when I arrive on the main forum page, the who's online shows the last member that has logged though if he was still there and DOESN't show me too. At this time if I go in the who's online detail page the page is empty. When I go back to the main page it shows me correctly. It seems like if the field on the DB containing the last member logged has not been deleted... And it also doesn't recognize u the first time u get in...
www.audiopro.it/forum
<img src="http://www.audiopro.it/max.gif" border=0> Distractly yours... manight@audiopro.it |
|
|
|
Bob
New Member
USA
79 Posts |
Posted - 08 December 2000 : 09:01:55
|
I can't get past this error message on the default page.
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'count(UserID) onlinecount'.
/forum/online2.asp, line 63
I have the 3.1 sr2 version and have ran the database update as well as set the data lenght to 255. I do get the whos_online.asp working just fine it is just the error message on the default.asp page
Any suggestions?
<b>Bob Smith</b>
www.zooweb.com
http://www.imageworks.net/fp2000/forum/default.asp |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 08 December 2000 : 09:17:49
|
Try changing it to this:
count(UserID) AS onlinecount |
|
|
|
Bob
New Member
USA
79 Posts |
Posted - 08 December 2000 : 09:28:07
|
Tried that now I am getting
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/forum/Default.asp, line 84
and nothing else is showing up on the page.
<b>Bob Smith</b>
www.zooweb.com
http://www.imageworks.net/fp2000/forum/default.asp |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 08 December 2000 : 09:42:29
|
| can you post what is at lines 75 - 90 of <b>default.asp</b> |
|
|
|
Bob
New Member
USA
79 Posts |
Posted - 08 December 2000 : 10:17:19
|
'## Forum_SQL - Get all Forums From DB
strSql = "SELECT " & strTablePrefix & "CATEGORY.CAT_ID, " & strTablePrefix & "CATEGORY.CAT_STATUS, "
strSql = strSql & strTablePrefix & "CATEGORY.CAT_NAME, " & strTablePrefix & "CATEGORY.CAT_ORDER "
strSql = strSql & " FROM " & strTablePrefix & "CATEGORY "
strSql = strSql & " ORDER BY " & strTablePrefix & "CATEGORY.CAT_ORDER ASC"
strSql = strSql & ", " & strTablePrefix & "CATEGORY.CAT_NAME ASC;"
set rs = my_Conn.Execute (strSql)
%>
<table border=0 width="95%" cellspacing=0 cellpadding=0 align=center>
<tr>
<td>
<%
<b>Bob Smith</b>
www.zooweb.com
http://www.imageworks.net/fp2000/forum/default.asp |
|
|
|
Bob
New Member
USA
79 Posts |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
|
Bob
New Member
USA
79 Posts |
Posted - 08 December 2000 : 11:19:04
|
No luck did it and it did update the database as needed.
Now I get this error message on the default page.Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'count(UserID) onlinecount'.
/forum/online2.asp, line 63
<b>Bob Smith</b>
www.zooweb.com
http://www.imageworks.net/fp2000/forum/default.asp |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 08 December 2000 : 11:31:56
|
did you change line 59 of <b>online2.asp</b>
From this:
<font size=1><pre id=code><font face=courier size=2 id=code> strSqL = "SELECT count(UserID) onlinecount "</font id=code></pre id=code></font id=size1>
To this:
<font size=1><pre id=code><font face=courier size=2 id=code> strSqL = "SELECT count(UserID) <font color=red>AS</font id=red> onlinecount "</font id=code></pre id=code></font id=size1>
|
|
|
|
Topic |
|
Topic Locked
