Usergroups moderate forums

Hello all!

Not sure - may se something like it exists already, but i was not able to find
- To add whole usegroup as forum moderator leave username field blank and select usergroup from list below
-To add normal mod leave that select in "Selected by username" position
While editing group mod still leave username field blank

[teksigns]

Originally Posted by JohnWoo

Hello all!

Not sure - may se something like it exists already, but i was not able to find
- To add whole usegroup as forum moderator leave username field blank and select usergroup from list below
-To add normal mod leave that select in "Selected by username" position
While editing group mod still leave username field blank

your instructions say to find :

	globalize($_POST, array(
		'moderator',
		'moderatorid' => INT,
		'modusername' => STR_NOHTML,
		'usergroupid' => INT,
		'membergroupids'
	));		
	
	if ($modusername == '')
	{
		print_stop_message('invalid_user_specified');
	}

	$userinfo = $DB_site->query_first("
		SELECT userid, username, usergroupid, membergroupids
		FROM " . TABLE_PREFIX . "user
		WHERE username = '" . addslashes($modusername) . "'
	");
	$foruminfo = $DB_site->query_first("
		SELECT forumid,title
		FROM " . TABLE_PREFIX . "forum
		WHERE forumid = $moderator[forumid]
	");

	if ($userinfo['userid'] AND $foruminfo['forumid'])
	{ // no errors

		require_once('./includes/functions_misc.php');

		$moderator['userid'] = $userinfo['userid'];
		
		$noalter = explode(',', $undeletableusers);
		if (!in_array($userinfo['userid'], $noalter))

however my code looks like this :

	globalize($_POST, array(
		'moderator',
		'moderatorid' => INT,
		'modusername' => STR_NOHTML,
		'usergroupid' => INT,
		'membergroupids'
	));

	if ($modusername == '')
	{
		print_stop_message('invalid_user_specified');
	}

	$userinfo = $DB_site->query_first("
		SELECT userid, username, usergroupid, membergroupids
		FROM " . TABLE_PREFIX . "user
		WHERE username = '" . addslashes($modusername) . "'
	");
	$foruminfo = $DB_site->query_first("
		SELECT forumid,title
		FROM " . TABLE_PREFIX . "forum
		WHERE forumid = $moderator[forumid]
	");

	if ($userinfo['userid'] AND $foruminfo['forumid'])
	{ // no errors

		require_once('./includes/functions_misc.php');

		$moderator['userid'] = $userinfo['userid'];
		$moderator['permissions'] = convert_array_to_bits($moderator, $_BITFIELD['moderatorpermissions'],1);
		if (!empty($moderatorid))
		{
			// update
			$DB_site->query(fetch_query_sql($moderator, 'moderator', "WHERE moderatorid = $moderatorid"));
		}
		else
		{
			// insert
			$newusergroupid = $userinfo['usergroupid'];
			$newmembergroupids = $userinfo['membergroupids'];

			$noalter = explode(',', $undeletableusers);
			if (!in_array($userinfo['userid'], $noalter))

[JohnWoo]

my fault
sorry
fixed txt uploaded

[teksigns]

Originally Posted by JohnWoo

my fault
sorry
fixed txt uploaded

my forums are now getting database errors .

Database error in vBulletin 3.0.0:

Invalid SQL:
SELECT permissions, FIND_IN_SET(forumid, '64,15,-1') AS pos
FROM moderator
WHERE modgroupid = 2 AND forumid IN (64,15,-1)
ORDER BY pos ASC
LIMIT 1

mysql error: Unknown column 'modgroupid' in 'where clause'

mysql error number: 1054

you must have added a few fields to the database tables and forgot about them .

[JohnWoo]

what about sql request in the beginning of .txt ?

ALTER TABLE moderator ADD modgroupid SMALLINT(4) DEFAULT '0' NOT NULL

[teksigns]

Originally Posted by JohnWoo

what about sql request in the beginning of .txt ?

ALTER TABLE moderator ADD modgroupid SMALLINT(4) DEFAULT '0' NOT NULL

opps

works now ....

thank you !


i click install

[teksigns]

when viewing my forums it does not show my moderators in the moderator
box near the end like before ....

now it shows [-Moderators-]

and is a link ....

when clicked it gives errors that no such user exist....

can you make this display the moderators like before ....

[teksigns]

Originally Posted by teksigns

when viewing my forums it does not show my moderators in the moderator
box near the end like before ....


now it shows [-Moderators-]

and is a link ....

when clicked it gives errors that no such user exist....


can you make this display the moderators like before ....

any ideas?

hum... never updated, and good feature ...

[fulviods]

nice mod does it work on a 3.7 RC1?