| T O P I C R E V I E W |
| TAF |
Posted - 11 January 2008 : 15:52:47
I have completed what I think is a great adjustment to Snitz.
The code adjustment allows users to hover over a topic title and view the first 200 characters of the post (or however many characters you want) in a 'title' box.
It works as a html title="Message of the Post..." in the <a> tag.
It adds about 4 snips of code to forum.asp, active.asp, and search.asp.
I will be happy to provide line numbers/code or full page code if anyone is interested in this. Please Email me if you would like the code posted.< |
| 15 L A T E S T R E P L I E S (Newest First) |
| SiSL |
Posted - 19 May 2008 : 17:08:16
I did it earlier for www.chip.com.tr/forum but thought getting entire post would be memory and CPU inefficient if long...
So I used that method:
1. CAST
2. RemoveHTML and forum codes
CAST is good feature in MS SQL (not sure if would work with others) such as:
CAST(T.T_MESSAGE AS nvarchar(100)) AS PREVMSG "
strSql2 = " FROM " & strMemberTablePrefix & "MEMBERS M, "
etc.
Then I get this into a function of removing HTML's inside along with quotes... Voila...
www.chip.com.tr/forum/CHIP-Online-Haber_f95.html" target="_blank">http://www.chip.com.tr/forum/CHIP-Online-Haber_f95.html
Edit: Interesting this URL is parsed weird...< |
| AnonJr |
Posted - 19 May 2008 : 15:33:30
If memory serves, it should be FormatStr() - which I believe is in inc_func_common.asp
I'm short on time at the moment, or I'd double-check.< |
| Carefree |
Posted - 19 May 2008 : 04:35:08
Is there a simple call we can insert in this that would use the code cleaner from func_common? All the forum code makes this unusable for me.< |
| texanman |
Posted - 02 May 2008 : 10:23:53
This Mod Screws up search.
Microsoft OLE DB Provider for SQL Server error '80040e14'
The ntext data type cannot be selected as DISTINCT because it is not comparable.
/search.asp, line 351
Line 351: rs.open strSql & strSql2 & strSql3 & strSql4, my_Conn, adOpenStatic
Did anyone else encounter similar error?< |
| texanman |
Posted - 01 May 2008 : 22:54:23
quote:
Originally posted by Carefree
Here, for those who wanted the code in color/bold:
http://24.168.209.249/changes.htm
active.asp"
L264: Remove strSql = strSql & (better yet remover all that line altogether). I thought that was part of the new code and it gave me errors when accessing new messages from active.asp.
Otherwise excellent job.< |
| Andy Humm |
Posted - 01 May 2008 : 18:55:56
cool< |
| Carefree |
Posted - 01 May 2008 : 17:04:05
Here, for those who wanted the code in color/bold:
http://98.25.191.199/changes.htm< |
| TAF |
Posted - 01 May 2008 : 14:04:54
My program doesn't mark bold for stuff, but you can find the changes by doing a search for ***** (since I marked the lines with comments that way)< |
| Andy Humm |
Posted - 20 January 2008 : 09:02:41
TAF Could you embold all the code in your three .txt files that have been changed for this great mod idea. It would be easier to see the changes. Thank you andy< |
| TAF |
Posted - 15 January 2008 : 19:44:17
I like that!
::Grabs code line and runs away with it::< |
| MarkJH |
Posted - 14 January 2008 : 16:24:20
I replaced the line
Topic_Message = LEFT(Replace(Replace("" & allActiveTopics(fT_MESSAGE,RowCount) & "","'","´"),"""","´´"),200) & "..."
with
Topic_Message = LEFT(Replace(Replace("" & allActiveTopics(fT_MESSAGE,RowCount) & "","'","#39;"),"""","#34;"),200) & "..."
and all seems fine now. It must have been some sort of encoding issue.  < |
| TAF |
Posted - 14 January 2008 : 15:24:58
This is the row that does the work getting the ' and " replaced with a character that doesn't try to break off the title="blablabla" area of the html. (example is the row from active.asp)
Topic_Message = LEFT(Replace(Replace("" & allActiveTopics(fT_MESSAGE,RowCount) & "","'","´"),"""","´´"),200) & "..."
In this area it replaces ' with ´ and " with ´´. I have never had a problem with it showing an 'A' in these areas, so I am thinking it must have something to do with poor font support in these cases. I am sure you could tell it to replace these with ` or with nothing.
The '200' in the line is what tells it how many characters to show. You could tell it to show more or less.
It uses the raw data from the post to create a html title block... that is why it shows the html and/or forum code. You could add to the replace functions and get it to remove these, but I didn't bother since it doesn't bother me to have a little html coding in there.< |
| kmac |
Posted - 12 January 2008 : 10:14:53
If the post begins with something other than text, i.e. a quote or image, the preview shows the HTML. Is this correct, or did I make a mistake somewhere? Perhaps a conflict with one of my other mods?< |
| MarkJH |
Posted - 12 January 2008 : 07:52:08
Great MOD!
One minor problem, though. When somebody puts a "'" in their post (i.e. I'm) it puts an "A" before it (i.e. IA'm). Any ideas?< |
| NiteOwl |
Posted - 11 January 2008 : 21:30:50
Really a very nice addition, thank you
< |
