Skip to content

Home

Jump to bottom
Chris Speck edited this page May 10, 2023 · 19 revisions

Deployment Procedure

  1. checkout the westgate edition of the latest release
  • at the time of writing it is v2.4.0.3-westgate
  • should there be a newer release, rebase v2.4.0.3-westgate branch off new tag, then create a new branch based off the updated tag and push to this repo
  1. set database config and copy source to remote host:
# for an upgrade - preview
rsync -av -e ssh --exclude='.vscode' --exclude='.git' --exclude='.github'  --exclude='.vscode' --exclude='private' --exclude='site/config.php' /home/chris/src/brewcompetitiononlineentry/ wgsite:/home/westdpkj/test.westgatebrewers.org

# for an upgrade - prod
rsync -av -e ssh --exclude='.vscode' --exclude='.git' --exclude='.github'  --exclude='.vscode' --exclude='private' --exclude='site/config.php' /home/chris/src/brewcompetitiononlineentry/ wgsite:/home/westdpkj/comps.westgatebrewers.org

# for a new install
rsync -av -e ssh --exclude='.vscode' --exclude='.git' --exclude='.github'  --exclude='.vscode' --exclude='private' /home/chris/src/brewcompetitiononlineentry/ wgsite:/home/westdpkj/comps.westgatebrewers.org

If there is an (untracked) config.local.php, copy it across the default one:

scp /home/chris/src/brewcompetitiononlineentry/site/config.local.php wgsite:/home/westdpkj/comps.westgatebrewers.org/site/config.php
  1. set database config and scp .htaccess to remote host
  2. fix remote permissions:
ssh wgsite
cd comps.westgatebrewers.org
find . -type d -exec chmod 755 {} +
  1. go through setup routine
Problems saving information or random blank pages?
set define('DEBUG', TRUE) in paths.php:90 to display errors and fix as required
  1. disable $setup_free_access
  2. setup recaptcha v2, "I'm not a robot" Checkbox site keys
  3. setup custom styles

Not working? Problems?: follow hint under step four above.

Changing Category Limit

This is a custom feature on our v2.4.0.3-westgate. To change it, modify the $category_limit variable in the limit_category function, lib/common.lib.php#3202:

function limit_category($style_num, $uid)
{
	/*
	$style_num = "style number" as computed by limit_subcategory function above.
	*/
	$category_limit = 2;

Setting Up Custom Styles

Direct insert

Use this SQL to create Speciality Stout category and sub-categories (valid for v2.5.0.1):

-- for BCOE&M 2.4.x - AABC2019
INSERT INTO `styles` (`brewStyleGroup`, `brewStyleNum`, `brewStyle`, `brewStyleCategory`, `brewStyleVersion`, `brewStyleOG`, `brewStyleOGMax`, `brewStyleFG`, `brewStyleFGMax`, `brewStyleABV`, `brewStyleABVMax`, `brewStyleIBU`, `brewStyleIBUMax`, `brewStyleSRM`, `brewStyleSRMMax`, `brewStyleType`, `brewStyleInfo`, `brewStyleLink`, `brewStyleActive`, `brewStyleOwn`, `brewStyleReqSpec`, `brewStyleStrength`, `brewStyleCarb`, `brewStyleSweet`, `brewStyleTags`, `brewStyleComEx`, `brewStyleEntry`) VALUES
('21', '001', 'Specialty Porter', 'Specialty', 'AABC', '1.040', '1.090', '1.008', '1.0124', '4.0', '9.5', '18', '50', '17', '40', '1', NULL, NULL, 'Y', 'bcoe', 1, 0, 0, 0, NULL, NULL, '<p>\r\n Beers in this category may use ingredients or processes that would be out of style in any other category. To assist judging of the specialty category entrants should also specify which AABC style their beer fits into from the list below:\r\n</p>\r\n<ul>\r\n <li>17.1 Fruit Beer</li>\r\n <li>17.2 Spice, Herb or vegetable Beer</li>\r\n <li>18.2 Classic Style Smoked Beer</li>\r\n <li>18.3 Specialty Smoked Beer</li>\r\n <li>18.4 Wood Aged Beer</li>\r\n <li>18.5 Specialty Wood Aged Beer</li>\r\n <li>18.6 Belgian Specialty Ale</li>\r\n <li>18.9 Experimental Beer</li>\r\n</ul>\r\n<p>\r\n All Specialty entries <b>must</b> have their ingredients listed along with a description of any special processes used.\r\n</p>'),
('21', '002', 'Specialty Stout', 'Specialty', 'AABC', '1.036', '1.065', '1.007', '1.024', '4.0', '6.5', '20', '50', '22', '45', '1', NULL, NULL, 'Y', 'bcoe', 1, 0, 0, 0, NULL, NULL, '<p>\r\n Beers in this category may use ingredients or processes that would be out of style in any other category. To assist judging of the specialty category entrants should also specify which AABC style their beer fits into from the list below:\r\n</p>\r\n<ul>\r\n <li>17.1 Fruit Beer</li>\r\n <li>17.2 Spice, Herb or vegetable Beer</li>\r\n <li>18.2 Classic Style Smoked Beer</li>\r\n <li>18.3 Specialty Smoked Beer</li>\r\n <li>18.4 Wood Aged Beer</li>\r\n <li>18.5 Specialty Wood Aged Beer</li>\r\n <li>18.6 Belgian Specialty Ale</li>\r\n <li>18.9 Experimental Beer</li>\r\n</ul>\r\n<p>\r\n All Specialty entries <b>must</b> have their ingredients listed along with a description of any special processes used.\r\n</p>'),
('21', '003', 'Specialty Strong Stout', 'Specialty', 'AABC', '1.050', '1.115', '1.010', '1.030', '5.0', '12.0', '30', '90', '30', '40', '1', NULL, NULL, 'Y', 'bcoe', 1, 0, 0, 0, NULL, NULL, '<p>\r\n Beers in this category may use ingredients or processes that would be out of style in any other category. To assist judging of the specialty category entrants should also specify which AABC style their beer fits into from the list below:\r\n</p>\r\n<ul>\r\n <li>17.1 Fruit Beer</li>\r\n <li>17.2 Spice, Herb or vegetable Beer</li>\r\n <li>18.2 Classic Style Smoked Beer</li>\r\n <li>18.3 Specialty Smoked Beer</li>\r\n <li>18.4 Wood Aged Beer</li>\r\n <li>18.5 Specialty Wood Aged Beer</li>\r\n <li>18.6 Belgian Specialty Ale</li>\r\n <li>18.9 Experimental Beer</li>\r\n</ul>\r\n<p>\r\n All Specialty entries <b>must</b> have their ingredients listed along with a description of any special processes used.\r\n</p>');

-- for BCOE&M 2.5.x - AABC2022
INSERT INTO `styles` (`brewStyleGroup`, `brewStyleNum`, `brewStyle`, `brewStyleCategory`, `brewStyleVersion`, `brewStyleOG`, `brewStyleOGMax`, `brewStyleFG`, `brewStyleFGMax`, `brewStyleABV`, `brewStyleABVMax`, `brewStyleIBU`, `brewStyleIBUMax`, `brewStyleSRM`, `brewStyleSRMMax`, `brewStyleType`, `brewStyleInfo`, `brewStyleLink`, `brewStyleActive`, `brewStyleOwn`, `brewStyleReqSpec`, `brewStyleStrength`, `brewStyleCarb`, `brewStyleSweet`, `brewStyleTags`, `brewStyleComEx`, `brewStyleEntry`) VALUES
('21', '01', 'Specialty Porter', 'Specialty', 'AABC2022', '1.040', '1.090', '1.008', '1.0124', '4.0', '9.5', '18', '50', '17', '40', '1', NULL, NULL, 'Y', 'bcoe', 1, 0, 0, 0, NULL, NULL, '<p>\r\n Beers in this category may use ingredients or processes that would be out of style in any other category. To assist judging of the specialty category entrants should also specify which AABC style their beer fits into from the list below:\r\n</p>\r\n<ul>\r\n <li>17.1 Fruit Beer</li>\r\n <li>17.2 Spice, Herb or vegetable Beer</li>\r\n <li>18.2 Classic Style Smoked Beer</li>\r\n <li>18.3 Specialty Smoked Beer</li>\r\n <li>18.4 Wood Aged Beer</li>\r\n <li>18.5 Specialty Wood Aged Beer</li>\r\n <li>18.6 Belgian Specialty Ale</li>\r\n <li>18.9 Experimental Beer</li>\r\n</ul>\r\n<p>\r\n All Specialty entries <b>must</b> have their ingredients listed along with a description of any special processes used.\r\n</p>'),
('21', '02', 'Specialty Stout', 'Specialty', 'AABC2022', '1.036', '1.065', '1.007', '1.024', '4.0', '6.5', '20', '50', '22', '45', '1', NULL, NULL, 'Y', 'bcoe', 1, 0, 0, 0, NULL, NULL, '<p>\r\n Beers in this category may use ingredients or processes that would be out of style in any other category. To assist judging of the specialty category entrants should also specify which AABC style their beer fits into from the list below:\r\n</p>\r\n<ul>\r\n <li>17.1 Fruit Beer</li>\r\n <li>17.2 Spice, Herb or vegetable Beer</li>\r\n <li>18.2 Classic Style Smoked Beer</li>\r\n <li>18.3 Specialty Smoked Beer</li>\r\n <li>18.4 Wood Aged Beer</li>\r\n <li>18.5 Specialty Wood Aged Beer</li>\r\n <li>18.6 Belgian Specialty Ale</li>\r\n <li>18.9 Experimental Beer</li>\r\n</ul>\r\n<p>\r\n All Specialty entries <b>must</b> have their ingredients listed along with a description of any special processes used.\r\n</p>'),
('21', '03', 'Specialty Strong Stout', 'Specialty', 'AABC2022', '1.050', '1.115', '1.010', '1.030', '5.0', '12.0', '30', '90', '30', '40', '1', NULL, NULL, 'Y', 'bcoe', 1, 0, 0, 0, NULL, NULL, '<p>\r\n Beers in this category may use ingredients or processes that would be out of style in any other category. To assist judging of the specialty category entrants should also specify which AABC style their beer fits into from the list below:\r\n</p>\r\n<ul>\r\n <li>17.1 Fruit Beer</li>\r\n <li>17.2 Spice, Herb or vegetable Beer</li>\r\n <li>18.2 Classic Style Smoked Beer</li>\r\n <li>18.3 Specialty Smoked Beer</li>\r\n <li>18.4 Wood Aged Beer</li>\r\n <li>18.5 Specialty Wood Aged Beer</li>\r\n <li>18.6 Belgian Specialty Ale</li>\r\n <li>18.9 Experimental Beer</li>\r\n</ul>\r\n<p>\r\n All Specialty entries <b>must</b> have their ingredients listed along with a description of any special processes used.\r\n</p>');

Scoring & Physical Judges Tables

Scoring of entries is done on paper.

Tallying & calculating of scores, along with management of physical judging tables are done in a spreadsheet.

The spreadsheet is built around a data export you can get from the BCOE&M admin dashboard.

We use a tool I wrote to upload the spreadsheet back into to BCOE&M.

After that, place-getters and special category winners must be set, then scores published via the BCOE&M admin interface.

Clone this wiki locally