🔍 Veritabanı Tabloları Test


📋 Tüm Tablolar:


👥 Users Tablosu (İlk 5 kayıt):

IDUsernamePAPTicketCloverKayıt Tarihi
3merve gizay0.00550.0011782025-05-31 01:03:22
5yunuserci1.00576.006112025-05-31 01:08:43
6clone1fs0.00590.006132025-05-31 01:09:18
68Gokhan_papiteam0.00560.005602025-05-31 19:26:53
82psikopatyazar060.00550.0022002025-05-31 19:48:23

💰 Balance_logs Tablosu Yapısı:

AlanTipNullKeyDefaultExtra
idintNOPRIauto_increment
user_idintNOMUL
ticket_changedecimal(10,2)NO
pap_changedecimal(10,2)NO
clover_changeintNO0
pap_balancedecimal(10,2)NO0.00
ticket_balancedecimal(10,2)NO0.00
clover_balanceintNO0
notetextYES
admin_idintYESMUL
created_attimestampNOCURRENT_TIMESTAMPDEFAULT_GENERATED

💰 Balance_logs Tablosu (Son 10 kayıt):

IDUser IDTicket ChangePAP ChangeClover ChangeNoteAdmin IDCreated At
13199119570.00-7.000PAP→Ticket çevirme: 7 PAP → 70 Ticket10142026-04-14 17:36:47
131982176250.00-25.000PAP→Ticket çevirme: 25 PAP → 250 Ticket10142026-04-14 17:02:51
13197119530.00-3.000PAP→Ticket çevirme: 3 PAP → 30 Ticket10142026-04-14 16:54:13
13196119510.00-1.000PAP→Ticket çevirme: 1 PAP → 10 Ticket10142026-04-14 16:46:29
13195119510.00-1.000PAP→Ticket çevirme: 1 PAP → 10 Ticket10142026-04-14 16:22:18
13194119510.00-1.000PAP→Ticket çevirme: 1 PAP → 10 Ticket10142026-04-14 16:05:43
131932189250.00-25.000PAP→Ticket çevirme: 25 PAP → 250 Ticket10142026-04-14 15:22:55
13192119510.00-1.000PAP→Ticket çevirme: 1 PAP → 10 Ticket10142026-04-14 15:06:19
13191119510.00-1.000PAP→Ticket çevirme: 1 PAP → 10 Ticket10142026-04-14 14:42:29
131901323250.00-25.000PAP→Ticket çevirme: 25 PAP → 250 Ticket10142026-04-14 14:41:18

📊 Balance_logs İstatistikleri:


👤 Örnek Kullanıcı Balance Logları:

Kullanıcı ID: 1195 (Toplam 707 kayıt)

TarihTicketPAPCloverNot
2026-04-14 17:36:4770.00-7.000PAP→Ticket çevirme: 7 PAP → 70 Ticket
2026-04-14 16:54:1330.00-3.000PAP→Ticket çevirme: 3 PAP → 30 Ticket
2026-04-14 16:46:2910.00-1.000PAP→Ticket çevirme: 1 PAP → 10 Ticket
2026-04-14 16:22:1810.00-1.000PAP→Ticket çevirme: 1 PAP → 10 Ticket
2026-04-14 16:05:4310.00-1.000PAP→Ticket çevirme: 1 PAP → 10 Ticket

🎮 Diğer Önemli Tablolar:

📋 Slot Oyun Logları (slot_logs):

Kayıt Sayısı: 2968882

iduser_idbetwinclover_betclover_wincreated_atprize_type
2978158510002026-05-08 21:19:04ticket_spent
2978157516002026-05-08 21:19:01bilet
2978156510002026-05-08 21:18:59ticket_spent

📋 Scratch Oyun Logları (scratch_logs):

Kayıt Sayısı: 998783

iduser_idbetwinclover_betclover_wincreated_atprize_type
1001626105310002026-04-14 17:34:12ticket_spent
1001625105310002026-04-14 17:34:00ticket_spent
1001624105310002026-04-14 17:33:47ticket_spent

📋 Wheel Oyun Logları (wheel_logs):

Kayıt Sayısı: 1128780

iduser_idbet_amountwin_amountclover_bet_amountclover_win_amountprize_typecreated_at
113207711951.001.0000bilet2026-04-14 17:38:23
113207611951.005.0000bilet2026-04-14 17:38:07
113207511951.000.0000ticket_spent2026-04-14 17:37:59

📋 Betyu Oyun Logları (betyu_logs):

Kayıt Sayısı: 3179

iduser_idbetselectioncreated_atresult_statusresult_amount
3190104725win2026-04-11 11:11:27won50
31891662100win2026-04-11 11:11:27won200
31881287100win2026-04-11 11:11:27won200

📋 Bakım Ayarları (maintenance_settings):

Kayıt Sayısı: 5


Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/test_all_tables.php on line 226

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/test_all_tables.php on line 226
idgame_typeis_maintenancemaintenance_passwordcreated_atupdated_atkick_timestamp
5main012192025-08-05 05:29:482025-09-26 08:56:39
4betyu011292025-08-04 05:34:342026-04-10 16:27:311754290312
3wheel012172025-08-04 05:28:402026-02-11 12:05:11

📋 Sponsor Türleri (sponsor_types):

Kayıt Sayısı: 13

idnamedisplay_nameis_activecreated_atupdated_at
33bigwinoBigWino12025-07-01 15:16:012025-07-01 15:16:01
32grandpashaGrandPashaBet12025-07-01 15:13:172025-07-01 15:13:17
31epikEpikBahis12025-07-01 15:13:072025-07-01 15:13:07

📋 Kullanıcı Sponsor ID'leri (user_sponsor_ids):

Kayıt Sayısı: 9


Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/test_all_tables.php on line 226

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/test_all_tables.php on line 226

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/test_all_tables.php on line 226

Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/test_all_tables.php on line 226
iduser_idsponsor_type_idsponsor_idstatusrejection_noteadmin_idcreated_atupdated_at
101101411change_pending 2025-12-14 22:01:462025-12-14 22:01:46
100101451change_pending 2025-12-14 22:01:432025-12-14 22:01:43
991014244rejected110142025-07-08 14:18:242025-07-08 14:18:36


✅ Test Tamamlandı!

Bu test sonuçlarına göre balance_logs tablosunun durumunu ve neden 00:00 bakiyelerinin 0 göründüğünü anlayabiliriz.