Jump to content


Level 2 Member
  • Content count

  • Joined

  • Last visited

Community Reputation

10 Good

About wellconnit

  • Rank
    Level 2 Member
  1. Access Data via SQL over the Remote API

    Hi, Yeah I understand the point of the API, however unfortunately with WHMCS making the decision to remove all custom API's and there being no default API to retrieve the files that are listed on a clients account, i'm forced to start looking for alternate ways to extract the data. Unless you know how to activate custom API's on the newer versions of WHMCS? In terms of the SQL access I was thinking even maybe just doing a html include on a file that had the DB credentials so that I don't need to store them in an additional spot incase the credentials change or the installation moves I won't have to worry about updating multiple locations.
  2. Hi All, I've been looking for a while to find a solution to how I can display users files in a remote API session. Just wondering if anyone has any experience accessing the database across the remote API, I'd rather not write into the page credentials to access the DB, as secure as it may be. As the API seems to have a few gaps in functionality, I'm planning on running SELECT * FROM `tblclientsfiles` WHERE userid = apiuserid Which will give me the information I need to display links to each of the files and their titles. Any help or examples on how to interface with the DB is much appreciated.
  3. Hi @carlswart, Completely makes sense. Thanks for posting some assistance ! Hopefully I can get it working with the reversal also. It's a shame it isn't built in functionally to WHMCS though. Would look much better where the Taxes are listed rather than as a line item. Thanks again for your help !
  4. Hi @brian!, Thanks for your response. I kind've understand the logic that it's probably not that high up WHMCS priority list because they don't allow it in their home country, however the primary language in the UK is also English yet WHMCS displays in various other languages, suggesting that they are happy to not limit their service to what suits the UK only. https://www.businesscompanion.info/en/quick-guides/pricing-and-payment/payment-surcharges This site also suggests that you are allowed to surcharge for other forms of payment, e.g. Cash / Cheque / Commercial Debit & Credit Cards. I'm not really a fan of paying for a solution like that, because at any point in time as with the custom API's WHMCS could remove the ability for the third party application to work.
  5. Sorry to hijack this thread, but in the reverse way to what's been suggested, Could using a promotion hook be reversed to add a secondary tax to an invoice? Currently for Australia I have GST. But if we could use a hook to add a reverse 'Promotion' then we could +2% as an additional tax.(Purpose is to charge a fee based on a gateway choice - which has been a request for almost as many years as the above request, so not holding my breath..) Any help with this is great. Thanks.
  6. PDF Invoices via API

    Upon further investigation I believe this error can be attributed to WHMCS stupidly disabling Custom API's in 7.4 without providing a real platform for external users to fix 'feature holes' within the system. Using Modules isn't really a convinient way to solve the issues that have been brought about by restricting the use of API calls. If anyone has any insight on this I'd be happy to test it out. Thanks.
  7. PDF Invoices via API

    Hi Guys, A much asked for feature over the last few years for API users has been the ability to retrieve PDF Invoices from the system. I stumbled across a link from The Wandering System Admin who has done a great job at dissecting the system and getting it to spit out a PDF invoice. (http://thewanderingsysadmin.net/?p=35) However I'm having a bit of trouble getting it working. I've created the request and passed it $username,$password & a static invoice ID of 10 however I'm getting a response of, I've created the api request file in /includes/api/genpdffile.php however it's still not working. Happy to drop the working code once I get it, because I know a few people are looking for it on here, and WHMCS support are yet to implement this natively. Thanks to anyone with any ideas. Anyone can follow the ticket if they want to keep updated on the issue.
  8. Result URL for Payments

    After looking at logs it seems that the return URL is being called from the IP address of the payment processor which is causing a lost session for the user, does anyone have any best practice ideas for how this should be resolved ??
  9. Result URL for Payments

    Hi guys, I've almost finished developing a custom payment gateway, however when I submit and it posts I've set the return url(not the callback) to /viewinvoice?id=#### and there is a problem somewhere The callback is separate and is set to modules/gateways/callback/nabtransact.php But it returns me a page with no CSS and a login box which suggests it's logged out or lost the login cookie in the process. The address bar shows the payment gateway target but the page does not correspond. Any ideas are appreciated. Thanks
  10. Custom Payment Gateway Question

    Hi @Logicmaker Softwares I've changed quite a bit of the code as the original wasn't working as designed. It's now posting to NAB, but I'm getting an error when it executes so I'm not entirely sure why it's failing, i'm guessing a field doesn't correspond with what it should. Waiting to hear back from the bank. I'm not up for paying for a custom produced payment gateway, so if anyone else from Australia is interested in giving me a hand to get it finished I'd be grateful. More up to date files are attached to this post. nabtransact.php nabtransact callback.php Direct_Post_Integration_Guide.pdf
  11. Custom Payment Gateway Question

    Hi Andrew, Thanks for getting back to me. I realized that I hadn't completely read the callback file instructions. It's cleared a few things up for me. If I setup a third party gateway I'll be stuck with having a redirect to the bank's payment page(I'd prefer to keep them on my own site if possible), however I do see what you're saying about the plain text, do you think making sure everything is over HTTPS is secure enough to keep it as a merchant gateway? If I was to set it up as a third party gateway is it worth trying to iFrame it ? or just load as a new window and then process the payment? Thanks for your help.
  12. Custom Payment Gateway Question

    Hi Guys, I'm trying to integrate my WHMCS install with my banks payment gateway, they don't have the best documentation but I think i'm on the right track. I've got the preferences sorted and I think i'm most of the way there on getting the capture correct. But there are a few things i'm confused with, mainly the result url? The callback file is used for 3D secure transactions only is it not? I've added what I've done and the integration guide from the bank, hoping someone can take a look and let me know what I should use as a result url, The service doesn't allow for refunds automatically and I've removed the 3D secure function also. Just looking at getting the capture right then I can copy the concept to the other function, Also the documentation from WHMCS is a little lacking. How do we know what parameters are available and for something like the URL i've defined with the test & the live how do I reference the value of that variable? Any help with this is greatly appreciated. Thanks. nabtransact.php Direct_Post_Integration_Guide.pdf
  13. Get Customer Files via API?

    Sorry to bump an old thread but does anyone have any examples of how we can extend the usage of the API ourselves? Learning by looking at the supplied API commands isn't really a working solution because it's all in smarty tags. I think this would be a fairly simple solution to get done, after that happy to try my luck at a few other ideas to try and expand the usability of WHMCS and post my results for whoever else may be looking for them. Thanks.
  14. API - Create a button for cPanel Login?

    Hi Andrew, Sorry to bump an old thread but is there a way to use AutoAuth with a goto pointing towards the cPanel login?? Otherwise is it possible to store the autoauth credentials so that when it tries to authenticate it will login automatically and not prompt for a login?? Looking for any other suggestions you may have on this also. Thanks
  15. Get Customer Files via API?

    https://requests.whmcs.com/topic/ability-to-request-invoice-pdf-by-api Thanks for the followup brian, if you have any previous experience getting this done through writing your own extension to the API please let me know, I'm interested in getting the feature going and if I need to teach myself to extend the functionality I will. Thanks.

Important Information

By using this site, you agree to our Terms of Use & Guidelines