vb.org Archive - Usergroup Permissions based off Profile Options

Page 2 of 3

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)

- - Usergroup Permissions based off Profile Options (https://vborg.vbsupport.ru/showthread.php?t=235372)

DaPro

02-12-2010 06:48 PM

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

02-12-2010 06:52 PM

Quote:

Originally Posted by DaPro (Post 1980969)

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']}

    ");

}

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

02-12-2010 07:00 PM

Quote:

Originally Posted by White_Snake (Post 1980972)

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

02-12-2010 07:07 PM

Quote:

Originally Posted by DaPro (Post 1980975)

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

http://img69.imageshack.us/img69/6458/overwrite.png

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

DaPro

02-12-2010 07:10 PM

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

02-12-2010 07:17 PM

Quote:

Originally Posted by DaPro (Post 1980982)

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

02-12-2010 07:32 PM

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

White_Snake

02-12-2010 07:47 PM

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

02-12-2010 09:51 PM

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

02-14-2010 03:47 PM

Would anyone mind helping me out?

All times are GMT. The time now is 05:59 AM.

Page 2 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01105 seconds Memory Usage 1,785KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (9)bbcode_php_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: