Forum PHP.pl

<?php
include("conn.php");
include("includes.php");
include("access.php");

//get the posted offers
$q1 = "select count(*) from class_catalog where MemberID = '$_SESSION[MemberID]' ";
$r1 = mysql_query($q1) or die(mysql_error());
$a1 = mysql_fetch_array($r1);

if($_SESSION[MaxOffers] == '0' || $_SESSION[AccountStatus] == 'inactive' || $a1[0] >= $_SESSION[MaxOffers])
{
header("location:more.php");
exit();
}


$SelectCategory = "<select name=CategoryID>\n\t<option value=\"\"></option>\n\t";

//get the categories and create the select menu
$q2 = "select * from class_categories order by CategoryName";
$r2 = mysql_query($q2) or die(mysql_error());

while($a2 = mysql_fetch_array($r2))
{
$SelectCategory .= "<option value=\"$a2[CategoryID]\">$a2[CategoryName]</option>\n\t";
}

$SelectCategory .= "</select>";

//get the member's assets, show them in a table (list), so the member will be able to edit or delete them
$q3 = "select * from class_catalog where MemberID = '$_SESSION[MemberID]' ";
$r3 = mysql_query($q3) or die(mysql_error());

if(mysql_num_rows($r3) > '0')
{
$ListMemberAsset .= "<table align=center width=400 cellspacing=0>\n";
$ListMemberAsset .= "<tr style=\"background-color:#D3D4E8; color:black; font-family:verdana; font-size:11; font-weight:bold\">\n\t<td width=300>Title</td>\n\t<td align=center width=100>Action</td>\n</tr>\n\n";

$col = "white";

while($a3 = mysql_fetch_array($r3))
{
if($col == "white")
{
$col = "dddddd";
}
else
{
$col = "white";
}

$ListMemberAsset .= "<tr bgcolor=$col>\n\t<td><a class=BlackLink href=\"info$a3[ProductID].html\">$a3[ProductName]</a> ";

if($a3[FeaturedStatus] == '1')
{
$ListMemberAsset .= "^{<font face=verdana color=\"#990000\"><b>Featured!</b></font>}";
}

$ListMemberAsset .= "</td>\n\t<td align=center><a class=GreenLink href=\"edit$a3[ProductID].html\">edit</a> | <a class=RedLink href=\"delete$a3[ProductID].html\">delete</a></td>\n</tr>\n\n";
}

$ListMemberAsset .= "</table>\n";
}


//get the priority levels
$qc = "select * from class_members where MemberID = '$_SESSION[MemberID]' ";
$rc = mysql_query($qc) or die(mysql_error());
$ac = mysql_fetch_array($rc);

$Featured = $ac[FeaturedAds];
$Standard = $ac[StandardAds];

//count the users ads
$qv = "select FeaturedStatus from class_catalog where MemberID = '$_SESSION[MemberID]' ";
$rv = mysql_query($qv) or die(mysql_error());

while($av = mysql_fetch_array($rv))
{
if($av[FeaturedStatus] == '1')
{
$f++;
}
else
{
$s++;
}
}

if(empty($f))
{
$f = '0';
}

if(empty($s))
{
$s = '0';
}

$SelectPriority = "<select name=sp>\n\t<option value=\"\"></option>\n\t";

if($Featured > $f)
{
$SelectPriority .= "<option value=\"1\">Featured</option>\n\t";
}

if($Standard > $s)
{
$SelectPriority .= "<option value=\"0\">Standard</option>\n\t";
}

$SelectPriority .= "</select>\n";




include("templates/HeaderTemplate.php");
include("templates/AddTemplate.php");
include("templates/FooterTemplate.php");

?>