$tNGs->addTransaction($ins_rafl_res); // Register triggers $ins_rafl_res->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "GET", "parent_id"); // Add columns $ins_rafl_res->setTable("{$_SESSION['RealS_prefix']}rafl_res"); $ins_rafl_res->addColumn("rafl_res_item", "NUMERIC_TYPE", "POST", "rafl_res_item"); $ins_rafl_res->addColumn("rafl_res_date", "DATE_TYPE", "VALUE", "{NOW_DT}"); $ins_rafl_res->addColumn("rafl_res_rate", "NUMERIC_TYPE", "GET", "rating", "{GET.rating}"); $ins_rafl_res->addColumn("rafl_res_share", "NUMERIC_TYPE", "GET", "share_id", "{GET.share_id}"); $ins_rafl_res->setPrimaryKey("rafl_res_id", "NUMERIC_TYPE"); $rating = $_GET['rating']; } else { // Update Evidence ---------------------------------- // Make an update transaction instance $upd_rafl_res = new tNG_update($conn_smart); $tNGs->addTransaction($upd_rafl_res); // Register triggers $upd_rafl_res->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "GET", "parent_id"); // Add columns $upd_rafl_res->setTable("{$_SESSION['RealS_prefix']}rafl_res"); $upd_rafl_res->addColumn("rafl_res_date", "DATE_TYPE", "VALUE", "{NOW_DT}"); $upd_rafl_res->addColumn("rafl_res_rate", "NUMERIC_TYPE", "GET", "rating", "{GET.rating}"); $upd_rafl_res->setPrimaryKey("rafl_res_id", "NUMERIC_TYPE", "VALUE", $row_rs_evidence['rafl_res_id']); $rating = $_GET['rating']; } //end if evidence exists // Execute all the registered transactions $tNGs->executeTransactions(); $idArray = explode("||", $_GET['taskArray']); include "count_rating.php"; echo $rating . "##" . array_sum($doneArray) / count($doneArray) . "##" . implode("||", $doneArray) . "##" . $rateTotal . "##" . implode("||", $rateArray);