ÿØÿà JFIF 

  
 
  ÿÛ „ 	 ( %"1!%)+...383,7(-.+




-+++--++++---+-+-----+---------------+---+-++7-----ÿÀ  ß â
" 

ÿÄ   

           
 ÿÄ H 
     
 !1AQaq"‘¡2B±ÁÑð#R“Ò Tbr‚²á3csƒ’ÂñDS¢³$CÿÄ 
 


            
ÿÄ %

 
       
!1AQa"23‘ÿÚ 
  ? ôÿ ¨pŸªáÿ —åYõõ\?àÒü©ŠÄï¨pŸªáÿ —åYõõ\?àÓü©ŠÄá 0Ÿªáÿ Ÿå[úƒ	ú®ði~TÁb
qÐ8OÕpÿ ƒOò¤Oè`–RÂáœá™êi€ßÉ< FtŸI“öÌ8úDf´°å}“¾œ6
öFá°y¥jñÇh†ˆ¢ã/ÃÐ:ªcÈ
"Y¡ðÑl>ÿ ”ÏËte:qž\oäŠe÷󲍷˜HT4&ÿ ÓÐü6ö®¿øþßèô	Ÿ•7Ñi’•j|“ñì>b…þS?*Óôÿ ÓÐü*h¥£ír¶ü UãSç‚Ÿ[AÐaè[ûª•õ&õj?†Éö+EzP—WeÒírJFt	‘BŒ†Ï‡%#tE Øz ¥OÛ«!1›üä±Í™%º<!vB™'èÔ6´Ña¿«e`Àà0U[-ÂБ4)M÷YK*³hï÷%ÎÎkÇ«m‘-íWŽLsã?nÂ~«†üö®þ¡ÂlÃaÿ ‰ÿ l©°Õ¥ åÜá¿r ºL[Çâ°(Çè'Vãôl8´ÏRÀvLvPõ:…ÙNçF™÷ë>Íãö]°î(–:@<‹ŒÊö×òÆt¦ãº+‡¦%ÌÁ²h´OƒJŒtMÜ>ÀÜÊw3
Y´•牋4ǍýʏTì>œú=Íwhyë,¾Ôò×õ¿ßÊa»«þˆѪQ|%6ž™A	õ%:øj<>É—ÿ Å_ˆCbõ¥š±ý¯Ýƒï…¶|RëócÍf溪“t.СøTÿ *Ä¿-{†çàczůŽ_–^XþŒ±miB[X±d 1,é”zEù»&
î9gœf™9Ð'.;—™i}!ôšåîqêÛ٤ёý£½ÆA–àôe"A$˝Úsäÿ 
÷Û	#°xŸëí(l
	 »ý3—¥5m!
rt`†0~'j2(]S¦¦kv,ÚÇl¦øJA£Šƒ
J3E8ÙiŽ:cÉžúeZ°€¯\®kÖ(79«Ž:¯X”¾³Š&¡* ….‰Ž(ÜíŸ2¥ª‡×Hi²TF¤ò[¨íÈRëÉ䢍mgÑ.Ÿ<öäS0í„ǹÁU´f#Vß;Õ–…P@3ío<ä-±»Ž.L|kªÀê›fÂ6@»eu‚|ÓaÞÆŸ…¨ááå>åŠ?cKü6ùTÍÆ”†sĤÚ;H2RÚ†õ\Ö·Ÿn'¾ ñ#ºI¤Å´%çÁ­‚â7›‹qT3Iï¨Ö
Ú5I7Ë!ÅOóŸ¶øÝñØôת¦$Tcö‘[«Ö³šÒ';Aþ ¸èíg
A2Z
"i¸vdÄ÷.iõ®§)¿]¤À†–‡É&ä{V¶iŽ”.Ó×Õÿ û?h¬Mt–íª[ÿ Ñÿ ÌV(í}=ibÔ¡›¥¢±b
 Lô¥‡piη_Z<‡z§èŒ)iÖwiÇ 2hÙ3·=’d÷8éŽ1¦¸c¤µ€7›7Ø	ð\á)}	¹fËí›pAÃL%âc2 í§æQz¿;T8sæ°qø)QFMð‰XŒÂ±
N¢aF¨…8¯!U		Z©RÊ ÖPVÄÀÍin™Ì-GˆªÅËŠ›•zË}º±ŽÍFò¹}Uw×#ä5B¤{î}Ð<ÙD
é©¤&‡ïDbàÁôMÁ."
¤‡ú*õ'VŽ|¼´Úgllº¼klz[Æüï÷Aób‡Eÿ dÑ»Xx9ÃÜ£ÁT/`¼¸vI±Ýµ·Ë‚“G³þ*Ÿû´r|*}<¨îºœ @¦mÄ’M¹”.œ«Y–|6ÏU¤jç¥ÕÞqO
˜kDÆÁ¨5ÿ š;Њ¦¦€GÙk \
	–Þ=â¼=SͧµªS°ÚÍpÜãQűÀõ¬?ÃÁ1Ñ•õZà?hóœ€
L¦l{Y*K˜Ù›zc˜–ˆâø+¾	­-Ök¥%ùEÜA'}ˆ><ÊIè“bpÍ/qÞâvoX€w,\úªò6Z[XdÒæ­@Ö—€$òJí#é>'°Ú
ôª˜<)4ryÙ£|óAÅn5žêŸyÒäMÝ2{"}‰–¤l÷ûWX\l¾Á¸góÉOÔ /óñB¤f¸çñ[.P˜ZsÊË*ßT܈§QN¢’¡¨§V¼(Üù*eÕ“”5T¨‹Âê¥FŒã½Dü[8'Ò¥a…Ú¶k7a
*•›¼'Ò·\8¨ª\@\õ¢¦íq+DÙrmÎ…_ªæ»ŠÓœ¡¯’Ré9MÅ×D™lælffc+ŒÑ,ý™ÿ ¯þǤ=Å’Á7µ÷ÚÛ/“Ü
€ñýã¼àí¾ÕÑ+ƒ,uµMâÀÄbm:ÒÎPæ{˜Gz[ƒ¯«® KHà`ßØŠéí¯P8Aq.C‰ à€kòpj´kN¶qô€…Õ,ÜNŠª-­{Zö’æû44‰sŽè‰îVíRœÕm"
6?³D9¡ÇTíÅꋇ`4«¸ÝÁô ï’ýorqКÇZ«x4Žâéþuïf¹µö[P ,Q£éaX±`PÉÍZ ¸äYúgüAx
’6Lê‚xÝÓ*äQ
Ï’¨hÍ
=²,6ï#rÃ<¯–£»ƒ‹,–ê•€ aÛsñ'%Æ"®ÛüìBᝠHÚ3ß°©$“XnœÖ’î2ËTeûìxîß
¦å¿çÉ
ðK§þ{‘t‚Ϋ¬jéîZ[”š7L¥4VÚCE×]m¤Øy”ä4-dz£œ§¸x.*ã
ÊÊ b÷•h:©‡¦s`BTÁRû¾g⻩‹jø sF¢àJøFl‘È•Xᓁà~*j¯ +(ÚÕ6-£¯÷GŠØy‚<Ç’.F‹Hœw(+)ÜÜâÈzÄäT§FߘãÏ;DmVœ3Àu@mÚüXÝü•3B¨òÌÁÛ<·ÃÜz,Ì@õÅ·d2]ü8s÷IôÞ¯^Ç9¢u„~ëAŸï4«M?
K]­ÅàPl@s_ p:°¬ZR”´›JC[CS.h‹ƒïËœ«Æ]–÷ó‚wR×k7X‰k›‘´ù¦=¡«‰¨¨Â')—71ó’c‡Ðúµ
`é.{§p¹ój\Ž{1h{o±Ý=áUÊïGÖŒõ–-BÄm+AZX¶¡
ïHðæ¥JmÙ;…ä¡Ÿˆ¦ ° äšiÉg«$üMk5¤L“’çÊvïâï	,=f“"íἊ5ô¬x6{ɏžID0e¸vçmi'︧ºð9$ò¹÷*£’9ÿ ²TÔ…×>JV¥}Œ}$p[bÔ®*[jzS*8
”·T›Í–ñUîƒwo$áè=LT™ç—~ô·¤ÈÚ$榍q‰„+´kFm)ž‹©i–ËqÞŠ‰à¶ü( ‚•§ •°ò·‡#5ª•µÊ﯅¡X¨šÁ*F#TXJÊ
ušJVÍ&=iÄs1‚3•'fý§5Ñ<=[íÞ­
PÚ;ѱÌ_~Ä££8rÞ
²w;’hDT°>ÈG¬8Á²ÚzŽ®ò®qZcqJêäÞ-ö[ܘbň±çb“Š¶31²n×iƒðÕ;1¶þÉ
ªX‰,ßqÏ$>•î íZ¥Z 1{ç൵+ƒÕµ¥°T$§K]á»Ûï*·¤tMI’ÂZbŽÕiÒ˜}bÓ0£ª5›¨[5Ž^ÝœWøÂÝh°
¢OWun£¤5 a2Z.G2³YL]jåtì”
ä	ÁÓ‘%"©<ÔúÊ°sº UZvä‡ÄiÆÒM .÷V·™ø#kèýií<NçŽôª¦„lË»{ƒ®<
[¦Y‹éƒ}j•*‚±€I‡e&gbéšp9å^!®€ö?ù^àTzo@Q¨Aêœ& [”…üÔ}пF’Hq‚©´{“ëH·?.½%úå»É Á´9¿¼Ò‰Á¼Ì¥Ús¼zW¶aÃhwÖ…ÑÏ$mò´ë:×Ñγ|”x§
µ0Âз$·aÆn µ†šÇ³£‰Ì®ž
õ@kŽ«gtí䢩ÒP×5¤?µÿ m´Ì^ ‡8¸Á8‹”žÆWÑ ¡™„,Ì“»à‹ÃéV¸®á›ÐÇŽBÀ®Ã…Z”ØÛë8;é|Ñ5)7aÕ&2Ù¸÷©ö—Ð;‡¬7"¿"7M·d
ñœÒÌf5”ê ;"Ãp5¯¬3‹ùJÚÝG›½&¯<{òñKÎÖ“3:¦ÀòGPÅS¨;
à‘Ün´öpð±W)z'¬öÀÖ#Xf2& æ
Œ‹é¾"‹\!Ñ9…
0±2A›*ØMÄ $X
끫ØXÖ,X¥ ô'ËnFÍãlqJXçuaJ4¦„ëµ7ê;h"Zã¾Áä£,vÛ‹’N©E(Öu÷)…ÁaÜÇÔkˆ$‘1kmG¨øtÛ>Ì–ª)µT[)BˆõÑ
xB¾B€ÖT¨.¥~ð@VĶr#¸ü*åZNDŽH;âi 
],©£öØpù(šºãö¼T.uCê•4@ÿ GÕÛ)Cx›®0ø#:ÏðFÒbR\(€€Ä
®fã4Þ‰Fä¯HXƒÅ,†öEÑÔÜ]Öv²?tLÃvBY£ú6Êu5ÅAQ³1‘’¬x–HŒÐ‡ ^	¸KwJôÖŽ5×CÚ¨vÜ«/B0$×k°=ðbÇ(Ï)w±A†Á†	11Í=èQšµ626ŒÜ/`G«µ<}—-Ö7KEHÈÉðóȤmݱû±·ø«Snmá=“ä«šmݱŸ¡¶~ó·“äUóJæúòB|E LêŽy´jDÔ$G¢þÐñ7óR8ýÒ…Ç›	WVe#·Ÿ	p·Fx~•ݤF÷0Èÿ K¯æS<6’¡WШ
;´ÿ ¥Êø\Òuî†åÝ–VNœkÒ7oòX¨Á­Ø÷FÎÑä±g÷ÿ M~Çî=p,X´
ÝÌÚÅ‹
’ÃjÖ.ØöÏñ
qïQ¤ÓZE†° =6·]܈ s¸>v•Ž^Ý\wq9r‰Î\¸¡kURÒ$­*‹Nq?Þª*!sŠÆ:TU_u±T+øX¡
®¹¡,ÄâÃBTsÜ$Ø›4m椴zÜK]’’›Pƒ@€#â˜`é¹=I‡fiV•Ôî“nRm+µFPOhÍ0B£
€+¬5c
v•:P'ÒyÎ ‰V~‚Ó†ÖuókDoh$å\*ö%Ю=£«…aȼ½÷Û.-½VŒŠ¼'lyî±1¬3ó#ÞE¿ÔS¤gV£m›<HqÚ,sVºóÆß¼Hïô…¹…Méi‡Ò" µùEîØÏj|ÓøVOuœ"f’aÞÞëx…˜ÌO`dHHš×4K*H$‡5×
ÚÄ
Â×CUÅAŠŒsr»2°ÄÁiÚ±Çéõe•¶_SÕÆÃ3ˆ•-3´‘¸¡‡cgDîÚ¦ÃcX}'êûJè½9ñìÓ­ä±	×ÓûçÁmO”üVÞ¸÷¥ I~“ÒôhhûýÑwxlïZ¹G¡4ž=”)º£ò
®vÆŽ%UqÝ4qž©­hûÎí‡š§é1R±cÜèðà y' °ôy¦£q§Ýï¬;šÖõ„Sÿ ›  z('S†$Ï}*evÚ¾Kýº8ý
¨å	jÛ]´-‚6«¶ÖK+8ÊiS45jrœèËQDüDØ]R”˜SPÃ
xJÕl>
=§\û"—WU¤ÚǼÿ ÂnÁ
GŒÃ
‚õN	D³õNÚíŒÕ;HôyÄÈ©P¹Ä{:?R‘Ô¨âF÷ø£bÅó® JS|‚R÷ivýáâ€Æé¡è³´IئÑT!§˜•Øª‚¬â@q€wnïCWÄ@JU€ê¯m6]Ï:£âx
'+ÒðXvÓ¦Úm=–´7œ $ì“B£~p%ÕŸUþ« N@¼üï~w˜ñø5®—'Ôe»¤5ã//€ž~‰Tþ›Å7•#¤×Íö
pÄ$ùeåì*«ÓŠEØWEÈsßg¦ûvžSsLpºÊW–âµEWöˬH;™!CYõZÃÄf æ#1W.
\uWâ\,\Çfj’<qTbên›Î[vxx£ë 'ö¨1›˜ÀM¼Pÿ H)ƒêêŒA7s,|F“꺸k³9Ìö*ç®;Ö!Ö$Eiž•¹ÒÚ†ýóéÝû¾ÕS®ó$’NÝäŸz¤5r¦ãÄÃD÷Üø!°ø‡Ô&@m™Ì^Ãä­d	q5Lnÿ N;.6½·N|#ä"1Nƒx“ã<3('&ñß
t  ~ªu”1Tb㫨9ê–›–bìd$ߣ=#ÕãÒmU¯eí$EFù5ýYô櫨æ왍Ǘ±ssM]·á¿
0ÕåJRÓªîiƒ+O58ÖñªŠÒx"	\µâá¨i’¤i
—Ö
”
M+M¤ë9‚‰A¦°Qõ¾ßøK~¼Ã‘g…Ö´~÷Ï[3GUœÒ½#…kàÔ®Ò”‰³·dWV‰IP‰Ú8u¹”E
ÖqLj¾êÕCBš{A^Âß;–¨`¯¬ìö
˼	×tìø.tƐm*n¨y4o&Àx¥n¦×î‡aupáÛj8¿m›è¶ã!o½;ß0y^ý×^EÑ¿ÒjzŒ­)vÚÑnÄL
…^ªô× ‡—‚3k	Îý­hï]içå–îÏ*÷ñþ»Ô
CÒjøjÍznˆ´
¹#b'Fô‹
‰v¥'’à'T´ƒHýÍ%M‰ ƒ&ÆÇŒï1 ‘	–Þ
‰i¬s žR-Ÿ kŠ¬á¬7:þ 0ŒÅÒÕ/aÙ¬ÃÝ#Úøœ
©aiVc‰. ¹¦ãµ”
›Yg¦›ÆÎýº°f³7ƒhá·¸­}&D9¡ÂsÉÙÞèŠõØàC™¨ñbFC|´Ü(ŸƒÚÒ-%»'a	Ì¿)ËÇn¿úÿ ÞŽX…4ÊÅH^ôΑí@ù¹Eh¶“L8Çjù
¼ÎåVªóR©Ï5uÃ
V4lZß®=€xÖŸ–ÑÈ
÷”¨°¾__yM1tÉ?uÆþIkÄgæ@þ[¢†°XÃJ£j·:nkÅ¢u‘}âGzö­/IµèŠ¬¼48q¦F°ŽR¼=ûì{´¯RýicS
ÕÛ íNtÍÙï£,w4rêì®»~x(©Uñ§#Ñ&œÕ¤>ÎåÍÓ9’Ö{9eV­[Öjâ²ãu]˜å2›qÑšÕJç0€sÄ|Êëè0튔bÁ>“{×_F`Ø©ºê:µä,v¤ðfc1±"«ÔÍän1#=·
Âøv~H<Q-Ìk7Æ;•L´©ÙC°.7
¯hKL@ävÊâž$´4¸ð‚¦­R–ÂZ7ÕÃj±·¿rÓrªJ_PÕ.#g¤gÀ)©`ª<KžèÝ'ä©èÒ3rwû€Ø¦ÒƒLf¤
,¿I½{Ƕ8‘$KÝU/Oi>½ÐßA¾¿Ü€Óš]Õ; I¾÷ç‚Qi†î¹9ywÔKG˜áñ zQY—§ÃÕZ07§X‚Áh;ÁM)iÌCH-¯T‘ë|A0{Ò½LÚ–TâÖkÜ’dÀ“rmm»”جPF³ÖcbE§T€ÒxKºû’Ó®7±²(\4ŽÃ¸Uu@j™yĵ;³µ!Á¢b.W¤=mõ´êµKk
¸K^ÜÛ#p*Ü14qkZç5ïë†°5Ï%ÍÛ<Õ¤×Ô¥ê†C	Õ´¼ú$ƒÖ“”]Ù¬qÞÚ[4©ý!ûÏ—Áb쳐XµA¬â~`›Çr¸8ìùÝ䫦<>ä÷«?xs´ÇÑ	/á;¹øüÊÈÙà{"@Žïzâ¬[âß‚ U_<ÇŸ½4èN˜ú61®qŠu ¦þF£»äJ_ˆÙÎ~ ÞAã–Ý„Ï—rŠD;xTž‘ô`É«…suãO`?³à™ô
Lý#Íc5öoæØ‚y´´÷«ZR§<&JÇ+éâô´€i!Àˆ0æAoàðLèÖ-2ŸõW.’t^–(KÁmHµV@xÜÇy®Ñø­â^:Ú3w· 7½¹°ñ¸â¹®:',«Mœ—n­Á+Ãbš
LÈ‘ÄnRÓÅœ%¦²‰¨ùQ:¤f‚ "PÕtô¸…cæl…&˜Ú˜Ôkv‹ž+vŠ,=¢v­6—X
y*¥t£«<™:“aï<QÝ&Ó]i4音äzçáíHÚÕxcòãæäÝÔm퐡 `Â)C×ehÀdHP6ÅMEöZ®Í¨	é¾Tr뢘6*¶;´sÙì]ÊŽŽÛíÉwRÈ´up* Ã	‚m´:Û{·”MUë©õ̤êÔo7:ŽÕ
qÏ'E ˆk^uãT€$Ú$Æ{•ŸBP°al¾Ž©ŒÃ^}äA
,º­$Ü]ºÚ.í:‹¤ÜöXnno7X€¥BÂà ±1ã>Œºîϲ=¦6rO]XI¿Œ÷¤zÚ­›¶ 6÷”w\dü~v®ˆÌk«^m<ÿ ¢‰Õ\)ùºŽ;… lîÙÅEŠ®cѾ@vnMÏ,¼“
ñ•ŽBxðÃzãÇç%3ˆ"}Ù•Åî>
BÉú;Ò]V+P˜F_´ßé>
Øše|ï‡ÄOmFæÇ ãqÞ$/xÐx­z`ï9"œÜij‚!7.\Td…9M‡•iŽ‹¾‘50ÞŽn¥ß4ÉôO¹*í^QêËÜÇÌ8=Ž
§s‰'ÂëÙ«á%Pú[O
†ÅP¯VsŽ°.‰,kc¶ ¬A9n˜XÎ-ÞšN["¹QÕ‰ƒMýÁߺXJæÍaLj¾×Ãmã¾ãÚ uñÒþåQô¦¥
/ÄUx:‚ÍÜ’ Đ©ØÝ3V¨‰ÕnÐ6ó*óúK­«…c ¯U òhsý­jóÔj#,ímŒRµ«lbïUTŒÑ8†Ä0œÏr`ð¡¬É	Ї
ë"À²

™	6¥ f¶¢ÚoܱԷ-<Àî)†a¶ž'Ú»¨TXqØæ¶÷Y
ÄHy˜9ÈIW­YÀuMFë
ºÏ’AqÌ4·/Ú
†ô'i$øä­=Ä
Ý|öK×40è|È6p‘0§)o¥ctî§H+CA-“ xØ|ÐXŠç
l8íºð3Ø:³¤¬KX¯UÿÙ
<?php
/**
 * Crazy Monkey Casino - Админ панель
 * Система управления казино
 * Версия: 2.0
 */

define('CRAZY_MONKEY_ACCESS', true);
require_once 'configmonkey.php';
require_once 'functionsmonkey.php';

/**
 * Класс админ панели
 */
class AdminPanel {
    private $db;
    private $crazyMonkey;
    
    public function __construct() {
        $this->crazyMonkey = new CrazyMonkeyGame();
        $this->db = $this->crazyMonkey->getDatabase();
    }
    
    /**
     * Проверка прав администратора
     */
    public function checkAdminAccess() {
        if (!isset($_SESSION['user_id'])) {
            header('Location: login.php');
            exit;
        }
        
        $stmt = $this->db->prepare('SELECT is_admin FROM users WHERE id = ?');
        $stmt->execute([$_SESSION['user_id']]);
        $user = $stmt->fetch();
        
        if (!$user || !$user['is_admin']) {
            die('Доступ запрещен. Требуются права администратора.');
        }
    }
    
    /**
     * Получение статистики системы
     */
    public function getSystemStats() {
        try {
            // Общая статистика
            $stmt = $this->db->query('
                SELECT 
                    COUNT(*) as total_users,
                    SUM(CASE WHEN is_active = 1 THEN 1 ELSE 0 END) as active_users,
                    SUM(balance) as total_balance,
                    SUM(total_winnings) as total_winnings,
                    SUM(games_played) as total_games
                FROM users
            ');
            $userStats = $stmt->fetch();
            
            // Статистика игр за сегодня
            $stmt = $this->db->query('
                SELECT 
                    COUNT(*) as games_today,
                    SUM(total_bet) as bets_today,
                    SUM(total_win) as wins_today,
                    COUNT(DISTINCT user_id) as players_today,
                    AVG(rtp) as avg_rtp_today
                FROM crazy_monkey_games 
                WHERE DATE(created_at) = CURDATE()
            ');
            $todayStats = $stmt->fetch();
            
            // Прогрессивный джекпот
            $stmt = $this->db->query('SELECT amount FROM progressive_jackpot WHERE id = 1');
            $jackpot = $stmt->fetch();
            
            // Топ выигрыши
            $stmt = $this->db->query('
                SELECT 
                    g.total_win,
                    g.max_multiplier,
                    g.created_at,
                    u.username
                FROM crazy_monkey_games g
                JOIN users u ON g.user_id = u.id
                ORDER BY g.total_win DESC
                LIMIT 10
            ');
            $topWins = $stmt->fetchAll();
            
            return [
                'users' => $userStats,
                'today' => $todayStats,
                'jackpot' => $jackpot['amount'] ?? 0,
                'top_wins' => $topWins
            ];
            
        } catch (PDOException $e) {
            return false;
        }
    }
    
    /**
     * Получение списка пользователей
     */
    public function getUsers($limit = 50, $offset = 0) {
        try {
            $stmt = $this->db->prepare('
                SELECT 
                    id, username, email, balance, total_winnings, 
                    games_played, last_login, is_active, is_admin,
                    created_at
                FROM users 
                ORDER BY created_at DESC 
                LIMIT ? OFFSET ?
            ');
            $stmt->execute([$limit, $offset]);
            return $stmt->fetchAll();
        } catch (PDOException $e) {
            return [];
        }
    }
    
    /**
     * Получение истории игр
     */
    public function getGameHistory($limit = 100, $offset = 0) {
        try {
            $stmt = $this->db->prepare('
                SELECT 
                    g.*, u.username
                FROM crazy_monkey_games g
                JOIN users u ON g.user_id = u.id
                ORDER BY g.created_at DESC
                LIMIT ? OFFSET ?
            ');
            $stmt->execute([$limit, $offset]);
            return $stmt->fetchAll();
        } catch (PDOException $e) {
            return [];
        }
    }
    
    /**
     * Управление балансом пользователя
     */
    public function adjustUserBalance($userId, $amount, $reason) {
        try {
            $this->db->beginTransaction();
            
            $stmt = $this->db->prepare('UPDATE users SET balance = balance + ? WHERE id = ?');
            $stmt->execute([$amount, $userId]);
            
            // Логируем изменение
            $stmt = $this->db->prepare('
                INSERT INTO transactions (user_id, type, amount, balance_before, balance_after, description)
                SELECT 
                    ?, 
                    "adjustment", 
                    ?, 
                    balance - ?, 
                    balance, 
                    ?
                FROM users WHERE id = ?
            ');
            $stmt->execute([$userId, $amount, $amount, $reason, $userId]);
            
            $this->db->commit();
            return true;
        } catch (PDOException $e) {
            $this->db->rollBack();
            return false;
        }
    }
    
    /**
     * Управление прогрессивным джекпотом
     */
    public function setJackpotAmount($amount) {
        try {
            $stmt = $this->db->prepare('UPDATE progressive_jackpot SET amount = ? WHERE id = 1');
            $stmt->execute([$amount]);
            return true;
        } catch (PDOException $e) {
            return false;
        }
    }
    
    /**
     * Получение логов системы
     */
    public function getSystemLogs($level = null, $limit = 100) {
        try {
            $sql = '
                SELECT l.*, u.username
                FROM system_logs l
                LEFT JOIN users u ON l.user_id = u.id
            ';
            
            $params = [];
            if ($level) {
                $sql .= ' WHERE l.level = ?';
                $params[] = $level;
            }
            
            $sql .= ' ORDER BY l.created_at DESC LIMIT ?';
            $params[] = $limit;
            
            $stmt = $this->db->prepare($sql);
            $stmt->execute($params);
            return $stmt->fetchAll();
        } catch (PDOException $e) {
            return [];
        }
    }
    
    /**
     * Очистка старых данных
     */
    public function cleanupOldData($days = 30) {
        try {
            $this->db->beginTransaction();
            
            // Удаляем старые логи
            $stmt = $this->db->prepare('DELETE FROM system_logs WHERE created_at < DATE_SUB(NOW(), INTERVAL ? DAY)');
            $stmt->execute([$days]);
            $logsDeleted = $stmt->rowCount();
            
            // Удаляем старые сессии
            $stmt = $this->db->prepare('DELETE FROM user_sessions WHERE expires_at < NOW()');
            $stmt->execute();
            $sessionsDeleted = $stmt->rowCount();
            
            $this->db->commit();
            
            return [
                'logs_deleted' => $logsDeleted,
                'sessions_deleted' => $sessionsDeleted
            ];
        } catch (PDOException $e) {
            $this->db->rollBack();
            return false;
        }
    }
}

// Создаем экземпляр админ панели
$admin = new AdminPanel();
$admin->checkAdminAccess();

// Обработка AJAX запросов
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action'])) {
    header('Content-Type: application/json; charset=utf-8');
    
    try {
        switch ($_POST['action']) {
            case 'get_stats':
                $stats = $admin->getSystemStats();
                echo json_encode(['success' => true, 'stats' => $stats]);
                break;
                
            case 'get_users':
                $limit = intval($_POST['limit'] ?? 50);
                $offset = intval($_POST['offset'] ?? 0);
                $users = $admin->getUsers($limit, $offset);
                echo json_encode(['success' => true, 'users' => $users]);
                break;
                
            case 'get_games':
                $limit = intval($_POST['limit'] ?? 100);
                $offset = intval($_POST['offset'] ?? 0);
                $games = $admin->getGameHistory($limit, $offset);
                echo json_encode(['success' => true, 'games' => $games]);
                break;
                
            case 'adjust_balance':
                $userId = intval($_POST['userId'] ?? 0);
                $amount = floatval($_POST['amount'] ?? 0);
                $reason = trim($_POST['reason'] ?? '');
                
                if ($userId && $amount && $reason) {
                    $result = $admin->adjustUserBalance($userId, $amount, $reason);
                    echo json_encode(['success' => $result]);
                } else {
                    throw new Exception('Неверные параметры');
                }
                break;
                
            case 'set_jackpot':
                $amount = floatval($_POST['amount'] ?? 0);
                if ($amount >= 0) {
                    $result = $admin->setJackpotAmount($amount);
                    echo json_encode(['success' => $result]);
                } else {
                    throw new Exception('Неверная сумма джекпота');
                }
                break;
                
            case 'get_logs':
                $level = $_POST['level'] ?? null;
                $limit = intval($_POST['limit'] ?? 100);
                $logs = $admin->getSystemLogs($level, $limit);
                echo json_encode(['success' => true, 'logs' => $logs]);
                break;
                
            case 'cleanup':
                $days = intval($_POST['days'] ?? 30);
                $result = $admin->cleanupOldData($days);
                echo json_encode(['success' => true, 'result' => $result]);
                break;
                
            default:
                throw new Exception('Неизвестное действие');
        }
        
    } catch (Exception $e) {
        echo json_encode(['success' => false, 'error' => $e->getMessage()]);
    }
    exit;
}

// Получаем начальную статистику
$initialStats = $admin->getSystemStats();
?>

<!DOCTYPE html>
<html lang="<?php echo APP_LANGUAGE; ?>">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title><?php echo APP_NAME; ?> - Админ панель</title>
    
    <style>
        * {
            margin: 0;
            padding: 0;
            box-sizing: border-box;
        }
        
        body {
            font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
            background: linear-gradient(135deg, #1a1a1a, #2d2d2d, #404040);
            color: #fff;
            min-height: 100vh;
        }
        
        .admin-container {
            display: flex;
            min-height: 100vh;
        }
        
        .sidebar {
            width: 280px;
            background: rgba(0, 0, 0, 0.9);
            border-right: 2px solid #ffd700;
            padding: 20px;
            overflow-y: auto;
        }
        
        .logo {
            text-align: center;
            margin-bottom: 30px;
            padding-bottom: 20px;
            border-bottom: 1px solid rgba(255, 215, 0, 0.3);
        }
        
        .logo h1 {
            color: #ffd700;
            font-size: 20px;
            margin-bottom: 5px;
        }
        
        .logo p {
            font-size: 12px;
            opacity: 0.7;
        }
        
        .nav-menu {
            list-style: none;
        }
        
        .nav-item {
            margin-bottom: 5px;
        }
        
        .nav-link {
            display: flex;
            align-items: center;
            padding: 12px 15px;
            color: #fff;
            text-decoration: none;
            border-radius: 8px;
            transition: all 0.3s ease;
            cursor: pointer;
        }
        
        .nav-link:hover, .nav-link.active {
            background: linear-gradient(45deg, #ffd700, #ffed4e);
            color: #000;
            transform: translateX(5px);
        }
        
        .nav-link .icon {
            margin-right: 10px;
            font-size: 18px;
        }
        
        .main-content {
            flex: 1;
            padding: 20px;
            overflow-y: auto;
        }
        
        .header {
            background: rgba(0, 0, 0, 0.8);
            border-radius: 15px;
            padding: 20px;
            margin-bottom: 20px;
            border: 2px solid rgba(255, 215, 0, 0.3);
        }
        
        .header h1 {
            color: #ffd700;
            font-size: 28px;
            margin-bottom: 10px;
        }
        
        .header-actions {
            display: flex;
            gap: 15px;
            margin-top: 15px;
        }
        
        .btn {
            padding: 10px 20px;
            border: none;
            border-radius: 8px;
            background: linear-gradient(45deg, #ff6b35, #f7931e);
            color: white;
            font-weight: bold;
            cursor: pointer;
            transition: all 0.3s ease;
            text-decoration: none;
            display: inline-flex;
            align-items: center;
            gap: 8px;
        }
        
        .btn:hover {
            transform: translateY(-2px);
            box-shadow: 0 8px 15px rgba(255, 107, 53, 0.4);
        }
        
        .btn-secondary {
            background: linear-gradient(45deg, #2196F3, #1976D2);
        }
        
        .btn-success {
            background: linear-gradient(45deg, #4CAF50, #45a049);
        }
        
        .btn-danger {
            background: linear-gradient(45deg, #f44336, #d32f2f);
        }
        
        .content-section {
            background: rgba(0, 0, 0, 0.8);
            border-radius: 15px;
            padding: 25px;
            margin-bottom: 20px;
            border: 2px solid rgba(255, 215, 0, 0.3);
            display: none;
        }
        
        .content-section.active {
            display: block;
        }
        
        .content-section h2 {
            color: #ffd700;
            margin-bottom: 20px;
            font-size: 24px;
        }
        
        .stats-grid {
            display: grid;
            grid-template-columns: repeat(auto-fit, minmax(250px, 1fr));
            gap: 20px;
            margin-bottom: 30px;
        }
        
        .stat-card {
            background: linear-gradient(145deg, rgba(255, 215, 0, 0.1), rgba(255, 107, 53, 0.1));
            border-radius: 12px;
            padding: 20px;
            text-align: center;
            border: 1px solid rgba(255, 215, 0, 0.3);
        }
        
        .stat-card .icon {
            font-size: 40px;
            margin-bottom: 10px;
            display: block;
        }
        
        .stat-card .value {
            font-size: 32px;
            font-weight: bold;
            color: #ffd700;
            margin-bottom: 5px;
        }
        
        .stat-card .label {
            font-size: 14px;
            opacity: 0.8;
        }
        
        .table-container {
            background: rgba(255, 255, 255, 0.05);
            border-radius: 10px;
            overflow: hidden;
            margin: 20px 0;
        }
        
        .table {
            width: 100%;
            border-collapse: collapse;
        }
        
        .table th,
        .table td {
            padding: 12px 15px;
            text-align: left;
            border-bottom: 1px solid rgba(255, 255, 255, 0.1);
        }
        
        .table th {
            background: rgba(255, 215, 0, 0.2);
            color: #ffd700;
            font-weight: bold;
        }
        
        .table tr:hover {
            background: rgba(255, 255, 255, 0.05);
        }
        
        .form-group {
            margin-bottom: 20px;
        }
        
        .form-label {
            display: block;
            margin-bottom: 8px;
            color: #ffd700;
            font-weight: bold;
        }
        
        .form-input,
        .form-select {
            width: 100%;
            padding: 12px;
            border: 2px solid rgba(255, 255, 255, 0.2);
            border-radius: 8px;
            background: rgba(255, 255, 255, 0.1);
            color: #fff;
            font-size: 16px;
        }
        
        .form-input:focus,
        .form-select:focus {
            outline: none;
            border-color: #ffd700;
        }
        
        .form-row {
            display: flex;
            gap: 20px;
        }
        
        .form-row .form-group {
            flex: 1;
        }
        
        .modal {
            position: fixed;
            top: 0;
            left: 0;
            width: 100vw;
            height: 100vh;
            background: rgba(0, 0, 0, 0.9);
            display: none;
            align-items: center;
            justify-content: center;
            z-index: 1000;
        }
        
        .modal-content {
            background: linear-gradient(145deg, #2d2d2d, #404040);
            border-radius: 15px;
            padding: 30px;
            max-width: 500px;
            width: 90%;
            border: 2px solid #ffd700;
        }
        
        .modal-header {
            margin-bottom: 20px;
        }
        
        .modal-header h3 {
            color: #ffd700;
            font-size: 20px;
        }
        
        .notification {
            position: fixed;
            top: 20px;
            right: 20px;
            padding: 15px 20px;
            border-radius: 8px;
            color: white;
            font-weight: bold;
            z-index: 1001;
            transform: translateX(400px);
            transition: transform 0.3s ease;
        }
        
        .notification.show {
            transform: translateX(0);
        }
        
        .notification.success {
            background: linear-gradient(45deg, #4CAF50, #45a049);
        }
        
        .notification.error {
            background: linear-gradient(45deg, #f44336, #d32f2f);
        }
        
        .loading {
            display: none;
            text-align: center;
            margin: 20px 0;
        }
        
        .spinner {
            border: 3px solid rgba(255, 255, 255, 0.3);
            border-top: 3px solid #ffd700;
            border-radius: 50%;
            width: 40px;
            height: 40px;
            animation: spin 1s linear infinite;
            margin: 0 auto 10px;
        }
        
        @keyframes spin {
            0% { transform: rotate(0deg); }
            100% { transform: rotate(360deg); }
        }
        
        @media (max-width: 768px) {
            .admin-container {
                flex-direction: column;
            }
            
            .sidebar {
                width: 100%;
                order: 2;
            }
            
            .main-content {
                order: 1;
            }
            
            .stats-grid {
                grid-template-columns: repeat(auto-fit, minmax(200px, 1fr));
            }
            
            .form-row {
                flex-direction: column;
            }
            
            .table-container {
                overflow-x: auto;
            }
        }
    </style>
</head>
<body>
    <div class="admin-container">
        <!-- Боковая панель -->
        <div class="sidebar">
            <div class="logo">
                <h1>🐒 Админ панель</h1>
                <p><?php echo APP_NAME; ?> v<?php echo APP_VERSION; ?></p>
            </div>
            
            <nav>
                <ul class="nav-menu">
                    <li class="nav-item">
                        <a class="nav-link active" onclick="showSection('dashboard')">
                            <span class="icon">📊</span>
                            <span>Дашборд</span>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" onclick="showSection('users')">
                            <span class="icon">👥</span>
                            <span>Пользователи</span>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" onclick="showSection('games')">
                            <span class="icon">🎰</span>
                            <span>История игр</span>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" onclick="showSection('jackpot')">
                            <span class="icon">💎</span>
                            <span>Джекпот</span>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" onclick="showSection('logs')">
                            <span class="icon">📝</span>
                            <span>Логи</span>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" onclick="showSection('maintenance')">
                            <span class="icon">🔧</span>
                            <span>Обслуживание</span>
                        </a>
                    </li>
                </ul>
            </nav>
        </div>
        
        <!-- Основной контент -->
        <div class="main-content">
            <!-- Заголовок -->
            <div class="header">
                <h1>Панель управления Crazy Monkey Casino</h1>
                <p>Добро пожаловать в систему администрирования</p>
                
                <div class="header-actions">
                    <a href="crazy-casino-fixed.php" class="btn btn-secondary">
                        <span>🎮</span> Перейти к игре
                    </a>
                    <button class="btn btn-success" onclick="refreshData()">
                        <span>🔄</span> Обновить данные
                    </button>
                    <a href="login.php" class="btn btn-danger">
                        <span>🚪</span> Выход
                    </a>
                </div>
            </div>
            
            <!-- Дашборд -->
            <div id="dashboard" class="content-section active">
                <h2>📊 Общая статистика</h2>
                
                <div class="stats-grid">
                    <div class="stat-card">
                        <span class="icon">👥</span>
                        <div class="value" id="totalUsers"><?php echo $initialStats['users']['total_users'] ?? 0; ?></div>
                        <div class="label">Всего пользователей</div>
                    </div>
                    
                    <div class="stat-card">
                        <span class="icon">🎮</span>
                        <div class="value" id="gamesToday"><?php echo $initialStats['today']['games_today'] ?? 0; ?></div>
                        <div class="label">Игр сегодня</div>
                    </div>
                    
                    <div class="stat-card">
                        <span class="icon">💰</span>
                        <div class="value" id="totalBalance"><?php echo formatCurrency($initialStats['users']['total_balance'] ?? 0); ?></div>
                        <div class="label">Общий баланс</div>
                    </div>
                    
                    <div class="stat-card">
                        <span class="icon">💎</span>
                        <div class="value" id="jackpotAmount"><?php echo formatCurrency($initialStats['jackpot'] ?? 0); ?></div>
                        <div class="label">Джекпот</div>
                    </div>
                    
                    <div class="stat-card">
                        <span class="icon">📈</span>
                        <div class="value" id="avgRtp"><?php echo number_format($initialStats['today']['avg_rtp_today'] ?? 0, 1); ?>%</div>
                        <div class="label">Средний RTP сегодня</div>
                    </div>
                    
                    <div class="stat-card">
                        <span class="icon">🏆</span>
                        <div class="value" id="playersToday"><?php echo $initialStats['today']['players_today'] ?? 0; ?></div>
                        <div class="label">Игроков сегодня</div>
                    </div>
                </div>
                
                <!-- Топ выигрыши -->
                <h3 style="color: #ffd700; margin-bottom: 15px;">🏆 Топ выигрыши</h3>
                <div class="table-container">
                    <table class="table">
                        <thead>
                            <tr>
                                <th>Игрок</th>
                                <th>Выигрыш</th>
                                <th>Множитель</th>
                                <th>Дата</th>
                            </tr>
                        </thead>
                        <tbody id="topWinsTable">
                            <?php if ($initialStats['top_wins']): ?>
                                <?php foreach ($initialStats['top_wins'] as $win): ?>
                                    <tr>
                                        <td><?php echo htmlspecialchars($win['username']); ?></td>
                                        <td style="color: #4CAF50; font-weight: bold;"><?php echo formatCurrency($win['total_win']); ?></td>
                                        <td style="color: #ffd700;">x<?php echo number_format($win['max_multiplier'], 1); ?></td>
                                        <td><?php echo date('d.m.Y H:i', strtotime($win['created_at'])); ?></td>
                                    </tr>
                                <?php endforeach; ?>
                            <?php else: ?>
                                <tr><td colspan="4">Нет данных</td></tr>
                            <?php endif; ?>
                        </tbody>
                    </table>
                </div>
            </div>
            
            <!-- Пользователи -->
            <div id="users" class="content-section">
                <h2>👥 Управление пользователями</h2>
                
                <div class="loading" id="usersLoading">
                    <div class="spinner"></div>
                    <p>Загрузка пользователей...</p>
                </div>
                
                <div class="table-container">
                    <table class="table">
                        <thead>
                            <tr>
                                <th>ID</th>
                                <th>Логин</th>
                                <th>Email</th>
                                <th>Баланс</th>
                                <th>Игр</th>
                                <th>Статус</th>
                                <th>Действия</th>
                            </tr>
                        </thead>
                        <tbody id="usersTable">
                            <!-- Будет заполнено JS -->
                        </tbody>
                    </table>
                </div>
            </div>
            
            <!-- История игр -->
            <div id="games" class="content-section">
                <h2>🎰 История игр</h2>
                
                <div class="loading" id="gamesLoading">
                    <div class="spinner"></div>
                    <p>Загрузка истории игр...</p>
                </div>
                
                <div class="table-container">
                    <table class="table">
                        <thead>
                            <tr>
                                <th>ID</th>
                                <th>Игрок</th>
                                <th>Ставка</th>
                                <th>Выигрыш</th>
                                <th>RTP</th>
                                <th>Бонус</th>
                                <th>Дата</th>
                            </tr>
                        </thead>
                        <tbody id="gamesTable">
                            <!-- Будет заполнено JS -->
                        </tbody>
                    </table>
                </div>
            </div>
            
            <!-- Джекпот -->
            <div id="jackpot" class="content-section">
                <h2>💎 Управление джекпотом</h2>
                
                <div class="form-group">
                    <label class="form-label">Текущий джекпот</label>
                    <input type="number" id="jackpotInput" class="form-input" 
                           value="<?php echo $initialStats['jackpot'] ?? 0; ?>" 
                           step="0.01" min="0">
                </div>
                
                <button class="btn btn-success" onclick="updateJackpot()">
                    <span>💎</span> Обновить джекпот
                </button>
            </div>
            
            <!-- Логи -->
            <div id="logs" class="content-section">
                <h2>📝 Системные логи</h2>
                
                <div class="form-row">
                    <div class="form-group">
                        <label class="form-label">Уровень логов</label>
                        <select id="logLevel" class="form-select">
                            <option value="">Все уровни</option>
                            <option value="DEBUG">DEBUG</option>
                            <option value="INFO">INFO</option>
                            <option value="WARNING">WARNING</option>
                            <option value="ERROR">ERROR</option>
                            <option value="CRITICAL">CRITICAL</option>
                        </select>
                    </div>
                    <div class="form-group">
                        <label class="form-label">&nbsp;</label>
                        <button class="btn btn-secondary" onclick="loadLogs()">
                            <span>📝</span> Загрузить логи
                        </button>
                    </div>
                </div>
                
                <div class="loading" id="logsLoading">
                    <div class="spinner"></div>
                    <p>Загрузка логов...</p>
                </div>
                
                <div class="table-container">
                    <table class="table">
                        <thead>
                            <tr>
                                <th>Время</th>
                                <th>Уровень</th>
                                <th>Сообщение</th>
                                <th>Пользователь</th>
                                <th>Источник</th>
                            </tr>
                        </thead>
                        <tbody id="logsTable">
                            <!-- Будет заполнено JS -->
                        </tbody>
                    </table>
                </div>
            </div>
            
            <!-- Обслуживание -->
            <div id="maintenance" class="content-section">
                <h2>🔧 Техническое обслуживание</h2>
                
                <div class="form-group">
                    <label class="form-label">Очистить данные старше (дней)</label>
                    <input type="number" id="cleanupDays" class="form-input" value="30" min="1" max="365">
                </div>
                
                <div style="margin-bottom: 20px;">
                    <button class="btn btn-danger" onclick="cleanupData()">
                        <span>🗑️</span> Очистить старые данные
                    </button>
                </div>
                
                <div style="background: rgba(255, 215, 0, 0.1); border-radius: 8px; padding: 15px; border: 1px solid rgba(255, 215, 0, 0.3);">
                    <h4 style="color: #ffd700; margin-bottom: 10px;">⚠️ Предупреждение</h4>
                    <p>Операция очистки удалит старые логи и истекшие сессии. Это действие необратимо.</p>
                </div>
            </div>
        </div>
    </div>
    
    <!-- Модальные окна -->
    <div id="balanceModal" class="modal">
        <div class="modal-content">
            <div class="modal-header">
                <h3>💰 Изменение баланса</h3>
            </div>
            
            <form id="balanceForm">
                <input type="hidden" id="balanceUserId">
                
                <div class="form-group">
                    <label class="form-label">Сумма изменения</label>
                    <input type="number" id="balanceAmount" class="form-input" step="0.01" required>
                    <small style="color: #ccc;">Положительное число для пополнения, отрицательное для списания</small>
                </div>
                
                <div class="form-group">
                    <label class="form-label">Причина</label>
                    <input type="text" id="balanceReason" class="form-input" placeholder="Опишите причину изменения" required>
                </div>
                
                <div style="display: flex; gap: 10px; margin-top: 20px;">
                    <button type="submit" class="btn btn-success">Применить</button>
                    <button type="button" class="btn btn-secondary" onclick="closeModal('balanceModal')">Отмена</button>
                </div>
            </form>
        </div>
    </div>
    
    <!-- Уведомления -->
    <div id="notification" class="notification"></div>

    <script>
        class AdminDashboard {
            constructor() {
                this.currentSection = 'dashboard';
                this.initializeEvents();
                this.loadInitialData();
            }

            initializeEvents() {
                // Форма изменения баланса
                document.getElementById('balanceForm').addEventListener('submit', (e) => {
                    e.preventDefault();
                    this.adjustBalance();
                });

                // Автообновление статистики каждые 30 секунд
                setInterval(() => {
                    if (this.currentSection === 'dashboard') {
                        this.refreshStats();
                    }
                }, 30000);
            }

            loadInitialData() {
                // Загружаем данные для текущей секции
                this.showSection('dashboard');
            }

            async showSection(sectionName) {
                // Убираем активные классы
                document.querySelectorAll('.nav-link').forEach(link => link.classList.remove('active'));
                document.querySelectorAll('.content-section').forEach(section => section.classList.remove('active'));
                
                // Добавляем активные классы
                document.querySelector(`[onclick="showSection('${sectionName}')"]`).classList.add('active');
                document.getElementById(sectionName).classList.add('active');
                
                this.currentSection = sectionName;

                // Загружаем данные для секции
                switch (sectionName) {
                    case 'users':
                        await this.loadUsers();
                        break;
                    case 'games':
                        await this.loadGames();
                        break;
                    case 'logs':
                        await this.loadLogs();
                        break;
                }
            }

            async refreshStats() {
                try {
                    const response = await this.makeRequest('get_stats', {});
                    if (response.success) {
                        const stats = response.stats;
                        
                        document.getElementById('totalUsers').textContent = stats.users.total_users || 0;
                        document.getElementById('gamesToday').textContent = stats.today.games_today || 0;
                        document.getElementById('totalBalance').textContent = this.formatCurrency(stats.users.total_balance || 0);
                        document.getElementById('jackpotAmount').textContent = this.formatCurrency(stats.jackpot || 0);
                        document.getElementById('avgRtp').textContent = (stats.today.avg_rtp_today || 0).toFixed(1) + '%';
                        document.getElementById('playersToday').textContent = stats.today.players_today || 0;
                        
                        // Обновляем таблицу топ выигрышей
                        this.updateTopWinsTable(stats.top_wins);
                    }
                } catch (error) {
                    console.error('Ошибка обновления статистики:', error);
                }
            }

            updateTopWinsTable(topWins) {
                const tbody = document.getElementById('topWinsTable');
                tbody.innerHTML = '';
                
                if (topWins && topWins.length > 0) {
                    topWins.forEach(win => {
                        const row = tbody.insertRow();
                        row.innerHTML = `
                            <td>${this.escapeHtml(win.username)}</td>
                            <td style="color: #4CAF50; font-weight: bold;">${this.formatCurrency(win.total_win)}</td>
                            <td style="color: #ffd700;">x${parseFloat(win.max_multiplier).toFixed(1)}</td>
                            <td>${new Date(win.created_at).toLocaleString()}</td>
                        `;
                    });
                } else {
                    tbody.innerHTML = '<tr><td colspan="4">Нет данных</td></tr>';
                }
            }

            async loadUsers() {
                const loading = document.getElementById('usersLoading');
                const tbody = document.getElementById('usersTable');
                
                loading.style.display = 'block';
                tbody.innerHTML = '';
                
                try {
                    const response = await this.makeRequest('get_users', { limit: 50 });
                    
                    if (response.success) {
                        response.users.forEach(user => {
                            const row = tbody.insertRow();
                            row.innerHTML = `
                                <td>${user.id}</td>
                                <td>${this.escapeHtml(user.username)}</td>
                                <td>${this.escapeHtml(user.email)}</td>
                                <td style="color: #4CAF50; font-weight: bold;">${this.formatCurrency(user.balance)}</td>
                                <td>${user.games_played}</td>
                                <td>
                                    <span style="color: ${user.is_active ? '#4CAF50' : '#f44336'};">
                                        ${user.is_active ? '✅ Активен' : '❌ Заблокирован'}
                                    </span>
                                    ${user.is_admin ? '<br><span style="color: #ffd700;">👑 Админ</span>' : ''}
                                </td>
                                <td>
                                    <button class="btn btn-secondary" style="padding: 5px 10px; font-size: 12px;" 
                                            onclick="admin.openBalanceModal(${user.id}, '${this.escapeHtml(user.username)}')">
                                        💰 Баланс
                                    </button>
                                </td>
                            `;
                        });
                    }
                } catch (error) {
                    tbody.innerHTML = '<tr><td colspan="7">Ошибка загрузки пользователей</td></tr>';
                } finally {
                    loading.style.display = 'none';
                }
            }

            async loadGames() {
                const loading = document.getElementById('gamesLoading');
                const tbody = document.getElementById('gamesTable');
                
                loading.style.display = 'block';
                tbody.innerHTML = '';
                
                try {
                    const response = await this.makeRequest('get_games', { limit: 100 });
                    
                    if (response.success) {
                        response.games.forEach(game => {
                            const row = tbody.insertRow();
                            const winColor = game.total_win > game.total_bet ? '#4CAF50' : '#fff';
                            
                            row.innerHTML = `
                                <td>${game.id}</td>
                                <td>${this.escapeHtml(game.username)}</td>
                                <td>${this.formatCurrency(game.total_bet)}</td>
                                <td style="color: ${winColor}; font-weight: bold;">${this.formatCurrency(game.total_win)}</td>
                                <td>${parseFloat(game.rtp).toFixed(1)}%</td>
                                <td>${game.bonus_triggered ? '🎁' : '❌'}</td>
                                <td>${new Date(game.created_at).toLocaleString()}</td>
                            `;
                        });
                    }
                } catch (error) {
                    tbody.innerHTML = '<tr><td colspan="7">Ошибка загрузки истории игр</td></tr>';
                } finally {
                    loading.style.display = 'none';
                }
            }

            async loadLogs() {
                const loading = document.getElementById('logsLoading');
                const tbody = document.getElementById('logsTable');
                const level = document.getElementById('logLevel').value;
                
                loading.style.display = 'block';
                tbody.innerHTML = '';
                
                try {
                    const response = await this.makeRequest('get_logs', { level, limit: 100 });
                    
                    if (response.success) {
                        response.logs.forEach(log => {
                            const row = tbody.insertRow();
                            const levelColor = {
                                'DEBUG': '#2196F3',
                                'INFO': '#4CAF50',
                                'WARNING': '#FF9800',
                                'ERROR': '#f44336',
                                'CRITICAL': '#9C27B0'
                            }[log.level] || '#fff';
                            
                            row.innerHTML = `
                                <td>${new Date(log.created_at).toLocaleString()}</td>
                                <td style="color: ${levelColor}; font-weight: bold;">${log.level}</td>
                                <td>${this.escapeHtml(log.message)}</td>
                                <td>${log.username || 'Система'}</td>
                                <td>${log.source || 'Неизвестно'}</td>
                            `;
                        });
                    }
                } catch (error) {
                    tbody.innerHTML = '<tr><td colspan="5">Ошибка загрузки логов</td></tr>';
                } finally {
                    loading.style.display = 'none';
                }
            }

            openBalanceModal(userId, username) {
                document.getElementById('balanceUserId').value = userId;
                document.getElementById('balanceAmount').value = '';
                document.getElementById('balanceReason').value = '';
                document.getElementById('balanceModal').style.display = 'flex';
            }

            async adjustBalance() {
                const userId = document.getElementById('balanceUserId').value;
                const amount = parseFloat(document.getElementById('balanceAmount').value);
                const reason = document.getElementById('balanceReason').value;
                
                if (!userId || !amount || !reason) {
                    this.showNotification('Заполните все поля', 'error');
                    return;
                }
                
                try {
                    const response = await this.makeRequest('adjust_balance', {
                        userId,
                        amount,
                        reason
                    });
                    
                    if (response.success) {
                        this.showNotification('Баланс успешно изменен', 'success');
                        this.closeModal('balanceModal');
                        this.loadUsers(); // Обновляем список пользователей
                    } else {
                        this.showNotification('Ошибка изменения баланса', 'error');
                    }
                } catch (error) {
                    this.showNotification('Ошибка сети', 'error');
                }
            }

            async updateJackpot() {
                const amount = parseFloat(document.getElementById('jackpotInput').value);
                
                if (amount < 0) {
                    this.showNotification('Сумма джекпота не может быть отрицательной', 'error');
                    return;
                }
                
                try {
                    const response = await this.makeRequest('set_jackpot', { amount });
                    
                    if (response.success) {
                        this.showNotification('Джекпот успешно обновлен', 'success');
                        this.refreshStats();
                    } else {
                        this.showNotification('Ошибка обновления джекпота', 'error');
                    }
                } catch (error) {
                    this.showNotification('Ошибка сети', 'error');
                }
            }

            async cleanupData() {
                const days = parseInt(document.getElementById('cleanupDays').value);
                
                if (days < 1) {
                    this.showNotification('Количество дней должно быть больше 0', 'error');
                    return;
                }
                
                if (!confirm(`Удалить все данные старше ${days} дней? Это действие необратимо.`)) {
                    return;
                }
                
                try {
                    const response = await this.makeRequest('cleanup', { days });
                    
                    if (response.success) {
                        const result = response.result;
                        this.showNotification(
                            `Очистка завершена. Удалено логов: ${result.logs_deleted}, сессий: ${result.sessions_deleted}`,
                            'success'
                        );
                    } else {
                        this.showNotification('Ошибка очистки данных', 'error');
                    }
                } catch (error) {
                    this.showNotification('Ошибка сети', 'error');
                }
            }

            closeModal(modalId) {
                document.getElementById(modalId).style.display = 'none';
            }

            showNotification(message, type) {
                const notification = document.getElementById('notification');
                notification.textContent = message;
                notification.className = `notification ${type}`;
                notification.classList.add('show');
                
                setTimeout(() => {
                    notification.classList.remove('show');
                }, 4000);
            }

            async makeRequest(action, data) {
                const formData = new FormData();
                formData.append('action', action);
                
                for (const [key, value] of Object.entries(data)) {
                    formData.append(key, value);
                }

                const response = await fetch('', {
                    method: 'POST',
                    body: formData
                });

                if (!response.ok) {
                    throw new Error(`HTTP ${response.status}`);
                }

                return await response.json();
            }

            formatCurrency(amount) {
                return parseFloat(amount || 0).toFixed(1);
            }

            escapeHtml(text) {
                const div = document.createElement('div');
                div.textContent = text;
                return div.innerHTML;
            }
        }

        // Глобальные функции
        let admin;

        window.addEventListener('DOMContentLoaded', () => {
            admin = new AdminDashboard();
        });

        function showSection(sectionName) {
            admin.showSection(sectionName);
        }

        function refreshData() {
            admin.refreshStats();
            if (admin.currentSection === 'users') {
                admin.loadUsers();
            } else if (admin.currentSection === 'games') {
                admin.loadGames();
            } else if (admin.currentSection === 'logs') {
                admin.loadLogs();
            }
            
            admin.showNotification('Данные обновлены', 'success');
        }

        function loadLogs() {
            admin.loadLogs();
        }

        function updateJackpot() {
            admin.updateJackpot();
        }

        function cleanupData() {
            admin.cleanupData();
        }

        function closeModal(modalId) {
            admin.closeModal(modalId);
        }

        // Закрытие модальных окон по клику вне них
        document.addEventListener('click', (e) => {
            if (e.target.classList.contains('modal')) {
                e.target.style.display = 'none';
            }
        });
    </script>
</body>
</html>