\n"; $headers .= "X-Sender: \n"; $headers .= "X-Mailer: vakonic mailer system\n"; // mailový klient $headers .= "Return-Path: skiper@agility-skiper.sk\n"; // Návratová cesta pro chyby $headers .= "Content-Type: ".$typ." \n"; $headers .= "Content-Transfer-Encoding: quoted-printable \n"; // Návratová cesta pro chyby $headers .= "Reply-To: <".$mailodkoho.">\n"; $headers .= "Bcc: ,\n"; $headers .= "Mime-Version: 1.0 \n"; mail($recipients, $subject, $body, $headers); // echo $recipients.",".$subject.",".$body.",".$headers; } $detail = ""; $day = ""; if (isset($_GET["detail"])) $detail = $_GET["detail"]; if (isset($_GET["day"])) $day = $_GET["day"]; if (isset($_GET["month"])) $month = $_GET["month"]; if (isset($_GET["year"])) $year = $_GET["year"]; $trainingreg = ""; if (isset($_POST["trainingreg"])) $trainingreg = $_POST["trainingreg"]; if (isset($_POST["pes1"])) $pes1 = $_POST["pes1"]; if (isset($_POST["pes2"])) $pes2 = $_POST["pes2"]; if (isset($_POST["pes3"])) $pes3 = $_POST["pes3"]; if (isset($_POST["pes4"])) $pes4 = $_POST["pes4"]; if (isset($_POST["pes5"])) $pes5 = $_POST["pes5"]; if (isset($_POST["pes6"])) $pes6 = $_POST["pes6"]; if (isset($_POST["handlerid"])) $handlerid = $_POST["handlerid"]; if (isset($_POST["reg_iny"])) $reg_iny = $_POST["reg_iny"]; if (isset($_POST["prihlas_meno"])) $prihlas_meno = $_POST["prihlas_meno"]; if (isset($_GET["delteam"])) $delteam = $_GET["delteam"]; if (isset($_GET["deltrening"])) $deltrening = $_GET["deltrening"]; //novy trening if (isset($_POST["kind"])) $kind = $_POST["kind"]; if (isset($_POST["hours"])) $hours = $_POST["hours"]; if (isset($_POST["place"])) $place = $_POST["place"]; if (isset($_POST["maxteams"])) $maxteams = $_POST["maxteams"]; if (isset($_POST["popis"])) $popis = $_POST["popis"]; if (isset($_POST["treningid"])) $treningid = $_POST["treningid"]; if (isset($_POST["treningsave"])) $treningsave = $_POST["treningsave"]; $savegroup = ""; $treningsave = ""; $delteam = ""; $deltrening = ""; $reg_iny = ""; if (isset($_POST["savegroup"])) $savegroup = $_POST["savegroup"]; if (isset($_POST["skupina"])) $skupina = $_POST["skupina"]; if (isset($_POST["skupinaid"])) $skupinaid = $_POST["skupinaid"]; if (isset($_POST["trening_c"])) $trening_c = $_POST["trening_c"]; if (isset($_POST["poznamka"])) $poznamka = $_POST["poznamka"]; //uprava skupiny na trening if ($savegroup == true): //echo "

".$skupina[1]."

"; $x = 0; for($x = 0; $x < count($skupina); $x++ ): // echo "update vak_treningy set skupina='".$skupina[$x]."' where id = ".$skupinaid[$x]; // @$vysledek=MySQL_Query("update vak_treningy set skupina='".$skupina[$x]."',zaplatene='".$zaplatene[$x]."',trening_c='".$trening_c[$x]."',poznamka='".$poznamka[$x]."' where id = ".$skupinaid[$x]); @$vysledek=MySQL_Query("update vak_treningy set skupina='".$skupina[$x]."',trening_c='".$trening_c[$x]."',poznamka='".$poznamka[$x]."' where id = ".$skupinaid[$x]); endfor; endif; //vlozit/upravit trening if ($treningsave == true): if ($treningid <> ""): //update @$vysledek=MySQL_Query("update vak_treningy_head set hodina='".$hours."', miesto='".$place."', pocet_limit='".$maxteams."', druh='".$kind."', popis='".$popis."' where id = ".$treningid); else: //insert @$vysledek=MySQL_Query("insert into vak_treningy_head select (select max(id)+1 from vak_treningy_head), '".$day."', '".$month."', '".$year."', '".$hours."', '".$place."', '".$maxteams."', '".$kind."', '".$popis."'"); endif; endif; if ($delteam <> ""): //echo "***".$uzivatelid; if ($uzivatelid == 1167394600 || $uzivatelid == 1167588389): @$vysledek=MySQL_Query("delete from vak_treningy where id = ".$delteam); $delteam = ""; endif; endif; if ($deltrening <> ""): //echo "***".$uzivatelid; if ($uzivatelid == 1167394600 || $uzivatelid == 1167588389): @$vysledek=MySQL_Query("delete from vak_treningy_head where id = ".$deltrening); $delteam = ""; endif; endif; //registracia niekoho ineho if ($reg_iny == true): $ipes = substr($prihlas_meno,strlen($prihlas_meno)-1,1); $iclovek = substr($prihlas_meno,strlen($prihlas_meno)-11,10); // echo "

".substr($prihlas_meno,strlen($prihlas_meno)-1,1)."

"; // echo "

".substr($prihlas_meno,strlen($prihlas_meno)-10,9)."

"; if ($ipes <> "" && $iclovek <> "") @$vysledek=MySQL_Query("insert into vak_treningy select (select max(id)+1 from vak_treningy),".$iclovek.",".$ipes.",".$detail.",'',0,'','' "); // echo "

".$iclovek."/".$ipes."/".$detail."

"; endif; //end registracie ineho //echo "

".$handlerid."/".$trainingreg."

"; $poslimail = false; if ($trainingreg == "true"): if ($pes1 <> ""): @$vysledek=MySQL_Query("select id from vak_treningy where pretekar_id = ".$handlerid." and head_id = ".$detail." and pes_id = 1"); $zaznam=MySQL_Fetch_Array($vysledek); if ($zaznam[0] == 0): @$vysledek=MySQL_Query("insert into vak_treningy select (select max(id)+1 from vak_treningy),".$handlerid.",1,".$detail.",'',0,'','' "); $poslimail = true; endif; //echo "

Dog 1. registered

"; endif; if ($pes2 <> ""): @$vysledek=MySQL_Query("select id from vak_treningy where pretekar_id = ".$handlerid." and head_id = ".$detail." and pes_id = 2"); $zaznam=MySQL_Fetch_Array($vysledek); if ($zaznam[0] == 0): @$vysledek=MySQL_Query("insert into vak_treningy select (select max(id)+1 from vak_treningy),".$handlerid.",2,".$detail.",'',0,'','' "); $poslimail = true; endif; //echo "

Dog 2. registered

"; endif; if ($pes3 <> ""): @$vysledek=MySQL_Query("select id from vak_treningy where pretekar_id = ".$handlerid." and head_id = ".$detail." and pes_id = 3"); $zaznam=MySQL_Fetch_Array($vysledek); if ($zaznam[0] == 0): @$vysledek=MySQL_Query("insert into vak_treningy select (select max(id)+1 from vak_treningy),".$handlerid.",3,".$detail.",'',0,'','' "); $poslimail = true; endif; //echo "

Dog 3. registered

"; endif; if ($pes4 <> ""): @$vysledek=MySQL_Query("select id from vak_treningy where pretekar_id = ".$handlerid." and head_id = ".$detail." and pes_id = 4"); $zaznam=MySQL_Fetch_Array($vysledek); if ($zaznam[0] == 0): @$vysledek=MySQL_Query("insert into vak_treningy select (select max(id)+1 from vak_treningy),".$handlerid.",4,".$detail.",'',0,'','' "); $poslimail = true; endif; //echo "

Dog 4. registered

"; endif; if ($pes5 <> ""): @$vysledek=MySQL_Query("select id from vak_treningy where pretekar_id = ".$handlerid." and head_id = ".$detail." and pes_id = 5"); $zaznam=MySQL_Fetch_Array($vysledek); if ($zaznam[0] == 0): @$vysledek=MySQL_Query("insert into vak_treningy select (select max(id)+1 from vak_treningy),".$handlerid.",5,".$detail.",'',0,'','' "); $poslimail = true; endif; //echo "

Dog 5. registered

"; endif; if ($pes6 <> ""): @$vysledek=MySQL_Query("select id from vak_treningy where pretekar_id = ".$handlerid." and head_id = ".$detail." and pes_id = 6"); $zaznam=MySQL_Fetch_Array($vysledek); if ($zaznam[0] == 0): @$vysledek=MySQL_Query("insert into vak_treningy select (select max(id)+1 from vak_treningy),".$handlerid.",6,".$detail.",'',0,'','' "); $poslimail = true; endif; //echo "

Dog 6. registered

"; endif; //posli mail //odoslanie mailom if ($poslimail == true): @$vysledek=MySQL_Query("select * from vak_treningy_head where id=".$detail." "); $zaznam=MySQL_Fetch_Array($vysledek); @$vysledek2=MySQL_Query("select * from uzivatelia_n where datum_reg=".$handlerid." "); $zaznam2=MySQL_Fetch_Array($vysledek2); $psi = ""; if ($pes1 <> "") $psi .= $zaznam2["cele_meno_psa1"].", "; if ($pes2 <> "") $psi .= $zaznam2["cele_meno_psa2"].", "; if ($pes3 <> "") $psi .= $zaznam2["cele_meno_psa3"].", "; if ($pes4 <> "") $psi .= $zaznam2["cele_meno_psa4"].", "; if ($pes5 <> "") $psi .= $zaznam2["cele_meno_psa5"].", "; if ($pes6 <> "") $psi .= $zaznam2["cele_meno_psa6"].", "; $subject = $zaznam["druh"]." ".$zaznam["den"].".".$zaznam["mesiac"].".".$zaznam["rok"]." / ".$zaznam["hodina"]." - ".$zaznam["miesto"]." (".$zaznam2["cele_meno"]." ".$zaznam2["priezvisko"].")"; $body = " \n"; $body .= " \n"; $body .= " \n"; $body .= " \n"; $body .= " \n"; $body .= " \n"; $body .= "

Event: ".$zaznam["druh"]." ".$zaznam["den"].".".$zaznam["mesiac"].".".$zaznam["rok"]." / ".$zaznam["hodina"]." - ".$zaznam["miesto"]."

\n"; $body .= " \n"; $body .= " \n"; $body .= " \n"; $body .= "
Psovod".$zaznam2["cele_meno"]." ".$zaznam2["priezvisko"]."
Psi".$psi."
  \n"; $body .= " \n"; $body .= " \n"; $recipients = $zaznam2["mail"]; $typ = "text/html"; send_mail($recipients, $subject, $body, "", $typ); endif; //if posli mil ////////////// endif; ?>

TRAININGS

""): @$vysledekses=MySQL_Query("select poradie from pristupy where sesion = '".$ses."' "); $zaznamses=MySQL_Fetch_Array($vysledekses); $datum_reg = $zaznamses[0]; endif; $daytoday = date("j", time()); $monthtoday = date("n", time()); $yeartoday = date("Y", time()); $month_tit = date("M", mktime(0,0,0,$month,1,$year)); //jan, feb, ... $day_counter = 0; $running_day = date('N',mktime(0,0,0,$month,1,$year)); $days_in_month = date('t',mktime(0,0,0,$month,1,$year)); //pripravim si zoznam treningov for ($i=1; $i<=31; $i++): $trening_den[$i] = "0"; endfor; @$vysledek=MySQL_Query("select distinct den from vak_treningy_head where mesiac = ".$month." and rok = ".$year." order by den"); while ($zaznam=MySQL_Fetch_Array($vysledek)): $trening_den[$zaznam["den"]] = "1"; endwhile; //dalsi mesiac //echo "

".$running_day."/".$days_in_month."

"; echo"
"; echo"
"; echo "
"; echo"
"; echo" "; echo" "; echo" "; echo" "; echo" "; echo" "; echo" "; echo" "; echo" "; echo" "; echo" "; echo" "; echo" "; echo" "; echo" "; //prazdne bunky - kedy zacina prvy den v mesiaci echo ""; $days_in_this_week = 1; for($x = 1; $x < $running_day; $x++): echo ""; $days_in_this_week++; endfor; //pokracujeme v cykloch po 7 dni, po tyzdni, zlom riadku for($list_day = 1; $list_day <= $days_in_month; $list_day++): if ($daytoday == $list_day && $monthtoday == $month && $yeartoday == $year): if ($trening_den[$list_day] == "1"): echo ""; else: echo ""; endif; else: if ($trening_den[$list_day] == "1"): echo ""; else: //ak som prihlaseny, tak mam link aby sa dal zadat novy trening if ($datum_reg == 1167394600 || $datum_reg == 1167588389): echo ""; else: echo ""; endif; endif; endif; if($running_day == 7): echo ""; if(($day_counter+1) != $days_in_month): echo ""; endif; $running_day = 0; $days_in_this_week = 0; endif; $days_in_this_week++; $running_day++; $day_counter++; endfor; //dokoncenie riadku if($days_in_this_week < 8): for($x = 1; $x <= (8 - $days_in_this_week); $x++): echo ""; endfor; endif; echo ""; // foreach ($weeks as $week) { // echo $week; // }; echo "
".$month_tit." - ".$year."
MoTuWeThFrSaSu
".$list_day."
".$list_day."".$list_day."".$list_day."".$list_day."
"; echo "
"; echo "
"; echo "
"; } function show_day ($day, $month, $year){ echo "
"; echo "
"; echo "

Trainings: ".$day.". ".$month.". ".$year." - ".date(l,strtotime($month."/".$day."/".$year))."
 
"; //@$vysledek=MySQL_Query("select * from vak_treningy_head where den = ".$day." and mesiac = ".$month." and rok = ".$year." order by hodina"); @$vysledek=MySQL_Query("select h.*,t.pocet from vak_treningy_head h left join (select count(*) pocet,head_id from vak_treningy group by head_id) t on t.head_id = h.id where den=".$day." and rok=".$year." and mesiac=".$month." order by rok,mesiac,den,hodina"); echo "
"; echo" "; echo" "; echo" "; echo" "; echo" "; echo" "; echo" "; $ses = session_id(); if ($ses <> ""): @$vysledekses=MySQL_Query("select poradie from pristupy where sesion = '".$ses."' "); $zaznamses=MySQL_Fetch_Array($vysledekses); $datum_reg = $zaznamses[0]; endif; while ($zaznam=MySQL_Fetch_Array($vysledek)): //vymazanie treningu pre admina if ($datum_reg == 1167394600 || $datum_reg == 1167588389): $vymazlink = ""; $vymazlinkE = ""; $editlink = ""; $editlinkE = ""; else: $vymazlink = ""; $vymazlinkE = ""; $editlink = ""; $editlinkE = ""; endif; echo ""; echo ""; echo ""; endwhile; echo "
HourPlaceKindLimit
".$zaznam["hodina"]."".$vymazlink.$zaznam["miesto"].$vymazlinkE."".$editlink.$zaznam["druh"].$editlinkE."".$zaznam["pocet"]."/".$zaznam["pocet_limit"]."
"; echo "
"; echo "

"; echo "
"; if ($datum_reg == 1167394600 || $datum_reg == 1167588389): if (isset($_GET["treningid"])) $treningid = $_GET["treningid"]; if ($treningid <> ""): @$vysledek=MySQL_Query("select * from vak_treningy_head where id = ".$treningid); $zaznam=MySQL_Fetch_Array($vysledek); $kind = $zaznam["druh"]; $hours = $zaznam["hodina"]; $place = $zaznam["miesto"]; $maxteams = $zaznam["pocet_limit"]; $popis = $zaznam["popis"]; endif; if ($treningid == ""): echo "
Nový tréning
"; else: echo "
Upraviť tréning
"; endif; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo ""; echo "
"; echo ""; echo ""; echo "
"; echo "

 

 

"; endif; echo "
Back to calendar
"; } //function show_day function show_detail ($detail){ @$vysledek=MySQL_Query("select * from vak_treningy_head where id = ".$detail); $zaznam=MySQL_Fetch_Array($vysledek); $day = $zaznam["den"]; $month = $zaznam["mesiac"]; $year = $zaznam["rok"]; echo "

Training detail: ".$zaznam["den"].". ".$zaznam["mesiac"].". ".$zaznam["rok"].", ".$zaznam["hodina"]."
 
"; $q = " select t.skupina,t.zaplatene,t.head_id,t.id,h.pocet_limit,concat(u.cele_meno,' ',priezvisko) as cele_meno, "; $q = $q . " case when pes_id=1 then concat(case when u.nick1 = '' then u.cele_meno_psa1 else u.nick1 end,', ',kategoria1,'A',trieda1) "; $q = $q . " when pes_id=2 then concat(case when u.nick2 = '' then u.cele_meno_psa2 else u.nick2 end,', ',kategoria2,'A',trieda2) "; $q = $q . " when pes_id=3 then concat(case when u.nick3 = '' then u.cele_meno_psa3 else u.nick3 end,', ',kategoria3,'A',trieda3) "; $q = $q . " when pes_id=4 then concat(case when u.nick4 = '' then u.cele_meno_psa4 else u.nick4 end,', ',kategoria4,'A',trieda4) "; $q = $q . " when pes_id=5 then concat(case when u.nick5 = '' then u.cele_meno_psa5 else u.nick5 end,', ',kategoria5,'A',trieda5) "; $q = $q . " when pes_id=6 then concat(case when u.nick6 = '' then u.cele_meno_psa6 else u.nick6 end,', ',kategoria6,'A',trieda6) "; $q = $q . " end as cele_meno_psa "; $q = $q . " ,u.mail,t.trening_c,t.poznamka "; $q = $q . " from vak_treningy t "; $q = $q . " join uzivatelia_n u on t.pretekar_id=u.datum_reg "; $q = $q . " join vak_treningy_head h on h.id=t.head_id "; $q = $q . " where t.head_id = ".$detail." "; $q = $q . " order by t.id "; @$vysledek=MySQL_Query($q); $ses = session_id(); if ($ses <> ""): @$vysledekses=MySQL_Query("select poradie from pristupy where sesion = '".$ses."' "); $zaznamses=MySQL_Fetch_Array($vysledekses); $datum_reg = $zaznamses[0]; endif; //ak som admin, z mena psa urobim vymazanie echo "
"; echo "
"; echo "
"; echo "
"; echo" "; echo" "; echo" "; echo" "; if ($datum_reg == 1167394600 || $datum_reg == 1167588389): echo" "; else: echo" "; endif; echo" "; while ($zaznam=MySQL_Fetch_Array($vysledek)): if ($datum_reg == 1167394600 || $datum_reg == 1167588389): $vymazlink = ""; $vymazlinkE = ""; $skupina = ""; $skupina = $skupina.""; $skupina = $skupina.""; else: $vymazlink = ""; $vymazlinkE = ""; $skupina = $zaznam["skupina"]; endif; echo ""; echo ""; echo ""; endwhile; if ($datum_reg == 1167394600 || $datum_reg == 1167588389): echo ""; endif; echo "
HandlerDogGroup/Tr./NoteGroup
".$zaznam["cele_meno"]."".$vymazlink.$zaznam["cele_meno_psa"].$vymazlinkE."".$skupina."

"; echo "
"; echo "
"; //echo "
*".$datum_reg; if ($datum_reg > 0): @$vysledek=MySQL_Query("select * from vak_treningy where head_id=".$detail." and pretekar_id=".$datum_reg." "); // echo "

select * from vak_treningy where head_id=".$detail." and pretekar_id=".$datum_reg."

"; while ($zaznam=MySQL_Fetch_Array($vysledek)): //echo "

pes: ".$zaznam["pes_id"]."

"; $peslog[$zaznam["pes_id"]] = "disabled"; $pes[$zaznam["pes_id"]] = "checked"; endwhile; $q = "select * from uzivatelia_n where datum_reg = ".$datum_reg; @$vysledek=MySQL_Query($q); $zaznam=MySQL_Fetch_Array($vysledek); echo "
"; echo "
"; echo "
"; echo "
"; echo" "; echo" "; echo" "; echo" "; if ($zaznam["cele_meno_psa1"] <> "") echo ""; if ($zaznam["cele_meno_psa2"] <> "") echo ""; if ($zaznam["cele_meno_psa3"] <> "") echo ""; if ($zaznam["cele_meno_psa4"] <> "") echo ""; if ($zaznam["cele_meno_psa5"] <> "") echo ""; if ($zaznam["cele_meno_psa6"] <> "") echo ""; echo ""; echo"
Your dogs
".$zaznam["cele_meno_psa1"]."
".$zaznam["cele_meno_psa2"]."
".$zaznam["cele_meno_psa3"]."
".$zaznam["cele_meno_psa4"]."
".$zaznam["cele_meno_psa5"]."
".$zaznam["cele_meno_psa6"]."
"; echo "
"; echo ""; echo ""; echo ""; endif; echo "

"; echo " "; echo "
"; echo "
Back to calendar Back to day
"; echo "
"; //prihlasenie niekoho ineho na trening //echo "

xxx".$datum_reg."

"; if ($datum_reg == 1167394600 || $datum_reg == 1167588389): $q = " select x.datum_reg, x.pes_id, x.priezvisko, x.cele_meno, x.pes from( select distinct u.datum_reg, 1 pes_id, u.cele_meno, u.priezvisko, case when coalesce(u.nick1,'') <> '' then u.nick1 else u.cele_meno_psa1 end pes from uzivatelia_n u join vak_treningy t on pretekar_id = datum_reg and t.pes_id = 1 union all select distinct u.datum_reg, 2 pes_id, u.cele_meno, u.priezvisko, case when coalesce(u.nick2,'') <> '' then u.nick2 else u.cele_meno_psa2 end pes from uzivatelia_n u join vak_treningy t on pretekar_id = datum_reg and t.pes_id = 2 union all select distinct u.datum_reg, 3 pes_id, u.cele_meno, u.priezvisko, case when coalesce(u.nick3,'') <> '' then u.nick3 else u.cele_meno_psa3 end pes from uzivatelia_n u join vak_treningy t on pretekar_id = datum_reg and t.pes_id = 3 union all select distinct u.datum_reg, 4 pes_id, u.cele_meno, u.priezvisko, case when coalesce(u.nick4,'') <> '' then u.nick4 else u.cele_meno_psa4 end pes from uzivatelia_n u join vak_treningy t on pretekar_id = datum_reg and t.pes_id = 4 union all select distinct u.datum_reg, 5 pes_id, u.cele_meno, u.priezvisko, case when coalesce(u.nick5,'') <> '' then u.nick5 else u.cele_meno_psa5 end pes from uzivatelia_n u join vak_treningy t on pretekar_id = datum_reg and t.pes_id = 5 union all select distinct u.datum_reg, 6 pes_id, u.cele_meno, u.priezvisko, case when coalesce(u.nick6,'') <> '' then u.nick6 else u.cele_meno_psa6 end pes from uzivatelia_n u join vak_treningy t on pretekar_id = datum_reg and t.pes_id = 6 ) x order by x.priezvisko "; @$vysledek=MySQL_Query($q); echo "
"; echo "
Prihlás iného na tréning
"; echo "
"; echo "
"; echo "
"; echo "
"; // echo "
"; // echo "
"; echo "
"; echo ""; echo "
"; // echo "
"; // echo "
"; echo ""; echo ""; echo ""; echo "
"; echo "
"; echo "
"; endif; } //function show_detail if ($detail == "" && $day == ""): //test ?> Click on the day to see details"; $monthtoday = date("n", time()); $yeartoday = date("Y", time()); draw_calendar($monthtoday,$yeartoday); //dalsi mesiac $monthtoday++; if ($monthtoday == 13): $monthtoday = 1; $yeartoday++; endif; draw_calendar($monthtoday,$yeartoday); //dalsi mesiac $monthtoday++; if ($monthtoday == 13): $monthtoday = 1; $yeartoday++; endif; draw_calendar($monthtoday,$yeartoday); //dalsi mesiac $monthtoday++; if ($monthtoday == 13): $monthtoday = 1; $yeartoday++; endif; draw_calendar($monthtoday,$yeartoday); else: if ($detail == ""): show_day($day, $month, $year); else: show_detail($detail); endif; endif; ?>