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;
}
function updateAttributesOptimalization()
{
global $config;
//milyen/nyelv optimalizálás (!minden misén átmegy!)
$c = 0;
$query = "SELECT * from misek WHERE milyen <> '' OR nyelv <> '' ";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {
$query = "UPDATE misek SET milyen = '" . cleanMassAttr($row['milyen']) . "', nyelv = '" . cleanMassAttr($row['nyelv']) . "' WHERE id = " . $row['id'] . " LIMIT 1";
//echo $query."<br/>";
mysql_query($query);
$c++;
}
if ($config['debug'] > 0) {
echo $c . " db milyen/nyelv optimalizálva<br/>";
}
}
