Hello all,

Okay i am making a kbs/bandwidth calculator, and the way i have it its a fairly simple script and basically i want to use something like the date() function to allow me to display the out put in days/hours/seconds but of course the date is less than 1970-01-01 so its basically adding 1970-01-01 to the date which is annouying! ><

I came across the adodb functions which seem good but are not installed on myserver http://phplens.com/phpeverywhere/adodb_date_library i am looking into getting them installed but i doubt it will be possible so i need a work arround.

Note if you were wondering its being used with in a Smarty Template system (WHMCS) hence the weird code...

PHP Code:

$kbs = $_POST['kbs']; //KB/s of the feed.
$bandwidth = $_POST['bandwidth'];

$kb_bandwidth = ($bandwidth*1024)*1024; //Total KBS / Month
$total_s = $kb_bandwidth/$kbs;
$total_mim= $total_s/60;
$total_hr= $total_mim/60;
$total_day=$total_hr/24;
 
$total = adodb_date('Y-m-d H:i:s', $total_s);

$smartyvalues["total_hr"] = $total; 
$smartyvalues["kbs"] = $kbs; 


Thanks and of course TP to anyone with a working answer!

Dan

Could you be more specific about what you're doing? An example would be great. I'm asking b/c I'm wondering why kb/s has anything to do with dates before 1970.

Simply do the math.
You need to pile up the seconds, and once you've got the total seconds, divide them to get months, weeks, days and hours.

I did this, some years ago (man, I do love subversion, when you have to find old code...)

PHP Code:

/**
 * Return a formated string with the time elpased between now and the specified unix timestamp
 * @param Int $ts    The unix timestamp to get shift from
 * @return string
 */
function getShift($ts){
    $delta=TIME-$ts;  //TIME is a defined constant with the current timestamp
    $ret=$str="";
    if($delta<=DAY_SECONDS){
        $str="Today";
    }
    else{
        $ret=($delta-($delta%DAY_SECONDS))/DAY_SECONDS;
        if($ret>=365){
            $year=($ret-$ret%365)/365;
            $ret-=$year*365;
            $str.="$year year";
            if($year>1){
                $str.="s";
            }
        }
        if($ret>=30){
            $month=($ret-$ret%30)/30;
            $ret-=$month*30;
            if($str!=""){
                $str.=",";
            }
            $str.=" $month month";
            if($month>1){
                $str.="s";
            }
            
            
        }
        if($ret<30){
            $days=$ret%30;
            if($str!=""){
                $str.=" and";
            }
            $str.=" $days day";
            if($days>1){
                $str.="s";
            }
        }
        
        $str.=" ago ";
        
    }
    return $str; 


}

Well, the math is simple. It's not that. My question is why 1970 matters? Are you tracking bandwidth since before 1970? If so, I'm intrigued, but for other reasons. If you're calculating the number of seconds between 2 times, why do you need something for 1970?

Totally lost here, but confident I can help when I understand...

Oh, and speaking of which, you didn't give me an example of a problem this would solve. That might help clear the fog.

Jeremy, I simply thought than Dan was mixing date() and time(), and gave him an guessed answer.
I can be totally off track, so yeah, Dan, can you bring us some light here, please.

Thanks.

Apologies.

Okay what it is is a SHOUTcast listener time calculator.
http://xdnet.co.uk/clients/shoutcast_bandwidth_calc.php

What it is suposed to do is so user inputs the kb/s of the online feed, selects their shoutcast package (which represents the total allowed bandwidth/month

and it then tells them exactly how many days/hours/minutes they can have thier feed streaming before their bandwidth runs out.

its probably me going at it from the wrong view.

but as you can see if u look at the page it dont work properly the way im doing it as i have like 95 hours and 88 minutes and stuff which is obviously wrong.

PHP Code:

if(isset($_POST['submit']))
{
$kbs = $_POST['kbs']; //KB/s of the feed.
$bandwidth = $_POST['bandwidth'];

$kb_bandwidth = ($bandwidth*1024)*1024; //Total KBS / Month
$total_s = $kb_bandwidth/$kbs;
$total_mins= $total_s/60;
$total_hrs= $total_mins/60;
$total_days=$total_hrs/24;
$total_hr = date('Y-m-d H:i:s', $total_s);
#$total = date('d \D\a\y\s H:i', $total_s);
$r_hr = substr($total_days, strrpos($total_days, '.') + 1); //Hours left over
$r_hr = $r_hr * 0.24;
$r_min= substr($r_hr, strrpos($r_hr, '.') + 1); //Remaining Minutes
$c_hrs = substr($r_hr, 0, 2);
$r_min = $r_min * 0.6;
$c_mins = substr($r_min, 0, 2);
$c_days = floor($total_days);

$smartyvalues["c_days"] = $c_days; 
$smartyvalues["c_hrs"] = $c_hrs; 
$smartyvalues["c_mins"] = $c_mins; 
$smartyvalues["total_days"] = $total_days; 
$smartyvalues["total_hrs"] = $total_hrs; 
$smartyvalues["total_mins"] = $total_mins; 
$smartyvalues["kbs"] = $kbs; 
$smartyvalues["submitted"] = true; 


okay so theres my bad attempt at hacking it right.

but obviously its not working

if it helps heres the table from the tpl file:

<table>
 <tr>
  <td>Time</td>
     <td>Value</td>
 </tr>
    
    <tr>
     <td>Days:</td>
        <td>{$c_days}</td>
    </tr>
    <tr>
     <td>Hours:</td>
        <td>{$c_hrs}</td>
    </tr>
    <tr>
     <td>Minutes:</td>
        <td>{$c_mins}</td>
    </tr>
    <tr>
     <td>Total Days:</td>
        <td>{$total_days}</td>
    </tr>
    <tr>
     <td>Total Hours:</td>
        <td>{$total_hrs}</td>
    </tr>
    <tr>
     <td>Total Minutes:</td>
        <td>{$total_mins}</td>
    </tr>
</table>

i am totally confused :s

Sorry Tripy. I didn't reply to you, just your post. I thought it was from Dan after I had replied to his first post. Needed to get my head on straight.

Anyway, if you want to convert secondsToDays, here's a function. It doesn't go to the months/years option, but I believe I have a thread on here which takes care of that in an accurate fashion (i.e. accounting for variations in the number of days per month, days per year, etc.).

PHP Code:

<?php
function secondsToDays($total_seconds) {
  $remaining_seconds = $total_seconds;
  
  $days = floor($remaining_seconds/86400);
  $remaining_seconds -= $days*86400;
  
  $hours = floor($remaining_seconds/3600);
  $remaining_seconds -= $hours*3600;
  
  $minutes = floor($remaining_seconds/60);
  $remaining_seconds -= $minutes*60;
  
  return array($days, $hours, $minutes, $remaining_seconds);
}
print_r(secondsToDays(86400*12.56));
?>

The result is returned as an array, but that was only for demonstration purposes. You can obviously pull it out of the function altogether.

Hope that helps and, again, sorry Tripy!

Thanks, its working now or at least appears to be.

Dan