I was planning to use queries to bulk add smilies, for example:
INSERT INTO xf_smilie VALUES ('12','Test',':test:','styles/default/xenforo/smilies/test.png');
However, they're only visible in the ACP and not in the editor so I need to find out what else is updated when adding them via the ACP.