//include("serive/samparka.php"); //Remove IT
$samasye = "SELECT atadaaidi
FROM gelluonduhogu_kemuru_drei
ORDER BY kramasankhye DESC LIMIT 1";//Add Kemuru
$samasyephalitansa = $conn->query($samasye);
$samasyesreni = mysqli_fetch_array($samasyephalitansa);
//$samasyesreni['atadaaidi'] = 20240624010862;
if(isset($samasyesreni['atadaaidi'])){
$gadhipathuli = "SELECT ojana, ketebida
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = ".$samasyesreni['atadaaidi']."
ORDER BY parichaya DESC LIMIT 1";
$gadhipathuliphala = $conn->query($gadhipathuli);
$gadhipathulidhadi = mysqli_num_rows($gadhipathuliphala);
if($gadhipathulidhadi >= 1){
$sabutathya = "SELECT\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '3') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_3_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '4') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_4_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '5') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_5_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '6') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_6_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '7') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_7_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '8') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_8_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '9') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_9_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '10') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_10_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '11') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_11_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '12') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_12_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '13') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_13_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '14') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_14_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '15') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_15_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '16') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_16_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '17') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_17_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '18') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_18_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, 'H') AND INSTR(prakar, '2') THEN ketebida ELSE 0 END) AS ojana_H_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, 'L') AND INSTR(prakar, '2') THEN ketebida ELSE 0 END) AS ojana_L_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, 'O') AND INSTR(prakar, '3') THEN ketebida ELSE 0 END) AS ojana_O_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, 'E') AND INSTR(prakar, '3') THEN ketebida ELSE 0 END) AS ojana_E_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 9 THEN ketebida ELSE 0 END) AS prakar_9_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 10 THEN ketebida ELSE 0 END) AS prakar_10_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 4 THEN ketebida ELSE 0 END) AS prakar_4_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 7 THEN ketebida ELSE 0 END) AS prakar_7_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 8 THEN ketebida ELSE 0 END) AS prakar_8_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 6 THEN ketebida ELSE 0 END) AS prakar_6_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 5 THEN ketebida ELSE 0 END) AS prakar_5_misana\xd\xa\x9\x9\x9\x9FROM bajikattuttate_kemuru_drei WHERE byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'];
$sabutathyaphala = $conn->query($sabutathya);
$sabutathyasreni = mysqli_fetch_array($sabutathyaphala);
$tini = ($sabutathyasreni["ojana_3_misana"] * 207.36) + ($sabutathyasreni["ojana_L_misana"] * 1.92) + ($sabutathyasreni["ojana_O_misana"] * 1.92);
$chari = ($sabutathyasreni["ojana_4_misana"] * 69.12) + ($sabutathyasreni["ojana_L_misana"] * 1.92) + ($sabutathyasreni["ojana_E_misana"] * 1.92);
$panche = ($sabutathyasreni["ojana_5_misana"] * 34.56) + ($sabutathyasreni["ojana_L_misana"] * 1.92) + ($sabutathyasreni["ojana_O_misana"] * 1.92);
$chha = ($sabutathyasreni["ojana_6_misana"] * 20.74) + ($sabutathyasreni["ojana_L_misana"] * 1.92) + ($sabutathyasreni["ojana_E_misana"] * 1.92);
$saate = ($sabutathyasreni["ojana_7_misana"] * 13.83) + ($sabutathyasreni["ojana_L_misana"] * 1.92) + ($sabutathyasreni["ojana_O_misana"] * 1.92);
$aathe = ($sabutathyasreni["ojana_8_misana"] * 9.88) + ($sabutathyasreni["ojana_L_misana"] * 1.92) + ($sabutathyasreni["ojana_E_misana"] * 1.92);
$nah = ($sabutathyasreni["ojana_9_misana"] * 8.3) + ($sabutathyasreni["ojana_L_misana"] * 1.92) + ($sabutathyasreni["ojana_O_misana"] * 1.92);
$dasa = ($sabutathyasreni["ojana_10_misana"] * 7.68) + ($sabutathyasreni["ojana_L_misana"] * 1.92) + ($sabutathyasreni["ojana_E_misana"] * 1.92);
$egara = ($sabutathyasreni["ojana_11_misana"] * 7.68) + ($sabutathyasreni["ojana_H_misana"] * 1.92) + ($sabutathyasreni["ojana_O_misana"] * 1.92);
$bara = ($sabutathyasreni["ojana_12_misana"] * 8.3) + ($sabutathyasreni["ojana_H_misana"] * 1.92) + ($sabutathyasreni["ojana_E_misana"] * 1.92);
$teyra = ($sabutathyasreni["ojana_13_misana"] * 9.88) + ($sabutathyasreni["ojana_H_misana"] * 1.92) + ($sabutathyasreni["ojana_O_misana"] * 1.92);
$chouda = ($sabutathyasreni["ojana_14_misana"] * 13.83) + ($sabutathyasreni["ojana_H_misana"] * 1.92) + ($sabutathyasreni["ojana_E_misana"] * 1.92);
$pandara = ($sabutathyasreni["ojana_15_misana"] * 20.74) + ($sabutathyasreni["ojana_H_misana"] * 1.92) + ($sabutathyasreni["ojana_O_misana"] * 1.92);
$sohala = ($sabutathyasreni["ojana_16_misana"] * 34.56) + ($sabutathyasreni["ojana_H_misana"] * 1.92) + ($sabutathyasreni["ojana_E_misana"] * 1.92);
$satara = ($sabutathyasreni["ojana_17_misana"] * 69.12) + ($sabutathyasreni["ojana_H_misana"] * 1.92) + ($sabutathyasreni["ojana_O_misana"] * 1.92);
$athara = ($sabutathyasreni["ojana_18_misana"] * 207.36) + ($sabutathyasreni["ojana_H_misana"] * 1.92) + ($sabutathyasreni["ojana_E_misana"] * 1.92);
$totalarr = array($tini, $chari, $panche, $chha, $saate, $aathe, $nah, $dasa, $egara, $bara, $teyra, $chouda, $pandara, $sohala, $satara, $athara);
$mintot = min($totalarr);
$thatnumber = array_search($mintot, $totalarr);
$realnumber = $thatnumber + 3;
function sort_with_positions($arr) {
$original_with_index = [];
foreach ($arr as $index => $value) {
$original_with_index[] = ['value' => $value, 'index' => $index];
}
usort($original_with_index, function($a, $b) {
return $a['value'] <=> $b['value'];
});
$sorted_values = [];
$positions = [];
foreach ($original_with_index as $element) {
$sorted_values[] = $element['value'];
$positions[] = $element['index'];
}
return [$sorted_values, $positions];
}
[$sorted_arr, $positions] = sort_with_positions($totalarr);
$pluspositions = array_map(function($value) {
return $value + 3;
}, $positions);
$sabualaga = ($sabutathyasreni['prakar_9_misana'] * 34.56) + ($sabutathyasreni['prakar_10_misana'] * 8.64) + ($sabutathyasreni['prakar_4_misana'] * 6.91);
$sabusaman = ($sabutathyasreni['prakar_7_misana'] * 207.36) + ($sabutathyasreni['prakar_8_misana'] * 34.56) + ($sabutathyasreni['prakar_6_misana'] * 13.83);
$ditasaman = $sabutathyasreni['prakar_5_misana'] * 69.12;
$sabujaka = array($sabualaga, $sabusaman, $ditasaman);
$sabuthukaam = min($sabujaka);
$kouta = array_search($sabuthukaam, $sabujaka);
if($sabualaga == 0 && $sabusaman == 0 && $ditasaman == 0){
$kouta = 3;
}
if($kouta == 0){
$sqlstr = "SELECT num
FROM (
SELECT '1' AS num
UNION ALL
SELECT '2'
UNION ALL
SELECT '3'
UNION ALL
SELECT '4'
UNION ALL
SELECT '5'
UNION ALL
SELECT '6'
) AS numbers
WHERE num NOT IN (
SELECT '1' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%1%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '2' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%2%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '3' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%3%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '4' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%4%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '5' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%5%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '6' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%6%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
)";
$sqlstrans = $conn->query($sqlstr);
$sqlstrnum = mysqli_num_rows($sqlstrans);
if($sqlstrnum == 0){
$difstr = "
WITH sums AS (
SELECT
SUM(CASE WHEN ojana LIKE '%1%' THEN ketebida ELSE 0 END) AS sum_1,
SUM(CASE WHEN ojana LIKE '%2%' THEN ketebida ELSE 0 END) AS sum_2,
SUM(CASE WHEN ojana LIKE '%3%' THEN ketebida ELSE 0 END) AS sum_3,
SUM(CASE WHEN ojana LIKE '%4%' THEN ketebida ELSE 0 END) AS sum_4,
SUM(CASE WHEN ojana LIKE '%5%' THEN ketebida ELSE 0 END) AS sum_5,
SUM(CASE WHEN ojana LIKE '%6%' THEN ketebida ELSE 0 END) AS sum_6
FROM
bajikattuttate_kemuru_drei
WHERE
(prakar = '9' OR prakar = '10' OR prakar = '4')
AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi']."
), min_sums AS (
SELECT '1' AS number, sum_1 AS ketebida_sum FROM sums
UNION ALL
SELECT '2' AS number, sum_2 AS ketebida_sum FROM sums
UNION ALL
SELECT '3' AS number, sum_3 AS ketebida_sum FROM sums
UNION ALL
SELECT '4' AS number, sum_4 AS ketebida_sum FROM sums
UNION ALL
SELECT '5' AS number, sum_5 AS ketebida_sum FROM sums
UNION ALL
SELECT '6' AS number, sum_6 AS ketebida_sum FROM sums
), minimum AS (
SELECT
MIN(ketebida_sum) AS minimum_ketebida
FROM
min_sums
)
SELECT
number,
ketebida_sum
FROM
min_sums
WHERE
ketebida_sum = (SELECT minimum_ketebida FROM minimum)
ORDER BY
RAND()
LIMIT 1
";
$difstrans = $conn->query($difstr);
$firstnumarr = mysqli_fetch_array($difstrans);
$firstnum = $firstnumarr['number'];
}
else{
$dif = array();
while($row = mysqli_fetch_array($sqlstrans)){
$dif[] = $row['num'];
}
$key = array_rand($dif,1);
$firstnum = $dif[$key];
}
function generateUniqueDigitNumber($digit, $targetSums) {
$digits = range(1, 6);
$digits = array_diff($digits, [$digit]);
$combinations = [];
foreach ($digits as $i) {
foreach ($digits as $j) {
if ($i != $j) {
$combinations[] = [$digit, $i, $j];
}
}
}
foreach ($targetSums as $sum) {
foreach ($combinations as $combination) {
if (array_sum($combination) == $sum) {
//sort($combination);
//shuffle($combination);
$partA = array_slice($combination,0,1);
$partB = array_slice($combination,1,sizeof($combination));
shuffle($partB);
return implode('', array_merge($partA, $partB));
}
}
}
return null;
}
$result = generateUniqueDigitNumber($firstnum, $pluspositions);
//echo $result;
}
if($kouta == 1){
$sqlstr = "SELECT num
FROM (
SELECT '1' AS num
UNION ALL
SELECT '2'
UNION ALL
SELECT '3'
UNION ALL
SELECT '4'
UNION ALL
SELECT '5'
UNION ALL
SELECT '6'
) AS numbers
WHERE num NOT IN (
SELECT '1' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%1%' AND (prakar = '7' OR prakar = '8' OR prakar = '6') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '2' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%2%' AND (prakar = '7' OR prakar = '8' OR prakar = '6') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '3' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%3%' AND (prakar = '7' OR prakar = '8' OR prakar = '6') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '4' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%4%' AND (prakar = '7' OR prakar = '8' OR prakar = '6') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '5' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%5%' AND (prakar = '7' OR prakar = '8' OR prakar = '6') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '6' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%6%' AND (prakar = '7' OR prakar = '8' OR prakar = '6') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
)";
$sqlstrans = $conn->query($sqlstr);
$sqlstrnum = mysqli_num_rows($sqlstrans);
if($sqlstrnum == 0){
$difstr = "
WITH sums AS (
SELECT
SUM(CASE WHEN ojana LIKE '%1%' THEN ketebida ELSE 0 END) AS sum_1,
SUM(CASE WHEN ojana LIKE '%2%' THEN ketebida ELSE 0 END) AS sum_2,
SUM(CASE WHEN ojana LIKE '%3%' THEN ketebida ELSE 0 END) AS sum_3,
SUM(CASE WHEN ojana LIKE '%4%' THEN ketebida ELSE 0 END) AS sum_4,
SUM(CASE WHEN ojana LIKE '%5%' THEN ketebida ELSE 0 END) AS sum_5,
SUM(CASE WHEN ojana LIKE '%6%' THEN ketebida ELSE 0 END) AS sum_6
FROM
bajikattuttate_kemuru_drei
WHERE
(prakar = '7' OR prakar = '8' OR prakar = '6')
AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi']."
), min_sums AS (
SELECT '1' AS number, sum_1 AS ketebida_sum FROM sums
UNION ALL
SELECT '2' AS number, sum_2 AS ketebida_sum FROM sums
UNION ALL
SELECT '3' AS number, sum_3 AS ketebida_sum FROM sums
UNION ALL
SELECT '4' AS number, sum_4 AS ketebida_sum FROM sums
UNION ALL
SELECT '5' AS number, sum_5 AS ketebida_sum FROM sums
UNION ALL
SELECT '6' AS number, sum_6 AS ketebida_sum FROM sums
), minimum AS (
SELECT
MIN(ketebida_sum) AS minimum_ketebida
FROM
min_sums
)
SELECT
number,
ketebida_sum
FROM
min_sums
WHERE
ketebida_sum = (SELECT minimum_ketebida FROM minimum)
ORDER BY
RAND()
LIMIT 1
";
$difstrans = $conn->query($difstr);
$firstnumarr = mysqli_fetch_array($difstrans);
$firstnum = $firstnumarr['number'];
}
else{
$dif = array();
while($row = mysqli_fetch_array($sqlstrans)){
$dif[] = $row['num'];
}
$key = array_rand($dif,1);
$firstnum = $dif[$key];
}
function find_third_digit($number, $targetSums) {
$digits = str_split($number);
$sumOfTwoDigits = array_sum($digits);
foreach ($targetSums as $targetSum) {
for ($thirdDigit = 1; $thirdDigit <= 6; $thirdDigit++) {
if ($sumOfTwoDigits + $thirdDigit == $targetSum) {
return $number . $thirdDigit;
}
}
}
return null;
}
$number = $firstnum.$firstnum;
$result = find_third_digit($number, $pluspositions);
//echo $result;
}
if($kouta == 2){
$sqlstr = "SELECT num
FROM (
SELECT '1' AS num
UNION ALL
SELECT '2'
UNION ALL
SELECT '3'
UNION ALL
SELECT '4'
UNION ALL
SELECT '5'
UNION ALL
SELECT '6'
) AS numbers
WHERE num NOT IN (
SELECT '1' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%1%' AND prakar = '5' AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '2' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%2%' AND prakar = '5' AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '3' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%3%' AND prakar = '5' AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '4' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%4%' AND prakar = '5' AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '5' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%5%' AND prakar = '5' AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '6' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%6%' AND prakar = '5' AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
)";
$sqlstrans = $conn->query($sqlstr);
$sqlstrnum = mysqli_num_rows($sqlstrans);
if($sqlstrnum == 0){
$difstr = "
WITH sums AS (
SELECT
SUM(CASE WHEN ojana LIKE '%1%' THEN ketebida ELSE 0 END) AS sum_1,
SUM(CASE WHEN ojana LIKE '%2%' THEN ketebida ELSE 0 END) AS sum_2,
SUM(CASE WHEN ojana LIKE '%3%' THEN ketebida ELSE 0 END) AS sum_3,
SUM(CASE WHEN ojana LIKE '%4%' THEN ketebida ELSE 0 END) AS sum_4,
SUM(CASE WHEN ojana LIKE '%5%' THEN ketebida ELSE 0 END) AS sum_5,
SUM(CASE WHEN ojana LIKE '%6%' THEN ketebida ELSE 0 END) AS sum_6
FROM
bajikattuttate_kemuru_drei
WHERE
prakar = '5'
AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi']."
), min_sums AS (
SELECT '1' AS number, sum_1 AS ketebida_sum FROM sums
UNION ALL
SELECT '2' AS number, sum_2 AS ketebida_sum FROM sums
UNION ALL
SELECT '3' AS number, sum_3 AS ketebida_sum FROM sums
UNION ALL
SELECT '4' AS number, sum_4 AS ketebida_sum FROM sums
UNION ALL
SELECT '5' AS number, sum_5 AS ketebida_sum FROM sums
UNION ALL
SELECT '6' AS number, sum_6 AS ketebida_sum FROM sums
), minimum AS (
SELECT
MIN(ketebida_sum) AS minimum_ketebida
FROM
min_sums
)
SELECT
number,
ketebida_sum
FROM
min_sums
WHERE
ketebida_sum = (SELECT minimum_ketebida FROM minimum)
ORDER BY
RAND()
LIMIT 1
";
$difstrans = $conn->query($difstr);
$firstnumarr = mysqli_fetch_array($difstrans);
$firstnum = $firstnumarr['number'];
}
else{
$dif = array();
while($row = mysqli_fetch_array($sqlstrans)){
$dif[] = $row['num'];
}
$key = array_rand($dif,1);
$firstnum = $dif[$key];
}
function generateNumber($firstDigit, $sums) {
foreach ($sums as $requiredSum) {
for ($middleDigit = 1; $middleDigit <= 6; $middleDigit++) {
if ($middleDigit == $firstDigit) {
continue;
}
$sum = $firstDigit + $middleDigit + $firstDigit;
if ($sum == $requiredSum) {
return $firstDigit . $middleDigit . $firstDigit;
}
}
}
return null;
}
$result = generateNumber($firstnum, $pluspositions);
//echo $result;
}
if($kouta == 3){
$totalsum = $realnumber;
function findThreeDigitNumbers($targetSum) {
if ($targetSum < 3 || $targetSum > 18) {
throw new InvalidArgumentException("Input must be a number between 3 and 18.");
}
$results = [];
for ($hundred = 1; $hundred <= 6; $hundred++) {
for ($ten = 1; $ten <= 6; $ten++) {
for ($unit = 1; $unit <= 6; $unit++) {
$number = $hundred * 100 + $ten * 10 + $unit;
if ($hundred >= 1 && $hundred <= 6 &&
$ten >= 1 && $ten <= 6 &&
$unit >= 1 && $unit <= 6 &&
$hundred + $ten + $unit === $targetSum) {
$results[] = [$hundred, $ten, $unit];
}
}
}
}
return $results;
}
$numsarr = findThreeDigitNumbers($totalsum);
$key = array_rand($numsarr ,1);
$finalnumarr = $numsarr[$key];
$result = $finalnumarr[0].$finalnumarr[1].$finalnumarr[2];
}
//$result = '666';
$pachare = mysqli_query($conn,"SELECT sankhye FROM `hastacalita_phalitansa_kemeru_drei` WHERE sthiti = '1' LIMIT 1");
$achiki = mysqli_num_rows($pachare);
if($achiki == 1){
$thaka = mysqli_fetch_array($pachare);
$kadimesucyanka = $thaka['sankhye'];
$result = $kadimesucyanka;
}
function checkNumberProperties($number) {
$digits = str_split((string) $number);
$output['isAllDifferent'] = (count(array_unique($digits)) === 3);
$output['isConsecutive'] = ($digits[0] + 1 == $digits[1] && $digits[1] + 1 == $digits[2]);
$output['isAllSame'] = ($digits[0] === $digits[1] && $digits[1] === $digits[2]);
$output['isFirstTwoSame'] = ($digits[0] === $digits[1]);
$output['isFirstLastSame'] = ($digits[0] === $digits[2]);
$sum = array_sum($digits);
$output['sum'] = $sum;
$output['isEven'] = ($sum % 2 === 0);
$output['digits'] = $digits;
return $output;
}
$res_arr = checkNumberProperties($result);
$dinanka = date('Y-m-d H:i:s');
$tathya = mysqli_query($conn,"INSERT INTO `gellaluhogiondu_kemeru_phalitansa_drei` (`kalaparichaya`,`bele`,`phalitansa`,`phalitansadaprakara`,`dinankavannuracisi`) VALUES ('".$samasyesreni['atadaaidi']."','".$result."','".$res_arr['sum']."','uncensored','".$dinanka."')");
if($res_arr['isAllDifferent']){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 34.56, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '9') > 0
AND INSTR(ojana, '".$res_arr['digits'][0]."') > 0
AND INSTR(ojana, '".$res_arr['digits'][1]."') = INSTR(ojana, '".$res_arr['digits'][0]."') + 4
AND INSTR(ojana, '".$res_arr['digits'][2]."') = INSTR(ojana, '".$res_arr['digits'][1]."') + 4
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '9') > 0
AND INSTR(ojana, '".$res_arr['digits'][0]."') > 0
AND INSTR(ojana, '".$res_arr['digits'][1]."') = INSTR(ojana, '".$res_arr['digits'][0]."') + 4
AND INSTR(ojana, '".$res_arr['digits'][2]."') = INSTR(ojana, '".$res_arr['digits'][1]."') + 4
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 6.91, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '4') > 0
AND INSTR(ojana, '".$res_arr['digits'][0]."') > 0
AND INSTR(ojana, '".$res_arr['digits'][1]."') = INSTR(ojana, '".$res_arr['digits'][0]."') + 4
AND INSTR(ojana, '".$res_arr['digits'][2]."') != INSTR(ojana, '".$res_arr['digits'][1]."') + 4
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '4') > 0
AND INSTR(ojana, '".$res_arr['digits'][0]."') > 0
AND INSTR(ojana, '".$res_arr['digits'][1]."') = INSTR(ojana, '".$res_arr['digits'][0]."') + 4
AND INSTR(ojana, '".$res_arr['digits'][2]."') != INSTR(ojana, '".$res_arr['digits'][1]."') + 4
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['isConsecutive']){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(sesabida * 8.64, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '10') > 0";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '10') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['isAllSame']){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(sesabida * 34.56, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '8') > 0";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '8') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 207.36, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '7') > 0
AND INSTR(ojana, '".$result."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '7') > 0
AND INSTR(ojana, '".$result."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['isFirstTwoSame']){
//echo 111."<br>";
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 13.83, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '6') > 0
AND INSTR(ojana, '".$res_arr['digits'][0].$res_arr['digits'][1]."') > 0
";
//echo $nabikarana;
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '6') > 0
AND INSTR(ojana, '".$res_arr['digits'][0].$res_arr['digits'][1]."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['isFirstLastSame']){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 69.12, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '5') > 0
AND INSTR(ojana, '".$res_arr['digits'][0].$res_arr['digits'][2]."') > 0
AND INSTR(ojana, '".$res_arr['digits'][1]."') != INSTR(ojana, '".$res_arr['digits'][0]."') + 1
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '6') > 0
AND INSTR(ojana, '".$res_arr['digits'][0].$res_arr['digits'][2]."') > 0
AND INSTR(ojana, '".$res_arr['digits'][1]."') != INSTR(ojana, '".$res_arr['digits'][0]."') + 1
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
if($res_arr['sum'] == 3){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 207.36, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 4){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 69.12, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 5){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 34.56, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 6){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 20.74, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 7){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 13.83, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 8){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 9.88, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 9){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 8.3, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 10){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 7.68, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 11){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 7.68, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 12){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 8.3, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 13){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 9.88, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 14){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 13.83, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 15){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 20.74, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 16){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 34.56, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 17){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 69.12, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 18){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 207.36, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
$nabikarana_dui = "UPDATE bajikattuttate_kemuru_drei set ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."'";
$conn->query($nabikarana_dui);
}
else{
$yadrcchika_1 = rand(1, 6);
$yadrcchika_2 = rand(1, 6);
$yadrcchika_3 = rand(1, 6);
$yadrcchika = $yadrcchika_1.$yadrcchika_2.$yadrcchika_3;
$yadrcchika_misana = $yadrcchika_1+$yadrcchika_2+$yadrcchika_3;
$dinanka = date('Y-m-d H:i:s');
$tathya = mysqli_query($conn,"INSERT INTO `gellaluhogiondu_kemeru_phalitansa_drei` (`kalaparichaya`,`bele`,`phalitansa`,`phalitansadaprakara`,`dinankavannuracisi`) VALUES ('".$samasyesreni['atadaaidi']."','".$yadrcchika."','".$yadrcchika_misana."','shonu','".$dinanka."')");
}
}//include("serive/samparka.php"); //Remove IT
$samasye = "SELECT atadaaidi
FROM gelluonduhogu_kemuru_drei
ORDER BY kramasankhye DESC LIMIT 1";//Add Kemuru
$samasyephalitansa = $conn->query($samasye);
$samasyesreni = mysqli_fetch_array($samasyephalitansa);
//$samasyesreni['atadaaidi'] = 20240624010862;
if(isset($samasyesreni['atadaaidi'])){
$gadhipathuli = "SELECT ojana, ketebida
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = ".$samasyesreni['atadaaidi']."
ORDER BY parichaya DESC LIMIT 1";
$gadhipathuliphala = $conn->query($gadhipathuli);
$gadhipathulidhadi = mysqli_num_rows($gadhipathuliphala);
if($gadhipathulidhadi >= 1){
$sabutathya = "SELECT\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '3') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_3_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '4') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_4_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '5') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_5_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '6') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_6_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '7') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_7_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '8') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_8_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '9') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_9_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '10') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_10_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '11') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_11_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '12') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_12_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '13') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_13_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '14') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_14_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '15') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_15_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '16') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_16_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '17') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_17_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '18') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_18_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, 'H') AND INSTR(prakar, '2') THEN ketebida ELSE 0 END) AS ojana_H_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, 'L') AND INSTR(prakar, '2') THEN ketebida ELSE 0 END) AS ojana_L_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, 'O') AND INSTR(prakar, '3') THEN ketebida ELSE 0 END) AS ojana_O_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, 'E') AND INSTR(prakar, '3') THEN ketebida ELSE 0 END) AS ojana_E_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 9 THEN ketebida ELSE 0 END) AS prakar_9_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 10 THEN ketebida ELSE 0 END) AS prakar_10_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 4 THEN ketebida ELSE 0 END) AS prakar_4_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 7 THEN ketebida ELSE 0 END) AS prakar_7_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 8 THEN ketebida ELSE 0 END) AS prakar_8_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 6 THEN ketebida ELSE 0 END) AS prakar_6_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 5 THEN ketebida ELSE 0 END) AS prakar_5_misana\xd\xa\x9\x9\x9ROM bajikattuttate_kemuru_drei WHERE byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'];
$sabutathyaphala = $conn->query($sabutathya);
$sabutathyasreni = mysqli_fetch_array($sabutathyaphala);
$tini = ($sabutathyasreni["ojana_3_misana"] * 207.36) + ($sabutathyasreni["ojana_L_misana"] * 1.92) + ($sabutathyasreni["ojana_O_misana"] * 1.92);
$chari = ($sabutathyasreni["ojana_4_misana"] * 69.12) + ($sabutathyasreni["ojana_L_misana"] * 1.92) + ($sabutathyasreni["ojana_E_misana"] * 1.92);
$panche = ($sabutathyasreni["ojana_5_misana"] * 34.56) + ($sabutathyasreni["ojana_L_misana"] * 1.92) + ($sabutathyasreni["ojana_O_misana"] * 1.92);
$chha = ($sabutathyasreni["ojana_6_misana"] * 20.74) + ($sabutathyasreni["ojana_L_misana"] * 1.92) + ($sabutathyasreni["ojana_E_misana"] * 1.92);
$saate = ($sabutathyasreni["ojana_7_misana"] * 13.83) + ($sabutathyasreni["ojana_L_misana"] * 1.92) + ($sabutathyasreni["ojana_O_misana"] * 1.92);
$aathe = ($sabutathyasreni["ojana_8_misana"] * 9.88) + ($sabutathyasreni["ojana_L_misana"] * 1.92) + ($sabutathyasreni["ojana_E_misana"] * 1.92);
$nah = ($sabutathyasreni["ojana_9_misana"] * 8.3) + ($sabutathyasreni["ojana_L_misana"] * 1.92) + ($sabutathyasreni["ojana_O_misana"] * 1.92);
$dasa = ($sabutathyasreni["ojana_10_misana"] * 7.68) + ($sabutathyasreni["ojana_L_misana"] * 1.92) + ($sabutathyasreni["ojana_E_misana"] * 1.92);
$egara = ($sabutathyasreni["ojana_11_misana"] * 7.68) + ($sabutathyasreni["ojana_H_misana"] * 1.92) + ($sabutathyasreni["ojana_O_misana"] * 1.92);
$bara = ($sabutathyasreni["ojana_12_misana"] * 8.3) + ($sabutathyasreni["ojana_H_misana"] * 1.92) + ($sabutathyasreni["ojana_E_misana"] * 1.92);
$teyra = ($sabutathyasreni["ojana_13_misana"] * 9.88) + ($sabutathyasreni["ojana_H_misana"] * 1.92) + ($sabutathyasreni["ojana_O_misana"] * 1.92);
$chouda = ($sabutathyasreni["ojana_14_misana"] * 13.83) + ($sabutathyasreni["ojana_H_misana"] * 1.92) + ($sabutathyasreni["ojana_E_misana"] * 1.92);
$pandara = ($sabutathyasreni["ojana_15_misana"] * 20.74) + ($sabutathyasreni["ojana_H_misana"] * 1.92) + ($sabutathyasreni["ojana_O_misana"] * 1.92);
$sohala = ($sabutathyasreni["ojana_16_misana"] * 34.56) + ($sabutathyasreni["ojana_H_misana"] * 1.92) + ($sabutathyasreni["ojana_E_misana"] * 1.92);
$satara = ($sabutathyasreni["ojana_17_misana"] * 69.12) + ($sabutathyasreni["ojana_H_misana"] * 1.92) + ($sabutathyasreni["ojana_O_misana"] * 1.92);
$athara = ($sabutathyasreni["ojana_18_misana"] * 207.36) + ($sabutathyasreni["ojana_H_misana"] * 1.92) + ($sabutathyasreni["ojana_E_misana"] * 1.92);
$totalarr = array($tini, $chari, $panche, $chha, $saate, $aathe, $nah, $dasa, $egara, $bara, $teyra, $chouda, $pandara, $sohala, $satara, $athara);
$mintot = min($totalarr);
$thatnumber = array_search($mintot, $totalarr);
$realnumber = $thatnumber + 3;
function sort_with_positions($arr) {
$original_with_index = [];
foreach ($arr as $index => $value) {
$original_with_index[] = ['value' => $value, 'index' => $index];
}
usort($original_with_index, function($a, $b) {
return $a['value'] <=> $b['value'];
});
$sorted_values = [];
$positions = [];
foreach ($original_with_index as $element) {
$sorted_values[] = $element['value'];
$positions[] = $element['index'];
}
return [$sorted_values, $positions];
}
[$sorted_arr, $positions] = sort_with_positions($totalarr);
$pluspositions = array_map(function($value) {
return $value + 3;
}, $positions);
$sabualaga = ($sabutathyasreni['prakar_9_misana'] * 34.56) + ($sabutathyasreni['prakar_10_misana'] * 8.64) + ($sabutathyasreni['prakar_4_misana'] * 6.91);
$sabusaman = ($sabutathyasreni['prakar_7_misana'] * 207.36) + ($sabutathyasreni['prakar_8_misana'] * 34.56) + ($sabutathyasreni['prakar_6_misana'] * 13.83);
$ditasaman = $sabutathyasreni['prakar_5_misana'] * 69.12;
$sabujaka = array($sabualaga, $sabusaman, $ditasaman);
$sabuthukaam = min($sabujaka);
$kouta = array_search($sabuthukaam, $sabujaka);
if($sabualaga == 0 && $sabusaman == 0 && $ditasaman == 0){
$kouta = 3;
}
if($kouta == 0){
$sqlstr = "SELECT num
FROM (
SELECT '1' AS num
UNION ALL
SELECT '2'
UNION ALL
SELECT '3'
UNION ALL
SELECT '4'
UNION ALL
SELECT '5'
UNION ALL
SELECT '6'
) AS numbers
WHERE num NOT IN (
SELECT '1' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%1%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '2' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%2%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '3' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%3%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '4' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%4%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '5' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%5%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '6' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%6%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
)";
$sqlstrans = $conn->query($sqlstr);
$sqlstrnum = mysqli_num_rows($sqlstrans);
if($sqlstrnum == 0){
$difstr = "
WITH sums AS (
SELECT
SUM(CASE WHEN ojana LIKE '%1%' THEN ketebida ELSE 0 END) AS sum_1,
SUM(CASE WHEN ojana LIKE '%2%' THEN ketebida ELSE 0 END) AS sum_2,
SUM(CASE WHEN ojana LIKE '%3%' THEN ketebida ELSE 0 END) AS sum_3,
SUM(CASE WHEN ojana LIKE '%4%' THEN ketebida ELSE 0 END) AS sum_4,
SUM(CASE WHEN ojana LIKE '%5%' THEN ketebida ELSE 0 END) AS sum_5,
SUM(CASE WHEN ojana LIKE '%6%' THEN ketebida ELSE 0 END) AS sum_6
FROM
bajikattuttate_kemuru_drei
WHERE
(prakar = '9' OR prakar = '10' OR prakar = '4')
AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi']."
), min_sums AS (
SELECT '1' AS number, sum_1 AS ketebida_sum FROM sums
UNION ALL
SELECT '2' AS number, sum_2 AS ketebida_sum FROM sums
UNION ALL
SELECT '3' AS number, sum_3 AS ketebida_sum FROM sums
UNION ALL
SELECT '4' AS number, sum_4 AS ketebida_sum FROM sums
UNION ALL
SELECT '5' AS number, sum_5 AS ketebida_sum FROM sums
UNION ALL
SELECT '6' AS number, sum_6 AS ketebida_sum FROM sums
), minimum AS (
SELECT
MIN(ketebida_sum) AS minimum_ketebida
FROM
min_sums
)
SELECT
number,
ketebida_sum
FROM
min_sums
WHERE
ketebida_sum = (SELECT minimum_ketebida FROM minimum)
ORDER BY
RAND()
LIMIT 1
";
$difstrans = $conn->query($difstr);
$firstnumarr = mysqli_fetch_array($difstrans);
$firstnum = $firstnumarr['number'];
}
else{
$dif = array();
while($row = mysqli_fetch_array($sqlstrans)){
$dif[] = $row['num'];
}
$key = array_rand($dif,1);
$firstnum = $dif[$key];
}
function generateUniqueDigitNumber($digit, $targetSums) {
$digits = range(1, 6);
$digits = array_diff($digits, [$digit]);
$combinations = [];
foreach ($digits as $i) {
foreach ($digits as $j) {
if ($i != $j) {
$combinations[] = [$digit, $i, $j];
}
}
}
foreach ($targetSums as $sum) {
foreach ($combinations as $combination) {
if (array_sum($combination) == $sum) {
//sort($combination);
//shuffle($combination);
$partA = array_slice($combination,0,1);
$partB = array_slice($combination,1,sizeof($combination));
shuffle($partB);
return implode('', array_merge($partA, $partB));
}
}
}
return null;
}
$result = generateUniqueDigitNumber($firstnum, $pluspositions);
//echo $result;
}
if($kouta == 1){
$sqlstr = "SELECT num
FROM (
SELECT '1' AS num
UNION ALL
SELECT '2'
UNION ALL
SELECT '3'
UNION ALL
SELECT '4'
UNION ALL
SELECT '5'
UNION ALL
SELECT '6'
) AS numbers
WHERE num NOT IN (
SELECT '1' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%1%' AND (prakar = '7' OR prakar = '8' OR prakar = '6') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '2' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%2%' AND (prakar = '7' OR prakar = '8' OR prakar = '6') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '3' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%3%' AND (prakar = '7' OR prakar = '8' OR prakar = '6') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '4' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%4%' AND (prakar = '7' OR prakar = '8' OR prakar = '6') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '5' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%5%' AND (prakar = '7' OR prakar = '8' OR prakar = '6') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '6' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%6%' AND (prakar = '7' OR prakar = '8' OR prakar = '6') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
)";
$sqlstrans = $conn->query($sqlstr);
$sqlstrnum = mysqli_num_rows($sqlstrans);
if($sqlstrnum == 0){
$difstr = "
WITH sums AS (
SELECT
SUM(CASE WHEN ojana LIKE '%1%' THEN ketebida ELSE 0 END) AS sum_1,
SUM(CASE WHEN ojana LIKE '%2%' THEN ketebida ELSE 0 END) AS sum_2,
SUM(CASE WHEN ojana LIKE '%3%' THEN ketebida ELSE 0 END) AS sum_3,
SUM(CASE WHEN ojana LIKE '%4%' THEN ketebida ELSE 0 END) AS sum_4,
SUM(CASE WHEN ojana LIKE '%5%' THEN ketebida ELSE 0 END) AS sum_5,
SUM(CASE WHEN ojana LIKE '%6%' THEN ketebida ELSE 0 END) AS sum_6
FROM
bajikattuttate_kemuru_drei
WHERE
(prakar = '7' OR prakar = '8' OR prakar = '6')
AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi']."
), min_sums AS (
SELECT '1' AS number, sum_1 AS ketebida_sum FROM sums
UNION ALL
SELECT '2' AS number, sum_2 AS ketebida_sum FROM sums
UNION ALL
SELECT '3' AS number, sum_3 AS ketebida_sum FROM sums
UNION ALL
SELECT '4' AS number, sum_4 AS ketebida_sum FROM sums
UNION ALL
SELECT '5' AS number, sum_5 AS ketebida_sum FROM sums
UNION ALL
SELECT '6' AS number, sum_6 AS ketebida_sum FROM sums
), minimum AS (
SELECT
MIN(ketebida_sum) AS minimum_ketebida
FROM
min_sums
)
SELECT
number,
ketebida_sum
FROM
min_sums
WHERE
ketebida_sum = (SELECT minimum_ketebida FROM minimum)
ORDER BY
RAND()
LIMIT 1
";
$difstrans = $conn->query($difstr);
$firstnumarr = mysqli_fetch_array($difstrans);
$firstnum = $firstnumarr['number'];
}
else{
$dif = array();
while($row = mysqli_fetch_array($sqlstrans)){
$dif[] = $row['num'];
}
$key = array_rand($dif,1);
$firstnum = $dif[$key];
}
function find_third_digit($number, $targetSums) {
$digits = str_split($number);
$sumOfTwoDigits = array_sum($digits);
foreach ($targetSums as $targetSum) {
for ($thirdDigit = 1; $thirdDigit <= 6; $thirdDigit++) {
if ($sumOfTwoDigits + $thirdDigit == $targetSum) {
return $number . $thirdDigit;
}
}
}
return null;
}
$number = $firstnum.$firstnum;
$result = find_third_digit($number, $pluspositions);
//echo $result;
}
if($kouta == 2){
$sqlstr = "SELECT num
FROM (
SELECT '1' AS num
UNION ALL
SELECT '2'
UNION ALL
SELECT '3'
UNION ALL
SELECT '4'
UNION ALL
SELECT '5'
UNION ALL
SELECT '6'
) AS numbers
WHERE num NOT IN (
SELECT '1' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%1%' AND prakar = '5' AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '2' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%2%' AND prakar = '5' AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '3' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%3%' AND prakar = '5' AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '4' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%4%' AND prakar = '5' AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '5' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%5%' AND prakar = '5' AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '6' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%6%' AND prakar = '5' AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
)";
$sqlstrans = $conn->query($sqlstr);
$sqlstrnum = mysqli_num_rows($sqlstrans);
if($sqlstrnum == 0){
$difstr = "
WITH sums AS (
SELECT
SUM(CASE WHEN ojana LIKE '%1%' THEN ketebida ELSE 0 END) AS sum_1,
SUM(CASE WHEN ojana LIKE '%2%' THEN ketebida ELSE 0 END) AS sum_2,
SUM(CASE WHEN ojana LIKE '%3%' THEN ketebida ELSE 0 END) AS sum_3,
SUM(CASE WHEN ojana LIKE '%4%' THEN ketebida ELSE 0 END) AS sum_4,
SUM(CASE WHEN ojana LIKE '%5%' THEN ketebida ELSE 0 END) AS sum_5,
SUM(CASE WHEN ojana LIKE '%6%' THEN ketebida ELSE 0 END) AS sum_6
FROM
bajikattuttate_kemuru_drei
WHERE
prakar = '5'
AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi']."
), min_sums AS (
SELECT '1' AS number, sum_1 AS ketebida_sum FROM sums
UNION ALL
SELECT '2' AS number, sum_2 AS ketebida_sum FROM sums
UNION ALL
SELECT '3' AS number, sum_3 AS ketebida_sum FROM sums
UNION ALL
SELECT '4' AS number, sum_4 AS ketebida_sum FROM sums
UNION ALL
SELECT '5' AS number, sum_5 AS ketebida_sum FROM sums
UNION ALL
SELECT '6' AS number, sum_6 AS ketebida_sum FROM sums
), minimum AS (
SELECT
MIN(ketebida_sum) AS minimum_ketebida
FROM
min_sums
)
SELECT
number,
ketebida_sum
FROM
min_sums
WHERE
ketebida_sum = (SELECT minimum_ketebida FROM minimum)
ORDER BY
RAND()
LIMIT 1
";
$difstrans = $conn->query($difstr);
$firstnumarr = mysqli_fetch_array($difstrans);
$firstnum = $firstnumarr['number'];
}
else{
$dif = array();
while($row = mysqli_fetch_array($sqlstrans)){
$dif[] = $row['num'];
}
$key = array_rand($dif,1);
$firstnum = $dif[$key];
}
function generateNumber($firstDigit, $sums) {
foreach ($sums as $requiredSum) {
for ($middleDigit = 1; $middleDigit <= 6; $middleDigit++) {
if ($middleDigit == $firstDigit) {
continue;
}
$sum = $firstDigit + $middleDigit + $firstDigit;
if ($sum == $requiredSum) {
return $firstDigit . $middleDigit . $firstDigit;
}
}
}
return null;
}
$result = generateNumber($firstnum, $pluspositions);
//echo $result;
}
if($kouta == 3){
$totalsum = $realnumber;
function findThreeDigitNumbers($targetSum) {
if ($targetSum < 3 || $targetSum > 18) {
throw new InvalidArgumentException("Input must be a number between 3 and 18.");
}
$results = [];
for ($hundred = 1; $hundred <= 6; $hundred++) {
for ($ten = 1; $ten <= 6; $ten++) {
for ($unit = 1; $unit <= 6; $unit++) {
$number = $hundred * 100 + $ten * 10 + $unit;
if ($hundred >= 1 && $hundred <= 6 &&
$ten >= 1 && $ten <= 6 &&
$unit >= 1 && $unit <= 6 &&
$hundred + $ten + $unit === $targetSum) {
$results[] = [$hundred, $ten, $unit];
}
}
}
}
return $results;
}
$numsarr = findThreeDigitNumbers($totalsum);
$key = array_rand($numsarr ,1);
$finalnumarr = $numsarr[$key];
$result = $finalnumarr[0].$finalnumarr[1].$finalnumarr[2];
}
//$result = '666';
$pachare = mysqli_query($conn,"SELECT sankhye FROM `hastacalita_phalitansa_kemeru_drei` WHERE sthiti = '1' LIMIT 1");
$achiki = mysqli_num_rows($pachare);
if($achiki == 1){
$thaka = mysqli_fetch_array($pachare);
$kadimesucyanka = $thaka['sankhye'];
$result = $kadimesucyanka;
}
function checkNumberProperties($number) {
$digits = str_split((string) $number);
$output['isAllDifferent'] = (count(array_unique($digits)) === 3);
$output['isConsecutive'] = ($digits[0] + 1 == $digits[1] && $digits[1] + 1 == $digits[2]);
$output['isAllSame'] = ($digits[0] === $digits[1] && $digits[1] === $digits[2]);
$output['isFirstTwoSame'] = ($digits[0] === $digits[1]);
$output['isFirstLastSame'] = ($digits[0] === $digits[2]);
$sum = array_sum($digits);
$output['sum'] = $sum;
$output['isEven'] = ($sum % 2 === 0);
$output['digits'] = $digits;
return $output;
}
$res_arr = checkNumberProperties($result);
$dinanka = date('Y-m-d H:i:s');
$tathya = mysqli_query($conn,"INSERT INTO `gellaluhogiondu_kemeru_phalitansa_drei` (`kalaparichaya`,`bele`,`phalitansa`,`phalitansadaprakara`,`dinankavannuracisi`) VALUES ('".$samasyesreni['atadaaidi']."','".$result."','".$res_arr['sum']."','uncensored','".$dinanka."')");
if($res_arr['isAllDifferent']){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 34.56, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '9') > 0
AND INSTR(ojana, '".$res_arr['digits'][0]."') > 0
AND INSTR(ojana, '".$res_arr['digits'][1]."') = INSTR(ojana, '".$res_arr['digits'][0]."') + 4
AND INSTR(ojana, '".$res_arr['digits'][2]."') = INSTR(ojana, '".$res_arr['digits'][1]."') + 4
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '9') > 0
AND INSTR(ojana, '".$res_arr['digits'][0]."') > 0
AND INSTR(ojana, '".$res_arr['digits'][1]."') = INSTR(ojana, '".$res_arr['digits'][0]."') + 4
AND INSTR(ojana, '".$res_arr['digits'][2]."') = INSTR(ojana, '".$res_arr['digits'][1]."') + 4
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 6.91, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '4') > 0
AND INSTR(ojana, '".$res_arr['digits'][0]."') > 0
AND INSTR(ojana, '".$res_arr['digits'][1]."') = INSTR(ojana, '".$res_arr['digits'][0]."') + 4
AND INSTR(ojana, '".$res_arr['digits'][2]."') != INSTR(ojana, '".$res_arr['digits'][1]."') + 4
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '4') > 0
AND INSTR(ojana, '".$res_arr['digits'][0]."') > 0
AND INSTR(ojana, '".$res_arr['digits'][1]."') = INSTR(ojana, '".$res_arr['digits'][0]."') + 4
AND INSTR(ojana, '".$res_arr['digits'][2]."') != INSTR(ojana, '".$res_arr['digits'][1]."') + 4
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['isConsecutive']){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(sesabida * 8.64, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '10') > 0";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '10') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['isAllSame']){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(sesabida * 34.56, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '8') > 0";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '8') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 207.36, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '7') > 0
AND INSTR(ojana, '".$result."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '7') > 0
AND INSTR(ojana, '".$result."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['isFirstTwoSame']){
//echo 111."<br>";
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 13.83, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '6') > 0
AND INSTR(ojana, '".$res_arr['digits'][0].$res_arr['digits'][1]."') > 0
";
//echo $nabikarana;
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '6') > 0
AND INSTR(ojana, '".$res_arr['digits'][0].$res_arr['digits'][1]."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['isFirstLastSame']){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 69.12, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '5') > 0
AND INSTR(ojana, '".$res_arr['digits'][0].$res_arr['digits'][2]."') > 0
AND INSTR(ojana, '".$res_arr['digits'][1]."') != INSTR(ojana, '".$res_arr['digits'][0]."') + 1
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '6') > 0
AND INSTR(ojana, '".$res_arr['digits'][0].$res_arr['digits'][2]."') > 0
AND INSTR(ojana, '".$res_arr['digits'][1]."') != INSTR(ojana, '".$res_arr['digits'][0]."') + 1
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
if($res_arr['sum'] == 3){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 207.36, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 4){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 69.12, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 5){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 34.56, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 6){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 20.74, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 7){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 13.83, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 8){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 9.88, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 9){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 8.3, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 10){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 7.68, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 11){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 7.68, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 12){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 8.3, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 13){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 9.88, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 14){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 13.83, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 15){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 20.74, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 16){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 34.56, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 17){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 69.12, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 18){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 207.36, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta
SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2)
";
$conn->query($nabikarana);
}
$nabikarana_dui = "UPDATE bajikattuttate_kemuru_drei set ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."'";
$conn->query($nabikarana_dui);
}
else{
$yadrcchika_1 = rand(1, 6);
$yadrcchika_2 = rand(1, 6);
$yadrcchika_3 = rand(1, 6);
$yadrcchika = $yadrcchika_1.$yadrcchika_2.$yadrcchika_3;
$yadrcchika_misana = $yadrcchika_1+$yadrcchika_2+$yadrcchika_3;
$dinanka = date('Y-m-d H:i:s');
$tathya = mysqli_query($conn,"INSERT INTO `gellaluhogiondu_kemeru_phalitansa_drei` (`kalaparichaya`,`bele`,`phalitansa`,`phalitansadaprakara`,`dinankavannuracisi`) VALUES ('".$samasyesreni['atadaaidi']."','".$yadrcchika."','".$yadrcchika_misana."','shonu','".$dinanka."')");
}
}//include("serive/samparkaphp"); //Remove IT
$samasye = "SELECT atadaaidi
FROM gelluonduhogu_kemuru_drei
ORDER BY kramasankhye DESC LIMIT 1";//Add Kemuru
$samasyephalitansa = $conn->query($samasye);
$samasyesreni = mysqli_fetch_array($samasyephalitansa);
//$samasyesreni['atadaaidi'] = 20240624010862;
if(isset($samasyesreni['atadaaidi'])){
$gadhipathuli = "SELECT ojana, ketebida
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = ".$samasyesreni['atadaaidi']."
ORDER BY parichaya DESC LIMIT 1";
$gadhipathuliphala = $conn->query($gadhipathuli);
$gadhipathulidhadi = mysqli_num_rows($gadhipathuliphala);
if($gadhipathulidhadi >= 1){
$sabutathya = "SELECT\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '3') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_3_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '4') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_4_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '5') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_5_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '6') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_6_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '7') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_7_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '8') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_8_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '9') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_9_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '10') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_10_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '11') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_11_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '12') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_12_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '13') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_13_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '14') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_14_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '15') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_15_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '16') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_16_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '17') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_17_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '18') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_18_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, 'H') AND INSTR(prakar, '2') THEN ketebida ELSE 0 END) AS ojana_H_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, 'L') AND INSTR(prakar, '2') THEN ketebida ELSE 0 END) AS ojana_L_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, 'O') AND INSTR(prakar, '3') THEN ketebida ELSE 0 END) AS ojana_O_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, 'E') AND INSTR(prakar, '3') THEN ketebida ELSE 0 END) AS ojana_E_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 9 THEN ketebida ELSE 0 END) AS prakar_9_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 10 THEN ketebida ELSE 0 END) AS prakar_10_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 4 THEN ketebida ELSE 0 END) AS prakar_4_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 7 THEN ketebida ELSE 0 END) AS prakar_7_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 8 THEN ketebida ELSE 0 END) AS prakar_8_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 6 THEN ketebida ELSE 0 END) AS prakar_6_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 5 THEN ketebida ELSE 0 END) AS prakar_5_misana\xd\xa\x9\x9\x9ROM bajikattuttate_kemuru_drei WHERE byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'];
$sabutathyaphala = $conn->query($sabutathya);
$sabutathyasreni = mysqli_fetch_array($sabutathyaphala);
$tini = ($sabutathyasreni["ojana_3_misana"] * 20736) + ($sabutathyasreni["ojana_L_misana"] * 192) + ($sabutathyasreni["ojana_O_misana"] * 192);
$chari = ($sabutathyasreni["ojana_4_misana"] * 6912) + ($sabutathyasreni["ojana_L_misana"] * 192) + ($sabutathyasreni["ojana_E_misana"] * 192);
$panche = ($sabutathyasreni["ojana_5_misana"] * 3456) + ($sabutathyasreni["ojana_L_misana"] * 192) + ($sabutathyasreni["ojana_O_misana"] * 192);
$chha = ($sabutathyasreni["ojana_6_misana"] * 2074) + ($sabutathyasreni["ojana_L_misana"] * 192) + ($sabutathyasreni["ojana_E_misana"] * 192);
$saate = ($sabutathyasreni["ojana_7_misana"] * 1383) + ($sabutathyasreni["ojana_L_misana"] * 192) + ($sabutathyasreni["ojana_O_misana"] * 192);
$aathe = ($sabutathyasreni["ojana_8_misana"] * 988) + ($sabutathyasreni["ojana_L_misana"] * 192) + ($sabutathyasreni["ojana_E_misana"] * 192);
$nah = ($sabutathyasreni["ojana_9_misana"] * 83) + ($sabutathyasreni["ojana_L_misana"] * 192) + ($sabutathyasreni["ojana_O_misana"] * 192);
$dasa = ($sabutathyasreni["ojana_10_misana"] * 768) + ($sabutathyasreni["ojana_L_misana"] * 192) + ($sabutathyasreni["ojana_E_misana"] * 192);
$egara = ($sabutathyasreni["ojana_11_misana"] * 768) + ($sabutathyasreni["ojana_H_misana"] * 192) + ($sabutathyasreni["ojana_O_misana"] * 192);
$bara = ($sabutathyasreni["ojana_12_misana"] * 83) + ($sabutathyasreni["ojana_H_misana"] * 192) + ($sabutathyasreni["ojana_E_misana"] * 192);
$teyra = ($sabutathyasreni["ojana_13_misana"] * 988) + ($sabutathyasreni["ojana_H_misana"] * 192) + ($sabutathyasreni["ojana_O_misana"] * 192);
$chouda = ($sabutathyasreni["ojana_14_misana"] * 1383) + ($sabutathyasreni["ojana_H_misana"] * 192) + ($sabutathyasreni["ojana_E_misana"] * 192);
$pandara = ($sabutathyasreni["ojana_15_misana"] * 2074) + ($sabutathyasreni["ojana_H_misana"] * 192) + ($sabutathyasreni["ojana_O_misana"] * 192);
$sohala = ($sabutathyasreni["ojana_16_misana"] * 3456) + ($sabutathyasreni["ojana_H_misana"] * 192) + ($sabutathyasreni["ojana_E_misana"] * 192);
$satara = ($sabutathyasreni["ojana_17_misana"] * 6912) + ($sabutathyasreni["ojana_H_misana"] * 192) + ($sabutathyasreni["ojana_O_misana"] * 192);
$athara = ($sabutathyasreni["ojana_18_misana"] * 20736) + ($sabutathyasreni["ojana_H_misana"] * 192) + ($sabutathyasreni["ojana_E_misana"] * 192);
$totalarr = array($tini, $chari, $panche, $chha, $saate, $aathe, $nah, $dasa, $egara, $bara, $teyra, $chouda, $pandara, $sohala, $satara, $athara);
$mintot = min($totalarr);
$thatnumber = array_search($mintot, $totalarr);
$realnumber = $thatnumber + 3;
function sort_with_positions($arr) {
$original_with_index = [];
foreach ($arr as $index => $value) {
$original_with_index[] = ['value' => $value, 'index' => $index];
}
usort($original_with_index, function($a, $b) {
return $a['value'] <=> $b['value'];
});
$sorted_values = [];
$positions = [];
foreach ($original_with_index as $element) {
$sorted_values[] = $element['value'];
$positions[] = $element['index'];
}
return [$sorted_values, $positions];
}
[$sorted_arr, $positions] = sort_with_positions($totalarr);
$pluspositions = array_map(function($value) {
return $value + 3;
}, $positions);
$sabualaga = ($sabutathyasreni['prakar_9_misana'] * 3456) + ($sabutathyasreni['prakar_10_misana'] * 864) + ($sabutathyasreni['prakar_4_misana'] * 691);
$sabusaman = ($sabutathyasreni['prakar_7_misana'] * 20736) + ($sabutathyasreni['prakar_8_misana'] * 3456) + ($sabutathyasreni['prakar_6_misana'] * 1383);
$ditasaman = $sabutathyasreni['prakar_5_misana'] * 6912;
$sabujaka = array($sabualaga, $sabusaman, $ditasaman);
$sabuthukaam = min($sabujaka);
$kouta = array_search($sabuthukaam, $sabujaka);
if($sabualaga == 0 && $sabusaman == 0 && $ditasaman == 0){
$kouta = 3;
}
if($kouta == 0){
$sqlstr = "SELECT num
FROM (
SELECT '1' AS num
UNION ALL
SELECT '2'
UNION ALL
SELECT '3'
UNION ALL
SELECT '4'
UNION ALL
SELECT '5'
UNION ALL
SELECT '6'
) AS numbers
WHERE num NOT IN (
SELECT '1' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%1%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '2' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%2%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '3' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%3%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '4' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%4%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '5' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%5%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '6' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%6%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
)";
$sqlstrans = $conn->query($sqlstr);
$sqlstrnum = mysqli_num_rows($sqlstrans);
if($sqlstrnum == 0){
$difstr = "
WITH sums AS (
SELECT
SUM(CASE WHEN ojana LIKE '%1%' THEN ketebida ELSE 0 END) AS sum_1,
SUM(CASE WHEN ojana LIKE '%2%' THEN ketebida ELSE 0 END) AS sum_2,
SUM(CASE WHEN ojana LIKE '%3%' THEN ketebida ELSE 0 END) AS sum_3,
SUM(CASE WHEN ojana LIKE '%4%' THEN ketebida ELSE 0 END) AS sum_4,
SUM(CASE WHEN ojana LIKE '%5%' THEN ketebida ELSE 0 END) AS sum_5,
SUM(CASE WHEN ojana LIKE '%6%' THEN ketebida ELSE 0 END) AS sum_6
FROM
bajikattuttate_kemuru_drei
WHERE
(prakar = '9' OR prakar = '10' OR prakar = '4')
AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi']."
), min_sums AS (
SELECT '1' AS number, sum_1 AS ketebida_sum FROM sums
UNION ALL
SELECT '2' AS number, sum_2 AS ketebida_sum FROM sums
UNION ALL
SELECT '3' AS number, sum_3 AS ketebida_sum FROM sums
UNION ALL
SELECT '4' AS number, sum_4 AS ketebida_sum FROM sums
UNION ALL
SELECT '5' AS number, sum_5 AS ketebida_sum FROM sums
UNION ALL
SELECT '6' AS number, sum_6 AS ketebida_sum FROM sums
), minimum AS (
SELECT
MIN(ketebida_sum) AS minimum_ketebida
FROM
min_sums
)
SELECT
number,
ketebida_sum
FROM
min_sums
WHERE
ketebida_sum = (SELECT minimum_ketebida FROM minimum)
ORDER BY
RAND()
LIMIT 1
";
$difstrans = $conn->query($difstr);
$firstnumarr = mysqli_fetch_array($difstrans);
$firstnum = $firstnumarr['number'];
}
else{
$dif = array();
while($row = mysqli_fetch_array($sqlstrans)){
$dif[] = $row['num'];
}
$key = array_rand($dif,1);
$firstnum = $dif[$key];
}
function generateUniqueDigitNumber($digit, $targetSums) {
$combinations = [];
foreach ($digits as $i) {
foreach ($digits as $j) {
if ($i != $j) {
$combinations[] = [$digit, $i, $j];
}
}
}
foreach ($targetSums as $sum) {
foreach ($combinations as $combination) {
if (array_sum($combination) == $sum) {
//sort($combination);
//shuffle($combination);
$partA = array_slice($combination,0,1);
$partB = array_slice($combination,1,sizeof($combination));
shuffle($partB);
return implode('', array_merge($partA, $partB));
}
}
}
return null;
}
$result = generateUniqueDigitNumber($firstnum, $pluspositions);
//echo $result;
}
if($kouta == 1){
$sqlstr = "SELECT num
FROM (
SELECT '1' AS num
UNION ALL
SELECT '2'
UNION ALL
SELECT '3'
UNION ALL
SELECT '4'
UNION ALL
SELECT '5'
UNION ALL
SELECT '6'
) AS numbers
WHERE num NOT IN (
SELECT '1' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%1%' AND (prakar = '7' OR prakar = '8' OR prakar = '6') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '2' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%2%' AND (prakar = '7' OR prakar = '8' OR prakar = '6') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '3' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%3%' AND (prakar = '7' OR prakar = '8' OR prakar = '6') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '4' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%4%' AND (prakar = '7' OR prakar = '8' OR prakar = '6') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '5' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%5%' AND (prakar = '7' OR prakar = '8' OR prakar = '6') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '6' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%6%' AND (prakar = '7' OR prakar = '8' OR prakar = '6') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
)";
$sqlstrans = $conn->query($sqlstr);
$sqlstrnum = mysqli_num_rows($sqlstrans);
if($sqlstrnum == 0){
$difstr = "
WITH sums AS (
SELECT
SUM(CASE WHEN ojana LIKE '%1%' THEN ketebida ELSE 0 END) AS sum_1,
SUM(CASE WHEN ojana LIKE '%2%' THEN ketebida ELSE 0 END) AS sum_2,
SUM(CASE WHEN ojana LIKE '%3%' THEN ketebida ELSE 0 END) AS sum_3,
SUM(CASE WHEN ojana LIKE '%4%' THEN ketebida ELSE 0 END) AS sum_4,
SUM(CASE WHEN ojana LIKE '%5%' THEN ketebida ELSE 0 END) AS sum_5,
SUM(CASE WHEN ojana LIKE '%6%' THEN ketebida ELSE 0 END) AS sum_6
FROM
bajikattuttate_kemuru_drei
WHERE
(prakar = '7' OR prakar = '8' OR prakar = '6')
AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi']."
), min_sums AS (
SELECT '1' AS number, sum_1 AS ketebida_sum FROM sums
UNION ALL
SELECT '2' AS number, sum_2 AS ketebida_sum FROM sums
UNION ALL
SELECT '3' AS number, sum_3 AS ketebida_sum FROM sums
UNION ALL
SELECT '4' AS number, sum_4 AS ketebida_sum FROM sums
UNION ALL
SELECT '5' AS number, sum_5 AS ketebida_sum FROM sums
UNION ALL
SELECT '6' AS number, sum_6 AS ketebida_sum FROM sums
), minimum AS (
SELECT
MIN(ketebida_sum) AS minimum_ketebida
FROM
min_sums
)
SELECT
number,
ketebida_sum
FROM
min_sums
WHERE
ketebida_sum = (SELECT minimum_ketebida FROM minimum)
ORDER BY
RAND()
LIMIT 1
";
$difstrans = $conn->query($difstr);
$firstnumarr = mysqli_fetch_array($difstrans);
$firstnum = $firstnumarr['number'];
}
else{
$dif = array();
while($row = mysqli_fetch_array($sqlstrans)){
$dif[] = $row['num'];
}
$key = array_rand($dif,1);
$firstnum = $dif[$key];
}
function find_third_digit($number, $targetSums) {
$sumOfTwoDigits = array_sum($digits);
foreach ($targetSums as $targetSum) {
for ($thirdDigit = 1; $thirdDigit <= 6; $thirdDigit++) {
if ($sumOfTwoDigits + $thirdDigit == $targetSum) {
return $number . $thirdDigit;
}
}
}
return null;
}
$number = $firstnum.$firstnum;
$result = find_third_digit($number, $pluspositions);
//echo $result;
}
if($kouta == 2){
$sqlstr = "SELECT num
FROM (
SELECT '1' AS num
UNION ALL
SELECT '2'
UNION ALL
SELECT '3'
UNION ALL
SELECT '4'
UNION ALL
SELECT '5'
UNION ALL
SELECT '6'
) AS numbers
WHERE num NOT IN (
SELECT '1' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%1%' AND prakar = '5' AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '2' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%2%' AND prakar = '5' AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '3' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%3%' AND prakar = '5' AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '4' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%4%' AND prakar = '5' AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '5' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%5%' AND prakar = '5' AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '6' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%6%' AND prakar = '5' AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
)";
$sqlstrans = $conn->query($sqlstr);
$sqlstrnum = mysqli_num_rows($sqlstrans);
if($sqlstrnum == 0){
$difstr = "
WITH sums AS (
SELECT
SUM(CASE WHEN ojana LIKE '%1%' THEN ketebida ELSE 0 END) AS sum_1,
SUM(CASE WHEN ojana LIKE '%2%' THEN ketebida ELSE 0 END) AS sum_2,
SUM(CASE WHEN ojana LIKE '%3%' THEN ketebida ELSE 0 END) AS sum_3,
SUM(CASE WHEN ojana LIKE '%4%' THEN ketebida ELSE 0 END) AS sum_4,
SUM(CASE WHEN ojana LIKE '%5%' THEN ketebida ELSE 0 END) AS sum_5,
SUM(CASE WHEN ojana LIKE '%6%' THEN ketebida ELSE 0 END) AS sum_6
FROM
bajikattuttate_kemuru_drei
WHERE
prakar = '5'
AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi']."
), min_sums AS (
SELECT '1' AS number, sum_1 AS ketebida_sum FROM sums
UNION ALL
SELECT '2' AS number, sum_2 AS ketebida_sum FROM sums
UNION ALL
SELECT '3' AS number, sum_3 AS ketebida_sum FROM sums
UNION ALL
SELECT '4' AS number, sum_4 AS ketebida_sum FROM sums
UNION ALL
SELECT '5' AS number, sum_5 AS ketebida_sum FROM sums
UNION ALL
SELECT '6' AS number, sum_6 AS ketebida_sum FROM sums
), minimum AS (
SELECT
MIN(ketebida_sum) AS minimum_ketebida
FROM
min_sums
)
SELECT
number,
ketebida_sum
FROM
min_sums
WHERE
ketebida_sum = (SELECT minimum_ketebida FROM minimum)
ORDER BY
RAND()
LIMIT 1
";
$difstrans = $conn->query($difstr);
$firstnumarr = mysqli_fetch_array($difstrans);
$firstnum = $firstnumarr['number'];
}
else{
$dif = array();
while($row = mysqli_fetch_array($sqlstrans)){
$dif[] = $row['num'];
}
$key = array_rand($dif,1);
$firstnum = $dif[$key];
}
function generateNumber($firstDigit, $sums) {
foreach ($sums as $requiredSum) {
for ($middleDigit = 1; $middleDigit <= 6; $middleDigit++) {
if ($middleDigit == $firstDigit) {
continue;
}
$sum = $firstDigit + $middleDigit + $firstDigit;
if ($sum == $requiredSum) {
return $firstDigit . $middleDigit . $firstDigit;
}
}
}
return null;
}
$result = generateNumber($firstnum, $pluspositions);
//echo $result;
}
if($kouta == 3){
$totalsum = $realnumber;
function findThreeDigitNumbers($targetSum) {
if ($targetSum < 3 || $targetSum > 18) {
throw new InvalidArgumentException("Input must be a number between 3 and 18.");
}
$results = [];
for ($hundred = 1; $hundred <= 6; $hundred++) {
for ($ten = 1; $ten <= 6; $ten++) {
for ($unit = 1; $unit <= 6; $unit++) {
$number = $hundred * 100 + $ten * 10 + $unit;
if ($hundred >= 1 && $hundred <= 6 &&
$ten >= 1 && $ten <= 6 &&
$unit >= 1 && $unit <= 6 &&
$hundred + $ten + $unit === $targetSum) {
$results[] = [$hundred, $ten, $unit];
}
}
}
}
return $results;
}
$numsarr = findThreeDigitNumbers($totalsum);
$key = array_rand($numsarr ,1);
$result = "$nu";
}
//$result = '666';
$pachare = mysqli_query($conn,"SELECT sankhye FROM `hastacalita_phalitansa_kemeru_drei` WHERE sthiti = '1' LIMIT 1");
$achiki = mysqli_num_rows($pachare);
if($achiki == 1){
$thaka = mysqli_fetch_array($pachare);
$kadimesucyanka = $thaka['sankhye'];
$result = $kadimesucyanka;
}
function checkNumberProperties($number) {
$output['isAllDifferent'] = (count(array_unique($digits)) === 3);
$output['isConsecutive'] = ("$" + 1 == "n" && "n" + 1 == "u");
$output['isAllSame'] = ("$" === "n" && "n" === "u");
$output['isFirstTwoSame'] = ("$" === "n");
$output['isFirstLastSame'] = ("$" === "u");
$sum = array_sum($digits);
$output['sum'] = $sum;
$output['isEven'] = ($sum % 2 === 0);
$output['digits'] = $digits;
return $output;
}
$res_arr = checkNumberProperties($result);
$dinanka = date('Y-m-d H:i:s');
$tathya = mysqli_query($conn,"INSERT INTO `gellaluhogiondu_kemeru_phalitansa_drei` (`kalaparichaya`,`bele`,`phalitansa`,`phalitansadaprakara`,`dinankavannuracisi`) VALUES ('".$samasyesreni['atadaaidi']."','".$result."','".$res_arr['sum']."','uncensored','".$dinanka."')");
if($res_arr['isAllDifferent']){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 3456, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '9') > 0
AND INSTR(ojana, '".$res_arr['digits'][0]."') > 0
AND INSTR(ojana, '".$res_arr['digits'][1]."') = INSTR(ojana, '".$res_arr['digits'][0]."') + 4
AND INSTR(ojana, '".$res_arr['digits'][2]."') = INSTR(ojana, '".$res_arr['digits'][1]."') + 4
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '9') > 0
AND INSTR(ojana, '".$res_arr['digits'][0]."') > 0
AND INSTR(ojana, '".$res_arr['digits'][1]."') = INSTR(ojana, '".$res_arr['digits'][0]."') + 4
AND INSTR(ojana, '".$res_arr['digits'][2]."') = INSTR(ojana, '".$res_arr['digits'][1]."') + 4
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 691, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '4') > 0
AND INSTR(ojana, '".$res_arr['digits'][0]."') > 0
AND INSTR(ojana, '".$res_arr['digits'][1]."') = INSTR(ojana, '".$res_arr['digits'][0]."') + 4
AND INSTR(ojana, '".$res_arr['digits'][2]."') != INSTR(ojana, '".$res_arr['digits'][1]."') + 4
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '4') > 0
AND INSTR(ojana, '".$res_arr['digits'][0]."') > 0
AND INSTR(ojana, '".$res_arr['digits'][1]."') = INSTR(ojana, '".$res_arr['digits'][0]."') + 4
AND INSTR(ojana, '".$res_arr['digits'][2]."') != INSTR(ojana, '".$res_arr['digits'][1]."') + 4
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['isConsecutive']){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(sesabida * 864, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '10') > 0";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '10') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['isAllSame']){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(sesabida * 3456, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '8') > 0";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '8') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 20736, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '7') > 0
AND INSTR(ojana, '".$result."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '7') > 0
AND INSTR(ojana, '".$result."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['isFirstTwoSame']){
//echo 111."<br>";
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1383, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '6') > 0
AND INSTR(ojana, '".$res_arr['digits'][0].$res_arr['digits'][1]."') > 0
";
//echo $nabikarana;
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '6') > 0
AND INSTR(ojana, '".$res_arr['digits'][0].$res_arr['digits'][1]."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['isFirstLastSame']){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 6912, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '5') > 0
AND INSTR(ojana, '".$res_arr['digits'][0].$res_arr['digits'][2]."') > 0
AND INSTR(ojana, '".$res_arr['digits'][1]."') != INSTR(ojana, '".$res_arr['digits'][0]."') + 1
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '6') > 0
AND INSTR(ojana, '".$res_arr['digits'][0].$res_arr['digits'][2]."') > 0
AND INSTR(ojana, '".$res_arr['digits'][1]."') != INSTR(ojana, '".$res_arr['digits'][0]."') + 1
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
}
if($res_arr['sum'] == 3){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 20736, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 4){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 6912, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 5){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 3456, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 6){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 2074, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 7){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1383, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 8){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 988, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 9){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 83, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 10){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 768, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'L') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 11){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 768, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 12){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 83, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 13){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 988, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 14){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1383, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 15){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 2074, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 16){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 3456, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 17){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 6912, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'O') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
}
else if($res_arr['sum'] == 18){
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 20736, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0
AND INSTR(ojana, '".$res_arr['sum']."') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0
AND INSTR(ojana, 'E') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
$nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 192, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."'
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
";
$conn->query($nabikarana);
$nabikarana = "UPDATE shonu_kaichila
INNER JOIN (
SELECT byabaharkarta, SUM(sesabida) AS total_paid
FROM bajikattuttate_kemuru_drei
WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0
AND INSTR(ojana, 'H') > 0
AND phalaphala ='gagner'
GROUP BY byabaharkarta
) AS subquery ON shonu_kaichilabalakedara = subquerybyabaharkarta
SET shonu_kaichilamotta = TRUNCATE(shonu_kaichilamotta + subquerytotal_paid, 2)
";
$conn->query($nabikarana);
}
$nabikarana_dui = "UPDATE bajikattuttate_kemuru_drei set ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."'";
$conn->query($nabikarana_dui);
}
else{
$yadrcchika_1 = rand(1, 6);
$yadrcchika_2 = rand(1, 6);
$yadrcchika_3 = rand(1, 6);
$yadrcchika = $yadrcchika_1.$yadrcchika_2.$yadrcchika_3;
$yadrcchika_misana = $yadrcchika_1+$yadrcchika_2+$yadrcchika_3;
$dinanka = date('Y-m-d H:i:s');
$tathya = mysqli_query($conn,"INSERT INTO `gellaluhogiondu_kemeru_phalitansa_drei` (`kalaparichaya`,`bele`,`phalitansa`,`phalitansadaprakara`,`dinankavannuracisi`) VALUES ('".$samasyesreni['atadaaidi']."','".$yadrcchika."','".$yadrcchika_misana."','shonu','".$dinanka."')");
}
}© 2023 Quttera Ltd. All rights reserved.