function check_version()
{
global $db;
// check to see that all tables are present
install_db();
// load version number from db
$config = $db->Execute('select db_version from ' . DB_PREFIX . 'zh_config');
$db_version = $config->fields['db_version'];
$config_file = file(DOC_REL_PATH . '/' . VERSION_FILENAME);
if (is_array($config_file)) {
foreach ($config_file as $line) {
if (substr(trim($line), 0, 7) == 'version') {
$file_version = trim(substr($line, strpos($line, '=') + 1, strpos($line, ';') - strpos($line, '=') - 1));
break;
}
}
} else {
die(TEXT_NO_VERSION . VERSION_FILENAME . '<br />' . TEXT_CHECK_CONFIG);
}
//echo 'db_version='.$db_version.' and file_version='.$file_version.'<br />';
if ($db_version != $file_version) {
synchronize($file_version);
}
return;
}
} require 'header.php'; require HOME . '_inc/function/defaults.php'; require HOME . 'install/install-core.php'; /** * connect to mysql database */ $connect = mysql_connect($_SESSION['db']['host'], $_SESSION['db']['user'], $_SESSION['db']['pass']); $select = mysql_select_db($_SESSION['db']['name'], $connect); /** * run install, variables below * are used for sharing of information * between install functions */ $constants = array(); $settings = array(); $hash = md5(mt_rand()); $user_id = 0; install_settings(); install_db(); install_dirs(); install_email(); echo ' <h1>Complete! Verification Email Sent to ' . $_SESSION['user']['email'] . '</h1> <p>Your Furasta CMS installation has been performed successfully. A user verification email has been sent to your email address. You must verify this address before you can log in. Please now finish and configure your website.</p> <br/> <a href="../admin/index.php" class="grey-submit right">Finish</a> </form> <br style="clear:both"/> '; require 'footer.php';
function create_db_tables()
{
include_once WP_PLUGIN_DIR . '/final-tiles-gallery/lib/install-db.php';
install_db();
}
function UnInstalldb($modName = "")
{
if ($modName == "") {
$fileInc = 'install.inc.php';
} else {
$fileInc = "{$modName}/install.inc.php";
}
require_once $fileInc;
$querys = install_db();
list($conn) = Getdb();
$error = false;
$aux = 0;
foreach ($querys['drop'] as $insert) {
$conn->Execute("DROP TABLE {$insert}");
if ($conn->ErrorNo() != 0) {
$error = true;
break;
}
$aux++;
}
if ($error == true) {
echo '<center><font color="red" size="+6">Fallo Total.</font><br>' . '<font color="red" size="+4">Imposible desinstalar las tablas' . ($modName != "" ? " del modulo {$modName}" : ".") . '</font><br>' . '<font color="red" size="+4">Por favor compruebe la configuración.</font><br></center>';
echo $querys['drop'][$aux];
die;
return false;
}
return true;
}
$can_connect = false;
echo "<p><font color='red'><b>Cannot select database. " . mysql_error() . "</b></font></p>";
} else {
// connection is fine
$can_connect = true;
$error = '';
// no error as yet
// check if database was installed..
$sql = "SELECT ID FROM `users` limit 1";
$result = jb_mysql_query($sql) or $error = mysql_error();
}
} elseif ($_REQUEST['jb_db_host'] != '') {
echo "<p><font color='red'><b>Cannot connect to database. " . mysql_error() . "</b></font></p>";
}
if ($_REQUEST['install'] != '') {
install_db(JB_MYSQL_HOST, MYSQL_DB, JB_MYSQL_USER, JB_MYSQL_PASS);
}
function check_connection($user, $pass, $host)
{
if (!($connection = @mysql_connect("{$host}", "{$user}", "{$pass}"))) {
return false;
}
return $connection;
}
function check_db($db_name, $connection)
{
if (!($db = @mysql_select_db($db_name, $connection))) {
return false;
}
return true;
}
function com_install()
{
$database =& JFactory::getDBO();
$cur_version = '2.9.1';
$error = false;
echo JText::_('I_CHECK');
// we check if we have a previous version
$database->setQuery("CREATE TABLE IF NOT EXISTS #__joomla_flash_uploader_conf (key_id TEXT, value TEXT)");
if (!$database->query()) {
echo $database->getErrorMsg() . '<br />';
}
$database->setQuery("SELECT value FROM #__joomla_flash_uploader_conf where key_id = 'version'");
$version = $database->loadObjectList();
// end version check
if (!$version) {
// tables do not exist
echo JText::_('I_CHECK_NONE');
install_db($cur_version);
// we install basic version.
$error = update_db(true);
// and then we update to current version.
} else {
$ver = $version[0]->value;
if ($ver == '' || version_compare($ver, $cur_version, "<")) {
echo JText::_('I_CHECK_OLD_FOUND') . $ver . JText::_('I_CHECK_OLD_FOUND_2');
$error = update_db(false);
// we update old settings of the table because the default of the flash has changed after 2.7.4
$database->setQuery("UPDATE #__joomla_flash_uploader SET allowed_file_extensions='jpg,jpeg,gif,png' WHERE allowed_file_extensions=''");
if (!$database->query()) {
$error = true;
echo $database->getErrorMsg() . '<br />';
}
} else {
echo JText::_('I_CHECK_FOUND');
}
}
if (!$error) {
// we update the version of the db table
$database->setQuery("UPDATE #__joomla_flash_uploader_conf SET value='" . $cur_version . "' WHERE key_id='version'");
if (!$database->query()) {
$error = true;
echo $database->getErrorMsg() . '<br />';
}
// we try to the license now
$database->setQuery("SELECT value FROM #__joomla_flash_uploader_conf where key_id = 'user'");
$user = $database->loadObjectList();
if (count($user) > 0) {
$us = $user[0]->value;
$database->setQuery("SELECT value FROM #__joomla_flash_uploader_conf where key_id = 'domain'");
$domain = $database->loadObjectList();
$do = $domain[0]->value;
$database->setQuery("SELECT value FROM #__joomla_flash_uploader_conf where key_id = 'code'");
$code = $database->loadObjectList();
$co = $code[0]->value;
// write twg.lic.twg !
$filename = dirname(__FILE__) . "/tfu/twg.lic.php";
$file = fopen($filename, 'w');
fputs($file, "<?php\n");
fputs($file, "\$l=\"" . $us . "\";\n");
fputs($file, "\$d=\"" . $do . "\";\n");
fputs($file, "\$s=\"" . $co . "\";\n");
fputs($file, "?>");
fclose($file);
}
echo " <br />";
echo "<div style='text-align:left;'>";
echo JText::_('I_TEXT');
echo JText::_('I_DESC');
echo "</div>";
}
}
/**
* Proceed to Freeder installation.
*/
function install()
{
global $default_timezone;
$current_user = get_current_user();
$tmp = install_dir('tmp');
if (!empty($tmp)) {
exit('Unable to create or write to tmp/ folder. Please check write permissions on this folder.');
}
$login = isset($_POST['login']) ? $_POST['login'] : '';
$timezone = isset($_POST['timezone']) ? $_POST['timezone'] : $default_timezone;
require_once INC_DIR . 'rain.tpl.class.php';
require_once INC_DIR . 'rewriting.class.php';
RainTPL::$tpl_dir = RELATIVE_TPL_DIR . DEFAULT_THEME . '/';
RainTPL::$base_url = dirname($_SERVER['SCRIPT_NAME']) . '/';
RewriteEngine::$rewrite_base = RainTPL::$base_url;
RainTPL::$rewriteEngine = new RewriteEngine();
$tpl = new RainTPL();
$tpl->assign('start_generation_time', microtime(true), RainTPL::RAINTPL_IGNORE_SANITIZE);
$tpl->assign('login', $login, RainTPL::RAINTPL_HTML_SANITIZE);
$tpl->assign('timezone', $timezone, RainTPL::RAINTPL_HTML_SANITIZE);
if ($err = RainTPL::$rewriteEngine->write_htaccess()) {
$error = array();
$error['type'] = 'error';
$error['title'] = 'Permissions error';
$error['content'] = 'Unable to create or write .htaccess file. Check the writing rights of Freeder root directory. The user who executes Freeder — ' . sanitize($current_user) . ' — should be able to write in this directory. You may prefer to create the .htaccess file on your own and allow ' . sanitize($current_user) . ' to write only in .htaccess instead of in the whole Freeder root.';
$tpl->assign('error', $error, RainTPL::RAINTPL_IGNORE_SANITIZE);
}
if (!empty($_POST['login']) && !empty($_POST['password']) && !empty($_POST['confirm_password']) && !empty($_POST['timezone'])) {
if ($_POST['confirm_password'] != $_POST['password']) {
$error = array();
$error['type'] = 'error';
$error['title'] = 'Password mismatch';
$error['content'] = 'Passwords do not match!';
} else {
$error = install_dir(DATA_DIR);
if (empty($error)) {
$error = install_db();
if (empty($error)) {
$_SESSION['user'] = new stdClass();
$_SESSION['user']->login = $_POST['login'];
$_SESSION['is_admin'] = 1;
header('location: index.php');
exit;
} else {
$tpl->assign('error', $error, RainTPL::RAINTPL_IGNORE_SANITIZE);
}
} else {
$tpl->assign('error', $error, RainTPL::RAINTPL_IGNORE_SANITIZE);
}
}
} else {
if (isset($_POST['login'])) {
$error = array();
$error['type'] = 'error';
$error['title'] = 'Incomplete installation form';
$error['content'] = 'You must fill every field.';
$tpl->assign('error', $error, RainTPL::RAINTPL_IGNORE_SANITIZE);
}
}
$tpl->draw('install');
exit;
}
function start($skipGrant = false)
{
if (is_file("/etc/artica-postfix/FROM_ISO")) {
if (!is_file("/etc/artica-postfix/artica-iso-setup-launched")) {
return;
}
}
$unix = new unix();
$pidfile = "/etc/artica-postfix/pids/squiddbstart.pid";
$sock = new sockets();
$WORKDIR = $sock->GET_INFO("SquidStatsDatabasePath");
if ($WORKDIR == null) {
$WORKDIR = "/opt/squidsql";
}
$SERV_NAME = "squid-db";
$pid = $unix->get_pid_from_file($pidfile);
$sock = new sockets();
$nohup = $unix->find_program("nohup");
$php5 = $unix->LOCATE_PHP5_BIN();
$lnbin = $unix->find_program("ln");
if (!$GLOBALS["FORCE"]) {
if (!$GLOBALS["NOPID"]) {
if ($unix->process_exists($pid, basename(__FILE__))) {
$time = $unix->PROCCESS_TIME_MIN($pid);
if ($GLOBALS["OUTPUT"]) {
echo "Starting......: " . date("H:i:s") . " [INIT]: Starting Task Already running PID {$pid} since {$time}mn\n";
}
return;
}
}
}
@file_put_contents($pidfile, getmypid());
$GetStartedValues = GetStartedValues();
$sock = new sockets();
$ProxyUseArticaDB = $sock->GET_INFO("ProxyUseArticaDB");
$DisableArticaProxyStatistics = $sock->GET_INFO("DisableArticaProxyStatistics");
if (!is_numeric($ProxyUseArticaDB)) {
$ProxyUseArticaDB = 0;
}
if (!is_numeric($DisableArticaProxyStatistics)) {
$DisableArticaProxyStatistics = 0;
}
if (!is_dir($WORKDIR)) {
@mkdir($WORKDIR, 0755, true);
}
if ($ProxyUseArticaDB == 0) {
if ($GLOBALS["OUTPUT"]) {
echo "Starting......: " . date("H:i:s") . " [INIT]:{$SERV_NAME} is disabled...\n";
}
stop();
return;
}
$mysqld = $unix->find_program("mysqld");
if (!is_file($mysqld)) {
if ($GLOBALS["OUTPUT"]) {
echo "Starting......: " . date("H:i:s") . " [INIT]:{$SERV_NAME} is not installed...\n";
}
return;
}
$pid = SQUIDDB_PID();
if ($unix->process_exists($pid)) {
$time = $unix->PROCCESS_TIME_MIN($pid);
if ($GLOBALS["OUTPUT"]) {
echo "Starting......: " . date("H:i:s") . " [INIT]: {$SERV_NAME} MySQL Database Engine already running pid {$pid} since {$time}mn\n";
}
return;
}
if ($GLOBALS["OUTPUT"]) {
echo "Starting......: " . date("H:i:s") . " [INIT]: {$SERV_NAME} writing init.d\n";
}
initd();
$memory = get_memory();
$swap = get_swap();
if ($GLOBALS["OUTPUT"]) {
echo "Starting......: " . date("H:i:s") . " [INIT]: {$SERV_NAME} Server available memory `{$memory}MB`\n";
}
if ($GLOBALS["OUTPUT"]) {
echo "Starting......: " . date("H:i:s") . " [INIT]: {$SERV_NAME} Server available swap `{$swap}MB`\n";
}
$SquidDBTuningParameters = unserialize(base64_decode($sock->GET_INFO("SquidDBTuningParameters")));
$ListenPort = $SquidDBTuningParameters["ListenPort"];
if (!is_numeric($ListenPort)) {
$ListenPort = 0;
}
if ($ListenPort == 0) {
$ListenPort = rand(8900, 45890);
$SquidDBTuningParameters["ListenPort"] = $ListenPort;
$sock->SET_INFO("SquidDBTuningParameters", base64_encode(serialize($SquidDBTuningParameters)));
}
@mkdir($WORKDIR, 0755, true);
$mysqlserv = new mysql_services();
$mysqlserv->WORKDIR = $WORKDIR;
$mysqlserv->MYSQL_PID_FILE = "/var/run/squid-db.pid";
$mysqlserv->MYSQL_SOCKET = "/var/run/mysqld/squid-db.sock";
$mysqlserv->SERV_NAME = $SERV_NAME;
$mysqlserv->TokenParams = "SquidDBTuningParameters";
$mysqlserv->INSTALL_DATABASE = true;
$mysqlserv->MYSQL_BIN_DAEMON_PATH = $unix->find_program("mysqld");
//$mysqlserv->MYSQL_ERRMSG=$GLOBALS["MYSQL_ERRMSG"];
$mysqlserv->InnoDB = false;
$cmdline = $mysqlserv->BuildParams();
$CREATEDB = false;
if (!is_file("{$WORKDIR}/my.cnf")) {
@file_put_contents("{$WORKDIR}/my.cnf", "\n");
}
if (!is_file("{$WORKDIR}/bin/my_print_defaults")) {
$my_print_defaults = $unix->find_program("my_print_defaults");
shell_exec("{$lnbin} -s {$my_print_defaults} {$WORKDIR}/bin/my_print_defaults");
}
if (!is_file("{$WORKDIR}/data/mysql/user.MYD")) {
if ($GLOBALS["OUTPUT"]) {
echo "Starting......: " . date("H:i:s") . " [INIT]: {$SERV_NAME} Installing defaults databases, Please Wait...\n";
}
install_db($WORKDIR);
$CREATEDB = true;
}
$topCopyMysql["host.frm"] = true;
$topCopyMysql["host.MYD"] = true;
$topCopyMysql["host.MYI"] = true;
$topCopyMysql["servers.frm"] = true;
$topCopyMysql["servers.MYD"] = true;
$topCopyMysql["servers.MYI"] = true;
$MYSQL_DATA_DIR = $unix->MYSQL_DATA_DIR();
$topCopyMysqlForce["tables_priv.frm"] = true;
$topCopyMysqlForce["tables_priv.MYD"] = true;
$topCopyMysqlForce["tables_priv.MYI"] = true;
$topCopyMysqlForce["columns_priv.frm"] = true;
$topCopyMysqlForce["columns_priv.MYD"] = true;
$topCopyMysqlForce["columns_priv.MYI"] = true;
$topCopyMysqlForce["procs_priv.frm"] = true;
$topCopyMysqlForce["procs_priv.MYD"] = true;
$topCopyMysqlForce["procs_priv.MYI"] = true;
$topCopyMysqlForce["plugin.frm"] = true;
$topCopyMysqlForce["plugin.MYD"] = true;
$topCopyMysqlForce["plugin.MYI"] = true;
$topCopyMysqlForce["user.frm"] = true;
$topCopyMysqlForce["user.MYD"] = true;
$topCopyMysqlForce["user.MYI"] = true;
$topCopyMysqlForce["db.frm"] = true;
$topCopyMysqlForce["db.MYD"] = true;
$topCopyMysqlForce["db.MYI"] = true;
$ToCopyForce = false;
while (list($filename, $ligne) = each($topCopyMysql)) {
if (!is_file("{$WORKDIR}/data/mysql/{$filename}")) {
$ToCopyForce = true;
if (is_file("{$MYSQL_DATA_DIR}/mysql/{$filename}")) {
if ($GLOBALS["OUTPUT"]) {
echo "Starting......: " . date("H:i:s") . " [INIT]: Installing {$filename}\n";
}
@copy("{$MYSQL_DATA_DIR}/mysql/{$filename}", "{$WORKDIR}/data/mysql/{$filename}");
$CREATEDB = true;
}
}
}
while (list($filename, $ligne) = each($topCopyMysqlForce)) {
if (!is_file("{$WORKDIR}/data/mysql/{$filename}")) {
if (is_file("{$MYSQL_DATA_DIR}/mysql/{$filename}")) {
if ($GLOBALS["OUTPUT"]) {
echo "Starting......: " . date("H:i:s") . " [INIT]: Installing {$filename}\n";
}
@copy("{$MYSQL_DATA_DIR}/mysql/{$filename}", "{$WORKDIR}/data/mysql/{$filename}");
}
}
}
@mkdir("{$WORKDIR}/share/mysql/english", 0755, true);
$Get_errmsgsys = Get_errmsgsys();
if (!is_file("{$WORKDIR}/share/mysql/english/errmsg.sys")) {
if ($GLOBALS["OUTPUT"]) {
echo "Starting......: " . date("H:i:s") . " [INIT]: Creating errmsg.sys\n";
}
ini_set('error_reporting', E_ALL);
ini_set('error_prepend_string', null);
ini_set('error_append_string', null);
if (is_file($Get_errmsgsys)) {
if ($GLOBALS["OUTPUT"]) {
echo "Starting......: " . date("H:i:s") . " [INIT]: copy {$Get_errmsgsys} -> {$WORKDIR}/share/mysql/english/errmsg.sys\n";
}
copy(Get_errmsgsys(), "{$WORKDIR}/share/mysql/english/errmsg.sys");
} else {
file_put_contents("{$WORKDIR}/share/mysql/english/errmsg.sys", "\n");
}
} else {
if ($GLOBALS["OUTPUT"]) {
echo "Starting......: " . date("H:i:s") . " [INIT]: errmsg.sys OK\n";
}
}
$TMP = $unix->FILE_TEMP();
$nohup = $unix->find_program("nohup");
if ($GLOBALS["VERBOSE"]) {
echo $cmdline . "\n";
}
if ($GLOBALS["OUTPUT"]) {
echo "Starting......: " . date("H:i:s") . " [INIT]: Starting MySQL daemon ({$SERV_NAME})\n";
}
@unlink("{$WORKDIR}/error.log");
shell_exec("{$nohup} {$cmdline} >{$TMP} 2>&1 &");
sleep(1);
for ($i = 0; $i < 5; $i++) {
$pid = SQUIDDB_PID();
if ($unix->process_exists($pid)) {
if ($GLOBALS["OUTPUT"]) {
echo "Starting......: " . date("H:i:s") . " [INIT]: MySQL daemon ({$SERV_NAME}) started pid .{$pid}..\n";
}
break;
}
if ($GLOBALS["OUTPUT"]) {
echo "Starting......: " . date("H:i:s") . " [INIT]: MySQL daemon wait {$i}/5\n";
}
sleep(1);
}
sleep(1);
$pid = SQUIDDB_PID();
if (!$unix->process_exists($pid)) {
if ($GLOBALS["OUTPUT"]) {
echo "Starting......: " . date("H:i:s") . " [INIT]: MySQL daemon ({$SERV_NAME}) failed to start\n";
}
if (is_file($TMP)) {
$f = explode("\n", @file_get_contents($TMP));
while (list($num, $ligne) = each($f)) {
if (trim($ligne) == null) {
continue;
}
if ($GLOBALS["OUTPUT"]) {
echo "Starting......: " . date("H:i:s") . " [INIT]: {$ligne}\n";
}
}
}
$f = explode("\n", @file_get_contents("{$WORKDIR}/error.log"));
while (list($num, $ligne) = each($f)) {
if ($GLOBALS["OUTPUT"]) {
echo "Starting......: " . date("H:i:s") . " [INIT]: MySQL Results \"{$ligne}\"\n";
}
if (preg_match("#Incorrect information in file: './mysql/proxies_priv.frm'#", $ligne)) {
if ($GLOBALS["OUTPUT"]) {
echo "Starting......: " . date("H:i:s") . " [INIT]: remove MySQL tables and install again...\n";
}
shell_exec("/bin/rm -rf {$WORKDIR}/data/mysql/*");
shell_exec("{$nohup} {$php5} " . __FILE__ . " --start --recall >/dev/ null 2>&1 &");
return;
}
}
} else {
if ($GLOBALS["OUTPUT"]) {
echo "Starting......: " . date("H:i:s") . " [INIT]: MySQL daemon ({$SERV_NAME}) success\n";
}
if ($CREATEDB) {
$q = new mysql_squid_builder();
$q->CheckTables();
}
$q = new mysql_squid_builder();
$q->MEMORY_TABLES_RESTORE();
}
if (!$unix->process_exists($pid)) {
if ($GLOBALS["OUTPUT"]) {
echo "Starting......: " . date("H:i:s") . " [INIT]: {$cmdline}\n";
}
}
$unix->THREAD_COMMAND_SET($unix->LOCATE_PHP5_BIN() . " " . __FILE__ . " --databasesize");
}
SmartyValidate::register_validator('v_db_host', 'db_host', 'notEmpty', false, false, 'trim', 'install');
SmartyValidate::register_validator('v_db_name', 'db_name', 'notEmpty', false, false, 'trim', 'install');
SmartyValidate::register_validator('v_db_user', 'db_user', 'notEmpty', false, false, 'trim', 'install');
SmartyValidate::register_validator('v_db_password', 'db_password', 'dummyValid', true, false, 'trim', 'install');
} else {
if ($_POST['submit'] == 'next') {
SmartyValidate::connect($tpl);
if (SmartyValidate::is_valid($_POST, 'install')) {
$db_details = array();
$db_details['db_driver'] = 'mysql';
$db_details['db_host'] = !empty($_POST['db_host']) ? $_POST['db_host'] : '';
$db_details['db_name'] = !empty($_POST['db_name']) ? $_POST['db_name'] : '';
$db_details['db_user'] = !empty($_POST['db_user']) ? $_POST['db_user'] : '';
$db_details['db_password'] = !empty($_POST['db_password']) ? $_POST['db_password'] : null;
$db_details['language'] = !empty($_SESSION['language']) ? $_SESSION['language'] : 'en';
if (install_db($db_details)) {
upgrade_user_table($db_details);
SmartyValidate::disconnect();
$step++;
@header('Location: index.php?step=' . $step);
@exit;
}
}
} elseif ($_POST['submit'] == 'back') {
SmartyValidate::disconnect();
$step--;
@header('Location: index.php?step=' . $step);
@exit;
}
}
$tpl->assign($_SESSION['values']);
function plug_install($qd)
{
if (!$qd) {
return;
}
$table = install_db($qd);
if ($_SESSION['auth'] > 6 or $_SESSION['first']) {
foreach ($table as $k => $sql) {
$req = mysql_query($sql) or die(mysql_error());
$ret .= divc('', $qd . '_' . $k . ': ok');
}
}
$_SESSION['first'] = '';
return $ret;
}
