Moderators for Album pictures - Page 4 Moderators for Album pictures - Page 4
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

Moderators for Album pictures

Started by Abbas Ali, January 09, 2006, 09:01:58 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Abbas Ali

In delete.php (somewhere around line 290)

Replace


$query = "INSERT INTO {$CONFIG['TABLE_ALBUMS']} (category, title, uploads, pos) VALUES ('$category', '" . addslashes($op['album_nm']) . "', 'NO',  '{$op['album_sort']}')";


with


$query = "INSERT INTO {$CONFIG['TABLE_ALBUMS']} (category, title, uploads, pos, moderator_group) VALUES ('$category', '" . addslashes($op['album_nm']) . "', 'NO',  '{$op['album_sort']}', '2')";


Replace '2' (at the end of the statement with the group id of your moderator group.

This will cause all the new albums, including personal albums, to be assigned to moderator group for moderation.
Chief Geek at Ranium Systems

Daft

Blah! hmmm The only number id that seems to be working is 2 which sets registered users to moderator how do i grab the id of my moderator group? I've been poking around in SQL looking for it.

Daft

Disregard that last post I figured it out. friggin beautiful man :)

Thanks for the help the autoassign is working perfectly.

Daft

I dont know if its my bridge with phpbb (the bridge seems to function exceptionally) but I loaded a test account and placed it in the moderator group the album assigns the proper group so i know that is working but there is no change to the moderators account. Did not receive notification of upload approval in any capacity and had insufficient access to the URL of the approval section from my admin account.

Either I applied something incorrectly (i dont seem to have), Dont know what I am looking for to change, Or am missing the point of the mod.

Daft

My apologies for all the posts.

It seems as though the problem is the members of the moderator group are having their group_id overridden by the Registered groups ID in this case 2 as defined by the debug readout.

If you need additional information Id be more than happy to grab it for you.

Abbas Ali

Very difficult to say anything without actually seeing what is happening. PM me the admin account and a test user account along with a link to your cpg site and i will look into it.
Chief Geek at Ranium Systems

Daft

Still havn't figured out what the problem is moderators are still group_id 2 "Registered"

Abbas Ali

I think you didn't modified the editpics.php file properly. The "Edit" link for the album is shown to the moderator but when moderator goes to the edit page, permission denied error is shown. I have created an album "New Folder" in the root category. Login as "test" user and see the "Edit" link is shown besides it but when it is clicked permission denied error is shown.

Re-check your editpics.php and make sure you have done all the mods properly.
Chief Geek at Ranium Systems

Daft

Still cant think of anything the moderator group_id is 121 and is set as such in delete.php but my moderators still show up as 2 in debug.

Double checked editpics

is there a specific thing I should be looking for?

Abbas Ali

@Daft: Don't know what to tell you :(.
Chief Geek at Ranium Systems

Daft

Hmm.. Can you post some detailed uninstall instructions? I want to try reinstalling from scratch without running the risk of compromising my site. Hopefully it will work the second time around.

Joachim Müller

To uninstal, restore your backup (you should make backups before starting to modify files) or get vanilla copies of the modified files by downloading the coppermine package and extracting the files needed.
To undo the adding of the column (step one of the mod), run the queryALTER TABLE `cpgPrefix_albums` DROP `moderator_group`

Daft

Thanks Gaugau. Ill let you guys know if I have better luck this time. If I dont I intend to find out why and Ill give a report.

Hein Traag

Goodmorning!

I began installing this little mod by running the sql query on my DB but got this:
[code]Failed to execute SQL : SQL ALTER TABLE `cpgPrefix_albums` ADD `moderator_group` INT NOT NULL; failed : Table 'fototest.cpgPrefix_albums' doesn't exist


I am running 1.4.10 , what am i missing here ?

Hein[/code]

Abbas Ali

Replace cpgPrefix_ in the sql query with the prefix you are using. Ex cpg1410_.
Chief Geek at Ranium Systems

Hein Traag

 :-\ i should know better to post before i had a cup of coffee

Sorry Abbas

Hein Traag

Back again. Loaded the SQL statement. Added the files and edited dutch.php for the language part.
I created a Editor group to put the people in that i need. When i now go to the properties of a album i do get the option to add a moderated by selection. I select the Editor group and save. I then login as a user which has the rights to upload files and i upload 1 file. When i try to add the file to the album it says it can't and that it did (?).
I log out again and login as a Editor user.. i do get a menu option which links to editpics.php?mode=upload_approval But when i click on that links it says there is nothing to display.
Where am i going wrong ?

Regards,
Hein

Abbas Ali

Can't say anything unless i see what's happening. Can you please PM me the admin and one moderator account of your gallery along with its URL.
Chief Geek at Ranium Systems

ARTURLION

I've searched forum for this feature/mod for some time and finally I've found. (Great job, Abbas! ;)

It's quite enigmatic that there's no possibility to give access ONLY to edit descriptions of files w/o any other administrative functions. I've made it very dangerously by giving access to additional account of admin user with full access, INCLUDING EDITING DESCRIPTION OF FILES. But it's not safe for longer way...

Now I see with this mode it's possible BUT...

I've made test of deleting files by my new moderator user and I see... Yes, (s)he can delete files from the accesible/moderable albums (and of course edit descriptions, THX! ;)

I've read this whole topic but I think I've understood it's quite complicated but possible (maybe quite to quickly I've read it? ;P).

Abbas, can You advise me how to disable all DELETING options to moderator and give them ONLY access to edit descriptions of files?

I know it sounds I do not believe in my moderators so far but I don't like to backup whole gallery every time I give access to another person who can delete all files (but not album as one person here pointed ;).
We're talking about public albums, no user albums are available, I don't want to go this way... ;P

Impatiently I'm waiting for solution, thanks in advance ;)

Abbas Ali

I have attached a new editpics.php. Replace your existing one with this and see how it goes. Moderators should be denied with all delete functionalities including comment deletion, resetting views and votes etc...

Chief Geek at Ranium Systems