0.2.1/inc/extensions.php

   1 <?php\r
   2 /************************************************************************\r
   3  * MXChange v0.2.1                                    Start: 03/25/2004 *\r
   4  * ===============                              Last change: 09/29/2004 *\r
   5  *                                                                      *\r
   6  * -------------------------------------------------------------------- *\r
   7  * File              : extensions.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']))\r
  36 {\r
  37         $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4)."/security.php";\r
  38         require($INC);\r
  39 }\r
  40 //\r
  41 function EXTENSION_REGISTER($ext_name, $id, $dry_run=false)\r
  42 {\r
  43         global $NOTES, $CONFIG, $INC_POOL;\r
  44         // We want to register an extension and registration status is by default "failed" (= false)\r
  45         $EXT_LOAD_MODE = "register"; $ret = false; $SQLs = array();\r
  46         $INC_POOL = array();\r
  47 \r
  48         // This shall never do a non-admin user!\r
  49         if (!IS_ADMIN()) return false;\r
  50 \r
  51         // Is this extension already installed?\r
  52         if (EXT_IS_ACTIVE($ext_name)) return false;\r
  53 \r
  54         // Generate file name\r
  55         $file = sprintf(PATH."inc/extensions/ext-%s.php", $ext_name);\r
  56 \r
  57         // Does this extension exists?\r
  58         if (file_exists($file) && is_readable($file))\r
  59         {\r
  60                 // Extension was found so we can load it in registration mode\r
  61                 require($file);\r
  62 \r
  63                 // And run possible updates\r
  64                 $EXT_LOAD_MODE = "update"; $EXT_UPDATE_DEPENDS = "";\r
  65                 foreach ($EXT_VER_HISTORY as $EXT_VER)\r
  66                 {\r
  67                         require($file);\r
  68                         if (((GET_EXT_VERSION("sql_patches") != "") && ($CONFIG['verbose_sql'] == "Y")) || (!EXT_IS_ACTIVE("sql_patches")))\r
  69                         {\r
  70                                 if (!empty($UPDATE_NOTES))\r
  71                                 {\r
  72                                         // Update notes found\r
  73                                         $NOTES .= "<STRONG>v".$EXT_VER.":</STRONG><BR>".$UPDATE_NOTES."<BR><BR>\n";\r
  74                                         $UPDATE_NOTES = "";\r
  75                                 }\r
  76                                  elseif (($EXT_VER == "0.0") || ($EXT_VER == "0.0.0"))\r
  77                                 {\r
  78                                         // Initial release\r
  79                                         $NOTES .= "<STRONG>v".$EXT_VER.":</STRONG><BR>".INITIAL_RELEASE."<BR><BR>\n";\r
  80                                 }\r
  81                                  else\r
  82                                 {\r
  83                                         $NOTES .= "<STRONG>v".$EXT_VER.":</STRONG><BR><I>".NO_UPDATE_NOTES."</I><BR><BR>\n";\r
  84                                 }\r
  85                         }\r
  86                 }\r
  87 \r
  88                 // Does this extension depends on an outstanding update of another update?\r
  89                 if (!empty($EXT_UPDATE_DEPENDS))\r
  90                 {\r
  91                         // Backup SQL commands and clear current\r
  92                         $SQLs2 = $SQLs;  $SQLs = array(); $test = false;\r
  93 \r
  94                         // Backup language as well\r
  95                         $LANG_BCK = $EXT_LANG_PREFIX;\r
  96 \r
  97                         // Load required extension also in update mode\r
  98                         $file = sprintf(PATH."inc/extensions/ext-%s.php", $EXT_UPDATE_DEPENDS);\r
  99 \r
 100                         // Check for required file\r
 101                         if (file_exists($file) && is_readable($file))\r
 102                         {\r
 103                                 // File exists so let's load it\r
 104                                 $VER_BACKUP = $EXT_VERSION;\r
 105                                 require($file);\r
 106                                 $EXT_VERSION = $VER_BACKUP;\r
 107 \r
 108                                 // If versions mismatch update extension first\r
 109                                 $ext_ver = GET_EXT_VERSION($EXT_UPDATE_DEPENDS);\r
 110                                 if (empty($ext_ver))\r
 111                                 {\r
 112                                         // Extension not registered so far so first load task's ID...\r
 113                                         $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_task_system WHERE task_type='EXTENSION' AND subject LIKE '[%s:]%%' LIMIT 1",\r
 114                                          array($EXT_UPDATE_DEPENDS), __FILE__, __LINE__);\r
 115                                         if (SQL_NUMROWS($result) == 1)\r
 116                                         {\r
 117                                                 // Task found so load task's ID and register extension...\r
 118                                                 list($task) = SQL_FETCHROW($result);\r
 119                                                 SQL_FREERESULT($result);\r
 120                                                 $test = EXTENSION_REGISTER($EXT_UPDATE_DEPENDS, $task, $dry_run);\r
 121                                         }\r
 122                                 }\r
 123                                  elseif ($ext_ver != $EXT_VERSION)\r
 124                                 {\r
 125                                         // Ok, update this extension now\r
 126                                         EXTENSION_UPDATE(basename($file), $EXT_UPDATE_DEPENDS, $ext_ver, $dry_run);\r
 127                                         $test = true;\r
 128                                 }\r
 129                                  else\r
 130                                 {\r
 131                                         // Nothing to register / update before...\r
 132                                         $test = true;\r
 133                                 }\r
 134                         }\r
 135                          else\r
 136                         {\r
 137                                 // Required file for update does not exists!\r
 138                                 $test = true;\r
 139                                 // But this is fine for the first time...\r
 140                         }\r
 141 \r
 142                         // Finally restore previous SQLs\r
 143                         $SQLs = $SQLs2; unset($SQLs2);\r
 144                         $EXT_LANG_PREFIX = $LANG_BCK;\r
 145                 }\r
 146                  else\r
 147                 {\r
 148                         // Does not depend on an other extension\r
 149                         $test = true;\r
 150                 }\r
 151 \r
 152                 // Does everthing before wents ok?\r
 153                 if ($test)\r
 154                 {\r
 155                         // "Dry-run-mode" activated?\r
 156                         if (!$dry_run)\r
 157                         {\r
 158                                 // Are there any SQL commands to run?\r
 159                                 if (count($SQLs) > 0)\r
 160                                 {\r
 161                                         foreach ($SQLs as $sql)\r
 162                                         {\r
 163                                                 $sql = trim($sql);\r
 164                                                 // Run SQL command\r
 165                                                 if (!empty($sql))\r
 166                                                 {\r
 167                                                         // Run SQLs without compiling them...\r
 168                                                         $result = SQL_QUERY($sql, __FILE__, __LINE__, false);\r
 169                                                 }\r
 170                                         }\r
 171                                 }\r
 172 \r
 173                                 // Check for added include files\r
 174                                 if (count($INC_POOL > 0))\r
 175                                 {\r
 176                                         // Loads every include file\r
 177                                         foreach ($INC_POOL as $inc)\r
 178                                         {\r
 179                                                 require_once($inc);\r
 180                                         }\r
 181                                 }\r
 182 \r
 183                                 // Register extension\r
 184                                 $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_extensions (ext_name, ext_lang_file, ext_active, ext_version) VALUES ('%s', '%s', 'N', '%s')",\r
 185                                  array($ext_name, $EXT_LANG_PREFIX, $EXT_VERSION), __FILE__, __LINE__);\r
 186 \r
 187                                 // Update task management\r
 188                                 $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_task_system SET status='SOLVED' WHERE id=%d LIMIT 1",\r
 189                                  array(bigintval($id)), __FILE__, __LINE__);\r
 190 \r
 191                                 // In normal mode return a true on success\r
 192                                 $ret = true; unset($SQLs);\r
 193                         }\r
 194                          else\r
 195                         {\r
 196                                 // Rewrite SQL command to keep { and } inside\r
 197                                 foreach ($SQLs as $key=>$sql)\r
 198                                 {\r
 199                                         $sql = str_replace('{', "&#123;", str_replace('}', "&#125;", $sql));\r
 200                                         $SQLs[$key] = $sql;\r
 201                                 }\r
 202 \r
 203                                 // In  "dry-run" mode return array with all SQL commands\r
 204                                 $ret = $SQLs;\r
 205 \r
 206                                 // Remove all SQL commands\r
 207                                 unset($SQLs);\r
 208                         }\r
 209                 }\r
 210                  else\r
 211                 {\r
 212                         // No, an error occurs while registering extension :-(\r
 213                         $ret = false;\r
 214                 }\r
 215         }\r
 216          elseif (($id > 0) && (!empty($ext_name)))\r
 217         {\r
 218                 // Remove task from system when id and extension's name is valid\r
 219                 $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_task_system WHERE id=%d AND status='NEW' LIMIT 1",\r
 220                  array(bigintval($id)), __FILE__, __LINE__);\r
 221         }\r
 222         // Return status code\r
 223         return $ret;\r
 224 }\r
 225 //\r
 226 function EXTENSION_RUN_SQLS($id, $EXT_LOAD_MODE)\r
 227 {\r
 228         global $CACHE;\r
 229         // This shall never do a non-admin user!\r
 230         if (!IS_ADMIN()) return false;\r
 231 \r
 232         // Get extension's name\r
 233         $result = SQL_QUERY_ESC("SELECT ext_name FROM "._MYSQL_PREFIX."_extensions WHERE id=%d LIMIT 1",\r
 234          array(bigintval($id)), __FILE__, __LINE__);\r
 235         list($ext_name) = SQL_FETCHROW($result);\r
 236         SQL_FREERESULT($result);\r
 237         if (empty($ext_name)) return false;\r
 238 \r
 239         // Load extension in detected mode\r
 240         $file = sprintf(PATH."inc/extensions/ext-%s.php", $ext_name); $SQLs = array();\r
 241         if (file_exists($file) && is_readable($file)) require($file);\r
 242         if ((is_array($SQLs) && (sizeof($SQLs) > 0)))\r
 243         {\r
 244                 // Run SQL commands...\r
 245                 foreach ($SQLs as $sql)\r
 246                 {\r
 247                         $sql = trim($sql);\r
 248                         if (!empty($sql))\r
 249                         {\r
 250                                 // Run SQL command\r
 251                                 $result = SQL_QUERY($sql, __FILE__, __LINE__, false);\r
 252                         }\r
 253                 }\r
 254 \r
 255                 // Remove cache file(s) if extension is active\r
 256                 if (EXT_IS_ACTIVE("cache"))\r
 257                 {\r
 258                         // Remove cache filer\r
 259                         if ($CACHE->cache_file("extensions", true)) $CACHE->cache_destroy();\r
 260                         if ($CACHE->cache_file("mod_reg", true))    $CACHE->cache_destroy();\r
 261                         if ($CACHE->cache_file("config", true))     $CACHE->cache_destroy();\r
 262                 }\r
 263         }\r
 264 }\r
 265 //\r
 266 function EXT_IS_ACTIVE ($ext_name, $ignore_admin=false, $ignore_cache=false)\r
 267 {\r
 268         global $EXTENSIONS, $CONFIG;\r
 269 \r
 270         // Extensions are all inactive during installation\r
 271         if ((!mxchange_installed) || (mxchange_installing) || (empty($ext_name))) return false;\r
 272 \r
 273         // Extension's file name will also be checked\r
 274         $FILE = PATH."inc/extensions/ext-".$ext_name.".php";\r
 275         if ((!file_exists($FILE)) && (!is_readable($FILE))) return false;\r
 276         //* DEBUG: */ echo "*".$ext_name."*<BR>";\r
 277 \r
 278         // Failed is the default\r
 279         $ret = false;\r
 280         if ((!empty($EXTENSIONS['ext_active'][$ext_name])) && (!$ignore_cache))\r
 281         {\r
 282                 // Load from cache\r
 283                 $active = $EXTENSIONS['ext_active'][$ext_name];\r
 284 \r
 285                 // Count cache hits\r
 286                 if (isset($CONFIG['cache_hits'])) $CONFIG['cache_hits']++;\r
 287         }\r
 288          else\r
 289         {\r
 290                 // Load from database\r
 291                 $result = SQL_QUERY_ESC("SELECT ext_active FROM "._MYSQL_PREFIX."_extensions WHERE ext_name='%s' LIMIT 1",\r
 292                  array($ext_name), __FILE__, __LINE__);\r
 293                 if (SQL_NUMROWS($result) == 0)\r
 294                 {\r
 295                         // Extension was not found!\r
 296                         return false;\r
 297                 }\r
 298                 list($active) = SQL_FETCHROW($result);\r
 299                 SQL_FREERESULT($result);\r
 300 \r
 301                 // Write cache array\r
 302                 $EXTENSIONS['ext_active'][$ext_name] = $active;\r
 303         }\r
 304 \r
 305         // Is this extension activated? (For admins we always have active extensions...)\r
 306         $inc = sprintf(PATH."inc/extensions/ext-%s.php", $ext_name);\r
 307         // Shorter way\r
 308         return (\r
 309                 (\r
 310                         ($active == "Y") || (\r
 311                                 (IS_ADMIN()) &&\r
 312                                 (!$ignore_admin) &&\r
 313                                 (!empty($active))\r
 314                         )\r
 315                 ) && (\r
 316                         file_exists($inc)\r
 317                 ) && (\r
 318                         is_readable($inc)\r
 319                 )\r
 320         );\r
 321 }\r
 322 //\r
 323 function GET_EXT_VERSION ($ext_name)\r
 324 {\r
 325         global $EXTENSIONS, $CONFIG;\r
 326         // Extensions are all inactive during installation\r
 327         if ((!mxchange_installed) || (mxchange_installing)) return "";\r
 328 \r
 329         // Is the cache written?\r
 330         if (!empty($EXTENSIONS['ext_version'][$ext_name]))\r
 331         {\r
 332                 // Load data from cache\r
 333                 $ret = $EXTENSIONS['ext_version'][$ext_name];\r
 334 \r
 335                 // Count cache hits\r
 336                 if (isset($CONFIG['cache_hits'])) $CONFIG['cache_hits']++;\r
 337         }\r
 338          else\r
 339         {\r
 340                 // Load from database\r
 341                 $result = SQL_QUERY_ESC("SELECT ext_version FROM "._MYSQL_PREFIX."_extensions WHERE ext_name='%s' LIMIT 1",\r
 342                  array($ext_name), __FILE__, __LINE__);\r
 343                 list($ret) = SQL_FETCHROW($result);\r
 344                 SQL_FREERESULT($result);\r
 345 \r
 346                 // Set cache\r
 347                 $EXTENSIONS['ext_version'][$ext_name] = $ret;\r
 348         }\r
 349         return $ret;\r
 350 }\r
 351 //\r
 352 function EXTENSION_UPDATE($file, $ext, $EXT_VER, $dry_run=false)\r
 353 {\r
 354         // This shall never do a non-admin user!\r
 355         global $CACHE, $CONFIG, $NOTES; $SQLs = array();\r
 356         if ((!IS_ADMIN()) || (empty($ext))) return false;\r
 357 \r
 358         // Load extension in update mode\r
 359         $EXT_LOAD_MODE = "update"; $EXT_UPDATE_DEPENDS = ""; $NOTES = "";\r
 360         include(PATH."inc/extensions/".$file);\r
 361         if (!empty($EXT_UPDATE_DEPENDS))\r
 362         {\r
 363                 // Update another extension first!\r
 364                 $test = EXTENSION_UPDATE(("ext-".$EXT_UPDATE_DEPENDS.".php"), $EXT_UPDATE_DEPENDS, GET_EXT_VERSION($EXT_UPDATE_DEPENDS), $dry_run);\r
 365         }\r
 366 \r
 367         // Check if version is updated\r
 368         if ((($EXT_VERSION != $EXT_VER) || ($dry_run)) && (is_array($EXT_VER_HISTORY)))\r
 369         {\r
 370                 // Search for starting point\r
 371                 $start = array_search($EXT_VER, $EXT_VER_HISTORY);\r
 372                 $NOTES = "";\r
 373 \r
 374                 // And load SQL queries in order of version history\r
 375                 for ($idx = ($start + 1); $idx < sizeof($EXT_VER_HISTORY); $idx++)\r
 376                 {\r
 377                         // Remove old SQLs array to prevent possible bugs\r
 378                         if (!$dry_run) { unset($SQLs); $SQLs = array(); }\r
 379 \r
 380                         // Set version\r
 381                         $EXT_VER = $EXT_VER_HISTORY[$idx];\r
 382 \r
 383                         // Include again...\r
 384                         include(PATH."inc/extensions/".$file);\r
 385 \r
 386                         // Add notes\r
 387                         if ($CONFIG['verbose_sql'] == "Y")\r
 388                         {\r
 389                                 $EXT_VER = $EXT_VER_HISTORY[$idx];\r
 390                                 if (!empty($UPDATE_NOTES))\r
 391                                 {\r
 392                                         // Update notes found\r
 393                                         $NOTES .= "<STRONG>v".$EXT_VER.":</STRONG><BR>".$UPDATE_NOTES."<BR><BR>\n";\r
 394                                         $UPDATE_NOTES = "";\r
 395                                 }\r
 396                                  elseif ($EXT_VER == "0.0")\r
 397                                 {\r
 398                                         // Initial release\r
 399                                         $NOTES .= "<STRONG>v".$EXT_VER.":</STRONG><BR>".INITIAL_RELEASE."<BR><BR>\n";\r
 400                                 }\r
 401                                  else\r
 402                                 {\r
 403                                         $NOTES .= "<STRONG>v".$EXT_VER.":</STRONG><BR><I>".NO_UPDATE_NOTES."</I><BR><BR>\n";\r
 404                                 }\r
 405                         }\r
 406 \r
 407                         // Run SQLs\r
 408                         if ((is_array($SQLs)) && (!$dry_run))\r
 409                         {\r
 410                                 // Run SQL commands\r
 411                                 foreach ($SQLs as $sql)\r
 412                                 {\r
 413                                         $sql = trim($sql);\r
 414                                         if (!empty($sql))\r
 415                                         {\r
 416                                                 // Run SQL command...\r
 417                                                 $result = SQL_QUERY($sql, __FILE__, __LINE__, false);\r
 418                                         }\r
 419                                 }\r
 420                         } elseif (GET_EXT_VERSION("sql_patches") == "") {\r
 421                                 // Remove SQLs if extension is not installed\r
 422                                 $SQLs = array();\r
 423                         }\r
 424                 }\r
 425 \r
 426                 if (!$dry_run)\r
 427                 {\r
 428                         // In normal mode insert task and update extension's version...\r
 429                         $ext_subj = "[UPDATE-".$ext."-".$EXT_VERSION.":] ".ADMIN_UPDATE_EXT_SUBJ;\r
 430 \r
 431                         // Create task\r
 432                         $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_task_system WHERE subject='%s' LIMIT 1",\r
 433                          array($ext_subj), __FILE__, __LINE__);\r
 434                         if (SQL_NUMROWS($result) == 0)\r
 435                         {\r
 436                                 // Task not created so it's a brand-new extension which we need to register and create a task for!\r
 437                                 $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_task_system (assigned_admin, userid, status, task_type, subject, text, task_created) VALUES ('%s', '0', 'NEW', 'EXTENSION_UPDATE', '%s', '%s', UNIX_TIMESTAMP())",\r
 438                                  array(GET_ADMIN_ID(SQL_ESCAPE($_COOKIE['admin_login'])), $ext_subj, addslashes($NOTES)), __FILE__, __LINE__);\r
 439                         }\r
 440 \r
 441                         // Free memory\r
 442                         SQL_FREERESULT($result);\r
 443 \r
 444                         // Update extension's version\r
 445                         $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_extensions SET ext_version='%s' WHERE ext_name='%s' LIMIT 1",\r
 446                          array($EXT_VERSION, $ext), __FILE__, __LINE__);\r
 447 \r
 448                         // Update cache\r
 449                         if (EXT_IS_ACTIVE("cache"))\r
 450                         {\r
 451                                 if ($CACHE->cache_file("extensions", true) == true) $CACHE->cache_destroy();\r
 452                                 if ($CACHE->cache_file("config", true) == true)     $CACHE->cache_destroy();\r
 453                                 if ($CACHE->cache_file("mod_reg", true) == true)    $CACHE->cache_destroy();\r
 454                         }\r
 455 \r
 456                         // Remove array\r
 457                         unset($SQLs);\r
 458                 }\r
 459                  else\r
 460                 {\r
 461                         // In "dry-run" mode return array with SQL commands\r
 462                         return $SQLs;\r
 463                 }\r
 464         }\r
 465 }\r
 466 //\r
 467 function EXTENSION_VERBOSE_TABLE($SQLs, $title=ADMIN_SQLS_EXECUTED_ON_REMOVAL, $dashed="", $switch=false, $WIDTH="480")\r
 468 {\r
 469         global $CONFIG;\r
 470 \r
 471         $S = false; $SW = 2; $i = 1;\r
 472         $OUT = "";\r
 473         if ((is_array($SQLs)) && (GET_EXT_VERSION("sql_patches")) && ($CONFIG['verbose_sql'] == "Y"))\r
 474         {\r
 475                 $OUT  = "<DIV align=\"center\">\r
 476 <TABLE border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"".$WIDTH."\" align=\"center\"".$dashed.">\r
 477 <TR>\r
 478   <TD colspan=\"2\" align=\"center\" class=\"admin_title bottom2\" height=\"24\">\r
 479     <STRONG>".$title.":</STRONG>\r
 480   </TD>\r
 481 </TR>\n";\r
 482                 foreach ($SQLs as $idx=>$sql)\r
 483                 {\r
 484                         $sql = trim($sql);\r
 485                         if (!empty($sql))\r
 486                         {\r
 487                                 $S = true;\r
 488                                 $OUT .= "<TR>\r
 489   <TD class=\"switch_sw".(3 - $SW)." bottom2\" style=\"padding-left: 2px\" width=\"30\">".$i.".</TD>\r
 490   <TD class=\"switch_sw".(3 - $SW)." bottom2\" style=\"padding-left: 5px; padding-right: 5px\">\r
 491     ".$sql."\r
 492   </TD>\r
 493 </TR>\n";\r
 494                                 if ($switch) $SW = 3 - $SW;\r
 495                                 $i++;\r
 496                         }\r
 497                 }\r
 498         }\r
 499 \r
 500         if ((!$S) && (GET_EXT_VERSION("sql_patches")) && ($CONFIG['verbose_sql'] == "Y"))\r
 501         {\r
 502                 // No addional SQL commands to run\r
 503                 $OUT .= "<TR>\r
 504   <TD colspan=\"2\" align=\"center\" class=\"switch_sw2 bottom2\" height=\"24\">\r
 505     <FONT class=\"admin_note\">".ADMIN_NO_ADDIONAL_SQLS."</FONT>\r
 506   </TD>\r
 507 </TR>\n";\r
 508         }\r
 509 \r
 510         if (!empty($OUT)) {\r
 511                 // Add missing close-table tag\r
 512                 $OUT .= "</TABLE>\r
 513 </DIV>\n";\r
 514         }\r
 515         return $OUT;\r
 516 }\r
 517 //\r
 518 function GET_EXT_NAME($id)\r
 519 {\r
 520         $ret = "";\r
 521         global $EXTENSIONS, $CONFIG;\r
 522         if (!empty($EXTENSIONS['ext_id'][$id]))\r
 523         {\r
 524                 // Load from cache\r
 525                 $ret = $EXTENSIONS['ext_id'][$id];\r
 526 \r
 527                 // Count cache hits\r
 528                 $CONFIG['cache_hits']++;\r
 529         }\r
 530          else\r
 531         {\r
 532                 // Load from database\r
 533                 $result = SQL_QUERY_ESC("SELECT ext_name FROM "._MYSQL_PREFIX."_extensions WHERE id=%d LIMIT 1",\r
 534                  array(bigintval($id)), __FILE__, __LINE__);\r
 535                 list($ret) = SQL_FETCHROW($result);\r
 536                 SQL_FREERESULT($result);\r
 537         }\r
 538         return $ret;\r
 539 }\r
 540 //\r
 541 function GET_EXT_ID($name)\r
 542 {\r
 543         $ret = "0";\r
 544         global $EXTENSIONS, $CONFIG;\r
 545         if ((isset($EXTENSIONS['ext_id'])) && (is_array($EXTENSIONS['ext_id'])))\r
 546         {\r
 547                 // Load from cache\r
 548                 $ret = array_search($name, $EXTENSIONS['ext_id']);\r
 549 \r
 550                 // Count cache hits\r
 551                 $CONFIG['cache_hits']++;\r
 552         }\r
 553          else\r
 554         {\r
 555                 // Load from database\r
 556                 $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_extensions WHERE ext_name='%s' LIMIT 1",\r
 557                  array($name), __FILE__, __LINE__);\r
 558                 list($ret) = SQL_FETCHROW($result);\r
 559                 SQL_FREERESULT($result);\r
 560         }\r
 561         return $ret;\r
 562 }\r
 563 //\r
 564 ?>\r