</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;'>"; } } }