Баг :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

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

15-05-20 01:03   Samantha Lock

Be one drop of the ocean.

ac repair San Diego   ac repair Chula Vista    ac repair Santee

12-02-20 11:00   shipfromca

ShipFromCA allows you to reserve oc 5 – 80 mg online without RX to cast off your ache. Opioid analgesic is the brand name for oxycontin containing the active factor oxycodone. The same is also observed in Percocet and Percodan. If you are stricken by ache with cancer, backache, or arthritis, then Oxycontin could be a powerful medicine for you. Buy Oxycontin online from ShipFromCA pharmacy.

08-02-20 01:14   leo1122

see site | our site 

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.