wellscam Posted July 22, 2008 Share Posted July 22, 2008 I know there are a million posts out there about converting the other way, I need to know how to convert my Hours:Minutes:Seconds into just seconds so I can use a function I already have in place to calculate totals. Any ideas would be great, a completed script would be BEST!! Quote Link to comment Share on other sites More sharing options...
revraz Posted July 22, 2008 Share Posted July 22, 2008 Explode it on : and multiply by 60? Quote Link to comment Share on other sites More sharing options...
wellscam Posted July 22, 2008 Author Share Posted July 22, 2008 I have no idea what you just said!! ??? I just checked the Access database I am pulling the info from, and the Duration of each call is actually set up as HH:MM'SS it doesn't use the colon between MM and SS, so I think this might make it harder, but I have no idea. I guess I should have started this post with (NEW-B)! Quote Link to comment Share on other sites More sharing options...
craygo Posted July 22, 2008 Share Posted July 22, 2008 try this <?php function get_seconds($time){ $array = explode(':', $time); $pt1[] = $array[0]; $pt2 = explode("'", $array[1]); $time = array_merge($pt1, $pt2); $sec = $time[2]; $min = $time[1]*60; $hour = $time[0]*60*60; $seconds = $sec+$min+$hour; return $seconds; } $time = "2:20'13"; echo get_seconds($time); ?> Ray Quote Link to comment Share on other sites More sharing options...
wellscam Posted July 22, 2008 Author Share Posted July 22, 2008 Okay, I'm an idiot. I can't seem to get this to do what I want it to. THE SCRIPT WORKS GREAT THOUGH, thank you. I need to integrate it into this query somehow and I can't seem to get it right. First I query for the data my user inputs (date and extension) then I use "sum" of DurationS which is a table in my database that totals the seconds of a call (but it's not working right so I have to calculate the total number of seconds based on the Duration column which is formatted as HH:MM'ss). $time = "SELECT Date, Extension, sum(DurationS) AS CountOfDuration FROM AllInfo WHERE Extension = '$ex' AND Date=#$id# GROUP BY Date, Extension"; Then I take my "CountOfDuration" and run it through my "minutestohours" function to get it to display everything in the right time format. echo "<td class=\"borderTable\"><center>".minutestohours($row["CountOfDuration"])."</center></td class=\"borderTable\"></table><p></p>"; } Here is the minutestohours function: // Transform minutes like "105" into hours like "1:45". function minutesToHours ($sec, $padHours = false) { // holds formatted string $hms = ""; // there are 3600 seconds in an hour, so if we // divide total seconds by 3600 and throw away // the remainder, we've got the number of hours $hours = intval(intval($sec) / 3600); // add to $hms, with a leading 0 if asked for $hms .= ($padHours) ? str_pad($hours, 2, "0", STR_PAD_LEFT). ':' : $hours. ':'; // dividing the total seconds by 60 will give us // the number of minutes, but we're interested in // minutes past the hour: to get that, we need to // divide by 60 again and keep the remainder $minutes = intval(($sec / 60) % 60); // then add to $hms (with a leading 0 if needed) $hms .= str_pad($minutes, 2, "0", STR_PAD_LEFT). ':'; // seconds are simple - just divide the total // seconds by 60 and keep the remainder $seconds = intval($sec % 60); // add to $hms, again with a leading 0 if needed $hms .= str_pad($seconds, 2, "0", STR_PAD_LEFT); // done! return $hms; } But I need to figure out how to get my query to run against the Duration column instead of the DurationS column or replace the DurationS with the results from the script you just gave me, but I need that script to total the Duration column and return that instead of a static HH:MM'SS. Does that make sense? Quote Link to comment Share on other sites More sharing options...
craygo Posted July 22, 2008 Share Posted July 22, 2008 First thing you should know is this. you can get the minutes from using the date and mktime function echo "<td class=\"borderTable\"><center>".date("g:i", mktime(0, $row["CountOfDuration"]))."</center></td class=\"borderTable\"></table><p></p>"; } does this return just one row?? Duration contain seconds or minute?? DurationS holds ?? Do you want to show a running total or something like that?? Ray Quote Link to comment Share on other sites More sharing options...
wellscam Posted July 22, 2008 Author Share Posted July 22, 2008 Hmm... mktime, interesting! I'm not sure I understand the way it works just by looking at it. I ran into that before, but reading the PHP manual on functions just makes me so lost sometimes that I didn't devote much time into trying to figure it out! I am actually a network admin who has to do some of this stuff, so I'm not really a programmer or designer of any sort. does this return just one row?? It returns the total time for all calls on the extension specified for the date requested. Duration contain seconds or minute?? Duration contains HH:MM'SS DurationS holds ?? Total number of seconds for the call, but it's not correct. It's telling me for a call that was 01:03'55 long, that the total number of seconds is 595. So I need to total the Duration column instead of the DurationS column. Do you want to show a running total or something like that?? Yeah, I need to show the total amount of time that caller has been on the phone. Quote Link to comment Share on other sites More sharing options...
wellscam Posted July 22, 2008 Author Share Posted July 22, 2008 If I just change the query to look at Duration instead of DurationS, then put the line you created with date and mktime, I get an error that says : "Data type mismatch in criteria expression." I don't think it likes the format of the Duration column. Trying to get an understanding of what I'm doing, I can summarize it like this. "Retrieve all calls on extension X for date Y and add all the call times together. The call times are located in the Duration column." But when it looks at the Duration column it errors out. Quote Link to comment Share on other sites More sharing options...
craygo Posted July 23, 2008 Share Posted July 23, 2008 What type of column is the Duration field. If it is just a text or varchar field, you will get the error. problem is the duration column can't be summed because it has those special characters in it. so a function will have to be made to add them up. try this out <?php function get_seconds($t){ $seconds = 0; if(is_array($t)){ foreach($t as $v){ $array = array(); $pt1 = array(); $pt2 = array(); $array = explode(':', $v); $pt1[] = $array[0]; $pt2 = explode("'", $array[1]); $time = array_merge($pt1, $pt2); $sec = $time[2]; $min = $time[1]*60; $hour = $time[0]*60*60; $seconds += ($sec+$min+$hour); } } else { $array = explode(':', $t); $pt1[] = $array[0]; $pt2 = explode("'", $array[1]); $time = array_merge($pt1, $pt2); $sec = $time[2]; $min = $time[1]*60; $hour = $time[0]*60*60; $seconds += ($sec+$min+$hour); } return $seconds; } $time = array(); $sql = "SELECT Date, Extension, Duration FROM AllInfo WHERE Extension = '$ex' AND Date=#$id# GROUP BY Date, Extension"; $result = mysql_query($sql) or die(mysql_error()); while($r = mysql_fetch_assoc($result)){ $time[] = $r['Duration']; } $seconds = get_seconds($time); echo "<td class=\"borderTable\"><center>".date("H:i:s", mktime(0, 0, $seconds))."</center></td class=\"borderTable\"></table><p></p>"; ?> Ray Quote Link to comment Share on other sites More sharing options...
wellscam Posted July 23, 2008 Author Share Posted July 23, 2008 $result = mysql_query($sql) or die(mysql_error()); while($r = mysql_fetch_assoc($result)){ I think this is specific to MySql right, what do I put in here for accessing my Access database I am pulling info from? $result = odbc_exec($odbc,$sql) or die(odbc_errormsg()); while($r = odbc_exec($result)){[/quote] Quote Link to comment Share on other sites More sharing options...
craygo Posted July 23, 2008 Share Posted July 23, 2008 Sorry forgot you were using access and odbc replace with this $time = array(); $sql = "SELECT Date, Extension, Duration FROM AllInfo WHERE Extension = '$ex' AND Date=#$id# GROUP BY Date, Extension"; $result = odbc_exec($odbc, $sql) or die(odbc_error()); while($r = odbc_fetch_array($result)){ $time[] = $r['Duration']; } Ray Quote Link to comment Share on other sites More sharing options...
wellscam Posted July 23, 2008 Author Share Posted July 23, 2008 I think I might have mixed something up in here because it's not returning anything. Here is my whole query, do you see what I did wrong? <p><?php require_once('odbc.php'); function get_seconds($t){ $seconds = 0; if(is_array($t)){ foreach($t as $v){ $array = array(); $pt1 = array(); $pt2 = array(); $array = explode(':', $v); $pt1[] = $array[0]; $pt2 = explode("'", $array[1]); $time = array_merge($pt1, $pt2); $sec = $time[2]; $min = $time[1]*60; $hour = $time[0]*60*60; $seconds += ($sec+$min+$hour); } } else { $array = explode(':', $t); $pt1[] = $array[0]; $pt2 = explode("'", $array[1]); $time = array_merge($pt1, $pt2); $sec = $time[2]; $min = $time[1]*60; $hour = $time[0]*60*60; $seconds += ($sec+$min+$hour); } return $seconds; } if(isset($_POST['submit'])) { $id = $_POST['id']; $ex = $_POST['ex']; if($id!="" & $ex!="") { echo "<b>Total number of calls for : ".$id."<br></b>"; $unixtime = time(); echo "" . date("F j, Y, g:i a",$unixtime) . "<br><br>"; $time = array(); $sql = "SELECT Date, Extension, Duration FROM AllInfo WHERE Extension = '$ex' AND Date=#$id# GROUP BY Date, Extension"; $result = odbc_exec($odbc, $sql) or die(odbc_error()); echo "<center><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"borderTable\"><tr><th class=\"borderTable\"> Extension </th><th class=\"borderTable\"> Time </th><th class=\"borderTable\">Total Dials</th><th class=\"borderTable\">Total Talk Time</th></tr>"; while($row = odbc_fetch_array($sql)) { echo "<tr>"; echo "<td class=\"borderTable\"><center>$ex</center></td class=\"borderTable\">"; echo "<td class=\"borderTable\"><center>00:01-23:59</center></td class=\"borderTable\">"; echo "<td class=\"borderTable\"><center>".$row['TotalNumberOfCalls']."</center></td class=\"borderTable\">"; while($r = odbc_fetch_array($result)){ $time[] = $r['Duration']; } $seconds = get_seconds($time); echo "<td class=\"borderTable\"><center>".date("H:i:s", mktime(0, 0, $seconds))."</center></td class=\"borderTable\"></table><p></p>"; } // end while } // end if } // end if ?> Quote Link to comment Share on other sites More sharing options...
craygo Posted July 23, 2008 Share Posted July 23, 2008 since you are grouping the results, you are not going to get what you want out of this the way it is. Let me ask you this. Do you want the total time by date or by extension?? also do you want it to look something like this Date: 07/23/2008 Ext: 111 time: 1:20'23 calls: 22 Ext: 123 time: 2:20'21 calls: 45 Total: 3:40'44 Ray Quote Link to comment Share on other sites More sharing options...
wellscam Posted July 23, 2008 Author Share Posted July 23, 2008 I actually need total time per extension on the date inputed. It should end up looking like this: Extension Time Total Dials Total Talk Time 3897 00:01-23:59 39 0:51:45 The "Time" column is in there because I run the query over and over again to show 6-7, 7-8, etc. There is probably a better way to do that, but that's another post all together!! Quote Link to comment Share on other sites More sharing options...
wellscam Posted July 23, 2008 Author Share Posted July 23, 2008 I left out my total dials query. I added it back in now, but it still doesn't return results. <?php require_once('odbc.php'); function get_seconds($t){ $seconds = 0; if(is_array($t)){ foreach($t as $v){ $array = array(); $pt1 = array(); $pt2 = array(); $array = explode(':', $v); $pt1[] = $array[0]; $pt2 = explode("'", $array[1]); $time = array_merge($pt1, $pt2); $sec = $time[2]; $min = $time[1]*60; $hour = $time[0]*60*60; $seconds += ($sec+$min+$hour); } } else { $array = explode(':', $t); $pt1[] = $array[0]; $pt2 = explode("'", $array[1]); $time = array_merge($pt1, $pt2); $sec = $time[2]; $min = $time[1]*60; $hour = $time[0]*60*60; $seconds += ($sec+$min+$hour); } return $seconds; } if(isset($_POST['submit'])) { $id = $_POST['id']; $ex = $_POST['ex']; if($id!="" & $ex!="") { echo "<b>Total number of calls for : ".$id."<br></b>"; $unixtime = time(); echo "" . date("F j, Y, g:i a",$unixtime) . "<br><br>"; $totalcalls = "SELECT Count(*) AS TotalNumberOfCalls FROM AllInfo WHERE Extension = '$ex' AND Date=#".$id."#"; $time = array(); $sql = "SELECT Date, Extension, Duration FROM AllInfo WHERE Extension = '$ex' AND Date=#$id# GROUP BY Date, Extension"; $totalcalls = odbc_exec($odbc,$totalcalls) or die(odbc_errormsg()); $result = odbc_exec($odbc, $sql) or die(odbc_error()); echo "<center><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"borderTable\"><tr><th class=\"borderTable\"> Extension </th><th class=\"borderTable\"> Time </th><th class=\"borderTable\">Total Dials</th><th class=\"borderTable\">Total Talk Time</th></tr>"; while($row = odbc_fetch_array($totalcalls)) { echo "<tr>"; echo "<td class=\"borderTable\"><center>$ex</center></td class=\"borderTable\">"; echo "<td class=\"borderTable\"><center>00:01-23:59</center></td class=\"borderTable\">"; echo "<td class=\"borderTable\"><center>".$row['TotalNumberOfCalls']."</center></td class=\"borderTable\">"; while($r = odbc_fetch_array($result)){ $time[] = $r['Duration']; } $seconds = get_seconds($time); echo "<td class=\"borderTable\"><center>".date("H:i:s", mktime(0, 0, $seconds))."</center></td class=\"borderTable\"></table><p></p>"; } // end while } // end if } // end if ?> Quote Link to comment Share on other sites More sharing options...
craygo Posted July 23, 2008 Share Posted July 23, 2008 try this out <p><?php require_once('odbc.php'); function get_seconds($t){ $seconds = 0; if(is_array($t)){ foreach($t as $v){ $array = array(); $pt1 = array(); $pt2 = array(); $array = explode(':', $v); $pt1[] = $array[0]; $pt2 = explode("'", $array[1]); $time = array_merge($pt1, $pt2); $sec = $time[2]; $min = $time[1]*60; $hour = $time[0]*60*60; $seconds += ($sec+$min+$hour); } } else { $array = explode(':', $t); $pt1[] = $array[0]; $pt2 = explode("'", $array[1]); $time = array_merge($pt1, $pt2); $sec = $time[2]; $min = $time[1]*60; $hour = $time[0]*60*60; $seconds += ($sec+$min+$hour); } return $seconds; } if(isset($_POST['submit'])) { $id = $_POST['id']; $ex = $_POST['ex']; if($id!="" & $ex!="") { echo "<b>Total number of calls for : ".$id."<br></b>"; $unixtime = time(); echo "" . date("F j, Y, g:i a",$unixtime) . "<br><br>"; $time = array(); $sql = "SELECT Date, Extension, Duration FROM AllInfo WHERE Extension = '$ex' AND Date=#$id# GROUP BY Date, Extension"; $result = odbc_exec($odbc, $sql) or die(odbc_error()); echo "<center><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"borderTable\"><tr><th class=\"borderTable\"> Extension </th><th class=\"borderTable\"> Time </th><th class=\"borderTable\">Total Dials</th><th class=\"borderTable\">Total Talk Time</th></tr>"; while($row = odbc_fetch_array($result)) { $cur_ext = $row['Extension']; $cur_date = $row['Date']; $t_sql = "SELECT Duration FROM AllInfo WHERE Extention = '$cur_ext' AND Date = '#$cur_date#'"; $t_res = odbc_exec($odbc, $t_sql) or die(mysql_error()); while($tr = odbc_fetch_array($t_res)){ $time[] = $tr['Duration']; } echo "<tr>"; echo "<td class=\"borderTable\"><center>$ex</center></td class=\"borderTable\">"; echo "<td class=\"borderTable\"><center>00:01-23:59</center></td class=\"borderTable\">"; echo "<td class=\"borderTable\"><center>".$row['TotalNumberOfCalls']."</center></td class=\"borderTable\">"; $seconds = get_seconds($time); echo "<td class=\"borderTable\"><center>".date("H:i:s", mktime(0, 0, $seconds))."</center></td class=\"borderTable\"></table><p></p>"; } // end while } // end if } // end if ?> There was an error in my previous code so may want to copy and paste this in. Ray Quote Link to comment Share on other sites More sharing options...
wellscam Posted July 23, 2008 Author Share Posted July 23, 2008 It returns this: Total number of calls for : 07/22/08 July 23, 2008, 12:02 pm 37000 I did change this line: $t_res = odbc_exec($odbc, $t_sql) or die(mysql_error()); To this: $t_res = odbc_exec($odbc, $t_sql) or die(odbc_error()); Quote Link to comment Share on other sites More sharing options...
wellscam Posted July 24, 2008 Author Share Posted July 24, 2008 I know you're probably busy, but any ideas on this? I noticed the part of the query that totals the number of calls is not in there "TotalNumberOfCalls". I try to call it in the table just before the total talk time: echo "<td class=\"borderTable\"><center>".$row['TotalNumberOfCalls']."</center></td class=\"borderTable\">"; But it's missing from the query above. I did have a separate query for that, so I added it back in, but I'm still getting the same results. No matter what extension or date I query for, the table does not print, it just returns "37000". So here is what I have now: <body> <div id="ddtabs1" class="basictab"> <ul> <li><a href="DailyCallTotals_SelectDate.php" rel="sc2">Qualifiers</a></li> <li><a href="Sales_DailyCallTotals_SelectDate.php" rel="sc2">Sales</a></li> <li><a href="CallsByHour.php" rel="sc2">Calls By Hour</a></li> <li class="style2"><a href="AllCalls.php" rel="sc1">All Calls By Extension</a></li> </ul> </div> <h2>Show All Calls by Extension</h2> <form action="<?php echo $_SERVER["PHP_SELF"]; ?>" method="post"> <div align="left">Enter Date: <input type="text" name="id" value="07/22/08"> <br> Enter Ext: <input type="text" name="ex" value="3897"> <br> <input type="submit" name="submit" value="Submit" onKeyPress="return submitenter(this,event)"> </div> </form> <hr> <p><?php require_once('odbc.php'); function get_seconds($t){ $seconds = 0; if(is_array($t)){ foreach($t as $v){ $array = array(); $pt1 = array(); $pt2 = array(); $array = explode(':', $v); $pt1[] = $array[0]; $pt2 = explode("'", $array[1]); $time = array_merge($pt1, $pt2); $sec = $time[2]; $min = $time[1]*60; $hour = $time[0]*60*60; $seconds += ($sec+$min+$hour); } } else { $array = explode(':', $t); $pt1[] = $array[0]; $pt2 = explode("'", $array[1]); $time = array_merge($pt1, $pt2); $sec = $time[2]; $min = $time[1]*60; $hour = $time[0]*60*60; $seconds += ($sec+$min+$hour); } return $seconds; } if(isset($_POST['submit'])) { $id = $_POST['id']; $ex = $_POST['ex']; if($id!="" & $ex!="") { echo "<b>Total number of calls for : ".$id."<br></b>"; $unixtime = time(); echo "" . date("F j, Y, g:i a",$unixtime) . "<br><br>"; $sql2 = "SELECT Count(*) AS TotalNumberOfCalls2 FROM AllInfo WHERE Extension = '3884' AND Date=#".$id."#"; $query2 = odbc_exec($odbc,$sql2) or die(odbc_errormsg()); $time = array(); $sql = "SELECT Date, Extension, Duration FROM AllInfo WHERE Extension = '$ex' AND Date=#$id# GROUP BY Date, Extension"; $result = odbc_exec($odbc, $sql) or die(odbc_error()); echo "<center><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"borderTable\"><tr><th class=\"borderTable\"> Extension </th><th class=\"borderTable\"> Time </th><th class=\"borderTable\">Total Dials</th><th class=\"borderTable\">Total Talk Time</th></tr>"; while($row = odbc_fetch_array($query2)) { echo "<tr>"; echo "<td class=\"borderTable\"><center>$ex</center></td class=\"borderTable\">"; echo "<td class=\"borderTable\"><center>00:01-23:59</center></td class=\"borderTable\">"; echo "<td class=\"borderTable\"><center>".$row['TotalNumberOfCalls']."</center></td class=\"borderTable\">"; } while($row = odbc_fetch_array($result)) { $cur_ext = $row['Extension']; $cur_date = $row['Date']; $t_sql = "SELECT Duration FROM AllInfo WHERE Extention = '$cur_ext' AND Date = '#$cur_date#'"; $t_res = odbc_exec($odbc, $t_sql) or die(odbc_error()); while($tr = odbc_fetch_array($t_res)){ $time[] = $tr['Duration']; } $seconds = get_seconds($time); echo "<td class=\"borderTable\"><center>".date("H:i:s", mktime(0, 0, $seconds))."</center></td class=\"borderTable\"></table><p></p>"; } // end while } // end if } // end if ?> <?php odbc_close($odbc); ?> </p> <p> </p> </body> Quote Link to comment Share on other sites More sharing options...
craygo Posted July 24, 2008 Share Posted July 24, 2008 To better help you out, if you don't mind sending me the access file with just the table in question withe some sample data. I can help you a lot better. Just PM me the file if you like Ray Quote Link to comment Share on other sites More sharing options...
craygo Posted July 25, 2008 Share Posted July 25, 2008 try this out. <?php require_once('odbc.php'); function get_seconds($t){ $seconds = 0; if(is_array($t)){ foreach($t as $v){ $array = array(); $pt1 = array(); $pt2 = array(); $array = explode(':', $v); $pt1[] = $array[0]; $pt2 = explode("'", $array[1]); $time = array_merge($pt1, $pt2); $sec = $time[2]; $min = $time[1]*60; $hour = $time[0]*60*60; $seconds += ($sec+$min+$hour); } } else { $array = explode(':', $t); $pt1[] = $array[0]; $pt2 = explode("'", $array[1]); $time = array_merge($pt1, $pt2); $sec = $time[2]; $min = $time[1]*60; $hour = $time[0]*60*60; $seconds += ($sec+$min+$hour); } return $seconds; } if(isset($_POST['submit'])) { $id = $_POST['id']; $ex = $_POST['ex']; if($id!="" & $ex!="") { echo "<b>Total number of calls for : ".$id."<br></b>"; $unixtime = time(); echo "" . date("F j, Y, g:i a",$unixtime) . "<br><br>"; $time = array(); $sql = "SELECT `Date`, `Extension`, `Duration` (SELECT COUNT(`Extension`) FROM `AllInfo` WHERE AllInfo.Date=#$id# AND AllInfo.Extension='$ex') AS `count` FROM `AllInfo` GROUP BY AllInfo.Date, AllInfo.Extension HAVING (((AllInfo.Date)=#$id#) AND ((AllInfo.Extension)='$ex'))"; // `Extension` = '$ex' AND `Date` = #$id# "; //GROUP BY Date, Extension"; $result = odbc_exec($odbc, $sql) or die(odbc_error()); echo "<center><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"borderTable\"><tr><th class=\"borderTable\"> Extension </th><th class=\"borderTable\"> Time </th><th class=\"borderTable\">Total Dials</th><th class=\"borderTable\">Total Talk Time</th></tr>"; while($row = odbc_fetch_array($result)) { $cur_ext = $row['Extension']; $cur_date = $row['Date']; $t_sql = "SELECT `Duration` FROM `AllInfo` WHERE `Extension` = '$cur_ext' AND Date = #$cur_date# GROUP BY `Date`, `Duration`"; $t_res = odbc_exec($odbc, $t_sql) or die(odbc_error()); while($tr = odbc_fetch_array($t_res)){ $time[] = $tr['Duration']; } echo "<tr>"; echo "<td class=\"borderTable\"><center>$ex</center></td class=\"borderTable\">"; echo "<td class=\"borderTable\"><center>00:01-23:59</center></td class=\"borderTable\">"; echo "<td class=\"borderTable\"><center>".$row['count']."</center>"; $seconds = get_seconds($time); echo "<td class=\"borderTable\"><center>".date("H:i:s", mktime(0, 0, $seconds))."</center></td class=\"borderTable\"></table><p></p>"; } // end while } // end if } // end if ?> Ray Quote Link to comment Share on other sites More sharing options...
wellscam Posted July 25, 2008 Author Share Posted July 25, 2008 Yeah!! You totally rock, that does it. Thank you sooooo much! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.