Форум пользователей MySQL

<?php defined('_VALID_MOS') or die('Direct Access to this location is not allowed.');

/*
 * Copyright © 2008 Compojoom.com. All rights reserved.
 * Copyright Copyright © 2007 Alain Georgette. All rights reserved.
 * Copyright Copyright © 2006 Frantisek Hliva. All rights reserved.
 * License <a href="http://www.gnu.org/copyleft/gpl.html">http://www.gnu.org/copyleft/gpl.html</a> GNU/GPL, see LICENSE.php
 *
 * !JoomlaComment 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.
 *
 * !JoomlaComment 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., 51 Franklin Street, Fifth Floor, Boston,
 * MA  02110-1301, USA.
 */

function com_install()
{
    global $mosConfig_absolute_path, $mosConfig_live_site, $database;

    /*
      * set the release compatibility
    */
    if (!defined('_JOSC_J10') && !defined('_JOSC_J15')) {
        if (version_compare($GLOBALS['_VERSION']->RELEASE, '1.5', '>='))
            DEFINE('_JOSC_J15', true);
        else
            DEFINE('_JOSC_J10', true);
    }

    if (defined('_JOSC_J15'))
        $mambots = 'plugins';
    else
        $mambots = 'mambots';    
       
    $adminDir = dirname(__FILE__);
    require_once("$mosConfig_absolute_path/administrator/components/com_comment/library.comment.php");
    require_once("$mosConfig_absolute_path/components/com_comment/joscomment/utils.php");
    require_once("$mosConfig_absolute_path/administrator/components/com_comment/class.config.comment.php");
?>
    <table class="adminheading" cellpadding="4" cellspacing="0" border="0">
      <tr>
        <td>
<?php
    $msgstart = "<h2><p style='color:red;'>There was a problem with your installation</p></h2>";
    $msgend = "<h2>Please, contact the <a target=\"_blank\" href=\"http://joomlacode.org/gf/project/joomagecomment\">support</a>."
            . "<br/>Thanks.</h2>";

    if (!JOSC_TableUtils::existsTable('#__comment')) {
        /* one day, when param will be in database we could set here or not complete_uninstall param */
    }
       
    /*
     * check mambot path is writable
     */      
    if (!is_writable("$mosConfig_absolute_path/$mambots/content/")) {
        $msgend = "<h2><p>Please:</p>" .
                "<ul>" .
                "    <li>Uninstall !JoomlaComment</li>" .
                "    <li>Modify the file permissions if needed</li>" .
                "    <li>Reinstall</li>" .
                "</ul>" .
                "<br/>Thanks.</p>" .
                "</h2>";
        echo $msgstart . "<p>The directory \"$mosConfig_absolute_path/$mambots/content/\" is not writeable</p>". $msgend;
        return false;
    }

    $install_log = "";
    if (!JOSC_install::checkDatabase($install_log)) {
        echo $msgstart ."<p>". $install_log ."</p>". $msgend;
        return false;
    }

    $install_log = "<p>Installation of joscomment & josccacheclean bots</p>";
    /* joscomment.php */
    $movefrom     = $adminDir."/plugin/joscomment.php";
    $moveto        = "$mosConfig_absolute_path/$mambots/content/joscomment.php";
    if (!@rename($movefrom, $moveto)) {
        echo $msgstart."<p style='color:red;'><b>error when moving</b> $movefrom <br /><b>TO</b> $moveto</p>".$msgend;
        $msgstart = $msgend = "";
    }
    /* joscomment.xml */
    $movefrom     = $adminDir."/plugin/joscomment.xml";
    $moveto        = "$mosConfig_absolute_path/$mambots/content/joscomment.xml";
    if (!@rename($movefrom, $moveto)) {
        echo $msgstart."<p style='color:red;'><b>error when moving</b> $movefrom <br /><b>TO</b> $moveto</p>".$msgend;
        $msgstart = $msgend = "";
    }
    /* josccleancache.php */
    $movefrom     = $adminDir."/plugin/josccleancache.php";
    $moveto        = "$mosConfig_absolute_path/$mambots/system/josccleancache.php";
    if (!@rename($movefrom, $moveto)) {
        echo $msgstart."<p style='color:red;'><b>error when moving</b> $movefrom <br /><b>TO</b> $moveto</p>".$msgend;
        $msgstart = $msgend = "";
    }
    /* josccleancache.xml */
    $movefrom     = $adminDir."/plugin/josccleancache.xml";
    $moveto        = "$mosConfig_absolute_path/$mambots/system/josccleancache.xml";
    if (!@rename($movefrom, $moveto)) {
        echo $msgstart."<p><b>error when moving</b> $movefrom <br /><b>TO</b> $moveto</p>".$msgend;
        $msgstart = $msgend = "";
    }

    /*
     * joscomment
     */
     /*
      * better to place after pagebreak
      */
    $database->setQuery("SELECT ordering"
            . "\n FROM #__$mambots"
            . "\n WHERE element LIKE 'pagebreak'"
            . "\n AND folder = 'content'"
            );
    $ordering = (int) $database->loadResult();
    $database->setQuery("SELECT COUNT(*)"
            . "\n FROM #__$mambots"
            . "\n WHERE element LIKE 'joscomment%'"
            . "\n AND folder = 'content'"
            . "\n AND published = 1 ");        
    $total = $database->loadResult();
    $published = $total ? '0' : '1'; // if joscomment% (example : joscomment_expert bot ) exists and published : do not publish
    $ordering++;
    $database->setQuery(  "INSERT INTO `#__$mambots` "
                        . "        (`name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) "
                        . " VALUES ('Content - !JoomlaComment', 'joscomment', 'content', 0, ".$ordering.", ".$published.", 0, 0, 0, '0000-00-00 00:00:00', '');");
    $result = $database->query();
    if($result) {
        /*
         * josccleancache
          */    
         $ordering = 0;
         if (defined('_JOSC_J15')) {
              /*
               * get legacy place and if published
               * (normally should be published because it is obligatory to install joomlacomment 3.25)
               */
            $database->setQuery("SELECT ordering"
                    . "\n FROM #__$mambots"
                    . "\n WHERE element LIKE 'legacy'"
                    . "\n AND folder = 'system'"
                    . "\n AND published = 1 "        
                    );
            $ordering = (int) $database->loadResult();
         }
        $database->setQuery("SELECT COUNT(*)"
                . "\n FROM #__$mambots"
                . "\n WHERE element LIKE 'josccleancache%'"
                . "\n AND folder = 'system'"
                . "\n AND published = 1 ");        
        $total = $database->loadResult();
        $published = ($total || (defined('_JOSC_J15') && $ordering<1)) ? '0' : '1'; // if joscomment% (example : joscomment_expert bot ) exists and published : do not publish
        $ordering++;
        $database->setQuery(  "INSERT INTO `#__$mambots` "
                            . "        (`name`,               `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) "
                            . " VALUES ('System - !JoomlaComment CleanCache', 'josccleancache', 'system', 0, ".$ordering.", ".$published.", 0, 0, 0, '0000-00-00 00:00:00', '');");
        $result = $database->query();
    }
    if(!$result) {
        $install_log .= "$mambots install error: " . $database->stderr() . "<br /><br />";
        echo $msgstart ."<p>". $install_log ."</p>". $msgend;
        return false;
    }  

   //add new admin menu images
    $database->setQuery("UPDATE #__components SET admin_menu_img='../components/com_comment/joscomment/images/logoicon.png' " .
                        "  WHERE admin_menu_link='option=com_comment'");
    $database->query();

    $database->setQuery("UPDATE #__components SET admin_menu_img='../includes/js/ThemeOffice/edit.png' " .
                        "  WHERE admin_menu_link='option=com_comment&task=comments'");
    $database->query();

    $database->setQuery("UPDATE #__components SET admin_menu_img='../includes/js/ThemeOffice/config.png' " .
                        "  WHERE admin_menu_link='option=com_comment&task=settingssimple'");
    $database->query();

    $database->setQuery("UPDATE #__components SET admin_menu_img='../includes/js/ThemeOffice/config.png' " .
                        "  WHERE admin_menu_link='option=com_comment&task=settings'");
    $database->query();

    $database->setQuery("UPDATE #__components SET admin_menu_img='../includes/js/ThemeOffice/config.png' " .
                        "  WHERE admin_menu_link='option=com_comment&task=settingsexpert'");
    $database->query();

    $database->setQuery("UPDATE #__components SET admin_menu_img='../includes/js/ThemeOffice/controlpanel.png' " .
                        "  WHERE admin_menu_link='option=com_comment&task=importcomment'");
    $database->query();

    $database->setQuery("UPDATE #__components SET admin_menu_img='../includes/js/ThemeOffice/credits.png' " .
                        "   WHERE admin_menu_link='option=com_comment&task=about'");
    $database->query();
?>
       </td>
      </tr>
      </table>
<?php
   
    JOSC_library::viewAbout();
}
?>