function com_install() { global $database, $mainframe, $mosConfig_absolute_path; // Determine MySQL version from phpinfo $database->setQuery("SELECT VERSION() as mysql_version"); $mysqlversion = $database->loadResult(); //before we do anything else we want to check for minimum system requirements if (version_compare(phpversion(), KUNENA_MIN_PHP, ">=") && version_compare($mysqlversion, KUNENA_MIN_MYSQL, ">=")) { // we're on 4.3.0 or later //change fb menu icon $database->setQuery("SELECT id FROM #__components WHERE admin_menu_link = 'option=com_kunena'"); $id = $database->loadResult(); //add new admin menu images if (defined('_JEXEC') && class_exists('JApplication')) { // J1.5 $database->setQuery("UPDATE #__components SET admin_menu_img = 'components/com_kunena/images/kunenafavicon.png'" . ", admin_menu_link = 'option=com_kunena' " . "WHERE id='" . $id . "'"); } else { // J1.0 $database->setQuery("UPDATE #__components SET admin_menu_img = '../administrator/components/com_kunena/images/kunenafavicon.png'" . ", admin_menu_link = 'option=com_kunena' " . "WHERE id='" . $id . "'"); } $database->query() or trigger_dbwarning("Não foi possível definir imagem do menu do admin."); //install & upgrade class $fbupgrade = new fx_Upgrade("com_kunena", "kunena.install.upgrade.xml", "fb_", "install", false); // Legacy enabler // Versions prior to 1.0.5 did not came with a version table inside the database // this would make the installer believe this is a fresh install. We need to perform // a 'manual' check if this is going to be an upgrade and if so create that table // and write a dummy version entry to force an upgrade. $database->setQuery("SHOW TABLES LIKE '%fb_messages'"); $database->query() or trigger_dbwarning("Não foi possível pesquisar por tabela de mensagens."); if ($database->getNumRows()) { // fb tables exist, now lets see if we have a version table $database->setQuery("SHOW TABLES LIKE '%fb_version'"); $database->query() or trigger_dbwarning("Não foi possível pesquisar por tabela de versão."); if (!$database->getNumRows()) { //version table does not exist - this is a pre 1.0.5 install - lets create $fbupgrade->createVersionTable(); // insert dummy version entry to force upgrade $fbupgrade->insertDummyVersion(); } } // Start Installation/Upgrade $fbupgrade->doUpgrade(); // THIS PROCEDURE IS UNTRANSLATED! ?> <style> .fbscs { margin: 0; padding: 0; list-style: none; } .fbscslist { list-style: none; padding: 5px 10px; margin: 3px 0; border: 1px solid #66CC66; background: #D6FEB8; display: block; font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: #333; } .fbscslisterror { list-style: none; padding: 5px 10px; margin: 3px 0; border: 1px solid #FF9999; background: #FFCCCC; display: block; font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: #333; } </style> <div style="border: 1px solid #ccc; background: #FBFBFB; padding: 10px; text-align: left; margin: 10px 0;"> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="20%" valign="top" style="padding: 10px;"><a href="index2.php?option=com_kunena"><img src="components/com_kunena/images/kunena.logo.png" alt="Kunena" border="0"></a> <br /> <a href="http://www.joomlaclube.com.br/" target="_blank"><img src="components/com_kunena/images/jcb.logo.png" alt="Joomla Clube - brazil open source" /></a> </td> <td width="80%" valign="top" style="padding: 10px;"> <div style="clear: both; text-align: left; padding: 0 20px;"> <ul class="fbscs"> <?php // // We might want to make the file copy below part of the install as well // if (is_writable($mainframe->getCfg("absolute_path") . "/images")) { //ok now it is installed, just copy the fbfiles directory, and apply 0777 dircopy($mainframe->getCfg("absolute_path") . "/components/com_kunena/kunena.files.distribution", $mainframe->getCfg("absolute_path") . "/images/fbfiles", false); } else { ?> <li class="fbscslisterror"> <div style="border: 1px solid #FF6666; background: #FFCC99; padding: 10px; text-align: left; margin: 10px 0;"> <img src='images/publish_x.png' align='absmiddle'> Criação/configuração de permissão dos seguintes diretórios falhou: <br> <pre> <?php echo $mainframe->getCfg("absolute_path"); ?> /images/fbfiles/ <?php echo $mainframe->getCfg("absolute_path"); ?> /images/fbfiles/avatars <?php echo $mainframe->getCfg("absolute_path"); ?> /images/fbfiles/avatars/gallery (você tem que colocar avatares aqui dentro se quiser usá-los) <?php echo $mainframe->getCfg("absolute_path"); ?> /images/fbfiles/category_images <?php echo $mainframe->getCfg("absolute_path"); ?> /images/fbfiles/files <?php echo $mainframe->getCfg("absolute_path"); ?> /images/fbfiles/images </pre> a) Você pode copiar o conteúdo de '_kunena.files.distribution' em 'componentes/com_kunena' para a raiz do seu Joomla, sob a pasta 'images/'. <br /> b) Se você já tem o conteúdo lá, mas a instalação do Kunena não foi capaz de torná-los graváveis e, então por favor, faça-o manualmente.</div> </li> <?php } ?> </ul> </div> <div style="border: 1px solid #FFCC99; background: #FFFFCC; padding: 20px; margin: 20px; clear: both;"> <strong>I N S T A L A Ç Ã O : <font color="green">Sucesso</font> </strong> <br /> <br /> <strong>versão do php: <font color="green"><?php echo phpversion(); ?> Requerida >= <?php echo KUNENA_MIN_PHP; ?> </font> </strong> <br /> <strong>versão do mysql: <font color="green"><?php echo $mysqlversion; ?> Requerida >= <?php echo KUNENA_MIN_MYSQL; ?> </font> </strong> </div> <?php } else { // Minimum version requirements not satisfied ?> <style> .fbscs { margin: 0; padding: 0; list-style: none; } .fbscslist { list-style: none; padding: 5px 10px; margin: 3px 0; border: 1px solid #66CC66; background: #D6FEB8; display: block; font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: #333; } .fbscslisterror { list-style: none; padding: 5px 10px; margin: 3px 0; border: 1px solid #FF9999; background: #FFCCCC; display: block; font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: #333; } </style> <div style="border: 1px solid #ccc; background: #FBFBFB; padding: 10px; text-align: left; margin: 10px 0;"> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="20%" valign="top" style="padding: 10px;"><a href="index2.php?option=com_kunena"><img src="components/com_kunena/images/kunena.logo.png" alt="Kunena" border="0"></a> <br /> <a href="http://www.joomlaclube.com.br/" target="_blank"><img src="components/com_kunena/images/jcb.logo.png" alt="Joomla Clube - brazil open source" /></a> </td> <td width="80%" valign="top" style="padding: 10px;"> <div style="border: 1px solid #FFCC99; background: #FFFFCC; padding: 20px; margin: 20px; clear: both;"> <strong>I N S T A L A Ç Ã O : <font color="red">F A L H O U - Requisitos Mínimos da Versão não satisfeitos</font> </strong> <br /> <br /> <strong>versão do php: <font color="red"><?php echo phpversion(); ?> Requerida >= <?php echo KUNENA_MIN_PHP; ?> </font> </strong> <br /> <strong>versão do mysql: <font color="red"><?php echo $mysqlversion; ?> Requerida >= <?php echo KUNENA_MIN_MYSQL; ?> </font> </strong> </div> <?php } // Rest of footer ?> <div style="border: 1px solid #99CCFF; background: #D9D9FF; padding: 20px; margin: 20px; clear: both;"> <strong>Obrigado por usar Kunena!</strong> <br /> Kunena Forum Component <em>para Joomla! </em> © by <a href="http://www.Kunena.com" target="_blank">www.Kunena.com</a>. Todos os direitos reservados.</div> <div style="border: 1px solid #ccc; background: #eee; padding: 20px; margin: 20px; clear: both;"> <a href="http://www.joomlaclube.com.br/" target="_blank"><span style="color:#00adbc;">joomla</span><span style="color:#636363">clube</span></a> <span style="color:#aaa">brazil open source</span> </div> </td> </tr> </table> </div> <?php }
function com_install() { $kunena_db = JFactory::getDBO(); // Determine MySQL version from phpinfo $kunena_db->setQuery("SELECT VERSION() as mysql_version"); $mysqlversion = $kunena_db->loadResult(); //before we do anything else we want to check for minimum system requirements if (version_compare(phpversion(), KUNENA_MIN_PHP, ">=") && version_compare($mysqlversion, KUNENA_MIN_MYSQL, ">")) { //change fb menu icon $kunena_db->setQuery("SELECT id FROM #__components WHERE admin_menu_link = 'option=com_kunena'"); $id = $kunena_db->loadResult(); //add new admin menu images $kunena_db->setQuery("UPDATE #__components SET admin_menu_img = 'components/com_kunena/images/kunenafavicon.png'" . ", admin_menu_link = 'option=com_kunena' " . "WHERE id='" . $id . "'"); $kunena_db->query() or trigger_dbwarning("Unable to set admin menu image."); //install & upgrade class $fbupgrade = new fx_Upgrade("com_kunena", "kunena.install.upgrade.xml", "fb_", "install", false); // Legacy enabler // Versions prior to 1.0.5 did not came with a version table inside the database // this would make the installer believe this is a fresh install. We need to perform // a 'manual' check if this is going to be an upgrade and if so create that table // and write a dummy version entry to force an upgrade. $kunena_db->setQuery("SHOW TABLES LIKE '%fb_messages'"); $kunena_db->query() or trigger_dbwarning("Unable to search for messages table."); if ($kunena_db->getNumRows()) { // fb tables exist, now lets see if we have a version table $kunena_db->setQuery("SHOW TABLES LIKE '%fb_version'"); $kunena_db->query() or trigger_dbwarning("Unable to search for version table."); if (!$kunena_db->getNumRows()) { //version table does not exist - this is a pre 1.0.5 install - lets create $fbupgrade->createVersionTable(); // insert dummy version entry to force upgrade $fbupgrade->insertDummyVersion(); } } // Start Installation/Upgrade $fbupgrade->doUpgrade(); // THIS PROCEDURE IS UNTRANSLATED! ?> <style> .fbscs { margin: 0; padding: 0; list-style: none; } .fbscslist { list-style: none; padding: 5px 10px; margin: 3px 0; border: 1px solid #66CC66; background: #D6FEB8; display: block; font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: #333; } .fbscslisterror { list-style: none; padding: 5px 10px; margin: 3px 0; border: 1px solid #FF9999; background: #FFCCCC; display: block; font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: #333; } </style> <div style="border: 1px solid #ccc; background: #FBFBFB; padding: 10px; text-align: left; margin: 10px 0;"> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="20%" valign="top" style="padding: 10px;"><a href="index2.php?option=com_kunena"><img src="components/com_kunena/images/kunena.logo.png" alt="Kunena" border="0"></a></td> <td width="80%" valign="top" style="padding: 10px;"> <div style="clear: both; text-align: left; padding: 0 20px;"> <ul class="fbscs"> <?php // // We might want to make the file copy below part of the install as well // jimport('joomla.filesystem.folder'); $ret = JFolder::copy(JPATH_ROOT . DS . "components" . DS . "com_kunena" . DS . "kunena.files.distribution", JPATH_ROOT . DS . "images" . DS . "fbfiles", '', true); if ($ret !== true) { ?> <li class="fbscslisterror"> <div style="border: 1px solid #FF6666; background: #FFCC99; padding: 10px; text-align: left; margin: 10px 0;"> <img src='images/publish_x.png' align='absmiddle' /> Creation/permission setting of the following directories failed: <br /> <pre> <?php echo JPATH_ROOT; ?> /images/fbfiles/ <?php echo JPATH_ROOT; ?> /images/fbfiles/avatars <?php echo JPATH_ROOT; ?> /images/fbfiles/avatars/gallery (you have to put avatars inside if you want to use it) <?php echo JPATH_ROOT; ?> /images/fbfiles/category_images <?php echo JPATH_ROOT; ?> /images/fbfiles/files <?php echo JPATH_ROOT; ?> /images/fbfiles/images </pre> a) You can copy the contents of _kunena.files.distribution under components/com_kunena to your Joomla root, under images/ folder. <br /> b) If you already have the contents there, but Kunena installation was not able to make them writable, then please do it manually.</div> </li> <?php } ?> </ul> </div> <div style="border: 1px solid #FFCC99; background: #FFFFCC; padding: 20px; margin: 20px; clear: both;"> <strong>I N S T A L L : <font color="green">Successful</font> </strong> <br /> <br /> <strong>php version: <font color="green"><?php echo phpversion(); ?> </font> (Required >= <?php echo KUNENA_MIN_PHP; ?> )</strong> <br /> <strong>mysql version: <font color="green"><?php echo $mysqlversion; ?> </font> (Required > <?php echo KUNENA_MIN_MYSQL; ?> )</strong> </div> <?php } else { // Minimum version requirements not satisfied ?> <style> .fbscs { margin: 0; padding: 0; list-style: none; } .fbscslist { list-style: none; padding: 5px 10px; margin: 3px 0; border: 1px solid #66CC66; background: #D6FEB8; display: block; font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: #333; } .fbscslisterror { list-style: none; padding: 5px 10px; margin: 3px 0; border: 1px solid #FF9999; background: #FFCCCC; display: block; font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: #333; } </style> <div style="border: 1px solid #ccc; background: #FBFBFB; padding: 10px; text-align: left; margin: 10px 0;"> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="20%" valign="top" style="padding: 10px;"><a href="index2.php?option=com_kunena"><img src="components/com_kunena/images/kunena.logo.png" alt="Kunena" border="0"></a></td> <td width="80%" valign="top" style="padding: 10px;"> <div style="border: 1px solid #FFCC99; background: #FFFFCC; padding: 20px; margin: 20px; clear: both;"> <strong>I N S T A L L : <font color="red">F A I L E D - Minimum Version Requirements not satisfied</font> </strong> <br /> <br /> <strong>php version: <font color="<?php echo version_compare(phpversion(), KUNENA_MIN_PHP, '>=') ? 'green' : 'red'; ?> "><?php echo phpversion(); ?> </font> (Required >= <?php echo KUNENA_MIN_PHP; ?> )</strong> <br /> <strong>mysql version: <font color="<?php echo version_compare($mysqlversion, KUNENA_MIN_MYSQL, '>') ? 'green' : 'red'; ?> "><?php echo $mysqlversion; ?> </font> (Required > <?php echo KUNENA_MIN_MYSQL; ?> )</strong> </div> <?php } // Rest of footer ?> <div style="border: 1px solid #99CCFF; background: #D9D9FF; padding: 20px; margin: 20px; clear: both;"> <strong>Thank you for using Kunena!</strong> <br /> Kunena Forum Component <em>for Joomla! </em> © by <a href="http://www.Kunena.com" target="_blank">www.Kunena.com</a>. All rights reserved.</div> </td> </tr> </table> </div> <?php }