]> git.mxchange.org Git - mailer.git/blobdiff - inc/modules/admin/what-extensions.php
Another column fix
[mailer.git] / inc / modules / admin / what-extensions.php
index eb6079c2e06c4ed2dd22f4c96a89cd39d3ff6996..9f3a1896fd1f1f37f1d9dfa7cb0ca76a7b674a57 100644 (file)
@@ -32,7 +32,7 @@
  ************************************************************************/
 
 // Some security stuff...
-if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) || (!IS_ADMIN())) {
+if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
        $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
        require($INC);
 }
@@ -44,7 +44,7 @@ global $cacheInstance, $cacheArray, $cacheMode;
 
 // Normally we want the overview of all registered extensions
 $do = "overview";
-$SEL = "0";
+$SEL = 0;
 if (!empty($_POST['sel'])) $SEL = SELECTION_COUNT($_POST['sel']);
 
 if (!empty($_GET['reg_ext'])) {
@@ -53,7 +53,7 @@ if (!empty($_GET['reg_ext'])) {
        // The ID comes from task management and it is - of course - *not* the extension's name!
 } elseif ((isset($_POST['change'])) && ($SEL > 0) && (!IS_DEMO())) {
        // De-/activate extensions
-       foreach ($_POST['sel'] as $id=>$active) {
+       foreach ($_POST['sel'] as $id => $active) {
                // Shall we keep the extension always active?
                if ((isset($cacheArray['active_extensions'][GET_EXT_NAME($id)])) && ($cacheArray['active_extensions'][GET_EXT_NAME($id)] == "Y") && ($active == "N")) {
                        // Keep this extension active!
@@ -61,7 +61,7 @@ if (!empty($_GET['reg_ext'])) {
                        // De/activate extension
                        $ACT = "N"; $EXT_LOAD_MODE = "deactivate";
                        if ($active == "N") { $ACT = "Y"; $EXT_LOAD_MODE = "activate"; }
-                       $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_extensions SET ext_active='".$ACT."' WHERE id=%d AND ext_active='%s' LIMIT 1",
+                       $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_extensions SET ext_active='".$ACT."' WHERE id=%s AND ext_active='%s' LIMIT 1",
                         array(bigintval($id), $active), __FILE__, __LINE__);
 
                        // Run embeded SQL commands
@@ -72,8 +72,8 @@ if (!empty($_GET['reg_ext'])) {
        // Change settings like CSS file load
        if (isset($_POST['modify'])) {
                // Change entries
-               $cacheInstance_UPDATE = "0";
-               foreach ($_POST['sel'] as $id=>$sel) {
+               $cache_update = 0;
+               foreach ($_POST['sel'] as $id => $sel) {
                        // Secure ID
                        $id = bigintval($id);
 
@@ -83,11 +83,11 @@ if (!empty($_GET['reg_ext'])) {
                                $active = $_POST['active'][$id];
                                if (GET_EXT_VERSION("sql_patches") >= "0.0.6")  {
                                        // Update also CSS column when extensions sql_patches is newer or exact v0.0.6
-                                       $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_extensions SET ext_has_css='%s', ext_active='%s' WHERE id=%d LIMIT 1",
+                                       $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_extensions SET ext_has_css='%s', ext_active='%s' WHERE id=%s LIMIT 1",
                                         array($_POST['css'][$id], $active, $id), __FILE__, __LINE__);
                                } else {
                                        // When extension is older than v0.0.6 there is no column for the CSS information
-                                       $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_extensions SET ext_active='%s' WHERE id=%d LIMIT 1",
+                                       $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_extensions SET ext_active='%s' WHERE id=%s LIMIT 1",
                                         array($active, $id), __FILE__, __LINE__);
                                }
 
@@ -109,17 +109,17 @@ if (!empty($_GET['reg_ext'])) {
        } else {
                // Edit selected entries
                $SW = "2"; $OUT = "";
-               foreach ($_POST['sel'] as $id=>$sel) {
+               foreach ($_POST['sel'] as $id => $sel) {
                        // Edit this extension?
                        if (($sel == "Y") || ($sel == "N")) {
                                // Load required data
                                if (GET_EXT_VERSION("sql_patches") >= "0.0.6") {
-                                       $result = SQL_QUERY_ESC("SELECT ext_name, ext_has_css, ext_active FROM "._MYSQL_PREFIX."_extensions WHERE id=%d LIMIT 1",
+                                       $result = SQL_QUERY_ESC("SELECT ext_name, ext_has_css, ext_active FROM "._MYSQL_PREFIX."_extensions WHERE id=%s LIMIT 1",
                                         array(bigintval($id)), __FILE__, __LINE__);
                                        list($name, $css, $active) = SQL_FETCHROW($result);
                                        SQL_FREERESULT($result);
                                } else {
-                                       $result = SQL_QUERY_ESC("SELECT ext_name, ext_active FROM "._MYSQL_PREFIX."_extensions WHERE id=%d LIMIT 1",
+                                       $result = SQL_QUERY_ESC("SELECT ext_name, ext_active FROM "._MYSQL_PREFIX."_extensions WHERE id=%s LIMIT 1",
                                         array(bigintval($id)), __FILE__, __LINE__);
                                        list($name, $active) = SQL_FETCHROW($result);
                                        SQL_FREERESULT($result);
@@ -153,7 +153,7 @@ if (!empty($_GET['reg_ext'])) {
 } elseif ((isset($_POST['delete'])) && ($SEL > 0) && (!IS_DEMO())) {
        // List extensions and when verbose is enabled SQL statements which will be executed
        $SW = 2; $OUT = "";
-       foreach ($_POST['sel'] as $id=>$sel) {
+       foreach ($_POST['sel'] as $id => $sel) {
                // Init variables
                $VERBOSE_OUT = ""; $SQLs = array();
 
@@ -164,17 +164,18 @@ if (!empty($_GET['reg_ext'])) {
                $ext_name = GET_EXT_NAME($id);
                $ext_ver = GET_EXT_VERSION($ext_name);
 
-               // Free the result
-               SQL_FREERESULT($result);
-
                if ($_CONFIG['verbose_sql']) {
                        // Load SQL commands in remove mode
                        $EXT_LOAD_MODE = "remove";
+                       $EXT_ALWAYS_ACTIVE = "N";
                        $file = sprintf("%sinc/extensions/ext-%s.php", PATH, $ext_name);
-                       include($file);
+                       if (FILE_READABLE($file)) {
+                               // Load file
+                               include($file);
 
-                       // Generate extra table with loaded SQL commands
-                       $VERBOSE_OUT = EXTENSION_VERBOSE_TABLE($SQLs);
+                               // Generate extra table with loaded SQL commands
+                               $VERBOSE_OUT = EXTENSION_VERBOSE_TABLE($SQLs);
+                       }
                } // END - if
 
                // Prepare data for the row template
@@ -197,8 +198,8 @@ if (!empty($_GET['reg_ext'])) {
        $do = "delete";
 } elseif ((isset($_POST['remove'])) && ($SEL > 0) && (!IS_DEMO())) {
        // Remove extensions from DB (you have to delete all files manually!)
-       $cacheInstance_UPDATE = "0";
-       foreach ($_POST['sel'] as $id=>$active) {
+       $cache_update = 0;
+       foreach ($_POST['sel'] as $id => $active) {
                // Secure ID number
                $id = bigintval($id);
 
@@ -206,10 +207,6 @@ if (!empty($_GET['reg_ext'])) {
                if ($active == 1) {
                        // Run embeded SQL commands
                        EXTENSION_RUN_SQLS($id, "remove");
-
-                       // Delete this extension (remember to remove it from your server *before* you click on welcome!
-                       $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_extensions WHERE id=%d LIMIT 1",
-                        array($id), __FILE__, __LINE__);
                } // END - if
        } // END - foreach
 } elseif (!empty($_GET['do']) && (!IS_DEMO())) {
@@ -280,8 +277,6 @@ case "overview": // List all registered extensions
                // No extensions are registered
                LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_NO_EXTENSION_REGISTERED."</FONT>");
        }
-       // Link for checking for new or updated extensions
-       OUTPUT_HTML("<br /><A href=\"".URL."/modules.php?module=admin&amp;what=extensions&amp;do=search\">".ADMIN_SEARCH_NEW_EXTENSIONS."</A>");
        break;
 
 case "register": // Register new extension
@@ -295,13 +290,13 @@ case "register": // Register new extension
        // Is the ID number valid and the task was found?
        if (($id > 0) && ($task_found == 1)) {
                // ID is valid so begin with registration, we first want to it's real name from task management (subject column)
-               $result = SQL_QUERY_ESC("SELECT subject FROM "._MYSQL_PREFIX."_task_system WHERE id=%d LIMIT 1",
+               $result = SQL_QUERY_ESC("SELECT subject FROM "._MYSQL_PREFIX."_task_system WHERE id=%s LIMIT 1",
                 array(bigintval($id)), __FILE__, __LINE__);
                list($subj) = SQL_FETCHROW($result);
                SQL_FREERESULT($result);
 
                // Disable cache update by default
-               $cacheInstance_UPDATE = "0";
+               $cache_update = 0;
                if (!empty($subj)) {
                        // Extract extension's name from subject...
                        $ext_name = trim(substr($subj, 1, strpos($subj, ":") - 1));
@@ -309,20 +304,19 @@ case "register": // Register new extension
                        // ... so we can finally register and load it in registration mode
                        $status = EXTENSION_REGISTER($ext_name, $id);
                        if ($status == true) {
-                               // Is this sql_patches? Then we need to auto-logout!
-                               if ($ext_name == "sql_patches") {
-                                       // Auto-logout here
-                                       LOAD_URL("modules.php?module=admin&logout=1&install=sql_patches");
-                               }
-
                                // Extension was found and successfully registered
                                LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_EXTENSION_REGISTERED);
 
                                // Do we need to update cache file?
                                if ((EXT_IS_ACTIVE("cache")) && ($cacheMode != "no")) {
                                        // Remove cache file (will be auto-created again!)
+                                       if ($cacheInstance->cache_file("config"    , true)) $cacheInstance->cache_destroy();
                                        if ($cacheInstance->cache_file("extensions", true)) $cacheInstance->cache_destroy();
-                               }
+                                       if ($cacheInstance->cache_file("mod_reg"   , true)) $cacheInstance->cache_destroy();
+                               } // END - if
+                       } elseif (GET_EXT_VERSION($ext_name) != "") {
+                               // Motify the admin that we have a problem here...
+                               LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_REG_FAILED_ALREADY);
                        } else {
                                // Motify the admin that we have a problem here...
                                LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_REG_FAILED_404);
@@ -340,126 +334,6 @@ case "register": // Register new extension
        }
        break;
 
-case "search": // Search for new extensions on our server
-       // Get response from our server
-       $response = MXCHANGE_OPEN("extensions.php");
-
-       // Are extensions found?
-       if (($response[sizeof($response) - 1] == "[EOF]") && ($response[0] != "[EOF]"))
-       {
-               // Ok, mark found and create the array
-               $EXT_SEARCH = array(
-                       'fname'  => array(), // File names
-                       'fsize'  => array(), // File size
-                       'fctime' => array(), // File creation timestamp
-                       'infos'  => array(), // File informations (maybe loaded!)
-                       'ver'    => array(), // Version number
-                       'cver'   => array(), // Current version number
-               );
-
-               // Get count of extensions for validation
-               $count = trim($response[sizeof($response) - 2]);
-               foreach ($response as $id=>$value)
-               {
-                       $value = str_replace("\n", "", $value); $ver = "";
-                       // Leave loop when data is invalid or EOF?
-                       if ((substr($value, 0, 4) == "ext-") && (substr($value, -4) == ".zip"))
-                       {
-                               $name = substr($value, 4, -4);
-                               $file = sprintf("%sinc/extensions/ext-%s.php", PATH, $name);
-                               $ver = trim(substr($response[$id + 3], 4));
-
-                               // Load current extension's version
-                               $cver = GET_EXT_VERSION($name);
-                               if (empty($cver)) $cver = "-.-";
-
-                               // Is the extension already installed or not?
-                               if (!file_exists($file) || ($ver != $cver))
-                               {
-                                       // No, it isn't. So let's add this one!
-                                       $EXT_SEARCH['fname'][]  = $name;
-                                       $EXT_SEARCH['fsize'][]  = $response[$id + 1];
-                                       $EXT_SEARCH['fctime'][] = $response[$id + 2];
-                                       $EXT_SEARCH['ver'][]    = $ver;
-                                       $EXT_SEARCH['cver'][]   = $cver;
-
-                                       $LANG_DUMMY = explode("[nl]", $response[$id + 4]);
-                                       $LANG = array();
-                                       $INFO = ADMIN_EXT_NO_INFO_FOUND;
-
-                                       // Trim every data line
-                                       foreach ($LANG_DUMMY as $k=>$v)
-                                       {
-                                               $v = trim($v);
-                                               if (substr($v, 3) == "") $v = "---";
-                                               $LANG_DUMMY[$k] = $v;
-                                               if ($v == "xx:xx") break;
-                                               $LANG[] = $v;
-                                       }
-
-                                       // If language is found stop searching on matching line
-                                       foreach($LANG as $search)
-                                       {
-                                               if (substr($search, 0, 3) == (GET_LANGUAGE().":")) { $INFO = substr($search, 3); break; }
-                                       }
-
-                                       // Add informations to array
-                                       $EXT_SEARCH['infos'][] = $INFO;
-                               }
-                       }
-               }
-
-               // Ok, extensions are on our server but maybe you have already installed them?
-               if (sizeof($EXT_SEARCH['fname']) > 0)
-               {
-                       // Sort array (I missed ver and cver here)
-                       array_pk_sort($EXT_SEARCH, array("cver", "fname"), 0, 1);
-
-                       // Extensions where found which are not downloaded and installed
-                       $SW = 2; $OUT = ""; $TSIZE = 0;
-                       foreach ($EXT_SEARCH['fname'] as $id=>$name)
-                       {
-                               // Generate download link
-                               $LINK = SERVER_URL."/extensions/ext-".$name.".zip";
-
-                               // Prepare data for the row template
-                               $content = array(
-                                       'sw'      => $SW,
-                                       'id'      => ($id + 1),
-                                       'name'    => $name,
-                                       'new_ver' => $EXT_SEARCH['ver'][$id],
-                                       'old_ver' => $EXT_SEARCH['cver'][$id],
-                                       'link'    => $LINK,
-                                       'last'    => MAKE_DATETIME($EXT_SEARCH['fctime'][$id], "2"),
-                                       'size'    => TRANSLATE_COMMA(round($EXT_SEARCH['fsize'][$id] / 1.024) / 1000),
-                                       'info'    => $EXT_SEARCH['infos'][$id],
-                               );
-
-                               // Load row template add current size to total size and switch color
-                               $OUT .= LOAD_TEMPLATE("admin_list_extensions_row", true, $content);
-                               $TSIZE += $EXT_SEARCH['fsize'][$id];
-                               $SW = 3 - $SW;
-                       }
-                       define('__EXTENSIONS_ROWS', $OUT);
-                       define('__TKBYTES_VALUE', TRANSLATE_COMMA(round($TSIZE / 1.024) / 1000));
-                       define('__TEXT_VALUE', sizeof($EXT_SEARCH['fname']));
-
-                       // Load template
-                       LOAD_TEMPLATE("admin_list_extensions");
-               }
-                else
-               {
-                       // All extensions are downloaded and installed
-                       LOAD_TEMPLATE("admin_extensions_installed", false, $count);
-               }
-       }
-        else
-       {
-               // No extensions where found
-               LOAD_TEMPLATE("admin_extensions_404");
-       }
-       break;
-
 case "demo":
        LOAD_TEMPLATE("admin_settings_saved", false, SETTINGS_NOT_SAVED);
        break;