[Wild-Wing]

ill release the code here
admin cp code

<?php

/*======================================================================*\
|| #################################################################### ||
|| # Staff Titles Hack Version 1.0.0                                      # ||
|| # ---------------------------------------------------------------- # ||
|| #                           # ||
|| # PHP Code by:  Wild-Wing                                # ||
|| #   ||
|| #                        # ||
|| #################################################################### ||
\*======================================================================*/

// ######################## SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);

// ##################### DEFINE IMPORTANT CONSTANTS #######################
define('THIS_SCRIPT', 'staff_titles_admin');
define('STAFFTITLE_VERSION', '1.0.0');

// #################### PRE-CACHE TEMPLATES AND DATA ######################
// get special phrase groups
$phrasegroups = array();

// get special data templates from the datastore
$specialtemplates = array('');

// ########################## REQUIRE BACK-END ############################
require_once('./global.php');

// ############################# LOG ACTION ###############################
//log_admin_action();
log_admin_action(($_REQUEST['usergroupid'] != 0 ? "usergroupid = ".$_REQUEST['usergroupid'] : ''));

print_cp_header("Staff Title  ".STAFFTITLE_VERSION." Admin");

if (!isset($_REQUEST['do']) || empty($_REQUEST['do'])) {
	$_REQUEST['do'] = "dotitles";
}

// ##################### LIST ALL STAFF TITLES ########################
if ($_REQUEST['do'] == "dotitles") {
	
	
	print_form_header('staff_titles_admin', 'nowhere');
	print_table_header("Staff Titles Admin");
	print_description_row("You can change usergroup staff titles here.");
	$grouptitle = $db->query_read("SELECT usergroupid, title, staffrank AS stafftitle, staffrank_opentag AS opentag, staffrank_closetag AS closetag FROM ".TABLE_PREFIX."usergroup order by usergroupid asc");
	while ($groupstitle = $db->fetch_array($grouptitle)) {
		print_form_header('staff_titles_admin', 'set_update');
		construct_hidden_code('usergroupid', $groupstitle['usergroupid']);
		construct_hidden_code('usergroup', $groupstitle['title']);
		print_table_header($groupstitle['title']." ID: ". $groupstitle['usergroupid']);
	//	print_yes_no_row($vbphrase['enable_staff_title'], 'groupstitle[isstaffrank]', $groupstitle['isstaffrank']);
		print_input_row($vbphrase['staff_title'], 'staffrank', $groupstitle['stafftitle']);
		print_label_row($vbphrase['staff_title_markup'],
        '<span style="white-space:nowrap">
        <input size="15" type="text" class="bginput" name="opentag" value="' . htmlspecialchars_uni($groupstitle['opentag']) . '" tabindex="1" />
        <input size="15" type="text" class="bginput" name="closetag" value="' . htmlspecialchars_uni($groupstitle['closetag']) . '" tabindex="1" />
        </span>', '', 'top', 'htmltags');
		print_submit_row("Set Usergroup Staff Title");
	}
	print_table_footer();
}

if ($_REQUEST['do'] == "set_update") {
$staffrank = $_REQUEST['staffrank'];
$opentag = $_REQUEST['opentag'];
$closetag = $_REQUEST['closetag'];
if ($opentag == ""){
$opentag ="";}
else{
$opentag =", staffrank_opentag='".$opentag."',";}
if ($closetag == ""){
$closetag ="";}
else{
$closetag ="staffrank_closetag='".$closetag."'";}
	$db->query_write("UPDATE ".TABLE_PREFIX."usergroup SET staffrank='$staffrank' $opentag $closetag where usergroupid =$_REQUEST[usergroupid]");//usergroup update
	$uStaff = $db->query_read("SELECT usergroupid, username, isstaffrank, staffrank AS stafftitle, staffrank_opentag AS opentag, staffrank_closetag AS closetag FROM ".TABLE_PREFIX."user where usergroupid = $_REQUEST[usergroupid]");
	while ($uStaffT = $db->fetch_array($uStaff)) {
	if ($uStaffT['isstaffrank']==0){
	$db->query_write("UPDATE ".TABLE_PREFIX."user SET staffrank='$staffrank' $opentag $closetag");//user update
	}
	else{
	$uStaffTs .= "<b>$uStaffT[username]</b>: could not be updated you have chosen to give them their own Staff Title.<br />\n";
	}
	}
	print "$_REQUEST[usergroup] Staff Title Updated and Users";
	print "<br />\n$uStaffTs";
	$_REQUEST['do'] = "dotitles";
}

//################## LIST ALL CUSTOM STAFF TITLES ######################
if ($_REQUEST['do'] == "custom") {
	print_form_header('staff_titles_admin', 'set_update');
	print_table_header("View Custom Admin Set Staff Titles");
	$userstaff = $db->query_read("SELECT userid, username, staffrank AS stafftitle, staffrank_opentag AS opentag, staffrank_closetag AS closetag FROM ".TABLE_PREFIX."user where isstaffrank = 1 order by userid asc");
	while ($userstafftitle = $db->fetch_array($userstaff)) {
	$userstafftitles .= "$userstafftitle[username] has the Staff Title of : ".$userstafftitle['opentag'].$userstafftitle['stafftitle'].$userstafftitle['closetag']."<br />\n";
	}
	print_description_row("$userstafftitles");
	print_table_footer();
}

//print_description_row();
print_cp_footer();


?>

sql note:this is comming from straight from the xml file

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "usergroup ADD (staffrank VARCHAR(250) NOT NULL DEFAULT '')");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "usergroup ADD (staffrank_opentag  VARCHAR(250) NOT NULL DEFAULT '')");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "usergroup ADD (staffrank_closetag  VARCHAR(250) NOT NULL DEFAULT '')");

oh yea the nav group

<navgroups product="livewires_staff_titles">

	<navgroup text="Staff Titles" permissions="canadminpermissions" displayorder="121">

		<navoption displayorder="10">
			<text>Set Usergroup Staff Titles</text>
			<link>staff_titles_admin.php?do=dotitles</link>
		</navoption>
		
		<navoption displayorder="20">
			<text>View Custom Set Staff Titles</text>
			<link>staff_titles_admin.php?do=custom</link>
		</navoption>
		
	</navgroup>

</navgroups>