abitlikehomer
-
Posts
50 -
Joined
-
Last visited
Never
Everything posted by abitlikehomer
-
Sorry - that is part of the code when the second form is called. However I have corrected the mistake now and everything works! Thorpe I cannot thank you enough for all the help and support you've given me the last couple of days - you're a life saver. If your in the UK and ever up north I owe you many a pint!! Thanks I can finally mark this as closed! YAY!!!!!!!!!
-
One last problem - it now won't pick up the UserID for some reason. So when I finally click save it shows the URL as Why is this? Final request I promise.
-
So are you sure you requesting the correct file? I wasn't doing - but I noticed it at about the same time as you must have done.
-
FOUND IT!!! Look in the selectNewsTest.js page. The variable to pass the URL - it is still set to the old link selectNews.js. I have changed it now and it is almost working. It throws up one error message though:
-
No me neither lol, not that that counts for much. It is obviously picking up the old code from somewhere but they are completely separate files with different links so I have no idea why it is doing this. Thank you for all your help anyway though
-
Tried that but unfortunately there is still no change. I've also deleted all cookies, just in case.
-
I agree with you - that does appear to be the case but I am sure I am editting the correct pages. I shall post the code below: editStory3.php <?php session_start(); ?> <!-- Design by 2A Smooth Ltd http://www.2asmooth.com --> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta name="generator" content="HTML Tidy for Linux (vers 1 September 2005), see www.w3.org" /> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <title>The Kingfisher Trust</title> <meta name="keywords" content="Homeless, People, Bridlington, Kingfisher, Trust" /> <meta name="description" content="The Kingfisher Trust - Helping the Homeless" /> <link href="default.css" rel="stylesheet" type="text/css"/> <script src="calendar.js" type="text/javascript" language="javascript"></script> <style type="text/css" media="screen,projection"> @import url(calendar.css); </style> <script type="text/javascript" src="selectNewsTest.js"></script> </head> <body> <!--Header Start--> <div id="header"> <div id="menu"> <ul> <li class="active"><a href="index.php" title="">Homepage</a></li> <li><a href="news.php" title="">News</a></li> <li><a href="about_us.php" title="">About Us</a></li> <li><a href="login.php" title="">Login</a></li> <li><a href="contact us.php" title="">Contact Us</a></li> </ul> </div> </div> <!--Header End--> <!--Content Start--> <div id="content"> <div id="sidebarleft"> <div id="linksleft" class="boxed"> <div class="title"> <h2>Latest News</h2> </div> <?php $i = 0; $rssdoc = simplexml_load_file('news/updatedNewsFeed.xml'); foreach ($rssdoc->channel->item as $item) { $i++; print "<b>". $item->title."</b><br>"; print $item->description."<br>"; print "<a href =".$item->link.">News Story</a><br>"; print "<br />" ; if ($i >= 5) break; } ?> </div> </div> <div id="main"> <div class="post"> <h2 class="title"><span>Edit News Story</span></h2> <div class="intro"><img src="images/logo.jpg" alt="" width="120" height="120" class="left" /> <p>Please select which news story you wish to edit using the drop-down box below: <?php include "connection.php" ?> <?php //database connection $query = mysql_query("SELECT * FROM News ORDER BY NewsID DESC"); ?> <form action="getNewsTest.php" method="POST"> <select name="News" onchange="showNews(this.value)"><option value="" "selected">Select News article to edit</option> <?php // loop through the records while ($row = mysql_fetch_array($query)) { echo "<option value=\"{$row['NewsID']}\">{$row['Title']}</option>"; } ?> </select> </form> </p> <div id="txtHint"><b>News story will appear here</b></div> <br /> <br /> <!-- OF COURSE YOU NEED TO ADAPT NEXT LINE TO YOUR tiny_mce.js PATH --> <script type="text/javascript" src="tinymce_3_2_7/tinymce/jscripts/tiny_mce/tiny_mce.js"></script> <script type="text/javascript"> tinyMCE.init({ theme : "advanced", //mode : "textareas", mode : "exact", elements : "txtHTMLContent", plugins : "fullpage", // Theme options theme_advanced_buttons1 : "save,newdocument,|,bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull,|,styleselect,formatselect,fontselect,fontsizeselect", theme_advanced_buttons2 : "cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,undo,redo,|,link,unlink,anchor,image,cleanup,help,code,|,forecolor,backcolor", theme_advanced_buttons3 : "hr,removeformat,visualaid,|,sub,sup,|,charmap,", theme_advanced_toolbar_align : "left", }); </script> <!-- OF COURSE YOU NEED TO ADAPT ACTION TO WHAT PAGE YOU WANT TO LOAD WHEN HITTING "SAVE" --> <form action="alterNews.php" method="POST" name="retrieveddetails"> <!--<input type="hidden" name="NewsID" value="<?php //$NewsID =$_POST['NewsID']; ?>"/>--> <input type="hidden" name="NewsID" id="NewsID" /> <p> Title: <input name="txtTitle" type="text" id="txtTitle"> </p> <p> Date: <input name="txtDate" type="text" id="txtDate" value="" class="calendarSelectDate" /> </p> <p> Content: <br /> <textarea name="txtContent" cols="50" rows="15" id="txtContent" ></textarea> HTML Content: <br /> <textarea name="txtHTMLContent" cols="50" rows="15" id="txtHTMLContent" ></textarea> <input type="submit" value="Save" /> </p> </form> </div> </div> </div> <div id="calendarDiv"></div> <div id="sidebarright"> <div id="linksright" class="boxed"> <div class="title"> <h2>Useful Links</h2> </div> <ul> <li><a href="http://www.shelter.org.uk">Shelter</a><br /> The UK's biggest homeless charity</li> <li><a href="http://www.eastriding.gov.uk/az/az_details_new?az_selected=599">Homeless form</a><br /> Complete this form for help and assistance from East Riding Council</li> <li><a href="http://homelessuk.org/">HomelessUK</a></li> </ul> <div id="sponsorlogo"><!--<img src="images/United logo.jpg" alt="united coop logo" />--></div> </div> </div> </div> <!--Content End--> <!--Footer Start--> <div id="footer"> <p id="legal">Copyright © 2009 Kingfisher Trust. All Rights Reserved. Designed by <a href="http://www.2asmooth.com/">2A Smooth Ltd</a>.</p> <p><a href="http://validator.w3.org/check?uri=referer"><img src= "http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0 Strict" height="31" width="88" /></a></p> </div> <!--Footer End--> <div style="font-size: 0.8em; text-align: center; margin-top: 1.0em; margin-bottom: 1.0em;"><a href="http://www.2asmooth.com/">2A Smooth Ltd</a> </div> </body> </html> selectNewsTest.js var xmlhttp; function showNews(str) { xmlhttp=GetXmlHttpObject(); if (xmlhttp==null) { alert ("Browser does not support HTTP Request"); return; } //the next couple of lines will add the information to the URL to be passed through so that the data can be retrieved. var url="getNews.php"; url=url+"?NewsID="+str; url=url+"&sid="+Math.random(); xmlhttp.onreadystatechange=stateChanged; xmlhttp.open("GET",url,true); xmlhttp.send(null); } function stateChanged() { if (xmlhttp.readyState==4) { //this will display the data that has been returned using the div element document.getElementById("txtHint").innerHTML=xmlhttp.responseText; //this will display the data that has been returned into the textbox //document.retrieveddetails.NewsID.value=xmlhttp.responseText; console.log(xmlhttp.responseText); var data = xmlhttp.responseText.split('||'); console.log(data); document.retrieveddetails.NewsID.value = data[0]; document.retrieveddetails.txtTitle.value = data[1]; document.retrieveddetails.txtDate.value = data[2]; document.retrieveddetails.txtContent.value = data[3]; //document.retrieveddetails.txtContent.value= data[3]; } } function GetXmlHttpObject() { if (window.XMLHttpRequest) { // code for IE7+, Firefox, Chrome, Opera, Safari return new XMLHttpRequest(); } if (window.ActiveXObject) { // code for IE6, IE5 return new ActiveXObject("Microsoft.XMLHTTP"); } return null; } getNewsTest.php <?php include "connection.php"; if (isset($_GET['NewsID'])) { $NewsID = mysql_real_escape_string($_GET['NewsID']); $query = "SELECT Title, `Date`, Content FROM News WHERE NewsID = $NewsID LIMIT 1"; if ($result = mysql_query($query)) { if (mysql_num_rows($result)) { $row = mysql_fetch_array($result); echo $row['NewsID'] . '||' . htmlentities($row['Title']) . '||' . htmlentities($row['Date']) . '||' . htmlentities($row['Content']); } } } ?> <?php /*include "connection.php"; $NewsID=$_GET['NewsID']; $query = "SELECT * FROM News WHERE NewsID = $NewsID"; $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); while ($row = @ mysql_fetch_array($result)) { $NewsID = $row['NewsID']; $Title = $row['Title']; $Date = $row['Date']; $Content = $row['Content']; $Link = $row['Link']; } echo $NewsID.'||'.htmlentities($Title).'||'.htmlentities($Date).'||'. htmlentities($Content); // close connection mysql_close($connection); */ ?> The only other explanation I can possibly think of is that somewhere, somehow it is cashing the page and not using the correct one?
-
I've tidied it up but still no luck. It is still coming up with the undefined error. Sorry to be a pain - I really do appreciate all the help you are giving me. You may not believe it but I am also learning quite a bit at the same time. Thanks again. Any other ideas?
-
as requested - my current getNewsTest.php <?php include "connection.php"; $NewsID=$_GET['NewsID']; $query = "SELECT * FROM News WHERE NewsID = $NewsID"; $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); while ($row = @ mysql_fetch_array($result)) { $NewsID = $row['NewsID']; $Title = $row['Title']; $Date = $row['Date']; $Content = $row['Content']; $Link = $row['Link']; } echo $NewsID.'||'.htmlentities($Title).'||'.htmlentities($Date).'||'. htmlentities($Content); // close connection mysql_close($connection); ?> Thing I have done what you mean there Is the below code what you meant about the html entities? echo $NewsID.'||'.htmlentities($Title).'||'.htmlentities($Date).'||'. htmlentities($Content);
-
I changed my php like how you suggested, the code currently looks like: echo $NewsID.'||'.$Title.'||'.$Date.'||'. $Content; and then: if (xmlhttp.readyState==4) { //this will display the data that has been returned using the div element document.getElementById("txtHint").innerHTML=xmlhttp.responseText; //this will display the data that has been returned into the textbox //document.retrieveddetails.NewsID.value=xmlhttp.responseText; console.log(xmlhttp.responseText); var data = xmlhttp.responseText.split('||'); console.log(data); document.retrieveddetails.NewsID.value = data[0]; document.retrieveddetails.txtTitle.value = data[1]; document.retrieveddetails.txtDate.value = data[2]; document.retrieveddetails.txtContent.value = data[3]; //document.retrieveddetails.txtContent.value= data[3]; } Yes there is HTML content within the content page.
-
The response is:
-
That is the response that I get when I click on one of the values from the drop down box and the returned data is just coming back with "undefined". I've attached a screenshot which should hopefully explain it. [attachment deleted by admin]
-
Tried that but it comes up with a response of "undefined".
-
Can you give me an example of how it should be done then if you can't echo comments out like that? I did what the original poster has done - copied it straight from the W3Schools website but it won't work for me. It looks like it is the closing tag like you say but I don't understand how to get around that. Thanks.
-
If I can get it done with one form then that is fine, I'm just not sure how to. I have tried looking through the tutorials on the W3Schools website and some work for me others don't. I can't get things to display using XML - just the Textproperty. I don't know enough on either AJAX or Javascript really but I am trying. Anybody know of any other good tutorials out there? Basically what I am trying to do is to select an option from a drop down menu - populate the other appropriate fields which can then be editted and finally saving off the editted version of the form. It seems near impossible to do. So far I can select the data and populate the form areas, but it populates the entire string rather than parts of it - this is where returning the data as xml would help but for some reason I can't get that to work either. Any help please....
-
I don't know. It is all in one string but I wouldn't know where to start in separating it. I'm hoping thats where thorpe can help lol. Im completely stuck
-
I think I need to work on my explanation skills lol. I've added a picture for help so I can show you what I mean. getNews.php <?php include "connection.php"; $NewsID=$_GET['NewsID']; $query = "SELECT * FROM News WHERE NewsID = $NewsID"; $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); while ($row = @ mysql_fetch_array($result)) { $NewsID = $row['NewsID']; $Title = $row['Title']; $Date = $row['Date']; $Content = $row['Content']; $Link = $row['Link']; } echo "News ID :". $NewsID; echo "Title :". $Title; echo "Date :". $Date; echo "Content :". $Content; // close connection mysql_close($connection); ?> So I can successfully retrieve all the data but I don't know then how to separate that data into different sections to put onto the different text boxes on the form - it merges into one long string.
-
It does but not in the right format - it sends everything back all in one line. So the NewsID, Title, Date and Content all do get pulled from the server but its like it is in one string rather than separately. I can't separate it so I cant then edit the news story. If I knew how to separate each section into its own and then display them individually into each text box I would have accomplished it. Does that make sense? Is there a way I could upload a screen shot of what I mean? [attachment deleted by admin]
-
I may well be overcomplicating things and for that im sorry - im new to all this. I just don't know how I can fix it. I've done the first two steps its the final step I can't get to work properly. I can edit the news but when it comes to submit it, it doesn't seem to be able to find which record it is supposed to be editting so it doesn't update the specific database record.
-
But you are doing that via ajax. yes but in order for me to do that via ajax i need to first send it to that page therefore I can't call the page itself because I am already telling it to do the AJAX stuff. I can either use the action to do the AJAX stuff by sending it to the selectNews.js page or I can call the page itself using the action. I can't do both. The only thing i can think of is to try and pass the variable into the ajax page, which i have already done and then somehow pass that back to the second form.
-
Why would the first page need to submit to the final processing page? When in reality you want to display another form in between. The process is simple. Form1 submits to Form2 Form2 submits to the final processing page. Because the first form needs to first select the record from the database using a drop down menu which gets the specific record to edit. It will then display that data in the second form but at the same time it needs to pass the variable of the specific record number to the second form which can then edit the data that has been pulled from the database and update it. Thats why I need two forms with two seperate locations, the first form can't just call itself because it needs to get all the record from the database and display it. Does that explanation make any more sense to you at all? Sorry if it sounds confusing. I have actually managed to pass the variable from the first form into the selectNews.js page which works fine but then I don't know how to retrieve that back onto the second php form in the editStory2.php page to then send across as part of the second action.
-
The first form will need to submit back to itself. it cant because i need to it submit to the page that it is already submitting to. Is there anyway in which i can get it to submit to two different locations at the same time?
-
so how can i get the data from one form passed to another on the same page so i can then pass it to another page? if that makes sense...
-
neither - there are two form that are in editStory2.php but each form has an action that directs them to different pages but i cant use the second form until the first has been completed.
-
alterNews.php <?php include "connection.php"; $NewsID = $_POST['NewsID']; echo "NewsID : ".$NewsID; // (2) gather all details from form $newTitle= $_POST['txtTitle']; $newDay = substr($_POST['txtDate'],0,2); $newMonth = substr($_POST['txtDate'],3,2); $newYear = substr($_POST['txtDate'],6,4); $newContent = $_POST['txtContent']; // (3) Create an UPDATE query of the form $query = "UPDATE News SET Title = '$newTitle', Date = '$newYear''$newMonth''$newDay', Content = '$newContent' WHERE NewsID = '$NewsID'"; // (4) Run query through connection $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); $title = 'Title'; $date = 'Date'; $content = 'Content'; ?> <?php // set server access variables include ("connection.php"); // create query $query = "SELECT * FROM News ORDER BY NewsID DESC"; // execute query $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); // see if any rows were returned if (mysql_num_rows($result) > 0) { // yes //Top of xml file $_xml = ""; $_xml = '<?xml version="1.0"?>'; $_xml .= '<rss version="2.0">'; $_xml .= '<channel>'; $_xml .= '<title>'.'Kingfisher Trust'.'</title>'; $_xml .= '<description>'.'The latest news about the charity'.'</description>'; $_xml .= '<link>'.'http://www.2asmooth.com/Kingfisher_Trust/news/updatedNewsFeed.xml'.'</link>'; while($row = mysql_fetch_array($result)) { $_xml .= '<item>'; $_xml .= '<title>'.$row['Title'].'</title>'; $_xml .= '<description>'.$row['Date'].'</description>'; $_xml .= '<link>'.$row['Link'].'</link>'; $_xml .= '</item>'; } $_xml .= '</channel>'; $_xml .= '</rss>'; //Output the xml string //print $_xml; // Could also write to a file at this point file_put_contents("news/updatedNewsFeed.xml", $_xml); // Need to give 'somedir' write permissions } else { // no // print status message echo "No rows found!"; } // (7) print message with ID of inserted record header("Location: newsReceipt.php?"."NewsID=".$NewsID); // ( close connection mysql_close($connection); ?> editStory2.php <?php session_start(); ?> <!-- Design by 2A Smooth Ltd http://www.2asmooth.com --> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta name="generator" content="HTML Tidy for Linux (vers 1 September 2005), see www.w3.org" /> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <title>The Kingfisher Trust</title> <meta name="keywords" content="Homeless, People, Bridlington, Kingfisher, Trust" /> <meta name="description" content="The Kingfisher Trust - Helping the Homeless" /> <link href="default.css" rel="stylesheet" type="text/css"/> <script src="calendar.js" type="text/javascript" language="javascript"></script> <style type="text/css" media="screen,projection"> @import url(calendar.css); </style> <script type="text/javascript" src="selectNews.js"></script> </head> <body> <!--Header Start--> <div id="header"> <div id="menu"> <ul> <li class="active"><a href="index.php" title="">Homepage</a></li> <li><a href="news.php" title="">News</a></li> <li><a href="about_us.php" title="">About Us</a></li> <li><a href="login.php" title="">Login</a></li> <li><a href="contact us.php" title="">Contact Us</a></li> </ul> </div> </div> <!--Header End--> <!--Content Start--> <div id="content"> <div id="sidebarleft"> <div id="linksleft" class="boxed"> <div class="title"> <h2>Latest News</h2> </div> <!--I will use this part of the page to do a dynamic link up to the database where it will display the latest news.--> <p> </p> <p>You can now register an account with us and also log in. To do so please <a href="login.php">login here</a> or <a href="registration.php">register here.</a></p> </div> </div> <div id="main"> <div class="post"> <h2 class="title"><span>Edit News Story</span></h2> <div class="intro"><img src="images/logo.jpg" alt="" width="120" height="120" class="left" /> <p>Please select which news story you wish to edit using the drop-down box below: <?php include "connection.php" ?> <?php //database connection $query = mysql_query("SELECT * FROM News ORDER BY NewsID DESC"); ?> <form action="getNews.php" method="POST"> <select name="News" onchange="showNews(this.value)"><option value="" "selected">Select News article to edit</option> <?php // loop through the records while ($row = mysql_fetch_array($query)) { echo "<option value=\"{$row['NewsID']}\">{$row['Title']}</option>"; } ?> </select> </form> </p> <div id="txtHint"><b>News story will appear here</b></div> <br /> <br /> <!-- OF COURSE YOU NEED TO ADAPT NEXT LINE TO YOUR tiny_mce.js PATH --> <script type="text/javascript" src="tinymce_3_2_7/tinymce/jscripts/tiny_mce/tiny_mce.js"></script> <script type="text/javascript"> tinyMCE.init({ theme : "advanced", //mode : "textareas", mode : "exact", elements : "txtHTMLContent", plugins : "fullpage", // Theme options theme_advanced_buttons1 : "save,newdocument,|,bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull,|,styleselect,formatselect,fontselect,fontsizeselect", theme_advanced_buttons2 : "cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,undo,redo,|,link,unlink,anchor,image,cleanup,help,code,|,forecolor,backcolor", theme_advanced_buttons3 : "hr,removeformat,visualaid,|,sub,sup,|,charmap,", theme_advanced_toolbar_align : "left", }); </script> <!-- OF COURSE YOU NEED TO ADAPT ACTION TO WHAT PAGE YOU WANT TO LOAD WHEN HITTING "SAVE" --> <form action="alterNews.php" method="POST" name="retrieveddetails"> <input type="hidden" name="NewsID" value="<?php $NewsID =$_POST['NewsID']; ?>" /> <?php echo $NewsID; ?> <p> Title: <input name="txtTitle" type="text" id="txtTitle"> </p> <p> Date: <input name="txtDate" type="text" id="txtDate" value="" class="calendarSelectDate" /> </p> <p> Content: <br /> <textarea name="txtContent" cols="50" rows="15" id="txtContent" ></textarea> HTML Content: <br /> <textarea name="txtHTMLContent" cols="50" rows="15" id="txtHTMLContent" ></textarea> <input type="submit" value="Save" /> </p> </form> </div> </div> </div> <div id="calendarDiv"></div> <div id="sidebarright"> <div id="linksright" class="boxed"> <div class="title"> <h2>Useful Links</h2> </div> <ul> <li><a href="http://www.shelter.org.uk">Shelter</a><br /> The UK's biggest homeless charity</li> <li><a href="http://www.eastriding.gov.uk/az/az_details_new?az_selected=599">Homeless form</a><br /> Complete this form for help and assistance from East Riding Council</li> <li><a href="http://homelessuk.org/">HomelessUK</a></li> </ul> <div id="sponsorlogo"><!--<img src="images/United logo.jpg" alt="united coop logo" />--></div> </div> </div> </div> <!--Content End--> <!--Footer Start--> <div id="footer"> <p id="legal">Copyright © 2009 Kingfisher Trust. All Rights Reserved. Designed by <a href="http://www.2asmooth.com/">2A Smooth Ltd</a>.</p> <p><a href="http://validator.w3.org/check?uri=referer"><img src= "http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0 Strict" height="31" width="88" /></a></p> </div> <!--Footer End--> <div style="font-size: 0.8em; text-align: center; margin-top: 1.0em; margin-bottom: 1.0em;"><a href="http://www.2asmooth.com/">2A Smooth Ltd</a> </div> </body> </html> selectNews.js var xmlhttp; function showNews(str) { xmlhttp=GetXmlHttpObject(); if (xmlhttp==null) { alert ("Browser does not support HTTP Request"); return; } //the next couple of lines will add the information to the URL to be passed through so that the data can be retrieved. var url="getNews.php"; url=url+"?NewsID="+str; url=url+"&sid="+Math.random(); xmlhttp.onreadystatechange=stateChanged; xmlhttp.open("GET",url,true); xmlhttp.send(null); } function stateChanged() { if (xmlhttp.readyState==4) { //this will display the data that has been returned using the div element document.getElementById("txtHint").innerHTML=xmlhttp.responseText; //this will display the data that has been returned into the textbox document.retrieveddetails.txtTitle.value=xmlhttp.responseText; document.retrieveddetails.txtDate.value=xmlhttp.responseText; document.retrieveddetails.txtContent.value=xmlhttp.responseText; } } function GetXmlHttpObject() { if (window.XMLHttpRequest) { // code for IE7+, Firefox, Chrome, Opera, Safari return new XMLHttpRequest(); } if (window.ActiveXObject) { // code for IE6, IE5 return new ActiveXObject("Microsoft.XMLHTTP"); } return null; } Don't know what else I can do. Thanks for all your help everyone. I owe the person who solves this issue many pints or other such tipple lol.