rendered paste body#!/usr/local/bin/php -q<?phpob_implicit_flush(true);set_time_limit(6);require_once("lib.php");include("config.php");$in = fopen("php://stdin","r");$stdlog = fopen("./lidb.log", "a+");while ($env=read()) { $s = split(": ",$env); $agi[str_replace("agi_","",$s[0])] = trim($s[1]); if (($env == "") || ($env == "\n")) { break; }}$dialeddigits = execute("GET VARIABLE blahblah");$dialeddigits2 = $dialeddigits['data'];// INSERT STOP RECORD$foo = execute("NoOp -- Adding stop record for current call to: $dialeddigits2");$stop_postpay = sprintf('UPDATE postpay_cdr SET stop = NOW() WHERE uniqueid = "%s"', $agi['uniqueid']);if (do_insert($stop_postpay) < 0) $foo = execute("NoOp DB Error - cdr_stop insert");// PUT FINAL SECONDS$bill_postpay = sprintf('UPDATE postpay_cdr SET rounded = TIME_TO_SEC(stop) - TIME_TO_SEC(start) WHERE uniqueid = "%s"', $agi['uniqueid']);if (do_insert($bill_postpay) < 0) $foo = execute("NoOp DB Error - cdr_stop insert");// SELECT VALUE IN ROUNDED SO IT CAN ACTUALLY BE ROUNDED$round_query = sprintf('SELECT rounded FROM postpay_cdr WHERE uniqueid = "%s"', $agi['uniqueid']);$grab_sec = mysql_query($round_query);// ROUND THE FINAL SECONDS$prerounded = ($grab_sec['rounded'] / 60);$finalround = ceil($prerounded);$foo = execute("NoOp -- ROUNDED TIME WAS: $finalround");// UPDATE THE VALUE IN ROUNDED WITH THE TRUE ROUNDED TIME$final_postpay = sprintf('UPDATE postpay_cdr SET rounded = "%s" WHERE uniqueid = "%s"', $finalround, $agi['uniqueid']);if (do_insert($final_postpay) < 0) $foo = execute("NoOp DB Error - Rounding Time");$foo = execute("NoOp -- CALL COMPLETED");?>