|
|
| 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
Diverging Futures at Ednas
5 Posts, Last By: Anatole April 26th Teach me Maestro Monkee
5 Posts, Last By: Circe April 25th Sleep Paralysis
223 Posts, Last By: Sonnie Wu April 24th High Striker: IDK, uh, Free Food + Talk
30 Posts, Last By: Circe April 21st (2403)Spring Coronation!
46 Posts, Last By: Saber Sloth April 20th Pain into Growth
1 Posts, Last By: Seraphina April 9th Rust-Eez Brush Removal
1 Posts, Last By: Circe March 29th Tunnels: Make it to, um, fake it
1 Posts, Last By: Circe March 26th Keeping the wheels on
2 Posts, Last By: Saber Sloth March 23rd (City on Fire) Sparks
131 Posts, Last By: Saber Sloth March 23rd PrP: Tunnels Off the Rails
46 Posts, Last By: Circe March 22nd (2402) A Warm Night at Edna's
22 Posts, Last By: Anatole March 18th Funderland Fight club
68 Posts, Last By: Kray March 12th Animating a Zombie Gun
1 Posts, Last By: Circe March 8th Welcome Back
7 Posts, Last By: Seraphina March 3rd The station is the destination
29 Posts, Last By: Kray March 1st PRP Railing against the dark
59 Posts, Last By: Circe February 22nd Old stories
22 Posts, Last By: Kray February 15th Kray
8 Posts, Last By: Saber Sloth February 2nd Walking off an appetite
2 Posts, Last By: Kray January 29th
|
Mage
Plot: Squeaky Choir: Sewage District
31 Posts, Last By: Winter April 25th (2404) Consilium
64 Posts, Last By: Corn April 25th Plot: Fallen Power: The Community Centre
42 Posts, Last By: Philip Crosen April 25th PRP DYLF: Taking stock and making plans
4 Posts, Last By: Corn April 25th Rendezvous
11 Posts, Last By: Winter April 24th A new, free, liberal chat
21 Posts, Last By: Philip Crosen April 24th PRP: DYLF: Back to the lounge
86 Posts, Last By: ReubanBrightwood April 21st Mysterium meeting VII faces old and new
59 Posts, Last By: Corn April 18th (Private)Catching Up
25 Posts, Last By: ReubanBrightwood April 13th Purple Thumb
61 Posts, Last By: Chambers April 10th Food, Drinks, and a chat
37 Posts, Last By: Chambers April 9th Consilium Corkboard
4 Posts, Last By: Chambers April 1st (2403) Sanctuary
74 Posts, Last By: Philip Crosen March 30th PRP: DYLF: Philip's Sanctum
39 Posts, Last By: ReubanBrightwood March 20th Stroll through the stones
46 Posts, Last By: Chambers March 10th The first commission
4 Posts, Last By: Chambers March 2nd (2402) Sanctuary
27 Posts, Last By: Chambers March 1st PRP: DYLF: All Faith Cremation
58 Posts, Last By: ReubanBrightwood February 29th Hitting the books
2 Posts, Last By: Chambers February 15th Recent history: On the job
1 Posts, Last By: Chambers February 12th
|
Vampire
Raul the second invite
23 Posts, Last By: Verity Carmen April 25th Shuffling the deck
20 Posts, Last By: Verity Carmen April 25th Fists and first brushes
2 Posts, Last By: Jennifer Hazelton April 25th (2404)Eternal Court
29 Posts, Last By: Jennifer Hazelton April 25th A most feline discussion
14 Posts, Last By: Albert Baker April 25th Innocent Lost Plot Short & Sweet
22 Posts, Last By: Verity Carmen April 24th (Private)Meeting of the minds?
20 Posts, Last By: Jennifer Hazelton April 21st Gathering to pay tribute
22 Posts, Last By: Jacque April 17th The Antique auction
2 Posts, Last By: Seryna April 15th (2404) Learning the moves
1 Posts, Last By: Verity Carmen April 14th Ordo Dracul Meeting 2/29
17 Posts, Last By: Seryna April 7th All roads have led to Raul
2 Posts, Last By: Verity Carmen March 31st March Blood Hunt Activities
20 Posts, Last By: Seryna March 30th (2403)Eternal Court
24 Posts, Last By: Verity Carmen March 29th Concluding the deal
17 Posts, Last By: Verity Carmen March 24th Music Party
30 Posts, Last By: Jennifer Hazelton March 24th (Blood Hunt) Office Reconnaissance
20 Posts, Last By: Seryna March 22nd Jennifer Hazleton
6 Posts, Last By: Verity Carmen March 8th Losh
6 Posts, Last By: Verity Carmen March 8th Scott Price
6 Posts, Last By: Verity Carmen March 8th
|
