Баг :Bug with counting the number of pages in the category
Статус :Опубликовано
Серьёзность :Нормальное
Репортер :Amro 25-12-14 19:23
Обновил :Amro 25-12-14 20:11
КатегорияPages
Версия :175
Частота :Постоянно
Пофиксено в :
Детали :

Bug associated with the wrong condition L IKE in a SQL query in list.inc.php.

 $sql4 = sed_sql_query("SELECT COUNT(*) FROM $db_pages p, $db_structure s 
       WHERE p.page_cat=s.structure_code 
       AND s.structure_path LIKE '".$sed_cat[$i]['rpath']."%' 
       AND page_state=0 "); 

Fix

 $sql4 = sed_sql_query("SELECT COUNT(*) FROM $db_pages p, $db_structure s 
       WHERE p.page_cat=s.structure_code 
       AND (s.structure_path LIKE '".$sed_cat[$i]['rpath'].".%' OR s.structure_path = '".$sed_cat[$i]['rpath']."') 
       AND page_state=0 "); 

 

Затронутые части :list.inc.php

История и комментарии :

17-01-20 10:04   joshuaprice153

We need develop more strategies in this regard, thanks for sharing. I think we need to bring more ideas for this purpose. tree service

15-01-20 13:10   luciham20

Loving the information on this site five nights at freddy's 2 scratch, you have done great job on the information.