�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: HourlyIpStatsStorage.php Size: 17.86 KB
/home2/astrociv/public_html/asquarebuildcon.in/wp-content/plugins/imunify-security/inc/App/Bot/HourlyIpStatsStorage.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;

/**
 * Per-IP hourly detail for the bot-traffic drill-down, backed by a durable
 * InnoDB table one step below {@see HourlyStatsStorage}.
 *
 * One row per (hour_bucket, category, bot, ip). Non-human traffic only —
 * humans never get a per-IP row (they are a single aggregate in the rollup).
 * The IP is stored in `inet_pton()` binary form (IPv4 or IPv6). `verdict`
 * holds the most severe action seen for that IP in the hour; the upsert raises
 * it (block > rate_limit > allow) and never lowers it.
 *
 * The table is bounded on shared hosting by capping each
 * (hour_bucket, category, bot) group at {@see IP_CAP} distinct IPs: a new IP
 * is not inserted once the group is full (the request is still counted in the
 * rollup), and {@see trim()} sweeps any overflow that slipped in under a race.
 *
 * Every method is fail-open, mirroring {@see HourlyStatsStorage}: schema is
 * created lazily on first write and any DB error degrades to a no-op / empty
 * result rather than surfacing to the request.
 *
 * @since 4.1.0
 */
class HourlyIpStatsStorage {

	use DbErrorDetection;

	const CATEGORY_MAX = 24;
	const BOT_MAX      = 32;
	const VERDICT_MAX  = 12;

	/**
	 * Maximum distinct IPs retained per (hour_bucket, category, bot) group.
	 */
	const IP_CAP = 50;

	/**
	 * 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;

	/**
	 * Groups already observed at capacity this request, keyed by
	 * "hour|category|bot" — lets a new IP skip the group-count query once the
	 * group is known full (matters under a scrape hammering one bot).
	 *
	 * @var array<string,bool>
	 */
	private $full_groups = array();

	/**
	 * 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_ip';
	}

	/**
	 * Build the per-IP storage over the global $wpdb, or null when no DB handle
	 * is available. The single authoritative constructor (see the twin on
	 * {@see HourlyStatsStorage}).
	 *
	 * @return self|null
	 */
	public static function forGlobalWpdb() {
		global $wpdb;
		return isset( $wpdb ) ? new self( $wpdb ) : null;
	}

	/**
	 * Record one non-human request against its (hour, category, bot, IP) row.
	 *
	 * Bumps an existing IP's count (raising its verdict) in a single UPDATE;
	 * for a new IP, inserts only while the group is below {@see IP_CAP}.
	 *
	 * @param string   $category One of the {@see Category} constants (never human).
	 * @param string   $bot      Matched signature slug, or '' when unnamed.
	 * @param string   $ip       Client IP in textual form.
	 * @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, $ip, $verdict, $now = null ) {
		$this->guardVoid(
			function () use ( $category, $bot, $ip, $verdict, $now ) {
				$category = (string) $category;
				if ( '' === $category ) {
					return;
				}
				// phpcs:ignore WordPress.PHP.NoSilencedErrors.Discouraged -- inet_pton warns on garbage; we want false and a skip.
				$ip_bin = @inet_pton( (string) $ip );
				if ( false === $ip_bin ) {
					return;
				}
				$category = substr( $category, 0, self::CATEGORY_MAX );
				$bot      = substr( (string) $bot, 0, self::BOT_MAX );
				$verdict  = substr( (string) $verdict, 0, self::VERDICT_MAX );

				$hour_bucket = HourlyStatsStorage::hourBucket( null === $now ? time() : (int) $now );

				if ( $this->bumpExisting( $hour_bucket, $category, $bot, $ip_bin, $verdict ) > 0 ) {
					return;
				}
				$group_key = $hour_bucket . '|' . $category . '|' . $bot;
				if ( isset( $this->full_groups[ $group_key ] ) ) {
					return;
				}
				if ( $this->groupCount( $hour_bucket, $category, $bot ) >= self::IP_CAP ) {
					$this->full_groups[ $group_key ] = true;
					return;
				}
				$this->insertNew( $hour_bucket, $category, $bot, $ip_bin, $verdict );
			}
		);
	}

	/**
	 * Fetch every per-IP row at or after $oldest_hour_bucket for aggregation.
	 * `ip` is returned in binary (inet_pton) form. Fail-open: null on error,
	 * which callers must keep distinct from an empty range (see
	 * {@see HourlyStatsStorage::fetchSince()}). 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 skew the drill-down.
	 * @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 ? HourlyStatsStorage::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`,`ip`,`verdict`,`req_count` 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;
	}

	/**
	 * Delete per-IP 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
				);
				$this->runSuppressed( $sql );
			}
		);
	}

	/**
	 * Trim every (hour_bucket, category, bot) group back to the top
	 * {@see IP_CAP} IPs by req_count — a backstop for rows that slipped past
	 * the insert-time guard under a concurrent race.
	 *
	 * Portable to MySQL 5.6 / MariaDB 10.0 (no window functions): a correlated
	 * subquery counts how many rows in the same group outrank each row, and any
	 * row with at least IP_CAP betters is dropped. Groups are tiny (~cap rows),
	 * so the O(n^2) self-join is negligible. The extra SELECT wrapper is the
	 * MySQL idiom for deleting from a table also read in the subquery.
	 *
	 * @return void
	 */
	public function trim() {
		$this->guardVoid(
			function () {
				$table = $this->table;
				$cap   = (int) self::IP_CAP;
				// The only value is the integer cap (a %d placeholder); every
				// other token is a literal or the trusted internal table name,
				// repeated across the correlated self-join. phpcs cannot see
				// through the multi-line build, so disable its SQL sniffs here.
				// phpcs:disable WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.PreparedSQLPlaceholders.ReplacementsWrongNumber
				$sql = $this->wpdb->prepare(
					"DELETE FROM `{$table}` WHERE (`hour_bucket`,`category`,`bot`,`ip`) IN ("
					. ' SELECT `hour_bucket`,`category`,`bot`,`ip` FROM ('
					. " SELECT t1.`hour_bucket`,t1.`category`,t1.`bot`,t1.`ip` FROM `{$table}` t1"
					. " WHERE ( SELECT COUNT(*) FROM `{$table}` t2"
					. ' WHERE t2.`hour_bucket`=t1.`hour_bucket` AND t2.`category`=t1.`category` AND t2.`bot`=t1.`bot`'
					. ' AND ( t2.`req_count` > t1.`req_count`'
					. ' OR ( t2.`req_count` = t1.`req_count` AND t2.`ip` > t1.`ip` ) ) ) >= %d'
					. ' ) d )',
					$cap
				);
				// phpcs:enable WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.PreparedSQLPlaceholders.ReplacementsWrongNumber
				$this->runSuppressed( $sql );
			}
		);
	}

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

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

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

	/**
	 * Bump an existing IP's count and raise its verdict. Returns affected rows
	 * (0 when the IP is new — req_count always changes, so a match is never 0).
	 *
	 * @param int    $hour_bucket Bucket.
	 * @param string $category    Category.
	 * @param string $bot         Bot slug.
	 * @param string $ip_bin      Binary IP.
	 * @param string $verdict     Incoming verdict.
	 * @return int|false
	 */
	private function bumpExisting( $hour_bucket, $category, $bot, $ip_bin, $verdict ) {
		$table = $this->table;
		// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
		$sql = $this->wpdb->prepare(
			// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
			"UPDATE `{$table}` SET `req_count` = `req_count` + 1,"
			. " `verdict` = IF( FIELD(%s,'allow','rate_limit','block') > FIELD(`verdict`,'allow','rate_limit','block'), %s, `verdict` )"
			. ' WHERE `hour_bucket` = %d AND `category` = %s AND `bot` = %s AND `ip` = %s',
			$verdict,
			$verdict,
			$hour_bucket,
			$category,
			$bot,
			$ip_bin
		);
		return $this->exec( $sql );
	}

	/**
	 * Count rows already in a (hour_bucket, category, bot) group.
	 *
	 * @param int    $hour_bucket Bucket.
	 * @param string $category    Category.
	 * @param string $bot         Bot slug.
	 * @return int
	 */
	private function groupCount( $hour_bucket, $category, $bot ) {
		$table = $this->table;
		// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
		$sql = $this->wpdb->prepare(
			// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
			"SELECT COUNT(*) FROM `{$table}` WHERE `hour_bucket` = %d AND `category` = %s AND `bot` = %s",
			$hour_bucket,
			$category,
			$bot
		);
		$suppress = $this->wpdb->suppress_errors( true );
		// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
		$count = $this->wpdb->get_var( $sql );
		$this->wpdb->suppress_errors( $suppress );
		return null === $count ? 0 : (int) $count;
	}

	/**
	 * Insert a new IP row. The ON DUPLICATE KEY UPDATE bump is a race guard for
	 * two requests racing the same new IP past the count check.
	 *
	 * @param int    $hour_bucket Bucket.
	 * @param string $category    Category.
	 * @param string $bot         Bot slug.
	 * @param string $ip_bin      Binary IP.
	 * @param string $verdict     Incoming verdict.
	 * @return int|false
	 */
	private function insertNew( $hour_bucket, $category, $bot, $ip_bin, $verdict ) {
		$table = $this->table;
		// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
		$sql = $this->wpdb->prepare(
			// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
			"INSERT INTO `{$table}` (`hour_bucket`,`category`,`bot`,`ip`,`verdict`,`req_count`)"
			. ' VALUES (%d, %s, %s, %s, %s, 1)'
			. ' ON DUPLICATE KEY UPDATE `req_count` = `req_count` + 1,'
			. " `verdict` = IF( FIELD(VALUES(`verdict`),'allow','rate_limit','block') > FIELD(`verdict`,'allow','rate_limit','block'), VALUES(`verdict`), `verdict` )",
			$hour_bucket,
			$category,
			$bot,
			$ip_bin,
			$verdict
		);
		return $this->exec( $sql );
	}

	/**
	 * Execute a write query, lazily creating the table on the first
	 * "doesn't exist" error and retrying 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;
	}

	/**
	 * Run a query with errors suppressed and no table auto-create (prune / trim
	 * / purge tolerate a missing table as a no-op).
	 *
	 * @param string $sql SQL to run.
	 * @return void
	 */
	private function runSuppressed( $sql ) {
		$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 );
	}

	/**
	 * Create the durable InnoDB per-IP table if it does not exist.
	 *
	 * @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 '',"
			. ' `ip`          VARBINARY(16) NOT NULL,'
			. ' `verdict`     VARCHAR(12) NOT NULL,'
			. ' `req_count`   INT UNSIGNED NOT NULL DEFAULT 0,'
			. ' PRIMARY KEY (`hour_bucket`,`category`,`bot`,`ip`)'
			. ') 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_ip',
				array( 'bot_stats_create_failed', 'imunify_bot_hourly_ip' ),
				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:28
Edit Download
AllowlistCheck.php
11.48 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
AllowlistMatch.php
2.43 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
AllowlistMatcher.php
1.47 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
AllowlistType.php
1.38 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
AtomicFileWriter.php
4.45 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
BasePath.php
1.17 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
BlockStorageInterface.php
2.01 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
BotDataConverter.php
21.21 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
BotIpStats.php
7.34 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
BotLifecycle.php
17.81 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
BotSettingsWriter.php
3.38 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
BotShimManager.php
2.79 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
BotStatsExporter.php
13.17 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
BotTrafficStats.php
8.77 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
BotTrafficSummary.php
5.67 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
BundledData.php
14.53 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
Category.php
4.25 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
CdnDetector.php
1.72 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
CidrMatcher.php
7.58 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
Classification.php
1.55 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
Classifier.php
14.00 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
CounterStorageInterface.php
1.58 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
DailyBotAggregator.php
5.99 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
DailyCounter.php
2.88 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
DatacenterDetector.php
1.41 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
DbErrorDetection.php
1.53 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
DbStorageFactory.php
2.61 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
HeaderAnomalyScorer.php
4.73 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
Honeypot.php
7.49 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
HourlyIpStatsStorage.php
17.86 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
HourlyStatsStorage.php
14.97 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
HttpClient.php
1.47 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
HttpResponse.php
4.76 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
IpNormalizer.php
2.06 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
IpRangeLookup.php
5.26 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
IpWhitelist.php
5.64 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
LoopbackResult.php
2.68 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
LoopbackSafetyTest.php
10.47 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
LoopbackStatus.php
2.49 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
MemoryBlockStorage.php
17.09 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
MemoryCounterStorage.php
8.51 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
MirrorDownloader.php
12.60 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
MirrorDownloadResult.php
3.46 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
MonitoringUaMatcher.php
835 B lrw-r--r-- 2026-11-03 01:06:29
Edit Download
MonitoringUserAgents.php
1.71 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
MuLoader.php
22.44 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
MuPluginInstaller.php
5.65 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
MuPluginSelfHealer.php
7.33 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
NullBlockStorage.php
892 B lrw-r--r-- 2026-11-03 01:06:29
Edit Download
NullCounterStorage.php
924 B lrw-r--r-- 2026-11-03 01:06:29
Edit Download
OptOutFlag.php
4.69 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
Pipeline.php
18.57 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
Preset.php
6.92 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
RateLimitDecision.php
3.87 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
RateLimiter.php
7.94 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
RdnsVerifier.php
18.17 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
RealIpResolver.php
8.48 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
RequestAllowlist.php
1.80 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
Responder.php
9.49 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
RestNamespaceMatcher.php
2.84 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
RestRouteResolver.php
7.45 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
SafeInclude.php
1.28 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
SameServerMatcher.php
2.27 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
SelfOriginDetector.php
9.90 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
SignatureRefresher.php
15.82 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
SiteAllowlist.php
20.41 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
SiteAllowlistFile.php
7.79 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
SiteAllowlistStore.php
5.61 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
SiteAllowlistValidation.php
1.80 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
SiteAllowlistValidator.php
30.46 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
SiteOwnerMatcher.php
2.79 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
SiteScope.php
1.41 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
StorageEventBuffer.php
3.72 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
UserAgentSignatures.php
9.60 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
WooCommerceMatcher.php
5.05 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
WordPressInternalsMatcher.php
6.56 KB lrw-r--r-- 2026-11-03 01:06:29
Edit Download
WpHttpClient.php
5.16 KB lrw-r--r-- 2026-11-03 01:06:29
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