Jump to content

Search the Community

Showing results for tags 'MySQL'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • WHMCS Beta Program
    • WHMCS 8.7 Beta Discussion
  • The latest WHMCS Release
  • The Latest from the WHMCS Team
  • WHMCS.Community
    • Community Announcements
    • Introduce Yourself
  • Using WHMCS
    • Pre-Sales Questions
    • Admin & Configuration Questions
    • Installation, Upgrade, and Import Support
    • Using WHMCS
    • Troubleshooting Issues
    • Vendor Discussions
  • WHMCS Showcase
    • Showcase Your Site
    • Share Your Best Practices & Tips
  • Developing & Extending WHMCS
    • Third Party Add-ons
    • Service Offers & Requests
    • Developer Corner
    • Building Modules
    • Share Ideas for WHMCS Modules
  • Community Competitions
    • News, Announcements & Blogs from WHMCS
    • Competitions
  • General Discussions
    • General Discussion
  • General Feedback & Assistance
    • Feedback
    • WHMCS.Community Tips & Tricks
  • Third Party Developers's Topics
  • Turkish International Discussions's Topics
  • Russian International Discussions's Topics
  • Spanish International Discussions's Topics
  • Portuguese International Discussions's Topics
  • French International Discussions's Topics
  • Italian International Discussions's Topics
  • German International Discussions's Topics
  • WHMCS Brasil's Topics
  • WHMCS Brasil's Tópicos
  • ModulesGarden Club's Topics
  • Hungarian International Discussions's Segítség
  • ThemeMetro Club's Topics
  • WHMCS Services Club's Topics
  • WHMCS Global Services Club's Topics
  • Katamaze's Free Scripts
  • Katamaze's Module Support
  • Zomex Club's Topics
  • 0100Dev Club's Topics

WHMCS Version

  • V8.6.x Hotfixes
  • V8.5.x Hotfixes
  • V8.4.x Hotfixes

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start



About Me

Found 16 results

  1. 1. Discover what our modules are up to! You can already view all previously uploaded advances and improvements at any time in our marketplace. What if you could also see what the next stages of development hide? This has just been made possible with the all-new section placed right next to the changelog. The implementation of Roadmap will show you that caring for customer engagement is one of the most important aspects taken into consideration at ModulesGarden. Want to know more and give the new feature a go? Continue reading on the ModulesGarden Blog! 2. Zendesk For WHMCS 2.4.0 You already know that we have a module in our offer that lets you include support tools powered by Zendesk into WHMCS and handle support tickets while bringing your clients unforgettable experience of customer care. Guess what - it’s just been updated with some fresh solutions! The description of the 2.4.0 update of Zendesk For WHMCS should start off with WHMCS users support - an addition which will send email notifications about the in-flow of new ticket replies to any user that participates in a conversation. Excited? Let us make you even more eager to give it a look. The latest version makes WHMCS user details fully synchronized with the Zendesk panel! See for yourself how easily you can up your customer service at an amazing 15% discount - give the changelog a thorough read! Read more about Zendesk For WHMCS 2.4.0! 3. Password Manager For WHMCS 3.0 - 25% OFF In the business landscape of today’s world, cyber security is a top priority. Safe and long passwords are a great start, however remembering complex keystroke combinations can be too much of a challenge sometimes. The answer to these concerns is here - Password Manager For WHMCS 3.0! The latest huge update introduces an overhauled user interface with a brand new look, as well as support for Lagom Client Theme and WHMCS "Twenty-One". This fabulous module for extended safety has already been flooded with positive reviews, so delve deeper into the subject and find out how we have elevated it to new heights! Read more about Password Manager For WHMCS 3.0! 4. PanelAlpha sets new trends in WordPress automation! Let us remind you of one more grand advancement - the next level in the development of our top-notch system for WordPress instances provisioning, PanelAlpha! The addition of Personal Hosting Toolkit will provide your clients with swift and painless control over their accounts by empowering them to handle domains, FTP accounts, DNS zones and more, all from the level of PanelAlpha. We all know how crucial a unique brand is nowadays. That’s why you will be able to customize the client area to fit yours however you desire with the Style Manager! Switch colors, enable shadows - from now on, you will be able to let out the inner artist. In fact, you can experience it right away via live demo, accessible at all times! Put theory into practice and see PanelAlpha in powerful action! Need Custom Software Development For Your Business? Get Your Free Quote Now! Specially for you we will adapt an application and its design to your own needs, create a new module or even a completely new system built from scratch!
  2. Hi, I am looking for a way to determine the source of a new invoice. That being is the new invoice generated by a client action, like ordering a service. Or if it simply is generated by billing. Testing the InvoiceCreated hook for invoiceID gives us the new invoice number. However it is not possible to check this invoiceID against database tables. This seems to be because the invoice has yet to be finalized. Else we could have checked if the invoiceID was located in both tblorders.invoiceid and tblinvoices.id. Any match on both tables would indicate it was an order, and should there only be a match in tblinvoices.id it would be simply billing. Next we have the source variable, there it seems to be mainly autogen being used. I did check the classdoc for Invoice, there we have a runCreationHooks method with a String $source parameter, with 4 possible options: 'adminarea', 'api', 'autogen' or 'clientarea'. Now the whmcs hook InvoiceCreated states that the only values it will return are one of 'adminarea', 'api', 'autogen' or 'clientarea'. Does anyone have any tips, or have you perhaps dealt with this issue and found a way?
  3. Hello, is there a module or a way to create a MySQL user & database automatically for the newly created cPanel account? Thanks, Davor
  4. Hello, I'm getting the following error : Critical Error Could not connect to the database. Here is my configuration.php file : <?php $license = 'WHMCS-SECRET'; $db_host = ''; $db_username = 'user'; $db_password = 'SECRET'; $db_name = 'mydb'; $cc_encryption_hash = 'jdhJSH4ze47qs5AZde45d5qsd4zesde44aDgfvfzZf'; $templates_compiledir = '/var/www/template_c/'; $attachments_dir = "/var/www/html/test/att"; $downloads_dir = "/var/www/html/test/att"; $customadminpath = 'admin'; $api_access_key = 'SECRET'; I tried to connect from the server to the database using the same credentials as in the file : mysql -h -u user -pSECRET mydb Result : MySQL [mydb]> How can I debug it ? PHP 7.0.33
  5. 1. cPanel Extended For WHMCS V3.10.0 The grand new update of cPanel Extended For WHMCS has arrived embracing a string of new possibilities raised by the freshly implemented User Manager section! With it, your customers are empowered to create additional users along with their email, FTP, and web disk sub-accounts. What is more, we have established support for Remote MySQL and ModSecurity. The first one permits customers to add remote host addresses that will allow visitors to connect to the MySQL databases. The second feature is responsible for protection of your clients' domains - they are free to decide whether it should be enabled or not. Learn more about cPanel Extended For WHMCS 3.10.0! 2. SMS Center For WHMCS V3.7.0 It’s common knowledge that untroubled flow of information both internal and external-wise is essential for smooth business operation. However, it is the skill of effective communication with both your teams and customers no matter the time and place that makes it truly stand out. Our newly released SMS Center For WHMCS 3.7.0 will offer you the choice of 7 more SMS gateways! With this prominent update, you can also bound customers to re-validate their phone numbers, access the archive of SMS messages, serve new events such as "Invoice Activation" and "Order Paid Activation", as well as make bulk status updates of the approval messages. Look into a more extensive account of the newly implemented changes! 3. Hetzner VPS For WHMCS V1.4.0 Our Hetzner VPS For WHMCS is already known to many, but after today it is very likely to win the hearts of the entire WHMCS community! This well-thought-out solution responsible for bringing automation into provisioning and management of Hetzner servers has just been bolstered up with some further optimizations. The 1.4.0 version introduces widely requested support for user data and floating IP addresses, as well as dynamic generation of hostname. Moreover, your clients are about to enjoy the freedom of ordering backups as an addition to the virtual machines. The richer the offer, the better! Eager to learn more? Look into the remaining benefits listed neatly in the module′s changelog! 4. Over the last weeks we have also released a greal deal of WHMCS V8.0 compatibility updates: Amazon EC2 For WHMCS - v1.2.2 Amazon Lightsail For WHMCS - v1.1.5 Client Profile Viewer For WHMCS - v1.7.2 DigitalOcean Droplets For WHMCS - v1.6.1 Enom Email For WHMCS - v1.3.7 Hosting Renewals For WHMCS - v3.2.4 InterWorx Extended For WHMCS - v1.0.9 OpenStack VPS & Cloud For WHMCS - v1.9.3 QuickBooks Desktop For WHMCS - v1.3.4 Payment Gateway Allocator For WHMCS - v1.1.13 SolidCP Extended For WHMCS - v3.4.2 Need Custom Software Development For Your Business? Get Your Free Quote Now! Specially for you we will adapt an application and its design to your own needs, create a new module or even a completely new system built from scratch!
  6. Hi, I have to types of client email addresses - a regular email address and an email address that starts with dontreply and then some numbers and the domain prifas.co.il - something like that: dontreply1267@psifas.co.il I want to remove the Email Notifications (all except the "Domain Emails - Registration/Transfer Confirmation & Renewal Notices" that I can't remove) from all of the dontreplyXXXX@psifas.co.il customers but not to remove them from any other customer. Can you please help me with the exact command I should use in phpMyAdmin in order to remove all the Email Notifications from the dontreplyXXXX@psifas.co.il customers and only from them? Regards, Ram
  7. Hello, I have a question on how to connect to hosted website whmcs database on my local pc, I am using MySQL Workbench, MySQL Query Browser to connect to cPanel database. Usually for a normal website database I am able to connect peacefully, but for whmcs it's on the other way round. For WHMCS, I filled in the hostname based on ip, username, password, and database name correctly but still doesn't let me. Is there a specific encryption or accessibility to grant user to connect whmcs database? Thank you!
  8. Hi guys, I have a php file executing some mysql queries with variables parsed by Ajax , this is why i can't do the queries directly in php tags in the WHMCS template. So basically there is a query.php file that i need to export the session variable to for further usage. I need this variable in that file {php} echo $_SESSION['uid']; {/php} so i can use it for further manipulations.
  9. Hello, I'm working on an Addon Module to store a License Key for an addon. I can have it verify the get the license key from the table.. but what I'm trying to do is figure out how to put a check_license within this: class License extends Model { /** @var string $table The table in which the addon settings are stored. (mod_mylicensetable) */ protected $table = 'mod_squareLicensing'; //protected function results($results); private $vString = "16da9d4d6fc1e1ec25ce622d59d3d34e2b147bed894296693492985d85d27868"; } $Licensedata = License::where('id', '1')->first( As such, I can get my License data as expected, however, within the Addon Module itself -- to ideally get everything, the check needs to be inside the Class. I'd like to do something like function verify_license { //--get information from original license call and do our actions for invalid or active } Can someone give me guidance? I'm new working with Laravel. I know how to do a license call with the default check_sample.php and have adapted that as needed, and have built upon it.. but working with the classes are new to me. Any help and pointers would be greatly appreciated 🙂
  10. For many years I have had problems with the field "expirydate" in the table "tbldomain" changing back to MySQL standard value 1970-01-01 when a customer moves a domain. I use a custom registrar module and this does not have Domainsync. Basically, it doesn't matter if the date changes, when the domain is moved, but what happens is that WHMCS generates an invoice because the domain has got a new date and this is not good ! I see that the field "expirydate" has "Not null" as opposed to the other "date" fields. Could this be the problem ? Is there anyone who has a suggestion for a solution to this? Alternatively, one could put a block on the Auth Code, so that the customer did not receive it before Auto Renewal Status was set to OFF, so that a new invoice was not generated.
  11. /admin/systemcleanup.php does not loading, it timeouts after a few minutes with blank white page (when enabled debug logging in settings, the error is: Fatal error: Maximum execution time of 300 seconds exceeded in /home/me/public_html/admin/systemcleanup.php on line 0) Can it be some mysql coruption regarding log data? Before some time i manually removed some data (i think by emptying tblmodulelog table) because if i remember right, my WHMCS site had some timeouts deleting it from WHMCS. DB was optimised, Total Tables: 123 - Total Rows: 103282 - Total Size: 23857.87 Kb WHMCS 6.3.2 Please any mysql commands that can help fix the mysql tables, or empty logs, or other way to fix issue?
  12. Hello Everyone, I am going to update my company WHMCS from 6 to 7.1, but its my sql database size is around 20GB. so its good to update it. if yes, so there is any issues with this? Thanks Madan Malhotra
  13. I'm trying to learn the new approach from v6 that uses Laravel for queries but this seems rather more messy (at least for me than the old way which is going to be deprecated. For example I made this query: This works and it gets the users logged in domains but the problem is that all results are into the single $dom variable as ouput. I tried setting them in $row like the a standard PHP query to MySQL but it does not work. Neither arrays worked for me. The problem with this approach is that I cannot use domains separately in the code. Is there an easier way to pull domains out of a users account?
  14. I'm working on a module, and I need to do an SELECT QUERY with an INNER JOIN. Here is what I have: $table = "tblcustomfieldsvalues"; $fields = "fieldid,fieldname"; $where = array( "relid"=>array("sqltype"=>"LIKE","value"=>$params['serviceid']), ); $sort = "fieldid"; $sortorder = "ASC"; $limits = "0,2"; $join = "tblcustomfields ON tblcustomfields.id=tblcustomfieldsvalues.fieldid"; $result = select_query($table,$fields,$where,$sort,$sortorder,$limits,$join); There are two custom fields for this product, and their values occupy two rows in the tblcustomfieldsvalues table. This query should result in two records, with fieldid (from tblcustomfieldvalues) and fieldname (from tblcustomfields) for each. However, $result always comes up null. Anyone out there have any ideas?
  15. I've created a custom table in the WHMCS DB, and would now like to display the contained table data on a custom page I've also created, in the form of an html table. In mycustompage.php, I've passed the data to an array like so: $result = mysql_query("SELECT * FROM tblclientscustom WHERE userid=".$ca->getUserID()); $data = mysql_fetch_array($result); $customdata = $data; $ca->assign('customdata', $customdata); Then in mycustompage.tpl (using the clientareainvoices.tpl as a 'template') I've done the following: {foreach from=$customdata item=customdata} <tr> <td>{$customdata.id}</td> <td>{$customdata.domain}</td> <td>{$customdata.email}</td> <td>{$customdata.organization}</td> <td >{$customdata.timestamp}</td> <td><a href="viewcustdata.php?id={$customdata.id}">{$LANG.customdataview}</a></td> </tr> {foreachelse} <tr> <td colspan="5">{$LANG.norecordsfound}</td> </tr> {/foreach} However the above just populates every row with the results from the first row of my custom DB table (tblclientscustom). Have I made a mistake in setting the variable/array $customdata? Also what is the 'item=customdata' setting? in the clientareainvoices.tpl template it's set to 'item=invoice'. Have I set this wrong too? Any help appreciated.
  16. Due to an administrator username change, my mySql database username changed. This broke both WordPress and WHMCS. In WordPress, I just had to go into wp-config.php and find where it had the old username and update it to the new one. Is there a file in WHMCS somewhere that I need to go into and update the mySQL username? Is there anything else I need to do to fix it? When I try to connect now, I get Critical Error Could not connect to the database
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated