|
|
| 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
String Carols by Candlelight
4 Posts, Last By: Kray December 5th Munchies and Movies
11 Posts, Last By: Svelte Sven December 4th Lemon? Upcycle it!
1 Posts, Last By: Circe December 4th Hedge Patrol X
111 Posts, Last By: Saber Sloth December 3rd Speak Easy: Facts and Feast
25 Posts, Last By: Saber Sloth December 3rd Jamie's Cafe Annual Car Show
34 Posts, Last By: Saber Sloth December 3rd Tea and Talks
30 Posts, Last By: Saber Sloth December 3rd Mystique Dining
26 Posts, Last By: Saber Sloth December 3rd Friday night Magic and games
2 Posts, Last By: Saber Sloth December 3rd Halloween Haul, Candy Camping
28 Posts, Last By: Saber Sloth December 3rd Autumn Equinox 2025
49 Posts, Last By: Saber Sloth December 2nd K-Pop Karaoke
27 Posts, Last By: Saber Sloth December 2nd (2508) Eternal Seasons
26 Posts, Last By: Saber Sloth December 2nd (2506) Summer Solstice
57 Posts, Last By: Saber Sloth December 2nd (Hedge Patrol X)Following the Hoberflies
47 Posts, Last By: Saber Sloth June 23rd A Tour! Here there and Everywhere!
37 Posts, Last By: Mina June 20th (2505) Eternal Seasons
37 Posts, Last By: Sonnie Wu June 20th Notice Board!
19 Posts, Last By: Circe June 10th Science is Gaseous
1 Posts, Last By: Circe June 6th Underland: Ash and Onyx Brawl (Duel)
26 Posts, Last By: Kray June 5th
|
Mage
NMYF: Poison of the soul
4 Posts, Last By: ReubanBrightwood December 5th Clean up Crew: Long lost knowledge
3 Posts, Last By: ReubanBrightwood December 5th Clean up crew: Grave robbing
4 Posts, Last By: ReubanBrightwood December 5th (2512) Sanctuary
5 Posts, Last By: Skye December 5th Where two rivers meet
5 Posts, Last By: Asclepius December 4th A chat with the newest councillor
10 Posts, Last By: Thirteen December 4th Clean up crew: A necromancers corpse
24 Posts, Last By: ReubanBrightwood December 3rd Clean up crew: Return to the forties
54 Posts, Last By: ReubanBrightwood December 3rd An in your face metaphor
30 Posts, Last By: ReubanBrightwood December 3rd Summer Antique Fayre
3 Posts, Last By: Chambers December 3rd Of and For the Dead
18 Posts, Last By: ReubanBrightwood December 3rd The art of duelling
57 Posts, Last By: Chambers December 3rd Duel: Aurora VS Chambers
16 Posts, Last By: Aurora December 3rd Duel: Asclepius VS Thirteen
11 Posts, Last By: ReubanBrightwood December 3rd Arrows of the blade
12 Posts, Last By: ReubanBrightwood December 3rd Farmers market
2 Posts, Last By: ReubanBrightwood December 3rd (2511) Sanctuary - Winter Grilling
30 Posts, Last By: ReubanBrightwood December 3rd (2510 Consilium)
36 Posts, Last By: ReubanBrightwood December 3rd (2509) Sanctuary
44 Posts, Last By: Chambers December 3rd (2507 Consilium)
52 Posts, Last By: ReubanBrightwood December 3rd
|
Vampire
Haunting: Hemmed with Prayer
3 Posts, Last By: Alicia Silvers December 5th (2512) Formal Court
6 Posts, Last By: Alicia Silvers December 5th Night Streets
6 Posts, Last By: Otto Schneider December 4th The Rot Beneath: Chapter One
16 Posts, Last By: Seryna December 4th (2511) Eternal Court
16 Posts, Last By: Otto Schneider December 3rd Seneschal's Office Territorial discourse
3 Posts, Last By: Jennifer Hazelton December 3rd Watchstanders: The Lion's Den
4 Posts, Last By: Seryna December 3rd (2509) Eternal Court
24 Posts, Last By: Alessandra December 3rd (2510) Eternal Court
1 Posts, Last By: Seryna December 3rd (2508) Formal Court
25 Posts, Last By: Otto Schneider December 3rd (2507) Eternal Court
42 Posts, Last By: Kylar Stern December 3rd Joining the Club (Watchstanders)
25 Posts, Last By: Seryna December 3rd Conversation and contemplation
20 Posts, Last By: Otto Schneider December 3rd A pair of dragons dine
10 Posts, Last By: Kylar Stern June 27th (2506) Eternal Court
8 Posts, Last By: Otto Schneider June 26th Haunting in Sacramento: Final Rest
23 Posts, Last By: Seryna June 26th 28 years later drive in movie
2 Posts, Last By: Alicia Silvers June 22nd Past Plots
2 Posts, Last By: Seryna June 12th Watchstanders: Dark Eyes
6 Posts, Last By: Jennifer Hazelton June 12th Lotus: Art of conversation
14 Posts, Last By: Jennifer Hazelton June 11th
|
