--
--
--
--
--
--
--
--
--
--
--
Checking...
--
Quick Access & Management Modules
Direct shortcuts to manage system configurations, emails, leads, and college content.
System Environment
Database: SQLite 3 (data/victoria.db)
Authentication Providers: Google OAuth, LinkedIn OAuth, Email / Password
AI Assistant Proxy: Direct backend endpoint /api/chat with database key storage and automatic college knowledge injection.
Registered Users
Manage student and administrator accounts, roles, and access statuses.
| User | Auth Provider | Role | Status | Created | Actions | |
|---|---|---|---|---|---|---|
| Loading users... | ||||||
College Knowledge Base Database
Official knowledge articles stored in SQLite. The chatbot checks this database first to answer questions with 100% accuracy before querying OpenAI.
| ID | Category | Title & Keywords | Knowledge Content | Priority | Status | Actions |
|---|---|---|---|---|---|---|
| Loading knowledge articles... | ||||||
Academic Programs Management
Manage vocational and enrichment programs, customize English & Chinese copy, homepage highlight cards, and curriculum modules.
| Order | Image | Program Title (EN / 中文) | Slug & Category | Status | Actions |
|---|---|---|---|---|---|
| Loading academic programs... | |||||
Image Library & Uploader
Upload images directly into the images/ folder for new academic programs, job fairs, and website articles.
Click or Drag & Drop Images Here to Upload
Supports JPG, PNG, WebP, GIF, SVG, AVIF (Max 15 MB). Uploaded images are immediately saved into the images/ directory and available across the entire site.
Available Images in images/
Click "Copy Path" or "Use in Program" to seamlessly apply any image to your courses and content.
Live Job Fair Banner Preview
Live preview of the banner as displayed on the homepage when active.
IN-PERSON PSW JOB FAIR
Connect with employers, find jobs
Friday, 12 May | 10:00AM – 12:00PM • 7050 Woodbine Ave. Markham
Secure Your SpotAll Job Fair & Event Banners
Create and manage event banners. Searchable across active and inactive events.
| Image | Event Title (EN / 中文) | Date & Location | CTA Button | Status | Actions |
|---|---|---|---|---|---|
| Loading job fair events... | |||||
AI GEO & SEO Article Generator
Generate high-ranking local GEO & SEO articles based on keywords. Newly generated articles are hidden (draft) by default until you activate them.
XML Sitemap for GEO & SEO (/sitemap.xml)
Automatically updated with active GEO-targeted articles. Hidden articles are strictly excluded.
Published & Draft Articles
Manage all GEO-targeted articles, toggle public visibility, edit content, and inspect Google search preview.
| ID | Article Title & SEO Slug | Target GEO | Category | Visibility Status | Views | Actions |
|---|---|---|---|---|---|---|
| Loading articles... | ||||||
Prospective Student Inquiries & Free Class Leads
Real-time lead capture from "Join Our Free Class", consultation forms, and program landing pages.
| Date & Time | Student Info | Contact Details | Program of Interest | Grant Req. | Source | Status | Action |
|---|---|---|---|---|---|---|---|
|
Loading student inquiries... |
|||||||
OpenAI API Key & Bot Configuration
Store your OpenAI API key securely in the SQLite database to empower the bottom-right AI Assistant.
Security & Admin Password Management
Update your Super Admin password stored securely as a salted hash in the SQLite database.
Database Persistence & Disaster Recovery
Monitor SQLite persistent storage health, download live production snapshots, and safeguard college records across deployments.
--
Restore Database from Local File
Upload a .db SQLite file to restore production. A safety backup of the current database is automatically created prior to restoring.
Automated Email & SMTP Notification Settings
Configure SMTP email dispatch to receive instant alerts at info@viccollege.com whenever students register for free classes or consultations.
Student Inquiries & Chat Logs
Review real queries asked by visitors and answers returned by the AI Assistant. Save valuable Q&As directly into your Knowledge Base with 1-click!
| Timestamp | User / Visitor | User Query | AI Response | Model Used | Action |
|---|---|---|---|---|---|
| Loading logs... | |||||
