'',
'ab_dspcnt' => '',
'ab_target' => '',
'ab_adsense' => '',
'ab_adsense_fixed' => '',
'ab_adsense_pos' => '',
'ab_adsense_pubid' => '',
'ab_adsense_channel' => '',
'ab_adsense_corners' => '',
'ab_adsense_col_border' => '',
'ab_adsense_col_title' => '',
'ab_adsense_col_bg' => '',
'ab_adsense_col_txt' => '',
'ab_adsense_col_url' => '',
'ab_nocss' => '',
'ab_width' => '',
'ab_padding' => '',
'ab_nofollow' => '',
'ab_powered' => '',
'ab_yah' => '',
'ab_yourad' => '',
'ab_geot' => '',
'ab_yaht' => '',
'ab_yahurl' => '',
'ab_anet' => '',
'ab_anetu' => '',
'ab_anett' => '',
'ab_fix' => '',
'ab_count' => ''
);
$ol_flash = '';
if(isset($_POST['ip2natinstall'])) {
$installed = get_option('ip2nation_db_installed');
echo"checking for previous version
";
if(isset($installed)){
// delete old data
$wpdb->query("DELETE FROM ip2nation");
$wpdb->query("DELETE FROM ip2nationCountries");
}
echo"installing new version (be patient, this can take some time)
";
// install ip2nation database
// this is quite a large sql file, so it will take some time to process
ini_set('max_execution_time', 600); //600 seconds = 10 minutes
require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
ob_start();
include('ip2n_countries.sql');
$sql = ob_get_contents();
ob_end_clean();
dbDelta($sql);
echo"Old data deleted and new tables created
";
echo"Adding data
";
ob_start();
include('ip2n_ip-1.sql');
$sql = ob_get_contents();
ob_end_clean();
dbDelta($sql);
echo"1 of 13 done...
";
ob_start();
include('ip2n_ip-2.sql');
$sql = ob_get_contents();
ob_end_clean();
dbDelta($sql);
echo"2 of 13 done...
";
ob_start();
include('ip2n_ip-3.sql');
$sql = ob_get_contents();
ob_end_clean();
dbDelta($sql);
echo"3 of 13 done...
";
ob_start();
include('ip2n_ip-4.sql');
$sql = ob_get_contents();
ob_end_clean();
dbDelta($sql);
echo"4 of 13 done...
";
ob_start();
include('ip2n_ip-5.sql');
$sql = ob_get_contents();
ob_end_clean();
dbDelta($sql);
echo"5 of 13 done...
";
ob_start();
include('ip2n_ip-6.sql');
$sql = ob_get_contents();
ob_end_clean();
dbDelta($sql);
echo"6 of 13 done...
";
ob_start();
include('ip2n_ip-7.sql');
$sql = ob_get_contents();
ob_end_clean();
dbDelta($sql);
echo"7 of 13 done...
";
ob_start();
include('ip2n_ip-8.sql');
$sql = ob_get_contents();
ob_end_clean();
dbDelta($sql);
echo"8 of 13 done...
";
ob_start();
include('ip2n_ip-9.sql');
$sql = ob_get_contents();
ob_end_clean();
dbDelta($sql);
echo"9 of 13 done...
";
ob_start();
include('ip2n_ip-10.sql');
$sql = ob_get_contents();
ob_end_clean();
dbDelta($sql);
echo"10 of 13 done...
";
ob_start();
include('ip2n_ip-11.sql');
$sql = ob_get_contents();
ob_end_clean();
dbDelta($sql);
echo"11 of 13 done...
";
ob_start();
include('ip2n_ip-12.sql');
$sql = ob_get_contents();
ob_end_clean();
dbDelta($sql);
echo"12 of 13 done...
";
ob_start();
include('ip2n_ip-13.sql');
$sql = ob_get_contents();
ob_end_clean();
dbDelta($sql);
echo"13 of 13 done...
";
$available_ip2nation = get_option('ip2nation_db_available');
update_option("ip2nation_db_installed", $available_ip2nation);
$ol_flash = "ip2nation database has been installed.";
}
if(isset($_POST['ab_dspcnt'])) {
if (
! isset( $_POST['ab-update-options-nonce'] )
|| ! wp_verify_nonce( $_POST['ab-update-options-nonce'], 'ab-update-options' )
) {
print 'Sorry, your nonce did not verify.';
exit;
} else {
// process form data
if (is_numeric ($_POST['ab_dspcnt'])) {
$widget_adbuttons_cfg['ab_title'] = esc_html($_POST['ab_title']);
$widget_adbuttons_cfg['ab_dspcnt'] = esc_html($_POST['ab_dspcnt']);
$widget_adbuttons_cfg['ab_target'] = esc_html($_POST['ab_target']);
$widget_adbuttons_cfg['ab_adsense'] = esc_html($_POST['ab_adsense']);
$widget_adbuttons_cfg['ab_adsense_fixed'] = esc_html($_POST['ab_adsense_fixed']);
$widget_adbuttons_cfg['ab_adsense_pos'] = esc_html($_POST['ab_adsense_pos']);
if($widget_adbuttons_cfg['ab_adsense_pos'] > $widget_adbuttons_cfg['ab_dspcnt']){
$widget_adbuttons_cfg['ab_adsense_pos'] = $widget_adbuttons_cfg['ab_dspcnt'];
}
$widget_adbuttons_cfg['ab_adsense_pubid'] = esc_html($_POST['ab_adsense_pubid']);
$widget_adbuttons_cfg['ab_adsense_channel'] = esc_html($_POST['ab_adsense_channel']);
$widget_adbuttons_cfg['ab_adsense_corners'] = esc_html($_POST['ab_adsense_corners']);
$widget_adbuttons_cfg['ab_adsense_col_border'] = trim(esc_html($_POST['ab_adsense_col_border']), "#");
$widget_adbuttons_cfg['ab_adsense_col_title'] = trim(esc_html($_POST['ab_adsense_col_title']), "#");
$widget_adbuttons_cfg['ab_adsense_col_bg'] = trim(esc_html($_POST['ab_adsense_col_bg']), "#");
$widget_adbuttons_cfg['ab_adsense_col_txt'] = trim(esc_html($_POST['ab_adsense_col_txt']), "#");
$widget_adbuttons_cfg['ab_adsense_col_url'] = trim(esc_html($_POST['ab_adsense_col_url']), "#");
$widget_adbuttons_cfg['ab_nocss'] = esc_html($_POST['ab_nocss']);
$widget_adbuttons_cfg['ab_width'] = esc_html($_POST['ab_width']);
$widget_adbuttons_cfg['ab_padding'] = esc_html($_POST['ab_padding']);
$widget_adbuttons_cfg['ab_nofollow'] = esc_html($_POST['ab_nofollow']);
$widget_adbuttons_cfg['ab_powered'] = esc_html($_POST['ab_powered']);
$widget_adbuttons_cfg['ab_yah'] = esc_html($_POST['ab_yah']);
$widget_adbuttons_cfg['ab_yourad'] = esc_html($_POST['ab_yourad']);
$widget_adbuttons_cfg['ab_geot'] = esc_html($_POST['ab_geot']);
$widget_adbuttons_cfg['ab_yaht'] = esc_html($_POST['ab_yaht']);
$widget_adbuttons_cfg['ab_yahurl'] = esc_html($_POST['ab_yahurl']);
$widget_adbuttons_cfg['ab_anet'] = esc_html($_POST['ab_anet']);
$widget_adbuttons_cfg['ab_anetu'] = esc_html($_POST['ab_anetu']);
$widget_adbuttons_cfg['ab_anett'] = esc_html($_POST['ab_anett']);
$widget_adbuttons_cfg['ab_fix'] = esc_html($_POST['ab_fix']);
$widget_adbuttons_cfg['ab_count'] = esc_html($_POST['ab_count']);
update_option('widget_adbuttons_cfg',$widget_adbuttons_cfg);
$ol_flash = "Your settings have been saved.";
} else {
$ab_num_err = 1;
}
}
}
if ($ol_flash != '') echo '
' . $ol_flash . '