"; $lt = ""; $dt = mysql_query("SELECT sj.id, sj.breedexpert, sj.name, sj.engname, sj.countryid, sj.".($iseng?"engdescription":"description")." AS description, COUNT(s.id) AS cnt FROM showjudges AS sj LEFT JOIN shows AS s ON sj.id=s.judgeid GROUP BY sj.id ORDER BY $nnm"); while($r = mysql_fetch_array($dt)) { if($lt != mb_substr($r[$nnm], 0, 1, "UTF-8")) { $lt = mb_substr($r[$nnm], 0, 1, "UTF-8"); $outtext .= "$lt "; } if(Is_admin($userid)) $addtxt = "[edit]"; else $addtxt = ""; if($r['breedexpert']) $addtxt .= "

{$if['judge_breedexpert']}

"; $outtext .= "\n"; $outtext .= " ".$r[$nnm]." $addtxt\n"; $outtext .= "".ShowNames($r['countryid'],"countries",$iseng)."\n"; $outtext .= "{$r['cnt']} {$if['judges_shows']}\n"; $outtext .= "{$r['description']}\n"; $outtext .= "\n"; }; $outtext .= ""; echo Title($if['judges_title'], FALSE); echo "

$outtext

"; } else { // ВЫВОДИМ ИНФО ПО ЭКСПЕРТУ $row = data_select('*', array('id' => $judgeid), 'showjudges'); if($row['countryid']) $rc = data_select('*', array('id' => $row['countryid']), 'countries'); if(file_exists("judges/$judgeid-0.jpg")) $outtext = "

"; if(is_admin($userid)) $addtxt = " [edit]"; else $addtxt = ""; $outtext .= $iseng?$row['engdescription']:$row['description']; $outtext .= "
"; $outtext .= "
"; $outtext .= ""; $dt = mysql_query("SELECT * FROM shows WHERE judgeid=$judgeid AND active=1 ORDER BY showdate DESC"); while($r = mysql_fetch_array($dt)) { $outtext .= ""; $outtext .= ""; $outtext .= ""; $outtext .= ""; $outtext .= ""; } $outtext .= "

"; $outtext .= "".$r[$nnm]."
".ConvertDate($r['showdate'])."
".ShowNames($r['statusid'], "showstatus", $iseng).""; $outtext .= "

"; $dsh = mysql_query("SELECT sr.dogid, sr.titleid, st.$nnm AS tname FROM showresults AS sr, showtitles AS st WHERE sr.showid = {$r['id']} AND sr.titleid=st.id AND sr.titleid != 0 ORDER BY st.rang"); while($rsh = mysql_fetch_array($dsh)) $outtext .= DogFullName($rsh['dogid'],TRUE)." - {$rsh['tname']}
"; $outtext .= "

"; $dst = mysql_query("SELECT markid, SUM(1) AS cnt FROM `showresults` WHERE showid={$r['id']} AND markid>0 GROUP BY markid"); while($rst = mysql_fetch_array($dst)) $outtext .= ShowNames($rst['markid'],'marktype', $iseng). " - {$rst['cnt']}
"; $outtext .= "

"; echo Title($if['judges_title'].": ".(($if['id'] == 1)?$row['name']:$row['engname']).($row['breedexpert']?" ({$if['judge_breedexpert']})":"").$addtxt, ($if['id'] == 1)?$rc['name']:$rc['engname']); echo "

$outtext

"; } FormEnding($userid); ?>