SiClyUnDeCideD

second!mpression's WHMCS Freeradius Server Module Features: - Detailed graphing. This months usage, daily drilldown for current month & monthly usage graph for current year - NEW... auto generate username with (firstname)(lastname)(serviceid)@(realm) - NEW... auto generate username yes / no - Detailed configuration: - "Group Name" - freeradius usergroup name - "Pool Name" - pool name for sqlippool. blank to disable - "Counter Name" - counter name for sqlcounter. blank to disable - "Realm" - for realm to attach to username when it is automatically generated - "Counter Limit" - the time or usage limit value for the Counter Name Module commands: - create user (creates the user in radius) - terminate user (removes user from radius. does not remove accounting records incase the account needs to be re-created) - suspend (expires radius account) - unsuspend (removes expire from radius) - change password (change password in radius) - remove accounting records (removes account records left by terminate) details: info:

got a reply on this from Matt, Thanks "you can use {if $smarty.session.adminid} show this... {/if}"

Hi Sorry to sound like a complete idiot, but with you method will I be able to "hack" WHMCS to do true calendar month billing rather than 30 day cycle billing? I need to be able to have a client signup any time of the month and NOT get a prorate rate, but all invoice have to be due on the first of every month. Will this work?

I am using the freeradius mod from whmcs, now in the client panel under product details i have managed to add graphing using the {$username} variable. Withing the admin templates the only client editable template is the client summary (as far as i know), now some clients have several freeradius accounts, it would be easier to put the additional info in the clients product page, rather than writing a script with a whole bunch of sql strings to get the user id from email, then all freeradius usernames from the user id. All a little waste in my view seeing as {$username} is all ready there. Sorry seem to have found myself rambling on....

Hello I would like to find out: When you log in to a customers portal via the admin panel you get that "Logged in as Administrator" banner. I assume that it pops up is because of the admin users session. Can I use that to add a area using the template files of the "Product Details", that only admin users logged in this way can see it. Not the clients. Impossible?

I wonder if anyone can help. I have added the below code into a .tpl file for graphing. When I comment out the two include lines everything works fine (obviously not the graphing ), and when they are uncommented it seems as though the template files disappear and the are no graphics just wording, and the graphing still does not show up. So I guess the big question is, what stupid thing have I done here? Snippet ______________________________________ {php} //include("Includes/FusionCharts.php"); //include("Includes/DBConn.php"); // Connect to the DB $link = connectToDB(); // [Ryan] changed their code - didnt like it (isset($_GET["animate"]) && $_GET["animate"] != "") ? $animateChart = $_GET["animate"] : $animateChart = 1; //$strXML will be used to store the entire XML document generated //Generate the chart element // Fetch all factory records $strQuery = "select acctsessiontime,Month(acctstoptime) as month, acctinputoctets, acctoutputoctets,AcctInputGigawords,AcctOutputGigawords from radacct where username='steve@aerosat.co.za' group by Month(acctstoptime);"; $result = mysql_query($strQuery) or die(mysql_error()); //Iterate through each factory $strXML = "<chart caption='Total Megabytes Transfered' subCaption='Monthly Report' showBorder='0' formatNumberScale='0' numberSuffix=' Megabytes' animation=' " . $animateChart . "' palette='1' showValues='0' yAxisValuesPadding='10'><categories>"; if ($result) { while($ors = mysql_fetch_array($result)) { //Now create a second query to get details for this factory //Note that we're setting link as Detailed.php?FactoryId=<<FactoryId>> $strXML .= "<category label='".date("M",mktime(0,0,0,$ors["month"],1,2009))."' />"; } $strXML .="</categories>"; $strXML .= "<dataset seriesName='Upload Megabytes'>"; $result = mysql_query($strQuery) or die(mysql_error()); while($ors = mysql_fetch_array($result)) { $strXML .= "<set value='".round(($ors["acctinputoctets"]+($ors["AcctInputGigawords"]*4096))/1024/1024,2)."' />"; } $strXML .= "</dataset>"; $strXML .= "<dataset seriesName='Download Megabytes'>"; $result = mysql_query($strQuery) or die(mysql_error()); while($ors = mysql_fetch_array($result)) { $strXML .= "<set value='".round(($ors["acctoutputoctets"]+($ors["AcctOutputGigawords"]*4096))/1024/1024,2)."' />"; } $strXML .= "</dataset>"; $strXML .= "<dataset seriesName='Total Megabytes'>"; $result = mysql_query($strQuery) or die(mysql_error()); while($ors = mysql_fetch_array($result)) { $strXML .= "<set value='".round((($ors["acctinputoctets"]+($ors["AcctInputGigawords"]*4096)) + ($ors["acctoutputoctets"]+($ors["AcctOutputGigawords"]*4096)))/1024/1024,2)."' />"; } $strXML .= "</dataset>"; } mysql_close($link); //Finally, close <chart> element $strXML .= "</chart>"; //Create the chart - Pie 3D Chart with data from strXML echo renderChart("Charts/MSColumnLine3D.swf", "", $strXML, "FactorySum", 600, 300, false, false); {/php} _____________________________________________________________