projects
/
infodrom.org
/
service.infodrom.org
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
15a2bfc
)
Use ID instead of OID for activity
author
Joey Schulze
<joey@infodrom.org>
Tue, 26 Aug 2008 18:07:52 +0000
(18:07 +0000)
committer
Joey Schulze
<joey@infodrom.org>
Tue, 26 Aug 2008 18:07:52 +0000
(18:07 +0000)
src/Infodrom/logbook/edit.wml
patch
|
blob
|
history
diff --git
a/src/Infodrom/logbook/edit.wml
b/src/Infodrom/logbook/edit.wml
index
fe165d4
..
1e9fe2a
100644
(file)
--- a/
src/Infodrom/logbook/edit.wml
+++ b/
src/Infodrom/logbook/edit.wml
@@
-8,9
+8,9
@@
pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
- if ($_GET[
oid
] > 0) {
- $query = sprintf ("SELECT
* FROM logbook WHERE oid = %d", $_GET[oid
]);
- $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!
"
);
+ if ($_GET[
'id'
] > 0) {
+ $query = sprintf ("SELECT
oid,* FROM logbook WHERE id = '%s'", $_GET['id'
]);
+ $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!
".$query
);
if (pg_NumRows ($sth) > 0) {
$row = pg_fetch_array ($sth, 0);
if (pg_NumRows ($sth) > 0) {
$row = pg_fetch_array ($sth, 0);
@@
-26,7
+26,7
@@
?>
<form method=post action="update.php">
?>
<form method=post action="update.php">
-<input type=hidden name=oid value="<? echo $
_GET[oid
]; ?>">
+<input type=hidden name=oid value="<? echo $
row['oid'
]; ?>">
<b>Category:</b> <select name=category><?
$sth = pg_exec ($dbh, "SELECT DISTINCT category FROM logbook ORDER BY category") or die("Datenbank-Abfrage!");
for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
<b>Category:</b> <select name=category><?
$sth = pg_exec ($dbh, "SELECT DISTINCT category FROM logbook ORDER BY category") or die("Datenbank-Abfrage!");
for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
@@
-39,11
+39,11
@@
<b>Text:</b> <br><textarea name=body rows=16 cols=79><? echo str_replace ("&", "&", $row['body']); ?></textarea><p>
<b>Public:</b> <input name=public type=checkbox value="1" <? if ($row['public']==1) { echo "checked";} ?>><br>
<b>Text:</b> <br><textarea name=body rows=16 cols=79><? echo str_replace ("&", "&", $row['body']); ?></textarea><p>
<b>Public:</b> <input name=public type=checkbox value="1" <? if ($row['public']==1) { echo "checked";} ?>><br>
-<? if ($_GET[
oid
] > 0) { ?>
+<? if ($_GET[
'id'
] > 0) { ?>
<b>Created:</b> <? echo $date; ?><br>
<? } ?>
<b>Created:</b> <? echo $date; ?><br>
<? } ?>
-<p><center><input type=submit value="<? echo $_GET[
oid
]>0?"Update":"Insert"; ?>">\
+<p><center><input type=submit value="<? echo $_GET[
'id'
]>0?"Update":"Insert"; ?>">\
<input type=reset value="Reset"></center><p>
</form>
<input type=reset value="Reset"></center><p>
</form>