nick@molten-servers

wow just all this over a comment Anyway @AlfnyHost next update include an option to post more then 1 update to a client area or maybe even product specific news items. So far its worked well and clients have already commented on it.

This is his first free module, he has 4 others that are paid ones. I use two of them which he has also posted on WHMCS forums under commercial addons. So yes what i say is true it is another great module which is useful for me.

double post

Very Nice Another great module from you and your team. Thanks and Merry xmas to you too.

What i have posted for the Domains section is the same default that was posted by the OP. I just ran a test with that line of code and it shows the price of the domain.

Sorry for the double post. One of my admins just come asking if it would be possible to set which departments a support ticket notification would be sent to, as in when a number is inserted if that admin only wants say Pre-sales then we insert {departmentid} at the end of the number? This may be a handy feature for others too as i have multiple admins for various departments it would be a massive help.

Running a trial of this now, just a thought that you should try not sure if its been asked or not. When it checks for the Yes No have it so it can be a config option when ordering aswell as on the end system if people still choose. Only reason i suggest this is so people may offer it as an extra service over the standard email for a small fee. One small other thing is changing the time it should send out messages as some clients like to make orders / tickets at 3-4am and i like to sleep at these times, sending a text to me at 4am would wake me. Other then that so far it looks good. Will give a more detailed report in a few days when we make our final decision on purchase. Thanks.

Should be right to pull the Notes from tblorders in the same way you do for tblclients. Even add in a pull from the tblticketnotes to bring any other ticket notes for that client into the message.

Hi, Only a few things i could see that would benefit from this would be to put old client notes (with a date) onto the new tickets. The other would be when adding a note to the clients profile its got to be within the main summary, its not currently using the products admin notes unless i am missing something. I think this may not be something you can add but its hard to know who put what on the notes so i have the guys now putting [staffname][date][time] [notes] so we know exactly who and why that note was put on and how long ago. I am still testing it alot with the guys but it seems to be working great so far.

I hope the OP does not mind. I have changed some of the code to fix above issues. <?php function widget_upcoming_renewals($vars) { $title = "Upcoming Renewals"; $content = $content .= '<h3 align="center">Upcoming Service Renewals (Next 7 Days)</h3> <table bgcolor="#cccccc" align="center" style="margin-bottom:5px;width:100%;" cellspacing="1"> <tr bgcolor="#efefef" style="text-align:center;font-weight:bold;"><td>UserID</td><td>Billing Cycle</td><td>Payment Method</td><td>Next Due Date</td><td>IP</td></tr>'; $i=1; $range = "<= 7"; $result = mysql_query("SELECT * FROM `tblhosting` WHERE DATEDIFF(`nextduedate`, Now()) $range AND `server` > 1 AND `domainstatus` = 'Active' ORDER BY `nextduedate` ASC"); while ($data = @mysql_fetch_array ($result)) { $content .= '<tr bgcolor="#ffffff" style="text-align:center;"><td><a href="clientshosting.php?userid='.$data['userid'].'&id='.$data['id'].'">'.$data['userid'].'</a></td><td>'.$data['billingcycle'].'</td><td>'.$data['paymentmethod'].'</td><td>'.fromMySQLDate($data['nextduedate']).'</td><td>'.$data['dedicatedip'].'</td></tr>'; $i=0; } if($i) $content .= '<tr bgcolor="#ffffff" style="text-align:center;"><td colspan="7">No upcoming hosting renewals</td></tr>'; $content .= '</table><br />'; $content .= '<h3 align="center">Upcoming Domain Renewals (Next 60 Days)</h3> <table bgcolor="#cccccc" align="center" style="margin-bottom:5px;width:100%;" cellspacing="1"> <tr bgcolor="#efefef" style="text-align:center;font-weight:bold;"><td>Domain</td><td>Registrar</td><td>Period</td><td>Next Due Date</td><td>Expiration Date</td><td>Payment Method</td><td>Amount</td><td>Do Not<br />Renew</td></tr>'; global $currency;$i=1; $range = "<= 60"; $result = mysql_query("SELECT * FROM `tbldomains` WHERE DATEDIFF(`expirydate`, Now()) $range AND `status` = 'Active' ORDER BY `expirydate` ASC"); while ($data = @mysql_fetch_array ($result)) { $currency=getCurrency($data['userid']); $content .= '<tr bgcolor="#ffffff" style="text-align:center;"><td><a href="clientsdomains.php?userid='.$data['userid'].'&id='.$data['id'].'">'.$data['domain'].'</a></td><td>'.$data['registrar'].'</td><td>'.$data['registrationperiod'].'</td><td>'.fromMySQLDate($data['nextduedate']).'</td><td>'.fromMySQLDate($data['expirydate']).'</td><td>'.$data['paymentmethod'].'</td><td>'.formatCurrency($data['recurringamount']).'</td><td>'.$data['donotrenew'].'</td></tr>'; $i=0; } if($i) $content .= '<tr bgcolor="#ffffff" style="text-align:center;"><td colspan="8">No upcoming domain renewals</td></tr>'; $content .= '</table><br />'; return array('title'=>$title,'content'=>$content); } add_hook("AdminHomeWidgets",1,"widget_upcoming_renewals"); ?> Ive set it to 7days and made it for Dedicated IP hosts and instead of the Domain link i made it UserID link.

No changes after the cron, its like its calling for each user who has a product due soon or before 14days including those prior to today, this could be changed with some coding im sure. Should add in a line for if invoice is over 14days old dont show else show sort of code.

Getting the same thing, im not sure as to why either. Will await the next cron to see if some settings i made change it and if so i will share them here.

Ok Thanks for that, will give it a real good test, we get around 20-30 tickets a day right now so will be good to let our other staff know whats happened before with a client.

One question, where do we put this file? Sorry may be stupid but its not anywhere i can think of.

I agree, turn on System Module Debug Log in your whmcs and see what the error is stopping at. Most of the time its from a non configured product or misconfiguration where you may have one option set that should not be set. Even take a screenshot of the products module page and match it with your package in whm.