Topic: Moderators for Album pictures (Read 159493 times)

Abbas Ali · « **Reply #60 on:** November 15, 2006, 12:34:49 pm »

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

Code: [Select]

$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.

Daft · « **Reply #61 on:** November 15, 2006, 08:11:26 pm »

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 · « **Reply #62 on:** November 15, 2006, 08:31:39 pm »

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

Thanks for the help the autoassign is working perfectly.

Daft · « **Reply #63 on:** November 15, 2006, 11:14:04 pm »

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 · « **Reply #64 on:** November 16, 2006, 02:29:49 am »

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 · « **Reply #65 on:** November 16, 2006, 11:07:40 am »

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.

Daft · « **Reply #66 on:** November 25, 2006, 08:32:56 pm »

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

Abbas Ali · « **Reply #67 on:** November 27, 2006, 11:14:41 am »

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.

Daft · « **Reply #68 on:** November 28, 2006, 12:51:29 am »

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 · « **Reply #69 on:** December 05, 2006, 01:26:41 pm »

@Daft: Don't know what to tell you

.

Daft · « **Reply #70 on:** December 08, 2006, 07:35:47 am »

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 · « **Reply #71 on:** December 08, 2006, 07:45:03 am »

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 query

Code: [Select]

ALTER TABLE `cpgPrefix_albums` DROP `moderator_group`

Daft · « **Reply #72 on:** December 08, 2006, 07:46:42 am »

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 · « **Reply #73 on:** December 22, 2006, 09:42:19 am »

Code: [Select]

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 · « **Reply #74 on:** December 22, 2006, 10:20:14 am »

Replace cpgPrefix_ in the sql query with the prefix you are using. Ex cpg1410_.

Hein Traag · « **Reply #75 on:** December 22, 2006, 11:00:44 am »

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

Sorry Abbas

Hein Traag · « **Reply #76 on:** December 22, 2006, 01:07:53 pm »

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

Code: [Select]

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 · « **Reply #77 on:** December 28, 2006, 06:28:39 am »

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.

ARTURLION · « **Reply #78 on:** December 28, 2006, 11:37:29 pm »

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 · « **Reply #79 on:** December 29, 2006, 12:01:54 pm »

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...

News:

Author Topic: Moderators for Album pictures (Read 159493 times)