'' )
$smtpsettings=explode('$#$',$cformsSettings['global']['cforms_smtp']);
if ( $smtpsettings[0]=='1' ) {
if ( file_exists(dirname(__FILE__) . '/phpmailer/class.phpmailer.php') )
require_once(dirname(__FILE__) . '/phpmailer/cforms_phpmailer.php');
else
$smtpsettings[0]=='0';
}
### debug message handling
function db($m){
global $cfdebug,$cfdebugmsg;
if ( $cfdebug ) $cfdebugmsg .= "$m\n";
}
function dbflush(){
global $cfdebug,$cfdebugmsg;
if ( $cfdebug ) echo ''."\ndebug:\n$cfdebugmsg\n".'';
}
### make time
function sec2hms($s){
$t='';
$h = intval(intval($s) / 3600);
$m = intval(($s / 60) % 60);
if ($h>0) $t .= " $h ".__('hour(s)', 'cforms').' &';
if ($m>0) $t .= " $m ".__('minute(s)', 'cforms');
return $t;
}
### make time
function cf_make_time($t) {
$dh = explode(' ',$t);
$d = explode('/',$dh[0]);
$h = explode(':',$dh[1]);
return mktime($h[0], $h[1], '0', $d[1], $d[0], $d[2]);
}
### check time constraints
function cf_check_time($no) {
global $cformsSettings;
$t1f = $t2f = false;
if( strlen($cformsSettings['form'.$no]['cforms'.$no.'_startdate']) > 1 )
$t1 = cf_make_time(stripslashes($cformsSettings['form'.$no]['cforms'.$no.'_startdate']));
else
$t1f=true;
if( strlen($cformsSettings['form'.$no]['cforms'.$no.'_enddate']) > 1 )
$t2 = cf_make_time(stripslashes($cformsSettings['form'.$no]['cforms'.$no.'_enddate']));
else
$t2f=true;
return ( ($t1f || $t1 <= time()) && ($t2f || $t2 >= time()) )?true:false;
}
### prep captcha get call
function get_captcha_uri() {
global $cformsSettings;
$cap = $cformsSettings['global']['cforms_captcha_def'];
$c1 = prep( $cap['c1'],'3' );
$c2 = prep( $cap['c2'],'5' );
$ac = prep( urlencode($cap['ac']),urlencode('abcdefghijkmnpqrstuvwxyz23456789') );
$i = prep( $cap['i'],'' );
$h = prep( $cap['h'],25 );
$w = prep( $cap['w'],115 );
$c = prep( $cap['c'],'000066' );
$l = prep( $cap['l'],'000066' );
$f = prep( $cap['f'],'font4.ttf' );
$a1 = prep( $cap['a1'],-12 );
$a2 = prep( $cap['a2'],12 );
$f1 = prep( $cap['f1'],17 );
$f2 = prep( $cap['f2'],19 );
$bg = prep( $cap['bg'],'1.gif');
return "&c1={$c1}&c2={$c2}&ac={$ac}&i={$i}&w={$w}&h={$h}&c={$c}&l={$l}&f={$f}&a1={$a1}&a2={$a2}&f1={$f1}&f2={$f2}&b={$bg}";
}
### sanitize label ID's
function cf_sanitize_ids($t) {
$t = strip_tags($t);
$t = preg_replace('|%([a-fA-F0-9][a-fA-F0-9])|', '---$1---', $t);
$t = str_replace('%', '', $t);
$t = preg_replace('|---([a-fA-F0-9][a-fA-F0-9])---|', '%$1', $t);
$t = remove_accents($t);
if (seems_utf8($t)) {
$t = utf8_uri_encode($t, 200);
}
$t = preg_replace('/&.+?;/', '', $t); // kill entities
$t = preg_replace('/\s+/', '-', $t);
$t = preg_replace('|-+|', '-', $t);
$t = preg_replace("|'|", '-', $t);
$t = trim($t, '-');
$t = str_replace('[', '', $t);
$t = str_replace(']', '', $t);
return $t;
}
### strip stuff
function prep($v,$d) {
return ($v<>'') ? stripslashes(htmlspecialchars($v)) : $d;
}
### map data
function allTracks($session){
$t = array(); $i = array();
### clean up underscores
foreach( array_keys($session) as $key){
if ( strpos($key,'cf_')===false ) continue;
foreach( $session[$key] as $k => $v )
$t[$key.'_'.$k] = $v;
}
return $t;
}
### formatEmail data
function formatEmail($track,$no){
global $cformsSettings;
$customspace = (int)($cformsSettings['form'.$no]['cforms'.$no.'_space']>0) ? $cformsSettings['form'.$no]['cforms'.$no.'_space'] : 30;
$t = $h = '';
$eol = ($cformsSettings['global']['cforms_crlf'][b]!=1)?"\r\n":"\n";
foreach( array_keys($track) as $k){
$v = stripslashes($track[$k]);
### Exclude empty fields?
if ($v == '' && $cformsSettings['form'.$no]['cforms'.$no.'_emptyoff'])
continue;
### fix labels
if ( in_array($k,array('luv','subscribe','cauthor','email','url','comment','send2author')) ) continue;
if ( preg_match('/\$\$\$/',$k) ) continue;
if ( strpos($k, 'cf_form') !== false && preg_match('/^cf_form\d*_(.+)/',$k, $r) )
$k = $r[1];
if ( strpos($k, '___') !== false && preg_match('/^(.+)___\d+/',$k, $r) )
$k = $r[1];
### fieldsets
if ( strpos($k,'FieldsetEnd')!==false ){
$t .= $eol;
$h .= '| |
' . $eol;
continue;
}
elseif ( strpos($k,'Fieldset')!==false ){
$space='-';
$n = ((($customspace*2)+2) - strlen(strip_tags($v))) / 2;
$n = ($n<0)?0:$n;
if ( strlen(strip_tags($v)) < (($customspace*2)-2) )
$space = str_repeat("-", $n );
$t .= substr($eol."$space".stripslashes( strip_tags($v) )."$space",0,($customspace*2)) . $eol . $eol;
$h .= '| ' . $v . ' |
' . $eol;
continue;
}
### Upload fields?
if ( strpos($k,'[*')!==false ) {
$k = substr($k,0,strpos($k,'[*'));
}
### HTML = TEXT (key, value)
$hk = $k;
$hv = htmlspecialchars($v);
### checkboxes get a symbol for value
if ( $v == '(x)' )
$hv = "✔";
### CRs for textareas \r\n user input hardcoded!
if ( strpos($v,"\n")!==false ) {
$k = $eol . $k;
$hv = str_replace("\r\n","\n",$v);
$hv = str_replace("\n",'
'.$eol,$hv);
$v = $eol . $v . $eol;
}
### TEXT: spacing
$space='';
if ( strlen(stripslashes($k)) < $customspace ) ### don't count ->\" sometimes adds more spaces?!?
$space = str_repeat(" ",$customspace-strlen(stripslashes($k)));
### create formdata block for email
$t .= stripslashes( strip_tags($k) ). ': '. $space . $v . $eol;
$h .= '| ' . $hk . ' | ' . $hv . ' |
' . $eol;
}
$r['text'] = $t;
$r['html'] = ''.stripslashes($cformsSettings['form'.$no]['cforms'.$no.'_fname']).'powered by cformsII ';
return $r;
}
### write DB record
function write_tracking_record($no,$field_email,$c=''){
global $wpdb, $track, $cformsSettings;
db('WRITING TRACKING RECORD');
$noTracking = $cformsSettings['form'.$no]['cforms'.$no.'_notracking'];
$mpSession = ($cformsSettings['form'.$no]['cforms'.$no.'_mp']['mp_form'] && $cformsSettings['form'.$no]['cforms'.$no.'_mp']['mp_email']);
if ( $noTracking || $mpSession ){
db("....bailing out: noTracking=$noTracking, mpSession=$mpSession\n");
return -1; ### bail out
}
if ( $cformsSettings['global']['cforms_database'] == '1' ) {
### first process fields, perhaps need to bail out
$sql='';
$dosave=false;
foreach ( $track as $k => $v ){
if( $c <> '' ){
if( !preg_match('/\$\$\$custom/',$k) )
continue;
else{
$k = $v;
$v = $track[$k];
}
}
### clean up keys
if ( preg_match('/\$\$\$/',$k) ) continue;
if ( strpos($k, 'cf_form') !== false && preg_match('/^cf_form\d*_(.+)/',$k, $r) )
$k = $r[1];
if ( strpos($k, '___') !== false && preg_match('/^(.+)___\d+/',$k, $r) )
$k = $r[1];
$sql .= "('-XXX-','".addslashes($k)."','".addslashes($v)."'),";
$dosave=true;
}
if( !$dosave ) return;
### good to go:
$page = (substr($cformsSettings['form'.$no]['cforms'.$no.'_tellafriend'],0,1)=='2')?$_POST['cforms_pl'.$no]:get_current_page(); // WP comment fix
$wpdb->query("INSERT INTO $wpdb->cformssubmissions (form_id,email,ip,sub_date) VALUES ".
"('" . $no . "', '" . $field_email . "', '" . cf_getip() . "', '".gmdate('Y-m-d H:i:s', current_time('timestamp'))."');");
$subID = $wpdb->get_row("select LAST_INSERT_ID() as number from $wpdb->cformssubmissions;");
$subID = ($subID->number=='')?'1':$subID->number;
if( $c <> '' )
$sql = "INSERT INTO $wpdb->cformsdata (sub_id,field_name,field_val) VALUES ('$subID','commentID','$c'),('$subID','email','$field_email'),".$sql;
else
$sql = "INSERT INTO $wpdb->cformsdata (sub_id,field_name,field_val) VALUES ('$subID','page','$page'),".$sql;
$wpdb->query( substr(str_replace('-XXX-',$subID,$sql) ,0,-1));
}
else
$subID = 'noid';
return $subID;
}
### move uploaded files to local dir
function cf_move_files(&$trackf, $no, $subID){
global $cformsSettings,$file;
$temp = explode( '$#$',stripslashes(htmlspecialchars($cformsSettings['form'.$no]['cforms'.$no.'_upload_dir'])) );
$fileuploaddir = $temp[0];
$inSession = (strpos($subID,'xx') !== false);
//if( !$inSession )
$subID_ = ($cformsSettings['form'.$no]['cforms'.$no.'_noid']) ? '' : $subID.'-';
$file2 = $file;
$i=0;
$_SESSION['cforms']['upload'][$no]['doAttach'] = !($cformsSettings['form'.$no]['cforms'.$no.'_noattachments']);
### debug
db("... in session=$inSession, moving files on form $no, tracking ID=$subID_");
if ( is_array($file2) && isset($file2[tmp_name]) ) {
foreach( $file2[tmp_name] as $tmpfile ) {
### copy attachment to local server dir
if ( is_uploaded_file($tmpfile) ){
$fileInfoArr = array('name'=>str_replace(' ','_',$file2['name'][$i]),'path'=>$fileuploaddir, 'subID'=>$subID);
if ( function_exists('my_cforms_logic') )
$fileInfoArr = my_cforms_logic( &$trackf, $fileInfoArr, 'fileDestination');
if( ! array_key_exists('modified', $fileInfoArr) )
$fileInfoArr['name'] = $subID_ . $fileInfoArr['name'];
$destfile = $fileInfoArr['path'].'/'.$fileInfoArr['name'];
move_uploaded_file($tmpfile,$destfile );
### debug
db(" $tmpfile -> $destfile");
$file[tmp_name][$i] = $destfile;
if( $inSession )
$_SESSION['cforms']['upload'][$no]['files'][] = $destfile;
}
$i++;
}
}
}
### base64 encode attached files
function cf_base64($fn, $attachFlag=false){
global $fdata, $fpointer;
if( file_exists($fn) ){
$fdata[$fpointer][name] = $fn;
$fdata[$fpointer][doAttach] = $attachFlag;
$fpointer++;
}
return;
}
### MIME / extensions
function getMIME ($ext){
$all_mime = array('txt'=>'text/plain', 'htm'=>'text/html', 'html'=>'text/html', 'gif'=>'image/gif', 'png'=>'image/png',
'jpeg'=>'image/jpeg', 'jpg'=>'image/jpeg', 'tif'=>'image/tiff', 'bmp'=>'image/x-ms-bmp', 'wav'=>'audio/wav',
'mpeg'=>'video/mpeg', 'mpg'=>'video/mpeg', 'mov'=>'video/quicktime', 'avi'=>'video/x-msvideo',
'rtf'=>'application/rtf', 'pdf'=>'application/pdf', 'zip'=>'application/zip', 'hqx'=>'application/mac-binhex40',
'sit'=>'application/x-stuffit', 'exe'=>'application/octet-stream', 'ppz'=>'application/mspowerpoint',
'ppt'=>'application/vnd.ms-powerpoint', 'ppj'=>'application/vnd.ms-project', 'xls'=>'application/vnd.ms-excel',
'doc'=>'application/msword');
return (!$all_mime[$ext])?'application/octet-stream':$all_mime[$ext];
}
### replace standard & custom variables in message/subject text
function get_current_page($clean=false){
global $Ajaxpid;
$page = $_SERVER['REQUEST_URI'];
if ($clean && strpos($page,'?')>0)
$page = substr( $page, 0, strpos($page,'?'));
$page = (trim($page)=='' || strpos($page,'lib_ajax.php')!==false )?$_SERVER['HTTP_REFERER']:trim($page); // for ajax
return htmlspecialchars($page);
}
### check for post custom fields in string
function check_post_vars($fv){
preg_match_all('/\\{([^\\{]+)\\}/',$fv,$fall);
if ( count($fall[1]) > 0 ) {
$custArr = get_post_custom( get_the_ID() );
foreach ( $fall[1] as $fvar ) {
if( $custArr[$fvar][0] <> '')
$fv = str_replace('{'.$fvar.'}', $custArr[$fvar][0], $fv);
}
}
return $fv;
}
### look for default/system variables
function check_default_vars($m,$no) {
global $subID, $Ajaxpid, $AjaxURL, $post, $wpdb, $wp_db_version, $cformsSettings;
$eol = ($cformsSettings['global']['cforms_crlf'][b]!=1)?"\r\n":"\n";
if ( $_POST['comment_post_ID'.$no] )
$pid = $_POST['comment_post_ID'.$no];
else if ( $Ajaxpid<>'' )
$pid = $Ajaxpid;
else if ( function_exists('get_the_ID') )
$pid = get_the_ID();
if ( $_POST['cforms_pl'.$no] )
$permalink = $_POST['cforms_pl'.$no];
else if ( $Ajaxpid<>'' )
$permalink = $AjaxURL;
else if ( function_exists('get_permalink') && function_exists('get_userdata') )
$permalink = get_permalink($pid);
###
### if the "month" is not spelled correctly, try the commented out line instead of the one after
###
### $date = utf8_encode(html_entity_decode( mysql2date(get_option('date_format'), current_time('mysql')) ));
$date = mysql2date(get_option('date_format'), current_time('mysql'));
$time = gmdate(get_option('time_format'), current_time('timestamp'));
$page = get_current_page();
if ( substr($cformsSettings['form'.$no]['cforms'.$no.'_tellafriend'],0,1)=='2' ) // WP comment fix
$page = $permalink;
$find = $wpdb->get_row("SELECT p.post_title, p.post_excerpt, u.display_name FROM $wpdb->posts AS p LEFT JOIN ($wpdb->users AS u) ON p.post_author = u.ID WHERE p.ID='$pid'");
$CurrUser = wp_get_current_user();
$m = str_replace( '{Referer}', $_SERVER['HTTP_REFERER'], $m );
$m = str_replace( '{PostID}', $pid, $m );
$m = str_replace( '{Form Name}', $cformsSettings['form'.$no]['cforms'.$no.'_fname'], $m );
$m = str_replace( '{Page}', $page, $m );
$m = str_replace( '{Date}', $date, $m );
$m = str_replace( '{Author}', $find->display_name, $m );
$m = str_replace( '{Time}', $time, $m );
$m = str_replace( '{IP}', cf_getip(), $m );
$m = str_replace( '{BLOGNAME}', get_option('blogname'), $m );
$m = str_replace( '{CurUserID}', $CurrUser->ID, $m );
$m = str_replace( '{CurUserName}', $CurrUser->display_name, $m );
$m = str_replace( '{CurUserEmail}',$CurrUser->user_email, $m );
$m = str_replace( '{CurUserFirstName}', $CurrUser->user_firstname, $m );
$m = str_replace( '{CurUserLastName}', $CurrUser->user_lastname, $m );
$m = str_replace( '{Permalink}', $permalink, $m );
$m = str_replace( '{Title}', $find->post_title, $m );
$m = str_replace( '{Excerpt}', $find->post_excerpt, $m );
$m = preg_replace( "/\r\n\./", "\n", $m );
### normalize
$m = str_replace( "\r\n", "\n", $m );
$m = str_replace( "\r", "\n", $m );
$m = str_replace( "\n", $eol, $m );
if ( $cformsSettings['global']['cforms_database'] && $subID<>'' )
$m = str_replace( '{ID}', $subID, $m );
return $m;
}
### look for custom variables
function check_cust_vars($m,$t,$no,$html=false) {
global $cformsSettings;
$eol = ($cformsSettings['global']['cforms_crlf'][b]!=1)?"\r\n":"\n";
preg_match_all('/\\{([^\\{]+)\\}/',$m,$findall);
if ( count($findall[1]) > 0 ) {
$allvars = array_keys($t);
foreach ( $findall[1] as $fvar ) {
$fTrackedVar = addslashes($fvar);
### convert _fieldXYZ to actual label name tracked...
if ( strpos($fvar,'_field')!==false ){
$fNo = substr($fvar,6);
if ( $allvars[$fNo]<>'' )
$fTrackedVar = $t['$$$'.$fNo]; ### reset $fvar to actual label name and continue
}
### convert if alt [id:] used
if ( in_array( '$$$'.$fTrackedVar, $allvars ) ){
if ( $t['$$$'.$fTrackedVar]<>'' )
$fTrackedVar = $t['$$$'.$fTrackedVar]; ### reset $fvar to actual label name and continue
}
### check if label name is tracked...
if( in_array( $fTrackedVar,$allvars ) ){
$v = stripslashes($t[$fTrackedVar]);
### CRs for textareas \r\n user input hardcoded!
if ( $html && strpos($v,"\n")!==false )
$v = str_replace("\n",'
'.$eol,$v);
$m = str_replace('{'.$fvar.'}', $v, $m);
}
}
}
return $m;
}
### Can't use WP's function here, so lets use our own
if ( !function_exists('cf_getip') ) :
function cf_getip() {
if (isset($_SERVER)) {
if (isset($_SERVER["HTTP_X_FORWARDED_FOR"]))$ip_addr = $_SERVER["HTTP_X_FORWARDED_FOR"];
elseif (isset($_SERVER["HTTP_CLIENT_IP"])) $ip_addr = $_SERVER["HTTP_CLIENT_IP"];
else $ip_addr = $_SERVER["REMOTE_ADDR"];
} else {
if ( getenv( 'HTTP_X_FORWARDED_FOR' ) ) $ip_addr = getenv( 'HTTP_X_FORWARDED_FOR' );
elseif ( getenv( 'HTTP_CLIENT_IP' ) ) $ip_addr = getenv( 'HTTP_CLIENT_IP' );
else $ip_addr = getenv( 'REMOTE_ADDR' );
}
return $ip_addr;
}
endif;
class cformsRSS {
function vars($public_query_vars) {
$public_query_vars[] = 'cformsRSS';
return $public_query_vars;
}
function outputRSS() {
global $wpdb, $cformsSettings, $plugindir;
$temp=get_query_var('cformsRSS');
if( $temp <> '' ) {
$cformsRSS = explode('$#$', $temp);
$no = $cformsRSS[0];
$key = $cformsRSS[1];
$all = $no=='-1' && $cformsSettings['global']['cforms_rssall'] && $cformsSettings['global']['cforms_rsskeyall'] == $key;
$single = $no<>'-1' && $cformsSettings['form'.$no]['cforms'.$no.'_rss'] && $key<>'' && $cformsSettings['form'.$no]['cforms'.$no.'_rsskey'] == $key;
if( $all || $single ){
### add opt. form content
$WHERE='';
if( $all )
$rsscount = ($cformsSettings['global']['cforms_rssall_count']>0)?$cformsSettings['global']['cforms_rssall_count']:5;
else if( $single ){
$WHERE = "WHERE form_id = '".$no."'";
$rsscount = ($cformsSettings['form'.$no]['cforms'.$no.'_rss_count']>0)?$cformsSettings['form'.$no]['cforms'.$no.'_rss_count']:5;
}
$entries = $wpdb->get_results("SELECT * FROM {$wpdb->cformssubmissions} $WHERE ORDER BY sub_date DESC LIMIT 0,".$rsscount);
$content = '';
if( count($entries)>0 ){
foreach($entries as $entry){
$f = $cformsSettings['form'.$entry->form_id]['cforms'.$entry->form_id.'_rss_fields'];
$date = mysql2date(get_option('date_format'), $entry->sub_date);
$time = mysql2date(get_option('time_format'), $entry->sub_date);
$title = '['.$entry->id.'] '.$entry->email;
$description = '#'.$entry->id.' '. "$date $time" .( $single?'':' "'.$cformsSettings['form'.$entry->form_id]['cforms'.$entry->form_id.'_fname'].'":' ).'';
$data = $wpdb->get_results("SELECT * FROM {$wpdb->cformsdata} WHERE sub_id='{$entry->id}'");
if( is_array($f) && array_count_values($f)>0 ){
foreach( $data as $e ){
if( array_search($e->field_name,$f)!==false )
$description .= ''.$e->field_name.':
'.$e->field_val.'
- '."\n".
"\t\t".''.$title.''."\n".
"\t\t".''.$description.''."\n".
"\t\t".''.$entrylink.''."\n".
"\t\t".''.$entrylink.''."\n".
"\t\t".''.mysql2date('D, d M Y H:i:s +0000', $entry->sub_date, false).''."\n".
"\t".'
'."\n";
}
}
else
$content = '- '.__('No entries yet','cforms').''.__('You might want to check back in a little while...','cforms').''.
''.gmdate('D, d M Y H:i:s +0000', current_time('timestamp')).'
';
header( 'Content-Type: text/xml; charset='.get_option('blog_charset') );
?>
'; ?>
<?php if ($single) echo __('New submissions for >>', 'cforms').' '.stripslashes($cformsSettings['form'.$no]['cforms'.$no.'_fname']); else _e('All new form submissions', 'cforms'); ?>
'')?'LIMIT 0,'.$limit:'';
$ORDER_1 = $cfsort = '';
if( in_array($s,array('id','form','timestamp','email','ip')) )
$ORDER_1 = "ORDER BY " . $s . ' ' . $sd;
else{
$ORDER_1 = "ORDER BY id DESC";
$cfsort = $s;
}
//SORT
$cfdata = array();
$cfsortdir = $sd;
//GENERAL WHERE
$where = false;
$fname_in = '';
for ($i=1; $i <= $cformsSettings['global']['cforms_formcount']; $i++){
$n = ( $i==1 )?'':$i;
$fnames[$i]=stripslashes($cformsSettings['form'.$n]['cforms'.$n.'_fname']);
if ( $fname && preg_match('/'.$fname.'/i',$fnames[$i]) )
$fname_in .= "'$n'".',';
}
if ( $fname<>'' )
$where = ($fname_in<>'')?' form_id IN ('.substr($fname_in,0,-1).')':" form_id='-1'";
$where .= $from?($where?' AND':'')." sub_date > '$from'":'';
$where .= $to?($where?' AND':'')." sub_date < '$to'":'';
$where = $where?'WHERE'.$where:'';
//
$in = '';
$sql = "SELECT *, UNIX_TIMESTAMP(sub_date) as rawdate FROM {$wpdb->cformssubmissions} $where $ORDER_1 $limit";
$all = $wpdb->get_results($sql);
/*
echo '
>>'.$sql;
echo '
'.print_r($all,1).'
';
die();
*/
foreach ( $all as $d ){
$in = $in . $d->id . ',';
$n = ( $d->form_id=='' )?1:$d->form_id;
$cfdata[$d->id]['id'] = $d->id;
$cfdata[$d->id]['form'] = $fnames[$n];
$cfdata[$d->id]['date'] = $d->sub_date;
$cfdata[$d->id]['timestamp'] = $d->rawdate;
$cfdata[$d->id]['email'] = $d->email;
$cfdata[$d->id]['ip'] = $d->ip;
}
if ( $in=='' )
return false;
$where = 'sub_id IN ('.substr($in,0,-1).')';
$sql = "SELECT * FROM {$wpdb->cformsdata} WHERE $where";
$all = $wpdb->get_results($sql);
$offsets = array();
foreach ( $all as $d ){
if( $offsets[$d->sub_id][$d->field_name]<>'')
$offsets[$d->sub_id][$d->field_name]++;
else
$offsets[$d->sub_id][$d->field_name]=1;
$tmp = '';
if( $offsets[$d->sub_id][$d->field_name]>1)
$tmp = '-'.$offsets[$d->sub_id][$d->field_name];
$cfdata[$d->sub_id]['data'][$d->field_name.$tmp] = $d->field_val;
}
if ( $cfsort <> '' ){
$cfdataTMP = $cfdata;
uksort ($cfdata, "cf_sort");
}
return $cfdata;
}
function cf_sort( $a,$b ){
global $cfdataTMP, $cfsort, $cfsortdir;
if (!is_array($a) && !is_array($b)){
$na = ($cfdataTMP[$a]['data'][$cfsort]<>'') ? $cfdataTMP[$a]['data'][$cfsort]:false;
$nb = ($cfdataTMP[$b]['data'][$cfsort]<>'') ? $cfdataTMP[$b]['data'][$cfsort]:false;
if ( !($na && $nb) ){
//echo "err: ($a=$naD) :: ($b=$nbD)
";
if ( !$na ) return 1;
if ( !$nb ) return -1;
return 0;
}
}
//echo "($a=$na) :: ($b=$nb)
";
$tmpA=(int)trim($na);
$tmpB=(int)trim($nb);
if ( is_numeric($na) && is_numeric($nb) ){
if ( stristr($cfsortdir,'asc')===false ){
return ($tmpB > $tmpA)?-1:1;
} else {
return ($tmpA < $tmpB)?-1:1;
}
} else {
if ( stristr($cfsortdir,'asc')===false ){
return strcasecmp($nb, $na);
}else{
// echo "$nb < $na = ".strcasecmp($nb, $na)."
";
return strcasecmp($na, $nb);
}
}
}
### API functions #2 : get tracked entries
function cf_extra_comment_data( $id ) {
global $wpdb;
$all = $wpdb->get_results("SELECT * FROM {$wpdb->cformsdata} WHERE sub_id = (SELECT sub_id FROM {$wpdb->cformsdata} WHERE field_name='commentID' AND field_val='$id')");
foreach( $all as $a )
$r[$a->field_name]=$a->field_val;
return $r;
}
?>