| Author |
 Topic  |
|
|
007Cheater
Starting Member
USA
2 Posts |
 Posted - 28 May 2001 : 00:44:07
|
This makes the picture that you put in under your profile appear under your name. This is very basic and I used most of the avatar. This is the kind of addon I needed so I modified it.
Credits go out to Richard Kinser for creating the avatar addon.
Check out the DEMO http://la.homeip.net/cheatlist/forums/topic.asp?TOPIC_ID=3&FORUM_ID=2&CAT_ID=3&Topic_Title=Current Issues%21&Forum_Title=General Discussion
*******************************
In the file: TOPIC.ASP *
*******************************
Below this line:
----------------
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_COUNTRY, "
Add this line:
--------------
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_PHOTO_URL, "
Below this line:
----------------
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_POSTS, " & strMemberTablePrefix & "MEMBERS.M_COUNTRY, "
Add this line:
--------------
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_PHOTO_URL, "
look for this code: (it will appear twice)
-------------------------------------------
<br>
<br><font color="<% =strForumFontColor %>" face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>"><small><% =rs("M_COUNTRY") %></small></font>
<br><font color="<% =strForumFontColor %>" face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>"><small><% =rs("M_POSTS") %> Posts</small></font></td>
replace the line that has just the <br> on it with this: (do this for both instances of the above code)
<br><% if Trim(rs("M_PHOTO_URL")) <> "" and lcase(rs("M_PHOTO_URL")) <> "no_photo.gif" and (IsNull(rs("M_PHOTO_URL")) = false) then %>
<% '## Forum_SQL - Get Avatar Settings from DB
strSql = "SELECT " & strTablePrefix & "MEMBERS.M_PHOTO_URL"
strSql = strSql & " FROM " & strTablePrefix & "MEMBERS"
set rsav = my_Conn.Execute (strSql) %>
<img src="<% =rs("M_PHOTO_URL") %>" align="absmiddle" width="110" height=110 border=0 hspace="0"><% set rsav = nothing %><% end if %>
Edited by - 007Cheater on 28 May 2001 00:46:27
Edited by - 007Cheater on 28 May 2001 00:46:54 |
|
|
giorgius
Starting Member
Italy
17 Posts |
Posted - 30 May 2001 : 06:26:02
|
Great!!! it works very, very, very well!!!
Giorgius! |
 |
|
|
Ribkick
Junior Member
USA
296 Posts |
Posted - 30 May 2001 : 09:57:53
|
 I've been looking for this type of Mod for awhile now but it didn't work for me. Got a black band all the way across the page where the reply text would go.
I'd really like this to work...any ideas?
|
|
|
|
Ribkick
Junior Member
USA
296 Posts |
Posted - 30 May 2001 : 10:29:51
|
In rereading your notes, do I have to have the avatar mod installed for this to work? If so, that's my problem.
|
|
|
|
big9erfan
Average Member
540 Posts |
Posted - 30 May 2001 : 11:12:40
|
Rib,
From the code he posted he's not using any info from the avatars mod, simply the idea behind it.
Check the code again, you probably just missed a line and copied over 1 too many or 1 too few.
http://www.ugfl.net/forums |
|
|
|
Ribkick
Junior Member
USA
296 Posts |
Posted - 30 May 2001 : 15:12:15
|
Yep, you were right again Big9, Thanks 
|
|
|
|
big9erfan
Average Member
540 Posts |
|
|
3dcandy
Starting Member
39 Posts |
Posted - 02 June 2001 : 19:24:51
|
Nice work - implemented it fine, just it resizes the pictures (using the browser) and some images look a little crappy!
|
|
|
|
racerslounge
Starting Member
23 Posts |
Posted - 06 June 2001 : 01:11:28
|
Is there a way to set the image as a percentage of the linked image, with say a maximum size limit. That way, each image could change shape a little, and the images wouldn't show up distorted?
http://www.racerslounge.com |
|
|
|
boffers
Starting Member
48 Posts |
Posted - 15 June 2001 : 15:03:18
|
yeah, is there?
|
|
|
|
big9erfan
Average Member
540 Posts |
|
|
boffers
Starting Member
48 Posts |
|
| |
Topic |
|
Topic Locked
