Administrating Users and/or Items

reinerk

Joined: 2006-09-06
Posts: 12

Posted: Wed, 2006-09-27 16:57

Hello,

I'd like to use Gallery in the near future embedded in a phpbb-based Forum.
I have a perfectly working Test-Installation.
Now i'm thinking about, how to administrate the Users and Items in the future?!

Could you please tell me, if the following things are possible or -even better- if a module with this features exists?

I want to look for Items or Albums which are not viewed for a certain period.
This could be done for instance by a list of all albums (or items) sorted by the last access-date. Then it should go to mark some of the albums (or items) and delete them.

If such a module doesn't exist, please tell me which DB_Entries have to be deleted to removing an album (or item) out of the gallery (Of course the Item itself has to be deleted too).

Thanks
Reiner

Gallery-Version = 2.1.2 Kern 1.1.0.2
PHP-Version = 4.4.2 cgi
Webserver = Apache
Datenbank = mysql 5.0.22, lock.system=flock
Werkzeuge = Exif, ImageMagick, Gd
Beschleunigung = none, none
Betriebssystem = Linux h831526 2.4.32-ow1 #3 SMP Mon Jul 24 11:54:30 CEST 2006 i686
Standard-Motiv = nikonpoint
Sprache = de_DE
Browser = Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; de; rv:1.8.0.6) Gecko/20060728 Firefox/1.5.0.6

valiant

Joined: 2003-01-04
Posts: 32509

Posted: Wed, 2006-09-27 17:05

- there's no last viewed / accessed date
- also note that such a timestamp would come at a performance penalty.

you'd have to to change modules/core/ShowItem.inc or modules/core/classes/helpers/GalleryItemAttributesHelper_simple.class function incrementViewCount().

reinerk

Joined: 2006-09-06
Posts: 12

Posted: Wed, 2006-09-27 17:25

Ok. then this way via database won't work...

What about to "crawl" through the albums and identify the last access date?
With the name of the album i've got the name of the user (Because each member in my installation has only one album with none sub-albums)

If i have the names of albums which are ununsed over a longer time i can delete the albums and their according db-entries.

Could this be a way?
Which db-entries have to be deleted?

reinerk Joined: 2006-09-06 Posts: 12	Posted: Wed, 2006-09-27 16:57
	Hello, I'd like to use Gallery in the near future embedded in a phpbb-based Forum. I have a perfectly working Test-Installation. Now i'm thinking about, how to administrate the Users and Items in the future?! Could you please tell me, if the following things are possible or -even better- if a module with this features exists? I want to look for Items or Albums which are not viewed for a certain period. This could be done for instance by a list of all albums (or items) sorted by the last access-date. Then it should go to mark some of the albums (or items) and delete them. If such a module doesn't exist, please tell me which DB_Entries have to be deleted to removing an album (or item) out of the gallery (Of course the Item itself has to be deleted too). Thanks Reiner Gallery-Version = 2.1.2 Kern 1.1.0.2 PHP-Version = 4.4.2 cgi Webserver = Apache Datenbank = mysql 5.0.22, lock.system=flock Werkzeuge = Exif, ImageMagick, Gd Beschleunigung = none, none Betriebssystem = Linux h831526 2.4.32-ow1 #3 SMP Mon Jul 24 11:54:30 CEST 2006 i686 Standard-Motiv = nikonpoint Sprache = de_DE Browser = Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; de; rv:1.8.0.6) Gecko/20060728 Firefox/1.5.0.6
	XUser login Username: * Password: * Create new account Request new password
valiant Joined: 2003-01-04 Posts: 32509	Posted: Wed, 2006-09-27 17:05
	- there's no last viewed / accessed date - also note that such a timestamp would come at a performance penalty. you'd have to to change modules/core/ShowItem.inc or modules/core/classes/helpers/GalleryItemAttributesHelper_simple.class function incrementViewCount().

reinerk Joined: 2006-09-06 Posts: 12	Posted: Wed, 2006-09-27 17:25
	Ok. then this way via database won't work... What about to "crawl" through the albums and identify the last access date? With the name of the album i've got the name of the user (Because each member in my installation has only one album with none sub-albums) If i have the names of albums which are ununsed over a longer time i can delete the albums and their according db-entries. Could this be a way? Which db-entries have to be deleted?

Administrating Users and/or Items

XUser login