| Author |
 Topic  |
|
animedj
Junior Member
USA
190 Posts |
 Posted - 06 August 2000 : 13:59:33
|
Well, here's my next add-on for the forums. this is just some general statistics that are being shown in the default page. Suggestions, bugs and fixes please email me. Also I kind of run out of ideas for another add-on (currently I'm working in a short url for the forums, but that would need a major change of code so as soon as I finish the code I'll put as suggestions for the next release) so if you got any more ideas, please post it.
d/l : http://animedj.com/community/forums/hacks/statistics.zip
demo : http://animedj.com/go.asp?catid=3
|
|
|
heptite
Average Member
USA
547 Posts |
Posted - 06 August 2000 : 15:58:05
|
Thanks very much for posting the code.
I made a few minor changes to your .asp page, I added punctuation and fixed a minor problem with the variable Users versus Users1.
Now it just needs an icon to go with it.
<center><font color=purple>
ASPDiva Forum - http://www.aspdiva.com/forum/default.asp
</font id=purple></center> |
 |
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 06 August 2000 : 16:44:49
|
ohh, Thanks heptite, I'm always doing a lot of modifications that I forgot about that. Now the code is fixed.
|
|
|
|
heptite
Average Member
USA
547 Posts |
Posted - 06 August 2000 : 18:23:10
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
ohh, Thanks heptite, I'm always doing a lot of modifications that I forgot about that. Now the code is fixed.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Great! One other minor thing, your readme lists the include file in two places, the before and after sections.
Sue (Technical Editor in a Past Life)
<center><font color=purple>
ASPDiva Forum - http://www.aspdiva.com/forum/default.asp
</font id=purple></center> |
|
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 06 August 2000 : 18:31:18
|
DOH!!! well, writing documentation has never been my Forte... well fixed and uploaded. Thanks Heptite!
|
|
|
|
slemieux
Junior Member
USA
234 Posts |
Posted - 06 August 2000 : 19:40:36
|
Thanks animedj!!
Works Great <img src=icon_smile.gif border=0 align=middle> and easy to install!
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 06 August 2000 : 20:06:10
|
Thanks <img src=icon_smile.gif border=0 align=middle>
|
|
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 06 August 2000 : 21:08:57
|
Thanks!! but still this add-on is not yet finished. There are 2 things that I left out and I thought I migbht ask here so I can release another version. The 2 things that I saw in the UBB like forums are these :
* 1024 members have made 15193 posts in 19 forums, with the last post on August 06, 2000 at 20:51
* There are currently 14946 active posts in 2525 active topics
* Todays featured member is Lord Caligo and please welcome our newest member djm3000
so my questions would be : what are the rules so a member would be presented as a feature member and what's the difference between 15193 posts and 14946 active posts ???
|
|
|
|
blkrogue
New Member
USA
79 Posts |
Posted - 07 August 2000 : 02:31:17
|
Love the paging add-on you did animedj !
Definately makes it easier to keep track of only the latest added replies to a topic.
Blkrogue
In the darkness of my soul a sparkling light has appeared |
|
|
|
Barry
Starting Member
13 Posts |
Posted - 07 August 2000 : 02:39:19
|
Hi,
I was having problems with this hack and see that you changed the statistics.asp code a bit so I am now using the current page (as of the moment.) But....I get an error referencing the following line:
lastPost = ChkDate(rs("T_LAST_POST")) & ChkTime(rs("T_LAST_POST"))
lastPostLink = "topic.asp?TOPIC_ID=" & rs("TOPIC_ID") & "&FORUM_ID=" & rs("FORUM_ID") & "&CAT_ID=" & rs("CAT_ID") & _
"&Topic_Title=" & ChkString(rs("T_SUBJECT"),"urlpath") & _
"&Forum_Title=" & ChkString(rs("F_SUBJECT"),"urlpath")
The error returned is:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/forum/statistics.asp, line 39
I am sure this is simple but I am fresh to ASP.
Talk Soon,
Barry
|
|
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 07 August 2000 : 08:42:36
|
hmm, that's strange... Yes I changed it because it was before working for access200 but now it can work with SQL as well. I would recommend you to d/l again the file and try it, because that error is when you try to open a field that doesn't exist. Also what DB are you using??
|
|
|
|
pier
Starting Member
Italy
22 Posts |
Posted - 07 August 2000 : 09:17:43
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hi,
I was having problems with this hack and see that you changed the statistics.asp code a bit so I am now using the current page (as of the moment.) But....I get an error referencing the following line:
lastPost = ChkDate(rs("T_LAST_POST")) & ChkTime(rs("T_LAST_POST"))
lastPostLink = "topic.asp?TOPIC_ID=" & rs("TOPIC_ID") & "&FORUM_ID=" & rs("FORUM_ID") & "&CAT_ID=" & rs("CAT_ID") & _
"&Topic_Title=" & ChkString(rs("T_SUBJECT"),"urlpath") & _
"&Forum_Title=" & ChkString(rs("F_SUBJECT"),"urlpath")
The error returned is:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/forum/statistics.asp, line 39
I am sure this is simple but I am fresh to ASP.
Talk Soon,
Barry
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Fix the last SQL SELECT as follow:
<pre id=code><font face=courier size=2 id=code>
strSql = "SELECT TOP 1 " & strTablePrefix & "TOPICS.CAT_ID, " & _
strTablePrefix & "TOPICS.FORUM_ID, " & _
strTablePrefix & "TOPICS.TOPIC_ID, " & _
strTablePrefix & "TOPICS.T_LAST_POST, " & _
strTablePrefix & "FORUM.F_SUBJECT, " & _
strTablePrefix & "TOPICS.T_SUBJECT " & _
"FROM " & strTablePrefix & "TOPICS " &_
"INNER JOIN " & strTablePrefix & "FORUM ON " & _
strTablePrefix & "TOPICS.FORUM_ID=" & _
strTablePrefix & "FORUM.FORUM_ID " & _
"WHERE F_PRIVATEFORUMS <> 6 " & _
"ORDER BY " & strTablePrefix & "TOPICS.T_LAST_POST DESC;"</font id=code></pre id=code>
Pier
|
|
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 07 August 2000 : 10:07:47
|
ohh.. I really need to create a new forum in my development machine so I won't keep doing these errors. Yes, I omitted to lines as my forums doesn't need topic title and forum title to work.. sorry. I'll try to be more cereful from now on.
|
|
|
|
Barry
Starting Member
13 Posts |
Posted - 07 August 2000 : 10:09:16
|
Hi Pier,
Thanks!
That did the trick.
Talk Soon,
Barry
|
|
|
|
webshorts
New Member
USA
96 Posts |
|
|
Lord Maverick
New Member
Norway
92 Posts |
Posted - 07 August 2000 : 17:31:15
|
This script is nice and I'm using it (MS Acc2000, IIS4.0), but it does'nt show how many forums I have. Looks
like the <% Categories%> does'nt respond with any value. Is there a new field in the
database that needs to be implemented, or is it a variable it does'nt find.
Anyone?
|
|
|
|
Topic |
|
Topic Locked
