[Phpgroupware-cvs] comic/inc class.uiadmin.inc.php, 1.1, 1.1.4.1 functions.inc.php, 1.17.2.5, 1.17.2.5.2.1

[Dave Hall <address@hidden>]

Update of /cvsroot/phpgroupware/comic/inc
In directory subversions:/tmp/cvs-serv26973/inc

Modified Files:
      Tag: Version-0_9_16-branch
        class.uiadmin.inc.php functions.inc.php 
Log Message:
sql and globals

Index: functions.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/comic/inc/functions.inc.php,v
retrieving revision 1.17.2.5
retrieving revision 1.17.2.5.2.1
diff -C2 -d -r1.17.2.5 -r1.17.2.5.2.1
*** functions.inc.php   20 Mar 2003 02:37:56 -0000      1.17.2.5
--- functions.inc.php   9 Oct 2003 21:33:03 -0000       1.17.2.5.2.1
***************
*** 49,56 ****
      if (!$phpgw->db->num_rows())
      {
!         $phpgw->db->query("insert into phpgw_comic_admin values "
!                           ."(0,0,0,0,120000)");
          
!         $phpgw->db->query("select * from phpgw_comic_admin");
      }
      $phpgw->db->next_record();
--- 49,56 ----
      if (!$phpgw->db->num_rows())
      {
!         $phpgw->db->query('INSERT INTO phpgw_comic_admin'
!                       . ' VALUES(0,0,0,0,120000)', __LINE__, __FILE__);
          
!         $phpgw->db->query('SELECT * FROM phpgw_comic_admin', __LINE__, 
__FILE__);
      }
      $phpgw->db->next_record();
***************
*** 68,75 ****
                  
      $phpgw->db->lock("phpgw_comic_data");
!     $phpgw->db->query("update phpgw_comic_data set "
!                       ."data_date='".(int)date("Ymd")."', "
!                       ."data_imageurl='".$comic_url."' "
!                       ."WHERE data_id='".$data_id."'");
      $phpgw->db->unlock();
  }
--- 68,75 ----
                  
      $phpgw->db->lock("phpgw_comic_data");
!     $phpgw->db->query('UPDATE phpgw_comic_data SET'
!                       .' data_date='.intval(date("Ymd")).','
!                       ." 
data_imageurl='".$phpgw->db->db_addslashes($comic_url)."' "
!                       .' WHERE data_id='.intval($data_id), __LINE__, 
__FILE__);
      $phpgw->db->unlock();
  }
***************
*** 657,664 ****
               * get the comic data
               
*****************************************************************/
!             $phpgw->db->query("select * from phpgw_comic_data "
!                               ."WHERE data_id='"
!                               .$comic_list[$index]."' AND "
!                               ."data_enabled='T'");
  
              if ($phpgw->db->next_record())
--- 657,663 ----
               * get the comic data
               
*****************************************************************/
!             $phpgw->db->query('SELECT * FROM phpgw_comic_data'
!                               .' WHERE data_id='.intval($comic_list[$index])
!                             ." AND data_enabled='T'", __LINE__, __FILE__);
  
              if ($phpgw->db->next_record())
***************
*** 892,898 ****
      {
          $match_str =
!             "WHERE data_censorlvl <= '".$censor_level."' AND ".
!             " data_pubdays LIKE '%".$comic_day."%' AND "
!             ."data_enabled='T'";
          
      }
--- 891,897 ----
      {
          $match_str =
!             'WHERE data_censorlvl <= '.intval($censor_level)
!           . " AND data_pubdays LIKE 
'%".$phpgw->db->db_addslashes($comic_day)."%'"
!           . " AND data_enabled='T'";
          
      }
***************
*** 903,908 ****
      {
          $match_str =
!             "WHERE data_id='".$data_id."' AND "
!             ."data_enabled='T'";
      }
  
--- 902,907 ----
      {
          $match_str =
!             'WHERE data_id='.intval($data_id)
!           . " AND data_enabled='T'";
      }
  
***************
*** 910,915 ****
       * get the comic data
       
*************************************************************************/
!     $phpgw->db->query("select * from phpgw_comic_data "
!                       .$match_str);
  
      
/**************************************************************************
--- 909,914 ----
       * get the comic data
       
*************************************************************************/
!     $phpgw->db->query('SELECT * FROM phpgw_comic_data '
!                       .$match_str, __LINE__, __FILE__);
  
      
/**************************************************************************

Index: class.uiadmin.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/comic/inc/class.uiadmin.inc.php,v
retrieving revision 1.1
retrieving revision 1.1.4.1
diff -C2 -d -r1.1 -r1.1.4.1
*** class.uiadmin.inc.php       2 Aug 2001 15:09:32 -0000       1.1
--- class.uiadmin.inc.php       9 Oct 2003 21:33:03 -0000       1.1.4.1
***************
*** 34,42 ****
        function global_options()
        {
!               global $phpgw, $phpgw_info, $HTTP_POST_VARS;
  
!               if ($HTTP_POST_VARS['submit']!='')
                {
!                       if ($HTTP_POST_VARS['submit']==lang("Submit"))
                        {
                                $field = $this->get_form();
--- 34,42 ----
        function global_options()
        {
!               global $phpgw, $phpgw_info;
  
!               if ($_POST['submit']!='')
                {
!                       if ($_POST['submit']==lang("Submit"))
                        {
                                $field = $this->get_form();
***************
*** 44,48 ****
                                $field['message'] = 
$this->bo->update_global_options($field);
                        }
!                       if ($HTTP_POST_VARS['submit']==lang("Done"))
                        {
                                header('Location: 
'.$phpgw->link('/admin/index.php'));
--- 44,48 ----
                                $field['message'] = 
$this->bo->update_global_options($field);
                        }
!                       if ($_POST['submit']==lang("Done"))
                        {
                                header('Location: 
'.$phpgw->link('/admin/index.php'));
***************
*** 155,165 ****
        function get_form()
        {
!               global $HTTP_POST_VARS;
! 
!               $field['censor_level']          = 
$HTTP_POST_VARS['censor_level'];
!               $field['override_enabled']      = 
$HTTP_POST_VARS['override_enabled'];
!               $field['image_source']          = 
$HTTP_POST_VARS['image_source'];
!               $field['remote_enabled']        = 
$HTTP_POST_VARS['remote_enabled'];
!               $field['filesize']              = $HTTP_POST_VARS['filesize'];
  
                return ($field);
--- 155,163 ----
        function get_form()
        {
!               $field['censor_level']          = $_POST['censor_level'];
!               $field['override_enabled']      = $_POST['override_enabled'];
!               $field['image_source']          = $_POST['image_source'];
!               $field['remote_enabled']        = $_POST['remote_enabled'];
!               $field['filesize']              = $_POST['filesize'];
  
                return ($field);