/**
* @dataProvider user_helpers_update_users_data
*/
public function test_user_helpers_update_users($user_ids, $data, $expected)
{
global $db;
$db = $this->new_dbal();
$this->assertEquals(true, phpbb_gallery_user_helpers::update_users($user_ids, $data));
$result = $db->sql_query('SELECT user_id, user_images
FROM ' . phpbb_gallery_user_base::sql_table());
$this->assertEquals($expected, $db->sql_fetchrowset($result));
}
/**
* @dataProvider user_base_validate_data_data
*/
public function test_user_base_validate_data($data, $allow_lower_0, $expected)
{
$this->assertEquals($expected, phpbb_gallery_user_base::validate_data($data, $allow_lower_0));
}
}
$user_cache[$user_id]['sig'] = bbcode_nl2br($user_cache[$user_id]['sig']);
$user_cache[$user_id]['sig'] = smiley_text($user_cache[$user_id]['sig']);
$user_cache[$user_id]['sig_parsed'] = true;
}
$template->assign_block_vars('commentrow', array('U_COMMENT' => phpbb_gallery_url::append_sid('image_page', "album_id={$album_id}&image_id={$image_id}&start={$start}&sort_order={$sort_order}") . '#' . $row['comment_id'], 'COMMENT_ID' => $row['comment_id'], 'TIME' => $user->format_date($row['comment_time']), 'TEXT' => generate_text_for_display($row['comment'], $row['comment_uid'], $row['comment_bitfield'], 7), 'EDIT_INFO' => $edit_info, 'U_DELETE' => phpbb_gallery::$auth->acl_check('m_comments', $album_id, $album_data['album_user_id']) || phpbb_gallery::$auth->acl_check('c_delete', $album_id, $album_data['album_user_id']) && $row['comment_user_id'] == $user->data['user_id'] && $user->data['is_registered'] ? phpbb_gallery_url::append_sid('posting', "album_id={$album_id}&image_id={$image_id}&mode=comment&submode=delete&comment_id=" . $row['comment_id']) : '', 'U_EDIT' => phpbb_gallery::$auth->acl_check('m_comments', $album_id, $album_data['album_user_id']) || phpbb_gallery::$auth->acl_check('c_edit', $album_id, $album_data['album_user_id']) && $row['comment_user_id'] == $user->data['user_id'] && $user->data['is_registered'] ? phpbb_gallery_url::append_sid('posting', "album_id={$album_id}&image_id={$image_id}&mode=comment&submode=edit&comment_id=" . $row['comment_id']) : '', 'U_INFO' => $auth->acl_get('a_') ? phpbb_gallery_url::append_sid('mcp', 'mode=whois&ip=' . $row['comment_user_ip']) : '', 'POST_AUTHOR_FULL' => get_username_string('full', $user_id, $row['comment_username'], $user_cache[$user_id]['user_colour']), 'POST_AUTHOR_COLOUR' => get_username_string('colour', $user_id, $row['comment_username'], $user_cache[$user_id]['user_colour']), 'POST_AUTHOR' => get_username_string('username', $user_id, $row['comment_username'], $user_cache[$user_id]['user_colour']), 'U_POST_AUTHOR' => get_username_string('profile', $user_id, $row['comment_username'], $user_cache[$user_id]['user_colour']), 'SIGNATURE' => $user_cache[$user_id]['sig'], 'RANK_TITLE' => $user_cache[$user_id]['rank_title'], 'RANK_IMG' => $user_cache[$user_id]['rank_image'], 'RANK_IMG_SRC' => $user_cache[$user_id]['rank_image_src'], 'POSTER_JOINED' => $user_cache[$user_id]['joined'], 'POSTER_POSTS' => $user_cache[$user_id]['posts'], 'POSTER_FROM' => $user_cache[$user_id]['from'], 'POSTER_AVATAR' => $user_cache[$user_id]['avatar'], 'POSTER_WARNINGS' => $user_cache[$user_id]['warnings'], 'POSTER_AGE' => $user_cache[$user_id]['age'], 'ICQ_STATUS_IMG' => $user_cache[$user_id]['icq_status_img'], 'ONLINE_IMG' => $user_id == ANONYMOUS || !$config['load_onlinetrack'] ? '' : ($user_cache[$user_id]['online'] ? $user->img('icon_user_online', 'ONLINE') : $user->img('icon_user_offline', 'OFFLINE')), 'S_ONLINE' => $user_id == ANONYMOUS || !$config['load_onlinetrack'] ? false : ($user_cache[$user_id]['online'] ? true : false), 'U_PROFILE' => $user_cache[$user_id]['profile'], 'U_SEARCH' => $user_cache[$user_id]['search'], 'U_PM' => $user_id != ANONYMOUS && $config['allow_privmsg'] && $auth->acl_get('u_sendpm') && ($user_cache[$user_id]['allow_pm'] || $auth->acl_gets('a_', 'm_')) ? phpbb_gallery_url::append_sid('phpbb', 'ucp', 'i=pm&mode=compose&u=' . $user_id) : '', 'U_EMAIL' => $user_cache[$user_id]['email'], 'U_WWW' => $user_cache[$user_id]['www'], 'U_ICQ' => $user_cache[$user_id]['icq'], 'U_AIM' => $user_cache[$user_id]['aim'], 'U_MSN' => $user_cache[$user_id]['msn'], 'U_YIM' => $user_cache[$user_id]['yim'], 'U_JABBER' => $user_cache[$user_id]['jabber'], 'U_GALLERY' => $user_cache[$user_id]['gallery_album'], 'GALLERY_IMAGES' => $user_cache[$user_id]['gallery_images'], 'U_GALLERY_SEARCH' => $user_cache[$user_id]['gallery_search']));
}
$db->sql_freeresult($result);
$template->assign_vars(array('DELETE_IMG' => $user->img('icon_post_delete', 'DELETE_COMMENT'), 'EDIT_IMG' => $user->img('icon_post_edit', 'EDIT_COMMENT'), 'INFO_IMG' => $user->img('icon_post_info', 'IP'), 'MINI_POST_IMG' => $user->img('icon_post_target_unread', 'COMMENT'), 'PAGE_NUMBER' => sprintf($user->lang['PAGE_OF'], floor($start / $config['posts_per_page']) + 1, ceil($image_data['image_comments'] / $config['posts_per_page'])), 'PAGINATION' => generate_pagination(phpbb_gallery_url::append_sid('image_page', "album_id={$album_id}&image_id={$image_id}&sort_order={$sort_order}"), $image_data['image_comments'], $config['posts_per_page'], $start)));
}
}
// Get the data of the image-uploader, if we don't have it from the comments anyway.
if (!isset($user_cache[$image_data['image_user_id']])) {
$sql = $db->sql_build_query('SELECT', array('SELECT' => 'u.*, gu.personal_album_id, gu.user_images', 'FROM' => array(USERS_TABLE => 'u'), 'LEFT_JOIN' => array(array('FROM' => array(phpbb_gallery_user_base::sql_table() => 'gu'), 'ON' => 'gu.user_id = u.user_id')), 'WHERE' => 'u.user_id = ' . $image_data['image_user_id']));
$result = $db->sql_query($sql);
$user_cache = array();
while ($row = $db->sql_fetchrow($result)) {
phpbb_gallery_user_base::add_user_to_user_cache($user_cache, $row);
}
$db->sql_freeresult($result);
}
if (phpbb_gallery::$auth->acl_check('m_status', $album_id, $album_data['album_user_id']) || $image_data['image_contest'] != phpbb_gallery_image::IN_CONTEST) {
$user_cache[$user_id]['username'] = $image_data['image_username'] ? $image_data['image_username'] : $user->lang['GUEST'];
$template->assign_vars(array('POSTER_FULL' => get_username_string('full', $user_id, $user_cache[$user_id]['username'], $user_cache[$user_id]['user_colour']), 'POSTER_COLOUR' => get_username_string('colour', $user_id, $user_cache[$user_id]['username'], $user_cache[$user_id]['user_colour']), 'POSTER_USERNAME' => get_username_string('username', $user_id, $user_cache[$user_id]['username'], $user_cache[$user_id]['user_colour']), 'U_POSTER' => get_username_string('profile', $user_id, $user_cache[$user_id]['username'], $user_cache[$user_id]['user_colour']), 'POSTER_SIGNATURE' => $user_cache[$user_id]['sig'], 'POSTER_RANK_TITLE' => $user_cache[$user_id]['rank_title'], 'POSTER_RANK_IMG' => $user_cache[$user_id]['rank_image'], 'POSTER_RANK_IMG_SRC' => $user_cache[$user_id]['rank_image_src'], 'POSTER_JOINED' => $user_cache[$user_id]['joined'], 'POSTER_POSTS' => $user_cache[$user_id]['posts'], 'POSTER_FROM' => $user_cache[$user_id]['from'], 'POSTER_AVATAR' => $user_cache[$user_id]['avatar'], 'POSTER_WARNINGS' => $user_cache[$user_id]['warnings'], 'POSTER_AGE' => $user_cache[$user_id]['age'], 'POSTER_ICQ_STATUS_IMG' => $user_cache[$user_id]['icq_status_img'], 'POSTER_ONLINE_IMG' => $user_id == ANONYMOUS || !$config['load_onlinetrack'] ? '' : ($user_cache[$user_id]['online'] ? $user->img('icon_user_online', 'ONLINE') : $user->img('icon_user_offline', 'OFFLINE')), 'S_POSTER_ONLINE' => $user_id == ANONYMOUS || !$config['load_onlinetrack'] ? false : ($user_cache[$user_id]['online'] ? true : false), 'U_POSTER_PROFILE' => $user_cache[$user_id]['profile'], 'U_POSTER_SEARCH' => $user_cache[$user_id]['search'], 'U_POSTER_PM' => $user_id != ANONYMOUS && $config['allow_privmsg'] && $auth->acl_get('u_sendpm') && ($user_cache[$user_id]['allow_pm'] || $auth->acl_gets('a_', 'm_')) ? phpbb_gallery_url::append_sid('phpbb', 'ucp', 'i=pm&mode=compose&u=' . $user_id) : '', 'U_POSTER_EMAIL' => $user_cache[$user_id]['email'], 'U_POSTER_WWW' => $user_cache[$user_id]['www'], 'U_POSTER_ICQ' => $user_cache[$user_id]['icq'], 'U_POSTER_AIM' => $user_cache[$user_id]['aim'], 'U_POSTER_MSN' => $user_cache[$user_id]['msn'], 'U_POSTER_YIM' => $user_cache[$user_id]['yim'], 'U_POSTER_JABBER' => $user_cache[$user_id]['jabber'], 'U_POSTER_GALLERY' => $user_cache[$user_id]['gallery_album'], 'POSTER_GALLERY_IMAGES' => $user_cache[$user_id]['gallery_images'], 'U_POSTER_GALLERY_SEARCH' => $user_cache[$user_id]['gallery_search']));
} else {
$template->assign_vars(array('POSTER_FULL' => sprintf($user->lang['CONTEST_USERNAME_LONG'], $user->format_date($album_data['contest_start'] + $album_data['contest_end'], false, true))));
}
$template->assign_vars(array('PROFILE_IMG' => $user->img('icon_user_profile', 'READ_PROFILE'), 'SEARCH_IMG' => $user->img('icon_user_search', 'SEARCH_USER_POSTS'), 'PM_IMG' => $user->img('icon_contact_pm', 'SEND_PRIVATE_MESSAGE'), 'EMAIL_IMG' => $user->img('icon_contact_email', 'SEND_EMAIL'), 'WWW_IMG' => $user->img('icon_contact_www', 'VISIT_WEBSITE'), 'ICQ_IMG' => $user->img('icon_contact_icq', 'ICQ'), 'AIM_IMG' => $user->img('icon_contact_aim', 'AIM'), 'MSN_IMG' => $user->img('icon_contact_msnm', 'MSNM'), 'YIM_IMG' => $user->img('icon_contact_yahoo', 'YIM'), 'JABBER_IMG' => $user->img('icon_contact_jabber', 'JABBER'), 'GALLERY_IMG' => $user->img('icon_contact_gallery', 'PERSONAL_ALBUM')));
page_header($user->lang['VIEW_IMAGE'] . ' - ' . $image_data['image_name'], false);
$template->set_filenames(array('body' => 'gallery/viewimage_body.html'));
page_footer();
