| Author |
 Topic  |
|
SiSL
Average Member
Turkey
671 Posts |
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
SiSL
Average Member
Turkey
671 Posts |
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
SiSL
Average Member
Turkey
671 Posts |
|
|
modifichicci
Average Member
Italy
787 Posts |
 Posted - 28 September 2005 : 08:34:56
|
quote:
it is Avatar Category ID determining Avatar to be in which category and it is in AVATAR table.
This is the dbs file, but I don't see the command to create AC_ID in AVATAR, it is create in AVATARS_CATS.
Where I am wrong?
[CREATE]
AVATAR_CATS
AC_ID
AC_NAME#varchar (255)#NULL#
AC_STATUS#int#NULL#0
[END]
[ALTER]
AVATAR
ADD#A_CATID#int#NULL#1
[END]
[INSERT]
AVATAR_CATS
(AC_NAME,AC_STATUS)#('Misc','0')
[END]
[UPDATE]
AVATAR
(AC_ID)#('1')
[END]< |
Ernia e Laparocele
Forum di Ernia e Laparocele
Acces - MySql Migration Tutorial
Adamantine forum |
 |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 28 September 2005 : 08:47:45
|
The last 4 lines of that dbs adds the AC_ID field to the AVATAR table.
< |
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 28 September 2005 : 12:20:52
|
You're welcome 
< |
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
SiSL
Average Member
Turkey
671 Posts |
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
SiSL
Average Member
Turkey
671 Posts |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 29 September 2005 : 06:26:54
|
Whoa! I must've been looking at that dbs completely wrong! 
< |
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
Gort
New Member
84 Posts |
Posted - 21 April 2006 : 16:03:03
|
Great MOD!
But your text colors are off - you're defining <td> bgcolor as category background but you're not using category background font color.....
I fixed it by replacing strDefaultFontColor with strCategoryfontcolor where ever the the TD bgcolor was strCategoryCellColor< |
Edited by - Gort on 21 April 2006 16:13:58 |
|
|
|
Gort
New Member
84 Posts |
Posted - 21 April 2006 : 19:13:19
|
I found another problem....my avatars aren't uploading correctly.
For some reason, the strCatID is not making its way into my sql statement. response.write on the statements gives the following:
INSERT INTO FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_CATID) VALUES ('avatars/batman1.jpg', 'batman1', 0, )
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
/board/avatar_upload.asp, line 201
Does anyone have any ideas?
< |
|
|
|
shaggy073077
Starting Member
29 Posts |
Posted - 15 March 2013 : 10:41:45
|
Can somebody tell me what I'm doing wrong.
Microsoft VBScript compilation error- Error '800a0409'
Unterminated string constant
/inc_avatar.asp, line 159
Response.Write "')"">
---------------------^
The problem lies in inc_avatar.asp which the part of the inc_avatar.asp file it's talking about is:
<br>
<%
else
Response.Write "<p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>You must register first, login and then edit profile to select avatar.</font></p>" & vbNewline
end if
Response.Write "<br><p>" & vbNewLine & _
"<input value=""Galeri"" name=""gallery"" type=""button"" onclick=""openWindow3('pop_avatar_gallery.asp?mode=" & Request.Querystring("mode") & ""
if Request.Querystring("mode") <> "Register" then
Response.Write "&member=" & rs("Member_ID") & "&avatar=" & rs("M_AVATAR_URL") & "#" & rs("M_AVATAR_URL")
end if
Response.Write "')"">
%>
<!--#INCLUDE file="inc_footer_short.asp" -->
Any help? |
|
|
|
Topic |
|
MOD: Avatar Categories W/ Avatar Gallery
