[Scoop-checkins] scoop/lib/Scoop/Admin Blocks.pm

[scoop at lithium.sabren.com]

Update of /cvs/scoop/scoop/lib/Scoop/Admin
In directory lithium.sabren.com:/tmp/cvs-serv8892/lib/Scoop/Admin

Modified Files:
	Blocks.pm 
Log Message:
Special page layout is now in a block, and a few quoting issues and 
limit/offset behaviour were fixed to work with both pgsql and mysql.

-janra



Index: Blocks.pm
===================================================================
RCS file: /cvs/scoop/scoop/lib/Scoop/Admin/Blocks.pm,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -d -r1.10 -r1.11
*** Blocks.pm	30 Jul 2004 08:12:56 -0000	1.10
--- Blocks.pm	15 Jan 2005 17:45:26 -0000	1.11
***************
*** 515,518 ****
--- 515,519 ----
  
  	my $q_blk_theme = $S->{DBH}->quote($blk_theme);
+ 	my $q_bid = $S->{DBH}->quote($bid);
  	$description    = $S->{DBH}->quote($description);
  	$value          = $S->{DBH}->quote($value);
***************
*** 530,534 ****
  		    INTO => 'blocks',
  		    COLS => 'bid, theme, block, description, category, aid',
! 		    VALUES => qq|"$bid", $q_blk_theme, $value, $description, $category, $S->{UID}|, });
  
  		unless( $rv ) {
--- 531,535 ----
  		    INTO => 'blocks',
  		    COLS => 'bid, theme, block, description, category, aid',
! 		    VALUES => qq|$q_bid, $q_blk_theme, $value, $description, $category, $S->{UID}|, });
  
  		unless( $rv ) {