l.address AS l_address,
l.zipcode AS l_zipcode,
l.city AS l_city,
- l.short AS l_short,
l.title AS l_title,
l.latitude AS l_latitude,
l.longitude AS l_longitude,
p.description AS p_description,
p.class AS p_class,
p.short AS p_short,
+ p.hat AS p_hat,
p.rate AS p_rate,
p.contact AS p_contact,
p.donate AS p_donate,
->addScalarResult('l_city', 'l_city', 'string')
->addScalarResult('l_latitude', 'l_latitude', 'float')
->addScalarResult('l_longitude', 'l_longitude', 'float')
- ->addScalarResult('l_short', 'l_short', 'string')
->addScalarResult('l_title', 'l_title', 'string')
->addScalarResult('t_id', 't_id', 'integer')
->addScalarResult('t_title', 't_title', 'string')
->addScalarResult('p_description', 'p_description', 'string')
->addScalarResult('p_class', 'p_class', 'string')
->addScalarResult('p_short', 'p_short', 'string')
+ ->addScalarResult('p_hat', 'p_hat', 'integer')
->addScalarResult('p_rate', 'p_rate', 'integer')
->addScalarResult('p_contact', 'p_contact', 'string')
->addScalarResult('p_donate', 'p_donate', 'string')
s.created,
s.updated,
s.location_id AS l_id,
- l.short AS l_short,
l.title AS l_title,
l.address AS l_address,
l.zipcode AS l_zipcode,
->addScalarResult('created', 'created', 'datetime')
->addScalarResult('updated', 'updated', 'datetime')
->addScalarResult('l_id', 'l_id', 'integer')
- ->addScalarResult('l_short', 'l_short', 'string')
->addScalarResult('l_title', 'l_title', 'string')
->addScalarResult('l_address', 'l_address', 'string')
->addScalarResult('l_zipcode', 'l_zipcode', 'string')
ADDDATE(ADDTIME(s.date, s.begin), INTERVAL IF(s.slot_id = :afterid, 1, 0) DAY) AS start,
ADDDATE(ADDTIME(ADDTIME(s.date, s.begin), s.length), INTERVAL IF(s.slot_id = :afterid, 1, 0) DAY) AS stop,
s.location_id AS l_id,
- l.short AS l_short,
l.title AS l_title,
s.slot_id AS t_id,
t.title AS t_title,
->addScalarResult('t_id', 't_id', 'integer')
->addScalarResult('t_title', 't_title', 'string')
->addScalarResult('l_id', 'l_id', 'integer')
- ->addScalarResult('l_short', 'l_short', 'string')
->addScalarResult('l_title', 'l_title', 'string')
->addScalarResult('a_id', 'a_id', 'integer')
->addScalarResult('a_canceled', 'a_canceled', 'datetime')
'id' => $session['id'],
'start' => $session['start'],
'stop' => $session['stop'],
- 'location' => $translator->trans($session['l_short']),
+ 'location' => $translator->trans($session['l_title']),
'pseudonym' => $pseudonym,
'class' => $class,
'slot' => self::GLYPHS[$session['t_title']],
ADDDATE(ADDTIME(s.date, s.begin), INTERVAL IF(s.slot_id = :afterid, 1, 0) DAY) AS start,
ADDDATE(ADDTIME(ADDTIME(s.date, s.begin), s.length), INTERVAL IF(s.slot_id = :afterid, 1, 0) DAY) AS stop,
s.location_id AS l_id,
- l.short AS l_short,
l.title AS l_title,
s.slot_id AS t_id,
t.title AS t_title,
->addScalarResult('t_id', 't_id', 'integer')
->addScalarResult('t_title', 't_title', 'string')
->addScalarResult('l_id', 'l_id', 'integer')
- ->addScalarResult('l_short', 'l_short', 'string')
->addScalarResult('l_title', 'l_title', 'string')
->addScalarResult('a_id', 'a_id', 'integer')
->addScalarResult('au_id', 'au_id', 'integer')
'id' => $session['id'],
'start' => $session['start'],
'stop' => $session['stop'],
- 'location' => $translator->trans($session['l_short']),
+ 'location' => $translator->trans($session['l_title']),
'pseudonym' => $pseudonym,
'class' => $class,
'slot' => self::GLYPHS[$session['t_title']],