I decided that DoraMoon's avatar addon was a little much more than I wanted. I want my members able to add, review, edit, and delete their own avatars using Hamlin's avatar mod that I have been using since it came out for version 3.4.
I'm not sure that it will work totally like I want but I have been able to copy all the admin files and make new ones that registered members are able to access. I revised the add_avatar.asp so that they are able to add there own. My problem is getting the code right so that when members view the review_avatar.asp they see ONLY their avatars and NOT all avatars in the DB. Can some please help with this coding issue?
This should work for that you want it to do, although I haven't tested it. I assume that AVATAR.A_MEMBER_ID is the memberid of the member who uploaded the avatar. If not, then the following will not work.
This should work for that you want it to do, although I haven't tested it. I assume that AVATAR.A_MEMBER_ID is the memberid of the member who uploaded the avatar. If not, then the following will not work.
Everything with this modification is working smoothly except one last thing that I can't pin-point. How do I change the drop down menu in add_avatar.asp and edit_avatar.asp to just be the member viewing the page? I don't need a drop down menu for all members but for the member viewing the page. I have attached my add_avatar.asp which is modified.
I cannot guarantee that this will work, but I think it will. Locate the sql-query which gets all members (lines 142-145), and replace it with the following:
'## Forum_SQL - Get all members
strSql = "SELECT MEMBER_ID, M_NAME FROM " & strMemberTablePrefix & "MEMBERS WHERE M_NAME <> 'n/a'"
if mLev < 4 then
strSql = strSql & " AND MEMBER_ID = " & MemberID
end if
strSql = strSql & " ORDER BY M_NAME ASC;"
'response.write(strSql)
'response.end
Topic Locked
Posted - 04 February 2004 : 19:48:19
