New Posts New Posts RSS Feed - Top 10 users
  FAQ FAQ  Forum Search   Register Register  Login Login

Topic ClosedTop 10 users

 Post Reply Post Reply Page  <123
Author
macpack View Drop Down
Newbie
Newbie


Joined: 19 Jun 2009
Status: Offline
Points: 38
Direct Link To This Post Posted: 30 Nov 2009 at 11:16am
slog: So far so good, i have now declared all the Dim it needed:
Dim blnNoMembers
Dim saryMembers
Dim intMembersFirst
Dim intMembersLast
Dim intMembersCount
Dim iLoop
Dim intAuthorID
Dim strAuthorName
 
See my test page here:
 
It seams to work now..
But can you tell me how to each users total number of post after the nick name.?
Back to Top
slog View Drop Down
Newbie
Newbie


Joined: 15 Sep 2009
Status: Offline
Points: 7
Direct Link To This Post Posted: 01 Dec 2009 at 7:25am
Great macpack!!!

To show the total number of posts of each member you will need to add few lines again...

You may want to declare another variable:

Dim intAuthorNoOfPosts

Then you have to change your sql string on line 72.

strSQL = "SELECT " & strDbTable & "Author.Author_ID, " & strDbTable & "Author.Username, " & strDbTable & "Author.No_of_posts FROM " & strDbTable & "Author ORDER BY " & strDbTable & "Author.No_of_posts DESC LIMIT 0,10;"

Then you will need to add more lines here around line 675.

for iLoop = intMembersFirst to intMembersLast


 
                    intAuthorID        = saryMembers(0, iLoop)


                    strAuthorName        = saryMembers(1, iLoop)


  intAuthorNoOfPosts  = saryMembers (2, iLoop)


            %><tr class="tableRow">


                <td>&nbsp;-&nbsp;<a rel="nofollow" href="member_profile.asp?PF=<%=intAuthorID%>"><%=strAuthorName%> - <%=intAuthorNoOfPosts%></a></td>


            </tr><%

Hope it works now.
Back to Top
macpack View Drop Down
Newbie
Newbie


Joined: 19 Jun 2009
Status: Offline
Points: 38
Direct Link To This Post Posted: 02 Dec 2009 at 6:02am
slog: Thanks it all works like it should now..
Back to Top
slog View Drop Down
Newbie
Newbie


Joined: 15 Sep 2009
Status: Offline
Points: 7
Direct Link To This Post Posted: 04 Dec 2009 at 12:15pm
macpack, I am glad it works now.
Back to Top
 Post Reply Post Reply Page  <123
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.047 seconds.