0.2.1/inc/modules/admin/what-extensions.php

   1 <?php\r
   2 /************************************************************************\r
   3  * MXChange v0.2.1                                    Start: 03/22/2004 *\r
   4  * ================                             Last change: 12/13/2004 *\r
   5  *                                                                      *\r
   6  * -------------------------------------------------------------------- *\r
   7  * File              : what-extentions.php                              *\r
   8  * -------------------------------------------------------------------- *\r
   9  * Short description : Extension management                             *\r
  10  * -------------------------------------------------------------------- *\r
  11  * Kurzbeschreibung  : Erweiterungen-Management                         *\r
  12  * -------------------------------------------------------------------- *\r
  13  *                                                                      *\r
  14  * -------------------------------------------------------------------- *\r
  15  * Copyright (c) 2003 - 2007 by Roland Haeder                           *\r
  16  * For more information visit: http://www.mxchange.org                  *\r
  17  *                                                                      *\r
  18  * This program is free software; you can redistribute it and/or modify *\r
  19  * it under the terms of the GNU General Public License as published by *\r
  20  * the Free Software Foundation; either version 2 of the License, or    *\r
  21  * (at your option) any later version.                                  *\r
  22  *                                                                      *\r
  23  * This program is distributed in the hope that it will be useful,      *\r
  24  * but WITHOUT ANY WARRANTY; without even the implied warranty of       *\r
  25  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the        *\r
  26  * GNU General Public License for more details.                         *\r
  27  *                                                                      *\r
  28  * You should have received a copy of the GNU General Public License    *\r
  29  * along with this program; if not, write to the Free Software          *\r
  30  * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,               *\r
  31  * MA  02110-1301  USA                                                  *\r
  32  ************************************************************************/\r
  33 \r
  34 // Some security stuff...\r
  35 if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) || (!IS_ADMIN()))\r
  36 {\r
  37         $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4)."/security.php";\r
  38         require($INC);\r
  39 }\r
  40 // Add description as navigation point\r
  41 ADD_DESCR("admin", basename(__FILE__));\r
  42 \r
  43 global $CACHE, $KEEP_ACTIVE, $CACHE_FILE;\r
  44 \r
  45 // Normally we want the overview of all registered extensions\r
  46 $mode = "overview";\r
  47 $SEL = "0";\r
  48 if (!empty($_POST['sel'])) $SEL = SELECTION_COUNT($_POST['sel']);\r
  49 \r
  50 if (!empty($_GET['reg_ext']))\r
  51 {\r
  52         // We are about to register a new extension\r
  53         $mode = "register"; $id = $_GET['reg_ext'];\r
  54         // The ID comes from task management and it is - of course - *not* the extension's name!\r
  55 }\r
  56  elseif ((isset($_POST['change'])) && ($SEL > 0) && (!IS_DEMO()))\r
  57 {\r
  58         // De-/activate extensions\r
  59         foreach ($_POST['sel'] as $id=>$active) {\r
  60                 // Shall we keep the extension always active?\r
  61                 if ((isset($KEEP_ACTIVE[GET_EXT_NAME($id)])) && ($KEEP_ACTIVE[GET_EXT_NAME($id)] == "Y") && ($active == "N")) {\r
  62                         // Keep this extension active!\r
  63                 } else {\r
  64                         // De/activate extension\r
  65                         $ACT = "N"; $EXT_LOAD_MODE = "deactivate";\r
  66                         if ($active == "N") { $ACT = "Y"; $EXT_LOAD_MODE = "activate"; }\r
  67                         $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_extensions SET ext_active='".$ACT."' WHERE id=%d AND ext_active='%s' LIMIT 1",\r
  68                          array(bigintval($id), $active), __FILE__, __LINE__);\r
  69 \r
  70                         // Run embeded SQL commands\r
  71                         EXTENSION_RUN_SQLS($id, $EXT_LOAD_MODE);\r
  72                 }\r
  73         }\r
  74 }\r
  75  elseif (((isset($_POST['edit'])) || (isset($_POST['modify']))) && ($SEL > 0) && (!IS_DEMO()))\r
  76 {\r
  77         // Change settings like CSS file load\r
  78         if (isset($_POST['modify']))\r
  79         {\r
  80                 // Change entries\r
  81                 $CACHE_UPDATE = "0";\r
  82                 foreach ($_POST['sel'] as $id=>$sel)\r
  83                 {\r
  84                         // Secure ID\r
  85                         $id = bigintval($id);\r
  86 \r
  87                         // Change this extension?\r
  88                         if ($sel == 1)\r
  89                         {\r
  90                                 // Update extension's record\r
  91                                 $active = $_POST['active'][$id];\r
  92                                 if (GET_EXT_VERSION("sql_patches") >= "0.0.6")\r
  93                                 {\r
  94                                         // Update also CSS column when extensions sql_patches is newer or exact v0.0.6\r
  95                                         $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_extensions SET ext_has_css='%s', ext_active='%s' WHERE id=%d LIMIT 1",\r
  96                                          array($_POST['css'][$id], $active, $id), __FILE__, __LINE__);\r
  97                                 }\r
  98                                  else\r
  99                                 {\r
 100                                         // When extension is older than v0.0.6 there is no column for the CSS information\r
 101                                         $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_extensions SET ext_active='%s' WHERE id=%d LIMIT 1",\r
 102                                          array($active, $id), __FILE__, __LINE__);\r
 103                                 }\r
 104                                 // Run SQLs on activation / deactivation\r
 105                                 switch ($active)\r
 106                                 {\r
 107                                         case "Y": $EXT_LOAD_MODE = "activate";   break;\r
 108                                         case "N": $EXT_LOAD_MODE = "deactivate"; break;\r
 109                                 }\r
 110 \r
 111                                 // Run embeded SQL commands\r
 112                                 EXTENSION_RUN_SQLS($id, $EXT_LOAD_MODE);\r
 113                         }\r
 114                 }\r
 115 \r
 116                 // Extensions changed\r
 117                 OUTPUT_HTML ("<P align=\"center\">");\r
 118                 LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_EXT_CHANGED);\r
 119                 OUTPUT_HTML ("</P>");\r
 120         }\r
 121          else\r
 122         {\r
 123                 // Edit selected entries\r
 124                 $SW = "2"; $OUT = "";\r
 125                 foreach ($_POST['sel'] as $id=>$sel)\r
 126                 {\r
 127                         // Edit this extension?\r
 128                         if (($sel == "Y") || ($sel == "N"))\r
 129                         {\r
 130                                 // Load required data\r
 131                                 if (GET_EXT_VERSION("sql_patches") >= "0.0.6")\r
 132                                 {\r
 133                                         $result = SQL_QUERY_ESC("SELECT ext_name, ext_has_css, ext_active FROM "._MYSQL_PREFIX."_extensions WHERE id=%d LIMIT 1",\r
 134                                          array(bigintval($id)), __FILE__, __LINE__);\r
 135                                         list($name, $css, $active) = SQL_FETCHROW($result);\r
 136                                         SQL_FREERESULT($result);\r
 137                                 }\r
 138                                  else\r
 139                                 {\r
 140                                         $result = SQL_QUERY_ESC("SELECT ext_name, ext_active FROM "._MYSQL_PREFIX."_extensions WHERE id=%d LIMIT 1",\r
 141                                          array(bigintval($id)), __FILE__, __LINE__);\r
 142                                         list($name, $active) = SQL_FETCHROW($result);\r
 143                                         SQL_FREERESULT($result);\r
 144                                         $css = "X";\r
 145                                 }\r
 146 \r
 147                                 // Output row\r
 148                                 $CSS = "---";\r
 149                                 if (GET_EXT_VERSION("sql_patches") >= "0.0.6") $CSS = ADD_SELECTION("yn", $css, "css", $id);\r
 150 \r
 151                                 // Prepare data for the row template\r
 152                                 $content = array(\r
 153                                         'sw'     => $SW,\r
 154                                         'id'     => $id,\r
 155                                         'name'   => $name,\r
 156                                         'active' => ADD_SELECTION("yn", $active, "active", $id),\r
 157                                         'css'    => $CSS,\r
 158                                 );\r
 159 \r
 160                                 // Load row template and switch color\r
 161                                 $OUT .= LOAD_TEMPLATE("admin_extensions_edit_row", true, $content);\r
 162                                 $SW = 3 - $SW;\r
 163                         }\r
 164                 }\r
 165                 define('__EXTENSIONS_ROWS', $OUT);\r
 166 \r
 167                 // Load template\r
 168                 LOAD_TEMPLATE("admin_extensions_edit");\r
 169                 $mode = "edit";\r
 170         }\r
 171 }\r
 172  elseif ((isset($_POST['delete'])) && ($SEL > 0) && (!IS_DEMO()))\r
 173 {\r
 174         // List extensions and when verbose is enabled SQL statements which will be executed\r
 175         $SW = 2; $OUT = "";\r
 176         foreach ($_POST['sel'] as $id=>$sel)\r
 177         {\r
 178                 $VERBOSE_OUT = ""; $SQLs = array();\r
 179                 // Load extension's data\r
 180                 $result = SQL_QUERY_ESC("SELECT ext_name, ext_version FROM "._MYSQL_PREFIX."_extensions WHERE id=%d LIMIT 1",\r
 181                  array(bigintval($id)), __FILE__, __LINE__);\r
 182                 list($ext_name, $ext_ver) = SQL_FETCHROW($result);\r
 183                 SQL_FREERESULT($result);\r
 184 \r
 185                 if ($CONFIG['verbose_sql'])\r
 186                 {\r
 187                         // Load SQL commands in remove mode\r
 188                         $EXT_LOAD_MODE = "remove";\r
 189                         $file = sprintf(PATH."inc/extensions/ext-%s.php", $ext_name);\r
 190                         include($file);\r
 191 \r
 192                         // Generate extra table with loaded SQL commands\r
 193                         $VERBOSE_OUT = EXTENSION_VERBOSE_TABLE($SQLs);\r
 194                 }\r
 195 \r
 196                 // Prepare data for the row template\r
 197                 $content = array(\r
 198                         'sw'       => $SW,\r
 199                         'id'       => $id,\r
 200                         'ext_name' => $ext_name,\r
 201                         'ext_ver'  => $ext_ver,\r
 202                         'verbose'  => $VERBOSE_OUT\r
 203                 );\r
 204 \r
 205                 // Load row template and switch color\r
 206                 $OUT .= LOAD_TEMPLATE("admin_extensions_delete_row", true, $content);\r
 207                 $SW = 3 - $SW;\r
 208         }\r
 209         define('__EXTENSIONS_ROWS', $OUT);\r
 210 \r
 211         // Load template\r
 212         LOAD_TEMPLATE("admin_extensions_delete");\r
 213         $mode = "delete";\r
 214 }\r
 215  elseif ((isset($_POST['remove'])) && ($SEL > 0) && (!IS_DEMO()))\r
 216 {\r
 217         // Remove extensions from DB (you have to delete all files manually!)\r
 218         $CACHE_UPDATE = "0";\r
 219         foreach ($_POST['sel'] as $id=>$active)\r
 220         {\r
 221                 if ($active == 1)\r
 222                 {\r
 223                         // Run embeded SQL commands\r
 224                         EXTENSION_RUN_SQLS($id, "remove");\r
 225 \r
 226                         // Delete this extension (remember to remove it from your server *before* you click on welcome!\r
 227                         $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_extensions WHERE id=%d LIMIT 1",\r
 228                          array(bigintval($id)), __FILE__, __LINE__);\r
 229                 }\r
 230         }\r
 231 }\r
 232  elseif (!empty($_GET['do']) && (!IS_DEMO()))\r
 233 {\r
 234         // Other things to do\r
 235         $mode = $_GET['do'];\r
 236 }\r
 237  elseif (!empty($_GET['do']))\r
 238 {\r
 239         // Demo mode active!\r
 240         $mode = "demo";\r
 241 }\r
 242 \r
 243 switch ($mode)\r
 244 {\r
 245 case "overview": // List all registered extensions\r
 246         if (GET_EXT_VERSION("sql_patches") >= "0.0.6")\r
 247         {\r
 248                 // Load extension data with CSS informations\r
 249                 $result = SQL_QUERY("SELECT id, ext_name, ext_lang_file, ext_active, ext_has_css, ext_version FROM "._MYSQL_PREFIX."_extensions ORDER BY ext_name", __FILE__, __LINE__);\r
 250         }\r
 251          else\r
 252         {\r
 253                 // Load extension data without CSS informations\r
 254                 $result = SQL_QUERY("SELECT id, ext_name, ext_lang_file, ext_active, id, ext_version FROM "._MYSQL_PREFIX."_extensions ORDER BY ext_name", __FILE__, __LINE__);\r
 255         }\r
 256         if (SQL_NUMROWS($result) > 0)\r
 257         {\r
 258                 // Extensions are registered\r
 259                 $SW = 2; $OUT = "";\r
 260                 while (list($id, $name, $lang, $active, $css, $ver) = SQL_FETCHROW($result))\r
 261                 {\r
 262                         $CSS = "---";\r
 263                         if (GET_EXT_VERSION("sql_patches") >= "0.0.6") $CSS = TRANSLATE_YESNO($css);\r
 264 \r
 265                         // Prepare data for the row template\r
 266                         $content = array(\r
 267                                 'sw'      => $SW,\r
 268                                 'id'      => $id,\r
 269                                 'name'    => $name,\r
 270                                 'active'  => TRANSLATE_YESNO($active),\r
 271                                 'act_val' => $active,\r
 272                                 'lang'    => $lang,\r
 273                                 'css'     => $CSS,\r
 274                                 'ver'     => $ver,\r
 275                         );\r
 276 \r
 277                         // Load row template and switch color\r
 278                         $OUT .= LOAD_TEMPLATE("admin_extensions_row", true, $content);\r
 279                         $SW = 3 - $SW;\r
 280                 }\r
 281 \r
 282                 // Free memory\r
 283                 SQL_FREERESULT($result);\r
 284 \r
 285                 // Remember rows in constant for the template\r
 286                 define('__EXT_ROWS', $OUT);\r
 287 \r
 288                 // Load template\r
 289                 LOAD_TEMPLATE("admin_extensions");\r
 290         }\r
 291          else\r
 292         {\r
 293                 // No extensions are registered\r
 294                 LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_NO_EXTENSION_REGISTERED."</FONT>");\r
 295         }\r
 296         // Link for checking for new or updated extensions\r
 297         OUTPUT_HTML ("<BR><A href=\"".URL."/modules.php?module=admin&amp;what=extensions&amp;do=search\">".ADMIN_SEARCH_NEW_EXTENSIONS."</A>");\r
 298         break;\r
 299 \r
 300 case "register": // Register new extension\r
 301         $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_task_system WHERE assigned_admin='%s' AND task_type='EXTENSION' LIMIT 1",\r
 302          array(bigintval(GET_ADMIN_ID($_COOKIE['admin_login']))), __FILE__, __LINE__);\r
 303         $task_found = SQL_NUMROWS($result);\r
 304         SQL_FREERESULT($result);\r
 305         if (($id > 0) && ($task_found == 1))\r
 306         {\r
 307                 // ID is valid so begin with registration, we first want to it's real name from task management (subject column)\r
 308                 $result = SQL_QUERY_ESC("SELECT subject FROM "._MYSQL_PREFIX."_task_system WHERE id=%d LIMIT 1",\r
 309                  array(bigintval($id)), __FILE__, __LINE__);\r
 310                 list($subj) = SQL_FETCHROW($result);\r
 311                 SQL_FREERESULT($result);\r
 312 \r
 313                 // Disable cache update by default\r
 314                 $CACHE_UPDATE = "0";\r
 315                 if (!empty($subj))\r
 316                 {\r
 317                         // Extract extension's name from subject...\r
 318                         $ext_name = trim(substr($subj, 1, strpos($subj, ":") - 1));\r
 319 \r
 320                         // ... so we can finally register and load it in registration mode\r
 321                         $status = EXTENSION_REGISTER($ext_name, $id);\r
 322                         if ($status)\r
 323                         {\r
 324                                 // Extension was found and successfully registered\r
 325                                 LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_EXTENSION_REGISTERED);\r
 326 \r
 327                                 // Do we need to update cache file?\r
 328                                 if ((EXT_IS_ACTIVE("cache")) && ($CACHE_FILE != "no"))\r
 329                                 {\r
 330                                         // Remove cache file (will be auto-created again!)\r
 331                                         if ($CACHE->cache_file("extensions", true)) $CACHE->cache_destroy();\r
 332                                 }\r
 333                         }\r
 334                          else\r
 335                         {\r
 336                                 // Motify the admin that we have a problem here...\r
 337                                 LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_REG_FAILED_404);\r
 338                         }\r
 339                 }\r
 340                  else\r
 341                 {\r
 342                         // Extension was not found in task management\r
 343                         LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_REG_FAILED_ID_404);\r
 344                 }\r
 345         }\r
 346          elseif ($task_found == "0")\r
 347         {\r
 348                 // No longer assigned or old task\r
 349                 LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_REG_FAILED_ASSIGED);\r
 350         }\r
 351          else\r
 352         {\r
 353                 // ID is invalid\r
 354                 LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_REG_FAILED_INVALID);\r
 355         }\r
 356         break;\r
 357 \r
 358 case "search": // Search for new extensions on our server\r
 359         // Get response from our server\r
 360         $response = MXCHANGE_OPEN("extensions.php");\r
 361 \r
 362         // Are extensions found?\r
 363         if (($response[sizeof($response) - 1] == "[EOF]") && ($response[0] != "[EOF]"))\r
 364         {\r
 365                 // Ok, mark found and create the array\r
 366                 $EXT_SEARCH = array(\r
 367                         'fname'  => array(), // File names\r
 368                         'fsize'  => array(), // File size\r
 369                         'fctime' => array(), // File creation timestamp\r
 370                         'infos'  => array(), // File informations (maybe loaded!)\r
 371                         'ver'    => array(), // Version number\r
 372                         'cver'   => array(), // Current version number\r
 373                 );\r
 374 \r
 375                 // Get count of extensions for validation\r
 376                 $count = trim($response[sizeof($response) - 2]);\r
 377                 foreach ($response as $id=>$value)\r
 378                 {\r
 379                         $value = str_replace("\n", "", $value); $ver = "";\r
 380                         // Leave loop when data is invalid or EOF?\r
 381                         if ((substr($value, 0, 4) == "ext-") && (substr($value, -4) == ".zip"))\r
 382                         {\r
 383                                 $name = substr($value, 4, -4);\r
 384                                 $file = sprintf(PATH."inc/extensions/ext-%s.php", $name);\r
 385                                 $ver = trim(substr($response[$id + 3], 4));\r
 386 \r
 387                                 // Load current extension's version\r
 388                                 $cver = GET_EXT_VERSION($name);\r
 389                                 if (empty($cver)) $cver = "-.-";\r
 390 \r
 391                                 // Is the extension already installed or not?\r
 392                                 if (!file_exists($file) || ($ver != $cver))\r
 393                                 {\r
 394                                         // No, it isn't. So let's add this one!\r
 395                                         $EXT_SEARCH['fname'][]  = $name;\r
 396                                         $EXT_SEARCH['fsize'][]  = $response[$id + 1];\r
 397                                         $EXT_SEARCH['fctime'][] = $response[$id + 2];\r
 398                                         $EXT_SEARCH['ver'][]    = $ver;\r
 399                                         $EXT_SEARCH['cver'][]   = $cver;\r
 400 \r
 401                                         $LANG_DUMMY = explode("[nl]", $response[$id + 4]);\r
 402                                         $LANG = array();\r
 403                                         $INFO = ADMIN_EXT_NO_INFO_FOUND;\r
 404 \r
 405                                         // Trim every data line\r
 406                                         foreach ($LANG_DUMMY as $k=>$v)\r
 407                                         {\r
 408                                                 $v = trim($v);\r
 409                                                 if (substr($v, 3) == "") $v = "---";\r
 410                                                 $LANG_DUMMY[$k] = $v;\r
 411                                                 if ($v == "xx:xx") break;\r
 412                                                 $LANG[] = $v;\r
 413                                         }\r
 414 \r
 415                                         // If language is found stop searching on matching line\r
 416                                         foreach($LANG as $search)\r
 417                                         {\r
 418                                                 if (substr($search, 0, 3) == (GET_LANGUAGE().":")) { $INFO = substr($search, 3); break; }\r
 419                                         }\r
 420 \r
 421                                         // Add informations to array\r
 422                                         $EXT_SEARCH['infos'][] = $INFO;\r
 423                                 }\r
 424                         }\r
 425                 }\r
 426 \r
 427                 // Ok, extensions are on our server but maybe you have already installed them?\r
 428                 if (sizeof($EXT_SEARCH['fname']) > 0)\r
 429                 {\r
 430                         // Sort array (I missed ver and cver here)\r
 431                         array_pk_sort($EXT_SEARCH, array("cver", "fname"), 0, 1);\r
 432 \r
 433                         // Extensions where found which are not downloaded and installed\r
 434                         $SW = 2; $OUT = ""; $TSIZE = 0;\r
 435                         foreach ($EXT_SEARCH['fname'] as $id=>$name)\r
 436                         {\r
 437                                 // Generate download link\r
 438                                 $LINK = SERVER_URL."/extensions/ext-".$name.".zip";\r
 439 \r
 440                                 // Prepare data for the row template\r
 441                                 $content = array(\r
 442                                         'sw'      => $SW,\r
 443                                         'id'      => ($id + 1),\r
 444                                         'name'    => $name,\r
 445                                         'new_ver' => $EXT_SEARCH['ver'][$id],\r
 446                                         'old_ver' => $EXT_SEARCH['cver'][$id],\r
 447                                         'link'    => $LINK,\r
 448                                         'last'    => MAKE_DATETIME($EXT_SEARCH['fctime'][$id], "2"),\r
 449                                         'size'    => TRANSLATE_COMMA(round($EXT_SEARCH['fsize'][$id] / 1.024) / 1000),\r
 450                                         'info'    => stripslashes($EXT_SEARCH['infos'][$id]),\r
 451                                 );\r
 452 \r
 453                                 // Load row template add current size to total size and switch color\r
 454                                 $OUT .= LOAD_TEMPLATE("admin_list_extensions_row", true, $content);\r
 455                                 $TSIZE += $EXT_SEARCH['fsize'][$id];\r
 456                                 $SW = 3 - $SW;\r
 457                         }\r
 458                         define('__EXTENSIONS_ROWS', $OUT);\r
 459                         define('__TKBYTES_VALUE', TRANSLATE_COMMA(round($TSIZE / 1.024) / 1000));\r
 460                         define('__TEXT_VALUE', sizeof($EXT_SEARCH['fname']));\r
 461 \r
 462                         // Load template\r
 463                         LOAD_TEMPLATE("admin_list_extensions");\r
 464                 }\r
 465                  else\r
 466                 {\r
 467                         // All extensions are downloaded and installed\r
 468                         LOAD_TEMPLATE("admin_extensions_installed", false, $count);\r
 469                 }\r
 470         }\r
 471          else\r
 472         {\r
 473                 // No extensions where found\r
 474                 LOAD_TEMPLATE("admin_extensions_404");\r
 475         }\r
 476         break;\r
 477 \r
 478 case "demo":\r
 479         LOAD_TEMPLATE("admin_settings_saved", false, SETTINGS_NOT_SAVED);\r
 480         break;\r
 481 }\r
 482 //\r
 483 ?>\r