tqhosting

have you added any new modules recently? we had this mysterious problem with cron after we implemented a custom server module. I don't remember exactly, but I think the problem was that the module didn't implement a function that whmcs was looking for.

I think it's safe to say they don't want the addon at all..fixed or not.

I think I could add this under custom client fields and would give what I'm looking for. Thank you for pointing me in the right direction, though!

Thanks John, but Is this just for the order form? I am looking to add fields to the admin area for additional login information, etc, to display on the client side so they can get their user / pass information. (We setup random passwords and they change it after they login initially) Is what I'm asking making sense?

We have been sending e-mails to customers with their login information, however this isn't secure and have had some complaints about it. I noticed the Username / Password fields on the Products / Services section on the Admin side. Is there a way for us to add additional sections to include username / password for VNC, Control panel, SSH, Root, hostname, IP, etc so that it will display on the client area screen? This way we would just tell themt o login to their client area to see the login credentials, etc. I see the spot for IP address ont he Admin side, but that does not display on the end user's client area screen. Any help is much appreciated!

This is pretty cool...is there a way to make it show the churn and churn rate? IE: How many Customers signed up in 2009, how many canceled, and how many are still active. Good logic, however.

I purchased a Mod from "Fiber Elephant" several months ago. I never received the addon or an e-mail about it. Even after several attempts to contact them.

OK, I've gotten it to sort by Product Group. I found an error in the way it calculated monthly totals. it added several hundred over what it should actually be, so I corrected that, and I also noticed the "Biennially" functions were all mis-spelled as "Biannually" so that field wasn't calculating at all. Here is the updated code for that: <?php $reportdata["title"] = "Product Group Income "; $reportdata["description"] = "Modified by KT"; $reportdata["tableheadings"] = array("Product Group","Monthly","Quarterly","Semi-Annual","Annual","Biennial","Total Yearly Income"); $query = "SELECT tblproducts.*,tblproductgroups.name AS groupname FROM tblproducts INNER JOIN tblproductgroups ON tblproductgroups.id = tblproducts.gid ORDER BY groupname ASC"; $result=mysql_query($query); $lastgroup = ""; $result=mysql_query($query); while ($data = mysql_fetch_array($result)) { $id = $data["id"]; $groupname = $data["groupname"]; $productname = $data["name"]; $monthly = 0; $quarterly = 0; $semiannually = 0; $annually = 0; $biennially = 0; $total = 0; $query2 = "SELECT * FROM tblhosting WHERE (domainstatus='Active' OR domainstatus='Suspended') AND billingcycle!='Free Account' AND billingcycle!='One Time' AND packageid='$id'"; $result2=mysql_query($query2); while($data = mysql_fetch_array($result2)){ $amount = $data["amount"]; $billingcycle = $data["billingcycle"]; if($billingcycle=="Monthly"){ $monthly=$monthly+$amount; }elseif($billingcycle=="Quarterly"){ $quarterly=$quarterly+$amount; }elseif($billingcycle=="Semi-Annually"){ $semiannually=$semiannually+$amount; }elseif($billingcycle=="Annually"){ $annually=$annually+$amount; }elseif($billingcycle=="Biennially"){ $biennially=$biennially+$amount; } } $monthly=number_format($monthly,2,".",""); $quarterly=number_format($quarterly,2,".",""); $semiannually=number_format($semiannually,2,".",""); $annually=number_format($annually,2,".",""); $biennially=number_format($biennially,2,".",""); //RDG Note //Where does it get $monthlycost from ??? $servertotal=number_format( ( ($monthly*12)+($quarterly*4)+($semiannually*2)+$annually+($biennially/2) - ($monthlycost*12) ) ,2,".",""); $overalltotal=$overalltotal+$servertotal; if ($servertotal >= "0.01") { if ($lastgroup != $groupname) { $lastgroup = $groupname ; $reportdata["tablevalues"][] = array("**$groupname"); } $reportdata["tablevalues"][] = array("$productname",$CONFIG["CurrencySymbol"]."$monthly",$CONFIG["CurrencySymbol"]."$quarterly",$CONFIG["CurrencySymbol"]."$semiannually",$CONFIG["CurrencySymbol"]."$annually",$CONFIG["CurrencySymbol"]."$biennially",$CONFIG["CurrencySymbol"]."$servertotal"); } } $reportdata["tablevalues"][] = array("**Products Addons"); $query = "SELECT DISTINCT name FROM tblhostingaddons WHERE status!='Terminated' AND billingcycle!='One Time' AND billingcycle!='Free'"; $result = mysql_query($query); while($data = mysql_fetch_array($result)) { $name = $data["name"]; $monthly = 0; $quarterly = 0; $semiannually = 0; $annually = 0; $biennially = 0; $annualtotal = 0; $query2 = "SELECT * FROM tblhostingaddons WHERE name='".$name."' AND status!='Terminated' AND billingcycle!='One Time' AND billingcycle!='Free'"; $result2 = mysql_query($query2); while($data2 = mysql_fetch_array($result2)) { $amount = $data2["recurring"]; $billingcycle = $data2["billingcycle"]; if($billingcycle=="Monthly") { $monthly=$monthly+$amount; } elseif($billingcycle=="Quarterly") { $quarterly=$quarterly+$amount; } elseif($billingcycle=="Semi-Annually") { $semiannually=$semiannually+$amount; } elseif($billingcycle=="Annually") { $annually=$annually+$amount; } elseif($billingcycle=="Biennially") { $biennially=$biennially+$amount; } } $monthly=number_format($monthly,2,".",""); $quarterly=number_format($quarterly,2,".",""); $semiannually=number_format($semiannually,2,".",""); $annually=number_format($annually,2,".",""); $biennially=number_format($biennially,2,".",""); $servertotal=number_format( ( ($monthly*12)+($quarterly*4)+($semiannually*2)+$annually+($biennially/2) ) ,2,".",""); $overalltotal=$overalltotal+$servertotal; if ($servertotal >= "0.01") { $reportdata["tablevalues"][] = array("$name",$CONFIG["CurrencySymbol"]."$monthly",$CONFIG["CurrencySymbol"]."$quarterly",$CONFIG["CurrencySymbol"]."$semiannually",$CONFIG["CurrencySymbol"]."$annually",$CONFIG["CurrencySymbol"]."$biennially",$CONFIG["CurrencySymbol"]."$servertotal"); } } $reportdata["tablevalues"][] = array("**Domains"); $annually = 0; $query = "SELECT * FROM tbldomains WHERE status!='Expired'"; $result=mysql_query($query); while($data = mysql_fetch_array($result)) { $amount = $data["recurringamount"]; $registrationperiod = $data["registrationperiod"]; if ($registrationperiod < 1) { $registrationperiod=1; } $annually=$annually+($amount/$registrationperiod); } $annually=number_format($annually,2,".",""); $servertotal=number_format($annually,2,".",""); $overalltotal=$overalltotal+$servertotal; $reportdata["tablevalues"][] = array("Domains","-","-","-",$CONFIG["CurrencySymbol"]."$annually","-",$CONFIG["CurrencySymbol"]."$servertotal"); $overalltotal=number_format($overalltotal,2,".",""); $data["footertext"]="Total Income: ".$CONFIG["CurrencySymbol"].$overalltotal; ?> The only thing I would like to see now is a total of each group column: Eg: Product Group Monthly service $9.00 service $9.00 Totals $18.00 can someone help with this?

Hi, I've tried to modify this report, unfortunately I'm not familiar enough with the code to be able to do it successfully. This report is pretty much what we're looking for, but I would like it to display ONLY the product groups, not each individual product and only the product group's revenue total for each billing cycle (not just yearly total but broken down by each billing cycle). I've attempted to take out this line:$productname = $data["name"]; but it still displays each line item just without the name. Is this possible? I'm sure it is, I'm just too stupid to figure it out

I've fought with this code for hours to try and get this exact report, I don't think I know enough about it to get it to sort ONLY by group and not display the products. I found one someone made that does something similar, but I can't figure out how to make it display the Product Groups only not the individual products and the grand total for each billing cycle.. Ideally, I'd like it to be a graph, but anything will work ok. Would appreciate it if someone could help us with this.

Hello, Is there a way to set WHMCS so that all NEW clients that sign up receive an email say, 20 days after signup? Sort of like a survey of how the service is working out, etc. Would like this to happen automatically after the customer signs up, to ensure quality. Is it possible? Thanks in advance for any information.

I was just pointing out on this thread, that following the wiki instructions do not work with the "singlepage" template.

I tried using cart.php instead that doesn't work, either. It re-directs to the product listing page

I had this working, now it doesn't: I was using the boxes order template, and this worked fine: https://www.rootbsd.net/manage/order.php?step=2&pid=15&promocode=TEST I changed the order form to single page now it doesn't auto-apply the promo code.

Ok, we changed the default order template to "singlepage" and it broke the auto-apply promo code. This is what I had before when using the "boxes template and it worked fine: https://www.rootbsd.net/manage/order.php?step=2&pid=15&promocode=XXXX now, with the singlepage template, the URL is completely different and adding the &promocode=XXXX to the end does not work. Suggestions?