/adm/admin_album_personal.php

<?php
/**
*
* @package Icy Phoenix
* @version $Id$
* @copyright (c) 2008 Icy Phoenix
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

/**
*
* @Extra credits for this file
* Smartor (smartor_xp@hotmail.com)
*
*/

define('IN_ICYPHOENIX', true);

if(!empty($setmodules))
{
	$filename = basename(__FILE__);
	$module['2200_Photo_Album']['140_Personal_Galleries'] = $filename;
	return;
}

// Load default Header
if (!defined('IP_ROOT_PATH')) define('IP_ROOT_PATH', './../');
if (!defined('PHP_EXT')) define('PHP_EXT', substr(strrchr(__FILE__, '.'), 1));
require('pagestart.' . PHP_EXT);
require_once(IP_ROOT_PATH . 'language/lang_' . $config['default_lang'] . '/lang_album_main.' . PHP_EXT);
require_once(IP_ROOT_PATH . 'language/lang_' . $config['default_lang'] . '/lang_album_admin.' . PHP_EXT);

if(!isset($_POST['submit']))
{
	$template->set_filenames(array('body' => ADM_TPL . 'album_personal_body.tpl'));

	// Get the list of phpBB usergroups
	$sql = "SELECT group_id, group_name
			FROM " . GROUPS_TABLE . "
			WHERE group_single_user <> " . TRUE ."
			ORDER BY group_name ASC";
	$result = $db->sql_query($sql);

	while($row = $db->sql_fetchrow($result))
	{
		$groupdata[] = $row;
	}

	// Get the current album settings for non created personal galleries
	$sql = "SELECT *
			FROM ". ALBUM_CONFIG_TABLE ."
			WHERE config_name = 'personal_gallery_private'";
	$result = $db->sql_query($sql);
	$row = $db->sql_fetchrow($result);
	$private_groups = explode(',', $row['config_value']);

	// Since all personal galleries have the same private/moderator settings we fetch the first personal gallery and not all.
	$sql = "SELECT cat_id, cat_title, cat_view_groups, cat_upload_groups, cat_rate_groups, cat_comment_groups, cat_edit_groups, cat_delete_groups, cat_moderator_groups
			FROM ". ALBUM_CAT_TABLE ."
			WHERE cat_parent = 0 and cat_user_id != 0
			LIMIT 1";
	$result = $db->sql_query($sql);
	$thiscat = $db->sql_fetchrow($result);

	$view_groups = @explode(',', $thiscat['cat_view_groups']);
	$upload_groups = @explode(',', $thiscat['cat_upload_groups']);
	$rate_groups = @explode(',', $thiscat['cat_rate_groups']);
	$comment_groups = @explode(',', $thiscat['cat_comment_groups']);
	$edit_groups = @explode(',', $thiscat['cat_edit_groups']);
	$delete_groups = @explode(',', $thiscat['cat_delete_groups']);

	$moderator_groups = @explode(',', $thiscat['cat_moderator_groups']);

	for($i = 0; $i < sizeof($groupdata); $i++)
	{
		$template->assign_block_vars('creation_grouprow', array(
			'GROUP_ID' => $groupdata[$i]['group_id'],
			'GROUP_NAME' => $groupdata[$i]['group_name'],
			'PRIVATE_CHECKED' => (in_array($groupdata[$i]['group_id'], $private_groups)) ? 'checked="checked"' : ''
			) //end array
		);
		$template->assign_block_vars('grouprow', array(
			'GROUP_ID' => $groupdata[$i]['group_id'],
			'GROUP_NAME' => $groupdata[$i]['group_name'],
			'VIEW_CHECKED' => (in_array($groupdata[$i]['group_id'], $view_groups)) ? 'checked="checked"' : '',
			'UPLOAD_CHECKED' => (in_array($groupdata[$i]['group_id'], $upload_groups)) ? 'checked="checked"' : '',
			'RATE_CHECKED' => (in_array($groupdata[$i]['group_id'], $rate_groups)) ? 'checked="checked"' : '',
			'COMMENT_CHECKED' => (in_array($groupdata[$i]['group_id'], $comment_groups)) ? 'checked="checked"' : '',
			'EDIT_CHECKED' => (in_array($groupdata[$i]['group_id'], $edit_groups)) ? 'checked="checked"' : '',
			'DELETE_CHECKED' => (in_array($groupdata[$i]['group_id'], $delete_groups)) ? 'checked="checked"' : '',
			'MODERATOR_CHECKED' => (in_array($groupdata[$i]['group_id'], $moderator_groups)) ? 'checked="checked"' : '')
		);
	}

	$template->assign_vars(array(
		'L_ALBUM_PERSONAL_TITLE' => $lang['Album_personal_gallery_title'],
		'L_ALBUM_PERSONAL_EXPLAIN' => $lang['Album_personal_gallery_explain'],
		'L_ALBUM_AUTH_EXPLAIN' => $lang['Album_Personal_Auth_Explain'],
		'L_SUBMIT' => $lang['Submit'],
		'L_RESET' => $lang['Reset'],
		'L_GROUP_CONTROL' => $lang['Auth_Control_Group'],
		'L_GROUPS' => $lang['Usergroups'],
		'L_VIEW' => $lang['View'],
		'L_UPLOAD' => $lang['Upload'],
		'L_RATE' => $lang['Rate'],
		'L_COMMENT' => $lang['Comment'],
		'L_EDIT' => $lang['Edit'],
		'L_DELETE' => $lang['Delete'],
		'L_IS_MODERATOR' => $lang['Is_Moderator'],
		'L_PRIVATE_ACCESS' => $lang['Private_access'],
		'S_ALBUM_ACTION' => append_sid('admin_album_personal.' . PHP_EXT)
		)
	);

	$template->pparse('body');

	include('./page_footer_admin.' . PHP_EXT);
}
else
{
	// Now we update the datatabase
	$private_groups = @implode(',', $_POST['private']);
	$view_groups = @implode(',', $_POST['view']);
	$upload_groups = @implode(',', $_POST['upload']);
	$rate_groups = @implode(',', $_POST['rate']);
	$comment_groups = @implode(',', $_POST['comment']);
	$edit_groups = @implode(',', $_POST['edit']);
	$delete_groups = @implode(',', $_POST['delete']);
	$moderator_groups = @implode(',', $_POST['moderator']);

	// album config for non created personal galleries
	$sql = "UPDATE ". ALBUM_CONFIG_TABLE ."
			SET config_value = '$private_groups'
			WHERE config_name = 'personal_gallery_private'";
	$result = $db->sql_query($sql);

	$sql = "UPDATE ". ALBUM_CAT_TABLE ."
		SET cat_view_groups = '$view_groups', cat_upload_groups = '$upload_groups', cat_rate_groups = '$rate_groups', cat_comment_groups = '$comment_groups', cat_edit_groups = '$edit_groups', cat_delete_groups = '$delete_groups', cat_moderator_groups = '$moderator_groups'
		WHERE cat_user_id != 0";
	$result = $db->sql_query($sql);

	// okay, return a message...
	$message = $lang['Album_personal_successfully'] . '<br /><br />' . sprintf($lang['Click_return_album_personal'], '<a href="' . append_sid("admin_album_personal." . PHP_EXT) . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid('index.' . PHP_EXT . '?pane=right') . '">', '</a>');

	message_die(GENERAL_MESSAGE, $message);
}

?>