aDriv4 website!

Linux server120.web-hosting.com 4.18.0-513.18.1.lve.el8.x86_64 #1 SMP Thu Feb 22 12:55:50 UTC 2024 x86_64
LiteSpeed
198.54.116.63

RecordQuery.php

<?php

// phpcs:ignore Generic.Commenting.DocComment.MissingShort
/** @noinspection PhpIllegalPsrClassPathInspection */

namespace WPForms\Logger;

/**
 * Class RecordQuery.
 *
 * @since 1.6.3
 */
class RecordQuery {

/**
	 * Build query.
	 *
	 * @since 1.6.3
	 *
	 * @param int    $limit  Query limit of records.
	 * @param int    $offset Offset of records.
	 * @param string $search Search.
	 * @param string $type   Type of records.
	 *
	 * @return array
	 */
	public function get( $limit, $offset = 0, $search = '', $type = '' ) {

global $wpdb;
		//phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared
		return (array) $wpdb->get_results(
			$this->build_query( $limit, $offset, $search, $type )
		);
		//phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared
	}

/**
	 * Build query.
	 *
	 * @since 1.6.3
	 *
	 * @param int    $limit  Query limit of records.
	 * @param int    $offset Offset of records.
	 * @param string $search Search.
	 * @param string $type   Type of records.
	 *
	 * @return string
	 */
	private function build_query( $limit, $offset = 0, $search = '', $type = '' ) {

global $wpdb;

$sql   = 'SELECT SQL_CALC_FOUND_ROWS * FROM ' . Repository::get_table_name();
		$where = [];

if ( ! empty( $search ) ) {
			$where[] = $wpdb->prepare(
				'`title` REGEXP %s OR `message` REGEXP %s',
				$search,
				$search
			);
		}

if ( ! empty( $type ) ) {
			$where[] = $wpdb->prepare(
				'`types` REGEXP %s',
				$type
			);
		}

if ( $where ) {
			$sql .= ' WHERE ' . implode( ' AND ', $where );
		}

$sql .= ' ORDER BY `create_at` DESC, `id` DESC';
		$sql .= $wpdb->prepare( ' LIMIT %d, %d', absint( $offset ), absint( $limit ) );

return $sql;
	}
}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	lesshgjr/lesshgjr	0755	2025-11-08 08:31:04
..	dir	-	lesshgjr/lesshgjr	0755	2025-11-08 08:31:04
ListTable.php	text/x-php	12.85 KB	lesshgjr/lesshgjr	0644	2025-06-12 10:56:20
Log.php	text/x-php	5.28 KB	lesshgjr/lesshgjr	0644	2025-06-12 10:56:20
Record.php	text/x-php	4.28 KB	lesshgjr/lesshgjr	0644	2025-06-12 10:56:20
RecordQuery.php	text/x-php	1.82 KB	lesshgjr/lesshgjr	0644	2025-06-12 10:56:20
Records.php	text/x-php	1.94 KB	lesshgjr/lesshgjr	0644	2025-06-12 10:56:20
Repository.php	text/x-php	5.95 KB	lesshgjr/lesshgjr	0644	2025-06-12 10:56:20

For more Private tool come to me!

https://t.me/aDriv4vz