vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   howtodo this with vbulletin (https://vborg.vbsupport.ru/showthread.php?t=110067)

Delphiprogrammi 03-11-2006 10:52 AM
howtodo this with vbulletin
 
hi people,

i have a custom usergroup called "permmaned_banned" with id 9.Now when i add a user to it (just a test username) and i goto "view banned users" vbulletin tells me "no users are banned on $vbulletin->options['bbtitle']"

i know vbulletin stores custom usergroups in a filed called "membergroupids" in the user table and i think no i know for sure i can get this with the MySQL function FIND_IN_SET().But since this function is not used verry much and not verry well documented i ask here


PHP Code:
$querygroups = array(); 
    foreach ($vbulletin->usergroupcache AS $usergroupid => $usergroup) 
    { 
        if ($usergroup['genericoptions'] & $vbulletin->bf_ugp_genericoptions['isbannedgroup']) 
        { 
            $querygroups["$usergroupid"] = $usergroup['title']; 
        } 
    } 
    if (empty($querygroups)) 
    { 
        print_stop_message('no_groups_defined_as_banned'); 
    } 
    //################################################### 
    // now query users from the specified groups 
    //################################################### 
    $getusers = $db->query_read(" 
        SELECT user.userid, user.username, user.usergroupid AS busergroupid, 
        userban.usergroupid AS ousergroupid, userban.reason AS reason, 
        IF(userban.displaygroupid = 0, userban.usergroupid, userban.displaygroupid) AS odisplaygroupid, 
        bandate, liftdate, 
        adminuser.userid AS adminid, adminuser.username AS adminname 
        FROM " . TABLE_PREFIX . "user AS user 
        LEFT JOIN " . TABLE_PREFIX . "userban AS userban ON(userban.userid = user.userid) 
        LEFT JOIN " . TABLE_PREFIX . "user AS adminuser ON(adminuser.userid = userban.adminid) 
        WHERE user.usergroupid IN(" . implode(',', array_keys($querygroups)) . ")  
        ORDER BY userban.bandate DESC, user.username 
    "); 
what would be the SQL to run to include the customgroups ? i have no idea howto use FIND_IN_SET() and that function could solve the issue

Marco van Herwaarden 03-11-2006 11:22 AM
http://dev.mysql.com/doc/refman/4.1/...functions.html
Quote:
FIND_IN_SET(str,strlist)

Returns a value in the range of 1 to N if the string str is in the string list strlist consisting of N substrings. A string list is a string composed of substrings separated by ‘,’ characters. If the first argument is a constant string and the second is a column of type SET, the FIND_IN_SET() function is optimized to use bit arithmetic. Returns 0 if str is not in strlist or if strlist is the empty string. Returns NULL if either argument is NULL. This function does not work properly if the first argument contains a comma (‘,’) character.

mysql> SELECT FIND_IN_SET('b','a,b,c,d');
-> 2
PS Did you set "Is banned usergroup" for that usergroup?

Delphiprogrammi 03-11-2006 11:25 AM
Quote:
Originally Posted by MarcoH64
http://dev.mysql.com/doc/refman/4.1/...functions.html


PS Did you set "Is banned usergroup" for that usergroup?
i set all to no except isbanned that's set to yes

FIND_IN_SET() isn't needed i found howto do it by looking at /modcp/banning.php permanent bans are store in a variable called "period"


All times are GMT. The time now is 07:11 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01110 seconds
  • Memory Usage 1,729KB
  • 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
  • (1)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete