Edit file File name : sitemap-addf.php Content :<?php session_start(); include("../include/config.php"); include("../include/functions.php"); validate_admin(); $sitemap_type=mysqli_real_escape_string($GLOBALS['conn'],$_POST['sitemap_type']); $url=mysqli_real_escape_string($GLOBALS['conn'],trim($_POST['url'])); $priority=mysqli_real_escape_string($GLOBALS['conn'],$_POST['priority']); if($_REQUEST['submitForm']=='yes'){ if($_REQUEST['id']==''){ $lines = explode('\r\n', $url); $lines = array_values(array_unique(array_filter($lines,'trim'))); $invalidurl=array(); $exist_url=array(); foreach ($lines as $line){ $line=trim($line); if (!filter_var($line, FILTER_VALIDATE_URL) === false) { $checkUrlQuery=$obj->query("select id from tbl_sitemap where url='$line'"); if($obj->numRows($checkUrlQuery)>0){ array_push($exist_url, $line); }else{ $obj->query("insert into tbl_sitemap set url='$line',url_category='$sitemap_type',priority='$priority',user_id='".$_SESSION['sess_admin_id']."',status=1, custom_url=1"); } }else { echo $line; array_push($invalidurl, $line); } } if(!empty($exist_url)){ $_SESSION['existlist']=implode(',', $exist_url); } if(!empty($invalidurl)){ $_SESSION['invalidlist']=implode(',', $invalidurl); } $_SESSION['sess_msg'].='Urls added sucessfully.'; }else{ $url=trim($url); if (!filter_var($url, FILTER_VALIDATE_URL) === false) { $obj->query("update tbl_sitemap set url='$url',url_category='$sitemap_type',priority='$priority',user_id='".$_SESSION['sess_admin_id']."',status=1, custom_url=1 where id=".$_REQUEST['id']); $_SESSION['sess_msg']='Url updated sucessfully'; } else { $_SESSION['sess_msg'].='Url is not valid!'; } } header("location:sitemap-list.php"); exit(); } if($_REQUEST['id']!=''){ $sql=$obj->query("select * from tbl_sitemap where id=".$_REQUEST['id']); $result=$obj->fetchNextObject($sql); } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title><?php echo SITE_TITLE; ?></title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <link href="css/admin.css" rel="stylesheet" type="text/css" /> <script type="text/javascript" language="javascript"> function validate(obj){ if(obj.url.value==''){ alert("Please enter URL."); obj.url.focus(); return false; } if(obj.sitemap_type.value==''){ alert("Please select sitemap category."); obj.sitemap_type.focus(); return false; } if(obj.priority.value==''){ alert("Please enter priority value between 0.1 - 1."); obj.priority.focus(); return false; } } </script> </head> <body> <table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0"> <?php include("header.php") ?> <tr> <td align="right" class="paddRtLt70" valign="top"> <table width="99%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="right" valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="left" valign="middle" class="headingbg bodr text14"> <em><img src="images/arrow2.gif" width="21" height="21" hspace="10" align="absmiddle" /></em>Admin: Update URL <span style="float:right; padding-right:10px;"> <input type="button" name="add" value="View Sitemap" class="button" onclick="location.href='sitemap-list.php?sitemap_type=general'" /></span></td> </tr> <tr> <td height="100" align="left" valign="top" bgcolor="#f3f4f6" class="bodr"> <form name="frm" method="POST" enctype="multipart/form-data" action="" onsubmit="return validate(this)"> <input type="hidden" name="submitForm" value="yes" /> <input type="hidden" name="id" value="<?php echo $_REQUEST['id'];?>" /> <table width="100%" cellpadding="0" cellspacing="0"> <tr> <td align="center" colspan="2" class="paddRt14 paddBot11"> <font color="#FF0000"><strong><?php echo $_SESSION['sess_msg']; $_SESSION['sess_msg']='';?></strong></font></td> </tr> <tr> <td width="18%" align="right" class="paddBot11 paddRt14"> </td> <td width="82%" align="left" class="paddBot11"></td> </tr> <tr> <td align="right" class="paddBot11 paddRt14"><strong>URL Category:</strong></td> <td align="left" class="paddBot11"> <select name="sitemap_type" style="width:506px" required> <option value="General" <?php if($result->url_category=='General'){ echo "selected"; } ?>>General</option> <option value="Grocery" <?php if($result->url_category=='Grocery'){ echo "selected"; } ?>>Grocery</option> <option value="Food" <?php if($result->url_category=='Food'){ echo "selected"; } ?>>Food & Nationwode</option> <option value="blog" <?php if($result->url_category=='Blog'){ echo "selected"; } ?>>Blog</option> <option value="Product" <?php if($result->url_category=='Product'){ echo "selected"; } ?>>Product</option> </select></td> </tr> <tr> <td align="right" class="paddBot11 paddRt14"><strong>Url Priority</strong></td> <td align="left" class="paddBot11"><input name="priority" type="text" size="106" required value="<?php echo stripslashes($result->priority);?>" /> <strong>Should be between 0.1 - 1</strong></td> </tr> <?php if($_REQUEST['id']!=''){ ?> <tr> <td align="right" class="paddBot11 paddRt14"><strong>URL:</strong></td> <td align="left" class="paddBot11"><input name="url" required type="text" size="106" value="<?php echo $result->url;?>" /></td> </tr> <?php }else{ ?> <tr> <td align="right" class="paddBot11 paddRt14"><strong>URL:</strong></td> <td align="left" class="paddBot11"><textarea name="url" required cols="91" rows="15" value="<?php echo $result->url;?>"></textarea></td> </tr> <?php } ?> <tr> <td align="right" class="paddRt14 paddBot11"> </td> <td align="left" class="paddBot11"> </td> </tr> <tr> <td width="18%" align="right" class="paddRt14 paddBot11"> </td> <td width="82%" align="left" class="paddBot11"> <input type="submit" name="submit" value="Submit" class="submit" border="0"/> <input name="Reset" type="reset" id="Reset" value="Reset" class="submit" border="0" /></td> </tr> </table></form> </td> </tr> </table> </td> </tr> </table> </td> </tr> <?php include('footer.php'); ?> </table> </body> </html> Save