Ejemplos de fx_Upgrade en PHP

Lenguaje de programación: PHP

Clase / Tipo: fx_Upgrade

Ejemplos en hotexamples.com: 2

PHP fx_Upgrade - 2 ejemplos encontrados. Estos son los ejemplos en PHP del mundo real mejor valorados de fx_Upgrade extraídos de proyectos de código abierto. Puedes valorar ejemplos para ayudarnos a mejorar la calidad de los ejemplos.

Métodos usados con frecuencia

Mostrar Ocultar

createVersionTable(2)

doUpgrade(2)

insertDummyVersion(2)

Ejemplo n.º 1

Mostrar archivo

Archivo: kunena.install.php Proyecto: kaantunc/MYK-BOR

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();
        check_dberror("Unable to find component.");
        //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();
        check_dbwarning("Unable to set admin menu image.");
        //install & upgrade class
        $fbupgrade = new fx_Upgrade("com_kunena", "kunena.install.upgrade.xml", "fb_", "install", false);
        // 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="index.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 &gt;= <?php 
        echo KUNENA_MIN_PHP;
        ?>
)</strong>
		<br />
		<strong>mysql version: <font color="green"><?php 
        echo $mysqlversion;
        ?>
</font> (Required &gt; <?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="index.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 &gt;= <?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 &gt; <?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> &copy; by <a
			href="http://www.Kunena.com" target="_blank">www.Kunena.com</a>.
		All rights reserved.</div>
		</td>
	</tr>
</table>
</div>
	<?php 
}

Ejemplo n.º 2

Mostrar archivo

Archivo: kunena.install.php Proyecto: patricmutwiri/joomlaclube

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> &copy; 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 
}