';
echo $row['caption'];
echo '
';
// echo "';
$lines_counter=0;
while($subrow=mysql_fetch_array($sq_res))
{
$link='';
$imgs='';
if($subrow['group']==0)
{
$link=' href="?art='.$subrow['id'].'"';
}
else
{
$link=' onClick="CollapseExpand(\'cmb_'.$subrow['id'].'_more\');" class="cmb_group_header"';
//$imgs='
';
}
$lines_counter++;
if($lines_counter==3)
{
echo '
';
}
//echo "';
}
$lines_counter++;
if($lines_counter==3)
{
echo '
';
}
$lines_counter++;
if($lines_counter==3)
{
echo '';
}
echo ''.$subrow['caption'].'';
//////////////////////////
$ssubquery = "SELECT * FROM articles WHERE level > 1 AND father_group = '".$subrow['id']."'";
$ssq_res=mysql_query($ssubquery);
if(mysql_num_rows($ssq_res) > 0)
{
echo ' ';
}
if($lines_counter>=3)
{
echo '
';
}
echo '';
$slines_counter=0;
while($ssubrow=mysql_fetch_array($ssq_res))
{
$link='';
$imgs='';
//$imgs='';
if($ssubrow['group']==0)
{
$link=' href="?art='.$ssubrow['id'].'"';
$imgs='';
}
$slines_counter++;
if($slines_counter==3)
{
echo '
';
}
/////////////////////////
echo '';
if($ssubrow['group']==0)
{
$link=' href="?art='.$ssubrow['id'].'"';
$imgs='';
}
$slines_counter++;
if($slines_counter==3)
{
echo '';
}
echo ''.$ssubrow['caption'].'';
echo ' ';
}
if($slines_counter>=3)
{
echo '
';
}
echo 'ALL TABLES TURNCATED
'; $request="TRUNCATE TABLE articles"; $res=mysql_query($request); } elseif($_GET["art"]=='send_message') { $msg=$_GET["msg"]; $msg=str_replace("@@@","\n\n",$msg); mail("pelixm@list.ru", "Сообщение с сайта ugpro.pro",$msg, "From: feedback@ ugpro.ru \r\n" ."X-Mailer: PHP \r\n charset=utf-8/ " . phpversion()); mail("info@ugpro.pro", "Сообщение с сайта ugpro.pro",$msg, "From: feddback@ ugpro.ru \r\n" ."X-Mailer: PHP \r\n charset=utf-8/ " . phpversion()); echo ' Ваше обращение отправленно! В случае необходимости мы свяжемся с Вами по указанным Вами контактным данным.
Спасибо!';
}
elseif($_GET["art"]=='search')
{
$msg=$_GET["text"];
echo "
".$msg."
"; $query = "SELECT * from articles WHERE content LIKE '%".$msg."%'"; $q_res=mysql_query($query); if(mysql_num_rows($q_res) > 0) { while($row=mysql_fetch_array($q_res)) { echo "",$row['caption'].""; echo "
".strip_tags(substr($row['content'],0,500))."
"; } } } else { if ($_GET['act'] == 'save') { $req="SELECT MAX(back_number) AS back_number FROM art_backup WHERE id=".$_GET['art']; $res=mysql_query($req); $data=mysql_fetch_array($res); $data['back_number']=$data['back_number']+1; $req="INSERT INTO art_backup(id, caption, content, father_group, level, back_number) SELECT id, caption, content, father_group, level, ".$data['back_number']." AS back_number FROM articles WHERE id=".$_GET['art']; $res_save=mysql_query($req); $req="UPDATE articles SET content='".$_POST['content']."' WHERE id=".$_GET['art']; $res_save=mysql_query($req); echo 'saved and backuped ' . $data['back_number'] . ' ERR: ' . mysql_error(); } $request="SELECT * FROM articles WHERE id=".$_GET['art']; $res=mysql_query($request); if($_GET['act']=='edit') { echo ' '; } } ?>
