<?php
// generate_latest_ca77.php — builds "Latest Registry Entry" snippet for CA77 (atomic write)
// NOTE: This script MUST NOT be directly included in phpBB templates.
// phpBB should only ever include the static file: /shared/include/latest_ca77.html

declare(strict_types=1);

try {
    // --- Environment / timezone ---
    date_default_timezone_set('America/New_York');

    // --- Resolve LimeSurvey DB config (same pattern as CB / CL) ---
    $cfgPath = dirname(__DIR__, 2) . '/application/config/config.php';

    if (!defined('BASEPATH')) {
        // LS config expects BASEPATH defined in some contexts
        define('BASEPATH', true);
    }

    if (!is_file($cfgPath)) {
        throw new RuntimeException("Config not found at: $cfgPath");
    }

    $config = require $cfgPath;
    $db     = $config['components']['db'] ?? null;

    if (!$db
        || empty($db['connectionString'])
        || !array_key_exists('username', $db)
        || !array_key_exists('password', $db)
    ) {
        throw new RuntimeException("DB config missing or incomplete");
    }

    // --- Connect to DB ---
    $pdo = new PDO(
        $db['connectionString'],
        $db['username'],
        $db['password'],
        [
            PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
            PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8mb4",
        ]
    );

    // --- Fetch newest completed CA entry ---
    // Assumes h305_ca77_entries is either a view or table already filtered to "completed" rows
    $sql = "
        SELECT
            model_year,
            model,
            ADM_StateOrProvince,
            ADM_Country,
            condition_value,
            opinion_value_today
        FROM h305_ca77_entries
        ORDER BY submitdate DESC, id DESC
        LIMIT 1
    ";

    $row = $pdo->query($sql)->fetch(PDO::FETCH_ASSOC);

    // --- Helpers for casing normalization (same pattern as CB / CL) ---
    $keepCaps = static function (string $w): bool {
        // Keep original word case if it's already an acronym (2+ caps) or has a digit
        return (bool)preg_match('/[A-Z]{2,}/', $w) || (bool)preg_match('/\d/', $w);
    };

    $word = static function (?string $w) use ($keepCaps): string {
        if ($w === null || $w === '') {
            return '';
        }

        // Respect hyphenated parts independently
        if (strpos($w, '-') !== false) {
            $parts = explode('-', $w);
            foreach ($parts as &$x) {
                $x = $keepCaps($x) ? $x : ucfirst(strtolower($x));
            }
            return implode('-', $parts);
        }

        // Already looks like an acronym or has digits -> leave alone
        if ($keepCaps($w)) {
            return $w;
        }

        $dot  = substr($w, -1) === '.';
        $base = $dot ? substr($w, 0, -1) : $w;
        $done = ucfirst(strtolower($base));
        return $dot ? ($done . '.') : $done;
    };

    $titleCase = static function (?string $s) use ($word): string {
        if ($s === null) {
            return '';
        }
        $s = trim($s);
        if ($s === '') {
            return '';
        }
        $t = preg_split('/\s+/', $s) ?: [];
        foreach ($t as &$x) {
            $x = $word($x);
        }
        return trim(implode(' ', $t), ", ");
    };

    // --- Build display line ---
    if (!$row) {
        $line = 'Latest Registry Entry: No completed entries found.';
    } else {
        // Location: "WA, Australia" (skip empties, title-case each part)
        $region  = $titleCase($row['ADM_StateOrProvince'] ?? '');
        $country = $titleCase($row['ADM_Country']        ?? '');
        $loc     = trim(
            implode(', ', array_filter([$region, $country], static fn($v) => $v !== '')),
            ', '
        );

        // Normalize opinion_value_today using CL rules:
        //  >=1000        => use as-is ($12500 => $12,500)
        //  100..999      => treat as dollars ($750 => $750)
        //  1..99         => treat as thousands (6 => $6,000)
        //  otherwise     => "Not Entered"
        $valFinal = 'Not Entered';
        if (isset($row['opinion_value_today']) && $row['opinion_value_today'] !== '') {
            $n = (float)$row['opinion_value_today'];
            if ($n >= 1000) {
                $valFinal = '$' . number_format($n, 0);
            } elseif ($n >= 100) {
                $valFinal = '$' . number_format($n, 0);
            } elseif ($n > 0) {
                $valFinal = '$' . number_format($n * 1000, 0);
            }
        }

        // Condition decoding (same mapping you provided, with fallback)
        $condRaw = $row['condition_value'] ?? '';
        $condMap = [
            'E'    => 'Excellent',
            'Exc'  => 'Excellent',
            'G'    => 'Good',
            'Goo'  => 'Good',
            'F'    => 'Fair',
            'P'    => 'Poor',
            'Par'  => 'Parts Bike',
            'R'    => 'Restored',
            'Res'  => 'Restored',
            'Rat'  => 'Rat',
        ];
        $condNice = $condMap[$condRaw] ?? ($condRaw !== '' ? $condRaw : 'Not Entered');

        // Gracefully handle blanks so we don't get double-spaces like " Honda "
        $yr    = isset($row['model_year']) ? trim((string)$row['model_year']) : '';
        $model = isset($row['model'])      ? trim((string)$row['model'])      : '';

        $bikePart = trim($yr . ' Honda ' . $model);
        $locPart  = $loc !== '' ? (' — ' . $loc) : '';

        $line = 'Latest Registry Entry: '
              . $bikePart
              . $locPart
              . ' — Condition: ' . $condNice
              . ' — Value: ' . $valFinal;
    }

    // --- Build final HTML snippet (static, safe to INCLUDEPHP in phpBB) ---
    $builtTs = (new DateTime('now'))->format('Y-m-d H:i:s T');

    // These first two lines are harmless in phpBB output: <meta> and <!-- built: ... -->
    $charset = '<meta charset="utf-8">';
    $stamp   = '<!-- built: ' . htmlspecialchars($builtTs, ENT_QUOTES, 'UTF-8') . ' -->';

    $htmlOut = $charset . "\n" . $stamp . "\n" . $line . "\n";

    // --- Write atomically to shared include dir ---
    $jobDir     = __DIR__; // wherever this script lives
    $includeDir = '/home/mstoic3/public_html/shared/include';

    $includeTmp = $includeDir . '/latest_ca77.tmp';
    $includeDst = $includeDir . '/latest_ca77.html';

    $jsonPath   = $jobDir . '/latest_ca77.json';
    $logPath    = $jobDir . '/logs/latest_ca77.log'; // reserved for future logging

    if (!is_dir($includeDir)) {
        if (!mkdir($includeDir, 0755, true) && !is_dir($includeDir)) {
            throw new RuntimeException("Failed to create include dir: $includeDir");
        }
    }

    if (file_put_contents($includeTmp, $htmlOut, LOCK_EX) === false) {
        throw new RuntimeException('Failed to write temp include file');
    }

    if (!rename($includeTmp, $includeDst)) {
        @unlink($includeTmp);
        throw new RuntimeException('Failed to move include into place');
    }

    // --- Optional JSON breadcrumb for debugging / external consumption ---
    @file_put_contents(
        $jsonPath,
        json_encode(
            [
                'line'  => $line,
                'stamp' => $builtTs,
                'ts'    => date('c'),
            ],
            JSON_UNESCAPED_UNICODE
        )
    );

    // --- Done ---
    echo "OK\n";
    exit(0);

} catch (Throwable $e) {
    // Minimal error surface; log server-side, generic public output
    error_log("[generate_latest_ca77.php] " . $e->getMessage());

    if (function_exists('http_response_code')) {
        @http_response_code(500);
    }

    echo "ERROR\n";
    exit(1);
}

<form action="./ucp.php?mode=login" method="post" id="login" data-focus="username">
<div class="panel">
	<div class="inner">

	<div class="content">
		<h2 class="login-title">You need to login in order to reply to topics within this forum.</h2>

		<fieldset class="fields1">
				<dl>
			<dt><label for="username">Username:</label></dt>
			<dd><input type="text" tabindex="1" name="username" id="username" size="25" value="" class="inputbox autowidth" /></dd>
		</dl>
		<dl>
			<dt><label for="password">Password:</label></dt>
			<dd><input type="password" tabindex="2" id="password" name="password" size="25" class="inputbox autowidth" autocomplete="off" /></dd>
							<dd><a href="./ucp.php?mode=sendpassword">I forgot my password</a></dd>									</dl>
						<dl>
			<dd><label for="autologin"><input type="checkbox" name="autologin" id="autologin" tabindex="4" /> Remember me</label></dd>			<dd><label for="viewonline"><input type="checkbox" name="viewonline" id="viewonline" tabindex="5" /> Hide my online status this session</label></dd>
		</dl>
		
		<input type="hidden" name="redirect" value="./posting.php?f=38&amp;mode=reply&amp;t=7632609" />
<input type="hidden" name="creation_time" value="1761341385" />
<input type="hidden" name="form_token" value="184d54e4f9dac2a983a9ac41600a2f83e964df36" />

		
		<dl>
			<dt>&nbsp;</dt>
			<dd><input type="hidden" name="sid" value="c2e3c63d08c87f7f942b40e872293004" />
<input type="submit" name="login" tabindex="6" value="Login" class="button1" /></dd>
		</dl>
		</fieldset>
	</div>

		</div>
</div>


	<div class="panel">
		<div class="inner">

		<div class="content">
			<h3>Register</h3>
			<p>In order to login you must be registered. Registering takes only a few moments but gives you increased capabilities. The board administrator may also grant additional permissions to registered users. Before you register please ensure you are familiar with our terms of use and related policies. Please ensure you read any forum rules as you navigate around the board.</p>
			<p><strong><a href="./ucp.php?mode=terms">Terms of use</a> | <a href="./ucp.php?mode=privacy">Privacy policy</a></strong></p>
			<hr class="dashed" />
			<p><a href="./ucp.php?mode=register" class="button2">Register</a></p>
		</div>

		</div>
	</div>

</form>

</div>


<footer id="page-footer" class="page-footer" role="contentinfo">

  
  <!-- Responsive Footer Ad Block (keep) -->
  <div class="h305.F-ad-container">
    <ins class="adsbygoogle"
         style="display:block"
         data-ad-client="ca-pub-3173058076347933"
         data-ad-slot="3441384405"
         data-ad-format="auto"
         data-full-width-responsive="true"></ins>
    <script>
      (adsbygoogle = window.adsbygoogle || []).push({});
    </script>
  </div>

  <!-- Legacy Footer Content (kept, minus old hard-wired nav) -->
  <div class="h305.F-footer-legacy">
    <div></div>
    <div></div>

    <hr class="h305.F-footer-line">

  <!-- === p406: mount shared footer-nav (forum only) === -->
  <div id="h305-footer-nav"></div>
  <script src="/shared/js/h305-footer-nav.js" defer></script>
  <!-- === p406 end === -->

    <hr class="h305.F-footer-line-thin">
  </div>
</footer>

<!-- JS Assets -->
<script src="./assets/javascript/jquery.min.js?assets_version=34"></script>
<script src="./assets/javascript/core.js?assets_version=34"></script>


</body>
</html>