Author: lesabotsy
Date: Wed May 2 07:23:01 2007
New Revision: 393
URL: http://svn.gna.org/viewcvs/phplinker?rev=393&view=rev
Log:
Rectification d'un bug de recherche lorsqu'on recherche dens une categories qui
n'a plus de sous-categ la recherche ne trouve qu'un seul site alors qu'il y en
a plusieur bug rectifié
Modified:
trunk/www/admin/url_search.php
Modified: trunk/www/admin/url_search.php
URL:
http://svn.gna.org/viewcvs/phplinker/trunk/www/admin/url_search.php?rev=393&r1=392&r2=393&view=diff
==============================================================================
--- trunk/www/admin/url_search.php (original)
+++ trunk/www/admin/url_search.php Wed May 2 07:23:01 2007
@@ -23,6 +23,7 @@
require("includes/auth.php");
require("includes/header.php");
require($linker_config['linker_php_pager']);
+$tst ="";
if(!isset($_GET["state1"])){
$_GET["state1"]="";
}
@@ -156,15 +157,21 @@
$categ_parents = linker_get_categories_tree_array();
$array_children=array();
$categ_children = linker_get_category_children($cat , $categ_parents,
$array_children, 1, 1,true);
- for ($i=0;$i<sizeof($categ_children);$i++) {
- $req_boucle = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"SELECT
id_url FROM url2category WHERE id_category=". $categ_children[$i]['id']);
- $id_categ = mysql_fetch_array($req_boucle);
- if($i==0){
- $all.= $id_categ['id_url'];
- }else{
- if(!empty($id_categ['id_url']))
- $all.= ",".$id_categ['id_url'];
- }
+ //print_r($categ_children);
+ for ($t=0;$t<sizeof($categ_children);$t++) {
+ $req_boucle = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"SELECT
id_url FROM url2category WHERE id_category=". $categ_children[$t]['id']);
+ $x=0;
+ while($id_categ = mysql_fetch_array($req_boucle)){
+ $tst = $tst." ".$id_categ['id_url'];
+ if($x==0){
+ $all.= $id_categ['id_url'];
+ }else{
+ if(!empty($id_categ['id_url']))
+ $all.= ",".$id_categ['id_url'];
+ $tst .= $id_categ['id_url'];
+ }
+ $x++;
+ }
}
$all = $all.")";
@@ -178,12 +185,11 @@
}
}
}
-//echo $all;
$simple_request = $state_request . $categorized_request . $key_request;
-//echo "SELECT id FROM url WHERE 1=1 " .$simple_request;
if(empty($simple_request)){
$result_for_all ="Pas de resultat pour cette requette";
}elseif(!empty($simple_request) || ($_GET['state']=="" &&
$_GET['categorized']=="none")){
+ //echo "SELECT id FROM url WHERE 1=1 " .$simple_request;
$qryCount = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"SELECT id FROM
url WHERE 1=1 " .$simple_request);
$nbr = mysql_num_rows($qryCount);
if(mysql_num_rows($qryCount)!=0){
_______________________________________________
PHPLinker-commits mailing list
[email protected]
https://mail.gna.org/listinfo/phplinker-commits
