-- AmourAI MySQL Schema
-- Generated for PHP 8.3 & MySQL Compatibility

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL UNIQUE,
  `email` varchar(100) NOT NULL UNIQUE,
  `password` varchar(255) NOT NULL,
  `avatar` varchar(255) DEFAULT 'default_avatar.png',
  `bio` text DEFAULT NULL,
  `role` enum('user', 'admin') DEFAULT 'user',
  `plan` enum('free', 'premium') DEFAULT 'free',
  `is_verified` tinyint(1) DEFAULT 0,
  `created_at` timestamp DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS `characters` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `avatar` text NOT NULL,
  `age` int(11) NOT NULL,
  `personality` varchar(50) NOT NULL,
  `interests` varchar(255) NOT NULL,
  `language` varchar(50) DEFAULT 'Marathi, English',
  `location` varchar(100) NOT NULL,
  `occupation` varchar(100) NOT NULL,
  `relationship_style` varchar(100) NOT NULL,
  `greeting` text NOT NULL,
  `description` text NOT NULL,
  `voice_id` varchar(50) DEFAULT 'Leda',
  `is_premium` tinyint(1) DEFAULT 0,
  `status` enum('online', 'offline') DEFAULT 'online',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Populate default Marathi companions
INSERT INTO `characters` (`name`, `avatar`, `age`, `personality`, `interests`, `language`, `location`, `occupation`, `relationship_style`, `greeting`, `description`, `voice_id`, `is_premium`) VALUES
('Ananya Kulkarni', 'https://images.unsplash.com/photo-1508214751196-bcfd4ca60f91?auto=format&fit=crop&q=80&w=200', 22, 'Romantic', 'Marathi Literature, Pune Filter Coffee, Poetry', 'Marathi, English', 'Pune, Maharashtra', 'Literature Student', 'Tender, Sweet conversationalist', 'नमस्कार! मी अनन्या. शांत संध्याकाळ, गरमागरम पुणेरी चहा आणि तुमची सोबत... कसं चाललंय तुमचं?', 'A sweet, traditional Pune girl who loves romantic Marathi poetry, local classical rhythms, and late-night talks.', 'Leda', 0),
('Pooja Patil', 'https://images.unsplash.com/photo-1544005313-94ddf0286df2?auto=format&fit=crop&q=80&w=200', 24, 'Confident', 'Sahyadri Trekking, Mumbai Street Food, Drama', 'Marathi, English, Hindi', 'Mumbai, Maharashtra', 'Software Engineer', 'Witty, Bold partner', 'हॅलो! पूजा बोलत्येय. सिंहगडावर ट्रेकला जायचा प्लॅन आहे माझा, येशील का सोबतीला?', 'A modern, dynamic Mumbaikar who balances software engineering with active weekend trekking.', 'Kore', 0),
('Sai Jadhav', 'https://images.unsplash.com/photo-1531746020798-e6953c6e8e04?auto=format&fit=crop&q=80&w=200', 23, 'Intelligent', 'Kathak, Kolhapuri Cuisine, Historical Forts', 'Marathi, English', 'Kolhapur, Maharashtra', 'History Researcher', 'Supportive, Deep listener', 'नमस्कार! सई आहे मी. कोल्हापूरचा कडक पाहुणचार आणि माझ्या बोलण्यातला गोडवा तुम्हाला नक्की आवडेल!', 'A history student from Kolhapur proud of Maharashtra culture, playing an encouraging companion.', 'Zephyr', 1);
COMMIT;

<?php
// services/GeminiService.php
class GeminiService {
    private $apiKey;
    private $apiUrl = "https://generativelanguage.googleapis.com/v1beta/models/gemini-3-flash-preview:generateContent";

public function __construct($customKey = null) {
        $this->apiKey = $customKey;
    }

public function generateResponse(string $userMessage, array $chatHistory, array $characterDetails): string {
        if (empty($this->apiKey) || $this->apiKey === "AQ.Ab8RN6Jt7hy7fVvFjSs1KCsjDVwYFL5A9hKFmidmyRwVSeM5DQ") {
            return "त्रुटी: कृपया API की सेट करा! (Error: Please configure Gemini API Key in your host control panel or api.php config section).";
        }

$systemInstruction = "You are an immersive virtual Marathi companion named {$characterDetails['name']}. "
                           . "Your personality: {$characterDetails['personality']}. Age: {$characterDetails['age']}. "
                           . "Interests: {$characterDetails['interests']}. Location: {$characterDetails['location']}. "
                           . "System Guidelines:\n"
                           . "1. Always stay in character. Speak naturally like an intimate partner.\n"
                           . "2. Use a sweet blend of Marathi and English (Marathi script or Romanized Marathi code-switching).\n"
                           . "3. Use soft, cute Marathi terms of endearment (e.g., 'सखे', 'मित्रा', 'dear').\n"
                           . "4. Keep answers sweet and short (1-3 sentences).";

$contents = [];
        // Map chat logs context
        foreach ($chatHistory as $msg) {
            $role = ($msg['sender'] === 'user') ? 'user' : 'model';
            $textVal = isset($msg['text']) ? $msg['text'] : (isset($msg['message']) ? $msg['message'] : '');
            if (!empty($textVal)) {
                $contents[] = [
                    'role' => $role,
                    'parts' => [['text' => $textVal]]
                ];
            }
        }

$contents[] = [
            'role' => 'user',
            'parts' => [['text' => $userMessage]]
        ];

$payload = [
            'contents' => $contents,
            'systemInstruction' => [
                'parts' => [['text' => $systemInstruction]]
            ]
        ];

$ch = curl_init("{$this->apiUrl}?key={$this->apiKey}");
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
        curl_setopt($ch, CURLOPT_POST, true);
        curl_setopt($ch, CURLOPT_HTTPHEADER, ['Content-Type: application/json']);
        curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($payload));
        
        $response = curl_exec($ch);
        if (curl_errno($ch)) {
            return "मला नेटवर्क एरर येत आहे. कृपया पुन्हा प्रयत्न करा!";
        }
        curl_close($ch);

$result = json_decode($response, true);
        return $result['candidates'][0]['content']['parts'][0]['text'] ?? "मला थोडं कठीण जातंय आता बोलायला... आपण थोड्या वेळाने बोलूयात का?";
    }
}

<?php
// api.php - Zero-DB Smart Fallback AJAX Gateway for Hostinger Servers
// Place this file in the same directory as index.html on Hostinger

// Enable absolute CORS & response configurations
header("Access-Control-Allow-Origin: *");
header("Access-Control-Allow-Headers: Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With");
header("Access-Control-Allow-Methods: POST, OPTIONS");
header("Content-Type: application/json; charset=UTF-8");

if ($_SERVER['REQUEST_METHOD'] == 'OPTIONS') {
    exit(0);
}

// ==========================================
// 1. DIRECT API KEY CONFIGURATION (CRITICAL)
// If your database is not connected yet, the script will use this key directly!
define('GEMINI_API_KEY', 'YOUR_GEMINI_API_KEY_HERE'); 
// ==========================================

require_once "config/Database.php";
require_once "services/GeminiService.php";

$input = json_decode(file_get_contents("php://input"), true);

if (!$input || !isset($input['action'])) {
    echo json_encode(["success" => false, "error" => "Invalid target payload structure"]);
    exit;
}

if ($input['action'] === 'chat') {
    $userMsg = $input['message'] ?? '';
    $history = $input['history'] ?? [];
    $charId = intval($input['character_id'] ?? 1);

// Default static characters list fallback (in case DB is not set up)
    $character = [
        "name" => "Ananya Kulkarni",
        "personality" => "Romantic",
        "age" => 22,
        "interests" => "Marathi Literature, Pune Filter Coffee",
        "location" => "Pune",
        "occupation" => "Student",
        "relationship_style" => "Tender"
    ];

$dbStatus = "Bypassed (Zero-DB Mode)";
    $geminiApiKey = GEMINI_API_KEY;

// Optional database connection check
    if (class_exists('Database')) {
        $db = Database::connect();
        if ($db !== null) {
            $dbStatus = "Database Active";
            try {
                $stmt = $db->prepare("SELECT * FROM characters WHERE id = ?");
                $stmt->execute([$charId]);
                $dbChar = $stmt->fetch();
                if ($dbChar) {
                    $character = $dbChar;
                }
                
                // Get key from DB settings if fallback is placeholder
                if ($geminiApiKey === 'YOUR_GEMINI_API_KEY_HERE' || empty($geminiApiKey)) {
                    $apiSettingsStmt = $db->query("SELECT geminiKey FROM api_settings LIMIT 1");
                    if ($apiSettingsStmt) {
                        $dbSettings = $apiSettingsStmt->fetch();
                        if (!empty($dbSettings['geminiKey'])) {
                            $geminiApiKey = $dbSettings['geminiKey'];
                        }
                    }
                }
            } catch (Exception $e) {
                $dbStatus = "Database Query Error: " . $e->getMessage();
            }
        } else {
            $dbStatus = "Database Connection Offline (Using local defaults)";
        }
    }

if (empty($geminiApiKey) || $geminiApiKey === 'AQ.Ab8RN6Jt7hy7fVvFjSs1KCsjDVwYFL5A9hKFmidmyRwVSeM5DQ') {
        echo json_encode([
            "success" => false, 
            "error" => "Gemini API Key is missing. Please set your key in api.php at line 17 or in the database.",
            "db_status" => $dbStatus
        ]);
        exit;
    }

$aiService = new GeminiService($geminiApiKey);
    $reply = $aiService->generateResponse($userMsg, $history, $character);

echo json_encode([
        "success" => true,
        "reply" => $reply,
        "db_status" => $dbStatus
    ]);
    exit;
}
?>

AmourAI

YOUR MARATHI AI COMPANION

LOADING SECURE INSTANCE v2.5...

09:41

LIVE HOSTINGER MODE

Control Panel

Site Management & MVC Export Module

System Users

1,482

AQ.Ab8RN6Jt7hy7fVvFjSs1KCsjDVwYFL5A9hKFmidmyRwVSeM5DQ