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

REPLACE INTO oktopusV1_core_users_online (user_id, ident,
logged, csrf_token, prev_url) VALUES (1,'3.138.105.4',
1732171676, 'f2fa5503a63d9d417d872889994919ee7138b15f',
'https://www.atelier-artisma.com/livre-d-or')

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 COUNT(id) AS num_sig FROM oktopusV1_mod_guestbook
WHERE 1 AND type='1' AND visible=1 AND (spam_status = "" OR
spam_status IS NULL) AND language='fr' ORDER BY date_sign
DESC 

SELECT id, language, message, nom, email, url, note, ip,
visible_home, date_sign, visible, spam_status, spam_filter,
date_reponse, reponse,type,element,id_user,
DATE_FORMAT(date_sign, "%d/%m/%Y %Hh%i") AS date_sign_fr,
DATE_FORMAT(date_reponse, "%d/%m/%Y %Hh%i") AS
date_reponse_fr FROM oktopusV1_mod_guestbook WHERE 1 AND
type='1' AND visible=1 AND (spam_status = "" OR spam_status
IS NULL) AND language='fr' ORDER BY date_sign DESC LIMIT 0,5

SELECT COUNT(id) AS num_sig, AVG(note) AS avg_note FROM
oktopusV1_mod_guestbook WHERE 1 AND visible=1 AND
(spam_status = "" OR spam_status IS NULL) AND language='fr' 

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