UTILITIES

Basic PHP Security Script

Summary

I've been reviewing some of my older code to ensure it remains efficient and secure. I found a login handler that was top of the line a few years ago and have been making major changes to it recently. I've been testing it live here. The handler code is here

Tools

PHP with a mySQL backend.

PHP Forum (currently building)

Summary

As part of a freelance project I am developing a forum so registered users can communicate with the consultant(s) and each other. So far there isn't much by way of design but it's coming together nicely. It is alive so if you'd like to test and give feedback please do so.

Tools

Coded primarily with PHP with a mySQL backend. Also utilizes AJAX to re-poll database for new messages without reloading the page.

Telecom Extension Viewer

Summary

This tool allows Telecom administrators to add new icons for equipment and click and drag tham to a location on any of several maps. A JavaScript allows the drop functionality and the coordinates for the icon's final location are posted to a database. When the map is viewed by the end users it shows the icon for the partucular equipment in the recorded location and also posts extension or other relevent data on hover. There are also a few other features that make this a useful application for the entire company.

Tools

This utility uses a combination of PERL and JavaScript with a database backend.

Quick Tool Checker

Summary

A useful troublshooting tool for my current team and other departments. It allows us to connect easily to other utilities which allow us to view data and also run utilities to resolve issues remotely.

Tools

This harnesses a combination of PERL and PHP.

Basic Data Entry Interface

Summary

This is a simple but very effective interface for adding, updating, and otherwise maintaining data in a database. The instance displayed shows it being used to maintain a running list of extensions, but it can be easily adapted to work with any sort of data.

Tools

PHP with a MySQL database backend

Status Board

Summary

This was created by request of the National Guard to track and post information during deployments. It is still in a developmental stage and there are plans to make the utility more robust by adding and improving upon its features.

Tools

This was created with PERL and JavaScript with a MySQL database backend.

Database Transaction Log Monitor

Summary

This simple utility helps us carefully watch the log files on dsatabases to ensure they aren't filling up too quickly indicating a problem and could result in database blocking. It runs a stored procedure and converts the data into a graphical representation.

Tools

This is written in PERL and AJAX.

Online Chat Room

Summary

We use a similar tool in our area to communicate and post data during large scale events. Not completely satisfied with what we are/were using I decided to create my own chat utility. It may not be released for official use at my current job but it has seen some use in my unit in National Guard where the network is so locked down that it will not permit any instant messenger type communication.

Tools

PERL, JavaScript, and AJAX with a MySQL database backend were used to build this utility. I'm considering converting it to PHP for fun and to see if there are any performance gains by doing so.

Computer Based Training (CBT)

Summary

Another project implemented for the National Guard. The goal is to reduce the amount of paperwork and time training by making more training available online. Shown in the image is the first page but it does actually calculate and provide a score based on the parameters and questions provided by whomever authors the test.

Tools

This was created using PERL and JavaScript and has a MySQL database backend.