Server : Apache/2 System : Linux server-15-235-50-60 5.15.0-164-generic #174-Ubuntu SMP Fri Nov 14 20:25:16 UTC 2025 x86_64 User : gositeme ( 1004) PHP Version : 8.2.29 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname Directory :  /home/gositeme/domains/gositeme.com/public_html/wp-content/plugins/whmpress/includes/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
$ctable_name = whmp_get_countries_table_name();
// Creating IP Tables for country detection.
$Q = "CREATE TABLE {$ctable_name} (
    id int(11) NOT NULL AUTO_INCREMENT,
    country_code varchar(2) NOT NULL default '',
    country_name varchar(100) NOT NULL default '',
    UNIQUE KEY id (id)
) " . $charset_collate;
dbDelta( $Q );

#Inserting countries.
if ( $wpdb->get_var( "SELECT COUNT(*) FROM `$ctable_name`" ) == "0" ) {
	global $wp_filesystem;
	if ( empty( $wp_filesystem ) ) {
		require_once( ABSPATH . '/wp-admin/includes/file.php' );
		WP_Filesystem();
	}
	
	$_countries = whmp_read_local_file( dirname( __FILE__ ) . "/countries.sql" );
	$_countries = str_replace( "INSERT INTO `countries`", "INSERT INTO `$ctable_name`", $_countries );
	$_countries = explode( "\n", $_countries );
	foreach ( $_countries as $_country ) {
		$wpdb->query( $_country );
	}
}