TrxShell [ www.6club.teacherslex.site ]

Name	Size	Permission
.pkexec	[ DIR ]	drwxr-xr-x
.well-known	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
apiimages	[ DIR ]	drwxrwxrwx
assets	[ DIR ]	drwxrwxrwx
deepanshu	[ DIR ]	drwxrwxrwx
images	[ DIR ]	drwxrwxrwx
images_usdt	[ DIR ]	drwxrwxrwx
jdb	[ DIR ]	drwxrwxrwx
jdbapi	[ DIR ]	drwxrwxrwx
jet	[ DIR ]	drwxrwxrwx
jili	[ DIR ]	drwxrwxrwx
loading	[ DIR ]	drwxrwxrwx
manifest	[ DIR ]	drwxrwxrwx
pay	[ DIR ]	drwxrwxrwx
plugins	[ DIR ]	drwxrwxrwx
serive	[ DIR ]	drwxrwxrwx
slex143	[ DIR ]	drwxrwxrwx
tashanaman	[ DIR ]	drwxrwxrwx
vendors	[ DIR ]	drwxrwxrwx
.htaccess	281 B	-rw-r--r--
.mad-root	0 B	-rw-r--r--
91club@192.png	23.44 KB	-rw-rw-rw-
abcoderscron.php	1.88 KB	-rw-rw-rw-
adminer.php	0 B	-rw-r--r--
agent_details.php	37.41 KB	-rw-rw-rw-
alf4.php	0 B	-rw-r--r--
api2.php	998 B	-rw-rw-rw-
api_pass.php	9.04 KB	-rw-r--r--
app.config.js	629 B	-rw-rw-rw-
ar-sw.js	2.19 KB	-rw-rw-rw-
atcron.php	1.52 KB	-rw-rw-rw-
bcreate.php	0 B	-rw-r--r--
bscan.php	0 B	-rw-r--r--
championtasklogo_2025102414164...	85.99 KB	-rw-rw-rw-
clear_spin.php	393 B	-rw-rw-rw-
commintioncron.php	2.61 KB	-rw-rw-rw-
dailysalary.php	13.32 KB	-rw-rw-rw-
data.json	46.77 KB	-rw-rw-rw-
down.svg	259 B	-rw-rw-rw-
error_log	6.47 KB	-rw-rw-rw-
firebase-messaging-sw.js	1.49 KB	-rw-rw-rw-
get_agent.php	547 B	-rw-rw-rw-
gold.svg	20.15 KB	-rw-rw-rw-
handlebalance.php	1.44 KB	-rw-rw-rw-
homeDown.svg	900 B	-rw-rw-rw-
index.html	1.24 MB	-rw-rw-rw-
index.php1	779.76 KB	-rw-rw-rw-
index.php2	613.26 KB	-rw-rw-rw-
ktrx.php	1.49 KB	-rw-rw-rw-
ktrx10.php	1.5 KB	-rw-rw-rw-
ktrx3.php	1.5 KB	-rw-rw-rw-
ktrx5.php	1.5 KB	-rw-rw-rw-
live-chat-help.html	446 B	-rw-rw-rw-
log.txt	0 B	-rw-rw-rw-
logo.png	30.35 KB	-rw-rw-rw-
maintenance.html	1.81 KB	-rw-rw-rw-
manifest.91club.json	808 B	-rw-rw-rw-
message_notice.svg	927 B	-rw-rw-rw-
nayakaphalitansa_mulaka_unohs....	31.86 KB	-rw-rw-rw-
nayakaphalitansa_mulaka_unohs3...	32 KB	-rw-rw-rw-
nayakaphalitansa_mulaka_unohs_...	128.17 KB	-rw-rw-rw-
nayakaphalitansa_mulaka_unohs_...	129.82 KB	-rw-rw-rw-
nayakaphalitansa_mulaka_unohs_...	129.82 KB	-rw-rw-rw-
nayakaphalitansa_mulaka_unohs_...	129.82 KB	-rw-rw-rw-
nayakaphalitansa_mulaka_unohs_...	32.22 KB	-rw-rw-rw-
nayakaphalitansa_mulaka_unohs_...	32.22 KB	-rw-rw-rw-
nayakaphalitansa_mulaka_unohs_...	93.84 KB	-rw-rw-rw-
nayakaphalitansa_mulaka_unohs_...	92.27 KB	-rw-rw-rw-
nayakaphalitansa_mulaka_unohs_...	92.27 KB	-rw-rw-rw-
nayakaphalitansa_mulaka_unohs_...	92.27 KB	-rw-rw-rw-
nayakaphalitansa_mulaka_unohs_...	32.22 KB	-rw-rw-rw-
niyamitakelasa.php	30.34 KB	-rw-rw-rw-
niyamitakelasa30sec.php	2.35 KB	-rw-rw-rw-
niyamitakelasa_aidudi.php	1.6 KB	-rw-rw-rw-
niyamitakelasa_aidudi_drei.php	1.63 KB	-rw-rw-rw-
niyamitakelasa_aidudi_funf.php	1.63 KB	-rw-rw-rw-
niyamitakelasa_aidudi_zehn.php	1.63 KB	-rw-rw-rw-
niyamitakelasa_drei.php	1.58 KB	-rw-rw-rw-
niyamitakelasa_funf.php	1.58 KB	-rw-rw-rw-
niyamitakelasa_kemuru.php	1.6 KB	-rw-rw-rw-
niyamitakelasa_kemuru_drei.php	1.63 KB	-rw-rw-rw-
niyamitakelasa_kemuru_funf.php	1.63 KB	-rw-rw-rw-
niyamitakelasa_kemuru_zehn.php	1.63 KB	-rw-rw-rw-
niyamitakelasa_zehn.php	2.37 KB	-rw-rw-rw-
notice.svg	1.42 KB	-rw-rw-rw-
orders_validity.json	5.16 KB	-rw-r--r--
php.ini	577 B	-rw-rw-rw-
point.svg	188 B	-rw-rw-rw-
pwnkit	0 B	-rwxr-xr-x
rank.svg	5.33 KB	-rw-rw-rw-
rank_bg.svg	7.45 KB	-rw-rw-rw-
recharge_btn.svg	1.68 KB	-rw-rw-rw-
refresh.svg	629 B	-rw-rw-rw-
scan_backdoor.php	1.36 KB	-rw-rw-rw-
spin.png	1.38 KB	-rw-rw-rw-
sw-domain.js	1.33 KB	-rw-rw-rw-
sw-page.js	8.31 KB	-rw-rw-rw-
sw-utils.js	3.83 KB	-rw-rw-rw-
tashanwin.teacherslex.site_fun...	5.6 KB	-rw-r--r--
testipay.php	1.2 KB	-rw-rw-rw-
timepad.php	1.4 KB	-rw-rw-rw-
trx.php	27.68 KB	-rw-rw-rw-
trx1.php	28.52 KB	-rw-rw-rw-
trx10.php	29.62 KB	-rw-rw-rw-
trxupkid.php	27.8 KB	-rw-rw-rw-
trxupkid10.php	27.93 KB	-rw-rw-rw-
trxupkid3.php	27.87 KB	-rw-rw-rw-
trxupkid5.php	27.87 KB	-rw-rw-rw-
turntable.svg	23.79 KB	-rw-rw-rw-
up.svg	261 B	-rw-rw-rw-
vip.svg	57.21 KB	-rw-rw-rw-
winner.svg	10.42 KB	-rw-rw-rw-
withdraw_btn.svg	1.67 KB	-rw-rw-rw-
wlogo.png	30.35 KB	-rw-rw-rw-

Code Editor : trx1.php

<?php
include("serive/samparka.php");

$samasye = "SELECT atadaaidi
	  FROM gelluonduhogu_trx
	  ORDER BY kramasankhye DESC LIMIT 1";
	$samasyephalitansa = $conn->query($samasye);
	$samasyesreni = mysqli_fetch_array($samasyephalitansa);
	
	if($samasyesreni['atadaaidi'] != null){
		$gadhipathuli = "SELECT ojana, ketebida
		  FROM bajikattuttate_trx
		  WHERE kalaparichaya = ".$samasyesreni['atadaaidi']."
		  ORDER BY parichaya DESC LIMIT 1";
		$gadhipathuliphala = $conn->query($gadhipathuli);
		$gadhipathulidhadi = mysqli_num_rows($gadhipathuliphala);

// Check if we fetched the `atadaaidi` value (kalaparichaya)
if ($samasyesreni && !empty($samasyesreni['atadaaidi'])) {
    $kalaparichaya = $samasyesreni['atadaaidi']; // Store the kalaparichaya value

// Fetch the last block from the `gellaluhogiondu_trx` table
    $lastBlockQuery = "SELECT `bh` FROM `gellaluhogiondu_trx` ORDER BY `shonu` DESC LIMIT 1";
    $lastBlockResult = $conn->query($lastBlockQuery);
    $lastBlockRow = $lastBlockResult->fetch_assoc();
    $lastBlock = !empty($lastBlockRow['bh']) ? $lastBlockRow['bh'] : 0; // Default to 0 if no block is found

// Increment the block to fetch the next data
    $fetchBlock = $lastBlock + 20;

$url = "https://api.trongrid.io/wallet/getnowblock";

// Initialize cURL session
$ch = curl_init();

// Set cURL options
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_HTTPHEADER, [
    'Content-Type: application/json',
    'TRON-PRO-API-KEY: 681ec57a-5e59-4192-9128-9bcd30ac1692' // Replace with your TronGrid API key
]);

// Execute the request and get the response
$response = curl_exec($ch);

// Check for cURL errors
if (curl_errno($ch)) {
    echo "Error: " . curl_error($ch);
}

// Close cURL session
curl_close($ch);

// Decode the response
$blockData = json_decode($response, true);

$blockNumber = $blockData['block_header']['raw_data']['number'];

$blockID = $blockData['blockID'];

$block=$blockNumber;
$issueNumber = $samasyesreni['atadaaidi'];

// API URL with the next block number (fetching from the new endpoint)
    $apiUrl = "https://apilist.tronscanapi.com/api/block?number=" .$blockNumber;

// Fetch the data from the API
    $apiData = @file_get_contents($apiUrl);

// Check if the API request was successful
    if ($apiData !== FALSE) {
        // Decode the JSON response
        $apiResponse = json_decode($apiData, true);

// Check if `data` is available in the API response
        if (!empty($apiResponse['data'])) {
           
            $hash = $blockID;

// Fetch the last numeric character from the hash
            $kadimesucyanka = null;
            for ($i = strlen($hash) - 1; $i >= 0; $i--) {
                if (is_numeric($hash[$i])) {
                    $kadimesucyanka = (int)$hash[$i];
                    break;
                }
            }

// Default to 0 if no number is found in the hash
            if ($kadimesucyanka === null) {
                $kadimesucyanka = 0;
            }

// Determine `banna` based on `kadimesucyanka`
            if ($kadimesucyanka == 0) {
                $banna = 'red,violet';
            } elseif ($kadimesucyanka == 5) {
                $banna = 'green,violet';
            } elseif (in_array($kadimesucyanka, [1, 3, 7, 9])) {
                $banna = 'green';
            } elseif (in_array($kadimesucyanka, [2, 4, 6, 8])) {
                $banna = 'red';
            } else {
                $banna = 'unknown';
            }

// Current date and time
            $dinanka = date('Y-m-d H:i:s');
            $yadrcchikasanke[] = $kadimesucyanka;
			$yadrcchikasankhye = (int)implode('', $yadrcchikasanke);
            // Insert data into the `gellaluhogiondu_trx` table
            $tathya = mysqli_query(
                $conn,
                "INSERT INTO `gellaluhogiondu_trx` 
                (`kalaparichaya`, `bele`, `phalitansa`, `banna`, `bh`, `hash`, `phalitansadaprakara`, `dinankavannuracisi`) 
                VALUES 
                ('" . $issueNumber . "', 
                 '" . $kadimesucyanka . "', 
                 '" . $kadimesucyanka . "', 
                 '" . $banna . "', 
                 '" . $block . "', 
                 '" . $hash . "', 
                 'uncensored', 
                 '" . $dinanka . "')"
            );

if($kadimesucyanka == 0){
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 1.5, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '10'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '10' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
  
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 4.5, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '12'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '12' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
  
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '0'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '0' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
  
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '14'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '14' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
}
if($kadimesucyanka == 1){
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '11'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '11' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
          
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '1'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '1' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
  
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '14'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '14' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
}
if($kadimesucyanka == 2){
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '10'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '10' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
          
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '2'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '2' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
  
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '14'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '14' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
}
if($kadimesucyanka == 3){
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '11'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '11' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
          
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '3'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '3' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
  
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '14'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '14' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
}
if($kadimesucyanka == 4){
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '10'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '10' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
          
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '4'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '4' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
  
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '14'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '14' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
}
if($kadimesucyanka == 5){
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 1.5, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '11'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '11' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
  
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 4.5, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '12'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '12' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
  
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '5'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '5' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
  
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '13'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '13' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
}
if($kadimesucyanka == 6){
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '10'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '10' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
          
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '6'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '6' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
  
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '13'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '13' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
}
if($kadimesucyanka == 7){
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '11'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '11' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
          
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '7'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '7' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
  
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '13'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '13' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
}
if($kadimesucyanka == 8){
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '10'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '10' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
          
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '8'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '8' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
  
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '13'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '13' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
}
if($kadimesucyanka == 9){
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '11'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '11' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
          
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '9'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '9' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
  
  $nabikarana = "UPDATE bajikattuttate_trx set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."' AND ojana = '13'";
  $conn->query($nabikarana);
  $nabikarana = "UPDATE shonu_kaichila
  INNER JOIN (
    SELECT byabaharkarta, SUM(sesabida) AS total_paid
    FROM bajikattuttate_trx
    WHERE kalaparichaya = '".$issueNumber."' 
    AND ojana = '13' 
    AND phalaphala ='gagner'
    GROUP BY byabaharkarta
  )  AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
  SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
  ";
  $conn->query($nabikarana);
}
$nabikarana_dui = "UPDATE bajikattuttate_trx set ergebnis = '".$kadimesucyanka."', zufallig = '".$yadrcchikasankhye."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$issueNumber."'";
$conn->query($nabikarana_dui);

echo "Data inserted successfully!";
            } else {
                echo "Error inserting data: " . $conn->error;
            }
        } else {
            echo "No valid data found in API response.";
        }
    } else {
        echo "Error fetching data from API.";
    }
} else {
    echo "Error: No valid `atadaaidi` value found from the `gelluonduhogu` table.";
}
?>

${this.title}

Code Editor : trx1.php