[Phpgroupware-cvs] phpgwapi/inc/class.sessions_db.inc.php, 1.2.2.10.2.11

[nomail]

Update of /phpgwapi/inc
Modified Files:
        Branch: Version-0_9_16-branch
          class.sessions_db.inc.php

date: 2004/06/06 22:43:10;  author: skwashd;  state: Exp;  lines: +7 -3

Log Message:
fix for bug #9201
=====================================================================
Index: phpgwapi/inc/class.sessions_db.inc.php
diff -u phpgwapi/inc/class.sessions_db.inc.php:1.2.2.10.2.10 
phpgwapi/inc/class.sessions_db.inc.php:1.2.2.10.2.11
--- phpgwapi/inc/class.sessions_db.inc.php:1.2.2.10.2.10        Tue Feb 10 
13:51:18 2004
+++ phpgwapi/inc/class.sessions_db.inc.php      Sun Jun  6 22:43:10 2004
@@ -181,9 +181,13 @@
                function list_sessions($start, $order, $sort, $all_no_sort = 
False)
                {
                        $values = array();
+                       $order = $this->db->db_addslashes($order);
+                       $sort = $this->db->db_addslashes($sort);
                        
-                       $ordermethod = 'order by session_dla asc';
-                       $this->db->limit_query("select * from phpgw_sessions 
where session_flags != 'A' order by $sort $order",$start,__LINE__,__FILE__);
+                       $this->db->limit_query('SELECT * FROM phpgw_sessions'
+                                               . " WHERE session_flags != 'A'"
+                                               . " ORDER BY $order 
$sort",$start
+                                               ,__LINE__,__FILE__);
 
                        while ($this->db->next_record())
                        {