/** * @param $userid * @param $customerid * @param $serviceid * @param $hours * @param $date * @param $desc * @param $weeklyid * @return object * Add a new time to the database. */ function insertNewTime($userid, $customerid, $serviceid, $hours, $date, $desc, $weeklyid) { $savedesc = saveDescription($desc, $weeklyid, $userid); $savecustomer = saveCustomer("", $customerid, $weeklyid, $userid); $saveservice = saveService("", $serviceid, $weeklyid, $userid); $userid = convertForInsert($userid); $hours = convertForInsert($hours); $date = convertForInsert($date); $sql = "INSERT INTO `tbl_time` (TimeID, UserID, Hours, HourDate, WeeklyID) VALUES (NULL, " . $userid . ", " . $hours . ", " . $date . ", " . $weeklyid . ");"; $mysqli = new mysqli(Database::dbserver, Database::dbuser, Database::dbpass, Database::dbname); $mysqli->query($sql); $insertid = $mysqli->insert_id; $mysqli->close(); $data = array("inserid" => $insertid, "savecustomer" => $savecustomer, "saveservice" => $saveservice, "savedesc" => $savedesc); return json_encode($data); }
$display .= trackback_editor($target, $url, $title, $excerpt, $blog); $display = COM_createHTMLDocument($display, array('pagetitle' => $LANG_TRB['trackback'])); } elseif ($mode == 'deleteservice' && SEC_checkToken()) { $pid = COM_applyFilter($_POST['service_id'], true); if ($pid > 0) { DB_delete($_TABLES['pingservice'], 'pid', $pid); $display = COM_refresh($_CONF['site_admin_url'] . '/trackback.php?mode=listservice&msg=66'); } else { $display = COM_refresh($_CONF['site_admin_url'] . '/index.php'); } } elseif ($mode == 'saveservice' && SEC_checkToken()) { $is_enabled = ''; if (isset($_POST['is_enabled'])) { $is_enabled = $_POST['is_enabled']; } $display .= saveService(COM_applyFilter($_POST['service_id'], true), $_POST['service_name'], $_POST['service_site_url'], $_POST['service_ping_url'], $_POST['method'], $is_enabled); } else { if ($mode == 'editservice') { $service_id = 0; if (isset($_GET['service_id'])) { $service_id = COM_applyFilter($_GET['service_id'], true); } $pid = COM_applyFilter($service_id, true); $display .= editServiceForm($pid); } else { if ($mode == 'listservice') { $display .= COM_showMessageFromParameter(); $display .= listServices(); $display = COM_createHTMLDocument($display, array('pagetitle' => $LANG_TRB['services_headline'])); } else { if ($mode == 'freepb') {