Thanks for helping! This guide is a living project that gets better with community input.
Open an issue using one of the templates:
- Correction — SQL example has a wrong column name, ID doesn't exist, etc.
- Page Improvement — something's confusing, needs a diagram, missing a step
- New Topic Request — a topic that should be covered but isn't
- Fork the repo
- Edit the
.mdfile indocs/ - Open a Pull Request with a clear description of what you changed and why
These rules exist so the guide stays consistent and beginner-friendly. All contributions must follow them.
- No jargon without immediate definition
- If you use a term for the first time, explain it in the same sentence
- Write like you're explaining to a friend who's never touched a database
- "The
entrycolumn is the creature's unique ID number" — not "entry is the PK"
- ASCII diagram at the top — show the concept visually before explaining in text
- Hands-on exercise — at least one "type this, see that" exercise with expected results
- Cheat sheet at the bottom — quick reference for the page's key commands/patterns
- Level 1 pages must NOT reference concepts from Level 2-4
- Level 2 can assume Level 1 knowledge, etc.
- If you need a concept from a later level, link to it with "(explained in File XX)"
- All SQL must use real TrinityCore IDs that exist in a stock TDB import
- Common examples: Hogger (448), Stormwind Guard (68), Fireball (133)
- Always include
WHEREin UPDATE/DELETE examples - Show the
DESCRIBEoutput or column names when referencing a table for the first time
Every page needs at least one. Use this style:
+----------+ +----------+ +----------+
| Step 1 | --> | Step 2 | --> | Result |
+----------+ +----------+ +----------+
- Indent 2 spaces
- Use
+--+for boxes,-->for arrows,|for vertical pipes - Keep under 70 characters wide (mobile readability)
XX_Title_With_Underscores.mdwhere XX is the number- Numbers determine reading order within a level
- Home page is always
index.md
Add this at the very top of new pages:
---
title: Your Page Title
description: One-sentence summary for search results
last_verified: YYYY-MM-DD
tc_build: 66838
---
- Content that requires specific repacks or custom cores (keep it generic TrinityCore)
- Copyrighted Blizzard content (quest text, lore, datamined strings)
- Links to piracy, private server listings, or client downloads
- Anything that requires a retail WoW subscription to verify (the guide is for people with repacks)
| Level | Audience | Assumes | Tone |
|---|---|---|---|
| 1 | Never touched a database | Can log into game as GM | Hand-holding, step by step |
| 2 | Can query and edit | Completed Level 1 | Practical, example-heavy |
| 3 | Understands SQL, wants the "why" | Completed Level 2 | Explanatory, connects dots |
| 4 | Ready to reverse-engineer | Completed Level 3 | Technical, but still accessible |
To preview the site locally:
pip install mkdocs-material
mkdocs serve
# Open http://127.0.0.1:8000/Changes to .md files auto-reload in the browser.