Here's your card!
Your Recent Cards
';
data.history.forEach(item => {
historyHtml += `
`;
});
historyHtml += '
';
historyContainer.innerHTML = historyHtml;
} else {
historyContainer.innerHTML = '
${escapeHTML(item.full_name)}
${new Date(item.created_at).toLocaleDateString()}
No recent cards found. Generate one to get started!
'; } }) .catch(error => { console.error('History Error:', error); historyContainer.innerHTML = 'Could not load history.
'; }); }; /** * Displays an error message in the error box. * @param {string} message The error message to display. */ const showError = (message) => { errorBox.textContent = message; errorBox.style.display = 'block'; }; /** * Escapes HTML to prevent XSS. * @param {string} str The string to escape. */ const escapeHTML = (str) => { const p = document.createElement('p'); p.appendChild(document.createTextNode(str)); return p.innerHTML; }; // --- Initializations --- if (form) { form.addEventListener('submit', handleFormSubmit); } loadHistory(); }); FILE 19: /home/custom-business-cards.digitalprank.com/public_html/history.php code PHP false, 'history' => []]; $user_id = $_SESSION['user_id'] ?? 0; $session_id = session_id(); // Only fetch history for logged-in users or sessions with previous activity if ($user_id === 0 && empty($session_id)) { echo json_encode($response); exit; } // --- Database Connection --- $db_host = 'localhost'; $db_name = 'digitalprank_db'; $db_user = 'dp_user'; $db_pass = '#$Dealer2355'; $pdo = null; try { $pdo = new PDO("mysql:host=$db_host;dbname=$db_name;charset=utf8mb4", $db_user, $db_pass); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { http_response_code(500); $response['message'] = 'Service unavailable.'; echo json_encode($response); exit; } // Fetch the last 10 items for the user or session try { if ($user_id > 0) { $stmt = $pdo->prepare( "SELECT full_name, image_path, created_at FROM custom_business_cards WHERE user_id = :user_id ORDER BY id DESC LIMIT 10" ); $stmt->execute([':user_id' => $user_id]); } else { $stmt = $pdo->prepare( "SELECT full_name, image_path, created_at FROM custom_business_cards WHERE session_id = :session_id AND user_id = 0 ORDER BY id DESC LIMIT 10" ); $stmt->execute([':session_id' => $session_id]); } $history = $stmt->fetchAll(PDO::FETCH_ASSOC); if ($history) { $response['success'] = true; $response['history'] = $history; } } catch (PDOException $e) { // Log error, don't expose to user error_log('History fetch failed: ' . $e->getMessage()); http_response_code(500); $response['message'] = 'Could not retrieve history.'; } echo json_encode($response); FILE 20: /home/custom-business-cards.digitalprank.com/public_html/export.php code PHP setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { error_log("Cleanup Cron Failed: DB Connection Error - " . $e->getMessage()); die("DB Connection Error\n"); } // --- Load Retention Policy from Config --- $config_path = __DIR__ . '/../tool_config.json'; if (!file_exists($config_path)) { die("Config file not found.\n"); } $config = json_decode(file_get_contents($config_path), true); $retention_days = $config['tool']['database']['retention_days'] ?? 60; if ($retention_days <= 0) { echo "Data retention is disabled (retention_days <= 0). Exiting.\n"; exit; } // --- Main Cleanup Logic --- $deleted_files_count = 0; $deleted_rows_count = 0; try { // 1. Find old records to delete $stmt = $pdo->prepare( "SELECT id, image_path FROM custom_business_cards WHERE created_at < NOW() - INTERVAL :days DAY" ); $stmt->bindValue(':days', (int)$retention_days, PDO::PARAM_INT); $stmt->execute(); $records_to_delete = $stmt->fetchAll(PDO::FETCH_ASSOC); if (empty($records_to_delete)) { echo "No old records found to delete. Exiting.\n"; exit; } $ids_to_delete = []; foreach ($records_to_delete as $record) { $ids_to_delete[] = $record['id']; // 2. Delete the associated image file from the server $file_path = __DIR__ . '/../' . $record['image_path']; if (file_exists($file_path)) { if (unlink($file_path)) { $deleted_files_count++; } } } // 3. Delete the records from the database in a single query if (!empty($ids_to_delete)) { $id_placeholders = implode(',', array_fill(0, count($ids_to_delete), '?')); $delete_stmt = $pdo->prepare("DELETE FROM custom_business_cards WHERE id IN ({$id_placeholders})"); $delete_stmt->execute($ids_to_delete); $deleted_rows_count = $delete_stmt->rowCount(); } echo "Cleanup complete.\n"; echo "Deleted database rows: {$deleted_rows_count}\n"; echo "Deleted image files: {$deleted_files_count}\n"; } catch (PDOException $e) { error_log("Cleanup Cron Failed: " . $e->getMessage()); die("A database error occurred during cleanup.\n"); } FILE 3: /home/custom-business-cards.digitalprank.com/public_html/tool_form.php (REVISED AGAIN) code PHPYour generated card will appear here.
Admin Dashboard
Custom Business Card Generator
Quick Stats
Total Generations
Generations Today
Total Errors Logged
Recent Activity Log
| Timestamp | IP Address | Status | Processing Time (s) |
|---|---|---|---|
| No recent activity found. | |||
Your generated card will appear here.
Here's your card!
code
Code
```
FILE 37: /home/custom-business-cards.digitalprank.com/public_html/README.md
code
Markdown
# Custom Business Card Generator Tool
This directory contains the complete source code for the Custom Business Card Generator, a tool for the DigitalPrank platform.
## Project Structure
.
├── admin/ # Basic admin dashboard
├── assets/ # CSS, JS, fonts, and image templates
├── cron/ # Cron jobs (e.g., cleanup scripts)
├── includes/ # Core PHP functions and classes
├── lang/ # Language files (i18n)
├── results/ # Directory for generated images (user uploads)
├── tests/ # PHPUnit tests
├── api.php # Public API endpoint
├── deploy.sh # Deployment script
├── export.php # Handles file downloads (PNG, JPG, PDF)
├── history.php # Fetches user's generation history
├── processor.php # Main backend logic for form submissions
├── tool_config.json # Primary configuration for the tool
├── tool_form.php # The main HTML/PHP frontend file
└── ... other config files
code
Code
## Setup & Deployment
1. **Prerequisites:** Ensure you have a LAMP/LEMP stack with PHP 8.1+, MySQL, Composer, and the required PHP extensions (`gd`, `json`, `pdo_mysql`). The server needs `imagemagick` and `python3-venv`.
2. **Clone:** Place these files in the appropriate directory on your server (e.g., `/home/custom-business-cards.digitalprank.com/`).
3. **Database:** Ensure the core platform tables exist in your `digitalprank_db` database.
4. **Dependencies:**
* Run `composer install` in the root directory to install PHPUnit.
* The `deploy.sh` script handles system package and Python venv setup.
5. **Deployment:** Run the `deploy.sh` script to create necessary tables, directories, set permissions, and install cron jobs.
6. **Web Server:** Configure your web server (e.g., OpenLiteSpeed) to point the subdomain `custom-business-cards.digitalprank.com` to the `public_html` directory.
7. **Assets:** Replace the placeholder `.png` and `.ttf` files in `/assets/` with actual font and template files.
## Running Tests
From the `public_html` directory, run the following command:
```bash
./vendor/bin/phpunit
Cron Job
The deployment script installs a daily cron job that runs cron/cleanup.php. This script deletes old generated images and database records based on the retention_days setting in tool_config.json.
code
Code
### FILE 38: /home/custom-business-cards.digitalprank.com/public_html/composer.json
```json
{
"name": "digitalprank/custom-business-cards",
"description": "The Custom Business Card Generator tool.",
"type": "project",
"require-dev": {
"phpunit/phpunit": "^9.5"
},
"autoload": {
"psr-4": {
"App\\": "includes/"
}
},
"scripts": {
"test": "phpunit"
}
}
FILE 39: /home/custom-business-cards.digitalprank.com/public_html/phpunit.xml
code
Xml