Author: rhari
Date: Tue Jun 5 14:36:57 2007
New Revision: 510
URL: http://svn.gna.org/viewcvs/phplinker?rev=510&view=rev
Log:
#234
Bug fix
Modified:
trunk/www/admin/moderator.php
trunk/www/admin/url_search.php
Modified: trunk/www/admin/moderator.php
URL:
http://svn.gna.org/viewcvs/phplinker/trunk/www/admin/moderator.php?rev=510&r1=509&r2=510&view=diff
==============================================================================
--- trunk/www/admin/moderator.php (original)
+++ trunk/www/admin/moderator.php Tue Jun 5 14:36:57 2007
@@ -109,10 +109,9 @@
}
$qryCount = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"SELECT url.id
FROM url WHERE state != 'moderated'");
$nbr = mysql_num_rows($qryCount);
- if(mysql_num_rows($qryCount)!=0){
-
+ if($nbr > 0) {
while($id_loop = mysql_fetch_array($qryCount)){
- $qryChange = mysql_query("SELECT id_url, id_category FROM url2category
WHERE `id_url`= ".$id_loop['id']) or die(mysql_query());
+ $qryChange = sql_query ('die',__FILE__,__LINE__,__FUNCTION__,"SELECT
id_url, id_category FROM url2category WHERE `id_url`= ".$id_loop['id']);
$arrayChange = mysql_fetch_array($qryChange);
$qryCount = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"SELECT
count(*) as nb FROM url,webmaster WHERE url.id_webmaster=webmaster.id AND state
!= 'moderated'");
if ($t_count = mysql_fetch_array($qryCount))
@@ -142,9 +141,10 @@
// echo $test_for_this."<br>";
if(isset($arrayChange["id_category"])){
if($test_for_this > 1){
- $category_name = "";
+ $category_name = "";
for($x=0;$x<$test_for_this;$x++){
- $category_name = $category_name .
linker_path($arrayChange["id_category"])." <br> ";
+ $id_categ = mysql_result($qryChange,$x,"id_category");
+ $category_name = $category_name . linker_path($id_categ)."
<br> ";
}
}else{
$category_name = linker_path($arrayChange["id_category"]);
Modified: trunk/www/admin/url_search.php
URL:
http://svn.gna.org/viewcvs/phplinker/trunk/www/admin/url_search.php?rev=510&r1=509&r2=510&view=diff
==============================================================================
--- trunk/www/admin/url_search.php (original)
+++ trunk/www/admin/url_search.php Tue Jun 5 14:36:57 2007
@@ -204,7 +204,7 @@
if(mysql_num_rows($qryCount)!=0){
while($id_loop = mysql_fetch_array($qryCount)){
- $qryChange = mysql_query("SELECT id_url, id_category FROM url2category
WHERE `id_url`= ".$id_loop['id']) or die(mysql_query());
+ $qryChange = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"SELECT
id_url, id_category FROM url2category WHERE `id_url`= ".$id_loop['id']);
$arrayChange = mysql_fetch_array($qryChange);
$qryCount = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"SELECT
count(*) as nb FROM url,webmaster WHERE 1=1 AND url.id_webmaster=webmaster.id
" .$simple_request);
if ($t_count = mysql_fetch_array($qryCount))
_______________________________________________
PHPLinker-commits mailing list
[email protected]
https://mail.gna.org/listinfo/phplinker-commits
