[Phpgroupware-cvs] CVS: calendar/inc class.socalendar_sql.inc.php,1.32,1.33

[Ralf Becker <address@hidden>]

Update of /cvsroot/phpgroupware/calendar/inc
In directory subversions:/tmp/cvs-serv12627

Modified Files:
        class.socalendar_sql.inc.php 
Log Message:
fix for bug #3162
creation of new calendar entries fails, because tempnam used to create the id 
returns a to long string (possibly because TMP_DIR is to long)
use the get_last_insert_id function now


Index: class.socalendar_sql.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/calendar/inc/class.socalendar_sql.inc.php,v
retrieving revision 1.32
retrieving revision 1.33
diff -C2 -r1.32 -r1.33
*** class.socalendar_sql.inc.php        23 Nov 2002 14:19:32 -0000      1.32
--- class.socalendar_sql.inc.php        14 Apr 2003 21:35:50 -0000      1.33
***************
*** 452,455 ****
--- 452,456 ----
                                $event['uid'] = 
$part[0].'-'.$part[1].'@'.$id_suffix;
                        }
+ /*    makes problems if tempnam is to long for title column, see bug #3162
                        $temp_name = 
tempnam($GLOBALS['phpgw_info']['server']['temp_dir'],'cal');
                        $this->stream->query('INSERT INTO 
phpgw_cal(uid,title,owner,priority,is_public,category) '
***************
*** 458,461 ****
--- 459,468 ----
                        $this->stream->next_record();
                        $event['id'] = $this->stream->f('cal_id');
+ */
+                       $this->stream->query('INSERT INTO 
phpgw_cal(uid,title,owner,priority,is_public,category) '
+                               . 
"values('".$event['uid']."','".$this->stream->db_addslashes($event['title'])
+                               . 
"',".$event['owner'].','.$event['priority'].','.$event['public'].",'"
+                               . $event['category']."')",__LINE__,__FILE__);
+                       $event['id'] = 
$this->stream->get_last_insert_id('phpgw_cal','cal_id');
                }