Web Wiz Forums Modifications

Print Page | Close Window

Top 10 Poster

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums Modifications
Forum Description: Mod's and Add-on's for Web Wiz Forums.
URL: https://forums.webwiz.net/forum_posts.asp?TID=24884
Printed Date: 28 March 2026 at 10:56am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Top 10 Poster

Posted By: true_king
Subject: Top 10 Poster
Date Posted: 24 November 2007 at 8:21am

how to see top ten poster?

Replies:

Posted By: Gleedo
Date Posted: 25 November 2007 at 5:35pm

Click on MemberList and then sort by Posts

Posted By: madmojo
Date Posted: 08 October 2008 at 3:08pm

<%
Set baglanti=Server.CreateObject("ADODB.connection" )
baglanti.Open "driver={microsoft access driver (*.mdb)}; DBQ=" &Server.MapPath("dbpath/mdnname.mdb" )
SQL="select * from tblAuthor ORDER BY No_of_posts desc"
Set kayitseti = baglanti.Execute(SQL)
i=1
Do While i<31 and not kayitseti.Eof
%>
<%=kayitseti("Username")%>  <%=kayitseti("No_of_posts")%> <br>
<% kayitseti.Movenext
i=i+1
Loop
kayitseti.Close
baglanti.Close %>

-------------
http://www.avsaadasi.ws - Avşa Adası

http://www.avsa.ws - Avşa

Posted By: madmojo
Date Posted: 08 October 2008 at 3:12pm

New User :

<%
Set baglanti=Server.CreateObject("ADODB.connection" )
baglanti.Open "driver={microsoft access driver (*.mdb)}; DBQ=" &Server.MapPath("dbpath/dbname.mdb" )
SQL="select * from tblAuthor ORDER BY Author_ID desc"
Set kayitseti = baglanti.Execute(SQL)
i=1
Do While i<31 and not kayitseti.Eof
%>

<%=kayitseti("Username")%><br>

<% kayitseti.Movenext
i=i+1
Loop
kayitseti.Close
baglanti.Close %>

-------------
http://www.avsaadasi.ws - Avşa Adası

http://www.avsa.ws - Avşa

Posted By: Scotty32
Date Posted: 09 October 2008 at 6:16pm

For MS Access and MSSQL you can just do:

SQL="select top 10 * from tblAuthor ORDER BY No_of_posts desc"

For MySQL you can do this:

SQL="select * from tblAuthor ORDER BY No_of_posts desc limit 0,10"

10 being the number of users you wish to display. Though if you are displaying them in forum pages (eg ones that include "common.asp") then you do not need to connect to the database and can just use adoCon and rsCommon

-------------
S2H.co.uk - http://www.s2h.co.uk/wwf/" rel="nofollow - WebWiz Mods and Skins

For support on my mods + skins, please use http://www.s2h.co.uk/forum/" rel="nofollow - my forum .