. */ function cforms2_setup_db () { global $wpdb, $cformsSettings, $localversion; $cformsSettings = (array) $cformsSettings; ### new global settings container ### Common HTML message information $cformsSettings['global']['cforms_style_doctype'] = ''; $cformsSettings['global']['v'] = $localversion; unset ( $cformsSettings['global']['cforms_style'] ); $cformsSettings['global']['cforms_style']['body'] = 'style="margin:0; padding:0; font-family: Verdana, Arial; font-size: 13px; color:#555;"'; $cformsSettings['global']['cforms_style']['meta'] = 'style="font-size: 90%; margin:0; background:#aaaaaa; padding:1em 2em 1em 0.6em; color:#555555; text-shadow:0 1px 0 #c5c5c5; border-bottom:1px solid #9d9d9d;"'; $cformsSettings['global']['cforms_style']['admin'] = 'style="background:#f0f0f0; border-top:1px solid #777; box-shadow:0 -2px 2px #999; -webkit-box-shadow:0 -2px 2px #999;"'; $cformsSettings['global']['cforms_style']['title'] = 'style="font-size: 90%; margin:0; background:#fcfcfc; padding:1em 2em 1em 0.6em; color:#888888; display:inline-block;"'; $cformsSettings['global']['cforms_style']['table'] = 'style="width:auto; margin: 0.2em 2em 2em; font-size: 100%;"'; $cformsSettings['global']['cforms_style']['fs'] = 'style="color:#555; padding:1em 0 0.4em; font-size: 110%; font-weight:bold; text-shadow:0 1px 0 #fff;"'; $cformsSettings['global']['cforms_style']['key_td'] = 'style="padding: 0.3em 1em; border-bottom:1px dotted #ddd; padding-right:2em; color:#888; width:1%;"'; $cformsSettings['global']['cforms_style']['val_td'] = 'style="padding: 0.3em 1em; border-bottom:1px dotted #ddd; padding-left:0; color:#333;"'; $cformsSettings['global']['cforms_style']['cforms'] = 'style="display:block; padding:1em 0.6em; margin-top:1em; background:#f7f7f7; color:#777; font-size:90%; text-align:right; font-family:Tahoma,Arial;"'; $cformsSettings['global']['cforms_style']['autoconf'] = 'style="padding:1em 1em 0; background:#f0f0f0; color:#333;"'; $cformsSettings['global']['cforms_style']['dear'] = 'style="margin:0.5em 30px; font-weight:bold; margin-bottom:1.2em;"'; $cformsSettings['global']['cforms_style']['confp'] = 'style="margin:0.5em 30px;"'; $cformsSettings['global']['cforms_style']['confirmationmsg'] = 'style="margin:4em 30px 0; padding-bottom:1em; font-size:80%; color:#aaa; font-family:Tahoma,Arial;"'; cforms2_setINI('global','cforms_showdashboard', ''); if (!isset($cformsSettings['global']['cforms_inexclude']['ex'])) $cformsSettings['global']['cforms_inexclude']['ex'] = ''; if (!isset($cformsSettings['global']['cforms_inexclude']['ids'])) $cformsSettings['global']['cforms_inexclude']['ids'] = ''; cforms2_setINI('global','cforms_no_css', ''); ### file upload $wp_upload_dir = wp_upload_dir(); cforms2_setINI('form','cforms_upload_dir', $wp_upload_dir['basedir'] ); cforms2_setINI('form','cforms_upload_ext', 'txt,zip,doc,rtf,xls'); cforms2_setINI('form','cforms_upload_size', '1024'); cforms2_setINI('form','cforms_dontclear', false); ### tracking settings cforms2_setINI('form','cforms_rsskey', md5(mt_rand()) ); cforms2_setINI('form','cforms_rss', false ); cforms2_setINI('form','cforms_rss_count', 5 ); ### fields for default form cforms2_setINI('form','cforms_count_fields', '5'); cforms2_setINI('form','cforms_count_field_1', __('My Fieldset', 'cforms').'$#$fieldsetstart$#$0$#$0$#$0$#$0$#$0'); cforms2_setINI('form','cforms_count_field_2', __('Your Name|Your Name', 'cforms').'$#$textfield$#$1$#$0$#$1$#$0$#$0'); cforms2_setINI('form','cforms_count_field_3', __('Email', 'cforms').'$#$textfield$#$1$#$1$#$0$#$0$#$0'); cforms2_setINI('form','cforms_count_field_4', __('Website', 'cforms').'|http://$#$textfield$#$0$#$0$#$0$#$0$#$0'); cforms2_setINI('form','cforms_count_field_5', __('Message', 'cforms').'$#$textarea$#$0$#$0$#$0$#$0$#$0'); cforms2_setINI('form','cforms_required', __('(required)', 'cforms')); cforms2_setINI('form','cforms_emailrequired', __('(valid email required)', 'cforms')); cforms2_setINI('form','cforms_confirm', '0'); cforms2_setINI('form','cforms_ajax', '1'); cforms2_setINI('form','cforms_fname', __('Your default form', 'cforms')); cforms2_setINI('form','cforms_csubject', __('Re: Your note', 'cforms').'$#$'.__('Re: Submitted form (copy)', 'cforms')); ### below is also in cforms-options.php! cforms2_setINI('form','cforms_cmsg', __('Dear {Your Name},', 'cforms') . "\n" . __('Thank you for your note!', 'cforms') . "\n". __('We will get back to you as soon as possible.', 'cforms') . "\n\n"); cforms2_setINI('form','cforms_cmsg_html', '

'. __('Dear {Your Name},', 'cforms') . "

'. __('Thank you for your note!', 'cforms') . "

'. __('We will get back to you as soon as possible.', 'cforms') . "\n

'.__('This is an automatic confirmation message.', 'cforms')." {Date}.

\n\n" ); ### cforms2_setINI('form','cforms_email', get_bloginfo('admin_email') ); cforms2_setINI('form','cforms_fromemail', get_bloginfo('admin_email') ); cforms2_setINI('form','cforms_bcc', ''); ### below is also in cforms-options.php! cforms2_setINI('form','cforms_header', __('A new submission (form: "{Form Name}")', 'cforms') . "\r\n============================================\r\n" . __('Submitted on: {Date}', 'cforms') . "\r\n" . __('Via: {Page}', 'cforms') . "\r\n" . __('By {IP} (visitor IP)', 'cforms') . ".\r\n" . ".\r\n" ); cforms2_setINI('form','cforms_header_html', '

' . __('A form has been submitted on {Date}, via: {Page} [IP {IP}]', 'cforms') . '

' ); ### cforms2_setINI('form','cforms_formdata', '1111'); cforms2_setINI('form','cforms_space', '30'); cforms2_setINI('form','cforms_noattachments', '0'); cforms2_setINI('form','cforms_subject', __('A comment from {Your Name}', 'cforms')); cforms2_setINI('form','cforms_submit_text', __('Submit', 'cforms')); cforms2_setINI('form','cforms_success', __('Thank you for your comment!', 'cforms')); cforms2_setINI('form','cforms_failure', __('Please fill in all the required fields.', 'cforms')); cforms2_setINI('form','cforms_limittxt', ''.__('No more submissions accepted at this time.', 'cforms').''); cforms2_setINI('form','cforms_working', __('One moment please...', 'cforms')); cforms2_setINI('form','cforms_popup', 'nn'); cforms2_setINI('form','cforms_showpos', 'ynyyy'); cforms2_setINI('form','cforms_hide', false); cforms2_setINI('form','cforms_redirect', false); cforms2_setINI('form','cforms_redirect_page', __('http://redirect.to.this.page', 'cforms')); cforms2_setINI('form','cforms_action', '0'); cforms2_setINI('form','cforms_action_page', 'http://'); cforms2_setINI('form','cforms_tracking', ''); cforms2_setINI('form','cforms_showdashboard', '1'); cforms2_setINI('form','cforms_maxentries', ''); cforms2_setINI('form','cforms_tellafriend', '01'); cforms2_setINI('form','cforms_dashboard', '0'); ### global file settings cforms2_setINI('global','cforms_formcount', '1'); cforms2_setINI('global','cforms_upload_err1', __('Generic file upload error. Please try again', 'cforms')); cforms2_setINI('global','cforms_upload_err2', __('File is empty. Please upload something more substantial.', 'cforms')); cforms2_setINI('global','cforms_upload_err3', __('Sorry, file is too large. You may try to zip your file.', 'cforms')); cforms2_setINI('global','cforms_upload_err4', __('File upload failed. Please try again or contact the blog admin.', 'cforms')); cforms2_setINI('global','cforms_upload_err5', __('File not accepted, file type not allowed.', 'cforms')); cforms2_setINI('global','cforms_rsskeyall', md5(mt_rand()) ); cforms2_setINI('global','cforms_rssall', false ); cforms2_setINI('global','cforms_rssall_count', 5 ); ### form verification $cap['h'] = 25; $cap['w'] = 115; $cap['c'] = '#000066'; $cap['l'] = '#000066'; $cap['f'] = 'font4.ttf'; $cap['a1'] = -12; $cap['a2'] = 12; $cap['f1'] = 17; $cap['f2'] = 19; $cap['bg'] = '1.gif'; $cap['c1'] = 4; $cap['c2'] = 5; $cap['ac'] = 'abcdefghijkmnpqrstuvwxyz23456789'; $cap['i'] = 'i'; cforms2_setINI('global','cforms_captcha_def', $cap ); cforms2_setINI('global','cforms_sec_qa', __('What color is snow?=white', 'cforms'). "\r\n" . __('The color of grass is=green', 'cforms'). "\r\n" . __('Ten minus five equals=five', 'cforms')); cforms2_setINI('global','cforms_codeerr', __('Please double-check your verification code.', 'cforms')); cforms2_setINI('global','cforms_show_quicktag', '1'); ### comment feature cforms2_setINI('global','cforms_commentsuccess', __('Thank you for leaving a comment.', 'cforms')); cforms2_setINI('global','cforms_commentWait', '15'); cforms2_setINI('global','cforms_commentParent', 'mycommentlist'); cforms2_setINI('global','cforms_commentHTML', "

{moderation}\n

{usercomment}

\nComment by {author} — {date} @ {time}\n

"); cforms2_setINI('global','cforms_commentInMod', ''.__('Your comment is awaiting moderation.', 'cforms').''); cforms2_setINI('global','cforms_avatar', '32'); cforms2_setINI('global','cforms_css', 'cforms2012.css'); cforms2_setINI('global','cforms_labelID', '0'); cforms2_setINI('global','cforms_liID', '0'); cforms2_setINI('global','cforms_database', '0'); cforms2_setINI('global','cforms_datepicker', '0'); cforms2_setINI('global','cforms_dp_start', '0'); cforms2_setINI('global','cforms_dp_date', 'mm/dd/yy'); cforms2_setINI('global','cforms_dp_days', __('S,M,T,W,T,F,S', 'cforms')); cforms2_setINI('global','cforms_dp_months', implode(',', array( __("January", 'cforms'), __("February", 'cforms'), __("March", 'cforms'), __("April", 'cforms'), __("May", 'cforms'), __("June", 'cforms'), __("July", 'cforms'), __("August", 'cforms'), __("September", 'cforms'), __("October", 'cforms'), __("November", 'cforms'), __("December", 'cforms') ))); $nav[0]=__('Previous Year', 'cforms'); $nav[1]=__('Previous Month', 'cforms'); $nav[2]=__('Next Year', 'cforms'); $nav[3]=__('Next Month', 'cforms'); $nav[4]=__('Close', 'cforms'); $nav[5]=__('Choose Date', 'cforms'); cforms2_setINI('global','cforms_dp_nav', $nav); ### migrate previous MP settings for( $i=1; $i<=$cformsSettings['global']['cforms_formcount']; $i++ ){ $no = ($i=='1')?'':$i; if( isset($cformsSettings['form'.$no]['mp']) && is_array($cformsSettings['form'.$no]['mp']) && !is_array($cformsSettings['form'.$no]['cforms'.$no.'_mp']) ){ foreach( array_keys($cformsSettings['form'.$no]['mp']) as $k ){ preg_match('/cforms\d*_(.*)/',$k, $kk); $cformsSettings['form'.$no]['cforms'.$no.'_mp'][$kk[1]] = $cformsSettings['form'.$no]['mp'][$k]; } } } ### migrate include/exclude pre v11.2 ! if( isset($cformsSettings['global']['cforms_include']) && $cformsSettings['global']['cforms_include'] <> '' ){ $cformsSettings['global']['cforms_inexclude']['ids'] = $cformsSettings['global']['cforms_include']; unset($cformsSettings['global']['cforms_include']); } ### migrate quoted values in months/days fields $cformsSettings['global']['cforms_dp_days'] = str_replace('"', '', $cformsSettings['global']['cforms_dp_days']); $cformsSettings['global']['cforms_dp_months'] = str_replace('"', '', $cformsSettings['global']['cforms_dp_months']); ### UPDATE 'the one' if ( get_option('cforms_settings') ) update_option('cforms_settings',$cformsSettings); else add_option('cforms_settings',$cformsSettings); ### updates existing tracking db if ( $wpdb->get_var("show tables like '$wpdb->cformsdata'") == $wpdb->cformsdata ) { ### fetch table column structure from the database $tablefields = $wpdb->get_results("DESCRIBE {$wpdb->cformsdata};"); $afield = array(); foreach($tablefields as $field) { array_push ($afield,$field->Field); } if ( !in_array('f_id', $afield) ) { $sql = "ALTER TABLE " . $wpdb->cformsdata . " ADD f_id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, CHANGE field_name field_name varchar(100) NOT NULL default '';"; $wpdb->query($sql); } } } ### check if option is set function cforms2_setINI($s,$v,$d) { global $cformsSettings; if( !is_array($cformsSettings[$s]) || !in_array($v, array_keys($cformsSettings[$s]) ) ) $cformsSettings[$s][$v]=$d; }