Difference between revisions of "DragonData"

From NorCon MUSH
 
(13 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
{{#get_db_data:
 
{{#get_db_data:
 
db=norcon
 
db=norcon
|from=dragons LEFT JOIN `clutches` on dragons.clutch = clutches.id
+
|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=dragons.weyr,hatchsecs=clutches.hatchsecs, dam=clutches.dam, sire=clutches.sire, hatchdate=clutches.hatchdate, weyr=clutches.weyr
+
|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
 
}}
 
}}
  
Line 10: Line 10:
 
|dragon-color={{{color}}}
 
|dragon-color={{{color}}}
 
|dragon-wing={{{wing}}}
 
|dragon-wing={{{wing}}}
|dragon-rider='{{#replace:{{{rider}}}|'|\'}}'
+
|dragon-rider={{#replace:{{{rider}}}|'|\'}}
 +
|dragon-rider2={{#replace:{{{rider}}}|'|'}}
 
|dragon-ename={{{ename}}}
 
|dragon-ename={{{ename}}}
 
|dragon-size={{{size}}}
 
|dragon-size={{{size}}}
Line 21: Line 22:
 
|dragon-hatchdate={{{hatchdate}}}
 
|dragon-hatchdate={{{hatchdate}}}
 
|dragon-weyr={{{weyr}}}
 
|dragon-weyr={{{weyr}}}
 +
|dragon-home2={{{home2}}}
 +
|dragon-status={{{npc}}}
 
}}
 
}}

Latest revision as of 04:49, 24 January 2016