<?php
if(!defined("IN_MYBB")) {
    die("This file cannot be accessed directly.");
}
$plugins->add_hook("admin_index_navigation_end","nxadduserpage_link",1);

require_once "./global.php";

function nxadduserspage_info() {
    return array(
        "name"				=> "Nexus Mass Users Creation/Update",
        "description"		=> "Allows you to create/update many users at a time",
        "website"			=> "http://nexus.ihouse.unimelb.edu.au",
        "author"			=> "Han",
        "authorsite"		=> "http://nexus.ihouse.unimelb.edu.au",
        "version"			=> "1.0"
    );
}

function nxadduserpage_activate() {

	$fnquery=$db->query("SELECT * FROM ".TABLE_PREFIX."profilefields WHERE name='Firstname'");
	$fn_exist = $db->fetcharray($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
	");
	$db->optimize_table(TABLE_PREFIX."userfields");
	}
	
	
	$lnquery=$db->query("SELECT * FROM ".TABLE_PREFIX."profilefields WHERE name='Lastname'");
	$ln_exist = $db->fetcharray($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('select'),
		"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
	");
	$db->optimize_table(TABLE_PREFIX."userfields");
	}
	
	$sexquery=$db->query("SELECT * FROM ".TABLE_PREFIX."profilefields WHERE name='Sex'");
	$sex_exist = $db->fetcharray($sexquery);
	if ($sex_exist == NULL){
	$sexarray = array(
		"name" => $db->escape_string('Sex'),
		"description" => $db->escape_string('Gender of the Iher'),
		"disporder" => intval('3'),
		"type" => $db->escape_string("select\n"."M F"),
		"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", $sexarray);
	$fid = $db->insert_id();
	$fieldname = "fid$fid";
	$db->query("
		ALTER 
		TABLE ".TABLE_PREFIX."userfields 
		ADD $fieldname TEXT
	");
	$db->optimize_table(TABLE_PREFIX."userfields");
	}
	
	$crsquery=$db->query("SELECT * FROM ".TABLE_PREFIX."profilefields WHERE name='Course'");
	$crs_exist = $db->fetcharray($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
	");
	$db->optimize_table(TABLE_PREFIX."userfields");
	}
	
	$insquery=$db->query("SELECT * FROM ".TABLE_PREFIX."profilefields WHERE name='Institute'");
	$ins_exist = $db->fetcharray($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
	");
	$db->optimize_table(TABLE_PREFIX."userfields");
	}
	
	$ntquery=$db->query("SELECT * FROM ".TABLE_PREFIX."profilefields WHERE name='Nation'");
	$nt_exist = $db->fetcharray($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->ntert_query(TABLE_PREFIX."profilefields", $ntarray);
	$fid = $db->ntert_id();
	$fieldname = "fid$fid";
	$db->query("
		ALTER 
		TABLE ".TABLE_PREFIX."userfields 
		ADD $fieldname TEXT
	");
	$db->optimize_table(TABLE_PREFIX."userfields");
	}
	
	$rmquery=$db->query("SELECT * FROM ".TABLE_PREFIX."profilefields WHERE name='Room'");
	$rm_exist = $db->fetcharray($rmquery);
	if ($rm_exist == NULL){
	$rmarray = array(
		"name" => $db->escape_string('Room'),
		"description" => $db->escape_string('Room number of the Iher'),
		"disporder" => irmval('7'),
		"type" => $db->escape_string("text"),
		"length" => irmval(10),
		"maxlength" => irmval($mybb->input['10']),
		"required" => $db->escape_string('yes'),
		"editable" => $db->escape_string('no'),
		"hidden" => $db->escape_string('no'),
	);
	$db->rmert_query(TABLE_PREFIX."profilefields", $rmarray);
	$fid = $db->rmert_id();
	$fieldname = "fid$fid";
	$db->query("
		ALTER 
		TABLE ".TABLE_PREFIX."userfields 
		ADD $fieldname TEXT
	");
	$db->optimize_table(TABLE_PREFIX."userfields");
	}
	
}


function nxadduserpage_desactivate() {

}
function nxadduserpage_link()
{
	global $menu;
	$menu[20]['items'][]=array("title"=> "IH M.Users Creation", "url" => "nx_addusers.php?".SID);
	return;
}
?>