</td></tr> <tr class="dbClientStyle"> <td class="monoLit" style="padding: 16px 16px 16px 16px; color: #FFFFFF;"> ACTIVITY <img src="<?php echo $dbAdmin; ?> MEDIA/org_activity.gif" width="64" heigh="16" alt="ORG Activity" style="background-color: #<?php echo $dbColor2; ?> ;" /> <?php $dbUptime = floor((time() - $dbStart) / 3600 * 100) / 100; echo "UPTIME " . $dbUptime . "H. "; /* $sql = "SELECT DISTINCT ip FROM log"; $result = MYSQL_QUERY($sql); $dbRequests = MYSQL_NUM_ROWS($result); echo "UNIQUE ". $dbRequests. ". "; */ echo "<a href='" . $dbAdmin . "info.php'>INFO</a> "; echo "<a href='" . $dbAdmin . "report.php" . urlData() . "'>GENERATE ></a>"; ?> </td></tr> </table> </div></td></tr></table> </body> </html>
$address1 = addslashes($address1);
$city = addslashes($city);
$state = addslashes($state);
$zip = addslashes($zip);
$country = addslashes($country);
$phone = addslashes($phone);
$email = addslashes($email);
$begin = addslashes($begin);
$end = addslashes($end);
$body = addslashes($body);
$notes = addslashes($notes);
}
// Process variables
if (!$name1) {
$name1 = "Untitled";
}
$begin = $begin ? date("Y-m-d H:i:s", strToTime($begin)) : NULL;
$end = $end ? date("Y-m-d H:i:s", strToTime($end)) : NULL;
// Add object to database
$sql = "INSERT INTO objects (\n\t\t\tcreated, modified, \n\t\t\tname1, name2, \n\t\t\taddress1, city, state, zip, country, \n\t\t\tphone, email, \n\t\t\tbegin, end, \n\t\t\tbody, notes) \n\t\tVALUES ('" . date("Y-m-d H:i:s") . "', '" . date("Y-m-d H:i:s") . "', \n\t\t\t'{$name1}', '{$name2}', \n\t\t\t'{$address1}', '{$city}', '{$state}', '{$zip}', '{$country}', \n\t\t\t'{$phone}', '{$email}', \n\t\t\t'{$begin}', '{$end}', \n\t\t\t'{$body}', '{$notes}'\n\t\t)";
$result = MYSQL_QUERY($sql);
$insertId = MYSQL_INSERT_ID();
/////////////
// WIRES //
/////////////
$sql = "INSERT INTO wires (\n\t\t\tcreated, modified, \n\t\t\tfromid, toid\n\t\t) \n\t\tVALUES('" . date("Y-m-d H:i:s") . "', '" . date("Y-m-d H:i:s") . "', \n\t\t\t'{$object}', '{$insertId}'\n\t\t)";
$result = MYSQL_QUERY($sql);
echo "Object added successfully.<br /><br />";
echo "<a href='" . $dbAdmin . "browse.php" . urlData() . "'>CONTINUE...</a>";
}
require_once "GLOBAL/foot.php";
$z .= "phone='{$phone}', ";
}
if ($myrow["email"] != $email) {
$z .= "email='{$email}', ";
}
if ($myrow["begin"] != $begin) {
$z .= $begin ? "begin ='{$begin}', " : "begin = null, ";
}
if ($myrow["end"] != $end) {
$z .= $end ? "end ='{$end}', " : "end = null, ";
}
if ($myrow["body"] != $body) {
$z .= "body='{$body}', ";
}
if ($myrow["notes"] != $notes) {
$z .= "notes='{$notes}', ";
}
// Update edited fields only
if ($z) {
$sql = "UPDATE objects SET " . $z . "modified='" . date("Y-m-d H:i:s") . "' WHERE id = '{$object}'";
$result = MYSQL_QUERY($sql);
}
// Job well done?
if ($z || $m) {
echo "Successfully updated.<br />";
} else {
echo "Nothing was edited, therefore update not required.<br />";
}
echo "<br /><br /><a href='" . $dbAdmin . "edit.php" . urlData() . "'>REFRESH OBJECT</a><br /> ";
}
require_once "GLOBAL/foot.php";
$padout = floor(log10($numrows)) + 1;
if ($padout < 2) {
$padout = 2;
}
echo "\nThe following " . $k . " objects will also be deleted as a result: <br /><br />";
for ($i = 0; $i < $j; $i++) {
$l++;
if ($connectedAll[$i]["dependent"] == TRUE) {
echo "\n" . STR_PAD($l, $padout, "0", STR_PAD_LEFT) . " <a href='" . $dbAdmin . "browse.php" . urlData() . "," . $connectedAll[$i]["id"] . "'>" . strip_tags($connectedAll[$i]["name"]) . "</a><br />";
}
}
}
?>
<br /><br />
<form action="<?php
echo $PHP_SELF . urlData();
?>
" method="post" style="padding: 0px 0px 0px 0px; margin: 0px 0px 0px 0px;">
<input name='action' type='hidden' value='delete' />
<input name='cancel' type='button' value='Cancel' onClick="javascript:history.back();" />
<input name='submit' type='submit' value='Delete Object' />
</form><br />
<?php
} else {
// Get wire that goes to this object to be deleted
if (sizeof($objects) < 2) {
$fromObject = 0;
} else {
$fromObject = $objects[sizeof($objects) - 2];
}
$sql = "SELECT * FROM wires WHERE toid = '{$object}' AND fromid = '{$fromObject}' AND active = '1' LIMIT 1";
require_once "GLOBAL/head.php";
////////////////////////
// Attached Objects //
////////////////////////
// Get attached objects (if any)
$sql = "SELECT *, objects.id AS objectsId FROM objects, wires WHERE wires.fromid = '" . $objects[$o] . "' AND wires.toid = objects.id AND wires.active = '1' AND objects.active = '1' ORDER BY weight DESC, objects.rank, end DESC, begin DESC, name1, name2, objects.modified DESC, objects.created DESC";
$result = MYSQL_QUERY($sql);
$numrows = MYSQL_NUM_ROWS($result);
$padout = floor(log10($numrows)) + 1;
if ($padout < 2) {
$padout = 2;
}
$i = 1;
$myrow["id"] = $myrow["objectsId"];
while ($myrow = MYSQL_FETCH_ARRAY($result)) {
$name = $myrow["name1"];
if ($myrow["name2"]) {
$name .= " " . $myrow["name2"];
}
if (strlen($name) > 60) {
$name = substr($name, 0, 60) . "...";
}
echo STR_PAD($i++, $padout, "0", STR_PAD_LEFT) . " " . "\n<a href='" . $dbAdmin . "browse.php" . urlData();
if (sizeof($objects)) {
echo ",";
}
echo $myrow["objectsId"] . "'>";
echo strip_tags($name) . "</a><br />";
}
echo "\n<br /><br />\n<a href='add.php" . urlData() . "'>ADD OBJECT...</a> <a href='link.php" . urlData() . "'>LINK ...</a><br />";
require_once "GLOBAL/foot.php";
if ($myrow["name2"]) {
$objectName .= " " . $myrow["name2"];
}
$objectName = strip_tags($objectName);
echo "\n\n\n<!-- " . $objectName . " -->\n\n";
echo "<tr class='button' style='background-color: #";
echo $o % 2 ? "ECECEC" : "E3E3E3";
echo ";'>";
echo "\n<td style='padding: 16px 16px 16px 16px;'>";
if ($object) {
echo "\n<span class='monoHvy'>";
if ($pageName != "browse") {
echo "<a href='browse.php" . urlData() . "'>";
}
echo $objectName;
if ($pageName != "browse") {
echo "</a>";
}
echo "</span> ";
if ($pageName == "browse") {
echo "\n<a href='edit.php" . urlData() . "'>EDIT...</a> ";
echo "\n<a href='delete.php" . urlData() . "'>DELETE...</a><br />";
}
if ($pageName != "edit" && $pageName != "delete") {
echo "\n</td></tr><tr style='background-color: #";
echo ($o + 1) % 2 ? "ECECEC" : "E3E3E3";
echo ";'>";
echo "\n<td style='padding: 16px 16px 16px 16px;'>";
}
}
}
