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!

---

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.

---

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.

---