From e921ca1ea261370c204a615c799109468dd87183 Mon Sep 17 00:00:00 2001 From: x2000habouzit Date: Wed, 24 Nov 2004 13:09:21 +0000 Subject: [PATCH] let the admin index been taken from the database --- htdocs/admin/index.php | 16 ++++++- install.d/skins/install.sql | 1 + install.d/skins/uninstall.sql | 1 + templates/admin/index.tpl | 102 ++++++------------------------------------ upgrade/0.9.3/50_admin.sql | 90 +++++++++++++++++++++++++++++++++++++ 5 files changed, 121 insertions(+), 89 deletions(-) create mode 100644 upgrade/0.9.3/50_admin.sql diff --git a/htdocs/admin/index.php b/htdocs/admin/index.php index 77899c9..79e1ea6 100644 --- a/htdocs/admin/index.php +++ b/htdocs/admin/index.php @@ -18,11 +18,25 @@ * Foundation, Inc., * * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA * *************************************************************************** - $Id: index.php,v 1.5 2004-11-22 20:04:36 x2000habouzit Exp $ + $Id: index.php,v 1.6 2004-11-24 13:09:21 x2000habouzit Exp $ ***************************************************************************/ require_once("xorg.inc.php"); new_admin_page('admin/index.tpl'); +if (!$page->xorg_is_cached()) { + $res = $globals->db->query(" + SELECT h1, h2, texte, url + FROM admin_a AS a + INNER JOIN admin_h2 AS h2 USING(h2id) + INNER JOIN admin_h1 AS h1 USING(h1id) + ORDER BY h1.prio, h2.prio, a.prio"); + $index = Array(); + while(list($h1,$h2,$txt,$url) = mysql_fetch_row($res)) { + $index[$h1][$h2][] = Array('txt' => $txt, 'url'=>$url); + } + $page->assign_by_ref('index', $index); +} + $page->run(); ?> diff --git a/install.d/skins/install.sql b/install.d/skins/install.sql index e9d16f4..33613e6 100644 --- a/install.d/skins/install.sql +++ b/install.d/skins/install.sql @@ -1,4 +1,5 @@ alter table auth_user_quick drop column skin; +insert into admin_a values(5, 'Skins', 'admin/gerer_skins.php', 30); -- -- Table structure for table `skins` diff --git a/install.d/skins/uninstall.sql b/install.d/skins/uninstall.sql index 48a5d9e..2b77ddf 100644 --- a/install.d/skins/uninstall.sql +++ b/install.d/skins/uninstall.sql @@ -1,2 +1,3 @@ alter table auth_user_quick drop column skin; +delete from admin_a where url='admin/gerer_skins.php'; DROP TABLE skins; diff --git a/templates/admin/index.tpl b/templates/admin/index.tpl index 926bf89..e0c887a 100644 --- a/templates/admin/index.tpl +++ b/templates/admin/index.tpl @@ -17,104 +17,30 @@ * Foundation, Inc., * * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA * *************************************************************************** - $Id: index.tpl,v 1.13 2004-10-31 16:46:10 x2000chevalier Exp $ + $Id: index.tpl,v 1.14 2004-11-24 13:09:22 x2000habouzit Exp $ ***************************************************************************}

Administration Polytechnique.org

+{foreach from=$index key=h1 item=index2} - - - - -
Système
- Postfix : - Blacklist   |   - Whitelist masspam   |   - Retardés par masspam -
- Statistiques : - Système   |   - Logs Postfix   |   - Webalizer -
- Sécurité : - Logs des sessions   |   - Actions -
- -
- - - - - - - - + {foreach from=$index2 key=h2 item=index3} + + - -
Contenu du site
- Utilisateurs : - Gestion/SU/Logs   |   - Homonymes   |   - AX/X.org   |   - Décès -
- Infos dynamiques : - Coupures   |   - événements -
- Champs profil : - Formations   |   - Binets   |   - Groupes X   |   - Skins -
- Newsletter : - Liste   |   - Catégories   |   - Adresses en panne -
- Administrer : - Auth Groupes X  |   - Listes -
- Valider demandes : - Valider +
{$h1}
+ {$h2} : + {foreach from=$index3 item=ln name=ln} + {$ln.txt} + {if !$smarty.foreach.ln.last}   |   - événements -
- Trésorerie : - Comptes -   |   - Paiements -
- -
- - - - - - - + {/foreach}
Développement
Trackers : - trackers -   |   - tickets -
CVS : - ViewCVS + {/if} + {/foreach}
-
- - - -
Gestion et entretien
- Reformatage Prenom NOM : - Table auth_user_md5 -
+{/foreach} {* vim:set et sw=2 sts=2 sws=2: *} diff --git a/upgrade/0.9.3/50_admin.sql b/upgrade/0.9.3/50_admin.sql new file mode 100644 index 0000000..7e150bf --- /dev/null +++ b/upgrade/0.9.3/50_admin.sql @@ -0,0 +1,90 @@ +-- +-- Table structure for table `admin_h1` +-- + +CREATE TABLE `admin_h1` ( + `h1id` tinyint(4) NOT NULL default '0', + `h1` varchar(64) NOT NULL default '', + `prio` tinyint(4) NOT NULL default '0', + PRIMARY KEY (h1id), + KEY `prio` (`prio`) +) TYPE=MyISAM; + +insert into admin_h1 values(1, 'Système', 0); +insert into admin_h1 values(2, 'Contenu du site', 10); +insert into admin_h1 values(3, 'Gestion et entretien', 30); + +-- +-- Table structure for table `admin_h2` +-- + +CREATE TABLE `admin_h2` ( + `h1id` tinyint(4) NOT NULL default '0', + `h2id` tinyint(4) NOT NULL default '0', + `h2` varchar(64) NOT NULL default '', + `prio` tinyint(4) NOT NULL default '0', + PRIMARY KEY (h2id), + KEY `prio` (`prio`) +) TYPE=MyISAM; + +insert into admin_h2 values(1, 1, 'Postfix', 0); +insert into admin_h2 values(1, 2, 'Sécurité', 20); + +insert into admin_h2 values(2, 3, 'Utilisateurs', 0); +insert into admin_h2 values(2, 4, 'Infos dynamiques', 10); +insert into admin_h2 values(2, 5, 'Champs profil', 20); +insert into admin_h2 values(2, 6, 'Newsletter', 30); +insert into admin_h2 values(2, 7, 'Administrer', 40); +insert into admin_h2 values(2, 8, 'Valider demandes', 50); +insert into admin_h2 values(2, 9, 'Trésorerie', 60); + +insert into admin_h2 values(3, 10, 'Reformatage Prenom NOM', 0); + +-- +-- Table structure for table `admin_a` +-- + +CREATE TABLE `admin_a` ( + `h2id` tinyint(4) NOT NULL default '0', + `texte` varchar(64) NOT NULL default '', + `url` varchar(64) NOT NULL default '', + `prio` tinyint(4) NOT NULL default '0', + KEY `prio` (`prio`) + +) TYPE=MyISAM; + +insert into admin_a values(1, 'Blacklist', 'admin/postfix_blacklist.php', 0); +insert into admin_a values(1, 'Whitelist', 'admin/postfix_whitelist.php', 10); +insert into admin_a values(1, 'Retardés', 'admin/postfix_delayed.php', 20); + +insert into admin_a values(2, 'Logs des sessions', 'admin/logger.php', 0); +insert into admin_a values(2, 'Actions', 'admin/logger_actions.php', 10); + +insert into admin_a values(3, 'Edit/Su/Logs', 'admin/utilisateurs.php', 0); +insert into admin_a values(3, 'Homonymes', 'admin/homonymes.php', 10); +insert into admin_a values(3, 'AX/X.org', 'admin/ax-xorg.php', 20); +insert into admin_a values(3, 'Décès', 'admin/deces_promo.php', 30); + +insert into admin_a values(4, 'Coupures', 'admin/gerer_coupure.php', 0); +insert into admin_a values(4, 'Événements', 'admin/evenements.php', 10); + +insert into admin_a values(5, 'Formations', 'admin/gerer_applis.php', 0); +insert into admin_a values(5, 'Binets', 'admin/gerer_binets.php', 10); +insert into admin_a values(5, 'Groupes X', 'admin/gerer_groupesx.php', 20); +insert into admin_a values(5, 'Skins', 'admin/gerer_skins.php', 30); + +insert into admin_a values(6, 'Liste', 'admin/newsletter.php', 0); +insert into admin_a values(6, 'Catégories', 'admin/newsletter_cats.php', 10); +insert into admin_a values(6, 'Adresses en panne', 'admin/newsletter_pattecassee.php', 20); + +insert into admin_a values(7, 'Auth Groupes X', 'admin/gerer_auth-groupex.php', 0); +insert into admin_a values(7, 'Listes', 'admin/lists.php', 10); + +insert into admin_a values(8, 'Valider', 'admin/valider.php', 0); +insert into admin_a values(8, 'Événements', 'admin/evenements.php', 10); + +insert into admin_a values(9, 'Comptes', 'admin/gere_operations.php', 0); +insert into admin_a values(9, 'Paiements', 'admin/gerer_paiement.php', 10); + +insert into admin_a values(10, 'Table auth_user_md5', 'admin/FormatePrenomNOM.php', 0); + -- 2.1.4