Esempio n. 1
0
 function dropVersionTable()
 {
     $kunena_db =& JFactory::getDBO();
     $kunena_db->setQuery("DROP TABLE IF EXISTS `{$this->versionTable}`;");
     $kunena_db->query();
     check_dbwarning('Unable to drop version table.');
 }
Esempio n. 2
0
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 
}