byp4a55 professor6T9

Linux prd24.1136.24x7ssfix.net 5.14.0-570.58.1.el9_6.x86_64 #1 SMP PREEMPT_DYNAMIC Wed Oct 29 06:24:11 EDT 2025 x86_64
LiteSpeed
170.39.213.43

File Name : postmeta.php

<?php
namespace ILJ\Database;

use ILJ\Core\Options;
use ILJ\Core\Options\Whitelist;
use ILJ\Helper\BatchBuilding;
use ILJ\Helper\BatchInfo;
use ILJ\Helper\Blacklist;

/**
 * Postmeta wrapper for the inlink postmeta
 *
 * @package ILJ\Database
 * @since   1.0.0
 */
class Postmeta {

const ILJ_META_KEY_LINKDEFINITION = 'ilj_linkdefinition';

/**
	 * Returns all Linkdefinitions from postmeta table
	 *
	 * @since  1.0.0
	 * @param  string $field Fetch single field value
	 * @return array
	 */
	public static function getAllLinkDefinitions($field = null) {
		global $wpdb;

$meta_key = self::ILJ_META_KEY_LINKDEFINITION;

$public_post_types = Options::getOption(\ILJ\Core\Options\Whitelist::getKey());

if (empty($public_post_types)) {
			return array();
		} else {
			$public_post_types_list = "'" . implode("','", $public_post_types) . "'";
		}

$fetch_field = '*';

if (null != $field) {
			$fetch_field = $field;
		}

$query = "
			SELECT postmeta.".$fetch_field."
			FROM $wpdb->postmeta postmeta
			LEFT JOIN $wpdb->posts posts ON postmeta.post_id = posts.ID
			WHERE postmeta.meta_key = '$meta_key'
			AND posts.post_status = 'publish'
			AND posts.post_type IN ($public_post_types_list)
		";
		// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared -- Direct query necessary and caching is not applicable for dynamic data.
		return $wpdb->get_results($query);
	}

/**
	 * Returns all Linkdefinitions from postmeta table
	 *
	 * @since  1.0.0
	 * @param  int $offset
	 * @return array
	 */
	public static function getAllLinkDefinitionsByBatch($offset) {
		global $wpdb;

$meta_key = self::ILJ_META_KEY_LINKDEFINITION;

$public_post_types = Options::getOption(\ILJ\Core\Options\Whitelist::getKey());

$batch_building = new BatchBuilding();
		$limit          = $batch_building->get_fetch_batch_keyword_size();

if (empty($public_post_types)) {
			return array();
		} else {
			$public_post_types_list = "'" . implode("','", $public_post_types) . "'";
		}

$query = "
			SELECT postmeta.*
			FROM $wpdb->postmeta postmeta
			LEFT JOIN $wpdb->posts posts ON postmeta.post_id = posts.ID
			WHERE postmeta.meta_key = '$meta_key'
			AND posts.post_status = 'publish'
			AND posts.post_type IN ($public_post_types_list) LIMIT $offset , $limit 
		";
		// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Direct query necessary and caching is not applicable for dynamic data.
		return $wpdb->get_results($query);
	}

/**
	 * Returns all Linkdefinitions from specific ID
	 *
	 * @param  int $id
	 * @return array
	 */
	public static function getLinkDefinitionsById($id) {
		global $wpdb;
		$meta_key = self::ILJ_META_KEY_LINKDEFINITION;

$public_post_types = Options::getOption(\ILJ\Core\Options\Whitelist::getKey());

if (empty($public_post_types)) {
			return array();
		} else {
			$public_post_types_list = "'" . implode("','", $public_post_types) . "'";
		}

$query = "
			SELECT postmeta.*
			FROM $wpdb->postmeta postmeta
			LEFT JOIN $wpdb->posts posts ON postmeta.post_id = posts.ID
			WHERE postmeta.meta_key = '$meta_key'
			AND posts.post_status = 'publish'
			AND posts.post_type IN ($public_post_types_list) AND posts.ID = $id
		";
		// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Direct query necessary and caching is not applicable for dynamic data.
		return $wpdb->get_results($query);

}

/**
	 * Removes all link definitions from postmeta table
	 *
	 * @since  1.1.3
	 * @return int
	 */
	public static function removeAllLinkDefinitions() {
		global $wpdb;
		$meta_key = self::ILJ_META_KEY_LINKDEFINITION;
		// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Direct database deletion is necessary, and caching is not applicable.
		return $wpdb->delete($wpdb->postmeta, array('meta_key' => $meta_key));
	}

public static function getLinkDefinitionCount() {
		global $wpdb;

$meta_key = self::ILJ_META_KEY_LINKDEFINITION;

$public_post_types = Options::getOption(\ILJ\Core\Options\Whitelist::getKey());

if (empty($public_post_types)) {
			return 0;
		} else {
			$public_post_types_list = "'" . implode("','", $public_post_types) . "'";
		}

$query = "
			SELECT COUNT(postmeta.meta_id)
			FROM $wpdb->postmeta postmeta
			LEFT JOIN $wpdb->posts posts ON postmeta.post_id = posts.ID
			WHERE postmeta.meta_key = '$meta_key'
			AND posts.post_status = 'publish'
			AND posts.post_type IN ($public_post_types_list)
		";

// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Direct query necessary and caching is not applicable for dynamic data.
		return $wpdb->get_var($query);
	}
}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	mahdevsfddfg/mahdevsfddfg	0755	2025-10-27 03:59:36
..	dir	-	mahdevsfddfg/mahdevsfddfg	0755	2025-10-27 03:59:36
wpml	dir	-	mahdevsfddfg/mahdevsfddfg	0755	2025-10-27 03:59:36
databasecollation.php	file	4.82 KB	mahdevsfddfg/mahdevsfddfg	0644	2025-10-27 03:59:36
keywords.php	file	1.53 KB	mahdevsfddfg/mahdevsfddfg	0644	2025-10-27 03:59:36
linkindex.php	file	20.39 KB	mahdevsfddfg/mahdevsfddfg	0644	2025-10-27 03:59:36
linkindexindividualtemp.php	file	7.16 KB	mahdevsfddfg/mahdevsfddfg	0644	2025-10-27 03:59:36
linkindextemp.php	file	5.84 KB	mahdevsfddfg/mahdevsfddfg	0644	2025-10-27 03:59:36
postmeta.php	file	4.87 KB	mahdevsfddfg/mahdevsfddfg	0644	2025-10-27 03:59:36
usermeta.php	file	600 B	mahdevsfddfg/mahdevsfddfg	0644	2025-10-27 03:59:36

Team Anon Force

https://t.me/Professor6T9x