PHD Help Desk is software conceived for the registry and follow-up of help desks incidents. Registry of incidents allows classification in two levels (type and subtype), the state of the incident, a description, ticket assignment and priority, historical registry, and an audit. Information can be reported in consultation format, to give reports or export the information for later processing in a database or spreadsheet.
TbsSQL is a small wrapper class for working with SQL databases within PHP scripts. It has few methods and two properties and it’s only one file per database for installation. Its most interesting feature is that it can protect and format values before merging them into the SQL statement. It has a cache feature, a trace mode, a debug console, and it can return data as arrays, standard objects, specific class objects, or clone objects. It can also delete PHP connection variables after making the connection.
sqlmap is a penetration testing tool that automates the process of detecting and exploiting SQL injection flaws and taking over of database servers. It comes with a detection engine, many niche features, and a broad range of switches including database fingerprinting, data fetching from the database, and accessing the underlying file system and executing commands on the operating system via out-of-band connections.
SCMS is an MVC based secure content management system. It is designed from the ground up to withstand common Web application vulnerabilities such as SQL injection, XSS, CSRF, session fixation/hijacking, and many others. It is designed for PHP 5.0-5.2.x and MySQL 4.1+, and it can optionally support PostgreSQL as a database backend.
TYPOlight is a content management system (CMS) for people who want a professional Internet presence that is easy to maintain. The state-of-the-art structure of the system offers a high security standard and allows you to develop search engine friendly Web sites that are also accessible for people with disabilities. Furthermore, the system can be expanded flexibly and inexpensively. It features easy management of user rights, a Live Update Service, a modern CSS framework, and many already integrated modules (news, calendar, forms, etc.).
Large Database Backup is a class to back up large MySQL databases into multiple files. It can list the tables of a given MySQL database, and generate SQL statements to create and insert records with the current values of the table rows, as if it were creating a new database. The class stores the generated SQL statements in files. A full backup process can be split into multiple iterations so as to not exceed the PHP default script execution time limit. Each iteration dumps a limited number of table rows. An iteration can be executed by a script that redirects the page request to itself at the end to proceed to the next iteration.
Change Web Site Mode is a PHP class that can be used to switch the access to sites between test and production versions. Each Web site must have a copy of all files in the production server and in a test server. This class allows the user to switch between the two copies of the site without having to change the URL. It provides a GUI interface for switching between the test mode and production site. The test version may be run in the local machine or in another machine.
MP3 Management can be used to build a catalog of MP3 files in a MySQL database. It can traverse a given directory to find MP3 files. For each MP3 file that is found, it extracts its ID3 tags, including album art, and adds an entry in a MySQL database. The class also extracts 20 second clips of each MP3 file and stores them in a subdirectory named clips. The duration of the clips is configurable. The class is intended to be used with the Id3 Tag Correction and Downloading script, which corrects id3 tags and downloads lyrics, artist biographies, and other information using Web services and other Web sites.