ÿØÿà JFIF    ÿÛ „  ( %"1!%)+...383,7(-.+  -+++--++++---+-+-----+---------------+---+-++7-----ÿÀ  ß â" ÿÄ     ÿÄ H    !1AQaq"‘¡2B±ÁÑð#R“Ò Tbr‚²á3csƒ’ÂñDS¢³$CÿÄ   ÿÄ %  !1AQa"23‘ÿÚ   ? ôÿ ¨pŸªáÿ —åYõõ\?àÒü©ŠÄï¨pŸªáÿ —åYõõ\?àÓü©ŠÄá 0Ÿªáÿ Ÿå[úƒ ú®ði~TÁbqÐ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›üä±Í™%ºÍãö]°î(–:@<‹ŒÊö×òÆt¦ãº+‡¦%ÌÁ²h´OƒJŒtMÜ>ÀÜÊw3Y´•牋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íÌ–ª)µ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›=§\û"—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½Ðß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—Xy*¥t£«<™:“aîϲ=¦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ÿÙ connect_error) { throw new Exception("Connection failed: " . $conn->connect_error); } $conn->set_charset("utf8mb4"); // Проверяем соединение простым запросом $result = $conn->query("SELECT 1"); if (!$result) { throw new Exception("Database test query failed: " . $conn->error); } } catch (Exception $e) { error_log("DB Connection Error: " . $e->getMessage()); return null; } } return $conn; } // === СОЗДАНИЕ ДИРЕКТОРИЙ === function create_directories() { $dirs = ['sessions', 'logs', 'backups']; foreach ($dirs as $dir) { if (!is_dir($dir)) { if (!mkdir($dir, 0755, true)) { error_log("Failed to create directory: $dir"); continue; } $htaccess_content = "Order Deny,Allow\nDeny from all"; file_put_contents("$dir/.htaccess", $htaccess_content); } } } // === БЕЗОПАСНОСТЬ === function check_rate_limit($telegram_id, $action = 'message') { if (!ENABLE_RATE_LIMITING) return true; try { $conn = db(); if (!$conn) return true; $limit = ($action === 'bet') ? RATE_LIMIT_BETS : RATE_LIMIT_MESSAGES; $stmt = $conn->prepare(" SELECT COUNT(*) FROM rate_limits WHERE telegram_id = ? AND action = ? AND created_at > DATE_SUB(NOW(), INTERVAL 1 MINUTE) "); if (!$stmt) return true; $stmt->bind_param("ss", $telegram_id, $action); $stmt->execute(); $stmt->bind_result($count); $stmt->fetch(); $stmt->close(); if ($count >= $limit) { return false; } // Записываем действие $stmt = $conn->prepare("INSERT INTO rate_limits (telegram_id, action, created_at) VALUES (?, ?, NOW())"); if ($stmt) { $stmt->bind_param("ss", $telegram_id, $action); $stmt->execute(); $stmt->close(); } return true; } catch (Exception $e) { error_log("Rate limit error: " . $e->getMessage()); return true; } } function is_admin($telegram_id) { return in_array((int)$telegram_id, ADMIN_TELEGRAM_IDS); } function is_user_banned($telegram_id) { try { $conn = db(); if (!$conn) return null; $stmt = $conn->prepare("SELECT ban_reason FROM users WHERE telegram_id = ? AND is_banned = 1"); if (!$stmt) return null; $stmt->bind_param("s", $telegram_id); $stmt->execute(); $stmt->bind_result($ban_reason); $stmt->fetch(); $stmt->close(); return $ban_reason; } catch (Exception $e) { error_log("Check ban error: " . $e->getMessage()); return null; } } function validate_input($text, $type = 'text') { if (strlen($text) > MAX_MESSAGE_LENGTH) return false; if (ENABLE_SPAM_PROTECTION) { foreach (BLOCKED_WORDS as $word) { if (stripos($text, $word) !== false) return false; } } switch ($type) { case 'score': return preg_match('/^\d{1,2}:\d{1,2}$/', $text); case 'profile_name': return preg_match('/^[a-zA-Zа-яА-Я0-9\s]{1,30}$/u', $text); default: return true; } } // === ПОЛЬЗОВАТЕЛИ === function get_or_create_user($telegram_id, $name) { try { $conn = db(); if (!$conn) { error_log("Database connection failed in get_or_create_user"); return null; } $stmt = $conn->prepare("SELECT id, points FROM users WHERE telegram_id = ?"); if (!$stmt) { error_log("Prepare failed: " . $conn->error); return null; } $stmt->bind_param("s", $telegram_id); $stmt->execute(); $stmt->store_result(); if ($stmt->num_rows > 0) { $stmt->bind_result($id, $points); $stmt->fetch(); $stmt->close(); // Обновляем активность $stmt = $conn->prepare("UPDATE users SET last_activity = NOW() WHERE id = ?"); if ($stmt) { $stmt->bind_param("i", $id); $stmt->execute(); $stmt->close(); } return ['id' => $id, 'points' => $points]; } else { $stmt->close(); // Создаем нового пользователя $stmt = $conn->prepare("INSERT INTO users (telegram_id, name, points, created_at, last_activity) VALUES (?, ?, ?, NOW(), NOW())"); if (!$stmt) { error_log("Insert prepare failed: " . $conn->error); return null; } $start_points = START_POINTS; $stmt->bind_param("ssi", $telegram_id, $name, $start_points); $stmt->execute(); $user_id = $stmt->insert_id; $stmt->close(); return ['id' => $user_id, 'points' => $start_points]; } } catch (Exception $e) { error_log("Get or create user error: " . $e->getMessage()); return null; } } // === ПРОФИЛИ === function get_profiles($telegram_id) { try { $conn = db(); if (!$conn) return []; $stmt = $conn->prepare(" SELECT p.id, p.name, p.points, COUNT(b.id) as total_bets FROM profiles p LEFT JOIN bets b ON p.id = b.profile_id WHERE p.telegram_id = ? GROUP BY p.id, p.name, p.points ORDER BY p.created_at ASC "); if (!$stmt) { error_log("Get profiles prepare failed: " . $conn->error); return []; } $stmt->bind_param("s", $telegram_id); $stmt->execute(); $res = $stmt->get_result(); $profiles = []; while ($row = $res->fetch_assoc()) { $profiles[] = $row; } $stmt->close(); return $profiles; } catch (Exception $e) { error_log("Get profiles error: " . $e->getMessage()); return []; } } function create_profile($telegram_id, $name) { if (!validate_input($name, 'profile_name')) return false; try { $conn = db(); if (!$conn) return false; // Проверяем лимит профилей $stmt = $conn->prepare("SELECT COUNT(*) FROM profiles WHERE telegram_id = ?"); if (!$stmt) return false; $stmt->bind_param("s", $telegram_id); $stmt->execute(); $stmt->bind_result($cnt); $stmt->fetch(); $stmt->close(); if ($cnt >= MAX_PROFILES_PER_USER) return false; // Проверяем уникальность имени $stmt = $conn->prepare("SELECT COUNT(*) FROM profiles WHERE telegram_id = ? AND name = ?"); if (!$stmt) return false; $stmt->bind_param("ss", $telegram_id, $name); $stmt->execute(); $stmt->bind_result($exists); $stmt->fetch(); $stmt->close(); if ($exists > 0) return 'exists'; // Создаем профиль $stmt = $conn->prepare("INSERT INTO profiles (telegram_id, name, points, created_at) VALUES (?, ?, ?, NOW())"); if (!$stmt) return false; $start_points = START_POINTS; $stmt->bind_param("ssi", $telegram_id, $name, $start_points); $stmt->execute(); $profile_id = $stmt->insert_id; $stmt->close(); return $profile_id; } catch (Exception $e) { error_log("Create profile error: " . $e->getMessage()); return false; } } function get_profile($profile_id) { try { $conn = db(); if (!$conn) return null; $stmt = $conn->prepare("SELECT id, name, points, created_at, telegram_id FROM profiles WHERE id = ?"); if (!$stmt) return null; $stmt->bind_param("i", $profile_id); $stmt->execute(); $res = $stmt->get_result(); $profile = $res->fetch_assoc(); $stmt->close(); return $profile; } catch (Exception $e) { error_log("Get profile error: " . $e->getMessage()); return null; } } function update_profile_name($profile_id, $new_name, $telegram_id) { if (!validate_input($new_name, 'profile_name')) return false; try { $conn = db(); if (!$conn) return false; // Проверяем владельца $stmt = $conn->prepare("SELECT COUNT(*) FROM profiles WHERE id = ? AND telegram_id = ?"); if (!$stmt) return false; $stmt->bind_param("is", $profile_id, $telegram_id); $stmt->execute(); $stmt->bind_result($owns); $stmt->fetch(); $stmt->close(); if (!$owns) return false; // Обновляем имя $stmt = $conn->prepare("UPDATE profiles SET name = ? WHERE id = ?"); if (!$stmt) return false; $stmt->bind_param("si", $new_name, $profile_id); $result = $stmt->execute(); $stmt->close(); return $result; } catch (Exception $e) { error_log("Update profile name error: " . $e->getMessage()); return false; } } function delete_profile($profile_id, $telegram_id) { try { $conn = db(); if (!$conn) return false; // Получаем данные профиля $stmt = $conn->prepare("SELECT name FROM profiles WHERE id = ? AND telegram_id = ?"); if (!$stmt) return false; $stmt->bind_param("is", $profile_id, $telegram_id); $stmt->execute(); $res = $stmt->get_result(); if ($res->num_rows === 0) { $stmt->close(); return false; } $profile = $res->fetch_assoc(); $stmt->close(); // Удаляем в транзакции $conn->begin_transaction(); try { // Удаляем ставки $stmt = $conn->prepare("DELETE FROM bets WHERE profile_id = ?"); if ($stmt) { $stmt->bind_param("i", $profile_id); $stmt->execute(); $stmt->close(); } // Удаляем профиль $stmt = $conn->prepare("DELETE FROM profiles WHERE id = ?"); if ($stmt) { $stmt->bind_param("i", $profile_id); $stmt->execute(); $stmt->close(); } $conn->commit(); return true; } catch (Exception $e) { $conn->rollback(); throw $e; } } catch (Exception $e) { error_log("Delete profile error: " . $e->getMessage()); return false; } } // === СИСТЕМА БАЛЛОВ === function get_balance_info($profile_id) { $profile = get_profile($profile_id); if (!$profile) return ['points' => 0, 'rub' => 0, 'status' => 'critical', 'can_bet' => false]; $balance_rub = $profile['points'] * POINTS_TO_RUBLE_RATE; $status = get_balance_status($profile['points']); return [ 'points' => $profile['points'], 'rub' => $balance_rub, 'status' => $status, 'can_bet' => $profile['points'] > MINIMUM_BALANCE ]; } function get_balance_status($points) { if ($points > 5) return 'good'; if ($points > 0) return 'low'; if ($points >= -10) return 'negative'; return 'critical'; } function can_make_bet($profile_id, $bet_cost = 1) { $balance = get_balance_info($profile_id); if (!$balance) { return [ 'allowed' => false, 'reason' => 'Ошибка получения информации о балансе.' ]; } if (!$balance['can_bet']) { return [ 'allowed' => false, 'reason' => 'Баланс слишком низкий для ставок. Обратитесь к администратору для пополнения.' ]; } if ($balance['points'] - $bet_cost < MINIMUM_BALANCE) { return [ 'allowed' => false, 'reason' => 'Недостаточно баллов для ставки. Текущий баланс: ' . $balance['points'] . ' баллов.' ]; } return ['allowed' => true]; } // === СТАВКИ === function save_bet($user_id, $profile_id, $match_id, $data) { $bet_check = can_make_bet($profile_id); if (!$bet_check['allowed']) { return ['success' => false, 'error' => $bet_check['reason']]; } try { $conn = db(); if (!$conn) { return ['success' => false, 'error' => 'Ошибка подключения к базе данных']; } $profile = get_profile($profile_id); $user_name = $profile ? $profile['name'] : ''; $conn->begin_transaction(); // Списываем балл $stmt = $conn->prepare("UPDATE profiles SET points = points - 1 WHERE id = ?"); if (!$stmt) throw new Exception("Prepare update failed: " . $conn->error); $stmt->bind_param("i", $profile_id); $stmt->execute(); $stmt->close(); // Создаем ставку $stmt = $conn->prepare(" INSERT INTO bets (user_id, profile_id, match_id, user_name, win, score, penalty, autogoal, redcard, total, corners, firstgoal, created_at, can_edit_until) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW(), DATE_ADD(NOW(), INTERVAL ? SECOND)) "); if (!$stmt) throw new Exception("Prepare insert failed: " . $conn->error); $edit_time = BET_EDIT_TIME; $stmt->bind_param( "iiisssssssssi", $user_id, $profile_id, $match_id, $user_name, $data['win'] ?? '', $data['score'] ?? '', $data['penalty'] ?? '', $data['autogoal'] ?? '', $data['redcard'] ?? '', $data['total'] ?? '', $data['corners'] ?? '', $data['firstgoal'] ?? '', $edit_time ); $stmt->execute(); $bet_id = $stmt->insert_id; $stmt->close(); $conn->commit(); return ['success' => true, 'bet_id' => $bet_id]; } catch (Exception $e) { if (isset($conn)) $conn->rollback(); error_log("Save bet error: " . $e->getMessage()); return ['success' => false, 'error' => 'Ошибка сохранения ставки']; } } function get_profile_bets($profile_id, $limit = null) { try { $conn = db(); if (!$conn) return []; $sql = "SELECT * FROM bets WHERE profile_id = ? ORDER BY created_at DESC"; if ($limit) $sql .= " LIMIT ?"; $stmt = $conn->prepare($sql); if (!$stmt) { error_log("Get bets prepare failed: " . $conn->error); return []; } if ($limit) { $stmt->bind_param("ii", $profile_id, $limit); } else { $stmt->bind_param("i", $profile_id); } $stmt->execute(); $res = $stmt->get_result(); $bets = []; while ($row = $res->fetch_assoc()) { $bets[] = $row; } $stmt->close(); return $bets; } catch (Exception $e) { error_log("Get profile bets error: " . $e->getMessage()); return []; } } // === СТАТИСТИКА === function get_profile_detailed_stats($profile_id) { try { $conn = db(); if (!$conn) { return [ 'total_bets' => 0, 'winning_bets' => 0, 'losing_bets' => 0, 'total_points' => 0, 'avg_points' => 0, 'best_bet' => 0, 'winrate' => 0 ]; } $stmt = $conn->prepare(" SELECT COUNT(*) as total_bets, COUNT(CASE WHEN points > 0 THEN 1 END) as winning_bets, COUNT(CASE WHEN points = 0 THEN 1 END) as losing_bets, COALESCE(SUM(CASE WHEN points IS NOT NULL THEN points ELSE 0 END), 0) as total_points, COALESCE(AVG(CASE WHEN points IS NOT NULL THEN points END), 0) as avg_points, COALESCE(MAX(points), 0) as best_bet FROM bets WHERE profile_id = ? "); if (!$stmt) { return [ 'total_bets' => 0, 'winning_bets' => 0, 'losing_bets' => 0, 'total_points' => 0, 'avg_points' => 0, 'best_bet' => 0, 'winrate' => 0 ]; } $stmt->bind_param("i", $profile_id); $stmt->execute(); $res = $stmt->get_result(); $stats = $res->fetch_assoc(); $stmt->close(); $stats['winrate'] = $stats['total_bets'] > 0 ? round(($stats['winning_bets'] / $stats['total_bets']) * 100, 1) : 0; return $stats; } catch (Exception $e) { error_log("Get profile stats error: " . $e->getMessage()); return [ 'total_bets' => 0, 'winning_bets' => 0, 'losing_bets' => 0, 'total_points' => 0, 'avg_points' => 0, 'best_bet' => 0, 'winrate' => 0 ]; } } function get_leaderboard($limit = 10) { try { $conn = db(); if (!$conn) return []; $stmt = $conn->prepare(" SELECT p.name, p.points, COUNT(b.id) as total_bets, COUNT(CASE WHEN b.points > 0 THEN 1 END) as winning_bets FROM profiles p LEFT JOIN bets b ON p.id = b.profile_id GROUP BY p.id, p.name, p.points HAVING total_bets >= 1 ORDER BY p.points DESC LIMIT ? "); if (!$stmt) { error_log("Get leaderboard prepare failed: " . $conn->error); return []; } $stmt->bind_param("i", $limit); $stmt->execute(); $res = $stmt->get_result(); $leaderboard = []; while ($row = $res->fetch_assoc()) { $row['winrate'] = $row['total_bets'] > 0 ? round(($row['winning_bets'] / $row['total_bets']) * 100, 1) : 0; $leaderboard[] = $row; } $stmt->close(); return $leaderboard; } catch (Exception $e) { error_log("Get leaderboard error: " . $e->getMessage()); return []; } } // === ФОРМАТИРОВАНИЕ === function format_bet($data) { $labels = [ 'win' => '🏆 Победитель', 'score' => '🔢 Точный счёт', 'penalty' => '⚽ Пенальти', 'autogoal' => '🎯 Автогол', 'redcard' => '❌ Удаление', 'total' => '📈 Тотал голов', 'corners' => '🚩 Угловые', 'firstgoal' => '⚡ Первый гол' ]; $out = []; foreach ($labels as $k => $label) { if (!isset($data[$k])) continue; $value = $data[$k]; if ($value === '' || mb_strtolower($value) === 'пропущено' || mb_strtolower($value) === 'пропустить') continue; $out[] = "$label: " . htmlspecialchars($value); } return implode("\n", $out); } // === ВОПРОСЫ === function get_questions() { return [ [ 'key' => 'win', 'text' => '🏆 Кто победит? (П1 — Сектор 4, П2 — Сектор 5)', 'keyboard' => ['П1', 'Ничья', 'П2', 'Пропустить'] ], [ 'key' => 'score', 'text' => '🔢 Точный счёт (Сектор 4 — Сектор 5, например: 2:1):', 'keyboard' => ['0:0', '1:0', '0:1', '1:1', '2:1', '1:2', '2:0', '0:2', 'Пропустить'] ], [ 'key' => 'penalty', 'text' => '⚽ Будет пенальти?', 'keyboard' => ['Да', 'Пропустить'] ], [ 'key' => 'autogoal', 'text' => '🎯 Будет автогол?', 'keyboard' => ['Да', 'Пропустить'] ], [ 'key' => 'redcard', 'text' => '❌ Будет удаление?', 'keyboard' => ['Да', 'Пропустить'] ], [ 'key' => 'total', 'text' => '📈 Тотал голов?', 'keyboard' => ['Больше 5', 'Меньше 5', 'Пропустить'] ], [ 'key' => 'corners', 'text' => '🚩 Кто подаст больше угловых? (П1 — 4 сектор, П2 — 5 сектор)', 'keyboard' => ['П1', 'Х', 'П2', 'Пропустить'] ], [ 'key' => 'firstgoal', 'text' => '⚡ Кто забьёт первый гол?', 'keyboard' => ['Сектор 4', 'Сектор 5', 'Никто', 'Пропустить'] ] ]; } // === АДМИНИСТРАТИВНЫЕ ФУНКЦИИ === function process_bet_result($bet_id, $points, $admin_id, $details = '') { try { $conn = db(); if (!$conn) { return ['success' => false, 'error' => 'Ошибка подключения к базе данных']; } $conn->begin_transaction(); // Получаем информацию о ставке $stmt = $conn->prepare(" SELECT b.profile_id, b.user_id, b.is_processed, p.name, p.telegram_id FROM bets b JOIN profiles p ON b.profile_id = p.id WHERE b.id = ? "); if (!$stmt) { throw new Exception("Prepare failed: " . $conn->error); } $stmt->bind_param("i", $bet_id); $stmt->execute(); $res = $stmt->get_result(); $bet_info = $res->fetch_assoc(); $stmt->close(); if (!$bet_info) { throw new Exception("Ставка не найдена"); } if ($bet_info['is_processed']) { throw new Exception("Ставка уже обработана"); } // Обновляем ставку $stmt = $conn->prepare(" UPDATE bets SET points = ?, is_processed = 1, processed_at = NOW(), result_details = ? WHERE id = ? "); if (!$stmt) { throw new Exception("Update prepare failed: " . $conn->error); } $stmt->bind_param("isi", $points, $details, $bet_id); $stmt->execute(); $stmt->close(); if ($points == 0) { // Проигрыш: дополнительно -1 балл (итого -2) $stmt = $conn->prepare("UPDATE profiles SET points = points - 1 WHERE id = ?"); if ($stmt) { $stmt->bind_param("i", $bet_info['profile_id']); $stmt->execute(); $stmt->close(); } $total_change = -2; $result_text = "проиграна"; } else { // Выигрыш: +1 балл возврат + баллы выигрыша $total_points_to_add = $points + 1; $stmt = $conn->prepare("UPDATE profiles SET points = points + ? WHERE id = ?"); if ($stmt) { $stmt->bind_param("ii", $total_points_to_add, $bet_info['profile_id']); $stmt->execute(); $stmt->close(); } $total_change = $points + 1; $result_text = "выиграна"; } $conn->commit(); // Отправляем уведомление пользователю $message = "🎯 Результат ставки #{$bet_id}\n\n"; $message .= "Профиль: {$bet_info['name']}\n"; $message .= "Ставка: {$result_text}\n"; if ($points == 0) { $message .= "Результат: -2 балла (400 ₽)\n"; $message .= "1 балл за ставку + 1 балл штраф за проигрыш"; } else { $message .= "Результат: +{$total_change} баллов (" . number_format($total_change * 200, 0, '', ' ') . " ₽)\n"; $message .= "Возврат 1 балла за ставку + {$points} баллов выигрыш"; } if ($details) { $message .= "\nКомментарий: $details"; } // Здесь должна быть функция отправки сообщения // send_message($bet_info['telegram_id'], $message); return [ 'success' => true, 'message' => 'Ставка обработана успешно', 'points_change' => $total_change ]; } catch (Exception $e) { if (isset($conn)) $conn->rollback(); error_log("Process bet result error: " . $e->getMessage()); return ['success' => false, 'error' => $e->getMessage()]; } } ?>