vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   How can I output (https://vborg.vbsupport.ru/showthread.php?t=102464)

mclark2112 12-07-2005 11:57 PM

How can I output
 
I would like to output all my member's user names to a text file, with just a space between the names? I know this is probably a simple sql statement, but I have no clue how to do it. Like this:
Quote:

John Bill Frank Barry Mke A Bobby John Bill Frank Barry Mke Adam Bobby John Bill Frank Barry Mke Adam Bobby John Bill Frank Barry Mke Adam Bobby John Bill Frank Barry Mke Adam Bobby John Bill Mke Adam Bobby John Bill Frank Barry Mke Adam Bobby John Bill Frank Barry Mke Adam Bobby John Bill Frank Barry Mke Adam Bobby John Bill Frank Barry Mke Adam Bobby John Bill Frank Barry Mke Adam Bobby John Bill Frank Barry Mke Adam Bobby Bill Frank Barry Mke Adam Bobby John Bill Frank Barry Mke Adam Bobby John Bill Frank Barry Adam Bobby John Bill Frank Barry Mke Adam Bobby John Frank Barry Mke Adam Bobby
My goal is to make a t-shirt that has, among other things, all the members names on it. So I need the names to make the screen. May use it for a subltle background for some pages too. I have about 3000 members right now. Oh, I would want to make sure banned members do not show up on this list, although I could manually remove them too.

peterska2 12-08-2005 01:52 AM

Try this

[sql]SELECT username FROM user WHERE usergroupid <> 8[/sql]

Just make sure your banned users are in usergroupid 8

mclark2112 12-08-2005 11:26 AM

That seems to spit out a vertical table when I run the query filled with the usernames. I can dump the user table into a text file, but that has all the extra fields in it. If it could just be usernames, I could get rid of the quotes nd commas easy enough...

Marco van Herwaarden 12-08-2005 11:29 AM

Just copy all the names in the query output to a decent text editor that let you replace the End-Of-Lines with a space.

mclark2112 12-08-2005 11:45 AM

OK, I dumped the user table, copied the username column into word as text. Then I replaced all the paragraph marks with 2 spaces. The output is perfect. Now to figure out how to make my design....


All times are GMT. The time now is 06:03 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.01783 seconds
  • Memory Usage 1,716KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)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