stephan
c7482016ce
This commit introduces a new function, `fxSuperadmRedirectToLoginIfNeeded`, to streamline the login redirection process for superadmin users. It enhances session management by checking for user authentication and allowing legacy account access under specific conditions. Additionally, the login flow is updated to ensure users are redirected appropriately after login, improving the overall security and user experience in the superadmin interface. These changes aim to enhance maintainability and clarity in session handling across various superadmin pages.
118 lines
10 KiB
SQL
118 lines
10 KiB
SQL
-- MSIN-promoteur-hub — Restaurer libellés hub (table info)
|
|
-- Contexte : clés promoteur_hub_* absentes ou info_texte = info_clef après sync / ménage
|
|
-- Idempotent : n'écrase pas une traduction déjà personnalisée (info_texte <> info_clef)
|
|
-- Prérequis : aucun. Exécuter sur dev préprod (serveur).
|
|
|
|
SET NAMES utf8mb4;
|
|
|
|
INSERT INTO info (info_clef, info_langue, info_texte, info_aide, info_prg, info_description, info_trie, info_actif, info_option1, info_option2, info_option3, info_creation)
|
|
SELECT 'promoteur_hub_intro', 'fr', 'Acces a vos tableaux de bord par evenement.', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'promoteur_hub_intro' AND info_langue = 'fr' AND info_prg = 'compte.php');
|
|
|
|
INSERT INTO info (info_clef, info_langue, info_texte, info_aide, info_prg, info_description, info_trie, info_actif, info_option1, info_option2, info_option3, info_creation)
|
|
SELECT 'promoteur_hub_intro', 'en', 'Access your event dashboards.', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'promoteur_hub_intro' AND info_langue = 'en' AND info_prg = 'compte.php');
|
|
|
|
INSERT INTO info (info_clef, info_langue, info_texte, info_aide, info_prg, info_description, info_trie, info_actif, info_option1, info_option2, info_option3, info_creation)
|
|
SELECT 'promoteur_hub_link_participant', 'fr', 'Mon espace client MS1', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'promoteur_hub_link_participant' AND info_langue = 'fr' AND info_prg = 'compte.php');
|
|
|
|
INSERT INTO info (info_clef, info_langue, info_texte, info_aide, info_prg, info_description, info_trie, info_actif, info_option1, info_option2, info_option3, info_creation)
|
|
SELECT 'promoteur_hub_link_participant', 'en', 'My MS1 client space', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'promoteur_hub_link_participant' AND info_langue = 'en' AND info_prg = 'compte.php');
|
|
|
|
INSERT INTO info (info_clef, info_langue, info_texte, info_aide, info_prg, info_description, info_trie, info_actif, info_option1, info_option2, info_option3, info_creation)
|
|
SELECT 'promoteur_hub_annonces_titre', 'fr', 'Nouveautes MS1', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'promoteur_hub_annonces_titre' AND info_langue = 'fr' AND info_prg = 'compte.php');
|
|
|
|
INSERT INTO info (info_clef, info_langue, info_texte, info_aide, info_prg, info_description, info_trie, info_actif, info_option1, info_option2, info_option3, info_creation)
|
|
SELECT 'promoteur_hub_annonces_titre', 'en', 'MS1 updates', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'promoteur_hub_annonces_titre' AND info_langue = 'en' AND info_prg = 'compte.php');
|
|
|
|
INSERT INTO info (info_clef, info_langue, info_texte, info_aide, info_prg, info_description, info_trie, info_actif, info_option1, info_option2, info_option3, info_creation)
|
|
SELECT 'promoteur_hub_section_highlight', 'fr', 'En vedette', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'promoteur_hub_section_highlight' AND info_langue = 'fr' AND info_prg = 'compte.php');
|
|
|
|
INSERT INTO info (info_clef, info_langue, info_texte, info_aide, info_prg, info_description, info_trie, info_actif, info_option1, info_option2, info_option3, info_creation)
|
|
SELECT 'promoteur_hub_section_highlight', 'en', 'Highlights', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'promoteur_hub_section_highlight' AND info_langue = 'en' AND info_prg = 'compte.php');
|
|
|
|
INSERT INTO info (info_clef, info_langue, info_texte, info_aide, info_prg, info_description, info_trie, info_actif, info_option1, info_option2, info_option3, info_creation)
|
|
SELECT 'promoteur_hub_section_archived', 'fr', 'Evenements passes', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'promoteur_hub_section_archived' AND info_langue = 'fr' AND info_prg = 'compte.php');
|
|
|
|
INSERT INTO info (info_clef, info_langue, info_texte, info_aide, info_prg, info_description, info_trie, info_actif, info_option1, info_option2, info_option3, info_creation)
|
|
SELECT 'promoteur_hub_section_archived', 'en', 'Past events', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'promoteur_hub_section_archived' AND info_langue = 'en' AND info_prg = 'compte.php');
|
|
|
|
INSERT INTO info (info_clef, info_langue, info_texte, info_aide, info_prg, info_description, info_trie, info_actif, info_option1, info_option2, info_option3, info_creation)
|
|
SELECT 'promoteur_hub_section_gestion', 'fr', 'Gestion', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'promoteur_hub_section_gestion' AND info_langue = 'fr' AND info_prg = 'compte.php');
|
|
|
|
INSERT INTO info (info_clef, info_langue, info_texte, info_aide, info_prg, info_description, info_trie, info_actif, info_option1, info_option2, info_option3, info_creation)
|
|
SELECT 'promoteur_hub_section_gestion', 'en', 'Management', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'promoteur_hub_section_gestion' AND info_langue = 'en' AND info_prg = 'compte.php');
|
|
|
|
INSERT INTO info (info_clef, info_langue, info_texte, info_aide, info_prg, info_description, info_trie, info_actif, info_option1, info_option2, info_option3, info_creation)
|
|
SELECT 'promoteur_hub_btn_tableau', 'fr', 'Tableau de bord', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'promoteur_hub_btn_tableau' AND info_langue = 'fr' AND info_prg = 'compte.php');
|
|
|
|
INSERT INTO info (info_clef, info_langue, info_texte, info_aide, info_prg, info_description, info_trie, info_actif, info_option1, info_option2, info_option3, info_creation)
|
|
SELECT 'promoteur_hub_btn_tableau', 'en', 'Dashboard', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'promoteur_hub_btn_tableau' AND info_langue = 'en' AND info_prg = 'compte.php');
|
|
|
|
INSERT INTO info (info_clef, info_langue, info_texte, info_aide, info_prg, info_description, info_trie, info_actif, info_option1, info_option2, info_option3, info_creation)
|
|
SELECT 'promoteur_hub_btn_mobile', 'fr', 'Inscriptions mobile', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'promoteur_hub_btn_mobile' AND info_langue = 'fr' AND info_prg = 'compte.php');
|
|
|
|
INSERT INTO info (info_clef, info_langue, info_texte, info_aide, info_prg, info_description, info_trie, info_actif, info_option1, info_option2, info_option3, info_creation)
|
|
SELECT 'promoteur_hub_btn_mobile', 'en', 'Mobile registrations', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'promoteur_hub_btn_mobile' AND info_langue = 'en' AND info_prg = 'compte.php');
|
|
|
|
INSERT INTO info (info_clef, info_langue, info_texte, info_aide, info_prg, info_description, info_trie, info_actif, info_option1, info_option2, info_option3, info_creation)
|
|
SELECT 'promoteur_hub_menu', 'fr', 'Mes evenements (promoteur)', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'promoteur_hub_menu' AND info_langue = 'fr' AND info_prg = 'compte.php');
|
|
|
|
INSERT INTO info (info_clef, info_langue, info_texte, info_aide, info_prg, info_description, info_trie, info_actif, info_option1, info_option2, info_option3, info_creation)
|
|
SELECT 'promoteur_hub_menu', 'en', 'My events (promoter)', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'promoteur_hub_menu' AND info_langue = 'en' AND info_prg = 'compte.php');
|
|
|
|
INSERT INTO info (info_clef, info_langue, info_texte, info_aide, info_prg, info_description, info_trie, info_actif, info_option1, info_option2, info_option3, info_creation)
|
|
SELECT 'promoteur_hub_empty', 'fr', 'Aucun evenement accessible pour le moment.', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'promoteur_hub_empty' AND info_langue = 'fr' AND info_prg = 'compte.php');
|
|
|
|
INSERT INTO info (info_clef, info_langue, info_texte, info_aide, info_prg, info_description, info_trie, info_actif, info_option1, info_option2, info_option3, info_creation)
|
|
SELECT 'promoteur_hub_empty', 'en', 'No accessible events at this time.', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'promoteur_hub_empty' AND info_langue = 'en' AND info_prg = 'compte.php');
|
|
|
|
-- Lignes poubelle (auto-créées par afficheTexte) : remettre le libellé par défaut
|
|
UPDATE info SET info_texte = 'Acces a vos tableaux de bord par evenement.'
|
|
WHERE info_clef = 'promoteur_hub_intro' AND info_langue = 'fr' AND info_prg = 'compte.php' AND info_texte = info_clef;
|
|
|
|
UPDATE info SET info_texte = 'Access your event dashboards.'
|
|
WHERE info_clef = 'promoteur_hub_intro' AND info_langue = 'en' AND info_prg = 'compte.php' AND info_texte = info_clef;
|
|
|
|
UPDATE info SET info_texte = 'Mon espace client MS1'
|
|
WHERE info_clef = 'promoteur_hub_link_participant' AND info_langue = 'fr' AND info_prg = 'compte.php' AND info_texte = info_clef;
|
|
|
|
UPDATE info SET info_texte = 'My MS1 client space'
|
|
WHERE info_clef = 'promoteur_hub_link_participant' AND info_langue = 'en' AND info_prg = 'compte.php' AND info_texte = info_clef;
|
|
|
|
UPDATE info SET info_texte = 'Nouveautes MS1'
|
|
WHERE info_clef = 'promoteur_hub_annonces_titre' AND info_langue = 'fr' AND info_prg = 'compte.php' AND info_texte = info_clef;
|
|
|
|
UPDATE info SET info_texte = 'MS1 updates'
|
|
WHERE info_clef = 'promoteur_hub_annonces_titre' AND info_langue = 'en' AND info_prg = 'compte.php' AND info_texte = info_clef;
|
|
|
|
UPDATE info SET info_texte = 'En vedette'
|
|
WHERE info_clef = 'promoteur_hub_section_highlight' AND info_langue = 'fr' AND info_prg = 'compte.php' AND info_texte = info_clef;
|
|
|
|
UPDATE info SET info_texte = 'Highlights'
|
|
WHERE info_clef = 'promoteur_hub_section_highlight' AND info_langue = 'en' AND info_prg = 'compte.php' AND info_texte = info_clef;
|
|
|
|
UPDATE info SET info_texte = 'Tableau de bord'
|
|
WHERE info_clef = 'promoteur_hub_btn_tableau' AND info_langue = 'fr' AND info_prg = 'compte.php' AND info_texte = info_clef;
|
|
|
|
UPDATE info SET info_texte = 'Dashboard'
|
|
WHERE info_clef = 'promoteur_hub_btn_tableau' AND info_langue = 'en' AND info_prg = 'compte.php' AND info_texte = info_clef;
|