[Phpgroupware-cvs] tts newticket.php,1.35

[fipsfuchs]

Update of tts

Modified Files:
     Branch: MAIN
            newticket.php lines: +8 -5

Log Message:
lastmod in sql statement included

====================================================
Index: tts/newticket.php
diff -u tts/newticket.php:1.34 tts/newticket.php:1.35
--- tts/newticket.php:1.34      Tue May 10 16:12:38 2005
+++ tts/newticket.php   Thu May 19 09:54:04 2005
@@ -77,9 +77,11 @@
                        $file_id = $GLOBALS['phpgw']->db->f('max(file_id)');
                }

-               $GLOBALS['phpgw']->db->query("insert into phpgw_tts_tickets 
(ticket_group,ticket_priority,ticket_owner,"
-                       . 
"ticket_assignedto,ticket_subject,ticket_category,ticket_billable_hours,"
-                       . 
"ticket_billable_rate,ticket_status,ticket_deadline,ticket_effort,ticket_type,ticket_platform,ticket_attachment,ticket_details)
 values ('"
+               $GLOBALS['phpgw']->db->query('INSERT INTO phpgw_tts_tickets '
+                       . '(ticket_group,ticket_priority,ticket_owner,'
+                       . 
'ticket_assignedto,ticket_subject,ticket_category,ticket_billable_hours,'
+                       . 
'ticket_billable_rate,ticket_status,ticket_deadline,ticket_effort,ticket_type, '
+                       . "ticket_platform, ticket_attachment, ticket_details, 
ticket_lastmod) VALUES ('"
       . (int) $_POST['ticket']['group'] . "','"
                        . (int) $_POST['ticket']['priority'] . "','"
                        . $GLOBALS['phpgw_info']['user']['account_id'] . "','"
@@ -93,7 +95,8 @@
                        . ((int) $_POST['ticket']['type'] ? (int) 
$_POST['ticket']['type'] : 0) . "','"
                        . ((int) $_POST['ticket']['platform'] ? (int) 
$_POST['ticket']['platform'] : 0) . "','"
                        . ((int) $file_id ? (int) $file_id : 0). "','"
-                       . 
$GLOBALS['phpgw']->db->db_addslashes($_POST['ticket']['details']) . 
"')",__LINE__,__FILE__);
+                       . 
$GLOBALS['phpgw']->db->db_addslashes($_POST['ticket']['details']) ."',"
+                       . time() . ")",__LINE__,__FILE__);

                $ticket_id = 
$GLOBALS['phpgw']->db->get_last_insert_id('phpgw_tts_tickets','ticket_id');