vb.org Archive - querry for secondary usergroups??

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

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

- - querry for secondary usergroups?? (https://vborg.vbsupport.ru/showthread.php?t=139560)

Dankness

02-16-2007 10:25 AM

querry for secondary usergroups??

Hello i have been tryin to figure out the proper operator to modify all users in a secondary user group. Which the table row would be

TABLE_PREFIX . 'user where membergroupids = 'is this possible?';

Basicly, i just need a method to check if say #1 is inside of the array stored in membergroupids.

Thanks
Shawn

Marco van Herwaarden

02-16-2007 11:57 AM

Check the MySQL function FIND_IN_SET()

http://dev.mysql.com/doc/refman/4.1/...functions.html

Dankness

02-16-2007 08:53 PM

Quote:

Originally Posted by Marco van Herwaarden (Post 1183812)

Check the MySQL function FIND_IN_SET()

http://dev.mysql.com/doc/refman/4.1/...functions.html

ok thank you for the tip, i have figured some of this out when i run the following querry in phpWebAdmin then it lists what im looking for.

Code:

select * from vb_user where FIND_IN_SET ( '6', membergroupids ) > 0";

but when i use it in a php querry then it gives a invalid sql syntanx

PHP Code:


		
			
$db->query("select * from ".TABLE_PREFIX."user where FIND_IN_SET ( '" . $_POST['usergroup'] . "', membergroupids ) > 0");

EDIT SOLVED:

After playing around with it for awhile i found this which works

PHP Code:


		
			
$db->query_read("SELECT * FROM ".TABLE_PREFIX."user as a WHERE FIND_IN_SET('{$_POST['usergroup']}', a.membergroupids) ");

Marco van Herwaarden

02-17-2007 06:12 AM

I hope you are not planning to use that query like this in your final code?

Never use unsanitised variables in a query (like $_POST).

All times are GMT. The time now is 03:31 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01027 seconds Memory Usage 1,723KB 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_code_printable (2)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)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
Messages: