]> git.mxchange.org Git - mailer.git/blob - inc/modules/admin/what-adminedit.php
87a8575d8744b71ac4236d69cf76eab70a63922a
[mailer.git] / inc / modules / admin / what-adminedit.php
1 <?php
2 /************************************************************************
3  * MXChange v0.2.1                                    Start: 09/05/2003 *
4  * ===============                              Last change: 12/13/2004 *
5  *                                                                      *
6  * -------------------------------------------------------------------- *
7  * File              : what-adminedit.php                               *
8  * -------------------------------------------------------------------- *
9  * Short description : Edit the admin menu                              *
10  * -------------------------------------------------------------------- *
11  * Kurzbeschreibung  : Das Admin-Menue editieren                        *
12  * -------------------------------------------------------------------- *
13  * $Revision::                                                        $ *
14  * $Date::                                                            $ *
15  * $Tag:: 0.2.1-FINAL                                                 $ *
16  * $Author::                                                          $ *
17  * Needs to be in all Files and every File needs "svn propset           *
18  * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
19  * -------------------------------------------------------------------- *
20  * Copyright (c) 2003 - 2008 by Roland Haeder                           *
21  * For more information visit: http://www.mxchange.org                  *
22  *                                                                      *
23  * This program is free software; you can redistribute it and/or modify *
24  * it under the terms of the GNU General Public License as published by *
25  * the Free Software Foundation; either version 2 of the License, or    *
26  * (at your option) any later version.                                  *
27  *                                                                      *
28  * This program is distributed in the hope that it will be useful,      *
29  * but WITHOUT ANY WARRANTY; without even the implied warranty of       *
30  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the        *
31  * GNU General Public License for more details.                         *
32  *                                                                      *
33  * You should have received a copy of the GNU General Public License    *
34  * along with this program; if not, write to the Free Software          *
35  * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,               *
36  * MA  02110-1301  USA                                                  *
37  ************************************************************************/
38
39 // Some security stuff...
40 if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
41         $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
42         require($INC);
43 }
44
45 // Add description as navigation point
46 ADD_DESCR("admin", __FILE__);
47
48 // Do we edit/delete/change main menus or sub menus?
49 $AND = "(`what` = '' OR `what` IS NULL)"; $SUB = "";
50 if (REQUEST_ISSET_GET(('sub')))
51 {
52         $AND = sprintf("`action`='%s' AND `what` IS NOT NULL", REQUEST_GET(('sub')));
53         $SUB = REQUEST_GET(('sub'));
54 }
55
56 // Get count of (maybe) selected menu points
57 $chk = 0;
58 if (REQUEST_ISSET_POST('sel')) $chk = SELECTION_COUNT(REQUEST_POST('sel'));
59
60 // List all menu points and make them editable
61 if ((REQUEST_ISSET_POST('edit')) && ($chk > 0) && (!IS_DEMO())) {
62         // Edit menu entries
63         define('__SUB_VALUE', $SUB);
64         define('__CHK_VALUE', $chk);
65         $cnt = 0; $SW = 2;
66         foreach (REQUEST_POST('sel') as $sel => $confirm)
67         {
68                 if ($confirm == 1)
69                 {
70                         $cnt++;
71                         $result = SQL_QUERY_ESC("SELECT title, action, what, descr FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE ".$AND." AND id=%s LIMIT 1",
72                          array(bigintval($sel)), __FILE__, __LINE__);
73                         if (SQL_NUMROWS($result) == 1)
74                         {
75                                 // Entry found so we load the stuff...
76                                 list($menu, $act, $wht, $descr) = SQL_FETCHROW($result);
77                                 SQL_FREERESULT($result);
78
79                                 // Prepare data for the row template
80                                 $content = array(
81                                         'action' => ADMIN_MAKE_MENU_SELECTION("admin", "action", "sel_action[".$sel."]", $act),
82                                         'what'   => ADMIN_MAKE_MENU_SELECTION("admin", "what", "sel_what[".$sel."]", $wht),
83                                         'sw'     => $SW,
84                                         'sel'    => $sel,
85                                         'menu'   => $menu,
86                                         'descr'  => $descr,
87                                         'cnt'    => $cnt,
88                                 );
89                                 $OUT .= LOAD_TEMPLATE("admin_amenu_edit_row", true, $content);
90                         }
91                          else
92                         {
93                                 // Entry not found?
94                                 $content = array(
95                                         'sw'  => $SW,
96                                         'sel' => $sel
97                                 );
98                                 $OUT .= LOAD_TEMPLATE("admin_menu_404_row", true, $content);
99                         }
100                         $SW = 3 - $SW;
101                 }
102         }
103         define('__MENU_ROWS', $OUT);
104         define('__CNT_VALUE', $cnt);
105
106         // Load template
107         LOAD_TEMPLATE("admin_amenu_edit_form");
108 }
109  elseif ((REQUEST_ISSET_POST('del')) && (!IS_DEMO()))
110 {
111         define('__SUB_VALUE', $SUB);
112         define('__CHK_VALUE', $chk);
113         // Del menu entries with or without confirmation
114         $SW = 2; $cnt = 0; $OUT = "";
115         foreach (REQUEST_POST('sel') as $sel => $confirm)
116         {
117                 if ($confirm == 1)
118                 {
119                         $cnt++;
120                         $result = SQL_QUERY_ESC("SELECT title FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE ".$AND." AND id=%s LIMIT 1",
121                          array(bigintval($sel)), __FILE__, __LINE__);
122                         if (SQL_NUMROWS($result) == 1)
123                         {
124                                 // Entry found so we load the stuff...
125                                 list($menu) = SQL_FETCHROW($result);
126                                 SQL_FREERESULT($result);
127
128                                 // Prepare data for the row template
129                                 $content = array(
130                                         'menu' => $menu,
131                                         'cnt'  => $cnt,
132                                         'sel'  => $sel,
133                                         'sw'   => $SW
134                                 );
135                                 $OUT .= LOAD_TEMPLATE("admin_amenu_delete_row", true, $content);
136                         }
137                          else
138                         {
139                                 // Entry not found?
140                                 $content = array(
141                                         'sw'  => $SW,
142                                         'sel' => $sel
143                                 );
144                                 $OUT .= LOAD_TEMPLATE("admin_menu_404_row", true, $content);
145                         }
146                         $SW = 3 - $SW;
147                 }
148         }
149         define('__MENU_ROWS', $OUT);
150         define('__CNT_VALUE', $cnt);
151
152         // Load template
153         LOAD_TEMPLATE("admin_amenu_delete");
154 } elseif ((IS_FORM_SENT()) && (!IS_DEMO())) {
155         // An action is done...
156         switch (REQUEST_POST('ok'))
157         {
158         case "edit": // Edit menu
159                 foreach (REQUEST_POST('sel') as $sel => $menu) {
160                         // Secure ID
161                         $sel = bigintval($sel);
162
163                         // Update entry
164                         SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_admin_menu` SET
165 title='%s',
166 `action`='%s',
167 `what`='%s',
168 descr='%s'
169 WHERE ".$AND." AND id=%s LIMIT 1",
170  array(
171         $menu,
172         REQUEST_POST('sel_action', $sel),
173         REQUEST_POST('sel_what', $sel),
174         REQUEST_POST('sel_desc', $sel),
175         $sel,
176 ), __FILE__, __LINE__);
177                 }
178
179                 // Purge admin menu cache
180                 CACHE_PURGE_ADMIN_MENU(0, REQUEST_POST('sel_action', $sel), REQUEST_POST('sel_what', $sel));
181
182                 // Load template
183                 LOAD_TEMPLATE("admin_settings_saved", false, getMessage('SETTINGS_SAVED'));
184                 break;
185
186         case "del": // Delete menu
187                 foreach (REQUEST_POST('sel') as $sel => $menu) {
188                         SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE ".$AND." AND id=%s LIMIT 1",
189                                 array(bigintval($sel)), __FILE__, __LINE__);
190                         CACHE_PURGE_ADMIN_MENU(0, "", "", $AND);
191                 } // END - foreach
192
193                 // Load template
194                 LOAD_TEMPLATE("admin_settings_saved", false, getMessage('SETTINGS_SAVED'));
195                 break;
196
197         default: // Unexpected action
198                 DEBUG_LOG(__FILE__, __LINE__, sprintf("Unsupported action %s detected.", REQUEST_POST('ok')));
199                 define('__OK_VALUE', REQUEST_POST('ok'));
200                 LOAD_TEMPLATE("admin_menu_unknown_okay");
201                 break;
202         }
203 } else {
204         if ((REQUEST_ISSET_GET(('act'))) && (REQUEST_ISSET_GET(('tid'))) && (REQUEST_ISSET_GET(('fid')))) {
205                 // Get IDs
206                 if (REQUEST_ISSET_GET(('w'))) {
207                         // Sub menus selected
208                         $result = SQL_QUERY_ESC("SELECT id FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE `action`='%s' AND `sort`='%s' LIMIT 1",
209                                 array(REQUEST_GET('act'), bigintval(REQUEST_GET('tid'))), __FILE__, __LINE__);
210                         list($tid) = SQL_FETCHROW($result);
211                         SQL_FREERESULT($result);
212                         $result = SQL_QUERY("SELECT id FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE `action`='%s' AND `sort`='%s' LIMIT 1",
213                                 array(REQUEST_GET('act'), bigintval(REQUEST_GET('fid'))), __FILE__, __LINE__);
214                         list($fid) = SQL_FETCHROW($result);
215                         SQL_FREERESULT($result);
216                 } else {
217                         // Main menu selected
218                         $result = SQL_QUERY_ESC("SELECT id FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE (`what`='' OR `what` IS NULL) AND `sort`='%s' LIMIT 1",
219                                 array(bigintval(REQUEST_GET('tid'))), __FILE__, __LINE__);
220                         list($tid) = SQL_FETCHROW($result);
221                         SQL_FREERESULT($result);
222                         $result = SQL_QUERY_ESC("SELECT id FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE (`what`='' OR `what` IS NULL) AND `sort`='%s' LIMIT 1",
223                                 array(bigintval(REQUEST_GET('fid'))), __FILE__, __LINE__);
224                         list($fid) = SQL_FETCHROW($result);
225                         SQL_FREERESULT($result);
226                 }
227
228                 if ((!empty($tid)) && (!empty($fid))) {
229                         // Sort menu
230                         SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_admin_menu` SET `sort`='%s' WHERE ".$AND." AND id=%s LIMIT 1",
231                                 array(bigintval(REQUEST_GET('tid')), bigintval($fid)), __FILE__, __LINE__);
232                         SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_admin_menu` SET `sort`='%s' WHERE ".$AND." AND id=%s LIMIT 1",
233                                 array(bigintval(REQUEST_GET('fid')), bigintval($tid)), __FILE__, __LINE__);
234                         CACHE_PURGE_ADMIN_MENU(0, "", "", $AND);
235                 }
236         }
237
238         // By default list menus
239         if (!empty($SUB)) {
240                 // Sub menus of a main menu
241                 $result = SQL_QUERY_ESC("SELECT id, action, what, title, sort FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE `action`='%s' AND `what` != '' AND `what` IS NOT NULL ORDER BY `sort` ASC",
242                  array($SUB), __FILE__, __LINE__);
243         } else {
244                 // Main menus
245                 $result = SQL_QUERY("SELECT id, action, what, title, sort FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE (`what`='' OR `what` IS NULL) ORDER BY `sort` ASC", __FILE__, __LINE__);
246         }
247
248         $max = SQL_NUMROWS($result);
249         if ($max > 0) {
250                 // @TODO Rewrite this constant
251                 define('__SUB_VALUE', $SUB);
252
253                 // Init variables
254                 $OUT = ""; $SW  = 2; $cnt = 0;
255
256                 // Process all entries
257                 while ($content = SQL_FETCHARRAY($result)) {
258                         // Count this entry
259                         $cnt++;
260
261                         // Init navigation variable
262                         $content['navi'] = "";
263                         if (($content['sort'] == 0) || (($content['sort'] == 1) && (!empty($SUB)))) {
264                                 // Is highest position
265                                 $content['navi'] = "<a href=\"{!URL!}/modules.php?module=admin&amp;what=adminedit&amp;sub={!__SUB_VALUE!}&amp;act=".$content['action']."&amp;w=".$content['what']."&amp;tid=".($content['sort']+1)."&amp;fid=".$content['sort']."\">{--LOWER--}</a>";
266                         } elseif ($cnt == $max) {
267                                 // Is lowest position
268                                 $content['navi'] = "<a href=\"{!URL!}/modules.php?module=admin&amp;what=adminedit&amp;sub={!__SUB_VALUE!}&amp;act=".$content['action']."&amp;w=".$content['what']."&amp;tid=".($content['sort']-1)."&amp;fid=".$content['sort']."\">{--HIGHER--}</a>";
269                         } elseif ($content['sort'] > 0) {
270                                 // Anything else between highest and lowest
271                                 $content['navi'] = "<a href=\"{!URL!}/modules.php?module=admin&amp;what=adminedit&amp;sub={!__SUB_VALUE!}&amp;act=".$content['action']."&amp;w=".$content['what']."&amp;tid=".($content['sort']-1)."&amp;fid=".$content['sort']."\">{--HIGHER--}</a>/<a href=\"{!URL!}/modules.php?module=admin&amp;what=adminedit&amp;sub={!__SUB_VALUE!}&amp;act=".$content['action']."&amp;w=".$content['what']."&amp;tid=".($content['sort']+1)."&amp;fid=".$content['sort']."\">{--LOWER--}</a>";
272                         }
273
274                         // Fix empty elements for constant (fixes display bugs in Firefox)
275                         if (empty($content['action'])) $content['action'] = "&nbsp;";
276                         if (empty($content['what']))   $content['what']   = "&nbsp;";
277                         if (empty($content['title']))  $content['title']  = "&nbsp;";
278
279                         // Add more data to $content
280                         $content['sw']   = $SW;
281                         $content['mode'] = "admin";
282
283                         // Load row template and switch colors
284                         $OUT .= LOAD_TEMPLATE("admin_menu_overview_row", true, $content);
285                         $SW = 3 - $SW;
286                 } // END - switch
287
288                 // Free memory
289                 SQL_FREERESULT($result);
290
291                 // Rewrite this constant
292                 define('__MENU_ROWS', $OUT);
293
294                 // Load template
295                 LOAD_TEMPLATE("admin_amenu_edit");
296         } else {
297                 // Menu entries are missing... (???)
298                 LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_NO_MENUS_FOUND'));
299         }
300 }
301
302 //
303 ?>