Author: lesabotsy
Date: Thu May 31 11:49:21 2007
New Revision: 479
URL: http://svn.gna.org/viewcvs/phplinker?rev=479&view=rev
Log:
# 201
Suppression des requettes qui utilisent le champs categorized
Modified:
trunk/www/admin/url_add.php
trunk/www/admin/url_edit.php
Modified: trunk/www/admin/url_add.php
URL:
http://svn.gna.org/viewcvs/phplinker/trunk/www/admin/url_add.php?rev=479&r1=478&r2=479&view=diff
==============================================================================
--- trunk/www/admin/url_add.php (original)
+++ trunk/www/admin/url_add.php Thu May 31 11:49:21 2007
@@ -48,16 +48,14 @@
if(mysql_num_rows($know_second)!=0){
$sms = "Ce liens existe déjà";
}else{
- $insert_db = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"INSERT INTO
url (id, url, description, state, categorized, hit , last_update, email) VALUES
('', '".$url."', '".$description."', '".$state."', 0 , 0 , '".date("Y-m-d
h:i:s")."', '".$email."')");
+ $insert_db = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"INSERT INTO
url (id, url, description, state, hit, last_update, email) VALUES ('',
'".$url."', '".$description."', '".$state."', 0 , '".date("Y-m-d h:i:s")."',
'".$email."')");
if (isset($_GET['categ_checked'])){
$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($_GET['categ_checked'] as $value){
$update_cat_url =
sql_query('die',__FILE__,__LINE__,__FUNCTION__,"INSERT INTO url2category
(id_url, id_category) VALUES (".$id_url.",".$value.")");
}
- $qry = "UPDATE url SET categorized = '1' WHERE id = ".$id_url;
- sql_query('die',__FILE__,__LINE__,__FUNCTION__,$qry);
- }
+ }
linker_log("[".$_SESSION['login'] ."]Insert URL url_".$id_url);
echo "<script language ='javascript'>window.location='url_add'</script>";
Modified: trunk/www/admin/url_edit.php
URL:
http://svn.gna.org/viewcvs/phplinker/trunk/www/admin/url_edit.php?rev=479&r1=478&r2=479&view=diff
==============================================================================
--- trunk/www/admin/url_edit.php (original)
+++ trunk/www/admin/url_edit.php Thu May 31 11:49:21 2007
@@ -45,7 +45,7 @@
// }
//*******************************
- $update_desc = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"UPDATE url
SET description=\"".utf8_decode($_GET["description"])."\", categorized = '0'
WHERE id=".$_GET["id"]);
+ $update_desc = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"UPDATE url
SET description=\"".utf8_decode($_GET["description"])."\" WHERE
id=".$_GET["id"]);
$categorized = 'uncategorized';
$up_cat = mysql_num_rows($select_test);
@@ -56,8 +56,6 @@
$update_cat_url =
sql_query('die',__FILE__,__LINE__,__FUNCTION__,"INSERT INTO url2category
(id_url, id_category) VALUES (".$_GET["id"].",".$value.")");
$values .= ($values=='')?$value:', '.$value;
}
- $qry = "UPDATE url SET categorized = '1' WHERE id = ".$_GET['id'];
- sql_query('die',__FILE__,__LINE__,__FUNCTION__,$qry);
$categorized = "categorized";
}
_______________________________________________
PHPLinker-commits mailing list
[email protected]
https://mail.gna.org/listinfo/phplinker-commits
