🔍 Veritabanı Tabloları Test

📋 Tüm Tablolar:

admin_logs
admin_notifications
balance_debug_logs
balance_logs
balance_update_audit
betyu_bets
betyu_logs
betyu_period_logs
betyu_periods
betyu_text_settings
blocked_ips
clover_settings
consecutive_wins
general_settings
hidden_ip_warnings
hidden_logs
hidden_users
investment_links
investment_reset_settings
investment_rewards
loyalty_history
loyalty_levels
maintenance_settings
max_win_logs
max_win_status
monthly_pap_quota
notifications
pap_earning_logs
png_sponsor_cards
png_sponsor_stats
referrals
reward_logs
scratch_config
scratch_logs
scratch_settings
security_heartbeats
security_requests
security_violations
segment1_status
slot_config
slot_logs
slot_max_symbol_logs
slot_max_symbol_status
special_win_state
sponsor_cards
sponsor_cards_backup_20250627_201450
sponsor_cards_backup_20260510_011851
sponsor_types
symbol_settings
symbols
tasks
test_security_violations
tokens
user_investment_steps
user_jokers
user_metric_overrides
user_notes
user_restrictions
user_sponsor_ids
user_stats
user_task_logs
user_violation_counters
username_history
users
wheel_config
wheel_logs
wheel_settings
withdraw_requests

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

ID	Username	PAP	Ticket	Clover	Kayıt Tarihi
3	merve gizay	0.00	550.00	1178	2025-05-31 01:03:22
5	yunuserci	1.00	576.00	611	2025-05-31 01:08:43
6	clone1fs	0.00	590.00	613	2025-05-31 01:09:18
68	Gokhan_papiteam	0.00	560.00	560	2025-05-31 19:26:53
82	psikopatyazar06	0.00	550.00	2200	2025-05-31 19:48:23

💰 Balance_logs Tablosu Yapısı:

Alan	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 Tablosu (Son 10 kayıt):

ID	User ID	Ticket Change	PAP Change	Note	Admin ID	Created At
13199	1195	70.00	-7.00	PAP→Ticket çevirme: 7 PAP → 70 Ticket	1014	2026-04-14 17:36:47
13198	2176	250.00	-25.00	PAP→Ticket çevirme: 25 PAP → 250 Ticket	1014	2026-04-14 17:02:51
13197	1195	30.00	-3.00	PAP→Ticket çevirme: 3 PAP → 30 Ticket	1014	2026-04-14 16:54:13
13196	1195	10.00	-1.00	PAP→Ticket çevirme: 1 PAP → 10 Ticket	1014	2026-04-14 16:46:29
13195	1195	10.00	-1.00	PAP→Ticket çevirme: 1 PAP → 10 Ticket	1014	2026-04-14 16:22:18
13194	1195	10.00	-1.00	PAP→Ticket çevirme: 1 PAP → 10 Ticket	1014	2026-04-14 16:05:43
13193	2189	250.00	-25.00	PAP→Ticket çevirme: 25 PAP → 250 Ticket	1014	2026-04-14 15:22:55
13192	1195	10.00	-1.00	PAP→Ticket çevirme: 1 PAP → 10 Ticket	1014	2026-04-14 15:06:19
13191	1195	10.00	-1.00	PAP→Ticket çevirme: 1 PAP → 10 Ticket	1014	2026-04-14 14:42:29
13190	1323	250.00	-25.00	PAP→Ticket çevirme: 25 PAP → 250 Ticket	1014	2026-04-14 14:41:18

📊 Balance_logs İstatistikleri:

Toplam Kayıt: 13092
Benzersiz Kullanıcı: 505
En Eski Kayıt: 2025-06-13 23:38:57
En Yeni Kayıt: 2026-04-14 17:36:47
00:00 Kayıtları: 526

👤 Örnek Kullanıcı Balance Logları:

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

Tarih	Ticket	PAP	Not
2026-04-14 17:36:47	70.00	-7.00	PAP→Ticket çevirme: 7 PAP → 70 Ticket
2026-04-14 16:54:13	30.00	-3.00	PAP→Ticket çevirme: 3 PAP → 30 Ticket
2026-04-14 16:46:29	10.00	-1.00	PAP→Ticket çevirme: 1 PAP → 10 Ticket
2026-04-14 16:22:18	10.00	-1.00	PAP→Ticket çevirme: 1 PAP → 10 Ticket
2026-04-14 16:05:43	10.00	-1.00	PAP→Ticket çevirme: 1 PAP → 10 Ticket

🎮 Diğer Önemli Tablolar:

📋 Slot Oyun Logları (slot_logs):

Kayıt Sayısı: 2968882

id	user_id	bet	win	created_at	prize_type
2978158	5	1	0	2026-05-08 21:19:04	ticket_spent
2978157	5	1	6	2026-05-08 21:19:01	bilet
2978156	5	1	0	2026-05-08 21:18:59	ticket_spent

📋 Scratch Oyun Logları (scratch_logs):

Kayıt Sayısı: 998783

id	user_id	bet	created_at	prize_type
1001626	1053	1	2026-04-14 17:34:12	ticket_spent
1001625	1053	1	2026-04-14 17:34:00	ticket_spent
1001624	1053	1	2026-04-14 17:33:47	ticket_spent

📋 Wheel Oyun Logları (wheel_logs):

Kayıt Sayısı: 1128780

id	user_id	bet_amount	win_amount	prize_type	created_at
1132077	1195	1.00	1.00	bilet	2026-04-14 17:38:23
1132076	1195	1.00	5.00	bilet	2026-04-14 17:38:07
1132075	1195	1.00	0.00	ticket_spent	2026-04-14 17:37:59

📋 Betyu Oyun Logları (betyu_logs):

Kayıt Sayısı: 3179

id	user_id	bet	selection	created_at	result_status	result_amount
3190	1047	25	win	2026-04-11 11:11:27	won	50
3189	1662	100	win	2026-04-11 11:11:27	won	200
3188	1287	100	win	2026-04-11 11:11:27	won	200

📋 Bakım Ayarları (maintenance_settings):

Kayıt Sayısı: 5

id	game_type	maintenance_password	created_at	updated_at	kick_timestamp
5	main	1219	2025-08-05 05:29:48	2025-09-26 08:56:39
4	betyu	1129	2025-08-04 05:34:34	2026-04-10 16:27:31	1754290312
3	wheel	1217	2025-08-04 05:28:40	2026-02-11 12:05:11

📋 Sponsor Türleri (sponsor_types):

Kayıt Sayısı: 13

id	name	display_name	is_active	created_at	updated_at
33	bigwino	BigWino	1	2025-07-01 15:16:01	2025-07-01 15:16:01
32	grandpasha	GrandPashaBet	1	2025-07-01 15:13:17	2025-07-01 15:13:17
31	epik	EpikBahis	1	2025-07-01 15:13:07	2025-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

id	user_id	sponsor_type_id	sponsor_id	status	rejection_note	admin_id	created_at	updated_at
101	1014	1	1	change_pending			2025-12-14 22:01:46	2025-12-14 22:01:46
100	1014	5	1	change_pending			2025-12-14 22:01:43	2025-12-14 22:01:43
99	1014	24	4	rejected	1	1014	2025-07-08 14:18:24	2025-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.