Открыть Ответить

Модуль News сортировка сообщений

0.00

0.00

1
14.12.2009 18:14:24

Сейчас вывод новостей происходит так -последние новости почему то выводятся в самом низу странички.... хотя логически можно было бы предположить, что новые сообщения должны вытеснять вниз более старые. Видел похожую тему, но не помню было ли там решение -не могу найти нужный топик. Может кто ткнёт носом в код или топик?

SLAED CMS 4.2 Pro
PHP 5
Сервер в интернете
Статус
Гость
sheft
sheft
14.12.2009 19:13:32 14.12.2009 19:19:14

sheft, тоесть как это? Смайл - 01
Странно.
Проверьте MODULES/NEWS/INDEX.PHP
Функция function news()
Код:

} else {<br /> $caton = 1;<br /> $field = "";<br /> $order = (!$home) &#063; "WHERE time <= now() AND status!='0' ".$lang." ORDER BY time DESC" : "WHERE ihome='0' AND time <= now() AND status!='0' ".$lang." ORDER BY time DESC";<br /> $ordernum = (!$home) &#063; "time <= now() AND status!='0'" : "ihome='0' AND time <= now() AND status!='0'";<br /> $news_logo = ""._NEWS."";<br /> $pagetitle = "".$conf['defis']." $news_logo";<br /> }

должен точно соответствовать приведенному выше.
Если есть разница, то замените на этот...
Должен быть именно оператор сортировки в обратном порядке DESC...

Или сделаем еще проще, замените функцию целиком, чтобы не заморачиваться на этот код:
function news() {<br /> global $prefix, $db, $admin_file, $user, $conf, $confu, $confn, $home, $pagetitle, $currentlang;<br /> $lang = ($conf['multilingual']) &#063; "AND (c.language='$currentlang' OR c.language='')" : "";<br /> $newnum = user_news($user[3], $confn['newnum']);<br /> $sbest = (isset($_GET['best'])) &#063; 1 : 0;<br /> $shits = (isset($_GET['hits'])) &#063; 1 : 0;<br /> $scat = (isset($_GET['cat'])) &#063; $_GET['cat'] : 0;<br /> if ($sbest && $confn['newrate']) {<br /> $caton = 0;<br /> $field = "best=1&";<br /> $order = "WHERE time <= now() AND status!='0' ".$lang." ORDER BY score DESC";<br /> $ordernum = "time <= now() AND status!='0'";<br /> $news_logo = ""._BEST."";<br /> $pagetitle = "".$conf['defis']." "._NEWS." ".$conf['defis']." $news_logo";<br /> } elseif ($shits && $confn['newrate']) {<br /> $caton = 0;<br /> $field = "hits=1&";<br /> $order = "WHERE time <= now() AND status!='0' ".$lang." ORDER BY counter DESC";<br /> $ordernum = "time <= now() AND status!='0'";<br /> $news_logo = ""._POP."";<br /> $pagetitle = "".$conf['defis']." "._NEWS." ".$conf['defis']." $news_logo";<br /> } elseif ($scat) {<br /> $caton = 1;<br /> $field = "cat=$scat&";<br /> list($cat_title, $cat_description) = $db->sql_fetchrow($db->sql_query("SELECT title, description FROM ".$prefix."_categories WHERE id='$scat'"));<br /> $order = "WHERE catid='$scat' AND time <= now() AND status!='0' ".$lang." ORDER BY time DESC";<br /> $ordernum = "catid='$scat' AND time <= now() AND status!='0'";<br /> $pagetitle = "".$conf['defis']." "._NEWS." ".$conf['defis']." $cat_title";<br /> } else {<br /> $caton = 1;<br /> $field = "";<br /> $order = (!$home) &#063; "WHERE time <= now() AND status!='0' ".$lang." ORDER BY time DESC" : "WHERE ihome='0' AND time <= now() AND status!='0' ".$lang." ORDER BY time DESC";<br /> $ordernum = (!$home) &#063; "time <= now() AND status!='0'" : "ihome='0' AND time <= now() AND status!='0'";<br /> $news_logo = ""._NEWS."";<br /> $pagetitle = "".$conf['defis']." $news_logo";<br /> }<br /> head();<br /> if (!$home) {<br /> if ($scat) {<br /> menu($cat_title);<br /> } else {<br /> menu($news_logo);<br /> }<br /> if ($caton == 1) categories($conf['name'], $confn['newcol'], $confn['newsub'], $confn['newcatdesc'], $scat);<br /> }<br /> $num = isset($_GET['num']) &#063; intval($_GET['num']) : "1";<br /> $offset = ($num-1) * $newnum;<br /> $offset = intval($offset);<br /> $result = $db->sql_query("SELECT s.sid, s.catid, s.name, s.title, UNIX_TIMESTAMP(s.time) as formatted, s.hometext, s.comments, s.counter, s.acomm, s.score, s.ratings, c.id, c.title, c.description, c.img, u.user_name FROM ".$prefix."_stories AS s LEFT JOIN ".$prefix."_categories AS c ON (s.catid=c.id) LEFT JOIN ".$prefix."_users AS u ON (s.uid=u.user_id) ".$order." LIMIT $offset, $newnum");<br /> if ($db->sql_numrows($result) > 0) {<br /> while (list($sid, $catid, $uname, $stitle, $formatted, $hometext, $comments, $counter, $acomm, $score, $ratings, $cid, $ctitle, $cdescription, $cimg, $user_name) = $db->sql_fetchrow($result)) {<br /> $time = date(""._DATESTRING."", $formatted);<br /> $title = "<a href=\"index.php&#063;name=".$conf['name']."&op=view&id=$sid\" title=\"$stitle\">".$stitle."</a> ".new_graphic($formatted)."";<br /> $read = "<a href=\"index.php&#063;name=".$conf['name']."&op=view&id=$sid\" title=\"$stitle\">"._READMORE."</a>";<br /> $post = ($user_name) &#063; " "._POSTEDBY.": ".user_info($user_name, 1)."" : (($uname) &#063; " "._POSTEDBY.": ".$uname."" : " "._POSTEDBY.": ".$confu['anonym']."");<br /> $ndate = ($confn['newdate']) &#063; " "._DATE.": ".$time."" : "";<br /> $reads = ($confn['newread']) &#063; " "._READS.": ".$counter."" : "";<br /> if (!$acomm) {<br /> if ($comments == 0) {<br /> $comm = " <a href=\"index.php&#063;name=".$conf['name']."&op=view&id=$sid#$sid\" title=\"$stitle\">"._COMMENTS."</a>";<br /> } elseif ($comments == 1) {<br /> $comm = " <a href=\"index.php&#063;name=".$conf['name']."&op=view&id=$sid#$sid\" title=\"$stitle\">"._COMMENT.": $comments</a>";<br /> } elseif ($comments > 1) {<br /> $comm = " <a href=\"index.php&#063;name=".$conf['name']."&op=view&id=$sid#$sid\" title=\"$stitle\">"._COMMENTS.": $comments</a>";<br /> }<br /> } else {<br /> $comm = "";<br /> }<br /> $arating = " ".ajax_rating(0, $sid, $conf['name'], $ratings, $score)."";<br /> $print = " ".ad_print("index.php&#063;name=".$conf['name']."&op=printe&id=".$sid."")."";<br /> $admin = (is_moder($conf['name'])) &#063; " ".ad_edit("".$admin_file.".php&#063;op=news_add&id=".$sid."")."" : "";<br /> $cdescription = ($cdescription) &#063; $cdescription : $ctitle;<br /> $cimg = ($cimg) &#063; "<a href=\"index.php&#063;name=".$conf['name']."&cat=$cid\"><img src=\"images/categories/".$cimg."\" border=\"0\" alt=\"$cdescription\" title=\"$cdescription\" align=\"right\" hspace=\"10\" vspace=\"10\"></a>" : "";<br /> $link = "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><tr><td width=\"75%\" align=\"left\"><b>".$read."</b>".$post."".$ndate."".$reads."".$comm."</td><td>".$arating."</td><td align=\"right\">".$print."".$admin."</td></tr></table>";<br /> basic($cid, $cimg, $ctitle, $sid, $title, bb_decode($hometext, $conf['name']), $link, $read, $post, $ndate, $reads, $comm, $arating, $print, $admin);<br /> }<br /> num_article($conf['name'], $newnum, $field, "sid", "_stories", "catid", $ordernum);<br /> }<br /> foot();<br /> }

Группа
Супермодераторы
Пункты
1595
Регистрация
18.09.2008
Пол
Мужчина
Из
Россия
Предупреждения
Нет
GRAFLEKX
GRAFLEKX
3.92

3.92

14.12.2009 19:58:08

да в коде указана сортировка по убыванию, код верный, но такое ощущение что сортировка вообще не срабатывает. Добавил три сообщения подряд, два оказались в центре, одно в самом низу - http://silon.su

по какому принципу идут сообщения, не ясно...

<&#063;php<br /> # Copyright © 2005 - 2008 SLAED<br /> # Website: http://www.slaed.net<br /> <br /> if (!defined("MODULE_FILE")) {<br /> header("Location: ../../index.php");<br /> exit;<br /> }<br /> get_lang($conf['name']);<br /> include("config/config_news.php");<br /> <br /> function menu($logo) {<br /> global $conf, $confn;<br /> $home = "<a href=\"index.php&#063;name=".$conf['name']."\" title=\""._HOME."\">"._HOME."</a>";<br /> $best = ($confn['newrate']) &#063; "<a href=\"index.php&#063;name=".$conf['name']."&best=1\" title=\""._BEST."\">"._BEST."</a>" : "";<br /> $pop = ($confn['newrate']) &#063; "<a href=\"index.php&#063;name=".$conf['name']."&hits=1\" title=\""._POP."\">"._POP."</a>" : "";<br /> $liste = "<a href=\"index.php&#063;name=".$conf['name']."&op=liste\" title=\""._LIST."\">"._LIST."</a>";<br /> $add = ((is_user() && $confn['add'] == 1) || (!is_user() && $confn['addquest'] == 1)) &#063; "<a href=\"index.php&#063;name=".$conf['name']."&op=add\" title=\""._ADD."\">"._ADD."</a>" : "";<br /> $navi = "[ <a href=\"index.php&#063;name=".$conf['name']."\" title=\""._HOME."\">"._HOME."</a>";<br /> $navi .= ($confn['newrate']) &#063; " | <a href=\"index.php&#063;name=".$conf['name']."&best=1\" title=\""._BEST."\">"._BEST."</a> | <a href=\"index.php&#063;name=".$conf['name']."&hits=1\" title=\""._POP."\">"._POP."</a>" : "";<br /> $navi .= " | <a href=\"index.php&#063;name=".$conf['name']."&op=liste\" title=\""._LIST."\">"._LIST."</a>";<br /> $navi .= ((is_user() && $confn['add'] == 1) || (!is_user() && $confn['addquest'] == 1)) &#063; " | <a href=\"index.php&#063;name=".$conf['name']."&op=add\" title=\""._ADD."\">"._ADD."</a>" : "";<br /> $navi .= " ]";<br /> search($logo, $conf['name'], $navi, $home, $best, $pop, $liste, $add);<br /> }<br /> <br /> function news() {<br /> global $prefix, $db, $admin_file, $user, $conf, $confu, $confn, $home, $pagetitle;<br /> $cwhere = catmids($conf['name'], "s.catid");<br /> $newnum = user_news($user[3], $confn['newnum']);<br /> $sbest = (isset($_GET['best'])) &#063; 1 : 0;<br /> $shits = (isset($_GET['hits'])) &#063; 1 : 0;<br /> $scat = (isset($_GET['cat'])) &#063; intval($_GET['cat']) : 0;<br /> if ($sbest && $confn['newrate']) {<br /> $caton = 0;<br /> $field = "best=1&";<br /> $order = "WHERE s.time <= now() AND s.status!='0' ".$cwhere." ORDER BY s.score DESC";<br /> $ordernum = "time <= now() AND status!='0'";<br /> $news_logo = ""._BEST."";<br /> $pagetitle = "".$conf['defis']." "._NEWS." ".$conf['defis']." $news_logo";<br /> } elseif ($shits && $confn['newrate']) {<br /> $caton = 0;<br /> $field = "hits=1&";<br /> $order = "WHERE s.time <= now() AND s.status!='0' ".$cwhere." ORDER BY s.counter DESC";<br /> $ordernum = "time <= now() AND status!='0'";<br /> $news_logo = ""._POP."";<br /> $pagetitle = "".$conf['defis']." "._NEWS." ".$conf['defis']." $news_logo";<br /> } elseif ($scat) {<br /> $caton = 1;<br /> $field = "cat=$scat&";<br /> list($cat_title, $cat_description) = $db->sql_fetchrow($db->sql_query("SELECT title, description FROM ".$prefix."_categories WHERE id='$scat'"));<br /> $order = "WHERE s.catid='$scat' AND s.time <= now() AND s.status!='0' ".$cwhere." ORDER BY s.time DESC";<br /> $ordernum = "catid='$scat' AND time <= now() AND status!='0'";<br /> $pagetitle = "".$conf['defis']." "._NEWS." ".$conf['defis']." $cat_title";<br /> } else {<br /> $caton = 1;<br /> $field = "";<br /> $order = (!$home) &#063; "WHERE s.time <= now() AND s.status!='0' ".$cwhere." ORDER BY s.time DESC" : "WHERE s.ihome='0' AND s.time <= now() AND s.status!='0' ".$cwhere." ORDER BY s.time DESC";<br /> $ordernum = (!$home) &#063; "time <= now() AND status!='0'" : "ihome='0' AND time <= now() AND status!='0'";<br /> $news_logo = ""._NEWS."";<br /> $pagetitle = "".$conf['defis']." $news_logo";<br /> }<br /> head();<br /> if (!$home) {<br /> if ($scat) {<br /> menu($cat_title);<br /> } else {<br /> menu($news_logo);<br /> }<br /> if ($scat) templ("catlink", catlink($conf['name'], $scat, $confn['defis'], _NEWS));<br /> if ($caton == 1) categories($conf['name'], $confn['newcol'], $confn['newsub'], $confn['newcatdesc'], $scat);<br /> }<br /> $num = isset($_GET['num']) &#063; intval($_GET['num']) : "1";<br /> $offset = ($num-1) * $newnum;<br /> $offset = intval($offset);<br /> $result = $db->sql_query("SELECT s.sid, s.catid, s.name, s.title, UNIX_TIMESTAMP(s.time) as formatted, s.hometext, s.comments, s.counter, s.acomm, s.score, s.ratings, c.id, c.title, c.description, c.img, u.user_name FROM ".$prefix."_stories AS s LEFT JOIN ".$prefix."_categories AS c ON (s.catid=c.id) LEFT JOIN ".$prefix."_users AS u ON (s.uid=u.user_id) ".$order." LIMIT $offset, $newnum");<br /> if ($db->sql_numrows($result) > 0) {<br /> while (list($sid, $catid, $uname, $stitle, $formatted, $hometext, $comments, $counter, $acomm, $score, $ratings, $cid, $ctitle, $cdescription, $cimg, $user_name) = $db->sql_fetchrow($result)) {<br /> $time = date(_DATESTRING, $formatted);<br /> $title = "<a href=\"index.php&#063;name=".$conf['name']."&op=view&id=$sid\" title=\"$stitle\">".$stitle."</a> ".new_graphic($formatted)."";<br /> $read = "<a href=\"index.php&#063;name=".$conf['name']."&op=view&id=$sid\" title=\"$stitle\">"._READMORE."</a>";<br /> $post = ($user_name) &#063; " "._POSTEDBY.": ".user_info($user_name, 1)."" : (($uname) &#063; " "._POSTEDBY.": ".$uname."" : " "._POSTEDBY.": ".$confu['anonym']."");<br /> $ndate = ($confn['newdate']) &#063; " "._DATE.": ".$time."" : "";<br /> $reads = ($confn['newread']) &#063; " "._READS.": ".$counter."" : "";<br /> if (!$acomm) {<br /> if ($comments == 0) {<br /> $comm = " <a href=\"index.php&#063;name=".$conf['name']."&op=view&id=$sid#$sid\" title=\"$stitle\">"._COMMENTS."</a>";<br /> } elseif ($comments == 1) {<br /> $comm = " <a href=\"index.php&#063;name=".$conf['name']."&op=view&id=$sid#$sid\" title=\"$stitle\">"._COMMENT.": $comments</a>";<br /> } elseif ($comments > 1) {<br /> $comm = " <a href=\"index.php&#063;name=".$conf['name']."&op=view&id=$sid#$sid\" title=\"$stitle\">"._COMMENTS.": $comments</a>";<br /> }<br /> } else {<br /> $comm = "";<br /> }<br /> $arating = " ".ajax_rating(0, $sid, $conf['name'], $ratings, $score, "");<br /> $print = " ".ad_print("index.php&#063;name=".$conf['name']."&op=printe&id=".$sid."");<br /> $admin = (is_moder($conf['name'])) &#063; " ".add_menu($sid, "<a href=\"".$admin_file.".php&#063;op=news_add&id=".$sid."\" title=\""._FULLEDIT."\">"._FULLEDIT."</a>||<a href=\"".$admin_file.".php&#063;op=news_delete&id=".$sid."\" OnClick=\"return DelCheck(this, '"._DELETE." &quot;$stitle&quot;&#063;');\" title=\""._ONDELETE."\">"._ONDELETE."</a>") : "";<br /> $cdescription = ($cdescription) &#063; $cdescription : $ctitle;<br /> $cimg = ($cimg) &#063; "<a href=\"index.php&#063;name=".$conf['name']."&cat=$cid\"><img src=\"images/categories/".$cimg."\" border=\"0\" alt=\"$cdescription\" title=\"$cdescription\" align=\"right\" hspace=\"10\" vspace=\"10\"></a>" : "";<br /> $link = "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><tr><td width=\"75%\" align=\"left\"><b>".$read."</b>".$post."".$ndate."".$reads."".$comm."</td><td>".$arating."</td><td align=\"right\">".$print."".$admin."</td></tr></table>";<br /> basic($cid, $cimg, $ctitle, $sid, $title, bb_decode($hometext, $conf['name']), $link, $read, $post, $ndate, $reads, $comm, $arating, $print, $admin);<br /> }<br /> num_article($conf['name'], $newnum, $field, "sid", "_stories", "catid", $ordernum);<br /> }<br /> foot();<br /> }<br /> <br /> function liste() {<br /> global $prefix, $db, $pagetitle, $conf, $confu, $confn;<br /> $cwhere = catmids($conf['name'], "s.catid");<br /> $newlistnum = intval($confn['newlistnum']);<br /> $let = (!preg_match("/[^a-zA-Zа-яА-Я0-9]/", $_GET['let'])) &#063; $_GET['let'] : "";<br /> if ($let) {<br /> $field = "op=liste&let=".urlencode($let)."&";<br /> $pagetitle = "".$conf['defis']." "._NEWS." ".$conf['defis']." "._LIST." ".$conf['defis']." $let";<br /> $order = "WHERE UPPER(s.title) LIKE '".$let."%' AND s.time <= now() AND s.status!='0'";<br /> } else {<br /> $field = "op=liste&";<br /> $pagetitle = "".$conf['defis']." "._NEWS." ".$conf['defis']." "._LIST."";<br /> $order = "WHERE s.time <= now() AND s.status!='0'";<br /> }<br /> $num = isset($_GET['num']) &#063; intval($_GET['num']) : "1";<br /> $offset = ($num-1) * $newlistnum;<br /> $offset = intval($offset);<br /> $result = $db->sql_query("SELECT s.sid, s.catid, s.name, s.title, s.time, c.id, c.title, u.user_name FROM ".$prefix."_stories AS s LEFT JOIN ".$prefix."_categories AS c ON (s.catid=c.id) LEFT JOIN ".$prefix."_users AS u ON (s.uid=u.user_id) ".$order." ".$cwhere." ORDER BY time DESC LIMIT $offset, $newlistnum");<br /> head();<br /> menu(""._LIST."");<br /> if ($db->sql_numrows($result) > 0) {<br /> open();<br /> if ($confn['newletter']) letter($conf['name']);<br /> echo "<table width=\"100%\" border=\"0\" cellpadding=\"2\" cellspacing=\"1\" class=\"sort\" id=\"sort_id\"><tr>"<br /> ."<th>"._ID."</th><th>"._TITLE."</th><th>"._CATEGORY."</th><th>"._DATE."</th><th>"._POSTEDBY."</th></tr>";<br /> while (list($sid, $catid, $uname, $stitle, $time, $cid, $ctitle, $user_name) = $db->sql_fetchrow($result)) {<br /> $ctitle = (!$ctitle) &#063; ""._NO."" : "<a href=\"index.php&#063;name=".$conf['name']."&cat=$cid\" title=\"".$ctitle."\">".cutstr($ctitle, 10)."</a>";<br /> $post = ($user_name) &#063; user_info($user_name, 1) : (($uname) &#063; $uname : $confu['anonym']);<br /> echo "<tr class=\"bgcolor1\">"<br /> ."<td align=\"center\">".$sid."</td>"<br /> ."<td><a href=\"index.php&#063;name=".$conf['name']."&op=view&id=$sid\" title=\"".$stitle."\">".cutstr($stitle, 35)."</a></td>"<br /> ."<td align=\"center\">".$ctitle."</td>"<br /> ."<td align=\"center\">".format_time($time)."</td>"<br /> ."<td align=\"center\">".$post."</td></tr>";<br /> }<br /> echo "</table>";<br /> close();<br /> $ordernum = ($let) &#063; "UPPER(title) LIKE '".$let."%' AND time <= now() AND status!='0'" : "time <= now() AND status!='0'";<br /> num_article($conf['name'], $newlistnum, $field, "sid", "_stories", "catid", $ordernum);<br /> } else {<br /> warning(_NO_INFO, "", "", 2);<br /> }<br /> foot();<br /> }<br /> <br /> function printe() {<br /> global $prefix, $db, $pagetitle, $conf, $confn;<br /> $id = intval($_GET['id']);<br /> $cwhere = catmids($conf['name'], "catid");<br /> $result = $db->sql_query("SELECT title, time, hometext, bodytext FROM ".$prefix."_stories WHERE sid='$id' AND time <= now() AND status!='0' ".$cwhere."");<br /> if ($db->sql_numrows($result) == 1) {<br /> $db->sql_query("UPDATE ".$prefix."_stories SET counter=counter+1 WHERE sid='$id'");<br /> list($stitle, $date, $hometext, $bodytext) = $db->sql_fetchrow($result);<br /> get_theme_inc();<br /> $conf['defis'] = urldecode($conf['defis']);<br /> $title = "$stitle ".$conf['defis']." "._NEWS." ".$conf['defis']." ".$conf['sitename']."";<br /> $ptitle = "".format_time($date)." - ".$stitle."";<br /> $text = ($bodytext) &#063; "".bb_decode($hometext, $conf['name'])."<br /><br />".bb_decode($bodytext, $conf['name'])."" : bb_decode($hometext, $conf['name']);<br /> $url = ""._COMESFROM.": <a href=\"".$conf['homeurl']."\" title=\"".$conf['sitename']."\">".$conf['homeurl']."</a><br />"._THEURL.": <a href=\"".$conf['homeurl']."/index.php&#063;name=".$conf['name']."&op=view&id=$id\" title=\"".$stitle."\">".$conf['homeurl']."/index.php&#063;name=".$conf['name']."&op=view&id=$id</a>";<br /> prints($title, $ptitle, str_replace("[pagebreak]", "", $text), $url);<br /> } else {<br /> header("Location: index.php&#063;name=".$conf['name']."");<br /> }<br /> }<br /> <br /> function view() {<br /> global $prefix, $db, $admin_file, $conf, $confu, $confn, $pagetitle, $hometext, $bodytext;<br /> $id = (isset($_GET['id'])) &#063; intval($_GET['id']) : 0;<br /> $pag = (isset($_GET['pag'])) &#063; intval($_GET['pag']) : 0;<br /> $word = (isset($_GET['word'])) &#063; text_filter($_GET['word']) : "";<br /> $cwhere = catmids($conf['name'], "s.catid");<br /> $result = $db->sql_query("SELECT s.catid, s.name, s.title, s.time, s.hometext, s.bodytext, s.field, s.comments, s.counter, s.acomm, s.score, s.ratings, s.associated, c.id, c.title, c.description, c.img, u.user_name FROM ".$prefix."_stories AS s LEFT JOIN ".$prefix."_categories AS c ON (s.catid=c.id) LEFT JOIN ".$prefix."_users AS u ON (s.uid=u.user_id) WHERE s.sid = '$id' AND s.time <= now() AND s.status!='0' ".$cwhere."");<br /> if ($db->sql_numrows($result) == 1) {<br /> $db->sql_query("UPDATE ".$prefix."_stories SET counter=counter+1 WHERE sid='$id'");<br /> list($catid, $uname, $title, $time, $hometext, $bodytext, $field, $comments, $counter, $acomm, $score, $ratings, $associated, $cid, $ctitle, $cdescription, $cimg, $user_name) = $db->sql_fetchrow($result);<br /> $pagetitle = (intval($catid)) &#063; "".$conf['defis']." "._NEWS." ".$conf['defis']." $ctitle ".$conf['defis']." $title" : "".$conf['defis']." "._NEWS." ".$conf['defis']." $title";<br /> head();<br /> menu(_NEWS);<br /> if ($catid) templ("catlink", catlink($conf['name'], $catid, $confn['defis'], _NEWS));<br /> $fields = fields_out($field, $conf['name']);<br /> $fields = ($fields) &#063; "<br /><br />".$fields."" : "";<br /> $text = (!$bodytext) &#063; "".$hometext."".$fields."" : "".$hometext."<br /><br />".$bodytext."".$fields."";<br /> $conpag = explode("[pagebreak]", $text);<br /> $pageno = count($conpag);<br /> $pag = ($pag == "" || $pag < 1) &#063; 1 : $pag;<br /> if ($pag > $pageno) $pag = $pageno;<br /> $arrayelement = (int)$pag;<br /> $arrayelement--;<br /> $post = ($user_name) &#063; _POSTEDBY.": ".user_info($user_name, 1) : (($uname) &#063; _POSTEDBY.": ".$uname : _POSTEDBY.": ".$confu['anonym']);<br /> $ndate = ($confn['newdate']) &#063; " "._DATE.": ".format_time($time) : "";<br /> $reads = ($confn['newread']) &#063; " "._READS.": ".$counter."" : "";<br /> $arating = " ".ajax_rating(1, $id, $conf['name'], $ratings, $score, "");<br /> $print = " ".ad_print("index.php&#063;name=".$conf['name']."&op=printe&id=".$id."");<br /> $admin = (is_moder($conf['name'])) &#063; " ".add_menu($id, "<a href=\"".$admin_file.".php&#063;op=news_add&id=".$id."\" title=\""._FULLEDIT."\">"._FULLEDIT."</a>||<a href=\"".$admin_file.".php&#063;op=news_delete&id=".$id."\" OnClick=\"return DelCheck(this, '"._DELETE." &quot;$title&quot;&#063;');\" title=\""._ONDELETE."\">"._ONDELETE."</a>") : "";<br /> $cdescription = ($cdescription) &#063; $cdescription : $ctitle;<br /> $cimg = ($cimg) &#063; "<a href=\"index.php&#063;name=".$conf['name']."&cat=$cid\"><img src=\"images/categories/".$cimg."\" border=\"0\" alt=\"$cdescription\" title=\"$cdescription\" align=\"right\" hspace=\"10\" vspace=\"10\"></a>" : "";<br /> $link = "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><tr><td width=\"75%\" align=\"left\">".$post."".$ndate."".$reads."</td><td>".$arating."</td><td align=\"right\">".$print."".$admin."</td></tr></table>";<br /> basic($cid, $cimg, $ctitle, $id, search_color($title, $word), search_color(bb_decode($conpag[$arrayelement], $conf['name']), $word), $link, "", $post, $ndate, $reads, "", $arating, $print, $admin);<br /> num_pages($conf['name'], 1, $pageno, 1, "op=view&id=".$id."&");<br /> if ($confn['newassoc']) {<br /> if ($associated[strlen($associated)-1] == "-") $associated = substr($associated, 0, -1);<br /> $asso = str_replace("-", ",", $associated);<br /> $limit = intval($confn['newasocnum']);<br /> $result = $db->sql_query("SELECT sid, title, time FROM ".$prefix."_stories WHERE catid IN (".$asso.") AND sid!='$id' AND time <= now() AND status!='0' ORDER BY time DESC LIMIT 0, ".$limit."");<br /> if ($db->sql_numrows($result) > 0) {<br /> open();<br /> echo "<h2 style=\"margin: 0 0 5px 0;\">"._ASSTORY."</h2>"<br /> ."<table border=\"0\" cellspacing=\"0\" cellpadding=\"2\">";<br /> while(list($s_sid, $title, $time) = $db->sql_fetchrow($result)) {<br /> echo "<tr><td><a href=\"index.php&#063;name=".$conf['name']."&op=view&id=$s_sid\" title=\"$title\"><img src=\"".img_find("all/news")."\" border=\"0\"></a></td><td>".format_time($time)." - <a href=\"index.php&#063;name=".$conf['name']."&op=view&id=$s_sid\" title=\"$title\">$title</a></td></tr>";<br /> }<br /> echo "</table>";<br /> close();<br /> }<br /> }<br /> if (!$acomm) {<br /> echo "<a name=\"$id\"></a>";<br /> show_com($id);<br /> }<br /> foot();<br /> } else {<br /> header("Location: index.php&#063;name=".$conf['name']."");<br /> }<br /> }<br /> <br /> function add() {<br /> global $prefix, $db, $user, $conf, $confn, $confu, $pagetitle, $stop;<br /> $pagetitle = "".$conf['defis']." "._NEWS." ".$conf['defis']." "._ADD."";<br /> if ((is_user() && $confn['add'] == 1) || (!is_user() && $confn['addquest'] == 1)) {<br /> head();<br /> menu(""._ADD."");<br /> if ($stop) warning($stop, "", "", 1);<br /> $subject = save_text($_POST['subject']);<br /> $catid = intval($_POST['catid']);<br /> $hometext = save_text($_POST['hometext']);<br /> $bodytext = save_text($_POST['bodytext']);<br /> $field = fields_save($_POST['field']);<br /> $postname = text_filter(substr($_POST['postname'], 0, 25));<br /> if ($hometext) preview($subject, $hometext, $bodytext, $field, $conf['name']);<br /> warning(""._SUBMIT."", "", "", 2);<br /> open();<br /> echo "<form name=\"post\" action=\"index.php&#063;name=".$conf['name']."\" method=\"post\">";<br /> if (is_user()) {<br /> echo "<div class=\"left\">"._YOURNAME.":</div><div class=\"center\">".text_filter(substr($user[1], 0, 25))."</div>";<br /> } else {<br /> $postname = ($postname) &#063; $postname : $confu['anonym'];<br /> echo "<div class=\"left\">"._YOURNAME.":</div><div class=\"center\"><input type=\"text\" name=\"postname\" value=\"".$postname."\" size=\"65\" class=\"".$conf['style']."\"></div>";<br /> }<br /> echo "<div class=\"left\">"._TITLE.":</div><div class=\"center\"><input type=\"text\" name=\"subject\" value=\"".$subject."\" maxlength=\"80\" size=\"65\" class=\"".$conf['style']."\"></div>"<br /> ."<div class=\"left\">"._CATEGORY.":</div><div class=\"center\">".getcat($conf['name'], $catid, "catid", $conf['style'], "<option value=\"\">"._HOMECAT."</option>")."</div>"<br /> ."<div class=\"left\">"._TEXT.":</div><div class=\"center\">".textarea("1", "hometext", $hometext, $conf['name'], "5")."</div>"<br /> ."<div class=\"left\">"._ENDTEXT.":</div><div class=\"center\">".textarea("2", "bodytext", $bodytext, $conf['name'], "15")."</div>"<br /> ."".fields_in($field, $conf['name']).""<br /> ."".captcha_random().""<br /> ."<div class=\"button\"><select name=\"posttype\">"<br /> ."<option value=\"preview\">"._PREVIEW."</option>"<br /> ."<option value=\"save\">"._SEND."</option></select>"<br /> ."<input type=\"hidden\" name=\"op\" value=\"send\">"<br /> ." <input type=\"submit\" value=\""._OK."\" class=\"fbutton\"></div></form>";<br /> close();<br /> foot();<br /> } else {<br /> header("Location: index.php&#063;name=".$conf['name']."");<br /> }<br /> }<br /> <br /> function send() {<br /> global $prefix, $db, $user, $conf, $confn, $stop;<br /> if ((is_user() && $confn['add'] == 1) || (!is_user() && $confn['addquest'] == 1)) {<br /> $postname = text_filter(substr($_POST['postname'], 0, 25));<br /> $subject = save_text($_POST['subject']);<br /> $hometext = save_text($_POST['hometext']);<br /> $bodytext = save_text($_POST['bodytext']);<br /> $field = fields_save($_POST['field']);<br /> $catid = intval($_POST['catid']);<br /> if (!$subject) $stop = ""._CERROR."";<br /> if (!$hometext) $stop = ""._CERROR1."";<br /> if (!$postname && !is_user()) $stop = ""._CERROR3."";<br /> if (captcha_check()) $stop = ""._SECCODEINCOR."";<br /> if (!$stop && $_POST['posttype'] == "save") {<br /> $postid = (is_user()) &#063; intval($user[0]) : "";<br /> $postname = (!is_user()) &#063; $postname : "";<br /> $ip = getip();<br /> $db->sql_query("INSERT INTO ".$prefix."_stories (sid, catid, uid, name, title, time, hometext, bodytext, field, comments, counter, ihome, acomm, score, ratings, associated, ip_sender, status) VALUES (NULL, '$catid', '$postid', '$postname', '$subject', now(), '$hometext', '$bodytext', '$field', '0', '0', '0', '0', '0', '0', '0', '$ip', '0')");<br /> update_points(31);<br /> head();<br /> menu(""._ADD."");<br /> warning(""._SUBTEXT."", "&#063;name=".$conf['name']."", 10, 2);<br /> foot();<br /> } else {<br /> add();<br /> }<br /> } else {<br /> header("Location: index.php&#063;name=".$conf['name']."");<br /> }<br /> }<br /> <br /> switch($op) {<br /> default:<br /> news();<br /> break;<br /> <br /> case "liste":<br /> liste();<br /> break;<br /> <br /> case "printe":<br /> printe();<br /> break;<br /> <br /> case "view":<br /> view();<br /> break;<br /> <br /> case "add":<br /> add();<br /> break;<br /> <br /> case "send":<br /> send();<br /> break;<br /> }<br /> &#063;>

SLAED CMS 4.2 Pro
PHP 5
Сервер в интернете
Статус
Гость
sheft
sheft
14.12.2009 20:18:34

sheft, замените полностью Ваш код на этот:

<&#063;php<br /> # Copyright © 2005 - 2008 SLAED<br /> # Website: http://www.slaed.net<br /> <br /> if (!defined("MODULE_FILE")) {<br /> Header("Location: ../../index.php");<br /> exit;<br /> }<br /> get_lang($conf['name']);<br /> include("config/config_news.php");<br /> <br /> function menu($logo) {<br /> global $conf, $confn;<br /> $home = "<a href=\"index.php&#063;name=".$conf['name']."\" title=\""._HOME."\">"._HOME."</a>";<br /> $best = ($confn['newrate']) &#063; "<a href=\"index.php&#063;name=".$conf['name']."&best=1\" title=\""._BEST."\">"._BEST."</a>" : "";<br /> $pop = ($confn['newrate']) &#063; "<a href=\"index.php&#063;name=".$conf['name']."&hits=1\" title=\""._POP."\">"._POP."</a>" : "";<br /> $liste = "<a href=\"index.php&#063;name=".$conf['name']."&op=liste\" title=\""._LIST."\">"._LIST."</a>";<br /> $add = ((is_user() && $confn['add'] == 1) || (!is_user() && $confn['addquest'] == 1)) &#063; "<a href=\"index.php&#063;name=".$conf['name']."&op=add\" title=\""._ADD."\">"._ADD."</a>" : "";<br /> $navi = "[ <a href=\"index.php&#063;name=".$conf['name']."\" title=\""._HOME."\">"._HOME."</a>";<br /> $navi .= ($confn['newrate']) &#063; " | <a href=\"index.php&#063;name=".$conf['name']."&best=1\" title=\""._BEST."\">"._BEST."</a> | <a href=\"index.php&#063;name=".$conf['name']."&hits=1\" title=\""._POP."\">"._POP."</a>" : "";<br /> $navi .= " | <a href=\"index.php&#063;name=".$conf['name']."&op=liste\" title=\""._LIST."\">"._LIST."</a>";<br /> $navi .= ((is_user() && $confn['add'] == 1) || (!is_user() && $confn['addquest'] == 1)) &#063; " | <a href=\"index.php&#063;name=".$conf['name']."&op=add\" title=\""._ADD."\">"._ADD."</a>" : "";<br /> $navi .= " ]";<br /> search($logo, $conf['name'], $navi, $home, $best, $pop, $liste, $add);<br /> }<br /> <br /> function news() {<br /> global $prefix, $db, $admin_file, $user, $conf, $confu, $confn, $home, $pagetitle, $currentlang;<br /> $lang = ($conf['multilingual']) &#063; "AND (c.language='$currentlang' OR c.language='')" : "";<br /> $newnum = user_news($user[3], $confn['newnum']);<br /> $sbest = (isset($_GET['best'])) &#063; 1 : 0;<br /> $shits = (isset($_GET['hits'])) &#063; 1 : 0;<br /> $scat = (isset($_GET['cat'])) &#063; $_GET['cat'] : 0;<br /> if ($sbest && $confn['newrate']) {<br /> $caton = 0;<br /> $field = "best=1&";<br /> $order = "WHERE time <= now() AND status!='0' ".$lang." ORDER BY score DESC";<br /> $ordernum = "time <= now() AND status!='0'";<br /> $news_logo = ""._BEST."";<br /> $pagetitle = "".$conf['defis']." "._NEWS." ".$conf['defis']." $news_logo";<br /> } elseif ($shits && $confn['newrate']) {<br /> $caton = 0;<br /> $field = "hits=1&";<br /> $order = "WHERE time <= now() AND status!='0' ".$lang." ORDER BY counter DESC";<br /> $ordernum = "time <= now() AND status!='0'";<br /> $news_logo = ""._POP."";<br /> $pagetitle = "".$conf['defis']." "._NEWS." ".$conf['defis']." $news_logo";<br /> } elseif ($scat) {<br /> $caton = 1;<br /> $field = "cat=$scat&";<br /> list($cat_title, $cat_description) = $db->sql_fetchrow($db->sql_query("SELECT title, description FROM ".$prefix."_categories WHERE id='$scat'"));<br /> $order = "WHERE catid='$scat' AND time <= now() AND status!='0' ".$lang." ORDER BY time DESC";<br /> $ordernum = "catid='$scat' AND time <= now() AND status!='0'";<br /> $pagetitle = "".$conf['defis']." "._NEWS." ".$conf['defis']." $cat_title";<br /> } else {<br /> $caton = 1;<br /> $field = "";<br /> $order = (!$home) &#063; "WHERE time <= now() AND status!='0' ".$lang." ORDER BY time DESC" : "WHERE ihome='0' AND time <= now() AND status!='0' ".$lang." ORDER BY time DESC";<br /> $ordernum = (!$home) &#063; "time <= now() AND status!='0'" : "ihome='0' AND time <= now() AND status!='0'";<br /> $news_logo = ""._NEWS."";<br /> $pagetitle = "".$conf['defis']." $news_logo";<br /> }<br /> head();<br /> if (!$home) {<br /> if ($scat) {<br /> menu($cat_title);<br /> } else {<br /> menu($news_logo);<br /> }<br /> if ($caton == 1) categories($conf['name'], $confn['newcol'], $confn['newsub'], $confn['newcatdesc'], $scat);<br /> }<br /> $num = isset($_GET['num']) &#063; intval($_GET['num']) : "1";<br /> $offset = ($num-1) * $newnum;<br /> $offset = intval($offset);<br /> $result = $db->sql_query("SELECT s.sid, s.catid, s.name, s.title, UNIX_TIMESTAMP(s.time) as formatted, s.hometext, s.comments, s.counter, s.acomm, s.score, s.ratings, c.id, c.title, c.description, c.img, u.user_name FROM ".$prefix."_stories AS s LEFT JOIN ".$prefix."_categories AS c ON (s.catid=c.id) LEFT JOIN ".$prefix."_users AS u ON (s.uid=u.user_id) ".$order." LIMIT $offset, $newnum");<br /> if ($db->sql_numrows($result) > 0) {<br /> while (list($sid, $catid, $uname, $stitle, $formatted, $hometext, $comments, $counter, $acomm, $score, $ratings, $cid, $ctitle, $cdescription, $cimg, $user_name) = $db->sql_fetchrow($result)) {<br /> $time = date(""._DATESTRING."", $formatted);<br /> $title = "<a href=\"index.php&#063;name=".$conf['name']."&op=view&id=$sid\" title=\"$stitle\">".$stitle."</a> ".new_graphic($formatted)."";<br /> $read = "<a href=\"index.php&#063;name=".$conf['name']."&op=view&id=$sid\" title=\"$stitle\">"._READMORE."</a>";<br /> $post = ($user_name) &#063; " "._POSTEDBY.": ".user_info($user_name, 1)."" : (($uname) &#063; " "._POSTEDBY.": ".$uname."" : " "._POSTEDBY.": ".$confu['anonym']."");<br /> $ndate = ($confn['newdate']) &#063; " "._DATE.": ".$time."" : "";<br /> $reads = ($confn['newread']) &#063; " "._READS.": ".$counter."" : "";<br /> if (!$acomm) {<br /> if ($comments == 0) {<br /> $comm = " <a href=\"index.php&#063;name=".$conf['name']."&op=view&id=$sid#$sid\" title=\"$stitle\">"._COMMENTS."</a>";<br /> } elseif ($comments == 1) {<br /> $comm = " <a href=\"index.php&#063;name=".$conf['name']."&op=view&id=$sid#$sid\" title=\"$stitle\">"._COMMENT.": $comments</a>";<br /> } elseif ($comments > 1) {<br /> $comm = " <a href=\"index.php&#063;name=".$conf['name']."&op=view&id=$sid#$sid\" title=\"$stitle\">"._COMMENTS.": $comments</a>";<br /> }<br /> } else {<br /> $comm = "";<br /> }<br /> $arating = " ".ajax_rating(0, $sid, $conf['name'], $ratings, $score)."";<br /> $print = " ".ad_print("index.php&#063;name=".$conf['name']."&op=printe&id=".$sid."")."";<br /> $admin = (is_moder($conf['name'])) &#063; " ".ad_edit("".$admin_file.".php&#063;op=news_add&id=".$sid."")."" : "";<br /> $cdescription = ($cdescription) &#063; $cdescription : $ctitle;<br /> $cimg = ($cimg) &#063; "<a href=\"index.php&#063;name=".$conf['name']."&cat=$cid\"><img src=\"images/categories/".$cimg."\" border=\"0\" alt=\"$cdescription\" title=\"$cdescription\" align=\"right\" hspace=\"10\" vspace=\"10\"></a>" : "";<br /> $link = "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><tr><td width=\"75%\" align=\"left\"><b>".$read."</b>".$post."".$ndate."".$reads."".$comm."</td><td>".$arating."</td><td align=\"right\">".$print."".$admin."</td></tr></table>";<br /> basic($cid, $cimg, $ctitle, $sid, $title, bb_decode($hometext, $conf['name']), $link, $read, $post, $ndate, $reads, $comm, $arating, $print, $admin);<br /> }<br /> num_article($conf['name'], $newnum, $field, "sid", "_stories", "catid", $ordernum);<br /> }<br /> foot();<br /> }<br /> <br /> function liste() {<br /> global $prefix, $db, $pagetitle, $conf, $confu, $confn, $currentlang;<br /> $lang = ($conf['multilingual']) &#063; "AND (c.language='$currentlang' OR c.language='')" : "";<br /> $newlistnum = intval($confn['newlistnum']);<br /> $let = (!preg_match("/[^a-zA-Zа-яА-Я0-9]/", $_GET['let'])) &#063; $_GET['let'] : "";<br /> if ($let) {<br /> $field = "op=liste&let=".urlencode($let)."&";<br /> $pagetitle = "".$conf['defis']." "._NEWS." ".$conf['defis']." "._LIST." ".$conf['defis']." $let";<br /> $order = "WHERE UPPER(s.title) LIKE '".$let."%' AND time <= now() AND status!='0'";<br /> } else {<br /> $field = "op=liste&";<br /> $pagetitle = "".$conf['defis']." "._NEWS." ".$conf['defis']." "._LIST."";<br /> $order = "WHERE time <= now() AND status!='0'";<br /> }<br /> $num = isset($_GET['num']) &#063; intval($_GET['num']) : "1";<br /> $offset = ($num-1) * $newlistnum;<br /> $offset = intval($offset);<br /> $result = $db->sql_query("SELECT s.sid, s.catid, s.name, s.title, s.time, c.id, c.title, u.user_name FROM ".$prefix."_stories AS s LEFT JOIN ".$prefix."_categories AS c ON (s.catid=c.id) LEFT JOIN ".$prefix."_users AS u ON (s.uid=u.user_id) ".$order." ".$lang." ORDER BY time DESC LIMIT $offset, $newlistnum");<br /> head();<br /> menu(""._LIST."");<br /> if ($db->sql_numrows($result) > 0) {<br /> open();<br /> if ($confn['newletter']) letter($conf['name']);<br /> echo "<table width=\"100%\" border=\"0\" cellpadding=\"2\" cellspacing=\"1\" class=\"sort\" id=\"sort_id\"><tr>"<br /> ."<th>"._ID."</th><th>"._TITLE."</th><th>"._CATEGORY."</th><th>"._DATE."</th><th>"._POSTEDBY."</th></tr>";<br /> while (list($sid, $catid, $uname, $stitle, $time, $cid, $ctitle, $user_name) = $db->sql_fetchrow($result)) {<br /> $ctitle = (!$ctitle) &#063; ""._NO."" : "<a href=\"index.php&#063;name=".$conf['name']."&cat=$cid\" title=\"".$ctitle."\">".cutstr($ctitle, 10)."</a>";<br /> $post = ($user_name) &#063; user_info($user_name, 1) : (($uname) &#063; $uname : $confu['anonym']);<br /> echo "<tr class=\"bgcolor1\">"<br /> ."<td align=\"center\">".$sid."</td>"<br /> ."<td><a href=\"index.php&#063;name=".$conf['name']."&op=view&id=$sid\" title=\"".$stitle."\">".cutstr($stitle, 35)."</a></td>"<br /> ."<td align=\"center\">".$ctitle."</td>"<br /> ."<td align=\"center\">".format_time($time)."</td>"<br /> ."<td align=\"center\">".$post."</td></tr>";<br /> }<br /> echo "</table>";<br /> close();<br /> $ordernum = ($let) &#063; "UPPER(title) LIKE '".$let."%' AND time <= now() AND status!='0'" : "time <= now() AND status!='0'";<br /> num_article($conf['name'], $newlistnum, $field, "sid", "_stories", "catid", $ordernum);<br /> } else {<br /> warning(""._NO_INFO."", "", "", 2);<br /> }<br /> foot();<br /> }<br /> <br /> function printe() {<br /> global $prefix, $db, $pagetitle, $conf, $confn;<br /> $id = intval($_GET['id']);<br /> $result = $db->sql_query("SELECT title, time, hometext, bodytext FROM ".$prefix."_stories WHERE sid='$id' AND time <= now() AND status!='0'");<br /> if ($db->sql_numrows($result) == 1) {<br /> $db->sql_query("UPDATE ".$prefix."_stories SET counter=counter+1 WHERE sid='$id'");<br /> list($stitle, $date, $hometext, $bodytext) = $db->sql_fetchrow($result);<br /> get_theme_inc();<br /> $conf['defis'] = urldecode($conf['defis']);<br /> $title = "$stitle ".$conf['defis']." "._NEWS." ".$conf['defis']." ".$conf['sitename']."";<br /> $ptitle = "".format_time($date)." - ".$stitle."";<br /> $text = ($bodytext) &#063; "".bb_decode($hometext, $conf['name'])."<br /><br />".bb_decode($bodytext, $conf['name'])."" : bb_decode($hometext, $conf['name']);<br /> $url = ""._COMESFROM.": <a href=\"".$conf['homeurl']."\" title=\"".$conf['sitename']."\">".$conf['homeurl']."</a><br />"._THEURL.": <a href=\"".$conf['homeurl']."/index.php&#063;name=".$conf['name']."&op=view&id=$id\" title=\"".$stitle."\">".$conf['homeurl']."/index.php&#063;name=".$conf['name']."&op=view&id=$id</a>";<br /> prints($title, $ptitle, str_replace("[pagebreak]", "", $text), $url);<br /> } else {<br /> Header("Location: index.php&#063;name=".$conf['name']."");<br /> }<br /> }<br /> <br /> function view() {<br /> global $prefix, $db, $admin_file, $conf, $confu, $confn, $pagetitle, $hometext, $bodytext;<br /> $id = intval($_GET['id']);<br /> $pag = intval($_GET['pag']);<br /> $word = ($_GET['word']) &#063; text_filter($_GET['word']) : "";<br /> $result = $db->sql_query("SELECT s.sid, s.catid, s.name, s.title, s.time, s.hometext, s.bodytext, s.field, s.comments, s.counter, s.acomm, s.score, s.ratings, s.associated, c.id, c.title, c.description, c.img, u.user_name FROM ".$prefix."_stories AS s LEFT JOIN ".$prefix."_categories AS c ON (s.catid=c.id) LEFT JOIN ".$prefix."_users AS u ON (s.uid=u.user_id) WHERE sid = '$id' AND time <= now() AND status!='0'");<br /> if ($db->sql_numrows($result) == 1) {<br /> $db->sql_query("UPDATE ".$prefix."_stories SET counter=counter+1 WHERE sid='$id'");<br /> list($sid, $catid, $uname, $title, $time, $hometext, $bodytext, $field, $comments, $counter, $acomm, $score, $ratings, $associated, $cid, $ctitle, $cdescription, $cimg, $user_name) = $db->sql_fetchrow($result);<br /> $pagetitle = (intval($catid)) &#063; "".$conf['defis']." "._NEWS." ".$conf['defis']." $ctitle ".$conf['defis']." $title" : "".$conf['defis']." "._NEWS." ".$conf['defis']." $title";<br /> head();<br /> menu(""._NEWS."");<br /> $fields = fields_out($field, $conf['name']);<br /> $fields = ($fields) &#063; "<br /><br />".$fields."" : "";<br /> $text = (!$bodytext) &#063; "".$hometext."".$fields."" : "".$hometext."<br /><br />".$bodytext."".$fields."";<br /> $conpag = explode("[pagebreak]", $text);<br /> $pageno = count($conpag);<br /> $pag = ($pag == "" || $pag < 1) &#063; 1 : $pag;<br /> if ($pag > $pageno) $pag = $pageno;<br /> $arrayelement = (int)$pag;<br /> $arrayelement--;<br /> $post = ($user_name) &#063; ""._POSTEDBY.": ".user_info($user_name, 1)."" : (($uname) &#063; ""._POSTEDBY.": ".$uname."" : ""._POSTEDBY.": ".$confu['anonym']."");<br /> $ndate = ($confn['newdate']) &#063; " "._DATE.": ".format_time($time)."" : "";<br /> $reads = ($confn['newread']) &#063; " "._READS.": ".$counter."" : "";<br /> $arating = " ".ajax_rating(1, $sid, $conf['name'], $ratings, $score)."";<br /> $print = " ".ad_print("index.php&#063;name=".$conf['name']."&op=printe&id=".$sid."")."";<br /> $admin = (is_moder($conf['name'])) &#063; " ".ad_edit("".$admin_file.".php&#063;op=news_add&id=".$sid."")."" : "";<br /> $cdescription = ($cdescription) &#063; $cdescription : $ctitle;<br /> $cimg = ($cimg) &#063; "<a href=\"index.php&#063;name=".$conf['name']."&cat=$cid\"><img src=\"images/categories/".$cimg."\" border=\"0\" alt=\"$cdescription\" title=\"$cdescription\" align=\"right\" hspace=\"10\" vspace=\"10\"></a>" : "";<br /> $link = "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><tr><td width=\"75%\" align=\"left\">".$post."".$ndate."".$reads."</td><td>".$arating."</td><td align=\"right\">".$print."".$admin."</td></tr></table>";<br /> basic($cid, $cimg, $ctitle, $sid, search_color($title, $word), search_color(bb_decode($conpag[$arrayelement], $conf['name']), $word), $link, $read, $post, $ndate, $reads, $comm, $arating, $print, $admin);<br /> num_pages($conf['name'], 1, $pageno, 1, "op=view&id=".$id."&");<br /> if ($confn['newassoc']) {<br /> if ($associated[strlen($associated)-1] == "-") $associated = substr($associated, 0, -1);<br /> $asso = str_replace("-", ",", $associated);<br /> $limit = intval($confn['newasocnum']);<br /> $result = $db->sql_query("SELECT sid, title, time FROM ".$prefix."_stories WHERE catid IN (".$asso.") AND sid!='$sid' AND time <= now() AND status!='0' ORDER BY time DESC LIMIT 0, ".$limit."");<br /> if ($db->sql_numrows($result) > 0) {<br /> open();<br /> echo "<h2 style=\"margin: 0 0 5px 0;\">"._ASSTORY."</h2>"<br /> ."<table border=\"0\" cellspacing=\"0\" cellpadding=\"2\">";<br /> while(list($s_sid, $title, $time) = $db->sql_fetchrow($result)) {<br /> echo "<tr><td><a href=\"index.php&#063;name=".$conf['name']."&op=view&id=$s_sid\" title=\"$title\"><img src=\"".img_find("all/news")."\" border=\"0\"></a></td><td>".format_time($time)." - <a href=\"index.php&#063;name=".$conf['name']."&op=view&id=$s_sid\" title=\"$title\">$title</a></td></tr>";<br /> }<br /> echo "</table>";<br /> close();<br /> }<br /> }<br /> if (!$acomm) {<br /> echo "<a name=\"$sid\"></a>";<br /> show_com($sid);<br /> }<br /> foot();<br /> } else {<br /> Header("Location: index.php&#063;name=".$conf['name']."");<br /> }<br /> }<br /> <br /> function add() {<br /> global $prefix, $db, $user, $conf, $confn, $confu, $pagetitle, $stop;<br /> $pagetitle = "".$conf['defis']." "._NEWS." ".$conf['defis']." "._ADD."";<br /> if ((is_user() && $confn['add'] == 1) || (!is_user() && $confn['addquest'] == 1)) {<br /> head();<br /> menu(""._ADD."");<br /> if ($stop) warning($stop, "", "", 1);<br /> $subject = save_text($_POST['subject']);<br /> $catid = intval($_POST['catid']);<br /> $hometext = save_text($_POST['hometext']);<br /> $bodytext = save_text($_POST['bodytext']);<br /> $field = fields_save($_POST['field']);<br /> $postname = text_filter(substr($_POST['postname'], 0, 25));<br /> if ($hometext) preview($subject, $hometext, $bodytext, $field, $conf['name']);<br /> warning(""._SUBMIT."", "", "", 2);<br /> open();<br /> echo "<form name=\"post\" action=\"index.php&#063;name=".$conf['name']."\" method=\"post\">";<br /> if (is_user()) {<br /> echo "<div class=\"left\">"._YOURNAME.":</div><div class=\"center\">".text_filter(substr($user[1], 0, 25))."</div>";<br /> } else {<br /> $postname = ($postname) &#063; $postname : $confu['anonym'];<br /> echo "<div class=\"left\">"._YOURNAME.":</div><div class=\"center\"><input type=\"text\" name=\"postname\" value=\"".$postname."\" size=\"65\" class=\"".$conf['style']."\"></div>";<br /> }<br /> echo "<div class=\"left\">"._TITLE.":</div><div class=\"center\"><input type=\"text\" name=\"subject\" value=\"".$subject."\" maxlength=\"80\" size=\"65\" class=\"".$conf['style']."\"></div>"<br /> ."<div class=\"left\">"._CATEGORY.":</div><div class=\"center\"><select name=\"catid\" class=\"".$conf['style']."\">".getcat($conf['name'], $catid)."</select></div>"<br /> ."<div class=\"left\">"._TEXT.":</div><div class=\"center\">".textarea("1", "hometext", $hometext, $conf['name'], "5")."</div>"<br /> ."<div class=\"left\">"._ENDTEXT.":</div><div class=\"center\">".textarea("2", "bodytext", $bodytext, $conf['name'], "15")."</div>"<br /> ."".fields_in($field, $conf['name']).""<br /> ."".captcha_random().""<br /> ."<div class=\"button\"><select name=\"posttype\">"<br /> ."<option value=\"preview\">"._PREVIEW."</option>"<br /> ."<option value=\"save\">"._SEND."</option></select>"<br /> ."<input type=\"hidden\" name=\"op\" value=\"send\">"<br /> ." <input type=\"submit\" value=\""._OK."\" class=\"fbutton\"></div></form>";<br /> close();<br /> foot();<br /> } else {<br /> Header("Location: index.php&#063;name=".$conf['name']."");<br /> }<br /> }<br /> <br /> function send() {<br /> global $prefix, $db, $user, $conf, $confn, $stop;<br /> if ((is_user() && $confn['add'] == 1) || (!is_user() && $confn['addquest'] == 1)) {<br /> $postname = text_filter(substr($_POST['postname'], 0, 25));<br /> $subject = save_text($_POST['subject']);<br /> $hometext = save_text($_POST['hometext']);<br /> $bodytext = save_text($_POST['bodytext']);<br /> $field = fields_save($_POST['field']);<br /> $catid = intval($_POST['catid']);<br /> if (!$subject) $stop = ""._CERROR."";<br /> if (!$hometext) $stop = ""._CERROR1."";<br /> if (!$postname && !is_user()) $stop = ""._CERROR3."";<br /> if (captcha_check()) $stop = ""._SECCODEINCOR."";<br /> if (!$stop && $_POST['posttype'] == "save") {<br /> $postid = (is_user()) &#063; intval($user[0]) : "";<br /> $postname = (!is_user()) &#063; $postname : "";<br /> $ip = getip();<br /> $db->sql_query("INSERT INTO ".$prefix."_stories (sid, catid, uid, name, title, time, hometext, bodytext, field, comments, counter, ihome, acomm, score, ratings, associated, ip_sender, status) VALUES (NULL, '$catid', '$postid', '$postname', '$subject', now(), '$hometext', '$bodytext', '$field', '0', '0', '0', '0', '0', '0', '0', '$ip', '0')");<br /> update_points(31);<br /> head();<br /> menu(""._ADD."");<br /> warning(""._SUBTEXT."", "&#063;name=".$conf['name']."", 10, 2);<br /> foot();<br /> } else {<br /> add();<br /> }<br /> } else {<br /> Header("Location: index.php&#063;name=".$conf['name']."");<br /> }<br /> }<br /> <br /> switch($op) {<br /> default:<br /> news();<br /> break;<br /> <br /> case "liste":<br /> liste();<br /> break;<br /> <br /> case "printe":<br /> printe();<br /> break;<br /> <br /> case "view":<br /> view();<br /> break;<br /> <br /> case "add":<br /> add();<br /> break;<br /> <br /> case "send":<br /> send();<br /> break;<br /> <br /> case "save_com":<br /> save_com();<br /> break;<br /> }<br /> &#063;>

Группа
Супермодераторы
Пункты
1595
Регистрация
18.09.2008
Пол
Мужчина
Из
Россия
Предупреждения
Нет
GRAFLEKX
GRAFLEKX
3.92

3.92

14.12.2009 21:58:00

заменил, результат нулевой, сообщения выводятся в порядке далёком от нормального, по сути ничего не сменилось- два сообщения по центру, вторая по счёту новость на предпоследнем месте и самое последнее по дате сообщение в самом низу. Это может быть связано с шаблоном?

SLAED CMS 4.2 Pro
PHP 5
Сервер в интернете
Статус
Гость
sheft
sheft
14.12.2009 22:05:46 14.12.2009 22:08:11

sheft, хм, теоритически может, если у Вас там несколько переменных вывода контента вставлены.
Может быть всё, что угодно.
Попробуйте вывести через родной шаблон.
Тяжело конечно так рассуждать, нужно, в идеале, весь код Вашего сайта видеть.
Версий 4.2 было выпущено во множестве модификаций, и в каждой свои глюки.

Группа
Супермодераторы
Пункты
1595
Регистрация
18.09.2008
Пол
Мужчина
Из
Россия
Предупреждения
Нет
GRAFLEKX
GRAFLEKX
3.92

3.92

14.12.2009 22:38:26 14.12.2009 22:42:04

сменил шаблон на celestial - порядок новостей не изменился, тотже самый беспорядок, наверное всё таки шаблон не виноват.... версия слаеда кстати 4.3.2 pro, просто в меню выбора этой версии нет.

Статус
Гость
sheft
sheft
14.12.2009 22:51:36

sheft, интересно. ок, завтра посмотрю что там может быть.

Группа
Супермодераторы
Пункты
1595
Регистрация
18.09.2008
Пол
Мужчина
Из
Россия
Предупреждения
Нет
GRAFLEKX
GRAFLEKX
3.92

3.92

15.12.2009 03:04:36

Ладно попробую предположить. Была такая кака с про версией 3,0. Виной был хостинг, а точнее кодировка базы данных на сервере. Где некоторые таблицы базы не верно сортировались. Попробуйте поиграться с кодировкой.
Кстати какая сейчас на базу установлена?

Ещё как вариант, вы сильно намудрили с перестановкой статей по числам создания. Возможно одна из статей имеет неверную дату создания. Как пример у меня был раз случай, статья имела время создания 31.11.2019 00:00:00 при этом чудом стояла между нормальными.

Просмотрите все статьи вручном режиме.

Но может я и не прав. Смайл - 13

SLAED CMS 3.5 Pro
PHP 5
Сервер в интернете
Группа
Клиент
Пункты
51
Регистрация
26.02.2007
Пол
Мужчина
Из
Paradise
Предупреждения
Нет
keeber
keeber
4.28

4.28

15.12.2009 09:06:16 15.12.2009 09:14:06

про кодировку тоже уже подумал, база была в кодировке UTF-8 но при этом не отображался русский язык, новости на русском просто не добавлялись, на англ всё работало, в конфигах Slaeda был указан при этом UTF-8... Саппорт посоветовал тоже поиграться с кодировками, в итоге всё "заработало" при установке в конфиге движка $dbcode = "cp1251"; но база по прежнему в utf-8 в этом видимо и проблема...

Просмотрите все статьи вручном режиме. - этого я не понял..
в админке новости выводятся в порядке создания сверху вниз, сортировка по номеру.

как правильнее сделать? сохранить дамп базы, исправить все utf-8 на cp1251 и залить дамп по новой? или есть способы наживую заменить кодировку базы?

Статус
Гость
sheft
sheft

Всего: 14 на 2 страницах по 10 на каждой странице

1 2
Открыть Ответить
Хотите опробовать SLAED CMS в действии?
Идеи и предложения
Обратная связь
Подтверждение

Поделиться
QR-код