Author |
Topic |
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 07 October 2006 : 18:09:04
|
The slow loading appears to be because the admin_album page calls for the full member list and if that list is large then it can seem to take ages to load If you can find a way to remove this so that the page doesn't load all members into the form to add a single user photo album then I think you'll have solved it ...
...Ps, if you do would you mind sharing it < |
|
|
ian9001
Starting Member
22 Posts |
Posted - 20 December 2006 : 06:49:26
|
I know this is an old one and the original poster has moved on to other things, but has anyone used this mod?
Every time I try it I end up with an empty recordset. I've checked out the other references to another similar mod but can't find the actual code.
Any pointers folks?
Thanks
Ian
quote: Originally posted by Kuthula
I gather a few people have already made mods so that only those users with photo's in their albums are shown. Still I thought I'd tackle it myself, and here's how I did it.
At around line 191 in Photo_Album.asp I changed this line quote: sqlst = "select * from "& strMemberTablePrefix & "ALBUM_USERS order by M_NAME"
for this chunk quote: strMemberTablePrefix & "ALBUM_USERS.M_NAME, " & _ "count(" & strMemberTablePrefix & "ALBUM.Photo_id) as total " & _ "FROM "& strMemberTablePrefix & "ALBUM_USERS INNER JOIN " & _ strMemberTablePrefix & "ALBUM ON " & strMemberTablePrefix & "ALBUM_USERS.Member_id = " & _ strMemberTablePrefix & "ALBUM.Member_id " & _ "group by " & strMemberTablePrefix & "ALBUM_USERS.Member_id, " & strMemberTablePrefix & "ALBUM_USERS.M_NAME " & _ "order by M_NAME"
In effect this is only gathering albums with more than one record, and we keep that count - it's added to the 'aData()' array.
After the mods at around line 394 (before the mods it's somewhere like 381) I change this line quote: Response.Write aData(1,i)&"</a>"&vbNewLine
for this quote: Response.Write aData(1,i)&"["&aData(2,i)&"]</a>"&vbNewLine
The benefit over an earlier post is that we're counting the number of photo's once at the very outset rather than calling the database for each user with an album - this should speed up the process somewhat.
At the mo' I've done nothing with 'hidden' images... if I do anything it will be to prevent the use of hidden pics, its an album after all and not somewhere for people to swap or store their pics!
< |
|
|
endomorph
Junior Member
United Kingdom
128 Posts |
Posted - 10 January 2007 : 14:24:34
|
Does anybody know of, or could knock up a MOD/short piece of code to display the last photo uploaded and also link to it ?
< |
Need help with your Snitz ? Most Snitz & ASP custom coding undertaken. Email for info | Search Engine Optimisation |
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 10 January 2007 : 14:31:09
|
Get the addon at snitz bitz it allows you to show mow many photos you want to show on the front page. It always shows the most recently updated one.
get it here: http://www.snitzbitz.com/mods/details.asp?Version=All&mid=45
scroll down and you will find the add on you want. < |
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 05 June 2007 : 09:28:47
|
There is no dbs script for this mod it is built right into the mod so you just install it like it says in the readme. < |
|
|
jeeper
Starting Member
34 Posts |
Posted - 08 June 2007 : 11:59:50
|
quote: Originally posted by JJenson
There is no dbs script for this mod it is built right into the mod so you just install it like it says in the readme.
I believe mines failing to create the database tables. does anyone have the dbs code so I can try it with alternative mod setup?
Error: There was an error [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
Mine hangs when you try to upload and the tester shows all those %20 in the filename. I've seen no resolution to these issues in this topic. Anyone have any ideas?
< |
|
|
modifichicci
Average Member
Italy
787 Posts |
Posted - 08 June 2007 : 12:29:55
|
Check if in photo_album_setup you have Create table " & strTablePrefix & "ALBUM (Photo_id int NOT NULL IDENTITY(1,1),.....
and
Create table " & strTablePrefix & "ALBUM_CAT (Photo_Cat_Id int NOT NULL IDENTITY(1,1),...
both for mssql and access
if so yu need to change to
Create table " & strMemberTablePrefix & "ALBUM_CAT (Photo_Cat_Id COUNTER NOT NULL,...
and
Create table " & strMemberTablePrefix & "ALBUM (Photo_id COUNTER NOT NULL, ..
for access.< |
Ernia e Laparocele Forum di Ernia e Laparocele Acces - MySql Migration Tutorial Adamantine forum |
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 08 June 2007 : 13:47:22
|
arg, well I had figured out a way to load up the photo album admin pages nice and fast, I had changed the code, somehow, to only display members with posts greater than 1. Now my files mysteriously disappeared and have the slow loading problem again with the original unmodded mod files. I thought I had documented in this topic how to speed it up but I guess I didn't. Anyone with this info can perhaps display modified code so rather than display all members it displays all FORUM_MEMBERS where M_POSTS > 1 > - greater than right>? I don't remmeber how I did it nor any of my saved files seem to have the change but I had done that and it made my loading much faster. Thanks.< |
coaster crazy |
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 08 June 2007 : 15:10:18
|
jeeper I just want to clarify the problem you are having. When you upload it says it uploaded correctly but the photo does not actually upload. With this is adds alot of %20 for spaces and so forth. Is this what the problem is? If so I had this problem and responded in one of the threads probably one I started on how to fix this or at least how I got it to work.
If you have a link to see it that would be great.
< |
|
|
jeeper
Starting Member
34 Posts |
Posted - 08 June 2007 : 17:29:52
|
quote: Originally posted by modifichicci
Check if in photo_album_setup you have Create table " & strTablePrefix & "ALBUM (Photo_id int NOT NULL IDENTITY(1,1),.....
and
Create table " & strTablePrefix & "ALBUM_CAT (Photo_Cat_Id int NOT NULL IDENTITY(1,1),...
both for mssql and access
if so yu need to change to
Create table " & strMemberTablePrefix & "ALBUM_CAT (Photo_Cat_Id COUNTER NOT NULL,...
and
Create table " & strMemberTablePrefix & "ALBUM (Photo_id COUNTER NOT NULL, ..
for access.
That fixed the database errors, thanks. Troubleshoot still shows the same:
exact path to file: /forum/photo_album Write to file failed.No Errors detected, If you are still haveing problems please send me an email to Wesley Brown File has been saved in file system.
The file I uploaded won't display and the pathname is: http://www.azbackcountry.com/forum/photo_album%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20/4wheel.jpg --- but hell it works now.. thanks..< |
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 08 June 2007 : 17:43:52
|
make sure that you have filesystemobjects on your server and if you don't you need to go find the file cls_upload.asp or something like that and on line 8 set it to false I believe.< |
|
|
keng38
New Member
United Kingdom
80 Posts |
Posted - 15 August 2008 : 09:23:04
|
I used to have this mod working and then one day it stopped? I have reloaded everything back into Snitz and all looks ok but when the photo is uploaded it only creates a thumbnail image and then shows that but not the main image.
http://www.bacupbanter.co.uk/forum/photo_album_view.asp?cname=Main+Album&mid=2&cid=3&page=1&pic=TESTER.JPG
When I troubleshoot through admin I have noticed there are alot of %20%20%20's in with the properties of the image? When I look in the folder that should be holding the image there is nothing there (Just the pic in the TN folder)
Any suggestions?< |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 15 August 2008 : 17:13:20
|
%20 is html for a blank space. If your picture file name doesn't use underlines or something similar to fill blanks, you need to use %20 to represent them.< |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 15 August 2008 : 17:15:34
|
The program works as intended. I clicked on the thumbnail and got a full size photo.< |
|
|
keng38
New Member
United Kingdom
80 Posts |
Posted - 04 September 2008 : 09:02:39
|
I managed to sort it, an include file was missing.< |
|
|
Topic |
|