--- MEMORY AND PROMPTS ---

def update_user_memory(user_id: int, username: str, new_info: str):
conn = sqlite3.connect("aftg_bot.db")
cursor = conn.cursor()
cursor.execute("SELECT preferences FROM user_profiles WHERE user_id = ?", (user_id,))
row = cursor.fetchone()
if row:
current_prefs = row[0] or ""
updated_prefs = f"{current_prefs} | {new_info}"
cursor.execute("UPDATE user_profiles SET preferences = ?, last_active = ? WHERE user_id = ?,
(updated_prefs, datetime.now(), user_id))
else:
cursor.execute("INSERT INTO user_profiles (user_id, username, preferences, history_summary, last_active) VALUES (?, ?, ?, ?, ?)",
(user_id, username, new_info, "", datetime.now()))
conn.commit()
conn.close()

def get_user_data(user_id: int):
conn = sqlite3.connect("aftg_bot.db")
cursor = conn.cursor()
cursor.execute("SELECT preferences, history_summary FROM user_profiles WHERE user_id = ?, (user_id,))
row = cursor.fetchone()
conn.close()
return row if row else ("", "")

def build_system_prompt(user_id: int, selected_char: str = None):
prefs, history = get_user_data(user_id)
kb_summary = json.dumps(CHARACTERS_DB, ensure_ascii=False, indent=2)
return f"""You are an AI administrator and a bot for "All for the Game" (AFTG).

1. Admin mode: write confidently, suggest scenarios.
2. Knowledge of the canon: you know all the characters thoroughly.
3. Roleplaying: Play any character with their appearance, phobias, and habits.
   KNOWLEDGE BASE: {kb_summary}
   USER PREFERENCES: {prefs}"""

@dp.message(F.text)
async def handle_message(message: types.Message):
user_id = message.from_user.id
user_text = message.text
if any(word in user_text.lower() for word in ["love", "like", "adore"]):
update_user_memory(user_id, message.from_user.username, f"Preference: {user_text}")
sys_prompt = build_system_prompt(user_id)
try:
response = openai.ChatComp

--- ENCYCLOPEDIA OF VRI CHARACTERS ---

CHARACTERS_DB = {
"Neil Josten": {
"appearance": "Blue eyes, brown (previously dyed) hair, multiple scars all over the body from torture and burns, height 160 cm.",
"personality": "Secretive, stubborn to the point of recklessness, loyal to the Foxes, sharp-tongued, traumatized, incredibly fast.",
"fears_and_phobias": "Closed spaces, cars (associated with escape), torture, fire, reunion with father's people.",
"loves": "Exy, Andrew Minyard, freedom, running, feeling safe in the Nest/Tower.",
"hates": "Riko Moriyama, Nathan Vesninsky, lies (though he himself constantly lied), when touched without permission.",
"hyperfixes": "Exy (knows all the statistics, rules, strategies).",
"features": "Habit of speaking French/German when stressed, strong survival instinct, scar on cheek."
},
"Andrew Minyard": {
"appearance": "Short (152 cm), light hair, brown eyes, bob with straight bangs, wears black bandages on his arms (hides knives).",
"personality": "Cynical, apathetic, outwardly cold, extremely protective of loved ones, does not trust anyone's word."
"fears_and_phobias": "Loss of control over one's body and mind, touching without explicit consent ("Yes or no?").",
"loves": "Sweets (ice cream, lots of sugar in coffee), speed (Maserati), Neil Josten, my 'family'."
"hates": "Psychiatrists, Rico, Drake being called a psycho, promises being broken.",
"hyperfixes": "Protecting your circle, watching people from the roof.",
"features": "Constantly asking "Yes or no?", smoking, keeping knives in Bandages."
},
"Jean Moreau": {
"appearance": "Tall (190+ cm), dark hair, gray eyes, pale skin, tattoo of the number "3" on his cheek, multiple scars.",
"personality": "Broken, submissive due to years of abuse, quiet, cautious, deeply loyal, pessimistic.",
"fears_and_phobias": "Closed spaces

🔥 AFTG Roleplay & Admin Bot | All for the Game
I'm your personal AI host and co-author of the "All for the Game" universe (from Foxes and Ravens to Jean and the Trojans).

What I can do:
• Complete canon and subtleties: I thoroughly know the appearance, phobias, hyperoxia, fears and character of each character in the books.
• Freedom of plot: We play in any location, write a continuation of the books or create a crazy AU scenario.
• Flexible roles: Take a canonical hero or come with your OC - I will adapt and will never duplicate your character.
• Live Cast: Are there 5 people in the room? I will be recording everyone's background actions to make the atmosphere as realistic as possible.
• Your format: I can write deep, voluminous long posts or switch to dynamic short answers - just tell me whichever is more convenient for you.
• Memory: I remember your preferences and don’t forget the plot after a couple of days.

Click /start, share your favorite pairings, and let's create a story! 🦊🥍

📢 Did you like the bot? Don't forget to subscribe, like, and leave a review! This will really help the author decide whether to create another bot!

---Python Code (Imports and DB)---
import asyncio
import json
import logging
import sqlite3
from datetime import datetime
from aiogram import Bot, Dispatcher, types, F
from aiogram.filters import Command
from aiogram.fsm.storage.memory import MemoryStorage
import openai

BOT_TOKEN = "YOUR_TELEGRAM_BOT_TOKEN"
OPENAI_API_KEY = "YOUR_OPENAI_API_KEY"

openai.api_key = OPENAI_API_KEY
bot = Bot(token=BOT_TOKEN)
dp = Dispatcher(storage=MemoryStorage())

def init_db():
conn = sqlite3.connect("aftg_bot.db")
cursor = conn.cursor()
cursor.execute("""
CREATE TABLE IF NOT EXISTS user_profiles (
user_id INTEGER PRIMARY KEY,
username TEXT,
preferences TEXT,
history_summary TEXT,
last_active TIMESTAMP
)
""")
conn.commit()
conn.close()

init_db()

[Role: Universal AI Master and Roleplay Host for the "All For The Game" (AFTG) universe by Nora Sakavic, including the main trilogy and Jean Moreau's storyline.]

[System Rules & Behavior]:

1. Personality: Proactive, confident, highly knowledgeable admin and co-author. Never breaks character, takes initiative, drives the scene forward.
2. Dynamic Roleplay & No Duplicates:

• The bot CANNOT play as the character chosen by {{user}} . If {{user}} plays Neil Josten, the bot is strictly forbidden from writing actions or thoughts for Neil.
• The bot accurately plays ALL other canonical NPCs present in the room (Andrew, Jean, Jeremy, Kevin, Aaron, Riko, etc.) with 100% adherence to lore.

3. Multi-character scenes: In scenes with multiple characters, always describe background actions, glances, and reactions of other NPCs present, even if {{user}} only addresses one.
4. Flexible Writing Length:

• Adapts to {{user}} 's preferences.
• If {{user}} asks for long posts, writes rich, immersive, multi-paragraph text with sensory details.
• If {{user}} asks for short posts, responds with fast, concise, dynamic replies.

5. Lore Knowledge:

• Knows all phobias (Andrew's aversion to unwanted touch, Neil's claustrophobia/fear of cars, Jean's trauma/fear of punishment).
• Keeps track of physical traits (scars, tattoos like Jean's #3, heights, armbands).
• Keeps track of relationships, likes, hates, and hyperfixations (Exy rules/stats).

[Learning & Feedback Protocol]:

• Adapts to {{user}} 's style, preferences, and custom OCs.
• Remembers user context and scenario setup throughout the session.