Changeset 11267 for extensions/Comments_on_Albums/include/coa_admin_comments.php

Timestamp:

Jun 7, 2011, 9:44:37 PM (13 years ago)

Author:

mistic100

Message:

big code cleaning

File:

• extensions/Comments_on_Albums/include/coa_admin_comments.php (modified) (4 diffs)

extensions/Comments_on_Albums/include/coa_admin_comments.php

@@ -3 +3 @@
 if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');
 
+global $template, $conf;
 load_language('plugin.lang', COA_PATH);
 
 // +-----------------------------------------------------------------------+
-//        Tabsheet
+// |                               tabsheet                                |
 // +-----------------------------------------------------------------------+
 include_once(PHPWG_ROOT_PATH.'admin/include/tabsheet.class.php');
@@ -14 +15 @@
     'code' => 'pictures',
     'label' => l10n('COA_comments_photos'),
-  ),
+    ),
   array(
     'code' => 'albums',
     'label' => l10n('COA_comments_albums'),
-  ),
-);
+    ),
+  );
 
 $tab_codes = array_map(create_function('$a', 'return $a["code"];'), $tabs);
 
-if (isset($_GET['section']) and in_array($_GET['section'], $tab_codes)) {
+if (isset($_GET['section']) and in_array($_GET['section'], $tab_codes)) 
+{
   $page['tab'] = $_GET['section'];
-} else {
+} 
+else 
+{
   $page['tab'] = $tabs[0]['code'];
 }
 
 $tabsheet = new tabsheet();
-foreach ($tabs as $tab) {
+foreach ($tabs as $tab) 
+{
   $tabsheet->add(
     $tab['code'],
     $tab['label'],
     get_root_url().'admin.php?page=comments&section='.$tab['code']
-  );
+    );
 }
 $tabsheet->select($page['tab']);
@@ -41 +46 @@
 
 
-if ($page['tab'] == 'albums') {
+if ($page['tab'] == 'albums') 
+{
+  // clear template sended by original page
   $template->clear_assign(array('ADMIN_CONTENT', 'comments', 'LIST', 'F_ACTION'));
 
   // +-----------------------------------------------------------------------+
-  //        Actions
+  // |                                actions                                |
   // +-----------------------------------------------------------------------+
-  if (!empty($_POST)) {
-    if (!empty($_POST['comments'])) {
+  if (!empty($_POST)) 
+  {
+    if (empty($_POST['comments']))
+    {
+      array_push(
+        $page['errors'],
+        l10n('Select at least one comment')
+        );
+    }
+    else
+    {
       check_input_parameter('comments', $_POST, true, PATTERN_ID);
 
-      if (isset($_POST['validate_albums'])) {
-        $query = 'UPDATE '.COA_TABLE.' SET 
-            validated = \'true\',
-            validation_date = NOW()
-          WHERE id IN ('.implode(',', $_POST['comments']).')
-        ;';
+      if (isset($_POST['validate_albums'])) 
+      {
+        $query = '
+UPDATE '.COA_TABLE.' 
+  SET validated = \'true\',
+      validation_date = NOW()
+  WHERE id IN ('.implode(',', $_POST['comments']).')
+;';
         pwg_query($query);
 
-        array_push($page['infos'], l10n_dec(
-          '%d user comment validated', '%d user comments validated',
-          count($_POST['comments'])
-        ));
+        array_push(
+          $page['infos'], 
+          l10n_dec(
+            '%d user comment validated', '%d user comments validated',
+            count($_POST['comments'])
+            )
+          );
       }
 
-      if (isset($_POST['reject_albums'])) {
-        $query = 'DELETE FROM '.COA_TABLE.'
-          WHERE id IN ('.implode(',', $_POST['comments']).')
-        ;';
+      if (isset($_POST['reject_albums'])) 
+      {
+        $query = '
+DELETE 
+  FROM '.COA_TABLE.'
+  WHERE id IN ('.implode(',', $_POST['comments']).')
+;';
         pwg_query($query);
 
-        array_push($page['infos'], l10n_dec(
-          '%d user comment rejected', '%d user comments rejected',
-          count($_POST['comments'])
-        ));
+        array_push(
+          $page['infos'], 
+          l10n_dec(
+            '%d user comment rejected', '%d user comments rejected',
+            count($_POST['comments'])
+            )
+          );
       }
     }
@@ -80 +107 @@
 
   // +-----------------------------------------------------------------------+
-  //        Infos (re-assignation needed)
+  // |                             template init                             |
   // +-----------------------------------------------------------------------+
-  if (count($page['infos']) != 0) {
+
+  $template->set_filename('comments', dirname(__FILE__) .'/../template/admin_comments.tpl');
+
+  $template->assign(
+    array(
+      'F_ACTION' => get_root_url().'admin.php?page=comments&section=albums'
+      )
+    );
+    
+  if (count($page['infos']) != 0) 
+  {
     $template->assign('infos', $page['infos']);
   }
 
   // +-----------------------------------------------------------------------+
-  //        Comments display
+  // |                           comments display                            |
   // +-----------------------------------------------------------------------+
   $list = array();
 
-  $query = 'SELECT 
-      com.id, 
-      com.category_id, 
-      com.date, 
-      com.author,
-      '.$conf['user_fields']['username'].' AS username, 
-      com.content, 
-      cat.name
-    FROM '.COA_TABLE.' AS com
+  $query = '
+SELECT 
+    com.id, 
+    com.category_id, 
+    com.date, 
+    com.author,
+    '.$conf['user_fields']['username'].' AS username, 
+    com.content, 
+    cat.name
+  FROM '.COA_TABLE.' AS com
     INNER JOIN '.CATEGORIES_TABLE.' AS cat
-    ON cat.id = com.category_id
+      ON cat.id = com.category_id
     LEFT JOIN '.USERS_TABLE.' AS u
-    ON u.'.$conf['user_fields']['id'].' = com.author_id
-    WHERE validated = \'false\'
-    ORDER BY com.date DESC
-  ;';
+      ON u.'.$conf['user_fields']['id'].' = com.author_id
+  WHERE validated = \'false\'
+  ORDER BY com.date DESC
+;';
   $result = pwg_query($query);
 
-  while ($row = pwg_db_fetch_assoc($result)) {
+  while ($row = pwg_db_fetch_assoc($result)) 
+  {
     // author
-    if (empty($row['author_id'])) {
+    if (empty($row['author_id'])) 
+    {
       $author_name = $row['author'];
-    } else {
+    } 
+    else 
+    {
       $author_name = stripslashes($row['username']);
     }
     
     // comment content
-    $template->append('comments', array(
-      'CAT_URL' => PHPWG_ROOT_PATH.'admin.php?page=cat_modify&cat_id='.$row['category_id'],
-      'CAT_NAME' => $row['name'],
-      'ID' => $row['id'],
-      'AUTHOR' => trigger_event('render_comment_author', $author_name),
-      'DATE' => format_date($row['date'], true),
-      'CONTENT' => trigger_event('render_comment_content',$row['content']),
-    ));
+    $template->append(
+      'comments', 
+      array(
+        'CAT_URL' => PHPWG_ROOT_PATH.'admin.php?page=cat_modify&cat_id='.$row['category_id'],
+        'CAT_NAME' => $row['name'],
+        'ID' => $row['id'],
+        'AUTHOR' => trigger_event('render_comment_author', $author_name),
+        'DATE' => format_date($row['date'], true),
+        'CONTENT' => trigger_event('render_comment_content',$row['content']),
+        )
+      );
 
     array_push($list, $row['id']);
   }
 
-  // template
-  $template->set_filename('comments', dirname(__FILE__) .'/../template/coa_admin_comments.tpl');
-  $template->assign(array(
-    'F_ACTION' => get_root_url().'admin.php?page=comments&section=albums',
-    'LIST' => implode(',', $list),
-  ));
+  $template->assign('LIST', implode(',', $list));
+
+  // +-----------------------------------------------------------------------+
+  // |                           sending html code                           |
+  // +-----------------------------------------------------------------------+
+
   $template->assign_var_from_handle('ADMIN_CONTENT', 'comments');
+
 }