🔧 SPEEDots Server Diagnostic

This tool checks your server configuration for SPEEDots Store API.

Server Time: 2026-03-01 01:52:37

1. PHP Environment

[PASS] PHP Version
Version: 8.2.4
Required: PHP 7.0 or higher
[PASS] PDO MySQL Extension
PDO and PDO_MySQL extensions are loaded
[PASS] JSON Support
JSON encoding/decoding available
[PASS] speedstore.php Exists
Path: C:\xampp\htdocs\speedots/speedstore.php
File found
Size: 56488 bytes
Modified: 2026-02-03 23:15:59
[FAIL] games/ Directory
Path: C:\xampp\htdocs\speedots/games
Directory does not exist. Create it: mkdir games && chmod 755 games

2. Database Connection

[PASS] Database Connection
Host: localhost
Database: speedots
User: root
Password: ******************************
✓ Connected successfully
[PASS] Database Exists
Database: speedots
Database exists
[PASS] published_games Table
Table exists with 27 columns
View Schema 
id                   int(11)         KEY:PRI
user_id              int(11)         KEY:MUL
title                text            
developer            text            
price                float           
description          text            
category             text            
content_type         varchar(20)     KEY:MUL
executable_path      text            
screenshot_path      text            
assets_path          text            
requirements         text            
status               text            
downloads            int(11)         
rating               float           
published_date       text            
submitted_date       text            
server_id            text            
download_url         text            
vendor_paypal_email  varchar(255)    
vendor_payout_percentage decimal(5,2)    
platform_fee_percentage decimal(5,2)    
image_path           text            
local_game_id        varchar(255)    
executable_name      varchar(255)    
screenshot_name      varchar(255)    
created_at           timestamp
[INFO] Published Games
Games in database: 0
No games published yet

3. API Functionality Test

[PASS] API Response Test
API can generate JSON responses:
{"success":true,"message":"API is working!","time":"2026-03-01 01:52:37"}

4. Recommendations

âš  Issues Found

Please fix the following issues:

  1. Create games/ directory with write permissions

5. Test Links

Manual API Tests

After fixing any issues above, test these endpoints:

6. Configuration Summary

Database Configuration:
  Host:     localhost
  Database: speedots
  User:     root
  Password: ******************************

File Paths:
  This file:    C:\xampp\htdocs\speedots\diagnostic.php
  speedstore:   C:\xampp\htdocs\speedots/speedstore.php
  games dir:    C:\xampp\htdocs\speedots/games

Server Info:
  PHP Version:  8.2.4
  Server:       Apache/2.4.56 (Win64) OpenSSL/1.1.1t PHP/8.2.4
  Document Root: C:/xampp/htdocs

SPEEDots Server Diagnostic v1.0 | Generated: 2026-03-01 01:52:37