�PNG  IHDR22?�� pHYs  �� OiCCPPhotoshop ICC profilexڝSgTS�=���BK���KoR RB���&*! J�!��Q�EEȠ�����Q, � ��!���������{�kּ������>���� �H3Q5� �B�������.@� $p�d!s�#�~<<+"��x� �M��0���B�\���t�8K�@z�B�@F���&S�`�cb�P-`'������{[�!�� e�Dh;��V�EX0fK�9�-0IWfH���� � 0Q��){`�##x��F�W<�+��*x��<�$9E�[-qWW.(�I+6aa�@.�y�2�4���������x����6��_-��"bb���ϫp@�t~��,/��;�m��%�h^ �u��f�@����W�p�~<�5�j>{�-�]c�K'Xt����o��(�h���w��?�G�%�fI�q^D$.Tʳ?�D��*�A��,���� �`6�B$��BB d�r`)��B(�Ͱ*`/�@4�Qh��p.�U�=p�a��(�� A�a!ڈb�X#����!�H�$ ɈQ"K�5H1R�T UH�=r9�\F��;�2����G1���Q=� �C��7�F� �dt1�����r�=�6��Ыhڏ>C�0��3�l0.��B�8, �c˱"� ���V����cϱw�E� 6wB aAHXLXN�H� $4� 7 �Q�'"��K�&���b21�XH,#��/{�C�7$�C2'��I��T��F�nR#�,��4H#���dk�9�, +ȅ����3��!�[ �b@q��S�(R�jJ��4�e�2AU��Rݨ�T5�ZB���R�Q��4u�9̓IK�����hh�i��t�ݕN��W���G���w ��Ljg(�gw��L�Ӌ�T071���oUX*�*|�� �J�&�*/T����ު U�U�T��^S}�FU3S� Ԗ�U��P�SSg�;���g�oT?�~Y��Y�L�OC�Q��_�� c�x,!k ��u�5�&���|v*�����=���9C3J3W�R�f?�q��tN �(���~���)�)�4L�1e\k����X�H�Q�G�6������E�Y��A�J'\'Gg����S�Sݧ �M=:��.�k���Dw�n��^��Lo��y���}/�T�m���G X� $� �<�5qo</���QC]�@C�a�a�ᄑ��<��F�F�i�\�$�m�mƣ&&!&KM�M�RM��)�;L;L���͢�֙5�=1�2��כ߷`ZxZ,����eI��Z�Yn�Z9Y�XUZ]�F���%ֻ�����N�N���gð�ɶ�����ۮ�m�}agbg�Ů��}�}��= ���Z~s�r:V:ޚΜ�?}����/gX���3��)�i�S��Ggg�s�󈋉K��.�>.���Ƚ�Jt�q]�z���������ۯ�6�i�ܟ�4�)�Y3s���C�Q��? ��0k߬~OCO�g��#/c/�W�װ��w��a�>�>r��>�<7�2�Y_�7��ȷ�O�o�_��C#�d�z����%g��A�[��z|!��?:�e����A���AA�������!h�쐭!��Α�i�P~���a�a��~ '���W�?�p�X�1�5w��Cs�D�D�Dޛg1O9�-J5*>�.j<�7�4�?�.fY��X�XIlK9.*�6nl������� �{�/�]py�����.,:�@L�N8��A*��%�w%� y��g"/�6ш�C\*N�H*Mz�쑼5y$�3�,幄'���L Lݛ:��v m2=:�1����qB�!M��g�g�fvˬe����n��/��k���Y- �B��TZ(�*�geWf�͉�9���+��̳�ې7�����ᒶ��KW-X潬j9�������(�x��oʿ�ܔ���Ĺd�f�f���-�[����n �ڴ �V����E�/��(ۻ��C���<��e����;?T�T�T�T6��ݵa��n��{��4���[���>ɾ�UUM�f�e�I���?�������m]�Nmq����#�׹���=TR��+�G�����w- 6 U����#pDy��� �� :�v�{���vg/jB��F�S��[b[�O�>����z�G��499�?r����C�d�&����ˮ/~�����јѡ�򗓿m|������������x31^�V���w�w��O�| (�h���SЧ��������c3-� cHRMz%������u0�`:�o�_�F5IDATx��ytUս�?�;���fN$$��@B�!�k��� -*�gE���j�O�kQ�ʠ`U�B_ �AÐ0%�Ȕ�@r3ޛ;߳��$�@��v����^�s����������$��ߢ !�W��5�̱'-٘������4�>�Rƫ$�G��0U�H}�_ _� #��k�MJ/=�9Du *ڲ�k�PQ;0��j|�*�$�^컂脛y���>�z×� B��� ��(�:$�ʔ_�6��C!B����MVx��a��ζyY����j��ƋY2�9�F�{r��r�딟F��Q��hY6��� x��[l��RC��������nt@��;P��3��� F�w��7��:�P���ɋ'���mj���Bƪ�$�Q�L��y��߷g��\���z����v5�p�v$�v櫻�`6~K �Y�X����,�:��"�o�e0II"(��,������l_�C���/4�+f�E�!q��:����u����c��樼.UE�@� �]K�W���$-�h]�JG���Dz)�`��.�A/ ���mᏣc�3jK� �!�>���$�Q�!�_�? \�C2(E �M$Z I{�U���s�ǣ���=��@Բe ޻��W�����@ �w����}�9v,)��.}*|"�s��di���,���G�]W�AC�������|<����[��ߕ������K�*�G nߴ!��‹��J�!��6(L�a)��Am��������;adf��:�xm��nh�;֦I��(���o�C~ډa?�=��s����h��E������xp����)���_���t��W�����´;8���`dz=(��@@�+,�;�`�fhl��XȌ�3,uI�~z(J����� �ZX�A����H'�À�㜦�82|��a�n�z2��I���� ���EY�h�ε<�0�q�{��C��v�˅��?"@��χ�x�WS+��N�~�KQ�J�8ل�� _.W��� !TU{�����,��"�� �;�������HI S� ��))�o�1�H�D� ���� (� ;����"Ҕ��,���� �F=���O��&�Ph>�`���y��߲ &S��P�<��'��1s�1cĂ�N����2)����@�u��tv��<�+�-&�����h��[!FSG���' � z z0��<����8d&�����E0�,��<��"!P�b4��� �{S�����X����.�囤���T��hEF��X�q0"-<����h���]�Py*����F⩍��@v�˂�Y08�� .q��a��s����(!<̫1�3�L�H��7sYW�`��qtu�\7��?�@�Y�� %Ka�x�GZ�*W�P��y�����N0r9��Z�c�%���q,��k�����!!,��>���IB��� �x1�Xu�Y���v-���ֺ��N������JP��a�2`�e5��w��u;�6�i���̃��(K���ťa��(l51��JL��O'%���]���ٖ뿉!��{*�p+f ���i8��D�ȑ���ܩ�M��V��ӟz��x�7Z�1i}�^͜���6e����x��)u�d�ˏ�V�eG�\�X1�����=n�U'�~Y����L�\,�(d!x ,�:�TW8� M`r���@��r+v�Q0��>^;˴�VbF��('����� �*O��i��j�Ӆ����^�S3&� ���{������.ی�� N;��NU%d0�Ce\r"�C�b��&t7N�7��� �ȪD�[%l�۪�$��'m?�A9tI�9>��NVL ��� 6v~M�����ъ�B���0����9$&=ώm��W�0���L���&��E���f�f��'+�9��hv��7,���M��6�D�&�^� �����8 D֮�����o��k^z��O��hP�8q�5d*��YVq3�{��������#LX4�?��jP=3�~�؅c�ݰ�̱�ұ��8̲��2�G�����j��έ�9��w7���U�X�w�85C��?!I&���o&����L���I#�^�eV�,�^t5�k� �xs˛\��U�8��."���{���ǵ�l4��ݼ�;��r"���G�/~���gJV�N糦��ZZ^k+NN�D��I$�=OE�z����|*�*{��%k���G��>�`9��b;�s���8,�qs��c��.b��q�%�>r��n�R�Ƨ�%�,�A��le#�8���}; 21�0�b�&�QX�f���q�00����$>�h�N�'�a3��A���/�r ��L5�8�GԲ'�����w;��c#�q1���h$*��V^�k��QĽ�b:i������� ����H F#�_���,��]g����Ը����`RUU���� ��"�qD���>-��ϤI�~��3�̴�����NZ[[555�eeek7�m����YF#[��Đ��R��i��L�H�r ��@��J-�Pŝ��_|�-��6y��ks�V�U~��6���w.����(��0A� 4��f��� /���C�xŊ�ٳ����z=6�����rg���mKo��o�/����a�g���?'9%9��P��斓��~���L{�� �H��{AW��B��$����v�1b�&Mb�ر��ر#�0`�`xMBp! )Z�Nmo�mZ�g�}�eذaWTVV ���'99��C5��&�&+5�bT>|8��PUUETT����&���t��~TE%��'������b�tEGG;RSS�S�N�v��ѯ��t����u1@�ޚ"f��͈���r'L�Ph��m��ƌ�74o��`�x�q�P���NRSS�X,�����l&&&��MFFA!-��`��ҷ�n��Yuu�����x<I�LB%����KԒ50�!�3�bz�����ʸKL���;---�l6[��`��������Ȏ;�����egg4��!D�T��jWujyZ��������K����%����p�^���X,6��sV=�ܖ����6�3�X ���4ҿ��A2�&����_k�;d�� �VfOIEND�B`� 0x0x
0x0x
PHP 8.1.34
Preview: HourlyStatsStorage.php Size: 14.97 KB
//home2/astrociv/public_html/avantaraholidays.com/wp-content/plugins/imunify-security/inc/App/Bot/HourlyStatsStorage.php
<?php
/**
 * Copyright (с) Cloud Linux GmbH & Cloud Linux Software, Inc 2010-2025 All Rights Reserved
 *
 * Licensed under CLOUD LINUX LICENSE AGREEMENT
 * https://www.cloudlinux.com/legal/
 */

namespace CloudLinux\Imunify\App\Bot;

/**
 * IP-free hourly rollup of bot traffic, backed by a durable InnoDB table.
 *
 * One row per (hour_bucket, category, bot, verdict). Every recorded bot
 * request is a single atomic `INSERT ... ON DUPLICATE KEY UPDATE` — no
 * staging table, no flush, nothing lost on a MySQL restart. Row count is
 * bounded by category × bot × verdict cardinality (a few hundred/hour at
 * most), never by request volume.
 *
 * `peak_req_min` is maintained inline: each write bumps a running
 * current-minute counter (resetting it when the minute-of-hour changes) and
 * keeps the largest value seen. This yields "peaked at N/min" without any
 * per-request storage.
 *
 * Every method is fail-open: schema is created lazily on first write, and any
 * DB error (or unexpected throw) degrades to a no-op / empty result rather
 * than surfacing to the request. Retention and opt-out purging are the
 * caller's responsibility (see {@see prune()} / {@see purge()}).
 *
 * @since 4.1.0
 */
class HourlyStatsStorage {

	use DbErrorDetection;

	/**
	 * Column widths, mirrored from the table schema so oversized inputs are
	 * capped before they reach the DB rather than being silently truncated
	 * (or rejected in STRICT mode).
	 */
	const CATEGORY_MAX = 24;
	const BOT_MAX      = 32;
	const VERDICT_MAX  = 12;

	/**
	 * Canonical retention window (hours) for the rollup — the single source of
	 * truth the cron prune and the dashboard read window both derive from.
	 */
	const RETENTION_HOURS = 24;

	/**
	 * WordPress database handle.
	 *
	 * @var object
	 */
	private $wpdb;

	/**
	 * Full table name (with WP prefix).
	 *
	 * @var string
	 */
	private $table;

	/**
	 * Prevents repeated CREATE TABLE attempts within one request.
	 *
	 * @var bool
	 */
	private $schema_init_attempted = false;

	/**
	 * Cause of the last failure fetchSince() or the fail-open guard saw, '' if none.
	 *
	 * @var string
	 */
	private $last_error = '';

	/**
	 * Bind the storage to a WordPress database handle.
	 *
	 * @param object $wpdb Connected WordPress $wpdb instance.
	 */
	public function __construct( $wpdb ) {
		$this->wpdb  = $wpdb;
		$this->table = $wpdb->prefix . 'imunify_bot_hourly';
	}

	/**
	 * Build the rollup storage over the global $wpdb, or null when no DB
	 * handle is available. The single authoritative constructor — callers
	 * (pipeline wiring, cron prune, dashboard read, opt-out purge) use this
	 * rather than re-deriving the "$wpdb present?" build at each site.
	 *
	 * @return self|null
	 */
	public static function forGlobalWpdb() {
		global $wpdb;
		return isset( $wpdb ) ? new self( $wpdb ) : null;
	}

	/**
	 * UTC epoch hour for a timestamp — the hour_bucket key. Single source of
	 * truth for the bucket definition shared with the reader and the cron prune.
	 *
	 * @param int $ts Unix timestamp.
	 * @return int
	 */
	public static function hourBucket( $ts ) {
		return (int) floor( (int) $ts / 3600 );
	}

	/**
	 * Record one bot request into its hourly bucket.
	 *
	 * @param string   $category One of the {@see Category} constants.
	 * @param string   $bot      Matched signature slug, or '' when unnamed.
	 * @param string   $verdict  One of the {@see RateLimitDecision} ACTION_* values.
	 * @param int|null $now      Unix timestamp; defaults to time(). Injectable for tests.
	 * @return void
	 */
	public function record( $category, $bot, $verdict, $now = null ) {
		$this->guardVoid(
			function () use ( $category, $bot, $verdict, $now ) {
				$category = (string) $category;
				if ( '' === $category ) {
					return;
				}
				$category = substr( $category, 0, self::CATEGORY_MAX );
				$bot      = substr( (string) $bot, 0, self::BOT_MAX );
				$verdict  = substr( (string) $verdict, 0, self::VERDICT_MAX );

				$ts          = null === $now ? time() : (int) $now;
				$hour_bucket = self::hourBucket( $ts );
				$cur_min     = (int) floor( $ts / 60 ) % 60;
				$table       = $this->table;

				// A single row-locked upsert keeps the current-minute counter and
				// the all-time peak in step. The assignment order is load-bearing
				// and must not be reshuffled: peak_req_min must be computed BEFORE
				// cur_min_cnt (so it reads the OLD count, not the incremented one),
				// and cur_min must be written LAST (so both the peak and the count
				// compare against the OLD minute). Both read OLD cur_min/cur_min_cnt.
				// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare
				$sql = $this->wpdb->prepare(
					// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
					"INSERT INTO `{$table}`"
					. ' (`hour_bucket`,`category`,`bot`,`verdict`,`req_count`,`cur_min`,`cur_min_cnt`,`peak_req_min`)'
					. ' VALUES (%d, %s, %s, %s, 1, %d, 1, 1)'
					. ' ON DUPLICATE KEY UPDATE'
					. ' `req_count` = `req_count` + 1,'
					. ' `peak_req_min` = GREATEST(`peak_req_min`, IF(`cur_min` = %d, `cur_min_cnt` + 1, 1)),'
					. ' `cur_min_cnt` = IF(`cur_min` = %d, `cur_min_cnt` + 1, 1),'
					. ' `cur_min` = %d',
					$hour_bucket,
					$category,
					$bot,
					$verdict,
					$cur_min,
					$cur_min,
					$cur_min,
					$cur_min
				);

				$this->exec( $sql );
			}
		);
	}

	/**
	 * Fetch every rollup row at or after $oldest_hour_bucket, newest data
	 * included. Rows are returned as associative arrays for the aggregation
	 * layer. Fail-open: any error yields null, which callers must keep distinct
	 * from the empty array a genuinely empty range returns — the daily export
	 * would otherwise publish a failed read as a zero-traffic day. A table not
	 * created yet reads as an empty range. {@see lastError()} holds the cause.
	 *
	 * @param int      $oldest_hour_bucket Inclusive lower bound on hour_bucket.
	 * @param int|null $newest_hour_bucket Inclusive upper bound; defaults to the
	 *                                     current hour so a clock-skewed future
	 *                                     row cannot inflate the summed KPIs.
	 * @return array|null List of associative row arrays, or null on read failure.
	 */
	public function fetchSince( $oldest_hour_bucket, $newest_hour_bucket = null ) {
		$this->last_error = '';
		$rows             = $this->guard(
			function () use ( $oldest_hour_bucket, $newest_hour_bucket ) {
				$table  = $this->table;
				$newest = null === $newest_hour_bucket ? self::hourBucket( time() ) : (int) $newest_hour_bucket;
				// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
				$sql = $this->wpdb->prepare(
					// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
					"SELECT `hour_bucket`,`category`,`bot`,`verdict`,`req_count`,`cur_min`,`cur_min_cnt`,`peak_req_min` FROM `{$table}` WHERE `hour_bucket` >= %d AND `hour_bucket` <= %d",
					(int) $oldest_hour_bucket,
					$newest
				);
				$suppress = $this->wpdb->suppress_errors( true );
				// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
				$rows  = $this->wpdb->get_results( $sql );
				$error = (string) $this->wpdb->last_error;
				$this->wpdb->suppress_errors( $suppress );
				// On a MySQL error get_results() still returns the empty array
				// flush() left behind, so last_error is the only failure signal.
				if ( '' !== $error ) {
					$this->last_error = $error;
					return null;
				}
				if ( ! is_array( $rows ) ) {
					return null;
				}
				$out = array();
				foreach ( $rows as $row ) {
					$out[] = (array) $row;
				}
				return $out;
			},
			null
		);
		// The table is created on the first write, so a missing one holds no rows.
		if ( null === $rows && '' !== $this->lastError() && false === $this->tableExists() ) {
			$this->last_error = '';
			return array();
		}
		return $rows;
	}

	/**
	 * Whether the table exists, or null when the check itself fails. Asks the
	 * database rather than parsing the read error, which may be localized.
	 * The name is not LIKE-escaped so db drop-ins (HyperDB, LudicrousDB) route
	 * the check to the read's server; a wildcard match can only err towards
	 * "exists", which keeps the read a failure. Keeps lastError() as the read
	 * left it.
	 *
	 * @return bool|null
	 */
	private function tableExists() {
		$read_error = $this->last_error;
		$exists     = $this->guard(
			function () {
				$sql      = $this->wpdb->prepare( 'SHOW TABLES LIKE %s', $this->table );
				$suppress = $this->wpdb->suppress_errors( true );
				// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
				$found = $this->wpdb->query( $sql );
				$this->wpdb->suppress_errors( $suppress );
				// query() returns false on any failure, also one that leaves no last_error.
				return false === $found ? null : $found > 0;
			},
			null
		);

		$this->last_error = $read_error;
		return $exists;
	}

	/**
	 * Cause of the most recent fetchSince() failure: the MySQL error, or the
	 * caught exception's class and message. '' after a successful read.
	 *
	 * @since 4.1.4
	 *
	 * @return string
	 */
	public function lastError() {
		return $this->last_error;
	}

	/**
	 * The storage engine the rollup table is actually on (e.g. 'InnoDB'), or
	 * null when the table does not exist yet or the engine cannot be read.
	 *
	 * The dashboard reports this rather than assuming InnoDB: on a host whose
	 * sql_mode allows engine substitution, a CREATE that asked for InnoDB can
	 * be silently downgraded, and the label must not then claim InnoDB.
	 *
	 * @return string|null
	 */
	public function tableEngine() {
		return $this->guard(
			function () {
				$sql      = $this->wpdb->prepare(
					'SELECT `ENGINE` FROM `information_schema`.`TABLES` WHERE `TABLE_SCHEMA` = DATABASE() AND `TABLE_NAME` = %s',
					$this->table
				);
				$suppress = $this->wpdb->suppress_errors( true );
				// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
				$engine = $this->wpdb->get_var( $sql );
				$this->wpdb->suppress_errors( $suppress );
				return is_string( $engine ) && '' !== $engine ? $engine : null;
			},
			null
		);
	}

	/**
	 * Delete rollup rows older than the retention cutoff.
	 *
	 * @param int $min_hour_bucket_to_keep Rows with hour_bucket below this are removed.
	 * @return void
	 */
	public function prune( $min_hour_bucket_to_keep ) {
		$this->guardVoid(
			function () use ( $min_hour_bucket_to_keep ) {
				$table = $this->table;
				// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
				$sql = $this->wpdb->prepare(
					// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
					"DELETE FROM `{$table}` WHERE `hour_bucket` < %d",
					(int) $min_hour_bucket_to_keep
				);
				$suppress = $this->wpdb->suppress_errors( true );
				// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
				$this->wpdb->query( $sql );
				$this->wpdb->suppress_errors( $suppress );
			}
		);
	}

	/**
	 * Remove every rollup row (used when the site owner opts out of stats).
	 *
	 * @return void
	 */
	public function purge() {
		$this->guardVoid(
			function () {
				$table    = $this->table;
				$suppress = $this->wpdb->suppress_errors( true );
				// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
				$this->wpdb->query( "DELETE FROM `{$table}`" );
				$this->wpdb->suppress_errors( $suppress );
			}
		);
	}

	/**
	 * Short identifier for telemetry.
	 *
	 * @return string
	 */
	public function name() {
		return 'hourly';
	}

	// -------------------------------------------------------------------------
	// Private helpers
	// -------------------------------------------------------------------------

	/**
	 * Execute a write query, lazily creating the table on the first
	 * "doesn't exist" error and retrying the query once.
	 *
	 * @param string $sql Prepared SQL.
	 * @return int|false Affected rows, or false on failure.
	 */
	private function exec( $sql ) {
		$suppress = $this->wpdb->suppress_errors( true );
		// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
		$result = $this->wpdb->query( $sql );
		if ( false === $result && ! $this->schema_init_attempted && $this->isTableMissing() ) {
			$this->schema_init_attempted = true;
			$this->createTable();
			// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
			$result = $this->wpdb->query( $sql );
		}
		$this->wpdb->suppress_errors( $suppress );
		return $result;
	}

	/**
	 * Create the durable InnoDB rollup table if it does not exist.
	 *
	 * ASCII charset: every stored value is an internal ASCII identifier
	 * (category enum, verdict enum, signature slug), so 1 byte/char is both
	 * sufficient and compact.
	 *
	 * @return void
	 */
	private function createTable() {
		$table = $this->table;
		$sql   = 'CREATE TABLE IF NOT EXISTS `' . $table . '` ('
			. ' `hour_bucket`  INT UNSIGNED NOT NULL,'
			. ' `category`     VARCHAR(24) NOT NULL,'
			. " `bot`          VARCHAR(32) NOT NULL DEFAULT '',"
			. ' `verdict`      VARCHAR(12) NOT NULL,'
			. ' `req_count`    INT UNSIGNED NOT NULL DEFAULT 0,'
			. ' `cur_min`      TINYINT UNSIGNED NOT NULL DEFAULT 0,'
			. ' `cur_min_cnt`  INT UNSIGNED NOT NULL DEFAULT 0,'
			. ' `peak_req_min` INT UNSIGNED NOT NULL DEFAULT 0,'
			. ' PRIMARY KEY (`hour_bucket`,`category`,`bot`,`verdict`)'
			. ') ENGINE=InnoDB DEFAULT CHARSET=ascii';
		// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.DirectDatabaseQuery.SchemaChange
		$result = $this->wpdb->query( $sql );
		if ( false === $result ) {
			StorageEventBuffer::record(
				'Failed to create InnoDB table: ' . $this->table,
				'bot_create_table_failed_hourly',
				array( 'bot_stats_create_failed', 'imunify_bot_hourly' ),
				array( 'table' => $this->table )
			);
		}
	}

	/**
	 * Run $fn under a fail-open wrapper, returning $default on any throw.
	 *
	 * @param callable $fn      Work to attempt.
	 * @param mixed    $default Value to return when $fn throws.
	 * @return mixed
	 */
	private function guard( $fn, $default ) {
		if ( interface_exists( 'Throwable' ) ) {
			try {
				return call_user_func( $fn );
			} catch ( \Throwable $t ) {
				$this->last_error = get_class( $t ) . ': ' . $t->getMessage();
				return $default;
			}
		}
		try {
			return call_user_func( $fn );
		} catch ( \Exception $e ) {
			$this->last_error = get_class( $e ) . ': ' . $e->getMessage();
			return $default;
		}
	}

	/**
	 * Fail-open wrapper for callables with no return value (see {@see guard()}).
	 *
	 * @param callable $fn Work to attempt.
	 * @return void
	 */
	private function guardVoid( $fn ) {
		$this->guard( $fn, null );
	}
}

Directory Contents

Dirs: 1 × Files: 77
Name Size Perms Modified Actions
data DIR
- drwxr-xr-x 2026-11-03 01:06:18
Edit Download
AllowlistCheck.php
11.48 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
AllowlistMatch.php
2.43 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
AllowlistMatcher.php
1.47 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
AllowlistType.php
1.38 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
AtomicFileWriter.php
4.45 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
BasePath.php
1.17 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
BlockStorageInterface.php
2.01 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
BotDataConverter.php
21.21 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
BotIpStats.php
7.34 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
BotLifecycle.php
17.81 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
BotSettingsWriter.php
3.38 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
BotShimManager.php
2.79 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
BotStatsExporter.php
13.17 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
BotTrafficStats.php
8.77 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
BotTrafficSummary.php
5.67 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
BundledData.php
14.53 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
Category.php
4.25 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
CdnDetector.php
1.72 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
CidrMatcher.php
7.58 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
Classification.php
1.55 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
Classifier.php
14.00 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
CounterStorageInterface.php
1.58 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
DailyBotAggregator.php
5.99 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
DailyCounter.php
2.88 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
DatacenterDetector.php
1.41 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
DbErrorDetection.php
1.53 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
DbStorageFactory.php
2.61 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
HeaderAnomalyScorer.php
4.73 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
Honeypot.php
7.49 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
HourlyIpStatsStorage.php
17.86 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
HourlyStatsStorage.php
14.97 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
HttpClient.php
1.47 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
HttpResponse.php
4.76 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
IpNormalizer.php
2.06 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
IpRangeLookup.php
5.26 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
IpWhitelist.php
5.64 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
LoopbackResult.php
2.68 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
LoopbackSafetyTest.php
10.47 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
LoopbackStatus.php
2.49 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
MemoryBlockStorage.php
17.09 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
MemoryCounterStorage.php
8.51 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
MirrorDownloader.php
12.60 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
MirrorDownloadResult.php
3.46 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
MonitoringUaMatcher.php
835 B lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
MonitoringUserAgents.php
1.71 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
MuLoader.php
22.44 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
MuPluginInstaller.php
5.65 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
MuPluginSelfHealer.php
7.33 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
NullBlockStorage.php
892 B lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
NullCounterStorage.php
924 B lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
OptOutFlag.php
4.69 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
Pipeline.php
18.57 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
Preset.php
6.92 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
RateLimitDecision.php
3.87 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
RateLimiter.php
7.94 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
RdnsVerifier.php
18.17 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
RealIpResolver.php
8.48 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
RequestAllowlist.php
1.80 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
Responder.php
9.49 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
RestNamespaceMatcher.php
2.84 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
RestRouteResolver.php
7.45 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
SafeInclude.php
1.28 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
SameServerMatcher.php
2.27 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
SelfOriginDetector.php
9.90 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
SignatureRefresher.php
15.82 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
SiteAllowlist.php
20.41 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
SiteAllowlistFile.php
7.79 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
SiteAllowlistStore.php
5.61 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
SiteAllowlistValidation.php
1.80 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
SiteAllowlistValidator.php
30.46 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
SiteOwnerMatcher.php
2.79 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
SiteScope.php
1.41 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
StorageEventBuffer.php
3.72 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
UserAgentSignatures.php
9.60 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
WooCommerceMatcher.php
5.05 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
WordPressInternalsMatcher.php
6.56 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
WpHttpClient.php
5.16 KB lrwxr-xr-x 2026-11-03 01:06:18
Edit Download
If ZipArchive is unavailable, a .tar will be created (no compression).
© 2026 0xNothings — Secure File Manager. All rights reserved. Built with ❤️ & Tailwind x Dark UI