Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 Member In Spotlight 3.4 - 3.4.02
 New Topic  Topic Locked
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 4

antracit
Starting Member

Sweden
33 Posts

Posted - 23 September 2002 :  04:31:36  Show Profile  Visit antracit's Homepage
Ok sorry
Some members put bad carracters in that feild. Not the http:// string ore the wrong adress..

johan
Go to Top of Page

@tomic
Senior Member

USA
1790 Posts

Posted - 23 September 2002 :  05:07:27  Show Profile  Visit @tomic's Homepage  Send @tomic an ICQ Message
Yes, bad addresses will mess it up unfortunately. i am editing them all the time.

@tomic

SportsBettingAcumen.com
Go to Top of Page

serverhacker
Junior Member

USA
125 Posts

Posted - 24 September 2002 :  03:52:35  Show Profile
Hello, @tomic

I am trying to setup your mod on my site I have 2 test sites, the one site has users with photos, and your mod works fine. The other test site only has admin with on photo. and I get this error:
----------------------------------------------------------------------------------------------------------------
ADODB.Recordset error '800a0bcd'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

/forum/include/member_spotlight.asp, line 26
----------------------------------------------------------------------------------------------------------------



this is what my "member_spotlight.asp" file looks like:
----------------------------------------------------------------------------------------------------------------
<%

Response.Write "<table width=""100%"" border=""0"" bordercolor=""" & strTableBorderColor & """ cellspacing=""1"" cellpadding=""0"" bgcolor=""" & strTableBorderColor & """>" & vbNewLine & _
"<tr>" & vbNewLine & _
"<td bgcolor=""" & StrHeadCellColor & """>" & vbNewLine & _
"<font size=""4"" color=""" & StrHeadFontColor & """> Member Spotlight</font>" & vbNewLine & _
"</td>" & vbNewLine & _
"</tr>" & vbNewLine & _
"<tr>" & vbNewLine & _
"<td align=""left"">" & vbNewLine & _
"<table width=""100%"" border=""0"" cellspacing=""0"" cellpadding=""0"" bgcolor=""" & strTableBorderColor & """>" & vbNewLine & _
"<tr>" & vbNewLine & _
"<td>" & vbNewLine

'START MEMBER IN SPOTLITE SCRIPT
function MemInSpot
set rsMemInSpot = Server.CreateObject("ADODB.Recordset")
strSql = "SELECT " & strTablePrefix & "MEMBERS.MEMBER_ID, " & strTablePrefix & "MEMBERS.M_PHOTO_URL, " & strTablePrefix & "MEMBERS.M_NAME, "
strSql = strSql & strTablePrefix & "MEMBERS.M_FIRSTNAME, " & strTablePrefix & "MEMBERS.M_LASTNAME, " & strTablePrefix & "MEMBERS.M_AGE"
strSql = strSql & " FROM " & strTablePrefix & "MEMBERS"
strSql = strSql & " WHERE FORUM_MEMBERS.M_PHOTO_URL <> ''"
rsMemInSpot.Open strSql, my_Conn,3,,adCmdText
Dim intRnd
Randomize Timer
intRnd = (Int(RND * rsMemInSpot.RecordCount))
rsMemInSpot.Move intRnd
strMemInSpot = rsMemInSpot("M_PHOTO_URL")
Response.Write " <tr><td align=center bgcolor=""" & strForumCellColor & """><br>" & vbCrLf & _
" <a href=""" & strForumURL & "pop_profile.asp?mode=display&id="& rsMemInSpot("member_id") & """><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><b>" & rsMemInSpot("M_NAME") & "</b></font></A><br><br>" & vbCrLf
if Trim(rsMemInSpot("M_PHOTO_URL")) <> "" and lcase(rsMemInSpot("M_PHOTO_URL")) <> "http://" then
if lcase(left(strMemInSpot,7)) = "http://" then
Response.write " <img src=" & ChkString(rsMemInSpot("M_PHOTO_URL"), "display") & vbCrLf
elseif lcase(left(strMemInSpot,7)) <> "http://" then
Response.write " <img src=" & strForumURL & "images/" & ChkString(rsMemInSpot("M_PHOTO_URL"), "display")& vbCrLf
end if
Response.write " alt=" & ChkString(rsMemInSpot("M_NAME"),"display")& vbCrLf & _
" width=""120"" height=""120"" border=""0"" hspace=""0"" vspace=""4""></a><br>" & vbCrLf
else
Response.Write getCurrentIcon(strIconPhotoNone,"No Photo Available","hspace=""0"" vspace=""4""") & "<br>" & vbCrLf _
end if
Response.Write " <table><td><a href=""" & strForumURL & "pop_profile.asp?mode=display&id="& rsMemInSpot("member_id") & """><img SRC=""" & strImageURL & "icon_member.gif"" border=""0""></A></td><td nowrap><a href=""" & strForumURL & "pop_profile.asp?mode=display&id="& rsMemInSpot("member_id") & """><font face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """>" & rsMemInSpot("M_NAME") & "'s Profile</font></A></td></table>" & vbCrLf
Response.Write " </td></tr>"
rsMemInSpot.Close
Set rsMemInSpot = Nothing
end function
'END MEMBER IN SPOTLITE SCRIPT

call MemInSpot

Response.Write "</td>" & vbNewLine & _
"</tr>" & vbNewLine & _
"</table>" & vbNewLine & _
"</td>" & vbNewLine & _
"</tr>" & vbNewLine & _
"</table>" & vbNewLine

%>
----------------------------------------------------------------------------------------------------------------

Any help would be great

Go to Top of Page

@tomic
Senior Member

USA
1790 Posts

Posted - 24 September 2002 :  04:20:08  Show Profile  Visit @tomic's Homepage  Send @tomic an ICQ Message
This was made specifically to show profiles with photos so i am not at all surprised by the error.

Try it with this line removed:

strSql = strSql & " WHERE FORUM_MEMBERS.M_PHOTO_URL <> ''"

@tomic

SportsBettingAcumen.com
Go to Top of Page

serverhacker
Junior Member

USA
125 Posts

Posted - 24 September 2002 :  13:29:52  Show Profile
Thanks, @tomic

That fixed it
Go to Top of Page

al_iguana
Junior Member

138 Posts

Posted - 28 September 2002 :  04:19:04  Show Profile  Visit al_iguana's Homepage
what would i have to change to display avatars instead of photos? (i'm using Serverhacker's modded forum). No-one uses photos, but most people have an avatar, so it makes more sense to display those instead.

avatar variables would be pulled from cbovis' Custom Avatars Mod 1.3
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=34509

sorry if this is vague

----

Don't Dream It ~ Be It
http://www.peppermintiguana.co.uk/cymrugothic/
Go to Top of Page

PeeWee.Inc
Senior Member

United Kingdom
1893 Posts

Posted - 16 October 2002 :  17:59:46  Show Profile  Visit PeeWee.Inc's Homepage
Where it says "xev's profile" i want it to show the Icon_Profile.gif ......... how would i do this?

De Priofundus Calmo Ad Te Damine
Go to Top of Page

@tomic
Senior Member

USA
1790 Posts

Posted - 16 October 2002 :  19:22:28  Show Profile  Visit @tomic's Homepage  Send @tomic an ICQ Message
After:
strMemInSpot = rsMemInSpot("M_PHOTO_URL")

Add:
Member_ID = rsMemInSpot("MEMBER_ID")
Member_Name = rsMemInSpot("M_NAME")

The following will set up your icon and make it link to the correct member:
profileLink(getCurrentIcon(strIconProfile,"Show " & Member_Name & "'s Profile","align=""absmiddle"" hspace=""6"""),Member_ID)

@tomic

SportsBettingAcumen.com
Go to Top of Page

padawan
Junior Member

200 Posts

Posted - 16 October 2002 :  23:30:57  Show Profile
quote:
Originally posted by @tomic

After:
strMemInSpot = rsMemInSpot("M_PHOTO_URL")

Add:
Member_ID = rsMemInSpot("MEMBER_ID")
Member_Name = rsMemInSpot("M_NAME")

The following will set up your icon and make it link to the correct member:
profileLink(getCurrentIcon(strIconProfile,"Show " & Member_Name & "'s Profile","align=""absmiddle"" hspace=""6"""),Member_ID)

@tomic



sir @tomic,

...just echoing sir Iguana's question... How do we get the member avatar to show rather than the photo?

much appreciate it!

- padawan

"...be mindful of the SnitzForce..."
Go to Top of Page

@tomic
Senior Member

USA
1790 Posts

Posted - 16 October 2002 :  23:51:45  Show Profile  Visit @tomic's Homepage  Send @tomic an ICQ Message
strSql = "SELECT " & strTablePrefix & "MEMBERS.MEMBER_ID, " & strTablePrefix & "MEMBERS.M_AVATAR_URL, " & strTablePrefix & "MEMBERS.M_NAME, "


strMemInSpot = rsMemInSpot("M_AVATAR_URL")
change all instances of M_PHOTO_URL to M_AVATAR_URL

Adjust the width and height accordingly.

@tomic

SportsBettingAcumen.com
Go to Top of Page

richfed
Average Member

United States
999 Posts

Posted - 18 October 2002 :  21:39:16  Show Profile  Visit richfed's Homepage
quote:
Originally posted by antracit

Is it difficult to make this mod work with 3.3.xxx (ore 4.0B0.3 international)?
Older versions than 3.4



Works great for me on 3.3.05! Just add a link to the file ...

I've got some editing questions: [remember I am illiterate, or near, in reading this stuff, so go easy, please!]

  • Can the words "No Photo Available" be shown, in lieu of the photo, if the user has none in their profile? It looks like the code does this, but, of course, it doesn't.
  • The top and bottom links both point to the same place - the user's profile - How can I "deactivate" one of them into plain text?
  • Can you go over, again, how to add another profile field, say "rank" to the box, perhaps just under their user name?


Thanks for bearing with me ...

Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1]
Go to Top of Page

PeeWee.Inc
Senior Member

United Kingdom
1893 Posts

Posted - 19 October 2002 :  07:07:19  Show Profile  Visit PeeWee.Inc's Homepage
what one would you like to be plain text?

De Priofundus Calmo Ad Te Damine
Go to Top of Page

PeeWee.Inc
Senior Member

United Kingdom
1893 Posts

Posted - 19 October 2002 :  09:26:31  Show Profile  Visit PeeWee.Inc's Homepage
Where it says the user name a the top it will link to the profile, if you dont want it to link do this:

line 37:
" <a href=""" & strForumURL & "pop_profile.asp?mode=display&id="& rsMemInSpot("member_id") & """><font class=""DefaultFont""><b>" & rsMemInSpot("M_NAME") & "</b></font></A><br>" & vbCrLf


Replace that with:
" <font class=""DefaultFont""><b>" & rsMemInSpot("M_NAME") & "</b></font></A><br>" & vbCrLf

De Priofundus Calmo Ad Te Damine
Go to Top of Page

richfed
Average Member

United States
999 Posts

Posted - 19 October 2002 :  18:26:21  Show Profile  Visit richfed's Homepage
Thanks, PeeWee, Inc.! That helped!

Another good thing might be to make the photo open in a pop-up window if you click it. Right now, it takes you to a new page. How can this be done?

Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1]
Go to Top of Page

pox
Junior Member

Denmark
110 Posts

Posted - 27 October 2002 :  05:10:08  Show Profile  Visit pox's Homepage
mmm.. mine says

Member Spotlight

ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/members_spotlite.asp, line 30

and this is my members_spotlite.asp


<%
Response.write "<table width=""150"" border=""0"" cellspacing=""0"" cellpadding=""0"" bgcolor=" & strHeadCellColor & ">" & vbCrLf & _
" <tr>" & vbCrLf & _
" <td align=""left"" valign=""top"">" & vbCrLf & _
" <table BORDER=""0"" bordercolor=""" & strHeadCellColor & """ cellspacing=""1"" cellpadding=""0"" width=""100%"">" & vbCrLf & _
" <tr>" & vbCrLf & _
" <td valign=""top"">" & vbCrLf & _
" <table border=""0"" cellspacing=""0"" cellpadding=""0"" width=""100%"">" & vbCrLf & _
" <tr>" & vbCrLf & _
" <td align=""center"" bgcolor=" & strHeadCellColor & ">" & vbCrLf & _
" <table width=""100%"" cellpadding=""2"">" & vbCrLf & _
" <tr>" & vbCrLf & _
" <td valign=""top"" align=""center""><font face=""" & strDefaultFontFace & """ color=""" & strHeadFontColor & """ size=""" & strHeaderFontSize & """>Member Spotlight</font></td>" & vbCrLf & _
" </tr>" & vbCrLf & _
" </table>" & vbCrLf & _
" </td>" & vbCrLf & _
" </tr>" & vbCrLf & _
" <tr>" & vbCrLf & _
" <td bgcolor=""" & strForumCellColor & """>" & vbCrLf & _
" <table border=""0"" width=""100%"" cellspacing=""0"" cellpadding=""2"">"


'START MEMBER IN SPOTLITE SCRIPT
function MemInSpot
set rsMemInSpot = Server.CreateObject("ADODB.Recordset")
strSql = "SELECT " & strTablePrefix & "MEMBERS.MEMBER_ID, " & strTablePrefix & "MEMBERS.M_PHOTO_URL, " & strTablePrefix & "MEMBERS.M_NAME, "
strSql = strSql & strTablePrefix & "MEMBERS.M_FIRSTNAME, " & strTablePrefix & "MEMBERS.M_LASTNAME, " & strTablePrefix & "MEMBERS.M_AGE"
strSql = strSql & " FROM " & strTablePrefix & "MEMBERS"
strSql = strSql & " WHERE FORUM_MEMBERS.M_PHOTO_URL <> ''"
rsMemInSpot.Open strSql, my_Conn,3,,adCmdText
Dim intRnd
Randomize Timer
intRnd = (Int(RND * rsMemInSpot.RecordCount))
rsMemInSpot.Move intRnd
strMemInSpot = rsMemInSpot("M_PHOTO_URL")
Response.Write " <tr><td align=center bgcolor=""" & strForumCellColor & """>" & vbCrLf & _
" <a href=""" & strForumURL & "pop_profile.asp?mode=display&id="& rsMemInSpot("member_id") & """><font face=""" & strDefaultFontFace & """ color=""" & strDefaultFontColor & """ size=""" & strDefaultFontSize & """><b>" & rsMemInSpot("M_NAME") & "</b></font></A><br>" & vbCrLf
if Trim(rsMemInSpot("M_PHOTO_URL")) <> "" and lcase(rsMemInSpot("M_PHOTO_URL")) <> "http://" then
if lcase(left(strMemInSpot,7)) = "http://" then
Response.write " <a href=" & ChkString(rsMemInSpot("M_PHOTO_URL"), "display")& ">" & vbCrLf & _
" <img src=" & ChkString(rsMemInSpot("M_PHOTO_URL"), "display") & vbCrLf
elseif lcase(left(strMemInSpot,7)) <> "http://" then
Response.write " <a href=" & strForumURL & "images/" & ChkString(rsMemInSpot("M_PHOTO_URL"), "display")& ">" & vbCrLf & _
" <img src=" & strForumURL & "images/" & ChkString(rsMemInSpot("M_PHOTO_URL"), "display")& vbCrLf
end if
Response.write " alt=" & ChkString(rsMemInSpot("M_NAME"),"display")& vbCrLf & _
" width=""120"" height=""120"" border=""0"" hspace=""0"" vspace=""4""></a><br>" & vbCrLf
else
Response.Write getCurrentIcon(strIconPhotoNone,"No Photo Available","hspace=""0"" vspace=""4""") & "<br>" & vbCrLf _
end if
Response.Write " <a href=""" & strForumURL & "pop_profile.asp?mode=display&id="& rsMemInSpot("member_id") & """><font face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """>" & rsMemInSpot("M_NAME") & "#039;s Profile</font></A><br>" & vbCrLf
Response.Write " </td></tr>"
rsMemInSpot.Close
Set rsMemInSpot = Nothing
end function
'END MEMBER IN SPOTLITE SCRIPT

call MemInSpot


Response.Write " </td>" & vbCrLf & _
" </tr>" & vbCrLf & _
" </table>" & vbCrLf & _
" </td>" & vbCrLf & _
" </tr>" & vbCrLf & _
"</table>" & vbCrLf & _
"</td>" & vbCrLf & _
"</tr>" & vbCrLf & _
"</table>" & vbCrLf & _
"</td>" & vbCrLf & _
"</tr>" & vbCrLf & _
"</table>"
%>

The red code is line 30.



http://www.psytrance.dk/members_spotlite.asp you can see for your self here.. ;)

Edited by - pox on 27 October 2002 05:16:29
Go to Top of Page
Page: of 4 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.43 seconds. Powered By: Snitz Forums 2000 Version 3.4.07