Author |
Topic |
laser
Advanced Member
Australia
3859 Posts |
Posted - 12 April 2003 : 18:23:04
|
A new feature that I want to add to my forum is to calculate the monthly posting average by month, rather than since the person joined. I have already isolated some of the code needed, but has anyone done this before ?? (I hate to waste time re-inventing the rule).
Maybe this could be broken into :
- topics started - replies
The total of these being the Total Posts. Obviously once you have total posts then average is pretty easy to come up with.
Anyway, let me know, and I'll keep this thread updated with my progress. |
|
dayve
Forum Moderator
USA
5820 Posts |
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 12 April 2003 : 19:14:54
|
Thanks for that dayve, seems exactly what I'm after.
I couldn't see the last two pages because I wasn't logged in (and I don't agree with creating an id to do it), but could you provide those files for download, or just email thatm to me ? (TIA!).
This is what I love & hate about Snitz. I've been trying to find something to do for Snitz that isn't doen yet (to give something back), but every time I think of something it is already done - the beauty of this community I suppose. |
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 12 April 2003 : 20:33:06
|
creating an id?? you mean the method parameters? that's for a reason, if you could see the page you'd realize why. I'll get you the downloads here shortly. I am out the door this second for a dinner party.
you can try logging into my forum using snitz/snitz |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 13 April 2003 : 02:12:31
|
snitz/snitz is what I meant by creating in ad
Thanks for the download offer, have a good party. |
|
|
Ez4arab
Junior Member
479 Posts |
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 13 April 2003 : 16:33:28
|
dayve will setup a download, just give him some time. |
|
|
Ez4arab
Junior Member
479 Posts |
|
dayve
Forum Moderator
USA
5820 Posts |
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 13 April 2003 : 22:19:09
|
I just realized, I have a lot of "specific" coding to my forum in the members.asp, it may not work natively with your site. Let me know if you'd like help with it or perhaps you can review the code and figure out most of it yourself. |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 14 April 2003 : 07:21:21
|
Thanks dayve, got them now.
I will post any changes to this thread. |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 14 April 2003 : 08:06:32
|
members_top_poster_na.txt - straight out of the box PERFECTION
pop_top_20.asp error :
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/snitz3403/pop_top_20.asp, line 45
when trying to perform :
SELECT TOP 20 R_AUTHOR, M_NAME, MAX(R_POSTS) AS T_MAX, COUNT(R_AUTHOR) AS T_POSTS FROM (SELECT R_AUTHOR, M_NAME, R_DATE, R_POSTS FROM (FORUM_MEMBERS INNER JOIN FORUM_REPLY ON FORUM_MEMBERS.MEMBER_ID=FORUM_REPLY.R_AUTHOR) WHERE R_DATE LIKE '200304%' UNION SELECT T_AUTHOR, M_NAME, T_DATE, T_POSTS FROM (FORUM_MEMBERS INNER JOIN FORUM_TOPICS ON FORUM_MEMBERS.MEMBER_ID=FORUM_TOPICS.T_AUTHOR) WHERE T_DATE LIKE '200304%') GROUP BY R_AUTHOR,M_NAME ORDER BY Count(R_AUTHOR) DESC;
but I can't see what is wrong.
members.asp error :
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'AUGetOnlineMembers'
/snitz3403/members2.asp, line 103
where line 103 is :
arrOnlineMembers = AUGetOnlineMembers()
so I would guess that your AUGetOnlineMembers function has been changed, any chance of that code please ? |
Edited by - laser on 14 April 2003 09:08:37 |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 15 April 2003 : 17:05:37
|
dayve/anyone able to help here ?
I'm using Access, is that why the SQL doesn't work ? |
Edited by - laser on 15 April 2003 17:06:38 |
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 15 April 2003 : 23:57:51
|
function AUGetOnlineMembers()
strSql ="SELECT " & strTablePrefix & "ACTIVE_USERS.MEMBER_ID "
strSql = strSql & " FROM " & strTablePrefix & "ACTIVE_USERS "
set rsOnline = my_Conn.Execute(strSql)
AUGetOnlineMembers = rsOnline.GetRows()
rsOnline.close
set rsOnline = nothing
end function
^^^ looks like what it should be... I did not edit it.
I am using MSSQL2000 so I'm not quite sure if the UNION query needs some tweaking. let me take a closer look at things. |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 16 April 2003 : 06:42:32
|
Thanks dayve, I didn't have that function anywhere at all (I searched thru every file in the Snitz directory).
In the end I just added it in, but the next function that I'm missing is AUMemberStatusG can you supply the file that contains these functions please ?? (I think there will be a few more than this maybe ) |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 19 April 2003 : 18:29:38
|
BUMP
.. I hate bumping, but I have no other way of contacting dayve. |
|
|
Topic |
|