

High-Tech Foosball Mod Project 196
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.
Spinning (Score:4, Interesting)
Re:Spinning (Score:1)
So I'd vote against spinning. It do think 180 spin (so just to the point where the feet are on top) are possible (also in real life
Bt as you said, rules are different everywhere you go
Re:Spinning (Score:1)
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.
Re:Spinning (Score:4, Insightful)
Re:Spinning (Score:1)
Spin Detector? Re:Spinning (Score:2, Funny)
Re:Spin Detector? Re:Spinning (Score:1)
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. :-)
Bending rods.... (Score:2, Insightful)
There was a "move" I was fond of, the squeezer. You just kinda pinch the ball between the player and the table, and then you just cranked hard. The ball just shot out, and the forward spin on it was incredible. Many a time you would score a goal after the ball hit the goalie/defender, and just spun right around him to the side, and into the goal.
The point being: I'd consider that an "advanced" shot, but it bends the hell out of the bars. Would you allow that?
Re:Bending rods.... (Score:2)
The point being: I'd consider that an "advanced" shot, but it bends the hell out of the bars. Would you allow that?
The backpin and frontpin squib are both legal, but they're not that effective at high levels of play. Also, you don't need to bend the rod much to shoot them--you can get the ball to shoot out just as fast with firm pressure rather than torquing the hell out of it, as long as you brush the rod off of the ball at the right speed/direction.
The kind of topspin you describe can be achieved on every shot with the right follow-through.
Basically the only time you'll see the backpin squeeze is from the goalie area--with enough practice, you can effectively pass to either side of the forward's 3-rod or shoot on goal with it. Even then it's usually limited to pick-up/funsy games as opposed to major tourney play.
Primary shots you'll see up front are the pull shot (with the middle man--including all straight, middle, long, and cutback/spray options), the snake (front-pin the ball, flip the man over and hit the ball--you can move it either direction), and the regular front-pin (which you can move either way). Less common but still seen are the push shot (with the middle man--harder to square off and effectively hit all the options than the pull), the push-kick (near man to middle man, plus dink options), the pull-kick, and tic-tac shots.
For the last 10 years I think every major tournament in the US (Worlds, Nationals, US Open, and Vegas Hall of Fame Classic) has been won by someone shooting a snake, pull, or front-pin. If there is an exception it's very uncommon. In the 70s and early 80s the push-kick and pull-kick were pretty successful as well, but nowadays literally everyone ranked in the top 200 who shoots a kick shot is over the age of 40--those shots have weaknesses that the snake, pull, and front-pin shots don't have. On european tables (grippier and slower) the front-pin is far more popular than in the US, but it's been gaining popularity here recently (since the top player in the world, Frederico Collignon, shoots it exclusively and has destroyed the US players in the last few years).
Popular funsy shots include the scorpion (bump off the near wall and brush at a steep angle into the goal, HARD), Texas T (chip the ball from a frontpin on the near man to the middle man and straight in, without moving the bar sideways at all), alien (two-handed push-kick that you slam with the left hand--hard to describe unless you see it), and the 3-to-5 smash.
Sumner
Re:Spinning (Score:2)
Just like in football, time in the redzone is going to get you the win.
If you're in the Washington, DC area, come out to the Crystal City Sports Pub in Arlington (23rd street and S. Eads) on Tuesday night at 8:00 PM. They have a handicapped tournament that is great for new players who want to learn to play tournament level foosball. Other cities have similar events, foosball.com should have a listing.
Sumner
Re:Spinning (Score:1, Redundant)
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.
No spinning! (Score:1)
A spin detector would only be allowed on tables used by players that don't spin, and then it wouldn't serve much purpose. It's fun to think about though, especially if the "appropriate punishment" were to include a mild electrical shock.
Re:Spinning (Score:1)
Re:Spinning (Score:1)
Re:Spinning (Score:2)
That's funny, after I make a cheap shot, I look at my opponent and expect him to develop a counter for it--delivering a painful demonstration of how weak my cheap shot actually is, and forcing me to improve my own game in response.
If my opponent can't counter it, then I'll just keep using it until they mount an all-out defense against it that I can't penetrate, forcing me to revert to other techniques that my opponent can counter. Then I'll mix it up, alternating between cheap shots and other shots unpredictably. If my opponent is playing in the same way, then it becomes a truly exciting mental contest, rather than a simple memorization and repetition of a single keystroke sequence, or spin shot, or whatever. And this, to me, is much more challenging than imposing an arbitrary rule against "cheap" techniques.
This generally works out for me, and I've yet to find a cheap shot in any game that was any good against an opponent who was more interested in playing than in whining.
Re:Spinning (Score:1, Informative)
It sometimes takes people a bit to learn not to spin, but once they do they are a lot better because of it. If a person is spinning they may get one or two lucky goals, but otherwise they probably can't stop the other player once that player gets the ball. Good players will be able to just pass the ball upfield and then score off of their 3 man rod.
Re:Spinning (Score:2)
Some people are uncomfortable with this level of competitiveness, and prefer to play a much more relaxed game. This is fine, of course, though I don't understand it. I always want to characterize it as "having more fun imposing arbitrary restrictions on gameplay, rather than constantly challenging yourself and your opponents to higher levels of performance". Me, I like the challenging bit. Others don't. As long as I don't accidentally end up playing with such a person, or get punished for being more competitive than my opponent, the two of us can coexist peacefully, I think.
Re:Kill The Spinners!!! (Score:1)
Some of us have to 5-man shoot to even things out (Score:1)
And the spinners do suck, but they seem to eventually figure out that it's sloppy and causing them to lose more games.
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
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.
Re:Innovation? (Score:2)
Ummm...Allow you to play foosball?
Cool, but... (Score:4, Funny)
Re:Cool, but... (Score:1)
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.
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!
Re:The goal problem (Score:1)
In France, a rebound doesn't count, it has to go in and stay in.
Re:The goal problem (Score:1)
Why doesn't he just use a sensor in the ball, then marks off the playing field and make some software to detect when and where the ball leaves the playing area. This would also allow four OUT detection, % of ball possion (you'd have to mark the players too, then see where the ball is the most)
Countless possibilities !
The Russian Linesman (Score:2)
He should have disassembled the thing (Score:2)
He should have spent the time to open it.
Umm... security concerns. (Score:3, Insightful)
Re:Umm... security concerns. (Score:4, Funny)
Its a foosball game.
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".
Re:Umm... security concerns. (Score:2)
This sounds like a rumour. It can't possibly be true. How would they account for two people going through the door at the same time? How about people swiping their card and then not entering the building. Sounds like something they tell the gullible freshman to scare the shit out of them.
Re:Umm... security concerns. (Score:2)
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:1)
Re:What? (Score:1)
Re:What? (Score:1)
Re:What? (Score:2)
Windows.KNOT?
Re:What? (Score:2, Funny)
Let's just hope that this wasn't for a software engineering course. :) Or NYU grads are in for a rude awakening after graduation.
Re:What? (Score:2)
Simple and straightforward. There's easier ways, but that sounds like it was fairly easy to prototype and test quickly. You can test that the script is outputting the right data without having the Director crap done yet.
Am I allowed to respond to all of this? (Score:2, Informative)
Of course it cost less than $50... (Score:5, Interesting)
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:1)
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:1)
He problably linked up the mysql database using ODBC. Access can link to tables from various datasources using ODBC. The tables can be accessed just like if it was a "normal" Access table.
Why on earth he would do that is beyond me.
Tuition Re:Of course it cost less than $50... (Score:1)
Re:Of course it cost less than $50... (Score:1)
So he just had to spend $50 on top of what was already available (or would you complain to someone who said they'd spent $50 modding their computer, because they'd actually spent more money on actually buying the computer in the first place?)
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...
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:1)
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:1)
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.
cool project (Score:1, Troll)
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)
Re:Proprietary technologies (Score:1)
Re:Proprietary technologies (Score:2)
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:1, Funny)
Here in Texas the pronunciations of place names given by German immigrants seem to have no connection to how they sound in German.
Re:Not a troll, or an Anti-American post but.... (Score:1)
Die Änderung -> Die Aenderung
(pronounced approximately "End-er-ung", the change), Die Lösung -> Die Loesung
("Ler-zung", the solution),
Die Übergabe -> Die Uebergabe ("Uwber-gabe" - like the sound on the end of the word "who", the transfer/handover).
Munich's proper name is München, so the transliteration's more like Muwnchen. The ch there isn't a 'ck' - think more of the softish 'ch' in 'Loch', not the hard 'ck' in 'lock'.
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:1)
I'm guessing that "foosball" sounds very close to the german "Fußball", except for the "a".
Re:Not a troll, or an Anti-American post but.... (Score:2)
Re:Not a troll, or an Anti-American post but.... (Score:1)
--
Arkan
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.
Re:You should see a foosball tournament some day (Score:1)
http://www.tafelvoetbal.nl/gallery/album0
any table that has slippery plastic balls sucks
Where Can I Get... (Score:1, Interesting)
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?
Don't forget... (Score:1, Redundant)
6) Profit!
All this technology?? (Score:2)
Webcam (Score:1)
Is this a hoax? (Score:2)
3 Goalies or 1 Goalie? (Score:2)
What do you prefer, 3 goalies or one goalie?
Whenever playing with friends (with two people on a side) I always want to control the defensemen and the goalie (at which I do a frustratingly good job). I've always aboslutely detested tables with 3 goalies on them. They just don't make any sense in my opinion. There aren't three goalies in real soccer (football) and there are 11 guys on a side in real soccer (football), not 13.
cost (Score:2)
Linux Version.... (Score:2)
a) A plane old computer lying around (I'd even say a 486)
b) Your favorite distro.
c) Java.
d) You could run a clotheshanger through the bottom of the goals and make it complete a circuit when depressed. This could link up to a $5 gamepad or other cheesy input device.
e) IIS? SQL? For Foosball? You could probably get away with plain text to keep track of things. If he was tracking velocity, shot placement, shot location, angle, number of beers.... well, I don't know how he'd get it. But if its just win-loss-ties, how hard could it be?
The ID reader was a slick idea though. I'll have to try out a shoppers club card on it.
Too bad my table sucks.
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:MM director for 50$ ? (Score:2)