webmaster@auses.org.au

A number of times I have tried to implement a $join in a WHMCS report. Each time there is an empty result set. For example: editing the Transactions report: $join = "tblinvoiceitems ON tblinvoiceitems.invoiceid=tblaccounts.invoiceid"; $result = select_query("tblaccounts",implode(',',$fieldlist),implode(' AND ',$filters),"date","ASC"),$join; Even without any filtering i get an empty result. Has anyone had success in using $join in a select_query? Any ideas? Cheers

It's not working for me. For some reason it won't login to the gateway so I get a 'Remote Transaction Failure' message. Login details are correct and the module worked on a test account. I think maybe it's still accessing the test site even though 'test mode' is unchecked.

Hi, I can't see any way to get a report of transactions that are not credit card - bank transfers, mail in payment to enable reconciliation with bank accounts. Is there any way to do this?

Eway creates a token for each customer which must be stored in whmcs for future payments. But to add customers with a token and their card details would require a separate function.

Just talking to eway on this: "You have the eWAY Customer ID which is for the module. This is also the eWAY Account ID, so out system knows which account to link the data with. Then you have the Token ID. This is generated when a Token customer is created/saved. Sounds like you cannot manually enter the token in WHMCS. Sounds like you will need to use the API to create the token and save the customer's details rather than manually create them in the eWAY Business Centre, then enter the token ID in to WHMCS" I'm happy to chip in for an API connector to add card details. Anyone else?

I am having a different problem in WHMCS v.5.1. The bindle of 4 items works fine for me but many people are reporting that the link takes them back to the cart.php and they mess around, get frustrated and some of them tell me about it. very frustrating and I can't explain it. Different platforms, different browsers.

Hi, I have clients who do not wish to allow their credit card details to be kept and want to pay each invoice as a one-off. Is there a way I can generated recurring invoices but allow payment for each invoice separately? Thanks

ok, that was rubbish, i admit it. I fixed the syntax errors in 2 minutes with debog on. Hope it works now... <?php /* Create username in incremental series */ function hook_create_username_action($vars) { $orderid = $vars['orderid']; $username = $vars['username']; $baseval = 20000; $result = mysql_query('SELECT id FROM tblhosting WHERE $orderid'); $username = $id + $baseval; mysql_query('UPDATE tblhosting SET username = $username WHERE id = $id'); } add_hook("AfterShoppingCartCheckout",1,"hook_create_username_action"); ?>

Hi Folks, Newbie warning! I'm using whmcs for a membership billing system and trying to get the product 'username' to increment automatically with each new registrant. whmcs support said to add a hook AfterShoppingCartCheckout and here is my code. It is causing a white screen on all whmcs pages : ( Any thoughts on the solution? <?php /* Create username in incremental series */ function hook_create_username_action($vars) { $orderid = $vars['orderid']; $username = $vars['username']; $baseval = 20000 # Lowest member number value $result = mysql_query( SELECT id FROM tblhosting WHERE $orderid ); $username = $id + $baseval; mysql_query("UPDATE tblhosting SET username = $username WHERE id = $id"); } add_hook("AfterShoppingCartCheckout",1,"hook_create_username_action"); ?>