| Author |
 Topic  |
|
dayve
Forum Moderator
USA
5820 Posts |
 Posted - 09 November 2002 : 14:35:40
|
Just add this SQL Statement after line 380
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)
and then change this line:
Response.Write aData(1,i)&"</a>"&vbNewLine
to this:
Response.Write aData(1,i)&"["&intTotals("totals")&"]</a>"&vbNewLine< |
 |
 |
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 09 November 2002 : 16:44:09
|
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.
I don't think it works with Netscape either.< |
|
|
|
|
Mikael
Starting Member
36 Posts |
Posted - 10 November 2002 : 04:42:54
|
Thanks dayve,
Above shows total photos but what about the issue of photos being visible when they are supposed to be invisible?
I tried with only one photo being invisible, the total says 0 but the photo is still visible when I click on the album.< |
|
|
|
webbee
Junior Member
100 Posts |
Posted - 12 November 2002 : 12:34:06
|
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< |
garnold@teamfatbastard.net
 |
Edited by - webbee on 12 November 2002 12:44:24 |
|
|
|
tacoma
Starting Member
5 Posts |
Posted - 13 November 2002 : 05:00:54
|
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.
Any ideas?< |
|
|
|
tacoma
Starting Member
5 Posts |
Posted - 13 November 2002 : 05:12:51
|
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?< |
|
|
|
Mikael
Starting Member
36 Posts |
Posted - 16 November 2002 : 19:09:28
|
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>:
cCat_Photo_Display = cint(strConf("Cat_Photo_Display"))
If <NULL> is the problem then somehow when users upload a photo the value of Cat_Photo_Display should default to 0 and not <NULL> I guess?< |
|
|
|
jeffery
Junior Member
USA
176 Posts |
Posted - 17 November 2002 : 01:43:18
|
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.
< |
www.thomasforum.com |
|
|
|
Mikael
Starting Member
36 Posts |
Posted - 17 November 2002 : 15:55:07
|
Hi Jeffrey,
I changed only the first mLev = 4 to mLev > 0 and the problem disappeared. Thanks, I do not know either the consequenses but it seemed harmless  < |
|
|
|
john160
Starting Member
2 Posts |
Posted - 28 November 2002 : 12:53:59
|
Dayve, Which file do you add this to?
John
quote:
Originally posted by dayve
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:
http://www.burningsoulsforum.com/forum/photo_album.asp
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.
< |
|
|
|
burthold
Junior Member
USA
426 Posts |
Posted - 29 November 2002 : 23:50:48
|
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!
Wes< |
|
|
|
DCM
Starting Member
37 Posts |
Posted - 01 December 2002 : 15:07:24
|
Wow, perfect timing for me. 
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!
TIA,
Dan
< |
|
|
|
burthold
Junior Member
USA
426 Posts |
Posted - 02 December 2002 : 16:17:10
|
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< |
|
|
|
DCM
Starting Member
37 Posts |
Posted - 04 December 2002 : 18:17:24
|
quote:
Originally posted by burthold
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?
-Dan< |
|
|
|
Jeepers Ron
New Member
USA
95 Posts |
Posted - 26 December 2002 : 22:22:27
|
| Is there a way to restrict the Photo album to selected members?< |
Jeeper from Michigan
|
|
|
|
Topic |
|
MOD: Photo Album for snitz 3.4.x version 1.82
