<?php
if(!defined("IN_MYBB")) {
    die("This file cannot be accessed directly.");
}
$plugins->add_hook("admin_index_navigation_end","nxadduserspage_link",1);

require_once "./global.php";

function nxadduserspage_info() {
    return array(
        "name"				=> "....",
        "description"		=> "...,
        "website"			=> "...",
        "author"			=> "...",
        "authorsite"		=> "...",
        "version"			=> "1.0"
    );
}

function option_set($options){

	$options = preg_replace("#(\r\n|\r|\n)#s", "\n", trim($options));
	
		$type = "$type\n$options";
		return $type;
		
}


function nxadduserspage_activate() {
	global $db;
	
	$fnquery=$db->query("SELECT * FROM ".TABLE_PREFIX."profilefields WHERE name='Firstname'");
	$fn_exist = $db->fetch_array($fnquery);
	if ($fn_exist == NULL){
	$fnarray = array(
		"name" => $db->escape_string('Firstname'),
		"description" => $db->escape_string('Firstname of the Iher'),
		"disporder" => intval('1'),
		"type" => $db->escape_string('text'),
		"length" => intval(20),
		"maxlength" => intval($mybb->input['25']),
		"required" => $db->escape_string('yes'),
		"editable" => $db->escape_string('no'),
		"hidden" => $db->escape_string('no'),
	);
	$db->insert_query(TABLE_PREFIX."profilefields", $fnarray);
	$fid = $db->insert_id();
	$fieldname = "fid$fid";
	$db->query("
		ALTER 
		TABLE ".TABLE_PREFIX."userfields 
		ADD $fieldname TEXT
	");
	
	}
	
	
	$lnquery=$db->query("SELECT * FROM ".TABLE_PREFIX."profilefields WHERE name='Lastname'");
	$ln_exist = $db->fetch_array($lnquery);
	if ($ln_exist == NULL){
	$lnarray = array(
		"name" => $db->escape_string('Lastname'),
		"description" => $db->escape_string('Lastname of the Iher'),
		"disporder" => intval('2'),
		"type" => $db->escape_string('text'),
		"length" => intval(20),
		"maxlength" => intval($mybb->input['25']),
		"required" => $db->escape_string('yes'),
		"editable" => $db->escape_string('no'),
		"hidden" => $db->escape_string('no'),
	);
	$db->insert_query(TABLE_PREFIX."profilefields", $lnarray);
	$fid = $db->insert_id();
	$fieldname = "fid$fid";
	$db->query("
		ALTER 
		TABLE ".TABLE_PREFIX."userfields 
		ADD $fieldname TEXT
	");
	
	}
	
	$sexquery=$db->query("SELECT * FROM ".TABLE_PREFIX."profilefields WHERE name='Sex'");
	$sex_exist = $db->fetch_array($sexquery);
	if ($sex_exist == NULL){
	$sextype = option_set("M\nF");
	$sexarray = array(
		"name" => $db->escape_string('Sex'),
		"description" => $db->escape_string('Gender of the Iher'),
		"disporder" => intval('3'),
		"type" => $db->escape_string("$sextype"),
		"length" => intval(2),
		"maxlength" => intval($mybb->input['2']),
		"required" => $db->escape_string('yes'),
		"editable" => $db->escape_string('no'),
		"hidden" => $db->escape_string('no'),
	);
	$db->insert_query(TABLE_PREFIX."profilefields", $sexarray);
	$fid = $db->insert_id();
	$fieldname = "fid$fid";
	$db->query("
		ALTER 
		TABLE ".TABLE_PREFIX."userfields 
		ADD $fieldname TEXT
	");
	
	}
	
	$crsquery=$db->query("SELECT * FROM ".TABLE_PREFIX."profilefields WHERE name='Course'");
	$crs_exist = $db->fetch_array($crsquery);
	if ($crs_exist == NULL){
	$crsarray = array(
		"name" => $db->escape_string('Course'),
		"description" => $db->escape_string('Course taken by the Iher'),
		"disporder" => intval('4'),
		"type" => $db->escape_string("text"),
		"length" => intval(30),
		"maxlength" => intval($mybb->input['30']),
		"required" => $db->escape_string('yes'),
		"editable" => $db->escape_string('no'),
		"hidden" => $db->escape_string('no'),
	);
	$db->insert_query(TABLE_PREFIX."profilefields", $crsarray);
	$fid = $db->insert_id();
	$fieldname = "fid$fid";
	$db->query("
		ALTER 
		TABLE ".TABLE_PREFIX."userfields 
		ADD $fieldname TEXT
	");
	
	}
	
	$insquery=$db->query("SELECT * FROM ".TABLE_PREFIX."profilefields WHERE name='Institute'");
	$ins_exist = $db->fetch_array($insquery);
	if ($ins_exist == NULL){
	$insarray = array(
		"name" => $db->escape_string('Institute'),
		"description" => $db->escape_string('Institute being studied the Iher'),
		"disporder" => intval('5'),
		"type" => $db->escape_string("text"),
		"length" => intval(35),
		"maxlength" => intval($mybb->input['35']),
		"required" => $db->escape_string('yes'),
		"editable" => $db->escape_string('no'),
		"hidden" => $db->escape_string('no'),
	);
	$db->insert_query(TABLE_PREFIX."profilefields", $insarray);
	$fid = $db->insert_id();
	$fieldname = "fid$fid";
	$db->query("
		ALTER 
		TABLE ".TABLE_PREFIX."userfields 
		ADD $fieldname TEXT
	");
	
	}
	
	$ntquery=$db->query("SELECT * FROM ".TABLE_PREFIX."profilefields WHERE name='Nation'");
	$nt_exist = $db->fetch_array($ntquery);
	if ($nt_exist == NULL){
	$ntarray = array(
		"name" => $db->escape_string('Nation'),
		"description" => $db->escape_string('Nationality of the Iher'),
		"disporder" => intval('6'),
		"type" => $db->escape_string("text"),
		"length" => intval(30),
		"maxlength" => intval($mybb->input['30']),
		"required" => $db->escape_string('yes'),
		"editable" => $db->escape_string('no'),
		"hidden" => $db->escape_string('no'),
	);
	$db->insert_query(TABLE_PREFIX."profilefields", $ntarray);
	$fid = $db->insert_id();
	$fieldname = "fid$fid";
	$db->query("
		ALTER 
		TABLE ".TABLE_PREFIX."userfields 
		ADD $fieldname TEXT
	");
	
	}
	
	$rmquery=$db->query("SELECT * FROM ".TABLE_PREFIX."profilefields WHERE name='Room'");
	$rm_exist = $db->fetch_array($rmquery);
	if ($rm_exist == NULL){
	$rmarray = array(
		"name" => $db->escape_string('Room'),
		"description" => $db->escape_string('Room number of the Iher'),
		"disporder" => intval('7'),
		"type" => $db->escape_string("text"),
		"length" => intval(10),
		"maxlength" => intval($mybb->input['10']),
		"required" => $db->escape_string('yes'),
		"editable" => $db->escape_string('no'),
		"hidden" => $db->escape_string('no'),
	);
	$db->insert_query(TABLE_PREFIX."profilefields", $rmarray);
	$fid = $db->insert_id();
	$fieldname = "fid$fid";
	$db->query("
		ALTER 
		TABLE ".TABLE_PREFIX."userfields 
		ADD $fieldname TEXT
	");
	
	}
	$db->optimize_table(TABLE_PREFIX."userfields");
}


function nxadduserspage_deactivate() {

}
function nxadduserspage_link()
{
	global $menu;
	$menu[20]['items'][]=array("title"=> "IH M.Users Creation", "url" => "nx_addusers.php?".SID);
	return;
}
?>