Mage Timeline
From Edge of Darkness Wiki
Mage Timeline
| Line 4: | Line 4: | ||
|where=char2.detail = 'Fame' AND characters.Status = 'Active' OR char2.detail = 'Contacts' AND characters.Status = 'Active' OR char2.detail = 'Allies' AND char2.value > 2 AND char2.option IN ('Academia','Arms Dealers','Charities','City Hall','Clubs','Criminals','Culture','Digital Networks','Emergency Services','Entertainment','Fashion','Finance','Judicial','Medical','Status','News Media','Public Works','Religious Groups','Street','Unions') AND characters.Status = 'Active' OR char2.detail = 'Status' AND char2.value > 1 AND char2.option IN ('Academia','Arms Dealers','Charities','City Hall','Clubs','Criminals','Culture','Digital Networks','Emergency Services','Entertainment','Fashion','Finance','Judicial','Medical','Status','News Media','Public Works','Religious Groups','Street','Unions') AND characters.Status = 'Active' | |where=char2.detail = 'Fame' AND characters.Status = 'Active' OR char2.detail = 'Contacts' AND characters.Status = 'Active' OR char2.detail = 'Allies' AND char2.value > 2 AND char2.option IN ('Academia','Arms Dealers','Charities','City Hall','Clubs','Criminals','Culture','Digital Networks','Emergency Services','Entertainment','Fashion','Finance','Judicial','Medical','Status','News Media','Public Works','Religious Groups','Street','Unions') AND characters.Status = 'Active' OR char2.detail = 'Status' AND char2.value > 1 AND char2.option IN ('Academia','Arms Dealers','Charities','City Hall','Clubs','Criminals','Culture','Digital Networks','Emergency Services','Entertainment','Fashion','Finance','Judicial','Medical','Status','News Media','Public Works','Religious Groups','Street','Unions') AND characters.Status = 'Active' | ||
| - | |data=threadid=characters.threadid, name=char_name, detail=detail, spheres=GROUP_CONCAT(DISTINCT char2.option ORDER BY char2.option ASC SEPARATOR ', ') | + | |data=threadid=characters.threadid, name=char_name, detail=detail, spheres=GROUP_CONCAT(DISTINCT char2.option ORDER BY char2.option ASC SEPARATOR ', '), userid=characters.userid |
}} | }} | ||
| + | |||
| + | <table style="width:100%"> | ||
| + | {{#for_external_table: <html><div style="background: darkgreen; margin-right: 5px; float: left; height: 38px; width: 38px; overflow: hidden; border-radius: 50%;" ><a href="http://nwod.org/forum/member.php?</html>{{{userid}}}<html>"><img title="</html>{{{name}}}<html>"src="http://nwod.org/forum/image.php?u=</html>{{{userid}}}<html>&type=thumb" style="width: 38px; min-height: 38px;" /></a></div></html> {{{name}}} <br /><div style="margin-left: 4em;"><small>{{{detail}}} ({{{spheres}}}) </small></div> }} | ||
| + | </table> | ||
Revision as of 17:48, 19 February 2017
