Jump to content

  • Recently Browsing   0 members

    • No registered users viewing this page.

Can anyone help with some WC data collection?

Jordan aka FltAdmlWolf

By Jordan aka FltAdmlWolf
in 2010

 Share

Recommended Posts

Jordan aka FltAdmlWolf Transhuman Elite

Jordan aka FltAdmlWolf

Posted
Posted

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.starbase118.net/forums/index.php?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.starbase118.net/forums/index.php?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? o:)

Link to comment
Share on other sites
kimstapledon Salt this, buddy!

kimstapledon

Posted
Posted

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.starbase118.net/forums/index.php?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.starbase118.net/forums/index.php?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? o:)

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?

Link to comment
Share on other sites
Jordan aka FltAdmlWolf Transhuman Elite

Jordan aka FltAdmlWolf

Posted
  • Author
Posted
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 :)

Link to comment
Share on other sites
Chen

Chen

Posted
Posted

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

Link to comment
Share on other sites
Chen

Chen

Posted
Posted (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 by Tallis Rhul
Link to comment
Share on other sites
Jordan aka FltAdmlWolf Transhuman Elite

Jordan aka FltAdmlWolf

Posted
  • Author
Posted

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!

Link to comment
Share on other sites
 Share
Go to topic listing
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.

  I accept