|
|
| Line 15: |
Line 15: |
| | </div> | | </div> |
| | {{clear left}} | | {{clear left}} |
| - | <div style="padding-right: 50px;"><rss>http://nwod.org/forum/external.php?type=RSS2&forumids=9,209,98,243|charset=UTF-8|short|max=30</rss></div> | + | {{#get_db_data:db=nwod |
| - | | + | |from=post JOIN thread ON (thread.threadid = post.threadid) JOIN forum ON (forum.forumid = thread.forumid) |
| | + | |where=thread.forumid IN (9,209,98,243) group by thread.title order by thread.lastpost desc LIMIT 20 |
| | + | |data=changelingforum=forum.title AS forum, changelingthread=thread.title, changelingdate=FROM_UNIXTIME(thread.lastpost, '%M %D') as date, changelingposter=thread.lastposter, changelingpostcount=count(postid), changelingpostid=post.postid, changelingforumid=thread.forumid |
| | + | }} |
| | + | <table style="width:100%"> |
| | + | {{#for_external_table: [http://nwod.org/forum/showthread.php?p={{{changelingpostid}}}#post{{{changelingpostid}}} {{{changelingthread}}}] <br /><div style="margin-left: 1.6em;"><small>{{{changelingpostcount}}} Posts, Last By: '''{{{changelingposter}}}''' {{{changelingdate}}}</small></div> }} |
| | + | </table> |
| | | | |
| | {{col-break|width=33%}} | | {{col-break|width=33%}} |
| Line 26: |
Line 32: |
| | </div> | | </div> |
| | {{clear left}} | | {{clear left}} |
| - | <div style="padding-right: 50px;"><rss>http://nwod.org/forum/external.php?type=RSS2&forumids=8,221,242,258|charset=UTF-8|short|max=30</rss></div> | + | {{#get_db_data:db=nwod |
| | + | |from=post JOIN thread ON (thread.threadid = post.threadid) JOIN forum ON (forum.forumid = thread.forumid) |
| | + | |where=thread.forumid IN (8,221,242,258) group by thread.title order by thread.lastpost desc LIMIT 20 |
| | + | |data=mageforum=forum.title AS forum, magethread=thread.title, magedate=FROM_UNIXTIME(thread.lastpost, '%M %D') as date, mageposter=thread.lastposter, magepostcount=count(postid), magepostid=post.postid, mageforumid=thread.forumid |
| | + | }} |
| | + | <table style="width:100%"> |
| | + | {{#for_external_table: [http://nwod.org/forum/showthread.php?p={{{magepostid}}}#post{{{magepostid}}} {{{magethread}}}] <br /><div style="margin-left: 1.6em;"><small>{{{magepostcount}}} Posts, Last By: '''{{{mageposter}}}''' {{{magedate}}}</small></div> }} |
| | + | </table> |
| | | | |
| | | | |
| Line 37: |
Line 50: |
| | </div> | | </div> |
| | {{clear left}} | | {{clear left}} |
| - | <div style="padding-right: 50px;"><rss>http://nwod.org/forum/external.php?type=RSS2&forumids=5,210,61,200|charset=UTF-8|short|max=30</rss></div> | + | {{#get_db_data:db=nwod |
| | + | |from=post JOIN thread ON (thread.threadid = post.threadid) JOIN forum ON (forum.forumid = thread.forumid) |
| | + | |where=thread.forumid IN (5,210,61,200) group by thread.title order by thread.lastpost desc LIMIT 20 |
| | + | |data=vampireforum=forum.title AS forum, vampirethread=thread.title, vampiredate=FROM_UNIXTIME(thread.lastpost, '%M %D') as date, vampireposter=thread.lastposter, vampirepostcount=count(postid), vampirepostid=post.postid, vampireforumid=thread.forumid |
| | + | }} |
| | + | <table style="width:100%"> |
| | + | {{#for_external_table: [http://nwod.org/forum/showthread.php?p={{{vampirepostid}}}#post{{{vampirepostid}}} {{{vampirethread}}}] <br /><div style="margin-left: 1.6em;"><small>{{{vampirepostcount}}} Posts, Last By: '''{{{vampireposter}}}''' {{{vampiredate}}}</small></div> }} |
| | + | </table> |
| | | | |
| | | | |
Changeling
(2505) Eternal Seasons
3 Posts, Last By: Mina May 21st (2504) Eternal Seasons
48 Posts, Last By: Sonnie Wu May 21st PRP Tunnels Candid Cameras
34 Posts, Last By: Kray May 21st A Tour! Here there and Everywhere!
2 Posts, Last By: Mina May 20th Hedge Patrol X
31 Posts, Last By: Mina May 20th (Hedge Patrol X)Following the Hoberflies
4 Posts, Last By: Vincent Black May 20th Underland: Ash and Onyx Brawl (Duel)
19 Posts, Last By: Kray May 19th Fixing to Save Time and Skin
1 Posts, Last By: Circe May 16th High Striker: Bounty for Bounties
40 Posts, Last By: Circe May 2nd Notice Board!
17 Posts, Last By: Kray April 29th Mina
6 Posts, Last By: Sonnie Wu April 28th Looming menace (Harvest)
2 Posts, Last By: Kray April 22nd (2503) Spring Equinox
46 Posts, Last By: Sonnie Wu April 20th (Private) The Coat Factory
19 Posts, Last By: Sonnie Wu April 19th Hedge Patrol IX
79 Posts, Last By: Saber Sloth April 15th (2503) Spring games
15 Posts, Last By: Kray April 14th Covert cutlet causes colorful commentary
1 Posts, Last By: Circe April 11th Capital Pinball Palor!
42 Posts, Last By: Mina April 7th First contact with San Fran freehold
70 Posts, Last By: Kray March 30th Dance Reclaimed
1 Posts, Last By: Mina March 27th
|
Mage
(Private)Hops, Bubbles and Words
31 Posts, Last By: Aurora May 21st A brief meeting
2 Posts, Last By: Aurora May 21st Clean up crew: Without Mercy
26 Posts, Last By: Thirteen May 21st BE: No rest for travellers
7 Posts, Last By: ReubanBrightwood May 21st Clean up crew: Return to the forties
7 Posts, Last By: ReubanBrightwood May 21st (2505) Sanctuary
33 Posts, Last By: Skye May 21st NMYF: Make a wish
26 Posts, Last By: Aurora May 20th Dusk and Embers
8 Posts, Last By: Skye May 19th Making the time to listen and talk
13 Posts, Last By: Chambers May 18th New hobby
1 Posts, Last By: Skye May 18th A second lesson
39 Posts, Last By: Skye May 18th MR/BE: Safety circle split off
44 Posts, Last By: ReubanBrightwood May 17th MR: Safety circle
25 Posts, Last By: ReubanBrightwood May 17th Clean up crew: Political Bulwarks
21 Posts, Last By: Chambers May 11th Thirteen
8 Posts, Last By: Chambers May 8th Ediolon
8 Posts, Last By: Chambers May 8th NMYF: The veterinarian is in
71 Posts, Last By: ReubanBrightwood May 7th (Private)When Paths Shift
43 Posts, Last By: Aurora May 5th Befriending a Murder
2 Posts, Last By: Thirteen May 4th First training session
22 Posts, Last By: Skye May 1st
|
Vampire
A meeting at Mysticism
7 Posts, Last By: Seryna May 21st The Prince and the Seneschal
12 Posts, Last By: Alessandra May 21st Lotus: Art of conversation
5 Posts, Last By: Alessandra May 20th (2505)Formal Court
20 Posts, Last By: Helen Kingsley May 19th Visiting the Local Library
6 Posts, Last By: Seryna May 19th Watchstanders - Fieldwork
13 Posts, Last By: Seryna May 19th (2504)Eternal Court
31 Posts, Last By: Seryna April 30th Necropolis: First Meetings
14 Posts, Last By: Jennifer Hazelton April 29th Park Planning Committee
18 Posts, Last By: Alicia Silvers April 24th Watchstanders: Dark tides
2 Posts, Last By: Seryna April 9th (2503) Eternal Court
20 Posts, Last By: Alicia Silvers March 30th A Good Friday for Mass
12 Posts, Last By: Jennifer Hazelton March 28th Necropolis A new outlook
8 Posts, Last By: Jennifer Hazelton March 27th Seneschal's Office Haunting meeting
20 Posts, Last By: Jennifer Hazelton March 27th Watchstanders: The Patrol
18 Posts, Last By: Seryna March 25th Haunting in Sacramento The Strange Winds
34 Posts, Last By: Seryna March 24th Private conference room
3 Posts, Last By: Seryna March 15th Cruise the Sacramento River
14 Posts, Last By: Jennifer Hazelton March 8th (2502) Formal Court
35 Posts, Last By: Jennifer Hazelton February 26th Blood Deep
13 Posts, Last By: Jennifer Hazelton February 25th
|
