New subject topic length - Is there a way to make - Web Wiz Support and Community Forums

Yes, there is. These are how to change it in SQL Server version:

FYI ~ you can only change code if you license permits it. Although, even in the free version, I would submit to WWF that this type of change should be deemed "acceptable" as long as adverts and copyrights are in place.

1) Determine the new length; current default is 70

2) Set the TYPE of the column Subject in the table tblTopic to nvarchar(NNN); where NNN is the new length.

NOTE: In SQL Server, when changing a database column type (or length), a dialog box will be presented noting that other tables will be affected. Click OK.

3) Make a copy of the file {forumRoot}/includes/message_form_inc.asp, then change the orig file message_form_inc.asp at line 139 by changing the maxlength value to the new length; and changing the size value:

<input type="text" name="subject" id="subject" size="75" maxlength="NNN"<% If strMode="editTopic" OR strMode = "editPoll" OR strMode="PM" Then Response.Write(" value=""" & strTopicSubject & """") %> tabindex="2" /><%

Note the green NNN above. Change the NNN to the new length MINUS 20. So, if you chose 150 as the new SQL table length, then set maxlength to 130. This will ensure that whatever is typed in by the user will fit into the database column.

Also note the red 75, this is changed from 30, as this is the size of the text field to display to the user.

Finally:

In all these files below, change the "41" and "50" to the new length.

{forumRoot}\edit_post.asp(137):strSubject = Trim(Mid(Request.Form("subject"), 1, 50))
{forumRoot}\email_messenger.asp(154): strSubject = Request.Form("subject")
{forumRoot}\move_post.asp(115): strNewTopicSubject = Request.Form("subject")
{forumRoot}\new_post.asp(150):strSubject = Trim(Mid(Request.Form("subject"), 1, 50))
{forumRoot}\pm_new_message.asp(125):strSubject = Trim(Mid(Request.Form("subject"), 1, 41))
{forumRoot}\pm_new_message_form.asp(131): strTopicSubject = Trim(Mid(Request.Form("subject"), 1, 41))
{forumRoot}\pop_up_topic_admin.asp(140): strSubject = Trim(Mid(Request.Form("subject"), 1, 50))
{forumRoot}\RTE_popup_link.asp(74): strSubject = Request.Form("subject")

MacSpudster

Edited by macspudster - 24 July 2007 at 6:29pm