MOT Script 2.0.b3

MOT is a generally useful web database that can be used to create web-based databases without writing a single line of code (sql, php, or html!).Features::- The ability to create and modify databases, tables, fields, and permissions, all from a point and click, web interface.- Support for links between tables. Jobs may be linked to users, equipment, and software. People may be linked to department, companies, contacts, and machines.- Support for multiple users and read, add, and modify permissions for each user for each table.- Support for sorting and restricting every table to a fully configurable set of fields (sort a list of jobs by priority, close date, or tech, or restrict the same list of jobs to a specified contact).- Support for actions, which are custom scripts automatically fired by specified database actions (adds, modifications, etc.). This is immensely helpful for implementing things like email notification and timestamping.- Basic support for writing custom sql queries. This will eventually include a custom query page but is very helpful now in the creation of actions. A sample mot_sql query that joins three tables together and grabs a value from the third table looks like:select {People}.[email] from {Jobs} where {Jobs}.[id] = $row_id- Support for importing and exporting database schemas.- Support for database-specific help files. All you have to do is write the text.- Basic searching capabilities.- CSS support for configuring the interface.

Requirements:	No special requirements
Platforms:	PHP
Keyword:	Actions,  Basic,  Create,  Custom,  Database,  Databases,  Fields,  Helpful,  Interface,  Linked,  Modify,  Permissions,  Query,  Support,  Table,  Tables,  Users,  Writing
Users rating:	0/10