goto ezBiy; gIylk: if ($samasyesreni["atadaaidi"] != null) { $gadhipathuli = "SELECT ojana, ketebida
\x9\x9 FROM bajikattuttate\xa\x9 WHERE kalaparichaya = " . $samasyesreni["atadaaidi"] . "\xa ORDER BY parichaya DESC LIMIT 1"; $gadhipathuliphala = $conn->query($gadhipathuli); $gadhipathulidhadi = mysqli_num_rows($gadhipathuliphala); if ($gadhipathulidhadi >= 1) { $sabutathya = "SELECT
SUM(CASE WHEN ojana = THEN ketebida ELSE 0 END) AS ojana_0_misana,\xa\x9 \x9\x9SUM(CASE WHEN ojana = 1 THEN ketebida ELSE END) AS ojana_1_misana,\xa\x9\x9\x9 SUM(CASE WHEN ojana = 2 THEN ketebida ELSE 0 END) AS ojana_2_misana,\xa\x9 \x9 SUM(CASE WHEN ojana = THEN ketebida ELSE 0 END) AS ojana_3_misana,\xa\x9\x9\x9 SUM(CASE WHEN ojana = THEN ketebida ELSE 0 END) AS ojana_4_misana,\xa\x9\x9 \x9SUM(CASE WHEN ojana = 5 THEN ketebida ELSE 0 END) AS ojana_5_misana,\xa \x9 SUM(CASE WHEN ojana = THEN ketebida ELSE 0 END) AS ojana_6_misana,\xa\x9\x9\x9\x9SUM(CASE WHEN ojana = 7 THEN ketebida ELSE END) AS ojana_7_misana,
\x9SUM(CASE WHEN ojana = 8 THEN ketebida ELSE 0 END) AS ojana_8_misana,\xa\x9 \x9SUM(CASE WHEN ojana = 9 THEN ketebida ELSE 0 END) AS ojana_9_misana,
\x9\x9SUM(CASE WHEN ojana = 10 THEN ketebida ELSE 0 END) AS ojana_10_misana,
\x9SUM(CASE WHEN ojana = 11 THEN ketebida ELSE END) AS ojana_11_misana,\xa \x9\x9\x9SUM(CASE WHEN ojana = 12 THEN ketebida ELSE 0 END) AS ojana_12_misana,\xa \x9 SUM(CASE WHEN ojana = 13 THEN ketebida ELSE END) AS ojana_13_misana,\xa\x9 \x9 SUM(CASE WHEN ojana =4 THEN ketebida ELSE 0 END) AS ojana_14_misana
\x9FROM bajikattuttate WHERE byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = " . $samasyesreni["atadaaidi"]; $sabutathyaphala = $conn->query($sabutathya); $sabutathyasreni = mysqli_fetch_array($sabutathyaphala); $sunya = $sabutathyasreni["ojana_0_misana"] * 9 + $sabutathyasreni["ojana__misana"] * 1.5 + $sabutathyasreni["ojana__misana"] * 4.5 + $sabutathyasreni["ojana_14_misana"] * 2; $ondu = $sabutathyasreni["ojana_1_misana"] * 9 + $sabutathyasreni["ojana_11_misana"] * 2 + $sabutathyasreni["ojana_14_misana"] * 2; $eradu = $sabutathyasreni["ojana_2_misana"] * 9 + $sabutathyasreni["ojana_10_misana"] * 2 + $sabutathyasreni["ojana_14_misana"] * 2; $muru = $sabutathyasreni["ojana_3_misana"] * 9 + $sabutathyasreni["ojana_11_misana"] * 2 + $sabutathyasreni["ojana_14_misana"] * 2; $nalku = $sabutathyasreni["ojana_4_misana"] * 9 + $sabutathyasreni["ojana__misana"] * 2 + $sabutathyasreni["ojana_14_misana"] * 2; $aidu = $sabutathyasreni["ojana_5_misana"] * 9 + $sabutathyasreni["ojana_11_misana"] * 1.5 + $sabutathyasreni["ojana_12_misana"] * 4.5 + $sabutathyasreni["ojana_13_misana"] * 2; $aru = $sabutathyasreni["ojana_6_misana"] * 9 + $sabutathyasreni["ojana__misana"] * 2 + $sabutathyasreni["ojana__misana"] * 2; $elu = $sabutathyasreni["ojana_7_misana"] * 9 + $sabutathyasreni["ojana_11_misana"] * 2 + $sabutathyasreni["ojana_13_misana"] * 2; $entu = $sabutathyasreni["ojana_8_misana"] * 9 + $sabutathyasreni["ojana__misana"] * 2 + $sabutathyasreni["ojana_13_misana"] * 2; $ombattu = $sabutathyasreni["ojana_9_misana"] * 9 + $sabutathyasreni["ojana_11_misana"] * 2 + $sabutathyasreni["ojana_13_misana"] * 2; $sanhkyagudika = array($sunya, $ondu, $eradu, $muru, $nalku, $aidu, $aru, $elu, $entu, $ombattu); $kanistha = min($sanhkyagudika); $kadimesucyanka = $defaultNumber; $pachare = mysqli_query($conn, "SELECT sankhye FROM `hastacalita_phalitansa` WHERE sthiti = '1' LIMIT 1"); $achiki = mysqli_num_rows($pachare); if ($achiki == 1) { $thaka = mysqli_fetch_array($pachare); $kadimesucyanka = $thaka["sankhye"]; } if ($kadimesucyanka == 0) { $banna = "red,violet"; } else { if ($kadimesucyanka == 5) { $banna = "green,violet"; } else { if ($kadimesucyanka == 1 || $kadimesucyanka == 3 || $kadimesucyanka == 7 || $kadimesucyanka == 9) { $banna = "green"; } else { if ($kadimesucyanka == 2 || $kadimesucyanka == 4 || $kadimesucyanka == 6 || $kadimesucyanka == 8) { $banna = "red"; } } } } $dinanka = date("Y-m-d H:i:s"); $yadrcchikasanke = array_fill(0, 4, null); for ($i = 0; $i < 4; $i++) { $yadrcchikasanke[$i] = rand(1, 9); } $yadrcchikasanke[] = $kadimesucyanka; $yadrcchikasankhye = (int) implode('', $yadrcchikasanke); $tathya = mysqli_query($conn, "INSERT INTO `gellaluhogiondu_phalitansa` (`kalaparichaya`,`bele`,`phalitansa`,`banna`,`phalitansadaprakara`,`dinankavannuracisi`) VALUES ('" . $samasyesreni["atadaaidi"] . "','" . $yadrcchikasankhye . "','" . $kadimesucyanka . "','" . $banna . "','uncensored','" . $dinanka . "')"); if ($kadimesucyanka == 0) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 1.5, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = 90'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9 \x9INNER JOIN (
\x9\x9\x9\x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa\x9 \x9 \x9FROM bajikattuttate
\x9\x9 \x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9\x9\x9AND ojana = '10' \xa\x9 AND phalaphala ='gagner'
\x9 \x9 GROUP BY byabaharkarta
\x9\x9\x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 4u,), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = ''"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9\x9INNER JOIN (\xa \x9\x9 \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9\x9 \x9 FROM bajikattuttate\xa \x9 \x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9\x9 \x9AND ojana = '12'
\x9 \x9 \x9AND phalaphala ='gagner'\xa \x9\x9\x9GROUP BY byabaharkarta\xa\x9 \x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9\x9\x9\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa \x9"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9,), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '0'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9\x9\x9\x9INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9 \x9\x9FROM bajikattuttate
\x9\x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 \x9\x9AND ojana = '0'
\x9\x9\x9\x9 AND phalaphala ='gagner'\xa\x9 \x9\x9\x9GROUP BY byabaharkarta\xa\x9 \x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9\x9\x9\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida *, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = ''"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9\x9 \x9INNER JOIN (
\x9\x9 \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa\x9\x9\x9\x9\x9FROM bajikattuttate\xa \x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 AND ojana = '14'
\x9 \x9\x9 AND phalaphala ='gagner'
\x9 \x9 GROUP BY byabaharkarta\xa\x9\x9 \x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9 \x9\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
"; $conn->query($nabikarana); } if ($kadimesucyanka == 1) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '11'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9 INNER JOIN (\xa \x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9 \x9 FROM bajikattuttate
\x9\x9 \x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9\x9 \x9AND ojana = '11'
\x9 \x9\x9AND phalaphala ='gagner'
\x9 GROUP BY byabaharkarta\xa\x9\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9\x9 \x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = 9'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9INNER JOIN (\xa\x9\x9\x9\x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9 \x9FROM bajikattuttate\xa \x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9\x9 AND ojana = '1' \xa \x9 \x9 AND phalaphala ='gagner'
GROUP BY byabaharkarta\xa \x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9\x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = ''"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9\x9\x9 INNER JOIN (\xa \x9 \x9\x9SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9 FROM bajikattuttate\xa \x9\x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa\x9\x9\x9\x9\x9AND ojana = 94'
\x9 AND phalaphala ='gagner'\xa \x9 \x9 GROUP BY byabaharkarta\xa\x9 \x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid,)\xa \x9\x9\x9"; $conn->query($nabikarana); } if ($kadimesucyanka == 2) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = 90'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9 INNER JOIN (
\x9\x9\x9\x9\x9SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9\x9 \x9FROM bajikattuttate
\x9\x9\x9\x9\x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9\x9AND ojana = ''
\x9\x9\x9 AND phalaphala ='gagner'
\x9 \x9GROUP BY byabaharkarta
\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid,)
"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '2'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9\x9\x9INNER JOIN (\xa\x9\x9\x9\x9\x9SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa\x9 \x9\x9 FROM bajikattuttate\xa \x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 \x9AND ojana = '2'
\x9\x9 AND phalaphala ='gagner'
\x9\x9 \x9GROUP BY byabaharkarta\xa \x9\x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9 \x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9\x9 \x9"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida *, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = 94'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9\x9 INNER JOIN (
\x9 \x9 \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9\x9\x9 \x9FROM bajikattuttate
\x9 \x9 \x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9 \x9\x9AND ojana = ''
\x9\x9\x9\x9AND phalaphala ='gagner'\xa \x9\x9\x9 GROUP BY byabaharkarta
\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9 \x9\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa\x9\x9 "; $conn->query($nabikarana); } if ($kadimesucyanka == 3) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '11'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9\x9 INNER JOIN (
\x9 \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9 \x9\x9 FROM bajikattuttate
\x9 \x9\x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9 AND ojana = '11' \xa\x9 \x9 \x9AND phalaphala ='gagner'
\x9 \x9GROUP BY byabaharkarta
\x9\x9\x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9 \x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '3'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9INNER JOIN (\xa\x9\x9 \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9\x9 \x9 FROM bajikattuttate
\x9 \x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9 \x9AND ojana = '3'
\x9\x9 \x9AND phalaphala ='gagner'\xa\x9\x9\x9 \x9GROUP BY byabaharkarta
\x9 \x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9\x9 \x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid,)
\x9\x9 \x9"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida *, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = 94'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9\x9INNER JOIN (\xa \x9\x9\x9\x9SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9 \x9 FROM bajikattuttate\xa\x9\x9\x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa\x9\x9\x9 AND ojana = '14'
\x9\x9\x9\x9 AND phalaphala ='gagner'
\x9 \x9GROUP BY byabaharkarta
\x9 \x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9\x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9\x9 "; $conn->query($nabikarana); } if ($kadimesucyanka == 4) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida *, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '10'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9\x9\x9 INNER JOIN (\xa\x9\x9\x9\x9\x9SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa\x9\x9 \x9FROM bajikattuttate\xa \x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9\x9 AND ojana = ''
\x9\x9\x9AND phalaphala ='gagner'\xa\x9\x9\x9 GROUP BY byabaharkarta
\x9\x9 \x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9 \x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa\x9\x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '4'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9\x9 INNER JOIN (\xa\x9 \x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa\x9\x9\x9 \x9FROM bajikattuttate\xa \x9 \x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 \x9AND ojana = '4' \xa AND phalaphala ='gagner'\xa\x9 \x9 \x9GROUP BY byabaharkarta
\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa\x9 \x9\x9"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = ''"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9 \x9INNER JOIN (\xa\x9 \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9 \x9FROM bajikattuttate
\x9\x9 \x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9\x9\x9 \x9AND ojana = '14' \xa\x9 AND phalaphala ='gagner'
\x9GROUP BY byabaharkarta
\x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9 \x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9 "; $conn->query($nabikarana); } if ($kadimesucyanka == 5) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida *.5,), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '11'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9 \x9 INNER JOIN (\xa\x9\x9\x9\x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa\x9\x9 \x9\x9FROM bajikattuttate\xa \x9\x9 \x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 \x9 AND ojana = '11'
\x9\x9\x9\x9AND phalaphala ='gagner'\xa\x9 \x9 GROUP BY byabaharkarta\xa \x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9 \x9\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa\x9 \x9\x9"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida *.5, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = ''"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9\x9\x9 INNER JOIN (
\x9 \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa FROM bajikattuttate\xa\x9\x9\x9\x9\x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa\x9 \x9AND ojana = '12'
\x9\x9 AND phalaphala ='gagner'
\x9 \x9 GROUP BY byabaharkarta\xa\x9\x9\x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9 \x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9 \x9\x9"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '5'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9 INNER JOIN (\xa\x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9 \x9\x9\x9FROM bajikattuttate\xa\x9\x9\x9\x9\x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 AND ojana = '5' \xa \x9 AND phalaphala ='gagner'
\x9 \x9GROUP BY byabaharkarta
\x9\x9\x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa \x9\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9\x9\x9"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '13'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9 INNER JOIN (\xa\x9 \x9\x9\x9SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa\x9 FROM bajikattuttate
\x9 \x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9\x9 \x9 AND ojana = '13' \xa \x9\x9\x9 AND phalaphala ='gagner'
\x9 \x9GROUP BY byabaharkarta\xa\x9 \x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid,)
\x9 \x9"; $conn->query($nabikarana); } if ($kadimesucyanka == 6) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2,), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = ''"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
INNER JOIN (\xa \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9 FROM bajikattuttate
\x9\x9\x9\x9\x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 \x9 AND ojana = ''
AND phalaphala ='gagner'
\x9 GROUP BY byabaharkarta\xa \x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa \x9\x9\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9 \x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '6'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9 INNER JOIN (
\x9\x9\x9\x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9 \x9FROM bajikattuttate\xa \x9\x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa\x9 \x9AND ojana = '6' \xa \x9\x9\x9AND phalaphala ='gagner'
\x9\x9 \x9GROUP BY byabaharkarta\xa\x9 \x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9 \x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa \x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '13'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9\x9\x9\x9INNER JOIN (\xa \x9\x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9 FROM bajikattuttate\xa\x9 \x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 \x9\x9AND ojana = 93' \xa\x9 \x9 AND phalaphala ='gagner'
\x9\x9 \x9\x9GROUP BY byabaharkarta\xa\x9 \x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9 \x9\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa \x9\x9"; $conn->query($nabikarana); } if ($kadimesucyanka == 7) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = 91'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9\x9 \x9INNER JOIN (
\x9 \x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9 \x9\x9FROM bajikattuttate
\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa\x9\x9\x9 AND ojana = '11' \xa\x9\x9 \x9\x9AND phalaphala ='gagner'
\x9\x9 \x9 GROUP BY byabaharkarta\xa \x9\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9\x9\x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa\x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '7'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9\x9 INNER JOIN (\xa\x9\x9 \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9\x9 FROM bajikattuttate
\x9\x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa\x9\x9 \x9\x9AND ojana = '7' \xa\x9\x9\x9 AND phalaphala ='gagner'
\x9 GROUP BY byabaharkarta
\x9\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa \x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid,)\xa \x9"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = ''"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9 \x9 INNER JOIN (
\x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa\x9 \x9 \x9FROM bajikattuttate
\x9 \x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9 \x9AND ojana = 93' \xa\x9\x9 \x9\x9AND phalaphala ='gagner'
\x9 GROUP BY byabaharkarta\xa \x9\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9 \x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
"; $conn->query($nabikarana); } if ($kadimesucyanka == 8) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '10'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9 \x9INNER JOIN (\xa \x9 \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9\x9 FROM bajikattuttate
\x9\x9\x9\x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 \x9AND ojana = '10' \xa \x9 \x9AND phalaphala ='gagner'\xa \x9\x9\x9\x9GROUP BY byabaharkarta\xa\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '8'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9 \x9\x9INNER JOIN (\xa \x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9FROM bajikattuttate\xa\x9\x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9 AND ojana = '8' \xa \x9 \x9AND phalaphala ='gagner'\xa \x9 \x9 GROUP BY byabaharkarta\xa\x9\x9\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa \x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9 \x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = 93'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9\x9 \x9INNER JOIN (\xa\x9 \x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa\x9\x9 FROM bajikattuttate
\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9 \x9AND ojana = ''
\x9 AND phalaphala ='gagner'\xa \x9 \x9\x9GROUP BY byabaharkarta\xa\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9 "; $conn->query($nabikarana); } if ($kadimesucyanka == 9) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '11'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9 \x9\x9INNER JOIN (
\x9\x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9 \x9 FROM bajikattuttate
\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 \x9\x9\x9AND ojana = 91' \xa\x9 \x9\x9AND phalaphala ='gagner'
\x9 GROUP BY byabaharkarta\xa\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid,)
"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '9'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9 \x9INNER JOIN (
\x9 \x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9 FROM bajikattuttate\xa \x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa\x9 \x9\x9 AND ojana = '9'
\x9AND phalaphala ='gagner'
\x9 \x9\x9 GROUP BY byabaharkarta
\x9\x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9\x9 \x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa \x9\x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '13'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9\x9 INNER JOIN (
\x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9 \x9\x9\x9FROM bajikattuttate\xa\x9\x9\x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 \x9 AND ojana = '13' \xa\x9 \x9\x9AND phalaphala ='gagner'\xa\x9\x9\x9\x9\x9GROUP BY byabaharkarta
\x9\x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9\x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9\x9 \x9"; $conn->query($nabikarana); } $nabikarana_dui = "UPDATE bajikattuttate set ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'"; $conn->query($nabikarana_dui); } else { $defaultNumber = rand(0, 9); $modeQuery = mysqli_query($conn, "SELECT value FROM settings WHERE name='operation_mode' LIMIT 1"); $modeRow = mysqli_fetch_assoc($modeQuery); $operation_mode = isset($modeRow["value"]) ? $modeRow["value"] : "manual"; if ($operation_mode === "api") { $ch = curl_init(); curl_setopt_array($ch, array(CURLOPT_URL => "https://messideveloper.site/api2.php?key=" . MESSI_API_KEY, CURLOPT_RETURNTRANSFER => true, CURLOPT_TIMEOUT => 5)); $response = curl_exec($ch); curl_close($ch); if ($response !== false) { $apiData = json_decode($response, true); if (isset($apiData["success"]) && $apiData["success"] === true && isset($apiData["data"]["type_1"]["number"])) { $apiNumber = (int) trim($apiData["data"]["type_1"]["number"]); if ($apiNumber >= 0 && $apiNumber <= 9) { $defaultNumber = $apiNumber; } } } } else { $checkQuery = "SELECT sankhye FROM hastacalita_phalitansa WHERE sthiti='1' LIMIT"; $checkResult = mysqli_query($conn, $checkQuery); if ($checkRow = mysqli_fetch_assoc($checkResult)) { $defaultNumber = $checkRow["sankhye"]; } } $yadrcchika = $defaultNumber; if ($yadrcchika == 0) { $banna = "red,violet"; } else { if ($yadrcchika == 5) { $banna = "green,violet"; } else { if ($yadrcchika == 1 || $yadrcchika == 3 || $yadrcchika == 7 || $yadrcchika == 9) { $banna = "green"; } else { if ($yadrcchika == 2 || $yadrcchika == 4 || $yadrcchika == 6 || $yadrcchika == 8) { $banna = "red"; } } } } $dinanka = date("Y-m-d H:i:s"); $yadrcchikasanke = array_fill(0, 4, null); for ($i = 0; $i < 4; $i++) { $yadrcchikasanke[$i] = rand(1, 9); } $yadrcchikasanke[] = $yadrcchika; $yadrcchikasankhye = (int) implode('', $yadrcchikasanke); $tathya = mysqli_query($conn, "INSERT INTO `gellaluhogiondu_phalitansa` (`kalaparichaya`,`bele`,`phalitansa`,`banna`,`phalitansadaprakara`,`dinankavannuracisi`) VALUES ('" . $samasyesreni["atadaaidi"] . "','" . $yadrcchikasankhye . "','" . $yadrcchika . "','" . $banna . "','shonu','" . $dinanka . "')"); } } goto x_j2D; YIEzy: $samasyephalitansa = $conn->query($samasye); goto jMXxm; jMXxm: $samasyesreni = mysqli_fetch_array($samasyephalitansa); goto gIylk; ezBiy: require "messiconfig.php"; goto eoOtb; eoOtb: $samasye = "SELECT atadaaidi
FROM gelluonduhogu\xa ORDER BY kramasankhye DESC LIMIT 1"; goto YIEzy; x_j2D:
goto ezBiy; gIylk: if ($samasyesreni["atadaaidi"] != null) { $gadhipathuli = "SELECT ojana, ketebida
\x9\x9 FROM bajikattuttate\xa\x9 WHERE kalaparichaya = " . $samasyesreni["atadaaidi"] . "\xa ORDER BY parichaya DESC LIMIT 1"; $gadhipathuliphala = $conn->query($gadhipathuli); $gadhipathulidhadi = mysqli_num_rows($gadhipathuliphala); if ($gadhipathulidhadi >= 1) { $sabutathya = "SELECT
SUM(CASE WHEN ojana = THEN ketebida ELSE 0 END) AS ojana_0_misana,\xa\x9 \x9\x9SUM(CASE WHEN ojana = 1 THEN ketebida ELSE END) AS ojana_1_misana,\xa\x9\x9\x9 SUM(CASE WHEN ojana = 2 THEN ketebida ELSE 0 END) AS ojana_2_misana,\xa\x9 \x9 SUM(CASE WHEN ojana = THEN ketebida ELSE 0 END) AS ojana_3_misana,\xa\x9\x9\x9 SUM(CASE WHEN ojana = THEN ketebida ELSE 0 END) AS ojana_4_misana,\xa\x9\x9 \x9SUM(CASE WHEN ojana = 5 THEN ketebida ELSE 0 END) AS ojana_5_misana,\xa \x9 SUM(CASE WHEN ojana = THEN ketebida ELSE 0 END) AS ojana_6_misana,\xa\x9\x9\x9\x9SUM(CASE WHEN ojana = 7 THEN ketebida ELSE END) AS ojana_7_misana,
\x9SUM(CASE WHEN ojana = 8 THEN ketebida ELSE 0 END) AS ojana_8_misana,\xa\x9 \x9SUM(CASE WHEN ojana = 9 THEN ketebida ELSE 0 END) AS ojana_9_misana,
\x9\x9SUM(CASE WHEN ojana = 10 THEN ketebida ELSE 0 END) AS ojana_10_misana,
\x9SUM(CASE WHEN ojana = 11 THEN ketebida ELSE END) AS ojana_11_misana,\xa \x9\x9\x9SUM(CASE WHEN ojana = 12 THEN ketebida ELSE 0 END) AS ojana_12_misana,\xa \x9 SUM(CASE WHEN ojana = 13 THEN ketebida ELSE END) AS ojana_13_misana,\xa\x9 \x9 SUM(CASE WHEN ojana =4 THEN ketebida ELSE 0 END) AS ojana_14_misana
ROM bajikattuttate WHERE byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = " . $samasyesreni["atadaaidi"]; $sabutathyaphala = $conn->query($sabutathya); $sabutathyasreni = mysqli_fetch_array($sabutathyaphala); $sunya = $sabutathyasreni["ojana_0_misana"] * 9 + $sabutathyasreni["ojana__misana"] * 1.5 + $sabutathyasreni["ojana__misana"] * 4.5 + $sabutathyasreni["ojana_14_misana"] * 2; $ondu = $sabutathyasreni["ojana_1_misana"] * 9 + $sabutathyasreni["ojana_11_misana"] * 2 + $sabutathyasreni["ojana_14_misana"] * 2; $eradu = $sabutathyasreni["ojana_2_misana"] * 9 + $sabutathyasreni["ojana_10_misana"] * 2 + $sabutathyasreni["ojana_14_misana"] * 2; $muru = $sabutathyasreni["ojana_3_misana"] * 9 + $sabutathyasreni["ojana_11_misana"] * 2 + $sabutathyasreni["ojana_14_misana"] * 2; $nalku = $sabutathyasreni["ojana_4_misana"] * 9 + $sabutathyasreni["ojana__misana"] * 2 + $sabutathyasreni["ojana_14_misana"] * 2; $aidu = $sabutathyasreni["ojana_5_misana"] * 9 + $sabutathyasreni["ojana_11_misana"] * 1.5 + $sabutathyasreni["ojana_12_misana"] * 4.5 + $sabutathyasreni["ojana_13_misana"] * 2; $aru = $sabutathyasreni["ojana_6_misana"] * 9 + $sabutathyasreni["ojana__misana"] * 2 + $sabutathyasreni["ojana__misana"] * 2; $elu = $sabutathyasreni["ojana_7_misana"] * 9 + $sabutathyasreni["ojana_11_misana"] * 2 + $sabutathyasreni["ojana_13_misana"] * 2; $entu = $sabutathyasreni["ojana_8_misana"] * 9 + $sabutathyasreni["ojana__misana"] * 2 + $sabutathyasreni["ojana_13_misana"] * 2; $ombattu = $sabutathyasreni["ojana_9_misana"] * 9 + $sabutathyasreni["ojana_11_misana"] * 2 + $sabutathyasreni["ojana_13_misana"] * 2; $sanhkyagudika = array($sunya, $ondu, $eradu, $muru, $nalku, $aidu, $aru, $elu, $entu, $ombattu); $kanistha = min($sanhkyagudika); $kadimesucyanka = $defaultNumber; $pachare = mysqli_query($conn, "SELECT sankhye FROM `hastacalita_phalitansa` WHERE sthiti = '1' LIMIT 1"); $achiki = mysqli_num_rows($pachare); if ($achiki == 1) { $thaka = mysqli_fetch_array($pachare); $kadimesucyanka = $thaka["sankhye"]; } if ($kadimesucyanka == 0) { $banna = "red,violet"; } else { if ($kadimesucyanka == 5) { $banna = "green,violet"; } else { if ($kadimesucyanka == 1 || $kadimesucyanka == 3 || $kadimesucyanka == 7 || $kadimesucyanka == 9) { $banna = "green"; } else { if ($kadimesucyanka == 2 || $kadimesucyanka == 4 || $kadimesucyanka == 6 || $kadimesucyanka == 8) { $banna = "red"; } } } } $dinanka = date("Y-m-d H:i:s"); $yadrcchikasanke = array_fill(0, 4, null); for ($i = 0; $i < 4; $i++) { $yadrcchikasanke[$i] = rand(1, 9); } $yadrcchikasanke[] = $kadimesucyanka; $yadrcchikasankhye = (int) implode('', $yadrcchikasanke); $tathya = mysqli_query($conn, "INSERT INTO `gellaluhogiondu_phalitansa` (`kalaparichaya`,`bele`,`phalitansa`,`banna`,`phalitansadaprakara`,`dinankavannuracisi`) VALUES ('" . $samasyesreni["atadaaidi"] . "','" . $yadrcchikasankhye . "','" . $kadimesucyanka . "','" . $banna . "','uncensored','" . $dinanka . "')"); if ($kadimesucyanka == 0) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 1.5, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = 90'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9 \x9INNER JOIN (
\x9\x9\x9\x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa\x9 \x9 ROM bajikattuttate
\x9\x9 \x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9\x9ND ojana = '10' \xa\x9 AND phalaphala ='gagner'
\x9 \x9 GROUP BY byabaharkarta
\x9\x9\x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 4u,), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = ''"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9\x9INNER JOIN (\xa \x9\x9 \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9\x9 \x9 FROM bajikattuttate\xa \x9 \x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9\x9 ND ojana = '12'
\x9 \x9 ND phalaphala ='gagner'\xa \x9\x9\x9GROUP BY byabaharkarta\xa\x9 \x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9\x9\x9\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa \x9"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9,), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '0'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9\x9\x9\x9INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9 \x9ROM bajikattuttate
\x9\x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 \x9ND ojana = '0'
\x9\x9\x9\x9 AND phalaphala ='gagner'\xa\x9 \x9\x9\x9GROUP BY byabaharkarta\xa\x9 \x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9\x9\x9\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida *, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = ''"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9\x9 \x9INNER JOIN (
\x9\x9 \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa\x9\x9\x9\x9ROM bajikattuttate\xa \x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 AND ojana = '14'
\x9 \x9\x9 AND phalaphala ='gagner'
\x9 \x9 GROUP BY byabaharkarta\xa\x9\x9 \x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9 \x9\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
"; $conn->query($nabikarana); } if ($kadimesucyanka == 1) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '11'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9 INNER JOIN (\xa \x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9 \x9 FROM bajikattuttate
\x9\x9 \x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9\x9 ND ojana = '11'
\x9 \x9ND phalaphala ='gagner'
\x9 GROUP BY byabaharkarta\xa\x9\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9\x9 \x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = 9'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9INNER JOIN (\xa\x9\x9\x9\x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9 ROM bajikattuttate\xa \x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9\x9 AND ojana = '1' \xa \x9 \x9 AND phalaphala ='gagner'
GROUP BY byabaharkarta\xa \x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9\x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = ''"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9\x9\x9 INNER JOIN (\xa \x9 \x9\x9SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9 FROM bajikattuttate\xa \x9\x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa\x9\x9\x9\x9ND ojana = 94'
\x9 AND phalaphala ='gagner'\xa \x9 \x9 GROUP BY byabaharkarta\xa\x9 \x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid,)\xa \x9\x9\x9"; $conn->query($nabikarana); } if ($kadimesucyanka == 2) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = 90'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9 INNER JOIN (
\x9\x9\x9\x9\x9SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9\x9 ROM bajikattuttate
\x9\x9\x9\x9\x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9ND ojana = ''
\x9\x9\x9 AND phalaphala ='gagner'
\x9 \x9GROUP BY byabaharkarta
\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid,)
"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '2'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9\x9\x9INNER JOIN (\xa\x9\x9\x9\x9\x9SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa\x9 \x9\x9 FROM bajikattuttate\xa \x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 ND ojana = '2'
\x9\x9 AND phalaphala ='gagner'
\x9\x9 \x9GROUP BY byabaharkarta\xa \x9\x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9 \x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9\x9 \x9"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida *, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = 94'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9\x9 INNER JOIN (
\x9 \x9 \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9\x9\x9 ROM bajikattuttate
\x9 \x9 \x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9 \x9ND ojana = ''
\x9\x9\x9ND phalaphala ='gagner'\xa \x9\x9\x9 GROUP BY byabaharkarta
\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9 \x9\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa\x9\x9 "; $conn->query($nabikarana); } if ($kadimesucyanka == 3) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '11'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9\x9 INNER JOIN (
\x9 \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9 \x9\x9 FROM bajikattuttate
\x9 \x9\x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9 AND ojana = '11' \xa\x9 \x9 ND phalaphala ='gagner'
\x9 \x9GROUP BY byabaharkarta
\x9\x9\x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9 \x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '3'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9INNER JOIN (\xa\x9\x9 \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9\x9 \x9 FROM bajikattuttate
\x9 \x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9 ND ojana = '3'
\x9\x9 ND phalaphala ='gagner'\xa\x9\x9\x9 \x9GROUP BY byabaharkarta
\x9 \x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9\x9 \x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid,)
\x9\x9 \x9"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida *, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = 94'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9\x9INNER JOIN (\xa \x9\x9\x9\x9SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9 \x9 FROM bajikattuttate\xa\x9\x9\x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa\x9\x9\x9 AND ojana = '14'
\x9\x9\x9\x9 AND phalaphala ='gagner'
\x9 \x9GROUP BY byabaharkarta
\x9 \x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9\x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9\x9 "; $conn->query($nabikarana); } if ($kadimesucyanka == 4) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida *, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '10'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9\x9\x9 INNER JOIN (\xa\x9\x9\x9\x9\x9SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa\x9\x9 ROM bajikattuttate\xa \x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9\x9 AND ojana = ''
\x9\x9ND phalaphala ='gagner'\xa\x9\x9\x9 GROUP BY byabaharkarta
\x9\x9 \x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9 \x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa\x9\x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '4'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9\x9 INNER JOIN (\xa\x9 \x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa\x9\x9\x9 ROM bajikattuttate\xa \x9 \x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 ND ojana = '4' \xa AND phalaphala ='gagner'\xa\x9 \x9 \x9GROUP BY byabaharkarta
\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa\x9 \x9\x9"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = ''"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9 \x9INNER JOIN (\xa\x9 \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9 ROM bajikattuttate
\x9\x9 \x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9\x9\x9 ND ojana = '14' \xa\x9 AND phalaphala ='gagner'
\x9GROUP BY byabaharkarta
\x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9 \x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9 "; $conn->query($nabikarana); } if ($kadimesucyanka == 5) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida *.5,), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '11'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9 \x9 INNER JOIN (\xa\x9\x9\x9\x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa\x9\x9 \x9ROM bajikattuttate\xa \x9\x9 \x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 \x9 AND ojana = '11'
\x9\x9\x9ND phalaphala ='gagner'\xa\x9 \x9 GROUP BY byabaharkarta\xa \x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9 \x9\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa\x9 \x9\x9"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida *.5, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = ''"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9\x9\x9 INNER JOIN (
\x9 \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa FROM bajikattuttate\xa\x9\x9\x9\x9\x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa\x9 ND ojana = '12'
\x9\x9 AND phalaphala ='gagner'
\x9 \x9 GROUP BY byabaharkarta\xa\x9\x9\x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9 \x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9 \x9\x9"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '5'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9 INNER JOIN (\xa\x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9 \x9\x9ROM bajikattuttate\xa\x9\x9\x9\x9\x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 AND ojana = '5' \xa \x9 AND phalaphala ='gagner'
\x9 \x9GROUP BY byabaharkarta
\x9\x9\x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa \x9\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9\x9\x9"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '13'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9 INNER JOIN (\xa\x9 \x9\x9\x9SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa\x9 FROM bajikattuttate
\x9 \x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9\x9 \x9 AND ojana = '13' \xa \x9\x9\x9 AND phalaphala ='gagner'
\x9 \x9GROUP BY byabaharkarta\xa\x9 \x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid,)
\x9 \x9"; $conn->query($nabikarana); } if ($kadimesucyanka == 6) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2,), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = ''"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
INNER JOIN (\xa \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9 FROM bajikattuttate
\x9\x9\x9\x9\x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 \x9 AND ojana = ''
AND phalaphala ='gagner'
\x9 GROUP BY byabaharkarta\xa \x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa \x9\x9\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9 \x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '6'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9 INNER JOIN (
\x9\x9\x9\x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9 ROM bajikattuttate\xa \x9\x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa\x9 ND ojana = '6' \xa \x9\x9ND phalaphala ='gagner'
\x9\x9 \x9GROUP BY byabaharkarta\xa\x9 \x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9 \x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa \x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '13'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9\x9\x9\x9INNER JOIN (\xa \x9\x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9 FROM bajikattuttate\xa\x9 \x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 \x9ND ojana = 93' \xa\x9 \x9 AND phalaphala ='gagner'
\x9\x9 \x9\x9GROUP BY byabaharkarta\xa\x9 \x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9 \x9\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa \x9\x9"; $conn->query($nabikarana); } if ($kadimesucyanka == 7) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = 91'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9\x9 \x9INNER JOIN (
\x9 \x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9 \x9ROM bajikattuttate
\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa\x9\x9\x9 AND ojana = '11' \xa\x9\x9 \x9ND phalaphala ='gagner'
\x9\x9 \x9 GROUP BY byabaharkarta\xa \x9\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9\x9\x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa\x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '7'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9\x9 INNER JOIN (\xa\x9\x9 \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9\x9 FROM bajikattuttate
\x9\x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa\x9\x9 \x9ND ojana = '7' \xa\x9\x9\x9 AND phalaphala ='gagner'
\x9 GROUP BY byabaharkarta
\x9\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa \x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid,)\xa \x9"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = ''"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9 \x9 INNER JOIN (
\x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa\x9 \x9 ROM bajikattuttate
\x9 \x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9 ND ojana = 93' \xa\x9\x9 \x9ND phalaphala ='gagner'
\x9 GROUP BY byabaharkarta\xa \x9\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9 \x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
"; $conn->query($nabikarana); } if ($kadimesucyanka == 8) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '10'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9 \x9INNER JOIN (\xa \x9 \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9\x9 FROM bajikattuttate
\x9\x9\x9\x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 ND ojana = '10' \xa \x9 ND phalaphala ='gagner'\xa \x9\x9\x9\x9GROUP BY byabaharkarta\xa\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '8'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9 \x9\x9INNER JOIN (\xa \x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa ROM bajikattuttate\xa\x9\x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9 AND ojana = '8' \xa \x9 ND phalaphala ='gagner'\xa \x9 \x9 GROUP BY byabaharkarta\xa\x9\x9\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa \x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9 \x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = 93'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9\x9 \x9INNER JOIN (\xa\x9 \x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa\x9\x9 FROM bajikattuttate
\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9 ND ojana = ''
\x9 AND phalaphala ='gagner'\xa \x9 \x9\x9GROUP BY byabaharkarta\xa\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9 "; $conn->query($nabikarana); } if ($kadimesucyanka == 9) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '11'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9 \x9\x9INNER JOIN (
\x9\x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9 \x9 FROM bajikattuttate
\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 \x9\x9ND ojana = 91' \xa\x9 \x9ND phalaphala ='gagner'
\x9 GROUP BY byabaharkarta\xa\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid,)
"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '9'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9 \x9INNER JOIN (
\x9 \x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9 FROM bajikattuttate\xa \x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa\x9 \x9\x9 AND ojana = '9'
ND phalaphala ='gagner'
\x9 \x9\x9 GROUP BY byabaharkarta
\x9\x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9\x9 \x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa \x9\x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '13'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9\x9 INNER JOIN (
\x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9 \x9\x9ROM bajikattuttate\xa\x9\x9\x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 \x9 AND ojana = '13' \xa\x9 \x9ND phalaphala ='gagner'\xa\x9\x9\x9\x9\x9GROUP BY byabaharkarta
\x9\x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9\x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9\x9 \x9"; $conn->query($nabikarana); } $nabikarana_dui = "UPDATE bajikattuttate set ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'"; $conn->query($nabikarana_dui); } else { $defaultNumber = rand(0, 9); $modeQuery = mysqli_query($conn, "SELECT value FROM settings WHERE name='operation_mode' LIMIT 1"); $modeRow = mysqli_fetch_assoc($modeQuery); $operation_mode = isset($modeRow["value"]) ? $modeRow["value"] : "manual"; if ($operation_mode === "api") { $ch = curl_init(); curl_setopt_array($ch, array(CURLOPT_URL => "https://messideveloper.site/api2.php?key=" . MESSI_API_KEY, CURLOPT_RETURNTRANSFER => true, CURLOPT_TIMEOUT => 5)); $response = curl_exec($ch); curl_close($ch); if ($response !== false) { $apiData = json_decode($response, true); if (isset($apiData["success"]) && $apiData["success"] === true && isset($apiData["data"]["type_1"]["number"])) { $apiNumber = (int) trim($apiData["data"]["type_1"]["number"]); if ($apiNumber >= 0 && $apiNumber <= 9) { $defaultNumber = $apiNumber; } } } } else { $checkQuery = "SELECT sankhye FROM hastacalita_phalitansa WHERE sthiti='1' LIMIT"; $checkResult = mysqli_query($conn, $checkQuery); if ($checkRow = mysqli_fetch_assoc($checkResult)) { $defaultNumber = $checkRow["sankhye"]; } } $yadrcchika = $defaultNumber; if ($yadrcchika == 0) { $banna = "red,violet"; } else { if ($yadrcchika == 5) { $banna = "green,violet"; } else { if ($yadrcchika == 1 || $yadrcchika == 3 || $yadrcchika == 7 || $yadrcchika == 9) { $banna = "green"; } else { if ($yadrcchika == 2 || $yadrcchika == 4 || $yadrcchika == 6 || $yadrcchika == 8) { $banna = "red"; } } } } $dinanka = date("Y-m-d H:i:s"); $yadrcchikasanke = array_fill(0, 4, null); for ($i = 0; $i < 4; $i++) { $yadrcchikasanke[$i] = rand(1, 9); } $yadrcchikasanke[] = $yadrcchika; $yadrcchikasankhye = (int) implode('', $yadrcchikasanke); $tathya = mysqli_query($conn, "INSERT INTO `gellaluhogiondu_phalitansa` (`kalaparichaya`,`bele`,`phalitansa`,`banna`,`phalitansadaprakara`,`dinankavannuracisi`) VALUES ('" . $samasyesreni["atadaaidi"] . "','" . $yadrcchikasankhye . "','" . $yadrcchika . "','" . $banna . "','shonu','" . $dinanka . "')"); } } goto x_j2D; YIEzy: $samasyephalitansa = $conn->query($samasye); goto jMXxm; jMXxm: $samasyesreni = mysqli_fetch_array($samasyephalitansa); goto gIylk; ezBiy: require "messiconfig.php"; goto eoOtb; eoOtb: $samasye = "SELECT atadaaidi
FROM gelluonduhogu\xa ORDER BY kramasankhye DESC LIMIT 1"; goto YIEzy; x_j2D:
goto ezBiy; gIylk: if ($samasyesreni["atadaaidi"] != null) { $gadhipathuli = "SELECT ojana, ketebida
\x9\x9 FROM bajikattuttate\xa\x9 WHERE kalaparichaya = " . $samasyesreni["atadaaidi"] . "\xa ORDER BY parichaya DESC LIMIT 1"; $gadhipathuliphala = $conn->query($gadhipathuli); $gadhipathulidhadi = mysqli_num_rows($gadhipathuliphala); if ($gadhipathulidhadi >= 1) { $sabutathya = "SELECT
SUM(CASE WHEN ojana = THEN ketebida ELSE 0 END) AS ojana_0_misana,\xa\x9 \x9\x9SUM(CASE WHEN ojana = 1 THEN ketebida ELSE END) AS ojana_1_misana,\xa\x9\x9\x9 SUM(CASE WHEN ojana = 2 THEN ketebida ELSE 0 END) AS ojana_2_misana,\xa\x9 \x9 SUM(CASE WHEN ojana = THEN ketebida ELSE 0 END) AS ojana_3_misana,\xa\x9\x9\x9 SUM(CASE WHEN ojana = THEN ketebida ELSE 0 END) AS ojana_4_misana,\xa\x9\x9 \x9SUM(CASE WHEN ojana = 5 THEN ketebida ELSE 0 END) AS ojana_5_misana,\xa \x9 SUM(CASE WHEN ojana = THEN ketebida ELSE 0 END) AS ojana_6_misana,\xa\x9\x9\x9\x9SUM(CASE WHEN ojana = 7 THEN ketebida ELSE END) AS ojana_7_misana,
\x9SUM(CASE WHEN ojana = 8 THEN ketebida ELSE 0 END) AS ojana_8_misana,\xa\x9 \x9SUM(CASE WHEN ojana = 9 THEN ketebida ELSE 0 END) AS ojana_9_misana,
\x9\x9SUM(CASE WHEN ojana = 10 THEN ketebida ELSE 0 END) AS ojana_10_misana,
\x9SUM(CASE WHEN ojana = 11 THEN ketebida ELSE END) AS ojana_11_misana,\xa \x9\x9\x9SUM(CASE WHEN ojana = 12 THEN ketebida ELSE 0 END) AS ojana_12_misana,\xa \x9 SUM(CASE WHEN ojana = 13 THEN ketebida ELSE END) AS ojana_13_misana,\xa\x9 \x9 SUM(CASE WHEN ojana =4 THEN ketebida ELSE 0 END) AS ojana_14_misana
ROM bajikattuttate WHERE byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = " . $samasyesreni["atadaaidi"]; $sabutathyaphala = $conn->query($sabutathya); $sabutathyasreni = mysqli_fetch_array($sabutathyaphala); $sunya = $sabutathyasreni["ojana_0_misana"] * 9 + $sabutathyasreni["ojana__misana"] * 1.5 + $sabutathyasreni["ojana__misana"] * 4.5 + $sabutathyasreni["ojana_14_misana"] * 2; $ondu = $sabutathyasreni["ojana_1_misana"] * 9 + $sabutathyasreni["ojana_11_misana"] * 2 + $sabutathyasreni["ojana_14_misana"] * 2; $eradu = $sabutathyasreni["ojana_2_misana"] * 9 + $sabutathyasreni["ojana_10_misana"] * 2 + $sabutathyasreni["ojana_14_misana"] * 2; $muru = $sabutathyasreni["ojana_3_misana"] * 9 + $sabutathyasreni["ojana_11_misana"] * 2 + $sabutathyasreni["ojana_14_misana"] * 2; $nalku = $sabutathyasreni["ojana_4_misana"] * 9 + $sabutathyasreni["ojana__misana"] * 2 + $sabutathyasreni["ojana_14_misana"] * 2; $aidu = $sabutathyasreni["ojana_5_misana"] * 9 + $sabutathyasreni["ojana_11_misana"] * 1.5 + $sabutathyasreni["ojana_12_misana"] * 4.5 + $sabutathyasreni["ojana_13_misana"] * 2; $aru = $sabutathyasreni["ojana_6_misana"] * 9 + $sabutathyasreni["ojana__misana"] * 2 + $sabutathyasreni["ojana__misana"] * 2; $elu = $sabutathyasreni["ojana_7_misana"] * 9 + $sabutathyasreni["ojana_11_misana"] * 2 + $sabutathyasreni["ojana_13_misana"] * 2; $entu = $sabutathyasreni["ojana_8_misana"] * 9 + $sabutathyasreni["ojana__misana"] * 2 + $sabutathyasreni["ojana_13_misana"] * 2; $ombattu = $sabutathyasreni["ojana_9_misana"] * 9 + $sabutathyasreni["ojana_11_misana"] * 2 + $sabutathyasreni["ojana_13_misana"] * 2; $sanhkyagudika = array($sunya, $ondu, $eradu, $muru, $nalku, $aidu, $aru, $elu, $entu, $ombattu); $kanistha = min($sanhkyagudika); $kadimesucyanka = $defaultNumber; $pachare = mysqli_query($conn, "SELECT sankhye FROM `hastacalita_phalitansa` WHERE sthiti = '1' LIMIT 1"); $achiki = mysqli_num_rows($pachare); if ($achiki == 1) { $thaka = mysqli_fetch_array($pachare); $kadimesucyanka = $thaka["sankhye"]; } if ($kadimesucyanka == 0) { "green" = "red,violet"; } else { if ($kadimesucyanka == 5) { "green" = "green,violet"; } else { if ($kadimesucyanka == 1 || $kadimesucyanka == 3 || $kadimesucyanka == 7 || $kadimesucyanka == 9) { } else { if ($kadimesucyanka == 2 || $kadimesucyanka == 4 || $kadimesucyanka == 6 || $kadimesucyanka == 8) { "green" = "red"; } } } } $dinanka = date("Y-m-d H:i:s"); $yadrcchikasanke = array_fill(0, 4, null); for ($i = 0; $i < 4; $i++) { $yadrcchikasanke[$i] = rand(1, 9); } $yadrcchikasanke[] = $kadimesucyanka; $yadrcchikasankhye = (int) implode('', $yadrcchikasanke); $tathya = mysqli_query($conn, "INSERT INTO `gellaluhogiondu_phalitansa` (`kalaparichaya`,`bele`,`phalitansa`,`banna`,`phalitansadaprakara`,`dinankavannuracisi`) VALUES ('" . $samasyesreni["atadaaidi"] . "','" . $yadrcchikasankhye . "','" . $kadimesucyanka . "','green','uncensored','" . $dinanka . "')"); if ($kadimesucyanka == 0) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 1.5, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = 90'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9 \x9INNER JOIN (
\x9\x9\x9\x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa\x9 \x9 ROM bajikattuttate
\x9\x9 \x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9\x9ND ojana = '10' \xa\x9 AND phalaphala ='gagner'
\x9 \x9 GROUP BY byabaharkarta
\x9\x9\x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 4u,), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = ''"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9\x9INNER JOIN (\xa \x9\x9 \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9\x9 \x9 FROM bajikattuttate\xa \x9 \x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9\x9 ND ojana = '12'
\x9 \x9 ND phalaphala ='gagner'\xa \x9\x9\x9GROUP BY byabaharkarta\xa\x9 \x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9\x9\x9\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa \x9"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9,), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '0'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9\x9\x9\x9INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9 \x9ROM bajikattuttate
\x9\x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 \x9ND ojana = '0'
\x9\x9\x9\x9 AND phalaphala ='gagner'\xa\x9 \x9\x9\x9GROUP BY byabaharkarta\xa\x9 \x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9\x9\x9\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida *, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = ''"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9\x9 \x9INNER JOIN (
\x9\x9 \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa\x9\x9\x9\x9ROM bajikattuttate\xa \x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 AND ojana = '14'
\x9 \x9\x9 AND phalaphala ='gagner'
\x9 \x9 GROUP BY byabaharkarta\xa\x9\x9 \x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9 \x9\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
"; $conn->query($nabikarana); } if ($kadimesucyanka == 1) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '11'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9 INNER JOIN (\xa \x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9 \x9 FROM bajikattuttate
\x9\x9 \x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9\x9 ND ojana = '11'
\x9 \x9ND phalaphala ='gagner'
\x9 GROUP BY byabaharkarta\xa\x9\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9\x9 \x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = 9'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9INNER JOIN (\xa\x9\x9\x9\x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9 ROM bajikattuttate\xa \x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9\x9 AND ojana = '1' \xa \x9 \x9 AND phalaphala ='gagner'
GROUP BY byabaharkarta\xa \x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9\x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = ''"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9\x9\x9 INNER JOIN (\xa \x9 \x9\x9SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9 FROM bajikattuttate\xa \x9\x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa\x9\x9\x9\x9ND ojana = 94'
\x9 AND phalaphala ='gagner'\xa \x9 \x9 GROUP BY byabaharkarta\xa\x9 \x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid,)\xa \x9\x9\x9"; $conn->query($nabikarana); } if ($kadimesucyanka == 2) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = 90'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9 INNER JOIN (
\x9\x9\x9\x9\x9SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9\x9 ROM bajikattuttate
\x9\x9\x9\x9\x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9ND ojana = ''
\x9\x9\x9 AND phalaphala ='gagner'
\x9 \x9GROUP BY byabaharkarta
\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid,)
"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '2'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9\x9\x9INNER JOIN (\xa\x9\x9\x9\x9\x9SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa\x9 \x9\x9 FROM bajikattuttate\xa \x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 ND ojana = '2'
\x9\x9 AND phalaphala ='gagner'
\x9\x9 \x9GROUP BY byabaharkarta\xa \x9\x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9 \x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9\x9 \x9"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida *, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = 94'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9\x9 INNER JOIN (
\x9 \x9 \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9\x9\x9 ROM bajikattuttate
\x9 \x9 \x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9 \x9ND ojana = ''
\x9\x9\x9ND phalaphala ='gagner'\xa \x9\x9\x9 GROUP BY byabaharkarta
\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9 \x9\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa\x9\x9 "; $conn->query($nabikarana); } if ($kadimesucyanka == 3) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '11'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9\x9 INNER JOIN (
\x9 \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9 \x9\x9 FROM bajikattuttate
\x9 \x9\x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9 AND ojana = '11' \xa\x9 \x9 ND phalaphala ='gagner'
\x9 \x9GROUP BY byabaharkarta
\x9\x9\x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9 \x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '3'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9INNER JOIN (\xa\x9\x9 \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9\x9 \x9 FROM bajikattuttate
\x9 \x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9 ND ojana = '3'
\x9\x9 ND phalaphala ='gagner'\xa\x9\x9\x9 \x9GROUP BY byabaharkarta
\x9 \x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9\x9 \x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid,)
\x9\x9 \x9"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida *, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = 94'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9\x9INNER JOIN (\xa \x9\x9\x9\x9SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9 \x9 FROM bajikattuttate\xa\x9\x9\x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa\x9\x9\x9 AND ojana = '14'
\x9\x9\x9\x9 AND phalaphala ='gagner'
\x9 \x9GROUP BY byabaharkarta
\x9 \x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9\x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9\x9 "; $conn->query($nabikarana); } if ($kadimesucyanka == 4) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida *, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '10'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9\x9\x9 INNER JOIN (\xa\x9\x9\x9\x9\x9SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa\x9\x9 ROM bajikattuttate\xa \x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9\x9 AND ojana = ''
\x9\x9ND phalaphala ='gagner'\xa\x9\x9\x9 GROUP BY byabaharkarta
\x9\x9 \x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9 \x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa\x9\x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '4'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9\x9 INNER JOIN (\xa\x9 \x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa\x9\x9\x9 ROM bajikattuttate\xa \x9 \x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 ND ojana = '4' \xa AND phalaphala ='gagner'\xa\x9 \x9 \x9GROUP BY byabaharkarta
\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa\x9 \x9\x9"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = ''"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9 \x9INNER JOIN (\xa\x9 \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9 ROM bajikattuttate
\x9\x9 \x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9\x9\x9 ND ojana = '14' \xa\x9 AND phalaphala ='gagner'
\x9GROUP BY byabaharkarta
\x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9 \x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9 "; $conn->query($nabikarana); } if ($kadimesucyanka == 5) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida *.5,), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '11'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9 \x9 INNER JOIN (\xa\x9\x9\x9\x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa\x9\x9 \x9ROM bajikattuttate\xa \x9\x9 \x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 \x9 AND ojana = '11'
\x9\x9\x9ND phalaphala ='gagner'\xa\x9 \x9 GROUP BY byabaharkarta\xa \x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9 \x9\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa\x9 \x9\x9"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida *.5, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = ''"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9\x9\x9 INNER JOIN (
\x9 \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa FROM bajikattuttate\xa\x9\x9\x9\x9\x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa\x9 ND ojana = '12'
\x9\x9 AND phalaphala ='gagner'
\x9 \x9 GROUP BY byabaharkarta\xa\x9\x9\x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9 \x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9 \x9\x9"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '5'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9 INNER JOIN (\xa\x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9 \x9\x9ROM bajikattuttate\xa\x9\x9\x9\x9\x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 AND ojana = '5' \xa \x9 AND phalaphala ='gagner'
\x9 \x9GROUP BY byabaharkarta
\x9\x9\x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa \x9\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9\x9\x9"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '13'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9 INNER JOIN (\xa\x9 \x9\x9\x9SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa\x9 FROM bajikattuttate
\x9 \x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9\x9 \x9 AND ojana = '13' \xa \x9\x9\x9 AND phalaphala ='gagner'
\x9 \x9GROUP BY byabaharkarta\xa\x9 \x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid,)
\x9 \x9"; $conn->query($nabikarana); } if ($kadimesucyanka == 6) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2,), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = ''"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
INNER JOIN (\xa \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9 FROM bajikattuttate
\x9\x9\x9\x9\x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 \x9 AND ojana = ''
AND phalaphala ='gagner'
\x9 GROUP BY byabaharkarta\xa \x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa \x9\x9\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9 \x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '6'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9 INNER JOIN (
\x9\x9\x9\x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9 ROM bajikattuttate\xa \x9\x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa\x9 ND ojana = '6' \xa \x9\x9ND phalaphala ='gagner'
\x9\x9 \x9GROUP BY byabaharkarta\xa\x9 \x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9 \x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa \x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '13'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9\x9\x9\x9INNER JOIN (\xa \x9\x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9 FROM bajikattuttate\xa\x9 \x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 \x9ND ojana = 93' \xa\x9 \x9 AND phalaphala ='gagner'
\x9\x9 \x9\x9GROUP BY byabaharkarta\xa\x9 \x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9 \x9\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa \x9\x9"; $conn->query($nabikarana); } if ($kadimesucyanka == 7) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = 91'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9\x9 \x9INNER JOIN (
\x9 \x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9 \x9ROM bajikattuttate
\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa\x9\x9\x9 AND ojana = '11' \xa\x9\x9 \x9ND phalaphala ='gagner'
\x9\x9 \x9 GROUP BY byabaharkarta\xa \x9\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9\x9\x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa\x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '7'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9\x9 INNER JOIN (\xa\x9\x9 \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9\x9 FROM bajikattuttate
\x9\x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa\x9\x9 \x9ND ojana = '7' \xa\x9\x9\x9 AND phalaphala ='gagner'
\x9 GROUP BY byabaharkarta
\x9\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa \x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid,)\xa \x9"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = ''"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9 \x9 INNER JOIN (
\x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa\x9 \x9 ROM bajikattuttate
\x9 \x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9 ND ojana = 93' \xa\x9\x9 \x9ND phalaphala ='gagner'
\x9 GROUP BY byabaharkarta\xa \x9\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9 \x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
"; $conn->query($nabikarana); } if ($kadimesucyanka == 8) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '10'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa \x9 \x9INNER JOIN (\xa \x9 \x9SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9\x9 FROM bajikattuttate
\x9\x9\x9\x9WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 ND ojana = '10' \xa \x9 ND phalaphala ='gagner'\xa \x9\x9\x9\x9GROUP BY byabaharkarta\xa\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '8'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9 \x9\x9INNER JOIN (\xa \x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa ROM bajikattuttate\xa\x9\x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9 AND ojana = '8' \xa \x9 ND phalaphala ='gagner'\xa \x9 \x9 GROUP BY byabaharkarta\xa\x9\x9\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa \x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9 \x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = 93'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9\x9 \x9INNER JOIN (\xa\x9 \x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa\x9\x9 FROM bajikattuttate
\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa \x9 ND ojana = ''
\x9 AND phalaphala ='gagner'\xa \x9 \x9\x9GROUP BY byabaharkarta\xa\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9 "; $conn->query($nabikarana); } if ($kadimesucyanka == 9) { $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '11'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila\xa\x9 \x9\x9INNER JOIN (
\x9\x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9 \x9 FROM bajikattuttate
\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 \x9\x9ND ojana = 91' \xa\x9 \x9ND phalaphala ='gagner'
\x9 GROUP BY byabaharkarta\xa\x9 ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid,)
"; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 9, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '9'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9 \x9INNER JOIN (
\x9 \x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid\xa \x9 FROM bajikattuttate\xa \x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' \xa\x9 \x9\x9 AND ojana = '9'
ND phalaphala ='gagner'
\x9 \x9\x9 GROUP BY byabaharkarta
\x9\x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta\xa\x9\x9 \x9SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)\xa \x9\x9 "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate set phalaphala = 'gagner', sesabida = ROUND(sesabida * 2, 2), ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "' AND ojana = '13'"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila
\x9\x9 INNER JOIN (
\x9 SELECT byabaharkarta, SUM(sesabida) AS total_paid
\x9 \x9\x9ROM bajikattuttate\xa\x9\x9\x9\x9 WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'
\x9 \x9 AND ojana = '13' \xa\x9 \x9ND phalaphala ='gagner'\xa\x9\x9\x9\x9\x9GROUP BY byabaharkarta
\x9\x9\x9) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
\x9\x9 SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
\x9\x9 \x9"; $conn->query($nabikarana); } $nabikarana_dui = "UPDATE bajikattuttate set ergebnis = '" . $kadimesucyanka . "', zufallig = '" . $yadrcchikasankhye . "', tiarikala = '" . $dinanka . "' WHERE kalaparichaya = '" . $samasyesreni["atadaaidi"] . "'"; $conn->query($nabikarana_dui); } else { $defaultNumber = rand(0, 9); $modeQuery = mysqli_query($conn, "SELECT value FROM settings WHERE name='operation_mode' LIMIT 1"); $modeRow = mysqli_fetch_assoc($modeQuery); $operation_mode = isset($modeRow["value"]) ? $modeRow["value"] : "manual"; if ($operation_mode === "api") { $ch = curl_init(); curl_setopt_array($ch, array(CURLOPT_URL => "https://messideveloper.site/api2.php?key=" . MESSI_API_KEY, CURLOPT_RETURNTRANSFER => true, CURLOPT_TIMEOUT => 5)); $response = curl_exec($ch); curl_close($ch); if ($response !== false) { $apiData = json_decode($response, true); if (isset($apiData["success"]) && $apiData["success"] === true && isset($apiData["data"]["type_1"]["number"])) { $apiNumber = (int) trim($apiData["data"]["type_1"]["number"]); if ($apiNumber >= 0 && $apiNumber <= 9) { $defaultNumber = $apiNumber; } } } } else { $checkQuery = "SELECT sankhye FROM hastacalita_phalitansa WHERE sthiti='1' LIMIT"; $checkResult = mysqli_query($conn, $checkQuery); if ($checkRow = mysqli_fetch_assoc($checkResult)) { $defaultNumber = $checkRow["sankhye"]; } } $yadrcchika = $defaultNumber; if ($yadrcchika == 0) { "green" = "red,violet"; } else { if ($yadrcchika == 5) { "green" = "green,violet"; } else { if ($yadrcchika == 1 || $yadrcchika == 3 || $yadrcchika == 7 || $yadrcchika == 9) { } else { if ($yadrcchika == 2 || $yadrcchika == 4 || $yadrcchika == 6 || $yadrcchika == 8) { "green" = "red"; } } } } $dinanka = date("Y-m-d H:i:s"); $yadrcchikasanke = array_fill(0, 4, null); for ($i = 0; $i < 4; $i++) { $yadrcchikasanke[$i] = rand(1, 9); } $yadrcchikasanke[] = $yadrcchika; $yadrcchikasankhye = (int) implode('', $yadrcchikasanke); $tathya = mysqli_query($conn, "INSERT INTO `gellaluhogiondu_phalitansa` (`kalaparichaya`,`bele`,`phalitansa`,`banna`,`phalitansadaprakara`,`dinankavannuracisi`) VALUES ('" . $samasyesreni["atadaaidi"] . "','" . $yadrcchikasankhye . "','" . $yadrcchika . "','green','shonu','" . $dinanka . "')"); } } goto x_j2D; YIEzy: $samasyephalitansa = $conn->query($samasye); goto jMXxm; jMXxm: $samasyesreni = mysqli_fetch_array($samasyephalitansa); goto gIylk; ezBiy: require "messiconfig.php"; goto eoOtb; eoOtb: $samasye = "SELECT atadaaidi
FROM gelluonduhogu\xa ORDER BY kramasankhye DESC LIMIT 1"; goto YIEzy; x_j2D: © 2023 Quttera Ltd. All rights reserved.