Usergroup Permissions based off Profile Options

[DaPro]

PHP Code:

if ($vbulletin->userinfo[field6] == 'Yes' AND $vbulletin->userinfo['usergroupid'] == '2')
{
    $vbulletin->db->query_write("
        UPDATE " . TABLE_PREFIX . "user    
        SET usergroupid = 10 
        WHERE userid = {$vbulletin->userinfo['userid']}
    ");
}
elseif ($vbulletin->userinfo[field6] == 'No' AND $vbulletin->userinfo['usergroupid'] == '10')
{
    $vbulletin->db->query_write("
        UPDATE " . TABLE_PREFIX . "user    
        SET usergroupid = 2 
        WHERE userid = {$vbulletin->userinfo['userid']}
    ");
} 


I was going to try this...

But isn't that what the AND's are for in my if statements? I figured those would make sure that ONLY users who are already in the usergroup '2' can have their usergroup changed. And then if they set it to no then it would remove them and revert them to '2' only if they are already in the usergroup '10'. Does that make sense?

[White_Snake]

Originally Posted by DaPro

PHP Code:

if ($vbulletin->userinfo[field6] == 'Yes' AND $vbulletin->userinfo['usergroupid'] == '2')
{
    $vbulletin->db->query_write("
        UPDATE " . TABLE_PREFIX . "user    
        SET usergroupid = 10 
        WHERE userid = {$vbulletin->userinfo['userid']}
    ");
}
elseif ($vbulletin->userinfo[field6] == 'No' AND $vbulletin->userinfo['usergroupid'] == '10')
{
    $vbulletin->db->query_write("
        UPDATE " . TABLE_PREFIX . "user    
        SET usergroupid = 2 
        WHERE userid = {$vbulletin->userinfo['userid']}
    ");
} 


I was going to try this...

But isn't that what the AND's are for in my if statements? I figured those would make sure that ONLY users who are already in the usergroup '2' can have their usergroup changed. And then if they set it to no then it would remove them and revert them to '2' only if they are already in the usergroup '10'. Does that make sense?

yes, that code will do exactly what you want, but as i say, you will run the risk to overwrite your and your staff main membergroup permissions, so, you must do it with secondary usergroups, and since secondary usergroups are a series of numbers, it requires another mysql structure, which is what im trying to figure out without adding extra queries

[DaPro]

Originally Posted by White_Snake

yes, that code will do exactly what you want, but as i say, you will run the risk to overwrite your and your staff main membergroup permissions, so, you must do it with secondary usergroups, and since secondary usergroups are a series of numbers, it requires another mysql structure, which is what im trying to figure out without adding extra queries

I still don't see how that could happen and that code didn't work, it doesn't like something listed in it. Is there a debugger I could see if any errors are happening?

[White_Snake]

Originally Posted by DaPro

I still don't see how that could happen and that code didn't work, it doesn't like something listed in it. Is there a debugger I could see if any errors are happening?

i will explain you how could it happen, and about the debug, you can turn on the debug mode just in the same way it can be turned on for vbulletin 3



your code is overwritting that part, the primary usergroup instead of just adding a new option into the aditional usergroup

[DaPro]

Haha, I know what it's overwriting, I am not dumb. But what I am saying is THIS

PHP Code:

 AND $vbulletin->userinfo['usergroupid'] == '2' 


Should stop it, because I am not using any additional usergroups, only primary usergroups for admins, staff, mods, etc. Everyone has their own PRIMARY usergroup.

[White_Snake]

Originally Posted by DaPro

Haha, I know what it's overwriting, I am not dumb. But what I am saying is THIS

PHP Code:

 AND $vbulletin->userinfo['usergroupid'] == '2' 


Should stop it, because I am not using any additional usergroups, only primary usergroups for admins, staff, mods, etc. Everyone has their own PRIMARY usergroup.

okay, lets see then, the last piece of code you posted should work, and i just spotted a error on your mysql query:

PHP Code:

$vbulletin->db->query_write(" 
        UPDATE " . TABLE_PREFIX . "user     
        SET usergroupid = 10  
        WHERE userid = {$vbulletin->userinfo['userid']} 
    "); 


should be:

PHP Code:

$vbulletin->db->query_write(" 
        UPDATE " . TABLE_PREFIX . "user     
        SET usergroupid = 10  
        WHERE userid = " . $vbulletin->userinfo['userid']. "
    "); 


same for the other below, hope this helps

[DaPro]

This crap is still not working, man I give up.

[White_Snake]

PHP Code:

$vbulletin->db->query_write(" 
        UPDATE " . TABLE_PREFIX . "user     
        SET usergroupid = '10'  
        WHERE userid = " . $vbulletin->userinfo['userid']. "
    "); 


now try it that way, with the 10 in between the lines

as well try to add

PHP Code:

global $vbulletin; 


at the begining of the script, sometimes hooks answers in very unexpected forms, or try it in another plugin such as MEMBERINFO which should display any user profile, just for the sake to see if there is something wrong with the plugin location it happend to me once :P

[DaPro]

That didn't help either, and I don't know how to set it to MEMBERINFO in the hook?

I decided to just scrap this, because I just realize it's not going to fully do what I want.

--------------- Added [DATE]1266074015[/DATE] at [TIME]1266074015[/TIME] ---------------

Okay, so I actually found this script someone made that works as a cronjob when set as a scheduled task. It worked, BUT people were having access issues once they logged in or did anything, it immediately reverted them back to the registered user usergroup.

Any idea as to why from any advanced coders on here?

PHP Code:

error_reporting(E_ALL & ~E_NOTICE);
if (!is_object($vbulletin->db))
{
    exit;
}

$tmpA = $vbulletin->db->query_read("
SELECT user.userid,user.usergroupid,user.username 
FROM `user`,`userfield` AS field 
WHERE user.usergroupid = 2 
AND user.userid=field.userid 
AND field.field6='Yes'
");

while ($tmpU = $vbulletin->db->fetch_array($tmpA))
{
    $vbulletin->db->query_write("
        UPDATE " . TABLE_PREFIX . "user
        SET usergroupid = 10 
        WHERE userid = " . $tmpU['userid']);
}




$tmpA = $vbulletin->db->query_read("
SELECT user.userid,user.usergroupid,user.username 
FROM `user`,`userfield` AS field 
WHERE user.usergroupid = 10 
AND user.userid=field.userid 
AND field.field6='No'
");

while ($tmpU = $vbulletin->db->fetch_array($tmpA))
{
    $vbulletin->db->query_write("
        UPDATE " . TABLE_PREFIX . "user
        SET usergroupid = 2
        WHERE userid = " . $tmpU['userid']);
} 


[DaPro]

Would anyone mind helping me out?