Changeset 1925 for plugins/blocNotes

Timestamp:

11/30/09 19:14:55 (14 years ago)

Author:

Moe

Message:

Bloc-Notes 1.0.4:

• fixed bug with PostgreSQL (closes #230)

Location:

plugins/blocNotes

Files:

• _define.php (modified) (1 diff)
• _install.php (modified) (1 diff)
• inc/lib.blocNotes.php (modified) (2 diffs)

plugins/blocNotes/_define.php

@@ -29 +29 @@
      /* Description*/    'Display notebooks on the backend',
      /* Author */        'Moe (http://gniark.net/)',
-     /* Version */       '1.0.3',
+     /* Version */       '1.0.4',
      /* Permissions */   'usage,contentadmin'
 );

plugins/blocNotes/_install.php

@@ -71 +71 @@
 }
 
+if (version_compare($i_version,'1.0.4','<'))
+{
+     # rename blocNotes field to bloc_notes (fix problem with PostgreSQL)
+     if ($core->con->driver() == 'pgsql')
+     {
+          $core->con->execute('ALTER TABLE '.$core->prefix.'user '.
+               'RENAME COLUMN blocNotes TO bloc_notes;');
+     }
+     else
+     {
+          $core->con->execute('ALTER TABLE '.$core->prefix.'user '.
+               'CHANGE blocNotes bloc_notes TEXT;');
+     }
+}
+
 # table
 $s = new dbStruct($core->con,$core->prefix);
  
-# add blocNotes column to (dc_)user 
+# add bloc_notes column to (dc_)user 
 $s->user
-     ->blocNotes('text',0,true,null)
+     ->bloc_notes('text',0,true,null)
 ;
 

plugins/blocNotes/inc/lib.blocNotes.php

@@ -38 +38 @@
                $set = $core->blog->settings;
                
-               $notes = $core->con->select('SELECT blocNotes '.
+               $notes = $core->con->select('SELECT bloc_notes '.
                     'FROM '.$core->prefix.'user '.
                     'WHERE user_id = \''.
@@ -71 +71 @@
                     # Personal notebook
                     $cur = $core->con->openCursor($core->prefix.'user');
-                    $cur->blocNotes = $_POST['blocNotes_personal_text'];
+                    $cur->bloc_notes = $_POST['blocNotes_personal_text'];
                     $cur->update('WHERE user_id = \''.$core->con->escape($core->auth->userID()).'\'');