/**
* 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>";
}
