".$_GET['tag']."
";
}
if ($year<>'' & $tag==''){
$query = "SELECT * FROM $userstable WHERE draft=0 and YEAR(Date) = '".$_GET['year']."' ORDER BY id";
echo "".$_GET['year']."
";
}
if($year=='' & $tag==''){
$query = "SELECT * FROM $userstable ORDER BY id";
}
if ($schema==1) {
$query = "SELECT * FROM $userstable WHERE draft=0 and `schema` = ".$_GET['schema']." ORDER BY id";
echo " работы со схемами
";
}
$res = mysql_query($query) or die(mysql_error());
$number = mysql_num_rows($res);
if (gmp_mod($number, $perpage)>0){
$page = gmp_strval(gmp_div_q($number, $perpage)) + 1;
}
else {
$page = $number / $perpage;
}
if ($_GET['page'] > $page){
echo "А такой страницы нет!"; } /*-----------------------------------------*/ if ($tag=="" & $year==""){ $query = "SELECT * FROM $userstable WHERE draft=0 ORDER BY Date DESC LIMIT ".((($_GET['page']-1)*$perpage + 1)-1).", ".$perpage; } if ($tag<>"" & $year==""){ $query = "SELECT * FROM $userstable WHERE draft=0 and typeof = '".$_GET['tag']."' ORDER BY Date DESC LIMIT ".((($_GET['page']-1)*$perpage + 1)-1).", ".$perpage; } if ($tag=="" & $year<>""){ $query = "SELECT * FROM $userstable WHERE draft=0 and YEAR(Date) = '".$_GET['year']."' ORDER BY Date DESC LIMIT ".((($_GET['page']-1)*$perpage + 1)-1).", ".$perpage; } if ($schema==1) { $query = "SELECT * FROM $userstable WHERE draft=0 and `schema` = ".$_GET['schema']." ORDER BY Date DESC LIMIT ".((($_GET['page']-1)*$perpage + 1)-1).", ".$perpage; } $res = mysql_query($query) or die(mysql_error()); $number = mysql_num_rows($res); /*-----------------------------TEST----------------------------------------*/ $currentpage = 1; /*-----------------------------TEST----------------------------------------*/ if ($number == 0) { echo "Записей нет"; } /*----------------------------------- вывод галереи ----------------------*/ else { switch ($_GET['page']){ case 1: {echo '';break;} case $page: {$prevpage=$page-1;echo '';break;} default:{$prevpage=$_GET['page']-1;$nextpage=$_GET['page']+1;echo ' ';break;} } echo '
';
$isvideo = 1;
while ($row = mysql_fetch_array($res)) {
$query1 = "SELECT * FROM $userstable1 WHERE ID_creation = ".$row['id']." ORDER BY ID";
$res1 = mysql_query($query1) or die(mysql_error());
$row1 = mysql_fetch_array($res1);
switch ($isvideo){
case 1: {echo '!['.$row1['alt'].']('.$row1['Large_photo'].' "'.$row1['title'].'")
';
echo '
'; $datearray = date_parse($row['Date']); echo '
';
break; }
case 2: {echo '';
echo '
'; $datearray = date_parse($row['Date']); echo '
';
break; }
case 3: {
switch ($_GET['page']){
case 1: {echo ' ';mysql_data_seek($res,$isvideo-2);
break; }
case 5: {echo '';
echo '
'; $datearray = date_parse($row['Date']); echo '
';
break; }
case 6: {echo '';
echo '
'; $datearray = date_parse($row['Date']); echo '
';
break; }
case 7: {echo '';
echo '
'; $datearray = date_parse($row['Date']); echo '
';
break; }
case 8: {echo '';
echo '
'; $datearray = date_parse($row['Date']); echo '
';
break; }
}
$isvideo = $isvideo + 1;
}
echo '
';
}
if ($number == 0) {
echo "записи в таблице отсутствуют";
}
/*----------------------------------- вывод номеров страниц ----------------------*/
else {
echo ''; $datearray = date_parse($row['Date']); echo '
'.date('d.m.Y',mktime( 0, 0, 0, $datearray[month], $datearray[day], $datearray[year] )).'
';
echo ''; $datearray = date_parse($row['Date']); echo '
'.date('d.m.Y',mktime( 0, 0, 0, $datearray[month], $datearray[day], $datearray[year] )).'
';
echo ''.$row['preview'].'
';
echo '
';
break;}
case 2: {echo '';
echo '
';
break;}
default: {echo '';
echo '
';
echo '
';
break;}} mysql_data_seek($res,$isvideo-2);
break; }
case 4: {echo ''; $datearray = date_parse($row['Date']); echo '
'.date('d.m.Y',mktime( 0, 0, 0, $datearray[month], $datearray[day], $datearray[year] )).'
';
echo ''; $datearray = date_parse($row['Date']); echo '
'.date('d.m.Y',mktime( 0, 0, 0, $datearray[month], $datearray[day], $datearray[year] )).'
';
echo ''.$row['preview'].'
'; $datearray = date_parse($row['Date']); echo '
'.date('d.m.Y',mktime( 0, 0, 0, $datearray[month], $datearray[day], $datearray[year] )).'
';
echo ''.$row['preview'].'
'; $datearray = date_parse($row['Date']); echo '
'.date('d.m.Y',mktime( 0, 0, 0, $datearray[month], $datearray[day], $datearray[year] )).'
';
echo '';
while ($currentpage <= $page) {
if ($currentpage == $_GET['page']){
if ($tag=="" & $year=="" & $schema==""){
echo ''.$currentpage.' '.' ';
$currentpage += 1;
}
if ($tag<>"" & $year=="" & $schema==""){
echo ''.$currentpage.' '.' ';
$currentpage += 1;
}
if ($tag=="" & $year<>"" & $schema==""){
echo ''.$currentpage.' '.' ';
$currentpage += 1;
}
if ($schema==1 & $tag=="" & $year==""){
echo ''.$currentpage.' '.' ';
$currentpage += 1;
}
}
else {
if ($tag=="" & $year==""){
echo ''.$currentpage.' '.' ';
$currentpage += 1;
}
if ($tag<>"" & $year==""){
echo ''.$currentpage.' '.' ';
$currentpage += 1;
}
if ($tag=="" & $year<>""){
echo ''.$currentpage.' '.' ';
$currentpage += 1;
}
}
}
}
echo '
';
?>
