function DeleteALLFields() { global $adb; include_once 'vtlib/Vtiger/Module.php'; $take_info = $adb->query("select * from vtiger_field where tabid = '" . $this->tabid . "'", true, "Error DeleteAddedFields()"); foreach ($take_info as $single_field) { $take_info = $adb->query("select * from vtiger_field where tabid = '" . $single_field['tabid'] . "' and fieldname = '" . $single_field['fieldname'] . "'", true, "Error DeleteAddedFields()"); if ($adb->num_rows($take_info) > 0) { $valuemap = array(); $moduleInstance = Vtiger_Module::getInstance($single_field['module']); $valuemap['fieldid'] = $adb->query_result($take_info, 0, 'fieldid'); $valuemap['fieldname'] = $adb->query_result($take_info, 0, 'fieldname'); $valuemap['fieldlabel'] = $adb->query_result($take_info, 0, 'fieldlabel'); $valuemap['columnname'] = $adb->query_result($take_info, 0, 'columnname'); $valuemap['tablename'] = $adb->query_result($take_info, 0, 'tablename'); $valuemap['uitype'] = $adb->query_result($take_info, 0, 'uitype'); $valuemap['typeofdata'] = $adb->query_result($take_info, 0, 'typeofdata'); $valuemap['block'] = $adb->query_result($take_info, 0, "block"); $fieldInstance = new Vtiger_Field(); $fieldInstance->initialize($valuemap, $moduleInstance); $fieldInstance->delete(); } } $delete = $adb->query("delete from vtiger_fieldmodulerel where module = '" . $this->module_name . "' or relmodule = '" . $this->module_name . "' ", true, "Error DeleteAddedFields()"); }