[Phpgroupware-cvs] CVS: sitemgr/inc class.Content_SO.inc.php,1.2,1.3

[Michael Totschnig <address@hidden>]

Update of /cvsroot/phpgroupware/sitemgr/inc
In directory subversions:/tmp/cvs-serv7780

Modified Files:
        class.Content_SO.inc.php 
Log Message:
last adjustment to mssql

Index: class.Content_SO.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/sitemgr/inc/class.Content_SO.inc.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -r1.2 -r1.3
*** class.Content_SO.inc.php    28 Jan 2003 20:00:00 -0000      1.2
--- class.Content_SO.inc.php    30 Jan 2003 14:52:31 -0000      1.3
***************
*** 61,65 ****
                function getallblocksforarea($area,$cat_list,$page_id,$lang)
                {
!                       $sql = "SELECT 
t1.block_id,area,cat_id,page_id,t1.module_id,app_name,module_name,arguments,arguments_lang,sort_order,title,viewable,actif
 FROM phpgw_sitemgr_content AS t1,phpgw_sitemgr_modules AS t2 LEFT JOIN 
phpgw_sitemgr_content_lang as t3 ON (t1.block_id=t3.block_id AND lang='$lang') 
WHERE t1.module_id = t2.module_id AND area = '$area' AND ((page_id = 0 and 
cat_id = 0)";
                        if ($cat_list)
                        {
--- 61,69 ----
                function getallblocksforarea($area,$cat_list,$page_id,$lang)
                {
!                       $sql = "SELECT t1.block_id, area, cat_id, page_id, 
t1.module_id, app_name, module_name, arguments, arguments_lang, sort_order, 
title, viewable, actif"
!                               . " FROM phpgw_sitemgr_content AS t1 LEFT JOIN "
!                               . " phpgw_sitemgr_modules AS t2 on 
t1.module_id=t2.module_id LEFT JOIN "
!                               . " phpgw_sitemgr_content_lang as t3 ON 
(t1.block_id=t3.block_id AND lang='$lang') "
!                               . " WHERE area = '$area' AND ((page_id = 0 and 
cat_id = 0)";
                        if ($cat_list)
                        {