Jump to content

MsKazza

Members
  • Content Count

    76
  • Joined

  • Last visited

Community Reputation

0 Neutral

About MsKazza

  • Rank
    Regular Member

Profile Information

  • Gender
    Not Telling
  1. Hi, i'm recently had to add a new value to our product database called supplier_id, which gets called from the supplier table. Now when i'm trying to add a new product, it looks up the supplier name, but i'm not sure where/how to add the supplier_id so that it gets past to the POST, if someone could help me would much appreciate it. Please see attached file. Thanks, MsKazza <?php include('header.php'); ?> <style> table { width: 600px; } th { height: 50px; } td { height: 30px; vertical-align: middle; } </style> </head> <body> <?php include('navbar.php'); if (isset($_POST['submit'])) { $product_code = $_POST['product_code']; $product_name = $_POST['product_name']; $supplier_id = $_POST['supplier_id']; $supplier = $_POST['supplier']; $category = $_POST['category']; $sub_category = $_POST['sub_category']; $category2 = $_POST['category2']; $sub_category2 = $_POST['sub_category2']; $sql = "SELECT * FROM sub_categories WHERE id = '$sub_category'"; $subcat_result = $con->query($sql); while ($row=mysqli_fetch_array($subcat_result)) { $subcat_name = $row['subcat_name']; } $sub_category1 = preg_replace('/[^a-zA-Z0-9_.]/', '-', $subcat_name); $product_name1 = preg_replace('/[^a-zA-Z0-9_.]/', '-', $product_name); $slug = $sub_category1 . "/" . $product_name1; $slug = strtolower($slug); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } // Perform queries mysqli_query($con,"INSERT INTO products (product_code, slug, supplier_id, supplier, category, sub_category, category2, sub_category2,product_name) VALUES ('$product_code', '$slug', '$supplier_id', '$supplier', '$category', '$sub_category', '$category2', '$sub_category2', '$product_name')"); // Perform queries mysqli_query($con,"INSERT INTO images (product_code) VALUES ('$product_code')"); ?> <script> location.replace("products.php"); </script> <? mysqli_close($con); } else { ?> <script language="javascript" type="text/javascript"> function getXMLHTTP() { //fuction to return the xml http object var xmlhttp=false; try{ xmlhttp=new XMLHttpRequest(); } catch(e) { try{ xmlhttp= new ActiveXObject("Microsoft.XMLHTTP"); } catch(e){ try{ xmlhttp = new ActiveXObject("Msxml2.XMLHTTP"); } catch(e1){ xmlhttp=false; } } } return xmlhttp; } function getSubcat(categoryId) { var strURL="findsubcat.php?category="+categoryId; var req = getXMLHTTP(); if (req) { req.onreadystatechange = function() { if (req.readyState == 4) { // only if "OK" if (req.status == 200) { document.getElementById('subcatdiv').innerHTML=req.responseText; } else { alert("Problem while using XMLHTTP:\n" + req.statusText); } } } req.open("GET", strURL, true); req.send(null); } } </script> <form method="post" action="" name="addproduct"> <?php $sql = "SELECT * FROM categories ORDER BY cat_name ASC"; $result = $con->query($sql); ?> <div class="container-fluid text-center"> <div class="row content"> <div class="col-sm-12 text-left"> <br /> <h1>Add New Product</h1> <br /> <table> <tr><td>Product Code : </td><td><input type="text" name="product_code" ></td></tr> <tr><td>Product Name : </td><td><input type="text" name="product_name" size="50px"></td></tr> <tr><td><div class="form-group"> <label for="name">Supplier</label><a href="#" style="font-size:12px"> (Edit)</a></td> <td><label class="input-group p-custom-arrow"> <select id="supplier" name="supplier" value="<?php echo $product['supplier']; ?>" class="form-control"> <option class="p-select-default" value="">Select Supplier</option> <?php $sql=mysqli_query($con,"select * from supplier ORDER BY supplier_name ASC"); while($row=mysqli_fetch_array($sql)) { ?> <option value="<?php echo $row['folder']; ?>" <?php if ($product['supplier'] == $row['folder']) echo ' selected="selected"' ?>><?php echo $row['supplier_name']; ?></option> <?php } ?> </select> </label> </div><br /></td></tr><!-- End: form group --> <tr><td style="width:150px;"> Category : </span></td><td><select name="category" onChange="getSubcat(this.value)"> <option value="">Select Category</option> <?php while ($row=mysqli_fetch_array($result)) { ?> <option value=<?php echo $row['id']?>><?php echo $row['cat_name']?></option> <?php } ?> </select> </td></tr> <tr><td style="width:150px;">Sub Category : </span></td><td><div id="subcatdiv"><select name="sub_category" > <option>Select Subcategory</option> </select></div><br /> </td></tr> </table><br /> <input type="submit" value="submit" name="submit"> </form> </div> </div> </div> </div> <?php } ?> <?php include('footer.php'); ?> </body> </html> addproduct.php
  2. Hi there, I was trying to do a live table edit for our site. Everything seemed to be going ok, till i realised that its not actually updating the database, there are no error messages, you have to refresh the page to see it hasn't worked. I'm at a loss as to why was hoping someone might be able to point me in the right direction. thanks, MsKazza tableedit.php table_edit_ajax.php
  3. Can anyone please help me with this? thanks MsKazza
  4. Hi there, I have a page of products listed on a categories page, at the minute the mysql results are split into 3 columns, but when the page opens on a larger / high res screen there is a lot of space down the right hand side of the products. I was hoping someone might be able to help me so these move when necessary. I have pasted the categories page, if anything else is needed please let me know. Hope to hear from someone. thanks. MsKazza <?php session_start(); include('Connections/adlantic.php'); ?> <!doctype html> <html> <head> <style> /* Remove the navbar's default margin-bottom and rounded borders */ .pagination { background: #0066FF; border-radius: 15px; } .rest { font:Arial, Helvetica, sans-serif; color:#0066FF; float: left; padding: 8px 8px; text-decoration: none; border: 1px solid #ddd; margin: 0 4px; transition: background-color .3s; } .rest a { color:#0066FF; text-decoration:none; transition: background-color .3s; } /* Set height of the grid so .sidenav can be 100% (adjust as needed) */ .active { font:Arial, Helvetica, sans-serif; color:#ffffff; background:#0066FF; float: left; padding: 8px 8px; text-decoration: none; border: 1px solid #ddd; margin: 0 4px; } </style> <?php $recordID = $_GET["recordID"]; $result_category = mysqli_query($con, "SELECT products.*, categories.* FROM products INNER JOIN categories ON products.category=categories.id WHERE cat_name='$recordID' AND products.product_publish='1'"); $row_category = mysqli_fetch_assoc($result_category); $metatitle= $row_category['cat_name']; $metadesc=$row_category['cat_name']; $metakeywords=$row_category['cat_name'] . "business gifts, corporate gifts, promotional products, promotional items, promotional merchandise, promotional giveaways, advertising products, sales promotion, giveaways, exhibition, conference, environmentally friendly products, eco products, printed"; include('header.php'); ?> <meta http- equiv="content-type" content="text/html;charset=UTF-8"> <script src="js/lightbox-2.6.min.js"></script> <script type="text/javascript"> $(function() { //More Button $('.more').live("click",function() { var ID = $(this).attr("id"); if(ID) { $("#more"+ID).html('<img src="moreajax.gif" />'); $.ajax({ type: "POST", url: "ajax_more.php", data: "lastmsg="+ ID, cache: false, success: function(html){ $("ol#updates").append(html); $("#more"+ID).remove(); } }); } else { $(".morebox").html('The End'); } return false; }); }); </script> <link href="css/lightbox.css" rel="stylesheet" /> <br /> <div style="clear: both;"> <br /> <div class="content-area"> <div class="page-content"> <div class="product"> <div class="product-name">Categories</div> <div class="product-info" style="background:#E5E4E4; margins:auto;"> <br /> <table border=0 width="550px" align="center" cellpadding="5" cellspacing="5" bgcolor="#FFFFFF"><tr> <?php $result = mysqli_query($con, "SELECT * FROM sub_categories WHERE cat_name='$recordID' ORDER BY subcat_name ")or die($result. "<br/><br/>".mysql_error()); $count = 0; $max = 4; while($row = mysqli_fetch_assoc($result)) { if (['$result'] > 0){ $count++; echo '<td style="padding:5px;"><img src="eCommerceAssets/images/arrow.png"> <a href="sub_category.php?recordID='.$row['id'].'" class="topbar">'.$row['subcat_name'].'</a></td>'; if($count >= $max){ //reset counter $count = 0; //end and restart echo '</tr><tr>'; } } elseif ($result = 0) { echo 'There are no Subcategories available.'; } } ?> </tr></table> <?php $recordID = $_GET["recordID"]; // find out how many rows are in the table $query = mysqli_query($con, "SELECT COUNT(*) FROM products WHERE category='$recordID' AND product_publish='1'"); $r = mysqli_fetch_array($query); $numrows = $r[0]; // number of rows to show per page $rowsperpage = 18; // find out total pages $totalpages = ceil($numrows / $rowsperpage); // get the current page or set a default if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) { // cast var as int $currentpage = (int) $_GET['currentpage']; } else { // default page num $currentpage = 1; } // end if // if current page is greater than total pages... if ($currentpage > $totalpages) { // set current page to last page $currentpage = $totalpages; } // end if // if current page is less than first page... if ($currentpage < 1) { // set current page to first page $currentpage = 1; } // end if // the offset of the list, based on current page $offset = ($currentpage - 1) * $rowsperpage; // get the info from the db $query = "SELECT * FROM products INNER JOIN images ON products.product_code=images.product_code WHERE category=$recordID AND product_publish='1' ORDER BY product_id ASC LIMIT $offset, $rowsperpage"; $rs_result = mysqli_query($con, $query); $cat_name = $row_category['cat_name']; // always make sure you get a valid result!!! if($result == false) { die("Query failed: ".mysqli_error().PHP_EOL.$query); } echo "<br /><br />"; echo "<b>You are viewing page " . $currentpage . " of " . $totalpages . "</b><br />"; echo "We found " . $numrows . " products <br />"; ?> <?php if ($rs_result == NULL) { echo "There are no products to display in this category"; } else { ?> <br /><br /> <table align="center" border=0 width="550px" cellpadding="5" cellspacing="5"><tr> <?php $count1 = 0; $max1 = 3; while($row1 = mysqli_fetch_assoc($rs_result)) { $prod_name = $row1['product_name']; if(strlen($prod_name)>24){ $prod_name=substr($prod_name,0,24).' ...'; } if (['$rs_result'] > 0){ $count1++; echo '<td align="center" valign="top">'; echo '<table align="center" bgcolor="#ffffff" width="160"><tr><td height="5" align="center">'; echo '</td></tr><tr><td align="center">'; echo '<a href="product.php?name='; echo $row1['slug']; echo '" class="topbar">'; echo '<img src="eCommerceAssets/images/products/'; echo $row1['product_image_big1']; echo '" width="150" height="200">'; echo '</a>'; echo '</td></tr><tr><td align="center">'; echo '<strong><a href="product.php?name='; echo $row1['slug']; echo '" class="prod-name">'; echo $prod_name; echo '</a></strong><br />'; echo '<a href="product.php?name='; echo $row1['slug']; echo '" class="button">More Info</a><br />'; echo '</td></tr></table><br /><br />'; echo '</td>'; if($count1 >= $max1){ //reset counter $count1 = 0; //end and restart echo '</tr><tr>'; } } elseif ($rs_result = 0) { echo 'There are no products available.'; } } ?> </tr></table> <?php } // close while loop echo "<br />"; /****** build the pagination links ******/ // range of num links to show $range = 3; // if not on page 1, don't show back links if ($currentpage > 1) { // show << link to go back to page 1 echo "<span class='rest'> <a href='?recordID=$recordID&currentpage=1'><<</a> </span>"; // get previous page num $prevpage = $currentpage - 1; // show < link to go back to 1 page echo "<span class='rest'> <a href='?recordID=$recordID&currentpage=$prevpage'><</a></span> "; } // end if // loop to show links to range of pages around current page for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) { // if it's a valid page number... if (($x > 0) && ($x <= $totalpages)) { // if we're on current page... if ($x == $currentpage) { // 'highlight' it but don't make a link echo "<span class='active'> <b>$x</b> </span>"; // if not current page... } else { // make it a link echo "<span class='rest'><a href='?recordID=$recordID&currentpage=$x'>$x</a> </span>"; } // end else } // end if } // end for // if not on last page, show forward and last page links if ($currentpage != $totalpages) { // get next page $nextpage = $currentpage + 1; // echo forward link for next page echo "<span class='rest'> <a href='?recordID=$recordID&currentpage=$nextpage'>></a></span>"; // echo forward link for lastpage echo "<span class='rest'> <a href='?recordID=$recordID&currentpage=$totalpages'>>></a></span>"; } // end if /****** end build pagination links ******/ // close if ?> </div> </div> </div><!-- end of page-content --> <div class="left-side"> <?php include('menu.php'); ?> </div><!-- end of left side panel --> </div><!--end of content-area--> <br /> <div style="clear: both;"><br /> <?php include('footer.php'); ?> </div> <script src="js/cbpFWTabs.js"></script> <script> new CBPFWTabs( document.getElementById( 'tabs' ) ); </script> </body> </html>
  5. Thank you so much for your answers, I have been trying to create an update statement to save the info to db, however it doesn't update db. If anyone can tell me what i'm doing wrong i would very much appreciate it. It updates the text file no problem. foreach($arr[1] as $element) { // get the id number list($not_used,$id) = explode('_',$element); $str = "Status: $status, Id: $id"; file_put_contents('log.txt',print_r($str,true)."\n",FILE_APPEND); $query = mysql_query("UPDATE jobs SET status = " . $status . " WHERE id = " .$id ); } Thanks, MsKazza
  6. Thank you it is working, i have started using netbeans to help me debug. There was an extra character that was preventing the save_order from running. Thanks again. MsKazza
  7. Thank you so much for your reply. I have edited as per your suggestions. However it doesn't ever seem to post the data to the save_order.php, am I missing something or shouldn't there be some kind of onChange call?
  8. <? if ($vTakeout=='y') {?> <img src="takeoutyes.jpg"> <? } elseif ($vTakeout=='n') { ?> <img src="takeoutno.jpg"> <? } ?> I was missing ; from after the two images.
  9. Hi, I'm trying to figure out how to make a multi column jquery sortable Portlet, save the column positions to a database onChange, I know that sortable has a serialize function but i really haven't had any luck getting it to work. If someone could please help me out with this. I have spent hours on google trying to find something. <!doctype html> <?php include('connection.php'); ?> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>jQuery UI Sortable - Portlets</title> <link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css"> <link rel="stylesheet" href="/resources/demos/style.css"> <style> body { min-width: 520px; } .new { width: 300px; float: left; font-size:18px; color:#C95F0D; border:#636262 solid; text-align:center; vertical-align:middle; line-height:90px; } .clear { width: 300px; float: right; padding-bottom: 50px; font-size:18px; color:#7433D0; border:#636262 solid; margin-right:100px; } .star { width: 300px; float: right; padding-bottom: 50px; font-size:18px; color:#7433D0; border:#636262 solid; margin-right:100px; } .column { width: 170px; float: left; padding-bottom: 100px; } .portlet { margin: 0 1em 1em 0; padding: 0.3em; } .portlet-header { padding: 0.2em 0.3em; margin-bottom: 0.5em; position: relative; } .portlet-toggle { position: absolute; top: 50%; right: 0; margin-top: -8px; } .portlet-content { padding: 0.4em; } .portlet-placeholder { border: 1px dotted black; margin: 0 1em 1em 0; height: 50px; } </style> <script src="https://code.jquery.com/jquery-1.12.4.js"></script> <script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script> <script> $( function() { $( ".column" ).sortable({ connectWith: ".column", handle: ".portlet-header", cancel: ".portlet-toggle", placeholder: "portlet-placeholder ui-corner-all" }); $( ".portlet" ) .addClass( "ui-widget ui-widget-content ui-helper-clearfix ui-corner-all" ) .find( ".portlet-header" ) .addClass( "ui-widget-header ui-corner-all" ) .prepend( "<span class='ui-icon ui-icon-minusthick portlet-toggle'></span>"); $( ".portlet-toggle" ).on( "click", function() { var icon = $( this ); icon.toggleClass( "ui-icon-minusthick ui-icon-plusthick" ); icon.closest( ".portlet" ).find( ".portlet-content" ).toggle(); }); $("#portlet").sortable({ handle : '.handle', update : function () { var order = $('#portlet').sortable('serialize'); $("#portlet").load("save_order.php?"+order); } }); } ); </script> </head> <body> <div class="toolbar"><div class="new">Get New Jobs</div><div class="clear">Clear Job</div></div> <div style="clear:both;"></div> <div class="column" id="1"> <h3>New</h3> <?php $result = mysqli_query($con,"SELECT * FROM jobs WHERE status='1' ORDER BY job_title DESC"); while($row = mysqli_fetch_array($result)) { ?> <div class="portlet"> <div class="portlet-header"><?php echo $row['job_title']; ?></div> <div class="portlet-content"><a href="pdfs/<?php echo $row['pdf_link']; ?>" target="_blank">View PDF</a></div> </div> <?php } ?> </div> <div class="column" id="2"> <h3>Artwork Rec</h3> <?php $result = mysqli_query($con,"SELECT * FROM jobs WHERE status='2' ORDER BY job_title DESC"); while($row = mysqli_fetch_array($result)) { ?> <div class="portlet"> <div class="portlet-header"><?php echo $row['job_title']; ?></div> <div class="portlet-content"><a href="pdfs/<?php echo $row['pdf_link']; ?>" target="_blank">View PDF</a></div> </div> <?php } ?> </div> <div class="column" id="3"> <h3>Approved & Ordered</h3> <?php $result = mysqli_query($con,"SELECT * FROM jobs WHERE status='3' ORDER BY job_title DESC"); while($row = mysqli_fetch_array($result)) { ?> <div class="portlet"> <div class="portlet-header"><?php echo $row['job_title']; ?></div> <div class="portlet-content"><a href="pdfs/<?php echo $row['pdf_link']; ?>" target="_blank">View PDF</a></div> </div> <?php } ?> </div> <div class="column" id="4"> <h3>In Production</h3> <?php $result = mysqli_query($con,"SELECT * FROM jobs WHERE status='4' ORDER BY job_title DESC"); while($row = mysqli_fetch_array($result)) { ?> <div class="portlet"> <div class="portlet-header"><?php echo $row['job_title']; ?></div> <div class="portlet-content"><a href="pdfs/<?php echo $row['pdf_link']; ?>" target="_blank">View PDF</a></div> </div> <?php } ?> </div> <div class="column" id="5"> <h3>Delivered</h3> <?php $result = mysqli_query($con,"SELECT * FROM jobs WHERE status='5' ORDER BY job_title DESC"); while($row = mysqli_fetch_array($result)) { ?> <div class="portlet"> <div class="portlet-header"><?php echo $row['job_title']; ?></div> <div class="portlet-content"><a href="pdfs/<?php echo $row['pdf_link']; ?>" target="_blank">View PDF</a></div> </div> <?php } ?> </div> <div class="column" id="6"> <h3>To Be Invoiced</h3> <?php $result = mysqli_query($con,"SELECT * FROM jobs WHERE status='6' ORDER BY job_title DESC"); while($row = mysqli_fetch_array($result)) { ?> <div class="portlet"> <div class="portlet-header"><?php echo $row['job_title']; ?></div> <div class="portlet-content"><a href="pdfs/<?php echo $row['pdf_link']; ?>" target="_blank">View PDF</a></div> </div> <?php } ?> </div> </body> </html> And this is the save_order.php file. I am unsure how to write the update statement getting the column id etc from the previous page. <?php include('connection.php'); foreach ($_POST['status'] as $value) { // Database stuff } ?> All help much appreciated. Regards, MsKazza
  10. No thank you you have sent me in the right direction, I get it now. Once its updated can send message to page such as 'record updated' but the actual page will stay the same. Thanks very much for your help.
  11. Oh right, so whatever is typed into the form basically just stays there? Ajax just executes the update statement and leaves the page alone. So in theory i edit a product description, click submit, it executes the update, then i see an error correct it, submit again and again it executes the update while the page stays as I typed it. **lightbulb moment** I thought it was somehow refreshing the page without reloading. In that case If i'm adding something to a mysql table via a form and have the results displayed in a separate div, how is this updated to reflect the new information, do i somehow need to make the div reload? Thanks very much for the quick response.
  12. Hi, I have been reading up on ajax using jquery, and theres something I can't seem to find, i have a form that gets the field values from mysql when the page loads, what is the best way to use ajax to edit this form? Obv the ajax request will execute the mysql update statement but how do i get the edited data back into the form, ready to be worked with again. thanks, hope i made sense, just looking for a little direction. MsKazza
  13. Thank you for your reply, i don't want them to be echo'd on a loop, i want to keep them in their own rows, so if there is no number 3, that row will become the text box, and a new number 3 will be chosen. I was hoping someone could please help me get this to work properly displaying the rows 1 through 6 or displaying the textbox if associated number doesn't exist. thanks
  14. Hi there, I was hoping someone could provide an insight as to why this is not working, it is not listing the products in the order they should be, but it is still listing all 6, just random. any help much appreciated. I would image there is a much easier way to do this i just don't know it. <?php $result_product = mysqli_query($con,"SELECT * FROM products WHERE NOT specials='0' AND product_publish='y'"); ?> <form id="specials" name="specials" action="" method="post"> <table > <?php while($row_product1 = mysqli_fetch_assoc($result_product)){ if ($row_product1['specials'] = 1) { echo "<tr><td>"; echo $row_product1['product_code']; echo "</td><td>"; echo $row_product1['product_name']; echo "</td><td><span class=\"glyphicon glyphicon-trash\"></td></tr>"; } else { echo "<tr><td><input type=\"text\" id=\"speical1code\"></td><td>add special</td></tr>"; } }?> <?php while($row_product2 = mysqli_fetch_array($result_product)){ if ($row_product2['specials'] = 2) { echo "<tr><td>"; echo $row_product2['product_code']; echo "</td><td>"; echo $row_product2['product_name']; echo "</td><td><span class=\"glyphicon glyphicon-trash\"></td></tr>"; } else { echo "<tr><td><input type=\"text\" id=\"speical1code\"></td><td>add special</td></tr>"; } }?> <?php while($row_product3 = mysqli_fetch_array($result_product)) { if ($row_product3['specials'] = 3) { echo "<tr><td>"; echo $row_product3['product_code']; echo "</td><td>"; echo $row_product3['product_name']; echo "</td><td><span class=\"glyphicon glyphicon-trash\"></td></tr>"; } else { echo "<tr><td><input type=\"text\" id=\"speical1code\"></td><td>add special</td></tr>"; } }?> <?php while($row_product4 = mysqli_fetch_array($result_product)) { if ($row_product4['specials'] = 4) { echo "<tr><td>"; echo $row_product4['product_code']; echo "</td><td>"; echo $row_product4['product_name']; echo "</td><td><span class=\"glyphicon glyphicon-trash\"></td></tr>"; } else { echo "<tr><td><input type=\"text\" id=\"speical1code\"></td><td>add special</td></tr>"; } }?> <?php while($row_product5 = mysqli_fetch_array($result_product)) { if ($row_product5['specials'] = 5) { echo "<tr><td>"; echo $row_product5['product_code']; echo "</td><td>"; echo $row_product5['product_name']; echo "</td><td><span class=\"glyphicon glyphicon-trash\"></td></tr>"; } else { echo "<tr><td><input type=\"text\" id=\"speical1code\"></td><td>add special</td></tr>"; } }?> <?php while($row_product6 = mysqli_fetch_array($result_product)) { if ($row_product6['specials'] = "9") { echo "<tr><td>"; echo $row_product6['product_code']; echo "</td><td>"; echo $row_product6['product_name']; echo "</td><td><span class=\"glyphicon glyphicon-trash\"></td></tr>"; } else { echo "<tr><td><input type=\"text\" id=\"speical1code\"></td><td>add special</td></tr>"; } }?> </table> </form>
  15. Thank you for your reply. I have figured it out it wasn't picking up the news_id properly on post. But thank you for your suggestion on the PDO i will look into it. thanks
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.