Author: rhari
Date: Thu May 31 14:43:52 2007
New Revision: 487
URL: http://svn.gna.org/viewcvs/phplinker?rev=487&view=rev
Log:
#223
Prise en compte de login et email dans url_add et url_edit
Modified:
trunk/smarty/default/templates/admin/url_add.tpl
trunk/smarty/default/templates/admin/url_edit.tpl
trunk/www/admin/url_add.php
trunk/www/admin/url_edit.php
Modified: trunk/smarty/default/templates/admin/url_add.tpl
URL:
http://svn.gna.org/viewcvs/phplinker/trunk/smarty/default/templates/admin/url_add.tpl?rev=487&r1=486&r2=487&view=diff
==============================================================================
--- trunk/smarty/default/templates/admin/url_add.tpl (original)
+++ trunk/smarty/default/templates/admin/url_add.tpl Thu May 31 14:43:52 2007
@@ -53,7 +53,11 @@
<td><b><input type="text" name="url"></b></td>
</tr>
<tr>
- <td align="right" width="35%">Webmaster email: </td>
+ <td align="right" width="35%">Webmaster logins: </td>
+ <td><b><input type="text" name="login"></b></td>
+</tr>
+<tr>
+ <td align="right" width="35%">Webmaster emails: </td>
<td><b><input type="text" name="email"></b></td>
</tr>
<tr>
Modified: trunk/smarty/default/templates/admin/url_edit.tpl
URL:
http://svn.gna.org/viewcvs/phplinker/trunk/smarty/default/templates/admin/url_edit.tpl?rev=487&r1=486&r2=487&view=diff
==============================================================================
--- trunk/smarty/default/templates/admin/url_edit.tpl (original)
+++ trunk/smarty/default/templates/admin/url_edit.tpl Thu May 31 14:43:52 2007
@@ -53,7 +53,11 @@
<td><b><a href="{$url}" target="_blank">{$url}</a></b></td>
</tr>
<tr>
- <td align="right" width="35%">Webmaster email: </td>
+ <td align="right" width="35%">Webmaster logins: </td>
+ <td><b>{$login}</b></td>
+ </tr>
+<tr>
+ <td align="right" width="35%">Webmaster emails: </td>
<td><b><a href="mailto:{$email}";
target="_blank">{$email}</a></b></td>
</tr>
Modified: trunk/www/admin/url_add.php
URL:
http://svn.gna.org/viewcvs/phplinker/trunk/www/admin/url_add.php?rev=487&r1=486&r2=487&view=diff
==============================================================================
--- trunk/www/admin/url_add.php (original)
+++ trunk/www/admin/url_add.php Thu May 31 14:43:52 2007
@@ -9,6 +9,7 @@
$description="";
$url ="";
$email = "";
+$login = "";
$sms ="";
$state ="";
$categ_id ="";
@@ -37,18 +38,25 @@
$email =$_GET["email"];
}
+if(isset($_GET["login"])){
+ $login =$_GET["login"];
+ }
+
if(isset($_GET["categ_id"])){
$categ_id = $_GET["categ_id"];
}
if($action == "insert" && $action !=""){
- if(($url=="") || ($description=="") ||(is_numeric($url) == true)
||(is_numeric($description) == true) || ($email=="")){
+ if(($url=="") || ($description=="") ||(is_numeric($url) == true)
||(is_numeric($description) == true) || ($email=="") || ($login=="")){
$sms = "des zones sont restée vides<br> Veuillez remplir
correctement le formulaire";
}else{
$know_second = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"SELECT id
FROM url WHERE url = '".$url."'");
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, hit, last_update, email) VALUES ('',
'".$url."', '".$description."', '".$state."', 0 , '".date("Y-m-d h:i:s")."',
'".$email."')");
+ $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 (id, url, description, state, hit, last_update, id_webmaster) VALUES ('',
'".$url."', '".$description."', '".$state."', 0 , '".date("Y-m-d h:i:s")."',
'".$webmaster_id."')");
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");
Modified: trunk/www/admin/url_edit.php
URL:
http://svn.gna.org/viewcvs/phplinker/trunk/www/admin/url_edit.php?rev=487&r1=486&r2=487&view=diff
==============================================================================
--- trunk/www/admin/url_edit.php (original)
+++ trunk/www/admin/url_edit.php Thu May 31 14:43:52 2007
@@ -45,7 +45,7 @@
// }
//*******************************
- $update_desc = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"UPDATE url
SET description=\"".utf8_decode($_GET["description"])."\" WHERE
id=".$_GET["id"]);
+ $update_desc = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"UPDATE url
SET description=\"".utf8_decode($_GET["description"])."\", categorized = '0'
WHERE id=".$_GET["id"]);
$categorized = 'uncategorized';
$up_cat = mysql_num_rows($select_test);
@@ -56,6 +56,8 @@
$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";
}
@@ -73,20 +75,23 @@
}
-$info_url = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"SELECT id, url,
description, hit, last_update, state, email FROM url WHERE id =".$_GET["id"]);
+$info_url = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"SELECT id, url,
description, hit, last_update, state, id_webmaster FROM url WHERE id
=".$_GET["id"]);
$result_fetch = mysql_fetch_array($info_url);
$qryListCateg = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"SELECT
id_category FROM url2category WHERE id_url =".$_GET["id"]);
-
+$qryGetWebmaster = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"SELECT id,
login, email FROM webmaster WHERE id = ".$result_fetch['id_webmaster']);
+$res_webmaster = mysql_fetch_array ($qryGetWebmaster);
if(mysql_num_rows($qryListCateg) !=0){
$categstochecked = array();
while ($line = mysql_fetch_array($qryListCateg))
$categstochecked[] = $line['id_category'];
}
+$id_webmaster = $result_fetch["id_webmaster"];
$url = $result_fetch["url"];
$description = $result_fetch["description"];
$id = $result_fetch["id"];
-$email = $result_fetch["email"];
+$email = $res_webmaster["email"];
+$login = $res_webmaster["login"];
?>
<?
$root=0;
@@ -178,6 +183,7 @@
linker_tpl("categ_ul_li", $categ_ul_li);
linker_tpl("id" , $id);
linker_tpl("url" , $url);
+ linker_tpl("login" , $login);
linker_tpl("email" , $email);
linker_tpl("description" , $description);
// linker_tpl("id_cat" , $id_cat);
_______________________________________________
PHPLinker-commits mailing list
[email protected]
https://mail.gna.org/listinfo/phplinker-commits
