[geeklog-cvs] Geeklog-1.x/public_html/admin block.php,1.112,1.113

[Blaine Lang]

Update of /cvsroot/geeklog/Geeklog-1.x/public_html/admin
In directory qs1489.pair.com:/tmp/cvs-serv38517/public_html/admin

Modified Files:
	block.php 
Log Message:
Change to support MSSQL , block content was being truncated in MSSQL. Need to implement separate sql for mssql  AND mysql.

Index: block.php
===================================================================
RCS file: /cvsroot/geeklog/Geeklog-1.x/public_html/admin/block.php,v
retrieving revision 1.112
retrieving revision 1.113
diff -C2 -d -r1.112 -r1.113
*** block.php	12 May 2007 12:51:13 -0000	1.112
--- block.php	23 Jul 2007 01:36:11 -0000	1.113
***************
*** 189,193 ****
  
      if (!empty($bid)) {
!         $result = DB_query("SELECT * FROM {$_TABLES['blocks']} WHERE bid ='$bid'");
          $A = DB_fetchArray($result);
          $access = SEC_hasAccess($A['owner_id'],$A['group_id'],$A['perm_owner'],$A['perm_group'],$A['perm_members'],$A['perm_anon']);
--- 189,199 ----
  
      if (!empty($bid)) {
!         $sql['mysql'] = "SELECT * FROM {$_TABLES['blocks']} WHERE bid ='$bid'";
!         
!         $sql['mssql'] = "SELECT bid, is_enabled, name, type, title, tid, blockorder, cast(content as text) as content, rdfurl, ";
!         $sql['mssql'] .= "rdfupdated, rdflimit, onleft, phpblockfn, help, owner_id,group_id, ";
!         $sql['mssql'] .= "perm_owner, perm_group, perm_members, perm_anon, allow_autotags FROM {$_TABLES['blocks']} WHERE bid ='$bid'";
!         
!         $result = DB_query($sql);
          $A = DB_fetchArray($result);
          $access = SEC_hasAccess($A['owner_id'],$A['group_id'],$A['perm_owner'],$A['perm_group'],$A['perm_members'],$A['perm_anon']);