2b:null 2c:["$","title",null,{"children":"[FFXIV] FF14 图标反查物品、技能、状态 | UnluckyNinja | Observable"}] 31:Tffc,result = { let _search = search if (!search) { switch (tableType){ case 'items_cn': return db.sql`SELECT "key: #", "9: Name", "8: Description", "10: Icon" FROM items_cn` case 'actions_cn': return db.sql`SELECT "key: #", "0: Name", "2: Icon" FROM actions_cn` case 'status_cn': return db.sql`SELECT "key: #", "0: Name", "1: Description", "2: Icon" FROM status_cn` } } if (forwardIndexing) { let search = `%${_search}%` switch (tableType){ case 'items_cn': return db.sql`SELECT "key: #" as ID, "9: Name" as 名称, "8: Description" as 描述, "10: Icon" as 图标 FROM items_cn WHERE "key: #" = ${search} OR 名称 ILIKE ${search} OR 描述 ILIKE ${search}` case 'actions_cn': return db.sql` SELECT '技能' as 类型, actions_cn."key: #" as ID, actions_cn."0: Name" as 名称, action_transient_cn."0: Description" as 描述, actions_cn."2: Icon" as 图标 FROM actions_cn left join action_transient_cn on actions_cn."key: #" = action_transient_cn."key: #" WHERE actions_cn."key: #" = ${search} OR 名称 ILIKE ${search} OR 描述 ILIKE ${search} UNION ALL SELECT '技能（被动）' as 类型, trait_cn."key: #" as ID, trait_cn."0: Name" as 名称, trait_transient_cn."0: Description" as 描述, trait_cn."1: Icon" as 图标 FROM trait_cn left join trait_transient_cn on trait_cn."key: #" = trait_transient_cn."key: #" WHERE trait_cn."key: #" = ${search} OR 名称 ILIKE ${search} OR 描述 ILIKE ${search} ` case 'status_cn': return db.sql`SELECT "key: #" as ID, "0: Name" as 名称, "1: Description" as 描述, "2: Icon" as 图标 FROM status_cn WHERE "key: #" = ${search} OR 名称 ILIKE ${search} OR 描述 ILIKE ${search}` } } else { return db.sql` SELECT '物品' as 类型, "key: #" as ID, "9: Name" as 名称, "8: Description" as 描述, "10: Icon" as 图标 FROM items_cn WHERE "10: Icon" = ${search} UNION ALL SELECT '技能' as 类型, actions_cn."key: #" as ID, "0: Name" as 名称, action_transient_cn."0: Description" as 描述, "2: Icon" as 图标 FROM actions_cn left join action_transient_cn on actions_cn."key: #" = action_transient_cn."key: #" WHERE "2: Icon" = ${search} UNION ALL SELECT '状态' as 类型, "key: #" as ID, "0: Name" as 名称, "1: Description" as 描述, "2: Icon" as 图标 FROM status_cn WHERE "2: Icon" = ${search} UNION ALL SELECT '制作' as 类型, "key: #" as ID, "0: Name" as 名称, "1: Description" as 描述, "4: Icon" as 图标 FROM craft_action_cn WHERE "4: Icon" = ${search} UNION ALL SELECT '一般' as 类型, "key: #" as ID, "0: Name" as 名称, "1: Description" as 描述, "7: Icon" as 图标 FROM general_action_cn WHERE "7: Icon" = ${search} UNION ALL SELECT '事件' as 类型, "key: #" as ID, "0: Name" as 名称, '(原表无该列)' as 描述, "1: Icon" as 图标 FROM event_action_cn WHERE "1: Icon" = ${search} UNION ALL SELECT '搭档' as 类型, "key: #" as ID, "0: Name" as 名称, "1: Description" as 描述, "2: Icon" as 图标 FROM buddy_action_cn WHERE "2: Icon" = ${search} UNION ALL SELECT '召唤兽' as 类型, "key: #" as ID, "0: Name" as 名称, "1: Description" as 描述, "2: Icon" as 图标 FROM pet_action_cn WHERE "2: Icon" = ${search} UNION ALL SELECT '冒险者小队' as 类型, "key: #" as ID, "1: " as 名称, '(原表无该列)' as 描述, "2: " as 图标 FROM bgc_army_action_cn WHERE "2: " = ${search} UNION ALL SELECT '宠物' as 类型, "key: #" as ID, "0: Singular" as 名称, '(原表无该列)' as 描述, "28: Icon" as 图标 FROM companion_cn WHERE "28: Icon" = ${search} UNION ALL SELECT '坐骑' as 类型, "key: #" as ID, "0: Singular" as 名称, '(原表无该列)' as 描述, "30: Icon" as 图标 FROM mount_cn WHERE "30: Icon" = ${search} UNION ALL SELECT '技能（被动）' as 类型, trait_cn."key: #" as ID, trait_cn."0: Name" as 名称, trait_transient_cn."0: Description" as 描述, trait_cn."1: Icon" as 图标 FROM trait_cn left join trait_transient_cn on trait_cn."key: #" = trait_transient_cn."key: #" WHERE "1: Icon" = ${search} ` } }32:[] 2f:{"id":"13877f6b49e17eb9","slug":null,"title":"[FFXIV] FF14 图标反查物品、技能、状态","thumbnail":"a1f2daa203a0b4d3129b8fc36f446f2baf1137645f35eb2e7d089fc9dd168ec9","access_level":"public","create_time":"$D2024-06-07T11:09:40.190Z","update_time":"$D2026-06-08T11:35:34.223Z","view_time":null,"first_public_time":"$D2024-06-07T11:09:40.190Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"ebb6118c9a990a2c","login":"unluckyninja","name":"UnluckyNinja","avatar_url":"https://avatars-next.observableusercontent.com/95d8d23bafa30b0b30e2ead4a72666d02cc17899c3c958c22c65fc0fc09afe3d","tier":"starter_2024"},"version":318,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"4df1f6fd87aa7295","login":"unluckyninja","name":"UnluckyNinja","avatar_url":"https://avatars-next.observableusercontent.com/95d8d23bafa30b0b30e2ead4a72666d02cc17899c3c958c22c65fc0fc09afe3d","tier":null}],"members":[{"type":"individual","id":"4df1f6fd87aa7295","login":"unluckyninja","name":"UnluckyNinja","avatar_url":"https://avatars-next.observableusercontent.com/95d8d23bafa30b0b30e2ead4a72666d02cc17899c3c958c22c65fc0fc09afe3d","tier":null,"role":"editor"},{"type":"team","id":"ebb6118c9a990a2c","login":"unluckyninja","name":"UnluckyNinja","avatar_url":"https://avatars-next.observableusercontent.com/95d8d23bafa30b0b30e2ead4a72666d02cc17899c3c958c22c65fc0fc09afe3d","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":{"id":"618097a6397b7b90","slug":"ffxiv","title":"FFXIV","owner":{"id":"ebb6118c9a990a2c","login":"unluckyninja","name":"UnluckyNinja"}},"type":"notebook","body":{"title":"[FFXIV] FF14 图标反查物品、技能、状态","cells":[{"id":0,"value":"# [FFXIV] FF14 图标反查物品、技能、状态\n可以反查到的只有物品、技能、状态，不支持查询其它用途（例如UI等） \n只需要输入图标ID即可，例如:26252","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":125,"value":"viewof forwardIndexing = Inputs.toggle({label: \"正查\", value: false})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":87,"value":"viewof tableType = Inputs.radio(new Map([['物品', 'items_cn'],['技能','actions_cn'],['状态','status_cn']]), {label: \"选择查询类型(仅正查需要指定)\", value: \"items_cn\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"viewof search = {\n if (forwardIndexing) {\n return Inputs.text({label: '正查输入对应数据ID，反查输入图标ID', value: this?.value ?? 19810})\n }\n return Inputs.number({label: '正查输入对应数据ID，反查输入图标ID', value: parseInt(this?.value) ?? 19810})\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"{\n if (!forwardIndexing) {\n return htl.html`对应图片：
肥肥cafe:

XIVAPI:

`\n } else {\n if (result.length === 0) return htl.html`未找到有效数据`\n const icon = result[0][result.schema.find((d)=>d.name.match(/图标/i)).name]\n return htl.html`IconID:${icon} 对应图片：
肥肥cafe:

XIVAPI:

`\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":112,"value":"table = result","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"table","database":"$undefined"},{"id":105,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":41,"value":"function getIconURL(id) {\n return 'https://cafemaker.wakingsands.com/i/' + Math.floor(id/1000).toString().padStart(3, '0').padEnd(6, '0') + '/' + id.toString().padStart(6, '0') + '_hr1.png'\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":65,"value":"function getXIVIconURL(id) {\n return 'https://xivapi.com/i/' + Math.floor(id/1000).toString().padStart(3, '0').padEnd(6, '0') + '/' + id.toString().padStart(6, '0') + '_hr1.png'\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":99,"value":"db = DuckDBClient.of({\n items_cn,\n actions_cn,\n status_cn,\n general_action_cn,\n event_action_cn,\n craft_action_cn,\n buddy_action_cn,\n pet_action_cn,\n bgc_army_action_cn,\n companion_cn,\n mount_cn,\n action_transient_cn,\n trait_cn,\n trait_transient_cn,\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":317,"value":"actions_cn.reverse()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":81,"value":"actions_cn = {\n return await parseCSV('https://raw.githubusercontent.com/thewakingsands/ffxiv-datamining-cn/master/Action.csv')\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":79,"value":"status_cn = {\n return await parseCSV('https://raw.githubusercontent.com/thewakingsands/ffxiv-datamining-cn/master/Status.csv')\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":185,"value":"general_action_cn = {\n return await parseCSV('https://raw.githubusercontent.com/thewakingsands/ffxiv-datamining-cn/master/GeneralAction.csv')\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":188,"value":"event_action_cn = {\n return await parseCSV('https://raw.githubusercontent.com/thewakingsands/ffxiv-datamining-cn/master/EventAction.csv')\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":191,"value":"craft_action_cn = {\n return await parseCSV('https://raw.githubusercontent.com/thewakingsands/ffxiv-datamining-cn/master/CraftAction.csv')\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":195,"value":"buddy_action_cn = {\n return await parseCSV('https://raw.githubusercontent.com/thewakingsands/ffxiv-datamining-cn/master/BuddyAction.csv')\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":201,"value":"pet_action_cn = {\n return await parseCSV('https://raw.githubusercontent.com/thewakingsands/ffxiv-datamining-cn/master/PetAction.csv')\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":198,"value":"bgc_army_action_cn = {\n return await parseCSV('https://raw.githubusercontent.com/thewakingsands/ffxiv-datamining-cn/master/BgcArmyAction.csv')\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":219,"value":"companion_cn = {\n return await parseCSV('https://raw.githubusercontent.com/thewakingsands/ffxiv-datamining-cn/master/Companion.csv')\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":225,"value":"mount_cn = {\n return await parseCSV('https://raw.githubusercontent.com/thewakingsands/ffxiv-datamining-cn/master/Mount.csv')\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":248,"value":"action_transient_cn = {\n return await parseCSV('https://raw.githubusercontent.com/thewakingsands/ffxiv-datamining-cn/master/ActionTransient.csv')\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":285,"value":"trait_cn = {\n return await parseCSV('https://raw.githubusercontent.com/thewakingsands/ffxiv-datamining-cn/master/Trait.csv')\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":282,"value":"trait_transient_cn = {\n return await parseCSV('https://raw.githubusercontent.com/thewakingsands/ffxiv-datamining-cn/master/TraitTransient.csv')\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":231,"value":"async function parseCSV(url) {\n let text = await (await fetch(url)).text()\n let lineend0 = text.indexOf('\\n') // key,0,1 ...\n let lineend1 = text.indexOf('\\n', lineend0+1) // #, Name, ...\n let lineend2 = text.indexOf('\\n', lineend1+1) // int,str, ...\n let lineend3 = text.indexOf('\\n', lineend2+1) // 0, '', ...\n let idxes = text.slice(0, lineend0).split(',').map(it=>it.replaceAll(/\\r/g, ''))\n let labels = text.slice(lineend0+1, lineend1).split(',').map(it=>it.replaceAll(/\\r/g, ''))\n let data = d3.csvParseRows(text.slice(lineend3+1), (d, i)=>{\n return Object.fromEntries(d.map((it, idx)=>[`${idxes[idx]}: ${labels[idx]}`, it]))\n })\n return data\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"import { items_cn} from '1ef1dad66b92c723'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W32","stdlib":"1","titling":"auto"}} 30:"$2f:body"