| Author |
 Topic  |
|
jessica
New Member
USA
58 Posts |
 Posted - 01 December 2000 : 20:13:13
|
Add your photo to each topic posted
I had found on various forums that trying to see who written what was kinda diffacult when scrolling quickly through the
thread. By adding your picture to it will allow each topic be found more quickly by seeing your picture.
Go to this section around the 200's and the 400's. You can do a search for
strSql ="SELECT " & strMemberTablePrefix & "MEMBERS.M_NAME, "
add the following red line to each of them.
<%
'## Forum_SQL - Get all topicsFrom DB
strSql ="SELECT " & strMemberTablePrefix & "MEMBERS.M_NAME, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_ICQ, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_YAHOO, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_AIM, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_TITLE, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.MEMBER_ID, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_Homepage, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_LEVEL, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_POSTS, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_COUNTRY, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_CITY, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_STATE, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_DATE, "
strsql = strsql & strMemberTablePrefix & "MEMBERS.M_PHOTO_URL, "
strSql = strSql & strTablePrefix & "REPLY.REPLY_ID, "
strSql = strSql & strTablePrefix & "REPLY.R_AUTHOR, "
strSql = strSql & strTablePrefix & "REPLY.TOPIC_ID, "
strSql = strSql & strTablePrefix & "REPLY.R_MESSAGE, "
strSql = strSql & strTablePrefix & "REPLY.R_DATE, "
strSql = strSql & strTablePrefix & "REPLY.R_MSGICON "
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS, " & strTablePrefix & "REPLY "
strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.MEMBER_ID = " & strTablePrefix & "REPLY.R_AUTHOR "
strSql = strSql & " AND TOPIC_ID = " & Request.QueryString("TOPIC_ID") & " "
strSql = strSql & " ORDER BY " & strTablePrefix & "REPLY.R_DATE"
-------------------------------------------------------------------------------------------------------------------------
Now we would like to search for this section:
Around line 300+ you should see, or do a search for if strShowRank = 1 or strShowRank = 3 then
<% if strShowRank = 1 or strShowRank = 3 then %>
<font color="<% =strForumFontColor %>" face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>"><table style="filter:glow(color=red, strength=1)"><small><% = ChkString(getMember_Level(rs("M_TITLE"), rs("M_LEVEL"), rs("M_POSTS")),"display") %></small></table></font>
<% end if %>
<% if strShowRank = 2 or strShowRank = 3 then %>
<% badge() %>
<% end if %>
right after all of that add the following:
<% if Trim(rs("M_PHOTO_URL")) <> "" and lcase(rs("M_PHOTO_URL")) <> "http://" then %>
[img]<% =rs("M_PHOTO_URL") %>" alt="<% =rs("M_NAME") %>" width="150" height="150" border=0 hspace="2" vspace="2">
<% else %>
[img]no_photo.gif" alt="No Photo Available" width="150" height="150" border=0 hspace="2" vspace="2">
<% end if %>
-------------------------------------------------------------------------------------------------------------------------
You can see an example at http://webzonecomplete.brinkster.net/forum/topic.asp?TOPIC_ID=17&FORUM_ID=6&CAT_ID=3&Topic_Title=Adding+Photos+to+your+posts&Forum_Title=Community+Forum+News
If you have any questions just let me know.
|
|
|
Kenno
Average Member
Cambodia
846 Posts |
Posted - 01 December 2000 : 21:13:02
|
I like the idea of adding the photo in each posting message, but here are some matters we should think about:
- The more messages are posted, the more times are required to load the photos. (Disadvantages?)
- How many members of Snitz Forum users have submited the picture?
<font color=red>÷</font id=red><font color=blue>§</font id=blue><font color=red>÷</font id=red><font color=green> <b>Kenno</b> </font id=green><font color=red>÷</font id=red><font color=blue>§</font id=blue><font color=red>÷</font id=red>
<font size=1>http://forum.soputtra.net</font id=size1> |
 |
|
|
isuru
Junior Member
464 Posts |
Posted - 01 December 2000 : 21:32:59
|
Cool! This could be modified to serve as a members avatar
-=-=-=-=-=-=-=-
Isuru Amarasena |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 01 December 2000 : 22:19:22
|
Jessica, nice site (This is off topic, but oh well). I was curious as to who your hosted by, or if you run your own servers?
BTW I LOVE this pic... prolly cuz I'm a trekky :)
<img src="http://www.tgsupport.com/images/created/jkd.jpg" border=0>
<font color=red>Da_Stimulator</font id=red>
<font color=red>http://aokingdom.com</font id=red>
<font color=blue>response.write("I know what you coded last summer!")</font id=blue>
http://www.tek-tips.com - The community where computer proffesionals meet and talk.
Edited by - da_stimulator on 01 December 2000 22:20:00 |
|
|
|
jessica
New Member
USA
58 Posts |
Posted - 03 December 2000 : 00:33:29
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Jessica, nice site (This is off topic, but oh well). I was curious as to who your hosted by, or if you run your own servers?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Actually, that graphic was designed by my ex-husband. (long story, divorced, all of us are still friends. High school stuff. To complicated to explain)
His new wife, Roberta and him run the servers on Brinkster. (paid account for $10.95 per month) http://www.brinkster.com He is also a real big Treky person.
|
|
|
|
kycable
New Member
USA
82 Posts |
Posted - 03 December 2000 : 00:46:17
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
BTW I LOVE this pic... prolly cuz I'm a trekky :)
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
There you go Da_Stimulator one for you to play around with
<img src="http://webzonecomplete.brinkster.net/images/myimage/trek.jpg" border=0>
|
|
|
|
kycable
New Member
USA
82 Posts |
Posted - 03 December 2000 : 01:13:51
|
Ok, I have found a bug in it...
I have fixed it (basically just for the second part where you add the
<font color=red>
<% if Trim(rs("M_PHOTO_URL")) <> "" and lcase(rs("M_PHOTO_URL")) <> "http://" then %>
[img]<% =rs("M_PHOTO_URL") %>" alt="<% =rs("M_NAME") %>" width="150" height="150" border=0 hspace="2" vspace="2">
<% else %>
[img]no_photo.gif" alt="No Photo Available" width="150" height="150" border=0 hspace="2" vspace="2">
<% end if %>
</font id=red>
There are two places you need to add that in the topic.asp
here is the final working version in mod commander format http://webzonecomplete.brinkster.net/forum/mods/topicpic.zip
Questions? Let Jessica or I know we'll look in to it quickly.
KYCable
http://www.webzonecomplete.com
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 03 December 2000 : 05:58:28
|
Instead of having it show the no_photo.gif why not just do it this way:
( I also added a check to see if Pictures are enabled by the admin )<% if Trim(rs("M_PHOTO_URL")) <> "" and lcase(rs("M_PHOTO_URL")) <> "http://" and strPicture = 1 then %>
<img src="<% =rs("M_PHOTO_URL") %>" alt="<% =rs("M_NAME") %>" width="150" height="150" border=0 hspace="2" vspace="2">
<% end if %> |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 03 December 2000 : 06:39:19
|
They maybe a small bug in your forum, I went to the main forum page, and although it was showung me the login form, in the private messages window, it was showing my name ?
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
thaksis
Starting Member
29 Posts |
Posted - 03 December 2000 : 10:00:24
|
reply works fine but when i post new...
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/forums/topic.asp, line 489
reply works fine but when i post new...
|
|
|
|
thaksis
Starting Member
29 Posts |
Posted - 03 December 2000 : 10:00:43
|
reply works fine but when i post new...
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/forums/topic.asp, line 489
reply works fine but when i post new...
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 03 December 2000 : 10:36:05
|
Looks like they forgot about the Select statement in <b>sub GetFirst()</b>
<b>Search for this line:</b> <font color=red>(if you go down to <b>sub GetFirst()</b> its 7 or 8 lines down from there)</font id=red>
<font size=1><pre id=code><font face=courier size=2 id=code> strSql = strSql & strMemberTablePrefix & "MEMBERS.M_POSTS, " & strMemberTablePrefix & "MEMBERS.M_COUNTRY, "</font id=code></pre id=code></font id=size1>
<b>replace with this line:</b>
<font size=1><pre id=code><font face=courier size=2 id=code> strSql = strSql & strMemberTablePrefix & "MEMBERS.M_POSTS, " & strMemberTablePrefix & "MEMBERS.M_COUNTRY, "<font color=red> & strMemberTablePrefix & "MEMBERS.M_PHOTO_URL, "</font id=red></font id=code></pre id=code></font id=size1> |
|
|
|
kycable
New Member
USA
82 Posts |
Posted - 03 December 2000 : 14:52:57
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
<b>Orginal by Richard
Instead of having it show the <b>no_photo.gif</b> why not just do it this way:
<font color=red>( I also added a check to see if Pictures are enabled by the admin )</font id=red>
<font size=1><pre id=code><font face=courier size=2 id=code><% if Trim(rs("M_PHOTO_URL")) <> "" and lcase(rs("M_PHOTO_URL")) <> "http://" and strPicture = 1 then %>
[img]<% =rs("M_PHOTO_URL") %>" alt="<% =rs("M_NAME") %>" width="150" height="150" border=0 hspace="2" vspace="2">
<% end if %></font id=code></pre id=code></font id=size1>
</b><hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Richard, I was debating on whether to keep the no photo picture or not. My dad said I should keep it because of the e-mails of "how to put your picture their.", and it would give them more of an oppertunity to just go ahead and put something there. But after looking at it I just went ahead and made the apporpiate changes.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote><b>
Looks like they forgot about the Select statement in sub GetFirst()
Search for this line: (if you go down to sub GetFirst() its 7 or 8 lines down from there)
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_POSTS, " & strMemberTablePrefix & "MEMBERS.M_COUNTRY, "
replace with this line:
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_POSTS, " & strMemberTablePrefix & "MEMBERS.M_COUNTRY, " & strMemberTablePrefix & "MEMBERS.M_PHOTO_URL, "
</b><hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
I am kinda wondering if this would also work. Currently this is out that is:
sub GetFirst()
'## Forum_SQL - Get Origional Posting
strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.M_NAME, " & strMemberTablePrefix & "MEMBERS.M_ICQ, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_YAHOO, " & strMemberTablePrefix & "MEMBERS.M_AIM, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_TITLE, " & strMemberTablePrefix & "MEMBERS.M_HOMEPAGE, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.MEMBER_ID, " & strMemberTablePrefix & "MEMBERS.M_LEVEL, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_POSTS, " & strMemberTablePrefix & "MEMBERS.M_COUNTRY, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_CITY, " & strMemberTablePrefix & "MEMBERS.M_STATE, " & strMemberTablePrefix & "MEMBERS.M_DATE, "
<font color=red><b> strsql = strsql & strMemberTablePrefix & "MEMBERS.M_PHOTO_URL, " </b></font id=red>
strSql = strSql & strTablePrefix & "TOPICS.T_DATE, " & strTablePrefix & "TOPICS.T_SUBJECT, " & strTablePrefix & "TOPICS.T_AUTHOR, " & strTablePrefix & "TOPICS.T_MSGICON, "
strSql = strSql & strTablePrefix & "TOPICS.TOPIC_ID, " & strTablePrefix & "TOPICS.T_MESSAGE, " & strTablePrefix & "TOPICS.T_MSGICON "
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS, " & strTablePrefix & "TOPICS "
strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.MEMBER_ID = " & strTablePrefix & "TOPICS.T_AUTHOR "
strSql = strSql & " AND " & strTablePrefix & "TOPICS.TOPIC_ID = " & Request.QueryString("TOPIC_ID")
The errors that everyone are recieving I believe it a cookie problem from the whos_online.asp If it already showing your user name, then I am almost positive (of course I am wrong more than right) that it is calling the cookie from another site that you all have been to. I have had a few others like boxer_1, Roberta34, and testaccount (my laptop), who have never been to any snitz forums have no problems. To me this is very serious and I would like to learn more about it. If someone could help me I would really apperciate it.
Thanks,
Jeff
http://www.webzonecomplete.com
BTW: The Zip has been updated with the correct *.mod and *.txt files
Edited by - kycable on 03 December 2000 15:05:21 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 03 December 2000 : 15:14:39
|
| kycable, either way would work. I just went back and reread where you talk about inserting that part. I think some may just get confused and only add it into the first SELECT statement and forget to add it into the sub GetFirst() SELECT statement. (since you showed the complete example for the first one and not the second, and the second one looks so much different than the first.) |
|
|
|
kycable
New Member
USA
82 Posts |
Posted - 03 December 2000 : 15:15:08
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I like the idea of adding the photo in each posting message, but here are some matters we should think about:
- The more messages are posted, the more times are required to load the photos. (Disadvantages?)
- How many members of Snitz Forum users have submited the picture?
<font color=red>÷</font id=red><font color=blue>§</font id=blue><font color=red>÷</font id=red><font color=green> <b>Kenno</b> </font id=green><font color=red>÷</font id=red><font color=blue>§</font id=blue><font color=red>÷</font id=red>
<font size=1>http://forum.soputtra.net</font id=size1>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Kenno (NOT KEENO <img src=icon_smile_big.gif border=0 align=middle> Sorry was reading a topic earilier)
Well I have thought about the picture reloading several times, but I have found that if the exact picture is called it come from the cache it loads quickly. My dad who has AOL, on a Saturday night at 9pm with a 33.6k modem when to that topic mentioned above and found it loaded in about 5 seconds. (That was with 3 pics. (mine, my wifes, and the no_photo.gif). With the idea of removing the no_photo.gif that would be 2 pictures. Plus by turning the number of topics to say 10 per page or so should take care of any speed problem.
That is true not many have added their picture but with this addition it may allow people to say "well I'll throw something up there" Even if it is just a picture of a smiley face or something.
In fact I am thinking about have two pictures in your profile, a image picture, and a topic image. (I have to get Access 2000 again though. I can't find Disk 1 of Office 2000)
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 03 December 2000 : 15:35:44
|
kycable,
You might take a look at the way I implemented it on my site:
http://www.cfm-resources.com/r/richard/beta/
Goto the Register page and you will see the drop down for Avatar and click on the <img src="icon_smile_question.gif" border=0> to see a pop-up with the avatars displayed.
The only problem is that I am using the filesystem object to display the avatars dynamically, which means that all you have to do is have the avatars name "avatar_xxxx.gif" and it will display them in the drop down box for the users to pick from. I even implemented a way so that each individual member can have their own specific avatar by setting up a directory (using their member #) and those will show up in the drop down box as well.
Some hosts don't allow you to use the FileSystemObject. I know for sure that WebSamba doesn't support it, now sure about Brinkster. cfm-resources.com for the moment still supports it. |
|
|
|
Topic |
|
|
|
Topic Locked
