vb.org Archive - The search for Custom User Title

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

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

- - The search for Custom User Title (https://vborg.vbsupport.ru/showthread.php?t=296979)

Panzer Max

04-08-2013 12:16 PM

The search for Custom User Title

So, how can I search and pull up all users with Custom User Title set as Yes, Admin set (HTML allowed) ?

Does anyone know which table and field in the db?

thanks

Edit: Is is User/customtitle ?

Looks like the values are
0 No
1 Yes, Admin set
2 Yes, user set

Is that correct?

Simon Lloyd

04-09-2013 04:57 AM

Perhaps use a query in phpmyadmin like:

PHP Code:


		
			
SELECT* 
FROM`MyTable.user` 
WHERE`customtitle`>0
LIMIT 0 , 30

change MyTable.User to be the name of your table DOT then the name of your user table to include any prefix if you have one.

All times are GMT. The time now is 11:53 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00951 seconds Memory Usage 1,708KB 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 (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (2)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: