function events_save($form)
{
foreach ($form['events'] as $name => $years) {
foreach ($years as $year => $input) {
if (isset($input['id'])) {
if ($input['input'] != '') {
$date = date('Y-m-d', strtotime($input['input']));
} else {
$date = '';
}
$query = "UPDATE events SET `date` = '" . $date . "' WHERE id = " . $input['id'] . " LIMIT 1";
mysql_query($query);
} else {
if ($input['input'] != '') {
if ($name == 'new') {
$name = sanitize($form['new']);
}
if ($name != 'new' or $form['new'] != '') {
$query = "INSERT INTO events (name,year,date) VALUES ('" . $name . "','" . $year . "','" . $input['input'] . "');";
mysql_query($query);
//echo $query."<br/>";
}
}
}
}
}
generateMassTmp();
}
function miserend_addingmise()
{
global $user;
$most = date('Y-m-d H:i:s');
foreach ($_REQUEST as $k => $i) {
$_REQUEST[$k] = sanitize($i);
}
if (!is_numeric($_REQUEST['tid'])) {
die('tid csak numeric');
}
//DELETE
if (isset($_REQUEST['delete']['period'])) {
foreach ($_REQUEST['delete']['period'] as $period) {
$query = "UPDATE misek SET torles = '" . $most . "', torolte = '" . $user->login . "' WHERE tid = " . $_REQUEST['tid'] . " AND idoszamitas = '" . $period . "' ;";
mysql_query($query);
}
}
if (isset($_REQUEST['delete']['particular'])) {
foreach ($_REQUEST['delete']['particular'] as $particular) {
$query = "UPDATE misek SET torles = '" . $most . "', torolte = '" . $user->login . "' WHERE tid = " . $_REQUEST['tid'] . " AND idoszamitas = '" . $particular . "' ;";
mysql_query($query);
}
}
if (isset($_REQUEST['delete']['mass'])) {
foreach ($_REQUEST['delete']['mass'] as $mid) {
$query = "UPDATE misek SET torles = '" . $most . "', torolte = '" . $user->login . "' WHERE tid = " . $_REQUEST['tid'] . " AND id = '" . $mid . "' LIMIT 1;";
mysql_query($query);
}
}
//UPDATE
if (is_array($_REQUEST['period'])) {
foreach ($_REQUEST['period'] as $period) {
foreach ($period as $key => $mass) {
if (is_numeric($key)) {
$mass['tid'] = $_REQUEST['tid'];
$mass['idoszamitas'] = sanitize($period['name']);
$mass['weight'] = $period['weight'];
$mass['tol'] = sanitize($period['from']);
if ($period['from2'] != 0) {
$mass['tol'] .= ' ' . $period['from2'];
}
$mass['ig'] = sanitize($period['to']);
if ($period['to2'] != 0) {
$mass['ig'] .= ' ' . $period['to2'];
}
$mass['milyen'] = cleanMassAttr($mass['milyen']);
$mass['nyelv'] = cleanMassAttr($mass['nyelv']);
if ($mass['id'] != 'new') {
$query = "UPDATE misek SET ";
$query .= "nap='" . $mass['napid'] . "',ido='" . $mass['ido'] . ":00',nap2='" . $mass['nap2'] . "',idoszamitas='" . $mass['idoszamitas'] . "',weight='" . $mass['weight'] . "',tol='" . $mass['tol'] . "',ig='" . $mass['ig'] . "',nyelv='" . $mass['nyelv'] . "',milyen='" . $mass['milyen'] . "',megjegyzes='" . $mass['megjegyzes'] . "',";
$query .= "modositotta='" . $user->login . "',moddatum='" . $most . "'";
$query .= " WHERE tid = " . $mass['tid'] . " AND id = " . $mass['id'] . " LIMIT 1";
} else {
$query = "INSERT INTO misek ";
$query .= " (tid,nap,ido,nap2,idoszamitas,weight,tol,ig,nyelv,milyen,megjegyzes,modositotta,moddatum) ";
$query .= " VALUES ('" . $mass['tid'] . "','" . $mass['napid'] . "','" . $mass['ido'] . ":00','" . $mass['nap2'] . "','" . $mass['idoszamitas'] . "','" . $mass['weight'] . "','" . $mass['tol'] . "','" . $mass['ig'] . "','" . $mass['nyelv'] . "','" . $mass['milyen'] . "','" . $mass['megjegyzes'] . "',";
$query .= "'" . $user->login . "','" . $most . "')";
}
mysql_query($query);
}
}
}
}
if (is_array($_REQUEST['particular'])) {
foreach ($_REQUEST['particular'] as $particular) {
foreach ($particular as $key => $mass) {
if (is_numeric($key)) {
$mass['tid'] = $_REQUEST['tid'];
$mass['idoszamitas'] = sanitize($particular['name']);
$mass['weight'] = $particular['weight'];
$mass['tol'] = sanitize($particular['from']);
if ($particular['from2'] != 0) {
$mass['tol'] .= ' ' . $particular['from2'];
}
$mass['ig'] = $mass['tol'];
$mass['napid'] = 0;
if ($mass['id'] != 'new') {
$query = "UPDATE misek SET ";
$query .= "nap='" . $mass['napid'] . "',ido='" . $mass['ido'] . ":00',nap2='" . $mass['nap2'] . "',idoszamitas='" . $mass['idoszamitas'] . "',weight='" . $mass['weight'] . "',tol='" . $mass['tol'] . "',ig='" . $mass['ig'] . "',nyelv='" . $mass['nyelv'] . "',milyen='" . $mass['milyen'] . "',megjegyzes='" . $mass['megjegyzes'] . "',";
$query .= "modositotta='" . $user->login . "',moddatum='" . $most . "'";
$query .= " WHERE tid = " . $mass['tid'] . " AND id = " . $mass['id'] . " LIMIT 1";
} else {
$query = "INSERT INTO misek ";
$query .= " (tid,nap,ido,nap2,idoszamitas,weight,tol,ig,nyelv,milyen,megjegyzes,modositotta,moddatum) ";
$query .= " VALUES ('" . $mass['tid'] . "','" . $mass['napid'] . "','" . $mass['ido'] . ":00','" . $mass['nap2'] . "','" . $mass['idoszamitas'] . "','" . $mass['weight'] . "','" . $mass['tol'] . "','" . $mass['ig'] . "','" . $mass['nyelv'] . "','" . $mass['milyen'] . "','" . $mass['megjegyzes'] . "',";
$query .= "'" . $user->login . "','" . $most . "')";
}
mysql_query($query);
}
}
}
}
generateMassTmp('tid = ' . $_REQUEST['tid']);
//LOG
$ip = $_SERVER['REMOTE_ADDR'];
$host = gethostbyaddr($ip);
$tid = $_REQUEST['tid'];
$ma = date('Y-m-d');
list($log) = mysql_fetch_row(mysql_query("select log from templomok where id='{$tid}'"));
$log .= "\nMISE_MOD: " . $user->login . " ({$most} - [{$ip} - {$host}])";
if ($_REQUEST['update'] == 'i') {
$frissites = ", frissites='{$ma}'";
}
$_REQUEST['misemegj'] = preg_replace('/<br\\/>/i', "\n", $_REQUEST['misemegj']);
$_REQUEST['adminmegj'] = preg_replace('/<br\\/>/i', "\n", $_REQUEST['adminmegj']);
$query = "update templomok set miseaktiv='" . $_REQUEST['miseaktiv'] . "', misemegj='" . $_REQUEST['misemegj'] . "', adminmegj='" . $_REQUEST['adminmegj'] . "', log='{$log}' {$frissites} where id='{$tid}' LIMIT 1";
mysql_query($query);
$modosit = $_REQUEST['modosit'];
if ($modosit == 'i') {
$kod = miserend_addmise($tid);
} elseif ($modosit == 'm') {
$kod = miserend_addtemplom($tid);
} elseif ($modosit == 't') {
header('Location: ?templom=' . $tid);
die;
} else {
$kod = miserend_modtemplom();
}
return $kod;
}
set_time_limit('300');
ini_set('memory_limit', '512M');
switch ($_REQUEST['q']) {
case 'hourly':
clearoutTokens();
clearoutMessages();
updateOverpass(50);
updateDistances();
break;
case 'daily':
clearoutVolunteers();
deleteOverpass();
updateOSM();
for ($v = 1; $v < 5; $v++) {
$file = 'fajlok/sqlite/miserend_v' . $v . '.sqlite3';
generateSqlite($v, $file);
//upload2ftp('*url*','*user*','*password*','web/'.$file,$file);
}
break;
case 'weekly':
assignUpdates();
updateImageSizes();
generateMassTmp();
updateCleanMassLanguages();
updateGorogkatolizalas();
updateDeleteZeroMass();
updateComments2Attributes();
//not so fast!
updateAttributesOptimalization();
break;
}
