Перейти в раздел голосования";
} elseif (isset($idfoto_v)) { //-----------------------------------------------------------------------------------------
$result=mysql_query("SELECT * FROM ".$xoopsConfig['prefix']."_prosm_v WHERE fotoid LIKE '$idfoto_v'");
if (mysql_num_rows($result)) mysql_query("UPDATE ".$xoopsConfig['prefix']."_prosm_v SET prosm=prosm+1 WHERE fotoid LIKE '$idfoto_v'");
else mysql_query("INSERT INTO ".$xoopsConfig['prefix']."_prosm_v VALUES ('DEFAULT','$idfoto_v','1');");
$result=mysql_query("SELECT * FROM ".$xoopsConfig['prefix']."_foto_v WHERE id=\"$idfoto_v\"");
if (mysql_num_rows($result)) {
$result1=mysql_query("SELECT * FROM ".$xoopsConfig['prefix']."_uservoice_v WHERE fotoid=\"$idfoto_v\"");
$totaluser=mysql_num_rows($result1);
$sumball=0;
while ($row1 = mysql_fetch_array($result1)) {
$sumball = $sumball + $row1['ball'];
}
$sredball = $sumball / $totaluser;
if (!$sredball) $sredball=0;
$img="upload/".mysql_result($result, 0, 'foto');;
echo "
";
$result=mysql_query("SELECT * FROM ".$xoopsConfig['prefix']."_system_v WHERE type LIKE 'onpage'");
$onpage = mysql_result($result, 0, 'znach1');
$firstrecord = $page_v * $onpage;
$result=mysql_query("SELECT * FROM ".$xoopsConfig['prefix']."_comment_v WHERE fotoid='$idfoto_v'");
$totalrecords = mysql_num_rows($result);
if ((mysql_num_rows($result) - $firstrecord) <= $onpage) $onpage = mysql_num_rows($result) - $firstrecord;
$result=mysql_query("SELECT * FROM ".$xoopsConfig['prefix']."_comment_v WHERE fotoid='$idfoto_v' ORDER BY id DESC LIMIT $firstrecord,$onpage");
if (mysql_num_rows($result)) echo "Комментарии:";
while ($row = mysql_fetch_array($result)) {
$comme_v=str_replace("\n"," ",$row[comment]);
echo "
Автор: ".$row[author]."
".$comme_v."
";
}
if ($xoopsUser) $reguser=$xoopsUser->getVar("uname");
echo " ";
$linkprefix="idfoto_v=".$idfoto_v."&";
onpagemap($totalrecords, $xoopsConfig['prefix'],$page_v,$linkprefix);
}
} else { //-----------------------------------------------------------------------------------------
$result=mysql_query("SELECT * FROM ".$xoopsConfig['prefix']."_system_v WHERE type LIKE 'onpage'");
$onpage = mysql_result($result, 0, 'znach1');
$firstrecord = $page_v * $onpage;
$result=mysql_query("SELECT * FROM ".$xoopsConfig['prefix']."_foto_v");
$totalrecords = mysql_num_rows($result);
if ((mysql_num_rows($result) - $firstrecord) <= $onpage) $onpage = mysql_num_rows($result) - $firstrecord;
$onpage = $firstrecord + $onpage;
$linkprefix="sort_v=".$sort_v."&sortvu_v=".$sortvu_v."&";
onpagemap($totalrecords, $xoopsConfig['prefix'], $page_v, $linkprefix);
if ($sort_v=='prosm') $temp1='selected';
elseif ($sort_v=='golos') $temp2='selected';
elseif ($sort_v=='ball') $temp3='selected';
if ($sortvu_v=='vozr') $temp4='selected';
elseif ($sortvu_v=='ubiv') $temp5='selected';
$result=mysql_query("SELECT * FROM ".$xoopsConfig['prefix']."_system_v WHERE type LIKE 'rule'");
echo "
Татуировки для болельщиков
".mysql_result($result, 0, 'comment')."
";
}
include_once(XOOPS_ROOT_PATH."/footer.php");
?>