WAP Мастер Форум / ошибка в коде навигации

rrrre » 2011.01.13 21:38

Гемарой подскажи что за ошибка в коде

Вот этот код выводит неправельно навигацею

Код:

span style="color: #0000BB"><?php if ($_GET['post_id'] AND $_GET['user_id']) { $row = $db->super_query( "SELECT hash FROM " . PREFIX . "_subscribe WHERE news_id='{$_GET['post_id']}' AND user_id='{$_GET['user_id']}'" ); if ($row['hash'] == $_GET['hash']) { $db->query( "DELETE FROM " . PREFIX . "_subscribe WHERE news_id='{$_GET['post_id']}' AND user_id='{$_GET['user_id']}'" ); msgbox( $lang['all_info'], $lang['unsubscribe_ok']); } else { msgbox( $lang['all_info'], $lang['unsubscribe_err']); } } else { msgbox( $lang['all_info'], $lang['unsubscribe_err']); } break; default : $is_main = 0; $active = false; $user_query = ""; $thisdate = date ( "Y-m-d H:i:s", (time () + ($config['date_adjust'] * 60)) ); if (intval ( $config['no_date'] )) $where_date = " AND date < '" . $thisdate . "'"; else $where_date = ""; if ($config['allow_fixed']) $fixed = "fixed desc, "; else $fixed = ""; $config['news_number'] = intval ( $config['news_number'] ); $attachments = array (); $news_sort_by = ($config['news_sort']) ? $config['news_sort'] : "date"; $news_direction_by = ($config['news_msort']) ? $config['news_msort'] : "DESC"; $allow_list = explode ( ',', $user_group[$member_id['user_group']]['allow_cats'] ); if ($allow_list[0] != "all") { if ($config['allow_multi_category']) { $stop_list = "category regexp '[[:<:]](" . implode ( '|', $allow_list ) . ")[[:>:]]' AND "; } else { $stop_list = "category IN ('" . implode ( "','", $allow_list ) . "') AND "; } } else $stop_list = ""; function numb($sql_count){ GLOBAL $db,$_REQUEST,$config; $all=$db->super_query($sql_count); if(!$_REQUEST['cstart']){ $cst=ceil($all['count']/$config['news_number']); }else{ $cst=$_REQUEST['cstart']; }//var_dump($cstart,ceil($all['count']/$config['news_number'])); $cstart=ceil($all['count']/$config['news_number'])-$cst+1; return $cstart; } if ($user_group[$member_id['user_group']]['allow_short']) $stop_list = ""; $sql_count = "SELECT COUNT(*) as count FROM " . PREFIX . "_post WHERE {$stop_list}approve AND allow_main" . $where_date; numb($sql_count); $sql_select = "SELECT id, autor, date, short_story, SUBSTRING(full_story, 1, 15) as full_story, xfields, title, category, alt_name, comm_num, allow_comm, allow_rate, fixed, rating, vote_num, news_read, flag, editdate, editor, reason, view_edit, tags FROM " . PREFIX . "_post WHERE {$stop_list}approve AND allow_main" . $where_date . " ORDER BY " . $fixed . $news_sort_by . " " . $news_direction_by . " LIMIT " . $cstart . "," . $config['news_number']; $sql_news = "";?>

А вот этот выводит правельно, но ошибка появляется в категориях при клике на следующую страницу

Код:

span style="color: #0000BB"><?phpif ($_GET['post_id'] AND $_GET['user_id']) { $row = $db->super_query( "SELECT hash FROM " . PREFIX . "_subscribe WHERE news_id='{$_GET['post_id']}' AND user_id='{$_GET['user_id']}'" ); if ($row['hash'] == $_GET['hash']) { $db->query( "DELETE FROM " . PREFIX . "_subscribe WHERE news_id='{$_GET['post_id']}' AND user_id='{$_GET['user_id']}'" ); msgbox( $lang['all_info'], $lang['unsubscribe_ok']); } else { msgbox( $lang['all_info'], $lang['unsubscribe_err']); } } else { msgbox( $lang['all_info'], $lang['unsubscribe_err']); } break; default : $is_main = 0; $active = false; $user_query = ""; $thisdate = date ( "Y-m-d H:i:s", (time () + ($config['date_adjust'] * 60)) ); if (intval ( $config['no_date'] )) $where_date = " AND date < '" . $thisdate . "'"; else $where_date = ""; if ($config['allow_fixed']) $fixed = "fixed desc, "; else $fixed = ""; $config['news_number'] = intval ( $config['news_number'] ); $attachments = array (); $news_sort_by = ($config['news_sort']) ? $config['news_sort'] : "date"; $news_direction_by = ($config['news_msort']) ? $config['news_msort'] : "DESC"; $allow_list = explode ( ',', $user_group[$member_id['user_group']]['allow_cats'] ); if ($allow_list[0] != "all") { if ($config['allow_multi_category']) { $stop_list = "category regexp '[[:<:]](" . implode ( '|', $allow_list ) . ")[[:>:]]' AND "; } else { $stop_list = "category IN ('" . implode ( "','", $allow_list ) . "') AND "; } } else $stop_list = ""; if ($user_group[$member_id['user_group']]['allow_short']) $stop_list = ""; $sql_count = "SELECT COUNT(*) as count FROM " . PREFIX . "_post WHERE {$stop_list}approve AND allow_main" . $where_date; $all=$db->super_query($sql_count); if(!$_REQUEST['cstart']){ $_REQUEST['cstart']=ceil($all['count']/$config['news_number']); }//var_dump($cstart,ceil($all['count']/$config['news_number'])); $cstart=ceil($all['count']/$config['news_number'])-$_REQUEST['cstart']+1; $sql_select = "SELECT id, autor, date, short_story, SUBSTRING(full_story, 1, 15) as full_story, xfields, title, category, alt_name, comm_num, allow_comm, allow_rate, fixed, rating, vote_num, news_read, flag, editdate, editor, reason, view_edit, tags FROM " . PREFIX . "_post WHERE {$stop_list}approve AND allow_main" . $where_date . " ORDER BY " . $fixed . $news_sort_by . " " . $news_direction_by . " LIMIT " . $cstart . "," . $config['news_number']; $sql_news = "";?>

Nu3oN » 2011.01.14 06:58

напиши какую ошибку выдает

Nu3oN » 2011.01.14 07:18

Вроде что то исправил, пробуй

Код:

span style="color: #0000BB"><?php if ($_GET['post_id'] фтв $_GET['user_id']) { $row = $db -> super_query("SELECT hash FROM `".PREFIX."_subscribe` WHERE `news_id` = '".$_GET['post_id']."' AND `user_id` = '".$_GET['user_id']."';"); if ($row['hash'] == $_GET['hash']) { $db -> query("DELETE FROM `".PREFIX."_subscribe` WHERE `news_id` = '".$_GET['post_id']."' AND `user_id` = '".$_GET['user_id']."';"); msgbox( $lang['all_info'], $lang['unsubscribe_ok']); } else { msgbox( $lang['all_info'], $lang['unsubscribe_err']); } } else { msgbox($lang['all_info'], $lang['unsubscribe_err']); } break;default : $is_main = 0; $active = false; $user_query = null; $thisdate = date ('Y-m-d H:i:s', (time () + ($config['date_adjust'] * 60))); if ((int)$config['no_date']) { $where_date = " AND date < '".$thisdate."'"; } else { $where_date = null; } if ($config['allow_fixed']) { $fixed = 'fixed desc, '; } else { $fixed = null; } $config['news_number'] = (int)$config['news_number']; $attachments = array(); $news_sort_by = ($config['news_sort']) ? $config['news_sort'] : 'date'; $news_direction_by = ($config['news_msort']) ? $config['news_msort'] : 'DESC'; $allow_list = explode (',', $user_group[$member_id['user_group']]['allow_cats']); if ($allow_list[0] != 'all') { if ($config['allow_multi_category']) { $stop_list = "category regexp '[[:<:]](".implode ('|', $allow_list ).")[[:>:]]' AND "; } else { $stop_list = "category IN ('" . implode ( "','", $allow_list ) . "') AND "; } } else { $stop_list = null; function numb($sql_count) { global $db, $config; $all = $db -> super_query($sql_count); if(!$_REQUEST['cstart']){ $cst = ceil($all['count'] / $config['news_number']); } else { $cst=$_REQUEST['cstart']; } return ceil($all['count'] / $config['news_number']) - $cst + 1; } if ($user_group[$member_id['user_group']]['allow_short']) { $stop_list = null; } $sql_count = "SELECT COUNT(*) as count FROM `".PREFIX."_post` WHERE ".$stop_list."approve AND allow_main".$where_date; numb($sql_count); $sql_select = "SELECT id, autor, date, short_story, SUBSTRING(full_story, 1, 15) as full_story, xfields, title, category, alt_name, comm_num, allow_comm, allow_rate, fixed, rating, vote_num, news_read, flag, editdate, editor, reason, view_edit, tags FROM `".PREFIX."_post` WHERE ".$stop_lis."approve AND allow_main".$where_date." ORDER BY ".$fixed.$news_sort_by." ".$news_direction_by." LIMIT ".$cstart.", ".$config['news_number'].";"; $sql_news = null;?>

rrrre » 2011.01.14 18:20

ошибку он не выдовал просто скрипт должен сортировать публикации новые на самой последней странице, первый вариант кода почемуто их несортирует как нужно. Второй вариант кода сортирует но при переходе в категорию появляется ошибка

Nu3oN » 2011.01.14 19:18

включи отображение ошибок...

reeee » 2011.01.17 12:06

вот с твоим кодом сейчас синтаксическая ошибка. а которой в моем коде ошибок нет ошибку выдает сам скрипт типа на данной странице нет публикаций хотя они там есть

Gemorroj » 2011.01.17 12:22

в коде Nu3oN'а синтаксических ошибок нет.

reeee » 2011.01.18 14:02

извиняюсь значит у меня кривые руки. спасибо.

TLENS » 2011.01.22 15:40

reeee написал:
извиняюсь значит у меня кривые руки. спасибо.

Копируй код нажатием на цитирования. Если у тебя мобильный.
Просто опера-мини обрабатует   как двойной пробел.

wexc » 2011.01.23 21:35

спасиб