Johncms boyicha umumiy savollar

3339

Yangi formatda davom etish uchun: https://uzfor.net/view.php?id=736&page=128

Johncms bo'yicha umumiy savollar

Xabarlar

Besthakker [929] [off]
#2549 19:25:36, 17 Mar 2020

Sardor, # Sardor (17.03.2020 / 16:59)
Tasodifiy bitta xikoyani chiqaruvchi kod kerak
53 soniyadan keyin yozdi:
Yana bir narsa
xikoya.ru dagi kabi xikoya ishlash kodi ham

<?php
 
$tasodifiy = mysql_query("SELECT * FROM `library_texts` WHERE `premod` = '1' ORDER BY RAND() LIMIT 1");
while ($tasodif = mysql_fetch_array($tasodifiy)) {
echo '<div class="bmenu"> » <font color= #FF0000 >Tasodifiy Maqola</font> : <a href="../library/index.php?id=' . $tasodif['id'] . '">'.$tasodif['name'].'</a><div>'.$tasodif['announce'].'<a href="../library/index.php?id=' . $tasodif['id'] . '"> Davomi...</a></div></div>';
}
?>

+ (1): Qobilov_Sardor,

sobirjonovv [1587] [off]
#2551 14:13:51, 18 Mar 2020

news/index.php dan categorya ochib bo'lmayapti

. Kim biladi nima qilsam bo'ladi? Yoki kimdadir ishlaydigan news modi bormi? Ishlaydigani bo'lsa tashlanglar, ichida .sql fayli bo'lsa ayni muddao. Categorya ochib bo'mayotganini sababi menimcha qaysidur ustun yoq bazada. Shunga news.sql xam kerak. Ijobiy mandan

@uMansurov [418] [off]
#2552 14:25:01, 18 Mar 2020

Mahmudjon, # Mahmudjon (18.03.2020 / 14:13)
news/index.php dan categorya ochib bo'lmayapti

. Kim biladi nima qilsam bo'ladi? Yoki kimdadir ishlaydigan news modi bormi? Ishlaydigani bo'lsa tashlanglar, ichida .sql fayli bo'lsa ayni muddao. Catview.php?act=post&id=70019 shu modni ozini ishlatsangiz ham boladi kategoriya uchun ichidagi sql.sql ni zalit qilsez kategoriya qowiladi. Sizdagi modga tablitsa qowilmagan

+ (1): sobirjonovv,

sobirjonovv [1587] [off]
#2556 15:27:35, 18 Mar 2020

Bu yerda 4 ta news chiqadigan qilishim kerak. Qayeridan limitni belgilayman?

// news
echo '<div class="header"><b>So\'ngi xabarlar</b></div>';
$count= mysql_query("select count(*)  from `cms_news` where `time`<='". time()."'");
$total= mysql_result($count,0);
if($total>0)
 
$trans_req= mysql_query("select * from `cms_news` where `time`<='". time()."' order by `time` desc limit $start, $kmess;");
 
while($trans_res= mysql_fetch_array($trans_req)){
$comm= mysql_result( mysql_query("select count(*)  from `cms_news_comments` where `refid` = '".$trans_res['id']."'"),0);
$ncount = mysql_fetch_array(mysql_query("SELECT * FROM `cms_news` WHERE `id` ='$id'"));
if (!isset($_SESSION['cms_news']) || isset($_SESSION['cms_news'])&&$_SESSION['cms_news'] != $id) {
$_SESSION['cms_news'] = $id;
$newscount = intval($ncount['count'])   1;
mysql_query("UPDATE `cms_news` SET `count` ='$newscount'WHERE `id` ='$id'");
}
 
 
 
$komm = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news_comments` WHERE `refid`='{$res['id']}'"), 0);
echo '<div class="yangilik">'; echo '<span class="newsTime time bottom">' . date('H:i', $trans_res['time']   (core::$system_set['timeshift']   core::$user_set['timeshift']) * 3600) . '</span> – <a href="/news/index.php?act=view&id='.$trans_res['id'].'">  '. htmlentities($trans_res['name'],ENT_QUOTES,'UTF-8').'</a> <img style="vertical-align: middle ! important;" src="/images/blue_comment.png" />  ' . $comm . '</div>';
  $i;
}
if($total>$kmess){
echo'<div class="yangilik" align="center"><p>'. functions::display_pagination('index.php?id='.$id.'&',$start,$total,$kmess).'</p></div>'; }

@uMansurov [418] [off]
#2557 15:34:41, 18 Mar 2020

Mahmudjon,

// news
echo '<div class="header"><b>So\'ngi xabarlar</b></div>';
$count= mysql_query("select count(*)  from `cms_news` where `time`<='". time()."'");
$total= mysql_result($count,0);
if($total>0)
$kmess=4
 
$trans_req= mysql_query("select * from `cms_news` where `time`<='". time()."' order by `time` desc limit $kmess;");
 
while($trans_res= mysql_fetch_array($trans_req)){
$comm= mysql_result( mysql_query("select count(*)  from `cms_news_comments` where `refid` = '".$trans_res['id']."'"),0);
$ncount = mysql_fetch_array(mysql_query("SELECT * FROM `cms_news` WHERE `id` ='$id'"));
if (!isset($_SESSION['cms_news']) || isset($_SESSION['cms_news'])&&$_SESSION['cms_news'] != $id) {
$_SESSION['cms_news'] = $id;
$newscount = intval($ncount['count'])   1;
mysql_query("UPDATE `cms_news` SET `count` ='$newscount'WHERE `id` ='$id'");
}
 
 
 
$komm = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news_comments` WHERE `refid`='{$res['id']}'"), 0);
echo '<div class="yangilik">'; echo '<span class="newsTime time bottom">' . date('H:i', $trans_res['time']   (core::$system_set['timeshift']   core::$user_set['timeshift']) * 3600) . '</span> – <a href="/news/index.php?act=view&id='.$trans_res['id'].'">  '. htmlentities($trans_res['name'],ENT_QUOTES,'UTF-8').'</a> <img style="vertical-align: middle ! important;" src="/images/blue_comment.png" />  ' . $comm . '</div>';
  $i;
}
if($total>$kmess){
echo'<div class="yangilik" align="center"><p>'. functions::display_pagination('index.php?id='.$id.'&',$start,$total,$kmess).'</p></div>'; }

sobirjonovv [1587] [off]
#2558 15:39:45, 18 Mar 2020

QAROQCHI, # QAROQCHI (18.03.2020 / 15:34)
Mahmudjon, // news
echo '<div class="header"><b>So\'ngi xabarlar</b></div>';
$count= mysql_query("select count(*) from `cms_news` where `time`<='". time()."'");
$total= mysql_result($count,0);
ifNechta komment bildirilganligini oldida, necha marta o'qilganini xam ko'rsatadigan qilish kerak. Qisqasi butsa.net day bo'lishi kerak.

@uMansurov [418] [off]
#2560 15:48:13, 18 Mar 2020

Mahmudjon,

// news
echo '<div class="header"><b>So\'ngi xabarlar</b></div>';
$count= mysql_query("select count(*)  from `cms_news` where `time`<='". time()."'");
$total= mysql_result($count,0);
if($total>0)
$kmess=4
 
$trans_req= mysql_query("select * from `cms_news` where `time`<='". time()."' order by `time` desc limit $kmess;");
 
while($trans_res= mysql_fetch_array($trans_req)){
$comm= mysql_result( mysql_query("select count(*)  from `cms_news_comments` where `refid` = '".$trans_res['id']."'"),0);
$ncount = mysql_fetch_array(mysql_query("SELECT * FROM `cms_news` WHERE `id` ='$id'"));
if (!isset($_SESSION['cms_news']) || isset($_SESSION['cms_news'])&&$_SESSION['cms_news'] != $id) {
$_SESSION['cms_news'] = $id;
$newscount = intval($ncount['count'])   1;
mysql_query("UPDATE `cms_news` SET `count` ='$newscount'WHERE `id` ='$id'");
}
 
 
 
$komm = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news_comments` WHERE `refid`='{$res['id']}'"), 0);
echo '<div class="yangilik">'; echo '<span class="newsTime time bottom">' . date('H:i', $trans_res['time']   (core::$system_set['timeshift']   core::$user_set['timeshift']) * 3600) . '</span> – <a href="/news/index.php?act=view&id='.$trans_res['id'].'">  '. htmlentities($trans_res['name'],ENT_QUOTES,'UTF-8').'</a> <img style="vertical-align: middle ! important;" src="/images/blue_comment.png" />  ' . $comm . ' - oqildi '.$trans_res['reads'].' </div>';
  $i;
}
if($total>$kmess){
echo'<div class="yangilik" align="center"><p>'. functions::display_pagination('index.php?id='.$id.'&',$start,$total,$kmess).'</p></div>'; }