Top 10 users |
Post Reply | Page 123> |
Author | ||
macpack
Newbie Joined: 19 Jun 2009 Status: Offline Points: 38 |
Topic: Top 10 users Posted: 18 Oct 2009 at 5:25pm |
|
Is it possible you can help me with some .asp programmering.?
I need a code to place on my site so i can show.
Alltime Top 10 thread writers
Month Top 10 thread writers
Is it something you can make bro.?
|
||
slog
Newbie Joined: 15 Sep 2009 Status: Offline Points: 7 |
Posted: 19 Oct 2009 at 7:18am | |
This sounds very nice, let me know if you get anything on that.
I've searching webwizguide foruns for something like that, but they only have tips on how to modificate from top 10 active topics to top 10 users, but it never mention a monthly thing... Here are some links. |
||
Matt
Admin Group Joined: 07 Feb 2003 Location: Manchester, UK Status: Offline Points: 195 |
Posted: 19 Oct 2009 at 1:27pm | |
Overall Top 10 Posters is very easy to do as you can use the Post_Count that is already set in the tblAuthor table.
How ever, Top 10 Posters this month would be difficult since you would need to loop through the Members and some how count all the posts they have made that month at the same time. I will post the code for Overal Top 10 later, but I may need to get back to you about the Monthly one. |
||
macpack
Newbie Joined: 19 Jun 2009 Status: Offline Points: 38 |
Posted: 21 Oct 2009 at 6:05am | |
Okey its perfect anyway scotty.
A Overal top 10 posters, whould also be very nice to start with fore me..
Hope to hear from you as soon as possible.
|
||
macpack
Newbie Joined: 19 Jun 2009 Status: Offline Points: 38 |
Posted: 23 Oct 2009 at 3:50am | |
Hey Scotty, is it possible you can fix that overall top 10 posters this week.?
|
||
macpack
Newbie Joined: 19 Jun 2009 Status: Offline Points: 38 |
Posted: 29 Oct 2009 at 4:15am | |
any news scotty..
Maybe its possible it can goes faster, if i can donate some money each time am searching for a new little script or so mate.?
|
||
Matt
Admin Group Joined: 07 Feb 2003 Location: Manchester, UK Status: Offline Points: 195 |
Posted: 30 Oct 2009 at 11:14am | |
You can donate an amount you feel apropriate by using the link on the Web Wiz Forums Modifications page Add the following in a code block before the head of your page:
Add the following where you want the top 10 posters to appear:
The above code assumes you are adding it to an existing page on your forum and are using MSSQL Server for the database. |
||
macpack
Newbie Joined: 19 Jun 2009 Status: Offline Points: 38 |
Posted: 01 Nov 2009 at 2:37pm | |
I get this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [MySQL][ODBC 3.51 Driver][mysqld-5.1.30-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '10 tblAuthor.Author_ID, tblAuthor.Username FROM tblAuthor ORDER BY tblAuthor.No_' at line 1 /mf-top-posters.asp, line 13 But am useing mysql, is that a problem or am i doing something wrong mate.?
|
||
Matt
Admin Group Joined: 07 Feb 2003 Location: Manchester, UK Status: Offline Points: 195 |
Posted: 01 Nov 2009 at 3:44pm | |
Change the SQL to:
|
||
macpack
Newbie Joined: 19 Jun 2009 Status: Offline Points: 38 |
Posted: 02 Nov 2009 at 4:27pm | |
hey again scotty,
now i have changed the strSQL line, but now it says:
Microsoft VBScript runtime error '800a01f4' Variable is undefined: 'blnNoMembers' /mf-top-posters.asp, line 17 |
||
Post Reply | Page 123> |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.078 seconds.