|
To achieve this in the SQL version you should go...
forum_topics.asp
where it says: <tr> <td align="left" class="bold"><img src="<% = strImagePath %>open_folder_icon.gif" border="0" align="absmiddle"> <a href="default.asp" target="_self" class="boldLink"><% = strMainForumName %></a><% Response.Write(strNavSpacer)
should say: <tr> <td align="left" class="bold"><img src="<% = strImagePath %>open_folder_icon.gif" border="0" align="absmiddle"> <a href="default.asp" target="_self" class="boldLink"><% = strMainForumName %></a> </tr> <tr> <td align="left" class="bold"> <img src="<% = strImagePath %>open_folder_icon.gif" border="0" align="absmiddle" class="boldLink"> <a href="default.asp?C=<% =rsForum("Cat_ID") %>" target="_self" class="boldLink"><% = rsForum("Cat_Name") %></a> </tr> <tr> <td align="left" class="bold"> & ; ; ;nbsp; <img src="<% = strImagePath %>open_folder_icon.gif" border="0" align="absmiddle" class="boldLink"> <%
'Response.Write(strNavSpacer)
------------------------------
forum_posts.asp
where it says: <tr> <td align="left" width="95%" class="bold"><img src="<% = strImagePath %>open_folder_icon.gif" border="0" align="absmiddle"> <a href="default.asp" target="_self" class="boldLink"><% = strMainForumName %></a><% Response.Write(strNavSpacer)
should say: <tr> <td align="left" width="95%" class="bold"><img src="<% = strImagePath %>open_folder_icon.gif" border="0" align="absmiddle"> <a href="default.asp" target="_self" class="boldLink"><% = strMainForumName %></a> </tr> <tr> <td align="left" class="bold"> <img src="<% = strImagePath %>open_folder_icon.gif" border="0" align="absmiddle" class="boldLink"> <a href="default.asp?C=<% =rsPost("Cat_ID") %>" target="_self" class="boldLink"><% = rsPost("Cat_Name") %></a> </tr> <tr> <td align="left" class="bold"> & ; ; ;nbsp; <img src="<% = strImagePath %>open_folder_icon.gif" border="0" align="absmiddle" class="boldLink"> <% 'Response.Write(strNavSpacer)
----------------------------
Stored Procedures changes:
wwfSpThreadDetails should be: CREATE PROCEDURE [dbo].[wwfSpThreadDetails] (@lngTopicID int) AS SELECT tblTopic.*, tblThread.*, tblAuthor.Username, tblAuthor.Homepage, tblAuthor.Location, tblAuthor.No_of_posts, tblAuthor.Join_date, tblAuthor.Signature, tblAuthor.Active, tblAuthor.Avatar, tblAuthor.Avatar_title, tblGroup.Name, tblGroup.Stars, tblGroup.Custom_stars, tblCategory.Cat_ID, tblCategory.Cat_Name FROM tblTopic, tblThread, tblAuthor, tblGroup, tblForum, tblCategory WHERE tblTopic.Topic_ID = tblThread.Topic_ID AND tblAuthor.Author_ID = tblThread.Author_ID AND tblAuthor.Group_ID = tblGroup.Group_ID AND tblTopic.Topic_ID = @lngTopicID AND tblForum.Forum_ID = tblTopic.Forum_ID AND tblCategory.Cat_ID = tblForum.Cat_ID ORDER BY tblThread.Message_date ASC; GO
------
wwfSpForumsAllWhereForumIs should be: CREATE PROCEDURE [dbo].[wwfSpForumsAllWhereForumIs] ( @intForumID int ) AS SELECT tblForum.*, tblCategory.Cat_Name, tblCategory.Cat_Id FROM tblForum INNER JOIN tblCategory ON tblForum.Cat_ID = tblCategory.Cat_ID WHERE Forum_ID = @intForumID; GO
|