All Activity
This stream auto-updates
- Past hour
-
Client Account Login Notification Hook
hardikjoshi replied to twhiting9275's topic in Third Party Add-ons
yes brother it's also working well -
Client Account Login Notification Hook
hardikjoshi replied to twhiting9275's topic in Third Party Add-ons
thanks you bro it's working fine -
Anyway to add a button in front of invoice/item to redirect it to service page or mention service id on the items?
steph.hope replied to sonuyos's topic in Admin & Configuration Questions
Thanks for this code, @Kian! It's been super helpful to me both to use in this form and to see how jquery hooks work. -
MySQL Workbench remote database
leeyondking replied to leeyondking's topic in Admin & Configuration Questions
I don't have much of saying, but it was due to port 3306 not enabled for public remote access. Have it turned on and now it is accessible. - Today
-
Welcome to WHMCS.Community wish! We're glad you're here please take some time to familiarise yourself with the Community Rules & Guidelines and take a moment to introduce yourself to other WHMCS.Community members in the Introduce Yourself Board.
-
wish joined the community
-
You need to use something that looks very similar to the code I posted here months ago: You have to change the query to retreive datepaid like follows: <?php $Data = Capsule::select(Capsule::raw('SELECT id, datepaid FROM tblinvoices')); $Data = json_encode($Data, true); Replace "Last Caputure Attempt" th with "Date Paid" then iterate each row to replace all your "N/A" with date paid. You can use this HTML as target. <td> <input type="checkbox" name="selectedinvoices[]" value="{USE_ME}" class="checkall"> </td> It's easy but sadly there's a big problem. Invoices page shows 25 to 250 records per page and selecting all records you have in tblinvoices makes no sense. What if you have 50k invoices stored on that table? It's clear that you need to select only the records you're actually seeing on screen. Basically you have to retreive all filters in use on the page (userid, invoicenum, invoicedate, duedate, datepaid...), sort order (ASC, DESC), current page number and of course calculate the right LIMIT to use. It's so damn frustrating and boring that I suggest you to stop working on it. If you need a proof just look at this code... <?php $filters = array_filter(json_decode(base64_decode(urldecode($_COOKIE['WHMCSFD'])), true)['invoices']); That's how you retrieve filters currently in use. Can you imagine the rest? ☠️
-
Hello, Basically that's me. WHMCS is okay but be careful with Licensing Addon if you plan to use it. It took me years to fix all flaws it has. I also know a fair amount of companies that are using WHMCS for things not related to hosting like for example consulting, support, a couple of SaaS, license selling, dropshipping, marketing and a radio station.
-
Disable Automatic CC Processing based on product
steph.hope replied to caroldaley's topic in Using WHMCS
Sorry for resurrecting an old thread, but I'm in a similar situation at present. We have clients who want to be automatically charged for their recurring costs such as hosting, but we don't want to charge automatically when they have larger invoices such as for website development. If we used a cron or invoicecreation hook to turn off the client's auto-cc-processing when the invoice exceeds a certain amount, then turned it back on later so that the smaller invoices would be captured, would WHMCS then try to capture the large invoice (which we don't want)? -
Add an option to see the original mail from the client (with the original HTML formatting etc.) https://requests.whmcs.com/topic/add-an-option-to-see-the-original-mail-from-the-client-with-the-original-html-formatting-etc Give your vote to increase chances WHMCS take a look at this. 👍
- Yesterday
-
Hello everyone, I'm considering using WHMCS for my business' online billing and self service account management and was wondering if anyone else was doing that too. We sell software as a subscription service, hardware to accompany it, and also consulting, training, and installation. Basically we have several different subscription services, with options having different billing rates based on user counts and hardware counts, along with one time invoices... All comments appreciated! Best, John
-
Hi Guys, i'm wondering, if there is anywhere to purchase pre-made cPanel video tutorials?
-
Client Account Login Notification Hook
twhiting9275 replied to twhiting9275's topic in Third Party Add-ons
changing $results = localAPI($command, $values, $adminuser); to $results = localAPI($command, $values); will do the trick too. I mean, that's the easiest hack to do it. No longer need that adminuser for localAPI -
Welcome to WHMCS.Community ccengine! We're glad you're here please take some time to familiarise yourself with the Community Rules & Guidelines and take a moment to introduce yourself to other WHMCS.Community members in the Introduce Yourself Board.
-
ccengine joined the community
-
Hello, I have a problem with whmcs invoices. First, I had these errors: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'status' in where clause is ambiguous in /var/www/clients/vendor/illuminate/database/Connection.php:333 Next Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'status' in where clause is ambiguous (SQL: select IFNULL(total, 0) as total, IFNULL(SUM(amountin), 0) as amount_in, IFNULL(SUM(amountout), 0) as amount_out from tblinvoices inner join tblinvoiceitems on tblinvoiceitems.invoiceid = tblinvoices.id left join tblaccounts on tblaccounts.invoiceid = tblinvoices.id where tblinvoices.userid = 1 and status = Unpaid and type != Invoice group by tblinvoices.id) in /var/www/clients/vendor/illuminate/database/Connection.php:713 Then I was advised to do, which now gives these errors: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'where clause' in /var/www/clients/vendor/illuminate/database/Connection.php:333 Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'where clause' (SQL: select IFNULL(total, 0) as total, IFNULL(SUM(amountin), 0) as amount_in, IFNULL(SUM(amountout), 0) as amount_out from tblinvoices left join tblaccounts on tblaccounts.invoiceid = tblinvoices.id where tblinvoices.userid = 1 and status = Unpaid and 1 = 1 group by tblinvoices.id) in /var/www/clients/vendor/illuminate/database/Connection.php:713 Does anyone have a solution? Regards.
-
Getting the feeling I'm the only one seeing my posts here. 😉
-
Welcome to WHMCS.Community amirveisi! We're glad you're here please take some time to familiarise yourself with the Community Rules & Guidelines and take a moment to introduce yourself to other WHMCS.Community members in the Introduce Yourself Board.
-
amirveisi joined the community
-
FREE ADDON: WHMCS Maintenance Mode Plus
HardSoftCode replied to HardSoftCode's topic in Third Party Add-ons
Thank you brian! We have enabled the free modules and they are available on WHMCS Marketplace and our website https://marketplace.whmcs.com/user/HardSoftCode/products https://www.hardsoftcode.com/products.php -
FREE ADDON: WHMCS Maintenance Mode Plus
HardSoftCode replied to HardSoftCode's topic in Third Party Add-ons
Hi guys Yes the module was free in 2012 and we decided in 2014 to rewrite the code from scratch and change it from free to commercial -
Hey folks, Daniel Here, i'm a sysadmin starting his career, nice to meet you all of you!!!
-
Looking forward to taking part in the community and learning the best way to make use of WHMCS. Stay healthy!
-
I am new to the forums and not sure if this is the correct place to ask my question, but here goes: I am using the WHMCS module provided by NameSilo and I am having issues when registering .ca names. Whenever a client does so, it takes the default profile information in my NameSilo account instead of the one provided by the person registering it. I have a ticket open with NameSilo, but they are not very quick to respond. I have heard they have the same issue with .us domains. So, my question is: Is there an add-on module you have used with NameSilo to register ,ca domains that works properly? Or, have you got the one provided by NameSilo to work? Thanks!
-
Hi there, i had some issues that will arise now, i have my client portal in the same whm, in other words my client portal is also a client. I would like to know what's your best advice for it. Thanks in advance!
-
Anyone have an idea to integration contract signature? Need to autofill fields. Electronic signature platform eversign.com or docusign.com
-
Welcome to WHMCS.Community TerraUtopia! We're glad you're here please take some time to familiarise yourself with the Community Rules & Guidelines and take a moment to introduce yourself to other WHMCS.Community members in the Introduce Yourself Board.
-
TerraUtopia joined the community
-
Welcome to WHMCS.Community dajobeuz101! We're glad you're here please take some time to familiarise yourself with the Community Rules & Guidelines and take a moment to introduce yourself to other WHMCS.Community members in the Introduce Yourself Board.
