-- The owner confirmed the fee model (2026-08-26): publication itself stays
-- free, but a review fee of Rs.700 + GST is charged at submission (the
-- configured REVIEW_FEE_PAISE / REVIEW_GST_PERCENT). The legacy page says
-- only "no publication charges", which could surprise authors at the
-- payment step — append a clarifying note. Guarded: only applies while the
-- body still ends with the seeded content (an admin edit wins otherwise).
UPDATE cms_content
SET value_en = value_en ||
      '<p><strong>Note:</strong> While there are no publication charges, a review fee of ' ||
      E'₹' || '700 + GST applies at the time of online submission through this portal.</p>',
    value_hi = value_hi ||
      '<p><strong>नोट:</strong> प्रकाशन निःशुल्क है, किन्तु ऑनलाइन प्रस्तुति के समय ' ||
      E'₹' || '700 + GST समीक्षा शुल्क देय है।</p>',
    updated_at = NOW()
WHERE section = 'AUTHOR_PUBLICATION_FEE'
  AND group_key = 'page'
  AND field_key = 'body'
  AND value_en NOT LIKE '%review fee%';