Newsletter

SET NAMES utf8mb4

SELECT u.*, g.* FROM oktopusV1_core_users AS u INNER JOIN
oktopusV1_core_users_groups AS g ON g.group_id=u.group_id
WHERE u.id=1

UPDATE oktopusV1_mod_news SET active = 1
                           WHERE active = 3 AND NOW() >
created_at 

UPDATE oktopusV1_mod_news SET active = 0
                              WHERE active = 1 AND end_at !=
"0000-00-00 00:00:00" 
                              AND NOW() > end_at 

SELECT id, visibility, title, date, date_end, slug,
title_tag, title_seo, description, disponibility, color,
created_at, updated_at, images, files, meta_description,
meta_keywords FROM oktopusV1_mod_diary  WHERE 1  AND
IF(date_end IS NULL OR date_end = "0000-00-00 00:00:00", 
							date BETWEEN '2026-2-01' AND '2026-2-28',
							((date >= '2026-2-01' AND date_end <= '2026-2-28')
						    OR  (date < '2026-2-01' AND date_end >
'2026-2-28') 
						    OR  (date <= '2026-2-01' AND date_end >=
'2026-2-01' AND date_end <= '2026-2-28') 
						    OR  (date >= '2026-2-01' AND date <= '2026-2-28'
AND date_end >= '2026-2-28'))) AND visibility=1 

SELECT f.id, f.active, f.type, f.category, f.ord, f.html_id,
f.colonne, f.picto, f.options, f.info_personnelle, fl.title,
fl.legend, fl.description, fl.value FROM
oktopusV1_mod_contact_fields f LEFT JOIN
oktopusV1_mod_contact_fields_locales AS fl ON
fl.field_id=f.id AND fl.category=f.category WHERE 1  AND
f.active>0  AND f.category = "insert" AND fl.language='fr'
ORDER BY ord ASC