session_start();
//header('Content-Type: text/html; charset=utf-8');
define("DB_HOST_MN", "localhost");
define("DB_NAME_MN", "maximilian_teatrum");
define("DB_USER_MN","maximilian_www");
define("DB_PASSWORD_MN","sandbox#123!");
header('Content-Type: text/html; charset=utf-8');
//$mysqli_link_mn = mysqli_connect(DB_HOST_MN,DB_USER_MN,DB_PASSWORD_MN);
$mysqli_link_mn = mysqli_connect(DB_HOST_MN,DB_USER_MN,DB_PASSWORD_MN,DB_NAME_MN) or die("Error " . mysqli_error($mysqli_link_mn));
$mysqli_link_mn->set_charset("utf8");
//mysqli_select_db(DB_NAME_MN,$mysqli_link_mn) or die("");
/*
$mysqli = new mysqli("localhost", 'maximilian_www', 'sandbox#123!', 'maximilian_teatrum');
if ($mysqli->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
*/
//echo $mysqli_link_mn->host_info . "\n";
$moj_ip="95.49.147.199";
$zastrzezone=0;
if($_SERVER['REMOTE_ADDR']==$moj_ip){
$zastrzezone=1;
}
$zastrzezone=1;
mysqli_query('set character_set_database = utf8;');
mysqli_query('set character_set_server = utf8;');
mysqli_query('set character_set_system = utf8;');
mysqli_query('set collation_database = utf8_general_ci;');
mysqli_query('set collation_server = utf8_general_ci;');
mysqli_query('set names utf8;');
$_CONF_id_sklepu=3;
//if( ($_SESSION[www_id_sklep_v4]=="" && $_POST[dokasy_niezarejestrowany]=="ok") || ($_SESSION[www_id_sklep_v4]!="") ){
if($_POST[dokasy]=="ok" && $_SESSION[www_id_sklep_v4]!=""){
$old_sessionid = session_id();
session_regenerate_id();
$new_sessionid = session_id();
//echo "Stara sesja: $old_sessionid
";
//echo "Nowa sesja: $new_sessionid
";
}
if($_POST['action']!=""){$_GET['action']=$_POST['action'];}
if($_POST['p']!=""){$_GET['p']=$_POST['p'];}
if($_POST['id_p']!=""){$_GET['id_p']=$_POST['id_p'];}
//if($_POST['rozmiar']!=""){$_GET['rozmiar']=$_POST['rozmiar'];}
//if($_GET['rozmiar']!="")$_GET['id_r']=$_GET['rozmiar'];
if($_POST['id_r']!=""){$_GET['id_r']=$_POST['id_r'];}
$piec="no";
$if_strona_glowna=0;
if($_GET[id]==""){
$if_strona_glowna=1;
$piec="ok";
//$query_FI="SELECT * from tblsklep_v4_struktura WHERE Przodek like '0' AND PL_blokada NOT LIKE '1' ORDER BY Poziom,Priorytet ASC LIMIT 0,1";
$query_FI="SELECT * from tblsklep_v4_struktura WHERE Przodek like '0' AND PL_blokada NOT LIKE '1' ORDER BY Priorytet ASC LIMIT 0,1";
$result_FI=mysqli_query($mysqli_link_mn, $query_FI);
if($rekord_FI = mysqli_fetch_array ($result_FI)){
$_GET[id]=$rekord_FI[Id];
}
}
/*
mysqli_query("SET NAMES latin2");
mysqli_query("SET collation_connection = latin2_general_ci");
mysqli_query("SET CHARACTER SET latin2");
mysqli_query(" set character_set_connection=latin2");
mysqli_query(" set character_set_client=latin2");
mysqli_query(" set character_set_database=latin2");
mysqli_query(" set character_set_results=latin2");
mysqli_query(" set character_set_server=latin2");
mysqli_query(" set collation_database=latin2_general_ci");
mysqli_query(" set collation_server=latin2_general_ci");
*/
//mysqli_query($mysqli_link, "SET NAMES 'utf8'");
//header("content-type: text/html; charset=utf-8");
//$lg="PL";
$lg=$_SESSION[lg];
if($_GET[lg]!="")$_SESSION[lg]=$_GET[lg];
if($_SESSION[lg]==$_GET[lg])$lg=$_GET[lg];
//}
//if($_GET[lg]!="")$lg=$_GET[lg];
//if($lg!="PL" && $lg!="EN" && $lg!="DE" && $lg!="RU"){$lg="PL";}
if($lg=="")$lg="PL";
@include"inc/langs/".$lg.".php";
##########################################################################################################################
######################################################### CONFIG #########################################################
##########################################################################################################################
$query_ES = "SELECT * from tblsklep_v4_config";
$result_ES=mysqli_query($mysqli_link_mn, $query_ES);
while($rekord_ES = mysqli_fetch_array ($result_ES)){
$BZM[]=$rekord_ES['Zmienna'];
}
//print_r($BZM);
/*
[0] => CONF_dotpay_id
[1] => CONF_email
[2] => CONF_haslo
[3] => CONF_smtp
[4] => CONF_nazwa_sklepu
[5] => CONF_www
[6] => CONF_email_receiver
*/
foreach($BZM as $kay => $var){
$query="SELECT * FROM tblsklep_v4_config where Zmienna='".$var."'";
$mysqli_result=mysqli_query($mysqli_link_mn, $query);
if ($rekord = mysqli_fetch_array ($mysqli_result)){
${"CONF_".$var}=$rekord['Wartosc'];
}
}
$STRONA_NAZWA=$CONF_nazwa_sklepu;
$STRONA_ADRESWWW=$CONF_www;
$STRONA_EMAILHOST=$CONF_smtp;
$STRONA_EMAILUSERNAME=$CONF_email;
$STRONA_EMAILPASSWORD=$CONF_haslo;
$STRONA_NEWSLETTERFROM=$CONF_email;
$STRONA_NEWSLETTERSENDER=$CONF_email;
$STRONA_NEWSLETTERFROMNAME=$CONF_email;
$STRONA_NEWSLETTERREPLYTO=$CONF_email;
$email_sklepu=$CONF_email_receiver;
##########################################################################################################################
######################################################### CONFIG #########################################################
##########################################################################################################################
/*
$STRONA_NAZWA="sklep_v4";
$STRONA_ADRESWWW="http://www.web.na16.pl/sklep_v4";
$STRONA_EMAILHOST="mail.web.na16.pl";
$STRONA_EMAILUSERNAME="sklep@web.na16.pl";
$STRONA_EMAILPASSWORD="123456";
$STRONA_NEWSLETTERFROM="sklep@web.na16.pl";
$STRONA_NEWSLETTERSENDER="sklep@web.na16.pl";
$STRONA_NEWSLETTERFROMNAME="sklep@web.na16.pl";
$STRONA_NEWSLETTERREPLYTO="sklep@web.na16.pl";
*/
$query_FI="SELECT * from tblsklep_v4_struktura WHERE Przodek LIKE '0' AND ".$lg."_blokada NOT LIKE '1' ORDER BY Priorytet ASC LIMIT 0,1";
$result_FI=mysqli_query($mysqli_link_mn, $query_FI);
if($rekord_FI = mysqli_fetch_array ($result_FI)){
$STRONA_ID_GLOWNA=$rekord_FI[Id];
}
/*
if($_GET[id]==""){
$_GET[id]=$STRONA_ID_GLOWNA;
}
*/
/*
$STRONA_ID_GLOWNA=114;
$STRONA_ID_AKTUALNOSCI=173;
$STRONA_ID_WYDARZENIA=174;
$STRONA_ID_IMPREZY=176;
*/
//if($_GET[id]==$STRONA_ID_GLOWNA){
// $_GET[id]="";
// header("location:index.php");
//exit();
//}
//$langs=array("PL","EN","RU","DE");
//$obowiazkowe="PL";
################################## SET TMP ##################################
/*
if($_GET[id]!=""){
$query = "SELECT * from tblsklep_v4_struktura where Id LIKE '".$_GET[id]."' ";
$result=mysqli_query($query);
if($rekord = mysqli_fetch_array ($result)){
$PHOTO_naglowek=$rekord[Naglowek];
$szablon=$rekord[Szablon];
$kategoria_tytul=$rekord[$lg.'_nazwa'];
$nazwa_dz_st=$kategoria_tytul;
}
}
else{
if($_GET[iz]==1){
$szablon="3kolumny_tekst";
$nazwa_dz_st="Mapa Serwisu";
}else{
$szablon="strona_glowna";
$nazwa_dz_st="Strona Główna";
}
}
*/
################################## SET TMP ##################################
include ("inc/w_functions.php");
if($_GET[id]!=""){
GetPoziom1($_GET[id],$lg);
if($ID_Miasta_tytul!=""){
//print"1";
$Poziom1_tytul=$ID_Miasta_tytul;
$queryS = "SELECT * from tblsklep_v4_struktura where Id LIKE '".$_GET[id]."'";
$resultS=mysqli_query($mysqli_link_mn, $queryS);
if($rekordS = mysqli_fetch_array ($resultS)){
//print"2";
if($rekordS[Poziom]==3){
//print"3";
$queryT="SELECT * from tblsklep_v4_tresci WHERE Id>0 ";
$queryT.=" AND Blokada NOT LIKE '1' ";
$queryT.=" AND Kategorie LIKE '%,".$_GET[id].",%' ";
$queryT.=" AND Lang LIKE '".$lg."' ";
$resultT=mysqli_query($mysqli_link_mn, $queryT);
if($rekordT = mysqli_fetch_array ($resultT)){
}else{
//print"4";
$queryP = "SELECT * from tblsklep_v4_struktura where ".$lg."_blokada NOT LIKE '1' AND Menu_lewe LIKE '1' AND Przodek LIKE '".$rekordS[Id]."' ORDER BY Priorytet ASC";
$resultP=mysqli_query($mysqli_link_mn, $queryP);
if($rekordP = mysqli_fetch_array ($resultP)){
//print"5";
//header("location:index.php?id=".$rekordP[Id]);
//exit();
}
}
}
}
}
}
//$AZM=Array("LN_kontakt","LN_galeria_zdjec","LN_uzupelnij","LN_zlyemail","LN_imie","LN_nazwisko","LN_firma","LN_temat","LN_tresc","LN_wyslij","LN_wybierz_jezyk","LN_wz_wyslana","LN_strona_glowna","LN_czytaj_wiecej","LN_cofnij","LN_przepisz_kod","LN_zly_kod","LN_adres","LN_telfax","LN_zobacz");
$query_ES = "SELECT * from tblsklep_v4_wersje_elstale";
$result_ES=mysqli_query($mysqli_link_mn, $query_ES);
while($rekord_ES = mysqli_fetch_array ($result_ES)){
$AZM[]=$rekord_ES['zmienna'];
}
//$tabks=Array("index","inc/config","admin/inc/config");
foreach($AZM as $kay => $var){
$query="SELECT * FROM tblsklep_v4_wersje_elstale where zmienna='".$var."'";
$mysqli_result=mysqli_query($mysqli_link_mn, $query);
if ($rekord = mysqli_fetch_array ($mysqli_result)){
${$var}=$rekord[$lg.'_nazwa'];
}
}
/*
$LN_przepisz_kod
$LN_zly_kod
$LN_czytaj_wiecej
$LN_cofnij
$LN_strona_glowna
$LN_uzupelnij
$LN_zlyemail
$LN_imie
$LN_nazwisko
$LN_firma
$LN_temat
$LN_tresc
$LN_wyslij
$LN_wybierz_jezyk
$LN_wz_wyslana
*/
// START WERYFIKACJA
/*
if($_GET[antt]==1){
$query="SELECT * FROM tblsklep_v4_newsletter_emails where Md5='".$_GET[ac]."' and Autoryzacja='0'";
$mysqli_result=mysqli_query($query);
if ($rekord = mysqli_fetch_array ($mysqli_result))
{
$query2="UPDATE tblsklep_v4_newsletter_emails set Autoryzacja='1' WHERE Id='".$rekord[Id]."'";
$mysqli_result2=mysqli_query($query2);
$alert="Autoryzacja zakończona pomyślnie.";
}
}
*/
//else{
// END WERYFIKACJA
//print $_GET[id];
//if($_GET[id]=="")$_GET[id]=10;
if($_GET[id]!="")$id_kat=$_GET[id];
//if($_GET[id]!=""){
//$kat=$_GET[id];
//}
if($_POST[rejestruj]=="ok" && $_POST[email]!="" && $_POST[haslo]!="" ){
########################################################################################################
/*
$haslo="";
$litery = "abcdefghijkmnpqrstuvwxyz23456789";
srand(time());
for ($i=0;$i<6;$i++){
$haslo.= substr($litery,(rand()%(strlen($litery))),1);
}
*/
$autoryzacja=1;
//Id Grupa Login Password Time_in Time_ll Host_in Host_ll Imie Nazwisko Firma NIP REGON PESEL Ulica Kod Miasto Kraj Tel Fax Email Skype GG Autoryzacja Blokada Rabat
$md5_haslo=md5($_POST[haslo]);
$query_upd="insert into tblsklep_v4_klienci(NIP,Password,Firma,Imie,Ulica,Kod,Miasto,Tel,Fax,Email,Autoryzacja,Host_in,Time_in,Grupa,Rabat)values";
$query_upd.="('".$_POST[nip]."','".$md5_haslo."','".$_POST[firma]."','".$_POST[imie]."','".$_POST[ulica]."','".$_POST[kod]."','".$_POST[miasto]."','".$_POST[tel]."','".$_POST[fax]."','".$_POST[email]."','".$autoryzacja."','".$_SERVER['REMOTE_ADDR']."','".(time())."','".$_POST[grupa]."','".$rabat."')";
$mysqli_result_upd=mysqli_query($mysqli_link_mn, $query_upd);
$id_rej=mysqli_insert_id();
$query="select * from tblsklep_v4_klienci where Id LIKE '".$id_rej."' ";
$mysqli_result=mysqli_query($mysqli_link_mn, $query);
if ($row=mysqli_fetch_array($mysqli_result)){
$_SESSION[www_id_sklep_v4]=$row[Id];
$_SESSION[www_grupa_sklep_v4]=$row[Grupa];
$_SESSION[www_Imie_sklep_v4]=$row[Imie];
$_SESSION[www_Email_sklep_v4]=$row[Email];
}
//if($_POST[c_newsletter]==1){
// $time_in=time();
// $md5_time_in=md5($time_in);
// $grupa_newslettera=1;
// $query_upd="insert into tblsklep_v4_newsletter_emails(Md5,Email,Autoryzacja,Host,Time_in,Grupa)values('".$md5_time_in."','$_POST[email]','1','".$_SERVER['REMOTE_ADDR']."','".(time())."','".$grupa_newslettera."')";
//$mysqli_result_upd=mysqli_query($query_upd);
//}
######################################################## send mail
if($id_rej){
require("inc/phpmailer/class.phpmailer.php");
$mail = new PHPMailer();
$mail->PluginDir = "inc/phpmailer/";
$mail->From = $STRONA_NEWSLETTERFROM;
$mail->FromName = $STRONA_NEWSLETTERFROMNAME;
$mail->Sender=$STRONA_NEWSLETTERSENDER; // indicates ReturnPath header
$mail->AddReplyTo($STRONA_NEWSLETTERREPLYTO); // indicates ReplyTo headers
$mail->Host = $STRONA_EMAILHOST;
$mail->Mailer = "smtp";
$mail->Username = $STRONA_EMAILUSERNAME;
$mail->Password = $STRONA_EMAILPASSWORD;
$mail->SMTPAuth = true;
//$mail->IsHTML(true);
//$mail->AddAttachment("zal/".$plik_name);
$mail->SetLanguage("pl", "inc/phpmailer/language/");
$subject="Rejestracja w sklepie ".$STRONA_NAZWA;
$subject = iconv ("UTF-8", "ISO-8859-2", $subject);
$mail->Subject = $subject;
$message="";
$message.="Witaj,\n";
$message .= "Twoje dane potrzebne do zalogowania się w sklepie ".$STRONA_NAZWA.": \n\n";
$message.="Login: ".$_POST[email]."\n";
$message.="Hasło: ".$_POST[haslo]."\n\n";
//$message .= "Twój adres e-mail został dodany przez Ciebie lub inną osobę do newslettera serwisu ".$STRONA_NAZWA." \n";
//$message .= "Aby zakończyć proces rejestracji musisz uruchomić poniższy link.\n";
//$message .= $STRONA_ADRESWWW."/index.php?m=2&ac=".$md5_time_in."\n\n";
$message .= "pozdrawiamy,\n";
$message .= $STRONA_NAZWA."\n";
$message = iconv ("UTF-8", "ISO-8859-2", $message);
$mail->Body = $message;
$mail->AddAddress($_POST[email]);
if(!$mail->Send())echo"";/* $mail->ErrorInfo."
";*/
$mail->ClearAddresses();
$mail->ClearAttachments();
}
######################################################## send mail
//$alert="Na podany adres E-mail została wysłana wiadomość potwierdzająca rejestrację w sklepie.";
header("location:index.php?p=c®=ok");
exit;
#######################################################################################################
}
if($_POST[cpass1]=="ok" && $_POST[email]!="" ){
########################################################################################################
$query_CPK1="select * from tblsklep_v4_klienci where Email LIKE '".$_POST['email']."' ";
$mysqli_result_CPK1=mysqli_query($mysqli_link_mn, $query_CPK1);
if ($rekord_CPK1=mysqli_fetch_array($mysqli_result_CPK1)){
$litery = "abcdefghijkmnpqrstuvwxyz23456789";
srand(time());
for ($i=0;$i<6;$i++){
$haslo.= substr($litery,(rand()%(strlen($litery))),1);
}
$haslo_md5=md5($haslo);
$query_del="DELETE FROM tblsklep_v4_klienci_hasla_zmiana WHERE Id_klienta LIKE '".$rekord_CPK1['Id']."' ";
$mysqli_result_del=mysqli_query($mysqli_link_mn, $query_del);
$query_upd="insert into tblsklep_v4_klienci_hasla_zmiana(Md5,Id_klienta,Login,Email,Old_Password,New_Password,Time_in,Host_in,Autoryzacja,Blokada)values";
$query_upd.="('".$haslo_md5."','".$rekord_CPK1['Id']."','','".$_POST['email']."','','','".(time())."','".$_SERVER['REMOTE_ADDR']."','0','0')";
$mysqli_result_upd=mysqli_query($mysqli_link_mn, $query_upd);
$id_rej=mysqli_insert_id();
######################################################## send mail
require("inc/phpmailer/class.phpmailer.php");
$mail = new PHPMailer();
$mail->PluginDir = "inc/phpmailer/";
$mail->From = $STRONA_NEWSLETTERFROM;
$mail->FromName = $STRONA_NEWSLETTERFROMNAME;
$mail->Sender=$STRONA_NEWSLETTERSENDER; // indicates ReturnPath header
$mail->AddReplyTo($STRONA_NEWSLETTERREPLYTO); // indicates ReplyTo headers
$mail->Host = $STRONA_EMAILHOST;
$mail->Mailer = "smtp";
$mail->Username = $STRONA_EMAILUSERNAME;
$mail->Password = $STRONA_EMAILPASSWORD;
$mail->SMTPAuth = true;
//$mail->IsHTML(true);
//$mail->AddAttachment("zal/".$plik_name);
$mail->SetLanguage("pl", "inc/phpmailer/language/");
$subject="Zmiana Twojego hasła w sklepie ".$STRONA_NAZWA;
$subject = iconv ("UTF-8", "ISO-8859-2", $subject);
$mail->Subject = $subject;
$message="";
$message.="Witaj,\n";
$message .= "Aby dokończyć proces zmiany Twojego hasła w sklepie ".$STRONA_NAZWA." uruchom ponizszy link: \n\n";
$message .= $STRONA_ADRESWWW."/index.php?p=zh&id=".$rekord_CPK1['Id']."&code=".$haslo_md5."\n\n";
$message .= "pozdrawiamy,\n";
$message .= $STRONA_NAZWA."\n";
$message = iconv ("UTF-8", "ISO-8859-2", $message);
$mail->Body = $message;
$mail->AddAddress($_POST[email]);
if(!$mail->Send())echo"";/* $mail->ErrorInfo."
";*/
$mail->ClearAddresses();
$mail->ClearAttachments();
######################################################## send mail
//$alert="Na podany adres E-mail została wysłana wiadomość potwierdzająca rejestrację w sklepie.";
header("location:index.php?p=zh&hs=1");
exit;
#######################################################################################################
}else{
// $kom_CPK1="W bazie nie ma użytkownika o podanym adresie e-mail.";
header("location:index.php?p=zh&hs=0");
exit;
}
}
// http://grzegorzp.multiciti.com/index.php?p=zh&id=8&code=2321339337bab8c66540f74ffbcaa50d
if($_GET[p]=="zh" && $_GET[id]!="" && $_GET[code]!="" ){
$query_CPK1="select * from tblsklep_v4_klienci_hasla_zmiana where Md5 LIKE '".$_GET[code]."' AND Id_klienta LIKE '".$_GET['id']."' ";
$mysqli_result_CPK1=mysqli_query($mysqli_link_mn, $query_CPK1);
if ($rekord_CPK1=mysqli_fetch_array($mysqli_result_CPK1)){
$query_CPK2="select * from tblsklep_v4_klienci where Id LIKE '".$rekord_CPK1['Id_klienta']."' ";
$mysqli_result_CPK2=mysqli_query($mysqli_link_mn, $query_CPK2);
if ($rekord_CPK2=mysqli_fetch_array($mysqli_result_CPK2)){
$litery = "abcdefghijkmnpqrstuvwxyz23456789";
srand(time());
for ($i=0;$i<6;$i++){
$haslo.= substr($litery,(rand()%(strlen($litery))),1);
}
$haslo_md5=md5($haslo);
$query_ll="update tblsklep_v4_klienci set Password='".$haslo_md5."' where Id like '".$rekord_CPK1['Id_klienta']."' ";
$mysqli_result_ll=mysqli_query($mysqli_link_mn, $query_ll);
######################################################## send mail
require("inc/phpmailer/class.phpmailer.php");
$mail = new PHPMailer();
$mail->PluginDir = "inc/phpmailer/";
$mail->From = $STRONA_NEWSLETTERFROM;
$mail->FromName = $STRONA_NEWSLETTERFROMNAME;
$mail->Sender=$STRONA_NEWSLETTERSENDER; // indicates ReturnPath header
$mail->AddReplyTo($STRONA_NEWSLETTERREPLYTO); // indicates ReplyTo headers
$mail->Host = $STRONA_EMAILHOST;
$mail->Mailer = "smtp";
$mail->Username = $STRONA_EMAILUSERNAME;
$mail->Password = $STRONA_EMAILPASSWORD;
$mail->SMTPAuth = true;
//$mail->IsHTML(true);
//$mail->AddAttachment("zal/".$plik_name);
$mail->SetLanguage("pl", "inc/phpmailer/language/");
$subject="Twoje nowe hasło w sklepie ".$STRONA_NAZWA;
$subject = iconv ("UTF-8", "ISO-8859-2", $subject);
$mail->Subject = $subject;
$message="";
$message.="Witaj,\n";
$message .= "Twoje nowe hasło w sklepie ".$STRONA_NAZWA." to: \n\n".$haslo." \n\nMożesz sie teraz zalogować: \n";
$message .= $STRONA_ADRESWWW."\n\n";
$message .= "pozdrawiamy,\n";
$message .= $STRONA_NAZWA."\n";
$message = iconv ("UTF-8", "ISO-8859-2", $message);
$mail->Body = $message;
$mail->AddAddress($rekord_CPK2['Email']);
if(!$mail->Send())echo"";/* $mail->ErrorInfo."
";*/
$mail->ClearAddresses();
$mail->ClearAttachments();
######################################################## send mail
$query_del="DELETE FROM tblsklep_v4_klienci_hasla_zmiana WHERE Id_klienta LIKE '".$rekord_CPK1['Id_klienta']."' ";
$mysqli_result_del=mysqli_query($mysqli_link_mn, $query_del);
header("location:index.php?p=zh&hs=3");
exit;
}
}
}
//@include"inc/functions.php";
@include"inc/functions_cart.php";
/* ===================================================== */
if (($_POST[loguj]=="ok")&&($_POST[login]!="")&&($_POST[haslo]!="")){
$md5_haslo=md5($_POST[haslo]);
if($_POST['typ_klient'] == "h"){
$query="select * from tblsklep_v4_klienci where Blokada NOT LIKE '1' AND Email = '".$_POST['login']."' and Password = '".$md5_haslo."' AND Grupa LIKE '2' ";
}else{
$query="select * from tblsklep_v4_klienci where Blokada NOT LIKE '1' AND Email = '".$_POST['login']."' and Password = '".$md5_haslo."' ";
}
$mysqli_result=mysqli_query($mysqli_link_mn, $query);
if ($row=mysqli_fetch_array($mysqli_result)){
$_SESSION[www_id_sklep_v4]=$row[Id];
$_SESSION[www_grupa_sklep_v4]=$row[Grupa];
$_SESSION[www_Imie_sklep_v4]=$row[Imie];
$_SESSION[www_Email_sklep_v4]=$row[Email];
$query_ll="update tblsklep_v4_klienci set Time_ll='".time()."' where id like '".$row[id]."' ";
$mysqli_result_ll=mysqli_query($mysqli_link_mn, $query_ll);
}
}
if ($_GET[button]=="Wyloguj"){
$_SESSION[www_id_sklep_v4]="";
$_SESSION[www_grupa_sklep_v4]="";
$_SESSION[www_Imie_sklep_v4]="";
$_SESSION[www_Email_sklep_v4]="";
$_SESSION['w18']="";
//print"";
header("location:index.php");
exit;
}
//print $_SESSION[www_grupa_sklep_v4];
if($_POST[zapytanie]=="ok" && $_POST[email]!="" && $_POST[imie]!="" ){
########################################################################################################
require("inc/phpmailer/class.phpmailer.php");
$mail = new PHPMailer();
$mail->PluginDir = "inc/phpmailer/";
$mail->From = $STRONA_NEWSLETTERFROM;
$mail->FromName = $STRONA_NEWSLETTERFROMNAME;
$mail->Sender=$STRONA_NEWSLETTERSENDER; // indicates ReturnPath header
$mail->AddReplyTo($STRONA_NEWSLETTERREPLYTO); // indicates ReplyTo headers
$mail->Host = $STRONA_EMAILHOST;
$mail->Mailer = "smtp";
$mail->Username = $STRONA_EMAILUSERNAME;
$mail->Password = $STRONA_EMAILPASSWORD;
$mail->SMTPAuth = true;
//$mail->IsHTML(true);
//$mail->AddAttachment("zal/".$plik_name);
$mail->SetLanguage("pl", "inc/phpmailer/language/");
$subject="Zapytanie ofertowe";
$subject = iconv ("UTF-8", "ISO-8859-2", $subject);
$mail->Subject = $subject;
$message="";
$message.="Zapytanie ofertowe:\n\n";
$message.="Imię: ".$_POST[imie]."\n";
$message.="Tel.: ".$_POST[tel]."\n";
$message.="Email: ".$_POST[email]."\n\n";
$message.="Treść: ".$_POST[tresc]."\n";
$message = iconv ("UTF-8", "ISO-8859-2", $message);
$mail->Body = $message;
$mail->AddAddress("jimij@poczta.onet.pl");
if(!$mail->Send())echo"";/* $mail->ErrorInfo."
";*/
$mail->ClearAddresses();
$mail->ClearAttachments();
######################################################## send mail
header("location:index.php?p=i&id=16&zap=ok");
exit;
#######################################################################################################
}
$rabat_now=0;
if($_SESSION['www_id_sklep_v4']!=""){
$query="select * from tblsklep_v4_klienci where Id LIKE '".$_SESSION['www_id_sklep_v4']."' ";
$mysqli_result=mysqli_query($query);
if ($row=mysqli_fetch_array($mysqli_result)){
$rabat_now=$row['Rabat'];
}
}
if($_GET['alert']!=""){$alert=$_GET['alert'];}
############################ w18############################ w18############################ w18
############################ w18############################ w18############################ w18
############################ w18############################ w18############################ w18
if($_SESSION['w18']==""){$w18="n";}
if($_POST['w18']=="t"){
$_SESSION['w18']="t";
header("location:index.php");
exit;
}
if($_POST['w18']=="n"){
$_SESSION['w18']="n";
header("location:index.php?p=k".$_POST['k']."&id=".$_POST['id']);
exit;
}
if($_GET['p']=="k" && $_GET['id']!=""){
$query_KAT="SELECT * from tblsklep_v4_struktura WHERE Id LIKE '".$_GET['id']."' ";
$result_KAT=mysqli_query($query_KAT);
if($rekord_KAT = mysqli_fetch_array ($result_KAT)){
if($rekord_KAT['Check1']==1){
//$_SESSION['w18']="t";
$w18="t";
}else{
$w18="n";
}
}
}
if($_SESSION['w18']=="t"){$w18="t";}
if($_SESSION['w18']=="n"){$w18="n";}
############################ w18############################ w18############################ w18
############################ w18############################ w18############################ w18
############################ w18############################ w18############################ w18
function PLtoLink($string)
{
$string=str_replace(" ","-",$string);
$string=str_replace("'","",$string);
$string=str_replace('"','',$string);
$string=str_replace("„",'"',$string);
$string=str_replace("”",'"',$string);
$string=str_replace("Ż","Z",$string);
$string=str_replace("Ź","Z",$string);
$string=str_replace("Ć","C",$string);
$string=str_replace("Ń","N",$string);
$string=str_replace("Ą","A",$string);
$string=str_replace("Ś","S",$string);
$string=str_replace("Ł","L",$string);
$string=str_replace("Ę","E",$string);
$string=str_replace("Ó","O",$string);
$string=str_replace("ż","z",$string);
$string=str_replace("ź","z",$string);
$string=str_replace("ć","c",$string);
$string=str_replace("ń","n",$string);
//$string=str_replace("�","a",$string);
$string=str_replace("ą","a",$string);
$string=str_replace("ś","s",$string);
$string=str_replace("ł","l",$string);
$string=str_replace("ę","e",$string);
$string=str_replace("ó","o",$string);
$string=str_replace(".","",$string);
$string=str_replace(";","",$string);
$string=str_replace(",","",$string);
$string=str_replace(":","",$string);
$string=str_replace("/","",$string);
$string=str_replace("~","",$string);
$string=str_replace("!","",$string);
$string=str_replace("@","",$string);
$string=str_replace("#","",$string);
$string=str_replace("$","",$string);
$string=str_replace("%","",$string);
$string=str_replace("^","",$string);
$string=str_replace("&","-and-",$string);
$string=str_replace("*","",$string);
$string=str_replace("(","",$string);
$string=str_replace(")","",$string);
$string=str_replace("+","",$string);
$string=str_replace("=","",$string);
$string=str_replace("|","",$string);
//$string=str_replace("\","",$string);
$string=str_replace("----","-",$string);
$string=str_replace("---","-",$string);
$string=str_replace("--","-",$string);
return $string;
}
?>