| T O P I C R E V I E W |
| Davecl |
Posted - 20 November 2005 : 02:23:58
The code for mine & Helters latest albums add-on for Burtholds photo album mode is now available here.
http://www.snitzbitz.com/mods/details.asp?Version=All&mid=45
This add-on displays thumbnails of the latest uploaded pic in 20 albums, very easy to install and can be modified to display any number of albums.< |
| 15 L A T E S T R E P L I E S (Newest First) |
| Helterskelter |
Posted - 20 March 2006 : 15:49:53
I know nothing... so one for Davecl< |
| ian9001 |
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< |
| Davecl |
Posted - 13 February 2006 : 12:08:30
updated the mod to include the new sql that only shows approved photos.
http://www.snitzbitz.com/mods/details.asp?mid=220
< |
| Davecl |
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;"< |
| Techrescue.net |
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< |
| Helterskelter |
Posted - 24 December 2005 : 04:48:54
Thanks m8< |
| rabufo |
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 |
Posted - 23 December 2005 : 21:09:21
welcome to post will save me 10 mins LOL< |
| rabufo |
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 |
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 |
Posted - 22 December 2005 : 01:10:52
Thank you Davecl, happy you like it  < |
| Davecl |
Posted - 22 December 2005 : 00:52:46
excellent idea.< |
| rabufo |
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 < |
| Davecl |
Posted - 29 November 2005 : 05:03:12
Thanks David, glad you got it working ok now  < |
| Classicmotorcycling |
Posted - 28 November 2005 : 15:30:20
The new sql statment seems to work good. Good add-on to the Photo Album. I have placed it at: Vn Commodore Main Page and in the Vn Commodore Support Forum
Good job Davecl...
< |
