[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] CVS: phpbrain/inc class.sokb.inc.php,1.8,1.9
From: |
Dave Hall <address@hidden> |
Subject: |
[Phpgroupware-cvs] CVS: phpbrain/inc class.sokb.inc.php,1.8,1.9 |
Date: |
Thu, 17 Apr 2003 00:19:47 -0400 |
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())
{
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] CVS: phpbrain/inc class.sokb.inc.php,1.8,1.9,
Dave Hall <address@hidden> <=