|
rick7165
Senior Member
USA
1094 Posts |
 Posted - 17 April 2001 : 17:13:05
|
Add your photo to each topic posted
I had found on various forums that trying to see who written what was kinda diffacult when scrolling quickly through the
thread. By adding your picture to it will allow each topic be found more quickly by seeing your picture.
The only file that needs to be edited is topic.asp
Go to this section around the 200's AND the 400's. You can do a search for
strSql ="SELECT " & strMemberTablePrefix & "MEMBERS.M_NAME, "
add the following to each of them.
*********************************************************************************************
THIS IS ALREADY THERE --- You will add the following below (inside the ##)
*********************************************************************************************
<%
'## Forum_SQL - Get all topicsFrom DB
strSql ="SELECT " & strMemberTablePrefix & "MEMBERS.M_NAME, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_ICQ, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_YAHOO, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_AIM, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_TITLE, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.MEMBER_ID, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_Homepage, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_LEVEL, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_POSTS, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_COUNTRY, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_CITY, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_STATE, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_DATE, "
'################################ Add this line below, here ####################################
strsql = strsql & strMemberTablePrefix & "MEMBERS.M_PHOTO_URL, "
'################################ Add this line above, here ####################################
strSql = strSql & strTablePrefix & "REPLY.REPLY_ID, "
strSql = strSql & strTablePrefix & "REPLY.R_AUTHOR, "
strSql = strSql & strTablePrefix & "REPLY.TOPIC_ID, "
strSql = strSql & strTablePrefix & "REPLY.R_MESSAGE, "
strSql = strSql & strTablePrefix & "REPLY.R_DATE, "
strSql = strSql & strTablePrefix & "REPLY.R_MSGICON "
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS, " & strTablePrefix & "REPLY "
strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.MEMBER_ID = " & strTablePrefix & "REPLY.R_AUTHOR "
strSql = strSql & " AND TOPIC_ID = " & Request.QueryString("TOPIC_ID") & " "
strSql = strSql & " ORDER BY " & strTablePrefix & "REPLY.R_DATE"
-------------------------------------------------------------------------------------------------------------------------
Now we would like to search for this section:
Around line 300+ AND the 450+ you should see, or do a search for if strShowRank = 1 or strShowRank = 3 then
<% if strShowRank = 1 or strShowRank = 3 then %>
<br><font color="<% =strForumFontColor %>" face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>"><table style="filter:glow(color=red, strength=1)"><small><% = ChkString(getMember_Level(rs("M_TITLE"), rs("M_LEVEL"), rs("M_POSTS")),"display") %></small></table></font>
<% end if %>
<% if strShowRank = 2 or strShowRank = 3 then %>
<br><% badge() %>
<% end if %>
<br>
right after all of that add the following in both places:
(* NOTE *): You have two options: Option #1; If the user does not have a picture in their profile that it will
NOT display the picture: Option #2; It will display the no_photo.gif
Option #1:
<% if Trim(rs("M_PHOTO_URL")) <> "" and lcase(rs("M_PHOTO_URL")) <> "http://" and strPicture = 1 then %>
<img src="<% =rs("M_PHOTO_URL") %>" alt="<% =rs("M_NAME") %>" width="150" height="150" border=0 hspace="2" vspace="2">
<% end if %>
Option #2:
<% if Trim(rs("M_PHOTO_URL")) <> "" and lcase(rs("M_PHOTO_URL")) <> "http://" and strPicture = 1 then %>
<img src="<% =rs("M_PHOTO_URL") %>" alt="<% =rs("M_NAME") %>" width="150" height="150" border=0 hspace="2" vspace="2">
<% else %>
<img src="no_photo.gif" alt="No Photo Available" width="150" height="150" border=0 hspace="2" vspace="2">
<% end if %>
-------------------------------------------------------------------------------------------------------------------------
Test Site
www.eastpasco.com
Running on HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser.
Edited by - rick7165 on 17 April 2001 17:15:43 |
 |
|
Topic Locked
