Menu
▾
▴
[xoops-svn] SF.net SVN: xoops:[9129] XoopsModules/xroster/trunk/xroster
|
From: <be...@us...> - 2012-03-14 10:17:31
|
Revision: 9129
http://xoops.svn.sourceforge.net/xoops/?rev=9129&view=rev
Author: beckmi
Date: 2012-03-14 10:17:18 +0000 (Wed, 14 Mar 2012)
Log Message:
-----------
Converting to XOOPS 2.5.x Admin GUI
Modified Paths:
--------------
XoopsModules/xroster/trunk/xroster/admin/index.php
XoopsModules/xroster/trunk/xroster/admin/menu.php
XoopsModules/xroster/trunk/xroster/blocks/xroster_blocks.php
XoopsModules/xroster/trunk/xroster/common.inc.php
XoopsModules/xroster/trunk/xroster/index.php
XoopsModules/xroster/trunk/xroster/language/english/main.php
XoopsModules/xroster/trunk/xroster/language/english/modinfo.php
XoopsModules/xroster/trunk/xroster/xoops_version.php
XoopsModules/xroster/trunk/xroster/xroster.png
Added Paths:
-----------
XoopsModules/xroster/trunk/xroster/admin/about.php
XoopsModules/xroster/trunk/xroster/admin/admin_footer.php
XoopsModules/xroster/trunk/xroster/admin/admin_header.php
XoopsModules/xroster/trunk/xroster/admin/main.php
XoopsModules/xroster/trunk/xroster/docs/
XoopsModules/xroster/trunk/xroster/docs/changelog.txt
XoopsModules/xroster/trunk/xroster/docs/credits.txt
XoopsModules/xroster/trunk/xroster/docs/index.html
XoopsModules/xroster/trunk/xroster/docs/install.txt
XoopsModules/xroster/trunk/xroster/docs/lang_diff.txt
XoopsModules/xroster/trunk/xroster/docs/licence.txt
XoopsModules/xroster/trunk/xroster/docs/readme.txt
XoopsModules/xroster/trunk/xroster/language/english/admin.php
XoopsModules/xroster/trunk/xroster/language/english/help/
XoopsModules/xroster/trunk/xroster/language/english/help/help.html
XoopsModules/xroster/trunk/xroster/language/english/help/index.html
Removed Paths:
-------------
XoopsModules/xroster/trunk/xroster/images/Thumbs.db
Added: XoopsModules/xroster/trunk/xroster/admin/about.php
===================================================================
--- XoopsModules/xroster/trunk/xroster/admin/about.php (rev 0)
+++ XoopsModules/xroster/trunk/xroster/admin/about.php 2012-03-14 10:17:18 UTC (rev 9129)
@@ -0,0 +1,31 @@
+<?php
+/**
+ * XOOPS Profile module
+ *
+ * You may not change or alter any portion of this comment or credits
+ * of supporting developers from this source code or any supporting source code
+ * which is considered copyrighted (c) material of the original comment or credit authors.
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
+ *
+ * @copyright The XOOPS Project (http://www.xoops.org)
+ * @license GNU GPL (http://www.gnu.org/licenses/gpl-2.0.html/)
+ * @package xoopsPoll
+ * @since 2.5.0
+ * @author Mage, Mamba
+ * @version $Id $
+ **/
+
+include '../../../include/cp_header.php';
+include 'admin_header.php';
+xoops_cp_header();
+
+$module_info =& $module_handler->get($xoopsModule->getVar("mid"));
+
+$aboutAdmin = new ModuleAdmin();
+
+echo $aboutAdmin->addNavigation('about.php');
+echo $aboutAdmin->renderabout('6KJ7RW5DR3VTJ', false);
+
+include 'admin_footer.php';
\ No newline at end of file
Added: XoopsModules/xroster/trunk/xroster/admin/admin_footer.php
===================================================================
--- XoopsModules/xroster/trunk/xroster/admin/admin_footer.php (rev 0)
+++ XoopsModules/xroster/trunk/xroster/admin/admin_footer.php 2012-03-14 10:17:18 UTC (rev 9129)
@@ -0,0 +1,27 @@
+<?php
+/**
+ * Marquee module
+ *
+ * You may not change or alter any portion of this comment or credits
+ * of supporting developers from this source code or any supporting source code
+ * which is considered copyrighted (c) material of the original comment or credit authors.
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
+ *
+ * @copyright The XOOPS Project http://sourceforge.net/projects/xoops/
+ * @license http://www.gnu.org/licenses/gpl-2.0.html GNU Public License
+ * @package Marquee
+ * @since 2.5.0
+ * @author Mamba (www.xoops.org)
+ * @version $Id $
+**/
+
+echo "<div class='adminfooter'>\n"
+ ." <div style='text-align: center;'>\n"
+ ." <a href='http://www.xoops.org' target='_blank'><img src='{$pathIcon32}/xoopsmicrobutton.gif' alt='XOOPS' title='XOOPS'></a>\n"
+ ." </div>\n"
+ ." " . _AM_ADMIN_FOOTER . "\n"
+ ."</div>";
+
+xoops_cp_footer();
\ No newline at end of file
Added: XoopsModules/xroster/trunk/xroster/admin/admin_header.php
===================================================================
--- XoopsModules/xroster/trunk/xroster/admin/admin_header.php (rev 0)
+++ XoopsModules/xroster/trunk/xroster/admin/admin_header.php 2012-03-14 10:17:18 UTC (rev 9129)
@@ -0,0 +1,25 @@
+<?php
+
+$path = dirname(dirname(dirname(dirname(__FILE__))));
+include_once $path . '/mainfile.php';
+include_once $path . '/include/cp_functions.php';
+require_once $path . '/include/cp_header.php';
+
+global $xoopsModule;
+
+$thisModuleDir = $GLOBALS['xoopsModule']->getVar('dirname');
+
+// Load language files
+xoops_loadLanguage('admin', $thisModuleDir);
+xoops_loadLanguage('modinfo', $thisModuleDir);
+xoops_loadLanguage('main', $thisModuleDir);
+
+$pathIcon16 = '../'.$xoopsModule->getInfo('icons16');
+$pathIcon32 = '../'.$xoopsModule->getInfo('icons32');
+$pathModuleAdmin = $xoopsModule->getInfo('dirmoduleadmin');
+
+if ( file_exists($GLOBALS['xoops']->path($pathModuleAdmin.'/moduleadmin.php'))){
+ include_once $GLOBALS['xoops']->path($pathModuleAdmin.'/moduleadmin.php');
+ }else{
+ redirect_header("../../../admin.php", 5, _AM_MODULEADMIN_MISSING, false);
+ }
\ No newline at end of file
Modified: XoopsModules/xroster/trunk/xroster/admin/index.php
===================================================================
--- XoopsModules/xroster/trunk/xroster/admin/index.php 2012-03-14 10:13:12 UTC (rev 9128)
+++ XoopsModules/xroster/trunk/xroster/admin/index.php 2012-03-14 10:17:18 UTC (rev 9129)
@@ -1,391 +1,53 @@
<?php
+// $Id: index.php 8066 2011-11-06 05:09:33Z beckmi $
+// ------------------------------------------------------------------------ //
+// XOOPS - PHP Content Management System //
+// Copyright (c) 2000 XOOPS.org //
+// <http://www.xoops.org/> //
+// ------------------------------------------------------------------------ //
+// 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. //
+// //
+// You may not change or alter any portion of this comment or credits //
+// of supporting developers from this source code or any supporting //
+// source code which is considered copyrighted (c) material of the //
+// original comment or credit authors. //
+// //
+// This program is distributed in the hope that it will be useful, //
+// but WITHOUT ANY WARRANTY; without even the implied warranty of //
+// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the //
+// GNU General Public License for more details. //
+// //
+// You should have received a copy of the GNU General Public License //
+// along with this program; if not, write to the Free Software //
+// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA //
+// ------------------------------------------------------------------------ //
+// Author: Raul Recio (AKA UNFOR) //
+// Project: The XOOPS Project //
+// ------------------------------------------------------------------------- //
-$xRoster_mydir = dirname(__FILE__);
-require_once "$xRoster_mydir/../../../include/cp_header.php";
-require_once file_exists("$xRoster_mydir/../language/" . $xoopsConfig['language'] . '/main.php')
- ? "$xRoster_mydir/../language/" . $xoopsConfig['language'] . '/main.php'
- : "$xRoster_mydir/../language/english/main.php";
-require_once "$xRoster_mydir/../common.inc.php";
+include_once 'admin_header.php';
+xoops_cp_header();
-function xRoster_AdminHeader(){
- global $xoopsModule;
- xoops_cp_header();
- printf(_MD_ADMINWELCOME, $xoopsModule->getVar('name'));
- echo '<p align="center"><b><a href="', XOOPS_URL, '/modules/system/admin.php?fct=preferences&op=showmod&mod=', $xoopsModule->getVar('mid'), '">', _MD_PREFERENCES, '</a></b>
- | <a href="index.php?op=members_add">', _MD_ADDMEMBER, '</a>
- | <a href="index.php?op=members_approve">', _MD_NEWMEMBERS, '</a>
- | <a href="index.php?op=members_list">', _MD_MEMBERS, '</a><br>
- <a href="index.php?op=Title_Editor">', _MD_TITLEEDITOR, '</a>
- | <a href="index.php?op=Title_Editor&t_action=add">', _MD_ADDTITLE, '</a>
- | <a href="index.php?op=Group_Editor">', _MD_GROUPEDITOR, '</a>
- | <a href="index.php?op=Group_Editor&g_action=add">', _MD_ADDGROUP, '</a>
- | <a href="index.php?op=Category_Editor">', _MD_CATEGORYEDITOR, '</a>
- | <a href="index.php?op=Category_Editor&c_action=add">', _MD_ADDCATEGORY, '</a></p>';
-}
+$indexAdmin = new ModuleAdmin();
+//-----------------------
+// $xpPartnerHandler =& xoops_getmodulehandler('partners', $xoopsModule->getVar('dirname'));
-function Members_Edit($id = 0) {
- global $xoopsDB, $xRosterList_connspeed, $xRosterList_ahour, $xRosterList_weapon, $xRosterList_imnetworks;
- if($id) {
- $result = xRoster_Query("SELECT * FROM {xRoster} WHERE id = $id");
- if(!($member = $xoopsDB->fetchArray($result))) return false;
- $member['since'] = formatTimestamp($member['since'], 's');
- } else
- $member = array('member' => 1, 'since' => formatTimestamp(time(), 's'));
- $result = xRoster_Query('SELECT id, name FROM {xRoster_titles} ORDER BY weight, name');
- while($row = $xoopsDB->fetchArray($result))
- $titles[$row['id']] = $row['name'];
- // Here comes the form
- echo '<form method="post">
- <input type="hidden" name="id" value="' . $id . '">
- <input type="hidden" name="op" value="members_update">
- <table cellspacing="8" cellpadding="8" class="outer">';
- echo '<tr><td>', _MD_REALNAME, '</td><td><input type="text" name="realname" value="', $member['realname'], '"></td></tr>';
- echo '<tr><td>', _MD_NAME, '</td><td><input type="text" name="membername" value="', $member['membername'], '"></td></tr>';
- echo '<tr><td>', _MD_EMAIL, '</td><td><input type="text" name="email" value="', $member['email'], '"></td></tr>';
- echo '<tr><td>', _MD_AGE, '</td><td><input type="text" name="age" value="', $member['age'], '"></td></tr>';
- echo '<tr><td>', _MD_CATEGORY, '</td><td>', xRoster_SQLDropDown('SELECT id, name FROM {xRoster_categories} ORDER BY weight, name', 'cid', $member['cid']), '</td></tr>';
- echo '<tr><td>', _MD_GROUP, '</td><td>', xRoster_SQLDropDown('SELECT id, name FROM {xRoster_groups} ORDER BY weight, name', 'gid', $member['gid']), '</td></tr>';
- echo '<tr><td>', _MD_LOCATION, '</td><td>', xRoster_LocationDropDown($member['location'] ? $member['location'] : 'US'), '</td></tr>';
- echo '<tr><td>', _MD_CONNECTION, '</td><td>', xRoster_DropDown('connection', $xRosterList_connspeed + array(_MD_OTHER=>_MD_OTHER), $member['connection']), '</td></tr>';
- echo '<tr><td>', _MD_AVAILABLEHOURS, '</td><td>', xRoster_DropDown('ahours', $xRosterList_ahour + array(_MD_TOOMANYHOURS=>_MD_TOOMANYHOURS), $member['ahours']), '</td></tr>';
- echo '<tr><td>', _MD_PRIMARYWEAPON, '</td><td>', xRoster_DropDown('pweapon', $xRosterList_weapon, $member['pweapon']), '</td></tr>';
- echo '<tr><td>', _MD_SECONDARYWEAPON, '</td><td>', xRoster_DropDown('sweapon', $xRosterList_weapon, $member['sweapon']), '</td></tr>';
- echo '<tr><td colspan="2">', _MD_CLANBEFORE, ' ', xRoster_YNDropDown('clan_before', $member['clan_before']), '</td></tr>';
- echo '<tr><td colspan="2">', _MD_NOTE3, '<br><textarea rows="3" name="why_play">', $member['why_play'], '</textarea></td></tr>';
- echo '<tr><td colspan="2">', _MD_NOTE4, '<br><textarea rows="3" name="skills_talents">', $member['skills_talents'], '</textarea></td></tr>';
- echo '<tr><td colspan="2">', _MD_NOTE1, '<br><textarea rows="3" name="additional_comments">', $member['additional_comments'], '</textarea></td></tr>';
- echo '<tr><td>', _MD_TITLE, '</td><td>', xRoster_DropDown('tid', $titles, $member['tid'], true), '</td></tr>';
- echo '<tr><td>', _MD_IMAGEPATH, '</td><td><input type="text" name="picture" value="', $member['picture'], '"></td></tr>';
- echo '<tr><td>', _MD_WEBSITENAME, '</td><td><input type="text" name="sitename" value="', $member['sitename'], '"></td></tr>';
- echo '<tr><td>', _MD_WEBSITEURL, '</td><td><input type="text" name="siteurl" value="', $member['siteurl'], '"></td></tr>';
- echo '<tr><td>', _MD_IMNETWORK, '</td><td>', xRoster_DropDown('impref', $xRosterList_imnetworks, $member['impref']), '</td></tr>';
- echo '<tr><td>', _MD_IMID, '</td><td><input type="text" name="imid" value="', $member['imid'], '"></td></tr>';
- echo '<tr><td colspan="2">', _MD_NOTE5, '<br><textarea rows="3" name="additional_info">', $member['additional_info'], '</textarea></td></tr>';
- echo '<tr><td>', _MD_SINCE, '</td><td>', $member['since'], '</td></tr>';
- echo '<tr><td colspan="2">', _MD_APPROVED, ' ', xRoster_YNDropDown('member', $member['member']), '</td></tr>';
- echo '<tr><td align="center" colspan="2"><input type="submit" value="', _MD_UPDATE, '"></td></tr>
- </table><form>';
-}
+// $totalPartners = $xpPartnerHandler->getCount();
+// $totalNonActivePartners = $xpPartnerHandler->getCount(new Criteria('status', 0, '='));
+// $totalActivePartners = $totalPartners - $totalNonActivePartners;
-function Members_List($op = 1) {
- $db =& Database::getInstance();
- $result = xRoster_Query("SELECT m.id, m.membername, m.member, t.name AS title, g.name AS xgroup, c.name AS game
- FROM {xRoster} m
- LEFT JOIN {xRoster_titles} t ON m.tid = t.id
- LEFT JOIN {xRoster_groups} g ON m.gid = g.id
- LEFT JOIN {xRoster_categories} c ON m.cid = c.id
- WHERE m.member = $op ORDER BY c.weight, g.weight, t.weight, m.membername");
- if($db->getRowsNum($result)) {
- echo '<table cellspacing="0" cellpadding="8" class="outer">';
- $last_game = '';
- $last_group = '';
- while($member = $db->fetchArray($result)) {
- if($last_game != $member['game']) {
- echo '<tr><td colspan="4"><h3>', $member['game'], '</h3></td></tr>';
- $last_game = $member['game'];
- }
- if($last_group != $member['xgroup'] || $last_game != $member['game']) {
- echo '<tr><td colspan="4"><h4>', $member['xgroup'], '</h4></td></tr>';
- echo '<tr bgcolor="#cccccc"><td> </td><td><strong>', _MD_MEMBERNAME, '</strong></td><td><strong>', _MD_MEMBERTITLE, '</strong></td><td> </td></tr>';
- $last_group = $member['xgroup'];
- }
- echo '<tr bgcolor="#eeeeee"><td><a href="?op=members_edit&action=edit&id=', $member['id'], '">', _MD_EDIT, '</a></td>
- <td>', $member['membername'], '</td>
- <td>', $member['title'], '</td>
- <td><a href="?op=members_delete&action=confirm&id=', $member['id'], '">', _MD_DELETE, '</a>
- | <a href="?op=members_approve&action=approve&id=', $member['id'], '&subaction=', $member['member'] ? '0' : '1', '">', !$member['member'] ? _MD_APPROVE : _MD_DISAPPROVE, '</a>',
- '</td></tr>';
- }
- echo '</table>';
- } else
- echo '<p align="center">', $op == 0 ? _MD_NOAPPLICANTS : _MD_NOMEMBERS, '</p>';
-}
+// $indexAdmin->addInfoBox(_MD_XPARTNERS_DASHBOARD);
-function Members_Delete($id){
- $result = xRoster_Query('DELETE FROM {xRoster} WHERE id=%u', $id);
- redirect_header('index.php?op=members_list', 1, _MD_MEMBERDELETED);
-}
+// $indexAdmin->addInfoBoxLine(_MD_XPARTNERS_DASHBOARD, "<infolabel>" ._MD_XPARTNERS_TOTALACTIVE. "</infolabel>", $totalActivePartners, 'Green');
+// $indexAdmin->addInfoBoxLine(_MD_XPARTNERS_DASHBOARD, "<infolabel>" ._MD_XPARTNERS_TOTALNONACTIVE. "</infolabel>", $totalNonActivePartners, 'Red');
+// $indexAdmin->addInfoBoxLine(_MD_XPARTNERS_DASHBOARD, "<infolabel>" ._MD_XPARTNERS_TOTALPARTNERS. "</infolabel><infotext>", $totalPartners."</infotext>");
+//----------------------------
-function Members_Approve($id, $action = 1){
- $action = (int)$action ? 1 : 0;
- $result = xRoster_Query('UPDATE {xRoster} SET member=%u, since=%u WHERE id=%u', $action, time(), $id);
- redirect_header('index.php?op=members_list', 1, _MD_MEMBERUPDATED);
-}
+echo $indexAdmin->addNavigation('index.php');
+echo $indexAdmin->renderIndex();
-function Group_Editor($g_action = '', $id = 0) {
- $db =& Database::getInstance();
- switch($g_action) {
- case 'delete':
- $result = xRoster_Query('SELECT count(*) AS c FROM {xRoster} WHERE gid=%u', $id);
- $row = $db->fetchArray($result);
- if($row['c'] == 0)
- $result = xRoster_Query('DELETE FROM {xRoster_groups} WHERE id=%u', $id);
- else
- printf('<br><br>' . _MD_CANTDELETEGROUP, $row['c']);
- redirect_header('index.php?op=Group_Editor', 1, _MD_GROUPDELETED);
- break;
- case 'insert':
- $sql = 'INSERT INTO {xRoster_groups} (name, weight) VALUES (%s, %u)';
- case 'update':
- $name = xRoster_PostVar('name');
- $weight = xRoster_PostVar('weight');
- if(!isset($sql))
- $result = xRoster_Query('UPDATE {xRoster_groups} SET name=%s, weight=%u WHERE ID=%u', $name, $weight, $id);
- else
- $result = xRoster_Query($sql, $name, $weight);
- redirect_header('index.php?op=Group_Editor', 1, _MD_GROUPUPDATED);
- break;
- case 'edit':
- $form_params = array('id'=>$id, 'g_action'=>'update', 'btn_label'=>_MD_UPDATE);
- $result = xRoster_Query('SELECT * FROM {xRoster_groups} WHERE id=%u', $id);
- if($row = $db->fetchArray($result)) {
- $name = $row['name'];
- $weight = $row['weight'];
- }
- case 'add':
- if(!isset($form_params))
- $form_params = array('id'=>0, 'g_action'=>'insert', 'btn_label'=>_MD_INSERT);
- echo '<form method="post">';
- if($form_params['id'])
- echo '<input type="hidden" name="id" value="', $form_params['id'], '">';
- echo '<input type="hidden" name="g_action" value="', $form_params['g_action'], '">
- <table cellspacing="0" cellpadding="8" class="outer">
- <tr><td>', _MD_GROUPNAME, '</td><td><input type="text" name="name" value="', $name, '"></td></tr>
- <tr><td>', _MD_WEIGHT, '</td><td><input type="text" name="weight" value="', $weight, '" size="4" maxlength="3"></td></tr>
- <tr><td> </td><td><input type="submit" value="', $form_params['btn_label'], '"></td></tr>
- </table><form>';
- break;
- default:
- $result = xRoster_Query('SELECT * FROM {xRoster_groups} ORDER BY weight, name');
- if($db->getRowsNum($result)) {
- echo '<table cellspacing="0" cellpadding="8" class="outer" bgcolor="#eeeeee">';
- while($row = $db->fetchArray($result)) {
- echo '<tr><td><a href="?op=Group_Editor&g_action=edit&id=', $row['id'], '">', _MD_EDIT, '</a></td>
- <td>', $row['name'], '</td><td>', $row['weight'], '</td>
- <td><a href="?op=Group_Editor&g_action=delete&id=', $row['id'], '">', _MD_DELETE, '</a></td></tr>';
- }
- echo '</table>';
- } else
- echo '<p align="center">', _MD_NOGROUPS, '</p>';
- break;
- }
-}
-
-function Category_Editor($c_action, $id, $name, $weight, $active = 1){
- $db =& Database::getInstance();
- switch($c_action) {
- case 'delete':
- $result = xRoster_Query('SELECT count(*) as count FROM {xRoster} WHERE cid=%u', $id);
- $row = $db->fetchArray($result);
- if($row['count'] == 0) {
- xRoster_Query('DELETE FROM {xRoster_categories} WHERE ID=%u', $id);
- redirect_header('index.php?op=Category_Editor', 1, _MD_CATEGORYDELETED);
- } else
- printf('<br><br>' . _MD_CANTDELECATEGORY, $row['count']);
- break;
- case 'update':
- $result = xRoster_Query("UPDATE {xRoster_categories} SET name=%s, weight=%u, active=%u WHERE ID=%u", $name, $weight, $active, $id);
- redirect_header("index.php?op=Category_Editor", 1, _MD_CATEGORYUPDATED);
- break;
- case 'insert':
- $result = xRoster_Query("INSERT INTO {xRoster_categories} (name, weight, active) VALUES (%s, %u, %u)", $name, $weight, $active);
- redirect_header('index.php?op=Category_Editor', 1, _MD_CATEGORYINSERTED);
- break;
- case 'add': case 'edit':
- echo '<p>
- <form method="post">
- <input type="hidden" name="c_action" value="', $c_action == 'edit' ? 'update' : 'insert', '">',
- $c_action == 'edit' ? '<input type="hidden" name="id" value="' . $id . '">' : '',
- '<table cellspacing=0 cellpadding=8 class="outer">
- <tr><td>', _MD_CATEGORYNAME, '</td><td><input type="text" name="name" value="', $name, '"></td></tr>
- <tr><td>', _MD_WEIGHT, '</td><td><input type="text" name="weight" value="', $weight, '"></td></tr>
- <tr><td>', _MD_ACTIVE, '</td><td>', xRoster_YNDropDown('active', $active), '</td></tr>
- <tr><td> </td><td><input type="submit" value="', $c_action == 'edit' ? _MD_UPDATE : _MD_INSERT, '">
- </td></tr>
- </table>
- <form>';
- break;
- default:
- $result = xRoster_Query('SELECT id, name, weight, active FROM {xRoster_categories} ORDER BY weight');
- if($db->getRowsNum($result) > 0) {
- echo '<p><table cellspacing="0" cellpadding="8" class="outer">
- <tr bgcolor="#cccccc"><td> </td><td>', _MD_CATEGORYNAME, '</td><td>', _MD_WEIGHT, '</td><td>', _MD_ACTIVE, '</td><td> </td></tr>';
- while($row = $db->fetchArray($result)) {
- echo '<tr bgcolor="#eeeeee">
- <td><a href="?op=Category_Editor&c_action=edit&id=', $row['id'], '&name=', $row['name'], '&weight=', $row['weight'], '&active=', $row['active'], '">', _MD_EDIT, '</a></td>
- <td>', $row['name'], '</td><td>', $row['weight'], '</td>
- <td>', $row['active'] ? _YES : _NO, '</td>
- <td><a href="?op=Category_Editor&c_action=delete&id=', $row['id'], '">', _MD_DELETE, '</a></td></tr>';
- }
- echo '</table>';
- } else
- echo '<p align="center">', _MD_NOCATEGORIES, '</p>';
- break;
- }
-}
-
-/******************************************************************************/
-/******************************************************************************/
-/******************************************************************************/
-
-function Title_Editor($t_action, $id, $name, $weight){
- $db =& Database::getInstance();
- switch($t_action){
- case "delete":
- $result = xRoster_Query('SELECT count(*) as count FROM {xRoster} WHERE tid=%u', $id);
- $row = $db->fetchArray($result);
- if($row['count'] == 0)
- xRoster_Query('DELETE FROM {xRoster_titles} WHERE ID=%u', $id);
- else
- printf('<br><br>' . _MD_CANTDELETETITLE, $row['count']);
- redirect_header('index.php?op=Title_Editor', 1, _MD_TITLEDELETED);
- break;
- case "update":
- $sql = "UPDATE " . $db->prefix("xRoster_titles") . " SET name='$name',weight=$weight WHERE ID=$id";
- if ( !$result = $db->query($sql) ) {
- exit("Error in admin/index.php :: Title_Editor($t_action,$id,$name,$weight)");
- }
- redirect_header("index.php?op=Title_Editor", 1, _MD_TITLEUPDATED);
- break;
- case "insert":
- $sql = "INSERT INTO " . $db->prefix("xRoster_titles") . " (name,weight) VALUES ('$name',$weight)";
- if ( !$result = $db->query($sql) ) {
- exit("Error in admin/index.php :: Title_Editor($t_action,$id,$name,$weight)");
- }
- redirect_header("index.php?op=Title_Editor", 1, _MD_TITLEINSERTED);
- break;
- case "add":
- echo("<p>");
- echo("<form method=post>");
- echo("<input type=\"hidden\" name=\"t_action\" value=\"insert\">");
- echo("<table cellspacing=0 cellpadding=8 class=\"outer\">");
- echo("<tr><td>"._MD_TITLENAME."</td><td><input type=\"text\" name=\"name\" value=\"".$name."\"></td></tr>");
- echo("<tr><td>"._MD_WEIGHT."</td><td><input type=\"text\" name=\"weight\" value=\"".$weight."\"></td></tr>");
- echo("<tr><td> </td><td><input type=\"submit\" value=\""._MD_INSERT."\"></td></tr>");
- echo("</table>");
- echo("<form>");
- break;
- case "edit":
- echo("<p>");
- echo("<form method=post>");
- echo("<input type=\"hidden\" name=\"id\" value=\"$id\">");
- echo("<input type=\"hidden\" name=\"t_action\" value=\"update\">");
- echo("<table cellspacing=0 cellpadding=8 class=\"outer\">");
- echo("<tr><td>"._MD_TITLENAME."</td><td><input type=\"text\" name=\"name\" value=\"".$name."\"></td></tr>");
- echo("<tr><td>"._MD_WEIGHT."</td><td><input type=\"text\" name=\"weight\" value=\"".$weight."\"></td></tr>");
- echo("<tr><td> </td><td><input type=\"submit\" value=\""._MD_UPDATE."\"></td></tr>");
- echo("</table>");
- echo("<form>");
- break;
- case 'default':
- xRoster_Query('UPDATE {xRoster_titles} SET isdefault=0 WHERE ID<>%u', $id);
- xRoster_Query('UPDATE {xRoster_titles} SET isdefault=1 WHERE ID=%u', $id);
- redirect_header('index.php?op=Title_Editor', 1, _MD_TITLEUPDATED);
- break;
- default:
- $result = xRoster_Query('SELECT id, name, weight FROM {xRoster_titles} ORDER BY weight');
- $titles = $titles_assoc = array();
- while($row = $db->fetchArray($result)) {
- $titles[] = $row;
- $titles_assoc[$row['id']] = $row['name'];
- }
- if(count($titles) > 0){
- echo("<p><table cellspacing=0 cellpadding=8 class=\"outer\">");
- echo("<tr bgcolor=\"#cccccc\"><td> </td><td>"._MD_TITLENAME."</td><td>"._MD_WEIGHT."</td><td> </td></tr>");
- for($j=0;$j<count($titles);$j++){
- echo("<tr bgcolor=\"#eeeeee\">");
- echo("<td><a href=\"?op=Title_Editor&t_action=edit&id=".$titles[$j]['id']."&name=".$titles[$j]['name']."&weight=".$titles[$j]['weight']."\">"._MD_EDIT."</a></td>");
- echo("<td>".$titles[$j]['name']."</td>");
- echo("<td>".$titles[$j]['weight']."</td>");
- echo("<td><a href=\"?op=Title_Editor&t_action=delete&id=".$titles[$j]['id']."\">"._MD_DELETE."</a></td>");
- echo("</tr>");
- }
- echo("</table>");
- // Default title
- echo '<form method="post"><input type="hidden" name="t_action" value="default">',
- _MD_DEFAULTTITLE, ':', xRoster_DropDown('id', $titles_assoc, xRoster_DefaultTitle(), true, null),
- ' <input type="submit" value=">>"></form>';
- } else {
- echo("<p align=\"center\">"._MD_NOTITLES."</p>");
- }
- break;
- }
-}
-
-/**************************************
- * Main - Admin SwitchBox
- *************************************/
-
-if(!ini_get('register_globals')) { // hotfix for register_globals=off
- extract($_GET);
- extract($_POST);
-}
-
-xRoster_AdminHeader();
-
-$op = isset($_POST['op']) ? $_POST['op'] : (isset($_GET['op']) ? $_GET['op'] : 'xRosterConfig');
-switch($op) {
- case 'Title_Editor': Title_Editor($t_action, $id, $name, $weight); break;
- case 'Category_Editor':
- Category_Editor($c_action, $id, $name, $weight, !isset($_REQUEST['active']) || (bool)$_REQUEST['active'] ? 1 : 0);
- break;
- case 'Group_Editor':
- $g_action = isset($_REQUEST['g_action']) ? $_REQUEST['g_action'] : '';
- $id = isset($_REQUEST['id']) ? (int)$_REQUEST['id'] : 0;
- Group_Editor($g_action, $id);
- break;
- case 'members_approve':
- if(@$_GET['action']=='approve' && (int)@$_GET['id'])
- Members_Approve($_GET['id'], isset($_GET['subaction']) ? (int)$_GET['subaction'] : 1);
- else
- Members_List(0);
- break;
- case 'members_list': Members_List(1); break;
- case 'members_add': $id = 0;
- case 'members_edit': Members_Edit($id); break;
- case 'members_update':
- $realname = xRoster_PostVar('realname');
- $membername = xRoster_PostVar('membername');
- $email = xRoster_PostVar('email');
- $age = (int)xRoster_PostVar('age');
- $gid = (int)xRoster_PostVar('gid');
- $cid = (int)xRoster_PostVar('cid');
- $location = xRoster_PostVar('location');
- $connection = xRoster_PostVar('connection');
- $ahours = xRoster_PostVar('ahours');
- $pweapon = xRoster_PostVar('pweapon');
- $sweapon = xRoster_PostVar('sweapon');
- $clan_before = (int)xRoster_PostVar('clan_before');
- $why_play = xRoster_PostVar('why_play');
- $skills_talents = xRoster_PostVar('skills_talents');
- $additional_comments = xRoster_PostVar('additional_comments');
- $tid = (int)xRoster_PostVar('tid');
- $picture = xRoster_PostVar('picture');
- $sitename = xRoster_PostVar('sitename');
- $siteurl = xRoster_PostVar('siteurl');
- $impref = xRoster_PostVar('impref');
- $imid = xRoster_PostVar('imid');
- $additional_info = xRoster_PostVar('additional_info');
- $member = (int)xRoster_PostVar('member', 0);
- $id = (int)xRoster_PostVar('id', 0);
- if($id) {
- //Todo: when I update, if the user was member=0, and it's approved (member=1), I should update the "since" field to time()
- $result = xRoster_Query('UPDATE {xRoster} SET realname=%s, membername=%s, email=%s, age=%d, gid=%d, cid=%d, location=%s, connection=%s, ahours=%s, pweapon=%s,
- sweapon=%s, clan_before=%d, why_play=%s, skills_talents=%s, additional_comments=%s, tid=%d, picture=%s, sitename=%s, siteurl=%s, impref=%s, imid=%s, additional_info=%s, member=%d WHERE id = %d',
- $realname, $membername, $email, $age, $gid, $cid, $location, $connection, $ahours, $pweapon, $sweapon, $clan_before, $why_play, $skills_talents, $additional_comments, $tid, $picture, $sitename, $siteurl, $impref, $imid, $additional_info, $member, $id);
- redirect_header($member ? 'index.php?op=members_list' : 'index.php?op=members_approve', 1, _MD_MEMBERUPDATED);
- } else {
- $result = xRoster_Query('INSERT INTO {xRoster}
- (realname, membername, email, age, gid, cid, location, connection, ahours, pweapon, sweapon, clan_before, why_play, skills_talents, additional_comments, tid, picture, sitename, siteurl, impref, imid, additional_info, member, since)
- VALUES (%s, %s, %s, %d, %d, %d, %s, %s, %s, %s, %s, %d, %s, %s, %s, %d, %s, %s, %s, %s, %s, %s, %d, %d)',
- $realname, $membername, $email, $age, $gid, $cid, $location, $connection, $ahours, $pweapon, $sweapon, $clan_before, $why_play, $skills_talents, $additional_comments, $tid, $picture, $sitename, $siteurl, $impref, $imid, $additional_info, $member, time());
- redirect_header('index.php?op=members_list', 1, _MD_MEMBERADDED);
- }
- break;
- case 'members_delete': Members_Delete($id); break;
- case 'ConfigUpdate': ConfigUpdate(); break;
-}
-
-xoops_cp_footer();
-
-?>
\ No newline at end of file
+include 'admin_footer.php';
+//xoops_cp_footer();
\ No newline at end of file
Added: XoopsModules/xroster/trunk/xroster/admin/main.php
===================================================================
--- XoopsModules/xroster/trunk/xroster/admin/main.php (rev 0)
+++ XoopsModules/xroster/trunk/xroster/admin/main.php 2012-03-14 10:17:18 UTC (rev 9129)
@@ -0,0 +1,431 @@
+<?php
+
+$xRoster_mydir = dirname(__FILE__);
+require_once "$xRoster_mydir/../../../include/cp_header.php";
+require_once file_exists("$xRoster_mydir/../language/" . $xoopsConfig['language'] . '/main.php')
+ ? "$xRoster_mydir/../language/" . $xoopsConfig['language'] . '/main.php'
+ : "$xRoster_mydir/../language/english/main.php";
+require_once "$xRoster_mydir/../common.inc.php";
+include_once 'admin_header.php';
+$indexAdmin = new ModuleAdmin();
+
+
+function Members_Edit($id = 0) {
+ global $xoopsDB, $xRosterList_connspeed, $xRosterList_ahour, $xRosterList_weapon, $xRosterList_imnetworks, $indexAdmin;
+ if($id) {
+
+ $result = xRoster_Query("SELECT * FROM {xRoster} WHERE id = $id");
+ if(!($member = $xoopsDB->fetchArray($result))) return false;
+ $member['since'] = formatTimestamp($member['since'], 's');
+ } else{
+ $member = array('member' => 1, 'since' => formatTimestamp(time(), 's'));
+ echo $indexAdmin->addNavigation('main.php?op=members_add');
+ }
+ $result = xRoster_Query('SELECT id, name FROM {xRoster_titles} ORDER BY weight, name');
+ while($row = $xoopsDB->fetchArray($result))
+ $titles[$row['id']] = $row['name'];
+ // Here comes the form
+ echo '<form method="post">
+ <input type="hidden" name="id" value="' . $id . '">
+ <input type="hidden" name="op" value="members_update">
+ <table cellspacing="8" cellpadding="8" class="outer">';
+ echo '<tr><td>', _MD_REALNAME, '</td><td><input type="text" name="realname" value="', $member['realname'], '"></td></tr>';
+ echo '<tr><td>', _MD_NAME, '</td><td><input type="text" name="membername" value="', $member['membername'], '"></td></tr>';
+ echo '<tr><td>', _MD_EMAIL, '</td><td><input type="text" name="email" value="', $member['email'], '"></td></tr>';
+ echo '<tr><td>', _MD_AGE, '</td><td><input type="text" name="age" value="', $member['age'], '"></td></tr>';
+ echo '<tr><td>', _MD_CATEGORY, '</td><td>', xRoster_SQLDropDown('SELECT id, name FROM {xRoster_categories} ORDER BY weight, name', 'cid', $member['cid']), '</td></tr>';
+ echo '<tr><td>', _MD_GROUP, '</td><td>', xRoster_SQLDropDown('SELECT id, name FROM {xRoster_groups} ORDER BY weight, name', 'gid', $member['gid']), '</td></tr>';
+ echo '<tr><td>', _MD_LOCATION, '</td><td>', xRoster_LocationDropDown($member['location'] ? $member['location'] : 'US'), '</td></tr>';
+ echo '<tr><td>', _MD_CONNECTION, '</td><td>', xRoster_DropDown('connection', $xRosterList_connspeed + array(_MD_OTHER=>_MD_OTHER), $member['connection']), '</td></tr>';
+ echo '<tr><td>', _MD_AVAILABLEHOURS, '</td><td>', xRoster_DropDown('ahours', $xRosterList_ahour + array(_MD_TOOMANYHOURS=>_MD_TOOMANYHOURS), $member['ahours']), '</td></tr>';
+ echo '<tr><td>', _MD_PRIMARYWEAPON, '</td><td>', xRoster_DropDown('pweapon', $xRosterList_weapon, $member['pweapon']), '</td></tr>';
+ echo '<tr><td>', _MD_SECONDARYWEAPON, '</td><td>', xRoster_DropDown('sweapon', $xRosterList_weapon, $member['sweapon']), '</td></tr>';
+ echo '<tr><td colspan="2">', _MD_CLANBEFORE, ' ', xRoster_YNDropDown('clan_before', $member['clan_before']), '</td></tr>';
+ echo '<tr><td colspan="2">', _MD_NOTE3, '<br><textarea rows="3" name="why_play">', $member['why_play'], '</textarea></td></tr>';
+ echo '<tr><td colspan="2">', _MD_NOTE4, '<br><textarea rows="3" name="skills_talents">', $member['skills_talents'], '</textarea></td></tr>';
+ echo '<tr><td colspan="2">', _MD_NOTE1, '<br><textarea rows="3" name="additional_comments">', $member['additional_comments'], '</textarea></td></tr>';
+ echo '<tr><td>', _MD_TITLE, '</td><td>', xRoster_DropDown('tid', $titles, $member['tid'], true), '</td></tr>';
+ echo '<tr><td>', _MD_IMAGEPATH, '</td><td><input type="text" name="picture" value="', $member['picture'], '"></td></tr>';
+ echo '<tr><td>', _MD_WEBSITENAME, '</td><td><input type="text" name="sitename" value="', $member['sitename'], '"></td></tr>';
+ echo '<tr><td>', _MD_WEBSITEURL, '</td><td><input type="text" name="siteurl" value="', $member['siteurl'], '"></td></tr>';
+ echo '<tr><td>', _MD_IMNETWORK, '</td><td>', xRoster_DropDown('impref', $xRosterList_imnetworks, $member['impref']), '</td></tr>';
+ echo '<tr><td>', _MD_IMID, '</td><td><input type="text" name="imid" value="', $member['imid'], '"></td></tr>';
+ echo '<tr><td colspan="2">', _MD_NOTE5, '<br><textarea rows="3" name="additional_info">', $member['additional_info'], '</textarea></td></tr>';
+ echo '<tr><td>', _MD_SINCE, '</td><td>', $member['since'], '</td></tr>';
+ echo '<tr><td colspan="2">', _MD_APPROVED, ' ', xRoster_YNDropDown('member', $member['member']), '</td></tr>';
+ echo '<tr><td align="center" colspan="2"><input type="submit" value="', _MD_UPDATE, '"></td></tr>
+ </table><form>';
+}
+
+function Members_List($op = 1) {
+ global $pathIcon16, $indexAdmin;
+ $db =& XoopsDatabaseFactory::getDatabaseConnection();
+ echo $indexAdmin->addNavigation('main.php?op=members_list');
+ $result = xRoster_Query("SELECT m.id, m.membername, m.member, t.name AS title, g.name AS xgroup, c.name AS game
+ FROM {xRoster} m
+ LEFT JOIN {xRoster_titles} t ON m.tid = t.id
+ LEFT JOIN {xRoster_groups} g ON m.gid = g.id
+ LEFT JOIN {xRoster_categories} c ON m.cid = c.id
+ WHERE m.member = $op ORDER BY c.weight, g.weight, t.weight, m.membername");
+ if($db->getRowsNum($result)) {
+ echo '<table cellspacing="0" cellpadding="8" class="outer">';
+ $last_game = '';
+ $last_group = '';
+ while($member = $db->fetchArray($result)) {
+ if($last_game != $member['game']) {
+ echo '<tr><td colspan="4"><h3>', $member['game'], '</h3></td></tr>';
+ $last_game = $member['game'];
+ }
+ if($last_group != $member['xgroup'] || $last_game != $member['game']) {
+ echo '<tr><td colspan="4"><h4>', $member['xgroup'], '</h4></td></tr>';
+ echo '<tr bgcolor="#cccccc"><td><strong>', _MD_MEMBERNAME, '</strong></td><td><strong>', _MD_MEMBERTITLE, '</strong></td><td>', _MD_ACTIONS, '</td></tr>';
+ $last_group = $member['xgroup'];
+ }
+ echo '<tr bgcolor="#eeeeee">
+ <td>', $member['membername'], '</td>
+ <td>', $member['title'], '</td>
+<td><a href="?op=members_edit&action=edit&id=', $member['id'], '">', '<img src='. $pathIcon16 .'/edit.png' . ' alt=' . _EDIT . ' title=' . _EDIT . ' />', '</a> <a href="?op=members_delete&action=confirm&id=', $member['id'], '">', '<img src='. $pathIcon16 .'/delete.png' . ' alt=' . _DELETE . ' title=' . _DELETE . ' />','</a>
+ <a href="?op=members_approve&action=approve&id=', $member['id'], '&subaction=', $member['member'] ? '0' : '1', '">', !$member['member'] ? '<img src='. $pathIcon16 .'/on.png' . ' alt=' . _MD_APPROVE . ' title=' . _MD_APPROVE . ' />' : '<img src='. $pathIcon16 .'/off.png' . ' alt=' . _MD_DISAPPROVE . ' title=' . _MD_DISAPPROVE . ' />', '</a>',
+ '</td></tr>';
+ }
+ echo '</table>';
+ } else
+ echo '<p align="center">', $op == 0 ? _MD_NOAPPLICANTS : _MD_NOMEMBERS, '</p>';
+}
+
+function Members_Delete($id){
+ $result = xRoster_Query('DELETE FROM {xRoster} WHERE id=%u', $id);
+ redirect_header('main.php?op=members_list', 1, _MD_MEMBERDELETED);
+}
+
+function Members_Approve($id, $action = 1){
+ global $indexAdmin;
+ echo $indexAdmin->addNavigation('main.php?op=members_approve');
+ $action = (int)$action ? 1 : 0;
+ $result = xRoster_Query('UPDATE {xRoster} SET member=%u, since=%u WHERE id=%u', $action, time(), $id);
+ redirect_header('main.php?op=members_list', 1, _MD_MEMBERUPDATED);
+}
+
+function Group_Editor($g_action = '', $id = 0) {
+ global $pathIcon16, $indexAdmin;
+ echo $indexAdmin->addNavigation('main.php?op=Group_Editor');
+ $indexAdmin->addItemButton(_MD_ADDGROUP, 'main.php?op=Group_Editor&g_action=add', 'add');
+ echo $indexAdmin->renderButton('right', '');
+
+ $db =& XoopsDatabaseFactory::getDatabaseConnection();
+ switch($g_action) {
+ case 'delete':
+ $result = xRoster_Query('SELECT count(*) AS c FROM {xRoster} WHERE gid=%u', $id);
+ $row = $db->fetchArray($result);
+ if($row['c'] == 0)
+ $result = xRoster_Query('DELETE FROM {xRoster_groups} WHERE id=%u', $id);
+ else
+ printf('<br><br>' . _MD_CANTDELETEGROUP, $row['c']);
+ redirect_header('main.php?op=Group_Editor', 1, _MD_GROUPDELETED);
+ break;
+ case 'insert':
+ $sql = 'INSERT INTO {xRoster_groups} (name, weight) VALUES (%s, %u)';
+ case 'update':
+ $name = xRoster_PostVar('name');
+ $weight = xRoster_PostVar('weight');
+ if(!isset($sql))
+ $result = xRoster_Query('UPDATE {xRoster_groups} SET name=%s, weight=%u WHERE ID=%u', $name, $weight, $id);
+ else
+ $result = xRoster_Query($sql, $name, $weight);
+ redirect_header('main.php?op=Group_Editor', 1, _MD_GROUPUPDATED);
+ break;
+ case 'edit':
+ $form_params = array('id'=>$id, 'g_action'=>'update', 'btn_label'=>_MD_UPDATE);
+ $result = xRoster_Query('SELECT * FROM {xRoster_groups} WHERE id=%u', $id);
+ if($row = $db->fetchArray($result)) {
+ $name = $row['name'];
+ $weight = $row['weight'];
+ }
+ case 'add':
+ if(!isset($form_params))
+ $form_params = array('id'=>0, 'g_action'=>'insert', 'btn_label'=>_MD_INSERT);
+ echo '<form method="post">';
+ if($form_params['id'])
+ echo '<input type="hidden" name="id" value="', $form_params['id'], '">';
+ echo '<input type="hidden" name="g_action" value="', $form_params['g_action'], '">
+ <table cellspacing="0" cellpadding="8" class="outer">
+ <tr><td>', _MD_GROUPNAME, '</td><td><input type="text" name="name" value="', $name, '"></td></tr>
+ <tr><td>', _MD_WEIGHT, '</td><td><input type="text" name="weight" value="', $weight, '" size="4" maxlength="3"></td></tr>
+ <tr><td> </td><td><input type="submit" value="', $form_params['btn_label'], '"></td></tr>
+ </table><form>';
+ break;
+ default:
+ $result = xRoster_Query('SELECT * FROM {xRoster_groups} ORDER BY weight, name');
+ if($db->getRowsNum($result)) {
+ //echo '<table cellspacing="0" cellpadding="8" class="outer" bgcolor="#eeeeee">';
+ echo '<p><table cellspacing="0" cellpadding="8" class="outer">
+ <tr bgcolor="#cccccc"><td>', _MD_GROUPNAME, '</td><td>', _MD_WEIGHT, '</td><td>', _MD_ACTIONS, '</td></tr>';
+ while($row = $db->fetchArray($result)) {
+ echo '<tr>
+ <td>', $row['name'], '</td><td>', $row['weight'], '</td>
+ <td><a href="?op=Group_Editor&g_action=edit&id=', $row['id'], '">', '<img src='. $pathIcon16 .'/edit.png' . ' alt=' . _EDIT . ' title=' . _EDIT . ' />', '</a>
+ <a href="?op=Group_Editor&g_action=delete&id=', $row['id'], '">', '<img src='. $pathIcon16 .'/delete.png' . ' alt=' . _DELETE . ' title=' . _DELETE . ' />', '</a></td></tr>';
+ }
+ echo '</table>';
+ } else
+ echo '<p align="center">', _MD_NOGROUPS, '</p>';
+ break;
+ }
+}
+
+function Category_Editor($c_action, $id, $name, $weight, $active = 1){
+ global $pathIcon16, $indexAdmin;
+ echo $indexAdmin->addNavigation('main.php?op=Category_Editor');
+ $indexAdmin->addItemButton(_MD_ADDCATEGORY, 'main.php?op=Category_Editor&c_action=add', 'add');
+ echo $indexAdmin->renderButton('right', '');
+ $db =& XoopsDatabaseFactory::getDatabaseConnection();
+ switch($c_action) {
+ case 'delete':
+ $result = xRoster_Query('SELECT count(*) as count FROM {xRoster} WHERE cid=%u', $id);
+ $row = $db->fetchArray($result);
+ if($row['count'] == 0) {
+ xRoster_Query('DELETE FROM {xRoster_categories} WHERE ID=%u', $id);
+ redirect_header('main.php?op=Category_Editor', 1, _MD_CATEGORYDELETED);
+ } else
+ printf('<br><br>' . _MD_CANTDELECATEGORY, $row['count']);
+ break;
+ case 'update':
+ $result = xRoster_Query("UPDATE {xRoster_categories} SET name=%s, weight=%u, active=%u WHERE ID=%u", $name, $weight, $active, $id);
+ redirect_header("main.php?op=Category_Editor", 1, _MD_CATEGORYUPDATED);
+ break;
+ case 'insert':
+ $result = xRoster_Query("INSERT INTO {xRoster_categories} (name, weight, active) VALUES (%s, %u, %u)", $name, $weight, $active);
+ redirect_header('main.php?op=Category_Editor', 1, _MD_CATEGORYINSERTED);
+ break;
+ case 'add': case 'edit':
+ echo '<p>
+ <form method="post">
+ <input type="hidden" name="c_action" value="', $c_action == 'edit' ? 'update' : 'insert', '">',
+ $c_action == 'edit' ? '<input type="hidden" name="id" value="' . $id . '">' : '',
+ '<table cellspacing=0 cellpadding=8 class="outer">
+ <tr><td>', _MD_CATEGORYNAME, '</td><td><input type="text" name="name" value="', $name, '"></td></tr>
+ <tr><td>', _MD_WEIGHT, '</td><td><input type="text" name="weight" value="', $weight, '"></td></tr>
+ <tr><td>', _MD_ACTIVE, '</td><td>', xRoster_YNDropDown('active', $active), '</td></tr>
+ <tr><td> </td><td><input type="submit" value="', $c_action == 'edit' ? _MD_UPDATE : _MD_INSERT, '">
+ </td></tr>
+ </table>
+ <form>';
+ break;
+ default:
+ $result = xRoster_Query('SELECT id, name, weight, active FROM {xRoster_categories} ORDER BY weight');
+ if($db->getRowsNum($result) > 0) {
+ echo '<p><table cellspacing="0" cellpadding="8" class="outer">
+ <tr bgcolor="#cccccc"><td>', _MD_CATEGORYNAME, '</td><td>', _MD_WEIGHT, '</td><td>', _MD_ACTIVE, '</td><td>', _MD_ACTIONS, '</td></tr>';
+ while($row = $db->fetchArray($result)) {
+ echo '<tr bgcolor="#eeeeee">
+
+ <td>', $row['name'], '</td><td>', $row['weight'], '</td>
+ <td>', $row['active'] ? _YES : _NO, '</td>
+ <td><a href="?op=Category_Editor&c_action=edit&id=', $row['id'], '&name=', $row['name'], '&weight=', $row['weight'], '&active=', $row['active'], '">', '<img src='. $pathIcon16 .'/edit.png' . ' alt=' . _EDIT . ' title=' . _EDIT . ' />', '</a> <a href="?op=Category_Editor&c_action=delete&id=', $row['id'], '">', '<img src='. $pathIcon16 .'/delete.png' . ' alt=' . _DELETE . ' title=' . _DELETE . ' />', '</a></td></tr>';
+ }
+ echo '</table>';
+ } else
+ echo '<p align="center">', _MD_NOCATEGORIES, '</p>';
+ break;
+ }
+}
+
+/******************************************************************************/
+/******************************************************************************/
+/******************************************************************************/
+
+function Title_Editor($t_action, $id, $name, $weight){
+ global $pathIcon16, $indexAdmin;
+ $db =& XoopsDatabaseFactory::getDatabaseConnection();
+ echo $indexAdmin->addNavigation('main.php?op=Title_Editor');
+ $db =& XoopsDatabaseFactory::getDatabaseConnection();
+$indexAdmin->addItemButton(_MD_ADDTITLE, 'main.php?op=Title_Editor&t_action=add', 'add');
+echo $indexAdmin->renderButton('right', '');
+
+ echo $t_action;
+
+ switch($t_action){
+ case "delete":
+ $result = xRoster_Query('SELECT count(*) as count FROM {xRoster} WHERE tid=%u', $id);
+ $row = $db->fetchArray($result);
+ if($row['count'] == 0)
+ xRoster_Query('DELETE FROM {xRoster_titles} WHERE ID=%u', $id);
+ else
+ printf('<br><br>' . _MD_CANTDELETETITLE, $row['count']);
+ redirect_header('main.php?op=Title_Editor', 1, _MD_TITLEDELETED);
+ break;
+ case "update":
+ $sql = "UPDATE " . $db->prefix("xRoster_titles") . " SET name='$name',weight=$weight WHERE ID=$id";
+ if ( !$result = $db->query($sql) ) {
+ exit("Error in admin/main.php :: Title_Editor($t_action,$id,$name,$weight)");
+ }
+ redirect_header("main.php?op=Title_Editor", 1, _MD_TITLEUPDATED);
+ break;
+ case "insert":
+ $sql = "INSERT INTO " . $db->prefix("xRoster_titles") . " (name,weight) VALUES ('$name',$weight)";
+ if ( !$result = $db->query($sql) ) {
+ exit("Error in admin/main.php :: Title_Editor($t_action,$id,$name,$weight)");
+ }
+ redirect_header("main.php?op=Title_Editor", 1, _MD_TITLEINSERTED);
+ break;
+ case "add":
+// echo("<p>");
+// echo("<form method=post>");
+// echo("<input type=\"hidden\" name=\"t_action\" value=\"insert\">");
+// echo("<table cellspacing=0 cellpadding=8 class=\"outer\">");
+// echo("<tr><td>"._MD_TITLENAME."</td><td><input type=\"text\" name=\"name\" value=\"".$name."\"></td></tr>");
+// echo("<tr><td>"._MD_WEIGHT."</td><td><input type=\"text\" name=\"weight\" value=\"".$weight."\"></td></tr>");
+// echo("<tr><td> </td><td><input type=\"submit\" value=\""._MD_INSERT."\"></td></tr>");
+// echo("</table>");
+// echo("<form>");
+// break;
+echo 'ADDDDDDDD';
+ if(!isset($form_params))
+ $form_params = array('id'=>0, 't_action'=>'insert', 'btn_label'=>_MD_INSERT);
+ echo '<form method="post">';
+ if($form_params['id'])
+ echo '<input type="hidden" name="id" value="', $form_params['id'], '">';
+// echo("<input type=\"hidden\" name=\"t_action\" value=\"insert\">");
+ echo("<table cellspacing=0 cellpadding=8 class=\"outer\">");
+ echo("<tr><td>"._MD_TITLENAME."</td><td><input type=\"text\" name=\"name\" value=\"".$name."\"></td></tr>");
+ echo("<tr><td>"._MD_WEIGHT."</td><td><input type=\"text\" name=\"weight\" value=\"".$weight."\"></td></tr>");
+ echo("<tr><td> </td><td><input type=\"submit\" value=\""._MD_INSERT."\"></td></tr>");
+ echo("</table>");
+ echo("<form>");
+ break;
+
+
+
+
+
+
+
+
+
+ case "edit":
+ echo("<p>");
+ echo("<form method=post>");
+ echo("<input type=\"hidden\" name=\"id\" value=\"$id\">");
+ echo("<input type=\"hidden\" name=\"t_action\" value=\"update\">");
+ echo("<table cellspacing=0 cellpadding=8 class=\"outer\">");
+ echo("<tr><td>"._MD_TITLENAME."</td><td><input type=\"text\" name=\"name\" value=\"".$name."\"></td></tr>");
+ echo("<tr><td>"._MD_WEIGHT."</td><td><input type=\"text\" name=\"weight\" value=\"".$weight."\"></td></tr>");
+ echo("<tr><td> </td><td><input type=\"submit\" value=\""._MD_UPDATE."\"></td></tr>");
+ echo("</table>");
+ echo("<form>");
+ break;
+ case 'default':
+ xRoster_Query('UPDATE {xRoster_titles} SET isdefault=0 WHERE ID<>%u', $id);
+ xRoster_Query('UPDATE {xRoster_titles} SET isdefault=1 WHERE ID=%u', $id);
+ redirect_header('main.php?op=Title_Editor', 1, _MD_TITLEUPDATED);
+ break;
+ default:
+ $result = xRoster_Query('SELECT id, name, weight FROM {xRoster_titles} ORDER BY weight');
+ $titles = $titles_assoc = array();
+ while($row = $db->fetchArray($result)) {
+ $titles[] = $row;
+ $titles_assoc[$row['id']] = $row['name'];
+ }
+ if(count($titles) > 0){
+ echo("<p><table cellspacing=0 cellpadding=8 class=\"outer\">");
+ echo("<tr bgcolor=\"#cccccc\"><td>"._MD_TITLENAME."</td><td>"._MD_WEIGHT."</td><td>"._MD_ACTIONS."</td></tr>");
+ for($j=0;$j<count($titles);$j++){
+ echo("<tr bgcolor=\"#eeeeee\">");
+ echo("<td>".$titles[$j]['name']."</td>");
+ echo("<td>".$titles[$j]['weight']."</td>");
+ echo("<td><a href=\"?op=Title_Editor&t_action=edit&id=".$titles[$j]['id']."&name=".$titles[$j]['name']."&weight=".$titles[$j]['weight']."\">".'<img src='. $pathIcon16 .'/edit.png' . ' alt=' . _EDIT . ' title=' . _EDIT . ' />'."</a>");
+ echo("<a href=\"?op=Title_Editor&t_action=delete&id=".$titles[$j]['id']."\">".'<img src='. $pathIcon16 .'/delete.png' . ' alt=' . _DELETE . ' title=' . _DELETE . ' />'."</a></td>");
+ echo("</tr>");
+ }
+ echo("</table>");
+ // Default title
+ echo '<form method="post"><input type="hidden" name="t_action" value="default">',
+ _MD_DEFAULTTITLE, ':', xRoster_DropDown('id', $titles_assoc, xRoster_DefaultTitle(), true, null),
+ ' <input type="submit" value=">>"></form>';
+ } else {
+ echo("<p align=\"center\">"._MD_NOTITLES."</p>");
+ }
+ break;
+ }
+}
+
+/**************************************
+ * Main - Admin SwitchBox
+ *************************************/
+
+if(!ini_get('register_globals')) { // hotfix for register_globals=off
+ extract($_GET);
+ extract($_POST);
+}
+
+//xRoster_AdminHeader();
+
+//global $xoopsModule;
+xoops_cp_header();
+
+
+$op = isset($_POST['op']) ? $_POST['op'] : (isset($_GET['op']) ? $_GET['op'] : 'xRosterConfig');
+switch($op) {
+ case 'Title_Editor': Title_Editor($t_action='', $id=0, $name='', $weight=0); break;
+ case 'Category_Editor':
+ Category_Editor($c_action='', $id=0, $name='', $weight=0, !isset($_REQUEST['active']) || (bool)$_REQUEST['active'] ? 1 : 0);
+ break;
+ case 'Group_Editor':
+ $g_action = isset($_REQUEST['g_action']) ? $_REQUEST['g_action'] : '';
+ $id = isset($_REQUEST['id']) ? (int)$_REQUEST['id'] : 0;
+ Group_Editor($g_action, $id);
+ break;
+ case 'members_approve':
+ if(@$_GET['action']=='approve' && (int)@$_GET['id'])
+ Members_Approve($_GET['id'], isset($_GET['subaction']) ? (int)$_GET['subaction'] : 1);
+ else
+ Members_List(0);
+ break;
+ case 'members_list': Members_List(1); break;
+ case 'members_add': $id = 0;
+ case 'members_edit': Members_Edit($id); break;
+ case 'members_update':
+ $realname = xRoster_PostVar('realname');
+ $membername = xRoster_PostVar('membername');
+ $email = xRoster_PostVar('email');
+ $age = (int)xRoster_PostVar('age');
+ $gid = (int)xRoster_PostVar('gid');
+ $cid = (int)xRoster_PostVar('cid');
+ $location = xRoster_PostVar('location');
+ $connection = xRoster_PostVar('connection');
+ $ahours = xRoster_PostVar('ahours');
+ $pweapon = xRoster_PostVar('pweapon');
+ $sweapon = xRoster_PostVar('sweapon');
+ $clan_before = (int)xRoster_PostVar('clan_before');
+ $why_play = xRoster_PostVar('why_play');
+ $skills_talents = xRoster_PostVar('skills_talents');
+ $additional_comments = xRoster_PostVar('additional_comments');
+ $tid = (int)xRoster_PostVar('tid');
+ $picture = xRoster_PostVar('picture');
+ $sitename = xRoster_PostVar('sitename');
+ $siteurl = xRoster_PostVar('siteurl');
+ $impref = xRoster_PostVar('impref');
+ $imid = xRoster_PostVar('imid');
+ $additional_info = xRoster_PostVar('additional_info');
+ $member = (int)xRoster_PostVar('member', 0);
+ $id = (int)xRoster_PostVar('id', 0);
+ if($id) {
+ //Todo: when I update, if the user was member=0, and it's approved (member=1), I should update the "since" field to time()
+ $result = xRoster_Query('UPDATE {xRoster} SET realname=%s, membername=%s, email=%s, age=%d, gid=%d, cid=%d, location=%s, connection=%s, ahours=%s, pweapon=%s,
+ sweapon=%s, clan_before=%d, why_play=%s, skills_talents=%s, additional_comments=%s, tid=%d, picture=%s, sitename=%s, siteurl=%s, impref=%s, imid=%s, additional_info=%s, member=%d WHERE id = %d',
+ $realname, $membername, $email, $age, $gid, $cid, $location, $connection, $ahours, $pweapon, $sweapon, $clan_before, $why_play, $skills_talents, $additional_comments, $tid, $picture, $sitename, $siteurl, $impref, $imid, $additional_info, $member, $id);
+ redirect_header($member ? 'main.php?op=members_list' : 'main.php?op=members_approve', 1, _MD_MEMBERUPDATED);
+ } else {
+ $result = xRoster_Query('INSERT INTO {xRoster}
+ (realname, membername, email, age, gid, cid, location, connection, ahours, pweapon, sweapon, clan_before, why_play, skills_talents, additional_comments, tid, picture, sitename, siteurl, impref, imid, additional_info, member, since)
+ VALUES (%s, %s, %s, %d, %d, %d, %s, %s, %s, %s, %s, %d, %s, %s, %s, %d, %s, %s, %s, %s, %s, %s, %d, %d)',
+ $realname, $membername, $email, $age, $gid, $cid, $location, $connection, $ahours, $pweapon, $sweapon, $clan_before, $why_play, $skills_talents, $additional_comments, $tid, $picture, $sitename, $siteurl, $impref, $imid, $additional_info, $member, time());
+ redirect_header('main.php?op=members_list', 1, _MD_MEMBERADDED);
+ }
+ break;
+ case 'members_delete': Members_Delete($id); break;
+ case 'ConfigUpdate': ConfigUpdate(); break;
+}
+
+//xoops_cp_footer();
+include_once 'admin_footer.php';
\ No newline at end of file
Modified: XoopsModules/xroster/trunk/xroster/admin/menu.php
===================================================================
--- XoopsModules/xroster/trunk/xroster/admin/menu.php 2012-03-14 10:13:12 UTC (rev 9128)
+++ XoopsModules/xroster/trunk/xroster/admin/menu.php 2012-03-14 10:17:18 UTC (rev 9129)
@@ -1,16 +1,52 @@
<?php
-$adminmenu[0]['title'] = _MI_XROSTER_ADMENU1;
-$adminmenu[0]['link'] = 'admin/index.php?op=members_add';
-$adminmenu[1]['title'] = _MI_XROSTER_ADMENU2;
-$adminmenu[1]['link'] = 'admin/index.php?op=members_approve';
-$adminmenu[2]['title'] = _MI_XROSTER_ADMENU3;
-$adminmenu[2]['link'] = 'admin/index.php?op=members_list';
-$adminmenu[3]['title'] = _MI_XROSTER_ADMENU4;
-$adminmenu[3]['link'] = 'admin/index.php?op=Status_Editor';
-$adminmenu[4]['title'] = _MI_XROSTER_ADMENU5;
-$adminmenu[4]['link'] = 'admin/index.php?op=Title_Editor';
-$adminmenu[5]['title'] = _MI_XROSTER_ADMENU6;
-$adminmenu[5]['link'] = 'admin/index.php?op=Category_Editor';
+defined("XOOPS_ROOT_PATH") or die("XOOPS root path not defined");
-?>
\ No newline at end of file
+$dirname = basename(dirname(dirname(__FILE__)));
+$module_handler = xoops_gethandler('module');
+$module = $module_handler->getByDirname($dirname);
+$pathIcon32 = $module->getInfo('icons32');
+
+xoops_loadLanguage('admin', $dirname);
+$i = 0;
+
+// Index
+$adminmenu[$i]['title'] = _MI_XROSTER_ADMENU0;
+$adminmenu[$i]['link'] = "admin/index.php";
+$adminmenu[$i]["icon"] = $pathIcon32.'/home.png';
+$i++;
+
+$adminmenu[$i]['title'] = _MI_XROSTER_ADMENU1;
+$adminmenu[$i]['link'] = 'admin/main.php?op=members_add';
+$adminmenu[$i]["icon"] = $pathIcon32.'/add.png';
+
+$i++;
+$adminmenu[$i]['title'] = _MI_XROSTER_ADMENU2;
+$adminmenu[$i]['link'] = 'admin/main.php?op=members_approve';
+$adminmenu[$i]["icon"] = $pathIcon32.'/button_ok.png';
+
+$i++;
+$adminmenu[$i]['title'] = _MI_XROSTER_ADMENU3;
+$adminmenu[$i]['link'] = 'admin/main.php?op=members_list';
+$adminmenu[$i]["icon"] = $pathIcon32.'/search.png';
+
+$i++;
+$adminmenu[$i]['title'] = _MI_XROSTER_ADMENU4;
+$adminmenu[$i]['link'] = 'admin/main.php?op=Group_Editor';
+$adminmenu[$i]["icon"] = $pathIcon32.'/users.png';
+
+$i++;
+$adminmenu[$i]['title'] = _MI_XROSTER_ADMENU5;
+$adminmenu[$i]['link'] = 'admin/main.php?op=Title_Editor';
+$adminmenu[$i]["icon"] = $pathIcon32.'/manage.png';
+
+$i++;
+$adminmenu[$i]['title'] = _MI_XROSTER_ADMENU6;
+$adminmenu[$i]['link'] = 'admin/main.php?op=Category_Editor';
+$adminmenu[$i]["icon"] = $pathIcon32.'/category.png';
+
+$i++;
+$adminmenu[$i]['title'] = _MI_XROSTER_ADMENU7;
+$adminmenu[$i]['link'] = "admin/about.php";
+$adminmenu[$i]["icon"] = $pathIcon32.'/about.png';
+
Modified: XoopsModules/xroster/trunk/xroster/blocks/xroster_blocks.php
===================================================================
--- XoopsModules/xroster/trunk/xroster/blocks/xroster_blocks.php 2012-03-14 10:13:12 UTC (rev 9128)
+++ XoopsModules/xroster/trunk/xroster/blocks/xroster_blocks.php 2012-03-14 10:17:18 UTC (rev 9129)
@@ -2,7 +2,7 @@
function b_xroster_newestmember_show() {
$block = array();
- $xoopsDB =& Database::getInstance();
+ $xoopsDB =& XoopsDatabaseFactory::getDatabaseConnection();
$result = $xoopsDB->query('SELECT id, membername FROM ' . $xoopsDB->prefix('xRoster') . ' WHERE member=1 ORDER BY since DESC LIMIT 10');
while($row = $xoopsDB->fetchArray($result))
$block[] = $row;
Modified: XoopsModules/xroster/trunk/xroster/common.inc.php
===================================================================
--- XoopsModules/xroster/trunk/xroster/common.inc.php 2012-03-14 10:13:12 UTC (rev 9128)
+++ XoopsModules/xroster/trunk/xroster/common.inc.php 2012-03-14 10:17:18 UTC (rev 9129)
@@ -24,7 +24,7 @@
function xRoster_PostVar($k, $defval = null) {
static $db = false, $myts = false;
- if(!$db) $db =& Database::getInstance();
+ if(!$db) $db =& XoopsDatabaseFactory::getDatabaseConnection();
if(!$myts) $myts =& MyTextSanitizer::getInstance();
return isset($_POST[$k]) ? $myts->stripSlashesGPC($_POST[$k]) : $defval;
}
@@ -32,7 +32,7 @@
function &xRoster_Query($sql) {
global $xoopsModule;
static $db = false;
- if(!$db) $db =& Database::getInstance();
+ if(!$db) $db =& XoopsDatabaseFactory::getDatabaseConnection();
foreach($xoopsModule->getInfo('tables') as $table)
if(strpos($sql, '{' . $table . '}'))
$sql = str_replace('{' . $table . '}', $db->prefix($table), $sql);
@@ -94,7 +94,7 @@
}
function xRoster_SQLDro...
[truncated message content] |
