Author: lesabotsy
Date: Mon Apr 30 08:43:32 2007
New Revision: 389
URL: http://svn.gna.org/viewcvs/phplinker?rev=389&view=rev
Log:
#201
Suppression du champs url.categorized et toutes ses références dans le code
Modified:
trunk/www/lib/category.php
trunk/www/lib/url.php
Modified: trunk/www/lib/category.php
URL:
http://svn.gna.org/viewcvs/phplinker/trunk/www/lib/category.php?rev=389&r1=388&r2=389&view=diff
==============================================================================
--- trunk/www/lib/category.php (original)
+++ trunk/www/lib/category.php Mon Apr 30 08:43:32 2007
@@ -519,13 +519,6 @@
}
return false;
}
-
-function linker_update_categories($id){
- if(linker_check_unsigned_int($id))
- $update_request = sql_query('die',__FILE__,__LINE__,__FUNCTION__,
- "UPDATE `url` SET `categorized` = '1' WHERE
`id` =".$id) ;
-}
-
function linker_category_tagged($id , $id_tag=-1){
if(linker_check_unsigned_int($id)){
Modified: trunk/www/lib/url.php
URL:
http://svn.gna.org/viewcvs/phplinker/trunk/www/lib/url.php?rev=389&r1=388&r2=389&view=diff
==============================================================================
--- trunk/www/lib/url.php (original)
+++ trunk/www/lib/url.php Mon Apr 30 08:43:32 2007
@@ -18,11 +18,11 @@
*/
?>
<?php
-function linker_get_urls_need_moderation(){
+function linker_get_urls_need_moderation($idf){
$urls=array();
$result=sql_query('die', __FILE__, __LINE__, __FUNCTION__,
- "SELECT id, url, description, state, hit,
date_format(last_update,'%d/%m/%Y') as last_update FROM url WHERE state
!='moderated' ORDER BY last_update ");
+ "SELECT id, url, description, state, hit,
date_format(last_update,'%d/%m/%Y') as last_update FROM url WHERE state !=
'moderated' ORDER BY last_update ");
$iter=0;
while($url = mysql_fetch_object($result)){
$categories=array();
@@ -67,33 +67,6 @@
return false;
}
-function linker_update_url($id,$description,$categories){
- if(is_numeric($id)){
- $r=sql_query('die', __FILE__, __LINE__, __FUNCTION__,
- "SELECT url FROM `url` WHERE id=$id ");
- $desc='';
- list($desc)=mysql_fetch_array($r);
-
- $res1=sql_query('die', __FILE__, __LINE__, __FUNCTION__,
- "DELETE FROM `url2category` WHERE id_url=$id ;");
-
- $categorized=0;
- foreach($categories as $i => $id_categ){
- $categorized=1;
- $res2=sql_query('die', __FILE__, __LINE__, __FUNCTION__,
- "INSERT INTO `url2category` SET id_url=$id ,
id_category=$id_categ ;");
- }
-
- $res3=sql_query('die', __FILE__, __LINE__, __FUNCTION__,
- "UPDATE url SET
description='".utf8_decode($description)."', categorized=$categorized,
last_update=NOW() WHERE id=$id ;");
-
- if($res1 && $res2 && $res3){
- linker_log("_user_".$_SESSION['id_user'] ." : mis à jour du site
$desc");
- return true;
- }
- }
- return false;
-}
function linker_accept_url($id){
if(is_numeric($id)){
@@ -119,13 +92,6 @@
return $nb_res;
}
-function linker_decategorized_url($id){
- if(is_numeric($id)){
- $qry = "UPDATE url SET categorized = 0 WHERE id = ".$id;
- sql_query('die', __FILE__, __LINE__, __FUNCTION__, $qry);
- }
-}
-
function linker_get_url_name($id){
if(is_numeric($id)){
$query = sql_query('die', __FILE__, __LINE__, __FUNCTION__,"SELECT url
FROM url WHERE id = ".$id);
_______________________________________________
PHPLinker-commits mailing list
[email protected]
https://mail.gna.org/listinfo/phplinker-commits
