From: <mo...@us...> - 2006-08-16 10:06:25
|
Update of /cvsroot/tikiwiki/tiki/lib/trackers In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv17591/lib/trackers Modified Files: Tag: BRANCH-1-9 trackerlib.php Log Message: fixed tracker data import when no status indicated in csv Index: trackerlib.php =================================================================== RCS file: /cvsroot/tikiwiki/tiki/lib/trackers/trackerlib.php,v retrieving revision 1.97.2.101 retrieving revision 1.97.2.102 diff -u -d -r1.97.2.101 -r1.97.2.102 --- trackerlib.php 13 Aug 2006 21:41:40 -0000 1.97.2.101 +++ trackerlib.php 16 Aug 2006 10:06:22 -0000 1.97.2.102 @@ -1036,13 +1036,14 @@ $fields = $this->list_tracker_fields($trackerId, 0, -1, 'position_asc', ''); while (($data = fgetcsv($csvHandle,100000)) !== FALSE) { $status = array_shift($data); + if (!$status) $status = 'o'; $itemId = array_shift($data); $categs = array_shift($data); $max = count($data); $nextId = $this->getOne('select max(`itemId`) from `tiki_tracker_items`'); - $itemId = $nextId + 1; + $itemId = (int) $nextId + 1; $query = "insert into `tiki_tracker_items`(`trackerId`,`created`,`lastModif`,`status`,`itemId`) values(?,?,?,?,?)"; - $result = $this->query($query,array((int) $trackerId,(int) $now,(int) $now,$status,$itemId)); + $result = $this->query($query,array((int) $trackerId,(int) $now,(int) $now,$status,(int)$itemId)); if (trim($categs)) { $cats = split(',',$categs); foreach ($cats as $c) { @@ -1058,7 +1059,7 @@ $data[$i] = ''; } elseif ($it['type'] == 'a') { $data[$i] = preg_replace('/\%\%\%/',"\r\n",$data[$i]); - } + } $this->query($query,array((int) $itemId,(int) $fieldId,$data[$i])); } } |