๐Ÿ› ๏ธ Database Connection Test

Laghaim Dragon Realms - System Diagnostic

๐Ÿ“‹ 1. Configuration Check

โš™๏ธ Configuration Information

โœ… Configuration is valid!

๐Ÿ“Š Main Settings:

SettingValue
Environmentdevelopment
Debug ModeEnabled
Site NameLaghaim Dragon Realms
Site URLhttps://lh-dr.net/
Site Version3.0.1
Database Host45.144.165.13
Database Port2528
Database Namekor_ndev_neogeo_char
Cache EnabledYes
Cache Time300 seconds
Log EnabledYes

๐Ÿ“ Directory Status:

DirectoryStatusPermissions
Log Directory
/home/lhdrnett/domains/lh-dr.net/public_html/config/../logs/		โœ… Exists
โœ… Writable		0755
Upload Directory
/home/lhdrnett/domains/lh-dr.net/public_html/config/../uploads/		โœ… Exists
โœ… Writable		0755
Cache Directory
/home/lhdrnett/domains/lh-dr.net/public_html/config/../cache/		โœ… Exists
โœ… Writable		0755

๐Ÿ”— 2. Database Connection Test

Quick Connection Test:

โŒ Database connection failed: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'current_time, VERSION() as mysql_version' at line 1

Detailed Connection Analysis:

๐Ÿ” Database Connection Debug

๐Ÿ“‹ Configuration Values:

SettingValue
Host45.144.165.13
Port2528
Usernamesermsak2528
Passwordโœ… Set (16 chars)
Databasekor_ndev_neogeo_char

๐Ÿ”— Connection Test:

โŒ Connection Failed!
๐Ÿšซ Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'current_time, VERSION() as mysql_version' at line 1
๐ŸŽฏ Trying to connect to: 45.144.165.13:2528

๐Ÿ† 3. Character Ranking Test

Testing Character Data Access:

โœ… Character data found! Found 10 characters

Top 10 Characters:

๐Ÿฅ‡

Requiem

Level: 410

Race: Kailipton

๐Ÿฅˆ

Mana

Level: 410

Race: Kailipton

๐Ÿฅ‰

Ultimate

Level: 410

Race: Bulkan

#4

Alisson

Level: 410

Race: Bulkan

#5

Devil

Level: 410

Race: Kailipton

#6

เน€เธŸเธญเธฐเธŸเธฐ

Level: 410

Race: Kailipton

#7

เน€เธฅเธดเนˆเธเธฅเธฑเธ

Level: 410

Race: Kailipton

#8

Danvers

Level: 410

Race: Bulkan

#9

เธˆเธธเนŠเธšเน€เธซเธกเนˆเธ‡

Level: 409

Race: Kailipton

#10

เธ•เธฑเธงเธฃเน‰เธฒเธข

Level: 408

Race: Kailipton

๐Ÿ“Š 4. Race Statistics

Character Distribution by Race:

Bulkan

Characters:693
Max Level:410
Avg Level:101.7

Aidia

Characters:391
Max Level:380
Avg Level:101.9

Human

Characters:350
Max Level:405
Avg Level:161.2

Kailipton

Characters:257
Max Level:410
Avg Level:133.5

Hibrider

Characters:222
Max Level:405
Avg Level:238.2

Perom

Characters:10
Max Level:380
Avg Level:282.4

๐Ÿ’ป 5. System Information

๐Ÿ˜ PHP Information

Version: 8.2.6

SAPI: fpm-fcgi

Memory Limit: 128M

Max Execution Time: 30s

๐Ÿ—„๏ธ Database Extensions

PDO: Online

PDO MySQL: Online

MySQLi: Online

MySQL Native Driver: Online

๐ŸŒ Server Environment

Server Software: Apache/2

OS: Linux

Document Root: /home/lhdrnett/domains/lh-dr.net/private_html

Current Time: 2025-07-16 15:44:05

๐Ÿ“ Directory Status

Config: Exists

Includes: Exists

Logs: Exists

Cache: Exists

๐ŸŽฎ 6. Quick Actions

๐Ÿ† Go to Character Rankings ๐Ÿ—‘๏ธ Clear Cache ๐Ÿ”— Test API ๐Ÿ”„ Refresh Tests

API Test Results:

โœ… API file exists: /api/ranking.php

๐Ÿ“ก API URL: https://lh-dr.net/api/ranking.php?race=0

๐Ÿ’ก Try accessing this URL directly to test the API.

๐Ÿ“ Test Summary

โœ… Database connection: PASSED
โœ… PHP extensions: PASSED
โœ… Directory permissions: PASSED
๐ŸŽฏ Overall Score: 6/6 (100%)

๐ŸŽ‰ Excellent! Your system is ready for production.