Viewing File: /home/markqprx/duniagaming.online/lib/function.php

<?php
function data_settings ($setting_name) {
	global $conn;
	
	$cek = $conn->query("SELECT * FROM settings WHERE setting_name = '$setting_name'");
	$data = mysqli_fetch_assoc($cek);
	
	$value = $data['setting_value'];

	return $value;
}
function link_media ($id_featured) {
    global $conn;

	$cek_media = $conn->query("SELECT * FROM media WHERE id = '$id_featured'");
	$data_media = mysqli_fetch_assoc($cek_media);
	$file_link = data_settings('home_url') . "media/upload/" . $data_media['file_name'];
	
	return $file_link;
}
function slot_games_web($id_provider = 0, $limit = 0, $more = true, $limit_start = 0, $sort = false) {
	global $conn;

	if ($limit == 0) {
		$limit = 12;
	}

	if ($sort == false) {
		$order_by = "ORDER BY rand()";
		$sort = '';
	} else {
		$sorts = json_decode($sort, true);

		foreach ($sorts as $sort_val) {
			$order_bys[] = $sort_val['order'] . " " . $sort_val['type'];
		}

		$order_by = "ORDER BY " . implode(', ', $order_bys);
	}

	if ($id_provider != 0) {
		$cek_slot = $conn->query("SELECT * FROM slot WHERE provider = '$id_provider' AND rtp >= '90' AND iframe != '' $order_by LIMIT 0,$limit");
	} else {
		$cek_slot = $conn->query("SELECT * FROM slot WHERE rtp >= '90' AND iframe != '' $order_by LIMIT 0,$limit");
	}

	if ($limit_start > 0) {
		$cek_slot = $conn->query("SELECT * FROM slot $order_by LIMIT $limit_start,$limit ");
	}

	$total_slot = $conn->query("SELECT * FROM slot");
	$total_slot = mysqli_num_rows($total_slot);

	if ($total_slot > 0) {
		while ($data_slot = mysqli_fetch_assoc($cek_slot)) {
			$id_providers = $data_slot['provider'];
			$id_target = $data_slot['target'];
			$cek_provider = $conn->query("SELECT * FROM provider WHERE id = '$id_providers'");
			$data_provider = mysqli_fetch_assoc($cek_provider);

			$cek_target = $conn->query("SELECT * FROM situs_slot WHERE id = '$id_target'");
			$data_target = mysqli_fetch_assoc($cek_target);

			$progress_color = 'danger';

			if($data_slot['rtp'] >= 30) {
				$progress_color = 'warning';
			}
			if ($data_slot['rtp'] >= 70) {
				$progress_color = 'success';
			}
			
			$slot_link = data_settings('home_url') . 'provider/' . $data_provider['permalink'] . '/' . $data_slot['permalink'];
			$link_media = link_media($data_slot['featured']);
			$data_media = getimagesize(data_settings('dir_file') . 'media/upload/' . basename($link_media));

			$html[] = '<div style="min-width:200px;padding-right:.5rem;">';
			$html[] = '<div class="game-container mb-2">';
			$html[] = '<div class="game-img">';
			$html[] = '<amp-img src="' . $link_media . '" class="img-fluid" height="' . $data_media[1] . '" width="' . $data_media[0] . '" layout="responsive"></amp-img>';
			$html[] = '<div class="user-online">';
			$html[] = '<div class="d-flex align-items-center">';
			$html[] = '<i class="bi bi-person-fill me-1"></i> ' . $data_slot['user_online'] . ' <small class="ms-1">Online</small>';
			$html[] = '</div>';
			$html[] = '</div>';
			$html[] = '</div>';
			$html[] = '<div class="game-text">';
			$html[] = '<span class="badge bg-warning text-black mb-1">'. strtoupper($data_provider['name']) .'</span>';
			$html[] = '<h5>'. $data_slot['name'] .'</h5>';
			$html[] = '</div>';
			$html[] = '<div class="progress-text fw-bold row mb-1">';
			$html[] = '<div class="col-6 small">RTP</div>';
			$html[] = '<div class="col-6 small text-end">'. $data_slot['rtp'] .'%</div>';
			$html[] = '</div>';
			$html[] = '<div class="progress-con mb-2">';
			$html[] = '<div class="progress-bar '. $progress_color .'" style="max-width: '. $data_slot['rtp'] .'%;"></div>';
			$html[] = '</div>';
			$html[] = '<div class="btn-con mt-3">';
			$html[] = '<div class="row">';
		    
		    if(!empty($data_slot['iframe'])){
    		    $html[] = '<div class="col-12 mb-2">';
        	    $html[] = '<a href = "'. $slot_link .'" target="_blank" title = "Demo '. $data_slot['name'] .'" class="btn btn-secondary w-100">Main Gratis</a>';
        		$html[] = '</div>'; 
    		}

		    $html[] = '<div class="col-6 pe-1">';
		    $html[] = '<button type="button" class="btn btn-info w-100 pola_gacor_new" data-id="'. $data_slot['id'] .'">Pola</button>';
		    $html[] = '</div>';
			
			$html[] = '<div class="col-6 ps-1">';
			$html[] = '<a href="/?content=register&ref=gacorreff" target="_blank" class="btn btn-danger w-100">Daftar</a>';
			$html[] = '</div>';
			$html[] = '</div>';
			$html[] = '</div>';
			$html[] = '</div>';
			$html[] = '</div>';
		}

		if ($id_provider > 0) {
			if ($more == true) {
				$cek_provider = $conn->query("SELECT * FROM provider WHERE id = '$id_provider'");
				$data_provider = mysqli_fetch_assoc($cek_provider);

				$provider_link = data_settings('home_url') . 'provider/' . $data_provider['permalink'];
				$html[] = '<div class="col-12 text-center mb-3">';
				$html[] = '<a href = "'. $provider_link .'" class="btn btn-secondary">Lebih Banyak</a>';
				$html[] = '</div>';
			}
		}

		if ($id_provider == 0) {
			if ($more == true) {
				$data_sort = "data-sort='" . $sort . "'";
				$provider_link = data_settings('home_url') . 'provider/' . $data_provider['permalink'];
				$html[] = '<div class="col-12 text-center mb-3 more_slot_games_con">';
				$html[] = '<button class="btn btn-secondary more_slot_games" data-total-slot="' . $total_slot . '" data-limit-start = "'. $limit_start .'" data-limit = "'. $limit .'" '. $data_sort .'>Lebih Banyak</button>';
				$html[] = '</div>';
			}
		}
	} else {
		$html[] = '<div class="col-12 text-center mb-3">';
		$html[] = 'No Data';
		$html[] = '</div>';
	}

	$html = implode('', $html);

	return $html;
}