Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 MOD: Photo Album for snitz 3.4.x version 1.82
 New Topic  Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 13

Webbo
Average Member

United Kingdom
982 Posts

Posted - 07 October 2006 :  18:09:04  Show Profile  Visit Webbo's Homepage  Reply with Quote
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 <
Go to Top of Page

ian9001
Starting Member

22 Posts

Posted - 20 December 2006 :  06:49:26  Show Profile  Reply with Quote
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!


<
Go to Top of Page

endomorph
Junior Member

United Kingdom
128 Posts

Posted - 10 January 2007 :  14:24:34  Show Profile  Reply with Quote
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
Go to Top of Page

JJenson
Advanced Member

USA
2121 Posts

Posted - 10 January 2007 :  14:31:09  Show Profile  Visit JJenson's Homepage  Reply with Quote
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.
<
Go to Top of Page

JJenson
Advanced Member

USA
2121 Posts

Posted - 05 June 2007 :  09:28:47  Show Profile  Visit JJenson's Homepage  Reply with Quote
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. <
Go to Top of Page

jeeper
Starting Member

34 Posts

Posted - 08 June 2007 :  11:59:50  Show Profile  Reply with Quote
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?

<
Go to Top of Page

modifichicci
Average Member

Italy
787 Posts

Posted - 08 June 2007 :  12:29:55  Show Profile  Visit modifichicci's Homepage  Reply with Quote
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
Go to Top of Page

weeweeslap
Senior Member

USA
1077 Posts

Posted - 08 June 2007 :  13:47:22  Show Profile  Visit weeweeslap's Homepage  Send weeweeslap an AOL message  Send weeweeslap a Yahoo! Message  Reply with Quote
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
Go to Top of Page

JJenson
Advanced Member

USA
2121 Posts

Posted - 08 June 2007 :  15:10:18  Show Profile  Visit JJenson's Homepage  Reply with Quote
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.

<
Go to Top of Page

jeeper
Starting Member

34 Posts

Posted - 08 June 2007 :  17:29:52  Show Profile  Reply with Quote
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..<
Go to Top of Page

JJenson
Advanced Member

USA
2121 Posts

Posted - 08 June 2007 :  17:43:52  Show Profile  Visit JJenson's Homepage  Reply with Quote
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.<
Go to Top of Page

keng38
New Member

United Kingdom
80 Posts

Posted - 15 August 2008 :  09:23:04  Show Profile  Visit keng38's Homepage  Reply with Quote
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?<
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 15 August 2008 :  17:13:20  Show Profile  Reply with Quote
%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.<
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 15 August 2008 :  17:15:34  Show Profile  Reply with Quote
The program works as intended. I clicked on the thumbnail and got a full size photo.<
Go to Top of Page

keng38
New Member

United Kingdom
80 Posts

Posted - 04 September 2008 :  09:02:39  Show Profile  Visit keng38's Homepage  Reply with Quote
I managed to sort it, an include file was missing.<
Go to Top of Page
Page: of 13 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.15 seconds. Powered By: Snitz Forums 2000 Version 3.4.07