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

AWD_ENVY
Junior Member

103 Posts

Posted - 02 December 2003 :  23:04:14  Show Profile  Reply with Quote
quote:
Originally posted by jeepgen

hi there. Me too, i have mysql problems.
The pic are there (i "translated" my db from access to mysql), all tables are there, but the pics dont show.
The page of any members say Sorry no pic.
If u go to "modify" option, u can see them.
And the admin-menu option for Photo album goes in .asp time out.
What's that??
Thanking u in advance,




When I modified the PhotoAlbums for out site & into MySQL, I had to do alot of changes. I know I converded alot of the recordsets to Arrays. I'll see if I can put my photoalbum code togeather for the other MySQL users.
<
Go to Top of Page

AWD_ENVY
Junior Member

103 Posts

Posted - 03 December 2003 :  14:44:17  Show Profile  Reply with Quote
Someone with MySQL, give this a try.... just replace your Photo_Album.asp with the code in this file.
Because I started making changes for our site with no thought that someone else might want it, There my be something that doesn't work. Everything should be fine, but make a backup of your original file. I don't think there will be any issues with MSaccess databases using this, but it was modified under MySQL. If anything it might speed up a MSAccess database, because almost everything is done through arrays rather than recordsets.

Note: This is JUST the code for the photo_album.asp file. If someone can verify there are not any issues, I'll give out the rest of the code.

Some of the things that have changed in this file Vs. the original:
'# Album Gives users the choice of single or Multi Mode (nolonger does and admin select 1 style)
'# Album Only diplays users with photos in their albums under Multi Mode
'# Album diplays photos & albums in order of Newest to Oldest (so the main page is always fresh and new looking)
'# Album Diplays PhotoCounts in users album under Multi Mode
'# Album Auto Displays the most recent picture in the ablumb, if a user has not selected one to diplay for their album
'# Album uses more array's for speed & MySQL compatibility

Demo of Photo_Album.asp

The Code

<

Edited by - AWD_ENVY on 03 December 2003 14:49:21
Go to Top of Page

mvita
Starting Member

1 Posts

Posted - 10 December 2003 :  08:25:43  Show Profile  Reply with Quote
I tried your module on my photoalbum (under MSaccess).
It doesn't work: Under "user view" I could see no users at all, while in "picture view" things are better, but the path to the pictures is not correct: the user directory comes with a lot of spaces after its name, so the picture is not found (eg. public/pictures/jimmy%20%20%20%20%20%20%20%20%20%20%20%20%20/picture.gif)

Any clue?
I would like very much to use this mod, since I like the look and the main page "always updated"

Marco
---------------
www.citroends.it<

This account was hacked into by Image, a very honest guy as you all can see! Stealing people' s passwords IS his pasttime.
Go to Top of Page

AWD_ENVY
Junior Member

103 Posts

Posted - 10 December 2003 :  09:22:40  Show Profile  Reply with Quote
I'm not sure how your database fields differ from mine in MySQL.
To start we need to find out where the error is occuring, and where it's getting the space(%20) values.

If you're fammiler with arrays, can you tell me what value your getting for "aData(1,i)" in the photo display loop ?

I'm guessing thats where the error is, and I'd like to verify that the "1" colomb(member's name) is the same one as the one that I'm pulling.<

Edited by - AWD_ENVY on 10 December 2003 09:23:29
Go to Top of Page

bitwise2000
Starting Member

38 Posts

Posted - 13 December 2003 :  12:07:32  Show Profile  Reply with Quote
AWD_ENVY, that code doesn't work on Access because Access does not support aggregate functions. Your SQL includes a join and a group by and that does not work in Access. I'm trying to rework the sql so it runs. Access users, if you turn off the on error resume you'll see the error from ADO. -- Bit<
Go to Top of Page

bitwise2000
Starting Member

38 Posts

Posted - 02 January 2004 :  12:37:26  Show Profile  Reply with Quote
How is ASPJpeg used? I see a test for its presence, but it doesn't seem to get used to generate thumbs if it's there.<
Go to Top of Page

unclefunk
Starting Member

South Africa
3 Posts

Posted - 08 January 2004 :  12:30:18  Show Profile  Visit unclefunk's Homepage  Reply with Quote
Where can I download this mod, since it can't be downloaded from
www.wesworld.net/mods/default.asp anymore.


<
Go to Top of Page

hirsp1
Starting Member

11 Posts

Posted - 03 February 2004 :  09:15:44  Show Profile  Reply with Quote
quote:
Originally posted by Sherm

quote:
Originally posted by Jeff V


Active Server Pages error 'ASP 0113'

Script timed out

/photo_album_upload.asp

The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.



That is the precise error I'm getting.

Clues, anyone?




I, too am getting this particular error. I've had my ISP check to make sure that permissions are correctly set AND that the FileServerObject is working. They assure me that both are as they need to be.

Any other suggestions on how to solve this problem? I actually have the same problem with the File Lister, too, so I'm still suspecting something at the ISP level, not necessarily with the code.<
Go to Top of Page

Kuthula
Starting Member

6 Posts

Posted - 09 February 2004 :  04:04:07  Show Profile  Visit Kuthula's Homepage  Reply with Quote
quote:
Where can I download this mod, since it can't be downloaded from
www.wesworld.net/mods/default.asp anymore.

Same question... can anyone point me in the right direction? Cheers.<
Go to Top of Page

Thomas
Starting Member

Belgium
20 Posts

Posted - 09 February 2004 :  14:04:03  Show Profile  Visit Thomas's Homepage  Reply with Quote
Uploaded the MOD to my personal webspace @ http://ceupers.telenet.be/shared/photo_album-34-180.zip. Enjoy!

Anyway, is the original developer of this MOD still busy with development?<

Edited by - Thomas on 11 February 2004 01:17:44
Go to Top of Page

Kuthula
Starting Member

6 Posts

Posted - 09 February 2004 :  17:16:01  Show Profile  Visit Kuthula's Homepage  Reply with Quote
Excellent - thanks very much Thomas. Now fingers crossed for an easy day in the office so that I can get to make the changes!

Much appreciated.
<

Edited by - Kuthula on 10 February 2004 07:55:10
Go to Top of Page

wii
Free ASP Hosts Moderator

Denmark
2632 Posts

Posted - 10 February 2004 :  08:45:39  Show Profile  Reply with Quote
Seems like the developer dropped Snitz and use phpBB in a Postnuke site now.<
Go to Top of Page

Thomas
Starting Member

Belgium
20 Posts

Posted - 10 February 2004 :  11:28:31  Show Profile  Visit Thomas's Homepage  Reply with Quote
quote:
Originally posted by wii

Seems like the developer dropped Snitz and use phpBB in a Postnuke site now.



Too bad. <
Go to Top of Page

Kuthula
Starting Member

6 Posts

Posted - 13 February 2004 :  09:01:28  Show Profile  Visit Kuthula's Homepage  Reply with Quote
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

fireskull
Starting Member

United Kingdom
5 Posts

Posted - 24 February 2004 :  19:09:54  Show Profile  Visit fireskull's Homepage  Reply with Quote
Hey All!
Ive got a problem, when i click on "Upload Files into Album" it takes ages to load and when it does finally do something a page cannot be displayed comes up and has this:

Active Server Pages, ASP 0113 (0x80004005)
The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.
/forum/photo_album_upload.asp

and once i got a different error to this but only once and cant remember what it said what could be wrong, ne help wud b appreciated

Paul<
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.13 seconds. Powered By: Snitz Forums 2000 Version 3.4.07