function getXML()
{
global $fnames, $wpdb, $count, $temp, $where, $in_list, $sortBy, $sortOrder, $cformsSettings, $charset;
if ($charset == 'utf-8') {
fwrite($temp, "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n<entries>\n");
} else {
fwrite($temp, "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>\n<entries>\n");
}
mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
@mysql_select_db(DB_NAME) or die("Unable to select database");
$sql = "SELECT ip, id, sub_date, form_id, field_name,field_val FROM {$wpdb->cformsdata},{$wpdb->cformssubmissions} WHERE sub_id=id {$where} {$in_list} ORDER BY {$sortBy} {$sortOrder}, f_id ASC";
$r = mysql_query($sql);
$sub_id = '';
while ($entry = mysql_fetch_array($r)) {
if ($entry[field_name] == 'page' || strpos($entry[field_name], 'Fieldset') !== false) {
continue;
}
$n = $entry[form_id] == '' ? '1' : $entry[form_id];
if ($sub_id != $entry[id]) {
if ($sub_id != '') {
fwrite($temp, "</entry>\n");
}
fwrite($temp, '<entry form="' . encData($fnames[$n]) . '" date="' . encData($entry[sub_date]) . '"' . ($_GET['addip'] ? ' ip="' . $entry[ip] . '"' : '') . ">\n");
$sub_id = $entry[id];
}
fwrite($temp, '<data col="' . encData(stripslashes($entry[field_name])) . '"><![CDATA[' . encData(stripslashes($entry[field_val])) . ']]></data>' . "\n");
}
### while
mysql_free_result($r);
mysql_close();
if ($sub_id != '') {
fwrite($temp, "</entry>\n</entries>\n");
}
return;
}
function getCSVTAB($format = 'csv')
{
global $fnames, $wpdb, $count, $temp, $where, $in_list, $sortBy, $sortOrder, $cformsSettings, $charset;
$results = $wpdb->get_results("SELECT ip, id, sub_date, form_id, field_name,field_val FROM {$wpdb->cformsdata},{$wpdb->cformssubmissions} WHERE sub_id=id {$where} {$in_list} ORDER BY {$sortBy} {$sortOrder}, f_id ASC");
/*
mysql_connect(DB_HOST,DB_USER,DB_PASSWORD);
@mysql_select_db(DB_NAME) or die( "Unable to select database");
$sql = "SELECT ip, id, sub_date, form_id, field_name,field_val FROM {$wpdb->cformsdata},{$wpdb->cformssubmissions} WHERE sub_id=id $where $in_list ORDER BY $sortBy $sortOrder, f_id ASC";
$r = mysql_query($sql);
*/
$br = "\n";
$buffer = array();
$body = '';
$sub_id = '';
$format = $format == "csv" ? "," : "\t";
$ipTab = $_GET['addip'] == 'true' ? $format : '';
$head = $_GET['header'] == 'true' ? $format . $format . $ipTab : '';
$last_n = '';
foreach ($results as $key => $entry) {
### while( $entry = mysql_fetch_array($r) ){
if ($entry->field_name == 'page' || strpos($entry->field_name, 'Fieldset') !== false) {
continue;
}
$next_n = $entry->form_id == '' ? '1' : $entry->form_id;
if ($sub_id != $entry->id) {
### new record starts
if ($buffer[body] != '') {
if ($_GET['header'] == 'true' && $buffer[last_n] != $buffer[last2_n]) {
fwrite($temp, $buffer[head] . $br . $buffer[body] . $br);
} else {
fwrite($temp, $buffer[body] . $br);
}
}
$buffer[body] = $body;
### save 1 line
$buffer[head] = $head;
### save 1 line
$buffer[last2_n] = $buffer[last_n];
$buffer[last_n] = $last_n;
$body = '"' . __('Form', 'cforms') . ': ' . encData($fnames[$next_n]) . '"' . $format . '"' . encData($entry->sub_date) . '"' . $format . ($_GET['addip'] == 'true' ? $entry->ip . $format : '');
$head = $_GET['header'] == 'true' ? $format . $format . $ipTab : '';
$last_n = $next_n;
$sub_id = $entry->id;
}
$url = '';
$urlTab = '';
if ($_GET['addurl'] == 'true' && strpos($entry->field_name, '[*')) {
preg_match('/.*\\[\\*(.*)\\]$/i', $entry->field_name, $t);
$no = $t[1] == '' ? $entry->form_id : ($t[1] == 1 ? '' : $t[1]);
$urlTab = $format;
$entry->field_name = substr($entry->field_name, 0, strpos($entry->field_name, '[*'));
$t = explode('$#$', stripslashes(htmlspecialchars($cformsSettings['form' . $no]['cforms' . $no . '_upload_dir'])));
$fdir = $t[0];
$fdirURL = $t[1];
$subID = $cformsSettings['form' . $no]['cforms' . $no . '_noid'] ? '' : $entry->id . '-';
if ($fdirURL == '') {
$url = $cformsSettings['global']['cforms_root'] . substr($fdir, strpos($fdir, $cformsSettings['global']['plugindir']) + strlen($cformsSettings['global']['plugindir']), strlen($fdir));
} else {
$url = $fdirURL;
}
$passID = $cformsSettings['form' . $no]['cforms' . $no . '_noid'] ? '' : $entry->id;
$fileInfoArr = array('name' => strip_tags($entry->field_val), 'path' => $url, 'subID' => $passID);
if (function_exists('my_cforms_logic')) {
$fileInfoArr = my_cforms_logic($results, $fileInfoArr, 'fileDestinationTrackingPage');
}
if (!array_key_exists('modified', $fileInfoArr)) {
$fileInfoArr['name'] = $subID . $fileInfoArr['name'];
}
$url = $fileInfoArr['path'] . '/' . $fileInfoArr['name'] . $format;
}
$head .= $_GET['header'] == 'true' ? '"' . encData(stripslashes($entry->field_name)) . '"' . $format . $urlTab : '';
$body .= '"' . str_replace('"', '""', encData(stripslashes($entry->field_val))) . '"' . $format . $url;
}
### foreach
### clean up buffer
if ($buffer[body] != '') {
if ($_GET['header'] == 'true' && $buffer[last_n] != $buffer[last2_n]) {
fwrite($temp, $buffer[head] . $br . $buffer[body] . $br);
} else {
fwrite($temp, $buffer[body] . $br);
}
}
### clean up last body
if ($_GET['header'] == 'true' && $buffer[last_n] != $next_n) {
fwrite($temp, $head . $br . $body . $br);
} else {
fwrite($temp, $body . $br);
}
/*
mysql_free_result($r);
mysql_close();
*/
return;
}
