sql_connect();
?>
<? echo $title; ?>
, Хочу все знать, Хочу всё знать, описание, краткое описание" />
50) { $width=50; };
$firstpicture="http://www.describe.ru/images/$photoname";
endwhile;
if ((empty($firstpicture)==true) && (empty($KodPersons)<>true)):
$txt.="\n| ".$my->personsgetimg($KodPersons,'0',$width)." | \n";
else:
$txt.="
\n![\"\"](\"$firstpicture\") | \n";
endif;
$txt.="\n";
$txt.="\n";
$txt.=" $description_small\nдалее » \n | \n";
$txt.="$datepub | \n$visitors | \n
\n";
// $txt.="$name\n";
endwhile;
if ($i>0) { $txt="$sectionname
\n\n"; };
$menu="Home / ";
*/
$y=0;
if (empty($Oind)==true) {$Oind=date_registration;}
$onpage = 10; // записей на страницу
$table = "describe_ru"; // из какой таблицы
$page = page(); // определяем страницу
$navigation = navigation($onpage, $page, $table, $field); // определим навигацию
if ($i==0) { echo "$title\n |
"; };
$result = sql_query($onpage, $page, $table, $field, $Oind); // sql - запрос
$check="";
$i=0;
while($data = mysql_fetch_array($result)) // цикл вывода
{
$txt=""; $check="Done";
$name=trim($data['name']) ;
//echo $name;
$idnum=trim($data['id']) ;
$nameengl=trim($data['nameengl']);
$datepub=trim($data['date_pub']);
$path=trim($data['path']) ;
$section=trim($data['section']) ;
$visitors=trim($data['visitors']) ;
$KodPersons=trim($data['KodPersons']) ;
$description=nl2br(trim($data['description']));
$description_small=substr($description,0,200);
$qSQL = "SELECT * FROM describe_ru_section WHERE nameengl='$section' ORDER BY RAND() LIMIT 1";
$qQResult = mysql_query($qSQL);
if (mysql_error()) { print(mysql_error()); }
while ($qrow = mysql_fetch_array($qQResult)):
$sectionname=$qrow['name'];
$title=$qrow['name'];
endwhile;
$firstpicture="";
$qSQL = "SELECT * FROM describe_ru_photo WHERE id_describe='$idnum' ORDER BY RAND() LIMIT 1";
$qQResult = mysql_query($qSQL);
if (mysql_error()) { print(mysql_error()); }
while ($qrow = mysql_fetch_array($qQResult)):
$photoname=trim($qrow['photoname']) ;
$filebig=split("\.", $photoname);
$url_small="http://www.describe.ru/images/$fieldpath/".$filebig[0]."_s.".$filebig[1];
$width=trim($qrow['width']) ;
$firstpicture="http://www.describe.ru/images/$fieldpath/$photoname";
endwhile;
if ($width>100) { $width=100; };
if ((empty($firstpicture)==true) && (empty($KodPersons)<>true)):
$txt.="\n| ".$my->personsgetimg($KodPersons,'0','100')." | \n";
else:
$txt.="
\n![\"$name\"](\"$url_small\") | \n";
endif;
$txt.="\n";
$txt.="\n";
$txt.=" $description_small\n$sectionname\nдалее » \n | \n";
$txt.="".$my->date_rus_time($datepub)." | \n$visitors | \n
\n";
echo $txt;
}
if (empty($check) == true) {
?>
| $navigation |
\n"; // выведем ее
$my->sql_close();
require_once('/usr/local/www/describe.ru/www/ssi/foot-dynamic-catalog.shtml');
function page()
{
if(empty($_GET["page"])){
$page = 0;
} else {
if(!is_numeric($_GET["page"])) die("Неправильный формат номера страницы!");
$page = $_GET["page"];
}
return $page;
echo $page;
}
function sql_query($onpage, $page, $table, $field, $Oind)
{
$begin = $page*$onpage; // откуда начинать
$sql = "SELECT * FROM ".$table." WHERE field='$field' AND date_pub BETWEEN subdate(now(), interval 650 day) AND now() ORDER BY date_pub DESC LIMIT ".$begin.", ".$onpage;
//echo $sql;
$result = mysql_query($sql) or die(mysql_error());
return $result;
}
function navigation($onpage, $page, $table, $field)
{
$return = null;
$count = mysql_query("SELECT COUNT(*) FROM $table WHERE field='$field'") or die(mysql_error());
$count = mysql_fetch_array($count);
$count = $count[0];
$pages = round($count/$onpage)-1;
if($page!==0){
$prev = "<< ";
$prevlast = "|<-- ";
} else {
$prev = "<<";
$prevlast = "||<--";
}
if($page>> ";
$nextlast = "-->| ";
} else {
$next = ">>";
$nextlast = "-->||";
}
// for($i=0;$i<10;$i++)
$pagemin=$page-3;
if ($pagemin<0) { $pagemin=0; };
$pagemax=$page+4;
if ($pagemax>$pages) { $pagemax=$pages; };
for($i=$pagemin;$i<$pagemax;$i++)
{
if($i==$page){
$return.="[".($i+1)."]";
} else {
// $return.="[".($i+1)."]";
$return.="[".($i+1)."]";
}
}
$page++;
return $return."
\n".$prevlast." ".$prev." ".$page." ".$next." ".$nextlast;
}
?>
".$i." | ".stripslashes($data['aphorism'])." | ".$my->aphorism_tema($data['tema'], aph_tema);
if (empty($data['tema2'])<>true) { echo ", ".$my->aphorism_tema($data['tema2'], aph_tema); };
if (empty($data['tema3'])<>true) { echo ", ".$my->aphorism_tema($data['tema3'], aph_tema); };
echo " | ";
echo "";
$i_num=0;
// $my->sql_close();
// $my->sql_connect_copy();
$aSQL = "SELECT count(*) FROM aph_love WHERE id_aph='".$data['nomber']."'";
$aQResult = mysql_query($aSQL);
$row = mysql_fetch_array ($aQResult);
if (mysql_error()) { print(mysql_error()); }
$i_num=$row[0];
// $my->sql_close_copy();
// $my->sql_connect();
echo $i_num;
echo " | ";
echo "Удалить | ";
echo "[".$my->date_rus(substr($data['data'], 0, 10))."] | ";
echo "\n";
*/
?>