echo $myrow["body"];
?>
</textarea></td></tr>
<tr><td>TXN ID </td>
<td><textarea name='notes' cols='20' rows='1'><?php
echo $myrow["notes"];
?>
</textarea></td></tr>
</table>
<br /><br /><br />
<input name='action' type='hidden' value='update' />
<input name='cancel' type='button' value='Cancel' onClick="javascript:location.href='<?php
echo "browse.php" . urlBack();
?>
';" />
<input name='submit' type='submit' value='Update Object' />
</form><br />
<?php
}
} else {
/////////////////////
// UPDATE Object //
/////////////////////
$sql = "SELECT * FROM objects WHERE id = '{$object}' LIMIT 1";
$result = MYSQL_QUERY($sql);
$myrow = MYSQL_FETCH_ARRAY($result);
if (!get_magic_quotes_gpc()) {
$name1 = addslashes($name1);
// Column headers
$html .= "<tr style='background-color:#CCCCCC;'>";
$html .= "<td width='200px'>NAME</td>";
$html .= "<td width='300px'>ADDRESS</td>";
$html .= "<td width='300px'>EMAIL</td>";
$html .= "<td width='100px'>BEGIN / END</td>";
$html .= "</tr>";
// Data
while ($myrow = MYSQL_FETCH_ARRAY($result)) {
$html .= "<tr style='background-color:#" . ($rowcolor % 2 ? "E9E9E9" : "EFEFEF") . ";'>";
$html .= "<td>" . $myrow['name1'] . " " . $myrow['name2'] . "</td>";
$html .= "<td>" . $myrow['address1'] . "<br />" . $myrow['city'] . " " . $myrow['state'] . " " . $myrow['zip'] . "<br />" . $myrow['country'] . "</td>";
$html .= "<td>" . $myrow['email'] . "</td>";
$html .= "<td>" . date("Y M j", strToTime($myrow['begin'])) . "<br />" . date("Y M j", strToTime($myrow['end'])) . "</td>";
$html .= "</tr>";
$rowcolor++;
$rownumber++;
}
$html .= "</table>";
$html .= "<br />{$rownumber} total results found.";
echo $html;
}
echo "<br /><br />";
if ($report) {
echo "<a href='report.php?object={$object}&csv=1' target='_new'>EXPORT CSV . . .</a> ";
}
if ($report) {
echo "<a href='report.php?object={$object}&emails=1' target='_new'>EXPORT EMAILS . . .</a> ";
}
echo "<a href='browse.php" . urlBack() . "'>GO BACK . . .</a> ";
require_once "GLOBAL/foot.php";
<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";
$result = MYSQL_QUERY($sql);
$myrow = MYSQL_FETCH_ARRAY($result);
$thisWire = $myrow['id'];
// echo "This wire id = " . $thisWire . " and toid = " . $object . " and fromid = " . $fromObject;
// this was the old way of deleting an object, by setting objects.active = 0, but since 3.0 we only set the wires.active = 0
// $sql = "UPDATE objects SET active = '0' WHERE id = $object";
$sql = "UPDATE wires SET active = '0' WHERE id = '{$thisWire}'";
$result = MYSQL_QUERY($sql);
?>
<div class='monoHvy'>Deleted sucessfully.<br /><br />
<?php
echo "<a href='" . $dbAdmin . "browse.php" . urlBack() . "'>CONTINUE...</a>";
}
require_once "GLOBAL/foot.php";
