| Author |
 Topic  |
|
blkrogue
New Member
USA
79 Posts |
 Posted - 08 August 2000 : 09:43:00
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Also BlkRogue, there is no conflict in the rs object as where is located it's outside the rs.eof loop and so the rs is empty.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
As I wanted it to be on top of the page (as my forum has alot of categories and forums, it takes too long to scroll down to view the statistics .... it then is put in a place where the rs object isn't empty yet, so I decided to change the rs object name in your statistics.asp page just to avoid problems
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
The error I was able to trace it to inc_functions.asp when it does a level check and it gives a result for a moderator. why it messes up the variable users.. I can't quite figure that out yet...
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
I'll give it some more tests and see if I can figure out what is happening, right now I'm not sure what you are meaning with the quoted remark.
Blkrogue
In the darkness of my soul a sparkling light has appeared |
 |
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 08 August 2000 : 21:23:39
|
Hey, blkRogue.. I just got yer email. Sorry I couldn't answer as I'm changing server now and my email accounts weren't set up in the new server yet. Abou the quote I thought you were talking about an old bug with the users variable, and I tried to d/l the zip but it doesn't exists. Could you repost it again??
|
|
|
|
Kal Corp
Average Member
USA
878 Posts |
Posted - 08 August 2000 : 21:57:17
|
<b>FYI - Also need to chage </b>
strSQL = "SELECT TOP 1 M_NAME, MEMBER_ID FROM " & <font color=red>strTablePrefix</font id=red> & "MEMBERS ORDER BY M_DATE desc;"
<b>to</b>
strSQL = "SELECT TOP 1 M_NAME, MEMBER_ID FROM " & <font color=red>strMemberTablePrefix</font id=red> & "MEMBERS ORDER BY M_DATE desc;"
|
|
|
|
blkrogue
New Member
USA
79 Posts |
Posted - 09 August 2000 : 03:54:47
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hey, blkRogue.. I just got yer email. Sorry I couldn't answer as I'm changing server now and my email accounts weren't set up in the new server yet. Abou the quote I thought you were talking about an old bug with the users variable, and I tried to d/l the zip but it doesn't exists. Could you repost it again??
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
The url to get to my list of d/l's is:
http://www.geocities.com/blkrogue99/forumhacks/
the newstats.zip is the one with a modified statistics.asp (hope that works better then the original link).
If you want to see a demo of where my statistics are set now, go to http://www.sfxserve.co.uk/Homepage/blkrogue/testforum/default.asp (it's mostly dutch as I'm helping out some friends with setting up their forum).
At least it'll give you an idea what I'm talking about *grin*.
The changes made to the rs object (now rsStats) is because if you move your stats to the top of the table, the original rs object in default.asp isn't closed yet, thus giving a conflict.
Hope this makes my ramblings a little clearer <img src=icon_smile_big.gif border=0 align=middle>
Blkrogue
In the darkness of my soul a sparkling light has appeared |
|
|
|
achagoury
Starting Member
USA
29 Posts |
Posted - 13 August 2000 : 11:29:28
|
I followed all instructions, however I am getting this error...
ADODB.Recordset.1 error '80004005'
Syntax error (missing operator) in query expression 'count(FORUM_ID) forums'.
statistics.asp, line 44
could you help?
|
|
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 13 August 2000 : 12:15:06
|
hmm, what kind of database are you using?? Access or SQL????
|
|
|
|
phishyDev
Starting Member
USA
6 Posts |
Posted - 13 August 2000 : 12:20:41
|
I have an idea or two about the "Featured Member" aspect of this you mentioned in the beginning of this thread.
1. The member with the most posts that day, or previous day.
- or -
2. A random member pulled from the db. This could be done in two fashions but both involve setting up 2 new fields in the db in the settings table ( a featured member field and a date field). For those using SQL, you can use SQL Agent to schedule some script to be run at midnight to modify the entry in the db. For those using Access, you would have to test the date stored in that new field to see if it matches today's date every time it is pulled and if it doesn't, run the script to pull a new name and insert into the db.
I like the idea very much and would definately use it!
Steve |
|
|
|
achagoury
Starting Member
USA
29 Posts |
Posted - 13 August 2000 : 12:23:43
|
I am using Access 2000 with DSN connection...
Thanks
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
hmm, what kind of database are you using?? Access or SQL????
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
|
|
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 13 August 2000 : 15:47:23
|
hmm, then you should check your config.asp file around line 32, the following line :
strDBType = "access" '## access, sqlserver
be sure that is access and not sqlserver.
|
|
|
|
Rigger82
Junior Member
USA
311 Posts |
Posted - 15 August 2000 : 15:43:12
|
Can this be used remotely? I have the forum on my site and as a way to draw attention I would like to do something like the statistics but add active topics (maybe limit it to 5) and use it on the main page of my site.. that way, new users see the latest topics and old users can watch it without accessing directly... both new and old users would get a constant reminder of the forums.. great for return hits.
Anyone?
PS... The stats are an awesome add-on, 2 thumbs up!
---------------------
Mark Christianson
Gulf War Veteran (82nd Airborne Division)
Owner/Operator of www.paratrooper.net
Rigger@paratrooper.net |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 18 August 2000 : 09:48:22
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
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 ???
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
For the source-code I defined an active topic as being an open topic (= not locked).
Because those are the only topics a Normal Member could respond to.
The Statistics have been added to the source-code. Also there has been added an option to the admin-screens so you can choose if you want the detailed statistics or just the statistics you see now at the forum (the You last Visited on top).
Also the You last Visited is only displayed if a user is logged on.
<center><b>Pierre Gorissen </b>
<font color=purple><font size=1>I'm a fulltime workaholic back from vacation...</font id=size1></font id=purple></center> |
|
|
|
blkrogue
New Member
USA
79 Posts |
Posted - 18 August 2000 : 10:00:26
|
Is it possible to get the statistics on top of your page (as with alot of categories and fora, always having to move to the bottom of default.asp isn't very usefull.
Blkrogue
In the darkness of my soul a sparkling light has appeared |
|
|
|
Rigger82
Junior Member
USA
311 Posts |
Posted - 18 August 2000 : 10:03:43
|
I married the slash mod with the statistic mod and made it portable...
I am using it to promo the forums for my visitors on the main page.
It now shows the newest topics and then the stats for the forums so new users or older ones get a reminder when the visit.
Check it out and tell me what you think.
http://www.paratrooper.net/aotw
---------------------
Mark Christianson
Gulf War Veteran (82nd Airborne Division)
Owner/Operator of www.paratrooper.net
Rigger@paratrooper.net |
|
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 18 August 2000 : 11:00:51
|
very cool rigger, i'll be releasing a new version soon with new features and a little optimization of the code as well.. so be in the look out..
|
|
|
|
Rigger82
Junior Member
USA
311 Posts |
Posted - 18 August 2000 : 11:13:32
|
Thanks, I will wait to see what you've fixed up. Also, I have to figure out the SQL so I can get the result set to show not new TOPICS but say the top 3 most recently posted to topics. This way it would be a little more dynamic and change as users posted to different forums.
Might even create an option to show all these stats.. a "change view type" link
1. Last few topics (by date)
2. Most recently posted too topics (by date of reply)
3. Hottest topics (by number of replies)
---------------------
Mark Christianson
Gulf War Veteran (82nd Airborne Division)
Owner/Operator of www.paratrooper.net
Rigger@paratrooper.net
Edited by - Rigger82 on 18 August 2000 11:15:15 |
|
|
|
Topic |
|
Topic Locked
