-- License logs table CREATE TABLE IF NOT EXISTS license_logs ( id INT AUTO_INCREMENT PRIMARY KEY, license_id INT, action VARCHAR(50), details TEXT, ip_address VARCHAR(45), created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, INDEX idx_license_id (license_id), INDEX idx_action (action), INDEX idx_created_at (created_at) ); <?php // config/database.php define('DB_HOST', 'localhost'); define('DB_NAME', 'license_system'); define('DB_USER', 'your_username'); define('DB_PASS', 'your_password');
// Authentication check (you should implement proper auth) $apiKey = $_SERVER['HTTP_X_API_KEY'] ?? null; if ($apiKey !== 'your-admin-api-key') { http_response_code(401); echo json_encode(['error' => 'Unauthorized']); exit; } php license key system github
/** * Cache validation result */ private function cacheValidation($data) { file_put_contents($this->cacheFile, json_encode([ 'timestamp' => time(), 'data' => $data ])); } -- License logs table CREATE TABLE IF NOT
public function getConnection() { return $this->connection; } '/Database
/** * Get license by key */ private function getLicense($licenseKey) { $sql = "SELECT * FROM licenses WHERE license_key = :license_key"; $stmt = $this->db->prepare($sql); $stmt->execute([':license_key' => $licenseKey]); return $stmt->fetch(); }
/** * Log license actions */ private function logAction($licenseId, $action, $details) { $sql = "INSERT INTO license_logs (license_id, action, details, ip_address) VALUES (:license_id, :action, :details, :ip_address)"; $stmt = $this->db->prepare($sql); $stmt->execute([ ':license_id' => $licenseId, ':action' => $action, ':details' => $details, ':ip_address' => $_SERVER['REMOTE_ADDR'] ?? null ]); } } <?php // src/LicenseValidator.php require_once DIR . '/Database.php';