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; }