/** * Build and save the actual configuration file for Perl (used by crondump.pl) * * @return boolean true on success or false on failure */ function writeCronScript() { global $config, $databases, $cron_db_array, $cron_dbpraefix_array, $cron_db_cbd_array, $cron_db_cad_array; if (!isset($config['email_maxsize'])) { $config['email_maxsize'] = $config['email_maxsize1'] * ($config['email_maxsize2'] == 1 ? 1024 : 1024 * 1024); } if (isset($config['db_actual'])) { $cron_dbname = $config['db_actual']; } else { //get first database name from database-array (this is the case at fresh installing) $dbs = array_keys($databases); $cron_dbname = $dbs[0]; } // -2 = Multidump configuration // -3 = all databases - nothing to do // get standard values for all databases $cron_db_array = ''; //$databases['Name']; $cron_dbpraefix_array = ''; //$databases['praefix']; $cron_command_before_dump = ''; //$databases['command_before_dump']; $cron_command_after_dump = ''; //$databases['command_after_dump']; $cron_ftp_server = ''; $cron_ftp_port = ''; $cron_ftp_mode = ''; $cron_ftp_user = ''; $cron_ftp_pass = ''; $cron_ftp_dir = ''; $cron_ftp_timeout = ''; $cron_ftp_ssl = ''; $cron_ftp_transfer = ''; //build db-arrays foreach ($databases as $k => $v) { //should we dump this database if (isset($databases[$k]['dump']) && $databases[$k]['dump'] === 1) { $cron_db_array[] .= $k; $cron_dbpraefix_array[] .= $databases[$k]['prefix']; $cron_command_before_dump[] .= $databases[$k]['command_before_dump']; $cron_command_after_dump[] .= $databases[$k]['command_after_dump']; } } //build ftp-arrays foreach ($config['ftp'] as $k => $v) { $cron_ftp_server[] .= $config['ftp'][$k]['server']; $cron_ftp_port[] .= $config['ftp'][$k]['port']; $cron_ftp_mode[] .= $config['ftp'][$k]['mode']; $cron_ftp_user[] .= $config['ftp'][$k]['user']; $cron_ftp_pass[] .= $config['ftp'][$k]['pass']; $cron_ftp_dir[] .= $config['ftp'][$k]['dir']; $cron_ftp_timeout[] .= $config['ftp'][$k]['timeout']; $cron_ftp_ssl[] .= $config['ftp'][$k]['ssl']; $cron_ftp_transfer[] .= $config['ftp'][$k]['transfer']; } $r = str_replace("\\\\", "/", $config['paths']['root']); $r = str_replace("@", "\\@", $r); //built recipient_cc-arrays $recipients_cc = ''; foreach ($config['email']['recipient_cc'] as $k => $v) { $recipients_cc .= '"' . $config['email']['recipient_cc'][$k]['name'] . '" <' . $config['email']['recipient_cc'][$k]['address'] . '>, '; } $recipients_cc = substr($recipients_cc, 0, -2); // auf manchen Server wird statt 0 ein leerer String gespeichert -> fuehrt zu einem Syntax-Fehler // hier die entsprechenden Ja/Nein-Variablen sicherheitshalber in intvalues aendern $int_array = array('dbport', 'cron_compression', 'cron_printout', 'multi_part', 'multipart_groesse', 'email_maxsize', 'perlspeed', 'optimize_tables_beforedump', 'logcompression', 'log_maxsize', 'cron_completelog', 'use_sendmail', 'smtp_port', 'smtp_useauth', 'smtp_usessl'); foreach ($int_array as $i) { if (is_array($i)) { foreach ($i as $key => $val) { $int_array[$key] = intval($val); } } else { if (!isset($config[$i])) { $config[$i] = 0; } $config[$i] = intval($config[$i]); } } if ($config['dbport'] == 0) { $config['dbport'] = 3306; } $cronscript = "<?php\n#Vars - written at " . date("Y-m-d H:i") . "\n"; $cronscript .= '$dbhost="' . $config['dbhost'] . '";' . "\n"; $cronscript .= '$dbname="' . $cron_dbname . '";' . "\n"; $cronscript .= '$dbuser="******";' . "\n"; $cronscript .= '$dbpass="******";' . "\n"; $cronscript .= '$dbport=' . $config['dbport'] . ';' . "\n"; $cronscript .= '$dbsocket="' . Html::escapeSpecialchars($config['dbsocket']) . '";' . "\n"; $cronscript .= '$compression=' . $config['cron_compression'] . ';' . "\n"; $cronscript .= '$sendmail_call="' . Html::escapeSpecialchars($config['sendmail_call']) . '";' . "\n"; $cronscript .= '$backup_path="' . $config['paths']['root'] . $config['paths']['backup'] . '";' . "\n"; $cronscript .= '$cron_printout=' . $config['cron_printout'] . ';' . "\n"; $cronscript .= '$cronmail=' . $config['send_mail'] . ';' . "\n"; $cronscript .= '$cronmail_dump=' . $config['email']['attach_backup'] . ';' . "\n"; $cronscript .= '$cronmailto="' . Html::escapeSpecialchars('"' . $config['email']['recipient_name'] . '" <' . $config['email']['recipient_address'] . '>') . '";' . "\n"; $cronscript .= '$cronmailto_cc="' . Html::escapeSpecialchars($recipients_cc) . '";' . "\n"; $cronscript .= '$cronmailfrom="' . Html::escapeSpecialchars('"' . $config['email']['sender_name'] . '" <' . $config['email']['sender_address'] . '>') . '";' . "\n"; $cronscript .= '$cron_use_sendmail=' . $config['use_sendmail'] . ';' . "\n"; $cronscript .= '$cron_smtp="' . Html::escapeSpecialchars($config['smtp_server']) . '";' . "\n"; $cronscript .= '$smtp_port=' . $config['smtp_port'] . ';' . "\n"; $cronscript .= '$smtp_useauth=' . $config['smtp_useauth'] . ';' . "\n"; $cronscript .= '$smtp_usessl=' . $config['smtp_usessl'] . ';' . "\n"; $cronscript .= '$smtp_user="******";' . "\n"; $cronscript .= '$smtp_pass="******";' . "\n"; $cronscript .= '@cron_db_array=' . myImplode($cron_db_array) . ';' . "\n"; $cronscript .= '@cron_dbpraefix_array=' . myImplode($cron_dbpraefix_array) . ';' . "\n"; $cronscript .= '@cron_command_before_dump=' . myImplode($cron_command_before_dump) . ';' . "\n"; $cronscript .= '@cron_command_after_dump=' . myImplode($cron_command_after_dump) . ';' . "\n"; $cronscript .= '@ftp_server=' . myImplode($cron_ftp_server) . ';' . "\n"; $cronscript .= '@ftp_port=' . myImplode($cron_ftp_port, 1) . ';' . "\n"; $cronscript .= '@ftp_mode=' . myImplode($cron_ftp_mode, 1) . ';' . "\n"; $cronscript .= '@ftp_user='******';' . "\n"; $cronscript .= '@ftp_pass='******';' . "\n"; $cronscript .= '@ftp_dir=' . myImplode($cron_ftp_dir) . ';' . "\n"; $cronscript .= '@ftp_timeout=' . myImplode($cron_ftp_timeout, 1) . ';' . "\n"; $cronscript .= '@ftp_useSSL=' . myImplode($cron_ftp_ssl, 1) . ';' . "\n"; $cronscript .= '@ftp_transfer=' . myImplode($cron_ftp_transfer, 1) . ';' . "\n"; $cronscript .= '$mp=' . $config['multi_part'] . ';' . "\n"; $cronscript .= '$multipart_groesse=' . $config['multipart_groesse'] . ';' . "\n"; $cronscript .= '$email_maxsize=' . $config['email_maxsize'] . ';' . "\n"; $cronscript .= '$auto_delete=' . $config['auto_delete']['activated'] . ';' . "\n"; $cronscript .= '$max_backup_files=' . $config['auto_delete']['max_backup_files'] . ';' . "\n"; $cronscript .= '$perlspeed=' . $config['perlspeed'] . ';' . "\n"; $cronscript .= '$optimize_tables_beforedump=' . $config['optimize_tables_beforedump'] . ';' . "\n"; $cronscript .= '$logcompression=' . $config['logcompression'] . ';' . "\n"; //add .gz to logfiles? if ($config['logcompression'] === 1) { $cronscript .= '$logdatei="' . $config['paths']['root'] . $config['files']['perllog'] . '.gz";' . "\n"; $cronscript .= '$completelogdatei="' . $config['paths']['root'] . $config['files']['perllogcomplete'] . '.gz";' . "\n"; } else { $cronscript .= '$logdatei="' . $config['paths']['root'] . $config['files']['perllog'] . '";' . "\n"; $cronscript .= '$completelogdatei="' . $config['paths']['root'] . $config['files']['perllogcomplete'] . '";' . "\n"; } $cronscript .= '$log_maxsize=' . $config['log_maxsize'] . ';' . "\n"; $cronscript .= '$complete_log=' . $config['cron_completelog'] . ';' . "\n"; $cronscript .= '$cron_comment="' . Html::escapeSpecialchars(stripslashes($config['cron_comment'])) . '";' . "\n"; $cronscript .= "?>"; // Save config $ret = true; $sfile = './' . $config['paths']['config'] . $config['config_file'] . '.conf.php'; if (file_exists($sfile)) { @unlink($sfile); } if ($fp = @fopen($sfile, "wb")) { if (!fwrite($fp, $cronscript)) { $ret = false; } if (!fclose($fp)) { $ret = false; } @chmod("{$sfile}", 0777); } else { $ret = false; } // if standard config was deleted -> restore it with the actual values if (!file_exists('./' . $config['paths']['config'] . "mysqldumper.conf.php")) { $sfile = './' . $config['paths']['config'] . 'mysqldumper.conf.php'; if ($fp = fopen($sfile, "wb")) { if (!fwrite($fp, $cronscript)) { $ret = false; } if (!fclose($fp)) { $ret = false; } @chmod("{$sfile}", 0777); } else { $ret = false; } } return $ret; }
case "city": $city = $value; break; case "pincode": $pincode = $value; break; case "about": $about = $value; } } if ($validater) { $sql = "INSERT INTO `user_details` (`uname`, `mail_id`, `address_no`, `area`, `city`, `pincode`, `password`, `date`)\n VALUES ('{$name}','{$email}','{$address}','{$area}', '{$city}', '{$pincode}', '{$password}', '{$time}')"; $result = $DB->query($sql); $token = $name . $city . $area . " "; $delimiters = array(" ", "\n", ",", ".", "\"", ":", "(", ")", "[", "]", "{", "}", "1", "2", "3", "4", "5", "6", "7", "8", "9", "0", "!", "@", "#", "\$", "%", "^", "&", "*", "<", ">", "?", "'", "\\", "/", ";", "+", "=", "_", "-", "\r", "\t"); $token = explode($delimiters[0], strtr($token, array_combine(array_slice($delimiters, 1), array_fill(0, count($delimiters) - 1, array_shift($delimiters))))); $token = myImplode("", $token); $iid = $DB->insert_id; echo "<br>" . $iid; $sql1 = "INSERT INTO `sub_tokens` (`token`, `uid`, `date`) VALUES ('{$token}', '{$iid}', '{$time}')"; echo "<br>" . $sql1; $result1 = $DB->query($sql1); if ($result && $result1) { echo json_encode(array('result' => "success")); } else { echo json_encode(array('result' => "failure", 'reason' => "Cannot register person")); } } else { echo json_encode(array('result' => "failure", 'reason' => "Some data missing")); } $DB->close();
$count = ( $count == 0 ) ? 15 : $count; $count = ( $count > 50 ) ? 50 : $count; if ( $_GET['op']=='comments' ) { require_once dirname(__FILE__).'/rss_comments.php'; exit; } // GUS begin $category = ( isset($_GET['cat']) ) ? intval($_GET['cat']) : 0; if ( isset($_GET['takeOffs']) ) { if ( $_GET['debug'] ) echo $_GET['takeOffs']."<br>"; $takeOffs = mysql_real_escape_string(urldecode($_GET['takeOffs'])); $takeOffs = myImplode("'", "'", ",", explode(",",$takeOffs)); } else { $takeOffs = ''; } $box_min_lat = ( isset($_GET['min_lat']) ) ? floatval($_GET['min_lat']) : 0; $box_max_lat = ( isset($_GET['max_lat']) ) ? floatval($_GET['max_lat']) : 0; $box_min_lon = ( isset($_GET['min_lon']) ) ? floatval($_GET['min_lon']) : 0; $box_max_lon = ( isset($_GET['max_lon']) ) ? floatval($_GET['max_lon']) : 0; if ( $_GET['debug'] ) { echo "$box_min_lat<br>$box_max_lat<br>$box_min_lon<br>$box_max_lon<br>"; }