Function Reference: geodir_claim_activation_script

Summary

This function has not been documented yet.

Actions

‘geodir_claim_listing_table_created’ [Line: 166]

Filters

‘geodir_claim_listing_table’ [Line: 157]

Source Code

function geodir_claim_activation_script() {
	global $wpdb,$plugin_prefix;

	/**
	 * Include any functions needed for upgrades.
	 *
	 * @since 1.1.4
	 */
	require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
	
	$wpdb->hide_errors();

	
	$collate = '';
	if($wpdb->has_cap( 'collation' ) ) {
		if(!empty($wpdb->charset)) $collate = "DEFAULT CHARACTER SET $wpdb->charset";
		if(!empty($wpdb->collate)) $collate .= " COLLATE $wpdb->collate";
	}
	
	if($wpdb->get_var("SHOW TABLES LIKE '".GEODIR_CLAIM_TABLE."'") != GEODIR_CLAIM_TABLE){
	
		$claim_table = "CREATE TABLE IF NOT EXISTS `".GEODIR_CLAIM_TABLE."` (
			`pid` int(11) NOT NULL AUTO_INCREMENT,
			`list_id` varchar(255) NOT NULL,
			`list_title` varchar(255) NOT NULL,
			`user_id` varchar(255) NOT NULL,
			`user_name` varchar(255) NOT NULL,
			`user_email` varchar(255) NOT NULL,
			`user_fullname` varchar(255) NOT NULL,
			`user_number` varchar(255) NOT NULL,
			`user_position` varchar(255) NOT NULL,
			`user_comments` longtext NOT NULL,
			`admin_comments` longtext NOT NULL,
			`claim_date` varchar(255) NOT NULL,
			`org_author` varchar(255) NOT NULL,
			`org_authorid` varchar(255) NOT NULL,
			`rand_string` varchar(255) NOT NULL,
			`status` varchar(255) NOT NULL,
			`user_ip` varchar(255) NOT NULL,
			`upgrade_pkg_id` INT( 11 ) NOT NULL,
			`upgrade_pkg_data` TINYTEXT NOT NULL,
			PRIMARY KEY (`pid`)) $collate";
		
		$claim_table = apply_filters('geodir_claim_listing_table' , $claim_table);	
		
		// rename tables if we need to
		if ($wpdb->query("SHOW TABLES LIKE 'geodir_claim'") > 0) {
			$wpdb->query("RENAME TABLE geodir_claim TO ".$wpdb->prefix."geodir_claim");
		} else {
			dbDelta($claim_table);
		}
		
		do_action('geodir_claim_listing_table_created' ,$claim_table ) ;
		
		update_option( 'geodir_claim_fields_upgrade', '1' );		
	}	
}