JourneyMaterials: Difference between revisions
From Dune Awakening DB
mNo edit summary |
mNo edit summary |
||
| Line 3: | Line 3: | ||
|from = data_journey_materials | |from = data_journey_materials | ||
|data = Level=level, ItemLabel=item_label, TotalQty=total_qty, InternalName=internal_name | |data = Level=level, ItemLabel=item_label, TotalQty=total_qty, InternalName=internal_name | ||
|where = journey_id = | |where = journey_id = {{{id|{{{1|}}}}}} | ||
|order by = level, item_label | |order by = level, item_label | ||
|cache = yes | |cache = yes | ||
| Line 24: | Line 24: | ||
{{#for_external_table:| | {{#for_external_table:| | ||
{{#ifeq:{{{Level}}}|1| | {{#ifeq:{{{Level}}}|1| | ||
<div class="material-card" data-item="{{{InternalName}}}" data-level="1"> | <div class="material-card" 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> | ||
</div> | |||
|}} | |}} | ||
}} | }} | ||
| Line 47: | Line 36: | ||
{{#for_external_table:| | {{#for_external_table:| | ||
{{#ifeq:{{{Level}}}|2| | {{#ifeq:{{{Level}}}|2| | ||
<div class="material-card" data-item="{{{InternalName}}}" data-level="2"> | <div class="material-card" 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> | ||
</div> | |||
|}} | |}} | ||
}} | }} | ||
| Line 70: | Line 48: | ||
{{#for_external_table:| | {{#for_external_table:| | ||
{{#ifeq:{{{Level}}}|3| | {{#ifeq:{{{Level}}}|3| | ||
<div class="material-card" data-item="{{{InternalName}}}" data-level="3"> | <div class="material-card" 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> | ||
</div> | |||
|}} | |}} | ||
}} | }} | ||
| Line 86: | Line 54: | ||
</div> | </div> | ||
</div> | </div> | ||
Revision as of 00:31, 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