Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Most Viewed Topics
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

wildfiction
Junior Member

167 Posts

Posted - 15 February 2006 :  15:39:15  Show Profile  Visit wildfiction's Homepage
Is there a way (or a MOD) that allows you to see the most viewed topics on a forum?

laser
Advanced Member

Australia
3859 Posts

Posted - 15 February 2006 :  15:44:54  Show Profile
Not that I can think of, but it wouldn't be too hard to write.
Go to Top of Page

CalloftheHauntedMaster
Junior Member

289 Posts

Posted - 19 February 2006 :  19:59:24  Show Profile
Actually, there is:
http://www.snitzbitz.com/mods/details.asp?Version=3.4&mid=148

It'll give you exactly what you want and is extremely easy to install.

This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums!
Go to Top of Page

bobby131313
Senior Member

USA
1163 Posts

Posted - 20 February 2006 :  00:37:03  Show Profile  Visit bobby131313's Homepage
I just intalled it, but I'm getting an error message starting with the last members seen section ...

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[MySQL][ODBC 3.51 Driver][mysqld-4.0.18-nt-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 '25 member_id, m_name, m_lastheredate FROM FORUM_MEMBERS ORDER B

/forum/member_stats.asp, line 253


I did some searching here, I couldn't find this exact situation, but found some similar ones. I think it has to do with the "SELECT TOP", I don't think that's valid for MySql. Looks like below, and appears 3 more times..

function DisplayLastSeen()
	dim rs
	set rs = server.CreateObject("adodb.recordset")
	
	strSql = "SELECT TOP " & intLastSeen & " member_id, m_name, m_lastheredate FROM " & strMemberTablePrefix & "MEMBERS ORDER BY M_LASTHEREDATE DESC"
	rs.Open strSql, my_Conn
	%>


I'm not sure how to fix it though.

Switch the order of your title tags

Edited by - bobby131313 on 20 February 2006 00:40:07
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 20 February 2006 :  03:05:19  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
Replace the lines

	strSql = "SELECT TOP " & intLastSeen & " member_id, m_name, m_lastheredate FROM " & strMemberTablePrefix & "MEMBERS ORDER BY M_LASTHEREDATE DESC"
	rs.Open strSql, my_Conn

with
	strSql = TopSQL("SELECT member_id, m_name, m_lastheredate FROM " & strMemberTablePrefix & "MEMBERS ORDER BY M_LASTHEREDATE DESC",intLastSeen)
	rs.Open strSql, my_Conn

My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz
Go to Top of Page

bobby131313
Senior Member

USA
1163 Posts

Posted - 20 February 2006 :  11:19:01  Show Profile  Visit bobby131313's Homepage
Thanks OWM! That worked great for that table. I'll go through and fix the other occurences and I should be good to go.

Thanks again!

Switch the order of your title tags

Edited by - bobby131313 on 20 February 2006 11:19:51
Go to Top of Page

bobby131313
Senior Member

USA
1163 Posts

Posted - 20 February 2006 :  11:48:08  Show Profile  Visit bobby131313's Homepage
Worked great. Fixed the other occurrences with no probs and I'm in business.

Thanks again!

Switch the order of your title tags

Edited by - bobby131313 on 20 February 2006 11:48:40
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.38 seconds. Powered By: Snitz Forums 2000 Version 3.4.07