Slashdot Log In
High-Tech Foosball Mod Project
Posted by
chrisd
on Thu Jan 02, 2003 07:08 AM
from the thirty-dollar-magstripe-readers dept.
from the thirty-dollar-magstripe-readers dept.
JakeBullet writes: "Project:
Take a standard foosball table and make it a little bit smarter. 1. The table should be aware of who's playing, the score and the status of the game. 2. Take the data from the game and use it to create a stats engine and player ranking system. 3. Project all relevant information about gameplay onto a flat screen. 4. Spend under $50.
This discussion has been archived.
No new comments can be posted.
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
Full
Abbreviated
Hidden
Loading... please wait.
Spinning (Score:4, Interesting)
Re:Spinning (Score:4, Insightful)
Parent
Spin Detector? Re:Spinning (Score:2, Funny)
Spinning not officially allowed (Score:3, Informative)
As I've never played a 'tournament' I play with spinning allowed, but YMMV.
-Trillian
Re:Spinning (Score:5, Interesting)
With spinning, you gain a broken table and a high total in the "L" column (to match the L on your forehead ;-). When I play against "spinners", I know that it's going to be a short, uninteresting game. But watching their frustration when you *always* have the ball is funny. :-)
Parent
Re:Spinning (Score:5, Funny)
Yeah, and while we're at it, I don't recall ever seeing the forwards connected together with a metal rod, restricting them to left-right movement. Same for the defensemen, too. Therefore, I vote against the foosball players being tethered together like that, because it's not like real life.
Not every table game has to be like real life. You play by the mechanics and rules given to you. What matters is that everyone has fun and nobody else's expense.
Parent
Re:Spinning (Score:2)
I think it's more of a case of when you keep losing, you stop spinning. Then you become a better player.
Okay then.. (Score:3, Funny)
Hey CowboyNeal, bet'ya $49.95 you can't take this laptop, climb inside that foosball table and stay down there while I hammer the surface back on..
Lingo and Serial Port Listining.. (Score:5, Interesting)
I am, however, curious as to how he is getting this data (1's and 0's) from the serial port to director? I wasn't aware that lingo had any hardware level control (besides the keybord and mouse) -- unless he's got it wired up so the bx board is actualy simulating a mouse click, but he doesn't say. I find myself wanting more details.
And by the way, the article is a little misleading. $50 for the sensors, breadboard and card reader. Flat screen LCD, foozball table and computer not included. See store for details.
Re:Lingo and Serial Port Listining.. (Score:2)
I believe that the way the data is taken in is by simulating a keystroke which is then captured.
And finally i dont think this was meant to be an outline for anyone else to do the project. His goal was to only spend $50 but im sure people could do it with less depending on available materials.
Re:Lingo and Serial Port Listining.. (Score:4, Informative)
See: Serial Xtra [clintonstreet.org]
S
Parent
Innovation? (Score:2)
I'm very sorry, besides the header is a little misleading I don't see anything innovative or interesting in this project... Back in '87 I had a teacher who used an Acorn and some homebrewn hardware to measure the speed of moving objects and other 'scientific' stuff and then draw graphs of the data gathered.
What does this fussball table that a pinball machine doesn't? IMHO it is just a rather primitive two person pinball game. Oh yes, it reads smartcards, very impressive.
Anyway I can image it must have been fun to built it. And... NYU now can measure how much time their students spend on playing fussball.
Cool, but... (Score:4, Funny)
Re:Cool, but... (Score:5, Insightful)
What if an incentive system were installed, instead? Considering that most foosball tables are found where drinking is involved, what if a nice, cold beer were dispensed to the player who scores each goal?
I figure things would get interesting as the player who took an early lead slows his reaction times due to alcohol, thus leveling the playing field.
Parent
And he got *credit* for this project? (Score:4, Interesting)
Also, it seems that the encoding on the student card may be the same as what we use; apparently the encoding of the social security number in my student card is the same as the encoding of the social security number at a local supermarket.
The goal problem (Score:4, Interesting)
Couldn't he combine the two systems ?
Like, detect when the ball hits the back plate + when it goes thhrough the vending machine censor. That way, if the ball just rolls in, the vending machine sensor will detect it, when it bounces the plate will detect it, and when they do bot (bounce but roll in anyway) they'll both detect it
It might get him over the $50 when adding extra sensors ofcourse
Re:The goal problem (Score:2)
Do that!
The Russian Linesman (Score:2)
Umm... security concerns. (Score:3, Insightful)
Re:Umm... security concerns. (Score:4, Funny)
Its a foosball game.
Parent
Re:Umm... security concerns. (Score:2)
BMCC had a problem with this, where they tracked your entry into various buildings and if you didn't entre certain buildings at certain times, in liu with your schedule, you'd lose financial aid.
So nw the concern is, is the kid goofing off or in class? At NYU, they don't care.. they just care they are getting money and have someone standing in front of the classroom "giving quality education".
What? (Score:5, Funny)
ASP script on a Win2k box, tied to an Access DB, which runs MySQL queries, spitting out XML which is parsed in Director. Does this guy actually realizes what he has written?
Re:What? (Score:2)
Windows.KNOT?
Of course it cost less than $50... (Score:5, Interesting)
- A large flat screen plasma TV "lieing around"
- A spare box running W2K
- Licences for MSQL (it was legal, right?)
- Licences for macromedia (that control app was made legally, right?)
- A Foosball table...
If I had all that lying around I am sure that I could of done it for $50 as well.... If not... well the licence for W2K alone would break that budget. And that is the cheapest item on the list!Not trying to take anything away from the hack, it was very cool, but saying that it cost $50 strikes me as a bit rich....
Re:Of course it cost less than $50... (Score:2)
a) typically rich
b) getting their degrees slowly
c) in debt from loans
Re:Of course it cost less than $50... (Score:2)
Re:Of course it cost less than $50... (Score:2, Interesting)
I think he used MySQL which sorts out one of the licencing costs. as for the computer - He must have had a couple of spares lieing around. What sort of a geek would he be if he didn't?
Re:Of course it cost less than $50... (Score:3, Interesting)
It seems to me that the author of the page is slightly confused:
4. Database: IIS/SQL/MS Access
In my opinion, the most interesting part of the project is the database that ties everything together. When the user swipes his or her NYU card, Director takes this information and sends it to a ASP script (running on an Windows 2000 box that is tied to an Access database). This ASP script runs a MySQL query through Access and spits back XML that contains information on the player (wins, loss, average points per game, number of games played, etc) . This XML is passed back into Director via getNetText and put into global variables which are then fed to the screen at the appropriate time.
(emphasis mine)
How you run a MySQL query through Access is beyond me. Heck, does that even make the slightest sense?
Re:Of course it cost less than $50... (Score:2)
Re:Of course it cost less than $50... (Score:3, Insightful)
Actually, since this is a foosball mod, I'd say that you could assume you already had the foosball table. Most foosball fanatics have a foosball player, just as most PC modders have a PC. On the other hand, I wouldn't say that most foosball fanatics have a spare plasma flat-panel sitting in the corner of their basement...
If I said you could mod a 486 into an Itanium monster for only $15 by:
1. Using a spare processor, power supply, motherboard, AGP video adaptor, ATA hard drive, etc.
2. Spending $15 on a ribbon cable to connect the hard drive to the motherboard, since you don't happen to have one of those handy.
Would you call that a real $15 upgrade?
Even if we all have PCs lying around the house, chances are we already have those PCs doing something else they are massive overkill. Sure, I can spare an old pentium, but then I'd lose my router...
Cheaper option. (Score:5, Funny)
Afterwards, in the bar, assess each other's footballing ability in a haze of lager and spittle.
rinse and repeat.
Re:Cheaper option. (Score:2)
More specifically, it requires you to be able to "get some people together".
On the other hand, it might actually be possible to develop a sort-of geekiness scale to descibe for this sort of project using exchange rates to convert people, money and parts into a common currency of 'Geeks'.
To that end, I therefore propose the following first draft exchange rate schedule subject to negotiation, and (of course) public ridicule:
1 Geek for each potential human participant eliminated.
1 Geek for each $100 spent on hardware/parts.
-1 Geek for Each $500 spent on commercial software.
0.2 Geek for each year of age of legacy or vintage tech parts used (> 5 years).
1 Geek for each 1000 Lego(TM) blocks used.
1 Geek bonus if a new language (human or computer) resulted from the project.
1 Geek bonus for posting it on your web site.
3 Geek bonus for getting it posted on
5 Geek bonus if your web server doesn't melt as a result.
10 Geek bonus is your project *IS* the web server.
I'm sure we can flesh it out a little, but that's a start. so, let's try it out:
1......1 Human statistician eliminated
-.5......$250 in commercial software (Win2k + Access)
0......0 Legos
0......0 Legacy factor (old parts)
9......Posted on web site, made it to
=====
So, by my calculation, this project rates 10 Geeks.
Not bad, but 90% of that rating comes from the publicity, so I think the scale needs some tuning. I guess the first thing we need to do is calibrate the scale by rating some standard projects so we can figure out what we want a standard 'Geek' to be.
Not a troll, or an Anti-American post but.... (Score:5, Interesting)
Is it to do with the German way of spelling it, with that crazy B letter they have?
I've only ever known it as table football. In fact I couldn't work out what you were talking about at first
Re:Not a troll, or an Anti-American post but.... (Score:3, Funny)
Apparently it's a decades-old transliteration of the German word.
Re:Not a troll, or an Anti-American post but.... (Score:3, Informative)
Re:Not a troll, or an Anti-American post but.... (Score:2)
Although if that was true, we wouldn't call it Munich, we'd call Moernchen.
Re:Not a troll, or an Anti-American post but.... (Score:3, Interesting)
Re:Not a troll, or an Anti-American post but.... (Score:2)
Re:Not a troll, or an Anti-American post but.... (Score:2)
You should see a foosball tournament some day (Score:3, Interesting)
I was in Nantes when the AFBF [francebabyfoot.com] held the national foosball (called "baby foot" here) tournament. Balls were litterally flying around the table. I considered myself a pretty good player until I saw real champions play...
Also, the foosball table that the guy used is really gross... He should have used a real foosball table [bonzini.com] instead. Those plasticky tables just suck, no way to lock a ball.
If the professor was smart to see the problem... (Score:2)
5. Cost of union (onion
6. School cost of relicensing from MS-SQL to DB2, several thousand dollars.
7. Expression on student's face when his project doesn't work since he only spent $50: Priceless.
Seriously, doesn't the professor factor in the cost of other tools, such as the database and other software in?
All this technology?? (Score:2)
Re:Step 5 (Score:2, Insightful)
I'm sure even for people who knew a lot, there was something to learn here.
Re:Step 5 (Score:2, Funny)
1. Fun
2. Not Fun
This guy chose (1) and now has an excellent foosball game, plus the admiration of thousands (notably NYU females, admit it, they're hot) and only a small load on his (borrowed) server.
You chose (2) and I suspect are at home poring over recent InfoWorlds.
Who's the better man? I leave that to posterity to decide. But I can guarantee I know who's enjoying his life more.
Re:To the author... (Score:2)
Re:To the author... (Score:3, Funny)
Re:cool project (Score:2)
My guess is he was familiar with these "dreaded" proprietary technologies and wanted to finish the project sometime before he graduated.
Often, the best tool for a job is the one you already have handy and know how to use. It was a foosball hack, afterall, and not a governmental census database for an emerging country, right?
Re:Proprietary technologies (Score:5, Funny)
Parent
Re:Proprietary technologies (Score:2)
Re:MM director for 50$ ? (Score:2)