📄 browsecats.php
字号:
<?
include_once("myconnect.php");
include_once("logincheck.php");
function main()
{
if ( isset( $_REQUEST["cid"] ) && $_REQUEST["cid"]!="" )
{
$cid=$_REQUEST["cid"];
}
else
{
$cid=0;
}
$catname="";
$sql_outter="Select * from sbbleads_categories where sb_id=$cid" ;
$rs_outter=mysql_query($sql_outter );
if ($rs_outter=mysql_fetch_array($rs_outter))
{
$catname = "<font size='2' > > </font><a href=\"browsecats.php?cid=" . $rs_outter["sb_id"] . "\"><font size='2' face='Arial, Helvetica, sans-serif'>".$rs_outter["sb_cat_name"]."</font></a>";
$cid = $rs_outter["sb_id"];
$pid = $rs_outter["sb_pid"];
while($pid<>0)
{
$cat=mysql_fetch_array(mysql_query("select * from sbbleads_categories where sb_id=$pid"));
$pid=$cat["sb_pid"];
$catname="<font size='2' >> </font><a href=\"browsecats.php?cid=" . $cat["sb_id"] . "\"><font size='2' face='Arial, Helvetica, sans-serif'>" .$cat["sb_cat_name"]."</font></a>" .$catname;
}
}
////////////////////////////////////////////////////////////
//////////////////DELETE CATEGORY///////////////////////////
////////////////////////////////////////////////////////////
if ( isset( $_REQUEST["delete"] ) && $_REQUEST["delete"]=="Yes" )
{
$sub_cats=mysql_num_rows(mysql_query("select * from sbbleads_categories where sb_pid=".$_REQUEST["delid"]));
$listing=mysql_num_rows(mysql_query("select * from sbbleads_offer_cats where sb_cid=".$_REQUEST["delid"]));
$listing1=mysql_num_rows(mysql_query("select * from sbbleads_offer_cats_buy where sb_cid=".$_REQUEST["delid"]));
$listing2=mysql_num_rows(mysql_query("select * from sbbleads_product_cats where sb_cid=".$_REQUEST["delid"]));
$listing3=mysql_num_rows(mysql_query("select * from sbbleads_profile_cats where sb_cid=".$_REQUEST["delid"]));
if($sub_cats<>0)
{
$delmsg=" This category cannot be deleted as it contains Subcategories. To delete this category you need to delete all its subcategories.";
}
elseif( ($listing<>0) || ($listing1<>0) || ($listing2<>0) || ($listing3<>0) )
{
$delmsg="This category has following contents<br>";
if($listing<>0)
$delmsg.=($listing > 1)?"$listing Sell Offers<br>":"$listing Sell Offer<br>";
if($listing1<>0)
$delmsg.=($listing1 > 1)?"$listing1 Buy Offers<br>":"$listing1 Buy Offer<br>";
if($listing2<>0)
$delmsg.=($listing2 > 1)?"$listing2 Product Catalogs<br>":"$listing2 Product Catalog<br>";
if($listing3<>0)
$delmsg.=($listing3 > 1)?"$listing3 Company Profiles<br>":"$listing3 Company Profile<br>";
$delmsg.=" You have to shift all these to any other category before deletion.";
}
else
{
mysql_query("delete from sbbleads_categories where sb_id=" . $_REQUEST["delid"] );
$delmsg=" Category has been deleted";
}
}
//////////////////////////////////////////////////////////////
//////////////// CATEGORY has been Deleted //////////////////
//////////////////////////////////////////////////////////////
$cat_name="";
$cat_desc="";
$cost="";
?>
<script language="JavaScript">
function del_confirm()
{
return confirm('Do you really want to delete the category?');
}
</script>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"> <table width="100%" border="0" cellpadding="1" cellspacing="1" dwcopytype="CopyTableCell">
<tr>
<td valign="top">
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top">
<table width="100%" border="0" cellspacing="10" cellpadding="2">
<tr>
<td>
<?
$errcnt=0;
$showform="";
$mailid="";
$fromid="";
$subject="";
$mail="";
if ( count($_POST)!=0 )
{
if ( !isset( $_REQUEST["cat_name"] ) || $_REQUEST["cat_name"]=="" )
{
$errs[$errcnt]="Category name must be provided";
$errcnt++;
}
elseif(preg_match ("/[;]/", $_REQUEST["cat_name"]))
{
$errs[$errcnt]="Category name can not have semi colon (;) ";
$errcnt++;
}
else
{
if (!get_magic_quotes_gpc()) {
$cat_name=str_replace('$', '\$',addslashes($_REQUEST["cat_name"]));
}
else
{
$cat_name=str_replace('$', '\$',$_REQUEST["cat_name"]);
}
$par_cat=mysql_fetch_array(mysql_query("select * from sbbleads_categories where sb_cat_name='".$cat_name."' and sb_pid=".$_REQUEST["cid"]));
if($par_cat)
{
$errs[$errcnt]="Category with this name already exists.";
$errcnt++;
}
}
$num_ques=0;
$num_ques+=mysql_num_rows(mysql_query("select * from sbbleads_offer_cats where sb_cid=".$_REQUEST["cid"]));
$num_ques+=mysql_num_rows(mysql_query("select * from sbbleads_offer_cats_buy where sb_cid=".$_REQUEST["cid"]));
$num_ques+=mysql_num_rows(mysql_query("select * from sbbleads_product_cats where sb_cid=".$_REQUEST["cid"]));
$num_ques+=mysql_num_rows(mysql_query("select * from sbbleads_profile_cats where sb_cid=".$_REQUEST["cid"]));
if( $num_ques>0)
{
$errs[$errcnt]="This category contains some listings, you have to shift all these listings to any other category before adding a subcategory.";
$errcnt++;
}
}
if (count($_POST)<>0)
{
if ( $errcnt==0 )
{
if (!get_magic_quotes_gpc()) {
$cat_name=str_replace('$', '\$',addslashes($_REQUEST["cat_name"]));
}
else
{
$cat_name=str_replace('$', '\$',$_REQUEST["cat_name"]);
}
$sql="Insert into sbbleads_categories (sb_cat_name,sb_pid,sb_visit_sell,sb_visit_buy,sb_visit_product,sb_visit_profile) values ('$cat_name',".$_REQUEST["cid"].",0,0,0,0)";
$rs=mysql_query( $sql);
$sql="select max(sb_order_index) from sbbleads_categories";
if( $rs_t1=mysql_fetch_array(mysql_query($sql) ))
{
$val=$rs_t1[0] + 1;
}
else
{
$val=0;
}
$sql="select max(sb_id) from sbbleads_categories";
if( $rs_t1=mysql_fetch_array(mysql_query($sql) ))
{
$sql="UPDATE sbbleads_categories SET sb_order_index=$val Where sb_id= ".$rs_t1[0];
mysql_query($sql);
}
$cat_name="";
?>
<font color="#FF0000" size="2" face="Arial, Helvetica, sans-serif">Category
has been Added</font>
<?
$showform="No";
}
else
{
$cat_name=$_REQUEST["cat_name"];
?>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2"><font color="#FF0000" size="2" face="Arial, Helvetica, sans-serif">
Your Add Category Request cannot be processed due
to following Reasons</font></td>
</tr>
<?
for ($i=0;$i<$errcnt;$i++)
{
?>
<tr valign="top">
<td width="6%"><font color="#FF0000" size="2" face="Arial, Helvetica, sans-serif"><?php echo $i+1; ?></font></td>
<td width="94%" align="left"><font color="#FF0000" size="2" face="Arial, Helvetica, sans-serif"><?php echo $errs[$i]; ?>
</font></td>
</tr>
<?
}//end for
?>
</table>
<?
}
}
?>
<font color="#FF0000" size="2" face="Arial, Helvetica, sans-serif">
<?
if (isset($delmsg))
{
echo $delmsg;
}
?>
</font> </td>
</tr>
<tr>
<td><a href="browsecats.php?cid=0"><font size='2' face='Arial, Helvetica, sans-serif'>All
Categories</font></a><font size="2" face="Arial, Helvetica, sans-serif"><? echo $catname;?>
</font></td>
</tr>
<tr>
<td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="76%" height="25" bgcolor="#004080"><strong><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"> Category</font></strong></td>
<td width="24%" height="25" bgcolor="#004080"><strong><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"> Options</font></strong></td>
</tr>
<?php
$rs_query=mysql_query("Select * from sbbleads_categories where sb_pid=$cid order by sb_order_index" );
$cat_num=mysql_num_rows($rs_query);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -