Новости-
";
while ($data=dbarray($result))
{
$cid=$data['comment_id'];
$comment=$data['comment_message'];
$news_id=$data['comment_item_id'];
$i=1;
$poryadkov_num=0;
$zap=dbquery("SELECT * FROM ".DB_COMMENTS." WHERE comment_item_id='$news_id' AND comment_type='N'");
while ($comment_id_zap=dbarray($zap))
{
if ($comment_id_zap['comment_id']==$cid){$poryadkov_num=$i;}
$i++;
}
$start_c=abs(ceil(($poryadkov_num/10)-1)*10);
$newsq=dbarray(dbquery("SELECT * FROM ".DB_NEWS." WHERE news_id=".$news_id." "));
$comment1=trimlink(strip_tags(parseubb($comment)),110);
$user_id=$data['comment_name'];
if (isnum($user_id)){
$userq=dbquery("SELECT * FROM ".DB_USERS." WHERE user_id=".$user_id."");
if (dbrows($userq)) {
$userqd = dbarray($userq);
$user = $userqd['user_name'];}
} else {
$user = $user_id;
};
$nc=$nc."".$user.": ".parsesmileys($comment1)."
";
}
$nc=$nc."
";
}
else {$nc="";}
$news_id=0;
$start_c=0;
$result = dbquery("SELECT * FROM ".DB_COMMENTS." WHERE comment_type='A' ORDER BY comment_datestamp DESC LIMIT 0,5");
if (dbrows($result)!=0)
{
$ac="Статьи-
";
while ($data=dbarray($result))
{
$cid=$data['comment_id'];
$comment=$data['comment_message'];
$news_id=$data['comment_item_id'];
$i=1;
$poryadkov_num=0;
$zap=dbquery("SELECT * FROM ".DB_COMMENTS." WHERE comment_item_id='$news_id' AND comment_type='A'");
while ($comment_id_zap=dbarray($zap))
{
if ($comment_id_zap['comment_id']==$cid){$poryadkov_num=$i;}
$i++;
}
$start_c=abs(ceil(($poryadkov_num/10)-1)*10);
$newsq=dbarray(dbquery("SELECT * FROM ".DB_ARTICLES." WHERE article_id=".$news_id.""));
$comment1=trimlink(strip_tags(parseubb($comment)),110);
$user_id=$data['comment_name'];
if (isnum($user_id)){
$userq=dbquery("SELECT * FROM ".DB_USERS." WHERE user_id=".$user_id."");
if (dbrows($userq)) {
$userqd = dbarray($userq);
$user = $userqd['user_name'];}
} else {
$user = $user_id;
};
$ac=$ac."".$user.": ".parsesmileys($comment1)."
";
}
$ac=$ac."
";
}
else {$ac="";}
$news_id=0;
$start_c=0;
$result = dbquery("SELECT * FROM ".DB_COMMENTS." WHERE comment_type='P' ORDER BY comment_datestamp DESC LIMIT 0,5");
if (dbrows($result)!=0)
{
$ic="Картинки-
";
while ($data=dbarray($result))
{
$cid=$data['comment_id'];
$comment=$data['comment_message'];
$news_id=$data['comment_item_id'];
$i=1;
$poryadkov_num=0;
$zap=dbquery("SELECT * FROM ".DB_COMMENTS." WHERE comment_item_id='$news_id' AND comment_type='P'");
while ($comment_id_zap=dbarray($zap))
{
if ($comment_id_zap['comment_id']==$cid){$poryadkov_num=$i;}
$i++;
}
$start_c=abs(ceil(($poryadkov_num/10)-1)*10);
$newsq=dbarray(dbquery("SELECT * FROM ".DB_PHOTOS." WHERE photo_id=".$news_id.""));
$comment1=trimlink(strip_tags(parseubb($comment)),110);
$user_id=$data['comment_name'];
if (isnum($user_id)){
$userq=dbquery("SELECT * FROM ".DB_USERS." WHERE user_id=".$user_id."");
if (dbrows($userq)) {
$userqd = dbarray($userq);
$user = $userqd['user_name'];}
} else {
$user = $user_id;
};
$ic=$ic."".$user.": ".parsesmileys($comment1)."
";
}
$ic=$ic."
";
}
else {$ic="";}
$start_c=0;
$news_id=0;
$result = dbquery("SELECT * FROM ".DB_COMMENTS." WHERE comment_type='F' ORDER BY comment_datestamp DESC LIMIT 0,15");
if (dbrows($result)!=0)
{
$fc="Файлы-
";
while ($data=dbarray($result))
{
$cid=$data['comment_id'];
$comment=$data['comment_message'];
$news_id=$data['comment_item_id'];
$i=1;
$poryadkov_num=0;
$zap=dbquery("SELECT * FROM ".DB_COMMENTS." WHERE comment_item_id='$news_id' AND comment_type='F'");
while ($comment_id_zap=dbarray($zap))
{
if ($comment_id_zap['comment_id']==$cid){$poryadkov_num=$i;}
$i++;
}
$start_c=abs(ceil(($poryadkov_num/10)-1)*10);
$newsq=dbarray(dbquery("SELECT * FROM ".DB_DOWNLOADS." WHERE download_id=".$news_id.""));
$comment1=trimlink(strip_tags(parseubb($comment)),110);
$user_id=$data['comment_name'];
if (isnum($user_id)){
$userq=dbquery("SELECT * FROM ".DB_USERS." WHERE user_id=".$user_id."");
if (dbrows($userq)) {
$userqd = dbarray($userq);
$user = $userqd['user_name'];}
} else {
$user = $user_id;
};
$fc=$fc."".$user.": ".parsesmileys($comment1)."
";
}
$fc=$fc."
";
}
else {$fc="";}
$news_id=0;
$start_c=0;
$result = dbquery("SELECT * FROM ".DB_COMMENTS." WHERE comment_type='C' ORDER BY comment_datestamp DESC LIMIT 0,5");
if (dbrows($result)!=0)
{
$cc="Страницы-
";
while ($data=dbarray($result))
{
$cid=$data['comment_id'];
$comment=$data['comment_message'];
$news_id=$data['comment_item_id'];
$i=1;
$poryadkov_num=0;
$zap=dbquery("SELECT * FROM ".DB_COMMENTS." WHERE comment_item_id='$news_id' AND comment_type='C'");
while ($comment_id_zap=dbarray($zap))
{
if ($comment_id_zap['comment_id']==$cid){$poryadkov_num=$i;}
$i++;
}
$start_c=abs(ceil(($poryadkov_num/10)-1)*10);
$newsq=dbarray(dbquery("SELECT * FROM ".DB_CUSTOM_PAGES." WHERE page_id =".$news_id.""));
$comment1=trimlink(strip_tags(parseubb($comment)),110);
$user_id=$data['comment_name'];
if (isnum($user_id)){
$userq=dbquery("SELECT * FROM ".DB_USERS." WHERE user_id=".$user_id."");
if (dbrows($userq)) {
$userqd = dbarray($userq);
$user = $userqd['user_name'];}
} else {
$user = $user_id;
};
$cc=$cc."".$user.": ".parsesmileys($comment1)."
";
}
$cc=$cc."
";
}
else {$cc="";}
echo "".$nc;
echo $ac;
echo $ic;
echo $fc;
echo $cc;
echo " |
";
?>