[Phpgroupware-cvs] CVS: phpbrain/inc class.sokb.inc.php,1.8,1.9

[Dave Hall <address@hidden>]

Update of /cvsroot/phpgroupware/phpbrain/inc
In directory subversions:/tmp/cvs-serv986

Modified Files:
        class.sokb.inc.php 
Log Message:
added  __LINE__ __FILE__ to queries

Index: class.sokb.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/phpbrain/inc/class.sokb.inc.php,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -r1.8 -r1.9
*** class.sokb.inc.php  16 Apr 2003 12:02:07 -0000      1.8
--- class.sokb.inc.php  17 Apr 2003 04:19:44 -0000      1.9
***************
*** 30,34 ****
                        foreach($faq_ids as $key => $val)
                        {
!                               $this->db->query("DELETE FROM phpgw_kb_faq 
WHERE faq_id = $key");
                                $i++;
                        }//end foreach(q_id)
--- 30,34 ----
                        foreach($faq_ids as $key => $val)
                        {
!                               $this->db->query("DELETE FROM phpgw_kb_faq 
WHERE faq_id = $key", __LINE__, __FILE__);
                                $i++;
                        }//end foreach(q_id)
***************
*** 36,40 ****
                        elseif(is_int($faq_ids))
                        {
!                               $this->db->query("DELETE FROM phpgw_kb_faq 
WHERE faq_id = $faq_ids");
                                $i = 1;
                        }//end is_type
--- 36,40 ----
                        elseif(is_int($faq_ids))
                        {
!                               $this->db->query("DELETE FROM phpgw_kb_faq 
WHERE faq_id = $faq_ids", __LINE__, __FILE__);
                                $i = 1;
                        }//end is_type
***************
*** 49,53 ****
                        foreach($question_ids as $key => $val)
                        {
!                               $this->db->query("DELETE FROM 
phpgw_kb_questions WHERE question_id = $key");
                                $i++;
                        }//end foreach(q_id)
--- 49,53 ----
                        foreach($question_ids as $key => $val)
                        {
!                               $this->db->query("DELETE FROM 
phpgw_kb_questions WHERE question_id = $key", __LINE__, __FILE__);
                                $i++;
                        }//end foreach(q_id)
***************
*** 55,59 ****
                        elseif(is_int($question_ids))
                        {
!                               $this->db->query("DELETE FROM 
phpgw_kb_questions WHERE question_id = $question_ids");
                                $i = 1;
                        }//end is_type
--- 55,59 ----
                        elseif(is_int($question_ids))
                        {
!                               $this->db->query("DELETE FROM 
phpgw_kb_questions WHERE question_id = $question_ids", __LINE__, __FILE__);
                                $i = 1;
                        }//end is_type
***************
*** 167,171 ****
                function get_pending()
                {
!                       $this->db->query('SELECT faq_id, text FROM phpgw_kb_faq 
WHERE published = 0');
                        while($this->db->next_record())
                        {
--- 167,171 ----
                function get_pending()
                {
!                       $this->db->query('SELECT faq_id, text FROM phpgw_kb_faq 
WHERE published = 0', __LINE__, __FILE__);
                        while($this->db->next_record())
                        {
***************
*** 228,232 ****
                                        $sql .= ' url = "' . 
$this->db->db_addslashes(urldecode($faq['ur'])) .'"';
                                        $sql .= " WHERE faq_id = $faq_id";
!                                       $this->db->query($sql);
                                        if($this->db->affected_rows() == 1)
                                        {
--- 228,232 ----
                                        $sql .= ' url = "' . 
$this->db->db_addslashes(urldecode($faq['ur'])) .'"';
                                        $sql .= " WHERE faq_id = $faq_id";
!                                       $this->db->query($sql, __LINE__, 
__FILE__);
                                        if($this->db->affected_rows() == 1)
                                        {
***************
*** 251,255 ****
                                        $sql .= $faq['is_faq'] . ', ';
                                        $sql .= '"' . 
$this->db->db_addslashes(urldecode($faq['url'])) .'")';//url is decoded to make 
sure it is not encoded already
!                                       $this->db->query($sql);
                                        return 
$this->db->get_last_insert_id('phpgw_kb_faq', 'faq_id');
                                }//end is new
--- 251,255 ----
                                        $sql .= $faq['is_faq'] . ', ';
                                        $sql .= '"' . 
$this->db->db_addslashes(urldecode($faq['url'])) .'")';//url is decoded to make 
sure it is not encoded already
!                                       $this->db->query($sql, __LINE__, 
__FILE__);
                                        return 
$this->db->get_last_insert_id('phpgw_kb_faq', 'faq_id');
                                }//end is new
***************
*** 283,287 ****
                        $sql  = 'INSERT INTO phpgw_kb_comment(user_id, comment, 
entered, faq_id) ';
                        $sql .= "VALUES($user_id, '" . 
$this->db->db_addslashes($comment) . "', ". time() .", $faq_id)";
!                       $this->db->query($sql); 
                }
  
--- 283,287 ----
                        $sql  = 'INSERT INTO phpgw_kb_comment(user_id, comment, 
entered, faq_id) ';
                        $sql .= "VALUES($user_id, '" . 
$this->db->db_addslashes($comment) . "', ". time() .", $faq_id)";
!                       $this->db->query($sql, __LINE__, __FILE__); 
                }
  
***************
*** 318,322 ****
                        
                        $sql = $select . 'AND' . $title . 'OR' . $keywords . 
'OR' . $text;
!                       $this->db->query($sql);
                        while($this->db->next_record())
                        {
--- 318,322 ----
                        
                        $sql = $select . 'AND' . $title . 'OR' . $keywords . 
'OR' . $text;
!                       $this->db->query($sql, __LINE__, __FILE__);
                        while($this->db->next_record())
                        {
***************
*** 339,343 ****
                        //$sql .= 'HAVING (score > 0) '; //- this isn't working 
properly afaik
                        $sql .= 'ORDER BY score DESC';
!                       $this->db->query($sql);
                        while($this->db->next_record())
                        {
--- 339,343 ----
                        //$sql .= 'HAVING (score > 0) '; //- this isn't working 
properly afaik
                        $sql .= 'ORDER BY score DESC';
!                       $this->db->query($sql, __LINE__, __FILE__);
                        while($this->db->next_record())
                        {