Author: rhari
Date: Fri Jun 1 10:32:00 2007
New Revision: 492
URL: http://svn.gna.org/viewcvs/phplinker?rev=492&view=rev
Log:
#223 & #146
Bug fix
Modified:
trunk/www/admin/api/update_url_info.php
trunk/www/admin/moderator.php
Modified: trunk/www/admin/api/update_url_info.php
URL:
http://svn.gna.org/viewcvs/phplinker/trunk/www/admin/api/update_url_info.php?rev=492&r1=491&r2=492&view=diff
==============================================================================
--- trunk/www/admin/api/update_url_info.php (original)
+++ trunk/www/admin/api/update_url_info.php Fri Jun 1 10:32:00 2007
@@ -65,14 +65,14 @@
$debug = 0;
}
-$qry = "SELECT count(*) AS nb FROM url WHERE id = ".$id." OR url LIKE
'".$url."'";
+$qry = "SELECT id FROM url WHERE id = ".$id." OR url LIKE '".$url."'";
$qry = sql_query('die',__FILE__,__LINE__,__FUNCTION__,$qry);
-$nb = mysql_result($qry, 0, "nb");
+$nb = mysql_num_rows($qry);
if ($nb < 1){
$qry_ins_webmaster = sql_query('die', __FILE__, __LINE__, __FUNCTION__,
"INSERT INTO webmaster (login, email) VALUES ('".$login."', '".$email."')");
$qry_get_id_webmaster = sql_query('die', __FILE__, __LINE__, __FUNCTION__,
"SELECT id FROM webmaster ORDER BY id DESC LIMIT 1");
$webmaster_id = mysql_result($qry_get_id_webmaster,0,"id");
- $insert_db = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"INSERT INTO url
(url, description, last_update, id_webmaster) VALUES ('".$url."',
'".$description."', '".date("Y-m-d h:i:s")."', '".$webmaster_id."')");
+ $insert_db = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"INSERT INTO url
(url, description, last_update, id_webmaster) VALUES ('".$url."',
'".utf8_decode($description)."', '".date("Y-m-d h:i:s")."',
'".$webmaster_id."')");
if ($categorized == 1){
$know_first = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"SELECT id
FROM url ORDER BY id DESC LIMIT 1");
$id_url = mysql_result($know_first,0,"id");
@@ -87,6 +87,7 @@
linker_log("[API : ".$_SERVER['REMOTE_ADDR'] ."] Insert URL url_".$id_url);
}
else {
+ $id = mysql_result($qry, 0, "id");
$qry = "UPDATE url SET
description = '".utf8_decode($description)."',
last_update = '".date("Y-m-d h:i:s")."'
Modified: trunk/www/admin/moderator.php
URL:
http://svn.gna.org/viewcvs/phplinker/trunk/www/admin/moderator.php?rev=492&r1=491&r2=492&view=diff
==============================================================================
--- trunk/www/admin/moderator.php (original)
+++ trunk/www/admin/moderator.php Fri Jun 1 10:32:00 2007
@@ -97,8 +97,12 @@
}
if(($action == "update") && isset($action) && isset($_GET['mod']) &&
$_GET['mod']!="Array" && $_GET["todo"]=="Refuser"){
foreach($_GET['mod'] as $value){
+ $qry_get_idwebmaster = "SELECT id_webmaster FROM url WHERE id = ".$value;
+ $qry_get_idwebmaster =
sql_query('die',__FILE__,__LINE__,__FUNCTION__,$qry_get_idwebmaster);
+ $id_webmaster = mysql_result($qry_get_idwebmaster, 0, "id_webmaster");
$update = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"DELETE FROM url
WHERE id=".$value);
$update2 = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"DELETE FROM
url2category WHERE id_url=".$value);
+ $update3 = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"DELETE FROM
webmaster WHERE id = ".$id_webmaster);
}
$sms = "ok";
}
_______________________________________________
PHPLinker-commits mailing list
[email protected]
https://mail.gna.org/listinfo/phplinker-commits
