Changeset 454 for trunk/plugins

Timestamp:

04/22/07 14:13:48 (19 months ago)

Author:

michiel

Message:

switch from PEAR::DB to PEAR::MDB2
This is the first round of work. Everything is working now.
We need to replace several calls of $db->query with ->execute
and also lots of code to sanitize data should be replaced
with the MDB2 methods for this.

Make sure you have the PEAR::MDB2 package and the
correct MDB2_Driver_* for your database backend.

for mysql users:
pear install MDB2 MDB2_Driver_mysql

for pgsql users:
pear install MDB2 MDB2_Driver_pgsql

Re #119

Location:

trunk/plugins

Files:

• acronyms.php (modified) (2 diffs)
• altarchive.php (modified) (3 diffs)

trunk/plugins/acronyms.php

@@ -25 +25 @@
                         die($res->getMessage());
                 }
-                while ($res->fetchInto($row, DB_FETCHMODE_ASSOC)) {
+                while ($row = $res->fetchRow(MDB2_FETCHMODE_ASSOC)) {
                         $this->_acronyms[$row["id"]] = array($row["acronym"], $row["description"]);
                 }
@@ -128 +128 @@
                                 $sql = sprintf("SELECT id FROM acronyms WHERE acronym='%s' AND description='%s'", $acro["acronym"], $acro["description"]);
                                 $res = $this->_mvblog->db->query($sql);
-                                $res->fetchInto($row);
+                                $row = $res->fetchRow();
                                 $this->_acronyms[$row[0]] = array($acro["acronym"], $acronym["description"]);
                         }

trunk/plugins/altarchive.php

@@ -32 +32 @@
                 $sql = "SELECT date FROM articles WHERE active=1 AND public=1 ORDER BY date DESC";
                 $res = $this->_mvblog->db->query($sql);
-                while ($res->fetchInto($row)) {
+                while ($row = $res->fetchRow()) {
                         $month = date("m", $row[0]);
                         $year  = date("Y", $row[0]);
@@ -45 +45 @@
                 $sql = "SELECT * FROM settings WHERE settingname LIKE 'altarchive_%'";
                 $res = $this->_mvblog->db->query($sql);
-                while ($res->fetchInto($row, DB_FETCHMODE_ASSOC)) {
+                while ($row = $res->fetchRow(MDB2_FETCHMODE_ASSOC)) {
                         $this->_settings[$row["settingname"]] = $row["settingvalue"];
                 }
@@ -148 +148 @@
                 $sql = "SELECT COUNT(*) FROM settings WHERE settingname = 'altarchive_showdefaultcss'";
                 $res = $this->_mvblog->db->query($sql);
-                $res->fetchInto($row);
+                $row = $res->fetchRow();
                 if ($row[0]) {
                         /* yes, so update */