[1.3] Manual Skills

-- quests table
ALTER TABLE quests
  ADD COLUMN IF NOT EXISTS skills TEXT[] DEFAULT '{}';
 
CREATE INDEX IF NOT EXISTS idx_quests_skills ON quests USING GIN (skills);
 
-- adventures table
ALTER TABLE adventures
  ADD COLUMN IF NOT EXISTS skills TEXT[] DEFAULT '{}';
 
CREATE INDEX IF NOT EXISTS idx_adventures_skills ON adventures USING GIN (skills);

// shared/schemas/questSchema.ts
 
// createQuestSchema.skills
skills: z
  .array(
    z.string()
      .max(50, "Each skill must be 50 characters or less")
      .min(1, "Skill name cannot be empty")
  )
  .transform((skills) => {
    // Case-insensitive deduplication
    const seen = new Set<string>();
    return skills.filter((skill) => {
      const normalized = skill.toLowerCase();
      if (seen.has(normalized)) return false;
      seen.add(normalized);
      return true;
    });
  })
  .refine((skills) => skills.length <= 20, {
    message: "Maximum 20 skills allowed per quest"
  })
  .default([])

{
  "quest_id": "uuid",
  "skills": ["Python", "Data Analysis", "Machine Learning"]
}

// app/quest-editor/[questID]/(sections)/overview/page.tsx
 
const validateSkills = (skillsString: string) => {
  const rawSkills = skillsString.split(',').map(s => s.trim()).filter(s => s.length > 0);
  const { deduplicated: skills, removedDuplicates } = deduplicateCaseInsensitive(rawSkills);
  const errors: string[] = [];
  const warnings: string[] = [];
 
  // Warn about duplicates (not blocking)
  if (removedDuplicates.length > 0) {
    warnings.push(`Duplicate skills removed: ${removedDuplicates.join(', ')}`);
  }
 
  // Validation rules
  if (skills.length > 20) errors.push("Maximum 20 skills allowed");
  if (skills.some(s => s.length > 50)) errors.push("Each skill must be 50 characters or less");
  if (skills.some(s => !/^[a-zA-Z0-9\s-]+$/.test(s))) {
    errors.push("Skills can only contain letters, numbers, spaces, and hyphens");
  }
 
  return { valid: errors.length === 0, errors, warnings, skills };
};

// hooks/creator/useSkillsFilter.ts
 
export function useSkillsFilter(items: ContentListObject[]) {
  const [selectedSkills, setSelectedSkills] = useState<string[]>([]);
 
  // Extract unique skills sorted alphabetically
  const availableSkills = useMemo(() => {
    const skillsSet = new Set<string>();
    items.forEach((item) => {
      item.skills?.forEach((skill) => skillsSet.add(skill.trim()));
    });
    return Array.from(skillsSet).sort((a, b) => a.localeCompare(b));
  }, [items]);
 
  // Filter items by selected skills (OR logic)
  const filterBySkills = useCallback((itemsToFilter) => {
    if (selectedSkills.length === 0) return itemsToFilter;
    return itemsToFilter.filter((item) =>
      selectedSkills.some((skill) => item.skills?.includes(skill))
    );
  }, [selectedSkills]);
 
  return { availableSkills, selectedSkills, filterBySkills, toggleSkill, removeSkill, clearAllSkills };
}