strPhotoCount = "SELECT count(*) as totals from " &strMemberTablePrefix & "Album where Photo_Status = 1 and Member_Id = "&cint(aData(0,i)) set intTotals = My_Conn.execute(strPhotoCount)
This MOD does not work with Opera 6.x. I was informed by wii that it worked for him but I think the issue is SQL Server related because my DLLHOST.exe pegs out my cpu at 100% even after I try to stop the upload process through the Opera Browser.
For some reason when I upload a picture I'm getting all these spaces in between where the file is surpose to be put and the file name. example: http://www.website.com/uploads(........spaces........)picture.jpg really strange. I can upload pictures fine but the thumbnail test is what's acting up and giving me this error. thx<
I'm new to Snitz. I just installed the Photo Album v1.50 The install went fine and I have the admin options for the photo album. But when any user clicks on the photo album forum it just says you do not have an album account.
Okay I figured it out by running admin_album_admin_users.asp But if a new user signs up they don't have access to upload until I create their album, is there anyway that I can set it so all new users automatically have an album?<
Some users says that no matter what they press they cannot access the edit photo section = photo_album_detail.asp.
I checked th DB and noticed that in FORUM_ALBUM the field Cat_Photo_display had the value <NULL> on some users and was wondering if this could abort photo_album_detail.asp causing the problem? I was thinking of this line of code stumbling upon <NULL>:
Having same problem. However admin can edit photo section. I changed mlev = 4 to mlev > 0 in several places in photo_album_detail.asp now regular members can edit.
However is this secure?
I'm not sure what the consequences of doing this is. <
just got it installed, super easy.. thanks. I did find a couple of bugs, one being that when you select a photo to NOT be visible it will still show. I had to add a check in the sql statement for photo_status.
I also added a routine to show how many photos each album has in its directory although I am not quite sure I am doing it the best way (using FSO). I think I am going to consider a field in album members that can be updated every time a person uploads or deletes a photo, that way it will be quicker. right now using FSO I am not having any issues, but I don't have a lot of albums nor images uploaded yet. here is an example:
I'm not sure if I should continue using the FSO routine or a SQL routine
FSO Routine:
Dim filesys, demofolder, fil, filecoll, filist, photoCount photoCount = 0 Set filesys = CreateObject("Scripting.FileSystemObject") Set demofolder = filesys.GetFolder(Server.Mappath("/photoalbum/" & aData(1,i))) Set filecoll = demofolder.Files
For Each fil in filecoll photoCount = photoCount + 1 Next
Set filesys = Nothing Set demofolder = Nothing Set filecoll = Nothing
==================================
SQL Routine:
strPhotoCount = "SELECT count(*) as totals from " &strMemberTablePrefix & "Album where Photo_Status = 1 and Member_Id = "&cint(aData(0,i)) set intTotals = My_Conn.execute(strPhotoCount)
=================================
I would imagine the SQL routine would be much faster if there were a lot of photo albums and a lot of images.
I don't know about the security issue if I ever get time to breathe I'll check it out. The category being null is fine. I haven't tested with opera at all it works fine with netscape 4.7 and above and IE 5.x and 6.x. In my current beta I have a field that gets updated everytime the update/delete/mark inactive for photos. One count for admins and themselves to know how many photos they actually have and one to show users from the outside so if they do have photos but they are marked not visable it doesn't show up in their count. I would stay away from using the FSO to find the count everytime a user hits the album and also stay away from select count(*) from Album do a select count(photo_id) where photo_status = 1 and member id = "blah" index the photo_id colum it will run much faster than counting all fields in that table always be as selective as possible when writing SQL statmens the less data to work with the faster the statement will be.
FYI I just wanted to drop a note and let people know I'm not dead. I will not be doing any work on my mods for a while maybe a month or more. If you produce a bug fix or an improvement please send it to me so I can merge it into the main mods once I get back from real life and can spare the time to work on them again. Right now I am working 60 to 80+ hours a week on some time critical projects for my current employer. You guys understand paying the bills comes before free mods in my wifes mind I am still answering emails as I can so don't be afraid to send them on.
Happy holidays and don't be afraid to help each other out on mods!
I run a car club web site too and was wondering if it would be hard to skip the categories section and just have one album for each user. I want to keep bandwidth down and just want to use the photo album as a way to display "member rides". Say 5-10 pics for each member. (I've tried the one album mode, but that is one album for the whole site, not one album for each user)
So when you click on a members name in the user's album list, it would go right to displaying all of their pictures instead of their catagories.
Since this is a wish list kinda post.... ideally I would like one description box for the all the pictures (instead of a description for each) where the user can enter the mods to their car.
I have no idea how much work this would entail. Let me know if it sounds like a good project!
if you click on a members name it displays their categories first then thier pics. The categories was a requested feature by several people. It sounds like a one off kind of project you are the only person to request the album back to the way it was wiht no categories. The descriptor thing I don't know about.
if you click on a members name it displays their categories first then thier pics. The categories was a requested feature by several people. It sounds like a one off kind of project you are the only person to request the album back to the way it was wiht no categories. The descriptor thing I don't know about.
Wes
Ok. So I take it I can't just cut that step out of the existing code with any ammount of ease. Meaning have the user link just display that user's main album.
Assuming I could find the a ver 1.2 download, (I think that's the version you're talking about) how involved would it be to get it to work on 3.4?
Appreciate your thoughts on which of the two approaches, if either, are doable?
MOD: Photo Album for snitz 3.4.x version 1.82
Posted - 09 November 2002 : 14:35:40
<
I am still answering emails as I can so don't be afraid to send them on. 
