Rev 635 | Rev 1050 | Go to most recent revision | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed
Rev 635 | Rev 790 | ||
---|---|---|---|
Line 51... | Line 51... | ||
51 | $res = OIDplus::db()->query("select lo.id, lo.unix_ts, lo.addr, lo.event, lu.severity from ###log lo ". |
51 | $res = OIDplus::db()->query("select lo.id, lo.unix_ts, lo.addr, lo.event, lu.severity from ###log lo ". |
52 | "left join ###log_object lu on lu.log_id = lo.id ". |
52 | "left join ###log_object lu on lu.log_id = lo.id ". |
53 | "where lu.object = ? " . |
53 | "where lu.object = ? " . |
54 | "order by lo.unix_ts desc", array($id)); |
54 | "order by lo.unix_ts desc", array($id)); |
55 | $text .= '<h2>'._L('Log messages for object %1',htmlentities($id)).'</h2>'; |
55 | $text .= '<h2>'._L('Log messages for object %1',htmlentities($id)).'</h2>'; |
56 | if ($res->num_rows() > 0) { |
56 | if ($res->any()) { |
57 | $text .= '<pre>'; |
57 | $text .= '<pre>'; |
58 | while ($row = $res->fetch_array()) { |
58 | while ($row = $res->fetch_array()) { |
59 | $users = array(); |
59 | $users = array(); |
60 | $res2 = OIDplus::db()->query("select username, severity from ###log_user ". |
60 | $res2 = OIDplus::db()->query("select username, severity from ###log_user ". |
61 | "where log_id = ?", array($row['id'])); |
61 | "where log_id = ?", array($row['id'])); |