[Phpgroupware-cvs] comic/admin_comics.php, 1.5

[nomail]

Update of /comic
Modified Files:
        Branch: 
          admin_comics.php

date: 2004/07/20 23:51:54;  author: skwashd;  state: Exp;  lines: +36 -20

Log Message:
merge from 16 and image clean up
=====================================================================
Index: comic/admin_comics.php
diff -u comic/admin_comics.php:1.4 comic/admin_comics.php:1.5
--- comic/admin_comics.php:1.4  Wed Aug 14 10:12:22 2002
+++ comic/admin_comics.php      Tue Jul 20 23:51:54 2004
@@ -21,16 +21,32 @@
        include('../header.inc.php');
        include('inc/comic_data.inc.php');
 
+       if(!$GLOBALS['phpgw_info']['user']['apps']['comic'])
+       {
+               Header('Location: '. $GLOBALS['phpgw']->link('/home.php') );
+               exit;
+       }
+
        $title             = lang('Daily Comics Data');
 
        $done_label        = lang('Done');
-       $doneurl           = $GLOBALS['phpgw']->link('/admin/index.php');
+       $doneurl           = $GLOBALS['phpgw']->link('/admin/index.php') . 
'#comic';
 
        $message           = '';
-   
-       $submit = get_var('submit',Array('POST'));
-       $act = get_var('act',Array('GET')); 
-       if($submit)
+
+       $act            = get_var('act', array('POST', 'GET'), '');
+       $order          = get_var('order', array('POST', 'GET'), 'data_title');
+       $sort           = get_var('sort', array('POST', 'GET'), 'ASC');
+       $start          = get_var('start', array('POST', 'GET'), 0);
+       $query          = get_var('query', array('POST', 'GET'), '');
+       $qfield         = get_var('qfield', array('POST', 'GET'), 'data_title');
+       $filter         = get_var('filter', array('POST', 'GET'), '');
+       $con            = get_var('con', array('POST', 'GET'), 0);
+       $submit         = get_var('submit', array('POST'), false);
+       $comic_name     = get_var('comic_name', array('POST'), '');
+       $data_id        = intval( get_var('data_id', array('POST'), 0) );
+    
+       if ($submit)
        {
                switch($act)
                {
@@ -44,20 +60,20 @@
                                $message = 'addition';
                                break;
                }
-               $message = lang('Performed %1 of element', $message);
+               $message = lang('Performed %1 of element', lang($message) );
        }
 
        $other_c           = '';
-
+       
        switch($act)
        {
                case 'edit':
-                       if($submit)
+                       if ($submit)
                        {
                                $GLOBALS['phpgw']->db->lock('phpgw_comic_data');
-                               $GLOBALS['phpgw']->db->query('update 
phpgw_comic_data set '
-                                       ."comic_name='".$comic_name."' "
-                                       ."where 
data_id='".$data_id."'",__LINE__,__FILE__);
+                               $GLOBALS['phpgw']->db->query('UPDATE 
phpgw_comic_data'
+                                               . " SET data_title = 
'".$GLOBALS['phpgw']->db->db_addslashes($comic_name)."'"
+                                               . " WHERE data_id = 
$data_id",__LINE__,__FILE__);
                                $GLOBALS['phpgw']->db->unlock();
 
                                
comic_table($order,$sort,$filter,$start,$query,$qfield,$table_c);
@@ -66,16 +82,16 @@
                        else
                        {
                                
comic_table($order,$sort,$filter,$start,$query,$qfield,$table_c);
-                               
comic_entry('','add',$order,$sort,$filter,$start,$query,$qfield,$add_c);
+                               
//comic_entry('','add',$order,$sort,$filter,$start,$query,$qfield,$add_c);
                                
comic_entry($con,$act,$order,$sort,$filter,$start,$query,$qfield,$other_c);
                        }
                        break;
                case 'delete':
-                       if($submit)
+                       if ($submit)
                        {
                                $GLOBALS['phpgw']->db->lock('phpgw_comic_data');
-                               $GLOBALS['phpgw']->db->query('delete from 
phpgw_comic_data '
-                                       ."where 
data_id='".$data_id."'",__LINE__,__FILE__);
+                               $GLOBALS['phpgw']->db->query('DELETE FROM 
phpgw_comic_data'
+                                       . " WHERE data_id =  
$data_id",__LINE__,__FILE__);
                                $GLOBALS['phpgw']->db->unlock();
 
                                
comic_table($order,$sort,$filter,$start,$query,$qfield,$table_c);
@@ -84,16 +100,16 @@
                        else
                        {
                                
comic_table($order,$sort,$filter,$start,$query,$qfield,$table_c);
-                               
comic_entry('','add',$order,$sort,$filter,$start,$query,$qfield,$add_c);
+                               
//comic_entry('','add',$order,$sort,$filter,$start,$query,$qfield,$add_c);
                                
comic_entry($con,$act,$order,$sort,$filter,$start,$query,$qfield,$other_c);
                        }
                        break;
                case 'add':
-                       if($submit)
+                       if ($submit)
                        {
                                $GLOBALS['phpgw']->db->lock('phpgw_comic_data');
-                               $GLOBALS['phpgw']->db->query('insert into 
phpgw_comic_data (comic_name)'
-                                       ."values 
('".$comic_name."')",__LINE__,__FILE__);
+                               $GLOBALS['phpgw']->db->query('INSERT INTO 
phpgw_comic_data(data_name) '
+                                       . " VALUES 
('".$GLOBALS['phpgw']->db->db_addslashes($comic_name)."')",__LINE__,__FILE__);
                                $GLOBALS['phpgw']->db->unlock();
                        }
                        
comic_table($order,$sort,$filter,$start,$query,$qfield,$table_c);