if(isset($_GET['prvdovrv']) or empty($_GET)) {
header("Location: https://prvdovrv.mk/register.php?e=vodno&p=basic");
}
?>
session_start();
include 'dbconnect.php';
// convert cyr to lat
function convertCyrToLat($key){
$contains_cyrillic = (bool) preg_match('/[\p{Cyrillic}]/u', $key);
if ($contains_cyrillic) {
$textcyr = $key;
$cyr = array('а','б','в','г','д','ѓ','е','ж','з','ѕ','и','ј','к','л','љ','м','н','њ','о','п','р','с','т','ќ','у',
'ф','х','ц','ч','џ','ш','щ','ъ','ь', 'ю','я','А','Б','В','Г','Д','Ѓ','Е','Ж','З','S','И','Ј','К','Л','Љ','М','Н','Њ','О','П','Р','С','Т','Ќ','У',
'Ф','Х','Ц','Ч','Џ','Ш','Щ','Ъ','Ь', 'Ю','Я' );
$lat = array( 'a','b','v','g','d','gj','e','zh','z','dz','i','j','k','l','lj','m','n','nj','o','p','r','s','t','kj','u',
'f' ,'h' ,'c' ,'ch','dj','sh' ,'sht' ,'a' ,'y' ,'yu' ,'ya','A','B','V','G','D','Gj','E','Zh',
'Z','Dz','I','J','K','L','Lj','M','N','Nj','O','P','R','S','T','Kj','U',
'F' ,'H' ,'C' ,'Ch','Dj','Sh' ,'Sht' ,'A' ,'Y' ,'Yu' ,'Ya' );
$prezimelat = str_replace($cyr, $lat, $textcyr);
} else {
$prezimelat = $key;
}
return $prezimelat;
}
?>
if(isset($_GET['ocr'])){ ?>
Регистрација за OCR SKOPJE 2024
} else { ?>
Регистрација за ПРВ ДО ВРВ 2024
} ?>
if(isset($_GET['prvdovrv'])) {
?>
Регистрација за ПРВ ДО ВРВ Водно 2024
}
?>
if(isset($_GET['sharra'])) {
?>
Регистрација за Sharra Challenge 2019
}
?>
if(isset($_GET['beachrun'])) {
?>
Регистрација за Beach Run 2019
}
?>
if(isset($_GET['meeting'])) {
?>
Регистрација за AAM Skopje 2019
}
?>
if(isset($_GET['tourdelake'])) {
?>
Регистрација за Tour de Lake(s) 2019
}
?>
if(isset($_GET['ocr']) or isset($_GET['hello-ocr'])){ ?>
} else { ?>
} ?>
/*
if (empty($_GET)) {
header("Location: https://prvdovrv.mk/register.php?e=vodno&p=basic");
}
*/
?>
if(isset($_GET['personal'])) {
?>
}
?>
if(isset($_GET['prvdovrv2021'])) {
?>
}
?>
if(isset($_GET['prvdovrv2023'])) {
if(isset($_GET['r'])){
$r = $_GET["r"];
$sql = "UPDATE sent_emails SET btt_click = btt_click + 1 WHERE recipient_uniqueid='$r'";
mysqli_query($conn, $sql);
}
$cena_basic = 600;
$cena_plus = 1000;
$date_from = '2023-02-07';
$date_to = '2023-02-19';
if (isset($_GET['z'])){
$z = $_GET['z'];
} else {
$z = '0';
}
?>
SPARKASSE LIFE PRVDOVRV 2023
Пријавувањето е затворено.
}
?>
if(isset($_GET['e'])){
if($_GET['e']=='vodno' and (($_GET['p']=='basic' or $_GET['p']=='plus'))) {
if(isset($_GET['r'])){
$r = $_GET["r"];
$sql = "UPDATE sent_emails SET btt_click = btt_click + 1 WHERE recipient_uniqueid='$r'";
mysqli_query($conn, $sql);
}
$cena_basic = 400;
$cena_plus = 800;
$date_from = '2024-12-10';
$date_to = '2024-12-15';
if (isset($_GET['z'])){
$z = $_GET['z'];
} else {
$z = '0';
}
$reg_status='closed';
if ($reg_status=='closed'){
$reg_alert='block';
$reg_form='none';
}else{
$reg_alert='none';
$reg_form='block';
}
?>
PRVDOVRV 2025
Пријавувањето е затворено.
}
}
?>
if(isset($_GET['ocr'])){
if(isset($_GET['r'])){
$r = $_GET["r"];
$sql = "UPDATE sent_emails SET btt_click = btt_click + 1 WHERE recipient_uniqueid='$r'";
mysqli_query($conn, $sql);
}
$cena_basic = 600;
$cena_plus = 1000;
$date_from = '2023-02-07';
$date_to = '2023-02-19';
if (isset($_GET['z'])){
$z = $_GET['z'];
} else {
$z = '0';
}
?>
Регистрација за OCR SKOPJE 2024
Пријавувањето е затворено.
}
?>
if(isset($_GET['zenskatrka'])) {
?>
Пријава за Sparkasse Life PRVDOVRV 2024 за учесничките во Женска Трка
Пријавувањето е затворено.
}
?>
if(isset($_GET['skopskimaraton'])) {
?>
Пријава за Sparkasse Life PRVDOVRV 2025 за учесниците на Скопски Маратон
Пријавувањето е затворено.
}
?>
if(isset($_GET['valentine'])) {
if(isset($_GET['r'])){
$r = $_GET["r"];
$sql = "UPDATE sent_emails SET btt_click=1 WHERE recipient_uniqueid='$r'";
mysqli_query($conn, $sql);
}
$cena_basic = 600;
$cena_plus = 1000;
$date_from = '2023-02-07';
$date_to = '2023-02-19';
?>
VALENTINE регистрација за ПРВДОВРВ ВОДНО 2023
if(date("Y-m-d") < $date_from or date("Y-m-d") > $date_to) { ?> Промоцијата е затворена.
} ?>
}
?>
if(isset($_GET['intwomenday'])) {
if(isset($_GET['r'])){
$r = $_GET["r"];
$sql = "UPDATE sent_emails SET btt_click=1 WHERE recipient_uniqueid='$r'";
mysqli_query($conn, $sql);
}
$cena_basic = 1200;
$cena_plus = 2400;
$date_from = '2023-03-06';
$date_to = '2023-03-09';
?>
INT. WOMEN DAY регистрација за ПРВДОВРВ ВОДНО 2023
if(date("Y-m-d") < $date_from or date("Y-m-d") > $date_to) { ?> Промоцијата е затворена.
} ?>
}
?>
if(isset($_GET['svtrifun'])) {
if(isset($_GET['r'])){
$r = $_GET["r"];
$sql = "UPDATE sent_emails SET btt_click=1 WHERE recipient_uniqueid='$r'";
mysqli_query($conn, $sql);
}
$cena_basic = 1050;
$cena_plus = 1650;
$date_from = '2023-02-07';
$date_to = '2023-02-19';
?>
Св. Трифун регистрација за ПРВДОВРВ ВОДНО 2023
if(date("Y-m-d") < $date_from or date("Y-m-d") > $date_to) { ?> Промоцијата е затворена.
} ?>
}
?>
if(isset($_GET['autumnrun'])) {
?>
Есенска 5К 2020
Пријавувањето е затворено.
}
?>
if(isset($_GET['springrun'])) {
?>
}
?>
if(isset($_GET['prvdovrv2019'])) {
?>
}
?>
if(isset($_GET['sharra'])) {
?>
}
?>
if(isset($_GET['business2017'])) {
?>
Бизнис регистрација ПРВ ДО ВРВ 2017
}
?>
if(isset($_GET['business2018'])) {
?>
Бизнис регистрација ПРВ ДО ВРВ Водно 2018
}
?>
if(isset($_GET['business2019'])) {
?>
Бизнис регистрација ПРВ ДО ВРВ Водно 2019
}
?>
if(isset($_GET['business'])) {
?>
Бизнис регистрација ПРВДОВРВ Водно 2024
}
?>
if(isset($_GET['business_dmt'])) {
?>
Бизнис регистрација COCA-COLA ДЕДОМРАЗОВСКА ТРКА 2023
}
?>
if(isset($_GET['summitrun2019'])) {
?>
Регистрација за Summit Run Vodno 2019
}
?>
if(isset($_GET['summitrun-ex-2023'])) {
$cena_basic = 600;
$cena_plus = 1000;
$date_from = '2023-02-07';
$date_to = '2023-02-19';
if (isset($_GET['z'])){
$z = $_GET['z'];
} else {
$z = '0';
}
?>
Регистрација за Summit Run 2024
Пријавувањето ќе биде отворено наскоро.
}
?>
if(isset($_GET['summitrun'])) {
$cena_basic = 400;
$cena_plus = 800;
$date_from = '2024-12-01';
$date_to = '2024-12-15';
if (isset($_GET['z'])){
$z = $_GET['z'];
} else {
$z = '0';
}
$reg_status='open';
if ($reg_status=='closed'){
$reg_alert='block';
$reg_form='none';
}else{
$reg_alert='none';
$reg_form='block';
}
?>
Регистрација за Summit Run 2025
Пријавувањето ќе биде отворено наскоро.
}
?>
if(isset($_GET['business_santa'])) {
?>
Бизнис регистрација за Coca-Cola Дедомразовска трка 2024
Пријави го тимот на твојата компанија со пополнување на овој формулар. Во следниот чекор ќе треба да се внесат податоците за членовите на тимот. За повеќе тимови од една компанија, се пополнува посебна пријава за секој тим.
}
?>
if(isset($_GET['teammates'])) {
$firma = $_POST['firma'];
$adresa = $_POST['adresa'];
$lice = $_POST['person'];
$email = $_POST['email'];
$telefon = $_POST['telefon'];
$teamname = $_POST['teamname'];
$qucesnici = $_POST['q'];
$email_buyer = $email;
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
$connA = mysqli_connect($servername, $username, $password, $dbname);
mysqli_set_charset($connA,"utf8");
$result = mysqli_query($connA, "SELECT * FROM events where id=43");
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
$cenareal=$row['cena2'];
$iznos=$cenareal * $qucesnici;
$cena=$iznos."00";
//$opis = $row['ime'];
$desc = "Summit Run 2023";
$opis = "Summit Run 2023";
$godina=$row['godina'];
$datum=date("Y-m-d H:i:s", strtotime('+0 hours'));
$ipadresa=$_SERVER["REMOTE_ADDR"];
$trka="PDV";
$note="PDV 2024 summit";
$product="Котизација за учество на PRVDOVRV SUMMIT RUN 2024";
$mysql_result = mysqli_query($conn, "SHOW TABLE STATUS LIKE 'sportdayohrid'");
$data = mysqli_fetch_array($mysql_result, MYSQLI_ASSOC);
$nextid = $data['Auto_increment'];
$sql = "INSERT INTO firmi (firma, adresa, telefon, email, lice, datum, ipadresa, kotizacija, note, trka, godina, qucesnici) VALUES ('$firma', '$adresa', '$telefon', '$email', '$lice', '$datum', '$ipadresa', $cenareal, '$note', '$trka', $godina, $qucesnici)";
mysqli_query($conn, $sql);
$last_id = mysqli_insert_id($conn);
?>
Регистрација за PRVDOVRV Summit Run 2024
Пополни ги потребните податоци за членовите на тимот echo $_POST['teamname'] ?> .
}
?>
if(isset($_GET['santa_teammates'])) {
$firma = $_POST['firma'];
$adresa = $_POST['adresa'];
$lice = $_POST['person'];
$email = $_POST['email'];
$telefon = $_POST['telefon'];
$teamname = $_POST['teamname'];
$qucesnici = $_POST['q'];
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
$connA = mysqli_connect($servername, $username, $password, $dbname);
mysqli_set_charset($connA,"utf8");
$result = mysqli_query($connA, "SELECT * FROM events where id=46");
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
$cenareal=$row['cena2'];
$iznos=$cenareal * $qucesnici;
$cena=$iznos."00";
//$opis = $row['ime'];
$desc = "Coca-Cola Дедомразовска трка 2024";
$opis = "Coca-Cola Dedomrazovska trka 2024";
$godina=$row['godina'];
$datum=date("Y-m-d H:i:s", strtotime('+0 hours'));
$ipadresa=$_SERVER["REMOTE_ADDR"];
$trka="DMT";
$note="DMT 2024 business";
$product="Котизација за учество на Coca-Cola Дедомразовска трка 2024";
$mysql_result = mysqli_query($conn, "SHOW TABLE STATUS LIKE 'sportdayohrid'");
$data = mysqli_fetch_array($mysql_result, MYSQLI_ASSOC);
$nextid = $data['Auto_increment'];
$sql = "INSERT INTO firmi (firma, adresa, telefon, email, lice, datum, ipadresa, kotizacija, note, trka, godina, qucesnici) VALUES ('$firma', '$adresa', '$telefon', '$email', '$lice', '$datum', '$ipadresa', $cenareal, '$note', '$trka', $godina, $qucesnici)";
mysqli_query($conn, $sql);
$last_id = mysqli_insert_id($conn);
?>
Регистрација за $desc ?>
Пополни ги потребните податоци за членовите на тимот echo $_POST['firma'] ?> .
}
?>
if(isset($_GET['summit-invoice'])) {
$teamname = $_POST['teamname'];
$qucesnici = $_POST['qucesnici'];
$last_id = $_POST['last_id'];
$firma = $_POST['firma'];
$adresa = $_POST['adresa'];
$email_buyer = $_POST['email_buyer'];
$coverpic = 'V20-summit-run-teambuilding.png';
?>
$datum=date("Y-m-d H:i:s", strtotime('+0 hours'));
$ipadresa=$_SERVER["REMOTE_ADDR"];
$trka="PDV";
$godina=2024;
$product="Котизација за учество на PRVDOVRV SUMMIT RUN 2024";
require_once 'phpmailer/PHPMailerAutoload.php';
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
$connA = mysqli_connect($servername, $username, $password, $dbname);
mysqli_set_charset($connA,"utf8");
$result = mysqli_query($connA, "SELECT * FROM events where id=47");
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
$cenareal=$row['cena2'];
$iznos=$cenareal * $qucesnici;
$cena=$iznos."00";
$opis = 'SUMMIT RUN 2024';
$desc = $opis;
$godina=$row['godina'];
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_prvdovrv";
$conn = mysqli_connect($servername, $username, $password, $dbname);
mysqli_set_charset($conn,"utf8");
$mysql_result = mysqli_query($conn, "SHOW TABLE STATUS LIKE 'sportdayohrid'");
$data = mysqli_fetch_array($mysql_result);
$next_id_last = $data['Auto_increment'];
$relayno = $last_id;
//$relayno = $next_id_last;
$ime = $_POST['ime'];
$prezime = $_POST['prezime'];
$rodenden = $_POST['rodenden'];
$email = $_POST['email'];
$pol = $_POST['pol'];
$size = $_POST['tshirt'];
for ($z = 0; $z < count($ime); $z++) {
//$size = date("Y") - $rodenden[$z];
$prezime_lat = convertCyrToLat($prezime[$z]);
$sql = "INSERT INTO sportdayohrid (datum, ipadresa, trka, tip, godina, relayno, run5k, ime, prezime, prezime_lat, rodenden, email, pol, kit, size, tim, uplata, uplata_nacin) VALUES ('$datum', '$ipadresa', '$trka', 'SummitRun', $godina, $relayno, $next_id_last, '$ime[$z]', '$prezime[$z]', '$prezime_lat', '$rodenden[$z]', '$email[$z]', '$pol[$z]', 'plus', '$size[$z]', '$teamname', 0, 0)";
mysqli_query($conn, $sql);
$next_id = mysqli_insert_id($conn);
}
/* Фактура */
include("MPDF57/mpdf.php");
$mpdf = new mPDF('utf-8', 'A4', '10', 'Arial', 0, 0, 5, 5, 5, 5);
$mpdf->charset_in = 'utf-8';
$mpdf->SetDisplayMode('fullpage');
$mpdf->list_indent_first_level = 0; // 1 or 0 - whether to indent the first level of a list
$html=file_get_contents('invoices/invoice.htm');
$html = str_replace('[Q]',$qucesnici,$html);
$html = str_replace('[PROIZVOD]',$product,$html);
$html = str_replace('[CENA]',$cenareal,$html);
$html = str_replace('[IZNOS]',$iznos,$html);
$html = str_replace('[VKUPNO]',$iznos,$html);
$html = str_replace('[FIRMA]',$firma,$html);
$html = str_replace('[ADRESA]',$adresa,$html);
$html = str_replace('[DATUM]',date('d.m.Y'),$html);
$html = str_replace('[VALUTA]',date('d.m.Y', strtotime('+1 days')),$html);
$html = str_replace('[FBR]',"2023W".$relayno,$html);
$mpdf->WriteHTML($html);
$mpdf->Output('invoices/prvdovrv2023W'.$relayno.'.pdf', F);
$attachurl='http://prvdovrv.mk/invoices/prvdovrv2023W'.$relayno.'.pdf';
/* ***** */
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email_buyer, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$mail->isSMTP();
$mail->SMTPAuth = true;
$mail->SMTPSecure = 'ssl';
$mail->Host = "mail.prvdovrv.mk";
$mail->Port = 465;
$mail->Username = "info@prvdovrv.mk";
$mail->Password = "Will0wTr33IITI";
$mail->SMTPDebug = 0;
$mail->Debugoutput = 'html';
$body = file_get_contents('newsletters/businessorder.htm');
$body = str_replace('[FIRMA]',$firma,$body);
$body = str_replace('[IZNOS]',$iznos,$body);
$body = str_replace('[nastan]',$opis,$body);
$body = str_replace('[coverpic]',$coverpic,$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Бизнис регистрација за ". $opis;
$mail->AddAddress($email_buyer);
$mail->addBcc("alek@prvdovrv.mk");
$mail->MsgHTML($body);
$mail->addStringAttachment(file_get_contents($attachurl), 'summit-run-2024.pdf');
$mail->Send();
$mail->ClearAllRecipients();
}
/************/
/* За плаќањето */
$cena_len=strlen($cena);
$details1= $desc;
$details1_len=strlen($details1);
$details2=$next_id_last;
$details2_len=strlen($details2);
$PaymentOKURL="https://prvdovrv.mk/ok.php?n=".$details2;
$PaymentOKURL_len=strlen($PaymentOKURL);
$PaymentFailURL="https://prvdovrv.mk/fail.php?n=".$details2;
$PaymentFailURL_len=strlen($PaymentFailURL);
$InputsLenght="0".$PaymentOKURL_len."0".$PaymentFailURL_len."00".$cena_len."010"."017"."003"."0".$details1_len."00".$details2_len;
$CheckSum="08PaymentOKURL,PaymentFailURL,AmountToPay,PayToMerchant,MerchantName,AmountCurrency,Details1,Details2,".$InputsLenght.$PaymentOKURL.$PaymentFailURL.$cena."1000000791PRV DO VRV SkopjeMKD".$details1.$details2."HMQkm5uS1aUCrFNF";
/* ****** */
?>
echo $firma ?>
Ви благодариме за испратеното барање за ваше компаниско учество на echo $opis ?>.
За успешно комплетирање на регистрацијата потребно е да се изврши плаќање од echo $iznos ?> денари .
Плаќањето може да се изврши со картичка на копчето подолу или според фактурата која ви е испратена на email.
Преземи фактура
}
?>
if(isset($_GET['business_santa_invoice'])) {
$teamname = $_POST['teamname'];
$qucesnici = $_POST['qucesnici'];
$last_id = $_POST['last_id'];
$firma = $_POST['firma'];
$adresa = $_POST['adresa'];
$coverpic = 'dmt2018promo001.jpg';
?>
$datum=date("Y-m-d H:i:s", strtotime('+0 hours'));
$ipadresa=$_SERVER["REMOTE_ADDR"];
$trka="DMT";
$godina=2024;
$product="Котизација за учество на Coca-Cola Дедомразовска трка 2024";
require 'phpmailer/PHPMailerAutoload.php';
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
// Create connection
$connA = mysqli_connect($servername, $username, $password, $dbname);
mysqli_set_charset($connA,"utf8");
$result = mysqli_query($connA, "SELECT * FROM events where id=46");
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
$cenareal=$row['cena2'];
//$cenareal = 400;
$iznos=$cenareal * $qucesnici;
$cena=$iznos."00";
//$opis = $row['ime'];
$opis = 'Coca-Cola Dedomrazovska trka 2024';
$desc = $opis;
$godina=$row['godina'];
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_prvdovrv";
$conn = mysqli_connect($servername, $username, $password, $dbname);
mysqli_set_charset($conn,"utf8");
$mysql_result = mysqli_query($conn, "SHOW TABLE STATUS LIKE 'sportdayohrid'");
$data = mysqli_fetch_array($mysql_result);
$next_id_last = $data['Auto_increment'];
$relayno = $last_id;
//$relayno = $next_id_last;
$ime = $_POST['ime'];
$prezime = $_POST['prezime'];
$rodenden = $_POST['rodenden'];
$email = $_POST['email'];
$pol = $_POST['pol'];
for ($z = 0; $z < count($ime); $z++) {
/*$ime = $_POST['ime[$z]'];
$prezime = $_POST['prezime[$z]'];
$rodenden = $_POST['rodenden[$z]'];
$email = $_POST['email[$z]'];
$pol = $_POST['pol[$z]'];
$tshirt = $_POST['tshirt[$z]'];
$ime = ${'ime'.$z};
$prezime = ${'prezime'.$z};
$rodenden = ${'rodenden'.$z};
$email = ${'email'.$z};
$pol = ${'pol'.$z};
$tshirt = ${'tshirt'.$z};*/
$size = date("Y") - $rodenden[$z];
$sql = "INSERT INTO sportdayohrid (datum, ipadresa, trka, godina, relayno, run5k, ime, prezime, rodenden, email, pol, kit, size, tim, uplata, uplata_nacin) VALUES ('$datum', '$ipadresa', '$trka', $godina, $relayno, $next_id_last, '$ime[$z]', '$prezime[$z]', '$rodenden[$z]', '$email[$z]', '$pol[$z]', 'plus', '$size', '$teamname', 0, 0)";
mysqli_query($conn, $sql);
$next_id = mysqli_insert_id($conn);
/*echo ${'ime'.$z}.' ';
echo ${'prezime'.$z}.' ';
echo ${'rodenden'.$z}.' ';
echo ${'email'.$z}.' ';
echo ${'pol'.$z}.' ';
echo ${'tshirt'.$z}.' ';
echo $z.' ';
echo $z.' ';
echo $datum.' ';
echo $ipadresa.' ';
echo $trka.' ';
echo $godina.' ';
echo $teamname.' ';
echo $relayno.' ';
echo $ime.' ';
echo $prezime.' ';
echo $rodenden.' ';
echo $email.' ';
echo $pol.' ';
echo $tshirt.' ';
echo $next_id.' ';
echo $next_id_last.' ';*/
}
//$next_id = mysqli_insert_id($conn);
// echo (mysqli_error($con));
// die(print_r($stuff, true ));
/* Фактура */
include("MPDF57/mpdf.php");
$mpdf = new mPDF('utf-8', 'A4', '10', 'Arial', 0, 0, 5, 5, 5, 5);
$mpdf->charset_in = 'utf-8';
$mpdf->SetDisplayMode('fullpage');
$mpdf->list_indent_first_level = 0; // 1 or 0 - whether to indent the first level of a list
$html=file_get_contents('invoices/invoice.htm');
$html = str_replace('[Q]',$qucesnici,$html);
$html = str_replace('[PROIZVOD]',$product,$html);
$html = str_replace('[CENA]',$cenareal,$html);
$html = str_replace('[IZNOS]',$iznos,$html);
$html = str_replace('[VKUPNO]',$iznos,$html);
$html = str_replace('[FIRMA]',$firma,$html);
$html = str_replace('[ADRESA]',$adresa,$html);
$html = str_replace('[DATUM]',date('d.m.Y'),$html);
$html = str_replace('[VALUTA]',date('d.m.Y', strtotime('+1 days')),$html);
//$html = str_replace('[VALUTA]',date('d.m.Y'),$html);
$html = str_replace('[FBR]',"2024W".$relayno,$html);
$mpdf->WriteHTML($html);
$mpdf->Output('invoices/prvdovrv2024W'.$relayno.'.pdf', F);
$attachurl='http://prvdovrv.mk/invoices/prvdovrv2024W'.$relayno.'.pdf';
/* ***** */
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$mail->isSMTP();
$mail->SMTPDebug = 0;
$mail->Debugoutput = 'html';
$mail->Host = "odin.mk-host.com";
$mail->Port = 465;
$mail->SMTPAuth = true;
$mail->Username = "upgradem@odin.mk-host.com";
$mail->Password = "N043Ze0fzn";
$mail->SMTPSecure = 'ssl';
$body = file_get_contents('newsletters/businessorder.htm');
//$body = eregi_replace("[\]",'',$body);
$body = str_replace('[FIRMA]',$firma,$body);
$body = str_replace('[IZNOS]',$iznos,$body);
$body = str_replace('[nastan]',$opis,$body);
//$body = str_replace('[cena]',$cenareal,$body);
//$body = str_replace('[id]',$nextid,$body);
$body = str_replace('[coverpic]',$coverpic,$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Бизнис регистрација за ". $opis;
$mail->AddAddress($email);
$mail->addBcc("alek@prvdovrv.mk");
//$mailer->AddAddress("info@prvdovrv.mk");
$mail->MsgHTML($body);
$mail->addStringAttachment(file_get_contents($attachurl), 'dedomrazovska-trka-2024.pdf');
$send = $mail->Send();
$mail->ClearAllRecipients();
}
/************/
// }
/* $resultlast = mysql_query("SELECT LAST_INSERT_ID()", $conn);
$rowlast = mysql_fetch_array($resultlast);
$nextid=$rowlast['id']; */
/* За плаќањето */
$cena_len=strlen($cena);
$details1= $desc;
$details1_len=strlen($details1);
$details2=$next_id_last;
$details2_len=strlen($details2);
$PaymentOKURL="https://prvdovrv.mk/ok.php?n=".$details2;
$PaymentOKURL_len=strlen($PaymentOKURL);
$PaymentFailURL="https://prvdovrv.mk/fail.php?n=".$details2;
$PaymentFailURL_len=strlen($PaymentFailURL);
$InputsLenght="0".$PaymentOKURL_len."0".$PaymentFailURL_len."00".$cena_len."010"."017"."003"."0".$details1_len."00".$details2_len;
$CheckSum="08PaymentOKURL,PaymentFailURL,AmountToPay,PayToMerchant,MerchantName,AmountCurrency,Details1,Details2,".$InputsLenght.$PaymentOKURL.$PaymentFailURL.$cena."1000000791PRV DO VRV SkopjeMKD".$details1.$details2."HMQkm5uS1aUCrFNF";
/* ****** */
?>
}
?>
if(isset($_GET['ponikva'])) {
?>
}
?>
if(isset($_GET['osogovoadventure'])) {
?>
}
?>
if(isset($_GET['slavej'])) {
?>
Slavej+Karaorman MTB 2019
}
?>
if(isset($_GET['babinsrt'])) {
?>
MTB Babin Srt 2021
Пријавувањето е затворено заради пополнување на максималниот број на учесници.
}
?>
if(isset($_GET['bistraadventure'])) {
if(isset($_GET['r'])){
$r = $_GET["r"];
$sql = "UPDATE sent_emails SET btt_click = btt_click + 1 WHERE recipient_uniqueid='$r'";
mysqli_query($conn, $sql);
}
?>
Sava MTB Bistra Adventure 2023
Пријавувањето е затворено заради пополнување на максималниот број на учесници.
}
?>
if(isset($_GET['konche'])) {
?>
Авантурите на Конче и Мантово 2023
Пријавувањето е затворено заради пополнување на максималниот број на учесници.
}
?>
if(isset($_GET['sava'])) {
?>
САВА АДРЕНАЛИНСКА АВАНТУРА
}
?>
if(isset($_GET['tourdelake'])) {
?>
}
?>
if(isset($_GET['velovodno'])) {
?>
Вело Водно
Пријавувањето е затворено.
}
?>
if(isset($_GET['savavirtualvelo'])) {
?>
Sava Virtual Velo
Пријавувањето е затворено.
}
?>
if(isset($_GET['mobility'])) {
?>
Mobility Virtual Challenge
Пријавувањето е затворено.
}
?>
if(isset($_GET['xbistraadventure'])) {
?>
}
?>
if(isset($_GET['meeting2017'])) {
?>
}
?>
if(isset($_GET['meeting2018'])) {
?>
}
?>
if(isset($_GET['meeting'])) {
?>
}
?>
if(isset($_GET['beachrun'])) {
?>
}
?>
if(isset($_GET['gift'])) {
?>
Подарок ваучер за ПРВ ДО ВРВ 2017
}
?>
if(isset($_GET['contact'])) {
$_SESSION["ime"] = $_POST['ime'];
$_SESSION["prezime"] = $_POST['prezime'];
$_SESSION["rodenden"] = $_POST['rodenden'];
$_SESSION["pol"] = $_POST['pol'];
?>
Контакт информации / Contact information
OK
Твојот град / Your city
Одбери град / City
Скопје
Other / Друг
OK
Твојата држава / Your country
Afghanistan
Åland Islands
Albania
Algeria
American Samoa
Andorra
Angola
Anguilla
Antarctica
Antigua and Barbuda
Argentina
Armenia
Aruba
Australia
Austria
Azerbaijan
Bahamas
Bahrain
Bangladesh
Barbados
Belarus
Belgium
Belize
Benin
Bermuda
Bhutan
Bolivia
Bosnia and Herzegovina
Botswana
Bouvet Island
Brazil
British Indian Ocean Territory
Brunei Darussalam
Bulgaria
Burkina Faso
Burundi
Cambodia
Cameroon
Canada
Cape Verde
Cayman Islands
Central African Republic
Chad
Chile
China
Christmas Island
Cocos (Keeling) Islands
Colombia
Comoros
Congo
Congo, The Democratic Republic of The
Cook Islands
Costa Rica
Cote D'ivoire
Croatia
Cuba
Cyprus
Czech Republic
Denmark
Djibouti
Dominica
Dominican Republic
Ecuador
Egypt
El Salvador
Equatorial Guinea
Eritrea
Estonia
Ethiopia
Falkland Islands (Malvinas)
Faroe Islands
Fiji
Finland
France
French Guiana
French Polynesia
French Southern Territories
Gabon
Gambia
Georgia
Germany
Ghana
Gibraltar
Greece
Greenland
Grenada
Guadeloupe
Guam
Guatemala
Guernsey
Guinea
Guinea-bissau
Guyana
Haiti
Heard Island and Mcdonald Islands
Holy See (Vatican City State)
Honduras
Hong Kong
Hungary
Iceland
India
Indonesia
Iran, Islamic Republic of
Iraq
Ireland
Isle of Man
Israel
Italy
Jamaica
Japan
Jersey
Jordan
Kazakhstan
Kenya
Kiribati
Korea, Democratic People's Republic of
Korea, Republic of
Kuwait
Kyrgyzstan
Lao People's Democratic Republic
Latvia
Lebanon
Lesotho
Liberia
Libyan Arab Jamahiriya
Liechtenstein
Lithuania
Luxembourg
Macao
Македонија
Madagascar
Malawi
Malaysia
Maldives
Mali
Malta
Marshall Islands
Martinique
Mauritania
Mauritius
Mayotte
Mexico
Micronesia, Federated States of
Moldova, Republic of
Monaco
Mongolia
Montenegro
Montserrat
Morocco
Mozambique
Myanmar
Namibia
Nauru
Nepal
Netherlands
Netherlands Antilles
New Caledonia
New Zealand
Nicaragua
Niger
Nigeria
Niue
Norfolk Island
Northern Mariana Islands
Norway
Oman
Pakistan
Palau
Palestinian Territory, Occupied
Panama
Papua New Guinea
Paraguay
Peru
Philippines
Pitcairn
Poland
Portugal
Puerto Rico
Qatar
Reunion
Romania
Russian Federation
Rwanda
Saint Helena
Saint Kitts and Nevis
Saint Lucia
Saint Pierre and Miquelon
Saint Vincent and The Grenadines
Samoa
San Marino
Sao Tome and Principe
Saudi Arabia
Senegal
Serbia
Seychelles
Sierra Leone
Singapore
Slovakia
Slovenia
Solomon Islands
Somalia
South Africa
South Georgia and The South Sandwich Islands
Spain
Sri Lanka
Sudan
Suriname
Svalbard and Jan Mayen
Swaziland
Sweden
Switzerland
Syrian Arab Republic
Taiwan, Province of China
Tajikistan
Tanzania, United Republic of
Thailand
Timor-leste
Togo
Tokelau
Tonga
Trinidad and Tobago
Tunisia
Turkey
Turkmenistan
Turks and Caicos Islands
Tuvalu
Uganda
Ukraine
United Arab Emirates
United Kingdom
United States
United States Minor Outlying Islands
Uruguay
Uzbekistan
Vanuatu
Venezuela
Viet Nam
Virgin Islands, British
Virgin Islands, U.S.
Wallis and Futuna
Western Sahara
Yemen
Zambia
Zimbabwe
}
?>
if(isset($_GET['contactsh'])) {
$_SESSION["ime"] = $_POST['ime'];
$_SESSION["prezime"] = $_POST['prezime'];
$_SESSION["rodenden"] = $_POST['rodenden'];
$_SESSION["pol"] = $_POST['pol'];
?>
}
?>
if(isset($_GET['contactbr'])) {
$_SESSION["ime"] = $_POST['ime'];
$_SESSION["prezime"] = $_POST['prezime'];
$_SESSION["rodenden"] = $_POST['rodenden'];
$_SESSION["pol"] = $_POST['pol'];
?>
}
?>
if(isset($_GET['event'])) {
$_SESSION["email"] = $_POST['email'];
$_SESSION["telefon"] = $_POST['telefon'];
$_SESSION["city"] = $_POST['city'];
$_SESSION["country"] = $_POST['country'];
?>
Информации за трката / Race information
OK
Која е твојата трка? / What is your race?
Одбери трка / Pick a race
Планинско трчање / Mountain running
Друмски велосипедизам / Road cycling
Планински велосипедизам / Mountain biking
Тимбилдинг / Teambuilding Summit Run
OK
Дали си рекреативец? / Amateur or pro?
Одбери конкуренција / Competition
Про (регистрирани спортисти) / Professionals
Хоби (рекреативци) / Hobby (amateurs)
OK
Одбери го твојот стартен пакет / Type of package?
Тип на стартен пакет / Package
Основен пакет (број, финишер медал) / Basic (bib, finisher medal)
Пакет плус (основен плус маичка) / Plus (basic plus t-shirt)
OK
Кој број носиш? / What's your shirt size?
Големина на маица
XS
S
M
L
XL
XXL
OK
Доколку си дел од клуб, фирма, група... / If any club, company or group member
$querytim = "SELECT DISTINCT tim FROM sportdayohrid where tim <> '' order by tim asc";
$resulttim = mysqli_query($conn, $querytim);
$rowtim = mysqli_fetch_array($resulttim, MYSQLI_ASSOC);
?>
Избери постоечки тим / Pick an existing team
while ($rowtim = mysqli_fetch_assoc($resulttim)) { ?>
"> echo $rowtim["tim"]; ?>
} ?>
OK
Доколку трчаше на Скопскиот маратон добиваш попуст
Цена:
денари
}
?>
if(isset($_GET['eventsh'])) {
$_SESSION["email"] = $_POST['email'];
$_SESSION["telefon"] = $_POST['telefon'];
?>
Информации за трката / Race information
OK
Која е твојата трка? / What is your race?
Одбери трка / Pick a race
Планинско трчање / Mountain running
Друмски велосипедизам / Road cycling
Планински велосипедизам / Mountain biking
OK
Одбери го твојот стартен пакет / Type of package?
Тип на стартен пакет / Package
Основен пакет (број, финишер медал) / Basic (bib, finisher medal)
Пакет плус (основен плус маичка) / Plus (basic plus t-shirt)
OK
Кој број носиш? What's your shirt size?
Големина на маица / Size
XS
S
M
L
XL
XXL
OK
Доколку си дел од клуб, фирма, група... / If any club, company or group member
$querytim = "SELECT DISTINCT tim FROM sportdayohrid where tim <> '' order by tim asc";
$resulttim = mysqli_query($conn, $querytim);
$rowtim = mysqli_fetch_array($resulttim, MYSQLI_ASSOC);
?>
Избери постоечки тим
while ($rowtim = mysqli_fetch_assoc($resulttim)) { ?>
"> echo $rowtim["tim"]; ?>
} ?>
OK
Доколку трчаше на Првдоврв Водно 2019 добиваш попуст
Цена:
денари
}
?>
if(isset($_GET['eventbr'])) {
$_SESSION["email"] = $_POST['email'];
$_SESSION["telefon"] = $_POST['telefon'];
?>
}
?>
if(isset($_GET['account'])) {
$_SESSION["kategorija"] = $_POST['kategorija'];
$_SESSION["size"] = $_POST['size'];
$_SESSION["tim"] = $_POST['tim'];
?>
}
?>
if(isset($_GET['hello'])) {
require_once 'phpmailer/PHPMailerAutoload.php';
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
$connA = mysqli_connect($servername, $username, $password, $dbname);
mysqli_set_charset($connA,"utf8");
$result = mysqli_query($connA, "SELECT * FROM events where id=47");
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
/*if ($_SESSION["pol"] == 'female') {
$cena=200;
} else {
$cena=$row['cena'];
}*/
$cena1=$row['cena'];
$cena2=$row['cena2'];
// za 8 mart 2023
//if($_POST['pol'] == 'female'){$cena1 = 300;$cena2 = 600;}
//
/*if ($_SESSION["skm"]>0) {
$cena = 500;
} */
/* samo za 8 mart 2019
if ($_SESSION["pol"] == 'female') {
$cena=350;
}
*/
$opis = "PRVDOVRV 2025";
$desc = $row['ime'];
$godina=$row['godina'];
$datum=date("Y-m-d H:i:s", strtotime('+0 hours'));
$ipadresa=$_SERVER["REMOTE_ADDR"];
$trka="PDV";
$ime=$_POST['ime'];
$prezime=$_POST['prezime'];
$prezime_lat = convertCyrToLat($prezime);
$birth=$_POST['rodenden'];
$pol=$_POST['pol'];
$tip = $_POST['kategorija'];
$size = $_POST['size'];
$tim = $_POST['tim'];
//$skm = $_POST['skm'];
//$lozinka = $_POST['lozinka'];
$kit = $_POST['kit'];
$competition = $_POST['competition'];
$if_discount = $_POST['if_discount'];
$discounted_price = $_POST['discounted_price'];
/*if ($if_discount == 1) {
$club_code = $_POST['$club_code'];
} else {
$club_code = '';
}*/
$club_code = $_POST['club_discount_code'];
if($tip=='mrun'){
$coverpic='run.jpg';
}else if ($tip=='mbike') {
$coverpic='mtb.jpg';
}else if ($tip=='rbike'){
$coverpic='road.jpg';
}
$email = $_POST['email'];
if (isset($_POST['telefon'])) { $tel = $_POST['telefon'];}else{$tel='';}
$country = $_POST['country'];
$city = $_POST['city'];
if ($tip === "SummitRun"){
$kit="plus";
$competition = "hobby";
}
//$kit = 'basic'; //only if late registration period 8-14 May 2023
// za 8 mart 2020
/*
if ($pol == 'female') {
$cena1 = $cena1*0.2;
//$cena2 = $cena2*0.85;
}
*/
if ($kit === "basic") {
$cena = $cena1;
if ($if_discount > 0) {$cena = $discounted_price;}
} elseif ($kit === "plus"){
$cena = $cena2;
if ($if_discount > 0) {$cena = $discounted_price;}
}
$cenareal=$cena;
$cena=$cena."00";
//$idunique = md5(uniqid($email, true));
/* Проверка на следен ID
$mysql_result = mysql_query("SHOW TABLE STATUS LIKE 'sportdayohrid'");
$data = mysql_fetch_assoc($mysql_result);
$nextid = $data['Auto_increment']; */
if ($club_code=='zenska trka') {
$nextid = $_POST['id'];
$_SESSION["id"] = $nextid;
$sql_update = "UPDATE sportdayohrid SET rodenden='$birth', city='$city', country='$country', tip='$tip', competition='$competition', kit='$kit', size='$size', tim='$tim', invitation_code='' where id = $nextid";
mysqli_query($conn, $sql_update);
echo mysqli_error($conn);
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$mail->isSMTP();
$mail->SMTPAuth = true;
$mail->SMTPSecure = 'ssl';
$mail->Host = "mail.prvdovrv.mk";
$mail->Port = 465;
$mail->Username = "info@prvdovrv.mk";
$mail->Password = "Will0wTr33IITI";
$body = file_get_contents('newsletters/registerednotpaid.htm');
if($kit=='virtual'){$body = file_get_contents('newsletters/registerednopayment.htm');}
$body = str_replace('[ime]',$ime,$body);
$body = str_replace('[prezime]',$prezime,$body);
$body = str_replace('[nastan]',$opis,$body);
$body = str_replace('[cena]',$cenareal,$body);
$body = str_replace('[id]',$_SESSION["id"],$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Регистрација за ". $opis;
$mail->AddAddress($email);
$mail->MsgHTML($body);
$mail->Send();
$mail->ClearAllRecipients();
}
/************/
} else {
/* Запишување на регистрацијата */
$dupesql = "SELECT * FROM sportdayohrid where trka = '$trka' and godina = $godina and ime = '$ime' and prezime = '$prezime' and email = '$email'";
$duperaw = mysqli_query($conn, $dupesql);
if (mysqli_num_rows($duperaw) == 0) {
$sql = "INSERT INTO sportdayohrid (datum, ipadresa, trka, godina, tip, competition, ime, prezime, prezime_lat, rodenden, email, telefon, city, country, pol, kit, size, tim, if_discount, discount_code, uplata, uplata_nacin, access_token, refresh_token, strava_status, expires_at) VALUES ('$datum', '$ipadresa', '$trka', $godina, '$tip', '$competition', '$ime', '$prezime', '$prezime_lat', '$birth', '$email', '$tel', '$city', '$country','$pol', '$kit', '$size', '$tim', $if_discount, '$club_code', 0, 0, 0, 0, 0, 0)";
mysqli_query($conn, $sql);
$nextid=mysqli_insert_id($conn);
$_SESSION["id"] = $nextid;
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$mail->isSMTP();
$mail->SMTPAuth = true;
$mail->SMTPSecure = 'ssl';
$mail->Host = "mail.prvdovrv.mk";
$mail->Port = 465;
$mail->Username = "info@prvdovrv.mk";
$mail->Password = "Will0wTr33IITI";
$body = file_get_contents('newsletters/registerednotpaid.htm');
if($kit=='virtual'){$body = file_get_contents('newsletters/registerednopayment.htm');}
$body = str_replace('[ime]',$ime,$body);
$body = str_replace('[prezime]',$prezime,$body);
$body = str_replace('[nastan]',$opis,$body);
$body = str_replace('[cena]',$cenareal,$body);
$body = str_replace('[id]',$_SESSION["id"],$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Регистрација за ". $opis;
$mail->AddAddress($email);
$mail->MsgHTML($body);
$mail->Send();
$mail->ClearAllRecipients();
}
/************/
}
}
/* $resultlast = mysql_query("SELECT LAST_INSERT_ID()", $conn);
$rowlast = mysql_fetch_array($resultlast);
$nextid=$rowlast['id']; */
/* За плаќањето */
$cena_len=strlen($cena);
$details1= $desc;
$details1_len=strlen($details1);
$details2=$_SESSION["id"];
$details2_len=strlen($details2);
$PaymentOKURL="https://prvdovrv.mk/ok.php?n=".$details2;
$PaymentOKURL_len=strlen($PaymentOKURL);
$PaymentFailURL="https://prvdovrv.mk/fail.php?n=".$details2;
$PaymentFailURL_len=strlen($PaymentFailURL);
$InputsLenght="0".$PaymentOKURL_len."0".$PaymentFailURL_len."00".$cena_len."010"."017"."003"."0".$details1_len."00".$details2_len;
$CheckSum="08PaymentOKURL,PaymentFailURL,AmountToPay,PayToMerchant,MerchantName,AmountCurrency,Details1,Details2,".$InputsLenght.$PaymentOKURL.$PaymentFailURL.$cena."1000000791PRV DO VRV SkopjeMKD".$details1.$details2."HMQkm5uS1aUCrFNF";
/* ****** */
?>
Здраво echo $ime ?>
Ги имаме твоите податоци за учество на echo $opis ?> . За успешно комплетирање на регистрацијата потребно е да се плати котизацијата од echo $cena/100 ?> денари . Цената важи до 5 мај 2024.
Thank you for the registration for echo $details1 ?> . For the successful completion of the registration you need to pay the fee of echo $cena/100 ?> denars . The price is valid until May 5 2024.
Имам ваучер
}
?>
if(isset($_GET['hello-ocr'])) {
require_once 'phpmailer/PHPMailerAutoload.php';
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
$connA = mysqli_connect($servername, $username, $password, $dbname);
mysqli_set_charset($connA,"utf8");
$result = mysqli_query($connA, "SELECT * FROM events where id=45");
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
$cena=$row['cena'];
$opis = "OCR SKOPJE 2024";
$desc = $row['ime'];
$godina=$row['godina'];
$datum=date("Y-m-d H:i:s", strtotime('+0 hours'));
$ipadresa=$_SERVER["REMOTE_ADDR"];
$trka="OCR";
$ime=$_POST['ime'];
$prezime=$_POST['prezime'];
$prezime_lat = convertCyrToLat($prezime);
$birth=$_POST['rodenden'];
$pol=$_POST['pol'];
$size = $_POST['size'];
$tim = $_POST['tim'];
$if_discount = $_POST['if_discount'];
$discounted_price = $_POST['discounted_price'];
$club_code = $_POST['club_discount_code'];
$email = $_POST['email'];
if (isset($_POST['telefon'])) { $tel = $_POST['telefon'];}else{$tel='';}
$country = $_POST['country'];
$city = $_POST['city'];
$kit = 'plus';
$cenareal=$cena;
$cena=$cena."00";
/* Запишување на регистрацијата */
$dupesql = "SELECT * FROM sportdayohrid where trka = '$trka' and godina = $godina and ime = '$ime' and prezime = '$prezime' and email = '$email'";
$duperaw = mysqli_query($conn, $dupesql);
if (mysqli_num_rows($duperaw) == 0) {
$sql = "INSERT INTO sportdayohrid (datum, ipadresa, trka, godina, ime, prezime, prezime_lat, rodenden, email, telefon, city, country, pol, kit, size, tim, if_discount, discount_code, uplata, uplata_nacin, access_token, refresh_token, strava_status, expires_at) VALUES ('$datum', '$ipadresa', '$trka', $godina, '$ime', '$prezime', '$prezime_lat', '$birth', '$email', '$tel', '$city', '$country','$pol', '$kit', '$size', '$tim', $if_discount, '$club_code', 0, 0, 0, 0, 0, 0)";
mysqli_query($conn, $sql);
$nextid=mysqli_insert_id($conn);
$_SESSION["id"] = $nextid;
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$mail->isSMTP();
$mail->SMTPAuth = true;
$mail->SMTPSecure = 'ssl';
$mail->Host = "mail.prvdovrv.mk";
$mail->Port = 465;
$mail->Username = "info@prvdovrv.mk";
$mail->Password = "Will0wTr33IITI";
$body = file_get_contents('newsletters/registerednotpaid_ocr.htm');
$body = str_replace('[ime]',$ime,$body);
$body = str_replace('[prezime]',$prezime,$body);
$body = str_replace('[nastan]',$opis,$body);
$body = str_replace('[cena]',$cenareal,$body);
$body = str_replace('[id]',$_SESSION["id"],$body);
$body = str_replace('[sender]','OCR Macedonia',$body);
$body = str_replace('[logo]','ocr_logo.png',$body);
$body = str_replace('[logo_url]','https://prvdovrv.mk/ocrmacedonia',$body);
$body = str_replace('[logo_width]','150',$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Регистрација за ". $opis;
$mail->AddAddress($email);
$mail->MsgHTML($body);
$check_if_already_is_sent = mysqli_query($conn, "SELECT * FROM sent_emails where recipient_id = $nextid and campaign_id=4");
if (mysqli_num_rows($check_if_already_is_sent)==0) {
if(!$mail->Send()){
$message_status = $mail->ErrorInfo;
}else{
$message_status = 'OK';
$mail->ClearAllRecipients();
}
$time_sent = date("Y-m-d H:i:s", strtotime('+0 hours'));
$campaign_id = 4; //4 e sekogas za REGISTERED NOT PAID email
$time_read = '1970-01-02 00:00:00';
$recipient_id = $nextid;
$recipient_uniqueid = uniqid();
$sql_sent_emails = "INSERT INTO sent_emails (recipient_id, recipient_uniqueid, time_sent, time_read, campaign_id, message_status, read_status, btt_click, moreinfo_click, header_click, logo_click, startlist_click) VALUES ('$recipient_id', '$recipient_uniqueid', '$time_sent', '$time_read', '$campaign_id', '$message_status', 0,0,0,0,0,0)";
mysqli_query($conn, $sql_sent_emails);
}
}
/************/
}
/* $resultlast = mysql_query("SELECT LAST_INSERT_ID()", $conn);
$rowlast = mysql_fetch_array($resultlast);
$nextid=$rowlast['id']; */
/* За плаќањето */
$cena_len=strlen($cena);
$details1= $desc;
$details1_len=strlen($details1);
$details2=$_SESSION["id"];
$details2_len=strlen($details2);
$PaymentOKURL="https://prvdovrv.mk/ok.php?n=".$details2;
$PaymentOKURL_len=strlen($PaymentOKURL);
$PaymentFailURL="https://prvdovrv.mk/fail.php?n=".$details2;
$PaymentFailURL_len=strlen($PaymentFailURL);
$InputsLenght="0".$PaymentOKURL_len."0".$PaymentFailURL_len."00".$cena_len."010"."017"."003"."0".$details1_len."00".$details2_len;
$CheckSum="08PaymentOKURL,PaymentFailURL,AmountToPay,PayToMerchant,MerchantName,AmountCurrency,Details1,Details2,".$InputsLenght.$PaymentOKURL.$PaymentFailURL.$cena."1000000791PRV DO VRV SkopjeMKD".$details1.$details2."HMQkm5uS1aUCrFNF";
/* ****** */
?>
Здраво echo $ime ?>
Ги имаме твоите податоци за учество на echo $opis ?> . За успешно комплетирање на регистрацијата потребно е да се плати котизацијата од echo $cena/100 ?> денари . Цената важи до 15 јули 2024.
Thank you for the registration for echo $opis ?> . For a successful completion of the registration you have to pay the fee of echo $cena/100 ?> denars . The price is valid until July 15 2024.
Имам ваучер
}
?>
if(isset($_GET['hellozt'])) {
require_once 'phpmailer/PHPMailerAutoload.php';
$datum=date("Y-m-d H:i:s", strtotime('+0 hours'));
$ipadresa=$_SERVER["REMOTE_ADDR"];
$trka="PDV";
$ime=$_POST['ime'];
$prezime=$_POST['prezime'];
$prezime_lat = convertCyrToLat($prezime);
$email = $_POST['email'];
$bibzt = $_POST['bibzt'];
$invitation_code = bin2hex(random_bytes(32));
$opis = 'Sparkasse Life PRVDOVRV 2024';
/* Запишување на регистрацијата */
$sql = "INSERT INTO sportdayohrid (datum, ipadresa, trka, godina, competition, ime, prezime, prezime_lat, email, pol, if_discount, discount_code, invitation_code, skmbib) VALUES ('$datum', '$ipadresa', '$trka', 2024, 'hobby', '$ime', '$prezime', '$prezime_lat', '$email', 'female', 1, 'zenska trka', '$invitation_code', $bibzt)";
mysqli_query($conn, $sql);
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$mail->isSMTP();
$mail->SMTPAuth = true;
$mail->SMTPSecure = 'ssl';
$mail->Host = "mail.prvdovrv.mk";
$mail->Port = 465;
$mail->Username = "info@prvdovrv.mk";
$mail->Password = "Will0wTr33IITI";
$body = file_get_contents('newsletters/discountedregistrationurl.htm');
$body = str_replace('[ime]',$ime,$body);
$body = str_replace('[prezime]',$prezime,$body);
$body = str_replace('[nastan]',$opis,$body);
$body = str_replace('[code]',$invitation_code,$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Регистрација за ". $opis;
$mail->AddAddress($email);
$mail->MsgHTML($body);
$mail->Send();
$mail->ClearAllRecipients();
}
/************/
?>
Здраво echo $ime ?>
Ти благодариме за твојот интерес за учество на echo $opis ?> . Ти испративме email порака преку која треба да ја довршиш твојата регистрација.
echo mysqli_error($conn); ?>
}
?>
if(isset($_GET['helloskm'])) {
require_once 'phpmailer/PHPMailerAutoload.php';
$datum=date("Y-m-d H:i:s", strtotime('+0 hours'));
$ipadresa=$_SERVER["REMOTE_ADDR"];
$trka="PDV";
$ime=$_POST['ime'];
$prezime=$_POST['prezime'];
$prezime_lat = convertCyrToLat($prezime);
$email = $_POST['email'];
$bibzt = $_POST['bibzt'];
$invitation_code = bin2hex(random_bytes(32));
$opis = 'Sparkasse Life PRVDOVRV 2025';
/* Запишување на регистрацијата */
$sql = "INSERT INTO sportdayohrid (datum, ipadresa, trka, godina, competition, ime, prezime, prezime_lat, email, pol, if_discount, discount_code, invitation_code, skmbib) VALUES ('$datum', '$ipadresa', '$trka', 2025, 'hobby', '$ime', '$prezime', '$prezime_lat', '$email', 'female', 1, 'zenska trka', '$invitation_code', $bibzt)";
mysqli_query($conn, $sql);
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$mail->isSMTP();
$mail->SMTPAuth = true;
$mail->SMTPSecure = 'ssl';
$mail->Host = "mail.prvdovrv.mk";
$mail->Port = 465;
$mail->Username = "info@prvdovrv.mk";
$mail->Password = "Will0wTr33IITI";
$body = file_get_contents('newsletters/discountedregistrationurl.htm');
$body = str_replace('[ime]',$ime,$body);
$body = str_replace('[prezime]',$prezime,$body);
$body = str_replace('[nastan]',$opis,$body);
$body = str_replace('[code]',$invitation_code,$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Регистрација за ". $opis;
$mail->AddAddress($email);
$mail->addBcc("alek@prvdovrv.mk");
$mail->MsgHTML($body);
$mail->Send();
$mail->ClearAllRecipients();
}
/************/
?>
Здраво echo $ime ?>
Ти благодариме за твојот интерес за учество на echo $opis ?> . Ти испративме email порака преку која треба да ја довршиш твојата регистрација.
echo mysqli_error($conn); ?>
}
?>
if(isset($_GET['hello_valentine'])) {
require_once('phpmailer/class.phpmailer.php');
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
$connA = mysqli_connect($servername, $username, $password, $dbname);
mysqli_set_charset($connA,"utf8");
$result = mysqli_query($connA, "SELECT * FROM events where id=40");
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
$cena1=$row['cena'];
$cena2=$row['cena2'];
$opis = "PRVDOVRV VODNO 2023";
$desc = $opis;
$godina=$row['godina'];
$datum=date("Y-m-d H:i:s", strtotime('+0 hours'));
$ipadresa=$_SERVER["HTTP_X_FORWARDED_FOR"];
if ($ipadresa == "") {
$ipadresa=$_SERVER["REMOTE_ADDR"];
}
$trka="PDV";
$mysql_result = mysqli_query($conn, "SHOW TABLE STATUS LIKE 'sportdayohrid'");
$data = mysqli_fetch_array($mysql_result);
$next_id_last = $data['Auto_increment'];
$ime_female=$_POST['ime_female'];
$prezime_female=$_POST['prezime_female'];
$birth_female=$_POST['rodenden_female'];
$pol_female=$_POST['pol_female'];
$tip_female = $_POST['kategorija_female'];
$size_female = $_POST['size_female'];
$tim_female = $_POST['tim_female'];
$kit_female = $_POST['kit_female'];
$competition_female = $_POST['competition_female'];
$email_female = $_POST['email'];
$tel_female = $_POST['telefon_female'];
$country_female = $_POST['country_female'];
$city_female = $_POST['city_female'];
/* Запишување на регистрацијата */
$sql = "INSERT INTO sportdayohrid (datum, ipadresa, trka, godina, tip, competition, ime, prezime, rodenden, email, telefon, city, country, pol, kit, size, tim, uplata, uplata_nacin, access_token, refresh_token, strava_status, expires_at, relayno, ny_wish) VALUES ('$datum', '$ipadresa', '$trka', $godina, '$tip_female', '$competition_female', '$ime_female', '$prezime_female', '$birth_female', '$email_female', '$tel_female', '$city_female', '$country_female','$pol_female', '$kit_female', '$size_female', '$tim_female', 0, 0, 0, 0, 0, 0, $next_id_last, 'valentine')";
mysqli_query($conn, $sql);
$ime_male=$_POST['ime_male'];
$prezime_male=$_POST['prezime_male'];
$birth_male=$_POST['rodenden_male'];
$pol_male=$_POST['pol_male'];
$tip_male = $_POST['kategorija_male'];
$size_male = $_POST['size_male'];
$tim_male = $_POST['tim_male'];
$kit_male = $_POST['kit_male'];
$competition_male = $_POST['competition_male'];
$email_male = $_POST['email'];
$tel_male = $_POST['telefon_male'];
$country_male = $_POST['country_male'];
$city_male = $_POST['city_male'];
if($tip_male=='mrun'){
$coverpic='run.jpg';
}else if ($tip_male=='mbike') {
$coverpic='mtb.jpg';
}else if ($tip_male=='rbike'){
$coverpic='road.jpg';
}
if ($kit_male === "basic") {
$cena = $cena1*2;
} elseif ($kit_male === "plus"){
$cena = $cena2*2;
}
$cenareal=$cena;
$cena=$cena."00";
/* Запишување на регистрацијата */
$sql = "INSERT INTO sportdayohrid (datum, ipadresa, trka, godina, tip, competition, ime, prezime, rodenden, email, telefon, city, country, pol, kit, size, tim, uplata, uplata_nacin, access_token, refresh_token, strava_status, expires_at, relayno, ny_wish) VALUES ('$datum', '$ipadresa', '$trka', $godina, '$tip_male', '$competition_male', '$ime_male', '$prezime_male', '$birth_male', '$email_male', '$tel_male', '$city_male', '$country_male','$pol_male', '$kit_male', '$size_male', '$tim_male', 0, 0, 0, 0, 0, 0, $next_id_last, 'valentine')";
mysqli_query($conn, $sql);
/* прати меил за успешно пријавување без плаќање */
if (filter_var($_POST['email'], FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$body = file_get_contents('newsletters/registerednotpaid.htm');
if($kit=='virtual'){$body = file_get_contents('newsletters/registerednopayment.htm');}
//$body = eregi_replace("[\]",'',$body);
$body = str_replace('[ime]',$_POST['email'],$body);
$body = str_replace('[prezime]',$prezime,$body);
$body = str_replace('[nastan]',$opis,$body);
$body = str_replace('[cena]',$cenareal,$body);
$body = str_replace('[id]',$next_id_last,$body);
$body = str_replace('[coverpic]',$coverpic,$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Регистрација за ". $opis;
$mail->AddAddress($_POST['email']);
$mail->MsgHTML($body);
$send = $mail->Send();
$mail->ClearAllRecipients();
}
/************/
$cena = bin2hex($cena);
$desc = bin2hex($desc);
$next_id_last = bin2hex($next_id_last);
$ime = bin2hex($ime_female . ' и ' . $ime_male);
header("Location: ?readytopay_valentine&cena=$cena&desc=$desc&next_id_last=$next_id_last&ime=$ime");
die();
}
if(isset($_GET['readytopay_valentine'])) {
/* За плаќањето */
$cena=hex2bin($_GET['cena']);
$cena_len=strlen($cena);
$details1= hex2bin($_GET['desc']);
$details1_len=strlen($details1);
$details2=hex2bin($_GET['next_id_last']);
$details2_len=strlen($details2);
$PaymentOKURL="https://prvdovrv.mk/ok.php?n=".$details2;
$PaymentOKURL_len=strlen($PaymentOKURL);
$PaymentFailURL="https://prvdovrv.mk/fail.php?n=".$details2;
$PaymentFailURL_len=strlen($PaymentFailURL);
$InputsLenght="0".$PaymentOKURL_len."0".$PaymentFailURL_len."00".$cena_len."010"."017"."003"."0".$details1_len."00".$details2_len;
$CheckSum="08PaymentOKURL,PaymentFailURL,AmountToPay,PayToMerchant,MerchantName,AmountCurrency,Details1,Details2,".$InputsLenght.$PaymentOKURL.$PaymentFailURL.$cena."1000000791PRV DO VRV SkopjeMKD".$details1.$details2."HMQkm5uS1aUCrFNF";
/* ****** */
?>
}
?>
if(isset($_GET['hello-autumn'])) {
require_once('phpmailer/class.phpmailer.php');
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
// Create connection
$connA = mysqli_connect($servername, $username, $password, $dbname);
mysqli_set_charset($connA,"utf8");
$result = mysqli_query($connA, "SELECT * FROM events where id=28");
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
/*if ($_SESSION["pol"] == 'female') {
$cena=200;
} else {
$cena=$row['cena'];
}*/
$cena1=$row['cena'];
$cena2=$row['cena2'];
/*if ($_SESSION["skm"]>0) {
$cena = 500;
} */
/* samo za 8 mart 2019
if ($_SESSION["pol"] == 'female') {
$cena=350;
}
*/
$opis = "ЕСЕНСКА 5К 2020";
$desc = $row['ime'];
$godina=$row['godina'];
$datum=date("Y-m-d H:i:s", strtotime('+0 hours'));
$ipadresa=$_SERVER["HTTP_X_FORWARDED_FOR"];
if ($ipadresa == "") {
$ipadresa=$_SERVER["REMOTE_ADDR"];
}
$trka="autumnrun";
$ime=$_POST['ime'];
$prezime=$_POST['prezime'];
$birth=$_POST['rodenden'];
$pol=$_POST['pol'];
$tip = $_POST['kategorija'];
$size = $_POST['size'];
$tim = $_POST['tim'];
$skm = $_POST['skm'];
$lozinka = $_POST['lozinka'];
$kit = $_POST['kit'];
$competition = $_POST['competition'];
/*if($tip=='mrun'){
$coverpic='run.jpg';
}else if ($tip=='mbike') {
$coverpic='mtb.jpg';
}else if ($tip=='rbike'){
$coverpic='road.jpg';
}*/
$coverpic='autumnrun-email-cover.jpg';
$email = $_POST['email'];
$tel = $_POST['telefon'];
$country = $_POST['country'];
$city = $_POST['city'];
if ($skm==""){
$skm=0;
}
if ($tip === "SummitRun"){
$kit="plus";
$competition = "hobby";
}
// za 8 mart 2020
/*
if ($pol == 'female') {
$cena1 = $cena1*0.85;
$cena2 = $cena2*0.85;
}
*/
if ($kit === "basic") {
$cena = $cena1;
} elseif ($kit === "plus"){
$cena = $cena2;
}
$cena = $cena1;
$cenareal=$cena;
$cena=$cena."00";
//$idunique = md5(uniqid($email, true));
/* Проверка на следен ID
$mysql_result = mysql_query("SHOW TABLE STATUS LIKE 'sportdayohrid'");
$data = mysql_fetch_assoc($mysql_result);
$nextid = $data['Auto_increment']; */
/* Запишување на регистрацијата */
$dupesql = "SELECT * FROM sportdayohrid where trka = '$trka' and godina = $godina and ime = '$ime' and prezime = '$prezime' and email = '$email'";
$duperaw = mysqli_query($conn, $dupesql);
if (mysqli_num_rows($duperaw) == 0) {
$sql = "INSERT INTO sportdayohrid (datum, ipadresa, trka, godina, tip, competition, ime, prezime, rodenden, email, telefon, city, country, pol, kit, size, tim, skmbib, uplata, uplata_nacin, access_token, refresh_token, strava_status, expires_at) VALUES ('$datum', '$ipadresa', '$trka', $godina, '$tip', '$competition', '$ime', '$prezime', '$birth', '$email', '$tel', '$city', '$country','$pol', '$kit', '$size', '$tim', $skm, 0, 0, 0, 0, 0, 0)";
mysqli_query($conn, $sql);
$nextid=mysqli_insert_id($conn);
$_SESSION["id"] = $nextid;
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$body = file_get_contents('newsletters/registerednotpaid.htm');
//if($kit=='virtual'){$body = file_get_contents('newsletters/registerednopayment.htm');}
//$body = eregi_replace("[\]",'',$body);
$body = str_replace('[ime]',$ime,$body);
$body = str_replace('[prezime]',$prezime,$body);
$body = str_replace('[nastan]',$opis,$body);
$body = str_replace('[cena]',$cenareal,$body);
$body = str_replace('[id]',$_SESSION["id"],$body);
$body = str_replace('[coverpic]',$coverpic,$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Регистрација за ". $opis;
$mail->AddAddress($email);
$mail->MsgHTML($body);
$send = $mail->Send();
$mail->ClearAllRecipients();
}
/************/
}
/* $resultlast = mysql_query("SELECT LAST_INSERT_ID()", $conn);
$rowlast = mysql_fetch_array($resultlast);
$nextid=$rowlast['id']; */
/* За плаќањето */
$cena_len=strlen($cena);
$details1= $desc;
$details1_len=strlen($details1);
$details2=$_SESSION["id"];
$details2_len=strlen($details2);
$PaymentOKURL="https://prvdovrv.mk/ok.php?n=".$details2;
$PaymentOKURL_len=strlen($PaymentOKURL);
$PaymentFailURL="https://prvdovrv.mk/fail.php?n=".$details2;
$PaymentFailURL_len=strlen($PaymentFailURL);
$InputsLenght="0".$PaymentOKURL_len."0".$PaymentFailURL_len."00".$cena_len."010"."017"."003"."0".$details1_len."00".$details2_len;
$CheckSum="08PaymentOKURL,PaymentFailURL,AmountToPay,PayToMerchant,MerchantName,AmountCurrency,Details1,Details2,".$InputsLenght.$PaymentOKURL.$PaymentFailURL.$cena."1000000791PRV DO VRV SkopjeMKD".$details1.$details2."HMQkm5uS1aUCrFNF";
/* ****** */
?>
Здраво echo $ime ?>
if($cenareal <> 0) { ?>
Ги имаме твоите податоци за учество на echo $opis ?>.
За успешно комплетирање на регистрацијата потребно е да се плати котизацијата од echo $cena/100 ?> денари .
Цената важи до 15.11.2020 год.
Thank you for the registration for echo $details1 ?>.
For the successful completion of the registration you have to pay the fee of echo $cena/100 ?> denars .
The price is valid until 15.11.2020.
//echo md5(uniqid($_SESSION["email"], true)) ?>
} else { ?>
} ?>
}
?>
if(isset($_GET['hello-springrun'])) {
require_once('phpmailer/class.phpmailer.php');
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
// Create connection
$connA = mysqli_connect($servername, $username, $password, $dbname);
mysqli_set_charset($connA,"utf8");
$result = mysqli_query($connA, "SELECT * FROM events where id=26");
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
/*if ($_SESSION["pol"] == 'female') {
$cena=200;
} else {
$cena=$row['cena'];
}*/
$cena1=$row['cena'];
$cena2=$row['cena2'];
/*if ($_SESSION["skm"]>0) {
$cena = 500;
} */
/* samo za 8 mart 2019
if ($_SESSION["pol"] == 'female') {
$cena=350;
}
*/
$opis = "ПРВ ДО ВРВ Водно 2020";
$desc = $row['ime'];
$godina=$row['godina'];
$datum=date("Y-m-d H:i:s", strtotime('+0 hours'));
$ipadresa=$_SERVER["HTTP_X_FORWARDED_FOR"];
if ($ipadresa == "") {
$ipadresa=$_SERVER["REMOTE_ADDR"];
}
$trka="springrun";
$ime=$_POST['ime'];
$prezime=$_POST['prezime'];
$birth=$_POST['rodenden'];
$pol=$_POST['pol'];
$tip = $_POST['kategorija'];
$size = $_POST['size'];
$tim = $_POST['tim'];
$skm = $_POST['skm'];
$lozinka = $_POST['lozinka'];
$kit = $_POST['kit'];
$competition = $_POST['competition'];
if($tip=='mrun'){
$coverpic='run.jpg';
}else if ($tip=='mbike') {
$coverpic='mtb.jpg';
}else if ($tip=='rbike'){
$coverpic='road.jpg';
}
$email = $_POST['email'];
$tel = $_POST['telefon'];
$country = $_POST['country'];
$city = $_POST['city'];
if ($skm==""){
$skm=0;
}
if ($tip === "SummitRun"){
$kit="plus";
$competition = "hobby";
}
// za 8 mart 2020
/*
if ($pol == 'female') {
$cena1 = $cena1*0.85;
$cena2 = $cena2*0.85;
}
*/
if ($kit === "basic") {
$cena = $cena1;
} elseif ($kit === "plus"){
$cena = $cena2;
} else {
$cena = 0;
}
$cenareal=$cena;
$cena=$cena."00";
//$idunique = md5(uniqid($email, true));
/* Проверка на следен ID
$mysql_result = mysql_query("SHOW TABLE STATUS LIKE 'sportdayohrid'");
$data = mysql_fetch_assoc($mysql_result);
$nextid = $data['Auto_increment']; */
/* Запишување на регистрацијата */
$dupesql = "SELECT * FROM sportdayohrid where trka = '$trka' and godina = $godina and ime = '$ime' and prezime = '$prezime' and email = '$email'";
$duperaw = mysqli_query($conn, $dupesql);
if (mysqli_num_rows($duperaw) == 0) {
$sql = "INSERT INTO sportdayohrid (datum, ipadresa, trka, godina, tip, competition, ime, prezime, rodenden, email, telefon, city, country, pol, kit, size, tim, skmbib, uplata, uplata_nacin, access_token, refresh_token, strava_status, expires_at) VALUES ('$datum', '$ipadresa', '$trka', $godina, '$tip', '$competition', '$ime', '$prezime', '$birth', '$email', '$tel', '$city', '$country','$pol', '$kit', '$size', '$tim', $skm, 0, 0, 0, 0, 0, 0)";
mysqli_query($conn, $sql);
$nextid=mysqli_insert_id($conn);
$_SESSION["id"] = $nextid;
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
//$body = file_get_contents('newsletters/registerednotpaid.htm');
$body = file_get_contents('newsletters/registerednopayment.htm');
$body = str_replace('[ime]',$ime,$body);
$body = str_replace('[prezime]',$prezime,$body);
$body = str_replace('[nastan]',$opis,$body);
$body = str_replace('[cena]',$cenareal,$body);
$body = str_replace('[id]',$_SESSION["id"],$body);
$body = str_replace('[coverpic]',$coverpic,$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Регистрација за ". $desc;
$mail->AddAddress($email);
$mail->MsgHTML($body);
$send = $mail->Send();
$mail->ClearAllRecipients();
}
/************/
}
/* $resultlast = mysql_query("SELECT LAST_INSERT_ID()", $conn);
$rowlast = mysql_fetch_array($resultlast);
$nextid=$rowlast['id']; */
/* За плаќањето */
$cena_len=strlen($cena);
$details1= $desc;
$details1_len=strlen($details1);
$details2=$_SESSION["id"];
$details2_len=strlen($details2);
$PaymentOKURL="https://prvdovrv.mk/ok.php?n=".$details2;
$PaymentOKURL_len=strlen($PaymentOKURL);
$PaymentFailURL="https://prvdovrv.mk/fail.php?n=".$details2;
$PaymentFailURL_len=strlen($PaymentFailURL);
$InputsLenght="0".$PaymentOKURL_len."0".$PaymentFailURL_len."00".$cena_len."010"."017"."003"."0".$details1_len."00".$details2_len;
$CheckSum="08PaymentOKURL,PaymentFailURL,AmountToPay,PayToMerchant,MerchantName,AmountCurrency,Details1,Details2,".$InputsLenght.$PaymentOKURL.$PaymentFailURL.$cena."1000000791PRV DO VRV SkopjeMKD".$details1.$details2."HMQkm5uS1aUCrFNF";
/* ****** */
?>
Здраво echo $ime ?>
if($cenareal <> 0) { ?>
Ги имаме твоите податоци за учество на echo $opis ?>.
За успешно комплетирање на регистрацијата потребно е да се плати котизацијата од echo $cena/100 ?> денари .
Цената важи до 4.5.2020 год.
Thank you for the registration for echo $details1 ?>.
For the successful completion of the registration you need to pay the fee of echo $cena/100 ?> denars .
The price is valid until 4.5.2020.
//echo md5(uniqid($_SESSION["email"], true)) ?>
} else { ?>
} ?>
}
?>
if(isset($_GET['hello2019'])) {
$_SESSION["kategorija"] = $_POST['kategorija'];
$_SESSION["size"] = $_POST['size'];
$_SESSION["tim"] = $_POST['tim'];
$_SESSION["skm"] = $_POST['skm'];
$_SESSION["lozinka"] = $_POST['lozinka'];
$_SESSION["kit"] = $_POST['kit'];
$_SESSION["competition"] = $_POST['competition'];
$coverpic='run.jpg';
?>
require_once('phpmailer/class.phpmailer.php');
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
// Create connection
$connA = mysql_connect($servername, $username, $password, true);
// Check connection
if (!$connA) {
die("Connection failed: " . mysql_error());
}
$db_selected = mysql_select_db($dbname, $connA);
$result = mysql_query("SELECT * FROM events where id=16", $connA);
$row = mysql_fetch_array($result);
/*if ($_SESSION["pol"] == 'female') {
$cena=200;
} else {
$cena=$row['cena'];
}*/
$cena1=$row['cena'];
$cena2=$row['cena2'];
$kit=$_SESSION["kit"];
/*if ($_SESSION["skm"]>0) {
$cena = 500;
} */
/* samo za 8 mart 2019
if ($_SESSION["pol"] == 'female') {
$cena=350;
}
*/
$opis = "ПРВ ДО ВРВ Водно 2019";
$desc = $row['ime'];
$godina=$row['godina'];
$datum=date("Y-m-d H:i:s", strtotime('+0 hours'));
$ipadresa=$_SERVER["HTTP_X_FORWARDED_FOR"];
if ($ipadresa == "") {
$ipadresa=$_SERVER["REMOTE_ADDR"];
}
$trka="PDV";
$ime=$_SESSION["ime"];
$prezime=$_SESSION["prezime"];
$birth=$_SESSION["rodenden"];
$pol=$_SESSION["pol"];
$size=$_SESSION["size"];
$tel=$_SESSION["telefon"];
$email=$_SESSION["email"];
$tip=$_SESSION["kategorija"];
$tim=$_SESSION["tim"];
$skm=$_SESSION["skm"];
if ($skm==""){
$skm=0;
}
$city=$_SESSION["city"];
$country=$_SESSION["country"];
$kit=$_SESSION["kit"];
$competition=$_SESSION["competition"];
if ($tip === "SummitRun"){
$kit="plus";
$competition = "hobby";
}
if ($kit === "basic") {
$cena = $cena1;
} elseif ($kit === "plus"){
$cena = $cena2;
}
$cenareal=$cena;
$cena=$cena."00";
//$idunique = md5(uniqid($email, true));
/* Проверка на следен ID
$mysql_result = mysql_query("SHOW TABLE STATUS LIKE 'sportdayohrid'");
$data = mysql_fetch_assoc($mysql_result);
$nextid = $data['Auto_increment']; */
/* Запишување на регистрацијата */
$dupesql = "SELECT * FROM sportdayohrid where trka = '$trka' and godina = $godina and ime = '$ime' and prezime = '$prezime' and email = '$email'";
$duperaw = mysql_query($dupesql, $conn);
if (mysql_num_rows($duperaw) == 0) {
$sql = "INSERT INTO sportdayohrid (datum, ipadresa, trka, godina, tip, competition, ime, prezime, rodenden, email, telefon, city, country, pol, kit, size, tim, skmbib) VALUES ('$datum', '$ipadresa', '$trka', $godina, '$tip', '$competition', '$ime', '$prezime', '$birth', '$email', '$tel', '$city', '$country','$pol', '$kit', '$size', '$tim', $skm)";
mysql_query($sql, $conn);
$nextid=mysql_insert_id($conn);
$_SESSION["id"] = $nextid;
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$body = file_get_contents('newsletters/registerednotpaid.htm');
$body = eregi_replace("[\]",'',$body);
$body = str_replace('[ime]',$ime,$body);
$body = str_replace('[prezime]',$prezime,$body);
$body = str_replace('[nastan]',$opis,$body);
$body = str_replace('[cena]',$cenareal,$body);
$body = str_replace('[id]',$_SESSION["id"],$body);
$body = str_replace('[coverpic]',$coverpic,$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Регистрација за ". $opis;
$mail->AddAddress($email);
$mail->MsgHTML($body);
$send = $mail->Send();
$mail->ClearAllRecipients();
}
/************/
}
/* $resultlast = mysql_query("SELECT LAST_INSERT_ID()", $conn);
$rowlast = mysql_fetch_array($resultlast);
$nextid=$rowlast['id']; */
/* За плаќањето */
$cena_len=strlen($cena);
$details1= $desc;
$details1_len=strlen($details1);
$details2=$_SESSION["id"];
$details2_len=strlen($details2);
$PaymentOKURL="https://prvdovrv.mk/ok.php?n=".$details2;
$PaymentOKURL_len=strlen($PaymentOKURL);
$PaymentFailURL="https://prvdovrv.mk/fail.php?n=".$details2;
$PaymentFailURL_len=strlen($PaymentFailURL);
$InputsLenght="0".$PaymentOKURL_len."0".$PaymentFailURL_len."00".$cena_len."010"."017"."003"."0".$details1_len."00".$details2_len;
$CheckSum="08PaymentOKURL,PaymentFailURL,AmountToPay,PayToMerchant,MerchantName,AmountCurrency,Details1,Details2,".$InputsLenght.$PaymentOKURL.$PaymentFailURL.$cena."1000000791PRV DO VRV SkopjeMKD".$details1.$details2."HMQkm5uS1aUCrFNF";
/* ****** */
?>
Здраво / Hello echo $_SESSION["ime"] ?>
Ги имаме твоите податоци за учество на echo $opis ?>.
За успешно комплетирање на регистрацијата потребно е да се плати котизацијата од echo $cena/100 ?> денари .
Цената важи до 18.5.2019 год. до 14 часот, кога се затвора пријавувањето.
Thank you for the registration for echo $details1 ?>.
For the successful completion of the registration you need to pay the fee of echo $cena/100 ?> denars .
The price is valid until 18.5.2019, 14 o'clock. After this the registration will be closed.
//echo md5(uniqid($_SESSION["email"], true)) ?>
}
?>
if(isset($_GET['hellosh'])) {
$_SESSION["kategorija"] = $_POST['kategorija'];
$_SESSION["size"] = $_POST['size'];
$_SESSION["tim"] = $_POST['tim'];
$_SESSION["skm"] = $_POST['skm'];
$_SESSION["lozinka"] = $_POST['lozinka'];
$_SESSION["kit"] = $_POST['kit'];
// $_SESSION["competition"] = $_POST['competition'];
$coverpic='run.jpg';
?>
require 'phpmailer/PHPMailerAutoload.php';
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
// Create connection
$connA = mysqli_connect($servername, $username, $password, $dbname);
mysqli_set_charset($connA,"utf8");
$result = mysqli_query($connA, "SELECT * FROM events where id=21");
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
/*if ($_SESSION["pol"] == 'female') {
$cena=200;
} else {
$cena=$row['cena'];
}*/
$cena1=$row['cena'];
$cena2=$row['cena2'];
$kit=$_SESSION["kit"];
/*if ($_SESSION["skm"]>0) {
$cena = 500;
} */
// $cena=$row['cena'];
if ($kit == 'basic') {
if ($_SESSION["skm"]>0) {
$cena = 300;
} else {
$cena = 400;
}
} else {
if ($_SESSION["skm"]>0) {
$cena = 500;
} else {
$cena = 600;
}
}
$cenareal=$cena;
$cena=$cena."00";
$opis = $row['ime'];
$desc = "Sharra Challenge 2019";
$godina=$row['godina'];
$datum=date("Y-m-d H:i:s", strtotime('+1 hours'));
$ipadresa=$_SERVER["HTTP_X_FORWARDED_FOR"];
if ($ipadresa == "") {
$ipadresa=$_SERVER["REMOTE_ADDR"];
}
$trka="sharra";
$ime=$_SESSION["ime"];
$prezime=$_SESSION["prezime"];
$birth=$_SESSION["rodenden"];
$pol=$_SESSION["pol"];
$size=$_SESSION["size"];
$tel=$_SESSION["telefon"];
$email=$_SESSION["email"];
$tip=$_SESSION["kategorija"];
$tim=$_SESSION["tim"];
$skm=$_SESSION["skm"];
if ($skm==""){
$skm=0;
}
//$idunique = md5(uniqid($email, true));
/* Проверка на следен ID
$mysql_result = mysql_query("SHOW TABLE STATUS LIKE 'sportdayohrid'");
$data = mysql_fetch_assoc($mysql_result);
$nextid = $data['Auto_increment']; */
/* Запишување на регистрацијата */
$dupesql = "SELECT * FROM sportdayohrid where trka = '$trka' and godina = $godina and ime = '$ime' and prezime = '$prezime' and email = '$email'";
$duperaw = mysqli_query($conn, $dupesql);
if (mysqli_num_rows($duperaw) == 0) {
$sql = "INSERT INTO sportdayohrid (datum, ipadresa, trka, godina, tip, ime, prezime, rodenden, email, telefon, pol, kit, size, tim, skmbib, bib) VALUES ('$datum', '$ipadresa', '$trka', $godina, '$tip', '$ime', '$prezime', '$birth', '$email', '$tel', '$pol', '$kit', '$size', '$tim', $skm, 0)";
mysqli_query($conn, $sql);
$nextid=mysqli_insert_id($conn);
$_SESSION["id"] = $nextid;
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$body = file_get_contents('newsletters/registerednotpaid.htm');
// $body = eregi_replace("[\]",'',$body);
$body = str_replace('[ime]',$ime,$body);
$body = str_replace('[prezime]',$prezime,$body);
$body = str_replace('[nastan]',$opis,$body);
$body = str_replace('[cena]',$cenareal,$body);
$body = str_replace('[id]',$_SESSION["id"],$body);
$body = str_replace('[coverpic]',$coverpic,$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Регистрација за ". $opis;
$mail->AddAddress($email);
$mail->MsgHTML($body);
$send = $mail->Send();
$mail->ClearAllRecipients();
}
/************/
}
/* $resultlast = mysql_query("SELECT LAST_INSERT_ID()", $conn);
$rowlast = mysql_fetch_array($resultlast);
$nextid=$rowlast['id']; */
/* За плаќањето */
$cena_len=strlen($cena);
$details1= $desc;
$details1_len=strlen($details1);
$details2=$_SESSION["id"];
$details2_len=strlen($details2);
$PaymentOKURL="http://prvdovrv.mk/ok.php?n=".$details2;
$PaymentOKURL_len=strlen($PaymentOKURL);
$PaymentFailURL="http://prvdovrv.mk/fail.php?n=".$details2;
$PaymentFailURL_len=strlen($PaymentFailURL);
$InputsLenght="0".$PaymentOKURL_len."0".$PaymentFailURL_len."00".$cena_len."010"."017"."003"."0".$details1_len."00".$details2_len;
$CheckSum="08PaymentOKURL,PaymentFailURL,AmountToPay,PayToMerchant,MerchantName,AmountCurrency,Details1,Details2,".$InputsLenght.$PaymentOKURL.$PaymentFailURL.$cena."1000000791PRV DO VRV SkopjeMKD".$details1.$details2."HMQkm5uS1aUCrFNF";
/* ****** */
?>
Здраво echo $_SESSION["ime"] ?>
Ги имаме твоите податоци за учество на echo $opis ?>.
За успешно комплетирање на регистрацијата потребно е да се плати котизацијата од echo $cena/100 ?> денари .
//echo md5(uniqid($_SESSION["email"], true)) ?>
}
?>
if(isset($_GET['meetingok'])) {
$ime=$_POST["ime"];
$prezime=$_POST["prezime"];
$birth=$_POST["rodenden"];
$pol=$_POST["pol"];
$tel=$_POST["telefon"];
$email=$_POST["email"];
$tip = $_POST['kategorija'];
$size=$_POST["size"];
$dres=$_POST["dres"];
$coverpic='aamsk19-web-cover.jpg';
?>
require_once('phpmailer/class.phpmailer.php');
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
// Create connection
$connA = mysql_connect($servername, $username, $password, true);
// Check connection
if (!$connA) {
die("Connection failed: " . mysql_error());
}
$db_selected = mysql_select_db($dbname, $connA);
$result = mysql_query("SELECT * FROM events where id=18", $connA);
$row = mysql_fetch_array($result);
/*if ($_SESSION["pol"] == 'female') {
$cena=200;
} else {
$cena=$row['cena'];
}*/
$cena=$row['cena'];
if ($_POST['dres'] == 'dres') {
$cena = 600;
}
$cenareal=$cena;
$cena=$cena."00";
$opis = $row['ime'];
$desc = "AAM Skopje 2019";
$godina=$row['godina'];
$datum=date("Y-m-d H:i:s", strtotime('+1 hours'));
$ipadresa=$_SERVER["HTTP_X_FORWARDED_FOR"];
if ($ipadresa == "") {
$ipadresa=$_SERVER["REMOTE_ADDR"];
}
$trka="AAM";
//$idunique = md5(uniqid($email, true));
/* Проверка на следен ID
$mysql_result = mysql_query("SHOW TABLE STATUS LIKE 'sportdayohrid'");
$data = mysql_fetch_assoc($mysql_result);
$nextid = $data['Auto_increment']; */
/* Запишување на регистрацијата */
$dupesql = "SELECT * FROM sportdayohrid where trka = '$trka' and godina = $godina and ime = '$ime' and prezime = '$prezime' and email = '$email'";
$duperaw = mysql_query($dupesql, $conn);
if (mysql_num_rows($duperaw) == 0) {
$sql = "INSERT INTO sportdayohrid (datum, ipadresa, trka, godina, tip, ime, prezime, rodenden, email, telefon, pol, size, cena) VALUES ('$datum', '$ipadresa', '$trka', $godina, '$tip', '$ime', '$prezime', '$birth', '$email', '$tel', '$pol', '$size', '$cenareal')";
mysql_query($sql, $conn);
$nextid=mysql_insert_id($conn);
$_SESSION["id"] = $nextid;
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$body = file_get_contents('newsletters/registerednotpaid.htm');
$body = eregi_replace("[\]",'',$body);
$body = str_replace('[ime]',$ime,$body);
$body = str_replace('[prezime]',$prezime,$body);
$body = str_replace('[nastan]',$opis,$body);
$body = str_replace('[cena]',$cenareal,$body);
$body = str_replace('[id]',$_SESSION["id"],$body);
$body = str_replace('[coverpic]',$coverpic,$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Регистрација за ". $opis;
$mail->AddAddress($email);
$mail->MsgHTML($body);
$send = $mail->Send();
$mail->ClearAllRecipients();
}
/************/
}
/* $resultlast = mysql_query("SELECT LAST_INSERT_ID()", $conn);
$rowlast = mysql_fetch_array($resultlast);
$nextid=$rowlast['id']; */
/* За плаќањето */
$cena_len=strlen($cena);
$details1= $desc;
$details1_len=strlen($details1);
$details2=$_SESSION["id"];
$details2_len=strlen($details2);
$PaymentOKURL="http://prvdovrv.mk/ok.php?n=".$details2;
$PaymentOKURL_len=strlen($PaymentOKURL);
$PaymentFailURL="http://prvdovrv.mk/fail.php?n=".$details2;
$PaymentFailURL_len=strlen($PaymentFailURL);
$InputsLenght="0".$PaymentOKURL_len."0".$PaymentFailURL_len."00".$cena_len."010"."017"."003"."0".$details1_len."00".$details2_len;
$CheckSum="08PaymentOKURL,PaymentFailURL,AmountToPay,PayToMerchant,MerchantName,AmountCurrency,Details1,Details2,".$InputsLenght.$PaymentOKURL.$PaymentFailURL.$cena."1000000791PRV DO VRV SkopjeMKD".$details1.$details2."HMQkm5uS1aUCrFNF";
/* ****** */
?>
Здраво echo $_SESSION["ime"] ?>
Ги имаме твоите податоци за учество на echo $opis ?>.
За успешно комплетирање на регистрацијата потребно е да се плати котизацијата од echo $cena/100 ?> денари .
//echo md5(uniqid($_SESSION["email"], true)) ?>
}
?>
if(isset($_GET['ponikvaok'])) {
$ime=$_POST["ime"];
$prezime=$_POST["prezime"];
$birth=$_POST["rodenden"];
$pol=$_POST["pol"];
$tel=$_POST["telefon"];
$email=$_POST["email"];
$size=$_POST["size"];
$pdv = $_POST['skm'];
$coverpic='OA-web-cover-2018-2.jpg';
?>
require_once('phpmailer/class.phpmailer.php');
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
// Create connection
$connA = mysql_connect($servername, $username, $password, true);
// Check connection
if (!$connA) {
die("Connection failed: " . mysql_error());
}
$db_selected = mysql_select_db($dbname, $connA);
$result = mysql_query("SELECT * FROM events where id=20", $connA);
$row = mysql_fetch_array($result);
/*if ($_SESSION["pol"] == 'female') {
$cena=200;
} else {
$cena=$row['cena'];
}*/
$cena=$row['cena'];
/*if ($pdv>1500) {
$cena = 299;
}*/
$cenareal=$cena;
$cena=$cena."00";
$opis = $row['ime'];
$desc = "OSOGOVO ADVENTURE 2019";
$godina=$row['godina'];
$datum=date("Y-m-d H:i:s", strtotime('+1 hours'));
$ipadresa=$_SERVER["HTTP_X_FORWARDED_FOR"];
if ($ipadresa == "") {
$ipadresa=$_SERVER["REMOTE_ADDR"];
}
$trka="ponikvatour";
//$idunique = md5(uniqid($email, true));
/* Проверка на следен ID
$mysql_result = mysql_query("SHOW TABLE STATUS LIKE 'sportdayohrid'");
$data = mysql_fetch_assoc($mysql_result);
$nextid = $data['Auto_increment']; */
/* Запишување на регистрацијата */
$dupesql = "SELECT * FROM sportdayohrid where trka = '$trka' and godina = $godina and ime = '$ime' and prezime = '$prezime' and email = '$email'";
$duperaw = mysql_query($dupesql, $conn);
if (mysql_num_rows($duperaw) == 0) {
$sql = "INSERT INTO sportdayohrid (datum, ipadresa, trka, godina, ime, prezime, rodenden, email, telefon, pol, size, cena, skmbib) VALUES ('$datum', '$ipadresa', '$trka', $godina, '$ime', '$prezime', '$birth', '$email', '$tel', '$pol', '$size', $cenareal, '$pdv')";
mysql_query($sql, $conn);
$nextid=mysql_insert_id($conn);
$_SESSION["id"] = $nextid;
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$body = file_get_contents('newsletters/registerednotpaid.htm');
$body = eregi_replace("[\]",'',$body);
$body = str_replace('[ime]',$ime,$body);
$body = str_replace('[prezime]',$prezime,$body);
$body = str_replace('[nastan]',$opis,$body);
$body = str_replace('[cena]',$cenareal,$body);
$body = str_replace('[id]',$_SESSION["id"],$body);
$body = str_replace('[coverpic]',$coverpic,$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Регистрација за ". $opis;
$mail->AddAddress($email);
$mail->MsgHTML($body);
$send = $mail->Send();
$mail->ClearAllRecipients();
}
/************/
}
/* $resultlast = mysql_query("SELECT LAST_INSERT_ID()", $conn);
$rowlast = mysql_fetch_array($resultlast);
$nextid=$rowlast['id']; */
/* За плаќањето */
$cena_len=strlen($cena);
$details1= $desc;
$details1_len=strlen($details1);
$details2=$_SESSION["id"];
$details2_len=strlen($details2);
$PaymentOKURL="http://prvdovrv.mk/ok.php?n=".$details2;
$PaymentOKURL_len=strlen($PaymentOKURL);
$PaymentFailURL="http://prvdovrv.mk/fail.php?n=".$details2;
$PaymentFailURL_len=strlen($PaymentFailURL);
$InputsLenght="0".$PaymentOKURL_len."0".$PaymentFailURL_len."00".$cena_len."010"."017"."003"."0".$details1_len."00".$details2_len;
$CheckSum="08PaymentOKURL,PaymentFailURL,AmountToPay,PayToMerchant,MerchantName,AmountCurrency,Details1,Details2,".$InputsLenght.$PaymentOKURL.$PaymentFailURL.$cena."1000000791PRV DO VRV SkopjeMKD".$details1.$details2."HMQkm5uS1aUCrFNF";
/* ****** */
?>
Здраво echo $_SESSION["ime"] ?>
Ги имаме твоите податоци за учество на echo $opis ?>.
За успешно комплетирање на регистрацијата потребно е да се плати котизацијата од echo $cena/100 ?> денари во рок од 2 дена за да може да се искористи промотивниот попуст.
Потоа цената се зголемува.
//echo md5(uniqid($_SESSION["email"], true)) ?>
}
?>
if(isset($_GET['savaok'])) {
$ime=$_POST["ime"];
$prezime=$_POST["prezime"];
$birth=$_POST["rodenden"];
$pol=$_POST["pol"];
$tel=$_POST["telefon"];
$email=$_POST["email"];
$size=$_POST["size"];
//$pdv = $_POST['skm'];
$coverpic='PT-WWW-Cover.jpg';
?>
require_once('phpmailer/class.phpmailer.php');
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
// Create connection
$connA = mysql_connect($servername, $username, $password, true);
// Check connection
if (!$connA) {
die("Connection failed: " . mysql_error());
}
$db_selected = mysql_select_db($dbname, $connA);
$result = mysql_query("SELECT * FROM events where id=5", $connA);
$row = mysql_fetch_array($result);
/*if ($_SESSION["pol"] == 'female') {
$cena=200;
} else {
$cena=$row['cena'];
}*/
$cena=$row['cena'];
/*if ($pdv>1500) {
$cena = 299;
} */
$cenareal=$cena;
$cena=$cena."00";
$opis = $row['ime'];
$desc = "Sava Adrenaline Adventure 2017";
$godina=$row['godina'];
$datum=date("Y-m-d H:i:s", strtotime('+1 hours'));
$ipadresa=$_SERVER["HTTP_X_FORWARDED_FOR"];
if ($ipadresa == "") {
$ipadresa=$_SERVER["REMOTE_ADDR"];
}
$trka="bistratour";
//$idunique = md5(uniqid($email, true));
/* Проверка на следен ID
$mysql_result = mysql_query("SHOW TABLE STATUS LIKE 'sportdayohrid'");
$data = mysql_fetch_assoc($mysql_result);
$nextid = $data['Auto_increment']; */
/* Запишување на регистрацијата */
$dupesql = "SELECT * FROM sportdayohrid where trka = '$trka' and godina = $godina and ime = '$ime' and prezime = '$prezime' and email = '$email'";
$duperaw = mysql_query($dupesql, $conn);
if (mysql_num_rows($duperaw) == 0) {
$sql = "INSERT INTO sportdayohrid (datum, ipadresa, trka, godina, ime, prezime, rodenden, email, telefon, pol, size, cena) VALUES ('$datum', '$ipadresa', '$trka', $godina, '$ime', '$prezime', '$birth', '$email', '$tel', '$pol', '$size', $cenareal)";
mysql_query($sql, $conn);
$nextid=mysql_insert_id($conn);
$_SESSION["id"] = $nextid;
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$body = file_get_contents('newsletters/registerednotpaid.htm');
$body = eregi_replace("[\]",'',$body);
$body = str_replace('[ime]',$ime,$body);
$body = str_replace('[prezime]',$prezime,$body);
$body = str_replace('[nastan]',$opis,$body);
$body = str_replace('[cena]',$cenareal,$body);
$body = str_replace('[id]',$_SESSION["id"],$body);
$body = str_replace('[coverpic]',$coverpic,$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Регистрација за ". $opis;
$mail->AddAddress($email);
$mail->MsgHTML($body);
$send = $mail->Send();
$mail->ClearAllRecipients();
}
/************/
}
/* $resultlast = mysql_query("SELECT LAST_INSERT_ID()", $conn);
$rowlast = mysql_fetch_array($resultlast);
$nextid=$rowlast['id']; */
/* За плаќањето */
$cena_len=strlen($cena);
$details1= $desc;
$details1_len=strlen($details1);
$details2=$_SESSION["id"];
$details2_len=strlen($details2);
$PaymentOKURL="http://prvdovrv.mk/ok.php?n=".$details2;
$PaymentOKURL_len=strlen($PaymentOKURL);
$PaymentFailURL="http://prvdovrv.mk/fail.php?n=".$details2;
$PaymentFailURL_len=strlen($PaymentFailURL);
$InputsLenght="0".$PaymentOKURL_len."0".$PaymentFailURL_len."00".$cena_len."010"."017"."003"."0".$details1_len."00".$details2_len;
$CheckSum="08PaymentOKURL,PaymentFailURL,AmountToPay,PayToMerchant,MerchantName,AmountCurrency,Details1,Details2,".$InputsLenght.$PaymentOKURL.$PaymentFailURL.$cena."1000000791PRV DO VRV SkopjeMKD".$details1.$details2."HMQkm5uS1aUCrFNF";
/* ****** */
?>
Здраво echo $ime ?>
Ги имаме твоите податоци за учество на echo $opis ?>.
За успешно комплетирање на регистрацијата и сигурно место во предвидениот број учесници во турата, потребно е да се плати котизацијата од echo $cena/100 ?> денари .
//echo md5(uniqid($_SESSION["email"], true)) ?>
}
?>
if(isset($_GET['tourdelakeok'])) {
$ime=$_POST["ime"];
$prezime=$_POST["prezime"];
$birth=$_POST["rodenden"];
$pol=$_POST["pol"];
$tel=$_POST["telefon"];
$email=$_POST["email"];
// $size=$_POST["size"];
//$pdv = $_POST['skm'];
$kategorija=$_POST["kategorija"];
$coverpic='tourdelake2017.jpg';
?>
require_once('phpmailer/class.phpmailer.php');
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
// Create connection
$connA = mysqli_connect($servername, $username, $password, $dbname);
mysqli_set_charset($connA,"utf8");
$result = mysqli_query($connA, "SELECT * FROM events where id=17");
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
/*if ($_SESSION["pol"] == 'female') {
$cena=200;
} else {
$cena=$row['cena'];
}*/
$cena=$row['cena'];
/*if ($pdv>1500) {
$cena = 299;
} */
$cenareal=$cena;
$cena=$cena."00";
$opis = $row['ime'];
$desc = "Tour de Lake(s) 2019";
$godina=$row['godina'];
$datum=date("Y-m-d H:i:s", strtotime('+1 hours'));
$ipadresa=$_SERVER["HTTP_X_FORWARDED_FOR"];
if ($ipadresa == "") {
$ipadresa=$_SERVER["REMOTE_ADDR"];
}
$trka="tourdelake";
//$idunique = md5(uniqid($email, true));
/* Проверка на следен ID
$mysql_result = mysql_query("SHOW TABLE STATUS LIKE 'sportdayohrid'");
$data = mysql_fetch_assoc($mysql_result);
$nextid = $data['Auto_increment']; */
/* Запишување на регистрацијата */
$dupesql = "SELECT * FROM sportdayohrid where trka = '$trka' and godina = $godina and ime = '$ime' and prezime = '$prezime' and email = '$email'";
$duperaw = mysqli_query($conn, $dupesql);
if (mysqli_num_rows($duperaw) == 0) {
$sql = "INSERT INTO sportdayohrid (datum, ipadresa, trka, godina, tip, ime, prezime, rodenden, email, telefon, pol, size, cena) VALUES ('$datum', '$ipadresa', '$trka', $godina, '$kategorija', '$ime', '$prezime', '$birth', '$email', '$tel', '$pol', '$size', $cenareal)";
mysqli_query($conn, $sql);
$nextid=mysqli_insert_id($conn);
$_SESSION["id"] = $nextid;
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$body = file_get_contents('newsletters/registeredfree.htm');
//$body = eregi_replace("[\]",'',$body);
$body = str_replace('[ime]',$ime,$body);
$body = str_replace('[prezime]',$prezime,$body);
$body = str_replace('[nastan]',$opis,$body);
$body = str_replace('[cena]',$cenareal,$body);
$body = str_replace('[id]',$_SESSION["id"],$body);
$body = str_replace('[coverpic]',$coverpic,$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Регистрација за ". $opis;
$mail->AddAddress($email);
$mail->MsgHTML($body);
$send = $mail->Send();
$mail->ClearAllRecipients();
}
/************/
}
/* $resultlast = mysql_query("SELECT LAST_INSERT_ID()", $conn);
$rowlast = mysql_fetch_array($resultlast);
$nextid=$rowlast['id']; */
/* За плаќањето */
$cena_len=strlen($cena);
$details1= $desc;
$details1_len=strlen($details1);
$details2=$_SESSION["id"];
$details2_len=strlen($details2);
$PaymentOKURL="http://prvdovrv.mk/ok.php?n=".$details2;
$PaymentOKURL_len=strlen($PaymentOKURL);
$PaymentFailURL="http://prvdovrv.mk/fail.php?n=".$details2;
$PaymentFailURL_len=strlen($PaymentFailURL);
$InputsLenght="0".$PaymentOKURL_len."0".$PaymentFailURL_len."00".$cena_len."010"."017"."003"."0".$details1_len."00".$details2_len;
$CheckSum="08PaymentOKURL,PaymentFailURL,AmountToPay,PayToMerchant,MerchantName,AmountCurrency,Details1,Details2,".$InputsLenght.$PaymentOKURL.$PaymentFailURL.$cena."1000000791PRV DO VRV SkopjeMKD".$details1.$details2."HMQkm5uS1aUCrFNF";
/* ****** */
?>
Здраво echo $ime ?>
Ти благодариме за успешната регистрација за echo $opis ?>.
//echo md5(uniqid($_SESSION["email"], true)) ?>
}
?>
if(isset($_GET['babinsrtok'])) {
$ime=$_POST["ime"];
$prezime=$_POST["prezime"];
$birth=$_POST["rodenden"];
$pol=$_POST["pol"];
$tel=$_POST["telefon"];
$email=$_POST["email"];
// $size=$_POST["size"];
//$pdv = $_POST['skm'];
$kategorija=$_POST["kategorija"];
$coverpic='babinsrt_email_cover.jpg';
?>
require_once('phpmailer/class.phpmailer.php');
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
// Create connection
$connA = mysqli_connect($servername, $username, $password, $dbname);
mysqli_set_charset($connA,"utf8");
$result = mysqli_query($connA, "SELECT * FROM events where id=31");
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
/*if ($_SESSION["pol"] == 'female') {
$cena=200;
} else {
$cena=$row['cena'];
}*/
$cena=$row['cena'];
/*if ($pdv>1500) {
$cena = 299;
} */
$cenareal=$cena;
$cena=$cena."00";
$opis = $row['ime'];
$desc = "MTB Babin Srt 2021";
$godina=$row['godina'];
$datum=date("Y-m-d H:i:s", strtotime('+1 hours'));
$ipadresa=$_SERVER["HTTP_X_FORWARDED_FOR"];
if ($ipadresa == "") {
$ipadresa=$_SERVER["REMOTE_ADDR"];
}
$trka="slavej";
//$idunique = md5(uniqid($email, true));
/* Проверка на следен ID
$mysql_result = mysql_query("SHOW TABLE STATUS LIKE 'sportdayohrid'");
$data = mysql_fetch_assoc($mysql_result);
$nextid = $data['Auto_increment']; */
/* Запишување на регистрацијата */
$dupesql = "SELECT * FROM sportdayohrid where trka = '$trka' and godina = $godina and ime = '$ime' and prezime = '$prezime' and email = '$email'";
$duperaw = mysqli_query($conn, $dupesql);
if (mysqli_num_rows($duperaw) == 0) {
$sql = "INSERT INTO sportdayohrid (datum, ipadresa, trka, godina, tip, ime, prezime, rodenden, email, telefon, pol, size, cena) VALUES ('$datum', '$ipadresa', '$trka', $godina, '$kategorija', '$ime', '$prezime', '$birth', '$email', '$tel', '$pol', '$size', $cenareal)";
mysqli_query($conn, $sql);
$nextid=mysqli_insert_id($conn);
$_SESSION["id"] = $nextid;
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$body = file_get_contents('newsletters/registeredfree.htm');
//$body = eregi_replace("[\]",'',$body);
$body = str_replace('[ime]',$ime,$body);
$body = str_replace('[prezime]',$prezime,$body);
$body = str_replace('[nastan]',$opis,$body);
$body = str_replace('[cena]',$cenareal,$body);
$body = str_replace('[id]',$_SESSION["id"],$body);
$body = str_replace('[coverpic]',$coverpic,$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Регистрација за ". $opis;
$mail->AddAddress($email);
$mail->MsgHTML($body);
$send = $mail->Send();
$mail->ClearAllRecipients();
}
/************/
}
/* $resultlast = mysql_query("SELECT LAST_INSERT_ID()", $conn);
$rowlast = mysql_fetch_array($resultlast);
$nextid=$rowlast['id']; */
/* За плаќањето */
$cena_len=strlen($cena);
$details1= $desc;
$details1_len=strlen($details1);
$details2=$_SESSION["id"];
$details2_len=strlen($details2);
$PaymentOKURL="http://prvdovrv.mk/ok.php?n=".$details2;
$PaymentOKURL_len=strlen($PaymentOKURL);
$PaymentFailURL="http://prvdovrv.mk/fail.php?n=".$details2;
$PaymentFailURL_len=strlen($PaymentFailURL);
$InputsLenght="0".$PaymentOKURL_len."0".$PaymentFailURL_len."00".$cena_len."010"."017"."003"."0".$details1_len."00".$details2_len;
$CheckSum="08PaymentOKURL,PaymentFailURL,AmountToPay,PayToMerchant,MerchantName,AmountCurrency,Details1,Details2,".$InputsLenght.$PaymentOKURL.$PaymentFailURL.$cena."1000000791PRV DO VRV SkopjeMKD".$details1.$details2."HMQkm5uS1aUCrFNF";
/* ****** */
?>
Здраво echo $ime ?>
Ти благодариме за успешната регистрација за echo $opis ?>.
//echo md5(uniqid($_SESSION["email"], true)) ?>
}
?>
if(isset($_GET['bistraadventureok'])) {
$ime=$_POST["ime"];
$prezime=$_POST["prezime"];
$birth=$_POST["rodenden"];
$pol=$_POST["pol"];
$tel=$_POST["telefon"];
$email=$_POST["email"];
// $size=$_POST["size"];
//$pdv = $_POST['skm'];
$kategorija=$_POST["kategorija"];
$coverpic='bistraadventure-cover-001-600px.jpg';
?>
require_once('phpmailer/class.phpmailer.php');
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
// Create connection
$connA = mysqli_connect($servername, $username, $password, $dbname);
mysqli_set_charset($connA,"utf8");
$result = mysqli_query($connA, "SELECT * FROM events where id=42");
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
/*if ($_SESSION["pol"] == 'female') {
$cena=200;
} else {
$cena=$row['cena'];
}*/
$cena=$row['cena'];
/*if ($pdv>1500) {
$cena = 299;
} */
$cenareal=$cena;
$cena=$cena."00";
$opis = $row['ime'];
$desc = "Sava MTB Bistra Adventure 2023";
$godina=$row['godina'];
$datum=date("Y-m-d H:i:s", strtotime('+1 hours'));
$ipadresa=$_SERVER["HTTP_X_FORWARDED_FOR"];
if ($ipadresa == "") {
$ipadresa=$_SERVER["REMOTE_ADDR"];
}
$trka="bistratour";
//$idunique = md5(uniqid($email, true));
/* Проверка на следен ID
$mysql_result = mysql_query("SHOW TABLE STATUS LIKE 'sportdayohrid'");
$data = mysql_fetch_assoc($mysql_result);
$nextid = $data['Auto_increment']; */
/* Запишување на регистрацијата */
$dupesql = "SELECT * FROM sportdayohrid where trka = '$trka' and godina = $godina and ime = '$ime' and prezime = '$prezime' and email = '$email'";
$duperaw = mysqli_query($conn, $dupesql);
if (mysqli_num_rows($duperaw) == 0) {
$sql = "INSERT INTO sportdayohrid (datum, ipadresa, trka, godina, tip, ime, prezime, rodenden, email, telefon, pol, size, cena) VALUES ('$datum', '$ipadresa', '$trka', $godina, '$kategorija', '$ime', '$prezime', '$birth', '$email', '$tel', '$pol', '$size', $cenareal)";
mysqli_query($conn, $sql);
$nextid=mysqli_insert_id($conn);
$_SESSION["id"] = $nextid;
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$body = file_get_contents('newsletters/registeredfree.htm');
//$body = eregi_replace("[\]",'',$body);
$body = str_replace('[ime]',$ime,$body);
$body = str_replace('[prezime]',$prezime,$body);
$body = str_replace('[nastan]',$opis,$body);
$body = str_replace('[eventpage]','bistraadventure',$body);
$body = str_replace('[cena]',$cenareal,$body);
$body = str_replace('[id]',$_SESSION["id"],$body);
$body = str_replace('[coverpic]',$coverpic,$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Регистрација за ". $opis;
$mail->AddAddress($email);
$mail->MsgHTML($body);
$send = $mail->Send();
$mail->ClearAllRecipients();
}
/************/
}
/* $resultlast = mysql_query("SELECT LAST_INSERT_ID()", $conn);
$rowlast = mysql_fetch_array($resultlast);
$nextid=$rowlast['id']; */
/* За плаќањето */
$cena_len=strlen($cena);
$details1= $desc;
$details1_len=strlen($details1);
$details2=$_SESSION["id"];
$details2_len=strlen($details2);
$PaymentOKURL="http://prvdovrv.mk/ok.php?n=".$details2;
$PaymentOKURL_len=strlen($PaymentOKURL);
$PaymentFailURL="http://prvdovrv.mk/fail.php?n=".$details2;
$PaymentFailURL_len=strlen($PaymentFailURL);
$InputsLenght="0".$PaymentOKURL_len."0".$PaymentFailURL_len."00".$cena_len."010"."017"."003"."0".$details1_len."00".$details2_len;
$CheckSum="08PaymentOKURL,PaymentFailURL,AmountToPay,PayToMerchant,MerchantName,AmountCurrency,Details1,Details2,".$InputsLenght.$PaymentOKURL.$PaymentFailURL.$cena."1000000791PRV DO VRV SkopjeMKD".$details1.$details2."HMQkm5uS1aUCrFNF";
/* ****** */
?>
Здраво echo $ime ?>
Ти благодариме за успешната регистрација за echo $opis ?>.
//echo md5(uniqid($_SESSION["email"], true)) ?>
}
?>
if(isset($_GET['koncheok'])) {
$ime=$_POST["ime"];
$prezime=$_POST["prezime"];
$birth=$_POST["rodenden"];
$pol=$_POST["pol"];
$tel=$_POST["telefon"];
$email=$_POST["email"];
$size=$_POST["size"];
//$pdv = $_POST['skm'];
$kategorija=$_POST["kategorija"];
$coverpic='cover-mantovo.jpg';
?>
require_once('phpmailer/class.phpmailer.php');
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
// Create connection
$connA = mysqli_connect($servername, $username, $password, $dbname);
mysqli_set_charset($connA,"utf8");
$result = mysqli_query($connA, "SELECT * FROM events where id=41");
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
/*if ($_SESSION["pol"] == 'female') {
$cena=200;
} else {
$cena=$row['cena'];
}*/
$cena=$row['cena'];
/*if ($pdv>1500) {
$cena = 299;
} */
$cenareal=$cena;
$cena=$cena."00";
$opis = $row['ime'];
$desc = "Авантурите на Конче и Мантово 2023";
$godina=$row['godina'];
$datum=date("Y-m-d H:i:s", strtotime('+1 hours'));
$ipadresa=$_SERVER["HTTP_X_FORWARDED_FOR"];
if ($ipadresa == "") {
$ipadresa=$_SERVER["REMOTE_ADDR"];
}
$trka="konche";
//$idunique = md5(uniqid($email, true));
/* Проверка на следен ID
$mysql_result = mysql_query("SHOW TABLE STATUS LIKE 'sportdayohrid'");
$data = mysql_fetch_assoc($mysql_result);
$nextid = $data['Auto_increment']; */
/* Запишување на регистрацијата */
$dupesql = "SELECT * FROM sportdayohrid where trka = '$trka' and godina = $godina and ime = '$ime' and prezime = '$prezime' and email = '$email'";
$duperaw = mysqli_query($conn, $dupesql);
if (mysqli_num_rows($duperaw) == 0) {
$sql = "INSERT INTO sportdayohrid (datum, ipadresa, trka, godina, tip, ime, prezime, rodenden, email, telefon, pol, size, cena) VALUES ('$datum', '$ipadresa', '$trka', $godina, '$kategorija', '$ime', '$prezime', '$birth', '$email', '$tel', '$pol', '$size', $cenareal)";
mysqli_query($conn, $sql);
$nextid=mysqli_insert_id($conn);
$_SESSION["id"] = $nextid;
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$body = file_get_contents('newsletters/registeredfree.htm');
//$body = eregi_replace("[\]",'',$body);
$body = str_replace('[ime]',$ime,$body);
$body = str_replace('[prezime]',$prezime,$body);
$body = str_replace('[nastan]',$opis,$body);
$body = str_replace('[cena]',$cenareal,$body);
$body = str_replace('[id]',$_SESSION["id"],$body);
$body = str_replace('[coverpic]',$coverpic,$body);
$body = str_replace('[eventpage]','konche',$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Регистрација за ". $opis;
$mail->AddAddress($email);
$mail->MsgHTML($body);
$send = $mail->Send();
$mail->ClearAllRecipients();
}
/************/
}
/* $resultlast = mysql_query("SELECT LAST_INSERT_ID()", $conn);
$rowlast = mysql_fetch_array($resultlast);
$nextid=$rowlast['id']; */
/* За плаќањето */
$cena_len=strlen($cena);
$details1= $desc;
$details1_len=strlen($details1);
$details2=$_SESSION["id"];
$details2_len=strlen($details2);
$PaymentOKURL="http://prvdovrv.mk/ok.php?n=".$details2;
$PaymentOKURL_len=strlen($PaymentOKURL);
$PaymentFailURL="http://prvdovrv.mk/fail.php?n=".$details2;
$PaymentFailURL_len=strlen($PaymentFailURL);
$InputsLenght="0".$PaymentOKURL_len."0".$PaymentFailURL_len."00".$cena_len."010"."017"."003"."0".$details1_len."00".$details2_len;
$CheckSum="08PaymentOKURL,PaymentFailURL,AmountToPay,PayToMerchant,MerchantName,AmountCurrency,Details1,Details2,".$InputsLenght.$PaymentOKURL.$PaymentFailURL.$cena."1000000791PRV DO VRV SkopjeMKD".$details1.$details2."HMQkm5uS1aUCrFNF";
/* ****** */
?>
Здраво echo $ime ?>
Ти благодариме за успешната регистрација за echo $opis ?>.
//echo md5(uniqid($_SESSION["email"], true)) ?>
}
?>
if(isset($_GET['velovodnook'])) {
$ime=$_POST["ime"];
$prezime=$_POST["prezime"];
$birth=$_POST["rodenden"];
$pol=$_POST["pol"];
//$tel=$_POST["telefon"];
$email=$_POST["email"];
// $size=$_POST["size"];
//$pdv = $_POST['skm'];
//$kategorija=$_POST["kategorija"];
$coverpic='VV21-web-cover.jpg';
$eventpage='velovodno';
?>
require_once('phpmailer/class.phpmailer.php');
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
// Create connection
$connA = mysqli_connect($servername, $username, $password, $dbname);
mysqli_set_charset($connA,"utf8");
$result = mysqli_query($connA, "SELECT * FROM events where id=34");
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
/*if ($_SESSION["pol"] == 'female') {
$cena=200;
} else {
$cena=$row['cena'];
}*/
$cena=$row['cena'];
$cena=0;
/*if ($pdv>1500) {
$cena = 299;
} */
$cenareal=$cena;
$cena=$cena."00";
$desc = $row['ime'];
$opis = "Вело Водно 2021";
$godina=$row['godina'];
$datum=date("Y-m-d H:i:s", strtotime('+1 hours'));
$ipadresa=$_SERVER["HTTP_X_FORWARDED_FOR"];
if ($ipadresa == "") {
$ipadresa=$_SERVER["REMOTE_ADDR"];
}
$trka="velovodno";
//$idunique = md5(uniqid($email, true));
/* Проверка на следен ID
$mysql_result = mysql_query("SHOW TABLE STATUS LIKE 'sportdayohrid'");
$data = mysql_fetch_assoc($mysql_result);
$nextid = $data['Auto_increment']; */
/* proverka na posleden bib */
$maxsql = "SELECT MAX(bib) maxbib FROM sportdayohrid where trka = '$trka' and godina = $godina";
$maxresult = mysqli_query($conn, $maxsql);
$maxrow = mysqli_fetch_array($maxresult, MYSQLI_ASSOC);
if ($maxrow["maxbib"] == ''){
$newbib=101;
}else{
$newbib=$maxrow["maxbib"]+1;
}
/* Запишување на регистрацијата */
$dupesql = "SELECT * FROM sportdayohrid where trka = '$trka' and godina = $godina and ime = '$ime' and prezime = '$prezime' and email = '$email'";
$duperaw = mysqli_query($conn, $dupesql);
if (mysqli_num_rows($duperaw) == 0) {
$sql = "INSERT INTO sportdayohrid (datum, ipadresa, trka, godina, ime, prezime, rodenden, email, pol, access_token, refresh_token, strava_status, expires_at, bib) VALUES ('$datum', '$ipadresa', '$trka', $godina, '$ime', '$prezime', '$birth', '$email', '$pol', 0, 0, 0, 0, $newbib)";
mysqli_query($conn, $sql);
$nextid=mysqli_insert_id($conn);
$_SESSION["id"] = $nextid;
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$body = file_get_contents('newsletters/registeredfree.htm');
//$body = eregi_replace("[\]",'',$body);
$body = str_replace('[ime]',$ime,$body);
$body = str_replace('[prezime]',$prezime,$body);
$body = str_replace('[nastan]',$opis,$body);
$body = str_replace('[eventpage]',$eventpage,$body);
$body = str_replace('[bib]',$newbib,$body);
$body = str_replace('[cena]',$cenareal,$body);
$body = str_replace('[id]',$_SESSION["id"],$body);
$body = str_replace('[coverpic]',$coverpic,$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Регистрација за ". $opis;
$mail->AddAddress($email);
$mail->MsgHTML($body);
$send = $mail->Send();
$mail->ClearAllRecipients();
}
/************/
}
/* $resultlast = mysql_query("SELECT LAST_INSERT_ID()", $conn);
$rowlast = mysql_fetch_array($resultlast);
$nextid=$rowlast['id']; */
/* За плаќањето */
$cena_len=strlen($cena);
$details1= $desc;
$details1_len=strlen($details1);
$details2=$_SESSION["id"];
$details2_len=strlen($details2);
$PaymentOKURL="http://prvdovrv.mk/ok.php?n=".$details2;
$PaymentOKURL_len=strlen($PaymentOKURL);
$PaymentFailURL="http://prvdovrv.mk/fail.php?n=".$details2;
$PaymentFailURL_len=strlen($PaymentFailURL);
$InputsLenght="0".$PaymentOKURL_len."0".$PaymentFailURL_len."00".$cena_len."010"."017"."003"."0".$details1_len."00".$details2_len;
$CheckSum="08PaymentOKURL,PaymentFailURL,AmountToPay,PayToMerchant,MerchantName,AmountCurrency,Details1,Details2,".$InputsLenght.$PaymentOKURL.$PaymentFailURL.$cena."1000000791PRV DO VRV SkopjeMKD".$details1.$details2."HMQkm5uS1aUCrFNF";
/* ****** */
?>
Здраво echo $ime ?>
Ти благодариме за успешната регистрација за echo $opis ?>.
//echo md5(uniqid($_SESSION["email"], true)) ?>
}
?>
if(isset($_GET['savavvok'])) {
require_once('phpmailer/class.phpmailer.php');
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
// Create connection
$connA = mysqli_connect($servername, $username, $password, $dbname);
mysqli_set_charset($connA,"utf8");
$result = mysqli_query($connA, "SELECT * FROM events where id=30");
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
/*if ($_SESSION["pol"] == 'female') {
$cena=200;
} else {
$cena=$row['cena'];
}*/
$cena1=$row['cena'];
$cena2=$row['cena2'];
/*if ($_SESSION["skm"]>0) {
$cena = 500;
} */
/* samo za 8 mart 2019
if ($_SESSION["pol"] == 'female') {
$cena=350;
}
*/
$opis = "Sava Virtual Velo 2021";
$desc = $row['ime'];
$godina=$row['godina'];
$datum=date("Y-m-d H:i:s", strtotime('+0 hours'));
$ipadresa=$_SERVER["HTTP_X_FORWARDED_FOR"];
if ($ipadresa == "") {
$ipadresa=$_SERVER["REMOTE_ADDR"];
}
$trka="savavirtualvelo";
$ime=$_POST['ime'];
$prezime=$_POST['prezime'];
$birth=$_POST['rodenden'];
$pol=$_POST['pol'];
$tip = $_POST['kategorija'];
$size = $_POST['size'];
$tim = $_POST['tim'];
$skm = $_POST['skm'];
$lozinka = $_POST['lozinka'];
$kit = $_POST['kit'];
$competition = $_POST['competition'];
if($tip=='mrun'){
$coverpic='run.jpg';
}else if ($tip=='mbike') {
$coverpic='mtb.jpg';
}else if ($tip=='rbike'){
$coverpic='road.jpg';
}
$email = $_POST['email'];
$tel = $_POST['telefon'];
$country = $_POST['country'];
$city = $_POST['city'];
if ($skm==""){
$skm=0;
}
if ($tip === "SummitRun"){
$kit="plus";
$competition = "hobby";
}
// za 8 mart 2020
/*
if ($pol == 'female') {
$cena1 = $cena1*0.85;
$cena2 = $cena2*0.85;
}
*/
if ($kit === "basic") {
$cena = $cena1;
} elseif ($kit === "plus"){
$cena = $cena2;
} else {
$cena = 0;
}
$cenareal=$cena;
$cena=$cena."00";
//$idunique = md5(uniqid($email, true));
/* Проверка на следен ID
$mysql_result = mysql_query("SHOW TABLE STATUS LIKE 'sportdayohrid'");
$data = mysql_fetch_assoc($mysql_result);
$nextid = $data['Auto_increment']; */
/* Запишување на регистрацијата */
$dupesql = "SELECT * FROM sportdayohrid where trka = '$trka' and godina = $godina and ime = '$ime' and prezime = '$prezime' and email = '$email'";
$duperaw = mysqli_query($conn, $dupesql);
if (mysqli_num_rows($duperaw) == 0) {
$sql = "INSERT INTO sportdayohrid (datum, ipadresa, trka, godina, tip, competition, ime, prezime, rodenden, email, telefon, city, country, pol, kit, size, tim, skmbib, uplata, uplata_nacin, access_token, refresh_token, strava_status, expires_at) VALUES ('$datum', '$ipadresa', '$trka', $godina, '$tip', '$competition', '$ime', '$prezime', '$birth', '$email', '$tel', '$city', '$country','$pol', '$kit', '$size', '$tim', $skm, 0, 0, 0, 0, 0, 0)";
mysqli_query($conn, $sql);
$nextid=mysqli_insert_id($conn);
$_SESSION["id"] = $nextid;
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
//$body = file_get_contents('newsletters/registerednotpaid.htm');
$body = file_get_contents('newsletters/registerednopayment.htm');
$body = str_replace('[ime]',$ime,$body);
$body = str_replace('[prezime]',$prezime,$body);
$body = str_replace('[nastan]',$opis,$body);
$body = str_replace('[cena]',$cenareal,$body);
$body = str_replace('[id]',$_SESSION["id"],$body);
$body = str_replace('[coverpic]',$coverpic,$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Регистрација за ". $desc;
$mail->AddAddress($email);
$mail->MsgHTML($body);
$send = $mail->Send();
$mail->ClearAllRecipients();
}
/************/
}
/* $resultlast = mysql_query("SELECT LAST_INSERT_ID()", $conn);
$rowlast = mysql_fetch_array($resultlast);
$nextid=$rowlast['id']; */
/* За плаќањето */
$cena_len=strlen($cena);
$details1= $desc;
$details1_len=strlen($details1);
$details2=$_SESSION["id"];
$details2_len=strlen($details2);
$PaymentOKURL="https://prvdovrv.mk/ok.php?n=".$details2;
$PaymentOKURL_len=strlen($PaymentOKURL);
$PaymentFailURL="https://prvdovrv.mk/fail.php?n=".$details2;
$PaymentFailURL_len=strlen($PaymentFailURL);
$InputsLenght="0".$PaymentOKURL_len."0".$PaymentFailURL_len."00".$cena_len."010"."017"."003"."0".$details1_len."00".$details2_len;
$CheckSum="08PaymentOKURL,PaymentFailURL,AmountToPay,PayToMerchant,MerchantName,AmountCurrency,Details1,Details2,".$InputsLenght.$PaymentOKURL.$PaymentFailURL.$cena."1000000791PRV DO VRV SkopjeMKD".$details1.$details2."HMQkm5uS1aUCrFNF";
/* ****** */
?>
Здраво echo $ime ?>
if($cenareal <> 0) { ?>
Ги имаме твоите податоци за учество на echo $opis ?>.
За успешно комплетирање на регистрацијата потребно е да се плати котизацијата од echo $cena/100 ?> денари .
Цената важи до 4.5.2020 год.
Thank you for the registration for echo $details1 ?>.
For the successful completion of the registration you need to pay the fee of echo $cena/100 ?> denars .
The price is valid until 4.5.2020.
//echo md5(uniqid($_SESSION["email"], true)) ?>
} else { ?>
} ?>
}
?>
if(isset($_GET['mobilityok'])) {
require_once('phpmailer/class.phpmailer.php');
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
// Create connection
$connA = mysqli_connect($servername, $username, $password, $dbname);
mysqli_set_charset($connA,"utf8");
$result = mysqli_query($connA, "SELECT * FROM events where id=33");
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
/*if ($_SESSION["pol"] == 'female') {
$cena=200;
} else {
$cena=$row['cena'];
}*/
$cena1=$row['cena'];
$cena2=$row['cena2'];
/*if ($_SESSION["skm"]>0) {
$cena = 500;
} */
/* samo za 8 mart 2019
if ($_SESSION["pol"] == 'female') {
$cena=350;
}
*/
$opis = "Mobility Virtual Challenge 2021";
$desc = $row['ime'];
$godina=$row['godina'];
$datum=date("Y-m-d H:i:s", strtotime('+0 hours'));
$ipadresa=$_SERVER["HTTP_X_FORWARDED_FOR"];
if ($ipadresa == "") {
$ipadresa=$_SERVER["REMOTE_ADDR"];
}
$trka="mobility";
$ime=$_POST['ime'];
$prezime=$_POST['prezime'];
$birth=$_POST['rodenden'];
$pol=$_POST['pol'];
$tip = $_POST['kategorija'];
$size = $_POST['size'];
$tim = $_POST['tim'];
$skm = $_POST['skm'];
$lozinka = $_POST['lozinka'];
$kit = $_POST['kit'];
$competition = $_POST['competition'];
if($tip=='mrun'){
$coverpic='run.jpg';
}else if ($tip=='mbike') {
$coverpic='mtb.jpg';
}else if ($tip=='rbike'){
$coverpic='road.jpg';
}
$email = $_POST['email'];
$tel = $_POST['telefon'];
$country = $_POST['country'];
$city = $_POST['city'];
if ($skm==""){
$skm=0;
}
if ($tip === "SummitRun"){
$kit="plus";
$competition = "hobby";
}
// za 8 mart 2020
/*
if ($pol == 'female') {
$cena1 = $cena1*0.85;
$cena2 = $cena2*0.85;
}
*/
if ($kit === "basic") {
$cena = $cena1;
} elseif ($kit === "plus"){
$cena = $cena2;
} else {
$cena = 0;
}
$cenareal=$cena;
$cena=$cena."00";
//$idunique = md5(uniqid($email, true));
/* Проверка на следен ID
$mysql_result = mysql_query("SHOW TABLE STATUS LIKE 'sportdayohrid'");
$data = mysql_fetch_assoc($mysql_result);
$nextid = $data['Auto_increment']; */
/* Запишување на регистрацијата */
$dupesql = "SELECT * FROM sportdayohrid where trka = '$trka' and godina = $godina and ime = '$ime' and prezime = '$prezime' and email = '$email'";
$duperaw = mysqli_query($conn, $dupesql);
if (mysqli_num_rows($duperaw) == 0) {
$sql = "INSERT INTO sportdayohrid (datum, ipadresa, trka, godina, tip, competition, ime, prezime, rodenden, email, telefon, city, country, pol, kit, size, tim, skmbib, uplata, uplata_nacin, access_token, refresh_token, strava_status, expires_at) VALUES ('$datum', '$ipadresa', '$trka', $godina, '$tip', '$competition', '$ime', '$prezime', '$birth', '$email', '$tel', '$city', '$country','$pol', '$kit', '$size', '$tim', $skm, 0, 0, 0, 0, 0, 0)";
mysqli_query($conn, $sql);
$nextid=mysqli_insert_id($conn);
$_SESSION["id"] = $nextid;
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
//$body = file_get_contents('newsletters/registerednotpaid.htm');
$body = file_get_contents('newsletters/registerednopayment.htm');
$body = str_replace('[ime]',$ime,$body);
$body = str_replace('[prezime]',$prezime,$body);
$body = str_replace('[nastan]',$opis,$body);
$body = str_replace('[cena]',$cenareal,$body);
$body = str_replace('[id]',$_SESSION["id"],$body);
$body = str_replace('[coverpic]',$coverpic,$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Регистрација за ". $desc;
$mail->AddAddress($email);
$mail->MsgHTML($body);
$send = $mail->Send();
$mail->ClearAllRecipients();
}
/************/
}
/* $resultlast = mysql_query("SELECT LAST_INSERT_ID()", $conn);
$rowlast = mysql_fetch_array($resultlast);
$nextid=$rowlast['id']; */
/* За плаќањето */
$cena_len=strlen($cena);
$details1= $desc;
$details1_len=strlen($details1);
$details2=$_SESSION["id"];
$details2_len=strlen($details2);
$PaymentOKURL="https://prvdovrv.mk/ok.php?n=".$details2;
$PaymentOKURL_len=strlen($PaymentOKURL);
$PaymentFailURL="https://prvdovrv.mk/fail.php?n=".$details2;
$PaymentFailURL_len=strlen($PaymentFailURL);
$InputsLenght="0".$PaymentOKURL_len."0".$PaymentFailURL_len."00".$cena_len."010"."017"."003"."0".$details1_len."00".$details2_len;
$CheckSum="08PaymentOKURL,PaymentFailURL,AmountToPay,PayToMerchant,MerchantName,AmountCurrency,Details1,Details2,".$InputsLenght.$PaymentOKURL.$PaymentFailURL.$cena."1000000791PRV DO VRV SkopjeMKD".$details1.$details2."HMQkm5uS1aUCrFNF";
/* ****** */
?>
Здраво echo $ime ?>
if($cenareal <> 0) { ?>
Ги имаме твоите податоци за учество на echo $opis ?>.
За успешно комплетирање на регистрацијата потребно е да се плати котизацијата од echo $cena/100 ?> денари .
Цената важи до 4.5.2020 год.
Thank you for the registration for echo $details1 ?>.
For the successful completion of the registration you need to pay the fee of echo $cena/100 ?> denars .
The price is valid until 4.5.2020.
//echo md5(uniqid($_SESSION["email"], true)) ?>
} else { ?>
} ?>
}
?>
if(isset($_GET['xbistraadventureok'])) {
$ime=$_POST["ime"];
$prezime=$_POST["prezime"];
$birth=$_POST["rodenden"];
$pol=$_POST["pol"];
$tel=$_POST["telefon"];
$email=$_POST["email"];
$size=$_POST["size"];
//$pdv = $_POST['skm'];
$kategorija=$_POST["kategorija"];
$coverpic='bistraadventure18-cover-email.jpg';
?>
require_once('phpmailer/class.phpmailer.php');
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
// Create connection
$connA = mysqli_connect($servername, $username, $password, $dbname);
mysqli_set_charset($connA,"utf8");
$result = mysqli_query($connA, "SELECT * FROM events where id=22");
$row = mysqli_fetch_array($result,MYSQLI_ASSOC);
/*if ($_SESSION["pol"] == 'female') {
$cena=200;
} else {
$cena=$row['cena'];
}*/
$cena=$row['cena'];
/*if ($pdv>1500) {
$cena = 299;
} */
$cenareal=$cena;
$cena=$cena."00";
$opis = $row['ime'];
$desc = "Bistra Adventure 2019";
$godina=$row['godina'];
$datum=date("Y-m-d H:i:s", strtotime('+1 hours'));
$ipadresa=$_SERVER["HTTP_X_FORWARDED_FOR"];
if ($ipadresa == "") {
$ipadresa=$_SERVER["REMOTE_ADDR"];
}
$trka="bistratour";
//$idunique = md5(uniqid($email, true));
/* Проверка на следен ID
$mysql_result = mysql_query("SHOW TABLE STATUS LIKE 'sportdayohrid'");
$data = mysql_fetch_assoc($mysql_result);
$nextid = $data['Auto_increment']; */
/* Запишување на регистрацијата */
$dupesql = "SELECT * FROM sportdayohrid where trka = '$trka' and godina = $godina and ime = '$ime' and prezime = '$prezime' and email = '$email'";
$duperaw = mysqli_query($conn, $dupesql);
if (mysqli_num_rows($duperaw) == 0) {
$sql = "INSERT INTO sportdayohrid (datum, ipadresa, trka, godina, tip, ime, prezime, rodenden, email, telefon, pol, size, cena) VALUES ('$datum', '$ipadresa', '$trka', $godina, '$kategorija', '$ime', '$prezime', '$birth', '$email', '$tel', '$pol', '$size', $cenareal)";
mysqli_query($conn, $sql);
$nextid=mysqli_insert_id($conn);
$_SESSION["id"] = $nextid;
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$body = file_get_contents('newsletters/registerednotpaid.htm');
//$body = eregi_replace("[\]",'',$body);
$body = str_replace('[ime]',$ime,$body);
$body = str_replace('[prezime]',$prezime,$body);
$body = str_replace('[nastan]',$opis,$body);
$body = str_replace('[cena]',$cenareal,$body);
$body = str_replace('[id]',$_SESSION["id"],$body);
$body = str_replace('[coverpic]',$coverpic,$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Регистрација за ". $opis;
$mail->AddAddress($email);
$mail->MsgHTML($body);
$send = $mail->Send();
$mail->ClearAllRecipients();
}
/************/
}
/* $resultlast = mysql_query("SELECT LAST_INSERT_ID()", $conn);
$rowlast = mysql_fetch_array($resultlast);
$nextid=$rowlast['id']; */
/* За плаќањето */
$cena_len=strlen($cena);
$details1= $desc;
$details1_len=strlen($details1);
$details2=$_SESSION["id"];
$details2_len=strlen($details2);
$PaymentOKURL="http://prvdovrv.mk/ok.php?n=".$details2;
$PaymentOKURL_len=strlen($PaymentOKURL);
$PaymentFailURL="http://prvdovrv.mk/fail.php?n=".$details2;
$PaymentFailURL_len=strlen($PaymentFailURL);
$InputsLenght="0".$PaymentOKURL_len."0".$PaymentFailURL_len."00".$cena_len."010"."017"."003"."0".$details1_len."00".$details2_len;
$CheckSum="08PaymentOKURL,PaymentFailURL,AmountToPay,PayToMerchant,MerchantName,AmountCurrency,Details1,Details2,".$InputsLenght.$PaymentOKURL.$PaymentFailURL.$cena."1000000791PRV DO VRV SkopjeMKD".$details1.$details2."HMQkm5uS1aUCrFNF";
/* ****** */
?>
Здраво echo $ime ?>
Ги имаме твоите податоци за учество на echo $opis ?>.
За успешно комплетирање на регистрацијата и сигурно место во предвидениот број учесници во турата, потребно е да се плати котизацијата од echo $cena/100 ?> денари .
//echo md5(uniqid($_SESSION["email"], true)) ?>
}
?>
if(isset($_GET['slavejok'])) {
$ime=$_POST["ime"];
$prezime=$_POST["prezime"];
$birth=$_POST["rodenden"];
$pol=$_POST["pol"];
$tel=$_POST["telefon"];
$email=$_POST["email"];
$size=$_POST["size"];
//$pdv = $_POST['skm'];
$kategorija=$_POST["kategorija"];
$coverpic='slavej_cover.jpg';
?>
require_once('phpmailer/class.phpmailer.php');
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
// Create connection
$connA = mysqli_connect($servername, $username, $password, $dbname);
mysqli_set_charset($connA,"utf8");
$result = mysqli_query($connA, "SELECT * FROM events where id=23");
$row = mysqli_fetch_array($result,MYSQLI_ASSOC);
/*if ($_SESSION["pol"] == 'female') {
$cena=200;
} else {
$cena=$row['cena'];
}*/
$cena=$row['cena'];
/*if ($pdv>1500) {
$cena = 299;
} */
$cenareal=$cena;
$cena=$cena."00";
$opis = $row['ime'];
$desc = "Slavej+Karaorman MTB 2019";
$godina=$row['godina'];
$datum=date("Y-m-d H:i:s", strtotime('+1 hours'));
$ipadresa=$_SERVER["HTTP_X_FORWARDED_FOR"];
if ($ipadresa == "") {
$ipadresa=$_SERVER["REMOTE_ADDR"];
}
$trka="slavej";
//$idunique = md5(uniqid($email, true));
/* Проверка на следен ID
$mysql_result = mysql_query("SHOW TABLE STATUS LIKE 'sportdayohrid'");
$data = mysql_fetch_assoc($mysql_result);
$nextid = $data['Auto_increment']; */
/* Запишување на регистрацијата */
$dupesql = "SELECT * FROM sportdayohrid where trka = '$trka' and godina = $godina and ime = '$ime' and prezime = '$prezime' and email = '$email'";
$duperaw = mysqli_query($conn, $dupesql);
if (mysqli_num_rows($duperaw) == 0) {
$sql = "INSERT INTO sportdayohrid (datum, ipadresa, trka, godina, tip, ime, prezime, rodenden, email, telefon, pol, size, cena) VALUES ('$datum', '$ipadresa', '$trka', $godina, '$kategorija', '$ime', '$prezime', '$birth', '$email', '$tel', '$pol', '$size', $cenareal)";
mysqli_query($conn, $sql);
$nextid=mysqli_insert_id($conn);
$_SESSION["id"] = $nextid;
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$body = file_get_contents('newsletters/registerednotpaid.htm');
//$body = eregi_replace("[\]",'',$body);
$body = str_replace('[ime]',$ime,$body);
$body = str_replace('[prezime]',$prezime,$body);
$body = str_replace('[nastan]',$opis,$body);
$body = str_replace('[cena]',$cenareal,$body);
$body = str_replace('[id]',$_SESSION["id"],$body);
$body = str_replace('[coverpic]',$coverpic,$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Регистрација за ". $opis;
$mail->AddAddress($email);
$mail->MsgHTML($body);
$send = $mail->Send();
$mail->ClearAllRecipients();
}
/************/
}
/* $resultlast = mysql_query("SELECT LAST_INSERT_ID()", $conn);
$rowlast = mysql_fetch_array($resultlast);
$nextid=$rowlast['id']; */
/* За плаќањето */
$cena_len=strlen($cena);
$details1= $desc;
$details1_len=strlen($details1);
$details2=$_SESSION["id"];
$details2_len=strlen($details2);
$PaymentOKURL="http://prvdovrv.mk/ok.php?n=".$details2;
$PaymentOKURL_len=strlen($PaymentOKURL);
$PaymentFailURL="http://prvdovrv.mk/fail.php?n=".$details2;
$PaymentFailURL_len=strlen($PaymentFailURL);
$InputsLenght="0".$PaymentOKURL_len."0".$PaymentFailURL_len."00".$cena_len."010"."017"."003"."0".$details1_len."00".$details2_len;
$CheckSum="08PaymentOKURL,PaymentFailURL,AmountToPay,PayToMerchant,MerchantName,AmountCurrency,Details1,Details2,".$InputsLenght.$PaymentOKURL.$PaymentFailURL.$cena."1000000791PRV DO VRV SkopjeMKD".$details1.$details2."HMQkm5uS1aUCrFNF";
/* ****** */
?>
Здраво echo $ime ?>
Ги имаме твоите податоци за учество на echo $opis ?>.
За успешно комплетирање на регистрацијата и сигурно место во предвидениот број учесници во турата, потребно е да се плати котизацијата од echo $cena/100 ?> денари .
//echo md5(uniqid($_SESSION["email"], true)) ?>
}
?>
if(isset($_GET['hellobr'])) {
$_SESSION["kategorija"] = $_POST['kategorija'];
$_SESSION["size"] = $_POST['size'];
$_SESSION["tim"] = $_POST['tim'];
$_SESSION["skm"] = $_POST['skm'];
$_SESSION["lozinka"] = $_POST['lozinka'];
$coverpic='beachrunoh16.jpg';
?>
date_default_timezone_set('Etc/UTC');
require 'phpmailer/PHPMailerAutoload.php'; //require_once('phpmailer/class.phpmailer.php');
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
// Create connection
// $connA = mysql_connect($servername, $username, $password, true); //old deprecated
$connA = mysqli_connect($servername, $username, $password, $dbname);
mysqli_set_charset($connA,"utf8");
// Check connection
if (!$connA) {
die("Connection failed: " . mysql_error());
}
// $db_selected = mysql_select_db($dbname, $connA); //old deprecated
/* $result = mysql_query("SELECT * FROM events where id=19", $connA);
$row = mysql_fetch_array($result); */ //old deprecated
$result = mysqli_query($connA, "SELECT * FROM events where id=19");
$row = mysqli_fetch_array($result,MYSQLI_ASSOC);
/*if ($_SESSION["pol"] == 'female') {
$cena=200;
} else {
$cena=$row['cena'];
}*/
$cena=$row['cena'];
//$cena=1199;
if ($_SESSION["kategorija"] == 'all') {
$cena=1500;
if ($_POST["skm"] > 1200 & $_POST["skm"] < 3601) {
$cena=1350;
}
}
if ($_SESSION["kategorija"] <> 'all') {
$cena=600;
if ($_SESSION["size"] == "") {
$cena=300;
}
}
if ($_SESSION["kategorija"] == 'Mavrovo') {
$cena=700;
if ($_SESSION["size"] == "") {
$cena=500;
}
}
$cenareal=$cena;
$cena=$cena."00";
$opis = $row['ime'];
$desc = "BEACH RUN 2019";
$godina=$row['godina'];
$datum=date("Y-m-d H:i:s", strtotime('+1 hours'));
$ipadresa=$_SERVER["HTTP_X_FORWARDED_FOR"];
if ($ipadresa == "") {
$ipadresa=$_SERVER["REMOTE_ADDR"];
}
$trka="beachrun";
$ime=$_SESSION["ime"];
$prezime=$_SESSION["prezime"];
$birth=$_SESSION["rodenden"];
$pol=$_SESSION["pol"];
$size=$_SESSION["size"];
$tel=$_SESSION["telefon"];
$email=$_SESSION["email"];
$tip=$_SESSION["kategorija"];
$tim=$_SESSION["tim"];
$skm=$_SESSION["skm"];
if ($skm==""){
$skm=0;
}
//$idunique = md5(uniqid($email, true));
/* Проверка на следен ID
$mysql_result = mysql_query("SHOW TABLE STATUS LIKE 'sportdayohrid'");
$data = mysql_fetch_assoc($mysql_result);
$nextid = $data['Auto_increment']; */
/* Запишување на регистрацијата */
$dupesql = "SELECT * FROM sportdayohrid where trka = '$trka' and godina = $godina and ime = '$ime' and prezime = '$prezime' and email = '$email' and tip = '$tip'";
$duperaw = mysqli_query($conn, $dupesql);
if (mysqli_num_rows($duperaw) == 0) {
$sql = "INSERT INTO sportdayohrid (datum, ipadresa, trka, godina, tip, ime, prezime, rodenden, email, telefon, pol, size, tim, cena, skmbib, bib) VALUES ('$datum', '$ipadresa', '$trka', $godina, '$tip', '$ime', '$prezime', '$birth', '$email', '$tel', '$pol', '$size', '$tim', $cenareal, $skm, 0)";
// $sql = "INSERT INTO sportdayohrid (trka, godina, tip, ime, prezime, rodenden, email, telefon, pol, size, tim, cena, skmbib) VALUES ('trka', 2019, 'tip', 'aleksandar', 'georgievski', '1974', 'alek@prvdovrv.mk', '072620000', 'male', 'L', 'tim', 1500, 1234)";
mysqli_query($conn, $sql);
$nextid = mysqli_insert_id($conn);
$_SESSION["id"] = $nextid;
// $_SESSION["id"] = 1234;
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$mail->isSMTP();
$mail->SMTPDebug = 0;
$mail->Debugoutput = 'html';
$mail->Host = "odin.mk-host.com";
$mail->Port = 465;
$mail->SMTPAuth = true;
$mail->Username = "upgradem@odin.mk-host.com";
$mail->Password = "N043Ze0fzn";
$mail->SMTPSecure = 'ssl';
/* ------------------
/* ------------------ */
$body = file_get_contents('newsletters/registerednotpaid.htm');
//$body = preg_replace("[\]",'',$body);
$body = str_replace('[ime]',$ime,$body);
$body = str_replace('[prezime]',$prezime,$body);
$body = str_replace('[nastan]',$opis,$body);
$body = str_replace('[cena]',$cenareal,$body);
$body = str_replace('[id]',$_SESSION["id"],$body);
$body = str_replace('[coverpic]',$coverpic,$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Регистрација за ". $opis;
$mail->AddAddress($email);
$mail->MsgHTML($body);
$send = $mail->Send();
$mail->ClearAllRecipients();
}
/************/
}
/* $resultlast = mysql_query("SELECT LAST_INSERT_ID()", $conn);
$rowlast = mysql_fetch_array($resultlast);
$nextid=$rowlast['id']; */
/* За плаќањето */
$cena_len=strlen($cena);
$details1= $desc;
$details1_len=strlen($details1);
$details2=$_SESSION["id"];
$details2_len=strlen($details2);
$PaymentOKURL="http://prvdovrv.mk/ok.php?n=".$details2;
$PaymentOKURL_len=strlen($PaymentOKURL);
$PaymentFailURL="http://prvdovrv.mk/fail.php?n=".$details2;
$PaymentFailURL_len=strlen($PaymentFailURL);
$InputsLenght="0".$PaymentOKURL_len."0".$PaymentFailURL_len."00".$cena_len."010"."017"."003"."0".$details1_len."00".$details2_len;
$CheckSum="08PaymentOKURL,PaymentFailURL,AmountToPay,PayToMerchant,MerchantName,AmountCurrency,Details1,Details2,".$InputsLenght.$PaymentOKURL.$PaymentFailURL.$cena."1000000791PRV DO VRV SkopjeMKD".$details1.$details2."HMQkm5uS1aUCrFNF";
/* ****** */
?>
Здраво echo $_SESSION["ime"] ?>
Ги имаме твоите податоци за учество на echo $opis ?>.
За успешно комплетирање на регистрацијата потребно е да се плати котизацијата од echo $cena/100 ?> денари .
//echo md5(uniqid($_SESSION["email"], true)) ?>
}
?>
if(isset($_GET['sendgift'])) {
$sender = $_POST['sender'];
$email = $_POST['email'];
$receiver = $_POST['receiver'];
$remail = $_POST['remail'];
$note = $_POST['message'];
?>
require_once('phpmailer/class.phpmailer.php');
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
// Create connection
$connA = mysql_connect($servername, $username, $password, true);
// Check connection
if (!$connA) {
die("Connection failed: " . mysql_error());
}
$db_selected = mysql_select_db($dbname, $connA);
$result = mysql_query("SELECT * FROM events where id=1", $connA);
$row = mysql_fetch_array($result);
$cenareal=200;
$cena=20000;
$opis = $row['ime'];
$desc = "PRV DO VRV 2017";
$godina=$row['godina'];
$datum=date("Y-m-d H:i:s", strtotime('+1 hours'));
$ipadresa=$_SERVER["HTTP_X_FORWARDED_FOR"];
if ($ipadresa == "") {
$ipadresa=$_SERVER["REMOTE_ADDR"];
}
$trka="PDV";
//$note="8 март";
$serial = base_convert(rand(1000000000,PHP_INT_MAX), 6, 36);
$year = date(Y);
$tip = 'gift';
/* Запишување на регистрацијата */
/* $dupesql = "SELECT * FROM sportdayohrid where trka = '$trka' and godina = $godina and ime = '$ime' and prezime = '$prezime' and email = '$email'";
$duperaw = mysql_query($dupesql, $conn);
if (mysql_num_rows($duperaw) == 0) { */
$sql = "INSERT INTO gifts (sender, semail, receiver, remail, datum, ipadresa, kotizacija, kod, note, trka, godina) VALUES ('$sender', '$semail', '$receiver', '$remail', '$datum', '$ipadresa', $cenareal, '$serial', '$note', '$trka', $godina)";
mysql_query($sql, $conn);
$nextid=mysql_insert_id($conn);
//$_SESSION["id"] = $nextid;
$sql = "INSERT INTO vouchers (id, year, tip) VALUES ('$serial', $year, '$tip')";
mysql_query($sql, $conn);
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$body = file_get_contents('newsletters/8mart.htm');
$body = eregi_replace("[\]",'',$body);
$body = str_replace('[SENDER]',$sender,$body);
$body = str_replace('[RECEIVER]',$receiver,$body);
$body = str_replace('[nastan]',$opis,$body);
//$body = str_replace('[cena]',$cenareal,$body);
//$body = str_replace('[id]',$nextid,$body);
//$body = str_replace('[coverpic]',$coverpic,$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Подарок за 8 март";
$mail->AddAddress($email);
$mail->MsgHTML($body);
$send = $mail->Send();
$mail->ClearAllRecipients();
}
/************/
// }
/* $resultlast = mysql_query("SELECT LAST_INSERT_ID()", $conn);
$rowlast = mysql_fetch_array($resultlast);
$nextid=$rowlast['id']; */
/* За плаќањето */
$cena_len=strlen($cena);
$details1= $desc;
$details1_len=strlen($details1);
$details2=$_SESSION["id"];
$details2_len=strlen($details2);
$PaymentOKURL="http://prvdovrv.mk/ok.php?n=".$details2."&p=".$cenareal."&t=gift";
$PaymentOKURL_len=strlen($PaymentOKURL);
$PaymentFailURL="http://prvdovrv.mk/fail.php?n=".$details2."&p=".$cenareal."&t=gift";
$PaymentFailURL_len=strlen($PaymentFailURL);
$InputsLenght="0".$PaymentOKURL_len."0".$PaymentFailURL_len."00".$cena_len."010"."017"."003"."0".$details1_len."00".$details2_len;
$CheckSum="08PaymentOKURL,PaymentFailURL,AmountToPay,PayToMerchant,MerchantName,AmountCurrency,Details1,Details2,".$InputsLenght.$PaymentOKURL.$PaymentFailURL.$cena."1000000791PRV DO VRV SkopjeMKD".$details1.$details2."HMQkm5uS1aUCrFNF";
/* ****** */
?>
echo $firma ?>
Ти благодариме за нарачката на подарок ваучер за учество на echo $opis ?>.
За успешно комплетирање на нарачката потребно е да се изврши плаќање од echo $cenareal ?> денари .
По плаќањето електронскиот ваучер ќе биде испратен нa email адресата на примачот.
//echo md5(uniqid($_SESSION["email"], true)) ?>
}
?>
if(isset($_GET['invoice_ex'])) {
$firma = $_POST['firma'];
$adresa = $_POST['adresa'];
$lice = $_POST['lice'];
$email = $_POST['email'];
$telefon = $_POST['telefon'];
$qucesnici = $_POST['q'];
?>
require 'phpmailer/PHPMailerAutoload.php';
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
// Create connection
$connA = mysql_connect($servername, $username, $password, true);
// Check connection
if (!$connA) {
die("Connection failed: " . mysql_error());
}
$db_selected = mysql_select_db($dbname, $connA);
$result = mysql_query("SELECT * FROM events where id=16", $connA);
$row = mysql_fetch_array($result);
$cenareal=$row['cena2'];
$iznos=$cenareal * $qucesnici;
$cena=$iznos."00";
$opis = $row['ime'];
//$desc = "PRV DO VRV 2017";
//$desc = "BEACH RUN 2017";
$desc = "PRV DO VRV Vodno 2019";
$godina=$row['godina'];
$datum=date("Y-m-d H:i:s", strtotime('+1 hours'));
$ipadresa=$_SERVER["HTTP_X_FORWARDED_FOR"];
if ($ipadresa == "") {
$ipadresa=$_SERVER["REMOTE_ADDR"];
}
$trka="PDV";
//$trka="beachrun";
//$note="8 март";
//$product="Ваучер 8 МАРТ за учество на ПРВ ДО ВРВ 2017";
$note="pdv 2019 biz";
$product="Котизација за учество на ПРВ ДО ВРВ Водно 2019";
//$note="beachrun 2017 biz";
//$product="Котизација за учество на BEACH RUN 2017";
/* Запишување на регистрацијата */
/* $dupesql = "SELECT * FROM sportdayohrid where trka = '$trka' and godina = $godina and ime = '$ime' and prezime = '$prezime' and email = '$email'";
$duperaw = mysql_query($dupesql, $conn);
if (mysql_num_rows($duperaw) == 0) { */
$sql = "INSERT INTO firmi (firma, adresa, telefon, email, lice, datum, ipadresa, kotizacija, note, trka, godina, qucesnici) VALUES ('$firma', '$adresa', '$telefon', '$email', '$lice', '$datum', '$ipadresa', $cenareal, '$note', '$trka', $godina, $qucesnici)";
mysql_query($sql, $conn);
$nextid=mysql_insert_id($conn);
//$_SESSION["id"] = $nextid;
/* Фактура */
include("MPDF57/mpdf.php");
$mpdf = new mPDF('utf-8', 'A4', '10', 'Arial', 0, 0, 5, 5, 5, 5);
$mpdf->charset_in = 'utf-8';
$mpdf->SetDisplayMode('fullpage');
$mpdf->list_indent_first_level = 0; // 1 or 0 - whether to indent the first level of a list
$html=file_get_contents('invoices/invoice.htm');
$html = str_replace('[Q]',$qucesnici,$html);
$html = str_replace('[PROIZVOD]',$product,$html);
$html = str_replace('[CENA]',$cenareal,$html);
$html = str_replace('[IZNOS]',$iznos,$html);
$html = str_replace('[VKUPNO]',$iznos,$html);
$html = str_replace('[FIRMA]',$firma,$html);
$html = str_replace('[ADRESA]',$adresa,$html);
$html = str_replace('[DATUM]',date('d.m.Y'),$html);
//$html = str_replace('[VALUTA]',date('d.m.Y', strtotime('+7 days')),$html);
$html = str_replace('[VALUTA]',date('d.m.Y'),$html);
$html = str_replace('[FBR]',"2019W".$nextid,$html);
$mpdf->WriteHTML($html);
$mpdf->Output('invoices/prvdovrv2019W'.$nextid.'.pdf', F);
$attachurl='http://prvdovrv.mk/invoices/prvdovrv2019W'.$nextid.'.pdf';
/* ***** */
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$mail->isSMTP();
$mail->SMTPDebug = 0;
$mail->Debugoutput = 'html';
$mail->Host = "odin.mk-host.com";
$mail->Port = 465;
$mail->SMTPAuth = true;
$mail->Username = "upgradem@odin.mk-host.com";
$mail->Password = "N043Ze0fzn";
$mail->SMTPSecure = 'ssl';
$body = file_get_contents('newsletters/businessorder.htm');
$body = eregi_replace("[\]",'',$body);
$body = str_replace('[FIRMA]',$firma,$body);
$body = str_replace('[IZNOS]',$iznos,$body);
$body = str_replace('[nastan]',$opis,$body);
//$body = str_replace('[cena]',$cenareal,$body);
//$body = str_replace('[id]',$nextid,$body);
//$body = str_replace('[coverpic]',$coverpic,$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Бизнис регистрација за ". $opis;
$mail->AddAddress($email);
//$mailer->AddAddress("info@prvdovrv.mk");
$mail->MsgHTML($body);
$mail->addStringAttachment(file_get_contents($attachurl), 'prvdovrv-vodno-2019.pdf');
$send = $mail->Send();
$mail->ClearAllRecipients();
}
/************/
// }
/* $resultlast = mysql_query("SELECT LAST_INSERT_ID()", $conn);
$rowlast = mysql_fetch_array($resultlast);
$nextid=$rowlast['id']; */
/* За плаќањето */
$cena_len=strlen($cena);
$details1= $desc;
$details1_len=strlen($details1);
$details2=$_SESSION["id"];
$details2_len=strlen($details2);
$PaymentOKURL="https://prvdovrv.mk/ok.php?n=".$details2;
$PaymentOKURL_len=strlen($PaymentOKURL);
$PaymentFailURL="https://prvdovrv.mk/fail.php?n=".$details2;
$PaymentFailURL_len=strlen($PaymentFailURL);
$InputsLenght="0".$PaymentOKURL_len."0".$PaymentFailURL_len."00".$cena_len."010"."017"."003"."0".$details1_len."00".$details2_len;
$CheckSum="08PaymentOKURL,PaymentFailURL,AmountToPay,PayToMerchant,MerchantName,AmountCurrency,Details1,Details2,".$InputsLenght.$PaymentOKURL.$PaymentFailURL.$cena."1000000791PRV DO VRV SkopjeMKD".$details1.$details2."HMQkm5uS1aUCrFNF";
/* ****** */
?>
echo $firma ?>
Ви благодариме за испратеното барање за ваше компаниско учество на echo $opis ?>.
За успешно комплетирање на регистрацијата потребно е да се изврши плаќање од echo $iznos ?> денари .
Плаќањето може да се изврши со картичка на копчето подолу или според фактурата која ви е испратена на email.
//echo md5(uniqid($_SESSION["email"], true)) ?>
}
?>
if(isset($_GET['invoice'])) {
$firma = $_POST['firma'];
$adresa = $_POST['adresa'];
$lice = $_POST['lice'];
$email = $_POST['email'];
$telefon = $_POST['telefon'];
$qucesnici = $_POST['q'];
$coverpic = "v19cover_850_run_2.jpg";
?>
require 'phpmailer/PHPMailerAutoload.php';
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
// Create connection
$connA = mysqli_connect($servername, $username, $password, $dbname);
mysqli_set_charset($connA,"utf8");
$result = mysqli_query($connA, "SELECT * FROM events where id=43");
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
//$cenareal=$row['cena'];
//$cenareal=$row['cena2'];
$cenareal=400;
//$cenareal=500;
//$cenareal=600;
$iznos=$cenareal * $qucesnici;
$cena=$iznos."00";
/*$cenareal=300;
$iznos=$cenareal * $qucesnici;
$cena=$iznos."00";*/
$opis = $row['ime'];
//$desc = "PRV DO VRV 2017";
//$desc = "BEACH RUN 2017";
// $desc = "PRV DO VRV Vodno 2019";
$desc = "PRVDOVRV VODNO 2024";
$opis = "ПРВДОВРВ ВОДНО 2024";
$godina=$row['godina'];
$datum=date("Y-m-d H:i:s", strtotime('+1 hours'));
$ipadresa=$_SERVER["HTTP_X_FORWARDED_FOR"];
if ($ipadresa == "") {
$ipadresa=$_SERVER["REMOTE_ADDR"];
}
$trka="PDV";
//$trka="beachrun";
//$note="8 март";
//$product="Ваучер 8 МАРТ за учество на ПРВ ДО ВРВ 2017";
$note="pdv 2024 biz";
$product="Котизација за учество на ПРВДОВРВ ВОДНО 2024";
//$note="beachrun 2017 biz";
//$product="Котизација за учество на BEACH RUN 2017";
/* Запишување на регистрацијата */
/* $dupesql = "SELECT * FROM sportdayohrid where trka = '$trka' and godina = $godina and ime = '$ime' and prezime = '$prezime' and email = '$email'";
$duperaw = mysql_query($dupesql, $conn);
if (mysql_num_rows($duperaw) == 0) { */
$mysql_result = mysqli_query($conn, "SHOW TABLE STATUS LIKE 'sportdayohrid'");
$data = mysqli_fetch_array($mysql_result, MYSQLI_ASSOC);
$nextid = $data['Auto_increment'];
$sql = "INSERT INTO firmi (firma, adresa, telefon, email, lice, datum, ipadresa, kotizacija, note, trka, godina, qucesnici) VALUES ('$firma', '$adresa', '$telefon', '$email', '$lice', '$datum', '$ipadresa', $cenareal, '$note', '$trka', $godina, $qucesnici)";
mysqli_query($conn, $sql);
//$nextid=mysqli_insert_id($conn);
//$_SESSION["id"] = $nextid;
/* Фактура */
include("MPDF57/mpdf.php");
$mpdf = new mPDF('utf-8', 'A4', '10', 'Arial', 0, 0, 5, 5, 5, 5);
$mpdf->charset_in = 'utf-8';
$mpdf->SetDisplayMode('fullpage');
$mpdf->list_indent_first_level = 0; // 1 or 0 - whether to indent the first level of a list
$html=file_get_contents('invoices/invoice_nlb.htm');
$html = str_replace('[Q]',$qucesnici,$html);
$html = str_replace('[PROIZVOD]',$product,$html);
$html = str_replace('[CENA]',$cenareal,$html);
$html = str_replace('[IZNOS]',$iznos,$html);
$html = str_replace('[VKUPNO]',$iznos,$html);
$html = str_replace('[FIRMA]',$firma,$html);
$html = str_replace('[ADRESA]',$adresa,$html);
$html = str_replace('[DATUM]',date('d.m.Y'),$html);
$html = str_replace('[VALUTA]',date('d.m.Y', strtotime('+1 days')),$html);
//$html = str_replace('[VALUTA]',date('d.m.Y'),$html);
$html = str_replace('[FBR]',"2024W".$nextid,$html);
$mpdf->WriteHTML($html);
$mpdf->Output('invoices/prvdovrv2024W'.$nextid.'.pdf', F);
$attachurl='http://prvdovrv.mk/invoices/prvdovrv2024W'.$nextid.'.pdf';
/* ***** */
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$mail->isSMTP();
$mail->SMTPDebug = 0;
$mail->Debugoutput = 'html';
$mail->Host = "odin.mk-host.com";
$mail->Port = 465;
$mail->SMTPAuth = true;
$mail->Username = "upgradem@odin.mk-host.com";
$mail->Password = "N043Ze0fzn";
$mail->SMTPSecure = 'ssl';
$body = file_get_contents('newsletters/businessorder.htm');
//$body = eregi_replace("[\]",'',$body);
$body = str_replace('[FIRMA]',$firma,$body);
$body = str_replace('[IZNOS]',$iznos,$body);
$body = str_replace('[nastan]',$opis,$body);
//$body = str_replace('[cena]',$cenareal,$body);
//$body = str_replace('[id]',$nextid,$body);
$body = str_replace('[coverpic]',$coverpic,$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Бизнис регистрација за ". $opis;
$mail->AddAddress($email);
$mail->addBcc("alek@prvdovrv.mk");
//$mailer->AddAddress("info@prvdovrv.mk");
$mail->MsgHTML($body);
$mail->addStringAttachment(file_get_contents($attachurl), 'prvdovrv-vodno-2024.pdf');
$send = $mail->Send();
$mail->ClearAllRecipients();
}
/************/
// }
/* $resultlast = mysql_query("SELECT LAST_INSERT_ID()", $conn);
$rowlast = mysql_fetch_array($resultlast);
$nextid=$rowlast['id']; */
/* За плаќањето */
$cena_len=strlen($cena);
$details1= $desc;
$details1_len=strlen($details1);
$details2=$nextid;
$details2_len=strlen($details2);
$PaymentOKURL="https://prvdovrv.mk/ok.php?n=".$details2;
$PaymentOKURL_len=strlen($PaymentOKURL);
$PaymentFailURL="https://prvdovrv.mk/fail.php?n=".$details2;
$PaymentFailURL_len=strlen($PaymentFailURL);
$InputsLenght="0".$PaymentOKURL_len."0".$PaymentFailURL_len."00".$cena_len."010"."017"."003"."0".$details1_len."00".$details2_len;
$CheckSum="08PaymentOKURL,PaymentFailURL,AmountToPay,PayToMerchant,MerchantName,AmountCurrency,Details1,Details2,".$InputsLenght.$PaymentOKURL.$PaymentFailURL.$cena."1000000791PRV DO VRV SkopjeMKD".$details1.$details2."HMQkm5uS1aUCrFNF";
/* ****** */
?>
echo $firma ?>
Ви благодариме за испратеното барање за ваше компаниско учество на echo $opis ?>.
За успешно комплетирање на регистрацијата потребно е да се изврши плаќање од echo $iznos ?> денари .
Плаќањето може да се изврши со картичка на копчето подолу или според фактурата која ви е испратена на email.
//echo md5(uniqid($_SESSION["email"], true)) ?>
}
?>
if(isset($_GET['invoice_dmt'])) {
$firma = $_POST['firma'];
$adresa = $_POST['adresa'];
$lice = $_POST['lice'];
$email = $_POST['email'];
$telefon = $_POST['telefon'];
$qucesnici = $_POST['q'];
$coverpic = "v19cover_850_run_2.jpg";
?>
require 'phpmailer/PHPMailerAutoload.php';
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
// Create connection
$connA = mysqli_connect($servername, $username, $password, $dbname);
mysqli_set_charset($connA,"utf8");
$result = mysqli_query($connA, "SELECT * FROM events where id=44");
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
//$cenareal=$row['cena'];
$cenareal=$row['cena2'];
//$cenareal=600;
$iznos=$cenareal * $qucesnici;
$cena=$iznos."00";
/*$cenareal=300;
$iznos=$cenareal * $qucesnici;
$cena=$iznos."00";*/
$opis = $row['ime'];
//$desc = "PRV DO VRV 2017";
//$desc = "BEACH RUN 2017";
// $desc = "PRV DO VRV Vodno 2019";
$desc = "Coca-Cola Dedomrazovska trka 2023";
$opis = "Coca-Cola Дедомразовска трка 2023";
$godina=$row['godina'];
$datum=date("Y-m-d H:i:s", strtotime('+1 hours'));
$ipadresa=$_SERVER["HTTP_X_FORWARDED_FOR"];
if ($ipadresa == "") {
$ipadresa=$_SERVER["REMOTE_ADDR"];
}
$trka="DMT";
//$trka="beachrun";
//$note="8 март";
//$product="Ваучер 8 МАРТ за учество на ПРВ ДО ВРВ 2017";
$note="DMT 2023 biz";
$product="Котизација за учество на Coca-Cola Дедомразовска трка 2023";
//$note="beachrun 2017 biz";
//$product="Котизација за учество на BEACH RUN 2017";
/* Запишување на регистрацијата */
/* $dupesql = "SELECT * FROM sportdayohrid where trka = '$trka' and godina = $godina and ime = '$ime' and prezime = '$prezime' and email = '$email'";
$duperaw = mysql_query($dupesql, $conn);
if (mysql_num_rows($duperaw) == 0) { */
$mysql_result = mysqli_query($conn, "SHOW TABLE STATUS LIKE 'sportdayohrid'");
$data = mysqli_fetch_array($mysql_result, MYSQLI_ASSOC);
$nextid = $data['Auto_increment'];
$sql = "INSERT INTO firmi (firma, adresa, telefon, email, lice, datum, ipadresa, kotizacija, note, trka, godina, qucesnici) VALUES ('$firma', '$adresa', '$telefon', '$email', '$lice', '$datum', '$ipadresa', $cenareal, '$note', '$trka', $godina, $qucesnici)";
mysqli_query($conn, $sql);
//$nextid=mysqli_insert_id($conn);
//$_SESSION["id"] = $nextid;
/* Фактура */
include("MPDF57/mpdf.php");
$mpdf = new mPDF('utf-8', 'A4', '10', 'Arial', 0, 0, 5, 5, 5, 5);
$mpdf->charset_in = 'utf-8';
$mpdf->SetDisplayMode('fullpage');
$mpdf->list_indent_first_level = 0; // 1 or 0 - whether to indent the first level of a list
$html=file_get_contents('invoices/invoice.htm');
$html = str_replace('[Q]',$qucesnici,$html);
$html = str_replace('[PROIZVOD]',$product,$html);
$html = str_replace('[CENA]',$cenareal,$html);
$html = str_replace('[IZNOS]',$iznos,$html);
$html = str_replace('[VKUPNO]',$iznos,$html);
$html = str_replace('[FIRMA]',$firma,$html);
$html = str_replace('[ADRESA]',$adresa,$html);
$html = str_replace('[DATUM]',date('d.m.Y'),$html);
$html = str_replace('[VALUTA]',date('d.m.Y', strtotime('+1 days')),$html);
//$html = str_replace('[VALUTA]',date('d.m.Y'),$html);
$html = str_replace('[FBR]',"2023W".$nextid,$html);
$mpdf->WriteHTML($html);
$mpdf->Output('invoices/prvdovrv2023W'.$nextid.'.pdf', F);
$attachurl='http://prvdovrv.mk/invoices/prvdovrv2023W'.$nextid.'.pdf';
/* ***** */
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$mail->isSMTP();
$mail->SMTPDebug = 0;
$mail->Debugoutput = 'html';
$mail->Host = "odin.mk-host.com";
$mail->Port = 465;
$mail->SMTPAuth = true;
$mail->Username = "upgradem@odin.mk-host.com";
$mail->Password = "N043Ze0fzn";
$mail->SMTPSecure = 'ssl';
$body = file_get_contents('newsletters/businessorder.htm');
//$body = eregi_replace("[\]",'',$body);
$body = str_replace('[FIRMA]',$firma,$body);
$body = str_replace('[IZNOS]',$iznos,$body);
$body = str_replace('[nastan]',$opis,$body);
//$body = str_replace('[cena]',$cenareal,$body);
//$body = str_replace('[id]',$nextid,$body);
$body = str_replace('[coverpic]',$coverpic,$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Бизнис регистрација за ". $opis;
$mail->AddAddress($email);
$mail->addBcc("alek@prvdovrv.mk");
//$mailer->AddAddress("info@prvdovrv.mk");
$mail->MsgHTML($body);
$mail->addStringAttachment(file_get_contents($attachurl), 'cc-dmt-2023.pdf');
$send = $mail->Send();
$mail->ClearAllRecipients();
}
/************/
// }
/* $resultlast = mysql_query("SELECT LAST_INSERT_ID()", $conn);
$rowlast = mysql_fetch_array($resultlast);
$nextid=$rowlast['id']; */
/* За плаќањето */
$cena_len=strlen($cena);
$details1= $desc;
$details1_len=strlen($details1);
$details2=$nextid;
$details2_len=strlen($details2);
$PaymentOKURL="https://prvdovrv.mk/ok.php?n=".$details2;
$PaymentOKURL_len=strlen($PaymentOKURL);
$PaymentFailURL="https://prvdovrv.mk/fail.php?n=".$details2;
$PaymentFailURL_len=strlen($PaymentFailURL);
$InputsLenght="0".$PaymentOKURL_len."0".$PaymentFailURL_len."00".$cena_len."010"."017"."003"."0".$details1_len."00".$details2_len;
$CheckSum="08PaymentOKURL,PaymentFailURL,AmountToPay,PayToMerchant,MerchantName,AmountCurrency,Details1,Details2,".$InputsLenght.$PaymentOKURL.$PaymentFailURL.$cena."1000000791PRV DO VRV SkopjeMKD".$details1.$details2."HMQkm5uS1aUCrFNF";
/* ****** */
?>
echo $firma ?>
Ви благодариме за испратеното барање за ваше компаниско учество на echo $opis ?>.
За успешно комплетирање на регистрацијата потребно е да се изврши плаќање од echo $iznos ?> денари .
Плаќањето може да се изврши со картичка на копчето подолу или според фактурата која ви е испратена на email.
//echo md5(uniqid($_SESSION["email"], true)) ?>
}
?>
if(isset($_GET['businessrun'])) {
$firma = $_POST['firma'];
$adresa = $_POST['adresa'];
$lice = $_POST['lice'];
$email = $_POST['email'];
$telefon = $_POST['telefon'];
$qucesnici = $_POST['q'];
?>
require 'phpmailer/PHPMailerAutoload.php';
$servername = "localhost";
$username = "upgradem_aleeek";
$password = "Will0wTreeII";
$dbname = "upgradem_active";
// Create connection
$connA = mysql_connect($servername, $username, $password, true);
// Check connection
if (!$connA) {
die("Connection failed: " . mysql_error());
}
$db_selected = mysql_select_db($dbname, $connA);
$result = mysql_query("SELECT * FROM events where id=4", $connA);
$row = mysql_fetch_array($result);
$cenareal=$row['cena'];
$iznos=$cenareal * $qucesnici;
$cena=$iznos."00";
$opis = $row['ime'];
//$desc = "PRV DO VRV 2017";
$desc = "BEACH RUN 2017";
$godina=$row['godina'];
$datum=date("Y-m-d H:i:s", strtotime('+1 hours'));
$ipadresa=$_SERVER["HTTP_X_FORWARDED_FOR"];
if ($ipadresa == "") {
$ipadresa=$_SERVER["REMOTE_ADDR"];
}
//$trka="PDV";
$trka="beachrun";
//$note="8 март";
//$product="Ваучер 8 МАРТ за учество на ПРВ ДО ВРВ 2017";
/*$note="pdv 2017 biz";
$product="Котизација за учество на ПРВ ДО ВРВ 2017"; */
$note="beachrun 2017 biz";
$product="Котизација за учество на BEACH RUN 2017";
/* Запишување на регистрацијата */
/* $dupesql = "SELECT * FROM sportdayohrid where trka = '$trka' and godina = $godina and ime = '$ime' and prezime = '$prezime' and email = '$email'";
$duperaw = mysql_query($dupesql, $conn);
if (mysql_num_rows($duperaw) == 0) { */
$sql = "INSERT INTO firmi (firma, adresa, telefon, email, lice, datum, ipadresa, kotizacija, note, trka, godina, qucesnici) VALUES ('$firma', '$adresa', '$telefon', '$email', '$lice', '$datum', '$ipadresa', $cenareal, '$note', '$trka', $godina, $qucesnici)";
mysql_query($sql, $conn);
$nextid=mysql_insert_id($conn);
//$_SESSION["id"] = $nextid;
/* Фактура */
include("MPDF57/mpdf.php");
$mpdf = new mPDF('utf-8', 'A4', '10', 'Arial', 0, 0, 5, 5, 5, 5);
$mpdf->charset_in = 'utf-8';
$mpdf->SetDisplayMode('fullpage');
$mpdf->list_indent_first_level = 0; // 1 or 0 - whether to indent the first level of a list
$html=file_get_contents('invoices/invoice.htm');
$html = str_replace('[Q]',$qucesnici,$html);
$html = str_replace('[PROIZVOD]',$product,$html);
$html = str_replace('[CENA]',$cenareal,$html);
$html = str_replace('[IZNOS]',$iznos,$html);
$html = str_replace('[VKUPNO]',$iznos,$html);
$html = str_replace('[FIRMA]',$firma,$html);
$html = str_replace('[ADRESA]',$adresa,$html);
$html = str_replace('[DATUM]',date('d.m.Y'),$html);
//$html = str_replace('[VALUTA]',date('d.m.Y', strtotime('+7 days')),$html);
$html = str_replace('[VALUTA]',date('d.m.Y'),$html);
$html = str_replace('[FBR]',$nextid,$html);
$mpdf->WriteHTML($html);
$mpdf->Output('invoices/prvdovrv2017W'.$nextid.'.pdf', F);
$attachurl='http://prvdovrv.mk/invoices/prvdovrv2017W'.$nextid.'.pdf';
/* ***** */
/* прати меил за успешно пријавување без плаќање */
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$mail = new PHPMailer();
$mail->CharSet = 'UTF-8';
$mail->isSMTP();
$mail->SMTPDebug = 0;
$mail->Debugoutput = 'html';
$mail->Host = "odin.mk-host.com";
$mail->Port = 465;
$mail->SMTPAuth = true;
$mail->Username = "upgradem@odin.mk-host.com";
$mail->Password = "N043Ze0fzn";
$mail->SMTPSecure = 'ssl';
$body = file_get_contents('newsletters/businessorder.htm');
$body = eregi_replace("[\]",'',$body);
$body = str_replace('[FIRMA]',$firma,$body);
$body = str_replace('[IZNOS]',$iznos,$body);
$body = str_replace('[nastan]',$opis,$body);
//$body = str_replace('[cena]',$cenareal,$body);
//$body = str_replace('[id]',$nextid,$body);
//$body = str_replace('[coverpic]',$coverpic,$body);
$mail->SetFrom("info@prvdovrv.mk","PRV DO VRV");
$mail->Subject = "Бизнис регистрација за ". $opis;
$mail->AddAddress($email);
//$mailer->AddAddress("info@prvdovrv.mk");
$mail->MsgHTML($body);
$mail->addStringAttachment(file_get_contents($attachurl), 'prvdovrv2017.pdf');
$send = $mail->Send();
$mail->ClearAllRecipients();
}
/************/
// }
/* $resultlast = mysql_query("SELECT LAST_INSERT_ID()", $conn);
$rowlast = mysql_fetch_array($resultlast);
$nextid=$rowlast['id']; */
/* За плаќањето */
$cena_len=strlen($cena);
$details1= $desc;
$details1_len=strlen($details1);
$details2=$_SESSION["id"];
$details2_len=strlen($details2);
$PaymentOKURL="http://prvdovrv.mk/ok.php?n=".$details2;
$PaymentOKURL_len=strlen($PaymentOKURL);
$PaymentFailURL="http://prvdovrv.mk/fail.php?n=".$details2;
$PaymentFailURL_len=strlen($PaymentFailURL);
$InputsLenght="0".$PaymentOKURL_len."0".$PaymentFailURL_len."00".$cena_len."010"."017"."003"."0".$details1_len."00".$details2_len;
$CheckSum="08PaymentOKURL,PaymentFailURL,AmountToPay,PayToMerchant,MerchantName,AmountCurrency,Details1,Details2,".$InputsLenght.$PaymentOKURL.$PaymentFailURL.$cena."1000000791PRV DO VRV SkopjeMKD".$details1.$details2."HMQkm5uS1aUCrFNF";
/* ****** */
?>
echo $firma ?>
Ви благодариме за испратеното барање за ваше компаниско учество на echo $opis ?>.
Во најкраток рок ќе ве побараме за да ви ги доставиме нарачаните ваучери.
За успешно комплетирање на регистрацијата потребно е да се изврши плаќање од echo $iznos ?> денари .
Плаќањето може да се изврши со картичка на копчето подолу или според фактурата која ви е испратена на email.
//echo md5(uniqid($_SESSION["email"], true)) ?>
}
?>