LinkBack URL
About LinkBacks
New mysql index.html page voor x.theme
Personally I find the original index.html page for 'MySQL Account Maintenance' a bit confusing for users. It's a bit of a mess. Especially the 'Add Users To Your Databases:' section. So I made a cleaner version. Nothing has been changed on any cPanel includes in order to be able to change the original one with the code below withoiut negative results. Just plain HTML changes.
File path: /usr/local/cpanel/base/frontend/x/sql/index.html
Note: Unfortunately after every cPanel update the edited index.html file will be replaced by the original version from the x.theme. Hopefully the developers of cPanel will add this change to the x.theme version for everybodies benefit.Code:<cpanel setvar="headerimg=../images/topmysql.gif"> <cpanel setvar="dprefix=../"> <cpanel include="../stdheader.html"> <script> function checkprivs() { if (document.adduserdb.ALTER.checked == true || document.adduserdb.CREATETEMPORARYTABLES.checked == true || document.adduserdb.CREATE.checked == true || document.adduserdb.DELETE.checked == true || document.adduserdb.DROP.checked == true || document.adduserdb.SELECT.checked == true || document.adduserdb.INSERT.checked == true || document.adduserdb.UPDATE.checked == true || document.adduserdb.REFERENCES.checked == true || document.adduserdb.INDEX.checked == true || document.adduserdb.LOCKTABLES.checked == true) { document.adduserdb.ALL.checked = false; } } function checkallprivs() { if (document.adduserdb.ALL.checked == true) { document.adduserdb.ALTER.checked=false; document.adduserdb.CREATETEMPORARYTABLES.checked=false; document.adduserdb.CREATE.checked=false; document.adduserdb.DELETE.checked=false; document.adduserdb.DROP.checked=false; document.adduserdb.SELECT.checked=false; document.adduserdb.INSERT.checked=false; document.adduserdb.UPDATE.checked=false; document.adduserdb.REFERENCES.checked=false; document.adduserdb.INDEX.checked=false; document.adduserdb.LOCKTABLES.checked=false; } } </script> <div align="center"> <font class="big">MySQL Account Maintenance</font> <br><br><br> <table width="550" border="0" cellspacing="0" cellpadding="0"> <tr> <td><hr></td> </tr> <tr> <td align="center"><cpanel Mysql="initcache()"><table> <tr> <td align="center"><font class="big">Current Databases:</font></td> </tr> <tr> <td align="center"><cpanel Mysql="listdbs()"></td> </tr> <tr> <td> </td> </tr> </table></td> </tr> <tr> <td align="center"><form action="adddb.html"><table> <tr> <td>New Database: <input type="text" name="db"> <input type=submit value="Create Database"></td> </tr> </table></form></td> </tr> <tr> <td><hr></td> </tr> <tr> <td align="center"><table> <tr> <td align="center"><font class="big">Current Users:</font></td> </tr> <tr> <td align="center"><cpanel Mysql="listusers()"></td> </tr> <tr> <td> </td> </tr> </table></td> </tr> <tr> <td align="center"><form action="adduser.html"><table> <tr> <td>Username:</td> <td><input type="text" name="user"></td> <td></td> </tr> <tr> <td>Password:</td> <td><input type="text" name="pass"></td> <td><input type="submit" value="Create User"></td> </tr> </table></form></td> </tr> <tr> <td><hr></td> </tr> <tr> <td align="center"><form action="addusertodb.html" name="adduserdb"><table> <tr> <td align="center" colspan="4"><font class="big">Add Users To Your Databases:</font></td> </tr> <tr> <td colspan="4"> </td> </tr> <tr> <td>User:</td> <td><select name=user><cpanel Mysql="listusersopt()"></select></td> <td>Database:</td> <td><select name=db><cpanel Mysql="listdbsopt()"></select></td> </tr> </table> <table> <tr> <td colspan="5">Privileges:</td> </tr> <tr> <td><input type=checkbox name="ALL" value="ALL" checked onClick="checkallprivs();"> ALL</td> <td width="100" align="center">or</td> <td width="120"><input type=checkbox name="SELECT" value="SELECT" onClick="checkprivs();"> SELECT</td> <td><input type=checkbox name="CREATE" value="CREATE" onClick="checkprivs();"> CREATE</td> </tr> <tr> <td></td> <td></td> <td><input type=checkbox name="INSERT" value="INSERT" onClick="checkprivs();"> INSERT</td> <td><input type=checkbox name="ALTER" value="ALTER" onClick="checkprivs();"> ALTER</td> </tr> <tr> <td></td> <td></td> <td><input type=checkbox name="UPDATE" value="UPDATE" onClick="checkprivs();"> UPDATE</td> <td><input type=checkbox name="DROP" value="DROP" onClick="checkprivs();"> DROP</td> </tr> <tr> <td></td> <td></td> <td><input type=checkbox name="DELETE" value="DELETE" onClick="checkprivs();"> DELETE</td> <td><input type=checkbox name="LOCKTABLES" value="LOCK" onClick="checkprivs();"> LOCK TABLES</td> </tr> <tr> <td></td> <td></td> <td><input type=checkbox name="INDEX" value="INDEX" onClick="checkprivs();"> INDEX</td> <td><input type=checkbox name="REFERENCES" value="REFERENCES" onClick="checkprivs();"> REFERENCES</td> </tr> <tr> <td></td> <td></td> <td colspan="2"><input type=checkbox name="CREATETEMPORARYTABLES" value="TEMPORARY" onClick="checkprivs();"> CREATE TEMPORARY TABLES</td> </tr> </table> <table> <tr> <td><input type="submit" value="Add User To Database"></td> </tr> </table></form></td> </tr> <tr> <td><hr></td> </tr> <tr> <td align="center"><table> <tr> <td align="center"><font class="big">Access Hosts:</font></td> </tr> <tr> <td align="center"><cpanel Mysql="listhosts()"></td> </tr> <tr> <td> </td> </tr> </table></td> </tr> <tr> <td align="center"><form action="addhost.html"><table> <tr> <td>Host (% wildcard is allowed):</td> <td><input type="text" name="host"></td> <td><input type=submit value="Add Host"></td> </tr> </table></form></td> </tr> <cpanelfeature phpmyadmin> <tr> <td><hr></td> </tr> <tr> <td align="center"><table> <tr> <td align="center"><b><a href="<cpanel Cgi="phpmyadminlink()">" target="_blank">phpMyAdmin</a></b></td> </tr> <tr> <td align="center">You can use phpMyAdmin to administrate your MySQL databases in a web based environment.</td> </tr> </table></td> </tr> </cpanelfeature> </table> </div> <center> <br><br><br> <b>[</b> <a href="../index.html"><cpanel langprint="Goback"></a> <b>]</b> </center> <cpanel include="../stdfooter.html">
Reply With Quote
Originally Posted by Roy@ENHOST
