public function deleteCustomFields() { if (!empty($_POST['del'])) { mysql_query("DELETE FROM `" . DB_PREFIX . "cusfields` \n WHERE `id` IN(" . implode(',', $_POST['del']) . ") \n\t") or die(mswMysqlErrMsg(mysql_errno(), mysql_error(), __LINE__, __FILE__)); $rows = mysql_affected_rows(); mysql_query("DELETE FROM `" . DB_PREFIX . "ticketfields` \n WHERE `fieldID` IN(" . implode(',', $_POST['del']) . ") \n\t") or die(mswMysqlErrMsg(mysql_errno(), mysql_error(), __LINE__, __FILE__)); if (mswRowCount('cusfields') == 0) { @mysql_query("TRUNCATE TABLE `" . DB_PREFIX . "cusfields`"); } if (mswRowCount('ticketfields') == 0) { @mysql_query("TRUNCATE TABLE `" . DB_PREFIX . "ticketfields`"); } // Rebuild sequence.. fields::rebuildSequence(); return $rows; } return '0'; }