Server IP : 51.89.169.208 / Your IP : 216.73.216.57 Web Server : Apache System : Linux ns3209505.ip-198-244-202.eu 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Tue Nov 5 04:50:16 EST 2024 x86_64 User : yellowleaf ( 1019) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/yellowleaf/public_html/members/ |
Upload File : |
<?php $path = $_SERVER['DOCUMENT_ROOT']; include_once $path.'/connect_db.php'; include "accesscontrol.php"; $adid=$_GET['adid']; // check if advert beleongs to members $query = $connect->query("SELECT COUNT(adid) FROM ads WHERE adid='{$adid}' AND memberid='{$memberid}'"); if(advert_check($adid,$memberid)===false){header('Location: index.html');exit();} // css for menu $styleManage = 'color:#ff6131;background-color:#fff;border-top:1px solid #c9c9c9;font-weight:bold;'; if(isset($_POST['submit'])){ $companyname=$_POST['companyname']; $address1=$_POST['address1']; $address2=$_POST['address2']; $countyDetails= explode("||", $_POST['county']); $county=$countyDetails[0]; $county_name=$countyDetails[2]; $townDetails = explode("|", $_POST['town']); $longitude=$townDetails[0]; $latitude=$townDetails[1]; $town_name=$townDetails[2]; $btype=$_POST['btype']; $bcategory=$_POST['bcat']; $postcode=$_POST['postcode']; $telephone=str_replace(' ','',$_POST['telephone']); $fax=$_POST['fax']; $email=$_POST['email']; $url=str_replace("http://","",$_POST['url']); $time=time(); $q3 = "UPDATE ads SET companyname = '$companyname', street1 = '$address1', street2 = '$address2', county_name = '$county_name', town_name = '$town_name', postcode = '$postcode', tel = '$telephone', fax = '$fax', email = '$email', url = '$url', business_type = '$btype', mcategory = '$bcategory', longitude = '$longitude', latitude = '$latitude', last_update = '$time' WHERE adid = '$adid' AND `memberid` = '$memberid'"; $r3 = $connect->query($q3) or die($connect->error); $success=TRUE; header('Location: edit_2.html?adid='.$adid); } $add_que_sql = mysql_query("SELECT * FROM ads WHERE memberid ='{$memberid}' AND adid ='{$adid}'"); $add_row = mysql_fetch_array($add_que_sql); $cat_sql = mysql_query("SELECT * FROM cats WHERE cat_id='{$add_row['cat_1']}' OR cat_id='{$add_row['cat_2']}' OR cat_id='{$add_row['cat_3']}' OR cat_id='{$add_row['cat_4']}'"); while($cat_row = mysql_fetch_array($cat_sql)){ $cats.=$cat_row['cat_name'].'|'; $catnames[$cat_row['cat_id']]=$cat_row['cat_name']; } $cat_piece = explode("|", $cats); // for main cats $cat_query = mysql_query("SELECT * FROM main_cats WHERE main_cats_id='".$add_row['mcategory']."'") or die(mysql_error()); $cat_row=mysql_fetch_array($cat_query); ?> <!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>YellowLeaf UK</title> <link href="./index.css" rel="stylesheet" type="text/css"> <script src="js/ajax_area.js"></script> <script src="js/ajax_cat.js"></script> <script src="js/drop_menu.js"></script> <script> function hideCat(id){ document.getElementById('cat_'+id+'_hid').value=''; document.getElementById('cat_'+id).value=''; } <!-- function CheckRegister(){ var em = /@/; var pc = /[^ +](.*) (.*)/; if(document.RegForm.companyname.value==""){ window.alert('Please enter your business name.'); document.RegForm.companyname.focus(); return false; } if(document.RegForm.address1.value==""){ window.alert('Please enter your business address.'); document.RegForm.address1.focus(); return false; } if(document.RegForm.county.value==""){ window.alert('Please select your county.'); document.RegForm.county.focus(); return false; } if(document.RegForm.town.value==""){ window.alert('Please select your area.'); document.RegForm.town.focus(); return false; } if(document.RegForm.postcode.value==""){ window.alert('Please enter your business postcode.'); document.RegForm.postcode.focus(); return false; } if(!pc.test(document.RegForm.postcode.value)){ window.alert('Invalid postcode.'); document.RegForm.postcode.focus(); return false; } if(document.RegForm.telephone.value==""){ window.alert('Please enter your business telephone number.'); document.RegForm.telephone.focus(); return false; } if(!em.test(document.RegForm.email.value)){ alert("Please enter a valid business email address"); document.RegForm.email.focus(); return false; } if(document.getElementById('btype').value==''){ window.alert('Please choose a type of business'); document.getElementById('btype').focus(); return false; } if(document.getElementById('b_sector').value==''){ window.alert('Please select a category for your business.'); document.getElementById('filterinput').focus(); return false; } } //--> </script> <style> .dv_bg{border:1px solid #d5d5d5;background: #fafafa;padding:15px;width:620px;} .notif_cn{margin-bottom:18px;} .shw_notif{color:#002EE6;cursor:pointer;font-size:9pt;font-weight:bold;position: relative;text-decoration:underline;display:none;} .shw_notif:hover{color:#005FEC;} .shw_notif img{border:0px;position:absolute;right:-24px;top: -1px;} .hide_notif{color:#5e5e5e;cursor:default;float:right;font-size:18px;font-weight:bold;margin-top:-7px;padding:2px;text-shadow:1px 1px #fff;{hide_noJS}} .hide_notif:hover{color:#9E2D2D} .frm_notif{position:relative;background:#FFFAE5;border:1px solid #FCD58B;color:#444;text-shadow:1px 1px 0 rgba(255,255,255,0.7);padding:10px;-webkit-box-shadow:0 2px 3px rgba(100,100,100,0.2);box-shadow:0 2px 3px rgba(100,100,100,0.2)} .frm_notif_arr_bg{position:absolute;z-index: 110;bottom:-9px;left:22px;width: 0px;height: 0px;border-style: solid;border-width:9px 9px 0 9px;border-color:#FFFAE5 transparent transparent transparent;} .frm_notif_arr_border{position:absolute;z-index: 100;bottom:-11px;left:20px;width: 0px;height: 0px;border-style: solid;border-width:11px 11px 0 11px;border-color:#FCD58B transparent transparent transparent;} .frm_notif_arr_bg_left{position:absolute;z-index: 110;top:10px;left:-10px;width: 0px;height: 0px;border-style: solid;border-width:9px 10px 9px 0;border-color: transparent #FFFAE5 transparent transparent;} .frm_notif_arr_border_left{position:absolute;z-index: 100;top:8px;left:-11px;width: 0px;height: 0px;border-style: solid;border-width:11px 11px 11px 0;border-color: transparent #FCD58B transparent transparent;} .notif_eg{font-size:9pt;} .sect_list{list-style-type:none;padding: 0px;margin:0px;} .sect_list li{color:#444;font-weight:normal;padding:3px 8px} .sect_list li:hover{background:#D6E7C4;} .sect_list li:active{background:#C1CFB3;} .sect_list div{cursor:default;} .cat_tag:hover{background: #657b53 url('/img/tag_remove.png') no-repeat 6px 7px;} .cat_tag{float:left;cursor:default;clear:both;white-space:nowrap;padding:3px 7px 3px 20px;-webkit-box-shadow: 0 1px 0 0 rgba(100,100,100,0.6) inset;-moz-box-shadow: 0 1px 0 0 rgba(100,100,100,0.6) inset;-o-box-shadow: 0 1px 0 0 rgba(100,100,100,0.6) inset;box-shadow: 0 1px 0 0 rgba(100,100,100,0.6) inset;-webkit-transition: .35s ease all;-moz-transition: .35s ease all;-ms-transition: .35s ease all;-o-transition: .35s ease all;transition: .35s ease all;margin: 0 4px 4px 0;color: #fff;background:#728b5e url('/img/tag_remove.png') no-repeat 6px 7px;text-shadow: 0 1px 0 rgba(0,0,0,0.3);font-size: 9pt;line-height: 16px;} .dp_cn{position:relative;z-index:9999;} .normal{background-color:#fff;} .selected{background: #f0f9ff;background: -webkit-gradient(linear,left top,left bottom,color-stop(0%,rgba(240,249,255,1)),color-stop(100%,rgba(226,244,255,1)));background: -webkit-linear-gradient(top,rgba(240,249,255,1) 0,rgba(226,244,255,1) 100%);background: -o-linear-gradient(top,rgba(240,249,255,1) 0,rgba(226,244,255,1) 100%);background: -ms-linear-gradient(top,rgba(240,249,255,1) 0,rgba(226,244,255,1) 100%);background: linear-gradient(to bottom,rgba(240,249,255,1) 0,rgba(226,244,255,1) 100%);filter: progid:DXImageTransform.Microsoft.gradient(startColorstr='#f0f9ff', endColorstr='#e2f4ff', GradientType=0);} </style> </head> <body> <? include 'header.php'; ?> <table class="tbwdth"> <tr> <td valign="top" style="width:210px;"> <? include 'member_menu.php'; ?> </td> <td valign="top" class="cnGrad"> <div class="cnHead">Manage Advert</div> <div style="position:relative;margin-bottom:70px"> <hr class="stpBar" noshade size="1" color="#cccccc"> <img style="position:absolute;left:223px;top:-33px;" src="/img/arr_nav.png" /> <img class="nav sel1 pos1" src="/img/img_trans.gif" width="1" height="1" /> <a href="edit_2.html?adid=<?=$adid?>"><img border="0" class="nav step2 pos2" src="/img/img_trans.gif" width="1" height="1" /></a> <a href="edit_3.html?adid=<?=$adid?>"><img border="0" class="nav step3 pos3" src="/img/img_trans.gif" width="1" height="1" /></a> <a href="edit_4.html?adid=<?=$adid?>"><img border="0" class="nav step4 pos4" src="/img/img_trans.gif" width="1" height="1" /></a> </div> <?if($success==TRUE){?> <div class="successDvBx"> Update Successful. Your details have been saved. <br><a href="edit_2.html?adid=<?=$adid?>">Click here to go to Section 2 ></a> </div> <?}?> <form name="RegForm" action="edit_1.html?adid=<?=$adid?>" method="POST" enctype="multipart/form-data" onsubmit="return CheckRegister();" autocomplete="off"> <table class="cnTbl" width="100%"> <tr> <td class="cnWidth cnTitle" style="padding-left:25px">Business Name*:<br> <div class="cnTitleDesc">Please enter your business name.</div><input name="companyname" type="text" class="txbox" size="40" value="<?=$add_row['companyname']?>" /></td> </tr> <tr> <td> <hr noshade color="#C9C9C9" size="1"> </td> </tr> <tr> <td class="cnTitle" style="padding-left:25px"> <div class="cnTitle"> Business County*:<br> <div class="cnTitleDesc">Please select the county of where your business is located.</div> <select size="1" name="county" id="county" class="curv3 edfrm return_false" onchange="return get_town_drop(this.value,'town_dv')" style="margin-bottom:8px;width:272px;"> <option value="null" selected="">Select a County</option> <? $cname = $add_row['county_name']; $get=mysql_query("SELECT * FROM `county` WHERE `county_id`!='999' ORDER BY divide_country ASC, county_name ASC"); while ($row_county = mysql_fetch_array($get)) { foreach($row_county AS $key => $val){ $$key = stripslashes(strip_tags($val)); } if ($county_name == "Bedfordshire") { if ($newcat) { $county.='</optgroup>'; } $county.='<optgroup label="England">'; $newcat=1; } if ($county_name == "County Antrim") { if ($newcat) { $county.='</optgroup>'; } $county.='<optgroup label="Northern Ireland">'; $newcat=1; } if ($county_name == "Aberdeen") { if ($newcat) { $county.='</optgroup>'; } $county.='<optgroup label="Scotland">'; $newcat=1; } if ($county_name == "Blaenau Gwent") { if ($newcat) { $county.='</optgroup>'; } $county.='<optgroup label="Wales">'; $newcat=1; } if ($county_name == "Channel Islands") { if ($newcat) { $county.='</optgroup>'; } $county.='<optgroup label="Channel Islands">'; $newcat=1; } $county.='<option value="'.$county_id.'||'.$divide_country.'||'.$county_name.'">'.$county_name.'</option>'; } echo $county; echo str_replace('>'.$cname.'</option>',' selected>'.$cname.'</option>',$county); ?> </select> </div> <div class="cnTitle" style="margin:20px 0"> Business Address*:<br> <div class="cnTitleDesc">Please enter the address of your business.</div> <input class="txbox" type="text" class="txbox" size="40" id="address1" value="<?=$add_row['street1']?>" name="address1"><br> <input class="txbox" type="text" class="txbox" size="40" id="address2" value="<?=$add_row['street2']?>" name="address2"> </div> <div id="town_dv" class="cnTitle"> <? $tname = $add_row['town_name']; $get=@mysql_query("SELECT * FROM `towns_new` WHERE `r_county_name`='{$cname}' AND type='2' ORDER BY stripped_name ASC"); $town.='<div class="cnTitle">Business Town / Area*:<br><div class="cnTitleDesc">Please select the town of where your business is located.</div></div>'; $town.='<select size="1" name="town" class="curv3 edfrm" id="towns" style="margin-bottom:8px;">'; $town.='<option value="null">Please select a town</option>'; while ($row = @mysql_fetch_array($get)) { $town.='<option value="'.$row['lon'].'|'.$row['lat'].'|'.$row['stripped_name'].'">'.$row['stripped_name'].'</option>'; } $town.='</select>'; echo str_replace('>'.$tname.'</option>',' selected>'.$tname.'</option>',$town); ?> </div> </td> </tr> <tr> <td> <hr noshade color="#C9C9C9" size="1"> </td> </tr> <tr> <td class="cnTitle" style="padding-left:25px">Postcode*:<br> <div class="cnTitleDesc">Please enter your business postcode.</div> <input name="postcode" type="text" class="txbox" size="40" value="<?=$add_row['postcode']?>" /></td> </tr> <tr> <td> <hr noshade color="#C9C9C9" size="1"> </td> </tr> <tr> <td class="cnTitle" style="padding-left:25px">Telephone*:<br> <div class="cnTitleDesc">Please enter your business telephone number.</div> <input name="telephone" type="text" class="txbox" size="40" value="<?=$add_row['tel']?>" onkeyup="this.value=this.value.replace(/[^\d ]/,'')" /></td> </tr> <tr> <td> <hr noshade color="#C9C9C9" size="1"> </td> </tr> <tr> <td class="cnTitle" style="padding-left:25px">FAX:<br> <div class="cnTitleDesc">Please enter your business FAX number.</div> <input name="fax" type="text" class="txbox" size="40" value="<?=$add_row['fax']?>" onkeyup="this.value=this.value.replace(/[^\d ]/,'')" /></td> </tr> <tr> <td> <hr noshade color="#C9C9C9" size="1"> </td> </tr> <tr> <td class="cnTitle" style="padding-left:25px">Email*:<br> <div class="cnTitleDesc">Please enter your business email address. <i>This will be kept confidential.</i></div> <input name="email" type="text" class="txbox" size="40" value="<?=$add_row['email']?>" /></td> </tr> <tr> <td> <hr noshade color="#C9C9C9" size="1"> </td> </tr> <tr> <td class="cnTitle" style="padding-left:25px">Website URL (optional):<br> <div class="cnTitleDesc">Please enter your business website URL.</div> <input name="url" type="text" class="txbox" size="40" value="<?=$add_row['url']?>" /></td> </tr> <tr> <td> <hr noshade color="#C9C9C9" size="1"> </td> </tr> <tr> <td valign="top" class="cnTitle" style="padding-left:25px">Type of Business*:<br> <div class="cnTitleDesc">Please choose a type of business</div> <? if($add_row['business_type']=="Offering Services"){ $offservice="selected"; }elseif($add_row['business_type']=="Selling Products"){ $sellprod="selected"; } ?> <select class="txbox" size="1" id="btype" name="btype"> <option <?=$offservice?> value="Offering Services">Offering Services</option> <option <?=$sellprod?> value="Selling Products">Selling Products</option> </select> <br><br> <br><br> <div class="cnTitleDesc" style="font-weight:bold;font-size:11pt;color:#05c;">Please select a category for your business</div> <div class="ed_cn" style="position:relative;"> <table class="norm_tbl" width="100%"> <tr> <td colspan="2"> <div style="color:#333;font-weight:normal"> <span style="background-color:#ffff6c;color:#f00;padding:0 2px;font-size:9pt;font-weight:bold;">PLEASE NOTE:</span> You can only choose one relevant category. </div> </td> </tr> <tr> <td valign="top" style="padding-left:0"> <div class="text_cn ed_cn dv_bg curv3" style="width:300px" id="filt_form"> <div id="fm_tag"> <input class="filterinput curv3 edfrm" type="text" id="filterinput" style="color:#888;margin-bottom:15px;width:265px;background:#fff url('/img/search-dark2.png') no-repeat 6px 9px;padding-left:25px !important;" onkeyup="getSector(this.value)" onblur="if(this.value==''||this.value=='Enter business sector or trade type'){this.value='Enter business sector or trade type';this.style.color='#888'}" onclick="if(this.value==''||this.value=='Enter business sector or trade type'){this.value='';this.style.color='#000';}" value="Enter business sector or trade type" autocomplete="off"> <div class="curv3" style="background:#fff;min-height:220px;max-height:325px;width:298px;border:1px solid #ddd;overflow:auto;margin-bottom:15px;"> <ul class="sect_list" id="list"> <div style="text-align:center;font-weight:bold;background:#EEE;color:#5A5A5A;padding:20px;margin-top:25px;line-height:17px">Enter your keyword in the above text box to select your business category.</div> </ul> </div> </div> <input type="hidden" class="txt_inp curv3" id="b_sector" size="60" name="bcat" value="<?=$cat_row['main_cats_id']?>"> </div> </td> <td valign="top" style="padding-left:15px;"> <div class="notif_cn" id="bsct" style="margin-top:19px;"> <div style="margin-bottom:10px" class="frm_notif curv3"> <div class="frm_notif_arr_border_left"></div><div class="frm_notif_arr_bg_left"></div> <b>Step 1: Please enter your business sector or trade type.</b><br><br> e.g. "Restaurants" or "Hotels". </div> </div> <div class="notif_cn" id="bsct" style="margin-bottom:0px;"> <div style="margin-bottom:10px" class="frm_notif curv3"> <div class="frm_notif_arr_border_left"></div><div class="frm_notif_arr_bg_left"></div> <b>Step 2: Click to select your business sector or trade type.</b><br><br> You can choose upto 1 sector. </div> </div> <div id="tag_info" style="width:290px;"> <div style="color:#444;text-align:center;font-weight:bold;margin:15px 10px;"></div> <div id="max_filter" class="curv3" style="margin-bottom:5px;color:rgb(235, 92, 23);padding:5px;text-align:center;font-weight:bold;background:#fceee7;display:none;">Maximum choice of 1</div> <div id="your_tag" class="curv3" style="margin-bottom:5px;color:rgb(18, 69, 134);padding:5px;text-align:center;font-weight:bold;background:#e5eefa;">Your Selected Tags</div> <? if($add_row['mcategory']){ echo '<div class="curv3 deselect cat_tag tg_'.$cat_row['main_cats'].'" id="'.$cat_row['main_cats_id'].'" onclick="add_tag(\''.$cat_row['main_cats'].'\')">'.$cat_row['main_cats'].'</div>'; } ?> </div> </td> </tr> </table> </div> </td> </tr> <tr> <td> <hr noshade color="#C9C9C9" size="1"> </td> </tr> <tr> <td> <span style="font-size:9pt;color:#666;">* mandatory fields that must be filled in.</span> </td> </tr> </table> <input class="blueBtn fancyBtn" style="border:0px;float:left;" type="submit" value="Update & Go to next step >" name="submit"> </form> </td> </tr> </table> <? include 'footer.php'; ?> <script type="text/javascript"> function getScript(e, t) {var n = document.createElement("script");n.src = e;var r = document.getElementsByTagName("head")[0],i = false;n.onload = n.onreadystatechange = function () {if (!i && (!this.readyState || this.readyState == "loaded" || this.readyState == "complete")){t();n.onload = n.onreadystatechange = null;r.removeChild(n)}};r.appendChild(n)} function getSector(value){ var xmlhttp = false; var xmlhttp = (window.XMLHttpRequest) ? xmlhttp=new XMLHttpRequest() : xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); //if (value==""){$("#list").html('<div style="text-align:center;font-weight:bold;color:#B30000;padding:30px;">No sector found, please use the search box above to find your sector.</div>'); return;} xmlhttp.onreadystatechange=function() { if (xmlhttp.readyState==4 && xmlhttp.status==200){ $('#list').html(xmlhttp.responseText); } } xmlhttp.open("GET","http://www.yellowleaf.co.uk/members/ajax/ajax_mainCat.php?value="+value,true); xmlhttp.send(); } function get_town_drop(value,el_id){ $('#'+el_id).html('<img src="/img/ajax-loader.gif"> Please wait...'); var xmlhttp = false; var xmlhttp = (window.XMLHttpRequest) ? xmlhttp=new XMLHttpRequest() : xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); xmlhttp.onreadystatechange=function() { if (xmlhttp.readyState==4 && xmlhttp.status==200){ $('#'+el_id).html(xmlhttp.responseText); return true; } } xmlhttp.open("GET","ajax/get_town.ajax.php?value="+value,true); xmlhttp.send(); } var sector_arr = [<?=$cat_row['main_cats_id']?>]; getScript("http://ajax.googleapis.com/ajax/libs/jquery/1.5.2/jquery.min.js",function (){ var cat_text = ""; var tag_limit = 1; // when filter item is clicked - category tag $('#list > li').live('click','#click',function(){ var ls_txt = $(this).children().text(); //cat_text = ls_txt + ' | ' + $(this).attr('class') + ' > ' + $(this).attr('id') + ' ~~ '; //cat_text = ls_txt + ' | ' + $(this).attr('class'); cat_text = $(this).attr('id'); // ADDING CAT -- limit tag_limit if(sector_arr.length < tag_limit){ // check value does not exists and not empty if($.inArray(cat_text, sector_arr) < 0 && cat_text!=''){ // placing value into array sector_arr.push(cat_text); $(this).css('background-color','#dde9d9'); $('#b_sector').val(sector_arr.toString()); $('<div class="curv3 deselect cat_tag tg_'+ls_txt+'" id="'+cat_text+'" onclick="add_tag(\''+cat_text+'\')">'+ls_txt+'</div>').appendTo("#tag_info"); if(sector_arr.length == tag_limit){ $('#your_tag').fadeOut(300,function(){$('#max_filter').fadeIn(300);}); } // fade in max filter sign if tag_limit if(sector_arr.length > 0 && sector_arr.length < tag_limit){$('#your_tag').fadeIn(300);} // fade in your sign if more than 0 } }else{ alert('You cannot choose more than '+tag_limit+' sectors.'); } }); // remove from category tag list $('.cat_tag').live('click','#click',function(){ if(sector_arr.length == tag_limit){ $('#max_filter').fadeOut(300,function(){$('#your_tag').fadeIn(300);}); } // fade out max filter sign if tag_limit if(sector_arr.length <= 1){$('#your_tag').fadeOut(300);} // fade out if your sign less than 0 var cat_text = $(this).attr('id'); var arr_spl = cat_text.split(" |"); $('#list').find("div:Contains("+arr_spl[0]+")").parent().css('background-color','white'); //sector_arr.splice(sector_arr.indexOf(cat_text), 1); // removing tag from array sector_arr.splice(jQuery.inArray($(this).attr("id"),sector_arr), 1); // removing tag from array $('#b_sector').val(sector_arr.toString()); $(this).remove(); }); // jquery Contains feature incase sensitive jQuery.expr[':'].Contains = function(a, i, m) {return jQuery(a).text().toUpperCase().indexOf(m[3].toUpperCase()) >= 0;}; }); </script> </body> </html>