[geeklog-cvs] geeklog: SERIAL fixes

[geeklog-cvs at lists.geeklog.net]

changeset 7643:2c37fb20b878
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/2c37fb20b878
user: stan <yankees26an at gmail.com>
date: Fri Jul 24 16:34:20 2009 -0400
description:
SERIAL fixes

diffstat:

 public_html/admin/block.php |  2 +-
 system/lib-comment.php      |  4 +++-
 2 files changed, 4 insertions(+), 2 deletions(-)

diffs (33 lines):

diff -r e625f1fd5ee6 -r 2c37fb20b878 public_html/admin/block.php
--- a/public_html/admin/block.php	Wed Jul 22 13:04:54 2009 -0400
+++ b/public_html/admin/block.php	Fri Jul 24 16:34:20 2009 -0400
@@ -604,7 +604,7 @@
             
              $sql['pgsql'] = "INSERT INTO {$_TABLES['blocks']} "
              .'(bid,name,title,help,type,blockorder,content,tid,rdfurl,rdfupdated,rdflimit,phpblockfn,onleft,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon,is_enabled,allow_autotags) '
-             ."VALUES ((SELECT NEXTVAL('bid_seq')),'$name','$title','$help','$type','$blockorder','$content','$tid','$rdfurl','$rdfupdated','$rdflimit','$phpblockfn',$onleft,$owner_id,$group_id,$perm_owner,$perm_group,$perm_members,$perm_anon,$is_enabled,$allow_autotags)";
+             ."VALUES ((SELECT NEXTVAL('{$_TABLES['blocks']}_bid_seq')),'$name','$title','$help','$type','$blockorder','$content','$tid','$rdfurl','$rdfupdated','$rdflimit','$phpblockfn',$onleft,$owner_id,$group_id,$perm_owner,$perm_group,$perm_members,$perm_anon,$is_enabled,$allow_autotags)";
              
              DB_query($sql);
              $bid = DB_insertId();
diff -r e625f1fd5ee6 -r 2c37fb20b878 system/lib-comment.php
--- a/system/lib-comment.php	Wed Jul 22 13:04:54 2009 -0400
+++ b/system/lib-comment.php	Fri Jul 24 16:34:20 2009 -0400
@@ -556,6 +556,8 @@
         }
         $row++;
     } while( !$preview && ($A = DB_fetchArray( $comments )));
+    
+
 
     return $retval;
 }
@@ -1174,7 +1176,7 @@
         
     }
 
-    $cid = DB_insertId('','comments_cid_seq');
+    $cid = DB_insertId('',$_TABLES['comments'].'_cid_seq');
     DB_unlockTable($_TABLES['comments']);
 
     // notify of new comment