/**
* Delete an image completly.
*
* @param array $images Array with the image_id(s)
* @param array $filenames Array with filenames for the image_ids. If a filename is missing it's queried from the database.
* Format: $image_id => $filename
*/
public static function delete_images($images, $filenames = array())
{
//@todo: phpbb_gallery_comment_base::delete_images($images);
//@todo: phpbb_gallery_report_base::delete_images($images);
//@todo: phpbb_gallery_favorite::delete_images($images);
//@todo: phpbb_gallery_watch::delete_images($images);
// Delete the files from the disc...
$need_filenames = array();
foreach ($images as $image) {
if (!isset($filenames[$image])) {
$need_filenames[] = $image;
}
}
$filenames = array_merge($filenames, self::get_filenames($need_filenames));
phpbb_gallery_image_file::delete($filenames);
// Delete the ratings...
phpbb_gallery_image_rating::delete_ratings($images);
$sql = 'DELETE FROM ' . GALLERY_IMAGES_TABLE . '
WHERE ' . $db->sql_in_set('image_id', $images);
$db->sql_query($sql);
return true;
}
function overview()
{
global $auth, $config, $db, $template, $user, $phpbb_ext_gallery, $table_prefix, $phpbb_dispatcher, $phpbb_root_path;
global $phpbb_container, $request;
$phpbbgallery_core_file = $phpbb_root_path . 'files/phpbbgallery/core';
$phpbbgallery_core_file_medium = $phpbb_root_path . 'files/phpbbgallery/core/medium';
$phpbbgallery_core_file_mini = $phpbb_root_path . 'files/phpbbgallery/core/mini';
$phpbbgallery_core_file_source = $phpbb_root_path . 'files/phpbbgallery/core/source';
$albums_table = $table_prefix . 'gallery_albums';
$roles_table = $table_prefix . 'gallery_roles';
$permissions_table = $table_prefix . 'gallery_permissions';
$modscache_table = $table_prefix . 'gallery_modscache';
$contests_table = $table_prefix . 'gallery_contests';
$users_table = $table_prefix . 'gallery_users';
$images_table = $table_prefix . 'gallery_images';
// Init album
$phpbb_ext_gallery_core_album = $phpbb_container->get('phpbbgallery.core.album');
// init users
$phpbb_gallery_user = $phpbb_container->get('phpbbgallery.core.user');
// init image
$phpbb_gallery_image = $phpbb_container->get('phpbbgallery.core.image');
// init config
$phpbb_ext_gallery_config = $phpbb_container->get('phpbbgallery.core.config');
$action = $request->variable('action', '');
$id = $request->variable('i', '');
$mode = 'overview';
// before we start let's check if directory structure is OK
if (!is_writable($phpbb_root_path . 'files')) {
$template->assign_vars(array('U_FILE_DIR_STATE' => $user->lang['NO_WRITE_ACCESS'], 'U_FILE_DIR_STATE_ERROR' => 1, 'U_CORE_DIR_STATE' => $user->lang['NO_WRITE_ACCESS'], 'U_CORE_DIR_STATE_ERROR' => 1, 'U_MEDIUM_DIR_STATE' => $user->lang['NO_WRITE_ACCESS'], 'U_MEDIUM_DIR_STATE_ERROR' => 1, 'U_MINI_DIR_STATE' => $user->lang['NO_WRITE_ACCESS'], 'U_MINI_DIR_STATE_ERROR' => 1, 'U_SOURCE_DIR_STATE' => $user->lang['NO_WRITE_ACCESS'], 'U_SOURCE_DIR_STATE_ERROR' => 1));
} else {
$template->assign_vars(array('U_FILE_DIR_STATE' => $user->lang['WRITE_ACCESS'], 'U_FILE_DIR_STATE_ERROR' => 0));
if (!file_exists($phpbbgallery_core_file)) {
mkdir($phpbbgallery_core_file, 0755, true);
$template->assign_vars(array('U_CORE_DIR_STATE' => $user->lang['DIR_CREATED'], 'U_CORE_DIR_STATE_ERROR' => 0));
} else {
if (is_writable($phpbbgallery_core_file)) {
$template->assign_vars(array('U_CORE_DIR_STATE' => $user->lang['WRITE_ACCESS'], 'U_CORE_DIR_STATE_ERROR' => 0));
} else {
$template->assign_vars(array('U_CORE_DIR_STATE' => $user->lang['NO_WRITE_ACCESS'], 'U_CORE_DIR_STATE_ERROR' => 1));
}
}
if (!file_exists($phpbbgallery_core_file_medium)) {
mkdir($phpbbgallery_core_file_medium, 0755, true);
$template->assign_vars(array('U_MEDIUM_DIR_STATE' => $user->lang['DIR_CREATED'], 'U_MEDIUM_DIR_STATE_ERROR' => 0));
} else {
if (is_writable($phpbbgallery_core_file_medium)) {
$template->assign_vars(array('U_MEDIUM_DIR_STATE' => $user->lang['WRITE_ACCESS'], 'U_MEDIUM_DIR_STATE_ERROR' => 0));
} else {
$template->assign_vars(array('U_MEDIUM_DIR_STATE' => $user->lang['NO_WRITE_ACCESS'], 'U_MEDIUM_DIR_STATE_ERROR' => 1));
}
}
if (!file_exists($phpbbgallery_core_file_mini)) {
mkdir($phpbbgallery_core_file_mini, 0755, true);
$template->assign_vars(array('U_MINI_DIR_STATE' => $user->lang['DIR_CREATED'], 'U_MINI_DIR_STATE_ERROR' => 0));
} else {
if (is_writable($phpbbgallery_core_file_mini)) {
$template->assign_vars(array('U_MINI_DIR_STATE' => $user->lang['WRITE_ACCESS'], 'U_MINI_DIR_STATE_ERROR' => 0));
} else {
$template->assign_vars(array('U_MINI_DIR_STATE' => $user->lang['NO_WRITE_ACCESS'], 'U_MINI_DIR_STATE_ERROR' => 1));
}
}
if (!file_exists($phpbbgallery_core_file_source)) {
mkdir($phpbbgallery_core_file_source, 0755, true);
$template->assign_vars(array('U_SOURCE_DIR_STATE' => $user->lang['DIR_CREATED'], 'U_SOURCE_DIR_STATE_ERROR' => 0));
} else {
if (is_writable($phpbbgallery_core_file_source)) {
$template->assign_vars(array('U_SOURCE_DIR_STATE' => $user->lang['WRITE_ACCESS'], 'U_SOURCE_DIR_STATE_ERROR' => 0));
} else {
$template->assign_vars(array('U_SOURCE_DIR_STATE' => $user->lang['NO_WRITE_ACCESS'], 'U_SOURCE_DIR_STATE_ERROR' => 1));
}
}
}
if (!confirm_box(true)) {
$confirm = false;
$album_id = 0;
switch ($action) {
case 'images':
$confirm = true;
$confirm_lang = 'RESYNC_IMAGECOUNTS_CONFIRM';
break;
case 'personals':
$confirm = true;
$confirm_lang = 'CONFIRM_OPERATION';
break;
case 'stats':
$confirm = true;
$confirm_lang = 'CONFIRM_OPERATION';
break;
case 'last_images':
$confirm = true;
$confirm_lang = 'CONFIRM_OPERATION';
break;
case 'reset_rating':
$album_id = $request->variable('reset_album_id', 0);
$album_data = $phpbb_ext_gallery_core_album->get_info($album_id);
$confirm = true;
$confirm_lang = sprintf($user->lang['RESET_RATING_CONFIRM'], $album_data['album_name']);
break;
case 'purge_cache':
$confirm = true;
$confirm_lang = 'GALLERY_PURGE_CACHE_EXPLAIN';
break;
case 'create_pega':
$confirm = false;
if (!$auth->acl_get('a_board')) {
trigger_error($user->lang['NO_AUTH_OPERATION'] . adm_back_link($this->u_action), E_USER_WARNING);
}
$username = $request->variable('username', '', true);
$user_id = 0;
if ($username) {
if (!function_exists('user_get_id_name')) {
$phpbb_ext_gallery->url->_include('functions_user', 'phpbb');
}
user_get_id_name($user_id, $username);
}
if (is_array($user_id)) {
$user_id = isset($user_id[0]) ? $user_id[0] : 0;
}
$sql = 'SELECT username, user_colour, user_id
FROM ' . USERS_TABLE . '
WHERE user_id = ' . $user_id;
$result = $db->sql_query($sql);
$user_row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
if (!$user_row) {
trigger_error($user->lang['NO_USER'] . adm_back_link($this->u_action), E_USER_WARNING);
}
$image_user = $phpbb_gallery_user->set_user_id($user_row['user_id']);
$album_id = $phpbb_gallery_user->get_data('personal_album_id');
if ($album_id) {
trigger_error($user->lang('PEGA_ALREADY_EXISTS', $user_row['username']) . adm_back_link($this->u_action), E_USER_WARNING);
}
$phpbb_ext_gallery_core_album->generate_personal_album($user_row['username'], $user_row['user_id'], $user_row['user_colour'], $phpbb_gallery_user);
trigger_error($user->lang('PEGA_CREATED', $user_row['username']) . adm_back_link($this->u_action));
break;
}
if ($confirm) {
confirm_box(false, $album_id ? $confirm_lang : $user->lang[$confirm_lang], build_hidden_fields(array('i' => $id, 'mode' => $mode, 'action' => $action, 'reset_album_id' => $album_id)));
}
} else {
switch ($action) {
case 'images':
if (!$auth->acl_get('a_board')) {
trigger_error($user->lang['NO_AUTH_OPERATION'] . adm_back_link($this->u_action), E_USER_WARNING);
}
$total_images = $total_comments = 0;
$phpbb_gallery_user->update_users('all', array('user_images' => 0));
$sql = 'SELECT COUNT(image_id) AS num_images, image_user_id AS user_id, SUM(image_comments) AS num_comments
FROM ' . $images_table . '
WHERE image_status <> ' . $phpbb_gallery_image::STATUS_UNAPPROVED . '
AND image_status <> ' . $phpbb_gallery_image::STATUS_ORPHAN . '
GROUP BY image_user_id';
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$total_images += $row['num_images'];
$total_comments += $row['num_comments'];
$image_user = $phpbb_container->get('phpbbgallery.core.user');
$image_user->set_user_id($row['user_id'], false);
$image_user->update_data(array('user_images' => $row['num_images']));
}
$db->sql_freeresult($result);
$phpbb_ext_gallery_config->set('num_images', $total_images);
$phpbb_ext_gallery_config->set('num_comments', $total_comments);
trigger_error($user->lang['RESYNCED_IMAGECOUNTS'] . adm_back_link($this->u_action));
break;
case 'personals':
if (!$auth->acl_get('a_board')) {
trigger_error($user->lang['NO_AUTH_OPERATION'] . adm_back_link($this->u_action), E_USER_WARNING);
}
$phpbb_gallery_user->update_users('all', array('personal_album_id' => 0));
$sql = 'SELECT album_id, album_user_id
FROM ' . $albums_table . '
WHERE album_user_id <> ' . $phpbb_ext_gallery_core_album::PUBLIC_ALBUM . '
AND parent_id = 0
GROUP BY album_user_id, album_id';
$result = $db->sql_query($sql);
$number_of_personals = 0;
while ($row = $db->sql_fetchrow($result)) {
$image_user = $phpbb_gallery_user->set_user_id($row['album_user_id'], false);
$phpbb_gallery_user->update_data(array('personal_album_id' => $row['album_id']));
$number_of_personals++;
}
$db->sql_freeresult($result);
$phpbb_ext_gallery_config->set('num_pegas', $number_of_personals);
// Update the config for the statistic on the index
$sql_array = array('SELECT' => 'a.album_id, u.user_id, u.username, u.user_colour', 'FROM' => array($albums_table => 'a'), 'LEFT_JOIN' => array(array('FROM' => array(USERS_TABLE => 'u'), 'ON' => 'u.user_id = a.album_user_id')), 'WHERE' => 'a.album_user_id <> ' . $phpbb_ext_gallery_core_album::PUBLIC_ALBUM . ' AND a.parent_id = 0', 'ORDER_BY' => 'a.album_id DESC');
$sql = $db->sql_build_query('SELECT', $sql_array);
$result = $db->sql_query_limit($sql, 1);
$newest_pgallery = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
$phpbb_ext_gallery_config->set('newest_pega_user_id', $newest_pgallery['user_id']);
$phpbb_ext_gallery_config->set('newest_pega_username', $newest_pgallery['username']);
$phpbb_ext_gallery_config->set('newest_pega_user_colour', $newest_pgallery['user_colour']);
$phpbb_ext_gallery_config->set('newest_pega_album_id', $newest_pgallery['album_id']);
trigger_error($user->lang['RESYNCED_PERSONALS'] . adm_back_link($this->u_action));
break;
case 'stats':
if (!$auth->acl_get('a_board')) {
trigger_error($user->lang['NO_AUTH_OPERATION'] . adm_back_link($this->u_action), E_USER_WARNING);
}
// Hopefully this won't take to long! >> I think we must make it batchwise
$sql = 'SELECT image_id, image_filename
FROM ' . $images_table . '
WHERE filesize_upload = 0';
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$sql_ary = array('filesize_upload' => @filesize($phpbb_ext_gallery->url->path('upload') . $row['image_filename']), 'filesize_medium' => @filesize($phpbb_ext_gallery->url->path('medium') . $row['image_filename']), 'filesize_cache' => @filesize($phpbb_ext_gallery->url->path('thumbnail') . $row['image_filename']));
$sql = 'UPDATE ' . $images_table . '
SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '
WHERE ' . $db->sql_in_set('image_id', $row['image_id']);
$db->sql_query($sql);
}
$db->sql_freeresult($result);
redirect($this->u_action);
break;
case 'last_images':
$sql = 'SELECT album_id
FROM ' . $albums_table;
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
// 5 sql's per album, but you don't run this daily ;)
$phpbb_ext_gallery_core_album::update_info($row['album_id']);
}
$db->sql_freeresult($result);
trigger_error($user->lang['RESYNCED_LAST_IMAGES'] . adm_back_link($this->u_action));
break;
case 'reset_rating':
$album_id = $request->variable('reset_album_id', 0);
$image_ids = array();
$sql = 'SELECT image_id
FROM ' . $images_table . '
WHERE image_album_id = ' . $album_id;
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$image_ids[] = $row['image_id'];
}
$db->sql_freeresult($result);
if (!empty($image_ids)) {
phpbb_gallery_image_rating::delete_ratings($image_ids, true);
}
trigger_error($user->lang['RESET_RATING_COMPLETED'] . adm_back_link($this->u_action));
break;
case 'purge_cache':
if ($user->data['user_type'] != USER_FOUNDER) {
trigger_error($user->lang['NO_AUTH_OPERATION'] . adm_back_link($this->u_action), E_USER_WARNING);
}
$cache_dir = @opendir($phpbb_ext_gallery->url->path('thumbnail'));
while ($cache_file = @readdir($cache_dir)) {
if (preg_match('/(\\.gif$|\\.png$|\\.jpg|\\.jpeg)$/is', $cache_file)) {
@unlink($phpbb_ext_gallery->url->path('thumbnail') . $cache_file);
}
}
@closedir($cache_dir);
$medium_dir = @opendir($phpbb_ext_gallery->url->path('medium'));
while ($medium_file = @readdir($medium_dir)) {
if (preg_match('/(\\.gif$|\\.png$|\\.jpg|\\.jpeg)$/is', $medium_file)) {
@unlink($phpbb_ext_gallery->url->path('medium') . $medium_file);
}
}
@closedir($medium_dir);
for ($i = 1; $i <= $phpbb_ext_gallery_config->get('current_upload_dir'); $i++) {
$cache_dir = @opendir($phpbb_ext_gallery->url->path('thumbnail') . $i . '/');
while ($cache_file = @readdir($cache_dir)) {
if (preg_match('/(\\.gif$|\\.png$|\\.jpg|\\.jpeg)$/is', $cache_file)) {
@unlink($phpbb_ext_gallery->url->path('thumbnail') . $i . '/' . $cache_file);
}
}
@closedir($cache_dir);
$medium_dir = @opendir($phpbb_ext_gallery->url->path('medium') . $i . '/');
while ($medium_file = @readdir($medium_dir)) {
if (preg_match('/(\\.gif$|\\.png$|\\.jpg|\\.jpeg)$/is', $medium_file)) {
@unlink($phpbb_ext_gallery->url->path('medium') . $i . '/' . $medium_file);
}
}
@closedir($medium_dir);
}
$sql_ary = array('filesize_medium' => 0, 'filesize_cache' => 0);
$sql = 'UPDATE ' . $images_table . '
SET ' . $db->sql_build_array('UPDATE', $sql_ary);
$db->sql_query($sql);
trigger_error($user->lang['PURGED_CACHE'] . adm_back_link($this->u_action));
break;
}
}
//@todo: phpbb_gallery_modversioncheck::check();
$boarddays = (time() - $config['board_startdate']) / 86400;
$images_per_day = sprintf('%.2f', $config['num_images'] / $boarddays);
$sql = 'SELECT COUNT(album_user_id) AS num_albums
FROM ' . $albums_table . '
WHERE album_user_id = 0';
$result = $db->sql_query($sql);
$num_albums = (int) $db->sql_fetchfield('num_albums');
$db->sql_freeresult($result);
$sql = 'SELECT SUM(filesize_upload) AS stat, SUM(filesize_medium) AS stat_medium, SUM(filesize_cache) AS stat_cache
FROM ' . $images_table;
$result = $db->sql_query($sql);
$dir_sizes = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
$template->assign_vars(array('S_GALLERY_OVERVIEW' => true, 'ACP_GALLERY_TITLE' => $user->lang['ACP_GALLERY_OVERVIEW'], 'ACP_GALLERY_TITLE_EXPLAIN' => $user->lang['ACP_GALLERY_OVERVIEW_EXPLAIN'], 'TOTAL_IMAGES' => $config['phpbb_gallery_num_images'], 'IMAGES_PER_DAY' => $images_per_day, 'TOTAL_ALBUMS' => $num_albums, 'TOTAL_PERSONALS' => $config['phpbb_gallery_num_pegas'], 'GUPLOAD_DIR_SIZE' => get_formatted_filesize($dir_sizes['stat']), 'MEDIUM_DIR_SIZE' => get_formatted_filesize($dir_sizes['stat_medium']), 'CACHE_DIR_SIZE' => get_formatted_filesize($dir_sizes['stat_cache']), 'GALLERY_VERSION' => $config['phpbb_gallery_version'], 'U_FIND_USERNAME' => $phpbb_ext_gallery->url->append_sid('phpbb', 'memberlist', 'mode=searchuser&form=action_create_pega_form&field=username&select_single=true'), 'S_SELECT_ALBUM' => $phpbb_ext_gallery_core_album->get_albumbox(false, 'reset_album_id', false, false, false, $phpbb_ext_gallery_core_album::PUBLIC_ALBUM, $phpbb_ext_gallery_core_album::TYPE_UPLOAD), 'S_FOUNDER' => $user->data['user_type'] == USER_FOUNDER ? true : false, 'U_ACTION' => $this->u_action));
}
/**
* Exif-Data
*/
if (phpbb_gallery_config::get('disp_exifdata') && $image_data['image_has_exif'] != phpbb_gallery_exif::UNAVAILABLE && substr($image_data['image_filename'], -4) == '.jpg' && function_exists('exif_read_data') && (phpbb_gallery::$auth->acl_check('m_status', $album_id, $album_data['album_user_id']) || $image_data['image_contest'] != phpbb_gallery_image::IN_CONTEST)) {
$exif = new phpbb_gallery_exif(phpbb_gallery_url::path('upload') . $image_data['image_filename'], $image_id);
$exif->interpret($image_data['image_has_exif'], $image_data['image_exif_data']);
if (!empty($exif->data["EXIF"])) {
$exif->send_to_template(phpbb_gallery::$user->get_data('user_viewexif'));
}
unset($exif);
}
/**
* Rating
*/
if (phpbb_gallery_config::get('allow_rates')) {
$rating = new phpbb_gallery_image_rating($image_id, $image_data, $album_data);
$user_rating = $rating->get_user_rating($user->data['user_id']);
// Check: User didn't rate yet, has permissions, it's not the users own image and the user is logged in
if (!$user_rating && $rating->is_allowed()) {
$rating->display_box();
}
$template->assign_vars(array('IMAGE_RATING' => $rating->get_image_rating($user_rating), 'S_ALLOWED_TO_RATE' => $rating->is_allowed(), 'S_VIEW_RATE' => phpbb_gallery::$auth->acl_check('i_rate', $album_id, $album_data['album_user_id']) ? true : false, 'S_COMMENT_ACTION' => phpbb_gallery_url::append_sid('posting', "album_id={$album_id}&image_id={$image_id}&mode=comment&submode=rate")));
unset($rating);
}
/**
* Posting comment
*/
if (phpbb_gallery_config::get('allow_comments') && phpbb_gallery::$auth->acl_check('c_post', $album_id, $album_data['album_user_id']) && $album_data['album_status'] != ITEM_LOCKED && ($image_data['image_status'] != phpbb_gallery_image::STATUS_LOCKED || phpbb_gallery::$auth->acl_check('m_status', $album_id, $album_data['album_user_id']))) {
$user->add_lang('posting');
phpbb_gallery_url::_include('functions_posting', 'phpbb');
$bbcode_status = $config['allow_bbcode'] ? true : false;
function overview()
{
global $auth, $config, $db, $template, $user;
$action = request_var('action', '');
$id = request_var('i', '');
$mode = 'overview';
if (!confirm_box(true)) {
$confirm = false;
$album_id = 0;
switch ($action) {
case 'images':
$confirm = true;
$confirm_lang = 'RESYNC_IMAGECOUNTS_CONFIRM';
break;
case 'personals':
$confirm = true;
$confirm_lang = 'CONFIRM_OPERATION';
break;
case 'stats':
$confirm = true;
$confirm_lang = 'CONFIRM_OPERATION';
break;
case 'last_images':
$confirm = true;
$confirm_lang = 'CONFIRM_OPERATION';
break;
case 'reset_rating':
$album_id = request_var('reset_album_id', 0);
$album_data = phpbb_gallery_album::get_info($album_id);
$confirm = true;
$confirm_lang = sprintf($user->lang['RESET_RATING_CONFIRM'], $album_data['album_name']);
break;
case 'purge_cache':
$confirm = true;
$confirm_lang = 'GALLERY_PURGE_CACHE_EXPLAIN';
break;
}
if ($confirm) {
confirm_box(false, $album_id ? $confirm_lang : $user->lang[$confirm_lang], build_hidden_fields(array('i' => $id, 'mode' => $mode, 'action' => $action, 'reset_album_id' => $album_id)));
}
} else {
switch ($action) {
case 'images':
if (!$auth->acl_get('a_board')) {
trigger_error($user->lang['NO_AUTH_OPERATION'] . adm_back_link($this->u_action), E_USER_WARNING);
}
$total_images = $total_comments = 0;
phpbb_gallery_user_helpers::update_users('all', array('user_images' => 0));
$sql = 'SELECT COUNT(image_id) num_images, image_user_id user_id, SUM(image_comments) AS num_comments
FROM ' . GALLERY_IMAGES_TABLE . '
WHERE image_status <> ' . phpbb_gallery_image::STATUS_UNAPPROVED . '
GROUP BY image_user_id';
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$total_images += $row['num_images'];
$total_comments += $row['num_comments'];
$image_user = new phpbb_gallery_user($db, $row['user_id'], false);
$image_user->update_data(array('user_images' => $row['num_images']));
}
$db->sql_freeresult($result);
phpbb_gallery_config::set('num_images', $total_images);
phpbb_gallery_config::set('num_comments', $total_comments);
trigger_error($user->lang['RESYNCED_IMAGECOUNTS'] . adm_back_link($this->u_action));
break;
case 'personals':
if (!$auth->acl_get('a_board')) {
trigger_error($user->lang['NO_AUTH_OPERATION'] . adm_back_link($this->u_action), E_USER_WARNING);
}
phpbb_gallery_user_helpers::update_users('all', array('personal_album_id' => 0));
$sql = 'SELECT album_id, album_user_id
FROM ' . GALLERY_ALBUMS_TABLE . '
WHERE album_user_id <> ' . phpbb_gallery_album::PUBLIC_ALBUM . '
AND parent_id = 0
GROUP BY album_user_id';
$result = $db->sql_query($sql);
$number_of_personals = 0;
while ($row = $db->sql_fetchrow($result)) {
$image_user = new phpbb_gallery_user($db, $row['album_user_id'], false);
$image_user->update_data(array('personal_album_id' => $row['album_id']));
$number_of_personals++;
}
$db->sql_freeresult($result);
phpbb_gallery_config::set('num_pegas', $number_of_personals);
// Update the config for the statistic on the index
$sql_array = array('SELECT' => 'a.album_id, u.user_id, u.username, u.user_colour', 'FROM' => array(GALLERY_ALBUMS_TABLE => 'a'), 'LEFT_JOIN' => array(array('FROM' => array(USERS_TABLE => 'u'), 'ON' => 'u.user_id = a.album_user_id')), 'WHERE' => 'a.album_user_id <> ' . phpbb_gallery_album::PUBLIC_ALBUM . ' AND a.parent_id = 0', 'ORDER_BY' => 'a.album_id DESC');
$sql = $db->sql_build_query('SELECT', $sql_array);
$result = $db->sql_query_limit($sql, 1);
$newest_pgallery = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
phpbb_gallery_config::set('newest_pega_user_id', $newest_pgallery['user_id']);
phpbb_gallery_config::set('newest_pega_username', $newest_pgallery['username']);
phpbb_gallery_config::set('newest_pega_user_colour', $newest_pgallery['user_colour']);
phpbb_gallery_config::set('newest_pega_album_id', $newest_pgallery['album_id']);
trigger_error($user->lang['RESYNCED_PERSONALS'] . adm_back_link($this->u_action));
break;
case 'stats':
if (!$auth->acl_get('a_board')) {
trigger_error($user->lang['NO_AUTH_OPERATION'] . adm_back_link($this->u_action), E_USER_WARNING);
}
// Hopefully this won't take to long! >> I think we must make it batchwise
$sql = 'SELECT image_id, image_filename, image_thumbnail
FROM ' . GALLERY_IMAGES_TABLE . '
WHERE filesize_upload = 0';
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$sql_ary = array('filesize_upload' => @filesize(phpbb_gallery_url::path('upload') . $row['image_filename']), 'filesize_medium' => @filesize(phpbb_gallery_url::path('medium') . $row['image_thumbnail']), 'filesize_cache' => @filesize(phpbb_gallery_url::path('cache') . $row['image_thumbnail']));
$sql = 'UPDATE ' . GALLERY_IMAGES_TABLE . '
SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '
WHERE ' . $db->sql_in_set('image_id', $row['image_id']);
$db->sql_query($sql);
}
$db->sql_freeresult($result);
redirect($this->u_action);
break;
case 'last_images':
$sql = 'SELECT album_id
FROM ' . GALLERY_ALBUMS_TABLE;
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
// 5 sql's per album, but you don't run this daily ;)
phpbb_gallery_album::update_info($row['album_id']);
}
$db->sql_freeresult($result);
trigger_error($user->lang['RESYNCED_LAST_IMAGES'] . adm_back_link($this->u_action));
break;
case 'reset_rating':
$album_id = request_var('reset_album_id', 0);
$image_ids = array();
$sql = 'SELECT image_id
FROM ' . GALLERY_IMAGES_TABLE . '
WHERE image_album_id = ' . $album_id;
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$image_ids[] = $row['image_id'];
}
$db->sql_freeresult($result);
phpbb_gallery_image_rating::delete_ratings($image_ids, true);
trigger_error($user->lang['RESET_RATING_COMPLETED'] . adm_back_link($this->u_action));
break;
case 'purge_cache':
if ($user->data['user_type'] != USER_FOUNDER) {
trigger_error($user->lang['NO_AUTH_OPERATION'] . adm_back_link($this->u_action), E_USER_WARNING);
}
$cache_dir = @opendir(phpbb_gallery_url::path('cache'));
while ($cache_file = @readdir($cache_dir)) {
if (preg_match('/(\\.gif$|\\.png$|\\.jpg|\\.jpeg)$/is', $cache_file)) {
@unlink(phpbb_gallery_url::path('cache') . $cache_file);
}
}
@closedir($cache_dir);
$medium_dir = @opendir(phpbb_gallery_url::path('medium'));
while ($medium_file = @readdir($medium_dir)) {
if (preg_match('/(\\.gif$|\\.png$|\\.jpg|\\.jpeg)$/is', $medium_file)) {
@unlink(phpbb_gallery_url::path('medium') . $medium_file);
}
}
@closedir($medium_dir);
$sql_ary = array('filesize_medium' => 0, 'filesize_cache' => 0);
$sql = 'UPDATE ' . GALLERY_IMAGES_TABLE . '
SET ' . $db->sql_build_array('UPDATE', $sql_ary);
$db->sql_query($sql);
trigger_error($user->lang['PURGED_CACHE'] . adm_back_link($this->u_action));
break;
}
}
phpbb_gallery_modversioncheck::check();
$boarddays = (time() - $config['board_startdate']) / 86400;
$images_per_day = sprintf('%.2f', phpbb_gallery_config::get('num_images') / $boarddays);
$sql = 'SELECT COUNT(album_user_id) num_albums
FROM ' . GALLERY_ALBUMS_TABLE . '
WHERE album_user_id = 0';
$result = $db->sql_query($sql);
$num_albums = (int) $db->sql_fetchfield('num_albums');
$db->sql_freeresult($result);
$sql = 'SELECT SUM(filesize_upload) as stat, SUM(filesize_medium) as stat_medium, SUM(filesize_cache) as stat_cache
FROM ' . GALLERY_IMAGES_TABLE;
$result = $db->sql_query($sql);
$dir_sizes = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
$template->assign_vars(array('S_GALLERY_OVERVIEW' => true, 'ACP_GALLERY_TITLE' => $user->lang['ACP_GALLERY_OVERVIEW'], 'ACP_GALLERY_TITLE_EXPLAIN' => $user->lang['ACP_GALLERY_OVERVIEW_EXPLAIN'], 'TOTAL_IMAGES' => phpbb_gallery_config::get('num_images'), 'IMAGES_PER_DAY' => $images_per_day, 'TOTAL_ALBUMS' => $num_albums, 'TOTAL_PERSONALS' => phpbb_gallery_config::get('num_pegas'), 'GUPLOAD_DIR_SIZE' => get_formatted_filesize($dir_sizes['stat']), 'MEDIUM_DIR_SIZE' => get_formatted_filesize($dir_sizes['stat_medium']), 'CACHE_DIR_SIZE' => get_formatted_filesize($dir_sizes['stat_cache']), 'GALLERY_VERSION' => phpbb_gallery_config::get('version'), 'S_FOUNDER' => $user->data['user_type'] == USER_FOUNDER ? true : false));
}
}
}
}
break;
}
}
break;
case 'comment':
if ($mode == 'comment') {
$comment = $comment_username = $s_captcha_hidden_fields = '';
$comment_username_req = $contest_rating_msg = false;
/**
* Rating-System: now you can comment and rate in one form
*/
if (phpbb_gallery_config::get('allow_rates') && $submode != 'edit') {
$rating = new phpbb_gallery_image_rating($image_id, $image_data, $album_data);
$user_rating = $rating->get_user_rating($user->data['user_id']);
// Check: User didn't rate yet, has permissions, it's not the users own image and the user is logged in
if (!$user_rating && $rating->is_allowed()) {
$rating->display_box();
// User just rated the image, so we store it
$rate_point = request_var('rating', 0);
if ($rating->rating_enabled && $rate_point > 0) {
$rating->submit_rating();
$message .= $user->lang['RATING_SUCCESSFUL'] . '<br />';
}
}
$template->assign_vars(array('S_ALLOWED_TO_RATE' => $rating->is_allowed()));
if ($submode == 'rate') {
$s_album_action = '';
}
