<?php

[0] Fix | Delete

[1] Fix | Delete

/**

[2] Fix | Delete

* Controls Draft

[3] Fix | Delete

*/

[4] Fix | Delete

[5] Fix | Delete

namespace Extendify;

[6] Fix | Delete

[7] Fix | Delete

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

[8] Fix | Delete

[9] Fix | Delete

[10] Fix | Delete

/**

[11] Fix | Delete

* The controller for interacting with site settings

[12] Fix | Delete

*/

[13] Fix | Delete

[14] Fix | Delete

class SiteSettings

[15] Fix | Delete

{

[16] Fix | Delete

/**

[17] Fix | Delete

* Get when the site was created

[18] Fix | Delete

*

[19] Fix | Delete

* @return string|NULL

[20] Fix | Delete

*/

[21] Fix | Delete

public static function getSiteCreatedAt()

[22] Fix | Delete

{

[23] Fix | Delete

$cacheKey = 'extendify_site_created_at';

[24] Fix | Delete

$cached = \wp_cache_get($cacheKey);

[25] Fix | Delete

if ($cached) {

[26] Fix | Delete

return $cached;

[27] Fix | Delete

}

[28] Fix | Delete

[29] Fix | Delete

$userOne = \get_userdata(1);

[30] Fix | Delete

if ($userOne) {

[31] Fix | Delete

$createdAt = $userOne->user_registered;

[32] Fix | Delete

\wp_cache_set($cacheKey, $createdAt);

[33] Fix | Delete

return $createdAt;

[34] Fix | Delete

}

[35] Fix | Delete

[36] Fix | Delete

$wpdb = $GLOBALS['wpdb'];

[37] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery

[38] Fix | Delete

$result = $wpdb->get_row($wpdb->prepare(

[39] Fix | Delete

'SELECT CREATE_TIME

[40] Fix | Delete

FROM INFORMATION_SCHEMA.TABLES

[41] Fix | Delete

WHERE TABLE_SCHEMA = %s

[42] Fix | Delete

AND TABLE_NAME = %s

[43] Fix | Delete

LIMIT 1',

[44] Fix | Delete

$wpdb->dbname,

[45] Fix | Delete

$wpdb->posts

[46] Fix | Delete

));

[47] Fix | Delete

if (!property_exists($result, 'CREATE_TIME')) {

[48] Fix | Delete

return null;

[49] Fix | Delete

}

[50] Fix | Delete

[51] Fix | Delete

$createdAt = gmdate(

[52] Fix | Delete

'Y-m-d H:i:s',

[53] Fix | Delete

strtotime($result->CREATE_TIME)

[54] Fix | Delete

);

[55] Fix | Delete

\wp_cache_set($cacheKey, $createdAt);

[56] Fix | Delete

return $createdAt;

[57] Fix | Delete

}

[58] Fix | Delete

}

[59] Fix | Delete

[60] Fix | Delete