//include("serive/samparka.php"); //Remove IT
$samasye = "SELECT atadaaidi
FROM gelluonduhogu_kemuru
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
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 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 \xd\xa\x9\x9\x9\x9\x9FROM ( \xd\xa\x9\x9\x9\x9\x9\x9SELECT '1' AS num \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '2' \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '3' \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '4' \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '5' \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '6' \xd\xa\x9\x9\x9\x9\x9) AS numbers \xd\xa\x9\x9\x9\x9\x9WHERE num NOT IN ( \xd\xa\x9\x9\x9\x9\x9\x9SELECT '1' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru 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']."
) \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '2' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru 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']."
) \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '3' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru 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 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 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 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
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 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 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 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 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 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 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
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 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 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 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 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 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 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
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` 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` (`kalaparichaya`,`bele`,`phalitansa`,`phalitansadaprakara`,`dinankavannuracisi`) VALUES ('".$samasyesreni['atadaaidi']."','".$result."','".$res_arr['sum']."','uncensored','".$dinanka."')");
if($res_arr['isAllDifferent']){
$nabikarana = "UPDATE bajikattuttate_kemuru 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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` (`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
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
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 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 \xd\xa\x9\x9\x9\x9ROM ( \xd\xa\x9\x9\x9\x9\x9\x9SELECT '1' AS num \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '2' \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '3' \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '4' \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '5' \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '6' \xd\xa\x9\x9\x9\x9\x9) AS numbers \xd\xa\x9\x9\x9\x9\x9WHERE num NOT IN ( \xd\xa\x9\x9\x9\x9\x9\x9SELECT '1' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru 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']."
) \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '2' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru 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']."
) \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '3' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru 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 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 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 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
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 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 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 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 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 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 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
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 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 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 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 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 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 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
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` 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` (`kalaparichaya`,`bele`,`phalitansa`,`phalitansadaprakara`,`dinankavannuracisi`) VALUES ('".$samasyesreni['atadaaidi']."','".$result."','".$res_arr['sum']."','uncensored','".$dinanka."')");
if($res_arr['isAllDifferent']){
$nabikarana = "UPDATE bajikattuttate_kemuru 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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` (`kalaparichaya`,`bele`,`phalitansa`,`phalitansadaprakara`,`dinankavannuracisi`) VALUES ('".$samasyesreni['atadaaidi']."','".$yadrcchika."','".$yadrcchika_misana."','shonu','".$dinanka."')");
}
}
//include("serive/samparkaphp"); //Remove IT
$samasye = "SELECT atadaaidi
FROM gelluonduhogu_kemuru
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
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 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 \xd\xa\x9\x9\x9\x9ROM ( \xd\xa\x9\x9\x9\x9\x9\x9SELECT '1' AS num \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '2' \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '3' \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '4' \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '5' \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '6' \xd\xa\x9\x9\x9\x9\x9) AS numbers \xd\xa\x9\x9\x9\x9\x9WHERE num NOT IN ( \xd\xa\x9\x9\x9\x9\x9\x9SELECT '1' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru 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']."
) \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '2' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru 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']."
) \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '3' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru 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 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 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 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
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 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 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 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 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 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 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
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 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 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 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 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 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 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
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` 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` (`kalaparichaya`,`bele`,`phalitansa`,`phalitansadaprakara`,`dinankavannuracisi`) VALUES ('".$samasyesreni['atadaaidi']."','".$result."','".$res_arr['sum']."','uncensored','".$dinanka."')");
if($res_arr['isAllDifferent']){
$nabikarana = "UPDATE bajikattuttate_kemuru 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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
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 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` (`kalaparichaya`,`bele`,`phalitansa`,`phalitansadaprakara`,`dinankavannuracisi`) VALUES ('".$samasyesreni['atadaaidi']."','".$yadrcchika."','".$yadrcchika_misana."','shonu','".$dinanka."')");
}
}
© 2023 Quttera Ltd. All rights reserved.