Author: rhari
Date: Thu Jun 7 08:39:07 2007
New Revision: 522
URL: http://svn.gna.org/viewcvs/phplinker?rev=522&view=rev
Log:
#223
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=522&r1=521&r2=522&view=diff
==============================================================================
--- trunk/www/admin/moderator.php (original)
+++ trunk/www/admin/moderator.php Thu Jun 7 08:39:07 2007
@@ -107,7 +107,7 @@
$sms = "ok";
}
}
- $qryCount = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"SELECT url.id
FROM url WHERE state != 'moderated'");
+ $qryCount = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"SELECT url.id
FROM url,webmaster WHERE state != 'moderated' AND url.id_webmaster =
webmaster.id");
$nbr = mysql_num_rows($qryCount);
if($nbr > 0) {
while($id_loop = mysql_fetch_array($qryCount)){
Modified: trunk/www/admin/url_search.php
URL:
http://svn.gna.org/viewcvs/phplinker/trunk/www/admin/url_search.php?rev=522&r1=521&r2=522&view=diff
==============================================================================
--- trunk/www/admin/url_search.php (original)
+++ trunk/www/admin/url_search.php Thu Jun 7 08:39:07 2007
@@ -199,7 +199,7 @@
$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 url.id
as id FROM url WHERE 1=1 " .$simple_request);
+ $qryCount = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"SELECT url.id
as id FROM url,webmaster WHERE 1=1 AND url.id_webmaster = webmaster.id "
.$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
