X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Fevents.php;h=eebfa82c219636e5f99ef61de91d88549220654f;hb=b6dcc0b3f53ce1252bcce82b49ffaf591ec59947;hp=d333d0c633cf84fe1d5c750a96a6ed058c0be0d3;hpb=b58e5ac25d105716cef952d5c3933c695e357cbe;p=platal.git diff --git a/modules/events.php b/modules/events.php index d333d0c..eebfa82 100644 --- a/modules/events.php +++ b/modules/events.php @@ -64,11 +64,11 @@ class EventsModule extends PLModule do { $priority = (int)($priority/2); $res = XDB::query("SELECT * - FROM tips + FROM reminder_tips WHERE (expiration = '0000-00-00' OR expiration > CURDATE()) AND (promo_min = 0 OR promo_min <= {?}) AND (promo_max = 0 OR promo_max >= {?}) - AND (priorite >= {?}) + AND (priority >= {?}) AND (state = 'active') $exclude ORDER BY RAND() @@ -307,7 +307,7 @@ class EventsModule extends PLModule { $page->setTitle('Administration - Astuces'); $page->assign('title', 'Gestion des Astuces'); - $table_editor = new PLTableEditor('admin/tips', 'tips', 'id'); + $table_editor = new PLTableEditor('admin/tips', 'reminder_tips', 'id'); $table_editor->describe('expiration', 'date de péremption', true); $table_editor->describe('promo_min', 'promo. min (0 aucune)', false); $table_editor->describe('promo_max', 'promo. max (0 aucune)', false);