***(Problema) No puedo ingresar a la administración***

Hoy estube cambiando permisos de grupos de usuarios y de repente no podia ingresar mas, osea no me toma la contraseña...

Ademas los moderadores y yo tambien no podemos moderar, pero igual aparecemos yo como Admin y los moderadores como tales...

Que puedo hacer???

Mira si puedes acceder via FTP a tu foro y edita el config.php a ver si esta correcto....

En la base de datos de mysql, no se donde estan los pass, y estos si haces otro update, no cambian....

Mmmmm en el config.php no esta... es la misma de antes...

¿Puedes acceder al foro con tu contraseña? Cuando intentas entrar al admincp, ¿que error te sale?.

Si el problema es la contraseña, lo más sencillo es que pidas que se te envie a tu correo. Quizás se ha cambiado por algún motivo y por eso no puedes entrar.

Tambien puede ser que te hayas negado permiso para acceder al AdminCP

Si a mi cuenta puedo entrar, la contraseña no se modifico...

Parece que me negue a mi mismo....

Cuando quiero entrar al admincp (escribiendo en la barra de direcciones, porque no me aparece abajo) no me tira ningun error, pero es como que la contraseña es incorrecta porq no hace nada....

entra a www/admincp/usergroup.php

y postea las lineas que tienes.

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

// ##################### DEFINE IMPORTANT CONSTANTS #######################
define('CVS_REVISION', '$RCSfile$ - $Revision: 26706 $');

// #################### PRE-CACHE TEMPLATES AND DATA ######################
$phrasegroups = array('cppermission', 'cpuser', 'promotion', 'pm', 'cpusergroup');
$specialtemplates = array();

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

// ######################## CHECK ADMIN PERMISSIONS #######################
if (!can_administer('canadminpermissions'))
{
print_cp_no_permission();
}

// ############################# LOG ACTION ###############################
$vbulletin->input->clean_array_gpc('r', array(
'usergroupid' => TYPE_INT,
'usergroupleaderid' => TYPE_INT,
));

log_admin_action(!empty($vbulletin->GPC['usergroupid']) ? "usergroup id = " . $vbulletin->GPC['usergroupid'] : (!empty($vbulletin->GPC['usergroupleaderid']) ? "leader id = " . $vbulletin->GPC['usergroupleaderid'] : ''));

// ########################################################################
// ######################### START MAIN SCRIPT ############################
// ########################################################################

print_cp_header($vbphrase['usergroup_manager']);

if (empty($_REQUEST['do']))
{
$_REQUEST['do'] = 'modify';
}

// ###################### Start getuserid #######################
function fetch_userid_from_username($username)
{
global $vbulletin;
if ($user = $vbulletin->db->query_first("SELECT userid FROM " . TABLE_PREFIX . "user WHERE username = '" . $vbulletin->db->escape_string(trim($username)) . "'"))
{
return $user['userid'];
}
else
{
return false;
}
}

// ###################### Start add / update #######################
if ($_REQUEST['do'] == 'add' OR $_REQUEST['do'] == 'edit')
{

$vbulletin->input->clean_array_gpc('r', array(
'defaultgroupid' => TYPE_INT
));

require_once(DIR . '/includes/class_bitfield_builder.php');
if (vB_Bitfield_Builder::build(false) !== false)
{
$myobj =& vB_Bitfield_Builder::init();
if (sizeof($myobj->datastore_total['ugp']) != sizeof($vbulletin->bf_ugp))
{
$myobj->save($db);
build_forum_permissions();
define('CP_REDIRECT', $vbulletin->scriptpath);
print_stop_message('rebuilt_bitfields_successfully');
}
}
else
{
echo "<strong>error</strong>\n";
print_r(vB_Bitfield_Builder::fetch_errors());
}

if ($_REQUEST['do'] == 'add')
{
// get a list of other usergroups to base this one off of
print_form_header('usergroup', 'add');
$groups = $db->query_read("SELECT usergroupid, title FROM " . TABLE_PREFIX . "usergroup ORDER BY title");
$selectgroups = '';
while ($group = $db->fetch_array($groups))
{
$selectgroups .= "<option value=\"$group[usergroupid]\" " . iif($group['usergroupid'] == $vbulletin->GPC['defaultgroupid'], 'selected="selected"') . ">$group[title]</option>\n";
}
print_description_row(construct_table_help_button('defaultgroupid') . '<b>' . $vbphrase['create_usergroup_based_off_of_usergroup'] . '</b> <select name="defaultgroupid" tabindex="1" class="bginput">' . $selectgroups . '</select> <input type="submit" class="button" value="' . $vbphrase['go'] . '" tabindex="1" />', 0, 2, 'tfoot', 'center');
print_table_footer();
}

print_form_header('usergroup', 'update');
print_column_style_code(array('width: 70%', 'width: 30%'));

if ($_REQUEST['do'] == 'add')
{
if (!empty($vbulletin->GPC['defaultgroupid']))
{
// set defaults to this group's info
$usergroup = $db->query_first("
SELECT * FROM " . TABLE_PREFIX . "usergroup
WHERE usergroupid = " . $vbulletin->GPC['defaultgroupid'] . "
");

$ug_bitfield = array();
foreach($vbulletin->bf_ugp AS $permissiongroup => $fields)
{
$ug_bitfield["$permissiongroup"] = convert_bits_to_array($usergroup["$permissiongroup"], $fields);
}
}
else
{
$ug_bitfield = array(
'genericoptions' => array('showgroup' => 1, 'showeditedby' => 1, 'isnotbannedgroup' => 1),
'forumpermissions' => array('canview' => 1, 'canviewothers' => 1, 'cangetattachment' => 1,
'cansearch' => 1, 'canthreadrate' => 1, 'canpostattachment' => 1, 'canpostpoll' => 1, 'canvote' => 1, 'canviewthreads' => 1),
'wolpermissions' => array('canwhosonline' => 1),
'genericpermissions' => array('canviewmembers' => 1, 'canmodifyprofile' => 1, 'canseeprofilepic' => 1, 'canusesignature' => 1, 'cannegativerep' => 1, 'canuserep' => 1, 'cansearchft_nl' => 1)
);
// set default numeric permissions
$usergroup = array(
'pmquota' => 0, 'pmsendmax' => 5, 'attachlimit' => 1000000,
'avatarmaxwidth' => 50, 'avatarmaxheight' => 50, 'avatarmaxsize' => 20000,
'profilepicmaxwidth' => 100, 'profilepicmaxheight' => 100, 'profilepicmaxsize' => 25000, 'sigmaxsizebbcode' => 7
);
}

$permgroups = $db->query_read("
SELECT usergroup.usergroupid, title,
(COUNT(forumpermission.forumpermissionid) + COUNT(calendarpermission.calendarpermissionid)) AS permcount
FROM " . TABLE_PREFIX . "usergroup AS usergroup
LEFT JOIN " . TABLE_PREFIX . "forumpermission AS forumpermission ON (usergroup.usergroupid = forumpermission.usergroupid)
LEFT JOIN " . TABLE_PREFIX . "calendarpermission AS calendarpermission ON (usergroup.usergroupid = calendarpermission.usergroupid)
GROUP BY usergroup.usergroupid
HAVING permcount > 0
ORDER BY title
");
$ugarr = array('-1' => '--- ' . $vbphrase['none'] . ' ---');
while ($group = $db->fetch_array($permgroups))
{
$ugarr["$group[usergroupid]"] = $group['title'];
}
print_table_header($vbphrase['default_forum_permissions']);
print_select_row($vbphrase['create_permissions_based_off_of_forum'], 'ugid_base', $ugarr, $vbulletin->GPC['defaultgroupid']);
print_table_break();

print_table_header($vbphrase['add_new_usergroup']);
}
else
{
$usergroup = $db->query_first("
SELECT * FROM " . TABLE_PREFIX . "usergroup
WHERE usergroupid = " . $vbulletin->GPC['usergroupid'] . "
");

$ug_bitfield = array();
foreach($vbulletin->bf_ugp AS $permissiongroup => $fields)
{
$ug_bitfield["$permissiongroup"] = convert_bits_to_array($usergroup["$permissiongroup"], $fields);
}
construct_hidden_code('usergroupid', $vbulletin->GPC['usergroupid']);
print_table_header(construct_phrase($vbphrase['x_y_id_z'], $vbphrase['usergroup'],$usergroup[title], $usergroup[usergroupid]), 2, 0);
}

print_input_row($vbphrase['title'], 'usergroup[title]', $usergroup['title']);
print_input_row($vbphrase['description'], 'usergroup[description]', $usergroup['description']);
print_input_row($vbphrase['usergroup_user_title'], 'usergroup[usertitle]', $usergroup['usertitle']);
print_label_row($vbphrase['username_markup'],
'<span style="white-space:nowrap">
<input size="15" type="text" class="bginput" name="usergroup[opentag]" value="' . htmlspecialchars_uni($usergroup['opentag']) . '" tabindex="1" />
<input size="15" type="text" class="bginput" name="usergroup[closetag]" value="' . htmlspecialchars_uni($usergroup['closetag']) . '" tabindex="1" />
</span>', '', 'top', 'htmltags');
print_input_row($vbphrase['password_expiry'], 'usergroup[passwordexpires]', $usergroup['passwordexpires']);
print_input_row($vbphrase['password_history'], 'usergroup[passwordhistory]', $usergroup['passwordhistory']);
print_table_break();
print_column_style_code(array('width: 70%', 'width: 30%'));

if ($vbulletin->GPC['usergroupid'] > 7 OR $_REQUEST['do'] == 'add')
{
print_table_header($vbphrase['public_group_settings']);
print_yes_no_row($vbphrase['public_joinable_custom_usergroup'], 'usergroup[ispublicgroup]', $usergroup['ispublicgroup']);
print_yes_no_row($vbphrase['can_override_primary_group_title'], 'usergroup[canoverride]', $usergroup['canoverride']);
print_table_break();
print_column_style_code(array('width: 70%', 'width: 30%'));
}

($hook = vBulletinHook::fetch_hook('admin_usergroup_edit')) ? eval($hook) : false;

foreach ($myobj->data['ugp'] AS $grouptitle => $perms)
{
foreach ($perms AS $permtitle => $permvalue)
{
if (empty($permvalue['group']))
{
continue;
}
$groupinfo["$permvalue[group]"]["$permtitle"] = array('phrase' => $permvalue['phrase'], 'value' => $permvalue['value'], 'parentgroup' => $grouptitle);
if ($permvalue['intperm'])
{
$groupinfo["$permvalue[group]"]["$permtitle"]['intperm'] = true;
}
if (!empty($myobj->data['layout']["$permvalue[group]"]['ignoregroups']))
{
$groupinfo["$permvalue[group]"]['ignoregroups'] = $myobj->data['layout']["$permvalue[group]"]['ignoregroups'];
}
if (!empty($permvalue['ignoregroups']))
{
$groupinfo["$permvalue[group]"]["$permtitle"]['ignoregroups'] = $permvalue['ignoregroups'];
}
if (!empty($permvalue['options']))
{
$groupinfo["$permvalue[group]"]["$permtitle"]['options'] = $permvalue['options'];
}
}
}

foreach ($groupinfo AS $grouptitle => $group)
{

// This set of permissions is hidden from a specific group
if (isset($group['ignoregroups']))
{
$ignoreids = explode(',', $group['ignoregroups']);
if (in_array($vbulletin->GPC['usergroupid'], $ignoreids))
{
continue;
}
else
{
unset($group['ignoregroups']);
}
}

print_table_header($vbphrase["$grouptitle"]);

foreach ($group AS $permtitle => $permvalue)
{
// Permission is shown only if a particular option is enabled.
if (isset($permvalue['options']) AND !$vbulletin->options["$permvalue[options]"])
{
continue;
}

// Permission is hidden from specific groups
if (isset($permvalue['ignoregroups']))
{
$ignoreids = explode(',', $permvalue['ignoregroups']);
if (in_array($vbulletin->GPC['usergroupid'], $ignoreids))
{
continue;
}
}

if (isset($permvalue['intperm']))
{
$getval = $usergroup["$permtitle"];

if (isset($permvalue['readonly']))
{
// This permission is readonly for certain usergroups
$readonlyids = explode(',', $permvalue['readonly']);
if (in_array($vbulletin->GPC['usergroupid'], $readonlyids))
{
$getval = ($permvalue['readonlyvalue']) ? $permvalue['readonlyvalue'] : $getval;

print_label_row($vbphrase["$permvalue[phrase]"], $getval);
construct_hidden_code($vbphrase["$permvalue[phrase]"], $getval);
continue;
}
}

print_input_row($vbphrase["$permvalue[phrase]"], "usergroup[$permtitle]", $getval, 1, 20);
}
else
{
$getval = $ug_bitfield["$permvalue[parentgroup]"]["$permtitle"];

if (isset($permvalue['readonly']))
{
// This permission is readonly for certain usergroups
$readonlyids = explode(',', $permvalue['readonly']);
if (in_array($vbulletin->GPC['usergroupid'], $readonlyids))
{
if ($permvalue['readonlyvalue'] == 'true')
{
print_yes_row($vbphrase["$permvalue[phrase]"], "usergroup[$permvalue[parentgroup]][$permtitle]", $vbphrase['yes'], true);
}
else
{
print_yes_row($vbphrase["$permvalue[phrase]"], "usergroup[$permvalue[parentgroup]][$permtitle]", $vbphrase['no'], false);
}
continue;
}
}

print_yes_no_row($vbphrase["$permvalue[phrase]"], "usergroup[$permvalue[parentgroup]][$permtitle]", $getval);
}
}
print_table_break();
print_column_style_code(array('width: 70%', 'width: 30%'));
}

print_submit_row(iif($_REQUEST['do'] == 'add', $vbphrase['save'], $vbphrase['update']));
}

// ###################### Start insert / update #######################
if ($_POST['do'] == 'update')
{
$vbulletin->input->clean_array_gpc('p', array(
'usergroup' => TYPE_ARRAY,
'ugid_base' => TYPE_INT,
));

// create bitfield values
require_once(DIR . '/includes/functions_misc.php');
foreach($vbulletin->bf_ugp AS $permissiongroup => $fields)
{
$vbulletin->GPC['usergroup']["$permissiongroup"] = convert_array_to_bits($vbulletin->GPC['usergroup']["$permissiongroup"], $fields, 1);
}

($hook = vBulletinHook::fetch_hook('admin_usergroup_save')) ? eval($hook) : false;

if (!empty($vbulletin->GPC['usergroupid']))
{
// update
if (!($vbulletin->GPC['usergroup']['adminpermissions'] & $vbulletin->bf_ugp_adminpermissions['cancontrolpanel']))
{ // check that not removing last admin group
$checkadmin = $db->query_first("
SELECT COUNT(*) AS usergroups
FROM " . TABLE_PREFIX . "usergroup
WHERE (adminpermissions & " . $vbulletin->bf_ugp_adminpermissions['cancontrolpanel'] . ") AND
usergroupid <> " . $vbulletin->GPC['usergroupid'] . "
");
if ($vbulletin->GPC['usergroupid'] == 6)
{ // stop them turning no control panel for usergroup 6, seems the most sensible thing
print_stop_message('invalid_usergroup_specified');
}
if (!$checkadmin['usergroups'])
{
print_stop_message('cant_delete_last_admin_group');
}
}

$db->query_write(fetch_query_sql($vbulletin->GPC['usergroup'], 'usergroup', "WHERE usergroupid=" . $vbulletin->GPC['usergroupid']));

if (!($vbulletin->GPC['usergroup']['genericpermissions'] & $vbulletin->bf_ugp_genericpermissions['caninvisible']))
{
if (!($vbulletin->GPC['usergroup']['genericoptions'] & $vbulletin->bf_ugp_genericoptions['allowmembergroups']))
{
// make the users in this group visible
$db->query_write("
UPDATE " . TABLE_PREFIX . "user
SET options = (options & ~" . $vbulletin->bf_misc_useroptions['invisible'] . ")
WHERE usergroupid = " . $vbulletin->GPC['usergroupid'] . "
");
}
else
{
// find all groups allowed to be invisible - don't change people with those as secondary groups
$invisible_groups = '';
$invisible_sql = $db->query_read("
SELECT usergroupid
FROM " . TABLE_PREFIX . "usergroup
WHERE genericpermissions & " . $vbulletin->bf_ugp_genericpermissions['caninvisible']
);
while ($invisible_group = $db->fetch_array($invisible_sql))
{
$invisible_groups .= "\nAND NOT FIND_IN_SET($invisible_group[usergroupid], membergroupids)";
}

$db->query_write("
UPDATE " . TABLE_PREFIX . "user
SET options = (options & ~" . $vbulletin->bf_misc_useroptions['invisible'] . ")
WHERE usergroupid = " . $vbulletin->GPC['usergroupid'] . "
$invisible_groups
");
}
}
if ($vbulletin->GPC['usergroup']['adminpermissions'] & $vbulletin->bf_ugp_adminpermissions['cancontrolpanel'])
{
$ausers = $db->query_write("
SELECT user.userid
FROM " . TABLE_PREFIX . "user AS user
LEFT JOIN " . TABLE_PREFIX . "administrator as administrator ON (user.userid = administrator.userid)
WHERE administrator.userid IS NULL AND
user.usergroupid = " . $vbulletin->GPC['usergroupid'] . "
");
while ($auser = $db->fetch_array($ausers))
{
$userids[] = $auser['userid'];
}

if (!empty($userids))
{
foreach ($userids AS $userid)
{
$admindm =& datamanager_init('Admin', $vbulletin, ERRTYPE_SILENT);
$admindm->set('userid', $userid);
$admindm->save();
unset($admindm);
}
}
}
else if ($vbulletin->usergroupcache["{$vbulletin->GPC['usergroupid']}"]['adminpermissions'] & $vbulletin->bf_ugp_adminpermissions['cancontrolpanel'])
{
// lets find admin usergroupids
$ausergroupids = array();
$vbulletin->usergroupcache["{$vbulletin->GPC['usergroupid']}"]['adminpermissions'] = $vbulletin->GPC['usergroup']['adminpermissions'];
foreach ($vbulletin->usergroupcache AS $ausergroupid => $ausergroup)
{
if ($ausergroup['adminpermissions'] & $vbulletin->bf_ugp_adminpermissions['cancontrolpanel'])
{
$ausergroupids[] = $ausergroupid;
}
}
$ausergroupids = implode(',', $ausergroupids);
$ausers = $db->query_read("
SELECT userid FROM " . TABLE_PREFIX . "user
WHERE usergroupid NOT IN ($ausergroupids)
AND NOT FIND_IN_SET('$ausergroupids', membergroupids)
AND (usergroupid = " . $vbulletin->GPC['usergroupid'] . "
OR FIND_IN_SET('" . $vbulletin->GPC['usergroupid'] . "', membergroupids))
");

while ($auser = $db->fetch_array($ausers))
{
$userids[] = $auser['userid'];
}

if (!empty($userids))
{
foreach ($userids AS $userid)
{
$info = array('userid' => $userid);

$admindm =& datamanager_init('Admin', $vbulletin, ERRTYPE_ARRAY);
$admindm->set_existing($info);
$admindm->delete();
unset($admindm);
}
}
}
}
else
{
// insert
/*insert query*/
$db->query_write(fetch_query_sql($vbulletin->GPC['usergroup'], 'usergroup'));
$newugid = $db->insert_id();

if ($vbulletin->GPC['ugid_base'] > 0)
{
$fperms = $db->query_read("
SELECT * FROM " . TABLE_PREFIX . "forumpermission
WHERE usergroupid = " . $vbulletin->GPC['ugid_base'] . "
");
while ($fperm = $db->fetch_array($fperms))
{
unset($fperm['forumpermissionid']);
$fperm['usergroupid'] = $newugid;
/*insert query*/
$db->query_write(fetch_query_sql($fperm, 'forumpermission'));
}

$cperms = $db->query_read("
SELECT * FROM " . TABLE_PREFIX . "calendarpermission
WHERE usergroupid = " . $vbulletin->GPC['ugid_base'] . "
");
while ($cperm = $db->fetch_array($cperms))
{
unset($cperm['calendarpermissionid']);
$cperm['usergroupid'] = $newugid;
/*insert query*/
$db->query_write(fetch_query_sql($cperm, 'calendarpermission'));
}
}
}

$markups = $db->query_read("
SELECT usergroupid, opentag, closetag
FROM " . TABLE_PREFIX . "usergroup
WHERE opentag <> '' OR
closetag <> ''
");
$usergroupmarkup = array();
while ($markup = $db->fetch_array($markups))
{
$usergroupmarkup["{$markup['usergroupid']}"]['opentag'] = $markup['opentag'];
$usergroupmarkup["{$markup['usergroupid']}"]['closetag'] = $markup['closetag'];
}

require_once(DIR . '/includes/functions_databuild.php');
build_forum_permissions();
build_birthdays();

// could be changing sig perms -- this is unscientific, but empty the sig cache
$db->query_write("
DELETE FROM " . TABLE_PREFIX . "sigparsed
");

($hook = vBulletinHook::fetch_hook('admin_usergroup_save_complete')) ? eval($hook) : false;

define('CP_REDIRECT', 'usergroup.php?do=modify');
print_stop_message('saved_usergroup_x_successfully', htmlspecialchars_uni($vbulletin->GPC['usergroup']['title']));

}

// ###################### Start Remove #######################

if ($_REQUEST['do'] == 'remove')
{

if ($vbulletin->GPC['usergroupid'] < 8)
{
print_stop_message('cant_delete_usergroup');
}
else
{
print_delete_confirmation('usergroup', $vbulletin->GPC['usergroupid'], 'usergroup', 'kill', 'usergroup', 0,
construct_phrase($vbphrase['all_members_of_this_usergroup_will_revert'], $vbulletin->usergroupcache['2']['title'])
);
}

}

// ###################### Start Kill #######################
if ($_POST['do'] == 'kill')
{

// update users who are in this usergroup to be in the registered usergroup
$db->query_write("UPDATE " . TABLE_PREFIX . "user SET usergroupid = 2 WHERE usergroupid = " . $vbulletin->GPC['usergroupid']);
$db->query_write("UPDATE " . TABLE_PREFIX . "user SET displaygroupid = 0 WHERE displaygroupid = " . $vbulletin->GPC['usergroupid']);
$db->query_write("UPDATE " . TABLE_PREFIX . "useractivation SET usergroupid = 2 WHERE usergroupid = " . $vbulletin->GPC['usergroupid']);
$db->query_write("UPDATE " . TABLE_PREFIX . "subscription SET nusergroupid = -1 WHERE nusergroupid = " . $vbulletin->GPC['usergroupid']);
$db->query_write("UPDATE " . TABLE_PREFIX . "subscriptionlog SET pusergroupid = 2 WHERE pusergroupid = " . $vbulletin->GPC['usergroupid']);
$db->query_write("UPDATE " . TABLE_PREFIX . "userban SET usergroupid = 2 WHERE usergroupid = " . $vbulletin->GPC['usergroupid']);
$db->query_write("UPDATE " . TABLE_PREFIX . "userban SET displaygroupid = 0 WHERE displaygroupid = " . $vbulletin->GPC['usergroupid']);

// now get on with deleting stuff...
$db->query_write("DELETE FROM " . TABLE_PREFIX . "usergroup WHERE usergroupid = " . $vbulletin->GPC['usergroupid']);
$db->query_write("DELETE FROM " . TABLE_PREFIX . "forumpermission WHERE usergroupid = " . $vbulletin->GPC['usergroupid']);
$db->query_write("DELETE FROM " . TABLE_PREFIX . "ranks WHERE usergroupid = " . $vbulletin->GPC['usergroupid']);
$db->query_write("DELETE FROM " . TABLE_PREFIX . "usergrouprequest WHERE usergroupid = " . $vbulletin->GPC['usergroupid']);
$db->query_write("DELETE FROM " . TABLE_PREFIX . "userpromotion WHERE usergroupid = " . $vbulletin->GPC['usergroupid'] . " OR joinusergroupid = " . $vbulletin->GPC['usergroupid']);
$db->query_write("DELETE FROM " . TABLE_PREFIX . "imagecategorypermission WHERE usergroupid = " . $vbulletin->GPC['usergroupid']);
$db->query_write("DELETE FROM " . TABLE_PREFIX . "attachmentpermission WHERE usergroupid = " . $vbulletin->GPC['usergroupid']);

build_ranks();
build_forum_permissions();

require_once(DIR . '/includes/adminfunctions_attachment.php');
build_attachment_permissions();

// remove this group from users who have this group as a membergroup
$updateusers = array();
$casesql = '';
$users = $db->query_read("
SELECT userid, username, membergroupids
FROM " . TABLE_PREFIX . "user
WHERE FIND_IN_SET('" . $vbulletin->GPC['usergroupid'] . "', membergroupids)
");
if ($db->num_rows($users))
{
while($user = $db->fetch_array($users))
{
$membergroups = fetch_membergroupids_array($user, false);
foreach($membergroups AS $key => $val)
{
if ($val == $vbulletin->GPC['usergroupid'])
{
unset($membergroups["$key"]);
}
}
$user['membergroupids'] = implode(',', $membergroups);
$casesql .= "WHEN $user[userid] THEN '$user[membergroupids]' ";
$updateusers[] = $user['userid'];
}

// do a big update to get rid of this usergroup from matched members' membergroupids
$db->query_write("
UPDATE " . TABLE_PREFIX . "user SET
membergroupids = CASE userid
$casesql
ELSE '' END
WHERE userid IN(" . implode(',', $updateusers) . ")
");
}

($hook = vBulletinHook::fetch_hook('admin_usergroup_kill')) ? eval($hook) : false;

define('CP_REDIRECT', 'usergroup.php?do=modify');
print_stop_message('deleted_usergroup_successfully');
}

// ###################### Start kill group leader #######################
if ($_POST['do'] == 'killleader')
{

$db->query_write("DELETE FROM " . TABLE_PREFIX . "usergroupleader WHERE usergroupleaderid = " . $vbulletin->GPC['usergroupleaderid']);

define('CP_REDIRECT', 'usergroup.php?do=modify');
print_stop_message('deleted_usergroup_leader_successfully');
}

// ###################### Start delete group leader #######################
if ($_REQUEST['do'] == 'removeleader')
{

print_delete_confirmation('usergroupleader', $vbulletin->GPC['usergroupleaderid'], 'usergroup', 'killleader', 'usergroup_leader');

}

// ###################### Start insert group leader #######################
if ($_POST['do'] == 'insertleader')
{
$vbulletin->input->clean_array_gpc('p', array(
'username' => TYPE_NOHTML
));

if ($usergroup = $db->query_first("SELECT title FROM " . TABLE_PREFIX . "usergroup WHERE usergroupid = " . $vbulletin->GPC['usergroupid'] . " AND ispublicgroup = 1 AND usergroupid > 7"))
{
if ($user = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "user WHERE username = '" . $db->escape_string($vbulletin->GPC['username']) . "'"))
{
if (is_unalterable_user($user['userid']))
{
print_stop_message('user_is_protected_from_alteration_by_undeletableusers_var');
}

if ($preexists = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "usergroupleader WHERE usergroupid = " . $vbulletin->GPC['usergroupid'] . " AND userid = $user[userid]"))
{
print_stop_message('invalid_usergroup_leader_specified');
}

// update leader's member groups if necessary
if (strpos(",$user[membergroupids],", "," . $vbulletin->GPC['usergroupid'] . ",") === false AND $user['usergroupid'] != $vbulletin->GPC['usergroupid'])
{
if (empty($user['membergroupids']))
{
$membergroups = $vbulletin->GPC['usergroupid'];
}
else
{
$membergroups = "$user[membergroupids]," . $vbulletin->GPC['usergroupid'];
}

$userdm =& datamanager_init('User', $vbulletin, ERRTYPE_CP);
$userdm->set_existing($user);
$userdm->set('membergroupids', $membergroups);
$userdm->save();
unset($userdm);
}

// insert into usergroupleader table
/*insert query*/
$result = $db->query_write("
INSERT INTO " . TABLE_PREFIX . "usergroupleader
(userid, usergroupid)
VALUES
($user[userid], " . $vbulletin->GPC['usergroupid'] . ")
");

define('CP_REDIRECT', 'usergroup.php?do=modify');
print_stop_message('saved_usergroup_leader_x_successfully', $vbulletin->GPC['username']);
}
else
{
print_stop_message('invalid_user_specified');
}
}
else
{
print_stop_message('cant_add_usergroup_leader');
}

}

// ###################### Start add group leader #######################
if ($_REQUEST['do'] == 'addleader')
{

$groups = array();
$usergroups = $db->query_read("
SELECT usergroupid, title
FROM " . TABLE_PREFIX . "usergroup
WHERE usergroupid > 7 AND
ispublicgroup = 1
ORDER BY title
");
while($usergroup = $db->fetch_array($usergroups))
{
$groups["$usergroup[usergroupid]"] = $usergroup['title'];
}

if (!isset($groups["{$vbulletin->GPC['usergroupid']}"]))
{
print_stop_message('usergroup_not_public_or_invalid');
}

print_form_header('usergroup', 'insertleader');
construct_hidden_code('usergroupid', $vbulletin->GPC['usergroupid']);
print_table_header($vbphrase['add_new_usergroup_leader']);
print_select_row($vbphrase['usergroup'], 'usergroupid', $groups, $vbulletin->GPC['usergroupid']);
print_input_row($vbphrase['username'], 'username');
print_submit_row($vbphrase['add'], 0);

}

// ###################### Start modify #######################
if ($_REQUEST['do'] == 'modify')
{
// get usergroups (don't use the cache at this point...
// this is the only place where you could rebuild the forumcache and vbulletin->usergroupcache
// without them being present already...

unset($vbulletin->usergroupcache);

$usergroups = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "usergroup ORDER BY title");
while ($usergroup = $db->fetch_array($usergroups))
{
$vbulletin->usergroupcache["{$usergroup['usergroupid']}"] = $usergroup;
}
unset($usergroup);
$db->free_result($usergroups);

// count primary users
$groupcounts = $db->query_read("
SELECT user.usergroupid, COUNT(user.userid) AS total
FROM " . TABLE_PREFIX . "user AS user
LEFT JOIN " . TABLE_PREFIX . "usergroup AS usergroup USING (usergroupid)
WHERE usergroup.usergroupid IS NOT NULL
GROUP BY usergroupid
");
while($groupcount = $db->fetch_array($groupcounts))
{
$vbulletin->usergroupcache["{$groupcount['usergroupid']}"]['count'] = $groupcount['total'];
}
unset($groupcount);
$db->free_result($groupcounts);

// count secondary users
$groupcounts = $db->query_read("
SELECT membergroupids, usergroupid
FROM " . TABLE_PREFIX . "user
WHERE membergroupids <> ''
");
while ($groupcount = $db->fetch_array($groupcounts))
{
$ids = fetch_membergroupids_array($groupcount, false);
foreach ($ids AS $index => $value)
{
if ($groupcount['usergroupid'] != $value AND !empty($vbulletin->usergroupcache["$value"]))
{
$vbulletin->usergroupcache["$value"]['secondarycount']++;
}
}
}
unset($groupcount);
$db->free_result($groupcounts);

// count requests
$groupcounts = $db->query_read("
SELECT usergroupid, COUNT(userid) AS total
FROM " . TABLE_PREFIX . "usergrouprequest AS usergrouprequest
GROUP BY usergroupid
");
while($groupcount = $db->fetch_array($groupcounts))
{
$vbulletin->usergroupcache["{$groupcount['usergroupid']}"]['requests'] = $groupcount['total'];
}
unset($groupcount);
$db->free_result($groupcounts);

$usergroups = array();
foreach($vbulletin->usergroupcache AS $group)
{
if ($group['usergroupid'] > 7)
{
if ($group['ispublicgroup'])
{
$usergroups['public']["{$group['usergroupid']}"] = $group;
}
else
{
$usergroups['custom']["{$group['usergroupid']}"] = $group;
}
}
else
{
$usergroups['default']["{$group['usergroupid']}"] = $group;
}
}

$usergroupleaders = array();
$leaders = $db->query_read("
SELECT usergroupleader.*, username
FROM " . TABLE_PREFIX . "usergroupleader AS usergroupleader
INNER JOIN " . TABLE_PREFIX . "user AS user USING(userid)
");
while ($leader = $db->fetch_array($leaders))
{
$usergroupleaders["{$leader['usergroupid']}"][] = $leader;
}
unset($leader);
$db->free_result($leaders);

$promotions = array();
$proms = $db->query_read("
SELECT COUNT(*) AS count, usergroupid
FROM " . TABLE_PREFIX . "userpromotion
GROUP BY usergroupid
");
while ($prom = $db->fetch_array($proms))
{
$promotions["{$prom['usergroupid']}"] = $prom['count'];
}

?>
<script type="text/javascript">
function js_usergroup_jump(usergroupid)
{
task = eval("document.cpform.u" + usergroupid + ".options[document.cpform.u" + usergroupid + ".selectedIndex].value");
switch (task)
{
case 'edit': window.location = "usergroup.php?<?php echo $vbulletin->session->vars['sessionurl_js']; ?>do=edit&usergroupid=" + usergroupid; break;
case 'kill': window.location = "usergroup.php?<?php echo $vbulletin->session->vars['sessionurl_js']; ?>do=remove&usergroupid=" + usergroupid; break;
case 'list': window.location = "user.php?<?php echo $vbulletin->session->vars['sessionurl_js']; ?>do=find&user[usergroupid]=" + usergroupid; break;
case 'list2': window.location = "user.php?<?php echo $vbulletin->session->vars['sessionurl_js']; ?>do=find&user[membergroup][]=" + usergroupid; break;
case 'reputation': window.location = "user.php?<?php echo $vbulletin->session->vars['sessionurl_js']; ?>do=find&display[username]=1&display[options]=1&display[posts]=1&display[usergroup]=1&display[lastvisit]=1&display[reputation]=1&orderby=reputation&direction=desc&limitnumber=25&user[usergroupid]=" + usergroupid; break;
case 'promote': window.location = "usergroup.php?<?php echo $vbulletin->session->vars['sessionurl_js']; ?>do=modifypromotion&returnug=1&usergroupid=" + usergroupid; break;
case 'leader': window.location = "usergroup.php?<?php echo $vbulletin->session->vars['sessionurl_js']; ?>do=addleader&usergroupid=" + usergroupid; break;
case 'requests': window.location = "usergroup.php?<?php echo $vbulletin->session->vars['sessionurl_js']; ?>do=viewjoinrequests&usergroupid=" + usergroupid; break;
default: return false; break;
}
}
</script>

// ###################### Start makeusergroupcode #######################
function print_usergroup_row($usergroup, $options)
{
global $usergroupleaders, $vbphrase, $promotions, $vbulletin;

if ($promotions["$usergroup[usergroupid]"])
{
$options['promote'] .= " (${promotions[$usergroup[usergroupid]]})";
}

$cell = array();
$cell[] = "<b>$usergroup[title]" . iif($usergroup['canoverride'], '*') . "</b>" . iif($usergroup['ispublicgroup'], '<br /><span class="smallfont">' . $usergroup['description'] . '</span>');
$cell[] = iif($usergroup['count'], vb_number_format($usergroup['count']), '-');
$cell[] = iif($usergroup['secondarycount'], vb_number_format($usergroup['secondarycount']), '-');

if ($usergroup['ispublicgroup'])
{
$cell[] = iif($usergroup['requests'], vb_number_format($usergroup['requests']), '0');
}
if ($usergroup['ispublicgroup'])
{
$cell_out = '<span class="smallfont">';
if (is_array($usergroupleaders["$usergroup[usergroupid]"]))
{
foreach($usergroupleaders["$usergroup[usergroupid]"] AS $usergroupleader)
{
$cell_out .= "<a href=\"user.php?" . $vbulletin->session->vars['sessionurl'] . "do=edit&amp;u=$usergroupleader[userid]\"><b>$usergroupleader[username]</b></a>" . construct_link_code($vbphrase['delete'], "usergroup.php?" . $vbulletin->session->vars['sessionurl'] . "do=removeleader&amp;usergroupleaderid=$usergroupleader[usergroupleaderid]") . '<br />';
}
}
$cell[] = $cell_out . '</span>';
}
$options['edit'] .= " (id: $usergroup[usergroupid])";
$cell[] = "\n\t<select name=\"u$usergroup[usergroupid]\" onchange=\"js_usergroup_jump($usergroup[usergroupid]);\" class=\"bginput\">\n" . construct_select_options($options) . "\t</select><input type=\"button\" class=\"button\" value=\"" . $vbphrase['go'] . "\" onclick=\"js_usergroup_jump($usergroup[usergroupid]);\" />\n\t";
print_cells_row($cell);
}

print_form_header('usergroup', 'add');

$options_default = array(
'edit' => $vbphrase['edit_usergroup'],
'promote' => $vbphrase['edit_promotions'],
'list' => $vbphrase['show_all_primary_users'],
'list2' => $vbphrase['show_all_additional_users'],
'reputation' => $vbphrase['view_reputation']
);
$options_custom = array(
'edit' => $vbphrase['edit_usergroup'],
'promote' => $vbphrase['edit_promotions'],
'kill' => $vbphrase['delete_usergroup'],
'list' => $vbphrase['show_all_primary_users'],
'list2' => $vbphrase['show_all_additional_users'],
'reputation' => $vbphrase['view_reputation']
);
$options_public = array(
'edit' => $vbphrase['edit_usergroup'],
'promote' => $vbphrase['edit_promotions'],
'kill' => $vbphrase['delete_usergroup'],
'list' => $vbphrase['show_all_primary_users'],
'list2' => $vbphrase['show_all_additional_users'],
'reputation' => $vbphrase['view_reputation'],
'leader' => $vbphrase['add_usergroup_leader'],
'requests' => $vbphrase['view_join_requests']
);

print_table_header($vbphrase['default_usergroups'], 5);
print_cells_row(array($vbphrase['title'], $vbphrase['primary_users'], $vbphrase['additional_users'], $vbphrase['controls']), 1);
foreach($usergroups['default'] AS $usergroup)
{
print_usergroup_row($usergroup, $options_default);
}
if (is_array($usergroups['custom']))
{
print_table_break();
print_table_header($vbphrase['custom_usergroups'], 5);
print_cells_row(array($vbphrase['title'], $vbphrase['primary_users'], $vbphrase['additional_users'], $vbphrase['controls']), 1);
foreach($usergroups['custom'] AS $usergroup)
{
print_usergroup_row($usergroup, $options_custom);
}
}
if (is_array($usergroups['public']))
{
print_table_break();
print_table_header($vbphrase['public_joinable_custom_usergroup'], 9);
print_cells_row(array($vbphrase['title'], $vbphrase['primary_users'], $vbphrase['additional_users'], $vbphrase['join_requests'], $vbphrase['usergroup_leader'], $vbphrase['controls']), 1);
foreach($usergroups['public'] AS $usergroup)
{
print_usergroup_row($usergroup, $options_public);
}
print_description_row('<span class="smallfont">' . $vbphrase['note_groups_marked_with_a_asterisk'] . '</span>', 0, 6);
}

print_table_break();
print_submit_row($vbphrase['add_new_usergroup'], 0);

}

// ###################### Start modify promotions #######################
if ($_REQUEST['do'] == 'modifypromotion')
{
$vbulletin->input->clean_array_gpc('r', array(
'returnug' => TYPE_BOOL
));

$title = $db->query_first("SELECT title FROM " . TABLE_PREFIX . "usergroup WHERE usergroupid = " . $vbulletin->GPC['usergroupid']);

$promotions = array();
$getpromos = $db->query_read("
SELECT userpromotion.*, joinusergroup.title
FROM " . TABLE_PREFIX . "userpromotion AS userpromotion
LEFT JOIN " . TABLE_PREFIX . "usergroup AS joinusergroup ON (userpromotion.joinusergroupid = joinusergroup.usergroupid)
" . iif($vbulletin->GPC['usergroupid'], "WHERE userpromotion.usergroupid = " . $vbulletin->GPC['usergroupid']) . "
");
while ($promotion = $db->fetch_array($getpromos))
{
$promotions["$promotion[usergroupid]"][] = $promotion;
}
unset($promotion);
$db->free_result($getpromos);

print_form_header('usergroup', 'updatepromotion');
if (isset($vbulletin->usergroupcache["{$vbulletin->GPC['usergroupid']}"]))
{
construct_hidden_code('usergroupid', $vbulletin->GPC['usergroupid']);
}
if ($vbulletin->GPC['returnug'])
{
construct_hidden_code('returnug', 1);
}

foreach($promotions AS $groupid => $promos)
{
print_table_header("$vbphrase[promotions]: <span style=\"font-weight:normal\">" . $vbulletin->usergroupcache["$groupid"]['title'] . ' ' . construct_link_code($vbphrase['add_new_promotion'], "usergroup.php?" . $vbulletin->session->vars['sessionurl'] . "do=updatepromotion&amp;usergroupid=$groupid" . ($vbulletin->GPC['returnug'] ? '&amp;returnug=1' : '')) . "</span>", 7);
print_cells_row(array(
$vbphrase['usergroup'],
$vbphrase['promotion_type'],
$vbphrase['promotion_strategy'],
$vbphrase['reputation_level'],
$vbphrase['days_registered'],
$vbphrase['posts'],
$vbphrase['controls']
), 1);

foreach($promos AS $promotion)
{
$promotion['strategy'] = iif(($promotion['strategy'] > 7 AND $promotion['strategy'] < 16) OR $promotion['strategy'] == 24, $promotion['strategy'] - 8, $promotion['strategy']);
if ($promotion['strategy'] == 16)
{
$type = $vbphrase['reputation'];
}
else if ($promotion['strategy'] == 17)
{
$type = $vbphrase['posts'];
}
else if ($promotion['strategy'] == 18)
{
$type = $vbphrase['join_date'];
}
else
{
$type = $vbphrase['promotion_strategy' . ($promotion['strategy'] + 1)];
}
print_cells_row(array(
"<b>$promotion[title]</b>",
iif($promotion['type']==1, $vbphrase['primary_usergroup'], $vbphrase['additional_usergroups']),
$type,
$promotion['reputation'],
$promotion['date'],
$promotion['posts'],
construct_link_code($vbphrase['edit'], "usergroup.php?" . $vbulletin->session->vars['sessionurl'] . "userpromotionid=$promotion[userpromotionid]&do=updatepromotion" . ($vbulletin->GPC['returnug'] ? '&returnug=1' : '')) . construct_link_code($vbphrase['delete'], "usergroup.php?" . $vbulletin->session->vars['sessionurl'] . "userpromotionid=$promotion[userpromotionid]&do=removepromotion" . ($vbulletin->GPC['returnug'] ? '&returnug=1' : '')),
));
}
}

print_submit_row($vbphrase['add_new_promotion'], 0, 7);

}

___A___J___G___ dijo:

entra a www/admincp/usergroup.php

y postea las lineas que tienes.

Hacer clic para expandir...

A partir de que parte necesitas???

asi posteo directo...