| Author |
 Topic  |
|
Davecl
Junior Member
United Kingdom
105 Posts |
 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.< |
Dave |
Edited by - Davecl on 28 November 2005 04:54:47 |
|
|
Helterskelter
Junior Member
United Kingdom
331 Posts |
Posted - 20 November 2005 : 03:22:27
|
Davecal done all the hard work.
How ever It's good that some one has at last figered out a way to do this.
Helter< |
 |
 |
|
|
Helterskelter
Junior Member
United Kingdom
331 Posts |
Posted - 20 November 2005 : 03:31:23
|
You need running the " burthold's" photoablum 1.82mod
and you'll need to edit inc_latestalbumthumb2.asp
Response.Write strname&"<br><a href=photo_album_cat.asp?sqldtl="&strmemid&"><img src=""http://yourdomain.com/albums/"&strname&"/tn/tn_"&strphoto&"""width=""100"" height=""75""></a>"
Edit the address (in RED)
And you may have to remove the following part in RED
Response.Write strname&"<br><a href=photo_album_cat.asp?sqldtl="&strmemid&"><img src=""http://yourdomain.com/albums/"&strname&"/tn/tn_"&strphoto&"""width=""100"" height=""75""></a>"
Of course if you have configered to upload to a different file, then you'll have to change from albums (default) to your new folder.
Helter< |
|
Edited by - Helterskelter on 20 November 2005 03:33:14 |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 20 November 2005 : 06:09:00
|
OK, I have used your MOD, but had to adjust a few things in it, but got it working with a simple 2 lines at the top of the file that needs changing to the one file to make it work for me easier. I also took away the need to adjust your red code above to make it easy for users.
I have a demo of it working at http://www.vncommodore.com/forum/
< |
Cheers,
David Greening |
|
|
|
Davecl
Junior Member
United Kingdom
105 Posts |
Posted - 21 November 2005 : 04:14:28
|
| Thanks David, glad you got it working< |
Dave |
|
|
|
richfed
Average Member
United States
999 Posts |
Posted - 21 November 2005 : 07:03:42
|
| How may I change the font size for the members' names that appear with their recent photo?< |
|
|
|
Helterskelter
Junior Member
United Kingdom
331 Posts |
Posted - 21 November 2005 : 13:38:47
|
In inc_latestalbumthumb2.asp
replace line 39 with the following code.
Response.Write "<font align=left face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>"&strname&"<br><a href=photo_album_cat.asp?sqldtl="&strmemid&"><img src=""http://www.yoursite.com/photo/"&strname&"/"&strphoto&"""width=""100"" height=""75""></a>"
This will now call the text formatting of the forum.
Helter< |
|
Edited by - Helterskelter on 21 November 2005 13:40:03 |
|
|
|
richfed
Average Member
United States
999 Posts |
Posted - 21 November 2005 : 17:20:22
|
| Much better ... thanks!< |
|
|
|
Helterskelter
Junior Member
United Kingdom
331 Posts |
Posted - 21 November 2005 : 17:44:48
|
| No probs. Just need the download file reziped at some point.< |
|
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 23 November 2005 : 13:35:56
|
OK, found a slight issue with the code. The actual photos do not update on the front page. I will give an example:
I have set the display to 10 photos (on a site not for the public) and it displays the first 10 users in alphabetical order (which will consist of say 3 users starting with A, 4 starting with D, 2 starting with F and 1 with H), but when a user with a name that starts with I or above updates their photo album, the photos do not change on the front page. In other words their phot doesn't show on the front page.
Any help getting this resolved would be great.
< |
Cheers,
David Greening |
|
|
|
imweazel
Starting Member
49 Posts |
Posted - 23 November 2005 : 14:41:16
|
quote:
Originally posted by Classicmotorcycling
OK, found a slight issue with the code. The actual photos do not update on the front page. I will give an example:
I have set the display to 10 photos (on a site not for the public) and
it displays the first 10 users in alphabetical order (which will
consist of say 3 users starting with A, 4 starting with D, 2 starting
with F and 1 with H), but when a user with a name that starts with I
or above updates their photo album, the photos do not change on the
front page. In other words their phot doesn't show on the front page.
Any help getting this resolved would be great.
Try changing the SQL statement to use TOP for Access and LIMIT for SQL
and if you order by the primary key in a descending fashion you should
get the last 10 entries made to the table. Something like this:
SELECT TOP 10 FORUM_ALBUM.Photo_id, FORUM_ALBUM.Photo_Name AS ID,
FORUM_ALBUM_USERS.M_NAME, FORUM_ALBUM.Member_id
FROM FORUM_ALBUM, FORUM_ALBUM_USERS
WHERE (((FORUM_ALBUM.Member_id)=[FORUM_ALBUM_USERS].[MEMBER_ID]) AND
((FORUM_ALBUM.Photo_Status)=1))
GROUP BY FORUM_ALBUM.Photo_id, FORUM_ALBUM.Photo_Name,
FORUM_ALBUM_USERS.M_NAME, FORUM_ALBUM.Member_id
ORDER BY FORUM_ALBUM.Photo_id DESC;
< |
Edited by - imweazel on 23 November 2005 14:43:33 |
|
|
|
Davecl
Junior Member
United Kingdom
105 Posts |
Posted - 24 November 2005 : 16:28:29
|
TOP doesn't work because that will give you the last 10 albums that were updated even if all 10 were from the same member which is not what i intended, you need to use MAX to get it to skip albums with more than one recent uploaded pic.
don't know why it's not working David, It's working fine on my forum, although i'm using 20 not 10. i'll take a look when i get chance.< |
Dave |
|
|
|
Davecl
Junior Member
United Kingdom
105 Posts |
Posted - 24 November 2005 : 17:53:01
|
| had a look and you are right david, silly me, as it stands you would have to show all the records that the sql creates to show all your latest updated albums. I will have to look into the sql.< |
Dave |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 25 November 2005 : 03:50:09
|
Cool... I thought that it was me for a second there..  If you could look in to it, then it would be great.  quote:
Originally posted by Davecl
had a look and you are right david, silly me, as it stands you would have to show all the records that the sql creates to show all your latest updated albums. I will have to look into the sql.
The site I have it on has more than 1000 members and you do not want to show than many images on the page.. 
< |
Cheers,
David Greening |
|
|
|
Davecl
Junior Member
United Kingdom
105 Posts |
Posted - 28 November 2005 : 04:52:17
|
New version - V1.1
Changed the SQL so it should now work correctly, showing the latest updated albums in descending order.
Added tool-tips to picture links
Usernames now display in the default forum font.
http://www.snitzbitz.com/mods/details.asp?Version=All&mid=220
Dave
< |
Dave |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
|
|
Topic |
|
MOD Add-On: Latest Albums - updated v1.1
