| Author |
 Topic  |
|
Davecl
Junior Member
United Kingdom
105 Posts |
 Posted - 29 November 2005 : 05:03:12
|
Thanks David, glad you got it working ok now  < |
Dave |
 |
|
|
rabufo
Junior Member
Italy
328 Posts |
Posted - 21 December 2005 : 18:56:35
|
For all interested, I'm using a double way to view thumbnails: 6 thumbs in the forum homepage and 18 in the Photo Album main page (photo_album .asp). In this way, more users are happy because their photos are viewable.
You can take a look at www.discusclub.net , scroll down and click on "Discus Forum Foto Album" link
To do this, I've used another inc_latestalbumthumb2.asp file (I've renamed it inc_latestalbumthumb2a.asp), calling it as include in photo_album.asp in this way
" </tr>"& vbNewLine & _
"</table>"& vbNewLine
%>
<!--#INCLUDE FILE="inc_latestalbumthumb2a.asp"-->
<%
'this is the top nav 3.4 will be compliant as soon as I get around to it ;)
Well, I know is a little thing, but hope someone can find useful the idea  < |
Edited by - rabufo on 21 December 2005 19:08:14 |
|
|
|
Davecl
Junior Member
United Kingdom
105 Posts |
Posted - 22 December 2005 : 00:52:46
|
| excellent idea.< |
Dave |
|
|
|
rabufo
Junior Member
Italy
328 Posts |
Posted - 22 December 2005 : 01:10:52
|
| Thank you Davecl, happy you like it < |
|
|
|
Helterskelter
Junior Member
United Kingdom
331 Posts |
Posted - 23 December 2005 : 02:30:33
|
Looks good.
I noticed u added a Camera Icon. Thats something I missed and should of added, How ever a good way to remind me to add it in.
Helter< |
 |
|
|
|
rabufo
Junior Member
Italy
328 Posts |
Posted - 23 December 2005 : 12:12:13
|
| Let me know if you need the code I've used to add the camera icon, Helter....< |
|
|
|
Helterskelter
Junior Member
United Kingdom
331 Posts |
Posted - 23 December 2005 : 21:09:21
|
| welcome to post will save me 10 mins LOL< |
|
|
|
|
rabufo
Junior Member
Italy
328 Posts |
Posted - 24 December 2005 : 03:25:49
|
here the related inc_photo_album_update2.asp
<%
'#################################################################################
'# Copyright (C) 2000-02 Wesley D. Brown
'# Photo Album v.05 for Snitz 3.3.05
'# This is include for default.asp it builds the small table needed for navigation
'#################################################################################
'################################################
'Latest Albums Add-On by Dave Clarke & Alan Dunne
'################################################
Response.Write " <tr>" & vbNewline & _
" <td bgcolor=""" & strCategoryCellColor & """ colspan=""" & sGetColspan(7,6) &_
"""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strCategoryFontColor & """ size=""+1""><b>Photo Albums - Last updates</b></font></td>" & vbNewline & _
" </tr>" & vbNewline & _
" <tr>" & vbNewline & _
" <td rowspan=""1"" bgcolor=""" & strForumCellColor & """><img src=""" & strImageUrl & "icon_palbum.gif""></td>"& vbNewline & _
" <td bgcolor=""" & strForumCellColor & """ colspan=""6"">" & vbNewline & _
" <TABLE border=0 width=""100%""><TR>" & vbNewline & _
" <TD width=""50%"">" & vbNewline
%>
<!--#INCLUDE FILE="inc_latestalbumthumb2.asp"-->
<%
Response.Write " </font></TD>" & vbNewline & _
" <TABLE border=0 width=""100%""><TR>" & vbNewline & _
" </TR>" & vbNewline & _
" <TR>" & vbNewline & _
" </TR>" & vbNewline & _
" </TABLE>" & vbNewline & _
" </td>" & vbNewline & _
" </tr>" & vbNewline
%>< |
|
|
|
Helterskelter
Junior Member
United Kingdom
331 Posts |
Posted - 24 December 2005 : 04:48:54
|
| Thanks m8< |
|
|
|
|
Techrescue.net
Starting Member
8 Posts |
Posted - 04 February 2006 : 11:58:29
|
Does anyone know how to adjust the SQL so that only photo's marked as 'Visible' show up in the latest photos?
I have tried inserting 'AND FA1.Photo_Status = 1' to various places in the sql however I can't get it to work.
Thanks< |
|
|
|
Davecl
Junior Member
United Kingdom
105 Posts |
Posted - 12 February 2006 : 02:50:23
|
thought i'd updated the files in the mod to do this but obviously not, i'll do it later, in the meantime alter the sql to this
strSql= "SELECT FA1.Photo_id, FA1.Photo_Name, FAU1.Member_id, FAU1.M_NAME FROM FORUM_ALBUM_USERS AS FAU1 INNER JOIN FORUM_ALBUM AS FA1 ON FAU1.Member_id = FA1.Member_id WHERE (((FA1.Photo_id)=(SELECT MAX(FA01.Photo_id)FROM FORUM_ALBUM AS FA01 WHERE FA01.Member_id = FA1.Member_id GROUP BY FA01.Member_id)) AND ((FA1.Photo_Status)=1))ORDER BY FA1.Photo_id DESC;"< |
Dave |
|
|
|
Davecl
Junior Member
United Kingdom
105 Posts |
|
|
ian9001
Starting Member
22 Posts |
Posted - 20 March 2006 : 15:37:12
|
Nice Mod I've used on several forums using MS Access, thanks guys. Now trying to use it on a forum using MySql Ver 5 and keep getting:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT MAX( FA01 . PHOTO_ID ) FROM FORUM_ALBUM AS FA01 WHERE FA
I've tested each part of this query using phpMyAdmin and it all works fine. Run it together and I get the above error. I'm afraid my knowledge of SQL is limited (I am trying!) and the various changes I made just got me deeper into the variety of error messages.
The Mod version I'm using is the latest one uploaded.
A pointer as to why this script keeps falling over would be cool..
Ian< |
|
|
|
Helterskelter
Junior Member
United Kingdom
331 Posts |
Posted - 20 March 2006 : 15:49:53
|
| I know nothing... so one for Davecl< |
|
|
|
|
Topic |
|
MOD Add-On: Latest Albums - updated v1.1
