6 replies to this topic

[FltAdml. Wolf]

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 dates
2. Link to challenge archive forum
3. Theme
4. Winning entry name
5. Winning entry author
6. Link to winning entry

For example:

1. Nov.-Dec. '08
2. http://www.starbase1...p?showforum=353
3. "What if the Federation descended into a civil war?"
4. "The Cost of the Greater Good"
5. Iolo Madoc Llewelyn
6. http://www.starbase1...?showtopic=4501

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

[kvdbreem]

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 dates
2. Link to challenge archive forum
3. Theme
4. Winning entry name
5. Winning entry author
6. Link to winning entry

For example:

1. Nov.-Dec. '08
2. http://www.starbase1...p?showforum=353
3. "What if the Federation descended into a civil war?"
4. "The Cost of the Greater Good"
5. Iolo Madoc Llewelyn
6. http://www.starbase1...?showtopic=4501

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

[FltAdml. Wolf]

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

[Diego Herrera]

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

[Sinda Essen]

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!

[Diego Herrera]

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 by Tallis Rhul, 29 August 2010 - 02:47 AM.

[FltAdml. Wolf]

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!