Beispiel #1
0
        echo $myrow["body"];
        ?>
</textarea></td></tr>

		<tr><td>TXN ID&nbsp; </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 />&nbsp;
		<?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);
Beispiel #2
0
    // 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>&nbsp;&nbsp;";
}
if ($report) {
    echo "<a href='report.php?object={$object}&emails=1' target='_new'>EXPORT EMAILS . . .</a>&nbsp;&nbsp;";
}
echo "<a href='browse.php" . urlBack() . "'>GO BACK . . .</a>&nbsp;&nbsp;";
require_once "GLOBAL/foot.php";
Beispiel #3
0
	<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 />&nbsp;
	<?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";