summary |
shortlog |
log |
commit | commitdiff |
tree
raw |
patch |
inline | side by side (from parent 1:
b61b121)
status mod time to be changed
allow hosts to be entered with status = RESERVED
/* status checking */
value = atoi(argv[7+row]);
/* status checking */
value = atoi(argv[7+row]);
- if (row == 0 && !(value == 1 || value == 3))
+ if (row == 0 && !(value == 1 || value == 0))
return(MR_TYPE);
if (row == 1) {
id = *(int *)argv[0];
EXEC SQL SELECT status INTO :cnt FROM machine WHERE mach_id = :id;
if (ingres_errno) return(mr_errcode);
if (value != cnt) {
return(MR_TYPE);
if (row == 1) {
id = *(int *)argv[0];
EXEC SQL SELECT status INTO :cnt FROM machine WHERE mach_id = :id;
if (ingres_errno) return(mr_errcode);
if (value != cnt) {
- EXEC SQL UPDATE machine SET statuschange = date('now');
+ EXEC SQL UPDATE machine SET statuschange = date('now')
+ WHERE mach_id = :id;