"; echo "
"; ?>


"; echo "

"; echo ""; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; // build SQL query to get node data $sql = "SELECT time, success, user, action, comment FROM logs "; if ($timeframe == "today") { $sql .= "WHERE TO_DAYS(NOW()) - TO_DAYS(time) = 0"; } elseif ($timeframe == "week") { $sql .= "WHERE TO_DAYS(NOW()) - TO_DAYS(time) <= 7"; } elseif ($timeframe == "month") { $sql .= "WHERE TO_DAYS(NOW()) - TO_DAYS(time) <= 30"; } $sql .= " ORDER BY $sort_by $order"; // run query $loc_db->query($sql); $counter = 1; // loop for each node in the db while($loc_db->next_record()) { if ($loc_db->f("success")) { $tr_class = "success"; } else { $tr_class = "error"; } echo ""; echo " "; echo " "; echo " "; echo " "; echo " "; echo ""; $counter++; } echo ""; echo "
TimeUserActionComment
" . $counter . "" . $loc_db->f( "time" ) . "" . $loc_db->f( "user" ) . "" . $loc_db->f( "action" ) . "" . $loc_db->f( "comment" ) . "
"; } ?>