| Server IP : 51.89.169.208 / Your IP : 3.148.192.32 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/staff/edit/ |
Upload File : |
<?php
ini_set("memory_limit", "200000000");
// prevent cache
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header("Cache-Control: no-cache");
header("Pragma: no-cache");
require('../../connect.php');
$adid=$_GET['adid'];
$memberid=$_GET['memberid'];
$companyname=$_GET['adname'];
// css for menu
$styleManage = 'color:#ff6131;background-color:#fff;border-top:1px solid #c9c9c9;font-weight:bold;';
if(isset($_POST['submit'])){
$monstart=$_POST['monstart'];$monstart1=$_POST['monstart1'];$monfin=$_POST['monfin'];$monfin1=$_POST['monfin1'];$monclosed=$_POST['monclosed'];
$tuestart=$_POST['tuestart'];$tuestart1=$_POST['tuestart1'];$tuefin=$_POST['tuefin'];$tuefin1=$_POST['tuefin1'];$tueclosed=$_POST['tueclosed'];
$wedstart=$_POST['wedstart'];$wedstart1=$_POST['wedstart1'];$wedfin=$_POST['wedfin'];$wedfin1=$_POST['wedfin1'];$wedclosed=$_POST['wedclosed'];
$thurstart=$_POST['thurstart'];$thurstart1=$_POST['thurstart1'];$thurfin=$_POST['thurfin'];$thurfin1=$_POST['thurfin1'];$thurclosed=$_POST['thurclosed'];
$fristart=$_POST['fristart'];$fristart1=$_POST['fristart1'];$frifin=$_POST['frifin'];$frifin1=$_POST['frifin1'];$friclosed=$_POST['friclosed'];
$satstart=$_POST['satstart'];$satstart1=$_POST['satstart1'];$satfin=$_POST['satfin'];$satfin1=$_POST['satfin1'];$satclosed=$_POST['satclosed'];
$sunstart=$_POST['sunstart'];$sunstart1=$_POST['sunstart1'];$sunfin=$_POST['sunfin'];$sunfin1=$_POST['sunfin1'];$sunclosed=$_POST['sunclosed'];
$facebook=str_replace("http://","",$_POST['facebook']);$twitter=str_replace("http://","",$_POST['twitter']);$google=str_replace("http://","",$_POST['google']);
$youtube=str_replace("http://","",$_POST['youtube']);$linkedin=str_replace("http://","",$_POST['linkedin']);
$opQuery = "
`monstart` = '$monstart',
`monstart1` = '$monstart1',
`monfin` = '$monfin',
`monfin1` = '$monfin1',
`monclosed` = '$monclosed',
`tuestart` = '$tuestart',
`tuestart1` = '$tuestart1',
`tuefin` = '$tuefin',
`tuefin1` = '$tuefin1',
`tueclosed` = '$tueclosed',
`wedstart` = '$wedstart',
`wedstart1` = '$wedstart1',
`wedfin` = '$wedfin',
`wedfin1` = '$wedfin1',
`wedclosed` = '$wedclosed',
`thurstart` = '$thurstart',
`thurstart1` = '$thurstart1',
`thurfin` = '$thurfin',
`thurfin1` = '$thurfin1',
`thurclosed` = '$thurclosed',
`fristart` = '$fristart',
`fristart1` = '$fristart1',
`frifin` = '$frifin',
`frifin1` = '$frifin1',
`friclosed` = '$friclosed',
`satstart` = '$satstart',
`satstart1` = '$satstart1',
`satfin` = '$satfin',
`satfin1` = '$satfin1',
`satclosed` = '$satclosed',
`sunstart` = '$sunstart',
`sunstart1` = '$sunstart1',
`sunfin` = '$sunfin',
`sunfin1` = '$sunfin1',
`sunclosed` = '$sunclosed'";
$q3 = "INSERT INTO `opening_hours` SET `opadid` = '{$adid}', {$opQuery} ON DUPLICATE KEY UPDATE {$opQuery}";
$r3 = mysql_query($q3) or die(mysql_error());
if($_POST['facebook']!=""||$_POST['twitter']!=""||$_POST['google']!=""||$_POST['youtube']!=""||$_POST['linkedin']!=""){
$q6 = "INSERT INTO social_links SET
so_member_id = '$memberid',
so_ad_id = '$adid',
facebook = '$facebook',
googleplus = '$google',
twitter = '$twitter',
youtube = '$youtube',
linkedin = '$linkedin'
ON DUPLICATE KEY UPDATE
facebook = '$facebook', googleplus = '$google', twitter = '$twitter',youtube = '$youtube', linkedin = '$linkedin'";
$r6 = mysql_query($q6) or die(mysql_error());
}
$success=TRUE;
header('Location: edit_4.html?adid='.$adid);
}
// for opening times
$add_que_sql = mysql_query("SELECT * FROM opening_hours WHERE opadid ='{$adid}'");
$add_row = mysql_fetch_array($add_que_sql);
// for social
$social_que_sql = mysql_query("SELECT * FROM social_links WHERE `so_ad_id` = '$adid' and `so_member_id` = '$memberid'");
$social_row = mysql_fetch_array($social_que_sql);
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>YellowLeaf UK</title>
<link href="../../style.css" rel="stylesheet" type="text/css">
<link href="../style_staff.css" rel="stylesheet" type="text/css">
<script language="javascript">
<!--
function CheckPostAd(){
// mon
if(document.getElementById('monCheck').checked==false){ // if not closed, then validate
if(document.RegForm.monstart.value==""){
window.alert('Please enter the time your business opens on Monday.');
document.RegForm.monstart.focus();
return false;
}
if(document.RegForm.monfin.value==""){
window.alert('Please enter the time your business closes on Monday');
document.RegForm.monfin.focus();
return false;
}
}
// tue
if(document.getElementById('tueCheck').checked==false){ // if not closed, then validate
if(document.RegForm.tuestart.value==""){
window.alert('Please enter the time your business opens on Tuesday.');
document.RegForm.tuestart.focus();
return false;
}
if(document.RegForm.tuefin.value==""){
window.alert('Please enter the time your business closes on Tuesday');
document.RegForm.tuefin.focus();
return false;
}
}
// wed
if(document.getElementById('wedCheck').checked==false){ // if not closed, then validate
if(document.RegForm.wedstart.value==""){
window.alert('Please enter the time your business opens on Wednesday');
document.RegForm.wedstart.focus();
return false;
}
if(document.RegForm.wedfin.value==""){
window.alert('Please enter the time your business closes on Wednesday');
document.RegForm.wedfin.focus();
return false;
}
}
// thur
if(document.getElementById('thuCheck').checked==false){ // if not closed, then validate
if(document.RegForm.thurstart.value==""){
window.alert('Please enter the time your business opens on Thursday');
document.RegForm.thurstart.focus();
return false;
}
if(document.RegForm.thurfin.value==""){
window.alert('Please enter the time your business closes on Thursday');
document.RegForm.thurfin.focus();
return false;
}
}
// fri
if(document.getElementById('friCheck').checked==false){ // if not closed, then validate
if(document.RegForm.fristart.value==""){
window.alert('Please enter the time your business opens on Friday');
document.RegForm.fristart.focus();
return false;
}
if(document.RegForm.frifin.value==""){
window.alert('Please enter the time your business closes on Friday');
document.RegForm.frifin.focus();
return false;
}
}
// sat
if(document.getElementById('satCheck').checked==false){ // if not closed, then validate
if(document.RegForm.satstart.value==""){
window.alert('Please enter the time your business opens on Saturday');
document.RegForm.satstart.focus();
return false;
}
if(document.RegForm.satfin.value==""){
window.alert('Please enter the time your business closes on Saturday');
document.RegForm.satfin.focus();
return false;
}
}
// sun
if(document.getElementById('sunCheck').checked==false){ // if not closed, then validate
if(document.RegForm.sunstart.value==""){
window.alert('Please enter the time your business opens on Sunday');
document.RegForm.sunstart.focus();
return false;
}
if(document.RegForm.sunfin.value==""){
window.alert('Please enter the time your business closes on Sunday');
document.RegForm.sunfin.focus();
return false;
}
}
}
function toggleOp(dv,chkbx){
var divBox = document.getElementById(dv);
var checkBox = document.getElementById(chkbx);
if(checkBox.checked == true){
// show box if not checked
divBox.style.display='none';
}else{
// hide box if checked
divBox.style.display='';
}
}
function init(){
<?
if($add_row['monclosed'] == '1'){
echo "document.getElementById('monOp').style.display='none';";
}
if($add_row['tueclosed'] == '1'){
echo "document.getElementById('tueOp').style.display='none';";
}
if($add_row['wedclosed'] == '1'){
echo "document.getElementById('wedOp').style.display='none';";
}
if($add_row['thurclosed'] == '1'){
echo "document.getElementById('thuOp').style.display='none';";
}
if($add_row['friclosed'] == '1'){
echo "document.getElementById('friOp').style.display='none';";
}
if($add_row['satclosed'] == '1'){
echo "document.getElementById('satOp').style.display='none';";
}
if($add_row['sunclosed'] == '1'){
echo "document.getElementById('sunOp').style.display='none';";
}
?>
}
</script>
<style>
.optmeDv{color:#444;padding:5px 15px;border-bottom:1px solid #ddd}
.closedTd{font-size:11pt;}
.socialTbl td{color:#444;}
</style>
</head>
<body onload="init()">
<? include '../staff_header.php'; include 'edit_menu.php';?>
<table class="tbwdth">
<tr>
<td valign="top">
<div class="cnHead">Manage Advert</div>
<?if($success==TRUE){?>
<div class="successDvBx">
Update Successful. Your details have been saved. <br><a href="edit_3.html?adid=<?=$adid?>">Click here to go to Section 3 ></a>
</div>
<?}?>
<form name="RegForm" action="edit_3.html?adid=<?=$adid?>" method="POST" enctype="multipart/form-data" onsubmit="return CheckPostAd();" autocomplete="off">
<table width="100%" class="cnTbl">
<tr>
<td align="left" valign="top" class="cnTitle" style="padding-left:25px">Opening Times*:<br>
<div class="cnTitleDesc">Please enter the business opening times.</div><br>
<div class="optmeDv">
<table>
<tr>
<td colspan="2" style="color:#244471" class="cnTitle">Monday</td></td>
</tr>
<tr>
<td>
<div id="monOp">
<input name="monstart" type="text" size="3" value="<?=$add_row['monstart']?>" />
<select name="monstart1">
<option value="<?=$add_row['monstart1']?>" selected><?=$add_row['monstart1']?></option>
<optgroup label="---"></optgroup>
<option value="am">am</option>
<option value="pm">pm</option>
</select> -
<input name="monfin" type="text" size="3" value="<?=$add_row['monfin']?>" />
<select name="monfin1">
<option value="<?=$add_row['monfin1']?>" selected><?=$add_row['monfin1']?></option>
<optgroup label="---"></optgroup>
<option value="am">am</option>
<option value="pm">pm</option>
</select>
</div>
</td>
<td class="closedTd">
<?if($add_row['monclosed'] == '1'){
echo "<input id='monCheck' onclick=\"toggleOp('monOp','monCheck')\" type='checkbox' name='monclosed' value='1' checked>";
}else{
echo "<input id='monCheck' onclick=\"toggleOp('monOp','monCheck')\" type='checkbox' name='monclosed' value='1'>";
}?> Closed on Monday</td>
</tr>
</table>
</div>
<div class="optmeDv">
<table>
<tr>
<td colspan="2" style="color:#244471" class="cnTitle">Tuesday</td></td>
</tr>
<tr>
<td>
<div id="tueOp">
<input name="tuestart" type="text" size="3" value="<?=$add_row['tuestart']?>" />
<select name="tuestart1">
<option value="<?=$add_row['tuestart1']?>" selected><?=$add_row['tuestart1']?></option>
<optgroup label="---"></optgroup>
<option value="am">am</option>
<option value="pm">pm</option>
</select> -
<input name="tuefin" type="text" size="3" value="<?=$add_row['tuefin']?>" />
<select name="tuefin1">
<option value="<?=$add_row['tuefin1']?>" selected><?=$add_row['tuefin1']?></option>
<optgroup label="---"></optgroup>
<option value="am">am</option>
<option value="pm">pm</option>
</select>
</div>
</td>
<td class="closedTd">
<?if($add_row['tueclosed'] == '1'){
echo "<input id='tueCheck' onclick=\"toggleOp('tueOp','tueCheck')\" type='checkbox' name='tueclosed' value='1' checked>";
}else{
echo "<input id='tueCheck' onclick=\"toggleOp('tueOp','tueCheck')\" type='checkbox' name='tueclosed' value='1'>";
}?> Closed on Tuesday</td>
</tr>
</table>
</div>
<div class="optmeDv">
<table>
<tr>
<td colspan="2" style="color:#244471" class="cnTitle">Wednesday</td></td>
</tr>
<tr>
<td>
<div id="wedOp">
<input name="wedstart" type="text" size="3" value="<?=$add_row['wedstart']?>" />
<select name="wedstart1">
<option value="<?=$add_row['wedstart1']?>" selected><?=$add_row['wedstart1']?></option>
<optgroup label="---"></optgroup>
<option value="am">am</option>
<option value="pm">pm</option>
</select> -
<input name="wedfin" type="text" size="3" value="<?=$add_row['wedfin']?>" />
<select name="wedfin1">
<option value="<?=$add_row['wedfin1']?>" selected><?=$add_row['wedfin1']?></option>
<optgroup label="---"></optgroup>
<option value="am">am</option>
<option value="pm">pm</option>
</select>
</div></td>
<td class="closedTd">
<?if($add_row['wedclosed'] == '1'){
echo "<input id='wedCheck' onclick=\"toggleOp('wedOp','wedCheck')\" type='checkbox' name='wedclosed' value='1' checked>";
}else{
echo "<input id='wedCheck' onclick=\"toggleOp('wedOp','wedCheck')\" type='checkbox' name='wedclosed' value='1'>";
}?> Closed on Wednesday</td>
</tr>
</table>
</div>
<div class="optmeDv">
<table>
<tr>
<td colspan="2" style="color:#244471" class="cnTitle">Thursday</td></td>
</tr>
<tr>
<td>
<div id="thuOp">
<input name="thurstart" type="text" size="3" value="<?=$add_row['thurstart']?>" />
<select name="thurstart1">
<option value="<?=$add_row['thurstart1']?>" selected><?=$add_row['thurstart1']?></option>
<optgroup label="---"></optgroup>
<option value="am">am</option>
<option value="pm">pm</option>
</select> -
<input name="thurfin" type="text" size="3" value="<?=$add_row['thurfin']?>" />
<select name="thurfin1">
<option value="<?=$add_row['thurfin1']?>" selected><?=$add_row['thurfin1']?></option>
<optgroup label="---"></optgroup>
<option value="am">am</option>
<option value="pm">pm</option>
</select>
</div>
</td>
<td class="closedTd">
<?if($add_row['thurclosed'] == '1'){
echo "<input id='thuCheck' onclick=\"toggleOp('thuOp','thuCheck')\" type='checkbox' name='thurclosed' value='1' checked>";
}else{
echo "<input id='thuCheck' onclick=\"toggleOp('thuOp','thuCheck')\" type='checkbox' name='thurclosed' value='1'>";
}?>
Closed on Thursday</td>
</tr>
</table>
</div>
<div class="optmeDv">
<table>
<tr>
<td colspan="2" style="color:#244471" class="cnTitle">Friday</td></td>
</tr>
<tr>
<td>
<div id="friOp">
<input name="fristart" type="text" size="3" value="<?=$add_row['fristart']?>" />
<select name="fristart1">
<option value="<?=$add_row['fristart1']?>" selected><?=$add_row['fristart1']?></option>
<optgroup label="---"></optgroup>
<option value="am">am</option>
<option value="pm">pm</option>
</select> -
<input name="frifin" type="text" size="3" value="<?=$add_row['frifin']?>" />
<select name="frifin1">
<option value="<?=$add_row['frifin1']?>" selected><?=$add_row['frifin1']?></option>
<optgroup label="---"></optgroup>
<option value="am">am</option>
<option value="pm">pm</option>
</select>
</div>
</td>
<td class="closedTd">
<?if($add_row['friclosed'] == '1'){
echo "<input id='friCheck' onclick=\"toggleOp('friOp','friCheck')\" type='checkbox' name='friclosed' value='1' checked>";
}else{
echo "<input id='friCheck' onclick=\"toggleOp('friOp','friCheck')\" type='checkbox' name='friclosed' value='1'>";
}?> Closed on Friday</td>
</tr>
</table>
</div>
<div class="optmeDv">
<table>
<tr>
<td colspan="2" style="color:#244471" class="cnTitle">Saturday</td></td>
</tr>
<tr>
<td>
<div id="satOp">
<input name="satstart" type="text" size="3" value="<?=$add_row['satstart']?>" />
<select name="satstart1">
<option value="<?=$add_row['satstart1']?>" selected><?=$add_row['satstart1']?></option>
<optgroup label="---"></optgroup>
<option value="am">am</option>
<option value="pm">pm</option>
</select> -
<input name="satfin" type="text" size="3" value="<?=$add_row['satfin']?>" />
<select name="satfin1">
<option value="<?=$add_row['satfin1']?>" selected><?=$add_row['satfin1']?></option>
<optgroup label="---"></optgroup>
<option value="am">am</option>
<option value="pm">pm</option>
</select>
</div>
</td>
<td class="closedTd">
<?if($add_row['satclosed'] == '1'){
echo "<input id='satCheck' onclick=\"toggleOp('satOp','satCheck')\" type='checkbox' name='satclosed' value='1' checked> Closed";
}else{
echo "<input id='satCheck' onclick=\"toggleOp('satOp','satCheck')\" type='checkbox' name='satclosed' value='1'> Closed";
}?> Closed on Saturday</td>
</tr>
</table>
</div>
<div class="optmeDv" style="border-bottom:0px">
<table>
<tr>
<td colspan="2" style="color:#244471" class="cnTitle">Sunday</td></td>
</tr>
<tr>
<td>
<div id="sunOp">
<input name="sunstart" type="text" size="3" value="<?=$add_row['sunstart']?>" />
<select name="sunstart1">
<option value="<?=$add_row['sunstart1']?>" selected><?=$add_row['sunstart1']?></option>
<optgroup label="---"></optgroup>
<option value="am">am</option>
<option value="pm">pm</option>
</select> -
<input name="sunfin" type="text" size="3" value="<?=$add_row['sunfin']?>" />
<select name="sunfin1">
<option value="<?=$add_row['sunfin1']?>" selected><?=$add_row['sunfin1']?></option>
<optgroup label="---"></optgroup>
<option value="am">am</option>
<option value="pm">pm</option>
</select>
</div>
</td>
<td class="closedTd">
<?if($add_row['sunclosed'] == '1'){
echo "<input id='sunCheck' onclick=\"toggleOp('sunOp','sunCheck')\" type='checkbox' name='sunclosed' value='1' checked>";
}else{
echo "<input id='sunCheck' onclick=\"toggleOp('sunOp','sunCheck')\" type='checkbox' name='sunclosed' value='1'>";
}?> Closed on Sunday</td>
</tr>
</table>
</div>
</td>
</tr>
<tr>
<td><hr noshade color="#C9C9C9" size="1"></td>
</tr>
<tr>
<td align="left" valign="top" class="cnTitle" style="padding-left:25px">Your Social Links (optional)<br>
<div class="cnTitleDesc">Please provide the links to your social pages.</div>
<table class="socialTbl">
<tr>
<td>Facebook: http:// </td>
<td><input name="facebook" type="text" class="txbox" size="40" value="<?=$social_row['facebook']?>" /></td>
</tr>
<tr>
<td>Twitter: http:// </td>
<td><input name="twitter" type="text" class="txbox" size="40" value="<?=$social_row['twitter']?>" /></td>
</tr>
<tr>
<td>Google+: http:// </td>
<td><input name="google" type="text" class="txbox" size="40" value="<?=$social_row['googleplus']?>" /></td>
</tr>
<tr>
<td>YouTube: http:// </td>
<td><input name="youtube" type="text" class="txbox" size="40" value="<?=$social_row['youtube']?>" /></td>
</tr>
<tr>
<td>LinkedIn: http:// </td>
<td><input name="linkedin" type="text" class="txbox" size="40" value="<?=$social_row['linkedin']?>" /></td>
</tr>
</table>
</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>
</body>
</html>