X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;ds=sidebyside;f=modules%2Fxnet.php;h=2c048356d4220fc7673fe24fe2382783a310fab8;hb=67e06366aa6d020c4e1ed3bfcb36cb877eae1829;hp=c76bf3a6b37e6376474f98bc59e04bfbd3a1c41d;hpb=1f58ccb1e75eca08fbd04971d617ea372bc77b5a;p=platal.git diff --git a/modules/xnet.php b/modules/xnet.php index c76bf3a..2c04835 100644 --- a/modules/xnet.php +++ b/modules/xnet.php @@ -114,12 +114,24 @@ class XnetModule extends PLModule if (Post::has('diminutif')) { S::assert_xsrf_token(); - XDB::query('INSERT INTO groupex.asso (id,diminutif) - VALUES(NULL,{?})', Post::v('diminutif')); - pl_redirect('../'.Post::v('diminutif').'/edit'); + $res = XDB::query('SELECT COUNT(*) + FROM groupex.asso + WHERE diminutif = {?}', + Post::v('diminutif')); + + if ($res->fetchOneCell() == 0) { + XDB::execute('INSERT INTO groupex.asso (id, diminutif) + VALUES (NULL, {?})', + Post::v('diminutif')); + pl_redirect('../' . Post::v('diminutif') . '/edit'); + } else { + $page->trigError('Le diminutif demandé est déjà pris.'); + } } - $res = XDB::query('SELECT nom,diminutif FROM groupex.asso ORDER by NOM'); + $res = XDB::query('SELECT nom, diminutif + FROM groupex.asso + ORDER BY nom'); $page->assign('assos', $res->fetchAllAssoc()); }