+<?php

+/**

+*

+* @package acp

+* @version $Id$

+* @copyright (c) 2005 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+/**

+* - Able to check for new module versions (modes changed/adjusted/added/removed)

+* Icons for:

+* - module enabled and displayed (common)

+* - module enabled and not displayed

+* - module deactivated

+* - category (enabled)

+* - category disabled

+*/

+

+/**

+* @package acp

+*/

+class acp_modules

+{

+ var $mode = '';

+

+ function main($id, $mode)

+ {

+ global $db, $user, $auth, $template;

+ global $config, $phpbb_admin_path, $phpbb_root_path, $phpEx, $SID;

+

+ // Set a global define for modules we might include (the author is able to prevent executing of code with this)

+ define('MODULE_INCLUDE', true);

+

+ $user->add_lang('acp/modules');

+

+ $this->tpl_name = 'acp_modules';

+

+ // module class

+ $this->module_class = $mode;

+

+ if ($this->module_class == 'ucp')

+ {

+ $user->add_lang('ucp');

+ }

+

+ $u_action = "{$phpbb_admin_path}index.$phpEx$SID&amp;i=$id&amp;mode=$mode";

+ $parent_id = request_var('parent_id', 0);

+ $module_id = request_var('m', 0);

+ $action = request_var('action', '');

+ $errors = array();

+

+ switch ($action)

+ {

+ case 'delete':

+ if (!$module_id)

+ {

+ trigger_error($user->lang['NO_MODULE_ID'] . adm_back_link($u_action . '&amp;parent_id=' . $parent_id));

+ }

+

+ if (confirm_box(true))

+ {

+ $errors = $this->delete_module($module_id);

+

+ if (!sizeof($errors))

+ {

+ $this->remove_cache_file();

+ trigger_error($user->lang['MODULE_DELETED'] . adm_back_link($u_action . '&amp;parent_id=' . $parent_id));

+ }

+ }

+ else

+ {

+ confirm_box(false, 'DELETE_MODULE', build_hidden_fields(array(

+ 'i' => $id,

+ 'mode' => $mode,

+ 'parent_id' => $parent_id,

+ 'module_id' => $module_id,

+ 'action' => $action,

+ )));

+ }

+

+ break;

+

+ case 'enable':

+ case 'disable':

+ if (!$module_id)

+ {

+ trigger_error($user->lang['NO_MODULE_ID'] . adm_back_link($u_action . '&amp;parent_id=' . $parent_id));

+ }

+

+ $sql = 'UPDATE ' . MODULES_TABLE . '

+ SET module_enabled = ' . (($action == 'enable') ? 1 : 0) . "

+ WHERE module_id = $module_id";

+ $db->sql_query($sql);

+

+ add_log('admin', 'LOG_MODULE_' . strtoupper($action));

+ $this->remove_cache_file();

+

+ break;

+

+ case 'move_up':

+ case 'move_down':

+ if (!$module_id)

+ {

+ trigger_error($user->lang['NO_MODULE_ID'] . adm_back_link($u_action . '&amp;parent_id=' . $parent_id));

+ }

+

+ $sql = 'SELECT parent_id, left_id, right_id, module_langname

+ FROM ' . MODULES_TABLE . "

+ WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

+ AND module_id = $module_id";

+ $result = $db->sql_query($sql);

+

+ if (!($row = $db->sql_fetchrow($result)))

+ {

+ trigger_error($user->lang['NO_MODULE'] . adm_back_link($u_action . '&amp;parent_id=' . $parent_id));

+ }

+ $db->sql_freeresult($result);

+

+ $module_info = array($module_id => $row);

+

+ // Get the adjacent forum

+ $sql = 'SELECT module_id, left_id, right_id, module_langname

+ FROM ' . MODULES_TABLE . "

+ WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

+ AND parent_id = {$row['parent_id']}

+ AND " . (($action == 'move_up') ? "right_id < {$row['right_id']} ORDER BY right_id DESC" : "left_id > {$row['left_id']} ORDER BY left_id ASC");

+ $result = $db->sql_query_limit($sql, 1);

+

+ if (!($row = $db->sql_fetchrow($result)))

+ {

+ // already on top or at bottom

+ break;

+ }

+ $db->sql_freeresult($result);

+

+ $module_info[$row['module_id']] = $row;

+

+ if ($action == 'move_up')

+ {

+ $up_id = $module_id;

+ $down_id = $row['module_id'];

+ }

+ else

+ {

+ $up_id = $row['module_id'];

+ $down_id = $module_id;

+ }

+

+ $move_module_name = $this->lang_name($row['module_langname']);

+ $diff_up = $module_info[$up_id]['right_id'] - $module_info[$up_id]['left_id'];

+ $diff_down = $module_info[$down_id]['right_id'] - $module_info[$down_id]['left_id'];

+

+ $ids = array();

+

+ $sql = 'SELECT module_id

+ FROM ' . MODULES_TABLE . "

+ WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

+ AND left_id > " . $module_info[$up_id]['left_id'] . '

+ AND right_id < ' . $module_info[$up_id]['right_id'];

+ $result = $db->sql_query($sql);

+

+ while ($row = $db->sql_fetchrow($result))

+ {

+ $ids[] = $row['module_id'];

+ }

+ $db->sql_freeresult($result);

+

+ // Start transaction

+ $db->sql_transaction('begin');

+

+ $sql = 'UPDATE ' . MODULES_TABLE . '

+ SET left_id = left_id + ' . ($diff_up + 1) . ', right_id = right_id + ' . ($diff_up + 1) . "

+ WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

+ AND left_id > " . $module_info[$down_id]['left_id'] . '

+ AND right_id < ' . $module_info[$down_id]['right_id'];

+ $db->sql_query($sql);

+

+ if (sizeof($ids))

+ {

+ $sql = 'UPDATE ' . MODULES_TABLE . '

+ SET left_id = left_id - ' . ($diff_down + 1) . ', right_id = right_id - ' . ($diff_down + 1) . "

+ WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

+ AND module_id IN (" . implode(', ', $ids) . ')';

+ $db->sql_query($sql);

+ }

+

+ $sql = 'UPDATE ' . MODULES_TABLE . '

+ SET left_id = ' . $module_info[$down_id]['left_id'] . ', right_id = ' . ($module_info[$down_id]['left_id'] + $diff_up) . "

+ WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

+ AND module_id = $up_id";

+ $db->sql_query($sql);

+

+ $sql = 'UPDATE ' . MODULES_TABLE . '

+ SET left_id = ' . ($module_info[$up_id]['right_id'] - $diff_down) . ', right_id = ' . $module_info[$up_id]['right_id'] . "

+ WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

+ AND module_id = $down_id";

+ $db->sql_query($sql);

+

+ $db->sql_transaction('commit');

+

+ add_log('admin', 'LOG_MODULE_' . strtoupper($action), $move_module_name);

+

+ // recalculate binary tree

+ recalc_btree('module_id', MODULES_TABLE, $this->module_class);

+ $this->remove_cache_file();

+

+ break;

+

+ case 'quickadd':

+ $quick_install = request_var('quick_install', '');

+

+ if (confirm_box(true))

+ {

+ if (!$quick_install || strpos($quick_install, '::') === false)

+ {

+ break;

+ }

+

+ list($module_name, $module_mode) = explode('::', $quick_install);

+

+ // Check if module name and mode exist...

+ $fileinfo = $this->get_module_infos($module_name);

+ $fileinfo = $fileinfo[$module_name];

+

+ if (isset($fileinfo['modes'][$module_mode]))

+ {

+ $module_data = array(

+ 'module_name' => $module_name,

+ 'module_enabled' => 0,

+ 'module_display' => (isset($fileinfo['modes'][$module_mode]['display'])) ? $fileinfo['modes'][$module_mode]['display'] : 1,

+ 'parent_id' => $parent_id,

+ 'module_class' => $this->module_class,

+ 'module_langname' => $fileinfo['modes'][$module_mode]['title'],

+ 'module_mode' => $module_mode,

+ 'module_auth' => $fileinfo['modes'][$module_mode]['auth'],

+ );

+

+ $errors = $this->update_module_data($module_data);

+

+ if (!sizeof($errors))

+ {

+ // recalculate binary tree

+ recalc_btree('module_id', MODULES_TABLE, $this->module_class);

+ $this->remove_cache_file();

+

+ trigger_error($user->lang['MODULE_ADDED'] . adm_back_link($u_action . '&amp;parent_id=' . $parent_id));

+ }

+ }

+ }

+ else

+ {

+ confirm_box(false, 'ADD_MODULE', build_hidden_fields(array(

+ 'i' => $id,

+ 'mode' => $mode,

+ 'parent_id' => $parent_id,

+ 'action' => 'quickadd',

+ 'quick_install' => $quick_install,

+ )));

+ }

+

+ break;

+

+ case 'edit':

+

+ if (!$module_id)

+ {

+ trigger_error($user->lang['NO_MODULE_ID'] . adm_back_link($u_action . '&amp;parent_id=' . $parent_id));

+ }

+

+ $module_row = $this->get_module_row($module_id);

+

+ // no break

+

+ case 'add':

+

+ if ($action == 'add')

+ {

+ $module_row = array(

+ 'module_name' => '',

+ 'module_enabled' => 0,

+ 'module_display' => 1,

+ 'parent_id' => 0,

+ 'module_langname' => request_var('module_langname', ''),

+ 'module_mode' => '',

+ 'module_auth' => '',

+ );

+ }

+

+ $module_data = array();

+

+ $module_data['module_name'] = request_var('module_name', (string) $module_row['module_name']);

+ $module_data['module_enabled'] = request_var('module_enabled', (int) $module_row['module_enabled']);

+ $module_data['module_display'] = request_var('module_display', (int) $module_row['module_display']);

+ $module_data['parent_id'] = request_var('parent_id', (int) $module_row['parent_id']);

+ $module_data['module_class'] = $this->module_class;

+ $module_data['module_langname'] = request_var('module_langname', (string) $module_row['module_langname']);

+ $module_data['module_mode'] = request_var('module_mode', (string) $module_row['module_mode']);

+

+ $submit = (isset($_POST['submit'])) ? true : false;

+

+ if ($submit)

+ {

+ if (!$module_data['module_langname'])

+ {

+ trigger_error($user->lang['NO_MODULE_LANGNAME'] . adm_back_link($u_action . '&amp;parent_id=' . $parent_id));

+ }

+

+ $module_type = request_var('module_type', 'category');

+

+ if ($module_type == 'category')

+ {

+ $module_data['module_name'] = $module_data['module_mode'] = $module_data['module_auth'] = '';

+ $module_data['module_display'] = 1;

+ }

+

+ if ($action == 'edit')

+ {

+ $module_data['module_id'] = $module_id;

+ }

+

+ // Adjust auth row

+ if ($module_data['module_name'] && $module_data['module_mode'])

+ {

+ $fileinfo = $this->get_module_infos($module_data['module_name']);

+ $module_data['module_auth'] = $fileinfo[$module_data['module_name']]['modes'][$module_data['module_mode']]['auth'];

+ }

+

+ $errors = $this->update_module_data($module_data);

+

+ if (!sizeof($errors))

+ {

+ // recalculate binary tree

+ recalc_btree('module_id', MODULES_TABLE, $this->module_class);

+ $this->remove_cache_file();

+

+ trigger_error((($action == 'add') ? $user->lang['MODULE_ADDED'] : $user->lang['MODULE_EDITED']) . adm_back_link($u_action . '&amp;parent_id=' . $parent_id));

+ }

+ }

+

+ // Category/not category?

+ $is_cat = (!$module_data['module_name']) ? true : false;

+

+ // Get module informations

+ $module_infos = $this->get_module_infos();

+

+ // Build name options

+ $s_name_options = $s_mode_options = '';

+ foreach ($module_infos as $option => $values)

+ {

+ if (!$module_data['module_name'])

+ {

+ $module_data['module_name'] = $option;

+ }

+

+ // Name options

+ $s_name_options .= '<option value="' . $option . '"' . (($option == $module_data['module_name']) ? ' selected="selected"' : '') . '>' . $this->lang_name($values['title']) . ' [' . $this->module_class . '_' . $option . ']</option>';

+

+ $template->assign_block_vars('m_names', array('NAME' => str_replace("'", "\'", stripslashes($option))));

+

+ // Build module modes

+ foreach ($values['modes'] as $m_mode => $m_values)

+ {

+ if ($option == $module_data['module_name'])

+ {

+ $s_mode_options .= '<option value="' . $m_mode . '"' . (($m_mode == $module_data['module_mode']) ? ' selected="selected"' : '') . '>' . $this->lang_name($m_values['title']) . '</option>';

+ }

+

+ $template->assign_block_vars('m_names.modes', array(

+ 'OPTION' => str_replace("'", "\'", stripslashes($m_mode)),

+ 'VALUE' => str_replace("'", "\'", stripslashes($this->lang_name($m_values['title']))))

+ );

+ }

+ }

+

+ $s_cat_option = '<option value="0"' . (($module_data['parent_id'] == 0) ? ' selected="selected"' : '') . '>' . $user->lang['NO_PARENT'] . '</option>';

+

+ $template->assign_vars(array_merge(array(

+ 'S_EDIT_MODULE' => true,

+ 'S_IS_CAT' => $is_cat,

+ 'S_CAT_OPTIONS' => $s_cat_option . $this->make_module_select($parent_id, ($action == 'edit') ? $module_row['module_id'] : false, false, false, false, true),

+ 'S_MODULE_NAMES' => $s_name_options,

+ 'S_MODULE_MODES' => $s_mode_options,

+ 'U_BACK' => $u_action . '&amp;parent_id=' . $parent_id,

+ 'U_EDIT_ACTION' => $u_action,

+

+ 'L_TITLE' => $user->lang[strtoupper($action) . '_MODULE'],

+

+ 'MODULENAME' => $this->lang_name($module_data['module_langname']),

+ 'ACTION' => $action,

+ 'MODULE_ID' => $module_id,

+

+ ),

+ array_change_key_case($module_data, CASE_UPPER))

+ );

+

+ if (sizeof($errors))

+ {

+ $template->assign_vars(array(

+ 'S_ERROR' => true,

+ 'ERROR_MSG' => implode('<br />', $errors))

+ );

+ }

+

+ return;

+

+ break;

+ }

+

+ // Default management page

+ if (sizeof($errors))

+ {

+ $template->assign_vars(array(

+ 'S_ERROR' => true,

+ 'ERROR_MSG' => implode('<br />', $errors))

+ );

+ }

+

+ if (!$parent_id)

+ {

+ $navigation = strtoupper($this->module_class);

+ }

+ else

+ {

+ $navigation = '<a href="' . $u_action . '">' . strtoupper($this->module_class) . '</a>';

+

+ $modules_nav = $this->get_module_branch($parent_id, 'parents', 'descending');

+ foreach ($modules_nav as $row)

+ {

+ $langname = $this->lang_name($row['module_langname']);

+

+ if ($row['module_id'] == $parent_id)

+ {

+ $navigation .= ' -&gt; ' . $langname;

+ }

+ else

+ {

+ $navigation .= ' -&gt; <a href="' . $u_action . '&amp;parent_id=' . $row['module_id'] . '">' . $langname . '</a>';

+ }

+ }

+ }

+

+ // Jumpbox

+ $module_box = $this->make_module_select($parent_id, false, false, false, false);

+

+ $sql = 'SELECT *

+ FROM ' . MODULES_TABLE . "

+ WHERE parent_id = $parent_id

+ AND module_class = '" . $db->sql_escape($this->module_class) . "'

+ ORDER BY left_id";

+ $result = $db->sql_query($sql);

+

+ if ($row = $db->sql_fetchrow($result))

+ {

+ do

+ {

+ $langname = $this->lang_name($row['module_langname']);

+

+ if (!$row['module_enabled'])

+ {

+ $module_image = '<img src="images/icon_folder_lock.gif" width="46" height="25" alt="' . $user->lang['DEACTIVATED_MODULE'] .'" />';

+ }

+ else

+ {

+ $module_image = (!$row['module_name'] || $row['left_id'] + 1 != $row['right_id']) ? '<img src="images/icon_subfolder.gif" width="46" height="25" alt="' . $user->lang['CATEGORY'] . '" />' : '<img src="images/icon_folder.gif" width="46" height="25" alt="' . $user->lang['MODULE'] . '" />';

+ }

+

+ $url = $u_action . '&amp;parent_id=' . $parent_id . '&amp;m=' . $row['module_id'];

+

+ $template->assign_block_vars('modules', array(

+ 'MODULE_IMAGE' => $module_image,

+ 'MODULE_TITLE' => $langname,

+ 'MODULE_ENABLED' => ($row['module_enabled']) ? true : false,

+

+ 'U_MODULE' => $u_action . '&amp;parent_id=' . $row['module_id'],

+ 'U_MOVE_UP' => $url . '&amp;action=move_up',

+ 'U_MOVE_DOWN' => $url . '&amp;action=move_down',

+ 'U_EDIT' => $url . '&amp;action=edit',

+ 'U_DELETE' => $url . '&amp;action=delete',

+ 'U_ENABLE' => $url . '&amp;action=enable',

+ 'U_DISABLE' => $url . '&amp;action=disable')

+ );

+ }

+ while ($row = $db->sql_fetchrow($result));

+ }

+ else if ($parent_id)

+ {

+ $row = $this->get_module_row($parent_id);

+

+ $url = $u_action . '&amp;parent_id=' . $parent_id . '&amp;m=' . $row['module_id'];

+

+ $template->assign_vars(array(

+ 'S_NO_MODULES' => true,

+

+ 'U_EDIT' => $url . '&amp;action=edit',

+ 'U_DELETE' => $url . '&amp;action=delete',

+ 'U_ENABLE' => $url . '&amp;action=enable',

+ 'U_DISABLE' => $url . '&amp;action=disable')

+ );

+ }

+ $db->sql_freeresult($result);

+

+ // Quick adding module

+ $module_infos = $this->get_module_infos();

+

+ // Build quick options

+ $s_install_options = '';

+ foreach ($module_infos as $option => $values)

+ {

+ // Name options

+ $s_install_options .= '<optgroup label="' . $this->lang_name($values['title']) . ' [' . $this->module_class . '_' . $option . ']">';

+

+ // Build module modes

+ foreach ($values['modes'] as $m_mode => $m_values)

+ {

+ $s_install_options .= '<option value="' . $option . '::' . $m_mode . '">&nbsp; &nbsp;' . $this->lang_name($m_values['title']) . '</option>';

+ }

+

+ $s_install_options .= '</optgroup>';

+ }

+

+ $template->assign_vars(array(

+ 'U_SEL_ACTION' => $u_action,

+ 'U_ACTION' => $u_action . '&amp;parent_id=' . $parent_id,

+ 'NAVIGATION' => $navigation,

+ 'MODULE_BOX' => $module_box,

+ 'S_INSTALL_OPTIONS' => $s_install_options,

+ )

+ );

+ }

+

+ /**

+ * Get row for specified module

+ */

+ function get_module_row($module_id)

+ {

+ global $db, $user;

+

+ $sql = 'SELECT *

+ FROM ' . MODULES_TABLE . "

+ WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

+ AND module_id = $module_id";

+ $result = $db->sql_query($sql);

+ $row = $db->sql_fetchrow($result);

+ $db->sql_freeresult($result);

+

+ if (!$row)

+ {

+ trigger_error($user->lang['NO_MODULE']);

+ }

+

+ return $row;

+ }

+

+ /**

+ * Get available module informations from module files

+ */

+ function get_module_infos($module = '')

+ {

+ global $phpbb_root_path, $phpEx;

+

+ $directory = $phpbb_root_path . 'includes/' . $this->module_class . '/';

+

+ $fileinfo = array();

+

+ if (!$module)

+ {

+ $dh = opendir($directory);

+ while ($file = readdir($dh))

+ {

+ // Is module?

+ if (strpos($file, $this->module_class . '_') === 0)

+ {

+ $class = str_replace(".$phpEx", '', $file) . '_info';

+

+ // Do not include current working file ;)

+ if (!class_exists($class))

+ {

+ include($directory . $file);

+ }

+

+ // Get module title tag

+ if (class_exists($class))

+ {

+ $c_class = new $class();

+ $module_info = $c_class->module();

+ $fileinfo[str_replace($this->module_class . '_', '', $module_info['filename'])] = $module_info;

+ }

+ }

+ }

+ closedir($dh);

+ }

+ else

+ {

+ $filename = $this->module_class . '_' . basename($module);

+ $class = $this->module_class . '_' . basename($module) . '_info';

+

+ // Do not include current working file ;)

+ if (!class_exists($class))

+ {

+ include($directory . $filename . '.' . $phpEx);

+ }

+

+ // Get module title tag

+ if (class_exists($class))

+ {

+ $c_class = new $class();

+ $module_info = $c_class->module();

+ $fileinfo[str_replace($this->module_class . '_', '', $module_info['filename'])] = $module_info;

+ }

+ }

+

+ return $fileinfo;

+ }

+

+ /**

+ * Simple version of jumpbox, just lists modules

+ */

+ function make_module_select($select_id = false, $ignore_id = false, $ignore_acl = false, $ignore_nonpost = false, $ignore_emptycat = true, $ignore_noncat = false)

+ {

+ global $db, $user, $auth, $config;

+

+ $sql = 'SELECT module_id, module_enabled, module_name, parent_id, module_langname, left_id, right_id, module_auth

+ FROM ' . MODULES_TABLE . "

+ WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

+ ORDER BY left_id ASC";

+ $result = $db->sql_query($sql);

+

+ $right = $iteration = 0;

+ $padding_store = array('0' => '');

+ $module_list = $padding = '';

+

+ while ($row = $db->sql_fetchrow($result))

+ {

+ if ($row['left_id'] < $right)

+ {

+ $padding .= '&nbsp; &nbsp;';

+ $padding_store[$row['parent_id']] = $padding;

+ }

+ else if ($row['left_id'] > $right + 1)

+ {

+ $padding = (isset($padding_store[$row['parent_id']])) ? $padding_store[$row['parent_id']] : '';

+ }

+

+ $right = $row['right_id'];

+

+ /**

+ * @todo think about using module class here

+ */

+ if (!$ignore_acl && $row['module_auth'])

+ {

+ $is_auth = false;

+ eval('$is_auth = (int) (' . preg_replace(array('#acl_([a-z_]+)(,\$id)?#e', '#\$id#', '#cfg_([a-z_]+)#e'), array('(int) $auth->acl_get("\\1"\\2)', '$this->acl_forup_id', '(int) $config["\\1"]'), trim($row['module_auth'])) . ');');

+ if (!$is_auth)

+ {

+ continue;

+ }

+ }

+

+ // ignore this module?

+ if ((is_array($ignore_id) && in_array($row['module_id'], $ignore_id)) || $row['module_id'] == $ignore_id)

+ {

+ continue;

+ }

+

+ // empty category

+ if (!$row['module_name'] && ($row['left_id'] + 1 == $row['right_id']) && $ignore_emptycat)

+ {

+ continue;

+ }

+

+ // ignore non-category?

+ if ($row['module_name'] && $ignore_noncat)

+ {

+ continue;

+ }

+

+ $selected = (is_array($select_id)) ? ((in_array($row['module_id'], $select_id)) ? ' selected="selected"' : '') : (($row['module_id'] == $select_id) ? ' selected="selected"' : '');

+

+ $langname = $this->lang_name($row['module_langname']);

+ $module_list .= '<option value="' . $row['module_id'] . '"' . $selected . ((!$row['module_enabled']) ? ' class="disabled"' : '') . '>' . $padding . $langname . '</option>';

+

+ $iteration++;

+ }

+ unset($padding_store);

+

+ return $module_list;

+ }

+

+ /**

+ * Get module branch

+ */

+ function get_module_branch($module_id, $type = 'all', $order = 'descending', $include_module = true)

+ {

+ global $db;

+

+ switch ($type)

+ {

+ case 'parents':

+ $condition = 'm1.left_id BETWEEN m2.left_id AND m2.right_id';

+ break;

+

+ case 'children':

+ $condition = 'm2.left_id BETWEEN m1.left_id AND m1.right_id';

+ break;

+

+ default:

+ $condition = 'm2.left_id BETWEEN m1.left_id AND m1.right_id OR m1.left_id BETWEEN m2.left_id AND m2.right_id';

+ }

+

+ $rows = array();

+

+ $sql = 'SELECT m2.*

+ FROM (' . MODULES_TABLE . ' m1

+ LEFT JOIN ' . MODULES_TABLE . " m2 ON $condition)

+ WHERE m1.module_class = '" . $db->sql_escape($this->module_class) . "'

+ AND m2.module_class = '" . $db->sql_escape($this->module_class) . "'

+ AND m1.module_id = $module_id

+ ORDER BY m2.left_id " . (($order == 'descending') ? 'ASC' : 'DESC');

+ $result = $db->sql_query($sql);

+

+ while ($row = $db->sql_fetchrow($result))

+ {

+ if (!$include_module && $row['module_id'] == $module_id)

+ {

+ continue;

+ }

+

+ $rows[] = $row;

+ }

+ $db->sql_freeresult($result);

+

+ return $rows;

+ }

+

+ /**

+ * Remove modules cache file

+ */

+ function remove_cache_file()

+ {

+ global $phpbb_root_path, $phpEx;

+

+ // Sanitise for future path use, it's escaped as appropriate for queries

+ $p_class = str_replace(array('.', '/', '\\'), '', basename($this->module_class));

+

+ if (file_exists($phpbb_root_path . 'cache/' . $p_class . '_modules.' . $phpEx))

+ {

+ @unlink($phpbb_root_path . 'cache/' . $p_class . '_modules.' . $phpEx);

+ }

+ }

+

+ /**

+ * Return correct language name

+ */

+ function lang_name($module_langname)

+ {

+ global $user;

+

+ return (!empty($user->lang[$module_langname])) ? $user->lang[$module_langname] : $module_langname;

+ }

+

+ /**

+ * Update/Add module

+ */

+ function update_module_data(&$module_data)

+ {

+ global $db, $user;

+

+ if (!isset($module_data['module_id']))

+ {

+ // no module_id means we're creating a new category/module

+

+ $db->sql_transaction('begin');

+

+ if ($module_data['parent_id'])

+ {

+ $sql = 'SELECT left_id, right_id

+ FROM ' . MODULES_TABLE . "

+ WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

+ AND module_id = {$module_data['parent_id']}";

+ $result = $db->sql_query($sql);

+

+ if (!$row = $db->sql_fetchrow($result))

+ {

+ trigger_error($user->lang['PARENT_NO_EXIST']);

+ }

+ $db->sql_freeresult($result);

+

+ $sql = 'UPDATE ' . MODULES_TABLE . "

+ SET left_id = left_id + 2, right_id = right_id + 2

+ WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

+ AND left_id > {$row['right_id']}";

+ $db->sql_query($sql);

+

+ $sql = 'UPDATE ' . MODULES_TABLE . "

+ SET right_id = right_id + 2

+ WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

+ AND {$row['left_id']} BETWEEN left_id AND right_id";

+ $db->sql_query($sql);

+

+ $module_data['left_id'] = $row['right_id'];

+ $module_data['right_id'] = $row['right_id'] + 1;

+ }

+ else

+ {

+ $sql = 'SELECT MAX(right_id) AS right_id

+ FROM ' . MODULES_TABLE . "

+ WHERE module_class = '" . $db->sql_escape($this->module_class) . "'";

+ $result = $db->sql_query($sql);

+ $row = $db->sql_fetchrow($result);

+ $db->sql_freeresult($result);

+

+ $module_data['left_id'] = $row['right_id'] + 1;

+ $module_data['right_id'] = $row['right_id'] + 2;

+ }

+

+ $sql = 'INSERT INTO ' . MODULES_TABLE . ' ' . $db->sql_build_array('INSERT', $module_data);

+ $db->sql_query($sql);

+

+ $db->sql_transaction('commit');

+

+ $module_data['module_id'] = $db->sql_nextid();

+ add_log('admin', 'LOG_MODULE_ADD', $this->lang_name($module_data['module_langname']));

+ }

+ else

+ {

+ $row = $this->get_module_row($module_data['module_id']);

+

+ if ($module_data['module_name'] && !$row['module_name'])

+ {

+ // we're turning a category into a module

+ $branch = $this->get_module_branch($module_data['module_id'], 'children', 'descending', false);

+

+ if (sizeof($branch))

+ {

+ return array($user->lang['NO_CATEGORY_TO_MODULE']);

+ }

+ }

+

+ if ($row['parent_id'] != $module_data['parent_id'])

+ {

+ $this->move_module($module_data['module_id'], $module_data['parent_id']);

+ }

+

+ $sql = 'UPDATE ' . MODULES_TABLE . '

+ SET ' . $db->sql_build_array('UPDATE', $module_data) . "

+ WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

+ AND module_id = {$module_data['module_id']}";

+ $db->sql_query($sql);

+

+ add_log('admin', 'LOG_MODULE_EDIT', $this->lang_name($module_data['module_langname']));

+ }

+

+ return array();

+ }

+

+ function move_module($from_module_id, $to_parent_id)

+ {

+ global $db;

+

+ $moved_modules = $this->get_module_branch($from_module_id, 'children', 'descending');

+ $from_data = $moved_modules[0];

+ $diff = sizeof($moved_modules) * 2;

+

+ $moved_ids = array();

+ for ($i = 0; $i < sizeof($moved_modules); ++$i)

+ {

+ $moved_ids[] = $moved_modules[$i]['module_id'];

+ }

+

+ // Resync parents

+ $sql = 'UPDATE ' . MODULES_TABLE . "

+ SET right_id = right_id - $diff

+ WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

+ AND left_id < " . $from_data['right_id'] . "

+ AND right_id > " . $from_data['right_id'];

+ $db->sql_query($sql);

+

+ // Resync righthand side of tree

+ $sql = 'UPDATE ' . MODULES_TABLE . "

+ SET left_id = left_id - $diff, right_id = right_id - $diff

+ WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

+ AND left_id > " . $from_data['right_id'];

+ $db->sql_query($sql);

+

+ if ($to_parent_id > 0)

+ {

+ $to_data = $this->get_module_row($to_parent_id);

+

+ // Resync new parents

+ $sql = 'UPDATE ' . MODULES_TABLE . "

+ SET right_id = right_id + $diff

+ WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

+ AND " . $to_data['right_id'] . ' BETWEEN left_id AND right_id

+ AND module_id NOT IN (' . implode(', ', $moved_ids) . ')';

+ $db->sql_query($sql);

+

+ // Resync the righthand side of the tree

+ $sql = 'UPDATE ' . MODULES_TABLE . "

+ SET left_id = left_id + $diff, right_id = right_id + $diff

+ WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

+ AND left_id > " . $to_data['right_id'] . '

+ AND module_id NOT IN (' . implode(', ', $moved_ids) . ')';

+ $db->sql_query($sql);

+

+ // Resync moved branch

+ $to_data['right_id'] += $diff;

+ if ($to_data['right_id'] > $from_data['right_id'])

+ {

+ $diff = '+ ' . ($to_data['right_id'] - $from_data['right_id'] - 1);

+ }

+ else

+ {

+ $diff = '- ' . abs($to_data['right_id'] - $from_data['right_id'] - 1);

+ }

+ }

+ else

+ {

+ $sql = 'SELECT MAX(right_id) AS right_id

+ FROM ' . MODULES_TABLE . "

+ WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

+ AND module_id NOT IN (" . implode(', ', $moved_ids) . ')';

+ $result = $db->sql_query($sql);

+ $row = $db->sql_fetchrow($result);

+ $db->sql_freeresult($result);

+

+ $diff = '+ ' . ($row['right_id'] - $from_data['left_id'] + 1);

+ }

+

+ $sql = 'UPDATE ' . MODULES_TABLE . "

+ SET left_id = left_id $diff, right_id = right_id $diff

+ WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

+ AND module_id IN (" . implode(', ', $moved_ids) . ')';

+ $db->sql_query($sql);

+ }

+

+ function delete_module($module_id)

+ {

+ global $db, $user;

+

+ $row = $this->get_module_row($module_id);

+

+ $branch = $this->get_module_branch($module_id, 'children', 'descending', false);

+

+ if (sizeof($branch))

+ {

+ return array($user->lang['CANNOT_REMOVE_MODULE']);

+ }

+

+ // If not move

+ $diff = 2;

+ $sql = 'DELETE FROM ' . MODULES_TABLE . "

+ WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

+ AND module_id = $module_id";

+ $db->sql_query($sql);

+

+ // Resync tree

+ $sql = 'UPDATE ' . MODULES_TABLE . "

+ SET right_id = right_id - $diff

+ WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

+ AND left_id < {$row['right_id']} AND right_id > {$row['right_id']}";

+ $db->sql_query($sql);

+

+ $sql = 'UPDATE ' . MODULES_TABLE . "

+ SET left_id = left_id - $diff, right_id = right_id - $diff

+ WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

+ AND left_id > {$row['right_id']}";

+ $db->sql_query($sql);

+

+ add_log('admin', 'LOG_MODULE_REMOVED', $this->lang_name($row['module_langname']));

+

+ return array();

+

+ }

+}

+

+/**

+* @package module_install

+*/

+class acp_modules_info

+{

+ function module()

+ {

+ return array(

+ 'filename' => 'acp_modules',

+ 'title' => 'ACP_MODULE_MANAGEMENT',

+ 'version' => '1.0.0',

+ 'modes' => array(

+ 'acp' => array('title' => 'ACP', 'auth' => 'acl_a_modules'),

+ 'ucp' => array('title' => 'USER_CONTROL_PANEL', 'auth' => 'acl_a_modules'),

+ 'mcp' => array('title' => 'MCP', 'auth' => 'acl_a_modules'),

+ ),

+ );

+ }

+

+ function install()

+ {

+ }

+

+ function uninstall()

+ {

+ }

+}

+

+?> \ No newline at end of file