| Author |
 Topic  |
|
rick7165
Senior Member
USA
1094 Posts |
 Posted - 03 April 2001 : 23:54:00
|
Richard...
Any way to get the persons Avatar to show up in their profile?
and if they don't have one just a blank?
Test Site
www.eastpasco.com
Running on HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser. |
 |
|
|
big9erfan
Average Member
540 Posts |
Posted - 04 April 2001 : 01:29:28
|
For those interested in the additional mod Rick ( see above ) mentioned
After line 159 ( about there that is )
<% end if ' strPicture %>
Insert this code
<% '################avatar mod #######################'%>
<% if Trim(rs("M_AVATAR_URL")) <> "" and lcase(rs("M_AVATAR_URL")) <> "noavatar.gif" and (IsNull(rs("M_AVATAR_URL")) = false) then
'## Forum_SQL - Get Avatar Settings from DB
strSql = "SELECT " & strTablePrefix & "AVATAR2.A_WSIZE"
strSql = strSql & ", " & strTablePrefix & "AVATAR2.A_HSIZE"
strSql = strSql & ", " & strTablePrefix & "AVATAR2.A_BORDER"
strSql = strSql & " FROM " & strTablePrefix & "AVATAR2"
set rsav = my_Conn.Execute (strSql) %>
<tr>
<td align=center bgcolor="<% =strCategoryCellColor %>" colspan="2"><b><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strHeadFontColor %> "> My Avatar </font></b></td>
</tr>
<tr>
<td bgColor=<% =strPopUpTableColor %> align=center colspan="2">
<img src="<% =rs("M_AVATAR_URL") %>" align="absmiddle" width=<% =rsav"A_WSIZE") %> height=<% =rsav("A_HSIZE") %> border=<% =rsav("A_BORDER") %> hspace="0" ><% set rsav = nothing %><% end if %>
</td>
</tr>
<% '################avatar mod #######################'%>
that's it
http://www.ugfl.net/forums |
|
|
|
Id
Junior Member
USA
129 Posts |
Posted - 04 April 2001 : 17:03:21
|
quote:
You are probably missing the following code(in red) in the SQL statement around line 800 in pop_profile.asp. It's the SQL statement for the case "goModify"
strsql = strsql & ", " & strMemberTablePrefix & "MEMBERS.M_PHOTO_URL "
strsql = strsql & ", " & strMemberTablePrefix & "MEMBERS.M_AVATAR_URL"
If it's not there, just add it and it should solve your problem.
BabyGate
http://forum.g4systems.net/babygate/
Edited by - babygate on 03 April 2001 23:10:48
nah, that's not it, i double-checked that line of code is there, it's not a problem of the avatar showing up, it's just a problem of it not remembering my preference everytime I go edit my profile
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 04 April 2001 : 17:25:12
|
| If you e-mail me your pop_profile.asp file I'll take a look at it. |
|
|
|
Id
Junior Member
USA
129 Posts |
Posted - 04 April 2001 : 18:15:34
|
quote:
If you e-mail me your pop_profile.asp file I'll take a look at it.
is on it's way, thanks 
|
|
|
|
Rmagddon
Starting Member
11 Posts |
Posted - 07 April 2001 : 12:05:49
|
when I was installing I got this, and I was wondering what it is trying to tell me.
Any help would be helpful.
--------------------------------------------------------------------------------
Avatar Mod v2.0
Creating table(s)...
CREATE TABLE FORUM_AVATAR( A_ID int COUNTER NOT NULL , A_URL text (255) NULL , A_NAME text (50) NULL , A_MEMBER_ID int NULL DEFAULT 0)
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_AVATAR2( A_HSIZE int NULL , A_WSIZE int NULL , A_BORDER int NULL )
Table created succesfully
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_AVATAR2 (A_HSIZE, A_WSIZE, A_BORDER) VALUES (64, 64, 0)
Value(s) updated succesfully
--------------------------------------------------------------------------------
Adding Column...
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_AVATAR_URL text (255) NULL
Column added successfully
Table(s) updated
--------------------------------------------------------------------------------
There were errors please post a question in the MOD Implementation Forum at
Snitz Forums
Edited by - Rmagddon on 07 April 2001 12:06:41 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 07 April 2001 : 12:16:13
|
| If you change your strConnString from the one labeled as Access 97 to the one labeled as Access 2000 you won't get that error. |
|
|
|
Rmagddon
Starting Member
11 Posts |
Posted - 07 April 2001 : 12:24:11
|
Thanks, that did the trick.
One other ?, can I set it up so that my members can enter a URL to an image that I have not setup as a Avatar? |
|
|
|
Rmagddon
Starting Member
11 Posts |
Posted - 07 April 2001 : 17:16:58
|
| Sry, but one more ?, can I change the max size of the images? |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 07 April 2001 : 17:26:07
|
The code for the size selection is in admin_avatar_settings.asp on line #'s 129 - 142. You can either change the existing values or add more values if you like.
On your question about the URL, this MOD was made to eliminate the need for the user to enter a URL for the Avatar. |
|
|
|
mbuchsbaum
Starting Member
1 Posts |
Posted - 14 April 2001 : 17:08:40
|
I noticed the mod_dbsetup.asp file uses the FSO component. My host does not have FSO enabled.
Is it possible to make the database changes another way? Possibly by manually editing the db...and if so, do you have the changes written out?
Thanks,
Michael
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
|
bjlt
Senior Member
1144 Posts |
Posted - 15 April 2001 : 05:04:51
|
would you kindly provide an alternative download link for this mod also?
Well, i'd also suggest that mod author asign version number for their mods, and note down changes in the beginning of readme and in the first message of the post. hence implementors would know if they are downloading the current version, esp when they download it from other site than the original author's.
TIA.
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 15 April 2001 : 05:14:46
|
| Alternate download link added to the Topic of this thread. |
|
|
|
blackinwhite
Average Member
Turkey
657 Posts |
Posted - 15 April 2001 : 07:05:23
|
I made all the changes to the files admin_home.asp ,inc_profile.asp,pop_profile.asp,register.asp,topic.asp .and the tabes were created succesfully. But I don't see any changes in topic.asp and other files. Did I miss something?
|
|
|
|
Topic |
|
Topic Locked
