[phpbbreloaded-checkins] SF.net SVN: phpbbreloaded: [283] main/trunk
Status: Planning
Brought to you by:
tehphpmaster
Menu
▾
▴
[phpbbreloaded-checkins] SF.net SVN: phpbbreloaded: [283] main/trunk
|
From: <teh...@us...> - 2007-04-13 22:50:02
|
Revision: 283
http://svn.sourceforge.net/phpbbreloaded/?rev=283&view=rev
Author: tehphpmaster
Date: 2007-04-13 15:50:02 -0700 (Fri, 13 Apr 2007)
Log Message:
-----------
Clearing out the trunk...
Removed Paths:
-------------
main/trunk/admin/
main/trunk/cache/
main/trunk/common.php
main/trunk/config.php
main/trunk/db/
main/trunk/extension.inc
main/trunk/extras/
main/trunk/extras_config.php
main/trunk/faq.php
main/trunk/groupcp.php
main/trunk/images/
main/trunk/includes/
main/trunk/index.php
main/trunk/install/
main/trunk/language/
main/trunk/login.php
main/trunk/memberlist.php
main/trunk/modcp.php
main/trunk/posting.php
main/trunk/privmsg.php
main/trunk/profile.php
main/trunk/search.php
main/trunk/templates/
main/trunk/viewforum.php
main/trunk/viewonline.php
main/trunk/viewtopic.php
Deleted: main/trunk/common.php
===================================================================
--- main/trunk/common.php 2006-12-31 16:08:16 UTC (rev 282)
+++ main/trunk/common.php 2007-04-13 22:50:02 UTC (rev 283)
@@ -1,253 +0,0 @@
-<?php
-/***************************************************************************
- * common.php
- * -------------------
- * begin : Saturday, Feb 23, 2001
- * copyright : (C) 2001 The phpBB Group
- * email : su...@ph...
- *
- * $Id: common.php,v 1.74.2.25 2006/05/26 17:46:59 grahamje Exp $
- *
- ***************************************************************************/
-
-/***************************************************************************
- *
- * This program is free software; you can redistribute it and/or modify
- * it under the terms of the GNU General Public License as published by
- * the Free Software Foundation; either version 2 of the License, or
- * (at your option) any later version.
- *
- ***************************************************************************/
-
-if ( !defined('IN_PHPBB') )
-{
- die("Hacking attempt");
-}
-
-//
-error_reporting (E_ERROR | E_WARNING | E_PARSE); // This will NOT report uninitialized variables
-set_magic_quotes_runtime(0); // Disable magic_quotes_runtime
-
-// The following code (unsetting globals)
-// Thanks to Matt Kavanagh and Stefan Esser for providing feedback as well as patch files
-
-// PHP5 with register_long_arrays off?
-if (@phpversion() >= '5.0.0' && (!@ini_get('register_long_arrays') || @ini_get('register_long_arrays') == '0' || strtolower(@ini_get('register_long_arrays')) == 'off'))
-{
- $HTTP_POST_VARS = $_POST;
- $HTTP_GET_VARS = $_GET;
- $HTTP_SERVER_VARS = $_SERVER;
- $HTTP_COOKIE_VARS = $_COOKIE;
- $HTTP_ENV_VARS = $_ENV;
- $HTTP_POST_FILES = $_FILES;
-
- // _SESSION is the only superglobal which is conditionally set
- if (isset($_SESSION))
- {
- $HTTP_SESSION_VARS = $_SESSION;
- }
-}
-
-// Protect against GLOBALS tricks
-if (isset($HTTP_POST_VARS['GLOBALS']) || isset($HTTP_POST_FILES['GLOBALS']) || isset($HTTP_GET_VARS['GLOBALS']) || isset($HTTP_COOKIE_VARS['GLOBALS']))
-{
- die("Hacking attempt");
-}
-
-// Protect against HTTP_SESSION_VARS tricks
-if (isset($HTTP_SESSION_VARS) && !is_array($HTTP_SESSION_VARS))
-{
- die("Hacking attempt");
-}
-
-if (@ini_get('register_globals') == '1' || strtolower(@ini_get('register_globals')) == 'on')
-{
- // PHP4+ path
- $not_unset = array('HTTP_GET_VARS', 'HTTP_POST_VARS', 'HTTP_COOKIE_VARS', 'HTTP_SERVER_VARS', 'HTTP_SESSION_VARS', 'HTTP_ENV_VARS', 'HTTP_POST_FILES', 'phpEx', 'phpbb_root_path');
-
- // Not only will array_merge give a warning if a parameter
- // is not an array, it will actually fail. So we check if
- // HTTP_SESSION_VARS has been initialised.
- if (!isset($HTTP_SESSION_VARS) || !is_array($HTTP_SESSION_VARS))
- {
- $HTTP_SESSION_VARS = array();
- }
-
- // Merge all into one extremely huge array; unset
- // this later
- $input = array_merge($HTTP_GET_VARS, $HTTP_POST_VARS, $HTTP_COOKIE_VARS, $HTTP_SERVER_VARS, $HTTP_SESSION_VARS, $HTTP_ENV_VARS, $HTTP_POST_FILES);
-
- unset($input['input']);
- unset($input['not_unset']);
-
- while (list($var,) = @each($input))
- {
- if (in_array($var, $not_unset))
- {
- die('Hacking attempt!');
- }
- unset($$var);
- }
-
- unset($input);
-}
-
-//
-// addslashes to vars if magic_quotes_gpc is off
-// this is a security precaution to prevent someone
-// trying to break out of a SQL statement.
-//
-if( !get_magic_quotes_gpc() )
-{
- if( is_array($HTTP_GET_VARS) )
- {
- while( list($k, $v) = each($HTTP_GET_VARS) )
- {
- if( is_array($HTTP_GET_VARS[$k]) )
- {
- while( list($k2, $v2) = each($HTTP_GET_VARS[$k]) )
- {
- $HTTP_GET_VARS[$k][$k2] = addslashes($v2);
- }
- @reset($HTTP_GET_VARS[$k]);
- }
- else
- {
- $HTTP_GET_VARS[$k] = addslashes($v);
- }
- }
- @reset($HTTP_GET_VARS);
- }
-
- if( is_array($HTTP_POST_VARS) )
- {
- while( list($k, $v) = each($HTTP_POST_VARS) )
- {
- if( is_array($HTTP_POST_VARS[$k]) )
- {
- while( list($k2, $v2) = each($HTTP_POST_VARS[$k]) )
- {
- $HTTP_POST_VARS[$k][$k2] = addslashes($v2);
- }
- @reset($HTTP_POST_VARS[$k]);
- }
- else
- {
- $HTTP_POST_VARS[$k] = addslashes($v);
- }
- }
- @reset($HTTP_POST_VARS);
- }
-
- if( is_array($HTTP_COOKIE_VARS) )
- {
- while( list($k, $v) = each($HTTP_COOKIE_VARS) )
- {
- if( is_array($HTTP_COOKIE_VARS[$k]) )
- {
- while( list($k2, $v2) = each($HTTP_COOKIE_VARS[$k]) )
- {
- $HTTP_COOKIE_VARS[$k][$k2] = addslashes($v2);
- }
- @reset($HTTP_COOKIE_VARS[$k]);
- }
- else
- {
- $HTTP_COOKIE_VARS[$k] = addslashes($v);
- }
- }
- @reset($HTTP_COOKIE_VARS);
- }
-}
-
-//
-// Define some basic configuration arrays this also prevents
-// malicious rewriting of language and otherarray values via
-// URI params
-//
-$board_config = array();
-$userdata = array();
-$theme = array();
-$images = array();
-$lang = array();
-$nav_links = array();
-$dss_seeded = false;
-$gen_simple_header = FALSE;
-
-include($phpbb_root_path . 'config.'.$phpEx);
-
-/*******************************************************************************
- * Include support for phpBBreloaded extra packages now.
- ******************************************************************************/
-include($phpbb_root_path . 'extras_config.'.$phpEx);
-
-if( !defined("PHPBB_INSTALLED") )
-{
- header('Location: ' . $phpbb_root_path . 'install/install.' . $phpEx);
- exit;
-}
-
-include($phpbb_root_path . 'includes/constants.'.$phpEx);
-include($phpbb_root_path . 'includes/template.'.$phpEx);
-include($phpbb_root_path . 'includes/sessions.'.$phpEx);
-include($phpbb_root_path . 'includes/auth.'.$phpEx);
-include($phpbb_root_path . 'includes/functions.'.$phpEx);
-include($phpbb_root_path . 'includes/db.'.$phpEx);
-
-/*******************************************************************************
- * If specified, include the 'Bad Behaviour' code now...
- * http://homelandstupidity.us/software/bad-behavior/
- * I have placed this here as I may want access to the db functions later in
- * order to utilise the Bad Behaviour logging. For now it's a simple spam
- * blocker!
- ******************************************************************************/
-if(defined('BAD_BEHAVIOUR_ROOT'))
-{
- include(BAD_BEHAVIOUR_ROOT . 'bad-behavior-phpBBreloaded.'.$phpEx);
-}
-
-// We do not need this any longer, unset for safety purposes
-unset($dbpasswd);
-
-//
-// Obtain and encode users IP
-//
-// I'm removing HTTP_X_FORWARDED_FOR ... this may well cause other problems such as
-// private range IP's appearing instead of the guilty routable IP, tough, don't
-// even bother complaining ... go scream and shout at the idiots out there who feel
-// "clever" is doing harm rather than good ... karma is a great thing ... :)
-//
-$client_ip = ( !empty($HTTP_SERVER_VARS['REMOTE_ADDR']) ) ? $HTTP_SERVER_VARS['REMOTE_ADDR'] : ( ( !empty($HTTP_ENV_VARS['REMOTE_ADDR']) ) ? $HTTP_ENV_VARS['REMOTE_ADDR'] : getenv('REMOTE_ADDR') );
-$user_ip = encode_ip($client_ip);
-
-//
-// Setup forum wide options, if this fails
-// then we output a CRITICAL_ERROR since
-// basic forum information is not available
-//
-$sql = "SELECT *
- FROM " . CONFIG_TABLE;
-if( !($result = $db->sql_query($sql)) )
-{
- message_die(CRITICAL_ERROR, "Could not query config information", "", __LINE__, __FILE__, $sql);
-}
-
-while ( $row = $db->sql_fetchrow($result) )
-{
- $board_config[$row['config_name']] = $row['config_value'];
-}
-
-if (file_exists('install') || file_exists('contrib'))
-{
- message_die(GENERAL_MESSAGE, 'Please_remove_install_contrib');
-}
-
-//
-// Show 'Board is disabled' message if needed.
-//
-if( $board_config['board_disable'] && !defined("IN_ADMIN") && !defined("IN_LOGIN") )
-{
- message_die(GENERAL_MESSAGE, 'Board_disable', 'Information');
-}
-
-?>
\ No newline at end of file
Deleted: main/trunk/config.php
===================================================================
Deleted: main/trunk/extension.inc
===================================================================
--- main/trunk/extension.inc 2006-12-31 16:08:16 UTC (rev 282)
+++ main/trunk/extension.inc 2007-04-13 22:50:02 UTC (rev 283)
@@ -1,26 +0,0 @@
-<?php
-/***************************************************************************
- * extension.inc
- * -------------------
- * begin : Saturday, Feb 13, 2001
- * copyright : (C) 2001 The phpBB Group
- * email : su...@ph...
- *
- * $Id: extension.inc,v 1.5 2002/04/04 11:52:50 psotfx Exp $
- *
- *
- ***************************************************************************/
-
-if ( !defined('IN_PHPBB') )
-{
- die("Hacking attempt");
-}
-
-//
-// Change this if your extension is not .php!
-//
-$phpEx = "php";
-
-$starttime = 0;
-
-?>
\ No newline at end of file
Deleted: main/trunk/extras_config.php
===================================================================
--- main/trunk/extras_config.php 2006-12-31 16:08:16 UTC (rev 282)
+++ main/trunk/extras_config.php 2007-04-13 22:50:02 UTC (rev 283)
@@ -1,68 +0,0 @@
-<?php
-/*******************************************************************************
- * extras_config.php
- * -------------------
- * begin : Sunday, Dec 31, 2006
- * copyright : (C) 2006 The phpBBreloaded Group
- * website : www.phpbbreloaded.org
- *
- * $Id: extras_config.php,v 1.0 2006/12/30 14:46:59 mjnr Exp $
- *
- ******************************************************************************/
-
-/*******************************************************************************
- *
- * This program is free software; you can redistribute it and/or modify
- * it under the terms of the GNU General Public License as published by
- * the Free Software Foundation; either version 2 of the License, or
- * (at your option) any later version.
- *
- ******************************************************************************/
-
-/*******************************************************************************
- * Use this file to configure the basics for using any phpBBreloaded 'extras',
- * such as location, whether to use, etc..
- *
- * My suggestion is to only use the 'extras' section/folder to store addins
- * that are developed independantly from the phpBBreloaded core. This will give
- * us an easy avenue into package management in the future for easy upgrades
- * to our users as these packages are upgraded indendantly of the main
- * phpBBreloaded source.
- *
- * This file is included from ./common.php so you should not have to
- * specifically link to it unless you're doiing something funky. In which case
- * make sure you have defined 'IN_PHPBB' first!
- *
- * MJ 20061231
- ******************************************************************************/
-
-if ( !defined('IN_PHPBB') )
-{
- die("Hacking attempt");
-}
-
-/*******************************************************************************
- * Comment out this definition to disable the Bad Behaviour anti spam-bot
- * module. Otherwise, use this definition to point to the location of the
- * Bad Behaviour root folder.
- * NOTE: I can only presume behavior is how they spell it in America. In
- * terms of the definitions I will use the British way. In all other aspects
- * (the directory structure etc.) I will use the American way. This should
- * allow easy package upgrades.
- ******************************************************************************/
-define('BAD_BEHAVIOUR_ROOT', $phpbb_root_path . 'extras/Bad-Behavior/');
-
-/*******************************************************************************
- * Comment out this definition to disable the !!HIGHLY ALPHA!! XML module
- * being developed by mjnr <mailto:mj...@us...>. Otherwise use
- * this definition to point to the location of the XML root folder.
- ******************************************************************************/
-//define('MJS_XML_ROOT', $phpbb_root_path . 'extras/mjsXML/');
-
-/*******************************************************************************
- * Comment out this definition to disable the !!HIGHLY ALPHA!! package
- * management modules.
- * TODO: Integrate the package manager into the admin console?
- ******************************************************************************/
-//define('PPM_LIB', $phpbb_root_path . 'includes/ppm_lib.'.$phpEx);
-?>
\ No newline at end of file
Deleted: main/trunk/faq.php
===================================================================
--- main/trunk/faq.php 2006-12-31 16:08:16 UTC (rev 282)
+++ main/trunk/faq.php 2007-04-13 22:50:02 UTC (rev 283)
@@ -1,150 +0,0 @@
-<?php
-/***************************************************************************
- * faq.php
- * -------------------
- * begin : Sunday, Jul 8, 2001
- * copyright : (C) 2001 The phpBB Group
- * email : su...@ph...
- *
- * $Id: faq.php,v 1.14.2.2 2004/07/11 16:46:15 acydburn Exp $
- *
- *
- ***************************************************************************/
-
-/***************************************************************************
- *
- * This program is free software; you can redistribute it and/or modify
- * it under the terms of the GNU General Public License as published by
- * the Free Software Foundation; either version 2 of the License, or
- * (at your option) any later version.
- *
- ***************************************************************************/
-
-define('IN_PHPBB', true);
-$phpbb_root_path = './';
-include($phpbb_root_path . 'extension.inc');
-include($phpbb_root_path . 'common.'.$phpEx);
-
-//
-// Start session management
-//
-$userdata = session_pagestart($user_ip, PAGE_FAQ);
-init_userprefs($userdata);
-//
-// End session management
-//
-
-// Set vars to prevent naughtiness
-$faq = array();
-
-//
-// Load the appropriate faq file
-//
-if( isset($HTTP_GET_VARS['mode']) )
-{
- switch( $HTTP_GET_VARS['mode'] )
- {
- case 'bbcode':
- $lang_file = 'lang_bbcode';
- $l_title = $lang['BBCode_guide'];
- break;
- default:
- $lang_file = 'lang_faq';
- $l_title = $lang['FAQ'];
- break;
- }
-}
-else
-{
- $lang_file = 'lang_faq';
- $l_title = $lang['FAQ'];
-}
-include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/' . $lang_file . '.' . $phpEx);
-
-//
-// Pull the array data from the lang pack
-//
-$j = 0;
-$counter = 0;
-$counter_2 = 0;
-$faq_block = array();
-$faq_block_titles = array();
-
-for($i = 0; $i < count($faq); $i++)
-{
- if( $faq[$i][0] != '--' )
- {
- $faq_block[$j][$counter]['id'] = $counter_2;
- $faq_block[$j][$counter]['question'] = $faq[$i][0];
- $faq_block[$j][$counter]['answer'] = $faq[$i][1];
-
- $counter++;
- $counter_2++;
- }
- else
- {
- $j = ( $counter != 0 ) ? $j + 1 : 0;
-
- $faq_block_titles[$j] = $faq[$i][1];
-
- $counter = 0;
- }
-}
-
-//
-// Lets build a page ...
-//
-$page_title = $l_title;
-include($phpbb_root_path . 'includes/page_header.'.$phpEx);
-
-$template->set_filenames(array(
- 'body' => 'faq_body.tpl')
-);
-make_jumpbox('viewforum.'.$phpEx);
-
-$template->assign_vars(array(
- 'L_FAQ_TITLE' => $l_title,
- 'L_BACK_TO_TOP' => $lang['Back_to_top'])
-);
-
-for($i = 0; $i < count($faq_block); $i++)
-{
- if( count($faq_block[$i]) )
- {
- $template->assign_block_vars('faq_block', array(
- 'BLOCK_TITLE' => $faq_block_titles[$i])
- );
- $template->assign_block_vars('faq_block_link', array(
- 'BLOCK_TITLE' => $faq_block_titles[$i])
- );
-
- for($j = 0; $j < count($faq_block[$i]); $j++)
- {
- $row_color = ( !($j % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
- $row_class = ( !($j % 2) ) ? $theme['td_class1'] : $theme['td_class2'];
-
- $template->assign_block_vars('faq_block.faq_row', array(
- 'ROW_COLOR' => '#' . $row_color,
- 'ROW_CLASS' => $row_class,
- 'FAQ_QUESTION' => $faq_block[$i][$j]['question'],
- 'FAQ_ANSWER' => $faq_block[$i][$j]['answer'],
-
- 'U_FAQ_ID' => $faq_block[$i][$j]['id'])
- );
-
- $template->assign_block_vars('faq_block_link.faq_row_link', array(
- 'ROW_COLOR' => '#' . $row_color,
- 'ROW_CLASS' => $row_class,
- 'FAQ_LINK' => $faq_block[$i][$j]['question'],
-
- 'U_FAQ_LINK' => '#' . $faq_block[$i][$j]['id'])
- );
- }
- }
-}
-
-$template->pparse('body');
-
-include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
-
-?>
\ No newline at end of file
Deleted: main/trunk/groupcp.php
===================================================================
--- main/trunk/groupcp.php 2006-12-31 16:08:16 UTC (rev 282)
+++ main/trunk/groupcp.php 2007-04-13 22:50:02 UTC (rev 283)
@@ -1,1284 +0,0 @@
-<?php
-/***************************************************************************
- * groupcp.php
- * -------------------
- * begin : Saturday, Feb 13, 2001
- * copyright : (C) 2001 The phpBB Group
- * email : su...@ph...
- *
- * $Id: groupcp.php,v 1.58.2.27 2006/12/16 13:11:24 acydburn Exp $
- *
- *
- ***************************************************************************/
-
-/***************************************************************************
- *
- * This program is free software; you can redistribute it and/or modify
- * it under the terms of the GNU General Public License as published by
- * the Free Software Foundation; either version 2 of the License, or
- * (at your option) any later version.
- *
- ***************************************************************************/
-
-define('IN_PHPBB', true);
-$phpbb_root_path = './';
-include($phpbb_root_path . 'extension.inc');
-include($phpbb_root_path . 'common.'.$phpEx);
-
-// -------------------------
-//
-function generate_user_info(&$row, $date_format, $group_mod, &$from, &$posts, &$joined, &$poster_avatar, &$profile_img, &$profile, &$search_img, &$search, &$pm_img, &$pm, &$email_img, &$email, &$www_img, &$www, &$icq_status_img, &$icq_img, &$icq, &$aim_img, &$aim, &$msn_img, &$msn, &$yim_img, &$yim)
-{
- global $lang, $images, $board_config, $phpEx;
-
- $from = ( !empty($row['user_from']) ) ? $row['user_from'] : ' ';
- $joined = create_date($date_format, $row['user_regdate'], $board_config['board_timezone']);
- $posts = ( $row['user_posts'] ) ? $row['user_posts'] : 0;
-
- $poster_avatar = '';
- if ( $row['user_avatar_type'] && $row['user_id'] != ANONYMOUS && $row['user_allowavatar'] )
- {
- switch( $row['user_avatar_type'] )
- {
- case USER_AVATAR_UPLOAD:
- $poster_avatar = ( $board_config['allow_avatar_upload'] ) ? '<img src="' . $board_config['avatar_path'] . '/' . $row['user_avatar'] . '" alt="" border="0" />' : '';
- break;
- case USER_AVATAR_REMOTE:
- $poster_avatar = ( $board_config['allow_avatar_remote'] ) ? '<img src="' . $row['user_avatar'] . '" alt="" border="0" />' : '';
- break;
- case USER_AVATAR_GALLERY:
- $poster_avatar = ( $board_config['allow_avatar_local'] ) ? '<img src="' . $board_config['avatar_gallery_path'] . '/' . $row['user_avatar'] . '" alt="" border="0" />' : '';
- break;
- }
- }
-
- if ( !empty($row['user_viewemail']) || $group_mod )
- {
- $email_uri = ( $board_config['board_email_form'] ) ? append_sid("profile.$phpEx?mode=email&" . POST_USERS_URL .'=' . $row['user_id']) : 'mailto:' . $row['user_email'];
-
- $email_img = '<a href="' . $email_uri . '"><img src="' . $images['icon_email'] . '" alt="' . $lang['Send_email'] . '" title="' . $lang['Send_email'] . '" border="0" /></a>';
- $email = '<a href="' . $email_uri . '">' . $lang['Send_email'] . '</a>';
- }
- else
- {
- $email_img = ' ';
- $email = ' ';
- }
-
- $temp_url = append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $row['user_id']);
- $profile_img = '<a href="' . $temp_url . '"><img src="' . $images['icon_profile'] . '" alt="' . $lang['Read_profile'] . '" title="' . $lang['Read_profile'] . '" border="0" /></a>';
- $profile = '<a href="' . $temp_url . '">' . $lang['Read_profile'] . '</a>';
-
- $temp_url = append_sid("privmsg.$phpEx?mode=post&" . POST_USERS_URL . "=" . $row['user_id']);
- $pm_img = '<a href="' . $temp_url . '"><img src="' . $images['icon_pm'] . '" alt="' . $lang['Send_private_message'] . '" title="' . $lang['Send_private_message'] . '" border="0" /></a>';
- $pm = '<a href="' . $temp_url . '">' . $lang['Send_private_message'] . '</a>';
-
- $www_img = ( $row['user_website'] ) ? '<a href="' . $row['user_website'] . '" target="_userwww"><img src="' . $images['icon_www'] . '" alt="' . $lang['Visit_website'] . '" title="' . $lang['Visit_website'] . '" border="0" /></a>' : '';
- $www = ( $row['user_website'] ) ? '<a href="' . $row['user_website'] . '" target="_userwww">' . $lang['Visit_website'] . '</a>' : '';
-
- if ( !empty($row['user_icq']) )
- {
- $icq_status_img = '<a href="http://wwp.icq.com/' . $row['user_icq'] . '#pager"><img src="http://web.icq.com/whitepages/online?icq=' . $row['user_icq'] . '&img=5" width="18" height="18" border="0" /></a>';
- $icq_img = '<a href="http://wwp.icq.com/scripts/search.dll?to=' . $row['user_icq'] . '"><img src="' . $images['icon_icq'] . '" alt="' . $lang['ICQ'] . '" title="' . $lang['ICQ'] . '" border="0" /></a>';
- $icq = '<a href="http://wwp.icq.com/scripts/search.dll?to=' . $row['user_icq'] . '">' . $lang['ICQ'] . '</a>';
- }
- else
- {
- $icq_status_img = '';
- $icq_img = '';
- $icq = '';
- }
-
- $aim_img = ( $row['user_aim'] ) ? '<a href="aim:goim?screenname=' . $row['user_aim'] . '&message=Hello+Are+you+there?"><img src="' . $images['icon_aim'] . '" alt="' . $lang['AIM'] . '" title="' . $lang['AIM'] . '" border="0" /></a>' : '';
- $aim = ( $row['user_aim'] ) ? '<a href="aim:goim?screenname=' . $row['user_aim'] . '&message=Hello+Are+you+there?">' . $lang['AIM'] . '</a>' : '';
-
- $temp_url = append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $row['user_id']);
- $msn_img = ( $row['user_msnm'] ) ? '<a href="' . $temp_url . '"><img src="' . $images['icon_msnm'] . '" alt="' . $lang['MSNM'] . '" title="' . $lang['MSNM'] . '" border="0" /></a>' : '';
- $msn = ( $row['user_msnm'] ) ? '<a href="' . $temp_url . '">' . $lang['MSNM'] . '</a>' : '';
-
- $yim_img = ( $row['user_yim'] ) ? '<a href="http://edit.yahoo.com/config/send_webmesg?.target=' . $row['user_yim'] . '&.src=pg"><img src="' . $images['icon_yim'] . '" alt="' . $lang['YIM'] . '" title="' . $lang['YIM'] . '" border="0" /></a>' : '';
- $yim = ( $row['user_yim'] ) ? '<a href="http://edit.yahoo.com/config/send_webmesg?.target=' . $row['user_yim'] . '&.src=pg">' . $lang['YIM'] . '</a>' : '';
-
- $temp_url = append_sid("search.$phpEx?search_author=" . urlencode($row['username']) . "&showresults=posts");
- $search_img = '<a href="' . $temp_url . '"><img src="' . $images['icon_search'] . '" alt="' . sprintf($lang['Search_user_posts'], $row['username']) . '" title="' . sprintf($lang['Search_user_posts'], $row['username']) . '" border="0" /></a>';
- $search = '<a href="' . $temp_url . '">' . sprintf($lang['Search_user_posts'], $row['username']) . '</a>';
-
- return;
-}
-//
-// --------------------------
-
-//
-// Start session management
-//
-$userdata = session_pagestart($user_ip, PAGE_GROUPCP);
-init_userprefs($userdata);
-//
-// End session management
-//
-
-$script_name = preg_replace('/^\/?(.*?)\/?$/', "\\1", trim($board_config['script_path']));
-$script_name = ( $script_name != '' ) ? $script_name . '/groupcp.'.$phpEx : 'groupcp.'.$phpEx;
-$server_name = trim($board_config['server_name']);
-$server_protocol = ( $board_config['cookie_secure'] ) ? 'https://' : 'http://';
-$server_port = ( $board_config['server_port'] <> 80 ) ? ':' . trim($board_config['server_port']) . '/' : '/';
-
-$server_url = $server_protocol . $server_name . $server_port . $script_name;
-
-if ( isset($HTTP_GET_VARS[POST_GROUPS_URL]) || isset($HTTP_POST_VARS[POST_GROUPS_URL]) )
-{
- $group_id = ( isset($HTTP_POST_VARS[POST_GROUPS_URL]) ) ? intval($HTTP_POST_VARS[POST_GROUPS_URL]) : intval($HTTP_GET_VARS[POST_GROUPS_URL]);
-}
-else
-{
- $group_id = '';
-}
-
-if ( isset($HTTP_POST_VARS['mode']) || isset($HTTP_GET_VARS['mode']) )
-{
- $mode = ( isset($HTTP_POST_VARS['mode']) ) ? $HTTP_POST_VARS['mode'] : $HTTP_GET_VARS['mode'];
- $mode = htmlspecialchars($mode);
-}
-else
-{
- $mode = '';
-}
-
-$confirm = ( isset($HTTP_POST_VARS['confirm']) ) ? TRUE : 0;
-$cancel = ( isset($HTTP_POST_VARS['cancel']) ) ? TRUE : 0;
-
-$start = ( isset($HTTP_GET_VARS['start']) ) ? intval($HTTP_GET_VARS['start']) : 0;
-$start = ($start < 0) ? 0 : $start;
-
-//
-// Default var values
-//
-$is_moderator = FALSE;
-
-if ( isset($HTTP_POST_VARS['groupstatus']) && $group_id )
-{
- if ( !$userdata['session_logged_in'] )
- {
- redirect(append_sid("login.$phpEx?redirect=groupcp.$phpEx&" . POST_GROUPS_URL . "=$group_id", true));
- }
-
- $sql = "SELECT group_moderator
- FROM " . GROUPS_TABLE . "
- WHERE group_id = $group_id";
- if ( !($result = $db->sql_query($sql)) )
- {
- message_die(GENERAL_ERROR, 'Could not obtain user and group information', '', __LINE__, __FILE__, $sql);
- }
-
- $row = $db->sql_fetchrow($result);
-
- if ( $row['group_moderator'] != $userdata['user_id'] && $userdata['user_level'] != ADMIN )
- {
- $template->assign_vars(array(
- 'META' => '<meta http-equiv="refresh" content="3;url=' . append_sid("index.$phpEx") . '">')
- );
-
- $message = $lang['Not_group_moderator'] . '<br /><br />' . sprintf($lang['Click_return_group'], '<a href="' . append_sid("groupcp.$phpEx?" . POST_GROUPS_URL . "=$group_id") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_index'], '<a href="' . append_sid("index.$phpEx") . '">', '</a>');
-
- message_die(GENERAL_MESSAGE, $message);
- }
-
- $sql = "UPDATE " . GROUPS_TABLE . "
- SET group_type = " . intval($HTTP_POST_VARS['group_type']) . "
- WHERE group_id = $group_id";
- if ( !($result = $db->sql_query($sql)) )
- {
- message_die(GENERAL_ERROR, 'Could not obtain user and group information', '', __LINE__, __FILE__, $sql);
- }
-
- $template->assign_vars(array(
- 'META' => '<meta http-equiv="refresh" content="3;url=' . append_sid("groupcp.$phpEx?" . POST_GROUPS_URL . "=$group_id") . '">')
- );
-
- $message = $lang['Group_type_updated'] . '<br /><br />' . sprintf($lang['Click_return_group'], '<a href="' . append_sid("groupcp.$phpEx?" . POST_GROUPS_URL . "=$group_id") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_index'], '<a href="' . append_sid("index.$phpEx") . '">', '</a>');
-
- message_die(GENERAL_MESSAGE, $message);
-
-}
-else if ( isset($HTTP_POST_VARS['joingroup']) && $group_id )
-{
- //
- // First, joining a group
- // If the user isn't logged in redirect them to login
- //
- if ( !$userdata['session_logged_in'] )
- {
- redirect(append_sid("login.$phpEx?redirect=groupcp.$phpEx&" . POST_GROUPS_URL . "=$group_id", true));
- }
-
- $sql = "SELECT ug.user_id, g.group_type
- FROM " . USER_GROUP_TABLE . " ug, " . GROUPS_TABLE . " g
- WHERE g.group_id = $group_id
- AND g.group_type <> " . GROUP_HIDDEN . "
- AND ug.group_id = g.group_id";
- if ( !($result = $db->sql_query($sql)) )
- {
- message_die(GENERAL_ERROR, 'Could not obtain user and group information', '', __LINE__, __FILE__, $sql);
- }
-
- if ( $row = $db->sql_fetchrow($result) )
- {
- if ( $row['group_type'] == GROUP_OPEN )
- {
- do
- {
- if ( $userdata['user_id'] == $row['user_id'] )
- {
- $template->assign_vars(array(
- 'META' => '<meta http-equiv="refresh" content="3;url=' . append_sid("index.$phpEx") . '">')
- );
-
- $message = $lang['Already_member_group'] . '<br /><br />' . sprintf($lang['Click_return_group'], '<a href="' . append_sid("groupcp.$phpEx?" . POST_GROUPS_URL . "=$group_id") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_index'], '<a href="' . append_sid("index.$phpEx") . '">', '</a>');
-
- message_die(GENERAL_MESSAGE, $message);
- }
- } while ( $row = $db->sql_fetchrow($result) );
- }
- else
- {
- $template->assign_vars(array(
- 'META' => '<meta http-equiv="refresh" content="3;url=' . append_sid("index.$phpEx") . '">')
- );
-
- $message = $lang['This_closed_group'] . '<br /><br />' . sprintf($lang['Click_return_group'], '<a href="' . append_sid("groupcp.$phpEx?" . POST_GROUPS_URL . "=$group_id") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_index'], '<a href="' . append_sid("index.$phpEx") . '">', '</a>');
-
- message_die(GENERAL_MESSAGE, $message);
- }
- }
- else
- {
- message_die(GENERAL_MESSAGE, $lang['No_groups_exist']);
- }
-
- $sql = "INSERT INTO " . USER_GROUP_TABLE . " (group_id, user_id, user_pending)
- VALUES ($group_id, " . $userdata['user_id'] . ", 1)";
- if ( !($result = $db->sql_query($sql)) )
- {
- message_die(GENERAL_ERROR, "Error inserting user group subscription", "", __LINE__, __FILE__, $sql);
- }
-
- $sql = "SELECT u.user_email, u.username, u.user_lang, g.group_name
- FROM ".USERS_TABLE . " u, " . GROUPS_TABLE . " g
- WHERE u.user_id = g.group_moderator
- AND g.group_id = $group_id";
- if ( !($result = $db->sql_query($sql)) )
- {
- message_die(GENERAL_ERROR, "Error getting group moderator data", "", __LINE__, __FILE__, $sql);
- }
-
- $moderator = $db->sql_fetchrow($result);
-
- include($phpbb_root_path . 'includes/emailer.'.$phpEx);
- $emailer = new emailer($board_config['smtp_delivery']);
-
- $emailer->from($board_config['board_email']);
- $emailer->replyto($board_config['board_email']);
-
- $emailer->use_template('group_request', $moderator['user_lang']);
- $emailer->email_address($moderator['user_email']);
- $emailer->set_subject($lang['Group_request']);
-
- $emailer->assign_vars(array(
- 'SITENAME' => $board_config['sitename'],
- 'GROUP_MODERATOR' => $moderator['username'],
- 'EMAIL_SIG' => (!empty($board_config['board_email_sig'])) ? str_replace('<br />', "\n", "-- \n" . $board_config['board_email_sig']) : '',
-
- 'U_GROUPCP' => $server_url . '?' . POST_GROUPS_URL . "=$group_id&validate=true")
- );
- $emailer->send();
- $emailer->reset();
-
- $template->assign_vars(array(
- 'META' => '<meta http-equiv="refresh" content="3;url=' . append_sid("index.$phpEx") . '">')
- );
-
- $message = $lang['Group_joined'] . '<br /><br />' . sprintf($lang['Click_return_group'], '<a href="' . append_sid("groupcp.$phpEx?" . POST_GROUPS_URL . "=$group_id") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_index'], '<a href="' . append_sid("index.$phpEx") . '">', '</a>');
-
- message_die(GENERAL_MESSAGE, $message);
-}
-else if ( isset($HTTP_POST_VARS['unsub']) || isset($HTTP_POST_VARS['unsubpending']) && $group_id )
-{
- //
- // Second, unsubscribing from a group
- // Check for confirmation of unsub.
- //
- if ( $cancel )
- {
- redirect(append_sid("groupcp.$phpEx", true));
- }
- elseif ( !$userdata['session_logged_in'] )
- {
- redirect(append_sid("login.$phpEx?redirect=groupcp.$phpEx&" . POST_GROUPS_URL . "=$group_id", true));
- }
-
- if ( $confirm )
- {
- $sql = "DELETE FROM " . USER_GROUP_TABLE . "
- WHERE user_id = " . $userdata['user_id'] . "
- AND group_id = $group_id";
- if ( !($result = $db->sql_query($sql)) )
- {
- message_die(GENERAL_ERROR, 'Could not delete group memebership data', '', __LINE__, __FILE__, $sql);
- }
-
- if ( $userdata['user_level'] != ADMIN && $userdata['user_level'] == MOD )
- {
- $sql = "SELECT COUNT(auth_mod) AS is_auth_mod
- FROM " . AUTH_ACCESS_TABLE . " aa, " . USER_GROUP_TABLE . " ug
- WHERE ug.user_id = " . $userdata['user_id'] . "
- AND aa.group_id = ug.group_id
- AND aa.auth_mod = 1";
- if ( !($result = $db->sql_query($sql)) )
- {
- message_die(GENERAL_ERROR, 'Could not obtain moderator status', '', __LINE__, __FILE__, $sql);
- }
-
- if ( !($row = $db->sql_fetchrow($result)) || $row['is_auth_mod'] == 0 )
- {
- $sql = "UPDATE " . USERS_TABLE . "
- SET user_level = " . USER . "
- WHERE user_id = " . $userdata['user_id'];
- if ( !($result = $db->sql_query($sql)) )
- {
- message_die(GENERAL_ERROR, 'Could not update user level', '', __LINE__, __FILE__, $sql);
- }
- }
- }
-
- $template->assign_vars(array(
- 'META' => '<meta http-equiv="refresh" content="3;url=' . append_sid("index.$phpEx") . '">')
- );
-
- $message = $lang['Unsub_success'] . '<br /><br />' . sprintf($lang['Click_return_group'], '<a href="' . append_sid("groupcp.$phpEx?" . POST_GROUPS_URL . "=$group_id") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_index'], '<a href="' . append_sid("index.$phpEx") . '">', '</a>');
-
- message_die(GENERAL_MESSAGE, $message);
- }
- else
- {
- $unsub_msg = ( isset($HTTP_POST_VARS['unsub']) ) ? $lang['Confirm_unsub'] : $lang['Confirm_unsub_pending'];
-
- $s_hidden_fields = '<input type="hidden" name="' . POST_GROUPS_URL . '" value="' . $group_id . '" /><input type="hidden" name="unsub" value="1" />';
-
- $page_title = $lang['Group_Control_Panel'];
- include($phpbb_root_path . 'includes/page_header.'.$phpEx);
-
- $template->set_filenames(array(
- 'confirm' => 'confirm_body.tpl')
- );
-
- $template->assign_vars(array(
- 'MESSAGE_TITLE' => $lang['Confirm'],
- 'MESSAGE_TEXT' => $unsub_msg,
- 'L_YES' => $lang['Yes'],
- 'L_NO' => $lang['No'],
- 'S_CONFIRM_ACTION' => append_sid("groupcp.$phpEx"),
- 'S_HIDDEN_FIELDS' => $s_hidden_fields)
- );
-
- $template->pparse('confirm');
-
- include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
- }
-
-}
-else if ( $group_id )
-{
- //
- // Did the group moderator get here through an email?
- // If so, check to see if they are logged in.
- //
- if ( isset($HTTP_GET_VARS['validate']) )
- {
- if ( !$userdata['session_logged_in'] )
- {
- redirect(append_sid("login.$phpEx?redirect=groupcp.$phpEx&" . POST_GROUPS_URL . "=$group_id", true));
- }
- }
-
- //
- // For security, get the ID of the group moderator.
- //
- switch(SQL_LAYER)
- {
- case 'postgresql':
- $sql = "SELECT g.group_moderator, g.group_type, aa.auth_mod
- FROM " . GROUPS_TABLE . " g, " . AUTH_ACCESS_TABLE . " aa
- WHERE g.group_id = $group_id
- AND aa.group_id = g.group_id
- UNION (
- SELECT g.group_moderator, g.group_type, NULL
- FROM " . GROUPS_TABLE . " g
- WHERE g.group_id = $group_id
- AND NOT EXISTS (
- SELECT aa.group_id
- FROM " . AUTH_ACCESS_TABLE . " aa
- WHERE aa.group_id = g.group_id
- )
- )
- ORDER BY aa.auth_mod DESC";
- break;
-
- case 'oracle':
- $sql = "SELECT g.group_moderator, g.group_type, aa.auth_mod
- FROM " . GROUPS_TABLE . " g, " . AUTH_ACCESS_TABLE . " aa
- WHERE g.group_id = $group_id
- AND aa.group_id (+) = g.group_id
- ORDER BY aa.auth_mod DESC";
- break;
-
- default:
- $sql = "SELECT g.group_moderator, g.group_type, aa.auth_mod
- FROM ( " . GROUPS_TABLE . " g
- LEFT JOIN " . AUTH_ACCESS_TABLE . " aa ON aa.group_id = g.group_id )
- WHERE g.group_id = $group_id
- ORDER BY aa.auth_mod DESC";
- break;
- }
- if ( !($result = $db->sql_query($sql)) )
- {
- message_die(GENERAL_ERROR, 'Could not get moderator information', '', __LINE__, __FILE__, $sql);
- }
-
- if ( $group_info = $db->sql_fetchrow($result) )
- {
- $group_moderator = $group_info['group_moderator'];
-
- if ( $group_moderator == $userdata['user_id'] || $userdata['user_level'] == ADMIN )
- {
- $is_moderator = TRUE;
- }
-
- //
- // Handle Additions, removals, approvals and denials
- //
- if ( !empty($HTTP_POST_VARS['add']) || !empty($HTTP_POST_VARS['remove']) || isset($HTTP_POST_VARS['approve']) || isset($HTTP_POST_VARS['deny']) )
- {
- if ( !$userdata['session_logged_in'] )
- {
- redirect(append_sid("login.$phpEx?redirect=groupcp.$phpEx&" . POST_GROUPS_URL . "=$group_id", true));
- }
-
- if ( !$is_moderator )
- {
- $template->assign_vars(array(
- 'META' => '<meta http-equiv="refresh" content="3;url=' . append_sid("index.$phpEx") . '">')
- );
-
- $message = $lang['Not_group_moderator'] . '<br /><br />' . sprintf($lang['Click_return_index'], '<a href="' . append_sid("index.$phpEx") . '">', '</a>');
-
- message_die(GENERAL_MESSAGE, $message);
- }
-
- if ( isset($HTTP_POST_VARS['add']) )
- {
- $username = ( isset($HTTP_POST_VARS['username']) ) ? phpbb_clean_username($HTTP_POST_VARS['username']) : '';
-
- $sql = "SELECT user_id, user_email, user_lang, user_level
- FROM " . USERS_TABLE . "
- WHERE username = '" . str_replace("\'", "''", $username) . "'";
- if ( !($result = $db->sql_query($sql)) )
- {
- message_die(GENERAL_ERROR, "Could not get user information", $lang['Error'], __LINE__, __FILE__, $sql);
- }
-
- if ( !($row = $db->sql_fetchrow($result)) )
- {
- $template->assign_vars(array(
- 'META' => '<meta http-equiv="refresh" content="3;url=' . append_sid("groupcp.$phpEx?" . POST_GROUPS_URL . "=$group_id") . '">')
- );
-
- $message = $lang['Could_not_add_user'] . "<br /><br />" . sprintf($lang['Click_return_group'], "<a href=\"" . append_sid("groupcp.$phpEx?" . POST_GROUPS_URL . "=$group_id") . "\">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_index'], "<a href=\"" . append_sid("index.$phpEx") . "\">", "</a>");
-
- message_die(GENERAL_MESSAGE, $message);
- }
-
- if ( $row['user_id'] == ANONYMOUS )
- {
- $template->assign_vars(array(
- 'META' => '<meta http-equiv="refresh" content="3;url=' . append_sid("groupcp.$phpEx?" . POST_GROUPS_URL . "=$group_id") . '">')
- );
-
- $message = $lang['Could_not_anon_user'] . '<br /><br />' . sprintf($lang['Click_return_group'], '<a href="' . append_sid("groupcp.$phpEx?" . POST_GROUPS_URL . "=$group_id") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_index'], '<a href="' . append_sid("index.$phpEx") . '">', '</a>');
-
- message_die(GENERAL_MESSAGE, $message);
- }
-
- $sql = "SELECT ug.user_id, u.user_level
- FROM " . USER_GROUP_TABLE . " ug, " . USERS_TABLE . " u
- WHERE u.user_id = " . $row['user_id'] . "
- AND ug.user_id = u.user_id
- AND ug.group_id = $group_id";
- if ( !($result = $db->sql_query($sql)) )
- {
- message_die(GENERAL_ERROR, 'Could not get user information', '', __LINE__, __FILE__, $sql);
- }
-
- if ( !($db->sql_fetchrow($result)) )
- {
- $sql = "INSERT INTO " . USER_GROUP_TABLE . " (user_id, group_id, user_pending)
- VALUES (" . $row['user_id'] . ", $group_id, 0)";
- if ( !$db->sql_query($sql) )
- {
- message_die(GENERAL_ERROR, 'Could not add user to group', '', __LINE__, __FILE__, $sql);
- }
-
- if ( $row['user_level'] != ADMIN && $row['user_level'] != MOD && $group_info['auth_mod'] )
- {
- $sql = "UPDATE " . USERS_TABLE . "
- SET user_level = " . MOD . "
- WHERE user_id = " . $row['user_id'];
- if ( !$db->sql_query($sql) )
- {
- message_die(GENERAL_ERROR, 'Could not update user level', '', __LINE__, __FILE__, $sql);
- }
- }
-
- //
- // Get the group name
- // Email the user and tell them they're in the group
- //
- $group_sql = "SELECT group_name
- FROM " . GROUPS_TABLE . "
- WHERE group_id = $group_id";
- if ( !($result = $db->sql_query($group_sql)) )
- {
- message_die(GENERAL_ERROR, 'Could not get group information', '', __LINE__, __FILE__, $group_sql);
- }
-
- $group_name_row = $db->sql_fetchrow($result);
-
- $group_name = $group_name_row['group_name'];
-
- include($phpbb_root_path . 'includes/emailer.'.$phpEx);
- $emailer = new emailer($board_config['smtp_delivery']);
-
- $emailer->from($board_config['board_email']);
- $emailer->replyto($board_config['board_email']);
-
- $emailer->use_template('group_added', $row['user_lang']);
- $emailer->email_address($row['user_email']);
- $emailer->set_subject($lang['Group_added']);
-
- $emailer->assign_vars(array(
- 'SITENAME' => $board_config['sitename'],
- 'GROUP_NAME' => $group_name,
- 'EMAIL_SIG' => (!empty($board_config['board_email_sig'])) ? str_replace('<br />', "\n", "-- \n" . $board_config['board_email_sig']) : '',
-
- 'U_GROUPCP' => $server_url . '?' . POST_GROUPS_URL . "=$group_id")
- );
- $emailer->send();
- $emailer->reset();
- }
- else
- {
- $template->assign_vars(array(
- 'META' => '<meta http-equiv="refresh" content="3;url=' . append_sid("groupcp.$phpEx?" . POST_GROUPS_URL . "=$group_id") . '">')
- );
-
- $message = $lang['User_is_member_group'] . '<br /><br />' . sprintf($lang['Click_return_group'], '<a href="' . append_sid("groupcp.$phpEx?" . POST_GROUPS_URL . "=$group_id") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_index'], '<a href="' . append_sid("index.$phpEx") . '">', '</a>');
-
- message_die(GENERAL_MESSAGE, $message);
- }
- }
- else
- {
- if ( ( ( isset($HTTP_POST_VARS['approve']) || isset($HTTP_POST_VARS['deny']) ) && isset($HTTP_POST_VARS['pending_members']) ) || ( isset($HTTP_POST_VARS['remove']) && isset($HTTP_POST_VARS['members']) ) )
- {
-
- $members = ( isset($HTTP_POST_VARS['approve']) || isset($HTTP_POST_VARS['deny']) ) ? $HTTP_POST_VARS['pending_members'] : $HTTP_POST_VARS['members'];
-
- $sql_in = '';
- for($i = 0; $i < count($members); $i++)
- {
- $sql_in .= ( ( $sql_in != '' ) ? ', ' : '' ) . intval($members[$i]);
- }
-
- if ( isset($HTTP_POST_VARS['approve']) )
- {
- if ( $group_info['auth_mod'] )
- {
- $sql = "UPDATE " . USERS_TABLE . "
- SET user_level = " . MOD . "
- WHERE user_id IN ($sql_in)
- AND user_level NOT IN (" . MOD . ", " . ADMIN . ")";
- if ( !$db->sql_query($sql) )
- {
- message_die(GENERAL_ERROR, 'Could not update user level', '', __LINE__, __FILE__, $sql);
- }
- }
-
- $sql = "UPDATE " . USER_GROUP_TABLE . "
- SET user_pending = 0
- WHERE user_id IN ($sql_in)
- AND group_id = $group_id";
- $sql_select = "SELECT user_email
- FROM ". USERS_TABLE . "
- WHERE user_id IN ($sql_in)";
- }
- else if ( isset($HTTP_POST_VARS['deny']) || isset($HTTP_POST_VARS['remove']) )
- {
- if ( $group_info['auth_mod'] )
- {
- $sql = "SELECT ug.user_id, ug.group_id
- FROM " . AUTH_ACCESS_TABLE . " aa, " . USER_GROUP_TABLE . " ug
- WHERE ug.user_id IN ($sql_in)
- AND aa.group_id = ug.group_id
- AND aa.auth_mod = 1
- GROUP BY ug.user_id, ug.group_id
- ORDER BY ug.user_id, ug.group_id";
- if ( !($result = $db->sql_query($sql)) )
- {
- message_die(GENERAL_ERROR, 'Could not obtain moderator status', '', __LINE__, __FILE__, $sql);
- }
-
- if ( $row = $db->sql_fetchrow($result) )
- {
- $group_check = array();
- $remove_mod_sql = '';
-
- do
- {
- $group_check[$row['user_id']][] = $row['group_id'];
- }
- while ( $row = $db->sql_fetchrow($result) );
-
- while( list($user_id, $group_list) = @each($group_check) )
- {
- if ( count($group_list) == 1 )
- {
- $remove_mod_sql .= ( ( $remove_mod_sql != '' ) ? ', ' : '' ) . $user_id;
- }
- }
-
- if ( $remove_mod_sql != '' )
- {
- $sql = "UPDATE " . USERS_TABLE . "
- SET user_level = " . USER . "
- WHERE user_id IN ($remove_mod_sql)
- AND user_level NOT IN (" . ADMIN . ")";
- if ( !$db->sql_query($sql) )
- {
- message_die(GENERAL_ERROR, 'Could not update user level', '', __LINE__, __FILE__, $sql);
- }
- }
- }
- }
-
- $sql = "DELETE FROM " . USER_GROUP_TABLE . "
- WHERE user_id IN ($sql_in)
- AND group_id = $group_id";
- }
-
- if ( !$db->sql_query($sql) )
- {
- message_die(GENERAL_ERROR, 'Could not update user group table', '', __LINE__, __FILE__, $sql);
- }
-
- //
- // Email users when they are approved
- //
- if ( isset($HTTP_POST_VARS['approve']) )
- {
- if ( !($result = $db->sql_query($sql_select)) )
- {
- message_die(GENERAL_ERROR, 'Could not get user email information', '', __LINE__, __FILE__, $sql);
- }
-
- $bcc_list = array();
- while ($row = $db->sql_fetchrow($result))
- {
- $bcc_list[] = $row['user_email'];
- }
-
- //
- // Get the group name
- //
- $group_sql = "SELECT group_name
- FROM " . GROUPS_TABLE . "
- WHERE group_id = $group_id";
- if ( !($result = $db->sql_query($group_sql)) )
- {
- message_die(GENERAL_ERROR, 'Could not get group information', '', __LINE__, __FILE__, $group_sql);
- }
-
- $group_name_row = $db->sql_fetchrow($result);
- $group_name = $group_name_row['group_name'];
-
- include($phpbb_root_path . 'includes/emailer.'.$phpEx);
- $emailer = new emailer($board_config['smtp_delivery']);
-
- $emailer->from($board_config['board_email']);
- $emailer->replyto($board_config['board_email']);
-
- for ($i = 0; $i < count($bcc_list); $i++)
- {
- $emailer->bcc($bcc_list[$i]);
- }
-
- $emailer->use_template('group_approved');
- $emailer->set_subject($lang['Group_approved']);
-
- $emailer->assign_vars(array(
- 'SITENAME' => $board_config['sitename'],
- 'GROUP_NAME' => $group_name,
- 'EMAIL_SIG' => (!empty($board_config['board_email_sig'])) ? str_replace('<br />', "\n", "-- \n" . $board_config['board_email_sig']) : '',
-
- 'U_GROUPCP' => $server_url . '?' . POST_GROUPS_URL . "=$group_id")
- );
- $emailer->send();
- $emailer->reset();
- }
- }
- }
- }
- //
- // END approve or deny
- //
- }
- else
- {
- message_die(GENERAL_MESSAGE, $lang['No_groups_exist']);
- }
-
- //
- // Get group details
- //
- $sql = "SELECT *
- FROM " . GROUPS_TABLE . "
- WHERE group_id = $group_id
- AND group_single_user = 0";
- if ( !($result = $db->sql_query($sql)) )
- {
- message_die(GENERAL_ERROR, 'Error getting group information', '', __LINE__, __FILE__, $sql);
- }
-
- if ( !($group_info = $db->sql_fetchrow($result)) )
- {
- message_die(GENERAL_MESSAGE, $lang['Group_not_exist']);
- }
-
- //
- // Get moderator details for this group
- //
- $sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm
- FROM " . USERS_TABLE . "
- WHERE user_id = " . $group_info['group_moderator'];
- if ( !($result = $db->sql_query($sql)) )
- {
- message_die(GENERAL_ERROR, 'Error getting user list for group', '', __LINE__, __FILE__, $sql);
- }
-
- $group_moderator = $db->sql_fetchrow($result);
-
- //
- // Get user information for this group
- //
- $sql = "SELECT u.username, u.user_id, u.user_viewemail, u.user_posts, u.user_regdate, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_msnm, ug.user_pending
- FROM " . USERS_TABLE . " u, " . USER_GROUP_TABLE . " ug
- WHERE ug.group_id = $group_id
- AND u.user_id = ug.user_id
- AND ug.user_pending = 0
- AND ug.user_id <> " . $group_moderator['user_id'] . "
- ORDER BY u.username";
- if ( !($result = $db->sql_query($sql)) )
- {
- message_die(GENERAL_ERROR, 'Error getting user list for group', '', __LINE__, __FILE__, $sql);
- }
-
- $group_members = $db->sql_fetchrowset($result);
- $members_count = count($group_members);
- $db->sql_freeresult($result);
-
- $sql = "SELECT u.username, u.user_id, u.user_viewemail, u.user_posts, u.user_regdate, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_msnm
- FROM " . GROUPS_TABLE . " g, " . USER_GROUP_TABLE . " ug, " . USERS_TABLE . " u
- WHERE ug.group_id = $group_id
- AND g.group_id = ug.group_id
- AND ug.user_pending = 1
- AND u.user_id = ug.user_id
- ORDER BY u.username";
- if ( !($result = $db->sql_query($sql)) )
- {
- message_die(GENERAL_ERROR, 'Error getting user pending information', '', __LINE__, __FILE__, $sql);
- }
-
- $modgroup_pending_list = $db->sql_fetchrowset($result);
- $modgroup_pending_count = count($modgroup_pending_list);
- $db->sql_freeresult($result);
-
- $is_group_member = 0;
- if ( $members_count )
- {
- for($i = 0; $i < $members_count; $i++)
- {
- if ( $group_members[$i]['user_id'] == $userdata['user_id'] && $userdata['session_logged_in'] )
- {
- $is_group_member = TRUE;
- }
- }
- }
-
- $is_group_pending_member = 0;
- if ( $modgroup_pending_count )
- {
- for($i = 0; $i < $modgroup_pending_count; $i++)
- {
- if ( $modgroup_pending_list[$i]['user_id'] == $userdata['user_id'] && $userdata['session_logged_in'] )
- {
- $is_group_pending_member = TRUE;
- }
- }
- }
-
- if ( $userdata['user_level'] == ADMIN )
- {
- $is_moderator = TRUE;
- }
-
- if ( $userdata['user_id'] == $group_info['group_moderator'] )
- {
- $is_moderator = TRUE;
-
- $group_details = $lang['Are_group_moderator'];
-
- $s_hidden_fields = '<input type="hidden" name="' . POST_GROUPS_URL . '" value="' . $group_id . '" />';
- }
- else if ( $is_group_member || $is_group_pending_member )
- {
- $template->assign_block_vars('switch_unsubscribe_group_input', array());
-
- $group_details = ( $is_group_pending_member ) ? $lang['Pending_this_group'] : $lang['Member_this_group'];
-
- $s_hidden_fields = '<input type="hidden" name="' . POST_GROUPS_URL . '" value="' . $group_id . '" />';
- }
- else if ( $userdata['user_id'] == ANONYMOUS )
- {
- $group_details = $lang['Login_to_join'];
- $s_hidden_fields = '';
- }
- else
- {
- if ( $group_info['group_type'] == GROUP_OPEN )
- {
- $template->assign_block_vars('switch_subscribe_group_input', array());
-
- $group_details = $lang['This_open_group'];
- $s_hidden_fields = '<input type="hidden" name="' . POST_GROUPS_URL . '" value="' . $group_id . '" />';
- }
- else if ( $group_info['group_type'] == GROUP_CLOSED )
- {
- $group_details = $lang['This_closed_group'];
- $s_hidden_fields = '';
- }
- else if ( $group_info['group_type'] == GROUP_HIDDEN )
- {
- $group_details = $lang['This_hidden_group'];
- $s_hidden_fields = '';
- }
- }
-
- $page_title = $lang['Group_Control_Panel'];
- include($phpbb_root_path . 'includes/page_header.'.$phpEx);
-
- //
- // Load templates
- //
- $template->set_filenames(array(
- 'info' => 'groupcp_info_body.tpl',
- 'pendinginfo' => 'groupcp_pending_info.tpl')
- );
- make_jumpbox('viewforum.'.$phpEx);
-
- //
- // Add the moderator
- //
- $username = $group_moderator['username'];
- $user_id = $group_moderator['user_id'];
-
- generate_user_info($group_moderator, $board_config['default_dateformat'], $is_moderator, $from, $posts, $joined, $poster_avatar, $profile_img, $profile, $search_img, $search, $pm_img, $pm, $email_img, $email, $www_img, $www, $icq_status_img, $icq_img, $icq, $aim_img, $aim, $msn_img, $msn, $yim_img, $yim);
-
- $s_hidden_fields .= '';
-
- $template->assign_vars(array(
- 'L_GROUP_INFORMATION' => $lang['Group_Information'],
- 'L_GROUP_NAME' => $lang['Group_name'],
- 'L_GROUP_DESC' => $lang['Group_description'],
- 'L_GROUP_TYPE' => $lang['Group_type'],
- 'L_GROUP_MEMBERSHIP' => $lang['Group_membership'],
- 'L_SUBSCRIBE' => $lang['Subscribe'],
- 'L_UNSUBSCRIBE' => $lang['Unsubscribe'],
- 'L_JOIN_GROUP' => $lang['Join_group'],
- 'L_UNSUBSCRIBE_GROUP' => $lang['Unsubscribe'],
- 'L_GROUP_OPEN' => $lang['Group_open'],
- 'L_GROUP_CLOSED' => $lang['Group_closed'],
- 'L_GROUP_HIDDEN' => $lang['Group_hidden'],
- 'L_UPDATE' => $lang['Update'],
- 'L_GROUP_MODERATOR' => $lang['Group_Moderator'],
- 'L_GROUP_MEMBERS' => $lang['Group_Members'],
- 'L_PENDING_MEMBERS' => $lang['Pending_members'],
- 'L_SELECT_SORT_METHOD' => $lang['Select_sort_method'],
- 'L_PM' => $lang['Private_Message'],
- 'L_EMAIL' => $lang['Email'],
- 'L_POSTS' => $lang['Posts'],
- 'L_WEBSITE' => $lang['Website'],
- 'L_FROM' => $lang['Location'],
- 'L_ORDER' => $lang['Order'],
- 'L_SORT' => $lang['Sort'],
- 'L_SUBMIT' => $lang['Sort'],
- 'L_AIM' => $lang['AIM'],
- 'L_YIM' => $lang['YIM'],
- 'L_MSNM' => $lang['MSNM'],
- 'L_ICQ' => $lang['ICQ'],
- 'L_SELECT' => $lang['Select'],
- 'L_REMOVE_SELECTED' => $lang['Remove_selected'],
- 'L_ADD_MEMBER' => $lang['Add_member'],
- 'L_FIND_USERNAME' => $lang['Find_username'],
-
- 'GROUP_NAME' => $group_info['group_name'],
- 'GROUP_DESC' => $group_info['group_description'],
- 'GROUP_DETAILS' => $group_details,
- 'MOD_ROW_COLOR' => '#' . $theme['td_color1'],
- 'MOD_ROW_CLASS' => $theme['td_class1'],
- 'MOD_USERNAME' => $username,
- 'MOD_FROM' => $from,
- 'MOD_JOINED' => $joined,
- 'MOD_POSTS' => $posts,
- 'MOD_AVATAR_IMG' => $poster_avatar,
- 'MOD_PROFILE_IMG' => $profile_img,
- 'MOD_PROFILE' => $profile,
- 'MOD_SEARCH_IMG' => $search_img,
- 'MOD_SEARCH' => $search,
- 'MOD_PM_IMG' => $pm_img,
- 'MOD_PM' => $pm,
- 'MOD_EMAIL_IMG' => $email_img,
- 'MOD_EMAIL' => $email,
- 'MOD_WWW_IMG' => $www_img,
- 'MOD_WWW' => $www,
- 'MOD_ICQ_STATUS_IMG' => $icq_status_img,
- 'MOD_ICQ_IMG' => $icq_img,
- 'MOD_ICQ' => $icq,
- 'MOD_AIM_IMG' => $aim_img,
- 'MOD_AIM' => $aim,
- 'MOD_MSN_IMG' => $msn_img,
- 'MOD_MSN' => $msn,
- 'MOD_YIM_IMG' => $yim_img,
- 'MOD_YIM' => $yim,
-
- 'U_MOD_VIEWPROFILE' => append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=$user_id"),
- 'U_SEARCH_USER' => append_sid("search.$phpEx?mode=searchuser"),
-
- 'S_GROUP_OPEN_TYPE' => GROUP_OPEN,
- 'S_GROUP_CLOSED_TYPE' => GROUP_CLOSED,
- 'S_GROUP_HIDDEN_TYPE' => GROUP_HIDDEN,
- 'S_GROUP_OPEN_CHECKED' => ( $group_info['group_type'] == GROUP_OPEN ) ? ' checked="checked"' : '',
- 'S_GROUP_CLOSED_CHECKED' => ( $group_info['group_type'] == GROUP_CLOSED ) ? ' checked="checked"' : '',
- 'S_GROUP_HIDDEN_CHECKED' => ( $group_info['group_type'] == GROUP_HIDDEN ) ? ' checked="checked"' : '',
- 'S_HIDDEN_FIELDS' => $s_hidden_fields,
- 'S_MODE_SELECT' => $select_sort_mode,
- 'S_ORDER_SELECT' => $select_sort_order,
- 'S_GROUPCP_ACTION' => append_sid("groupcp.$phpEx?" . POST_GROUPS_URL . "=$group_id"))
- );
-
- //
- // Dump out the remaining users
- //
- for($i = $start; $i < min($board_config['topics_per_page'] + $start, $members_count); $i++)
- {
- $username = $group_members[$i]['username'];
- $user_id = $group_members[$i]['user_id'];
-
- generate_user_info($group_members[$i], $board_config['default_dateformat'], $is_moderator, $from, $posts, $joined, $poster_avatar, $profile_img, $profile, $search_img, $search, $pm_img, $pm, $email_img, $email, $www_img, $www, $icq_status_img, $icq_img, $icq, $aim_img, $aim, $msn_img, $msn, $yim_img, $yim);
-
- if ( $group_info['group_type'] != GROUP_HIDDEN || $is_group_member || $is_moderator )
- {
- $row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
- $row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];
-
- $template->assign_block_vars('member_row', array(
- 'ROW_COLOR' => '#' . $row_color,
- 'ROW_CLASS' => $row_class,
- 'USERNAME' => $username,
- 'FROM' => $from,
- 'JOINED' => $joined,
- 'POSTS' => $posts,
- 'USER_ID' => $user_id,
- 'AVATAR_IMG' => $poster_avatar,
- 'PROFILE_IMG' => $profile_img,
- 'PROFILE' => $profile,
- 'SEARCH_IMG' => $search_img,
- 'SEARCH' => $search,
- 'PM_IMG' => $pm_img,
- 'PM' => $pm,
- 'EMAIL_IMG' => $email_img,
- 'EMAIL' => $email,
- 'WWW_IMG' => $www_img,
- 'WWW' => $www,
- 'ICQ_STATUS_IMG' => $icq_status_img,
- 'ICQ_IMG' => $icq_img,
- 'ICQ' => $icq,
- 'AIM_IMG' => $aim_img,
- 'AIM' => $aim,
- 'MSN_IMG' => $msn_img,
- 'MSN' => $msn,
- 'YIM_IMG' => $yim_img,
- 'YIM' => $yim,
-
- 'U_VIEWPROFILE' => append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=$user_id"))
- );
-
- if ( $is_moderator )
- {
- $template->assign_block_vars('member_row.switch_mod_option', array());
- }
- }
- }
-
- if ( !$members_count )
- {
- //
- // No group members
- //
- $template->assign_block_vars('switch_no_members', array());
- $template->assign_vars(array(
- 'L_NO_MEMBERS' => $lang['No_group_members'])
- );
- }
-
- $current_page = ( !$members_count ) ? 1 : ceil( $members_count / $board_config['topics_per_page'] );
-
- $template->assign_vars(array(
- 'PAGINATION' => generate_pagination("groupcp.$phpEx?" . POST_GROUPS_URL . "=$group_id", $members_count, $board_config['topics_per_page'], $start),
- 'PAGE_NUMBER' => sprintf($lang['Page_of'], ( floor( $start / $board_config['topics_per_page'] ) + 1 ), $current_page ),
-
- 'L_GOTO_PAGE' => $lang['Goto_page'])
- );
-
- if ( $group_info['group_type'] == GROUP_HIDDEN && !$is_group_member && !$is_moderator )
- {
- //
- // No group members
- //
- $template->assign_block_vars('switch_hidden_group', array());
- $template->assign_vars(array(
- 'L_HIDDEN_MEMBERS' => $lang['Group_hidden_members'])
- );
- }
-
- //
- // We've displayed the members who belong to the group, now we
- // do that pending memebers...
- //
- if ( $is_moderator )
- {
- //
- // Users pending in ONLY THIS GROUP (which is moderated by this user)
- //
- if ( $modgroup_pending_count )
- {
- for($i = 0; $i < $modgroup_pending_count; $i++)
- {
- $username = $modgroup_pending_list[$i]['username'];
- $user_id = $modgroup_pending_list[$i]['user_id'];
-
- generate_user_info($modgroup_pending_list[$i], $board_config['default_dateformat'], $is_moderator, $from, $posts, $joined, $poster_avatar, $profile_img, $profile, $search_img, $search, $pm_img, $pm, $email_img, $email, $www_img, $www, $icq_status_img, $icq_img, $icq, $aim_img, $aim, $msn_img, $msn, $yim_img, $yim);
-
- $row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
- $row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];
-
- $user_select = '<input type="checkbox" name="member[]" value="' . $user_id . '">';
-
- $template->assign_block_vars('pending_members_row', array(
- 'ROW_CLASS' => $row_class,
- 'ROW_COLOR' => '#' . $row_color,
- 'USERNAME' => $username,
- 'FROM' => $from,
- 'JOINED' => $joined,
- 'POSTS' => $posts,
- 'USER_ID' => $user_id,
- 'AVATAR_IMG' => $poster_avatar,
- 'PROFILE_IMG' => $profile_img,
- 'PROFILE' => $profile,
- 'SEARCH_IMG' => $search_img,
- 'SEARCH' => $search,
- 'PM_IMG' => $pm_img,
- 'PM' => $pm,
- 'EMAIL_IMG' => $email_img,
- 'EMAIL' => $email,
- 'WWW_IMG' => $www_img,
- 'WWW' => $www,
- 'ICQ_STATUS_IMG' => $icq_status_img,
- 'ICQ_IMG' => $icq_img,
- 'ICQ' => $icq,
- 'AIM_IMG' => $aim_img,
- 'AIM' => $aim,
- 'MSN_IMG' => $msn_img,
- 'MSN' => $msn,
- 'YIM_IMG' => $yim_img,
- 'YIM' => $yim,
-
- 'U_VIEWPROFILE' => append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=$user_id"))
- );
- }
-
- $template->assign_block_vars('switch_pending_members', array() );
-
- $template->assign_vars(array(
- 'L_SELECT' => $lang['Select'],
- 'L_APPROVE_SELECTED' => $lang['Approve_selected'],
- ...
[truncated message content] |
