<?
require_once '../config.php';
require_once '../libraries/medoo/medoo.php';

$mdb = new medoo( [
  'database_type' => 'mysql',
  'database_name' => $database['name'],
  'server'        => $database['host'],
  'username'      => $database['user'],
  'password'      => $database['password'],
  'charset'       => 'utf8'
] );

$current_ver = 1693; // aktualizowane automatycznie przez build-update.ps1

// 1. Skan filesystem Ă˘â‚¬â€ť lista istniejĂ„â€¦cych ZIPÄ‚Ĺ‚w
$versions = [];
for ( $i = 1; $i <= $current_ver; $i++ )
{
  $dir         = substr( number_format( $i / 1000, 3 ), 0, strlen( number_format( $i / 1000, 3 ) ) - 2 ) . '0';
  $version_old = number_format( $i / 1000, 2 );
  $version_new = number_format( $i / 1000, 3 );

  if ( file_exists( '../updates/' . $dir . '/ver_' . $version_old . '.zip' ) )
    $versions[] = $version_old;

  if ( file_exists( '../updates/' . $dir . '/ver_' . $version_new . '.zip' ) )
    $versions[] = $version_new;
}
$versions = array_unique( $versions );

// 2. Walidacja klucza licencji
$license = $mdb->get( 'pp_update_licenses', '*', [ 'key' => ( $_GET['key'] ?? '' ) ] );
if ( !$license )
  die();

// 3. SprawdÄąĹź waÄąÄ˝noÄąâ€şĂ„â€ˇ daty
if ( $license['valid_to_date'] && $license['valid_to_date'] < date( 'Y-m-d' ) )
  die();

// 4. Auto-discovery: rejestruj nowe ZIPy jako beta
$known = array_flip( $mdb->select( 'pp_update_versions', 'version', [] ) ?: [] );
foreach ( $versions as $ver )
{
  if ( !isset( $known[$ver] ) )
  {
    @$mdb->insert( 'pp_update_versions', [
      'version'    => $ver,
      'channel'    => 'beta',
      'created_at' => date( 'Y-m-d H:i:s' )
    ] );
    $known[$ver] = true;
  }
}

// 5. Filtruj wersje wg kanaÄąâ€šu (beta widzi beta+stable, reszta tylko stable)
$channels = $license['beta'] ? [ 'beta', 'stable' ] : [ 'stable' ];
$allowed  = array_flip( $mdb->select( 'pp_update_versions', 'version', [ 'channel' => $channels ] ) ?: [] );

// 6. Wypisz dostĂ„â„˘pne wersje
$valid_to_version = $license['valid_to_version'];
foreach ( $versions as $ver )
{
  if ( !isset( $allowed[$ver] ) )
    continue;

  if ( $valid_to_version && $ver > $valid_to_version )
    continue;

  echo $ver . PHP_EOL;
}