Jordan aka FltAdmlWolf Posted August 27, 2010 Posted August 27, 2010 I'm in the final stages of preparing the new website for launch, and I need some help with moving a few areas. For the Writing Challenges area, I don't have any data on the website for challenges that happened in 2009 or 2010. Here's what I need: 1. Challenge dates2. Link to challenge archive forum3. Theme4. Winning entry name5. Winning entry author6. Link to winning entryFor example: 1. Nov.-Dec. '082. http://www.starbase118.net/forums/index.php?showforum=3533. "What if the Federation descended into a civil war?"4. "The Cost of the Greater Good"5. Iolo Madoc Llewelyn6. http://www.starbase118.net/forums/index.php?showtopic=4501Even better would be if I could get it formatted in the following template: <li><a href="http://www.starbase118.net/forums/index.php?showforum=353">Nov.-Dec. '08</a></li> <ul> <li>Theme: "What if the Federation descended into a civil war?"</li> <li>Winner: "<a href="http://www.starbase118.net/forums/index.php?showtopic=4501">The Cost of the Greater Good</a>," by: Iolo Madoc Llewelyn</li> </ul>That way I can just copy/paste what I get into the new site! If you can help - even if you can only do two or three! - just REPLY to this thread. If you can do it in the HTML template, just use the "code" button when you reply. It looks like this: < > If you put the HTML inside that, it'll appear properly. Can anyone help?
kimstapledon Posted August 27, 2010 Posted August 27, 2010 On 8/27/2010 at 4:14 AM, FltAdml. Wolf said: I'm in the final stages of preparing the new website for launch, and I need some help with moving a few areas. For the Writing Challenges area, I don't have any data on the website for challenges that happened in 2009 or 2010. Here's what I need: 1. Challenge dates2. Link to challenge archive forum3. Theme4. Winning entry name5. Winning entry author6. Link to winning entryFor example: 1. Nov.-Dec. '082. http://www.starbase118.net/forums/index.php?showforum=3533. "What if the Federation descended into a civil war?"4. "The Cost of the Greater Good"5. Iolo Madoc Llewelyn6. http://www.starbase118.net/forums/index.php?showtopic=4501Even better would be if I could get it formatted in the following template: <li><a href="http://www.starbase118.net/forums/index.php?showforum=353">Nov.-Dec. '08</a></li> <ul> <li>Theme: "What if the Federation descended into a civil war?"</li> <li>Winner: "<a href="http://www.starbase118.net/forums/index.php?showtopic=4501">The Cost of the Greater Good</a>," by: Iolo Madoc Llewelyn</li> </ul>That way I can just copy/paste what I get into the new site! If you can help - even if you can only do two or three! - just REPLY to this thread. If you can do it in the HTML template, just use the "code" button when you reply. It looks like this: < > If you put the HTML inside that, it'll appear properly. Can anyone help? Hi Adm Wolf,Is this site in PHP? If so it might be a good idea to define a class called something like PastWritingChallenge that maps to a table called past_wc such that past_wc is created like this:create table past_wc ( id int auto_increment primary key, theme varchar(256), winner text);Then PastWritingChallenge would have fields theme and winner coming from the past_wc table. Finally a simple data entry app could be created that would insert records into past_wc for immediate consumption by the app that displayed the records....Any thoughts?
Jordan aka FltAdmlWolf Posted August 27, 2010 Author Posted August 27, 2010 On 8/27/2010 at 4:24 AM, kvdbreem said: Hi Adm Wolf,Is this site in PHP? If so it might be a good idea to define a class called something like PastWritingChallenge that maps to a table called past_wc such that past_wc is created like this:create table past_wc ( id int auto_increment primary key, theme varchar(256), winner text);Then PastWritingChallenge would have fields theme and winner coming from the past_wc table. Finally a simple data entry app could be created that would insert records into past_wc for immediate consumption by the app that displayed the records....Any thoughts?The Writing Challenge Area is pretty much just a list of past winners, for easy reference. Nothing so fancy
Chen Posted August 27, 2010 Posted August 27, 2010 I just put it on my weekend to-do list - I don't think I'll get chance today but I certainly should be able to help out as far back as June 09 I think. (Unless someone beats me to it of course!)
Guest Posted August 27, 2010 Posted August 27, 2010 Whereas I probably won't get a cance until at least Sunday, so I'll see if I can pick up any bits you miss!
Chen Posted August 29, 2010 Posted August 29, 2010 (edited) Below is everything I can find for 2009-2010, if there's any problem with the code then give me a shout and I'll fix it. I think it should be OK though. Mar-Apr 09 is missing, and I wasn't a member of the group back then so I can't offer you an explanation! <li><a href="http://www.starbase118.net/forums/index.php?/forum/137-writing-challenges/">Jul.-Aug. '10</a></li> <ul> <li>Theme: "Universal Rights"</li> <li>Winner: "<a href="http://www.starbase118.net/forums/index.php?/topic/5172-righting-the-past/">Righting the Past</a>," by: Tal Tel-ar</li> </ul> <li><a href="http://www.starbase118.net/forums/index.php?/forum/389-may-jun-10/">May-Jun. '10</a></li> <ul> <li>Theme: "Present"</li> <li>Winner: "<a href="http://www.starbase118.net/forums/index.php?/topic/5114-circle/">Circle</a>," by: Thomas Gregory</li> </ul><li><a href="http://www.starbase118.net/forums/index.php?/forum/388-mar-apr-10/">Mar.-Apr. '10</a></li> <ul> <li>Theme: "To Seek Out New Life"</li> <li>Winner: "<a href="http://www.starbase118.net/forums/index.php?/topic/5071-excision/">Excision</a>," by: Kevin Breeman</li> </ul><li><a href="http://www.starbase118.net/forums/index.php?/forum/387-jan-feb-10/">Jan.-Feb. '10</a></li> <ul> <li>Theme: "Perspective"</li> <li>Winner: "<a href="http://www.starbase118.net/forums/index.php?/topic/5008-broken/">Broken</a>," by: Jesse Lawn</li> </ul><li><a href="http://www.starbase118.net/forums/index.php?/forum/359-nov-dec-09/">Nov.-Dec. '09</a></li> <ul> <li>Theme: "What if the Cardassians had occupied Earth instead of Bajor?"</li> <li>Winner: "<a href="http://www.starbase118.net/forums/index.php?/topic/4942-real-lips/">Real Lips</a>," by: Kevin Breeman</li> </ul><li><a href="http://www.starbase118.net/forums/index.php?/forum/358-sep-oct-09/">Sep.-Oct. '09</a></li> <ul> <li>Theme: "The Gathering Darkness"</li> <li>Winner: "<a href="http://www.starbase118.net/forums/index.php?/topic/4823-the-darkness-within/">The Darkness Within</a>," by: Tallis Rhul</li> </ul><li><a href="http://www.starbase118.net/forums/index.php?/forum/357-jul-aug-09/">Jul.-Aug. '09</a></li> <ul> <li>Theme: "The Gauntlet"</li> <li>Winner: "<a href="http://www.starbase118.net/forums/index.php?/topic/4785-the-gauntlet-of-atlas/">The Gauntlet of Atlas</a>," by: David Whale</li> </ul><li><a href="http://www.starbase118.net/forums/index.php?/forum/356-may-jun-09/">May-Jun. '09</a></li> <ul> <li>Theme: "The Tomb"</li> <li>Winner: "<a href="http://www.starbase118.net/forums/index.php?/topic/4660-the-mystery-of-lengdis-viii/">The Mystery of Lengdis VIII</a>," by: Jhen Thelev</li> </ul><li><a href="http://www.starbase118.net/forums/index.php?/forum/354-jan-feb-09/">Jan.-Feb. '09</a></li> <ul> <li>Theme: "Inheritance"</li> <li>Winner: "<a href="http://www.starbase118.net/forums/index.php?/topic/4610-only-one-constant/">Only One Constant</a>," by: Nemitor Atimen</li> </ul> Edited August 29, 2010 by Tallis Rhul
Jordan aka FltAdmlWolf Posted August 29, 2010 Author Posted August 29, 2010 Perfect - you have no idea how much time that saved me! Thank you!We're getting very close on our website relaunch. I'm hoping to have it up this week!
Recommended Posts