<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha1/dist/css/bootstrap.min.css" rel="stylesheet"
        integrity="sha384-GLhlTQ8iRABdZLl6O3oVMWSktQOp6b7In1Zl3/Jr59b6EGGoI1aFkw7cmDA6j6gD" crossorigin="anonymous">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.3.0/css/all.min.css"
        integrity="sha512-SzlrxWUlpfuzQ+pcUCosxcglQRNAq/DZjVsC0lE40xsADsfeQoEypE+enwcOiGjk/bSuGGKHEyjSoQ1zVisanQ=="
        crossorigin="anonymous" referrerpolicy="no-referrer" />
</head>
</html>
<?php

/**
 * Controls Draft
 */

namespace Extendify;

defined('ABSPATH') || die('No direct access.');


/**
 * The controller for interacting with site settings
 */

class SiteSettings
{
    /**
     * Get when the site was created
     *
     * @return string|NULL
     */
    public static function getSiteCreatedAt()
    {
        $cacheKey = 'extendify_site_created_at';
        $cached = \wp_cache_get($cacheKey);
        if ($cached) {
            return $cached;
        }

        $userOne = \get_userdata(1);
        if ($userOne) {
            $createdAt = $userOne->user_registered;
            \wp_cache_set($cacheKey, $createdAt);
            return $createdAt;
        }

        $wpdb = $GLOBALS['wpdb'];
        // phpcs:ignore WordPress.DB.DirectDatabaseQuery
        $result = $wpdb->get_row($wpdb->prepare(
            'SELECT CREATE_TIME
            FROM INFORMATION_SCHEMA.TABLES
            WHERE TABLE_SCHEMA = %s
            AND TABLE_NAME = %s
            LIMIT 1',
            $wpdb->dbname,
            $wpdb->posts
        ));
        if (!property_exists($result, 'CREATE_TIME')) {
            return null;
        }

        $createdAt = gmdate(
            'Y-m-d H:i:s',
            strtotime($result->CREATE_TIME)
        );
        \wp_cache_set($cacheKey, $createdAt);
        return $createdAt;
    }
}
