[Version 2 Release] RaspberryPints - Digital Taplist Solution

RandR+ said:

Here are the instruction I followed:

pi@raspberrypi ~ $ sudo mysql
You will see something like this:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 71
Server version: 10.1.23-MariaDB-9+deb9u1 Raspbian 9.0

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>


[Enter the following commands not including MariaDB [(noen)](Lines that start with MariaDB [(none)]> the other lines are the result)
Feel Free to change the userName(after USER) and password (after IDENTIFIED BY )]
MariaDB [(none)]> CREATE USER RaspberryPints@'%' IDENTIFIED BY 'RaspberryPints';
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> grant all privileges on *.* to RaspberryPints@'%';
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> exit
Bye

Then open install/includes/configprocessor.php and replace all instances of "root" with "RaspberryPints" (or your chosen user name)

Click to expand...

tentenbrews said:

So here is my display. I've been trying to figure out how to get the taplist to cover the whole screen. Is there a way to stretch it out?

Click to expand...

day_trippr said:

There is a built-in conflict between the default installations of BrewPi and RaspberryPints: they both use an index.php file as the target of a web access, so if you try to install both in the same root folder, the latter installation will over-write the former's index.php.

While I've always rooted my multiple BrewPi installations in a folder below /var/www (or /var/www/html), one can have them coexist in the same folder by renaming the first installed to something like rpints.php or brewpi.php, so that the latter installation doesn't wipe out the former. Then you can reference the desired page by adding /rpints.php or /brewpi.php (whichever you went with) to the end of the url...

[edit] The only conflicting files are the index.php, btw. BrewPi parks its style.css in a subordinate folder and the apps don't share any folder names or other file names at their roots...

Cheers!

Click to expand...

omhelle said:

I`ve tried to do this, but without any luck.

Ole

Click to expand...

jevers said:

So have I screwed up both of them now? Or since I installed RPints second, should it be OK and BrewPi just needs to be wiped and reinstalled?

Click to expand...

day_trippr said:

Go back to one +, then find a nice image you can tack on across the bottom to fill the dead space

Cheers!

Click to expand...

dcrog said:

Simple. Add more taps.

Click to expand...

tentenbrews said:

Definitely a good idea. But that is a little out of my wheelhouse to accomplish that. Besides, I could be wrong, but I don't think it's possible with the current configuration? The background goes right to the end of the forth tap. It seems everything below that is dead space. If the space below the forth tap was available wouldn't the background cover the entire screen? And yes the background image is definitely big enough to do it.

Click to expand...

<style type="text/css">
<!--
img.size{
	width:100%;
	height:auto;
}
-->
</style>

<img class="size" src="img/tap_numbers.png" alt="">

tentenbrews said:

Just not an option.

Click to expand...

table .tap-num{
width: 50px;
}

table .tap-num{
width: 50px;
height: 150px;
}

day_trippr said:

That the background image isn't covering the entire screen is strange.
I just zoomed way out of my taplist and the background still covered the full screen.
Not sure what to make of that aside from a suspicion the screen geometer isn't set correctly.
What happens when you zoom in - does the background image eventually fill the entire screen?

Anyway...wrt tacking an image to the bottom of the page, if you look at the pic of my taplist a few posts back, the "Taps" line across the bottom of the display is actually an image file (a png with background transparency set).

All it took was to add these lines to the bottom of index.php:

Code:

<style type="text/css">
<!--
img.size{
	width:100%;
	height:auto;
}
-->
</style>

<img class="size" src="img/tap_numbers.png" alt="">

If you want your image to be opaque you can use pretty much any file format including a jpg, no need to use formats that support transparency, and the html code above doesn't specify - or care - either way.
If you park a virgin copy of index.php you can play with the live file 'til you get things the way you want it...

Cheers!

Click to expand...

kaljade said:

The other option is a simple css hack to increase the height of each row:

Open your style.css file and look for the following lines:

PHP:

table .tap-num{
width: 50px;
}

Then add a height value in, eg:

PHP:

table .tap-num{
width: 50px;
height: 150px;
}

Save and push it up to your Pi, then plug your USB keyboard back into it and hit 'CTRL+F5' to do a hard refresh and force it to load the new css values.

If 150 is too much, scale it back to 125, or if you need more increase it to 175, then rinse and repeat with the upload and hard refresh.

Might take a little tweaking but it should get you there.

Only caveat is that the row heights are dynamically adjusted based on your text within the notes field, so if you keg a beer with a particularly verbose description you may need to clawback the height value to compensate.

Cheers,

Kal

Click to expand...

tentenbrews said:

So long story short, no the background would not fill the screen when zoomed in. But it's fixed now.
And thanks for the info about the image at the bottom. Where did you save the png file at? [...]

Click to expand...

day_trippr said:

There is a section of the installation to configure your screen size. I suspect running in Portrait mode requires an edit to those settings.

You can save the file anywhere, of course, and use an explicit path to it, but I stuck it in the /img folder where RaspberryPints keeps the rest of its images (the background and logo files)...

Cheers!

Click to expand...

tentenbrews said:

So long story short, no the background would not fill the screen when zoomed in. But it's fixed now.

And thanks for the info about the image at the bottom. Where did you save the png file at?



Thanks. I gave this a try. Indeed it works and I can fill the screen, but it is only expanding the line starting with "tap #". So it ends up looking kinda weird. Plus it throws off the "Beer name & etc" column if one beer has a bunch of tasting notes, like you mentioned. I will probably try and mess around with the header size. What I would really like to do is put a image there instead of the text.

Click to expand...

tentenbrews said:

I would like to figure out how to put a logo in the header instead of the text at some point.

Click to expand...

				<div class="HeaderCenter">
					<h1 id="HeaderTitle">
						<?php
							if (mb_strlen($config[ConfigNames::HeaderText], 'UTF-8') > ($config[ConfigNames::HeaderTextTruncLen])) {
								$headerTextTrunced = substr($config[ConfigNames::HeaderText],0,$config[ConfigNames::HeaderTextTruncLen]) . "...";
								echo $headerTextTrunced ; }
							else
								echo $config[ConfigNames::HeaderText];
						?>
					</h1>
				</div>

				<div class="HeaderCenter">
					<?php if($config[ConfigNames::UseHighResolution]) { ?>			
						<img src="img/logo/centre.png" height="200" alt="">
					<?php } else { ?>
						<img src="img/logo/centre.png" height="100" alt="">
					<?php } ?>
				</div>

tentenbrews said:

So this is where I am at. It's not too bad, it will do for now.[...]

Click to expand...

kaljade said:

That one is easy enough, look for this in your index.php file:

PHP:

				<div class="HeaderCenter">
					<h1 id="HeaderTitle">
						<?php
							if (mb_strlen($config[ConfigNames::HeaderText], 'UTF-8') > ($config[ConfigNames::HeaderTextTruncLen])) {
								$headerTextTrunced = substr($config[ConfigNames::HeaderText],0,$config[ConfigNames::HeaderTextTruncLen]) . "...";
								echo $headerTextTrunced ; }
							else
								echo $config[ConfigNames::HeaderText];
						?>
					</h1>
				</div>

Switch it for something like this:

PHP:

				<div class="HeaderCenter">
					<?php if($config[ConfigNames::UseHighResolution]) { ?>			
						<img src="img/logo/centre.png" height="200" alt="">
					<?php } else { ?>
						<img src="img/logo/centre.png" height="100" alt="">
					<?php } ?>
				</div>

Image location and title changed to suit your environment of course.

Click to expand...

day_trippr said:

That actually looks pretty good. The frame is a nice touch as well

Click to expand...

2Kegger said:

Hey all,

I've modified my taplist so that I can put the images from my tap handles on my list. It seems some people have trouble figuring out what 1,2,3,4 and 5 mean. I used some code from another user who put pool balls on his, and I'm sorry, I can't remember who that was. Basically, I made images for tap handles (http://www.micromatic.com/draft-keg-beer/tap-handles-pid-C100-4-M.html) and then used the same images for my tap list. I shrunk them down a bit, and number name them 1-Tap, 2-Tap, etc...

Then I do this:
Changing Tap images:

It's a pretty easy change to make. – INDEX.PHP

The original code line just wrote the tap number:
Code:
<span class="tapcircle"><?php echo $i; ?></span>

I added extra code as an image tag to use the tap number plus additional characters to make up the file names (e.g. 1-Tap.jpg, 2-Tap.jpg, etc):
Code:

<img src="img/<?php echo $i; ?>-Tap.jpg" alt="">

Click to expand...

GMAN-62 said:

2kegger, I haven't worked with php before so I want to make sure I understand how to do this. do I put the image files in the "var/www/img folder, and then edit the index.php line to this:

<span class= "tapcircle"><img src="img/<?php echo $i; ?>-Tap.jpg" alt=""></span>

save the index.php file and I'm good to go?

Thanks.

Click to expand...

<span class= "tapcircle"><img src="img/tap/<?php echo $i; ?>-tap.png" alt=""></span>

GMAN-62 said:

Kal,

In your code you have "src="img/tap/". Is that because the path to your images is "var/www/img/tap" and that's where you put all the snooker ball images and the code you added is pointing to that directory?

If my assumption is right, ad if I don't make a "tap" sub directory under img, do I put my images in the directory var/www/img?

Click to expand...

<span class= "tapcircle"><img src="img/<?php echo $i; ?>-tap.png" alt=""></span>

GMAN-62 said:

Also, you said to include the code under the active and inactive section of the index.php file. How do you know which is the active and which is the inactive section of the index.php file? I found the near the top of the page and near the bottom of the page, but I couldn't figure out how to tell the difference between active and inactive sections.

Thanks.

GMan-62

Click to expand...

GMAN-62 said:

Is there an easy way to update RPINTS to the 2015 BJCP Style Guidelines?

Click to expand...

barrooze said:

FINALLY FIGURED OUT THE BJCP CATEGORIES!

There's apparently some 'Foreign Keys' in the SQL DB. They are linking the original 'beerStyles' table to the 'beers' table. I had renamed the original styles table to 'beerStyles2', which drove the limit of the style ID number to be no more than the max of the original table. The PHP beer_form sheet showed the 'beerStyles' table, but the code in the background used the 'beerStyles2' sheet. I could not figure out how to re-direct the relation, so I ended up re-renaming the original table back to 'beerStyles', appended the 2015 category table to the original, then just deleted all of the original line items in the now-merged table.
(EDIT: I found out how to change the relation in 'beers'. If you've renamed the original table to something (i.e. beerStyles2008) and named the 2015 cats to 'beerStyles', you'll need to go to 'beers', Structure, click on "Relations View under the fields. On the beerStyleId line, the 5th dropdown should be 'beerStyles2008'. Click on this and point to 'beerStyles'. Press Save, and your RPints should now allow all the categories found in the 'beerStyles' table!)

Something to note at this point: any beer you have in your 'beers' table needs to have the style updated to the new category. If you do not, and you delete the id from 'beerStyles', the beer entirely gets deleted from the 'beers' table. I only had a few, and I had my tap listing up on a monitor so it was easy to re-add the beers. That being said, if you've been using RPints for years and have tons of Beers in the table, you may want to forego this update. OR you can update the category IDs in the beer table with a relation table.

If anyone is interested in updating their category list to the 2015 BJCP cats, I will type up how to do it and post it here. I'll also try to add the 2008-2015 mapping table and SQL code to update the cats in the 'beers' table.


NOW... continue trying to figure out wtf is up with these BeerSmith SRM images...

Click to expand...

GMAN-62 said:

Kal,

Where do you go to change the font color for the tasting notes (Beer Description). I've been looking at styles under admin and trying to remember back to my HTML coding days which was 20 years ago.

Thanks,
GMan-62

Click to expand...

p {
	margin: 20px 0 0 0;
	color: #A0A0A0;
	font-weight: normal;
	font-size: .8em;
}

GMAN-62 said:

Kal, day_trippr,

I've got everything up and running with the mods for my tap handles to display in rpints, and a slight mod to the color of the font for the beer description. I'm finally going to plum my flowmeters into my keezer.

I'm using the adafruit flow meters and changed the raspberrypints.ino pulse to 35 and the pours.php pulse to 1500 as recommended by day_trippr, and I'm planning on 2' of beer line from keg to flowmeter in, and then 8' of beer line from flowmeter out to faucet for a total of 10'. Also, I usually set my CO2 to 10 - 12 psi depending on the beer style. I'll test it to see how well that measures a 12 oz pour and adjust as necessary.

Do you notice a difference in how RPints measures the pour amounts depending on the pressure you set the PSI to? Is it enough to where you will have to change the pulses depending on the CO2 pressure? I have 4 secondary regulators so I can control the psi on each keg. If I have to adjust the pulses depending on CO2 pressure, is there a way to set the pulse separately for each meter?

Thanks,
GMan-62

Click to expand...

GMAN-62 said:

Do the beer line lengths sound right?

Click to expand...

GMAN-62 said:

I’ve used that calculator before and it indicated I needed 11 ft w/o the flowmeters, but I’ve been using 3/16” ID bev line that is 5’ 6” long with no problem. I know there’s a bit of churn with the meters so I thought adding 5’ would do the trick. Maybe I’ll do one line before cutting the rest. Don’t want to waste the line.

Click to expand...

kaljade said:

Barrooze offered to write up a how-to after much "banging of head against wall":



You can try hitting him up, but you'll need some MySQL chops as you can see above.

Click to expand...

sedgington said:

Hi,
I tried to install this the other night with the links posted on the website using alternative operating systems. I consistently got:

Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /Applications/MAMP/htdocs/RaspiPints/install/includes/configprocessor.php:178 Stack trace: #0 {main} thrown in /Applications/MAMP/htdocs/RaspiPints/install/includes/configprocessor.php on line 178

As I was using XAMPP on Windows 10, my first inclination was to believe it was something with Windows. One post on http://backpackbees.com/home-brewing/brew-controller-brew-servers/ even suggested that this was routine on a Raspberry Pi and you just needed to reboot.

Stepping outside that mindset, I looked at the mysql_connect() command and found that it no longer worked with PHP 7, which is what XAMPP, MAMP, and Raspbian Stretch use. So, if you are installing the Raspbian image after August 17 2017, Raspberry Pints, as it currently stands, will fail when installed. Please correct me if I am wrong.

Otherwise, the alternatives, as I see it, are to either:

1. install Raspbian Jessie, which still uses PHP5-MySQL, which can be found here: http://downloads.raspberrypi.org/raspbian/images/ and then follow the various hacks in this thread, and never upgrade, or

2. get someone who knows PHP 7 MySQL to rewrite the configprocessor.php to handle these calls.

(Also, it would be good to not force the user to to use a root password on the initial setup screen as this is a tedious step that breaks phpMyAdmin and has to be fixed right off the bat.)

For anyone who has been able to install Raspbian Pints on a machine using PHP 7, I would so appreciate your posting your fixes here to save any future souls the tediousness of this discovery process.

In advance, many thanks!

Click to expand...

sedgington said:

Hi,
I tried to install this the other night with the links posted on the website using alternative operating systems. I consistently got:

Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /Applications/MAMP/htdocs/RaspiPints/install/includes/configprocessor.php:178 Stack trace: #0 {main} thrown in /Applications/MAMP/htdocs/RaspiPints/install/includes/configprocessor.php on line 178

As I was using XAMPP on Windows 10, my first inclination was to believe it was something with Windows. One post on http://backpackbees.com/home-brewing/brew-controller-brew-servers/ even suggested that this was routine on a Raspberry Pi and you just needed to reboot.

Stepping outside that mindset, I looked at the mysql_connect() command and found that it no longer worked with PHP 7, which is what XAMPP, MAMP, and Raspbian Stretch use. So, if you are installing the Raspbian image after August 17 2017, Raspberry Pints, as it currently stands, will fail when installed. Please correct me if I am wrong.

Otherwise, the alternatives, as I see it, are to either:

1. install Raspbian Jessie, which still uses PHP5-MySQL, which can be found here: http://downloads.raspberrypi.org/raspbian/images/ and then follow the various hacks in this thread, and never upgrade, or

2. get someone who knows PHP 7 MySQL to rewrite the configprocessor.php to handle these calls.

(Also, it would be good to not force the user to to use a root password on the initial setup screen as this is a tedious step that breaks phpMyAdmin and has to be fixed right off the bat.)

For anyone who has been able to install Raspbian Pints on a machine using PHP 7, I would so appreciate your posting your fixes here to save any future souls the tediousness of this discovery process.

In advance, many thanks!

Click to expand...