function addPage($page_title, $page_meta_title, $page_meta_description, $page_meta_keywords, $page_content, $show_on_page, $section_type)
{
$dbobj = new Cdb(SERVER, DBNAME, DBUSER, DBPASS);
$dbobj->connectDB();
$maxqry = $dbobj->getCellFromDB("max(sortOrder)", "contentspagetemplate", "1=1");
$sort_order = $maxqry + 1;
$dbobj->writeToDB("(SectionID, PageTitle, PageMetaTitle, PageMetaDescription, PageMetaKeywords, PageContents, showOnPage, sortOrder )VALUES('{$section_type}', '{$page_title}', '{$page_meta_title}', '{$page_meta_description}', '{$page_meta_keywords}','" . nl2br($page_content) . "', '{$show_on_page}', '{$sort_order}')", "contentspagetemplate");
$dbobj->disconnectDB();
}
function AddProperty()
{
$dbobj = new Cdb(SERVER, DBNAME, DBUSER, DBPASS);
$dbobj->connectDB();
$folder = "images/productimages/";
move_uploaded_file($_FILES["productimage"]["tmp_name"], "{$folder}" . $_FILES["productimage"]["name"]);
move_uploaded_file($_FILES["productimage1"]["tmp_name"], "{$folder}" . $_FILES["productimage1"]["name"]);
move_uploaded_file($_FILES["productimage2"]["tmp_name"], "{$folder}" . $_FILES["productimage2"]["name"]);
move_uploaded_file($_FILES["productimage3"]["tmp_name"], "{$folder}" . $_FILES["productimage3"]["name"]);
move_uploaded_file($_FILES["productimage4"]["tmp_name"], "{$folder}" . $_FILES["productimage4"]["name"]);
//move_uploaded_file($_FILES["LogoImage"]["tmp_name"] ,"$folder".$_FILES["LogoImage"]["name"]);
if ($_REQUEST["imgNew"]) {
$logoimage = "new_tiny.gif";
} elseif ($_REQUEST["imgAvailableSoon"]) {
$logoimage = "available-soon_scriptred.jpg";
} elseif ($_REQUEST["imgSold"]) {
$logoimage = "sold_ani.gif";
} elseif ($_REQUEST["imgUnderContract"]) {
$logoimage = "undercontract.gif";
} elseif ($_REQUEST["imgOwnerFinancing"]) {
$logoimage = "ownerfinancing.gif";
} elseif ($_REQUEST["imgDepositTaken"]) {
$logoimage = "deposittaken.gif";
} elseif ($_REQUEST["imgBackOnTheMarket"]) {
$logoimage = "backonthemarket.gif";
}
$dbobj->writeToDB("(CategoryID,Address,SalePrice,RentPrice,ProductDescription,\n\t\t\t\t\t\t\t\t\tMonthlyRentCredit,ProductImage,ProductImage1,ProductImage2,ProductImage3,ProductImage4,LogoImage,\n\t\t\t\t\t\t\t\t\tType,Bedrooms,FullBathrooms,HalfBathrooms,Levels,Parking,Contact,ParkingSpaces,SqFtTotal,SqFtUNFinished\n\t\t\t\t\t\t\t\t\t,SqFtFinished,LotSizeAcres,Direction\n\t\t\t\t\t\t\t\t\t,City\n\t\t\t\t\t\t\t\t\t,ZipCode\n\t\t\t\t\t\t\t\t\t,CompanyName\n\t\t\t\t\t\t\t\t\t,FirstName\n\t\t\t\t\t\t\t\t\t,LastName\n\t\t\t\t\t\t\t\t\t,EmailAddress\n\t\t\t\t\t\t\t\t\t,PhoneNumber\n\t\t\t\t\t\t\t\t\t,FaxNumber\n\t\t\t\t\t\t\t\t\t,Basement\n\t\t\t\t\t\t\t\t\t,EmailBlastText\n\t\t\t\t\t\t\t\t\t,UserID\n\t\t\t\t\t\t\t\t\t,desc1\n\t\t\t\t\t\t\t\t\t,desc2\n\t\t\t\t\t\t\t\t\t,desc3\n\t\t\t\t\t\t\t\t\t,desc4\n\t\t\t\t\t\t\t\t\t,desc5\n\t\t\t\t\t\t\t\t\t,desc6\n\t\t\t\t\t\t\t\t\t,desc7\n\t\t\t\t\t\t\t\t\t,desc8\n\t\t\t\t\t\t\t\t\t,desc9\n\t\t\t\t\t\t\t\t\t,desc10\n\t\t\t\t\t\t\t\t\t,desc11\n\t\t\t\t\t\t\t\t\t,headline\n\t\t\t\t\t\t\t\t\t,estimaterepairs\n\t\t\t\t\t\t\t\t\t,saleaddress1\n\t\t\t\t\t\t\t\t\t,soldprice1\n\t\t\t\t\t\t\t\t\t,saleaddress2\n\t\t\t\t\t\t\t\t\t,soldprice2\n\t\t\t\t\t\t\t\t\t,saleaddress3\n\t\t\t\t\t\t\t\t\t,soldprice3\n\t\t\t\t\t\t\t\t\t,rentaddress1\n\t\t\t\t\t\t\t\t\t,rentprice1\n\t\t\t\t\t\t\t\t\t,rentaddress2\n\t\t\t\t\t\t\t\t\t,rentprice2\n\t\t\t\t\t\t\t\t\t,rentaddress3\n\t\t\t\t\t\t\t\t\t,rentprice3\n\t\t\t\t\t\t\t\t\t,salemis1\n\t\t\t\t\t\t\t\t\t,salemis2\n\t\t\t\t\t\t\t\t\t,salemis3\n\t\t\t\t\t\t\t\t\t,rentmis1\n\t\t\t\t\t\t\t\t\t,rentmis2\n\t\t\t\t\t\t\t\t\t,rentmis3\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\t\t\tVALUES\n\t\t\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\t\t\t'" . $_REQUEST["CategoryID"] . "','" . $_REQUEST["Address"] . "','" . $_REQUEST["SalePrice"] . "'\n\t\t\t\t\t\t\t\t\t\t,'" . $_REQUEST["RentPrice"] . "','" . $_REQUEST["Comments"] . "',\n\t\t\t\t\t\t\t \t\t\t'" . $_REQUEST["MonthlyRentCredit"] . "','" . $_FILES['productimage']['name'] . "','" . $_FILES['productimage1']['name'] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_FILES['productimage2']['name'] . "','" . $_FILES['productimage3']['name'] . "','" . $_FILES['productimage4']['name'] . "',\n\t\t\t\t\t\t\t \t\t\t'" . $logoimage . "','" . $_REQUEST["Type"] . "',\n\t\t\t\t\t\t\t \t\t\t'" . $_REQUEST["Bedrooms"] . "','" . $_REQUEST["FullBathrooms"] . "','" . $_REQUEST["HalfBathrooms"] . "',\n\t\t\t\t\t\t\t \t\t\t'" . $_REQUEST["Levels"] . "','" . $_REQUEST["Parking"] . "','" . $_REQUEST["Contact"] . "','" . $_REQUEST["ParkingSpaces"] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST["SqFtTotal"] . "','" . $_REQUEST["SqFtUNFinished"] . "','" . $_REQUEST["SqFtFinished"] . "','" . $_REQUEST["LotSizeAcres"] . "','" . $_REQUEST["Direction"] . "'\n\t\t\t\t\t\t\t \t\t\t\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST["City"] . "','" . $_REQUEST["ZipCode"] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST["CompanyName"] . "','" . $_REQUEST["FirstName"] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST["LastName"] . "','" . $_REQUEST["EmailAddress"] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST["PhoneNumber"] . "','" . $_REQUEST["FaxNumber"] . "','" . $_REQUEST['Basement'] . "','" . trim($_REQUEST['EmailBlastText']) . "','" . $_SESSION['USER_ID'] . "'\n\t\t\t\t\t\t\t \t\t\t\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST['desc1'] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST['desc2'] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST['desc3'] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST['desc4'] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST['desc5'] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST['desc6'] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST['desc7'] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST['desc8'] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST['desc9'] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST['desc10'] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST['desc11'] . "'\n\t\t\t\t\t\t\t \t\t\t\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST['headline'] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST['estimaterepairs'] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST['saleaddress1'] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST['soldprice1'] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST['saleaddress2'] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST['soldprice2'] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST['saleaddress3'] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST['soldprice3'] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST['rentaddress1'] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST['rentprice1'] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST['rentaddress2'] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST['rentprice2'] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST['rentaddress3'] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . $_REQUEST['rentprice3'] . "'\n\t\t\t\t\t\t\t \t\t\t,'" . trim($_REQUEST['salemis1']) . "'\n\t\t\t\t\t\t\t \t\t\t,'" . trim($_REQUEST['salemis2']) . "'\n\t\t\t\t\t\t\t \t\t\t,'" . trim($_REQUEST['salemis3']) . "'\n\t\t\t\t\t\t\t \t\t\t,'" . trim($_REQUEST['rentmis1']) . "'\n\t\t\t\t\t\t\t \t\t\t,'" . trim($_REQUEST['rentmis2']) . "'\n\t\t\t\t\t\t\t \t\t\t,'" . trim($_REQUEST['rentmis3']) . "'\n\t\t\t\t\t\t\t \t\t\t\n\t\t\t\t\t\t\t \t\t)", "products");
}
