Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 MOD: Latest Top 10 Messages

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!
Before posting, make sure you have read this topic!

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
balexandre Posted - 26 November 2007 : 01:49:37
continuing what I said in this topic about the "Show how many messages since yours" here is the Finished MOD that you can start use...


' **********************************************************************************************
' Author: Bruno Alexandre <bruno [dot] in [dot] dk [at] gmail [dot] com>
' Date: April 2007
' MOD: Get last 10 messages in the Forum
' Function: 
'   Displays vertically and horizontally the Top messages in the Forum
'   it turns user own message in a different color
' Versions: 
'   1.0	            Original version
'   1.1  26.11.07   Added more string to the translate part 
'   		    Added Rows and Columns in order to display
'   1.2  01.03.08   Added block preventing private messages to show
'   1.3  02.03.08   Updated with TopSQL() so it runs in mySQL as well (>4.x)
'
' **********************************************************************************************




How to use it
It's really simple, the MOD will build a table with Rows and Columns that you can specified in the 2 variables, the TOP messages displayed will be the multiplication of those 2 values, so if you specify 2 rows by 5 cols you will get the Top 10 messages in the forum, if you select 4 rows by 5 cols you will get the Top 20 messages in the forum.

There are more variables that you can play with, and the right translation as well using the Session.LCID variable in ASP.


How to get it
check it here to see the code

save as inc_topMessages.asp and just place the include where you need it like

<!-- #include file="inc_topMessages.asp" -->


How can I test it
you have this direct link that, by default shows you 2 rows by 5 columns, to use with more variations, I changed the code so you can use the query to pass how many rows and how many columns you want to be displayed...

so, instead of http://ga-paneuropean.com/gape.v2/test_topMessages.asp you can add ?rows=4&cols=2 to be like http://ga-paneuropean.com/gape.v2/test_topMessages.asp?rows=4&cols=2 so it will show you 4 rows by 2 columns.

Hope you like the MOD
.

Images so you can see what the mod does:






<
15   L A T E S T    R E P L I E S    (Newest First)
Jays Posted - 16 April 2010 : 09:06:16
Sorry, I had to remove it from my site, but thank you anyway.

I suspect I have an open tag somewhere

Jays
Jays Posted - 15 April 2010 : 08:57:57
Thank you for your response, here is a link to my site
http://newsthatsused.com/newsthatsused/aion/forum/
I am using Internet Explorer

I'm wondering if it has anything to do will the "select case session.lcid" which I have included below. The first part is written in Portuguese (I'm assuming).

select case session.lcid
case 2070 ' PT-pt
strTop10TopMsg = "Últimas " & cStr(TABLE_TYPE_TOP) & " mensagens!"
strTop10MsgBottomLink = "Últimos tópicos activos"
strTop10MsgTopic = "Tópico"
strTop10MsgBy = "por"
strTop10MsgIn = "em"
strTop10Error = "TABLE_TYPE_ROWS e/ou TABLE_TYPE_COLS não são um valor numerico!"
case else ' All the others
strTop10TopMsg = "Top " & cStr(TABLE_TYPE_TOP) & " messages!"
strTop10MsgBottomLink = "Active topics"
strTop10MsgTopic = "Topic"
strTop10MsgBy = "by"
strTop10MsgIn = "in"
strTop10Error = "TABLE_TYPE_ROWS and/or TABLE_TYPE_COLS are not a numeric value!"
end select

TIA
Jays
balexandre Posted - 14 April 2010 : 18:00:30
using Firebug in Firefox you can see what is going on.

I have no idea how Site Integration handles HTML, with no link and nothing more than your message, I have no idea how you think you should have help [:/]
Jays Posted - 13 April 2010 : 14:32:42
I would like to use this mod in the left hand side of Site Integration, but it throws my alignment to the right and about halfway over the screen.
Can anyone tell me how to fix this problem

TIA
Jays
richfed Posted - 17 October 2009 : 17:55:00
Balexandre -

Is there a way to eliminate this MOD from displaying any posts from a specific forum?

I have just installed MarcelG's blog MOD and would like to prevent blog posts from appearing. Blogs are posted in one specific forum and I would like to block it. What code would I use and where would I place it? Forum ID is "71".
pierretopping Posted - 06 July 2009 : 16:52:21
quote:
Originally posted by leesh695

I have tried this out,

http://www.hwaronecity.info/oriphan/forum/inc_topmessages.asp


Everytime I gives me this error.

Active Server Pages error 'ASP 0113'
Script timed out

/oriphan/forum/inc_topmessages.asp

The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.


Am i doing somthing wrong?<



Hi I' get the same timeout, did anybody get the fix for this great mod ?
balexandre Posted - 16 June 2009 : 18:05:29
I already replied him on his email, no feedback since
gjs Posted - 05 June 2009 : 16:36:47
Thanks for the suggestion - I'll try that now.

Regards,



Greg
Etymon Posted - 04 June 2009 : 20:56:17
You may want to contact the author of this via e-mail through his profile. He may not see your question as quickly as you are perhaps needing the help.
gjs Posted - 03 June 2009 : 15:47:38
Hello.

I am using this cool mod on my forum, but now also want to integrate the events calendar mod.

However, the posts that go in the events calendar also come up in the most recent messages.

Can you give some modified SQL to exclude the posts added to the events calendar from coming up in the top x messages?

Many Thanks,



Greg.
championc Posted - 08 April 2008 : 16:27:52
I worked it out - dead easy when it came down to it. I simply replaced the top line of the strsql from
sqlstr = "SELECT " & _
"a.CAT_ID, a.FORUM_ID, a.TOPIC_ID, a.T_SUBJECT, a.MSG_ID, a.MSG, a.MSG_DATE, a.MEMBER_ID, a.M_NAME " & _

to
sqlstr = "SELECT " & _
"a.CAT_ID, a.FORUM_ID, a.TOPIC_ID, a.T_SUBJECT, a.MSG_ID, a.MSG, a.MSG_DATE, a.MEMBER_ID, a.M_NAME, f.FORUM_ID, f.F_SUBJECT " & _

You can then use objRec.fields("F_SUBJECT") to retrieve the category description


C
<
championc Posted - 06 April 2008 : 18:36:18
Hi Bruno,

Super job. I have installed this against my mySQL installation and it worked perfectly first time.

I wonder if you have ever done a further mod to show the Forum Name - if not, what extra code would I need to do this. I know I would need to use the t.FORUM_ID to read the forum name (F_SUBJECT) from the forum_forum table


C
<
puzo Posted - 19 March 2008 : 17:02:57
Thank you, very useful.<
balexandre Posted - 14 March 2008 : 11:29:17
always glad to help the community<
kolucoms6 Posted - 13 March 2008 : 16:50:16
Worked.

Cool

Thanks for the Support.<

Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000 Version 3.4.07