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.225.56.181' WHERE u.id=1

REPLACE INTO oktopusV1_core_users_online (user_id, ident,
logged, csrf_token, prev_url) VALUES (1,'18.225.56.181',
1735230986, '21f9c1b1e3e375bf2a5ae56c0ef56702b734e43b',
'https://www.atelier-artisma.com/agenda/2025/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 '2025-1-01' AND '2025-1-31',
							((date >= '2025-1-01' AND date_end <= '2025-1-31')
						    OR  (date < '2025-1-01' AND date_end >
'2025-1-31') 
						    OR  (date <= '2025-1-01' AND date_end >=
'2025-1-01' AND date_end <= '2025-1-31') 
						    OR  (date >= '2025-1-01' AND date <= '2025-1-31'
AND date_end >= '2025-1-31'))) 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