Files
ave-cms/adminx/modules/Rubrics/migrations/004_native_database_calls.sql
2026-07-27 12:58:44 +03:00

22 lines
747 B
SQL

UPDATE `{{prefix}}_rubrics`
SET `rubric_template` = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
`rubric_template`,
'$AVE_DB->Query', 'DB::query'),
'$AVE_DB->EscStr', 'DB::escape'),
'->FetchAssocArray()', '->getAssoc()'),
'->FetchRow()', '->getObject()'),
'->GetCell()', '->getValue()'),
'->getCell()', '->getValue()')
WHERE `rubric_template` LIKE '%$AVE_DB%';
UPDATE `{{prefix}}_rubric_templates`
SET `template` = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
`template`,
'$AVE_DB->Query', 'DB::query'),
'$AVE_DB->EscStr', 'DB::escape'),
'->FetchAssocArray()', '->getAssoc()'),
'->FetchRow()', '->getObject()'),
'->GetCell()', '->getValue()'),
'->getCell()', '->getValue()')
WHERE `template` LIKE '%$AVE_DB%';