TBroMEM Posted September 10 Share Posted September 10 I have worked with a variety of hooks, but lack of knowledge of the data table schemas is a hindrance. Looking for an add-on to bridge this gap. Help would we appreciated. 0 Quote Link to comment Share on other sites More sharing options...
bear Posted September 10 Share Posted September 10 In the upper-right corner of PhpMyAdmin on the server, select the “Designer” tab to create a database ER diagram (ERD). All tables will be populated by default, but it's clunky and slow to respond in my experience. Better to take a DB dump and install locally, then generate what you need with something like Navicat, if you have it. 0 Quote Link to comment Share on other sites More sharing options...
TBroMEM Posted September 11 Author Share Posted September 11 Hello Bear. I don't have access to the WHMCS server so was hoping for an add-on that could be deployed/configured in the WHMCS application(s) itself so a system admin as myself can login and view those details. Thanks for the info. 0 Quote Link to comment Share on other sites More sharing options...
bear Posted September 11 Share Posted September 11 How did this get installed if you don't have access? If you have the installation files, that contains the database. From there you should be able to install the DB locally and find a way to get the ERD. 0 Quote Link to comment Share on other sites More sharing options...
TBroMEM Posted September 11 Author Share Posted September 11 Hello Bear - I may have title of system admin but it is only for the application not the server. Now, we had been working to update WHMCS in-app, and I had downloaded the installer and found the install.sql. I opened the file and found some schema details, but it does not seem to include all (such as tblpaymethods). If there are no add-ons available that can be deployed/configured in the WHMCS application itself, I will redirect my inquiries to internal IT resources. I suppose also, as you had indicated, I could take alternate approaches. 0 Quote Link to comment Share on other sites More sharing options...
bear Posted September 11 Share Posted September 11 Maybe this will be of assistance? That will get a live copy of the database using any of a number of methods. https://blog.whmcs.com/133579/automated-backups-in-whmcs 0 Quote Link to comment Share on other sites More sharing options...
TBroMEM Posted October 2 Author Share Posted October 2 Thanks for the ideas. I had hoped for an actual low effort solution that simply reveals the schema, such as to an Full Admin logged into the WHMCS Admin app. If push comes to shove, I will simply request working session with out IT resource to evaluate the datatables themselves on MySQL (or access the server to get to PhpMyAdmin on the server to create a database ER diagram (ERD) from Designer. I will select the latter as a workaround, given there is no add-on available. 0 Quote Link to comment Share on other sites More sharing options...
Solution pRieStaKos Posted Sunday at 07:36 PM Solution Share Posted Sunday at 07:36 PM Schema files of WHMCS database can be found within the /resources/sql/install/ directory. 1 Quote Link to comment Share on other sites More sharing options...
TBroMEM Posted Monday at 02:03 PM Author Share Posted Monday at 02:03 PM @pRieStaKos Thanks for directing me to this folder. This is helpful. I could have found it if I had dug around further. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.