QBESX
Agency-LifeinvaderV3 Configuración
Sistema publicitario moderno para FiveM con interfaz Liquid Glass, precios escalonados, categorías de anuncios, impulso.
v3.0.0De pago4 Páginas
01Configuración
Instalación rápida · config.lua · Agency-LifeinvaderV3
--[[ ═══════════════════════════════════════════
AGENCY LIFEINVADER V3 - CONFIGURATION
by Agency Scripts
═══════════════════════════════════════════ ]]
Config = {}
-- Framework auto-detection (ESX, QBCore, or standalone)
Config.Framework = 'auto'
-- Enable Database Integration (MySQL/MariaDB via oxmysql)
-- If false: Ads are not saved through restarts, recent feed is empty, settings are reset, and
-- admin panel cannot fetch or edit previous ads. Good for temporary servers.
Config.UseDatabase = true
-- Debug mode (set to true for detailed console/chat messages)
Config.Debug = false
-- Localization
-- Available: en, de, fr, es, it, pt, pl, nl, tr, ru, cs, sv, da, no, ro
Config.Locale = 'en'
Config.Localization = {
fallbackLocale = 'en', -- Missing translation keys fall back to English automatically
useLocaleNotifications = true
}
-- Use Agency Notify system
Config.UseAgencyNotify = true
-- ═══ UI BRANDING ══════════════════════════════
-- Customize the name and logo shown in all UI panels.
-- Change "BrandName" to match your server name (e.g. "WEAZEL NEWS", "LS ADVERTISER", etc.)
-- "BrandSubtitle" is the small text shown below the brand name in the main menu header.
-- "LogoFile" is the path to your logo image.
-- Option 1: Just the filename if it's in the web/ folder (e.g. "logo.png")
-- Option 2: Full nui:// path (e.g. "nui://Agency-LifeinvaderV3/web/logo.png")
-- Option 3: "" (empty string) to use the default SVG icon instead of an image
-- The logo should be a white/light-colored PNG with transparent background for best results.
-- IMPORTANT: Make sure your logo file is listed in the "files" block of fxmanifest.lua!
Config.UI = {
BrandName = 'LIFEINVADER', -- Main title shown in the menu header (uppercase recommended)
BrandSubtitle = 'Ad Agency v3', -- Subtitle shown below the brand name
LogoFile = 'nui://Agency-LifeinvaderV3/web/logo.png', -- Logo path ("" = use default icon)
}
-- ═══ COMMANDS ═══════════════════════════════
-- All commands are configurable. Prefix "al" = Agency Lifeinvader
Config.Commands = {
main = 'alad', -- Open ad creation menu
recent = 'alfeed', -- Open recent ads feed
test = 'altest', -- Show a test notification
admin = 'aladmin' -- Open admin panel
}
-- ═══ KEY BINDINGS ═══════════════════════════
-- Key to open the main menu (F6 = 167)
Config.OpenKey = 167
-- Key to open recent ads menu (F5 = 166)
Config.RecentKey = 166
-- ═══ ADVERTISEMENT SETTINGS ═════════════════
Config.Price = 5000 -- Base price per ad
Config.MaxReps = 5 -- Maximum repetitions
Config.MinInterval = 30 -- Minimum interval in seconds
Config.MaxInterval = 300 -- Maximum interval in seconds
Config.MaxLength = 300 -- Maximum message length
Config.DisplayDuration = 8000 -- Default how long notifications show (ms)
Config.MaxDisplayDuration = 60 -- Max display duration players can choose (seconds)
Config.CostPerSecond = 500 -- Additional cost per second of display duration
Config.TickerInterval = 15 -- How often the server checks for ads (seconds)
Config.InitialDelay = 0 -- Default delay before first send
Config.NotificationColor = '#3b82f6' -- Global accent color for all notifications
-- ═══ AD CATEGORIES ═════════════════════════
Config.Categories = {
{ id = 'jobs', label = 'Jobs', emoji = '💼' },
{ id = 'vehicles', label = 'Vehicles', emoji = '🚗' },
{ id = 'realestate', label = 'Real Estate', emoji = '🏠' },
{ id = 'services', label = 'Services', emoji = '🔧' },
{ id = 'events', label = 'Events', emoji = '🎉' },
{ id = 'other', label = 'Other', emoji = '📌' }
}
-- Category-specific behavior (language-neutral, reused by UI + server logic)
Config.CategoryRules = {
jobs = {
priceMultiplier = 0.9, -- Price multiplier (0.9 = 10% cheaper)
priorityBonus = 2, -- Queue priority boost
requireApproval = false, -- Require admin approval for this category
maxRepetitions = 4, -- Max repetitions for this category
minInterval = 30 -- Min interval in seconds for this category
},
vehicles = {
priceMultiplier = 1.15,
priorityBonus = 1,
requireApproval = false,
maxRepetitions = 5,
minInterval = 45
},
realestate = {
priceMultiplier = 1.25,
priorityBonus = 1,
requireApproval = true,
maxRepetitions = 4,
minInterval = 60
},
services = {
priceMultiplier = 1.0,
priorityBonus = 2,
requireApproval = false,
maxRepetitions = 5,
minInterval = 30
},
events = {
priceMultiplier = 1.1,
priorityBonus = 3,
requireApproval = false,
maxRepetitions = 5,
minInterval = 30
},
other = {
priceMultiplier = 1.0,
priorityBonus = 0,
requireApproval = false,
maxRepetitions = 3,
minInterval = 45
}
}
-- ═══ AGENCY EMPLOYEE PANEL ═════════════════
-- Configure a job/company whose employees can access the Agency panel.
-- Employees can manage ads and earn commission from each ad placed through them.
Config.Agency = {
enabled = true,
command = 'alagency', -- Command to open the agency panel
-- Job/company requirements (framework-dependent)
job = 'lifeinvader', -- Job name (ESX/QBCore job)
minGrade = 0, -- Minimum grade/rank required
-- Commission settings
commissionPercent = 10, -- Percentage of ad revenue paid to the employee
commissionType = 'cash', -- 'cash' or 'bank'
-- Agency account (shared company money pot)
useCompanyAccount = true, -- If true, ad revenue goes to a shared account
companyAccountName = 'lifeinvader_agency', -- Account identifier for company funds
}
-- ═══ ANONYMOUS ADS ═════════════════════════
Config.AllowAnonymous = true -- Allow players to post anonymously
-- ═══ BOOST SYSTEM ══════════════════════════
Config.BoostMultiplier = 2 -- Price multiplier for boosted ads (2x)
Config.BoostEnabled = true -- Enable the boost feature
-- ═══ ADMIN SETTINGS ═════════════════════════
Config.Admin = {
-- Who can use the admin panel?
-- 'ace' = uses ace permissions (group.admin)
-- 'identifier' = uses a list of identifiers
-- 'framework' = uses framework admin detection
permissionType = 'ace',
-- If permissionType = 'identifier', list allowed identifiers
allowedIdentifiers = {
-- 'license:xxxx',
-- 'steam:xxxx',
},
-- Require admin approval before ads go live?
requireApproval = false,
-- Maximum ads shown in admin panel
maxAdsInPanel = 50
}
-- ═══ V3 FEATURE FLAGS ════════════════════════
Config.Features = {
agencyAI = true, -- Enable heuristic AI moderation
playerLimits = true, -- Enable cooldown/limit system
adminLogs = true, -- Show activity logs in admin panel
adminBulkActions = true, -- Allow bulk approve/reject/delete in admin panel
adminActivityFeed = true, -- Show recent activity feed in admin panel
adminLogDetails = true, -- Show detailed log entries
adminSearch = true, -- Enable search bar in admin panel
adminStats = true, -- Show statistics in admin panel
scheduleOverview = true, -- Show schedule overview in history tab
queueInsights = true, -- Show queue insights in history tab
pendingEditing = true, -- Allow editing pending (under review) ads
categoryRules = true, -- Enable category rules system
scheduling = true, -- Enable ad scheduling
draftTitleEditing = true, -- Allow naming drafts
drafts = true -- Enable draft system
}
-- ═══ PLAYER LIMITS / FLOW CONTROL ════════════
Config.PlayerLimits = {
cooldownSeconds = 45, -- Time between ad submissions
maxPendingAds = 3, -- Max waiting-for-review ads per player
maxActiveAds = 4, -- Max currently running approved ads per player
adminBypass = true -- Allow admins to bypass these limits
}
-- ═══ SCHEDULING ══════════════════════════════
Config.Scheduling = {
enabled = true,
maxMinutesAhead = 1440 -- How far ahead players can schedule (1440 = 24 hours)
}
-- ═══ AGENCY AI (HEURISTIC, NO EXTERNAL AI) ═══
-- Built-in heuristic system that flags suspicious ads for manual review.
-- This does NOT use any external AI API — it runs locally on the server.
Config.AgencyAI = {
enabled = true,
autoNormalizeWhitespace = true, -- Auto-clean excessive whitespace
forceApprovalOnFlag = true, -- Force admin approval when AI flags an ad
scoreThreshold = 4, -- Penalty score threshold to trigger a flag
duplicateWindowMinutes = 30, -- Time window to check for duplicate ads
duplicateThreshold = 1, -- How many duplicates before flagging
externalLinkPatterns = { -- Patterns that count as external links
'http://',
'https://',
'www.',
'discord.gg',
'bit.ly'
},
suspiciousTerms = { -- Terms that trigger a penalty
'@everyone',
'free money',
'hack',
'exploit',
'cheap cash',
'real money'
},
categoryPriority = { -- Queue priority bonus per category
events = 3,
jobs = 2,
services = 2,
vehicles = 1,
realestate = 1,
other = 0
},
boostedBonus = 8, -- Extra priority score for boosted ads
penalties = { -- Penalty scores per violation type
duplicate_message = 3,
aggressive_frequency = 2,
excessive_caps = 1,
excessive_symbols = 1,
external_link = 2,
contact_heavy = 1,
suspicious_term = 2,
long_copy = 1
}
}
-- ═══ AI TEXT GENERATION ═════════════════════
-- Generate professional ad copy using AI. Players can click "Generate" in the ad form.
-- API key can also be set via server.cfg: set lifeinvader_ai_key "your-key"
Config.AIGeneration = {
enabled = true,
-- Provider: 'groq', 'openai', 'perplexity', 'claude'
provider = 'groq',
-- API keys per provider (leave empty to use server convar "lifeinvader_ai_key")
apiKeys = {
groq = '',
openai = '',
perplexity = '',
claude = ''
},
-- Recommended models per provider
models = {
groq = '',
openai = 'gpt-4o-mini',
perplexity = '',
claude = ''
},
-- API endpoints per provider
endpoints = {
groq = 'https://api.groq.com/openai/v1/chat/completions',
openai = 'https://api.openai.com/v1/chat/completions',
perplexity = 'https://api.perplexity.ai/chat/completions',
claude = 'https://api.anthropic.com/v1/messages'
},
-- Generation settings
maxTokens = 200,
temperature = 0.8,
-- System prompt for generating ad text
systemPrompt = 'You are an advertising copywriter for Lifeinvader (a social media platform in GTA/FiveM). Write short, catchy advertisement texts in the language the user writes in. Keep it under 250 characters. Be creative, professional and persuasive. Include a catchy title line followed by the ad body. Do NOT use hashtags or emojis. Respond ONLY with the ad text, nothing else.'
}
-- ═══ PLAYER SETTINGS (DEFAULTS) ═════════════
-- Default values for player-configurable settings.
-- Players can change these in their settings menu (gear icon).
Config.PlayerSettingsDefaults = {
notificationPosition = {x = 0, y = 50}, -- Default position (left side, vertically centered)
notificationEnabled = true, -- Can players disable ad notifications?
notificationScale = 1.0, -- Default UI scale (0.8 to 1.4)
uiTransparency = 0.55, -- Menu background opacity (0.1 to 1.0)
soundEnabled = true -- Play sounds on new ads?
}
-- ═══ SOUNDS ═════════════════════════════════
-- Native GTA sounds (soundName, soundSet)
Config.Sounds = {
openMenu = { name = "SELECT", set = "HUD_FRONTEND_DEFAULT_SOUNDSET" },
closeMenu = { name = "CANCEL", set = "HUD_FRONTEND_DEFAULT_SOUNDSET" },
submitAd = { name = "PURCHASE", set = "HUD_LIQUOR_STORE_SOUNDSET" },
newAd = { name = "TEXT_ARRIVE_TONE", set = "HUD_AWARDS" }
}
-- ═══ NOTIFICATION SETTINGS ══════════════════
Config.AdNotification = {
enabled = true,
position = {x = 0, y = 50}, -- Default position (left side, vertically centered)
duration = 6000, -- Display duration in milliseconds
maxWidth = 380, -- Max notification width in pixels
showAuthor = true -- Show who posted the ad
}
-- ═══ MONEY SETTINGS ═════════════════════════
Config.Money = {
type = "cash", -- "cash" or "bank"
removeOnSubmit = true, -- Set to false if you handle money elsewhere
agencyPay = true -- Allow payment via Agency-Pay (requires agency-phone)
}
-- ═══ NOTIFICATION MESSAGES ══════════════════
-- These are the server-side notification texts sent to players.
Config.Notification = {
useAgencyNotify = true,
successMessage = "Advertisement submitted successfully!",
errorMessage = "Not enough money to submit advertisement!",
pendingMessage = "Your ad has been submitted and is awaiting admin approval.",
adminPendingMessage = "A new advertisement is waiting for admin review.",
approvedMessage = "Your ad has been approved and will be broadcast soon!",
rejectedMessage = "Your ad has been rejected by an admin.",
aiPendingMessage = "Agency AI flagged your ad for review before it can go live.",
cooldownMessage = "Please wait %s seconds before submitting another advertisement.",
pendingLimitMessage = "You already have %s advertisements waiting for review.",
activeLimitMessage = "You already have %s active advertisements running."
}
02Archivo SQL
Importa este archivo SQL en tu base de datos antes de iniciar el recurso:
-- ═══════════════════════════════════════════
-- AGENCY LIFEINVADER V3 - DATABASE SETUP
-- by Agency Scripts
-- ═══════════════════════════════════════════
CREATE TABLE IF NOT EXISTS `lifeinvader_ads` (
`id` INT AUTO_INCREMENT PRIMARY KEY,
`identifier` VARCHAR(100) NOT NULL,
`author_name` VARCHAR(100) DEFAULT 'Anonymous',
`message` TEXT NOT NULL,
`category` VARCHAR(50) DEFAULT 'other',
`anonymous` TINYINT DEFAULT 0,
`boosted` TINYINT DEFAULT 0,
`repetitions_total` INT DEFAULT 1,
`repetitions_left` INT DEFAULT 1,
`interval_seconds` INT DEFAULT 60,
`display_duration` INT DEFAULT 8,
`status` ENUM('pending','active','completed','rejected') DEFAULT 'active',
`approved` TINYINT DEFAULT 1,
`approved_by` VARCHAR(100) DEFAULT NULL,
`rejected_reason` TEXT DEFAULT NULL,
`next_send_time` DATETIME DEFAULT NULL,
`created_at` DATETIME DEFAULT CURRENT_TIMESTAMP,
`updated_at` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
INDEX `idx_identifier` (`identifier`),
INDEX `idx_status` (`status`),
INDEX `idx_approved` (`approved`),
INDEX `idx_category` (`category`),
INDEX `idx_boosted` (`boosted`),
INDEX `idx_next_send` (`next_send_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS `lifeinvader_player_settings` (
`id` INT AUTO_INCREMENT PRIMARY KEY,
`identifier` VARCHAR(100) NOT NULL UNIQUE,
`notification_position` VARCHAR(20) DEFAULT '0,50',
`notification_enabled` TINYINT DEFAULT 1,
`notification_scale` FLOAT DEFAULT 1.0,
`ui_transparency` FLOAT DEFAULT 0.55,
`accent_color` VARCHAR(20) DEFAULT '#3b82f6',
`sound_enabled` TINYINT DEFAULT 1,
`admin_panel_scale` FLOAT DEFAULT 1.0,
`created_at` DATETIME DEFAULT CURRENT_TIMESTAMP,
`updated_at` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
INDEX `idx_identifier` (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS `lifeinvader_ad_drafts` (
`id` INT AUTO_INCREMENT PRIMARY KEY,
`identifier` VARCHAR(100) NOT NULL,
`title` VARCHAR(120) DEFAULT NULL,
`message` TEXT NOT NULL,
`category` VARCHAR(50) DEFAULT 'other',
`anonymous` TINYINT DEFAULT 0,
`boosted` TINYINT DEFAULT 0,
`repetitions_total` INT DEFAULT 1,
`interval_seconds` INT DEFAULT 60,
`display_duration` INT DEFAULT 8,
`delay` INT DEFAULT 0,
`scheduled_for` DATETIME DEFAULT NULL,
`created_at` DATETIME DEFAULT CURRENT_TIMESTAMP,
`updated_at` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
INDEX `idx_identifier` (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS `lifeinvader_admin_logs` (
`id` INT AUTO_INCREMENT PRIMARY KEY,
`admin_identifier` VARCHAR(100) DEFAULT NULL,
`admin_name` VARCHAR(100) DEFAULT NULL,
`action` VARCHAR(64) NOT NULL,
`ad_id` INT DEFAULT NULL,
`metadata` LONGTEXT DEFAULT NULL,
`created_at` DATETIME DEFAULT CURRENT_TIMESTAMP,
INDEX `idx_action` (`action`),
INDEX `idx_ad_id` (`ad_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ═══ AUTO UPGRADE SYSTEM ═══
-- Safely adds missing columns without throwing errors on existing databases
DROP PROCEDURE IF EXISTS `UpgradeLifeinvaderColumns`;
DELIMITER //
CREATE PROCEDURE `UpgradeLifeinvaderColumns`()
BEGIN
DECLARE _dbName VARCHAR(255) DEFAULT DATABASE();
DECLARE cnt INT;
-- Add category column
SELECT COUNT(*) INTO cnt FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = _dbName AND TABLE_NAME = 'lifeinvader_ads' AND COLUMN_NAME = 'category';
IF cnt = 0 THEN
ALTER TABLE `lifeinvader_ads` ADD COLUMN `category` VARCHAR(50) DEFAULT 'other' AFTER `message`;
END IF;
-- Add anonymous column
SELECT COUNT(*) INTO cnt FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = _dbName AND TABLE_NAME = 'lifeinvader_ads' AND COLUMN_NAME = 'anonymous';
IF cnt = 0 THEN
ALTER TABLE `lifeinvader_ads` ADD COLUMN `anonymous` TINYINT DEFAULT 0 AFTER `category`;
END IF;
-- Add boosted column
SELECT COUNT(*) INTO cnt FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = _dbName AND TABLE_NAME = 'lifeinvader_ads' AND COLUMN_NAME = 'boosted';
IF cnt = 0 THEN
ALTER TABLE `lifeinvader_ads` ADD COLUMN `boosted` TINYINT DEFAULT 0 AFTER `anonymous`;
END IF;
-- Add ui_transparency column to player settings
SELECT COUNT(*) INTO cnt FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = _dbName AND TABLE_NAME = 'lifeinvader_player_settings' AND COLUMN_NAME = 'ui_transparency';
IF cnt = 0 THEN
ALTER TABLE `lifeinvader_player_settings` ADD COLUMN `ui_transparency` FLOAT DEFAULT 0.55 AFTER `notification_scale`;
END IF;
-- Add accent_color column to player settings
SELECT COUNT(*) INTO cnt FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = _dbName AND TABLE_NAME = 'lifeinvader_player_settings' AND COLUMN_NAME = 'accent_color';
IF cnt = 0 THEN
ALTER TABLE `lifeinvader_player_settings` ADD COLUMN `accent_color` VARCHAR(20) DEFAULT '#3b82f6' AFTER `ui_transparency`;
END IF;
-- Add admin_panel_scale column to player settings
SELECT COUNT(*) INTO cnt FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = _dbName AND TABLE_NAME = 'lifeinvader_player_settings' AND COLUMN_NAME = 'admin_panel_scale';
IF cnt = 0 THEN
ALTER TABLE `lifeinvader_player_settings` ADD COLUMN `admin_panel_scale` FLOAT DEFAULT 1.0 AFTER `sound_enabled`;
END IF;
-- Add display_duration column to drafts
SELECT COUNT(*) INTO cnt FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = _dbName AND TABLE_NAME = 'lifeinvader_ad_drafts' AND COLUMN_NAME = 'display_duration';
IF cnt = 0 THEN
ALTER TABLE `lifeinvader_ad_drafts` ADD COLUMN `display_duration` INT DEFAULT 8 AFTER `interval_seconds`;
END IF;
-- Add delay column to drafts
SELECT COUNT(*) INTO cnt FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = _dbName AND TABLE_NAME = 'lifeinvader_ad_drafts' AND COLUMN_NAME = 'delay';
IF cnt = 0 THEN
ALTER TABLE `lifeinvader_ad_drafts` ADD COLUMN `delay` INT DEFAULT 0 AFTER `display_duration`;
END IF;
-- Add scheduling / review / AI fields
SELECT COUNT(*) INTO cnt FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = _dbName AND TABLE_NAME = 'lifeinvader_ads' AND COLUMN_NAME = 'scheduled_for';
IF cnt = 0 THEN
ALTER TABLE `lifeinvader_ads` ADD COLUMN `scheduled_for` DATETIME DEFAULT NULL AFTER `next_send_time`;
END IF;
SELECT COUNT(*) INTO cnt FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = _dbName AND TABLE_NAME = 'lifeinvader_ads' AND COLUMN_NAME = 'review_requested_at';
IF cnt = 0 THEN
ALTER TABLE `lifeinvader_ads` ADD COLUMN `review_requested_at` DATETIME DEFAULT NULL AFTER `approved`;
END IF;
SELECT COUNT(*) INTO cnt FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = _dbName AND TABLE_NAME = 'lifeinvader_ads' AND COLUMN_NAME = 'reviewed_at';
IF cnt = 0 THEN
ALTER TABLE `lifeinvader_ads` ADD COLUMN `reviewed_at` DATETIME DEFAULT NULL AFTER `review_requested_at`;
END IF;
SELECT COUNT(*) INTO cnt FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = _dbName AND TABLE_NAME = 'lifeinvader_ads' AND COLUMN_NAME = 'review_decision';
IF cnt = 0 THEN
ALTER TABLE `lifeinvader_ads` ADD COLUMN `review_decision` VARCHAR(32) DEFAULT NULL AFTER `reviewed_at`;
END IF;
SELECT COUNT(*) INTO cnt FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = _dbName AND TABLE_NAME = 'lifeinvader_ads' AND COLUMN_NAME = 'queue_priority';
IF cnt = 0 THEN
ALTER TABLE `lifeinvader_ads` ADD COLUMN `queue_priority` INT DEFAULT 0 AFTER `review_decision`;
END IF;
SELECT COUNT(*) INTO cnt FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = _dbName AND TABLE_NAME = 'lifeinvader_ads' AND COLUMN_NAME = 'ai_score';
IF cnt = 0 THEN
ALTER TABLE `lifeinvader_ads` ADD COLUMN `ai_score` INT DEFAULT 0 AFTER `queue_priority`;
END IF;
SELECT COUNT(*) INTO cnt FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = _dbName AND TABLE_NAME = 'lifeinvader_ads' AND COLUMN_NAME = 'ai_flags';
IF cnt = 0 THEN
ALTER TABLE `lifeinvader_ads` ADD COLUMN `ai_flags` LONGTEXT DEFAULT NULL AFTER `ai_score`;
END IF;
SELECT COUNT(*) INTO cnt FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = _dbName AND TABLE_NAME = 'lifeinvader_ads' AND COLUMN_NAME = 'admin_notes';
IF cnt = 0 THEN
ALTER TABLE `lifeinvader_ads` ADD COLUMN `admin_notes` LONGTEXT DEFAULT NULL AFTER `ai_flags`;
END IF;
-- Add display_duration column
SELECT COUNT(*) INTO cnt FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = _dbName AND TABLE_NAME = 'lifeinvader_ads' AND COLUMN_NAME = 'display_duration';
IF cnt = 0 THEN
ALTER TABLE `lifeinvader_ads` ADD COLUMN `display_duration` INT DEFAULT 8 AFTER `interval_seconds`;
END IF;
-- Indexes cannot be safely checked inline as easily in older MySQL,
-- but usually they don't break queries if missing. We only add them on fresh install via CREATE TABLE above.
END //
DELIMITER ;
CALL UpgradeLifeinvaderColumns();
DROP PROCEDURE IF EXISTS `UpgradeLifeinvaderColumns`;