[Librefm-commits] [1631] convert admin.php to adodb

[Clint Adams]

Revision: 1631
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1631
Author:   clint
Date:     2009-05-15 17:04:25 +0000 (Fri, 15 May 2009)
Log Message:
-----------
convert admin.php to adodb

Modified Paths:
--------------
    trunk/nixtape/admin.php

Modified: trunk/nixtape/admin.php
===================================================================
--- trunk/nixtape/admin.php     2009-05-15 16:58:33 UTC (rev 1630)
+++ trunk/nixtape/admin.php     2009-05-15 17:04:25 UTC (rev 1631)
@@ -19,7 +19,7 @@
 
 */
 require_once('auth.php');
-require_once('database.php');
+require_once('database2.php');
 require_once('templating.php');
 require_once('config.php');
 
@@ -28,7 +28,7 @@
 $userlevel = $u_user->userlevel;
 
 function sendEmail($email) {
-       global $mdb2;
+       global $adodb;
        global $base_url;
        global $u_user;
        $username = $u_user->name;
@@ -36,14 +36,15 @@
 
        // Insert the invitation into the table
        $sql = 'INSERT INTO Invitations (inviter, code) VALUES ('
-               . $mdb2->quote($username, 'text') . ', '
-               . $mdb2->quote($code, 'text') . ')';
+                       . $adodb->qstr($username) . ', '
+                       . $adodb->qstr($code) . ')';
 
-       $affected =& $mdb2->exec($sql);
-
-       if (PEAR::isError($affected)) {
-               die($affected->getMessage());
+       try {
+               $adodb->Execute($sql);
        }
+       catch (exception $e) {
+               die($e->getMessage());
+       }
 
        $url = $base_url . '/register.php?authcode=' . $code;
        $headers = 'From: Libre.fm Invitations <address@hidden>';
@@ -73,8 +74,8 @@
                                // Send the email
                                sendEmail($_GET['email']);
                                $smarty->assign('sent', true);
-                               $sql = 'UPDATE Invitation_Request SET status=1 
WHERE email=' . $mdb2->quote($_GET['email'], 'text');
-                               $mdb2->exec($sql);
+                               $sql = 'UPDATE Invitation_Request SET status=1 
WHERE email=' . $adodb->qstr($_GET['email']);
+                               $adodb->Execute($sql);
                        }
                } else {
                        $smarty->assign('error', 'Error!');
@@ -86,8 +87,8 @@
 
 }
 
-$res = $mdb2->query('SELECT email,status FROM Invitation_Request ORDER BY time 
ASC');
-$data = $res->fetchAll(MDB2_FETCHMODE_ASSOC);
+$adodb->SetFetchMode(ADODB_FETCH_ASSOC);
+$data = $adodb->GetAll('SELECT email,status FROM Invitation_Request ORDER BY 
time ASC');
 $smarty->assign('emails', $data);
 $smarty->display('admin.tpl');
 ?>