Displaying content on this site starts of course with the database much like any other site. It differs a bit on how data comes from the database. The file ‘alltable.asp’ is dynamic so if data is to be displayed on the page conventionally you need nothing else. It will read the structure of the tables and automatically create forms on the fly. Things like field size and type are error handled by this file, no need for miles of error handling for the normal stuff. Applications like news, profiles, permissions, application settings, ad rotation, are set up in minutes, just create the table and your off and running.
Of course database tables aren’t user friendly, so the use of the ‘tableconfig.asp’ file is used to make data more digestible for any surfers. Things like dropdown menus, double validation, or enabling fields are configured here.
Permissions are ultra simple and are set by the use of three tables in the database. First the user table holds all the normal data in respect to user information just like any other site. The applications table holds application data and settings for each application registered in your website. Finally we have the permissions table that links these together. You can set permissions at the application level by giving all surfers access, or you can deny surfer level access and bring access to the user level. The ‘alltable.asp’ of course handles all three of these tables for ease of use. Of course menu options are customized for the access you have, no need to show buttons you don’t have access to.
Website tracking is all inclusive no one can sneeze without it being recorded in the session or activity logs. Activities like logging in adding a record, or editing a profile are all shoved in sessions each session can be looked at queried and reported on.
Reporting is an awesome feature here. Anything in the database can be reported on in multiple ways through the ‘reporting.asp’ file. Like the ‘alltable.asp’ file it is dynamic and grabs table structures. Pareto type bar charts and custom query builders make it easy to generate reports. Functions also include creating query string links that enable a webmaster to create a report, then post a link anywhere for surfers to see the report. For example the 'Site Statistics' button to the left leads you to some differnet reports.