Free Euro 2008 Pool Script

OK, I don’t contribute much to the software community but I’m feeling generous today.

Since I run this pool at my office and for some unknown and weird reasons the link is #1 on Google for Euro 2008 Office Pool, I figured I’d share the piece of code that runs that “system” with the public.

Its basically a PHP/MySQL app with a few tables that are self-explanatory (I hope). You just enter who picked what teams and players and then just update the results as they happen – watch the entrants rise and fall as each team wins, loses or ties. Its quite fun really, much better than doing cocaine. The PDF form that entrants fill out is part of the zip along with everything else you need, but here it is anyway if you want to take a look.

Download the ZIP file here. All you really need to do is dump the schema in a MySQL 5 database (maybe even 4 might work), change the database info in ez_sql.php file (just replace INSERT_HOST tags etc.) and you’re good to go.

If you do feel like joining the pool, send me your entry form and $16 through PayPal to zarars at gmail

Update: I’ve updated this post with an improved version of this software which includes sample data. Here’s the older version.

30 thoughts on “Free Euro 2008 Pool Script

  1. depress0r

    1. Thank you for sharing

    2. Please write and deliver a verbose user’s manual by Friday, the 30th of May

    I’m sorry to be thick but I am a graphic designer for the most part, I’m sure you understand… I assume/d I’d be populating the table’s data manually but I see quite a lot of reference in the php to soccernet data. Would you mind throwing out a brief summary of how this works?

    Thanks regardless, I hope this finds you cheerful

    Reply
  2. Dave

    Nice script…

    depress0r, the soccernet links are just a href link to the teams page. You don’t have to worry about it. All I needed to do to get it to work was dump the schema in a mysql table change the INSERT_HOST etc. stuff in ez_sql.php.

    Reply
  3. Peter

    Fixed. While using dummy data to test the entrants table, I had left the ‘players’ fields empty. After assigning values other than NULL the entrants showed up fine.

    Thanks to Zarar.

    Reply
  4. Kenneth Robinson

    How do the quarter, semi, and finals work? Are these also based on the ranking system?

    Thanks a million for this.

    Reply
  5. Dennis

    Hey, I tried to setup this up, but I get the error Fatal Error: ezSQL_mysql requires ezSQLcore (ez_sql_core.php) to be included/loaded before it can be used

    What am I missing??

    Reply
  6. Redux3

    Thanks for the script. If anybody’s standings aren’t showing up, just make sure you have values for every field in the entrants table and that those ids correspond to something in the other two tables (teams and players).

    It took me a while to figure that out. The author should’ve probably mentioned that in the post but thanks anyway.

    Reply
  7. Pingback: Free Euro 2008 Pool Script [ Depressed Programmer ]

  8. Pingback: Free World Cup 2010 Office Pool Software « Depressed Programmer

  9. kexiaoping dresses

    Pure short paragraph the wedding dress completely unfolded gentle temperament, will also show up the bride’s elegance. If the design is pleated skirt like this short section of the design of Aspect bride dress, skirt design with a hint of sweet this cute range of children. Sexy low-cut tailoring,wedding fashion trends change quickly, and no general, the same to create a dream, beautiful or noble feeling, but the changes made to all the details of the treatment.

    Reply
  10. odzież dla firm lublin

    The Mens – Wearhouse in Schaumburg, Illinois saved
    the day. There are those too that sells no
    tag wholesale apparel that supplies directly to big importers and when there’s overstock
    that these big chain stores in the country failed to
    buy, you can then buy it from wholesale women’s clothing liquidators for prices next to nothing and put your own brand on the brand name tags.

    If you look past the major chains you may find some enterprising store owners that have less overhead and can sell
    you quality goods at a fantastic price.

    Reply
  11. Eddie

    It’s nearly impossible to find experienced people about this subject, but you sound like you know what
    you’re talking about! Thanks

    Reply
  12. starting a small business from home

    Hi there, just became alert to your blog through Google, and found
    that it’s truly informative. I’m going to watch out for brussels.
    I will be grateful if you continue this in future.
    A lot of people will be benefited from your writing.

    Cheers!

    Reply
  13. http://nasa-balinusra.com/index.php/buku-tamu-bibit-pupuk-organik-nasa-ntb-balim/entry

    That cost alone can be more than owing one of these
    units. The cylinder head of an air compressor is one of the most important components, which
    is usually heavy and strong enough to withstand the compression force of
    air and excessive heat of compression. The first is indoors in an environment heated
    to prevent lines condense at the same time it gives you
    enough to cool the compressor where ventilation may be high temperatures.

    Reply
  14. Tyree

    Its like you read my mind! You appear to know so much approximately this, like you
    wrote the e book in it or something. I feel that you could do with a
    few percent to pressure the message house a bit, however instead of that,
    that is wonderful blog. A fantastic read. I will certainly be
    back.

    Reply
  15. Powersellers Center Video

    Plus it does not require calling potential customers
    in order to suggest that product or making fliers available
    to most in major streets. Good customer service leads to word of mouth advertisement.

    This option is also available with e – Bay in South Korea but
    it faces stiff competition from Gmarket as it
    is further long and has its 90% of its sales volume using this method.

    Reply
  16. swimming

    This Manhattan Hotel provides Guests with a perfect mix of comfortable Guest Rooms, ideal New York
    City location and gracious Guest Services all at a very affordable
    rate that will surprise you. If you have a small bust,
    choosing a suit with decoration or padding in the bust area will help balance your body.
    All through season, you can go down to any clothing
    retailer, chain store or specialty retail store and find a nice selection of swimwear,
    men’s or women’s.

    Reply
  17. Wendy

    A halter strap ties around the neck and a metal ring with
    ruching at the center of the bust adds great detail.
    And, it is this time of the year when swimwear becomes an essential buy,
    especially for women. The belly is hugged by the stretchy fabric with intricate side cinching to show off your curves in comfort and
    style.

    Reply
  18. Anneliese

    So when you see thongs and bikini swimwear
    for males, you know that a revolution has took place.
    With this technology, women can still feel sexy and refreshed even when outdoors,
    in beaches or swimming pools. Hundreds of rigs representing over 50 different RV makes and models will be available from the leading dealers in the region.

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s