__ __ __ __ _____ _ _ _____ _ _ _ | \/ | \ \ / / | __ \ (_) | | / ____| | | | | | \ / |_ __\ V / | |__) | __ ___ ____ _| |_ ___ | (___ | |__ ___| | | | |\/| | '__|> < | ___/ '__| \ \ / / _` | __/ _ \ \___ \| '_ \ / _ \ | | | | | | |_ / . \ | | | | | |\ V / (_| | || __/ ____) | | | | __/ | | |_| |_|_(_)_/ \_\ |_| |_| |_| \_/ \__,_|\__\___| |_____/|_| |_|\___V 2.1 if you need WebShell for Seo everyday contact me on Telegram Telegram Address : @jackleetFor_More_Tools:
-- -- Fix wrong asset name for com_content basic workflow stage if a new asset with the right -- name hasn't been created yet when saving the workflow stage in backend in past. -- UPDATE "#__assets" SET "name" = 'com_content.stage.1' WHERE "name" = 'com_content.state.1' AND (SELECT c."count" FROM (SELECT COUNT(b."id") AS "count" FROM "#__assets" b WHERE b."name" = 'com_content.stage.1') AS c) = 0; -- -- Fix wrong asset titles for workflow transitions -- UPDATE "#__assets" SET "title" = 'Unpublish' WHERE "name" = 'com_content.transition.1' AND "title" = 'Publish'; UPDATE "#__assets" SET "title" = 'Publish' WHERE "name" = 'com_content.transition.2' AND "title" = 'Unpublish'; UPDATE "#__assets" SET "title" = 'Trash' WHERE "name" = 'com_content.transition.3' AND "title" = 'Archive'; UPDATE "#__assets" SET "title" = 'Archive' WHERE "name" = 'com_content.transition.4' AND "title" = 'Trash';