'maxid'), FALSE, "shows"); $showid = $tmpid['maxid'] + 1; if(!mysql_query("INSERT INTO shows(id, userid) VALUES($showid, $userid)")) { unset($showid); exit; } } $isrightuser = ((Whois($showid,"shows") == $userid) || is_Admin($userid))?TRUE:FALSE; // обновление информации при наличии showid if(($update == "info") && $showid && $isrightuser) { $name = Shield($_REQUEST[showname]); $countryid = (int)$_REQUEST[showcountryid]; $showdate_days = Shield($_REQUEST[showdate_days]); $showdate_months = Shield($_REQUEST[showdate_months]); $showdate_years = Shield($_REQUEST[showdate_years]); $showdate = "$showdate_days.$showdate_months.$showdate_years"; $judgeid = (int)$_REQUEST[judgeid]; $photourl = Shield($_REQUEST[photourl]); $videourl = Shield($_REQUEST[videourl]); $comments = Shield($_REQUEST[comments]); $colorsep = $_REQUEST[colorsep]; $status = (int)$_REQUEST[showstatus]; $suserid = is_admin($userid)?((int)$_REQUEST[suserid]):$userid; $bk = (int)$_REQUEST[bk]; $bk_p = ($bk > 0)?((int)$_REQUEST[bk_p]):0; $bb = (int)$_REQUEST[bb]; $bb_p = ($bb > 0)?((int)$_REQUEST[bb_p]):0; $bp = (int)$_REQUEST[bp]; $bp_p = ($bp > 0)?((int)$_REQUEST[bp_p]):0; $bj = (int)$_REQUEST[bj]; $bj_p = ($bj > 0)?((int)$_REQUEST[bj_p]):0; $bs = (int)$_REQUEST[bs]; $bs_p = ($bs > 0)?((int)$_REQUEST[bs_p]):0; $big = (int)$_REQUEST[big]; $big_p = ($big > 0)?((int)$_REQUEST[big_p]):0; $bis = (int)$_REQUEST[bis]; $bis_p = ($bis > 0)?((int)$_REQUEST[bis_p]):0; $br = (int)$_REQUEST[br]; $br_p = ($br > 0)?((int)$_REQUEST[br_p]):0; $bpair_m = (int)$_REQUEST[bpair_m]; $bpair_f = (int)$_REQUEST[bpair_f]; if(($bpair_m > 0) || ($bpair_f > 0)) $bpair_p = (int)$_REQUEST[bpair_p]; else { $bpair_m = 0; $bpair_f = 0; $bpair_p = 0; } $query .= "UPDATE shows SET "; $query .= " name = \"$name\", "; $query .= " countryid = \"$countryid\", "; $query .= " showdate = \"".ConvertDate($showdate,TRUE)."\", "; $query .= " judgeid = \"$judgeid\", "; $query .= " photourl = \"$photourl\", "; $query .= " videourl = \"$videourl\", "; $query .= " comments = \"$comments\", "; $query .= " statusid = \"$status\", "; $query .= " userid=$suserid, "; $query .= " bk = $bk, bk_p = $bk_p, "; $query .= " bb = $bb, bb_p = $bb_p, "; $query .= " bp = $bp, bp_p = $bp_p, "; $query .= " bj = $bj, bj_p = $bj_p, "; $query .= " bs = $bs, bs_p = $bs_p, "; $query .= " big = $big, big_p = $big_p, "; $query .= " bis = $bis, bis_p = $bis_p, "; $query .= " br = $br, br_p = $br_p, "; $query .= " bpair_m = $bpair_m, bpair_f = $bpair_f, bpair_p = $bpair_p"; $query .= (is_admin($userid)?(", active = ".(int)$_REQUEST[showactive]):"")." "; $query .= ", colorsep=".(($colorsep == "on")?"1":"0")." "; $query .= "WHERE id = $showid"; if(!mysql_query($query)) $errstr .= ErrMsg("

".mysql_error()."

"); } // обновление информации при наличии showid if(($update == "photo") && $showid && $isrightuser) { //var_dump($_FILES); foreach($_FILES[newfoto][tmp_name] AS $dogid => $newf) { if($newf <> "") $a = LoadPhoto((int)$dogid,$showid,$newf,4); else $a = FALSE; if($a) $errstr .= "

‘ќ“ќ ".DogFullName($dogid, FALSE, FALSE, FALSE)." Ќ «ј–”Ќќ: $a !

"; } } // если нет нормального Showid - вернемс€ на страницу списка выставок if(!$showid) Header("Location: shows.php"); $jq .= "$(\"#formshowres\").load('aj_showform.php', {showid: '$showid'});"; $jq .= "$(\"#showresults\").load('aj_showresults.php', {showid: '$showid'});"; FormHeader(FALSE, $userid, $jq); if($errstr <> "") echo ErrMsg($errstr); SQLConn(); $sn = data_select('*', array('id' => $showid), 'shows'); $title = "{$sn['name']}"; $linkstr = ShowNames($sn['countryid'],"countries",$iseng).", ".ShowNames($sn['statusid'],"showstatus",$iseng).", ". ConvertDate($sn['showdate']) .", ".ShowNames($sn['judgeid'],"showjudges",$iseng).(is_admin($userid)?(" / ".ShowNames($sn['userid'], 'users')):""); if($isrightuser) $linkstr .= " / [{$if['common_edit']}] ". " [{$if['common_photo']}]"; // добавим выборку числа участников $dc = data_select("COUNT( place ) AS catalog, SUM( IF( place <> \"неяв.\", 1, 0 ) ) AS really", array('showid' => (int)$showid), 'showresults', array('group by' => 'showid')); if($sn['photourl'] <> "") $countstr .= "

{$if['shows_photo_url']}

"; if($sn['videourl'] <> "") $countstr .= "

{$if['shows_video_url']}

"; $countstr .= "{$if['shows_dogcount']}: {$dc['catalog']} - {$if['shows_dogcount_catalog']} / {$dc['really']} - {$if['shows_dogcount_really']}."; // -------------------- // «—№ ЅџЋ ЅЋќ  ¬џ¬ќј –«”Ћ№“ј“ќ¬, “ѕ–№ ѕ–Ќ—Ќ ¬ AJAX файл aj_showresults.php // -------------------- // ------------------------------------------------- // AJAX-блок добавлени€ собаки в результаты $outajax = "
"; if($isrightuser) { $outajax .= << function GetDogs() { var sname = document.getElementById("sn").value; var fname = "dogid"; $("#res01").html("Запрос обрабатывается ..."); $('#res01').load('aj_doglist.php', {sname: sname, fname: fname}); $('a.lightbox').lightBox(); } EOT; } // компоновка страницы $c1 .= Title($title, $linkstr); if($sn['comments']) $c1 .= "
{$sn['comments']}
"; $c1 .= "
$countstr
"; if($isrightuser) $c1 .= InfoBlock($if['shows_enter_results'], "", $outajax); $c1 .= "
"; $c1 = "
$c1
"; // другие выставки в этот день $dt3 = mysql_query("SELECT * FROM shows WHERE showdate=\"{$sn['showdate']}\" AND id <> {$sn['id']} ".(!$userid?" AND active>0":"")." ORDER BY countryid"); while($r = mysql_fetch_array($dt3)) $outtext3 .= "
". (($r['id'] == $sn['id'])?"{$r['name']}":("{$r['name']}".(is_admin($userid)?" [ред]".($r['active']?" (+)":" (-)"):""))). "
". ConvertDate($r['showdate']).", ".ShowNames($r['countryid'],"countries",($if['id'] == 1)?FALSE:TRUE). (is_admin($userid)?"
".ShowNames($r['userid'], 'users')."":""). "
". "
"; $c2 .= InfoBlock(ConvertDate($sn['showdate']), $if['shows_dayshows'], $outtext3); // другие выставки этого эксперта $dt3 = mysql_query("SELECT * FROM shows WHERE judgeid=\"{$sn['judgeid']}\" ".(!$userid?" AND active>0":"")." ORDER BY showdate DESC"); while($r = mysql_fetch_array($dt3)) { $shname = $r[$nnm]; $outtext4 .= "
". (($r['id'] == $sn['id'])?"$shname":("$shname".(is_admin($userid)?" [ред]".($r['active']?" (+)":" (-)"):""))). "
". ConvertDate($r['showdate']).", ".ShowNames($r['countryid'],"countries", $iseng). (is_admin($userid)?"
".ShowNames($r['userid'], 'users')."":""). "
". "
"; } if(file_exists("judges/{$sn['judgeid']}-0.jpg")) $outtext4 = "".$outtext4; $jn = data_select('*', array('id' => $sn['judgeid']), 'showjudges'); $c2 .= InfoBlock("".($iseng?$jn['engname']:$jn['name'])."".($jn['breedexpert']?"
{$if['judge_breedexpert']}":""), $if['shows_judgeshows'], $outtext4); // echo jsSaveShowInfo($userid, $showid); - вариант редактировани€ инфы о выставке в теле страницы TwoColumns($c1, $c2); FormEnding($userid); ?>