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

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 Hover preview of post message.		  New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 01 May 2008 :  17:04:05  Show Profile  Reply with Quote
Here, for those who wanted the code in color/bold:

http://98.25.191.199/changes.htm<
Edited by - Carefree on 30 May 2008 21:31:44
Go to Top of Page

Andy Humm
Average Member

United Kingdom
908 Posts
Posted - 01 May 2008 :  18:55:56  Show Profile  Reply with Quote
cool<
Go to Top of Page

texanman
Junior Member

United States
410 Posts
Posted - 01 May 2008 :  22:54:23  Show Profile  Reply with Quote
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.<
Edited by - texanman on 01 May 2008 22:55:01
Go to Top of Page

texanman
Junior Member

United States
410 Posts
Posted - 02 May 2008 :  10:23:53  Show Profile  Reply with Quote
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?<
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 19 May 2008 :  04:35:08  Show Profile  Reply with Quote
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.<
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts
Posted - 19 May 2008 :  15:33:30  Show Profile  Visit AnonJr's Homepage  Reply with Quote
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.<
Go to Top of Page

SiSL
Average Member

Turkey
671 Posts
Posted - 19 May 2008 :  17:08:16  Show Profile  Visit SiSL's Homepage  Reply with Quote
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...<
CHIP Online Forum

My Mods
Select All Code | Fix a vulnerability for your private messages | Avatar Categories W/ Avatar Gallery Mod | Complaint Manager
Admin Level Revisited | Merge Forums | No More Nested Quotes Mod
Edited by - SiSL on 19 May 2008 17:26:44
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000 Version 3.4.07