Please make sure IN_MYBB is defined.');
}
/* --- Plugin API: --- */
function groupsort_info()
{
return array(
'name' => 'Group Sort',
'description' => 'Sort the usergroups by display and sort each users groups by this sequence',
'website' => 'https://opt-community.de/',
'author' => 'Dieter Gobbers (@Terran_ulm)',
'authorsite' => 'https://opt-community.de/',
'version' => '1.1.3',
'codename' => 'opt_groupsort',
'compatibility' => '18*'
);
}
function groupsort_activate()
{
global $db, $lang, $cache;
groupsort_deactivate();
$lang->load('groupsort');
$updated_record = array(
"enabled" => intval(1)
);
$db->update_query(
'tasks',
$updated_record,
"title='{$db->escape_string($lang->groupsort_title)}'"
);
$cache->update_tasks();
}
function groupsort_deactivate()
{
global $db, $lang, $cache;
$lang->load('groupsort');
$updated_record = array(
"enabled" => intval(0)
);
$db->update_query(
'tasks',
$updated_record,
"title='{$db->escape_string($lang->groupsort_title)}'"
);
$cache->update_tasks();
}
function groupsort_is_installed()
{
global $db, $lang;
$lang->load('groupsort');
$query=$db->simple_select(
'tasks',
'*',
"title='{$db->escape_string($lang->groupsort_title)}'"
);
$result=$db->fetch_array($query);
$db->free_result($query);
return(!empty($result));
}
function groupsort_install()
{
global $db, $lang, $cache;
$lang->load('groupsort');
// create task
require_once MYBB_ROOT."/inc/functions_task.php";
$new_task = array(
"title" => $db->escape_string($lang->groupsort_title),
"description" => $db->escape_string($lang->groupsort_task_description),
"file" => $db->escape_string('groupsort'),
"minute" => $db->escape_string('27'),
"hour" => $db->escape_string('4'),
"day" => $db->escape_string('*'),
"month" => $db->escape_string('*'),
"weekday" => $db->escape_string('*'),
"enabled" => intval(0),
"logging" => intval(1)
);
$new_task['nextrun'] = fetch_next_run($new_task);
$tid = $db->insert_query("tasks", $new_task);
$cache->update_tasks();
}
function groupsort_uninstall()
{
global $db, $lang, $cache;
$lang->load('groupsort');
$db->delete_query("tasks", "title='{$db->escape_string($lang->groupsort_title)}'");
$cache->update_tasks();
}
/* --- Hooks: --- */
/* --- Hook #1 - Add groupsort Tab --- */
$plugins->add_hook('admin_user_groups_edit_graph_tabs','groupsort_admin_user_groups_edit_graph_tabs_1',1);
function groupsort_admin_user_groups_edit_graph_tabs_1(&$tabs)
{
global $lang;
$lang->load('groupsort');
$tabs["groupsort"] = $lang->groupsort_title;
return $tabs;
}
/* --- Hook #2 - Add Teamspeak Tab Content --- */
$plugins->add_hook('admin_user_groups_edit_graph','groupsort_admin_user_groups_edit_graph_2',1);
function groupsort_admin_user_groups_edit_graph_2()
{
global $lang, $form, $mybb;
$lang->load('groupsort');
echo "";
$form_container = new FormContainer($lang->groupsort_title);
$form_container->output_row($lang->groupsort_rank, $lang->groupsort_rank_description, $form->generate_text_box('disporder', $mybb->input['disporder'], array('id' => 'disporder')), 'servergroupid');
$form_container->end();
echo "
";
groupsort_reorder_all_users();
}
/* --- Hook #6 - admin_user_groups_edit_commit --- */
$plugins->add_hook('admin_user_groups_edit_commit','groupsort_admin_user_groups_edit_commit_6',10);
function groupsort_admin_user_groups_edit_commit_6()
{
global $mybb, $db, $updated_group, $cache;
$updated_group['disporder'] = intval($mybb->input['disporder']);
$db->update_query("usergroups", $updated_group, "gid='{$usergroup['gid']}'");
groupsort_reorder_groups();
// Update the caches
$cache->update_usergroups();
}
$plugins->add_hook('admin_user_groups_start_commit','groupsort_admin_user_groups_start_commit',10);
function groupsort_admin_user_groups_start_commit()
{
groupsort_reorder_groups();
}
/* --- Hook #23 - set disporder for groups on creation --- */
$plugins->add_hook('admin_user_groups_add_commit','groupsort_admin_user_groups_add_commit_23',10);
function groupsort_admin_user_groups_add_commit_23()
{
global $new_usergroup;
$new_usergroup['disporder']=10000;
}
function groupsort_reorder_groups()
{
global $db;
$query = $db->simple_select('usergroups', '*', '', array(
'order_by' => 'disporder',
'order_dir' => 'ASC'
));
$count = 1;
while ($row = $db->fetch_array($query))
{
$updated_record=array(
'disporder' => intval($count)
);
$db->update_query(
'usergroups',
$updated_record,
'gid='.intval($row['gid'])
);
$count++;
}
$db->free_result($query);
}
function groupsort_reorder_all_users()
{
global $db, $mybb;
$query=$db->simple_select(
'usergroups',
'*',
'',
array(
'order_by' => 'disporder',
'order_dir' => 'ASC'
)
);
$all_usergroups=array();
while($usergroup = $db->fetch_array($query))
{
$all_usergroups[$usergroup['gid']]=$usergroup['disporder'];
}
$db->free_result($query);
$query=$db->simple_select(
'users',
'uid'
);
while($uid = $db->fetch_field($query, 'uid'))
{
groupsort_reorder_user($uid, $all_usergroups);
}
$db->free_result($query);
}
function groupsort_reorder_user($uid, $all_usergroups)
{
global $db;
// get the users' groups
$query = $db->simple_select(
'users',
'*',
'uid='.intval($uid)
);
$user=$db->fetch_array($query);
$db->free_result($query);
// build usergroup array
$usergroups = array_unique (array_merge(array($user['usergroup']), explode(',', $user['additionalgroups'])));
sort($usergroups);
if (!in_array(2,$usergroups)) // user is not in the "registered" group
{
if(!in_array(5,$usergroups) && !in_array(7,$usergroups) && !in_array(1,$usergroups)) // should the user be in the "registered" group? (not banned, not awaiting activation and not unregistered
{
$usergroups[]=2;
}
}
// reorder the usergroups
$new_usergroups=array();
foreach($all_usergroups as $usergroup => $order)
{
if (in_array($usergroup, $usergroups))
{
$new_usergroups[]=$usergroup;
}
}
// update user data
$primarygroup=array_shift($new_usergroups);
$usergroups=implode(',', $new_usergroups);
$new_record=array(
'usergroup' => $primarygroup,
'additionalgroups' => $usergroups,
'displaygroup' => 0
);
$db->update_query(
'users',
$new_record,
'uid='.intval($uid)
);
}
/* Exported by Hooks plugin Wed, 28 Aug 2013 10:37:27 GMT */
?>