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.
29 lines
1.2 KiB
SQL
29 lines
1.2 KiB
SQL
-- MSIN-info — Inventaire table info (exécuter sur CHAQUE base : backup d'avant sync, prod actuelle, dev)
|
|
-- Exporter les résultats (CSV) et comparer dans Navicat ou Excel.
|
|
-- Ne modifie rien.
|
|
|
|
-- 1) Volume global
|
|
SELECT 'info_total' AS k, COUNT(*) AS v FROM info
|
|
UNION ALL
|
|
SELECT 'info_poubelle', COUNT(*) FROM info WHERE info_texte = info_clef
|
|
UNION ALL
|
|
SELECT 'info_promoteur_hub', COUNT(*) FROM info WHERE info_clef LIKE 'promoteur_hub_%';
|
|
|
|
-- 2) Clés hub promoteur (souvent les premières manquantes)
|
|
SELECT info_clef, info_langue, info_actif,
|
|
CASE WHEN info_texte = info_clef THEN 'POUBELLE' ELSE 'OK' END AS etat,
|
|
LEFT(info_texte, 80) AS extrait
|
|
FROM info
|
|
WHERE info_clef LIKE 'promoteur_hub_%'
|
|
ORDER BY info_clef, info_langue;
|
|
|
|
-- 3) Lignes poubelle restantes (auto-créées par afficheTexte pendant fenêtre vide)
|
|
SELECT info_clef, info_langue, info_prg, info_texte
|
|
FROM info
|
|
WHERE info_texte = info_clef
|
|
ORDER BY info_prg, info_clef, info_langue
|
|
LIMIT 500;
|
|
|
|
-- 4) Export complet pour diff externe (décommenter si besoin — peut être gros)
|
|
-- SELECT info_clef, info_langue, info_prg, info_texte, info_actif FROM info ORDER BY info_clef, info_langue, info_prg;
|