| 150 |
//composite primary key= nid sid cid |
//composite primary key= nid sid cid |
| 151 |
foreach($orig_fields[$nid] as $key=>$value){ |
foreach($orig_fields[$nid] as $key=>$value){ |
| 152 |
|
|
| 153 |
$component_type=db_result(db_query("SELECT c.type FROM {webform_component} c |
$component=db_fetch_object(db_query("SELECT type, cid FROM {webform_component} |
| 154 |
WHERE c.nid=%d AND c.form_key='%s'",$nid,$key)); |
WHERE nid=%d AND form_key='%s'", $nid,$key)); |
| 155 |
if($component_type=='date'){ |
if($component->type=='date'){ |
| 156 |
$date=db_fetch_array(db_query("SELECT * FROM {webform_submitted_data} WHERE nid=129 AND cid=50")); |
$date=array(); |
| 157 |
$date=webform_expand_date($date); |
$query=db_query("select no, data from {webform_submitted_data} where nid=%d and sid=%d and cid=%d",$nid,$sid,$component->cid); |
| 158 |
$timestamp=mktime(0, 0, 0, $date['#value']['month'], $date['#value']['day'], $date['#value']['year']); |
while($data=db_fetch_object($query)){ |
| 159 |
$text_fields[$value]=date("M d, Y",$timestamp); |
switch($data->no){ |
| 160 |
|
case '0': $date['month']=$data->data;break; |
| 161 |
|
case '1': $date['day']=$data->data;break; |
| 162 |
|
case '2': $date['year']=$data->data;break; |
| 163 |
|
} |
| 164 |
|
} |
| 165 |
|
$timestamp=mktime(0, 0, 0, $date['month'], $date['day'], $date['year']); |
| 166 |
|
$text_fields[]=date("M d, Y",$timestamp); |
| 167 |
} |
} |
| 168 |
else{ |
else{ |
| 169 |
$text_fields[$value]=db_result(db_query("SELECT s.data |
$text_fields[$value]=db_result(db_query("SELECT s.data |