Linux s3.cpanelhost.co.in 5.14.0-611.49.2.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Apr 30 09:05:08 EDT 2026 x86_64
LiteSpeed
: 65.108.44.247 | : 216.73.217.179
Cant Read [ /etc/named.conf ]
7.4.33
teac11783
Bypass.pw
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
Backdoor Scanner
Backdoor Create
Alfa Webshell
CPANEL RESET
CREATE WP USER
README
+ Create Folder
+ Create File
/
home /
teac11783 /
jaiclub.teacherslex.site /
[ HOME SHELL ]
Name
Size
Permission
Action
.well-known
[ DIR ]
drwxr-xr-x
apiimages
[ DIR ]
drwxrwxrwx
assets
[ DIR ]
drwxrwxrwx
assetsrajagame
[ DIR ]
drwxrwxrwx
av
[ DIR ]
drwxrwxrwx
deepanshu
[ DIR ]
drwxrwxrwx
diuwinnew
[ DIR ]
drwxrwxrwx
download
[ DIR ]
drwxrwxrwx
downloadcenter
[ DIR ]
drwxrwxrwx
game100
[ DIR ]
drwxrwxrwx
game121
[ DIR ]
drwxrwxrwx
h5kservice
[ DIR ]
drwxrwxrwx
hackall
[ DIR ]
drwxrwxrwx
images
[ DIR ]
drwxrwxrwx
images_usdt
[ DIR ]
drwxrwxrwx
jdb
[ DIR ]
drwxrwxrwx
jdbapi
[ DIR ]
drwxrwxrwx
jet
[ DIR ]
drwxrwxrwx
jili
[ DIR ]
drwxrwxrwx
loading
[ DIR ]
drwxrwxrwx
manifest
[ DIR ]
drwxrwxrwx
pay
[ DIR ]
drwxrwxrwx
plugins
[ DIR ]
drwxrwxrwx
public_ftp
[ DIR ]
drwxrwxrwx
public_html
[ DIR ]
drwxrwxrwx
secretadminop
[ DIR ]
drwxrwxrwx
serive
[ DIR ]
drwxrwxrwx
slex143
[ DIR ]
drwxrwxrwx
vendors
[ DIR ]
drwxrwxrwx
.htaccess
281
B
-rw-r--r--
.mad-root
0
B
-rw-r--r--
91club@192.png
23.44
KB
-rw-rw-rw-
abcoderscron.php
1.86
KB
-rw-rw-rw-
admin_slex143.zip
5.81
MB
-rw-rw-rw-
adminer.php
0
B
-rw-r--r--
agent_details.php
37.4
KB
-rw-rw-rw-
alf4.php
0
B
-rw-r--r--
api2.php
998
B
-rw-rw-rw-
api_pass.php
9.04
KB
-rw-r--r--
app.config.js
627
B
-rw-rw-rw-
ar-sw.js
2.58
KB
-rw-rw-rw-
atcron.php
1.52
KB
-rw-rw-rw-
backup_2026-01-08_18-43-24.zip...
732
B
-rw-rw-rw-
bscan.php
0
B
-rw-r--r--
clear_spin.php
393
B
-rw-rw-rw-
commintioncron.php
2.61
KB
-rw-rw-rw-
dailysalary.php
13.32
KB
-rw-rw-rw-
data.json
2.19
KB
-rw-rw-rw-
deepanshu.html
12.54
KB
-rw-rw-rw-
down.svg
259
B
-rw-rw-rw-
error_log
11.5
KB
-rw-rw-rw-
favico.ico
135
B
-rw-rw-rw-
firebase-messaging-sw.js
1.49
KB
-rw-rw-rw-
full.apk
1.07
MB
-rw-rw-rw-
get_agent.php
547
B
-rw-rw-rw-
gold.svg
20.15
KB
-rw-rw-rw-
handlebalance.php
1.44
KB
-rw-rw-rw-
homeDown.svg
900
B
-rw-rw-rw-
icon-192x192.png
41.77
KB
-rw-rw-rw-
img.icon
32.26
KB
-rw-rw-rw-
index.html
1.2
MB
-rw-r--r--
index.htmlbdg_
1.18
MB
-rw-rw-rw-
index.htmlrajagame
1.18
MB
-rw-rw-rw-
index.php1
779.76
KB
-rw-rw-rw-
index.php2
613.26
KB
-rw-rw-rw-
jaiclub.teacherslex.site_funct...
5.6
KB
-rw-r--r--
jdb-1.php
13.4
KB
-rw-rw-rw-
ktrx.php
1.49
KB
-rw-rw-rw-
ktrx10.php
1.5
KB
-rw-rw-rw-
ktrx3.php
1.5
KB
-rw-rw-rw-
ktrx5.php
1.5
KB
-rw-rw-rw-
live-chat-help.html
446
B
-rw-rw-rw-
log.txt
0
B
-rw-rw-rw-
logo.png
30.35
KB
-rw-rw-rw-
maintenance.html
1.81
KB
-rw-rw-rw-
manifest.91club.json
808
B
-rw-rw-rw-
message_notice.svg
927
B
-rw-rw-rw-
nayakaphalitansa_mulaka_unohs....
32.27
KB
-rw-rw-rw-
nayakaphalitansa_mulaka_unohs3...
32
KB
-rw-rw-rw-
nayakaphalitansa_mulaka_unohs_...
128.17
KB
-rw-rw-rw-
nayakaphalitansa_mulaka_unohs_...
129.82
KB
-rw-rw-rw-
nayakaphalitansa_mulaka_unohs_...
129.82
KB
-rw-rw-rw-
nayakaphalitansa_mulaka_unohs_...
129.82
KB
-rw-rw-rw-
nayakaphalitansa_mulaka_unohs_...
32.92
KB
-rw-rw-rw-
nayakaphalitansa_mulaka_unohs_...
32.95
KB
-rw-rw-rw-
nayakaphalitansa_mulaka_unohs_...
93.84
KB
-rw-rw-rw-
nayakaphalitansa_mulaka_unohs_...
92.27
KB
-rw-rw-rw-
nayakaphalitansa_mulaka_unohs_...
92.27
KB
-rw-rw-rw-
nayakaphalitansa_mulaka_unohs_...
92.27
KB
-rw-rw-rw-
nayakaphalitansa_mulaka_unohs_...
33.44
KB
-rw-rw-rw-
niyamitakelasa.php
3.99
KB
-rw-rw-rw-
niyamitakelasa30sec.php
2.34
KB
-rw-rw-rw-
niyamitakelasa_aidudi.php
1.54
KB
-rw-rw-rw-
niyamitakelasa_aidudi_drei.php
1.58
KB
-rw-rw-rw-
niyamitakelasa_aidudi_funf.php
1.58
KB
-rw-rw-rw-
niyamitakelasa_aidudi_zehn.php
1.58
KB
-rw-rw-rw-
niyamitakelasa_drei.php
2.1
KB
-rw-rw-rw-
niyamitakelasa_funf.php
2.08
KB
-rw-rw-rw-
niyamitakelasa_kemuru.php
1.54
KB
-rw-rw-rw-
niyamitakelasa_kemuru_drei.php
1.58
KB
-rw-rw-rw-
niyamitakelasa_kemuru_funf.php
1.58
KB
-rw-rw-rw-
niyamitakelasa_kemuru_zehn.php
1.58
KB
-rw-rw-rw-
niyamitakelasa_zehn.php
1.79
KB
-rw-rw-rw-
notice.svg
1.42
KB
-rw-rw-rw-
orders_validity.json
8.55
KB
-rw-r--r--
php.ini
632
B
-rw-rw-rw-
point.svg
188
B
-rw-rw-rw-
pwnkit
0
B
-rwxr-xr-x
rank.svg
5.33
KB
-rw-rw-rw-
rank_bg.svg
7.45
KB
-rw-rw-rw-
recharge_btn.svg
1.68
KB
-rw-rw-rw-
refresh.svg
629
B
-rw-rw-rw-
slex143.zip
11.65
MB
-rw-r--r--
spin.png
1.38
KB
-rw-rw-rw-
sw-domain.js
1.36
KB
-rw-rw-rw-
sw-page.js
7.98
KB
-rw-rw-rw-
sw-utils.js
3.84
KB
-rw-rw-rw-
test_anim.html
3.21
KB
-rw-rw-rw-
testipay.php
1.2
KB
-rw-rw-rw-
text.php
4.27
KB
-rw-rw-rw-
timepad.php
1.4
KB
-rw-rw-rw-
trx.php
27.68
KB
-rw-rw-rw-
trx1.php
28.52
KB
-rw-rw-rw-
trx10.php
29.62
KB
-rw-rw-rw-
trxupkid.php
27.8
KB
-rw-rw-rw-
trxupkid10.php
27.93
KB
-rw-rw-rw-
trxupkid3.php
27.87
KB
-rw-rw-rw-
trxupkid5.php
27.87
KB
-rw-rw-rw-
turntable.svg
23.79
KB
-rw-rw-rw-
up.svg
261
B
-rw-rw-rw-
Delete
Unzip
Zip
${this.title}
Close
Code Editor : nayakaphalitansa_mulaka_unohs_kemuru_drei.php
<?php //include("serive/samparka.php"); //Remove IT $samasye = "SELECT atadaaidi FROM gelluonduhogu_kemuru_drei ORDER BY kramasankhye DESC LIMIT 1";//Add Kemuru $samasyephalitansa = $conn->query($samasye); $samasyesreni = mysqli_fetch_array($samasyephalitansa); //$samasyesreni['atadaaidi'] = 20240624010862; if(isset($samasyesreni['atadaaidi'])){ $gadhipathuli = "SELECT ojana, ketebida FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = ".$samasyesreni['atadaaidi']." ORDER BY parichaya DESC LIMIT 1"; $gadhipathuliphala = $conn->query($gadhipathuli); $gadhipathulidhadi = mysqli_num_rows($gadhipathuliphala); if($gadhipathulidhadi >= 1){ $sabutathya = "\x53\x45\x4c\x45\x43\x54\xd\xa\x9\x9\x9\x9\x53\x55\x4d\x28\x43\x41\x53\x45\x20\x57\x48\x45\x4e\x20\x49\x4e\x53\x54\x52\x28\x6f\x6a\x61\x6e\x61\x2c\x20\x27\x33\x27\x29\x20\x41\x4e\x44\x20\x49\x4e\x53\x54\x52\x28\x70\x72\x61\x6b\x61\x72\x2c\x20\x27\x31\x27\x29\x20\x54\x48\x45\x4e\x20\x6b\x65\x74\x65\x62\x69\x64\x61\x20\x45\x4c\x53\x45\x20\x30\x20\x45\x4e\x44\x29\x20\x41\x53\x20\x6f\x6a\x61\x6e\x61\x5f\x33\x5f\x6d\x69\x73\x61\x6e\x61\x2c\xd\xa\x9\x9\x9\x9\x53\x55\x4d\x28\x43\x41\x53\x45\x20\x57\x48\x45\x4e\x20\x49\x4e\x53\x54\x52\x28\x6f\x6a\x61\x6e\x61\x2c\x20\x27\x34\x27\x29\x20\x41\x4e\x44\x20\x49\x4e\x53\x54\x52\x28\x70\x72\x61\x6b\x61\x72\x2c\x20\x27\x31\x27\x29\x20\x54\x48\x45\x4e\x20\x6b\x65\x74\x65\x62\x69\x64\x61\x20\x45\x4c\x53\x45\x20\x30\x20\x45\x4e\x44\x29\x20\x41\x53\x20\x6f\x6a\x61\x6e\x61\x5f\x34\x5f\x6d\x69\x73\x61\x6e\x61\x2c\xd\xa\x9\x9\x9\x9\x53\x55\x4d\x28\x43\x41\x53\x45\x20\x57\x48\x45\x4e\x20\x49\x4e\x53\x54\x52\x28\x6f\x6a\x61\x6e\x61\x2c\x20\x27\x35\x27\x29\x20\x41\x4e\x44\x20\x49\x4e\x53\x54\x52\x28\x70\x72\x61\x6b\x61\x72\x2c\x20\x27\x31\x27\x29\x20\x54\x48\x45\x4e\x20\x6b\x65\x74\x65\x62\x69\x64\x61\x20\x45\x4c\x53\x45\x20\x30\x20\x45\x4e\x44\x29\x20\x41\x53\x20\x6f\x6a\x61\x6e\x61\x5f\x35\x5f\x6d\x69\x73\x61\x6e\x61\x2c\xd\xa\x9\x9\x9\x9\x53\x55\x4d\x28\x43\x41\x53\x45\x20\x57\x48\x45\x4e\x20\x49\x4e\x53\x54\x52\x28\x6f\x6a\x61\x6e\x61\x2c\x20\x27\x36\x27\x29\x20\x41\x4e\x44\x20\x49\x4e\x53\x54\x52\x28\x70\x72\x61\x6b\x61\x72\x2c\x20\x27\x31\x27\x29\x20\x54\x48\x45\x4e\x20\x6b\x65\x74\x65\x62\x69\x64\x61\x20\x45\x4c\x53\x45\x20\x30\x20\x45\x4e\x44\x29\x20\x41\x53\x20\x6f\x6a\x61\x6e\x61\x5f\x36\x5f\x6d\x69\x73\x61\x6e\x61\x2c\xd\xa\x9\x9\x9\x9\x53\x55\x4d\x28\x43\x41\x53\x45\x20\x57\x48\x45\x4e\x20\x49\x4e\x53\x54\x52\x28\x6f\x6a\x61\x6e\x61\x2c\x20\x27\x37\x27\x29\x20\x41\x4e\x44\x20\x49\x4e\x53\x54\x52\x28\x70\x72\x61\x6b\x61\x72\x2c\x20\x27\x31\x27\x29\x20\x54\x48\x45\x4e\x20\x6b\x65\x74\x65\x62\x69\x64\x61\x20\x45\x4c\x53\x45\x20\x30\x20\x45\x4e\x44\x29\x20\x41\x53\x20\x6f\x6a\x61\x6e\x61\x5f\x37\x5f\x6d\x69\x73\x61\x6e\x61\x2c\xd\xa\x9\x9\x9\x9\x53\x55\x4d\x28\x43\x41\x53\x45\x20\x57\x48\x45\x4e\x20\x49\x4e\x53\x54\x52\x28\x6f\x6a\x61\x6e\x61\x2c\x20\x27\x38\x27\x29\x20\x41\x4e\x44\x20\x49\x4e\x53\x54\x52\x28\x70\x72\x61\x6b\x61\x72\x2c\x20\x27\x31\x27\x29\x20\x54\x48\x45\x4e\x20\x6b\x65\x74\x65\x62\x69\x64\x61\x20\x45\x4c\x53\x45\x20\x30\x20\x45\x4e\x44\x29\x20\x41\x53\x20\x6f\x6a\x61\x6e\x61\x5f\x38\x5f\x6d\x69\x73\x61\x6e\x61\x2c\xd\xa\x9\x9\x9\x9\x53\x55\x4d\x28\x43\x41\x53\x45\x20\x57\x48\x45\x4e\x20\x49\x4e\x53\x54\x52\x28\x6f\x6a\x61\x6e\x61\x2c\x20\x27\x39\x27\x29\x20\x41\x4e\x44\x20\x49\x4e\x53\x54\x52\x28\x70\x72\x61\x6b\x61\x72\x2c\x20\x27\x31\x27\x29\x20\x54\x48\x45\x4e\x20\x6b\x65\x74\x65\x62\x69\x64\x61\x20\x45\x4c\x53\x45\x20\x30\x20\x45\x4e\x44\x29\x20\x41\x53\x20\x6f\x6a\x61\x6e\x61\x5f\x39\x5f\x6d\x69\x73\x61\x6e\x61\x2c\xd\xa\x9\x9\x9\x9\x53\x55\x4d\x28\x43\x41\x53\x45\x20\x57\x48\x45\x4e\x20\x49\x4e\x53\x54\x52\x28\x6f\x6a\x61\x6e\x61\x2c\x20\x27\x31\x30\x27\x29\x20\x41\x4e\x44\x20\x49\x4e\x53\x54\x52\x28\x70\x72\x61\x6b\x61\x72\x2c\x20\x27\x31\x27\x29\x20\x54\x48\x45\x4e\x20\x6b\x65\x74\x65\x62\x69\x64\x61\x20\x45\x4c\x53\x45\x20\x30\x20\x45\x4e\x44\x29\x20\x41\x53\x20\x6f\x6a\x61\x6e\x61\x5f\x31\x30\x5f\x6d\x69\x73\x61\x6e\x61\x2c\xd\xa\x9\x9\x9\x9\x53\x55\x4d\x28\x43\x41\x53\x45\x20\x57\x48\x45\x4e\x20\x49\x4e\x53\x54\x52\x28\x6f\x6a\x61\x6e\x61\x2c\x20\x27\x31\x31\x27\x29\x20\x41\x4e\x44\x20\x49\x4e\x53\x54\x52\x28\x70\x72\x61\x6b\x61\x72\x2c\x20\x27\x31\x27\x29\x20\x54\x48\x45\x4e\x20\x6b\x65\x74\x65\x62\x69\x64\x61\x20\x45\x4c\x53\x45\x20\x30\x20\x45\x4e\x44\x29\x20\x41\x53\x20\x6f\x6a\x61\x6e\x61\x5f\x31\x31\x5f\x6d\x69\x73\x61\x6e\x61\x2c\xd\xa\x9\x9\x9\x9\x53\x55\x4d\x28\x43\x41\x53\x45\x20\x57\x48\x45\x4e\x20\x49\x4e\x53\x54\x52\x28\x6f\x6a\x61\x6e\x61\x2c\x20\x27\x31\x32\x27\x29\x20\x41\x4e\x44\x20\x49\x4e\x53\x54\x52\x28\x70\x72\x61\x6b\x61\x72\x2c\x20\x27\x31\x27\x29\x20\x54\x48\x45\x4e\x20\x6b\x65\x74\x65\x62\x69\x64\x61\x20\x45\x4c\x53\x45\x20\x30\x20\x45\x4e\x44\x29\x20\x41\x53\x20\x6f\x6a\x61\x6e\x61\x5f\x31\x32\x5f\x6d\x69\x73\x61\x6e\x61\x2c\xd\xa\x9\x9\x9\x9\x53\x55\x4d\x28\x43\x41\x53\x45\x20\x57\x48\x45\x4e\x20\x49\x4e\x53\x54\x52\x28\x6f\x6a\x61\x6e\x61\x2c\x20\x27\x31\x33\x27\x29\x20\x41\x4e\x44\x20\x49\x4e\x53\x54\x52\x28\x70\x72\x61\x6b\x61\x72\x2c\x20\x27\x31\x27\x29\x20\x54\x48\x45\x4e\x20\x6b\x65\x74\x65\x62\x69\x64\x61\x20\x45\x4c\x53\x45\x20\x30\x20\x45\x4e\x44\x29\x20\x41\x53\x20\x6f\x6a\x61\x6e\x61\x5f\x31\x33\x5f\x6d\x69\x73\x61\x6e\x61\x2c\xd\xa\x9\x9\x9\x9\x53\x55\x4d\x28\x43\x41\x53\x45\x20\x57\x48\x45\x4e\x20\x49\x4e\x53\x54\x52\x28\x6f\x6a\x61\x6e\x61\x2c\x20\x27\x31\x34\x27\x29\x20\x41\x4e\x44\x20\x49\x4e\x53\x54\x52\x28\x70\x72\x61\x6b\x61\x72\x2c\x20\x27\x31\x27\x29\x20\x54\x48\x45\x4e\x20\x6b\x65\x74\x65\x62\x69\x64\x61\x20\x45\x4c\x53\x45\x20\x30\x20\x45\x4e\x44\x29\x20\x41\x53\x20\x6f\x6a\x61\x6e\x61\x5f\x31\x34\x5f\x6d\x69\x73\x61\x6e\x61\x2c\xd\xa\x9\x9\x9\x9\x53\x55\x4d\x28\x43\x41\x53\x45\x20\x57\x48\x45\x4e\x20\x49\x4e\x53\x54\x52\x28\x6f\x6a\x61\x6e\x61\x2c\x20\x27\x31\x35\x27\x29\x20\x41\x4e\x44\x20\x49\x4e\x53\x54\x52\x28\x70\x72\x61\x6b\x61\x72\x2c\x20\x27\x31\x27\x29\x20\x54\x48\x45\x4e\x20\x6b\x65\x74\x65\x62\x69\x64\x61\x20\x45\x4c\x53\x45\x20\x30\x20\x45\x4e\x44\x29\x20\x41\x53\x20\x6f\x6a\x61\x6e\x61\x5f\x31\x35\x5f\x6d\x69\x73\x61\x6e\x61\x2c\xd\xa\x9\x9\x9\x9\x53\x55\x4d\x28\x43\x41\x53\x45\x20\x57\x48\x45\x4e\x20\x49\x4e\x53\x54\x52\x28\x6f\x6a\x61\x6e\x61\x2c\x20\x27\x31\x36\x27\x29\x20\x41\x4e\x44\x20\x49\x4e\x53\x54\x52\x28\x70\x72\x61\x6b\x61\x72\x2c\x20\x27\x31\x27\x29\x20\x54\x48\x45\x4e\x20\x6b\x65\x74\x65\x62\x69\x64\x61\x20\x45\x4c\x53\x45\x20\x30\x20\x45\x4e\x44\x29\x20\x41\x53\x20\x6f\x6a\x61\x6e\x61\x5f\x31\x36\x5f\x6d\x69\x73\x61\x6e\x61\x2c\xd\xa\x9\x9\x9\x9\x53\x55\x4d\x28\x43\x41\x53\x45\x20\x57\x48\x45\x4e\x20\x49\x4e\x53\x54\x52\x28\x6f\x6a\x61\x6e\x61\x2c\x20\x27\x31\x37\x27\x29\x20\x41\x4e\x44\x20\x49\x4e\x53\x54\x52\x28\x70\x72\x61\x6b\x61\x72\x2c\x20\x27\x31\x27\x29\x20\x54\x48\x45\x4e\x20\x6b\x65\x74\x65\x62\x69\x64\x61\x20\x45\x4c\x53\x45\x20\x30\x20\x45\x4e\x44\x29\x20\x41\x53\x20\x6f\x6a\x61\x6e\x61\x5f\x31\x37\x5f\x6d\x69\x73\x61\x6e\x61\x2c\xd\xa\x9\x9\x9\x9\x53\x55\x4d\x28\x43\x41\x53\x45\x20\x57\x48\x45\x4e\x20\x49\x4e\x53\x54\x52\x28\x6f\x6a\x61\x6e\x61\x2c\x20\x27\x31\x38\x27\x29\x20\x41\x4e\x44\x20\x49\x4e\x53\x54\x52\x28\x70\x72\x61\x6b\x61\x72\x2c\x20\x27\x31\x27\x29\x20\x54\x48\x45\x4e\x20\x6b\x65\x74\x65\x62\x69\x64\x61\x20\x45\x4c\x53\x45\x20\x30\x20\x45\x4e\x44\x29\x20\x41\x53\x20\x6f\x6a\x61\x6e\x61\x5f\x31\x38\x5f\x6d\x69\x73\x61\x6e\x61\x2c\xd\xa\x9\x9\x9\x9\x53\x55\x4d\x28\x43\x41\x53\x45\x20\x57\x48\x45\x4e\x20\x49\x4e\x53\x54\x52\x28\x6f\x6a\x61\x6e\x61\x2c\x20\x27\x48\x27\x29\x20\x41\x4e\x44\x20\x49\x4e\x53\x54\x52\x28\x70\x72\x61\x6b\x61\x72\x2c\x20\x27\x32\x27\x29\x20\x54\x48\x45\x4e\x20\x6b\x65\x74\x65\x62\x69\x64\x61\x20\x45\x4c\x53\x45\x20\x30\x20\x45\x4e\x44\x29\x20\x41\x53\x20\x6f\x6a\x61\x6e\x61\x5f\x48\x5f\x6d\x69\x73\x61\x6e\x61\x2c\xd\xa\x9\x9\x9\x9\x53\x55\x4d\x28\x43\x41\x53\x45\x20\x57\x48\x45\x4e\x20\x49\x4e\x53\x54\x52\x28\x6f\x6a\x61\x6e\x61\x2c\x20\x27\x4c\x27\x29\x20\x41\x4e\x44\x20\x49\x4e\x53\x54\x52\x28\x70\x72\x61\x6b\x61\x72\x2c\x20\x27\x32\x27\x29\x20\x54\x48\x45\x4e\x20\x6b\x65\x74\x65\x62\x69\x64\x61\x20\x45\x4c\x53\x45\x20\x30\x20\x45\x4e\x44\x29\x20\x41\x53\x20\x6f\x6a\x61\x6e\x61\x5f\x4c\x5f\x6d\x69\x73\x61\x6e\x61\x2c\xd\xa\x9\x9\x9\x9\x53\x55\x4d\x28\x43\x41\x53\x45\x20\x57\x48\x45\x4e\x20\x49\x4e\x53\x54\x52\x28\x6f\x6a\x61\x6e\x61\x2c\x20\x27\x4f\x27\x29\x20\x41\x4e\x44\x20\x49\x4e\x53\x54\x52\x28\x70\x72\x61\x6b\x61\x72\x2c\x20\x27\x33\x27\x29\x20\x54\x48\x45\x4e\x20\x6b\x65\x74\x65\x62\x69\x64\x61\x20\x45\x4c\x53\x45\x20\x30\x20\x45\x4e\x44\x29\x20\x41\x53\x20\x6f\x6a\x61\x6e\x61\x5f\x4f\x5f\x6d\x69\x73\x61\x6e\x61\x2c\xd\xa\x9\x9\x9\x9\x53\x55\x4d\x28\x43\x41\x53\x45\x20\x57\x48\x45\x4e\x20\x49\x4e\x53\x54\x52\x28\x6f\x6a\x61\x6e\x61\x2c\x20\x27\x45\x27\x29\x20\x41\x4e\x44\x20\x49\x4e\x53\x54\x52\x28\x70\x72\x61\x6b\x61\x72\x2c\x20\x27\x33\x27\x29\x20\x54\x48\x45\x4e\x20\x6b\x65\x74\x65\x62\x69\x64\x61\x20\x45\x4c\x53\x45\x20\x30\x20\x45\x4e\x44\x29\x20\x41\x53\x20\x6f\x6a\x61\x6e\x61\x5f\x45\x5f\x6d\x69\x73\x61\x6e\x61\x2c\xd\xa\x9\x9\x9\x9\x53\x55\x4d\x28\x43\x41\x53\x45\x20\x57\x48\x45\x4e\x20\x70\x72\x61\x6b\x61\x72\x20\x3d\x20\x39\x20\x54\x48\x45\x4e\x20\x6b\x65\x74\x65\x62\x69\x64\x61\x20\x45\x4c\x53\x45\x20\x30\x20\x45\x4e\x44\x29\x20\x41\x53\x20\x70\x72\x61\x6b\x61\x72\x5f\x39\x5f\x6d\x69\x73\x61\x6e\x61\x2c\xd\xa\x9\x9\x9\x9\x53\x55\x4d\x28\x43\x41\x53\x45\x20\x57\x48\x45\x4e\x20\x70\x72\x61\x6b\x61\x72\x20\x3d\x20\x31\x30\x20\x54\x48\x45\x4e\x20\x6b\x65\x74\x65\x62\x69\x64\x61\x20\x45\x4c\x53\x45\x20\x30\x20\x45\x4e\x44\x29\x20\x41\x53\x20\x70\x72\x61\x6b\x61\x72\x5f\x31\x30\x5f\x6d\x69\x73\x61\x6e\x61\x2c\xd\xa\x9\x9\x9\x9\x53\x55\x4d\x28\x43\x41\x53\x45\x20\x57\x48\x45\x4e\x20\x70\x72\x61\x6b\x61\x72\x20\x3d\x20\x34\x20\x54\x48\x45\x4e\x20\x6b\x65\x74\x65\x62\x69\x64\x61\x20\x45\x4c\x53\x45\x20\x30\x20\x45\x4e\x44\x29\x20\x41\x53\x20\x70\x72\x61\x6b\x61\x72\x5f\x34\x5f\x6d\x69\x73\x61\x6e\x61\x2c\xd\xa\x9\x9\x9\x9\x53\x55\x4d\x28\x43\x41\x53\x45\x20\x57\x48\x45\x4e\x20\x70\x72\x61\x6b\x61\x72\x20\x3d\x20\x37\x20\x54\x48\x45\x4e\x20\x6b\x65\x74\x65\x62\x69\x64\x61\x20\x45\x4c\x53\x45\x20\x30\x20\x45\x4e\x44\x29\x20\x41\x53\x20\x70\x72\x61\x6b\x61\x72\x5f\x37\x5f\x6d\x69\x73\x61\x6e\x61\x2c\xd\xa\x9\x9\x9\x9\x53\x55\x4d\x28\x43\x41\x53\x45\x20\x57\x48\x45\x4e\x20\x70\x72\x61\x6b\x61\x72\x20\x3d\x20\x38\x20\x54\x48\x45\x4e\x20\x6b\x65\x74\x65\x62\x69\x64\x61\x20\x45\x4c\x53\x45\x20\x30\x20\x45\x4e\x44\x29\x20\x41\x53\x20\x70\x72\x61\x6b\x61\x72\x5f\x38\x5f\x6d\x69\x73\x61\x6e\x61\x2c\xd\xa\x9\x9\x9\x9\x53\x55\x4d\x28\x43\x41\x53\x45\x20\x57\x48\x45\x4e\x20\x70\x72\x61\x6b\x61\x72\x20\x3d\x20\x36\x20\x54\x48\x45\x4e\x20\x6b\x65\x74\x65\x62\x69\x64\x61\x20\x45\x4c\x53\x45\x20\x30\x20\x45\x4e\x44\x29\x20\x41\x53\x20\x70\x72\x61\x6b\x61\x72\x5f\x36\x5f\x6d\x69\x73\x61\x6e\x61\x2c\xd\xa\x9\x9\x9\x9\x53\x55\x4d\x28\x43\x41\x53\x45\x20\x57\x48\x45\x4e\x20\x70\x72\x61\x6b\x61\x72\x20\x3d\x20\x35\x20\x54\x48\x45\x4e\x20\x6b\x65\x74\x65\x62\x69\x64\x61\x20\x45\x4c\x53\x45\x20\x30\x20\x45\x4e\x44\x29\x20\x41\x53\x20\x70\x72\x61\x6b\x61\x72\x5f\x35\x5f\x6d\x69\x73\x61\x6e\x61\xd\xa\x9\x9\x9\x9\x46\x52\x4f\x4d\x20\x62\x61\x6a\x69\x6b\x61\x74\x74\x75\x74\x74\x61\x74\x65\x5f\x6b\x65\x6d\x75\x72\x75\x5f\x64\x72\x65\x69\x20\x57\x48\x45\x52\x45\x20\x62\x79\x61\x62\x61\x68\x61\x72\x6b\x61\x72\x74\x61\x20\x4e\x4f\x54\x20\x49\x4e\x20\x28\x53\x45\x4c\x45\x43\x54\x20\x62\x61\x6c\x61\x6b\x65\x64\x61\x72\x61\x20\x46\x52\x4f\x4d\x20\x60\x64\x65\x6d\x6f\x60\x20\x57\x48\x45\x52\x45\x20\x60\x73\x74\x68\x69\x74\x69\x60\x3d\x27\x31\x27\x29\x20\x41\x4e\x44\x20\x6b\x61\x6c\x61\x70\x61\x72\x69\x63\x68\x61\x79\x61\x20\x3d\x20".$samasyesreni['atadaaidi']; $sabutathyaphala = $conn->query($sabutathya); $sabutathyasreni = mysqli_fetch_array($sabutathyaphala); $tini = ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x33\x5f\x6d\x69\x73\x61\x6e\x61"] * 207.36) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x4c\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x4f\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92); $chari = ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x34\x5f\x6d\x69\x73\x61\x6e\x61"] * 69.12) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x4c\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x45\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92); $panche = ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x35\x5f\x6d\x69\x73\x61\x6e\x61"] * 34.56) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x4c\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x4f\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92); $chha = ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x36\x5f\x6d\x69\x73\x61\x6e\x61"] * 20.74) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x4c\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x45\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92); $saate = ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x37\x5f\x6d\x69\x73\x61\x6e\x61"] * 13.83) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x4c\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x4f\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92); $aathe = ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x38\x5f\x6d\x69\x73\x61\x6e\x61"] * 9.88) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x4c\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x45\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92); $nah = ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x39\x5f\x6d\x69\x73\x61\x6e\x61"] * 8.3) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x4c\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x4f\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92); $dasa = ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x31\x30\x5f\x6d\x69\x73\x61\x6e\x61"] * 7.68) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x4c\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x45\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92); $egara = ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x31\x31\x5f\x6d\x69\x73\x61\x6e\x61"] * 7.68) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x48\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x4f\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92); $bara = ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x31\x32\x5f\x6d\x69\x73\x61\x6e\x61"] * 8.3) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x48\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x45\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92); $teyra = ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x31\x33\x5f\x6d\x69\x73\x61\x6e\x61"] * 9.88) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x48\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x4f\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92); $chouda = ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x31\x34\x5f\x6d\x69\x73\x61\x6e\x61"] * 13.83) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x48\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x45\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92); $pandara = ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x31\x35\x5f\x6d\x69\x73\x61\x6e\x61"] * 20.74) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x48\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x4f\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92); $sohala = ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x31\x36\x5f\x6d\x69\x73\x61\x6e\x61"] * 34.56) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x48\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x45\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92); $satara = ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x31\x37\x5f\x6d\x69\x73\x61\x6e\x61"] * 69.12) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x48\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x4f\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92); $athara = ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x31\x38\x5f\x6d\x69\x73\x61\x6e\x61"] * 207.36) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x48\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92) + ($sabutathyasreni["\x6f\x6a\x61\x6e\x61\x5f\x45\x5f\x6d\x69\x73\x61\x6e\x61"] * 1.92); $totalarr = array($tini, $chari, $panche, $chha, $saate, $aathe, $nah, $dasa, $egara, $bara, $teyra, $chouda, $pandara, $sohala, $satara, $athara); $mintot = min($totalarr); $thatnumber = array_search($mintot, $totalarr); $realnumber = $thatnumber + 3; function sort_with_positions($arr) { $original_with_index = []; foreach ($arr as $index => $value) { $original_with_index[] = ['value' => $value, 'index' => $index]; } usort($original_with_index, function($a, $b) { return $a['value'] <=> $b['value']; }); $sorted_values = []; $positions = []; foreach ($original_with_index as $element) { $sorted_values[] = $element['value']; $positions[] = $element['index']; } return [$sorted_values, $positions]; } [$sorted_arr, $positions] = sort_with_positions($totalarr); $pluspositions = array_map(function($value) { return $value + 3; }, $positions); $sabualaga = ($sabutathyasreni['prakar_9_misana'] * 34.56) + ($sabutathyasreni['prakar_10_misana'] * 8.64) + ($sabutathyasreni['prakar_4_misana'] * 6.91); $sabusaman = ($sabutathyasreni['prakar_7_misana'] * 207.36) + ($sabutathyasreni['prakar_8_misana'] * 34.56) + ($sabutathyasreni['prakar_6_misana'] * 13.83); $ditasaman = $sabutathyasreni['prakar_5_misana'] * 69.12; $sabujaka = array($sabualaga, $sabusaman, $ditasaman); $sabuthukaam = min($sabujaka); $kouta = array_search($sabuthukaam, $sabujaka); if($sabualaga == 0 && $sabusaman == 0 && $ditasaman == 0){ $kouta = 3; } if($kouta == 0){ $sqlstr = "SELECT num FROM ( SELECT '1' AS num UNION ALL SELECT '2' UNION ALL SELECT '3' UNION ALL SELECT '4' UNION ALL SELECT '5' UNION ALL SELECT '6' ) AS numbers WHERE num NOT IN ( SELECT '1' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%1%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND \x62\x79\x61\x62\x61\x68\x61\x72\x6b\x61\x72\x74\x61\x20\x4e\x4f\x54\x20\x49\x4e\x20\x28\x53\x45\x4c\x45\x43\x54\x20\x62\x61\x6c\x61\x6b\x65\x64\x61\x72\x61\x20\x46\x52\x4f\x4d\x20\x60\x64\x65\x6d\x6f\x60\x20\x57\x48\x45\x52\x45\x20\x60\x73\x74\x68\x69\x74\x69\x60\x3d\x27\x31\x27\x29\x20\x41\x4e\x44\x20 kalaparichaya = ".$samasyesreni['atadaaidi'].") UNION ALL SELECT '2' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%2%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND \x62\x79\x61\x62\x61\x68\x61\x72\x6b\x61\x72\x74\x61\x20\x4e\x4f\x54\x20\x49\x4e\x20\x28\x53\x45\x4c\x45\x43\x54\x20\x62\x61\x6c\x61\x6b\x65\x64\x61\x72\x61\x20\x46\x52\x4f\x4d\x20\x60\x64\x65\x6d\x6f\x60\x20\x57\x48\x45\x52\x45\x20\x60\x73\x74\x68\x69\x74\x69\x60\x3d\x27\x31\x27\x29\x20\x41\x4e\x44\x20 kalaparichaya = ".$samasyesreni['atadaaidi'].") UNION ALL SELECT '3' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%3%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND \x62\x79\x61\x62\x61\x68\x61\x72\x6b\x61\x72\x74\x61\x20\x4e\x4f\x54\x20\x49\x4e\x20\x28\x53\x45\x4c\x45\x43\x54\x20\x62\x61\x6c\x61\x6b\x65\x64\x61\x72\x61\x20\x46\x52\x4f\x4d\x20\x60\x64\x65\x6d\x6f\x60\x20\x57\x48\x45\x52\x45\x20\x60\x73\x74\x68\x69\x74\x69\x60\x3d\x27\x31\x27\x29\x20\x41\x4e\x44\x20 kalaparichaya = ".$samasyesreni['atadaaidi'].") UNION ALL SELECT '4' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%4%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND \x62\x79\x61\x62\x61\x68\x61\x72\x6b\x61\x72\x74\x61\x20\x4e\x4f\x54\x20\x49\x4e\x20\x28\x53\x45\x4c\x45\x43\x54\x20\x62\x61\x6c\x61\x6b\x65\x64\x61\x72\x61\x20\x46\x52\x4f\x4d\x20\x60\x64\x65\x6d\x6f\x60\x20\x57\x48\x45\x52\x45\x20\x60\x73\x74\x68\x69\x74\x69\x60\x3d\x27\x31\x27\x29\x20\x41\x4e\x44\x20 kalaparichaya = ".$samasyesreni['atadaaidi'].") UNION ALL SELECT '5' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%5%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND \x62\x79\x61\x62\x61\x68\x61\x72\x6b\x61\x72\x74\x61\x20\x4e\x4f\x54\x20\x49\x4e\x20\x28\x53\x45\x4c\x45\x43\x54\x20\x62\x61\x6c\x61\x6b\x65\x64\x61\x72\x61\x20\x46\x52\x4f\x4d\x20\x60\x64\x65\x6d\x6f\x60\x20\x57\x48\x45\x52\x45\x20\x60\x73\x74\x68\x69\x74\x69\x60\x3d\x27\x31\x27\x29\x20\x41\x4e\x44\x20 kalaparichaya = ".$samasyesreni['atadaaidi'].") UNION ALL SELECT '6' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%6%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND \x62\x79\x61\x62\x61\x68\x61\x72\x6b\x61\x72\x74\x61\x20\x4e\x4f\x54\x20\x49\x4e\x20\x28\x53\x45\x4c\x45\x43\x54\x20\x62\x61\x6c\x61\x6b\x65\x64\x61\x72\x61\x20\x46\x52\x4f\x4d\x20\x60\x64\x65\x6d\x6f\x60\x20\x57\x48\x45\x52\x45\x20\x60\x73\x74\x68\x69\x74\x69\x60\x3d\x27\x31\x27\x29\x20\x41\x4e\x44\x20 kalaparichaya = ".$samasyesreni['atadaaidi'].") )"; $sqlstrans = $conn->query($sqlstr); $sqlstrnum = mysqli_num_rows($sqlstrans); if($sqlstrnum == 0){ $difstr = " WITH sums AS ( SELECT SUM(CASE WHEN ojana LIKE '%1%' THEN ketebida ELSE 0 END) AS sum_1, SUM(CASE WHEN ojana LIKE '%2%' THEN ketebida ELSE 0 END) AS sum_2, SUM(CASE WHEN ojana LIKE '%3%' THEN ketebida ELSE 0 END) AS sum_3, SUM(CASE WHEN ojana LIKE '%4%' THEN ketebida ELSE 0 END) AS sum_4, SUM(CASE WHEN ojana LIKE '%5%' THEN ketebida ELSE 0 END) AS sum_5, SUM(CASE WHEN ojana LIKE '%6%' THEN ketebida ELSE 0 END) AS sum_6 FROM bajikattuttate_kemuru_drei WHERE (prakar = '9' OR prakar = '10' OR prakar = '4') AND \x62\x79\x61\x62\x61\x68\x61\x72\x6b\x61\x72\x74\x61\x20\x4e\x4f\x54\x20\x49\x4e\x20\x28\x53\x45\x4c\x45\x43\x54\x20\x62\x61\x6c\x61\x6b\x65\x64\x61\x72\x61\x20\x46\x52\x4f\x4d\x20\x60\x64\x65\x6d\x6f\x60\x20\x57\x48\x45\x52\x45\x20\x60\x73\x74\x68\x69\x74\x69\x60\x3d\x27\x31\x27\x29\x20\x41\x4e\x44\x20 kalaparichaya = ".$samasyesreni['atadaaidi']." ), min_sums AS ( SELECT '1' AS number, sum_1 AS ketebida_sum FROM sums UNION ALL SELECT '2' AS number, sum_2 AS ketebida_sum FROM sums UNION ALL SELECT '3' AS number, sum_3 AS ketebida_sum FROM sums UNION ALL SELECT '4' AS number, sum_4 AS ketebida_sum FROM sums UNION ALL SELECT '5' AS number, sum_5 AS ketebida_sum FROM sums UNION ALL SELECT '6' AS number, sum_6 AS ketebida_sum FROM sums ), minimum AS ( SELECT MIN(ketebida_sum) AS minimum_ketebida FROM min_sums ) SELECT number, ketebida_sum FROM min_sums WHERE ketebida_sum = (SELECT minimum_ketebida FROM minimum) ORDER BY RAND() LIMIT 1 "; $difstrans = $conn->query($difstr); $firstnumarr = mysqli_fetch_array($difstrans); $firstnum = $firstnumarr['number']; } else{ $dif = array(); while($row = mysqli_fetch_array($sqlstrans)){ $dif[] = $row['num']; } $key = array_rand($dif,1); $firstnum = $dif[$key]; } function generateUniqueDigitNumber($digit, $targetSums) { $digits = range(1, 6); $digits = array_diff($digits, [$digit]); $combinations = []; foreach ($digits as $i) { foreach ($digits as $j) { if ($i != $j) { $combinations[] = [$digit, $i, $j]; } } } foreach ($targetSums as $sum) { foreach ($combinations as $combination) { if (array_sum($combination) == $sum) { //sort($combination); //shuffle($combination); $partA = array_slice($combination,0,1); $partB = array_slice($combination,1,sizeof($combination)); shuffle($partB); return implode('', array_merge($partA, $partB)); } } } return null; } $result = generateUniqueDigitNumber($firstnum, $pluspositions); //echo $result; } if($kouta == 1){ $sqlstr = "SELECT num FROM ( SELECT '1' AS num UNION ALL SELECT '2' UNION ALL SELECT '3' UNION ALL SELECT '4' UNION ALL SELECT '5' UNION ALL SELECT '6' ) AS numbers WHERE num NOT IN ( SELECT '1' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%1%' AND (prakar = '7' OR prakar = '8' OR prakar = '6') AND \x62\x79\x61\x62\x61\x68\x61\x72\x6b\x61\x72\x74\x61\x20\x4e\x4f\x54\x20\x49\x4e\x20\x28\x53\x45\x4c\x45\x43\x54\x20\x62\x61\x6c\x61\x6b\x65\x64\x61\x72\x61\x20\x46\x52\x4f\x4d\x20\x60\x64\x65\x6d\x6f\x60\x20\x57\x48\x45\x52\x45\x20\x60\x73\x74\x68\x69\x74\x69\x60\x3d\x27\x31\x27\x29\x20\x41\x4e\x44\x20 kalaparichaya = ".$samasyesreni['atadaaidi'].") UNION ALL SELECT '2' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%2%' AND (prakar = '7' OR prakar = '8' OR prakar = '6') AND \x62\x79\x61\x62\x61\x68\x61\x72\x6b\x61\x72\x74\x61\x20\x4e\x4f\x54\x20\x49\x4e\x20\x28\x53\x45\x4c\x45\x43\x54\x20\x62\x61\x6c\x61\x6b\x65\x64\x61\x72\x61\x20\x46\x52\x4f\x4d\x20\x60\x64\x65\x6d\x6f\x60\x20\x57\x48\x45\x52\x45\x20\x60\x73\x74\x68\x69\x74\x69\x60\x3d\x27\x31\x27\x29\x20\x41\x4e\x44\x20 kalaparichaya = ".$samasyesreni['atadaaidi'].") UNION ALL SELECT '3' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%3%' AND (prakar = '7' OR prakar = '8' OR prakar = '6') AND \x62\x79\x61\x62\x61\x68\x61\x72\x6b\x61\x72\x74\x61\x20\x4e\x4f\x54\x20\x49\x4e\x20\x28\x53\x45\x4c\x45\x43\x54\x20\x62\x61\x6c\x61\x6b\x65\x64\x61\x72\x61\x20\x46\x52\x4f\x4d\x20\x60\x64\x65\x6d\x6f\x60\x20\x57\x48\x45\x52\x45\x20\x60\x73\x74\x68\x69\x74\x69\x60\x3d\x27\x31\x27\x29\x20\x41\x4e\x44\x20 kalaparichaya = ".$samasyesreni['atadaaidi'].") UNION ALL SELECT '4' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%4%' AND (prakar = '7' OR prakar = '8' OR prakar = '6') AND \x62\x79\x61\x62\x61\x68\x61\x72\x6b\x61\x72\x74\x61\x20\x4e\x4f\x54\x20\x49\x4e\x20\x28\x53\x45\x4c\x45\x43\x54\x20\x62\x61\x6c\x61\x6b\x65\x64\x61\x72\x61\x20\x46\x52\x4f\x4d\x20\x60\x64\x65\x6d\x6f\x60\x20\x57\x48\x45\x52\x45\x20\x60\x73\x74\x68\x69\x74\x69\x60\x3d\x27\x31\x27\x29\x20\x41\x4e\x44\x20 kalaparichaya = ".$samasyesreni['atadaaidi'].") UNION ALL SELECT '5' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%5%' AND (prakar = '7' OR prakar = '8' OR prakar = '6') AND \x62\x79\x61\x62\x61\x68\x61\x72\x6b\x61\x72\x74\x61\x20\x4e\x4f\x54\x20\x49\x4e\x20\x28\x53\x45\x4c\x45\x43\x54\x20\x62\x61\x6c\x61\x6b\x65\x64\x61\x72\x61\x20\x46\x52\x4f\x4d\x20\x60\x64\x65\x6d\x6f\x60\x20\x57\x48\x45\x52\x45\x20\x60\x73\x74\x68\x69\x74\x69\x60\x3d\x27\x31\x27\x29\x20\x41\x4e\x44\x20 kalaparichaya = ".$samasyesreni['atadaaidi'].") UNION ALL SELECT '6' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%6%' AND (prakar = '7' OR prakar = '8' OR prakar = '6') AND \x62\x79\x61\x62\x61\x68\x61\x72\x6b\x61\x72\x74\x61\x20\x4e\x4f\x54\x20\x49\x4e\x20\x28\x53\x45\x4c\x45\x43\x54\x20\x62\x61\x6c\x61\x6b\x65\x64\x61\x72\x61\x20\x46\x52\x4f\x4d\x20\x60\x64\x65\x6d\x6f\x60\x20\x57\x48\x45\x52\x45\x20\x60\x73\x74\x68\x69\x74\x69\x60\x3d\x27\x31\x27\x29\x20\x41\x4e\x44\x20 kalaparichaya = ".$samasyesreni['atadaaidi'].") )"; $sqlstrans = $conn->query($sqlstr); $sqlstrnum = mysqli_num_rows($sqlstrans); if($sqlstrnum == 0){ $difstr = " WITH sums AS ( SELECT SUM(CASE WHEN ojana LIKE '%1%' THEN ketebida ELSE 0 END) AS sum_1, SUM(CASE WHEN ojana LIKE '%2%' THEN ketebida ELSE 0 END) AS sum_2, SUM(CASE WHEN ojana LIKE '%3%' THEN ketebida ELSE 0 END) AS sum_3, SUM(CASE WHEN ojana LIKE '%4%' THEN ketebida ELSE 0 END) AS sum_4, SUM(CASE WHEN ojana LIKE '%5%' THEN ketebida ELSE 0 END) AS sum_5, SUM(CASE WHEN ojana LIKE '%6%' THEN ketebida ELSE 0 END) AS sum_6 FROM bajikattuttate_kemuru_drei WHERE (prakar = '7' OR prakar = '8' OR prakar = '6') AND \x62\x79\x61\x62\x61\x68\x61\x72\x6b\x61\x72\x74\x61\x20\x4e\x4f\x54\x20\x49\x4e\x20\x28\x53\x45\x4c\x45\x43\x54\x20\x62\x61\x6c\x61\x6b\x65\x64\x61\x72\x61\x20\x46\x52\x4f\x4d\x20\x60\x64\x65\x6d\x6f\x60\x20\x57\x48\x45\x52\x45\x20\x60\x73\x74\x68\x69\x74\x69\x60\x3d\x27\x31\x27\x29\x20\x41\x4e\x44\x20 kalaparichaya = ".$samasyesreni['atadaaidi']." ), min_sums AS ( SELECT '1' AS number, sum_1 AS ketebida_sum FROM sums UNION ALL SELECT '2' AS number, sum_2 AS ketebida_sum FROM sums UNION ALL SELECT '3' AS number, sum_3 AS ketebida_sum FROM sums UNION ALL SELECT '4' AS number, sum_4 AS ketebida_sum FROM sums UNION ALL SELECT '5' AS number, sum_5 AS ketebida_sum FROM sums UNION ALL SELECT '6' AS number, sum_6 AS ketebida_sum FROM sums ), minimum AS ( SELECT MIN(ketebida_sum) AS minimum_ketebida FROM min_sums ) SELECT number, ketebida_sum FROM min_sums WHERE ketebida_sum = (SELECT minimum_ketebida FROM minimum) ORDER BY RAND() LIMIT 1 "; $difstrans = $conn->query($difstr); $firstnumarr = mysqli_fetch_array($difstrans); $firstnum = $firstnumarr['number']; } else{ $dif = array(); while($row = mysqli_fetch_array($sqlstrans)){ $dif[] = $row['num']; } $key = array_rand($dif,1); $firstnum = $dif[$key]; } function find_third_digit($number, $targetSums) { $digits = str_split($number); $sumOfTwoDigits = array_sum($digits); foreach ($targetSums as $targetSum) { for ($thirdDigit = 1; $thirdDigit <= 6; $thirdDigit++) { if ($sumOfTwoDigits + $thirdDigit == $targetSum) { return $number . $thirdDigit; } } } return null; } $number = $firstnum.$firstnum; $result = find_third_digit($number, $pluspositions); //echo $result; } if($kouta == 2){ $sqlstr = "SELECT num FROM ( SELECT '1' AS num UNION ALL SELECT '2' UNION ALL SELECT '3' UNION ALL SELECT '4' UNION ALL SELECT '5' UNION ALL SELECT '6' ) AS numbers WHERE num NOT IN ( SELECT '1' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%1%' AND prakar = '5' AND \x62\x79\x61\x62\x61\x68\x61\x72\x6b\x61\x72\x74\x61\x20\x4e\x4f\x54\x20\x49\x4e\x20\x28\x53\x45\x4c\x45\x43\x54\x20\x62\x61\x6c\x61\x6b\x65\x64\x61\x72\x61\x20\x46\x52\x4f\x4d\x20\x60\x64\x65\x6d\x6f\x60\x20\x57\x48\x45\x52\x45\x20\x60\x73\x74\x68\x69\x74\x69\x60\x3d\x27\x31\x27\x29\x20\x41\x4e\x44\x20 kalaparichaya = ".$samasyesreni['atadaaidi'].") UNION ALL SELECT '2' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%2%' AND prakar = '5' AND \x62\x79\x61\x62\x61\x68\x61\x72\x6b\x61\x72\x74\x61\x20\x4e\x4f\x54\x20\x49\x4e\x20\x28\x53\x45\x4c\x45\x43\x54\x20\x62\x61\x6c\x61\x6b\x65\x64\x61\x72\x61\x20\x46\x52\x4f\x4d\x20\x60\x64\x65\x6d\x6f\x60\x20\x57\x48\x45\x52\x45\x20\x60\x73\x74\x68\x69\x74\x69\x60\x3d\x27\x31\x27\x29\x20\x41\x4e\x44\x20 kalaparichaya = ".$samasyesreni['atadaaidi'].") UNION ALL SELECT '3' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%3%' AND prakar = '5' AND \x62\x79\x61\x62\x61\x68\x61\x72\x6b\x61\x72\x74\x61\x20\x4e\x4f\x54\x20\x49\x4e\x20\x28\x53\x45\x4c\x45\x43\x54\x20\x62\x61\x6c\x61\x6b\x65\x64\x61\x72\x61\x20\x46\x52\x4f\x4d\x20\x60\x64\x65\x6d\x6f\x60\x20\x57\x48\x45\x52\x45\x20\x60\x73\x74\x68\x69\x74\x69\x60\x3d\x27\x31\x27\x29\x20\x41\x4e\x44\x20 kalaparichaya = ".$samasyesreni['atadaaidi'].") UNION ALL SELECT '4' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%4%' AND prakar = '5' AND \x62\x79\x61\x62\x61\x68\x61\x72\x6b\x61\x72\x74\x61\x20\x4e\x4f\x54\x20\x49\x4e\x20\x28\x53\x45\x4c\x45\x43\x54\x20\x62\x61\x6c\x61\x6b\x65\x64\x61\x72\x61\x20\x46\x52\x4f\x4d\x20\x60\x64\x65\x6d\x6f\x60\x20\x57\x48\x45\x52\x45\x20\x60\x73\x74\x68\x69\x74\x69\x60\x3d\x27\x31\x27\x29\x20\x41\x4e\x44\x20 kalaparichaya = ".$samasyesreni['atadaaidi'].") UNION ALL SELECT '5' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%5%' AND prakar = '5' AND \x62\x79\x61\x62\x61\x68\x61\x72\x6b\x61\x72\x74\x61\x20\x4e\x4f\x54\x20\x49\x4e\x20\x28\x53\x45\x4c\x45\x43\x54\x20\x62\x61\x6c\x61\x6b\x65\x64\x61\x72\x61\x20\x46\x52\x4f\x4d\x20\x60\x64\x65\x6d\x6f\x60\x20\x57\x48\x45\x52\x45\x20\x60\x73\x74\x68\x69\x74\x69\x60\x3d\x27\x31\x27\x29\x20\x41\x4e\x44\x20 kalaparichaya = ".$samasyesreni['atadaaidi'].") UNION ALL SELECT '6' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru_drei WHERE ojana LIKE '%6%' AND prakar = '5' AND \x62\x79\x61\x62\x61\x68\x61\x72\x6b\x61\x72\x74\x61\x20\x4e\x4f\x54\x20\x49\x4e\x20\x28\x53\x45\x4c\x45\x43\x54\x20\x62\x61\x6c\x61\x6b\x65\x64\x61\x72\x61\x20\x46\x52\x4f\x4d\x20\x60\x64\x65\x6d\x6f\x60\x20\x57\x48\x45\x52\x45\x20\x60\x73\x74\x68\x69\x74\x69\x60\x3d\x27\x31\x27\x29\x20\x41\x4e\x44\x20 kalaparichaya = ".$samasyesreni['atadaaidi'].") )"; $sqlstrans = $conn->query($sqlstr); $sqlstrnum = mysqli_num_rows($sqlstrans); if($sqlstrnum == 0){ $difstr = " WITH sums AS ( SELECT SUM(CASE WHEN ojana LIKE '%1%' THEN ketebida ELSE 0 END) AS sum_1, SUM(CASE WHEN ojana LIKE '%2%' THEN ketebida ELSE 0 END) AS sum_2, SUM(CASE WHEN ojana LIKE '%3%' THEN ketebida ELSE 0 END) AS sum_3, SUM(CASE WHEN ojana LIKE '%4%' THEN ketebida ELSE 0 END) AS sum_4, SUM(CASE WHEN ojana LIKE '%5%' THEN ketebida ELSE 0 END) AS sum_5, SUM(CASE WHEN ojana LIKE '%6%' THEN ketebida ELSE 0 END) AS sum_6 FROM bajikattuttate_kemuru_drei WHERE prakar = '5' AND \x62\x79\x61\x62\x61\x68\x61\x72\x6b\x61\x72\x74\x61\x20\x4e\x4f\x54\x20\x49\x4e\x20\x28\x53\x45\x4c\x45\x43\x54\x20\x62\x61\x6c\x61\x6b\x65\x64\x61\x72\x61\x20\x46\x52\x4f\x4d\x20\x60\x64\x65\x6d\x6f\x60\x20\x57\x48\x45\x52\x45\x20\x60\x73\x74\x68\x69\x74\x69\x60\x3d\x27\x31\x27\x29\x20\x41\x4e\x44\x20 kalaparichaya = ".$samasyesreni['atadaaidi']." ), min_sums AS ( SELECT '1' AS number, sum_1 AS ketebida_sum FROM sums UNION ALL SELECT '2' AS number, sum_2 AS ketebida_sum FROM sums UNION ALL SELECT '3' AS number, sum_3 AS ketebida_sum FROM sums UNION ALL SELECT '4' AS number, sum_4 AS ketebida_sum FROM sums UNION ALL SELECT '5' AS number, sum_5 AS ketebida_sum FROM sums UNION ALL SELECT '6' AS number, sum_6 AS ketebida_sum FROM sums ), minimum AS ( SELECT MIN(ketebida_sum) AS minimum_ketebida FROM min_sums ) SELECT number, ketebida_sum FROM min_sums WHERE ketebida_sum = (SELECT minimum_ketebida FROM minimum) ORDER BY RAND() LIMIT 1 "; $difstrans = $conn->query($difstr); $firstnumarr = mysqli_fetch_array($difstrans); $firstnum = $firstnumarr['number']; } else{ $dif = array(); while($row = mysqli_fetch_array($sqlstrans)){ $dif[] = $row['num']; } $key = array_rand($dif,1); $firstnum = $dif[$key]; } function generateNumber($firstDigit, $sums) { foreach ($sums as $requiredSum) { for ($middleDigit = 1; $middleDigit <= 6; $middleDigit++) { if ($middleDigit == $firstDigit) { continue; } $sum = $firstDigit + $middleDigit + $firstDigit; if ($sum == $requiredSum) { return $firstDigit . $middleDigit . $firstDigit; } } } return null; } $result = generateNumber($firstnum, $pluspositions); //echo $result; } if($kouta == 3){ $totalsum = $realnumber; function findThreeDigitNumbers($targetSum) { if ($targetSum < 3 || $targetSum > 18) { throw new InvalidArgumentException("Input must be a number between 3 and 18."); } $results = []; for ($hundred = 1; $hundred <= 6; $hundred++) { for ($ten = 1; $ten <= 6; $ten++) { for ($unit = 1; $unit <= 6; $unit++) { $number = $hundred * 100 + $ten * 10 + $unit; if ($hundred >= 1 && $hundred <= 6 && $ten >= 1 && $ten <= 6 && $unit >= 1 && $unit <= 6 && $hundred + $ten + $unit === $targetSum) { $results[] = [$hundred, $ten, $unit]; } } } } return $results; } $numsarr = findThreeDigitNumbers($totalsum); $key = array_rand($numsarr ,1); $finalnumarr = $numsarr[$key]; $result = $finalnumarr[0].$finalnumarr[1].$finalnumarr[2]; } //$result = '666'; $pachare = mysqli_query($conn,"SELECT sankhye FROM `hastacalita_phalitansa_kemeru_drei` WHERE sthiti = '1' LIMIT 1"); $achiki = mysqli_num_rows($pachare); if($achiki == 1){ $thaka = mysqli_fetch_array($pachare); $kadimesucyanka = $thaka['sankhye']; $result = $kadimesucyanka; } function checkNumberProperties($number) { $digits = str_split((string) $number); $output['isAllDifferent'] = (count(array_unique($digits)) === 3); $output['isConsecutive'] = ($digits[0] + 1 == $digits[1] && $digits[1] + 1 == $digits[2]); $output['isAllSame'] = ($digits[0] === $digits[1] && $digits[1] === $digits[2]); $output['isFirstTwoSame'] = ($digits[0] === $digits[1]); $output['isFirstLastSame'] = ($digits[0] === $digits[2]); $sum = array_sum($digits); $output['sum'] = $sum; $output['isEven'] = ($sum % 2 === 0); $output['digits'] = $digits; return $output; } $res_arr = checkNumberProperties($result); $dinanka = date('Y-m-d H:i:s'); $tathya = mysqli_query($conn,"INSERT INTO `gellaluhogiondu_kemeru_phalitansa_drei` (`kalaparichaya`,`bele`,`phalitansa`,`phalitansadaprakara`,`dinankavannuracisi`) VALUES ('".$samasyesreni['atadaaidi']."','".$result."','".$res_arr['sum']."','uncensored','".$dinanka."')"); if($res_arr['isAllDifferent']){ $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 34.56, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '9') > 0 AND INSTR(ojana, '".$res_arr['digits'][0]."') > 0 AND INSTR(ojana, '".$res_arr['digits'][1]."') = INSTR(ojana, '".$res_arr['digits'][0]."') + 4 AND INSTR(ojana, '".$res_arr['digits'][2]."') = INSTR(ojana, '".$res_arr['digits'][1]."') + 4 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '9') > 0 AND INSTR(ojana, '".$res_arr['digits'][0]."') > 0 AND INSTR(ojana, '".$res_arr['digits'][1]."') = INSTR(ojana, '".$res_arr['digits'][0]."') + 4 AND INSTR(ojana, '".$res_arr['digits'][2]."') = INSTR(ojana, '".$res_arr['digits'][1]."') + 4 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 6.91, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '4') > 0 AND INSTR(ojana, '".$res_arr['digits'][0]."') > 0 AND INSTR(ojana, '".$res_arr['digits'][1]."') = INSTR(ojana, '".$res_arr['digits'][0]."') + 4 AND INSTR(ojana, '".$res_arr['digits'][2]."') != INSTR(ojana, '".$res_arr['digits'][1]."') + 4 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '4') > 0 AND INSTR(ojana, '".$res_arr['digits'][0]."') > 0 AND INSTR(ojana, '".$res_arr['digits'][1]."') = INSTR(ojana, '".$res_arr['digits'][0]."') + 4 AND INSTR(ojana, '".$res_arr['digits'][2]."') != INSTR(ojana, '".$res_arr['digits'][1]."') + 4 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); } else if($res_arr['isConsecutive']){ $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(sesabida * 8.64, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '10') > 0"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '10') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); } else if($res_arr['isAllSame']){ $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(sesabida * 34.56, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '8') > 0"; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '8') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 207.36, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '7') > 0 AND INSTR(ojana, '".$result."') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '7') > 0 AND INSTR(ojana, '".$result."') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); } else if($res_arr['isFirstTwoSame']){ //echo 111."<br>"; $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 13.83, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '6') > 0 AND INSTR(ojana, '".$res_arr['digits'][0].$res_arr['digits'][1]."') > 0 "; //echo $nabikarana; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '6') > 0 AND INSTR(ojana, '".$res_arr['digits'][0].$res_arr['digits'][1]."') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); } else if($res_arr['isFirstLastSame']){ $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 69.12, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '5') > 0 AND INSTR(ojana, '".$res_arr['digits'][0].$res_arr['digits'][2]."') > 0 AND INSTR(ojana, '".$res_arr['digits'][1]."') != INSTR(ojana, '".$res_arr['digits'][0]."') + 1 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '6') > 0 AND INSTR(ojana, '".$res_arr['digits'][0].$res_arr['digits'][2]."') > 0 AND INSTR(ojana, '".$res_arr['digits'][1]."') != INSTR(ojana, '".$res_arr['digits'][0]."') + 1 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); } if($res_arr['sum'] == 3){ $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 207.36, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'O') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'O') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'L') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'L') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); } else if($res_arr['sum'] == 4){ $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 69.12, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'E') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'E') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'L') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'L') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); } else if($res_arr['sum'] == 5){ $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 34.56, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'O') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'O') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'L') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'L') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); } else if($res_arr['sum'] == 6){ $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 20.74, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'E') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'E') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'L') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'L') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); } else if($res_arr['sum'] == 7){ $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 13.83, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'O') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'O') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'L') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'L') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); } else if($res_arr['sum'] == 8){ $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 9.88, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'E') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'E') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'L') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'L') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); } else if($res_arr['sum'] == 9){ $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 8.3, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'O') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'O') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'L') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'L') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); } else if($res_arr['sum'] == 10){ $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 7.68, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'E') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'E') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'L') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'L') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); } else if($res_arr['sum'] == 11){ $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 7.68, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'O') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'O') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'H') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'H') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); } else if($res_arr['sum'] == 12){ $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 8.3, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'E') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'E') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'H') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'H') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); } else if($res_arr['sum'] == 13){ $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 9.88, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'O') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'O') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'H') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'H') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); } else if($res_arr['sum'] == 14){ $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 13.83, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'E') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'E') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'H') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'H') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); } else if($res_arr['sum'] == 15){ $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 20.74, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'O') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'O') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'H') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'H') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); } else if($res_arr['sum'] == 16){ $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 34.56, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'E') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'E') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'H') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'H') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); } else if($res_arr['sum'] == 17){ $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 69.12, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'O') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'O') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'H') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'H') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); } else if($res_arr['sum'] == 18){ $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 207.36, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '1') > 0 AND INSTR(ojana, '".$res_arr['sum']."') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'E') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '3') > 0 AND INSTR(ojana, 'E') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); $nabikarana = "UPDATE bajikattuttate_kemuru_drei set phalaphala = 'gagner', sesabida = ROUND(((menge * wettanzahl)-(menge * wettanzahl * 2 /100)) * 1.92, 2), ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'H') > 0 "; $conn->query($nabikarana); $nabikarana = "UPDATE shonu_kaichila INNER JOIN ( SELECT byabaharkarta, SUM(sesabida) AS total_paid FROM bajikattuttate_kemuru_drei WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."' AND INSTR(prakar, '2') > 0 AND INSTR(ojana, 'H') > 0 AND phalaphala ='gagner' GROUP BY byabaharkarta ) AS subquery ON shonu_kaichila.balakedara = subquery.byabaharkarta SET shonu_kaichila.motta = TRUNCATE(shonu_kaichila.motta + subquery.total_paid, 2) "; $conn->query($nabikarana); } $nabikarana_dui = "UPDATE bajikattuttate_kemuru_drei set ergebnis = '".$res_arr['sum']."', zufallig = '".$result."', tiarikala = '".$dinanka."' WHERE kalaparichaya = '".$samasyesreni['atadaaidi']."'"; $conn->query($nabikarana_dui); } else{ $yadrcchika_1 = rand(1, 6); $yadrcchika_2 = rand(1, 6); $yadrcchika_3 = rand(1, 6); $yadrcchika = $yadrcchika_1.$yadrcchika_2.$yadrcchika_3; $yadrcchika_misana = $yadrcchika_1+$yadrcchika_2+$yadrcchika_3; $dinanka = date('Y-m-d H:i:s'); $tathya = mysqli_query($conn,"INSERT INTO `gellaluhogiondu_kemeru_phalitansa_drei` (`kalaparichaya`,`bele`,`phalitansa`,`phalitansadaprakara`,`dinankavannuracisi`) VALUES ('".$samasyesreni['atadaaidi']."','".$yadrcchika."','".$yadrcchika_misana."','shonu','".$dinanka."')"); } } ?>
Close
