Add all remaining mysql user privileges options (SKINS)(LANG)

Version 1.48.1

Feature
Finished

Remaining User Privilege options added to MySQL User privileges section. Default directadmin.conf option: database_extended_user_privileges=1 can be set to 0 to hide the options below. If missing, they'll still be set to "Y" by default. If you have MySQL 5.1.6, then the token: DATABASE_EXTENDED_USER_PRIVILEGES will be set to 2. Setting the database_extended_user_privileges directadmin.conf option to 2 will have no effect on this, only the mysqld version. Add trigger checkbox to mysql user privileges page if mysql version >= 5.1.6. mysql.db The TRIGGER privilege enables trigger operations. You must have this privilege for a table to create, drop, or execute triggers for that table. This privilege was added in MySQL 5.1.6 http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html#priv_trigger SKINS: user/db/user_priv.html add: |*if DATABASE_EXTENDED_USER_PRIVILEGES>="1"| <tr><td class=list align=right>Show View</td><td class=list>|SHOW_VIEW_PRIV|</td></tr> <tr><td class=list align=right>Create Routine</td><td class=list>|CREATE_ROUTINE_PRIV|</td></tr> <tr><td class=list align=right>Alter Routine</td><td class=list>|ALTER_ROUTINE_PRIV|</td></tr> <tr><td class=list align=right>Execute</td><td class=list>|EXECUTE_PRIV|</td></tr> <tr><td class=list align=right>Create View</td><td class=list>|CREATE_VIEW_PRIV|</td></tr> |*endif| |*if DATABASE_EXTENDED_USER_PRIVILEGES>="2"| <tr><td class=list align=right>Event</td><td class=list>|EVENT_PRIV|</td></tr> <tr><td class=list align=right>Trigger</td><td class=list>|TRIGGER_PRIV|</td></tr> |*endif| LANG: lang/en/user/db/db.html LANG_SHOW_VIEW=Show View LANG_CREATE_ROUTINE=Create Routine LANG_ALTER_ROUTINE=Alter Routine LANG_EXECUTE=Execute LANG_CREATE_VIEW=Create View LANG_EVENT=Event LANG_TRIGGER=Trigger

Interested to try DirectAdmin? Get a 30-day Free Trial!