| | |
Hidden Link - Please help.
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Sep 2008
Posts: 6
Reputation:
Solved Threads: 0
Please help checking the following code. It may look too mess. It's from other programmer. I try to fix it but I start to get headache now. It's make our product's page showing 3 hidden links of its own products' link on Google.
For example: The page of http://www.mywebsite.com/product-name-1.html, currently showing 3 hidden links of http://www.mywebsite.com/product-name-1.html on Google.
Thank you very much for your help.
For example: The page of http://www.mywebsite.com/product-name-1.html, currently showing 3 hidden links of http://www.mywebsite.com/product-name-1.html on Google.
PHP Syntax (Toggle Plain Text)
<?php /* $Id: product_info.php,v 1.97 2003/07/01 14:34:54 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ //header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); //header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); //header("Cache-Control: no-store, no-cache, must-revalidate"); //header("Cache-Control: post-check=0, pre-check=0", false); header("Pragma: no-cache"); $info = 1; require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO); //################## Added Enable / Disable Categories #################" // $product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); //################## End Added Enable / Disable Categories ################# $product_check = tep_db_fetch_array($product_check_query); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <TITLE><?php echo $titletag; ?></TITLE> <META HTTP-EQUIV="PRAGMA" CONTENT="NO-CACHE"> <META NAME="Keywords" content="<?php echo $keywordtag; ?>"> <META NAME="Description" content="<?php echo $description; ?>"> <META NAME="Robots" content="INDEX, FOLLOW"> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <script language="JavaScript" type="text/javascript"> <!-- window.status="Shopping Cart Contents / <?php echo $cart->count_contents(); ?> Items In Basket / Current Total = <?php echo 'L'.$cart->show_total(); ?> (+ GST) " // --> </script> <script type="text/javascript" src="jquery-1.2.2.pack.js"></script> <script type="text/javascript" src="stepcarousel.js"></script> <link rel="stylesheet" type="text/css" href="stylesheet.css"> <link rel="shortcut icon" href="http://www.1staudiovisual.co.uk/images/favicon.ico"> <script language="javascript"><!-- function popupWindow(url) { window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=yes,copyhistory=no,width=400,height=400,screenX=150,screenY=150,top=150,left=150') } function popup(mylink, windowname) { if (! window.focus)return true; var href; if (typeof(mylink) == 'string') href=mylink; else href=mylink.href; window.open(href, windowname, 'width=400,height=400,scrollbars=yes'); return false;} function popupWindow(url) { window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=yes,copyhistory=no,width=400,height=400,screenX=150,screenY=150,top=150,left=150') } function popupPricematch(url) { window.open(url,'popupPricematch','toolbar=no,status=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,copyhistory=no,width=400,height=400,screenX=10,screenY=150,top=10,left=150') } //--></script> <!-- Bundle Query Start --> <script language="javascript"> var xmlHttp function showBundle(bundle_id,p_set,pageElement,callMessage,customer_id,product_id,product_type) { document.getElementById(pageElement).innerHTML = callMessage; xmlHttp=GetXmlHttpObject(); if (xmlHttp==null) { alert ("Your browser does not support AJAX!"); return; } var url="getbundle.php"; url=url+"?bundle_id="+bundle_id; url=url+"&p_set="+p_set; url=url+"&customer_id="+customer_id; url=url+"&product_id="+product_id; url=url+"&product_type="+product_type; xmlHttp.onreadystatechange=stateChanged; xmlHttp.open("GET",url,true); xmlHttp.send(null); } function stateChanged() { if (xmlHttp.readyState==4) { document.getElementById("bundle_offer").innerHTML=xmlHttp.responseText; } } function GetXmlHttpObject() { var xmlHttp=null; try { // Firefox, Opera 8.0+, Safari xmlHttp=new XMLHttpRequest(); } catch (e) { // Internet Explorer try { xmlHttp=new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { xmlHttp=new ActiveXObject("Microsoft.XMLHTTP"); } } return xmlHttp; } </script> <!-- Bundle Query End --> <!-- --> <script language="javascript"> var xmlHttp3 function showShopCart(pageElement,callMessage,customer_id) { document.getElementById(pageElement).innerHTML = callMessage; xmlHttp3=GetXmlHttpObject3(); if (xmlHttp3==null) { alert ("Your browser does not support AJAX!"); return; } //alert (customer_id); var url5="item_box2.php"; url5=url5+"?customer_id="+customer_id; //alert (url5); xmlHttp3.onreadystatechange=stateChanged3; xmlHttp3.open("GET",url5,true); xmlHttp3.send(null); } function stateChanged3() { if (xmlHttp3.readyState==4) { document.getElementById("item_box").innerHTML=xmlHttp3.responseText; } } function GetXmlHttpObject3() { var xmlHttp3=null; try { // Firefox, Opera 8.0+, Safari xmlHttp3=new XMLHttpRequest(); } catch (e) { // Internet Explorer try { xmlHttp3=new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { xmlHttp3=new ActiveXObject("Microsoft.XMLHTTP"); } } return xmlHttp3; } </script> <!-- --> <!-- Bundle Query Start --> <script language="javascript"> var xmlHttp2 function UpdateBundle(pageElement,callMessage) { document.getElementById(pageElement).innerHTML = callMessage; xmlHttp2=GetXmlHttpObject2(); if (xmlHttp2==null) { alert ("Your browser does not support AJAX!"); return; } alert("Get Product Id"); for( i = 0; i < bundle_set.add_recommended.length; i++ ){ if( bundle_set["add_recommended"][i].checked ) val = bundle_set["add_recommended"][i].value; } //alert( "val = " + val ); var url2="ajax/updatebundle.php"; url2 = url2+"?p_id=".val xmlHttp2.onreadystatechange=stateChanged2; xmlHttp2.open("GET",url2,true); xmlHttp2.send(null); } function stateChanged2() { if (xmlHttp2.readyState==4) { document.getElementById("bundle_offer").innerHTML=xmlHttp2.responseText; } } function GetXmlHttpObject2() { var xmlHttp2=null; try { // Firefox, Opera 8.0+, Safari xmlHttp2=new XMLHttpRequest(); } catch (e) { // Internet Explorer try { xmlHttp2=new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { xmlHttp2=new ActiveXObject("Microsoft.XMLHTTP"); } } return xmlHttp2; } var http_request = false; function makeRequest(url, parameters) { http_request = false; if (window.XMLHttpRequest) { // Mozilla, Safari,... http_request = new XMLHttpRequest(); if (http_request.overrideMimeType) { // set type accordingly to anticipated content type //http_request.overrideMimeType('text/xml'); http_request.overrideMimeType('text/html'); } } else if (window.ActiveXObject) { // IE try { http_request = new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { try { http_request = new ActiveXObject("Microsoft.XMLHTTP"); } catch (e) {} } } if (!http_request) { alert('Cannot create XMLHTTP instance'); return false; } http_request.onreadystatechange = alertContents; http_request.open('GET', url + parameters, true); http_request.send(null); } function alertContents() { if (http_request.readyState == 4) { if (http_request.status == 200) { //alert(http_request.responseText); result = http_request.responseText; document.getElementById('bundle_offer').innerHTML = result; } else { alert('There was a problem with the request.'); } } } function get(obj,customer_id,bundle_id,p_set,product_id,product_name) { var getstr = "?"; for (i=0; i<obj.childNodes.length; i++) { if (obj.childNodes[i].tagName == "INPUT") { if (obj.childNodes[i].type == "hidden") { getstr += obj.childNodes[i].name + "=" + obj.childNodes[i].value + "&"; } } } getstr += "customer_id=" +customer_id; //alert(getstr); makeRequest('updatebundle.php', getstr); //alert('update'); document.getElementById('des_bun').innerHTML = "You have added "+product_name+" to cart."; document.getElementById('bundle_offer').innerHTML = '<center><img src=images/loading.gif></center>'; document.getElementById('item_box').innerHTML = '<center><img src=images/loading.gif></center>'; showBundle(bundle_id,p_set,'bundle_offer','<center><img src=images/loading.gif></center>',customer_id,product_id); //window.setTimeout("showBundle("+bundle_id+","+p_set+",'bundle_offer','<center><img src=images/loading.gif></center>',"+customer_id+","+product_id+")",1000); //window.setTimeout("showShopCart('item_box','<center><img src=images/loading.gif></center>',"+customer_id+")",3000); showShopCart('item_box','<center><img src=images/loading.gif></center>',customer_id); } </script> <!-- Bundle Query End --> <!-- Add Cart Start --> <script language="javascript"> var xmlHttp4 function add_cart(product_id,customer_id) { //document.getElementById(pageElement).innerHTML = callMessage; xmlHttp4=GetXmlHttpObject4(); if (xmlHttp4==null) { alert ("Your browser does not support AJAX!"); return; } var url_addcart="add_cart.php"; url_addcart=url_addcart+"?product_id="+product_id+"&customer_id="+customer_id; xmlHttp4.onreadystatechange=stateChanged4; xmlHttp4.open("GET",url_addcart,true); xmlHttp4.send(null); } function stateChanged4() { if (xmlHttp4.readyState==4) { document.getElementById("item_box").innerHTML=xmlHttp4.responseText; } } function GetXmlHttpObject4() { var xmlHttp4=null; try { // Firefox, Opera 8.0+, Safari xmlHttp4=new XMLHttpRequest(); } catch (e) { // Internet Explorer try { xmlHttp4=new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { xmlHttp4=new ActiveXObject("Microsoft.XMLHTTP"); } } return xmlHttp4; } </script> <!-- Add Cart End --> <script type="text/javascript"> function hidediv(divId,divId2,divId3,divId4,divId5,divId6,divId7,divId8){ var arr = document.getElementById(divId) if ( arr!= null ) { arr.style.display = (arr.style.display == 'none')? 'block':'none'; } var arr2 = document.getElementById(divId2) if ( arr2!= null ) { arr2.style.display = (arr2.style.display == 'none')? 'block':'none'; } var arr3 = document.getElementById(divId3) if ( arr3!= null ) { arr3.style.display = (arr3.style.display == 'none')? 'block':'none'; } var arr4 = document.getElementById(divId4) if ( arr4!= null ) { arr4.style.display = (arr4.style.display == 'none')? 'block':'none'; } var arr5 = document.getElementById(divId5) if ( arr5!= null ) { arr5.style.display = (arr5.style.display == 'none')? 'block':'none'; } var arr6 = document.getElementById(divId6) if ( arr6!= null ) { arr6.style.display = (arr6.style.display == 'none')? 'block':'none'; } var arr7 = document.getElementById(divId7) if ( arr7!= null ) { arr7.style.display = (arr7.style.display == 'none')? 'block':'none'; } var arr8 = document.getElementById(divId8) if ( arr8!= null ) { arr8.style.display = (arr8.style.display == 'none')? 'block':'none'; } } function actionstep(divId){ var arr = document.getElementById(divId) if ( arr!= null ) { arr.style.display = (arr.style.display == 'none')? 'block':'block'; } } function warranty(id){ var pro_id = document.getElementById(id).value; document.getElementById("newvalue").value = pro_id; } </script> <!-- This script requires PROTOTYPE AND SCRIPTACULOUS. Please alter the following import statements if you have the scripts installed in a different directory. --> <script type="text/javascript" src="javascript/prototype.js"></script> <script type="text/javascript" src="javascript/scriptaculous.js"></script> <script type="text/javascript" language="javascript"> //<!-- /* escapeOverlay's construction is a bit hard to grasp. It is needed to be able to stop the event listener. See the prototype API docs for more information: http://www.prototypejs.org/api/event */ var escapeOverlay = { fx: function(e) { // To make script compatable with both MSIE and Firefox var kC = (window.event) ? event.keyCode : e.keyCode; var Esc = (window.event) ? 27 : e.DOM_VK_ESCAPE; // If keypressed is escape and the new entry field is empty if(kC==Esc && ($F('newvalue') == '' || $F('newvalue') == null) ) closeDialogue(); else if(kC==Esc && window.confirm('Are you sure you wish to close the dialogue box?') ) closeDialogue(); } } // Save in cache (to be able to stopObserving() it), see Prototype API docs for more info: // http://www.prototypejs.org/api/event escapeOverlay.bfx = escapeOverlay.fx.bindAsEventListener(escapeOverlay); // loadPopup shows the overlay and dialogue box function loadPopup(ch) { // Show the overlay (disables rest of page) showOverlay(); // Show dialogue and focus on newvalue if(ch=="cart_button") { $('dialogue').show(); } if(ch=="bundle") { $('dialogue_bundle').show(); } } // Shows the overlay and starts the ESCAPE event listener function showOverlay() { $('overlay').show(); //document.body.scroll="no"; Event.observe(document, 'keypress', escapeOverlay.bfx ); } // Hides the overlay and stops the ESCAPE event listener function hideOverlay() { $('overlay').hide(); //document.body.scroll="yes"; Event.stopObserving(document, 'keypress', escapeOverlay.bfx ); } // Closes the dialogue box, resets it and hides the overlay function closeDialogue() { hideOverlay(); // Hide dialogue $('dialogue').hide(); $('dialogue_bundle').hide(); // Clear dialogue $('newvalue').value = ''; } /* Event handler for onKeyPress for the newvalue field. Enables the use of the ENTER (RETURN) key when adding a new entry in the dialogue box */ function enterKey(event, field) { // If the event key pressed was a return (code 13) if (event.which == 13 || event.keyCode == 13) addEntry(field.value); } // count is used to number the entries LI IDs var count = 1; // Adds an entry function addEntry(message,type,warranty) { // Close the dialogue if(type=='continue') { closeDialogue(); } if(type=='continue_bun' || warranty=='no_warranty') { closeDialogue(); } // If the value entered for the new entry is not empty if (message != '' && message != null) { closeDialogue(); // Build a new LI, set its value and id and add it //newLI= Builder.node('li', {id: count}); //newLI.innerHTML = message; //count++; if(message!='free') { //add_cart(message); //showShopCart('item_box','<center><img src=images/loading.gif></center>'); document.getElementById("item_box").value=add_cart(message); } //alert(message); if(type=='checkout') { var url="<?=tep_href_link("shopping_cart.php");?>"; window.location.href=url; } // Append the new LI to the entries UL //$('entries').appendChild(newLI); } if(type=='checkout_bun') { closeDialogue(); var url="<?=tep_href_link("shopping_cart.php");?>"; window.location.href=url; } if(type=='checkout' && (warranty=='no_warranty' || warranty=='warranty')) { closeDialogue(); var url="<?=tep_href_link("shopping_cart.php");?>"; window.location.href=url; } } //--> </script> <style type="text/css"> #overlay { position: absolute; left: 0px; top: 0px; width: 100%; height: 180%; background:#000 url(images/overlay1.gif); /* Set both opacity and filter, for MSIE and firefox compatability */ opacity: .7; filter: alpha(opacity=70); /* z-index sets the layer order, so that the overlay rests on top. Bear in mind that the popup dialogue needs to be even higher! */ z-index: 1000; } #dialogue { position: absolute; left: 50%; margin-left: -250px; top: 30%; width: 450px; /*padding: 20px; border: 0px solid #c4d8df;*/ background-color: #FFFFFF; z-index: 2000; } #dialogue_bundle { position: absolute; left: 50%; margin-left: -250px; top: 60%; width: 450px; /*padding: 20px; border: 0px solid #c4d8df;*/ background-color: #FFFFFF; z-index: 2000; } /* set millions of background images */ .t {background: url(images/dot.gif) 0 0 repeat-x; width: 100%} .b {background: url(images/dot.gif) 0 100% repeat-x} .l {background: url(images/dot.gif) 0 0 repeat-y} .r {background: url(images/dot.gif) 100% 0 repeat-y} .bl {background: url(images/bl.gif) 0 100% no-repeat} .br {background: url(images/br.gif) 100% 100% no-repeat} .tl {background: url(images/tl2.gif) 0 0 no-repeat} .tr {background: url(images/tr.gif) 100% 0 no-repeat; padding:10px} </style> <!-- Gray POP UP End --> <link rel="stylesheet" type="text/css" href="tabcontent2.css" /> <script type="text/javascript" src="tabcontent.js"></script> </head> <? $id = $_SESSION['customer_id'];?> <body id="body" marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" onLoad="javascript:showShopCart('item_box','<center><img src=images/loading.gif></center>','<?=$id;?>');"> <div id="overlay" style="display:none;"></div> <table width="1000" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td colspan="3"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--></td> </tr> <tr style="padding-top:5px;"> <td valign="top" width="150"> <table border="0" width="150" cellspacing="0" cellpadding="2"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left_products.php'); ?> <!-- left_navigation_eof //--> </table> </td> <td width="77%" valign="top"> <?php echo tep_draw_form('cart_quantity', tep_href_link('product_info.php', tep_get_all_get_params(array('action')) . 'action=add_products')); ?> <input name="customer_id" type="hidden" value="<?= $_SESSION['customer_id']; ?>" /> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <?php if ($product_check['total'] < 1) { ?> <tr> <td colspan="3"><?php new infoBox(array(array('text' => TEXT_PRODUCT_NOT_FOUND))); ?></td> </tr> <tr> <td colspan="3"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td colspan="3"><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> </table></td> </tr> </table></td> </tr> <?php } else { $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, pd.products_short_description, pd.products_spec, pd.products_musthave, pd.products_extraimage, pd.products_manual, pd.products_extra1, pd.products_moreinfo, p.products_pdf, p.products_pdf_name, p.products_description_image, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_start_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, p.products_nostock, p.products_stockdate, p.products_instock from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_info = tep_db_fetch_array($product_info_query); tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'"); //print_r($product_info); $GST = 17.5; $products_price1 = $product_info['products_price'] + ($GST*($product_info['products_price']/100)); $products_price = '<b>£' . number_format($products_price1, 2, '.', '') .'</b>' ; $products_price_start = $product_info['products_start_price']; ?> <tr> <td width="31%" valign="top"> <table border="0"><tr><td> <?php //echo '<div><h1>'.$product_info['products_name'].'</h1></div>'; echo tep_image(DIR_WS_IMAGES . $product_info['products_image'],$product_info['products_image'], 250, 250, 'hspace="0" vspace="0"'); ?> <? include('includes/modules/product_tab_query.php'); ?> </td></tr></table> </td> <td width="21%" valign="top"><table border="0"> <tr> <td><?php $pro_info = explode(" ", $product_info['products_name'],3); echo '<table border="0" cellspacing="0" cellpadding="3"><tr><td><h1>'.$pro_info[0].'<br>'.$pro_info[1].'</h1></td></tr></table>'; echo '<table border="0" cellspacing="0" cellpadding="3"><tr><td><h2><span style="font-size:12px;color:#5c96d6;"><b>'.$pro_info[2].'</b></span></h2></td></tr>'; echo '<tr><td><h2><font style="font-size:12px;">['.$pro_info[1].']</font></h2></td></tr></table>'; ?> </td> </tr> <tr> <td nowrap="nowrap" class="main"> <table><tr><td> <?php if (($product_info['products_start_price']*1)>0 && $product_info['products_start_price'] > $products_price1){ echo "<font color='red' class='main' style='font-weight:bold;font-size:14px;'>"; echo "WAS : <s>£".$products_price_start."</s><br>"; echo "</font>"; echo '<font color="#008000" class="main" style="font-weight:bold;font-size:14px;">'; echo "NOW : ".$products_price; echo "</font><br>"; $save = ((( number_format($products_price_start, 2, '.', '')-number_format($products_price1, 2, '.', ''))/number_format($products_price1, 2, '.', '')))*100; echo "<font color='#5c96d6' class='main' style='font-weight:bold;font-size:14px;'>"; echo "SAVE : ".number_format($save, 0, '', '')."%"; echo "</font><br/>"; } else{ echo "<font color='red' class='main' style='font-weight:bold;font-size:14px;'>"; echo "WAS : <s>£"; $products_price_start= number_format($products_price1* 1.2, 2, '.', '') ; echo $products_price_start."</s><br>"; echo "</font>"; echo '<font color="#008000" class="main" style="font-weight:bold;font-size:14px;">'; echo "NOW : ".$products_price; echo "</font><br>"; echo "<font color='#5c96d6' class='main' style='font-weight:bold;font-size:14px;'>"; echo "SAVE : 20%"; echo "</font><br/>"; } ?> </td></tr></table> </td> </tr> <tr> <td> <table><tr><td> <? //Query stock status $stock_query = tep_db_query("select products_stock from products where products_id = '".(int) $products_id."'"); $stock_status_result = tep_db_fetch_array($stock_query); //$stock_status = ''; if($stock_status_result['products_stock'] == '1'){ echo '<div align="left">'.tep_image('images/instock.gif', 'In Stock','113','31').'<br> <span class="smallText">Available for Next Business Day.</span> </div>'; }else if($stock_status_result['products_stock'] == '3'){ // Query stock date $stockdate_query = tep_db_query("select products_stockdate from products where products_id = '".(int) $products_id."'"); $stockdate_result = tep_db_fetch_array($stockdate_query); if($stockdate_result['products_stockdate'] != ''){ $stockdate = $stockdate_result['products_stockdate']; }else{ $stockdate = date('F j, Y'); } echo '<div align="left">'.tep_image('images/due_stock.gif', 'Due in Stock','113','31').'<br> <span class="smallText"><font color="#FF0000"><b>'.$stockdate.'</b></font><br> Preorder now to reserve stock </span> </div>'; }else{ ?> <div> <!-- BEGIN PHP Live! code, (c) OSI Codes Inc. --> <script language="JavaScript" src="http://www.1staudiovisual.co.uk/catalog/phplive/js/status_image.php?base_url=http://www.1staudiovisual.co.uk/catalog/phplive&l=1staudiovisual&x=1&deptid=10&"></script> <!-- END PHP Live! code : (c) OSI Codes Inc. --> </div> <? } ?> </td></tr></table> </td> </tr> <tr> <td align="left"> <table><tr><td> <!-- These DIVs are the popups and overlay. Leave these here. --> <div id="dialogue" style="display: none;"> <!--div id="close"><a href="javascript: void(0);" onClick="closeDialogue()">X</a></div--> <? include('includes/modules/warranty.php'); ?> <!-- New entry value: <input type="text" name="newvalue" id="newvalue" onKeyPress="enterKey(event, this)"> <input type="button" onClick="addEntry($F('newvalue'));" value="Add"> !--> </div> <div> <?php if($id=='') { $id=0; } echo '<a href="javascript:void(0);" onclick="javascript:loadPopup(\'cart_button\')">'. tep_image('includes/languages/english/images/buttons/cart_button.gif', IMAGE_BUTTON_IN_CART,'','','onclick="javascript:actionstep(\'warranty\');actionstep(\'ready_to_cart\');javascript:add_cart('.$HTTP_GET_VARS['products_id'].','.$id.');"').'</a>'; ?> </div> </td></tr></table> </td> </tr> </table></td> <td width="41%" rowspan="2" valign="top"> <? include('includes/modules/specifications.php'); ?> <table cellpadding="0" width="100%"> <tr><td> <div id="dialogue_bundle" style="display: none;"> <table width="500" border="0" cellspacing="0" cellpadding="0" align="left"> <tr> <td valign="bottom" class="main"><img src="images/top_left.gif" width="13" height="15" /></td> <td valign="bottom" class="main" style="background-image:url(images/top1.gif)"> </td> <td valign="bottom" class="main"><img src="images/top_right.gif" width="14" height="15" /></td> </tr> <tr> <td class="main" style="background-image:url(images/left2.gif)"> </td> <td class="main" align="center"> <table width="460" border="0" cellpadding="0" cellspacing="0"> <tr bgcolor="#ffffff"> <td bgcolor="#ffffff" class="main" style="font-size:10px" colspan="2" align="center"><div id="des_bun"></div></td> </tr> </table> <br/> <table width="450" border="0" cellpadding="0" cellspacing="0" align="center"> <tr bgcolor="#ffffff" align="center"> <td><? echo tep_image("includes/languages/english/images/buttons/button_continue_shopping.gif", 'Continue Shopping','','','onClick="addEntry($F(\'newvalue\'),\'continue_bun\');"');?></td> <td><? echo tep_image("includes/languages/english/images/buttons/button_checkout.gif", 'Checkout','','','onClick="addEntry($F(\'newvalue\'),\'checkout_bun\');"');?></td> </tr> </table> <td width="14" class="main" style="background-image:url(images/right2.gif)"> </td> </tr> <tr> <td width="13" valign="top" class="main"><img src="images/bottom_left.gif" width="13" height="15" /></td> <td class="main" style="background-image:url(images/bottom2.gif)"> </td> <td width="14" valign="top" class="main"><img src="images/bottom_right.gif" width="14" height="15" /></td> </tr> </table> </div> <div id="product_bundle"> <?php include('product_bundle.php');?> </div> </td></tr> </table></td> </tr> <? /////////////////////////////////////////////////////////////////////////////////////// $categories_query = tep_db_query("SELECT categories.categories_id, categories.parent_id FROM products_to_categories Inner Join categories ON categories.categories_id = products_to_categories.categories_id WHERE products_to_categories.products_id = '".(int)$HTTP_GET_VARS['products_id']."'"); $categories_info = tep_db_fetch_array($categories_query); $cid=$categories_info['categories_id']; $c_pid=$categories_info['parent_id']; ?> <tr> <!-- start tab --> <td colspan="2"> <table width="99%"><tr><td> <div id="tab"> <ul id="maintab" class="shadetabs"> <? if(($c_pid=='52' or $c_pid=='135' or $c_pid=='136' or $c_pid=='22' or $c_pid=='121' or $c_pid=='129' or $c_pid=='23' or $cid=='207' or $c_pid=='73' or $cid=='111' or $cid=='106') and $products_price1>=400) { ?> <li class="selected"><a href="#" rel="tcontent1" id="v12"> </a></li> <? }?> <li <? if( !( ($c_pid=='52' or $c_pid=='135' or $c_pid=='136' or $c_pid=='22' or $c_pid=='121' or $c_pid=='129' or $c_pid=='23' or $cid=='207' or $c_pid=='73' or $cid=='111' or $cid=='106') and $products_price1>=400) ) echo 'class="selected"'; ?> ><a href="#" rel="tcontent2" id="delivery"> </a></li> <? if($bracket_set==1 or $bracket_set==2 or $bracket_set==3 or $bracket_set==4) { ?> <li><a href="#" rel="tcontent3" id="install"> </a></li> <? } ?> </ul> </div> <div class="tabcontentstyle"> <? if(($c_pid=='52' or $c_pid=='135' or $c_pid=='136' or $c_pid=='22' or $c_pid=='121' or $c_pid=='129' or $c_pid=='23' or $cid=='207' or $c_pid=='73' or $cid=='111' or $cid=='106') and $products_price1>=400) { ?> <div id="tcontent1" class="tabcontent"> <?php // work out percentages and display $vat = 17.5; $start_price = $product_info['products_price'] + ($vat*($product_info['products_price']/100)); $percentage_start = $start_price; //Able2Buy Calculate $factor_forty =0.02986; $factor_thirty =0.03674; $factor_twenty =0.05504; // the deposit is here $deposit1 = $start_price/10; $deposit = number_format($deposit1, 2, '.', ''); $fortyeight_month = number_format($percentage_start * $factor_forty, 2); $fortyeight_total = number_format($percentage_start * $factor_forty * 48, 2); $thirtysix_month = number_format($percentage_start * $factor_thirty, 2); $thirtysix_total = number_format($percentage_start * $factor_thirty * 36, 2); $twentyfour_month = number_format($percentage_start * $factor_twenty, 2); $twentyfour_total = number_format($percentage_start * $factor_twenty * 24, 2); //-------------------------------------------------------------------------------// // V12 Calculate // //-------------------------------------------------------------------------------// // apr ammount is here $apr = 19.9; $apr2 = 29.8; $factor_thirtysix = 0.0363; $factor_bnpl_six = 0.04092; $factor_bnpl_nine = 0.04574; // the deposit is here $deposit1 = $start_price/10; $deposit = number_format($deposit1, 2, '.', ''); $BalanceBeforeCharges = $percentage_start - $deposit; $MonthlyInstalment_36 = number_format($BalanceBeforeCharges * $factor_thirtysix, 2); $MonthlyInstalment_bnpl_6 = number_format($BalanceBeforeCharges * $factor_bnpl_six, 2); $MonthlyInstalment_bnpl_9 = number_format($BalanceBeforeCharges * $factor_bnpl_nine, 2); $MonthlyPPI_36 = number_format($MonthlyInstalment_36*0.16, 2); $MonthlyPPI_bnpl_6 = number_format($MonthlyInstalment_bnpl_6*0.16, 2); $MonthlyPPI_bnpl_9 = number_format($MonthlyInstalment_bnpl_9*0.16, 2); $MonthlyWithPPI_36 = ($MonthlyPPI_36*1)+($MonthlyInstalment_36*1); $BalancePayable_36 = $MonthlyInstalment_36 * 36; $BalancePayable_bnpl_6 = $MonthlyInstalment_bnpl_6 * 42; $BalancePayable_bnpl_9 = $MonthlyInstalment_bnpl_9 * 39; $ChargeForCredit_36 = $BalancePayable_36 - $BalanceBeforeCharges; $ChargeForCredit_bnpl_6 = $BalancePayable_bnpl_6 - $BalanceBeforeCharges; $ChargeForCredit_bnpl_9 = $BalancePayable_bnpl_9 - $BalanceBeforeCharges; $TotalAmountPayable_36 = ($BalanceBeforeCharges*1)+ ($ChargeForCredit_36*1); $TotalAmountPayable_bnpl_6 = ($BalanceBeforeCharges*1)+ ($ChargeForCredit_bnpl_6*1) + 29; $TotalAmountPayable_bnpl_9 = ($BalanceBeforeCharges*1)+ ($ChargeForCredit_bnpl_9*1) + 49; ?> <div class="t"><div class="b"><div class="l"><div class="r"><div class="bl"><div class="br"><div class="tl"><div class="tr"> <div id="textv12" class="main" align="justify" style="font-size:10px;">V12 provide finance packages to our customers. To read more detailed info please <?php echo'<a href="' . tep_href_link('v12.php') .'" target="_blank"><font color="#5C96D6"><u>click here</u></font></a>'; ?>. This option is available at checkout and will redirect you to the V12 website automatically!</div> <table width="95%" border="0" > <tr> <td class="main" style="font-size:10px;"><div id="buypayclassic_all"><strong>Classic Credit 36 Months<br> of £<?php echo $MonthlyInstalment_36; ?> per month</strong></div></td> <td class="main" style="font-size:10px;" align="right"><div id="buypayclassic_show"><a href="#" onClick="javascript:hidediv('buypayclassic','buypayclassic_show','buypayclassic_hide','textv12','buypay6month_all','buypay9month_all','buypay6month_show','buypay9month_show');return false;"><font color="#5C96D6"><u>Read more</u></font></a></div> <div id="buypayclassic_hide" style="display:none;" align="center"><a href="#" onClick="javascript:hidediv('buypayclassic','buypayclassic_show','buypayclassic_hide','textv12','buypay6month_all','buypay9month_all','buypay6month_show','buypay9month_show');return false;"><font color="#5C96D6"><u>Back</u></font></a></div></td> </tr> <tr> <td class="main" colspan="2" style="font-size:10px;"><div id="buypayclassic" style="display:none;"> 10% deposit (£<?php echo $deposit;?>)<br> Total payable £<?php echo $TotalAmountPayable_36; ?> at 19.9% APR<br> </div></td> </tr> <tr> <td class="main" style="font-size:10px;"><div id="buypay6month_all"><strong>Buy now pay 6 months later 0% interest</strong></div></td> <td class="main" align="right" style="font-size:10px;"><div id="buypay6month_show"><a href="#" onClick="javascript:hidediv('buypay6month','buypay6month_show','buypay6month_hide','textv12','buypayclassic_all','buypay9month_all','buypayclassic_show','buypay9month_show');return false;"><font color="#5C96D6"><u>Read more</u></font></a></div> <div id="buypay6month_hide" style="display:none;" align="center"><a href="#" onClick="javascript:hidediv('buypay6month','buypay6month_show','buypay6month_hide','textv12','buypayclassic_all','buypay9month_all','buypayclassic_show','buypay9month_show');return false;"><font color="#5C96D6"><u>Back</u></font></a></div></td> </tr> <tr> <td class="main" colspan="2" style="font-size:10px;"><div id="buypay6month" style="display:none;"> 10% deposit (£<?php echo $deposit;?>) plus £29 Set Up fee<br> Settle in full inside 6 months and pay <strong>no interest</strong> or wait 6 months and make 42 monthly payments of £<?php echo $MonthlyInstalment_bnpl_6; ?> per month<br> Total payable £<?php echo $TotalAmountPayable_bnpl_6; ?> at 29.8% APR<br> </div></td> </tr> <tr> <td class="main" style="font-size:10px;"><div id="buypay9month_all"><strong>Buy now pay 9 months later 0% interest</strong></div></td> <td class="main" align="right" style="font-size:11px;"><div id="buypay9month_show"><a href="#" onClick="javascript:hidediv('buypay9month','buypay9month_show','buypay9month_hide','textv12','buypayclassic_all','buypay6month_all','buypayclassic_show','buypay6month_show');return false;"><font color="#5C96D6"><u>Read more</u></font></a></div> <div id="buypay9month_hide" style="display:none;" align="center"><a href="#" onClick="javascript:hidediv('buypay9month','buypay9month_show','buypay9month_hide','textv12','buypayclassic_all','buypay6month_all','buypayclassic_show','buypay6month_show');return false;"><font color="#5C96D6"><u>Back</u></font></a></div></td> </tr> <tr> <td class="main" colspan="2" style="font-size:10px;"><div id="buypay9month" style="display:none;"> 10% deposit (£<?php echo $deposit;?>) plus £49 Set Up fee<br> Settle in full inside 9 months and pay <strong>no interest</strong> or wait 9 months and make 39 monthly payments of £<?php echo $MonthlyInstalment_bnpl_9; ?> per month<br> Total payable £<?php echo $TotalAmountPayable_bnpl_9; ?> at 29.8% APR<br> </div></td> </tr> </table> </div> </div></div></div></div></div></div></div></div> <? } ?> <div id="tcontent2" class="tabcontent"> <div class="t"><div class="b"><div class="l"><div class="r"><div class="bl"><div class="br"><div class="tl"><div class="tr"> <div align="justify"> <?php // non mainland delivery if($products_price1 < 40){$non1 = 10.00; $non2 = 5.00;} else if($products_price1 >= 40 && $products_price1 < 200){$non1 = 29.00; $non2 = 19.00;} else if($products_price1 >= 200 && $products_price1 < 1500){$non1 = 99.00; $non2 = 59.00;} else{$non1 = 129.00; $non2 = 89.00;} //delivery prices $delivery_query = tep_db_query("SELECT p.products_id, p.products_ship_price_one, p.products_ship_price_two, p.products_ship_price_three from " . TABLE_PRODUCTS . " p where p.products_id =". (int) $products_id .""); while ($delivery_results = tep_db_fetch_array($delivery_query)) { $delivery_sat = number_format($delivery_results['products_ship_price_one'], 2, '.', ''); $delivery_nbd = number_format($delivery_results['products_ship_price_two'], 2, '.', ''); $delivery_ndbpre = number_format($delivery_results['products_ship_price_three'], 2, '.', ''); echo '<table width="95%" border="0" > <tr> <td class="main" style="font-size:10px;" width="65%" valign="top"><b>Free delivery available</b></td> <td class="main" style="font-size:10px;" valign="top">3 to 5 working days.</td> </tr> <tr> <td class="main" style="font-size:10px;" valign="top">Next Business Day</td> <td class="main" style="font-size:10px;" valign="top">£' . $delivery_nbd . '</td> </tr> <tr> <td class="main" style="font-size:10px;" valign="top">Next Business Day Pre 12</td> <td class="main" style="font-size:10px;" valign="top">£' . $delivery_ndbpre . '</td> </tr> <tr> <td class="main" style="font-size:10px;" valign="top">Saturday Delivery</td> <td class="main" style="font-size:10px;" valign="top">£' . $delivery_sat . '</td> </tr> <tr> <td class="main" style="font-size:10px;"><b>Non UK Mainland Delivery</b></td> <td class="main" style="font-size:10px;" valign="top">Delivery price at Checkout.</td> </tr> </table>'; } ?> </div> </div></div></div></div></div></div></div></div> </div> <div id="tcontent3" class="tabcontent"> <div class="t"><div class="b"><div class="l"><div class="r"><div class="bl"><div class="br"><div class="tl"><div class="tr"> <table width="95%" border="0" cellspacing="0"> <!-- <tr> <td class="main">Small Installation </td> <td class="main">£129.99</td> <td class="main"> </td> </tr>--> <? if($bracket_set==1) { echo '<tr> <td class="main" style="font-size:10px;" ><b><u>MEDIUM INSTALLATION SERVICE - sceen size up to 32"</u></b><br>1staudiovisual have teamed up with the UK\'s leading TV installation company wecanfit.</u></b></td><td width="5"> </td> <td class="main" align="center" style="font-size:10px;" valign=top>£149.99</td> <td class="main"> </td> </tr> <tr> <td class="main" colspan=4 align="right"><a href="http://www.1staudiovisual.co.uk/catalog/product_info.php?products_id=3914" target="_blank"><img src="images/small_moreinfo.gif" border="0" align="absmiddle" alt="for more information" width="70" height="20"></a></td> </tr>'; } if($bracket_set==2) { echo '<tr> <td class="main" style="font-size:10px;" ><b><u>LARGE INSTALLATION SERVICE '.$bracket_text.'</u></b><br>1staudiovisual have teamed up with the UK\'s leading TV installation company wecanfit.</u></b></td><td width="5"> </td> <td class="main" align="center" style="font-size:10px;" valign=top>£189.99</td> <td class="main"> </td> </tr> <tr> <td class="main" colspan=4 align="right"><a href="http://www.1staudiovisual.co.uk/catalog/product_info.php?products_id=3913" target="_blank"><img src="images/small_moreinfo.gif" border="0" align="absmiddle" alt="for more information"></a></td> </tr>'; } if($bracket_set==3) { echo '<tr> <td class="main" style="font-size:10px;" ><b><u>LARGE INSTALLATION SERVICE '.$bracket_text.'</u></b><br>1staudiovisual have teamed up with the UK\'s leading TV installation company wecanfit.</u></b></td><td width="5"> </td> <td class="main" align="center" style="font-size:10px;" valign=top>£189.99</td> <td class="main"> </td> </tr> <tr> <td class="main" colspan=4 align="right"><a href="http://www.1staudiovisual.co.uk/catalog/product_info.php?products_id=3913" target="_blank"><img src="images/small_moreinfo.gif" border="0" align="absmiddle" alt="for more information"></a></td> </tr>'; } if($bracket_set==4) { echo '<tr> <td class="main" style="font-size:10px;"><b><u>LARGE INSTALLATION SERVICE '.$bracket_text.'</u></b><br>1staudiovisual have teamed up with the UK\'s leading TV installation company wecanfit.</u></b></td> <td class="main" align="center" style="font-size:10px;" valign=top>£189.99</td><td width="5"> </td> <td class="main"> </td> </tr> <tr> <td class="main" colspan=4 align="right"><a href="http://www.1staudiovisual.co.uk/catalog/product_info.php?products_id=3913" target="_blank"><img src="images/small_moreinfo.gif" border="0" align="absmiddle" alt="for more information"></a></td> </tr>'; } ?> </table> </div></div></div></div></div></div></div></div> </div> </div> <script type="text/javascript"> //Start Tab Content script for UL with id="maintab" Separate multiple ids each with a comma. initializetabcontent("maintab") </script> </td></tr></table> </td> <!--eof tab --> <!--warranty--> <!--warranty eof--> </tr> <tr> <td colspan="3"><table width="99%" border="0"> <tr> <td width="100%" align="center" valign="top"> <? $bluray_logo_query = tep_db_query("SELECT * FROM products_to_products_extra_fields WHERE products_to_products_extra_fields.products_id = '".(int)$HTTP_GET_VARS['products_id']."' AND products_to_products_extra_fields.products_extra_fields_id = '1006' AND products_to_products_extra_fields.products_extra_fields_value LIKE '%Blu Ray%' "); if(tep_db_num_rows($bluray_logo_query)>0) echo '<a href="http://dvdretail.at/1staudiovisual?CTY=2&CID=10456" target="_blank"><img src="http://b1.perfb.com/o1.php?ID=10456&PURL=dvdretail.at/1staudiovisual" alt="Low prices on Blu-ray" border="0" /></a>'; else echo ' '; /* // Start How To and Already if($c_pid=='52' or $c_pid=='135' or $c_pid=='136' or $c_pid=='22' or $c_pid=='121' or $c_pid=='129' or $c_pid=='23' or $cid=='207' or $c_pid=='73' or $cid=='111' or $cid=='106') { ?><table width="100%" border="0" cellspacing="0" cellpadding="0" align="left"> <tr> <td valign="bottom" class="main"><img src="images/top_left.gif" width="13" height="15" /></td> <td valign="bottom" class="main" style="background-image:url(images/top1.gif)"> </td> <td valign="bottom" class="main"><img src="images/top_right.gif" width="14" height="15" /></td> </tr> <tr> <td class="main" style="background-image:url(images/left2.gif)"> </td> <td class="main"><table width="100%" border="0" cellpadding="0" cellspacing="0" background="images/help.gif" style="background-position:right; background-repeat:no-repeat;"> <tr> <td class="main" style="font-size:10px;"><strong>Need some help? Here is how to Purchase:</strong> <ol> <li>Click the green 'add to cart' button in the middle of the screen to add the main item to your cart.</li> <li>Select your Warranty from the pop up box. Extended warranties are provided by Domestic and General.</li> <li>Check out our recommended accessories for this product. Click on the category to see individual items.</li> <li>All done? OK. click in the bottom right corner to review your shopping cart and check out.</li> </ol></td> </tr> </table></td> <td width="14" class="main" style="background-image:url(images/right2.gif)"> </td> </tr> <tr> <td width="13" valign="top" class="main"><img src="images/bottom_left.gif" width="13" height="15" /></td> <td class="main" style="background-image:url(images/bottom2.gif)"> </td> <td width="14" valign="top" class="main"><img src="images/bottom_right.gif" width="14" height="15" /></td> </tr> </table> <? }else { echo " "; } ?> </td> <td width="26%" align="right"> <?php echo '<div id="ready_to_cart" style="display:none;">'.tep_image_submit('ready_to_cart.gif', IMAGE_BUTTON_IN_CART).'</div>'; ?>*/ ?></td> </tr> </table></td> </tr> <? } ?> </table></td> <td valign="top" width="137"> <table border="0" width="137" cellspacing="0" cellpadding="2"> <!-- right_navigation //--> <tr><td> <!-- Start of item Box --> <table width="137" align="left" cellpadding="0" cellspacing="0" border="0"> <tr> <td height="14"><img src="/catalog/images/infobox/corner_left.gif" border="0"/></td> <td width="100%"class="infoBoxHeading">Shopping Cart</td> <td height="14"><img src="/catalog/images/infobox/corner_right.gif" border="0"/></td> </tr> <tr> <td width="137" colspan="3" class="smallText"> <table cellpadding="1" cellspacing="0" width="100%" style="border:solid 1px #c4d8df"> <tr><td class="smallText" align="center" > <div id="item_box" class="smallText"> </div> </td></tr> </table> </td> </tr> </table> <!-- end of item Box --> </td></tr> <?php require(DIR_WS_INCLUDES . 'column_right_products.php'); ?> <!-- right_navigation_eof //--> </table></td> </tr> <tr> <td colspan="3"><!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--></td> </tr> </table> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
Thank you very much for your help.
I don't understand what your asking...
★ "If your not having fun, your doing something wrong." - Humbug
★ Did I help you out? Did I piss you off? Add to my reputation!
★ The Gabriel Method is a great book for losing weight and keeping healthy - I know Jon Gabriel Personally.
★ Did I help you out? Did I piss you off? Add to my reputation!
★ The Gabriel Method is a great book for losing weight and keeping healthy - I know Jon Gabriel Personally.
![]() |
Similar Threads
- Hidden program installs .dlls with randomly generated names in random "notify" reg. (Viruses, Spyware and other Nasties)
- Paypal shopping basket link (PHP)
- have i discovered a hidden seo trick? (Search Engine Optimization)
- Available events for Button hidden in .NET (ASP.NET)
- Please review my Web site (Website Reviews)
- hide link if variable is empty (JSP)
- How did Dani get the "Search" link to go directly... (Existing Scripts)
- hidden window (Windows NT / 2000 / XP)
- Hidden Dialler (Viruses, Spyware and other Nasties)
Other Threads in the PHP Forum
- Previous Thread: PHP to Java script
- Next Thread: help
| Thread Tools | Search this Thread |
301 apache api array autosuggest beginner binary broken cakephp checkbox class cms code compression cron curl data database date display dropdownlist dynamic echo email eregi error execution file files folder form forms function functions google href htaccess html httppost if...loop image include insert ip javascript joomla jquery key library limit link links login mail md5 menu mlm multiple mysql mysql_real_escape_string oop paypal pdf pdfdownload php phpvotingscript problem query radio random recursion remote screen script search searchbox server session sessions sms sorting source space sql syntax system table tutorial update upload url validator variable video volume votedown web website youtube zend





