From 4e17e6c9dbac8991ee8b302cb2581241247dc8bc Mon Sep 17 00:00:00 2001
From: thomascube <thomas@roundcube.net>
Date: Sun, 25 Sep 2005 14:18:03 +0000
Subject: Initial revision

---
 program/steps/addressbook/delete.inc | 104 +++++++++++++++++++++++++++++++++++
 1 file changed, 104 insertions(+)
 create mode 100644 program/steps/addressbook/delete.inc

(limited to 'program/steps/addressbook/delete.inc')

diff --git a/program/steps/addressbook/delete.inc b/program/steps/addressbook/delete.inc
new file mode 100644
index 000000000..99d9e33d4
--- /dev/null
+++ b/program/steps/addressbook/delete.inc
@@ -0,0 +1,104 @@
+<?php
+
+/*
+ +-----------------------------------------------------------------------+
+ | program/steps/addressbook/delete.inc                                  |
+ |                                                                       |
+ | This file is part of the RoundCube Webmail client                     |
+ | Copyright (C) 2005, RoundCube Dev. - Switzerland                      |
+ | All rights reserved.                                                  |
+ |                                                                       |
+ | PURPOSE:                                                              |
+ |   Delete the submitted contacts (CIDs) from the users address book    |
+ |                                                                       |
+ +-----------------------------------------------------------------------+
+ | Author: Thomas Bruederli <roundcube@gmail.com>                        |
+ +-----------------------------------------------------------------------+
+
+ $Id$
+
+*/
+
+$REMOTE_REQUEST = TRUE;
+
+if ($_GET['_cid'])
+  {
+  $DB->query(sprintf("UPDATE %s
+                      SET    del='1'
+                      WHERE  user_id=%d
+                      AND    contact_id IN (%s)",
+                     get_table_name('contacts'),
+                     $_SESSION['user_id'],
+                     $_GET['_cid']));
+                     
+  $count = $DB->affected_rows();
+  if (!$count)
+    {
+    // send error message
+    exit;
+    }
+
+
+  // count contacts for this user
+  $sql_result = $DB->query(sprintf("SELECT COUNT(contact_id) AS rows
+                                    FROM   %s
+                                    WHERE  del!='1'
+                                    AND    user_id=%d",
+                                 get_table_name('contacts'),
+                                 $_SESSION['user_id']));
+                                   
+  $sql_arr = $DB->fetch_assoc($sql_result);
+  $rowcount = $sql_arr['rows'];    
+
+  // update message count display
+  $pages = ceil($rowcount/$CONFIG['pagesize']);
+  $commands = sprintf("this.set_rowcount('%s');\n", rcmail_get_rowcount_text($rowcount));
+  $commands .= sprintf("this.set_env('pagecount', %d);\n", $pages);
+
+
+  // add new rows from next page (if any)
+  if ($_GET['_from']!='show' && $pages>1 && $_SESSION['page'] < $pages)
+    {
+    $start_row = ($_SESSION['page'] * $CONFIG['pagesize']) - $count;
+
+    // get contacts from DB
+    $sql_result = $DB->query(sprintf("SELECT * FROM %s
+                                      WHERE  del!='1'
+                                      AND    user_id=%d
+                                      ORDER BY name
+                                      LIMIT %d, %d",
+                                     get_table_name('contacts'),
+                                     $_SESSION['user_id'],
+                                     $start_row,
+                                     $count));
+                                     
+    $commands .= rcmail_js_contacts_list($sql_result);
+
+/*
+    // define list of cols to be displayed
+    $a_show_cols = array('name', 'email');
+    
+    while ($sql_arr = $DB->fetch_assoc($sql_result))
+      {
+      $a_row_cols = array();
+            
+      // format each col
+      foreach ($a_show_cols as $col)
+        {
+        $cont = rep_specialchars_output($sql_arr[$col]);
+        $a_row_cols[$col] = $cont;
+        }
+  
+      $commands .= sprintf("this.add_contact_row(%s, %s);\n",
+                           $sql_arr['contact_id'],
+                           array2js($a_row_cols));
+      }
+*/
+    }
+
+  // send response
+  rcube_remote_response($commands);
+  }
+
+exit;
+?>
\ No newline at end of file
-- 
cgit v1.2.3