Changeset 10973 for extensions/Copyrights/admin.php

Timestamp:

May 21, 2011, 2:02:37 PM (13 years ago)

Author:

J.Commelin

Message:

Added the 'Description' field to Copyrights

File:

• extensions/Copyrights/admin.php (modified) (6 diffs)

extensions/Copyrights/admin.php

@@ -38 +38 @@
 $CRname = '';
 $CRurl = '';
+$CRdesc = '';
 $CRvisible = 0;
 
@@ -45 +46 @@
     $name = pwg_db_real_escape_string($_REQUEST['name']);
     $url = pwg_db_real_escape_string($_REQUEST['url']);
+    $desc = pwg_db_real_escape_string($_REQUEST['desc']);
     $visible = (isset($_REQUEST['visible']) ? 1 : 0);
     $query = sprintf(
       'INSERT INTO %s
-      (`name`,`url`,`visible`) VALUES
-      ("%s","%s",%d)
+      (`name`,`url`,`des`,`visible`) VALUES
+      ("%s","%s","%s",%d)
       ;',
-      COPYRIGHTS_ADMIN, $name, $url, $visible);
+      COPYRIGHTS_ADMIN, $name, $url, $desc, $visible);
     pwg_query($query);
   }
@@ -68 +70 @@
     $CRname = $row['name'];
     $CRurl = $row['url'];
+    $CRdesc = $row['desc'];
     $CRvisible = $row['visible'];
   }
@@ -75 +78 @@
     $name = pwg_db_real_escape_string($_REQUEST['name']);
     $url = pwg_db_real_escape_string($_REQUEST['url']);
+    $desc= pwg_db_real_escape_string($_REQUEST['desc']);
     $visible = (isset($_REQUEST['visible']) ? 1 : 0);
     $query = sprintf(
       'UPDATE %s
-      SET `name`="%s", `url`="%s", `visible`=%d
+      SET `name`="%s", `url`="%s", `desc`="%s", `visible`=%d
       WHERE `cr_id`=%d
       ;',
-      COPYRIGHTS_ADMIN, $name, $url, $visible, $id);
+      COPYRIGHTS_ADMIN, $name, $url, $desc, $visible, $id);
     pwg_query($query);
   }
@@ -119 +123 @@
       'name'    => $row['name'],
       'url'     => $row['url'],
+      'desc'    => $row['desc'],
       'visible' => $row['visible']
     )
@@ -133 +138 @@
 $template->assign('CRname', $CRname);
 $template->assign('CRurl', $CRurl);
+$template->assign('CRdesc', $CRdesc);
 $template->assign('CRvisible', $CRvisible);