Re-design of caching (new database table added\!); some bugfixes; Postgres ...

thomascube

2005-12-03 1cded85790206afe084e1baff371c543711b2b18

 program/steps/addressbook/func.inc

@@ -43,7 +43,7 @@
  // count contacts for this user
  $sql_result = $DB->query("SELECT COUNT(contact_id) AS rows
                            FROM ".get_table_name('contacts')."
                            WHERE  del<>'1'
                            WHERE  del<>1
                            AND    user_id=?",
                            $_SESSION['user_id']);

@@ -56,7 +56,7 @@

    // get contacts from DB
    $sql_result = $DB->limitquery("SELECT * FROM ".get_table_name('contacts')."
                                   WHERE  del<>'1'
                                   WHERE  del<>1
                                   AND    user_id= ?
                                   ORDER BY name",
                                   $start_row,
@@ -173,7 +173,7 @@
  if ($max===NULL)
    {
    $sql_result = $DB->query("SELECT 1 FROM ".get_table_name('contacts')."
                              WHERE  del<>'1'
                              WHERE  del<>1
                              AND    user_id=?",
                              $_SESSION['user_id']);