JourneyMaterials: Difference between revisions
From Dune Awakening DB
mNo edit summary |
mNo edit summary |
||
| Line 24: | Line 24: | ||
{{#for_external_table:| | {{#for_external_table:| | ||
{{#ifeq:{{{Level}}}|1| | {{#ifeq:{{{Level}}}|1| | ||
<div class="material- | <div class="material-item" data-item="{{{InternalName}}}" data-level="1"><div class="material-checkbox-wrapper"><span class="material-checkbox" data-qty="{{{TotalQty}}}"></span></div><div class="material-content"><span class="material-icon">{{#ifexist:File:{{#replace:{{{ItemLabel}}}{{!}} {{!}}_}}_-_Icon.png|[[File:{{#replace:{{{ItemLabel}}}{{!}} {{!}}_}}_-_Icon.png|20px|link=]]|}}</span><span class="material-name">{{{ItemLabel}}}</span><span class="material-qty">{{{TotalQty}}}</span></div><div class="material-children-indicator"></div></div> | ||
|}} | |}} | ||
}} | }} | ||
| Line 36: | Line 36: | ||
{{#for_external_table:| | {{#for_external_table:| | ||
{{#ifeq:{{{Level}}}|2| | {{#ifeq:{{{Level}}}|2| | ||
<div class="material- | <div class="material-item" data-item="{{{InternalName}}}" data-level="2"><div class="material-checkbox-wrapper"><span class="material-checkbox" data-qty="{{{TotalQty}}}"></span></div><div class="material-content"><span class="material-icon">{{#ifexist:File:{{#replace:{{{ItemLabel}}}{{!}} {{!}}_}}_-_Icon.png|[[File:{{#replace:{{{ItemLabel}}}{{!}} {{!}}_}}_-_Icon.png|20px|link=]]|}}</span><span class="material-name">{{{ItemLabel}}}</span><span class="material-qty">{{{TotalQty}}}</span></div><div class="material-children-indicator"></div></div> | ||
|}} | |}} | ||
}} | }} | ||
| Line 48: | Line 48: | ||
{{#for_external_table:| | {{#for_external_table:| | ||
{{#ifeq:{{{Level}}}|3| | {{#ifeq:{{{Level}}}|3| | ||
<div class="material- | <div class="material-item" data-item="{{{InternalName}}}" data-level="3"><div class="material-checkbox-wrapper"><span class="material-checkbox" data-qty="{{{TotalQty}}}"></span></div><div class="material-content"><span class="material-icon">{{#ifexist:File:{{#replace:{{{ItemLabel}}}{{!}} {{!}}_}}_-_Icon.png|[[File:{{#replace:{{{ItemLabel}}}{{!}} {{!}}_}}_-_Icon.png|20px|link=]]|}}</span><span class="material-name">{{{ItemLabel}}}</span><span class="material-qty">{{{TotalQty}}}</span></div></div> | ||
|}} | |}} | ||
}} | }} | ||
Revision as of 00:41, 2 June 2025
The query SELECT level,item_label,total_qty,internal_name FROM `data_journey_materials` WHERE journey_id = ORDER BY level, item_label is invalid (Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY level, item_label' at line 1 Function: EDConnectorRdbms::fetch Query: SELECT level,item_label,total_qty,internal_name FROM `data_journey_materials` WHERE journey_id = ORDER BY level, item_label ).
0 / 0 Materials Ready