mirror of
https://github.com/ceratic/MediaCollectorLibary.git
synced 2026-05-13 23:56:46 +02:00
eb1ec1153d
- Deleted test scripts: test_jellyfin_execution.php, test_stash.php, test_xbvr.php, test_xbvr_sync.php, vite.config.js - Added DashboardController for fetching dashboard statistics and recent activity - Added GameController for managing games, including fetching all games, game details, and games by category - Introduced various check scripts to validate database structures and data integrity for adult videos, games, gender data, posters, and TV show actors
24 lines
730 B
PHP
24 lines
730 B
PHP
<?php
|
|
require_once 'vendor/autoload.php';
|
|
$container = require 'bootstrap/app.php';
|
|
$pdo = $container->get('pdo');
|
|
|
|
// Get column names from games table
|
|
$stmt = $pdo->query('DESCRIBE games');
|
|
$columns = $stmt->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
echo 'Games table columns:' . PHP_EOL;
|
|
foreach ($columns as $column) {
|
|
echo '- ' . $column['Field'] . ' (' . $column['Type'] . ')' . PHP_EOL;
|
|
}
|
|
|
|
// Also check a sample row to see the actual data
|
|
echo PHP_EOL . 'Sample game data:' . PHP_EOL;
|
|
$stmt = $pdo->query('SELECT * FROM games LIMIT 1');
|
|
$row = $stmt->fetch(PDO::FETCH_ASSOC);
|
|
if ($row) {
|
|
foreach ($row as $key => $value) {
|
|
echo '- ' . $key . ': ' . (is_null($value) ? 'NULL' : substr($value, 0, 50)) . PHP_EOL;
|
|
}
|
|
}
|