sann0638
Joined: Aug 09, 2010
|
 Posted:
Oct 13, 2015 - 21:45 |
 
|
Little project I'm working on - anyone able to supply a big list of names that have been used for Fumbbl teams? |
_________________
NAF Ex-President
Founder of SAWBBL, Wiltshire's BB League on Facebook and Discord |
|
sonrises
Joined: May 02, 2013
|
| Posted:
Oct 13, 2015 - 21:54 |
|
I am. Contact me by PM if u interested.
o/ |
|
|
Dalfort
Joined: Jun 23, 2008
|
| Posted:
Oct 13, 2015 - 21:57 |
|
Can the Script kings not write something that will return all of the teams names ever used or is that too big a task to search the Database?
Edit: Ninja'd!!! |
_________________
 |
|
xnoelx
Joined: Jun 05, 2012
|
| Posted:
Oct 13, 2015 - 23:42 |
|
That's going to be a huge list. There are 284948 active teams. Then the inactive teams, whatever that means. Then there's all the retired teams. And every one of those has a different name.
Of course, Jan-Erik's retired teams probably count for about half of that total... |
_________________
 Nerf Ball 2014 |
|
harvestmouse
Joined: May 13, 2007
|
| Posted:
Oct 13, 2015 - 23:57 |
|
Well maybe if Sann doesn't include teams that have conceded, that problem might go away? I have no idea of course, just pure speculation. |
|
|
Kam
Joined: Nov 06, 2012
|
| Posted:
Oct 14, 2015 - 14:42 |
|
|
Roland
Joined: May 12, 2004
|
| Posted:
Oct 14, 2015 - 15:29 |
|
|
koadah
Joined: Mar 30, 2005
|
| Posted:
Oct 14, 2015 - 15:38 |
|
|
Christer
Joined: Aug 02, 2003
|
| sann0638 wrote: | | Little project I'm working on - anyone able to supply a big list of names that have been used for Fumbbl teams? |
I can. It's a big list though:
| Code: | > select count(1) from teams;
+----------+
| count(1) |
+----------+
| 618224 |
+----------+
1 row in set (0.05 sec)
|
|
|
|
sann0638
Joined: Aug 09, 2010
|
| Posted:
Oct 14, 2015 - 16:53 |
|
Thanks guys  |
_________________
NAF Ex-President
Founder of SAWBBL, Wiltshire's BB League on Facebook and Discord |
|
Christer
Joined: Aug 02, 2003
|
Oh, if you wish me to provide the list, get in touch in a PM with a format you'd want and I'll see what I can do. |
|
|
sann0638
Joined: Aug 09, 2010
|
| Posted:
Oct 14, 2015 - 22:47 |
|
I am alright now, thank you. |
_________________
NAF Ex-President
Founder of SAWBBL, Wiltshire's BB League on Facebook and Discord |
|
grant85
Joined: Dec 19, 2005
|
| Posted:
Mar 07, 2016 - 00:08 |
|
mike, what did you ever do with this?
very keen to know...and search the lists |
|
|
sann0638
Joined: Aug 09, 2010
|
| Posted:
Mar 07, 2016 - 08:15 |
|
Ha, thanks for asking - I was populating data for a NAF World Cup run through, basically. |
_________________
NAF Ex-President
Founder of SAWBBL, Wiltshire's BB League on Facebook and Discord |
|
|
|
TSC Draft
Search
