cformssubmissions = $wpdb->prefix . 'cformssubmissions';
$wpdb->cformsdata = $wpdb->prefix . 'cformsdata';
### Check Whether User Can Manage Database
if(!current_user_can('manage_cforms') && !current_user_can('track_cforms')) {
die(__('Access Denied','cforms'));
}
// if all data has been erased quit
if ( get_option('cforms_formcount') == '' ){
?>
Plugins tab and either disable the plugin, or toggle its status (disable/enable) to revive cforms!', 'cforms') ?>
form_id.'_upload_dir'))) );
$fileuploaddir = $temp[0];
$fileval = $wpdb->get_row("SELECT DISTINCT field_val,form_id FROM {$wpdb->cformsdata},{$wpdb->cformssubmissions} WHERE sub_id = '$entry' AND id=sub_id AND field_name LIKE '%[*]%'");
$file = $fileuploaddir.'/'.$entry.'-'.$fileval->field_val;
$del='';
if ( $fileval->field_val <> '' ){
if ( file_exists( $file ) )
unlink ( $file );
}
$nuked = $wpdb->query("DELETE FROM {$wpdb->cformssubmissions} WHERE id = '$entry'");
$nuked = $wpdb->query("DELETE FROM {$wpdb->cformsdata} WHERE sub_id = '$entry'");
$i++;
endforeach;
?>
get_results("SELECT field_val,form_id FROM {$wpdb->cformsdata},{$wpdb->cformssubmissions} WHERE sub_id = '$entry' AND id=sub_id AND field_name LIKE '%[*]%'");
$del='';
$found = 0;
foreach( $filevalues as $fileval ) {
$temp = explode( '$#$',stripslashes(htmlspecialchars(get_option('cforms'.$fileval->form_id.'_upload_dir'))) );
$fileuploaddir = $temp[0];
$file = $fileuploaddir.'/'.$entry.'-'.$fileval->field_val;
if ( $fileval->field_val <> '' ){
if ( file_exists( $file ) ){
unlink ( $file );
$found = $found | 1;
}
else{
$found = $found | 2;
}
}
}
if ( $found==3 )
$del = ' '.__('(some associated attachment/s were not found!)','cforms');
else if ( $found==2 )
$del = ' '.__('(associated attachment/s were not found!)','cforms');
else if ( $found==1 )
$del = ' '.__('(including all attachment/s)','cforms');
$nuked = $wpdb->query("DELETE FROM {$wpdb->cformssubmissions} WHERE id = '$entry'");
$nuked = $wpdb->query("DELETE FROM {$wpdb->cformsdata} WHERE sub_id = '$entry'");
?>
.
'' || isset($_POST['showselected']) || isset($_POST['sqlwhere'])) && !isset($_POST['filter_x']) && !isset($_POST['delete']) && !isset($_POST['downloadselectedcforms']) && !$reorder ) {
if ( isset($_POST['showselected']) && isset($_POST['entries']) )
$sub_id = implode(',', $_POST['entries']);
else if ( $_POST['showid']<>'' )
$sub_id = $_POST['showid'];
else if ( isset($_POST['sqlwhere']) )
$sub_id = $_POST['sqlwhere'];
else
$sub_id = '-1';
$sql="SELECT *, form_id FROM {$wpdb->cformsdata},{$wpdb->cformssubmissions} WHERE sub_id in ($sub_id) AND sub_id=id ORDER BY sub_id, f_id";
$entries = $wpdb->get_results($sql);
?>
';
$sub_id='';
foreach ($entries as $entry){
if( $sub_id<>$entry->sub_id ){
$sub_id = $entry->sub_id;
echo '