Author: rhari
Date: Fri Jun 1 09:35:19 2007
New Revision: 491
URL: http://svn.gna.org/viewcvs/phplinker?rev=491&view=rev
Log:
#223 & #146
Modified:
trunk/www/admin/api/update_url_info.php
trunk/www/admin/url_add.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=491&r1=490&r2=491&view=diff
==============================================================================
--- trunk/www/admin/api/update_url_info.php (original)
+++ trunk/www/admin/api/update_url_info.php Fri Jun 1 09:35:19 2007
@@ -26,10 +26,20 @@
}
extract($_GET);
-if (!isset ($id)){
- echo ("error\t"._("Missing site ids"));
+if (!isset ($id) && !isset($url)){
+ echo ("error\t"._("You must specify the URL or the id of the website"));
exit;
}
+
+if (!isset ($url))
+ $url = '';
+else{
+ if (strpos($url,'http://') != 0 || strpos($url,'http://') === false)
+ $url = 'http://'.$url;
+}
+
+if (!isset ($id))
+ $id = -999;
if (!isset ($email)){
echo ("error\t"._("Missing webmaster email address"));
@@ -46,14 +56,6 @@
exit;
}
-$qry = "SELECT count(*) AS nb FROM url WHERE id = ".$id;
-$qry = sql_query('die',__FILE__,__LINE__,__FUNCTION__,$qry);
-$nb = mysql_result($qry, 0, "nb");
-if ($nb < 1){
- echo ("error\t"._("This id (".$id.") does not exist"));
- exit;
- }
-
if (!isset($category) or sizeof($category) == 0)
$categorized = 0;
else
@@ -63,39 +65,53 @@
$debug = 0;
}
-// echo 'url : '.$url.'<br>';
-// echo 'email : '.$email.'<br>';
-// echo 'description : '.utf8_decode($description).'<br>';
-// echo '<pre>';
-// print_r ($category);
-// echo '</pre>';
-// echo sizeof($category);
-
-$qry = "UPDATE url SET
+$qry = "SELECT count(*) AS nb FROM url WHERE id = ".$id." OR url LIKE
'".$url."'";
+$qry = sql_query('die',__FILE__,__LINE__,__FUNCTION__,$qry);
+$nb = mysql_result($qry, 0, "nb");
+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."')");
+ 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");
+ foreach($category as $value){
+ $qry = "SELECT count(*) AS nb FROM category WHERE id = ".$value;
+ $qry = sql_query('die',__FILE__,__LINE__,__FUNCTION__,$qry);
+ $nb_cat = mysql_result($qry, 0, "nb");
+ if (is_numeric($value) && $nb_cat > 0)
+ $update_cat_url =
sql_query('die',__FILE__,__LINE__,__FUNCTION__,"INSERT INTO url2category
(id_url, id_category) VALUES (".$id_url.",".$value.")");
+ }
+ }
+ linker_log("[API : ".$_SERVER['REMOTE_ADDR'] ."] Insert URL url_".$id_url);
+ }
+ else {
+ $qry = "UPDATE url SET
description = '".utf8_decode($description)."',
last_update = '".date("Y-m-d h:i:s")."'
WHERE
id = ".$id;
-sql_query('die',__FILE__,__LINE__,__FUNCTION__,$qry);
+ sql_query('die',__FILE__,__LINE__,__FUNCTION__,$qry);
-$qry = "UPDATE webmaster SET
+ $qry = "UPDATE webmaster SET
email = '".utf8_decode($email)."',
login = '".utf8_decode($login)."'
WHERE
id IN (SELECT id_webmaster FROM url WHERE id = ".$id.")";
-sql_query('die',__FILE__,__LINE__,__FUNCTION__,$qry);
+ sql_query('die',__FILE__,__LINE__,__FUNCTION__,$qry);
-if ($categorized == 1){
- $know_first = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"DELETE FROM
url2category WHERE id_url = ".$id);
- foreach($category as $value){
- $qry = "SELECT count(*) AS nb FROM category WHERE id = ".$value;
- $qry = sql_query('die',__FILE__,__LINE__,__FUNCTION__,$qry);
- $nb_cat = mysql_result($qry, 0, "nb");
- if (is_numeric($value) && $nb_cat > 0)
- $update_cat_url =
sql_query('die',__FILE__,__LINE__,__FUNCTION__,"INSERT INTO url2category
(id_url, id_category) VALUES (".$id.",".$value.")");
- }
+ if ($categorized == 1){
+ sql_query('die',__FILE__,__LINE__,__FUNCTION__,"DELETE FROM url2category
WHERE id_url = ".$id);
+ foreach($category as $value){
+ $qry = "SELECT count(*) AS nb FROM category WHERE id = ".$value;
+ $qry = sql_query('die',__FILE__,__LINE__,__FUNCTION__,$qry);
+ $nb_cat = mysql_result($qry, 0, "nb");
+ if (is_numeric($value) && $nb_cat > 0)
+ $update_cat_url =
sql_query('die',__FILE__,__LINE__,__FUNCTION__,"INSERT INTO url2category
(id_url, id_category) VALUES (".$id.",".$value.")");
+ }
+ }
+ linker_log("[API : ".$_SERVER['REMOTE_ADDR'] ."] Update URL url_".$id);
}
-
-linker_log("[API : ".$_SERVER['REMOTE_ADDR'] ."] Update URL url_".$id);
printf("OK");
?>
Modified: trunk/www/admin/url_add.php
URL:
http://svn.gna.org/viewcvs/phplinker/trunk/www/admin/url_add.php?rev=491&r1=490&r2=491&view=diff
==============================================================================
--- trunk/www/admin/url_add.php (original)
+++ trunk/www/admin/url_add.php Fri Jun 1 09:35:19 2007
@@ -32,6 +32,8 @@
if(isset($_GET["url"])){
$url =$_GET["url"];
+ if (strpos($url,'http://') != 0 || strpos($url,'http://') === false)
+ $url = 'http://'.$url;
}
if(isset($_GET["email"])){
_______________________________________________
PHPLinker-commits mailing list
[email protected]
https://mail.gna.org/listinfo/phplinker-commits
