Veritabanı: slot_game
Sunucu: localhost
| # | Tablo Adı | İşlemler |
|---|---|---|
| 1 | admin_logs | |
| 2 | admin_notifications | |
| 3 | balance_debug_logs | |
| 4 | balance_logs | |
| 5 | balance_update_audit | |
| 6 | betyu_bets | |
| 7 | betyu_logs | |
| 8 | betyu_period_logs | |
| 9 | betyu_periods | |
| 10 | betyu_text_settings | |
| 11 | blocked_ips | |
| 12 | clover_settings | |
| 13 | consecutive_wins | |
| 14 | general_settings | |
| 15 | hidden_ip_warnings | |
| 16 | hidden_logs | |
| 17 | hidden_users | |
| 18 | investment_links | |
| 19 | investment_reset_settings | |
| 20 | investment_rewards | |
| 21 | loyalty_history | |
| 22 | loyalty_levels | |
| 23 | maintenance_settings | |
| 24 | max_win_logs | |
| 25 | max_win_status | |
| 26 | monthly_pap_quota | |
| 27 | notifications | |
| 28 | pap_earning_logs | |
| 29 | png_sponsor_cards | |
| 30 | png_sponsor_stats | |
| 31 | referrals | |
| 32 | reward_logs | |
| 33 | scratch_config | |
| 34 | scratch_logs | |
| 35 | scratch_settings | |
| 36 | security_heartbeats | |
| 37 | security_requests | |
| 38 | security_violations | |
| 39 | segment1_status | |
| 40 | slot_config | |
| 41 | slot_logs | |
| 42 | slot_max_symbol_logs | |
| 43 | slot_max_symbol_status | |
| 44 | special_win_state | |
| 45 | sponsor_cards | |
| 46 | sponsor_cards_backup_20250627_201450 | |
| 47 | sponsor_cards_backup_20260510_011851 | |
| 48 | sponsor_types | |
| 49 | symbol_settings | |
| 50 | symbols | |
| 51 | tasks | |
| 52 | test_security_violations | |
| 53 | tokens | |
| 54 | user_investment_steps | |
| 55 | user_jokers | |
| 56 | user_metric_overrides | |
| 57 | user_notes | |
| 58 | user_restrictions | |
| 59 | user_sponsor_ids | |
| 60 | user_stats | |
| 61 | user_task_logs | |
| 62 | user_violation_counters | |
| 63 | username_history | |
| 64 | users | |
| 65 | wheel_config | |
| 66 | wheel_logs | |
| 67 | wheel_settings | |
| 68 | withdraw_requests |
Toplam Tablo Sayısı: 68
✅ Balance logs tablosu mevcut!
| Sütun | Tip | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int | NO | PRI | auto_increment | |
| user_id | int | NO | MUL | ||
| ticket_change | decimal(10,2) | NO | |||
| pap_change | decimal(10,2) | NO | |||
| clover_change | int | NO | 0 | ||
| pap_balance | decimal(10,2) | NO | 0.00 | ||
| ticket_balance | decimal(10,2) | NO | 0.00 | ||
| clover_balance | int | NO | 0 | ||
| note | text | YES | |||
| admin_id | int | YES | MUL | ||
| created_at | timestamp | NO | CURRENT_TIMESTAMP | DEFAULT_GENERATED |
Balance Logs Kayıt Sayısı: 13092
| ID | User ID | Admin ID | PAP Balance | Ticket Balance | Clover Balance | PAP Change | Ticket Change | Clover Change | Note | Created At |
|---|---|---|---|---|---|---|---|---|---|---|
| 13199 | 1195 | 1014 | 0.00 | 0.00 | 0 | -7.00 | 70.00 | 0 | PAP→Ticket çevirme: 7 PAP → 70 Ticket | 2026-04-14 17:36:47 |
| 13198 | 2176 | 1014 | 0.00 | 0.00 | 0 | -25.00 | 250.00 | 0 | PAP→Ticket çevirme: 25 PAP → 250 Ticket | 2026-04-14 17:02:51 |
| 13197 | 1195 | 1014 | 0.00 | 0.00 | 0 | -3.00 | 30.00 | 0 | PAP→Ticket çevirme: 3 PAP → 30 Ticket | 2026-04-14 16:54:13 |
| 13196 | 1195 | 1014 | 0.00 | 0.00 | 0 | -1.00 | 10.00 | 0 | PAP→Ticket çevirme: 1 PAP → 10 Ticket | 2026-04-14 16:46:29 |
| 13195 | 1195 | 1014 | 0.00 | 0.00 | 0 | -1.00 | 10.00 | 0 | PAP→Ticket çevirme: 1 PAP → 10 Ticket | 2026-04-14 16:22:18 |
| Sütun | Tip | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int | NO | PRI | auto_increment | |
| telegram_id | bigint | NO | UNI | ||
| referral_code | varchar(20) | YES | UNI | ||
| username | varchar(255) | NO | |||
| photo_url | text | YES | |||
| created_at | timestamp | NO | CURRENT_TIMESTAMP | DEFAULT_GENERATED | |
| last_login | timestamp | NO | CURRENT_TIMESTAMP | DEFAULT_GENERATED on update CURRENT_TIMESTAMP | |
| ticket_balance | decimal(10,2) | YES | 0.00 | ||
| pap_balance | decimal(10,2) | YES | 0.00 | ||
| clover_balance | int | NO | 0 | ||
| loyalty_points | int | NO | 0 | ||
| is_admin | tinyint(1) | YES | 0 | ||
| password | varchar(255) | YES | |||
| creation_ip | varchar(45) | YES | |||
| last_login_ip | varchar(45) | YES | |||
| is_banned | tinyint(1) | NO | 0 | ||
| blocked_until | timestamp | YES | |||
| blocked_reason | text | YES | |||
| is_verified | tinyint(1) | NO | 0 | ||
| tophill_id | varchar(32) | YES | |||
| tophill_status | enum('pending','approved','rejected','change_pending') | YES | |||
| tophill_rejection_note | text | YES | |||
| tophill_updated_at | timestamp | YES | |||
| tophill_admin_id | int | YES | |||
| reward_claimed | tinyint(1) | YES | 0 | ||
| kick_username | varchar(255) | YES | |||
| youtube_username | varchar(255) | YES | |||
| instagram_username | varchar(255) | YES |
Toplam Kullanıcı Sayısı: 1330
✅ Balance logs tablosu mevcut! user_detail.php çalışmalı.