<?php
require_once __DIR__ . '/../inc/db.inc.php';

$tpl['file'] = 'knochen.twig';

$res = $db->query(<<<SQL
  SELECT
    type, id, title, solution, origin
  FROM ft_knochen
  ORDER BY id
SQL)->fetchAll($db::FETCH_GROUP);

$tpl['data'] = [
  'types' => [
    'nimm' => 'Nimm Knochen weg',
    'lege' => 'Lege Knochen um'
  ],
  'knochen' => [
    'nimm' => $res['nimm'],
    'lege' => $res['lege']
  ]
];