if ($this->showPublicLink) { $this->Dataset->displayPublicIcon(); } $this->Dataset->displayTableColumns(); echo '</tr>'; } } else { echo ' <tr class="r' . $trClass . '"> <td class="l" style="width:24px;">'; foreach ($day['shorts'] as $short) { $this->Dataset->setActivityData($short); $this->Dataset->displayShortLink(); } echo '</td> <td class="l as-small-as-possible">' . Dataset::getDateString($day['date']) . '</td> <td colspan="' . ($this->Dataset->cols() + $this->showPublicLink) . '"></td> </tr>'; } } echo '</tbody>'; echo '<tbody>'; // Z U S A M M E N F A S S U N G $WhereNotPrivate = FrontendShared::$IS_SHOWN && !\Runalyze\Configuration::Privacy()->showPrivateActivitiesInList() ? 'AND is_public=1' : ''; $sports = DB::getInstance()->query('SELECT `id`, `time`, `sportid`, SUM(1) as `num` FROM `' . PREFIX . 'training` WHERE `time` BETWEEN ' . ($this->timestamp_start - 10) . ' AND ' . ($this->timestamp_end - 10) . ' AND accountid = ' . SessionAccountHandler::getId() . ' ' . $WhereNotPrivate . ' GROUP BY `sportid` ORDER BY `num` DESC')->fetchAll(); foreach ($sports as $i => $sportdata) { $Sport = new Sport($sportdata['sportid']); echo '<tr class="r no-zebra"> <td colspan="' . $this->additionalColumns . '"> <small>' . $sportdata['num'] . 'x</small> ' . $Sport->name() . '