angelcosta

Sorry, I just moved it: http://webangel.com.br/download/clicky-addon/

I will be adjusting this so you dont have to insert your mysql data.

Live link: https://www.whmcs.com/members/communityaddons.php?action=viewmod&id=1894

Clicky is an awesome web analytics option. I use it in all my websites. Here it's an addon so you can add the tracking code to the client area in no time. After you activate it, click configure to add the site id. If you don't have Clicky, you have no idea what you're missing: a more visual and friendly analytics than Google Analytics. /http://portaldohost.com.br/downloads/clicky.zip

Seja bem-vindo Ruy!

Yeah, gonna try this till the end of the week.

Yes, Invictus has a point. I am waiting for 17 days now. I am definetely moving. That is just disrespectful.

It rounds the number, maybe that was it.

Actually the first code works in any php page: <?php $servidor = "localhost"; // database server $usuario = "usuario"; // user $senha = "senha"; // password $banco = "login_banco"; // database name $conecta = mysql_connect($servidor,$usuario,$senha); if (!$conecta){ die('Error connecting: ' . mysql_error()); } mysql_select_db($banco, $conecta); $result = mysql_query("SELECT tk.date, rp.date, tk.id FROM tbltickets as tk, tblticketreplies as rp WHERE tk.id=rp.tid AND tk.admin='' GROUP BY tk.id ORDER BY tk.date DESC LIMIT 0,10"); while($row = mysql_fetch_array($result)) { $tempo = abs(strtotime($row['0']) - strtotime($row['1'])); $minutos = floor(($tempo)/ 60); $tempos[] = $minutos; } $media = round(array_sum($tempos)/10); $horas = (int)($media / 60); $h = $horas."h"; $minutos = $media - ($horas * 60); $m = $minutos."min"; echo "Our average response time: ".$h."".$m; mysql_close($conecta); ?> Hope it helps

Yes, let me do that. I'll post later on today (Diablo 3 is holding me back today).

It is not supposed to be used in a plain php only in whmcs client's area.

Thanks openmind The links for that were in the post, i should have attached here.

It takes in consideration the latest 10 opened tickets and gets the average time between the opening time and the reply time.

I am a customer at media temple and decided to mimic their "response time" thing. So now we can show off the average time it takes us to reply tickets. You can get the code for the widget and client area at: http://portaldohost.com.br/whmcs/media-do-tempo-de-resposta-de-tickets-no-whmcs#.T334EtXNmg8 The code for the email template: http://www.whmcs.blog.br/principal/media-do-tempo-de-resposta-de-tickets-no-whmcs/#.T332CdXNmg8

+2 - I agree. Some of the designs (even though as not winners) could be included or given/sold here also.