standard_error(fetch_error('invalidid', $vbphrase['picture'], $vbulletin->options['contactuslink'])); } $pictureinfo['adddate'] = vbdate($vbulletin->options['dateformat'], $pictureinfo['dateline'], true); $pictureinfo['addtime'] = vbdate($vbulletin->options['timeformat'], $pictureinfo['dateline']); $pictureurl = create_full_url("picture.php?albumid={$albuminfo['albumid']}&pictureid={$pictureinfo['pictureid']}"); if (!preg_match('#^[a-z]+://#i', $pictureurl)) { $pictureurl = $vbulletin->options['bburl'] . "/picture.php?albumid={$albuminfo['albumid']}&pictureid={$pictureinfo['pictureid']}"; } $pictureinfo['pictureurl'] = htmlspecialchars_uni($pictureurl); $pictureinfo['caption_censored'] = fetch_censored_text($pictureinfo['caption']); $show['picture_owner'] = $userinfo['userid'] == $vbulletin->userinfo['userid']; $show['edit_picture_option'] = ($userinfo['userid'] == $vbulletin->userinfo['userid'] or can_moderate(0, 'caneditalbumpicture')); $show['add_group_link'] = ($userinfo['userid'] == $vbulletin->userinfo['userid'] and $vbulletin->options['socnet'] & $vbulletin->bf_misc_socnet['enable_groups'] and $vbulletin->options['socnet_groups_albums_enabled'] and $vbulletin->userinfo['permissions']['socialgrouppermissions'] & $vbulletin->bf_ugp_socialgrouppermissions['canviewgroups'] and $vbulletin->userinfo['permissions']['socialgrouppermissions'] & $vbulletin->bf_ugp_socialgrouppermissions['canjoingroups'] and $pictureinfo['state'] != 'moderation'); $show['reportlink'] = ($vbulletin->userinfo['userid'] and ($vbulletin->options['rpforumid'] or $vbulletin->options['enableemail'] and $vbulletin->options['rpemail'])); $navpictures_sql = $db->query_read_slave("\n\t\tSELECT albumpicture.pictureid\n\t\tFROM " . TABLE_PREFIX . "albumpicture AS albumpicture\n\t\tINNER JOIN " . TABLE_PREFIX . "picture AS picture ON (albumpicture.pictureid = picture.pictureid)\n\t\tWHERE albumpicture.albumid = {$albuminfo['albumid']}\n\t\t" . ((!can_moderate(0, 'canmoderatepictures') and $pictureinfo['userid'] != $vbulletin->userinfo['userid']) ? "AND picture.state = 'visible'" : "") . "\n\t\tORDER BY albumpicture.dateline DESC\n\t"); $pic_location = fetch_picture_location_info($navpictures_sql, $pictureinfo['pictureid']); ($hook = vBulletinHook::fetch_hook('album_picture')) ? eval($hook) : false; if ($vbulletin->options['pc_enabled'] and $pictureinfo['state'] == 'visible') { require_once DIR . '/includes/functions_picturecomment.php'; $pagenumber = $vbulletin->GPC['pagenumber']; $perpage = $vbulletin->GPC['perpage']; $picturecommentbits = fetch_picturecommentbits($pictureinfo, $messagestats, $pagenumber, $perpage, $vbulletin->GPC['commentid'], $vbulletin->GPC['showignored']); $pagenavbits = array("albumid={$albuminfo['albumid']}", "pictureid={$pictureinfo['pictureid']}"); if ($perpage != $vbulletin->options['pc_perpage']) { $pagenavbits[] = "pp={$perpage}"; } if ($vbulletin->GPC['showignored']) { $pagenavbits[] = 'showignored=1'; } $pagenav = construct_page_nav($pagenumber, $perpage, $messagestats['total'], 'album.php?' . $vbulletin->session->vars['sessionurl'] . implode('&', $pagenavbits), ''); $editorid = fetch_picturecomment_editor($pictureinfo, $pagenumber, $messagestats);
} } $pictureinfo = fetch_socialgroup_picture($vbulletin->GPC['attachmentid'], $group['groupid']); if (!$pictureinfo) { standard_error(fetch_error('invalidid', $vbphrase['picture'], $vbulletin->options['contactuslink'])); } $pictureinfo['adddate'] = vbdate($vbulletin->options['dateformat'], $pictureinfo['dateline'], true); $pictureinfo['addtime'] = vbdate($vbulletin->options['timeformat'], $pictureinfo['dateline']); $pictureinfo['caption_html'] = nl2br(fetch_word_wrapped_string(fetch_censored_text($pictureinfo['caption']))); $pictureurl = create_full_url("attachment.php?attachmentid={$pictureinfo['attachmentid']}"); if (!preg_match('#^[a-z]+://#i', $pictureurl)) { $pictureurl = $vbulletin->options['bburl'] . "/attachment.php?attachmentid={$pictureinfo['attachmentid']}"; } $pictureinfo['pictureurl'] = $pictureurl; $navpictures_sql = $db->query_read_slave("\r\n\t\tSELECT\r\n\t\t\ta.attachmentid\r\n\t\tFROM " . TABLE_PREFIX . "attachment AS a\r\n\t\tINNER JOIN " . TABLE_PREFIX . "socialgroupmember AS socialgroupmember ON\r\n\t\t\t(socialgroupmember.userid = a.userid AND socialgroupmember.groupid = {$group['groupid']} AND socialgroupmember.type = 'member')\r\n\t\tWHERE\r\n\t\t\ta.contentid = {$group['groupid']}\r\n\t\t\t\tAND\r\n\t\t\ta.contenttypeid = {$contenttypeid}\r\n\t\tORDER BY a.dateline DESC\r\n\t"); $pic_location = fetch_picture_location_info($navpictures_sql, $pictureinfo['attachmentid']); $db->free_result($navpictures_sql); ($hook = vBulletinHook::fetch_hook('group_picture')) ? eval($hook) : false; $show['edit_picture_option'] = ($pictureinfo['userid'] == $vbulletin->userinfo['userid'] or can_moderate(0, 'caneditgrouppicture')); $show['remove_picture_option'] = ($pictureinfo['userid'] == $vbulletin->userinfo['userid'] or fetch_socialgroup_modperm('canremovepicture', $group)); $show['reportlink'] = ($vbulletin->userinfo['userid'] and ($vbulletin->options['rpforumid'] or $vbulletin->options['enableemail'] and $vbulletin->options['rpemail'])); if ($vbulletin->options['pc_enabled']) { require_once DIR . '/includes/functions_picturecomment.php'; $pagenumber = $vbulletin->GPC['pagenumber']; $perpage = $vbulletin->GPC['perpage']; $picturecommentbits = fetch_picturecommentbits($pictureinfo, $messagestats, $pagenumber, $perpage, $vbulletin->GPC['commentid'], $vbulletin->GPC['showignored']); $pagenavbits = array('do=picture', "groupid={$group['groupid']}", "attachmentid={$pictureinfo['attachmentid']}"); if ($perpage != $vbulletin->options['pc_perpage']) { $pagenavbits[] = "pp={$perpage}"; } if ($vbulletin->GPC['showignored']) {