.
*/
add_action( 'wp_dashboard_setup', 'cforms2_dashboard_setup', 1 );
### Show entries on dashboard for WP2.7+
function cforms2_dashboard_setup() {
wp_add_dashboard_widget( 'cforms_dashboard', __( 'Recent cforms entries','cforms2' ), 'cforms2_dashboard' );
}
### Show entries on dashboard
function cforms2_dashboard() {
global $wpdb, $cformsSettings;
if (!current_user_can('track_cforms')) return;
$WHERE='';
for($i=0; $i<$cformsSettings['global']['cforms_formcount']; $i++){
$no = ($i==0)?'':($i+1);
if ( $cformsSettings['form'.$no]['cforms'.$no.'_dashboard'] == '1' )
$WHERE .= "'$no',";
}
if ( $WHERE <> '')
$WHERE = "WHERE form_id in (".substr($WHERE,0,-1).")";
else
return;
$entries = $wpdb->get_results("SELECT * FROM {$wpdb->cformssubmissions} $WHERE ORDER BY sub_date DESC LIMIT 0,5");
$content .= "\n".
"";
if( count($entries)>0 ){
foreach($entries as $entry){
$dateConv = mysql2date(get_option('date_format'), $entry->sub_date);
$content.= '.'images/cformsicon.png)
'.
"$entry->email ".
__('via','cforms2') . " ". $cformsSettings['form'.$entry->form_id]['cforms'.$entry->form_id.'_fname']. "".
" on ". $dateConv ."- '.__('No entries yet','cforms2').'
';
$content .= "
" . __('Visit the cforms tracking page for all entries ','cforms2') . " »
";
echo $content;
}