Exemplo n.º 1
0
 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';
 }