<?php


add_action( 'admin_init', 'nic_fi_names_install_db');

function nic_fi_names_install_db() {
	global $wpdb;

	$table_name = $wpdb->prefix.'nic_fi_names';
	if($wpdb->get_var("SHOW TABLES LIKE '$table_name'") != $table_name) {
		//table not in database. Create new table
		$charset_collate = $wpdb->get_charset_collate();

		$sql = "CREATE TABLE $table_name (
		id mediumint(9) NOT NULL AUTO_INCREMENT,
		name text NOT NULL,
		UNIQUE KEY id (id)
		) $charset_collate;";
		require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
		dbDelta( $sql );
	}
}

function insert_nic_fi_name($name) {
	global $wpdb;
    $table_name = $wpdb->prefix . "nic_fi_names";

    $return = $wpdb->get_var("SELECT id from $table_name WHERE name='$name'");

    if(!$return){
    	$return = $wpdb->insert(
	        $table_name,
	        array('name' => $name),
	        array('%s')
	    );
	    return $wpdb->insert_id;
    }

    return $return;

}

function update_nic_fi_name($id, $name = '') {
    global $wpdb;

    if($name){
		$table_name = $wpdb->prefix . "nic_fi_names";
	    $wpdb->update(
	        $table_name,
	        array('name' => $name),
	        array('id' => $id),
	        array('%s'),
	        array('%s')
	    );
    } else {
    	delete_nic_fi_name($id);
    }

}

function delete_nic_fi_name($id) {
	global $wpdb;
	$table_name = $wpdb->prefix . "nic_fi_names";
	$return = $wpdb->query(
		$wpdb->prepare("DELETE FROM $table_name WHERE id = %s", $id)
	);

	return $return;
}

function get_all_nic_fi_names(){
	global $wpdb;
	$table_name = $wpdb->prefix . "nic_fi_names";
	$rows = $wpdb->get_results("SELECT id,name from $table_name");

	return $rows;
}

function get_nic_fi_name($id) {
	global $wpdb;
	$table_name = $wpdb->prefix . "nic_fi_names";
	$rows = $wpdb->get_var("SELECT name from $table_name WHERE id=$id");

	return $rows;
}

function get_nic_fi_name_id_by_name($name) {
	global $wpdb;
	$table_name = $wpdb->prefix . "nic_fi_names";
	$rows = $wpdb->get_results("SELECT id from $table_name WHERE name='$name'");

	if($rows){
		return $rows[0]->id;
	}

	return false;
}

/*function reset_all_nic_fi_names($conferm = ''){
	if($conferm == 'reset'){
		global $wpdb;
		$table  = $wpdb->prefix . 'nic_fi_names';
		$delete = $wpdb->query("TRUNCATE TABLE $table");
	}
}*/