Difference between revisions of "DragonData"
From NorCon MUSH
(Created page with "{{#get_db_data: db=norcon |from=dragons |data=dragon=name,hname=hname,color=color,wing=wing,rider=rider,ename=ename,size=size,clutch=clutch,desc=description,home=weyr,hatchsec...") |
|||
| (18 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{#get_db_data: | {{#get_db_data: | ||
db=norcon | db=norcon | ||
| − | |from=dragons | + | |from=dragons LEFT JOIN `clutches` on dragons.clutch = clutches.id LEFT JOIN `chars` on dragons.charid = chars.id LEFT JOIN `chars_subareas` on chars.subareaid = chars_subareas.id |
| − | |data=dragon=name,hname=hname,color=color,wing=wing,rider=rider,ename=ename,size=size,clutch=clutch,desc=description,home=weyr,hatchsecs=hatchsecs | + | |data=dragon=dragons.name,hname=hname,color=color,wing=wing,rider=rider,ename=ename,size=size,clutch=clutch,desc=description,home=dragons.weyr,hatchsecs=clutches.hatchsecs, dam=clutches.dam, sire=clutches.sire, hatchdate=clutches.hatchdate, weyr=clutches.weyr, home2=chars_subareas.subarea, npc=npc |
}} | }} | ||
{{#store_external_table:DragonData | {{#store_external_table:DragonData | ||
| − | |dragon={{{dragon}}} | + | |dragon-name={{{dragon}}} |
| − | |hname={{{hname}}} | + | |dragon-hname={{{hname}}} |
| − | |color={{{color}}} | + | |dragon-color={{{color}}} |
| − | |wing={{{wing}}} | + | |dragon-wing={{{wing}}} |
| − | |rider={{{rider}}} | + | |dragon-rider={{#replace:{{{rider}}}|'|\'}} |
| − | |ename={{{ename}}} | + | |dragon-rider2={{#replace:{{{rider}}}|'|'}} |
| − | |size={{{size}}} | + | |dragon-ename={{{ename}}} |
| − | |clutch={{{clutch}}} | + | |dragon-size={{{size}}} |
| − | |desc={{{desc}}} | + | |dragon-clutch={{{clutch}}} |
| − | |home={{{home}}} | + | |dragon-desc={{{desc}}} |
| − | |hatchsecs={{{hatchsecs}}} | + | |dragon-home={{{home}}} |
| + | |dragon-hatchsecs={{{hatchsecs}}} | ||
| + | |dragon-dam={{{dam}}} | ||
| + | |dragon-sire={{{sire}}} | ||
| + | |dragon-hatchdate={{{hatchdate}}} | ||
| + | |dragon-weyr={{{weyr}}} | ||
| + | |dragon-home2={{{home2}}} | ||
| + | |dragon-status={{{npc}}} | ||
}} | }} | ||
Latest revision as of 04:49, 24 January 2016
