Newsletter

SET NAMES utf8mb4

SELECT u.*, g.*, o.logged, o.csrf_token, o.prev_url FROM
oktopusV1_core_users AS u INNER JOIN
oktopusV1_core_users_groups AS g ON g.group_id=u.group_id
LEFT JOIN oktopusV1_core_users_online AS o ON
o.ident='18.217.241.235' WHERE u.id=1

REPLACE INTO oktopusV1_core_users_online (user_id, ident,
logged, csrf_token, prev_url) VALUES (1,'18.217.241.235',
1735283671, '4fb4853404ed5211912fb55060aec797acf035e6',
'https://www.atelier-artisma.com/agenda/2025/2')

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 '2025-2-01' AND '2025-2-28',
							((date >= '2025-2-01' AND date_end <= '2025-2-28')
						    OR  (date < '2025-2-01' AND date_end >
'2025-2-28') 
						    OR  (date <= '2025-2-01' AND date_end >=
'2025-2-01' AND date_end <= '2025-2-28') 
						    OR  (date >= '2025-2-01' AND date <= '2025-2-28'
AND date_end >= '2025-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