| 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.< |
