{"slug":"chatbot","name":"WPBot – AI ChatBot for Live Support, Lead Generation, WordPress Automation, AI Services","description":"AI ChatBot & Automation for WordPress WPBot. 24/7 Live Chat Customer Support. NATIVE, AI Actions, Forms, Leads, Gemini, ChatGPT, Claude, OpenRouter ✨","author":"QuantumCloud","active_installs":5000,"version":"8.8.9","wp_org_url":"https://wordpress.org/plugins/chatbot/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"qcin_","full_table_name":"wp_qcin_","description":"Stores qcin  data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"qcld_wpbot_ai_seo_ai_usage","full_table_name":"wp_qcld_wpbot_ai_seo_ai_usage","description":"Stores qcld wpbot ai seo ai usage data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"qcld_wpbot_ai_seo_content_articles","full_table_name":"wp_qcld_wpbot_ai_seo_content_articles","description":"Stores qcld wpbot ai seo content articles data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"qcld_wpbot_ai_seo_content_images","full_table_name":"wp_qcld_wpbot_ai_seo_content_images","description":"Stores qcld wpbot ai seo content images data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"qcld_wpbot_ai_seo_content_presets","full_table_name":"wp_qcld_wpbot_ai_seo_content_presets","description":"Stores qcld wpbot ai seo content presets data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"qcld_wpbot_ai_seo_log","full_table_name":"wp_qcld_wpbot_ai_seo_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"qcld_wpbot_ai_seo_modules","full_table_name":"wp_qcld_wpbot_ai_seo_modules","description":"Stores qcld wpbot ai seo modules data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"module_id","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"is_active","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"settings","type":"longtext","nullable":true,"primary_key":false},{"name":"activated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"module_id","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"level","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"message","type":"text","nullable":false,"primary_key":false},{"name":"context","type":"longtext","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"connection_id","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"connection_name","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"provider","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"model","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"task","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"prompt_tokens","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"completion_tokens","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"success","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_qcld_wpbot_ai_seo_modules ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, module_id varchar(50) NOT NULL, is_active tinyint(1) NOT NULL DEFAULT 1, settings longtext, activated_at datetime DEFAULT NULL, updated_at datetime DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY idx_module_id (module_id) ) {$charset_collate};\"; // Activity log. $tables[] = \"CREATE TABLE wp_qcld_wpbot_ai_seo_log ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, module_id varchar(50) DEFAULT 'core', level varchar(20) NOT NULL DEFAULT 'info', message text NOT NULL, context longtext, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_module (module_id), KEY idx_level (level), KEY idx_created (created_at) ) {$charset_collate};\"; // AI usage log (token accounting per generation call). $tables[] = \"CREATE TABLE wp_qcld_wpbot_ai_seo_ai_usage ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, connection_id varchar(64) NOT NULL DEFAULT '', connection_name varchar(191) NOT NULL DEFAULT '', provider varchar(50) NOT NULL DEFAULT '', model varchar(191) NOT NULL DEFAULT '', task varchar(50) NOT NULL DEFAULT 'text', prompt_tokens bigint(20) unsigned NOT NULL DEFAULT 0, completion_tokens bigint(20) unsigned NOT NULL DEFAULT 0, success tinyint(1) NOT NULL DEFAULT 1, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_created (created_at), KEY idx_connection (connection_id) ) {$charset_collate};\"; // Background AI job queue. foreach ( $tables as $sql ) { dbDelta( $sql );"},{"table_name":"qcwpbot_subscribers","full_table_name":"wp_qcwpbot_subscribers","description":"Stores qcwpbot subscribers data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"rag_documents","full_table_name":"wp_rag_documents","description":"Stores rag documents data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wpbot_chat_report","full_table_name":"wp_wpbot_chat_report","description":"Stores wpbot chat report data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wpbot_conversation","full_table_name":"wp_wpbot_conversation","description":"Stores wpbot conversation data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wpbot_crm_","full_table_name":"wp_wpbot_crm_","description":"Stores wpbot crm  data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wpbot_failed_response","full_table_name":"wp_wpbot_failed_response","description":"Stores wpbot failed response data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wpbot_response","full_table_name":"wp_wpbot_response","description":"Stores wpbot response data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wpbot_sessions","full_table_name":"wp_wpbot_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wpbot_subscription","full_table_name":"wp_wpbot_subscription","description":"Stores wpbot subscription data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wpbot_user","full_table_name":"wp_wpbot_user","description":"Stores wpbot user data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wpbot_ut_","full_table_name":"wp_wpbot_ut_","description":"Stores wpbot ut  data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":18}