 |
|
|
| ';
$r=mysql_query("select id from feedbacks order by id");
$i=0;
while ($rec=mysql_fetch_array($r)){
$i++;
echo ' |
| ';
if ($i%4==0) echo '
|
';
}
echo ' ';
} elseif ($section==16) {
echo '
|
';
$r=mysql_query("select name$lang as name, txt$lang as txt, id from goals order by id desc");
while ($rec=mysql_fetch_array($r)){
echo '
 |
|
'.popup("goals/$rec[id].jpg",800,600).' |
|
|
 |
|
|
| '.$rec["name"].' |
|
| '.$rec["txt"].'
|
|
|
|
';
}
echo ' ';
} elseif ($section==14 || $section==15) {
echo '';
if ($section==15) {
if (!@$year) {
$rec=mqfa("select max(year) as year from projects");
$year=$rec["year"];
}
$r=mysql_query("select distinct year from projects where year>0 and name$lang<>'' order by year desc");
echo '
| ';
while ($rec=mysql_fetch_array($r)){
if ($rec["year"]!=$year) echo " $rec[year] |";
else echo " $rec[year] |";
}
echo ' |
|
|
';
$r=mysql_query("select id, name$lang as name, desc$lang as descr, date_format(dat,'%d.%m.%Y') as dat from projects where year=$year and name$lang<>'' order by projects.dat desc");
} else {
$r=mysql_query("select id, name$lang as name, desc$lang as descr, date_format(dat,'%d.%m.%Y') as dat from projects where year=0 and name$lang<>'' order by projects.dat desc");
}
echo mysql_error();
while ($rec=mysql_fetch_array($r)){
$rec2=mqfa("select id from pics where project=$rec[id]");
echo '
|
|
| '.$rec["name"].' |
|
';
$r2=mysql_query("select id from pics where project=$rec[id]");
while ($rec2=mysql_fetch_array($r2)) {
echo ' |
| ';
}
echo '
|
|
| '.$rec["descr"].' |
|
|
|
';
}
echo ' ';
} elseif ($section==9) {
$r=mysql_query("select intro$lang as intro, id, name$lang as name, txt$lang as txt from content where page=2 and id>9 order by id=12");
echo '
|
';
while ($rec=mysql_fetch_array($r)){
echo '
|
|
';
}
$rec=mqfa("select txt$lang as txt from content where id=$section");
echo '
| '.$rec["txt"].' |
';
} elseif ($section==6) {
echo '
';
$r=mysql_query("select id, link$lang as link from partners");
$i=0;
while ($rec=mysql_fetch_array($r)){
$i++;
echo ' |
| ';
if ($i%4==0) echo '
|
';
}
echo ' ';
} elseif ($section==4 && $section==5) {
$r=mysql_query("select id, name$lang as name, place$lang as place, phone, email from workers order by id");
echo '
|
';
$i=0;
while ($rec=mysql_fetch_array($r)) {
echo ' |
 |
| ';
$i++;
if ($i%2==0) echo '
|
'; else echo ' | ';
}
echo ' |
|
|
|
';
} elseif (($section==5 || $section==7 || $section==8 || $section==18) && !@$newid) {
if (!@$startfrom) $startfrom=0;
echo '
|
';
$r=mysql_query("select intro$lang as intro, id, name$lang as name, txt$lang as txt, date_format(dat,'%d.%m.%Y') as dat from news where section=$section and name$lang<>'' order by id desc ".($section==18 && $startfrom>-1?"limit ".($startfrom).",".($startfrom+$ipp):""));
while ($rec=mysql_fetch_array($r)) {
$rec["intro"]=strip_tags($rec["intro"]);
echo '
';
if ($section==5 || $page==5) echo '
|
|
';
echo ' |
|
|
';
}
echo ' ';
} else {
if (!@$newid)
$rec=mqfa("select txt$lang as txt from content where id=$section");
else $rec=mqfa("select txt$lang as txt from news where id=$newid");
echo $rec["txt"];
}
?>
|
':'