Viewing file:  index.php (8.2 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?
include("../include/settings");
include("../include/db_connect");
//get the relevant data based on settings (which features to include, existing database entries, etc.
if ($listings_option){
$property_query = mysql_query("SELECT ID, title, type, year, month, active FROM listings ORDER BY active desc, year desc, month desc", $db);
$property_rows = mysql_num_rows($property_query);
if ($property_rows > 0){
for ($count = 0; $count < $property_rows; $count++){
$type = mysql_result($property_query, $count, 'type');
$ID = mysql_result($property_query, $count, 'ID');
$title = mysql_result($property_query, $count, 'title');
$active = mysql_result($property_query, $count, 'active');
$property_list[]= array("ID" => $ID, "title" => $title, "type" => $type, "active" => $active);
}
}//end of if $property_rows...
}//end of if $listings...
if ($feature_option){
$feature_query = mysql_query("SELECT ID, title FROM feature ORDER BY start_date desc", $db);
$feature_rows = mysql_num_rows($feature_query);
if ($feature_rows > 0){
for ($count = 0; $count < $feature_rows; $count++){
$ID = mysql_result($feature_query, $count, 'ID');
$title = mysql_result($feature_query, $count, 'title');
$feature_list[]= array("ID" => $ID, "title" => $title);
}
}//end of if $feature_rows...
}//end of if $feature...
if ($client_option){
$client_query = mysql_query("SELECT ID, title, client FROM client ORDER BY client, ID desc", $db);
$client_rows = mysql_num_rows($client_query);
if ($client_rows > 0)
{
for ($count = 0; $count < $client_rows; $count++)
{
$mclient = mysql_result($client_query, $count, 'client');
$ID = mysql_result($client_query, $count, 'ID');
$title = mysql_result($client_query, $count, 'title');
$client_list[]= array("ID" => $ID, "title" => $title, "client" => $mclient);
$loop_number = count($clients);
for ($counter = 0; $counter <= $loop_number; $counter++)
{
$add = "yes"; //reset $add
$name = $clients["$counter"]; //get current name in array
if ($mclient == $name) //compare it to client from database
{
$add = "no"; //match? set $add to "no" and break loop
break;
}
}
if ($add == "yes") $clients[] = "$mclient"; //if no match, add to new array
}//end of outer for loop
}//end of if $client_rows
}// end of if $client...
if ($resources_option){
$categories_query = "SELECT * FROM categories ORDER BY category";
$categories = mysql_query($categories_query, $db);
while ($rows = mysql_fetch_array($categories)){
$category_array[] = "$rows[category]";
}
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title><?print($client['name'] ." | Administrative Area");?></title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
<table border="2" bordercolor="#222244" cellpadding="0" cellspacing="0" align="center"><tr><td>
<table align="center" border="0"cellpadding="0" cellspacing="0"><tr><td><br><p align="center"><b>Hello <?print($client['name']);?></b> <br>Please select from the options below<br><hr width="60%" size="1" noshade><br>
<?
/**************************************
LISTINGS?
**************************************/
if ($listings_option){
print("<U>PROPERTY LISTINGS</U><br>\n");
print("<p><a href=\"property_form.php\">Create a new property listing</a>\n");
if ($property_rows > 0)
{
print("<p><i>Modify one of the following property listings:</i><br>\n");
for ($count = 0; $count < $property_rows; $count++)
{
$title = $property_list[$count]["title"];
$ID = $property_list[$count]["ID"];
if ($property_list[$count]["active"] == "yes") $active = "Active";
else $active = "Hidden";
print("\t\t<p style=\"margin-left: 40px\">$active: <a href=\"property_form.php?ID=$ID\">$title</a>\n");
}
}
print("<br> <hr width=\"80%\" align=\"left\" size=\"1\" noshade>\n");
print("<br>\n");
} //end of if $listings_option
/**************************************
CLIENT PAGE?
**************************************/
if ($client_option){
print("<U>CLIENT EXTRANET</U><br>\n");
print("<p><i><a href=\"client_form.php\">Create a new Client Page</a></i><br>\n");
if ($client_rows > 0)
{
print("<p><i>Add a new picture set to an existing Client Page:<br><p style=\"margin-left: 40px\">Clients:<br></i><br>\n");
$unique_clients = count($clients);
for ($count = 0; $count < $unique_clients; $count++)
{
$URLmclient = urlencode($clients[$count]);
$underscore = ereg_replace(" ", "_", $clients[$count]);
$mclient = $clients[$count];
$domain = $client['domain'];
print("\t\t<p style=\"margin-left: 50px\"> <b><a href=\"client_form.php?mclient=$URLmclient\">$mclient</a></b><br>\n");
print("\t\t<br> URL: <a href=\"http://$domain/c.php?c=$underscore\" target=\"_blank\">http://$domain/c.php?c=$underscore</a><br>\n");
}
print("<p><i>Modify an existing Client Picture Set:</i><br>\n");
for ($count = 0; $count < $client_rows; $count++)
{
$mclient = $client_list[$count]["client"];
$title = $client_list[$count]["title"];
$ID = $client_list[$count]["ID"];
print("\t\t<p style=\"margin-left: 40px\">$mclient: <a href=\"client_form.php?ID=$ID\">$title</a>\n");
}
print("<br> <hr width=\"80%\" align=\"left\" size=\"1\" noshade>\n");
}
print("<br>\n");
}//end of if $client_option...
/**************************************
FEATURE?
**************************************/
if ($feature_option){
print("<U>FEATURE ARTICLE</U><br>\n");
print("<p><a href=\"feature_form.php\">Create a new feature article</a><br>\n");
if ($feature_rows > 0)
{
print("<p><i>Modify one of the following feature articles:</i><br>\n");
for ($count = 0; $count < $feature_rows; $count++)
{
$title = $feature_list[$count]["title"];
$ID = $feature_list[$count]["ID"];
print("\t\t<p style=\"margin-left: 40px\"><a href=\"feature_form.php?ID=$ID\">$title</a>\n");
}
}
}
print("<br> <hr width=\"80%\" align=\"left\" size=\"1\" noshade>\n");
/**************************************
E-MAIL LIST?
**************************************/
if ($email_option){
print("<U>E-MAIL SUBSCRIPTION MANAGER</U><br>\n");
print("<p><a href=\"e-mail_form.php\">Add new e-mail subscriber</a><br>\n");
print("<p><a href=\"print_list.php\">Print list of e-mail addresses for mailing</a><br>\n");
print("<p><a href=\"print_list.php?type=update\">Change or delete e-mail recipient</a><br>\n");
print("<p><a href=\"send_email.php\">Send e-mail to list</a>");
print("<br> <hr width=\"80%\" align=\"left\" size=\"1\" noshade>\n");
}
/**************************************
RESOURCE DATABASE?
**************************************/
if ($resources_option){
print("<form action=\"resources_list.php\">\n");
print("<U>RESOURCES DATABASE</U><br>\n");
print("<p><a href=\"resources_form.php\">Add a new entry to the resources database</a><br>\n");
print("<p>Modify or delete an entry from <select name=\"modify_category\">\n");
for ($i = 0; $i < count($category_array); $i++){
print("<option>$category_array[$i]</option>\n");
}
print("</select> <input type=\"submit\" name=\"submit\" value=\"Update listing\">\n");
print("<br><br>\n");
print("Create a new Category: <input type=\"text\" name=\"new_category\" size=\"20\">\n");
print(" <input type=\"submit\" name=\"submit\" value=\"New category\"><br><br>\n");
print("<p>Delete The <i>Entire</i> <select name=\"delete_category\">\n");
for ($i = 0; $i < count($category_array); $i++){
print("<option>$category_array[$i]</option>\n");
}
print("</select> category <input type=\"submit\" name=\"submit\" value=\"Delete category!\">\n");
print("<br> \n");
print("<br> <hr width=\"80%\" align=\"left\" size=\"1\" noshade>\n");
print("</form>\n");
}
?>
</td></tr></table>
</td></tr></table>
</body>
</html>
|