Last 50 Shows
View All Shows
";
do{
$get_show_year = baray_query("SELECT date FROM event WHERE tid_dshow='" . baray_escape($shows[2]) . "' LIMIT 1");
$sh_y = date("Y",mysqli_result($get_show_year,0));
$sh_m = date("m",mysqli_result($get_show_year,0));
// $sh_res[year][month][s.name] = tid_dshow;
$sh_res[$sh_y][$sh_m][$shows[2]] = $shows[1];
}while($shows = @mysqli_fetch_row($get_shows));
// Special code to add the Package Shows.
$mRS = baray_query("SELECT DISTINCT id, name, (SELECT date FROM event WHERE tid_dshow = dshow.id ORDER BY id LIMIT 1) as show_date FROM dshow WHERE results_override != ''");
if($mRS != false)
{
if(mysqli_num_rows($mRS) > 0)
{
while($mR = mysqli_fetch_assoc($mRS))
{
$sh_y = date("Y",$mR["show_date"]);
$sh_m = date("m",$mR["show_date"]);
// $sh_res[year][month][s.name] = tid_dshow;
$sh_res[$sh_y][$sh_m][$mR["id"]] = $mR["name"];
}
}
}
krsort($sh_res);
reset($sh_res);
$last_month = 0;
//while(list($rkey,$rval) = each($sh_res)){
foreach($sh_res as $rkey => $rval) {
echo "
$rkey";
krsort($rval);
reset($rval);
//while(list($rlkey,$rlval) = each($rval)){
foreach($rval as $rlkey => $rlval) {
if($last_month != $rlkey)
{
$last_month = $rlkey;
$date_string = $rlkey."/01/2000";
print "| ".date("F",strtotime($date_string))." | ";
}
//while(list($key,$val) = each($rlval)){
foreach($rlval as $key => $val) {
echo "| $val | ";
}
}
echo "
";
}
}else
echo "No Shows currently have results posted.";
break;
case 'listevents':
if($_GET["sid"]){
$get_s_name = baray_query("SELECT name FROM dshow WHERE id='" . baray_escape($_GET["sid"]) . "'");
$ro_rs = baray_query("SELECT results_override FROM dshow WHERE id='" . baray_escape($_GET["sid"]) . "'");
$ro_r = mysqli_fetch_assoc($ro_rs);
$results_override = $ro_r['results_override'];
$get_year = date("Y",mysqli_result(baray_query("SELECT e.date FROM event e WHERE tid_dshow='" . baray_escape($_GET["sid"]) . "' LIMIT 1"),0));
if($get_year != date("Y"))
$hd_msg = "ATTENTION: THESE RESULTS ARE FOR " . $get_year . ".
FOR A FULL LIST OF CURRENT RESULTS CLICK HERE.
";
else
$hd_msg = "";
echo "" . $hd_msg . "" . @mysqli_result($get_s_name,0) . "
";
if(trim($results_override) == "")
{
$get_events = baray_query("SELECT id,name,date FROM event WHERE tid_dshow='" . baray_escape($_GET["sid"]) . "' ORDER BY sort_order");
if($events = @mysqli_fetch_row($get_events)){
do{
$one_breed = 0;
$chk_for_one_breed = baray_query("SELECT DISTINCT tid_bgroup FROM entry WHERE tid_event='" . baray_escape($events[0]) . "'");
if(mysqli_num_rows($chk_for_one_breed) == 1)
$one_breed = 1;
echo "$events[1] (" . date("l, M jS Y",$events[2]) . ")
";
$get_shows = baray_query("SELECT g.name,r.id FROM bgroup g,result r WHERE r.tid_event='" . baray_escape($events[0]) . "' AND r.class_type='0' AND g.id=r.tid_bgroup GROUP BY r.id ORDER BY g.sort_order ASC");
if($shows = @mysqli_fetch_row($get_shows)){
echo "";
$check_for_im = baray_query("SELECT id,note FROM image WHERE tid_event='" . baray_escape($events[0]) . "' AND location='1'");
if(@mysqli_num_rows($check_for_im) > 0){
$im = @mysqli_fetch_row($check_for_im);
$size = @getimagesize($_SERVER["DOCUMENT_ROOT"] . "/images/ios/" . $im[0] . ".jpg");
echo "Best In Show
![](\"/images/ios/$im[0].jpg\")
$im[1] |
";
}
if($one_breed != 1)
echo "SELECT GROUP";
else
echo "";
do{
if($one_breed != 1){
echo "| " . strtoupper($shows[0]) . " | ";
$eid = $events[0];
}else{
echo "| Results | ";
$eid = $events[0];
unset($one_breed,$chk_for_one_breed);
}
}while($shows = @mysqli_fetch_row($get_shows));
echo "
";
}
echo "";
$check_for_classes = baray_query("SELECT id,class_type FROM result WHERE tid_event='" . baray_escape($events[0]) . "' AND (class_type='1' OR class_type='2')");
if($oclass = @mysqli_fetch_row($check_for_classes)){
do{
if($oclass[1] == 1)
echo "| JUNIOR | ";
else{
if(preg_match("/Rally/i",$events[1]))
echo "| RALLY RESULTS | ";
else
echo "| OBEDIENCE | ";
}
}while($oclass = @mysqli_fetch_row($check_for_classes));
}
$chk_grp_tot = baray_query("SELECT id FROM result WHERE tid_dshow='" . baray_escape($_GET["sid"]) . "' AND tid_event='" . baray_escape($events[0]) . "' AND class_type='3'");
if(@mysqli_num_rows($chk_grp_tot) > 0){
$tot = @mysqli_fetch_row($chk_grp_tot);
echo "| GROUP RESULTS | ";
}
$chk_grp_tot = baray_query("SELECT id FROM result WHERE tid_dshow='" . baray_escape($_GET["sid"]) . "' AND tid_event='" . baray_escape($events[0]) . "' AND class_type='37'");
if(@mysqli_num_rows($chk_grp_tot) > 0){
$tot = @mysqli_fetch_row($chk_grp_tot);
echo "| BEST BRED-BY RESULTS | ";
}
$chk_grp_tot = baray_query("SELECT id FROM result WHERE tid_dshow='" . baray_escape($_GET["sid"]) . "' AND tid_event='" . baray_escape($events[0]) . "' AND class_type='39'");
if(@mysqli_num_rows($chk_grp_tot) > 0){
$tot = @mysqli_fetch_row($chk_grp_tot);
echo "| GROUP SWEEPSTAKES | ";
}
$chk_grp_tot = baray_query("SELECT id FROM result WHERE tid_dshow='" . baray_escape($_GET["sid"]) . "' AND tid_event='" . baray_escape($events[0]) . "' AND class_type='38'");
if(@mysqli_num_rows($chk_grp_tot) > 0){
$tot = @mysqli_fetch_row($chk_grp_tot);
echo "| BEST PUPPY GROUP RESULTS | ";
}
$chk_grp_tot = baray_query("SELECT id FROM result WHERE tid_dshow='" . baray_escape($_GET["sid"]) . "' AND tid_event='" . baray_escape($events[0]) . "' AND class_type='40'");
if(@mysqli_num_rows($chk_grp_tot) > 0){
$tot = @mysqli_fetch_row($chk_grp_tot);
echo "| OWNER HANDLER RESULTS | ";
}
$chk_notice = baray_query("SELECT id FROM result WHERE tid_dshow='" . baray_escape($_GET["sid"]) . "' AND tid_event='" . baray_escape($events[0]) . "' AND class_type='4'");
if(@mysqli_num_rows($chk_notice) > 0){
$notice = @mysqli_fetch_row($chk_notice);
echo "" . implode ('', file ($_SERVER["DOCUMENT_ROOT"] . "/results/" . $notice[0] . ".html")) . " | ";
}
echo "
";
}while($events = @mysqli_fetch_row($get_events));
}else
echo "No Events in specified Show, please Click Here to try again.";
}
else
{
print $results_override;
}
}else
echo "No Show specified, please Click Here to try again.";
break;
case 'results':
$get_year = date("Y",mysqli_result(baray_query("SELECT e.date FROM event e WHERE tid_dshow='" . baray_escape($_GET["sid"]) . "' LIMIT 1"),0));
if($get_year != date("Y"))
$hd_msg = "ATTENTION: THESE RESULTS ARE FOR " . $get_year . ".
FOR A FULL LIST OF CURRENT RESULTS CLICK HERE.
";
else
$hd_msg = "";
$get = baray_query("SELECT e.name,s.name,e.date FROM event e,dshow s WHERE e.id='" . baray_escape($_GET["eid"]) . "' AND s.id='" . baray_escape($_GET["sid"]) . "'");
$got = @mysqli_fetch_row($get);
echo "" . $hd_msg . "$got[1]
$got[0]
" . date("l, M jS Y",$got[2]) . "
" . $_GET["group"] . "";
$grp_lu = baray_query("SELECT id FROM image WHERE note='First In Group (" . baray_escape($_GET["group"]) . ")'");
if(@mysqli_num_rows($grp_lu) > 0){
$grp = @mysqli_result($grp_lu,0);
$check_for_im = baray_query("SELECT id,note FROM image WHERE tid_event='" . baray_escape($_GET["eid"]) . "' AND location='" . baray_escape($grp) . "'");
if(@mysqli_num_rows($check_for_im) > 0){
$im = @mysqli_fetch_row($check_for_im);
$size = getimagesize("images/ios/" . $im[0] . ".jpg");
echo "First In Group ($group)
$im[1] |
";
}
}
echo "
";
if(file_exists($_SERVER["DOCUMENT_ROOT"] . "/results/" . $_GET["rid"] . ".html"))
@include("results/" . $_GET["rid"] . ".html");
else
echo "Results are missing, please contact dogshows@barayevents.com.
Be Sure to indicate show and group.";
break;
case 'viewallresults':
$get = baray_query("SELECT e.name,s.name FROM event e,dshow s WHERE e.id='" . baray_escape($_GET["eid"]) . "' AND s.id='" . baray_escape($_GET["sid"]) . "'");
$got = @mysqli_fetch_row($get);
echo "$got[1]
$got[0]
";
$get_res = baray_query("SELECT r.id,r.tid_bgroup,g.name,g.sort_order FROM result r,bgroup g WHERE r.tid_dshow='" . baray_escape($_GET["sid"]) . "' AND r.tid_event='" . baray_escape($_GET["eid"]) . "' AND r.class_type='0' AND g.id=r.tid_bgroup ORDER BY g.sort_order ASC");
if($res = @mysqli_fetch_row($get_res)){
do{
if(file_exists("results/" . $res[0] . ".html")){
echo "$res[2]";
@include("results/" . $res[0] . ".html");
echo "
";
}else
echo "Results are missing, please contact dogshows@barayevents.com.
Be Sure to indicate show and group.";
}while($res = @mysqli_fetch_row($get_res));
}
$get_res = baray_query("SELECT r.id,r.tid_bgroup FROM result r WHERE r.tid_dshow='" . baray_escape($_GET["sid"]) . "' AND r.tid_event='" . baray_escape($_GET["eid"]) . "' AND r.class_type='1'");
if($res = @mysqli_fetch_row($get_res)){
do{
if(file_exists("results/" . $res[0] . ".html")){
echo "JUNIOR";
@include("results/" . $res[0] . ".html");
echo "
";
}else
echo "Results are missing, please contact dogshows@barayevents.com.
Be Sure to indicate show and group.";
}while($res = @mysqli_fetch_row($get_res));
}
$get_res = baray_query("SELECT r.id,r.tid_bgroup FROM result r WHERE r.tid_dshow='" . baray_escape($_GET["sid"]) . "' AND r.tid_event='" . baray_escape($_GET["eid"]) . "' AND r.class_type='2'");
if($res = @mysqli_fetch_row($get_res)){
do{
if(file_exists("results/" . $res[0] . ".html")){
echo "OBEDIENCE";
@include("results/" . $res[0] . ".html");
echo "
";
}else
echo "Results are missing, please contact dogshows@barayevents.com.
Be Sure to indicate show and group.";
}while($res = @mysqli_fetch_row($get_res));
}
break;
}
?>
|