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