Difference between revisions of "CharacterData"
From NorCon MUSH
| (13 intermediate revisions by the same user not shown) | |||
| 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 | + | |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 |
}} | }} | ||
| − | {{#store_external_table: | + | {{#store_external_table:CharacterData |
|name={{#replace:{{{name}}}|'|\'}} | |name={{#replace:{{{name}}}|'|\'}} | ||
|name2={{#replace:{{{name}}}|'|'}} | |name2={{#replace:{{{name}}}|'|'}} | ||
| Line 26: | Line 26: | ||
|home={{{npc-home}}} | |home={{{npc-home}}} | ||
|dragon-name={{{dragon}}} | |dragon-name={{{dragon}}} | ||
| + | |hname={{{hname}}} | ||
| + | |wing={{{wing}}} | ||
| + | |dcolor={{{color}}} | ||
| + | |gender={{{gender}}} | ||
}} | }} | ||
Latest revision as of 00:42, 17 January 2016
