OceanFront Classified Ads";
echo $ads->viewLinks();
$expire_new = date("Y-m-d",
mktime(0, 0, 0, date("m") + 3, date("d"), date("Y")));
if (!isset($category))
$category = "Ad";
if (isset($cmdType) && $cmdType == "Edit") {
$rs->query("SELECT category FROM ads WHERE id = '$id'");
$rs->next_record();
$category = $rs->f("category");
if (isset($renew) && $renew == "true")
$rs->query("UPDATE ads " .
"SET expire_date = '$expire_new' " .
"WHERE id = '$id'");
}
$rs = new qlDatabase();
$form = new qlForm("Edit Classified Ads");
$form->rs = new qlDatabase();
$form->dbTable = "ads";
$form->action = "editAds.php";
$form->method = "post";
$form->itemType = ucfirst($category);
$form->idField = "id";
$owner_id = $qlAuth->getUserID();
$form->criteriaID = "owner_id";
$form->criteriaVal = $owner_id;
$form->hideLinks = true;
if ($cmdType == "View" || $cmdType == "") $form->hideTitle = true;
$form->viewField = array("name"=>"name",
"subcategory"=>"subcategory",
"type"=>"type");
$form->catField = "category;adscategories;name;name";
$pid = $qlAuth->getUserID();
$form->add_element(array("type"=>"hidden",
"name"=>"owner_id",
"value"=>$pid,
"forceDatabase"=>"true",
"passVar"=>true));
$form->add_element(array("type"=>"hidden",
"name"=>"category",
"value"=>"$category",
"forceDatabase"=>"true",
"passVar"=>true));
$form->add_element(array("type"=>"showtext",
"name"=>"header1",
"description"=>"Ad Information",
"headerRow"=>true));
$lblArray = array(array("label"=>"For Sale", "value"=>"for sale"),
array("label"=>"Wanted", "value"=>"wanted"));
$form->add_element(array("type"=>"select",
"name"=>"type",
"description"=>"Type",
"tableBreak"=>"",
"required"=>"true",
"options"=>$lblArray,
"selected"=>array("forsale"),
"size"=>"1"));
$rs = new qlDatabase();
$rs->query("SELECT subcategories FROM adscategories " .
"WHERE name = '$category'");
$rs->next_record();
$subcats = explode(';', $rs->f("subcategories"));
sort($subcats);
$lblArray = array();
foreach ($subcats as $cat)
$lblArray[] = array("label"=>ucwords($cat), "value"=>$cat);
$form->add_element(array("type"=>"select",
"name"=>"subcategory",
"description"=>"Sub Category",
"required"=>"true",
"options"=>$lblArray,
"selected"=>array(""),
"size"=>"1"));
global $cmdType, $id;
require_once("qlDateDisplayer.inc");
$dt = new qlDateDisplayer();
if ($cmdType == "Edit") {
$rs->query("SELECT expire_date FROM ads WHERE id = '$id'");
$rs->next_record();
$expire = $rs->f("expire_date");
$expire = $dt->showDate("F j, Y", $expire);
$form->add_element(array("type"=>"showtext",
"name"=>"header3",
"description"=>"Expiration Date
" .
"(ads expire after 3 months)
" .
"(Renew)",
"value"=>$expire));
}
else {
$form->add_element(array("type"=>"hidden",
"name"=>"expire_date",
"value"=>$expire_new,
"forceDatabase"=>"true"));
}
$form->add_element(array("type"=>"showtext",
"name"=>"header2",
"description"=>"Ad Details",
"headerRow"=>true));
$form->add_element(array("type"=>"text",
"name"=>"name",
"description"=>"Short Description (Title)",
"tableBreak"=>"",
"required"=>"true",
"maxlength"=>"100"));
$rs->query("SELECT field_descs FROM adscategories " .
"WHERE name = '$category'");
$rs->next_record();
$extraFields = explode(';', $rs->f('field_descs'));
if ($extraFields[0] == "") $extraFields = array();
foreach ($extraFields as $ndx => $field) {
$form->add_element(array("type"=>"text",
"name"=>"data$ndx",
"description"=>"$field",
"tableBreak"=>"",
"maxlength"=>"100"));
}
$form->add_element(array("type"=>"textarea",
"name"=>"description",
"description"=>"Detailed Description",
"tableBreak"=>"",
"rows"=>"4",
"cols"=>"40"));
$form->add_element(array("type"=>"text",
"name"=>"price",
"description"=>"Price",
"tableBreak"=>"",
"value"=>"$",
"maxlength"=>"12"));
$form->add_element(array("type"=>"text",
"name"=>"image_url",
"description"=>"Image URL
(i.e. " .
"/images/oceanFront.gif)",
"tableBreak"=>"",
"value"=>"",
"maxlength"=>"100"));
$form->add_element(array("type"=>"submit",
"name"=>"submit",
"value"=>"Save Ad"));
if ($cmdType == "Edit") {
$rs->query("SELECT owner_id FROM ads WHERE id = '$id'");
$rs->next_record();
if ($rs->f("owner_id") != $qlAuth->getUserID()
&& !$qlAuth->hasPerm("admin"))
echo "\nSorry, but you do not have permission to edit this ad.
";
else
$form->start();
}
elseif ($category != "Ad" || $cmdType != "Add")
$form->start();
else {
echo "\nPost an Ad: Select a Category
\n";
$rs->query("SELECT name from adscategories ORDER BY name");
while ($rs->next_record()) {
$cat = $rs->f("name");
echo "\n - " . ucfirst($cat) . "
";
}
echo "\n
";
}
?>