Content Moderation: Celebrity Text Messages
Reviewing the 100 most recent creations. Click an image to enlarge.
No content has been generated yet.
| Check | Status | Details |
|---|
No tool specified. Please provide a tool_slug parameter.
'; return; } // Fetch basic tool info from the database global $wpdb; $tool = $wpdb->get_row($wpdb->prepare( "SELECT name, description, created_at FROM {$wpdb->prefix}digitalprank_tools WHERE slug = %s", $tool_slug )); if (!$tool) { echo 'Tool not found.
description); ?>
Could not load dashboard data: ${error.message}
No tool specified.
'; return; } global $wpdb; // Simplified DB connection for standalone demo $db_host = 'localhost'; $db_name = 'digitalprank_db'; $db_user = 'dp_user'; $db_pass = '#$Dealer2355'; $pdo = new PDO("mysql:host=$db_host;dbname=$db_name;charset=utf8mb4", $db_user, $db_pass); // Fetch recent generations from the tool-specific table // This assumes the table name is predictable, which it is from our config. $table_name = 'celebrity_chat_history'; // This would be dynamic in a multi-tool platform $stmt = $pdo->prepare( "SELECT id, user_id, celebrity_name, image_path, created_at FROM `{$table_name}` WHERE deleted_at IS NULL ORDER BY id DESC LIMIT 100" ); $stmt->execute(); $generations = $stmt->fetchAll(PDO::FETCH_ASSOC); ?>Reviewing the 100 most recent creations. Click an image to enlarge.
No content has been generated yet.
DELETED
'; } else if (action === 'approve') { itemElement.style.border = '2px solid green'; itemElement.querySelector('.actions').innerHTML = 'APPROVED
'; } } else { alert(`Failed to ${action} item: ${data.error || 'Unknown error'}`); } }) .catch(error => { console.error('Moderation error:', error); alert('An error occurred while communicating with the server.'); }); } FILE 35: /home/wp.digitalprank.com/public_html/wp-content/themes/digitalprank-admin/ajax/moderation-endpoint.php code PHP false, 'error' => 'Invalid parameters.']); exit; } $db_host = 'localhost'; $db_name = 'digitalprank_db'; $db_user = 'dp_user'; $db_pass = '#$Dealer2355'; $pdo = new PDO("mysql:host=$db_host;dbname=$db_name;charset=utf8mb4", $db_user, $db_pass); $table_name = 'celebrity_chat_history'; // Map tool_slug to table try { if ($action === 'delete') { // Soft delete the item $stmt = $pdo->prepare("UPDATE `{$table_name}` SET deleted_at = NOW() WHERE id = ?"); $stmt->execute([$item_id]); } elseif ($action === 'approve') { // In a more complex system, you might have a 'status' column. // For now, we'll just log the approval action. error_log("Admin approved content item #{$item_id} from table `{$table_name}`."); } echo json_encode(['success' => true]); } catch (Exception $e) { http_response_code(500); echo json_encode(['success' => false, 'error' => $e->getMessage()]); } FILE 36: /home/custom-celebrity-texts.digitalprank.com/public_html/install.sql (Updated) code SQL -- ================================================================= -- UPDATE SCRIPT FOR CUSTOM CELEBRITY TEXTS TOOL V1.4 -- ================================================================= -- This script adds a table to manage one-off credits purchased by users, -- enabling the single-purchase monetization feature. -- ================================================================= CREATE TABLE IF NOT EXISTS `wp_digitalprank_one_off_credits` ( `id` BIGINT PRIMARY KEY AUTO_INCREMENT, `user_id` BIGINT NOT NULL, `tool_slug` VARCHAR(100) NOT NULL, `credits_granted` INT DEFAULT 1, `credits_used` INT DEFAULT 0, `transaction_id` VARCHAR(255) NULL, `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `last_used_at` TIMESTAMP NULL, INDEX `user_tool_credit_idx` (`user_id`, `tool_slug`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- ================================================================= -- UPDATE COMPLETE -- The processor.php logic should be updated to check for and consume -- these credits for non-pro users who have exceeded their daily free limit. -- ================================================================= Model ThinkingThoughts (experimental) Auto Expand to view model thoughts chevron_right Excellent. The platform is robust, but the monetization loop is not yet complete. We have a system to grant one-off credits via a payment handler, but the main tool processor does not yet consume these credits. This final step will fully integrate the single-purchase feature, making it a viable alternative for users who have hit their daily free limit but do not wish to subscribe. FILE 37: /home/custom-celebrity-texts.digitalprank.com/public_html/user_status_handler.php code PHP false]; $user_id = isset($_SESSION['user_id']) ? (int)$_SESSION['user_id'] : null; try { $db_host = 'localhost'; $db_name = 'digitalprank_db'; $db_user = 'dp_user'; $db_pass = '#$Dealer2355'; $pdo = new PDO("mysql:host=$db_host;dbname=$db_name;charset=utf8mb4", $db_user, $db_pass); $config = json_decode(file_get_contents('tool_config.json'), true)['tool']; $tool_slug = $config['identity']['slug']; $can_generate = false; $reason = 'unknown'; $can_purchase = $config['billing']['one_off_enabled'] && $user_id; $has_credit = false; // Fetch user access level $stmt_access = $pdo->prepare("SELECT status FROM wp_pms_member_subscriptions WHERE user_id = ? ORDER BY id DESC LIMIT 1"); $stmt_access->execute([$user_id]); $is_pro = $stmt_access->fetchColumn() === 'active'; if ($is_pro) { $can_generate = true; $reason = 'pro_access'; } else { // Check daily usage $limit = $config['limits']['tier_daily']['free']; $key = $user_id ? "user_id" : "ip_address"; $value = $user_id ? $user_id : $_SERVER['REMOTE_ADDR']; $stmt_usage = $pdo->prepare("SELECT COUNT(*) FROM wp_digitalprank_usage WHERE tool_slug = ? AND {$key} = ? AND timestamp >= CURDATE()"); $stmt_usage->execute([$tool_slug, $value]); $count = $stmt_usage->fetchColumn(); if ($count < $limit) { $can_generate = true; $reason = 'within_free_limit'; } else { // Daily limit exceeded, check for a one-off credit if ($user_id) { $stmt_credit = $pdo->prepare( "SELECT id FROM wp_digitalprank_one_off_credits WHERE user_id = ? AND tool_slug = ? AND credits_used < credits_granted" ); $stmt_credit->execute([$user_id, $tool_slug]); if ($stmt_credit->fetch()) { $can_generate = true; $has_credit = true; $reason = 'has_one_off_credit'; } else { $reason = 'limit_exceeded_no_credit'; } } else { $reason = 'limit_exceeded_anonymous'; $can_purchase = false; // Anonymous users can't buy credits } } } $response = [ 'success' => true, 'status' => [ 'can_generate' => $can_generate, 'reason' => $reason, 'is_pro' => $is_pro, 'has_credit' => $has_credit, 'can_purchase' => $can_purchase, 'price_cents' => $config['billing']['one_off_price_cents'] ] ]; } catch (Exception $e) { $response['message'] = 'Could not determine user status.'; error_log("User Status Handler Error: " . $e->getMessage()); } echo json_encode($response); FILE 38: /home/custom-celebrity-texts.digitalprank.com/public_html/processor.php (Updated)```php false, 'message' => 'An unknown error occurred.']; $user_id = isset($_SESSION['user_id']) ? (int)$_SESSION['user_id'] : null; $status = 'failed'; $output_data = []; $credit_to_consume_id = null; // Variable to track if we're using a purchased credit try { $db_host = 'localhost'; $db_name = 'digitalprank_db'; $db_user = 'dp_user'; $db_pass = '#$Dealer2355'; $pdo = new PDO("mysql:host=$db_host;dbname=$db_name;charset=utf8mb4", $db_user, $db_pass); $config = json_decode(file_get_contents('tool_config.json'), true)['tool']; $tool_slug = $config['identity']['slug']; // ... (Rate Limiting, CSRF checks from File 26) ... $input = $_POST; $access = getUserAccessLevel($pdo, $user_id, $tool_slug); $usage = checkDailyUsage($pdo, $tool_slug, $user_id, $access['tier'], $config['limits']['tier_daily']); if ($usage['exceeded'] && !$access['has_pro_access']) { // Daily limit exceeded for a non-pro user, check for a purchased credit. if ($user_id) { $stmt_credit = $pdo->prepare( "SELECT id FROM wp_digitalprank_one_off_credits WHERE user_id = ? AND tool_slug = ? AND credits_used < credits_granted ORDER BY id ASC LIMIT 1" ); $stmt_credit->execute([$user_id, $tool_slug]); $credit_id = $stmt_credit->fetchColumn(); if ($credit_id) { $credit_to_consume_id = $credit_id; // Found a valid credit, flag it for consumption on success. } else { throw new Exception("You have exceeded your daily free limit. Please upgrade to Pro or purchase a single generation credit."); } } else { throw new Exception("You have exceeded your daily free limit. Please log in to continue or purchase a credit."); } } // --- (Tool processing, file uploads, AI, image generation from File 15 remains here) --- // ... This logic remains the same ... $status = 'success'; $response = ['success' => true, 'data' => $output_data, 'access' => $access]; // *** FINAL STEP: Consume the credit if one was used *** if ($credit_to_consume_id) { $stmt_consume = $pdo->prepare( "UPDATE wp_digitalprank_one_off_credits SET credits_used = credits_used + 1, last_used_at = NOW() WHERE id = ?" ); $stmt_consume->execute([$credit_to_consume_id]); error_log("Consumed one-off credit ID {$credit_to_consume_id} for user {$user_id}."); } } catch (Exception $e) { $response['message'] = $e->getMessage(); } // ... (Logging logic remains the same) ... if (isset($pdo) && isset($config)) { // We don't log usage against the daily limit if a credit was used $credits_used = $credit_to_consume_id ? 0 : $config['billing']['credit_cost']; logUsage($pdo, $user_id, $tool_slug, 'generate', $input, $output_data, (microtime(true) - $start_time), $status, $credits_used); } echo json_encode($response); ``` ### FILE 39: /home/custom-celebrity-texts.digitalprank.com/public_html/tool_form.php (Updated) ```php