AND
ROUTINE_NAME LIKE '" . $q->escape("{$table}_trigger_") . "%'
AND
- ROUTINE_TYPE = 'CALL'
+ ROUTINE_TYPE = 'PROCEDURE'
");
while ($q->fetch()) {
- $cache[$table] = $q->SPECIFIC_NAME;
+ $cache[$table][] = $q->SPECIFIC_NAME;
}
if ($table == 'core_notify_recur') {
- print_r($cache($table]);
+ print_r($cache[$table]);
}
}
// now see which of the procedures match the specification..