$val){if(!is_numeric($key)){$__data_new[$key] = $val;}}}
return($__data_new);
}
function GetDateSec($_datum, $_cas = 0){
if($_cas){$_cas_arr = explode(":", $_cas);} $_cas_arr[0] = 0 + $_cas_arr[0]; $_cas_arr[1] = 0 + $_cas_arr[1];
$_datum = str_replace(".", "/", $_datum);
$val_arr = explode("/", $_datum);
$val = MkTime($_cas_arr[0],$_cas_arr[1],0,$val_arr[1],$val_arr[0],$val_arr[2]);
return($val);
}
function GetTimeSec($_cas = 0){
$_cas = str_replace(".", ":", $_cas);
$_cas = str_replace(",", ":", $_cas);
$_cas_arr = explode(":", $_cas);
$_cas_arr[0] = (0 + $_cas_arr[0]) * 3600;
$_cas_arr[1] = (0 + $_cas_arr[1]) * 60;
return($_cas_arr[0] + $_cas_arr[1]);
}
function logEvent($data, $category = "", $typ = ""){
$_sql = "INSERT INTO event_log SET user='".$login_user_ID."', datum='".time()."', page='".$_SERVER[SCRIPT_NAME]."', category='".$category."', typ='".$typ."', description='".$data."'";
MySQL_Query($_sql); // echo $_sql;
}
function getSpreadsheet_Array($spreadsheet_url)
{
if(!strpos($spreadsheet_url, "output=csv")){
$spreadsheet_url=str_replace('spreadsheets/d/', 'spreadsheet/pub?key=', $spreadsheet_url);
$spreadsheet_url=str_replace('/pubhtml', '&single=true&gid=0&output=csv', $spreadsheet_url);
}
if(!ini_set('default_socket_timeout', 15)) echo "";
if (($handle = fopen($spreadsheet_url, "r")) !== FALSE) {
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
$spreadsheet_data[]=$data;
}
fclose($handle);
}
else
die("Problem reading csv");
return $spreadsheet_data;
}
// doblni sloupce do tabulky, nebo jen vrátí jejich seznam
function GetTableStructure($_table, $_sloupec_info = false, $_define_import_cell = false){
$_data_form_nosave = Array("ID"); // data která nechceme pridavat do DB
$result = mysql_query("SHOW COLUMNS FROM ".$_table);
if (!$result) { echo 'Could not run query: ' . mysql_error(); exit;}
// pole tabulky do pole
if (mysql_num_rows($result) > 0) {while ($row = mysql_fetch_assoc($result)) {$db_cars_field[$row[Field]] = $row[Type];}}
// pokud pole v DB neexistuje, vytvorime ho
if(is_array($_sloupec_info)){
foreach($_sloupec_info as $key => $val){
// pokud ma sloupec predefinici v tabulce prejmenujeme ho
if($_define_import_cell[$key]){$key = $_define_import_cell[$key];}
if(!$db_cars_field[$key] AND !in_array($key, $_data_form_nosave)){
$db_cars_field[$key] = "varchar(255)";
$_sql = "ALTER TABLE `".$_table."` ADD `".$key."` VARCHAR(255) NULL";
MySQL_Query($_sql); $db_cars_field[$key] = true;
}
}}
return $db_cars_field;
}
// -------------- funkce pro mailování
Function Mailuj2($_kod, $_email, $_predmet, $_text, $is_html){
global $databaze, $web_url, $lang, $_system_vals, $mailmess, $no_strip_html, $_replace_mail, $_domain_mail, $_mail_attachment, $_soubory_do_mailu_file, $_soubory_do_mailu_cid, $_soubory_do_mailu, $no_strip_html, $_replace_mail, $_domain_mail, $email_odesilatel;
$_web_domain_mail = $_web_domain;
if($_domain_mail){$_web_domain_mail = $_domain_mail;} // pokud preferuneme jiny mailmanager
if(!$_predmet){$_predmet = "none";}
$kod_find = "none";
//$email = "samal@ipf.cz";
$email_odesilatel = "info@ipmsnymburk.com";
$jmeno = "IPMS NYMBURK forum";
$mess = "IPMS NYMBURK forum";
if($_system_vals[$_kod]){
$_mail_info = explode("#", $_system_vals[$_kod]);
$email_odesilatel = $_mail_info[0];
$jmeno = $_mail_info[1];
$mess = $_mail_info[1];
$email_prijemce = $_mail_info[2];
}
if($email_prijemce){$_email.=",".$email_prijemce;}
if(!$kod_find){echo "kod ".$_kod." not exist!";return;}
if($_kod == "none"){
$mailmess = $_text;
}else{
if($is_html == "html"){
$mailmess = "".date("d.m.Y H:i")." - $_predmet
\n\n";
$mailmess.= "$_text
\n\n";
$mailmess.= "".NL2BR($mess)."
\n\n";
}else{
$mailmess = date("d.m.Y H:i")." - $_predmet\n";
$mailmess.= "----------------------------------------------------------\n";
$mailmess.= $_text."\n";
$mailmess.= "----------------------------------------------------------\n\n";
$mailmess.= "$mess\n\n";
$mailmess.= $_SERVER[REMOTE_ADDR]."\n";
//if(!$no_strip_html)
$mailmess = strip_tags($mailmess);
}
}
require_once "class.phpmailer.php";
$mail = new PHPMailer();
/*
$mail->IsSMTP(); // k odeslání e-mailu použijeme SMTP server
$mail->Host = "mail.miab.cz"; // zadáme adresu SMTP serveru //smtp.iol.cz
$mail->SMTPAuth = true; // nastavíme true v případě, že server vyžaduje SMTP autentizaci
$mail->Username = "forum@ipmsnymburk.com"; // uživatelské jméno pro SMTP autentizaci //220874027
$mail->Password = "kultivator"; // heslo pro SMTP autentizaci //0000912056
*/
$mail->From = $email_odesilatel; // adresa odesílatele skriptu
$mail->FromName = $jmeno; // jméno odesílatele skriptu (zobrazí se vedle adresy odesílatele)
$_mail_explode = Explode(",", $_email);
foreach($_mail_explode as $klic => $hodnota) {
$_seznam_mailu[$hodnota] = $klic;
}
unset($_mail_explode);
$_mail_explode = Explode(",", $email);
foreach($_mail_explode as $klic => $hodnota) {
$_seznam_mailu[$hodnota] = $klic;
}
unset($_mail_explode);
foreach($_seznam_mailu as $klic => $hodnota) {
$mail->AddAddress("$klic");
}
$mail->Subject = $_predmet; // nastavíme předmět e-mailu
$mail->Body = $mailmess; // nastavíme tělo e-mailu
//$mail->WordWrap = 50; // je vhodné taky nastavit zalomení (po 50 znacích)
$mail->CharSet = "utf-8"; // nastavíme kódování, ve kterém odesíláme e-mail
$mail->Priority = 1;
$mail->Encoding = "8bit";
if(is_Array($_mail_attachment)){
foreach($_mail_attachment as $k => $file){
$mail->AddAttachment($file,
'',
'base64');
}
unset($_mail_attachment);
}
/*
$mail->AddAttachment("/path/to/file.zip");
$mail->AddAttachment("/path/to/image.jpg", "new.jpg"); // attachment
*/
if(is_array($_soubory_do_mailu)){
foreach($_soubory_do_mailu as $k => $_soubory){
//$mail->AddAttachment($_soubory, $_soubory_do_mailu_file[$k]);
$mail->AddEmbeddedImage(
$_soubory, // lokalni soubor
$_soubory_do_mailu_cid[$k], // ID shodné s HTML
$_soubory_do_mailu_file[$k], // zobrazený název souboru
'base64'); // MIME typ
//echo $_soubory.", ".$_soubory_do_mailu_file[$k]."
";
}
}
if($is_html == "html")
$mail->IsHTML(true); // send as HTML
if(!$mail->Send()) { // odešleme e-mail
echo "mail No send: " . $mail->ErrorInfo;
}
unset($_domain_mail);
}
function getHash($_count = 1){
$_hash = md5($_SERVER[REMOTE_ADDR].time());
while($_count > 0){
$_hash = md5($_hash.time()); $_count--;
}
return $_hash;
}
function getLoginsesshash($_id){
$_sql = "SELECT * FROM auth_users WHERE `ID` = '".mysql_real_escape_string($_id)."' LIMIT 0, 1";
MySQL_Query($_sql); // echo $_sql;
$vysledek = MySQL_Query($_sql);
$zaznam = MySQL_Fetch_Array($vysledek);
return $zaznam["hash"];
}
function getLogin($_sess = false , $_email = false, $_hash = false){
if($_sess){
$_sql = "SELECT * FROM auth_users WHERE `hash` = '".mysql_real_escape_string($_sess)."' LIMIT 0, 1";
MySQL_Query($_sql); // echo $_sql;
$vysledek = MySQL_Query($_sql);
$zaznam = MySQL_Fetch_Array($vysledek);
$_login_data[ID] = $zaznam["ID"];
$_login_data[enable] = $zaznam["enable"];
$_login_data[counter] = $zaznam["counter"];
$_login_data[email] = $zaznam["email"];
$_login_data[write] = $zaznam["write"];
$_login_data[block] = $zaznam["block"];
$_login_data[spam] = $zaznam["spam"];
if($_login_data[enable]){
$_login_data[logout] = "Odhlásit se: [ Deautorizovat prohlížeč ]";
}
return $_login_data;
}elseif($_email AND !$_hash){
$_sql = "SELECT * FROM auth_users WHERE `email` LIKE '".mysql_real_escape_string($_email)."' LIMIT 0, 1";
MySQL_Query($_sql); // echo $_sql;
$vysledek = MySQL_Query($_sql);
$zaznam = MySQL_Fetch_Array($vysledek);
if($zaznam["email"]){
$_go_hash = $zaznam["hash"];
}else{
$_go_hash = getHash(3);
$_sql = "INSERT INTO auth_users SET `email` = '".mysql_real_escape_string($_email)."', `hash` = '".$_go_hash."', `ip_adresa` = '".$_SERVER[REMOTE_ADDR]."'";
MySQL_Query($_sql); // echo $_sql;
}
$_act_hash = getHash();
$_sql = "INSERT INTO auth_users_send SET `email` = '".mysql_real_escape_string($_email)."', `hash` = '".$_go_hash."', `act_hast` = '".$_act_hash."', `send` = ".time().", `ip_adresa` = '".$_SERVER[REMOTE_ADDR]."'";
MySQL_Query($_sql); // echo $_sql;
$_sql = "DELETE FROM auth_users WHERE `lastlog` < ".(time() - 34300800);
MySQL_Query($_sql); // echo $_sql;
$_sql = "DELETE FROM auth_users_send WHERE `send` < ".(time() - 259200);
MySQL_Query($_sql); // echo $_sql;
$_sn_hash[go] = $_go_hash;
$_sn_hash[act] = $_act_hash;
return ($_sn_hash);
}elseif($_hash){
$_sql = "SELECT * FROM auth_users_send WHERE `act_hast` LIKE '".mysql_real_escape_string($_hash)."' LIMIT 0, 1";
MySQL_Query($_sql); // echo $_sql;
$vysledek = MySQL_Query($_sql);
$zaznam = MySQL_Fetch_Array($vysledek);
if($zaznam["hash"]){
$_log_ID = getLogin($zaznam["hash"]);
setcookie("CUID", $zaznam["hash"], (time() + 315360000));
$_COOKIE["CUID"] = $zaznam["hash"];
$_sql = "UPDATE auth_users SET `counter` = ".($_log_ID[counter] + 1).", `lastlog` = '".time()."', `ip_adresa` = '".$_SERVER[REMOTE_ADDR]."' WHERE ID = ".$_log_ID[ID];
MySQL_Query($_sql); // echo $_sql;
$_sql = "DELETE FROM auth_users_send WHERE `act_hast` LIKE '".mysql_real_escape_string($_hash)."'";
MySQL_Query($_sql); // echo $_sql;
return false;
}else{
return("Neplatný link");
}
}
}
function checkMail($_email = false){
$_email = trim($_email);
if(!$_email){$_email_res = "Zadejte Váš e-mail";}
elseif(!strpos($_email, "@")){$_email_res = "Neplatný e-mail";}
elseif(!strpos($_email, ".")){$_email_res = "Neplatný e-mail";}
elseif(strpos($_email, "@") >= strrpos($_email, ".")){$_email_res = "Neplatný e-mail";}
else{$_email_res = false;}
return $_email_res;
}
function GetSafeFileName($_file_name){
$_file_name = preg_replace('/[^a-zA-Z0-9-_\.]/','', $_file_name); $_file_name = seo_replace(Trim($_file_name), TRUE); $_file_name = str_replace("-", "_", $_file_name); $_file_name= str_replace("+", "_", $_file_name);
return($_file_name);
}
function getDevel(){
if($_COOKIE[devel] != "on"){unset($_COOKIE[devel]);}
$_devel_info["on"] = "Devel is enable - for disable click here: [ devel off ]";
$_devel_data[enable] = $_COOKIE[devel];
$_devel_data[status] = $_devel_info[$_COOKIE[devel]];
return $_devel_data;
}
?>