[Version 2 Release] RaspberryPints - Digital Taplist Solution

day_trippr · Sep 28, 2017

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? [...]

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!

tentenbrews · Sep 28, 2017

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!

I did set it up for my screen (1080p TV) and a portrait orientation.

I see where you referenced the img folder now in your code, thanks.

tentenbrews · Sep 28, 2017

So this is where I am at. It's not too bad, it will do for now. Obviously the height will change with more or less tasting notes. I will probably just make an effort to add more notes to keep the screen full. I would like to figure out how to put a logo in the header instead of the text at some point.

kaljade · Sep 28, 2017

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.

Weird, works fine on mine, but admittedly I don't have the headings above mine, so maybe I pointed you at the wrong css attribute for your setup.

kaljade · Sep 28, 2017

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

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.

day_trippr · Sep 28, 2017

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

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

tentenbrews · Sep 29, 2017

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.

Cool, I will play around with this soon. Thanks!

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

Thanks! I need to take it all apart this weekend and put a couple coats of poly on it.

GMAN-62 · Oct 2, 2017

Using 3/16 ID bev line, and using the 1/4 barb, did you have to use clamps to prevent leaking?

day_trippr · Oct 2, 2017

I've always used Bevlex 200 (solid pvc) on 1/4" barbs and while I do install hose clamps the fit is so snug I'm confident the clamps aren't making them seal.
Indeed they're likely superfluous - I always have to cut the tubing off the barbs, no way they slide off without heating them first.

Otoh...if you're using PET barrier tubing, none of the above applies. I'd be using JG fittings if I ran Bev Seal Ultra 235, for instance.
But no clamps needed with those, either

Cheers!

GMAN-62 · Oct 8, 2017

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:
<?php echo $i; ?>

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="">

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:

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

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

Thanks.

kaljade · Oct 8, 2017

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:

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

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

Thanks.

I use this on my setup but with snooker balls instead of beer labels:

The key thing to remember is you need to add the

Code:

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

twice (once in the "active taps" section of your index.php file and again in the "inactive" section).

Cheers,

Kal

GMAN-62 · Oct 9, 2017

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?

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 <?php echo $i; ?> 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

GMAN-62 · Oct 9, 2017

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

kaljade · Oct 9, 2017

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?

Correct, I have all of my image files separated in subdirectories: tap, keg, srm, ibu, abv, logo but only because I have a lot of them so it just keeps things tidy you don't need to use subdirectories, if not remove the tap folder in the code like this:

Code:

<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

I called the top section the "active taps" section because that is where the code for your tapped kegs resides. The bottom section is where your "Nothing on tap" taps reside, ergo "inactive taps".

Cheers,

Kal

kaljade · Oct 9, 2017

GMAN-62 said:
Is there an easy way to update RPINTS to the 2015 BJCP Style Guidelines?

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

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...

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

GMAN-62 · Oct 9, 2017

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

kaljade · Oct 9, 2017

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

You actually want www/style.css the one in admin/ controls the admin page font colour.

Look for this:

PHP:

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

GMAN-62 · Oct 10, 2017

Kal,

Roughly what size do the images have to be for the taps? I'm able to make the changes and the handles show up, but they are way to big. I'm using a beer bottle as the handle and have included a pic.

Also, does it require modifying the width of the column for the TAP #?

Thanks.

GMAN-62 · Oct 10, 2017

Kal,

I was able to get it set. I had to make the images 55 pix x 186 pix. It displays well, and I can read them easily.

Thanks for the assist. Once I get my handles, I'll upload a photo of my keezer with the display and my handles.

GMAN-62 · Oct 10, 2017

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

CadiBrewer · Oct 10, 2017

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

Nope, no need to change the pulse count to compensate for different serving pressures. At any one time I'll have something on nitro, a low carb bitter, and a high carb kolsch and it all stays remarkably accurate. I have the standard SwissFlow meters with a much higher pulse count, but I can't see the lower pulse count meters needing to be altered.

GMAN-62 · Oct 10, 2017

Do the beer line lengths sound right?

kaljade · Oct 10, 2017

GMAN-62 said:
Do the beer line lengths sound right?

You need to set your hose length based on individual serving pressure, so it will vary from keg to keg, I have three secondary regs set to 6, 11, and 16 PSI.

This is the best hose length calculator I've seen, pretty sure it's the same day_trippr and a few others here use: http://www.mikesoltys.com/2012/09/17/determining-proper-hose-length-for-your-kegerator/

GMAN-62 · Oct 10, 2017

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.

kaljade · Oct 10, 2017

GMAN-62 said:
Ive used that calculator before and it indicated I needed 11 ft w/o the flowmeters, but Ive been using 3/16 ID bev line that is 5 6 long with no problem. I know theres a bit of churn with the meters so I thought adding 5 would do the trick. Maybe Ill do one line before cutting the rest. Dont want to waste the line.

The closer you fit the flowmeter to the keg the less the impact will be, the sweet spot is 12" - 18" from the keg, and keep them horizontal to reduce "ghost pours".

barrooze · Oct 10, 2017

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.

Doh! I need to do that! I'll write it up and send it out this week. Thanks for the reminder! :mug:

day_trippr · Oct 10, 2017

I agree with everything attributed to me in the last few posts

My SF800 meters are 12" from the keg Out posts, and I have another 11 feet of beer line from the meters to the faucets on four of my faucets, 14 more on one faucet, and 6 on the stout faucet.

And yes, I am 100% behind Mike's line calculator, truly the only one worth using. I just wish he'd do the work to provide numbers for PET lined tubing, but, in the meantime, using a 1.5X multiplier will put the user in the ballpark.

wrt pressure vs meter accuracy, I typically run three different pressures (15 psi for the hefe I keep on tap, 35 psi beer gas for the stout, and the rest share an 11 psi rail.
I've been running SF800 meters for two years now and have never noticed performance differences across all six taps. If I put in an accurate starting volume, any keg will kick within +/- one 12 ounce pour. These meters are used in a myriad of applications - I suspect my three cases make for a skinny subset of the practical scope.

Also, I recommend coiling the beer line atop the keg and having an air stirring fan running 24/7 inside the cooler. It'll solve a lot of ghost pours.

btw, anyone running flow meters should make sure they can launch phpMyAdmin and connect to the R'Pints database successfully.
You can do hella lot with that tool wrt finding interesting things in your pour database and diagnosing issues...

Cheers!

sedgington · Oct 17, 2017

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!

kaljade · Oct 17, 2017

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!

I have successfully installed RPints on Stretch (which uses MariaDB 10 & PHP7), but the issue I ran into was around hardware conflicts between the RPi3 and the Alamode board.

I did write up my steps but never posted them as life got in the way so I never finished addressing the RPi3/Alamode conflict (although I think I know the solution but haven't had time to test it).

Considering Jessie is still supported and the steps are well documented I'd suggest you follow that path as I can't see any compelling reason to need to upgrade beyond that in the near future.

Cheers,

Kal

BTW, to make RPints PHP7 compatible would take more than just rewriting configprocessor.php as it uses PHP-MySQL throughout, but I believe one contributor is already undertaking that monumental project (albeit from a forked branch so not exactly apples and apples).

iainwb · Oct 18, 2017

So, I loved RaspberryPints, and ran it for a couple of years, but I prefer running up-to-date systems and I keep my development machine up to date. Since the project was basically abandoned there is no a lot of deprecated code in RPints 2.0; I was having to change so much code and database info to make it work, that I just started from scratch, since I also wanted updated beer styles, BeerXML import for beers, a non-alchoholic feature, on-deck keg status, multiple style sheets, updated interface.

Right now I'm running it on an RPi 3-B, with Jessie, PHP 7, and MySQL 5.7 + PDO. I don't have flow meters since I always have a keg or two ready to replace a kicked keg, but am working on integrating the old RPints flow meter code into my system. Also, there is no auto configure or page security, since I run this at home behind a firewall.

I find you can get great help here keeping the old RPints going, especially working with flow meter issues. I just wanted something different.

Here is what it looks like.

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!

[Version 2 Release] RaspberryPints - Digital Taplist Solution

Help Support Homebrew Talk:

Foxtrot Delta Tango

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Foxtrot Delta Tango

Well-Known Member

GMan-62

Foxtrot Delta Tango

GMan-62

Well-Known Member

GMan-62

GMan-62

Well-Known Member

Well-Known Member

GMan-62

Well-Known Member

GMan-62

GMan-62

GMan-62

Well-Known Member

GMan-62

Well-Known Member

GMan-62

Well-Known Member

Well-Known Member

Foxtrot Delta Tango

Well-Known Member

Well-Known Member

Active Member

Similar threads