Modules: Adminer 3.1 Beta 1 for XOOPS 2.5.8 & PHP 7 Released

Posted by: Mambaon 2016/7/19 21:10:00 4349 reads
Resized Image

The Adminer Module provides SQL Management for XOOPS from inside the Admin Panel. It includes three tools:

a) Adminer

Connect to a database server with username and password
Select an existing database or create a new one
List fields, indexes, foreign keys and triggers of table
Change name, engine, collation, auto_increment and comment of table
Alter name, type, collation, comment and default values of columns
Add and drop tables and columns
Create, alter, drop and search by indexes including fulltext
Create, alter, drop and link lists by foreign keys
Create, alter, drop and select from views
Create, alter, drop and call stored procedures and functions
Create, alter and drop triggers
List data in tables with search, aggregate, sort and limit results
Insert new records, update and delete the existing ones
Supports all data types, blobs through file transfer
Execute any SQL command from a text field or a file
Export table structure, data, views, routines, databases to SQL or CSV
Print database schema connected by foreign keys
Show processes and kill them
Display users and rights and change them
Display variables with links to documentation
Manage events and table partitions (MySQL 5.1)
Schemas, sequences, user types (PostgreSQL)
Extensive customization options

b) Adminer Editor

Interface to select and edit data ready for your client
Table and column comments are displayed instead of identifiers
Separate set of login credentials different from the real database user and password
Single database per one instance of Editor
Links to referenced records
Works with the name of a referenced record, not its ID
Displays images stored in BLOB
Displays checkbox and icons for BOOL
Uses national format for DATE
Allows sending messages to e-mails found in table
No edit or display of SQL commands (only in HTML comment)

c) BigDump from Alexey Ozerov for import of large and very large MySQL Dumps (like phpMyAdmin dumps) even through the web servers with hard runtime limit and those in safe mode.

The module was originally developed by Kris_fr from XOOPS France, and now has been updated for XOOPS 2.5.8 and PHP 7

Download: GitHub

Development: GitHub

Tutorial: GitBook

You can contribute to the tutorial, as well as provide translation, on GitHub XOOPS Docs here

Check out XOOPS on GitHub: Let's Get involved!

Some of the changes in 3.1:

- Update: Adminer 4.2.5
- Update: Adminer editor 4.2.5
- Update: BigDump 0.36b
- added Admin GUI and moved the apps there
- renamed .html templates to .tpl (mamba)
- moved images to /assets
- added /help
- updated Adminer plugins
- added more Admine plugins: dump-bz2, dump-json, edit-calendar, FasterTableFilters
- Unnecessary double quotes