1.5.3.6 Released

2011-03-14
2013-03-27
  • John Holder
    John Holder
    2011-03-14

    03/13/2011 v 1.5.3.6
    Minor updates here.
    - Added documentation to bottom of page regarding Paths to Victory to
      prevent needless 'help forum' posts
    - Added same documentation to this README in the "Usage" section.
    - Update the historical probabilities with 2010 tourney data
    - Normalize email to not use <> (despite the RFC) - at least one file had
      issues sending email.
    - change bracket heading from "Round 2" to "Round of 32"
    - made H tags a "basketball orange" color
    Last Checkin Included: rev 80
    Files Updated from 1.5.3.5:
    /
      bracket.php
      braket_view_module.php
      sendcode.php
    /images/
      images/style.css
    /admin/
      sendEmailUsers.php
      sendcode.php
      emailatstart.php
      index.php
      structure_1_5_1.sql
      convert_1_0_3_to_1_5_structure.sql
    /admin/utils/
      calculateSeedRoundProbs.py

     
  • cnyballer
    cnyballer
    2011-03-15

    If already running 1.5.3.5, what sql file should be run to update the db for 1.5.3.6

     
  • John Holder
    John Holder
    2011-03-15

    The DB structure is the same.  Just go into your SQL admin (phpmyadmin) and truncate table 'scoring' and then run:

    INSERT INTO `scoring` (`seed`, `1`, `2`, `3`, `4`, `5`, `6`, `type`) VALUES
    (2, 1, 2, 4, 8, 16, 32, 'geometric'),
    (3, 1, 2, 4, 8, 16, 32, 'geometric'),
    (4, 1, 2, 4, 8, 16, 32, 'geometric'),
    (5, 1, 2, 4, 8, 16, 32, 'geometric'),
    (6, 1, 2, 4, 8, 16, 32, 'geometric'),
    (7, 1, 2, 4, 8, 16, 32, 'geometric'),
    (8, 1, 2, 4, 8, 16, 32, 'geometric'),
    (9, 1, 2, 4, 8, 16, 32, 'geometric'),
    (10, 1, 2, 4, 8, 16, 32, 'geometric'),
    (11, 1, 2, 4, 8, 16, 32, 'geometric'),
    (12, 1, 2, 4, 8, 16, 32, 'geometric'),
    (13, 1, 2, 4, 8, 16, 32, 'geometric'),
    (14, 1, 2, 4, 8, 16, 32, 'geometric'),
    (15, 1, 2, 4, 8, 16, 32, 'geometric'),
    (16, 1, 2, 4, 8, 16, 32, 'geometric'),
    (1, 1, 2, 4, 8, 16, 32, 'geometric'),
    (16, 10, 20, 40, 80, 120, 160, 'espn'),
    (15, 10, 20, 40, 80, 120, 160, 'espn'),
    (14, 10, 20, 40, 80, 120, 160, 'espn'),
    (13, 10, 20, 40, 80, 120, 160, 'espn'),
    (12, 10, 20, 40, 80, 120, 160, 'espn'),
    (11, 10, 20, 40, 80, 120, 160, 'espn'),
    (10, 10, 20, 40, 80, 120, 160, 'espn'),
    (9, 10, 20, 40, 80, 120, 160, 'espn'),
    (8, 10, 20, 40, 80, 120, 160, 'espn'),
    (7, 10, 20, 40, 80, 120, 160, 'espn'),
    (6, 10, 20, 40, 80, 120, 160, 'espn'),
    (5, 10, 20, 40, 80, 120, 160, 'espn'),
    (4, 10, 20, 40, 80, 120, 160, 'espn'),
    (3, 10, 20, 40, 80, 120, 160, 'espn'),
    (2, 10, 20, 40, 80, 120, 160, 'espn'),
    (1, 10, 20, 40, 80, 120, 160, 'espn'),
    (1, 2, 3, 5, 8, 13, 21, 'fibonacci'),
    (2, 2, 3, 5, 8, 13, 21, 'fibonacci'),
    (3, 2, 3, 5, 8, 13, 21, 'fibonacci'),
    (4, 2, 3, 5, 8, 13, 21, 'fibonacci'),
    (5, 2, 3, 5, 8, 13, 21, 'fibonacci'),
    (6, 2, 3, 5, 8, 13, 21, 'fibonacci'),
    (7, 2, 3, 5, 8, 13, 21, 'fibonacci'),
    (8, 2, 3, 5, 8, 13, 21, 'fibonacci'),
    (9, 2, 3, 5, 8, 13, 21, 'fibonacci'),
    (10, 2, 3, 5, 8, 13, 21, 'fibonacci'),
    (11, 2, 3, 5, 8, 13, 21, 'fibonacci'),
    (12, 2, 3, 5, 8, 13, 21, 'fibonacci'),
    (13, 2, 3, 5, 8, 13, 21, 'fibonacci'),
    (14, 2, 3, 5, 8, 13, 21, 'fibonacci'),
    (15, 2, 3, 5, 8, 13, 21, 'fibonacci'),
    (16, 2, 3, 5, 8, 13, 21, 'fibonacci'),
    (1, 0, 0.125, 0.175824, 0.4, 0.444444, 0.36, 'odds'),
    (2, 0.0384615, 0.33, 0.283582, 0.520833, 0.521739, 0.636364, 'odds'),
    (3, 0.153846, 0.397727, 0.509434, 0.5, 0.384615, 0.625, 'odds'),
    (4, 0.211538, 0.463415, 0.681818, 0.357143, 0.777778, 0.5, 'odds'),
    (5, 0.336538, 0.449275, 0.815789, 0.142857, 0.5, 1, 'odds'),
    (6, 0.317308, 0.478873, 0.648649, 0.769231, 0.333333, 0.5, 'odds'),
    (7, 0.403846, 0.709677, 0.666667, 1, 1, 1, 'odds'),
    (8, 0.538462, 0.8125, 0.333333, 0.5, 0.666667, 0, 'odds'),
    (9, 0.461538, 0.928571, 0.75, 1, 1, 1, 'odds'),
    (10, 0.596154, 0.547619, 0.631579, 1, 1, 1, 'odds'),
    (11, 0.682692, 0.636364, 0.666667, 0.5, 1, 1, 'odds'),
    (12, 0.663462, 0.485714, 0.944444, 1, 1, 1, 'odds'),
    (13, 0.788462, 0.818182, 1, 1, 1, 1, 'odds'),
    (14, 0.846154, 0.875, 1, 1, 1, 1, 'odds'),
    (15, 0.961538, 1, 1, 1, 1, 1, 'odds'),
    (16, 1, 1, 1, 1, 1, 1, 'odds');
    
     
  • John Holder
    John Holder
    2011-03-15

    (The update is to the 'odds' method of alternate scoring)

     
  • George Westrup
    George Westrup
    2011-03-15

    Need to replace "Round of 32" in all four places in bracket_view_module.php

     
  • George Westrup
    George Westrup
    2011-03-15

    Also update admin/database.php to reflect new version 1.5.3.6

     
  • Rob J
    Rob J
    2011-03-15

    Thanks. I think someone will get to that.

     
  • John Holder
    John Holder
    2011-03-15

    Whoopsie.  I usually do that before releasing.  I'm out of practice.

     
  • John Holder
    John Holder
    2011-03-15

    I went ahead and re-uploaded with the corrected database.php file version # since it was so minor.  I also added the latest "bracket_view_module.php" that was updated by botagrox which properly prints "Round of 32" everywhere on bracket display page. (instead of "Round 2")