X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=include%2Fvalidations%2Fpaiements.inc.php;h=aab352e597b46d4e0614e1180b130f9f6526f42e;hb=d645ceb701b0e8aa1de2e5271bed35e56ef169f1;hp=094252970b15c8c5ded7f9ae255c4ae6e5653ec4;hpb=5660032ac785d410f90e3f5b0d6948dc90b0cfea;p=platal.git diff --git a/include/validations/paiements.inc.php b/include/validations/paiements.inc.php index 0942529..aab352e 100644 --- a/include/validations/paiements.inc.php +++ b/include/validations/paiements.inc.php @@ -1,6 +1,6 @@ montant_max = $_montantmax; if ($_asso_id) { - $res = XDB::query("SELECT nom FROM #groupex#.asso WHERE id = {?}", $_asso_id); + $res = XDB::query("SELECT nom FROM groups WHERE id = {?}", $_asso_id); $this->asso = $res->fetchOneCell(); } if ($_asso_id && $_evt) { - $res = XDB::query("SELECT intitule FROM #groupex#.evenements WHERE asso_id = {?} AND eid = {?}", $_asso_id, $_evt); + $res = XDB::query("SELECT intitule FROM group_events WHERE asso_id = {?} AND eid = {?}", $_asso_id, $_evt); $this->evt_intitule = $res->fetchOneCell(); } } @@ -165,9 +165,9 @@ Si le télépaiement n'est pas lié à un groupe ou supérieur à 51 euros, lais public function commit() { - $res = XDB::query("SELECT MAX(id) FROM #paiement#.paiements"); + $res = XDB::query("SELECT MAX(id) FROM payments"); $id = $res->fetchOneCell()+1; - $ret = XDB::execute("INSERT INTO #paiement#.paiements VALUES + $ret = XDB::execute("INSERT INTO payments VALUES ( {?}, {?}, {?}, '', {?}, {?}, {?}, {?}, {?}, {?} ) @@ -176,18 +176,18 @@ Si le télépaiement n'est pas lié à un groupe ou supérieur à 51 euros, lais $this->montant, $this->montant_min, $this->montant_max, $this->user->bestEmail(), $this->msg_reponse, $this->asso_id); if ($this->asso_id && $this->evt) { - XDB::execute("UPDATE #groupex#.evenements + XDB::execute("UPDATE group_events SET paiement_id = {?} WHERE asso_id = {?} AND eid = {?}", $id, $this->asso_id, $this->evt); $res = XDB::query("SELECT a.nom, a.diminutif, e.intitule - FROM #groupex#.asso AS a - INNER JOIN #groupex#.evenements AS e ON (a.id = e.asso_id) + FROM groups AS a + INNER JOIN group_events AS e ON (a.id = e.asso_id) WHERE e.eid = {?}", $this->evt); list($nom, $diminutif, $evt) = $res->fetchOneRow(); require_once dirname(__FILE__) . '/../../modules/xnetevents/xnetevents.inc.php'; - $participants = get_event_participants(get_event_detail($this->evt, false, $this->asso_id), null, 'nom'); + $participants = get_event_participants(get_event_detail($this->evt, false, $this->asso_id), null); foreach ($participants as &$u) { if (!$u['notify_payment']) { continue;