Author: rhari
Date: Thu May 31 09:59:14 2007
New Revision: 477
URL: http://svn.gna.org/viewcvs/phplinker?rev=477&view=rev
Log:
#223
Ajout de l'email du webmaster dans la table url
Modification du script affichage/ajout pour tenir compte de l'email
Modification de phplinker.sql pour integrer l'email du webmaster
Modified:
trunk/doc/phplinker.sql
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/doc/phplinker.sql
URL:
http://svn.gna.org/viewcvs/phplinker/trunk/doc/phplinker.sql?rev=477&r1=476&r2=477&view=diff
==============================================================================
--- trunk/doc/phplinker.sql (original)
+++ trunk/doc/phplinker.sql Thu May 31 09:59:14 2007
@@ -111,6 +111,7 @@
`state` enum('moderated','awaiting_submission_moderation',
'awaiting_update_moderation') collate utf8_bin NOT NULL default
'awaiting_submission_moderation',
`hit` int(11) NOT NULL,
`last_update` datetime NOT NULL,
+ `email` varchar(128) collate utf8_bin NOT NULL,
PRIMARY KEY (`id`),
KEY `state` (`state`),
KEY `hit` (`hit`),
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=477&r1=476&r2=477&view=diff
==============================================================================
--- trunk/smarty/default/templates/admin/url_add.tpl (original)
+++ trunk/smarty/default/templates/admin/url_add.tpl Thu May 31 09:59:14 2007
@@ -53,6 +53,10 @@
<td><b><input type="text" name="url"></b></td>
</tr>
<tr>
+ <td align="right" width="35%">Webmaster emails: </td>
+ <td><b><input type="text" name="email"></b></td>
+</tr>
+<tr>
<td align="right" valign="top">State: </td>
<td><b></b>
<select name="state">
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=477&r1=476&r2=477&view=diff
==============================================================================
--- trunk/smarty/default/templates/admin/url_edit.tpl (original)
+++ trunk/smarty/default/templates/admin/url_edit.tpl Thu May 31 09:59:14 2007
@@ -51,6 +51,10 @@
<tr>
<td align="right" width="35%">Url: </td>
<td><b><a href="{$url}" target="_blank">{$url}</a></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>
<tr>
Modified: trunk/www/admin/url_add.php
URL:
http://svn.gna.org/viewcvs/phplinker/trunk/www/admin/url_add.php?rev=477&r1=476&r2=477&view=diff
==============================================================================
--- trunk/www/admin/url_add.php (original)
+++ trunk/www/admin/url_add.php Thu May 31 09:59:14 2007
@@ -8,6 +8,7 @@
$action ="";
$description="";
$url ="";
+$email = "";
$sms ="";
$state ="";
$categ_id ="";
@@ -31,6 +32,11 @@
if(isset($_GET["url"])){
$url =$_GET["url"];
}
+
+if(isset($_GET["email"])){
+ $email =$_GET["email"];
+ }
+
if(isset($_GET["categ_id"])){
$categ_id = $_GET["categ_id"];
}
@@ -42,7 +48,7 @@
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) VALUES ('',
'".$url."', '".$description."', '".$state."', 0 , 0 , '".date("Y-m-d
h:i:s")."')");
+ $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."')");
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=477&r1=476&r2=477&view=diff
==============================================================================
--- trunk/www/admin/url_edit.php (original)
+++ trunk/www/admin/url_edit.php Thu May 31 09:59:14 2007
@@ -75,7 +75,7 @@
}
-$info_url = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"SELECT id, url,
description, hit, last_update, state FROM url WHERE id =".$_GET["id"]);
+$info_url = sql_query('die',__FILE__,__LINE__,__FUNCTION__,"SELECT id, url,
description, hit, last_update, state, email 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"]);
@@ -88,6 +88,7 @@
$url = $result_fetch["url"];
$description = $result_fetch["description"];
$id = $result_fetch["id"];
+$email = $result_fetch["email"];
?>
<?
$root=0;
@@ -179,6 +180,7 @@
linker_tpl("categ_ul_li", $categ_ul_li);
linker_tpl("id" , $id);
linker_tpl("url" , $url);
+ linker_tpl("email" , $email);
linker_tpl("description" , $description);
// linker_tpl("id_cat" , $id_cat);
linker_tpl("bc" , $bc);
_______________________________________________
PHPLinker-commits mailing list
[email protected]
https://mail.gna.org/listinfo/phplinker-commits
