"columnname", "vtiger_cvstdfilter"=>"columnname", "vtiger_cvadvfilter"=>"columnname", "vtiger_selectcolumn"=>"columnname", "vtiger_relcriteria"=>"columnname", "vtiger_reportsortcol"=>"columnname", "vtiger_reportdatefilter"=>"datecolumnname", "vtiger_reportsummary"=>"columnname", ); foreach($tables_array as $tablename => $columnname) { $query = "select $columnname from $tablename where $columnname like '%:cf_%'"; $result = $conn->query($query); $noofrows = $conn->num_rows($result); for($i=0;$i<$noofrows;$i++) { //First get the fieldname from the result $col_value = $conn->query_result($result,$i,$columnname); $fieldname = substr($col_value,strpos($col_value,':cf_')+1,6); //Now check whether this field is available in field table $sql1 = "select fieldid from vtiger_field where fieldname='".$fieldname."' and vtiger_field.presence in (0,2)"; $result1 = $conn->query($sql1); $noofrows1 = $conn->num_rows($result1); $fieldid = $conn->query_result($result1,0,"fieldid"); //if there is no field then we have to delete that field entries if($noofrows1 == 0 && !isset($fieldid)) { //Now we have to delete that customfield from the $tablename Execute("delete from $tablename where $columnname like '%:".$fieldname.":%'"); } } } ?>