Difference between revisions of "CharacterData"

From NorCon MUSH
 
Line 2: Line 2:
 
db=norcon
 
db=norcon
 
|from=chars LEFT JOIN `chars_ranks` on chars.rankid = chars_ranks.id INNER JOIN `chars_status` on chars.status = chars_status.id LEFT JOIN `chars_crafts` on chars.craftid = chars_crafts.id INNER JOIN `chars_subareas` on chars.subareaid = chars_subareas.id LEFT JOIN `dragons` on chars.dragonid = dragons.id
 
|from=chars LEFT JOIN `chars_ranks` on chars.rankid = chars_ranks.id INNER JOIN `chars_status` on chars.status = chars_status.id LEFT JOIN `chars_crafts` on chars.craftid = chars_crafts.id INNER JOIN `chars_subareas` on chars.subareaid = chars_subareas.id LEFT JOIN `dragons` on chars.dragonid = dragons.id
|data=name=chars.name,pb=pb,rank=chars_ranks.rank,status=chars_status.status,craft=chars_crafts.craft,birthplace=birthplace,subarea=chars_subareas.fullarea,wysk=wysk,areacode=chars_subareas.subarea,owner=owner, craftspeciality=craftspeciality, position=position, height=glance_height, build=glance_build, eyes=glance_eyes, hair=glance_hair, birthsecs=birthsecs, dragonid=dragonid, home=home, dragon=dragons.name,hname=hname,color=color,wing=wing, wiki=wiki
+
|data=name=chars.name,pb=pb,rank=chars_ranks.rank,status=chars_status.status,craft=chars_crafts.craft,birthplace=birthplace,subarea=chars_subareas.fullarea,wysk=wysk,areacode=chars_subareas.subarea,owner=owner, craftspeciality=craftspeciality, position=position, height=glance_height, build=glance_build, eyes=glance_eyes, hair=glance_hair, birthsecs=birthsecs, dragonid=dragonid, home=home, dragon=dragons.name,hname=hname,color=color,wing=wing, wiki=wiki, gender=sex
 
}}
 
}}
  
Line 29: Line 29:
 
|wing={{{wing}}}
 
|wing={{{wing}}}
 
|dcolor={{{color}}}
 
|dcolor={{{color}}}
 +
|gender={{{gender}}}
 
}}
 
}}

Latest revision as of 00:42, 17 January 2016