%preserve_order%> <%include:header%>
|
$sitename = "<%insert_title%>";
global $ses;
$userid = $ses["user_id"];
$result = mysql_query("select * from inl_users where user_id = '$userid'");
if (!$result)
die("SQL result failed");
$num = mysql_num_rows($result);
while ($row = mysql_fetch_array($result))
{
$first = $row["first"];
$last = $row["last"];
$email = $row["email"];
}
$linkuser = "<%link_user%>";
if (!$userid)
{
echo "You must be logged in to use this feature.";
}
if ($userid && ($userid != $linkuser))
{
echo "This isn't your product, your account information along with your actions have been sent to our abuse team for review.";
$mail .= " Name: $first $last\n";
$mail .= " Account: $userid\n";
$mail .= " E-Mail: $email\n";
$mail .= " Product: <%link_name%> <%link_cust7%> (<%link_id%>)\n\n";
$mail .= "An illegal attempt was made to delete this product.";
mail("$adminemail","$sitename - Illegal Delete",$mail,"From: $email\n");
}
?>
if ($userid && ($userid == $linkuser))
{
if (!$yes) { ?>
Are you sure you want to remove: <%link_name%> <%link_cust7%> IMPORTANT NOTICE: If you need to update your listing, don't delete it then re-add it, simply edit it. } if ($yes) { global $conn, $ses, $having, $extended_search, $sid; ## delete category link relation for specified category OR all in NULL or ALL $add_catID = (($link_cat == "all") || is_null($link_cat))? "" : " AND cat_id='$link_cat'"; $conn->Execute("DELETE FROM inl_lc where link_id='$id'".$add_catID); $conn->Execute("DELETE FROM inl_fav where link_id='$id'"); $rs = &$conn->Execute("select count(link_id) from inl_lc where link_id=$id"); $count = ($rs->EOF)? 1 : $rs->fields[0]; if(($link_cat=="all") || ($count == 0)) { //take care of custom, if any $rs = &$conn->Execute("select link_cust from inl_links where link_id='$id'"); if ($rs && !$rs->EOF) { if ($rs->fields[0]) { $conn->Execute("DELETE FROM inl_custom where cust_id='".$rs->fields[0]."'"); } } //delete physical link record itself $conn->Execute("DELETE FROM inl_links where link_id='$id'"); //clean up references (should already be Ok); $conn->Execute("DELETE FROM inl_lc where link_id=$id"); $conn->Execute("DELETE FROM inl_reviews where rev_link=$id"); } $ret = ($link_cat=="all")? update_all_link_count() : update_link_count($link_cat); $mail .= " Name: $first $last\n"; $mail .= " E-Mail: $email\n"; $mail .= " Product: <%link_name%> <%link_cust7%> (<%link_id%>)\n"; $mail .= " URL: http://$_SERVER[HTTP_HOST]/details/<%link_id%>\n"; mail("$adminemail","$sitename - Delete Product Request",$mail,"From: $email\n"); echo " Your product has been completely removed from the database, a notification of this action has been sent to the administrator. Modify Listings |