vb.org Archive - membergroupids IN (18) doesnt work

Page 1 of 2

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

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

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - membergroupids IN (18) doesnt work - why? (https://vborg.vbsupport.ru/showthread.php?t=159435)

kafi	10-04-2007 07:29 AM

membergroupids IN (18) doesnt work - why?

Can anybody help me with this querry? I have users that are in 2 membergroupids. That is 12 and 18.
When I write condition membergroupids = 12 it works fine and it pull out ousers that are in 12 membergroupids (aka additional usergroup). I guess this works only because 12 is recorderd as first id in table... 12,18...
But when i try conditional membergroupids = 18; or I try membergroupids IN (18) neither doesnt work.

Any idea why? How to accomplish this querry? Is it because there are two "IN" in the querry???

This is what I try and doesnt work for me:

PHP Code:


		
			
$query4 = $vbulletin->db->query("SELECT userid FROM user WHERE userid IN ($user) and membergroupids IN (18)"); 
while ($row4 = $vbulletin->db->fetch_array($query4)) {
     echo $row4['userid'].";";
     echo "<br />";
}

Milion thanks!!!

WhaLberg

10-05-2007 02:56 AM

Are you sure that there are users whose membergroupid is 18?

Adrian Schneider

10-05-2007 03:49 AM

You have it backwards, it would be

Code:

18 IN (membergroupids)

but that won't work because it would parse the entire membergroupids list as a string and not a list.

Use,

Code:

find_in_set(18, membergroupids)

kafi	10-05-2007 06:58 AM

Hmm I tried this:

PHP Code:


		
			
$query5= find_in_set(18, membergroupids);
echo $query5.";";

but I have got undefined function - probably I didnt call this function? Is this function OK here anyway? Because i found it in functions.php and it is about forums not about membergroupids... Well I am not coder so maybe I am doing something wrong...

Anyway i managed it with "membergroupids LIKE %18%" query and it works fine sofar.

Thanks for your help and any further feedback is appreciated .-)

Adrian Schneider

10-05-2007 07:18 AM

It's a MySQL function not a PHP function. :p

Use it instead of IN

nexialys

10-05-2007 10:54 AM

[sql]SELECT userid FROM " . TABLE_PREFIX . "user WHERE userid IN ($user) and membergroupids find_in_set(18, membergroupids)[/sql]

your way of doing the LIKE is not good as it will grab also members in group 118, 2187 etc... if you have that much usergroups.. lol

kafi	10-05-2007 12:37 PM

I am aware of that :)
Ok so how to make it in correct way? I am getting syntax errror.

PHP Code:


		
			
$query5 = $vbulletin->db->query("SELECT userid FROM user WHERE userid IN ($user) and membergroupids find_in_set(18, membergroupids)"); 

while ($row5 = $vbulletin->db->fetch_array($query5)) {

     echo $row5['userid'].";";

     echo "<br />";

Invalid SQL:
SELECT userid FROM user WHERE userid IN (17291,24998,19,8026,28994,56325) and membergroupids find_in_set(18, membergroupids);

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'find_in_set(18, membergroupids)' at line 1
Error Number : 1064

Marco van Herwaarden

10-05-2007 12:41 PM

Should be:

PHP Code:


		
			
$query5 = $vbulletin->db->query("SELECT userid FROM user WHERE userid IN ($user) and find_in_set(18, membergroupids)");

Dismounted

10-09-2007 08:00 AM

And if you get touchy about vBulletin Coding Standards...

PHP Code:


		
			
$query5 = $vbulletin->db->query("
    SELECT userid
    FROM user
    WHERE userid IN($user)
        AND FIND_IN_SET(18, membergroupids)
");

kafi	10-09-2007 12:14 PM

Thanks, it is good to learn handy stuff from beginning :)

Thanks to all of you, your advice with find_ind_set is working great .-)

All times are GMT. The time now is 12:08 PM.

Page 1 of 2

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01659 seconds Memory Usage 1,743KB 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 (2)bbcode_code_printable (5)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)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: