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

UPDATE oktopusV1_core_users_online SET logged=1734071485,
prev_url='https://www.atelier-artisma.com/agenda/2024/12'
WHERE ident='18.97.14.82'

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 '2024-12-01' AND '2024-12-31',
							((date >= '2024-12-01' AND date_end <= '2024-12-31')
						    OR  (date < '2024-12-01' AND date_end >
'2024-12-31') 
						    OR  (date <= '2024-12-01' AND date_end >=
'2024-12-01' AND date_end <= '2024-12-31') 
						    OR  (date >= '2024-12-01' AND date <= '2024-12-31'
AND date_end >= '2024-12-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