|
|
| 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
Sac Comic Con
19 Posts, Last By: Kray March 23rd Welcome at the Witch House
26 Posts, Last By: Kray March 23rd The Welcome tour
1 Posts, Last By: Kray March 23rd (2603) Spring Equinox
8 Posts, Last By: Jack Violet March 23rd (Rope Bridge) Crossing
114 Posts, Last By: Jack Violet March 23rd Sea Salt Cravings
1 Posts, Last By: Ellaria Undertow March 22nd Talking Points
83 Posts, Last By: Kray March 21st (Talking Points) Tracks
3 Posts, Last By: Circe March 20th Springing into Action
37 Posts, Last By: Sonnie Wu March 17th Show Bidness
3 Posts, Last By: Sonnie Wu March 11th Summers Speaking Easy
30 Posts, Last By: Circe March 3rd Fine dining and parlour magic
39 Posts, Last By: Kray February 21st PRP Tunnels: What Lies Forth
40 Posts, Last By: Circe February 21st (2512) Winter Solstice
45 Posts, Last By: Saber Sloth January 21st Notice Board!
20 Posts, Last By: Circe January 18th Jack Violet
6 Posts, Last By: Svelte Sven January 15th Wining over the Cleanup
1 Posts, Last By: Circe January 11th A shift at the rodent graveyard
1 Posts, Last By: Kray January 10th Shaking hands (Harvest)
2 Posts, Last By: Kray December 29th String Carols by Candlelight
29 Posts, Last By: Kray December 26th
|
Mage
Shadows of San Francisco: At the table
43 Posts, Last By: Skye March 23rd (2602) Sanctuary
32 Posts, Last By: Aurora March 23rd Back to the Bismark
19 Posts, Last By: ReubanBrightwood March 23rd In the Rose Garden
9 Posts, Last By: Thirteen March 22nd Clean up crew: Hunters house
31 Posts, Last By: Skye March 22nd MR: Investigations of the abyssal
11 Posts, Last By: ReubanBrightwood March 22nd Clean up Crew: Sewage spill
11 Posts, Last By: ReubanBrightwood March 22nd Consilium Corkboard
39 Posts, Last By: Skye March 16th Knowing Thy Neighbors
1 Posts, Last By: Thirteen March 15th The Unlucky Day
1 Posts, Last By: Thirteen March 13th Dreams Inspire Mastery
2 Posts, Last By: Asclepius March 11th Studies in Orichalcum
7 Posts, Last By: Thirteen March 9th Woven stories
1 Posts, Last By: Chambers March 9th Duel school: round two!
32 Posts, Last By: Chambers March 8th Shadows of San Francisco: Opening moves
40 Posts, Last By: ReubanBrightwood March 8th A simple dream fulfilled
1 Posts, Last By: Skye March 8th Duel school round two: Witch and Skye
38 Posts, Last By: Chambers March 8th LL&H: Sleeping interest
76 Posts, Last By: ReubanBrightwood March 7th Preparations for a sewage search
1 Posts, Last By: Asclepius March 6th Item left
2 Posts, Last By: ReubanBrightwood March 6th
|
Vampire
(2603)Formal Court
27 Posts, Last By: Seryna March 23rd Projector night
17 Posts, Last By: Alicia Silvers March 21st Stolen Blood: Fire Drill
21 Posts, Last By: Otto Schneider March 20th Two Savages Talking
7 Posts, Last By: Alessandra March 19th Valentine's Day Game Night
8 Posts, Last By: Jennifer Hazelton March 13th (2602)Eternal Court
20 Posts, Last By: Alicia Silvers February 28th Keep open eyes
1 Posts, Last By: Alicia Silvers February 18th 90s night
15 Posts, Last By: Alicia Silvers February 18th Rot Beneath: Walking the Beat
11 Posts, Last By: Seryna February 16th Stolen Blood Ch 1 Lighting the Candle
35 Posts, Last By: Jennifer Hazelton February 13th (Private) A Welcome Back?
14 Posts, Last By: Raul February 6th Seneschal's Office Rose and the Haunt
17 Posts, Last By: Jennifer Hazelton February 1st (2601) Eternal Court
30 Posts, Last By: Kylar Stern January 31st Singles night, new hunting ground
2 Posts, Last By: Alicia Silvers January 28th The Rot Beneath Chapter One Corpse Chaos
23 Posts, Last By: Seryna January 26th Kylar Stern
5 Posts, Last By: Alicia Silvers January 13th Jennifer invites a guest
12 Posts, Last By: Jennifer Hazelton January 12th The Rot Beneath: Ch 1 Alicia's Efforts
20 Posts, Last By: Seryna January 8th The Rot Beneath: Ch 1 Alessandra's Act
23 Posts, Last By: Seryna January 8th Matters of the lost
12 Posts, Last By: Seryna January 4th
|
