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 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 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