DB Design finally final.. ish?

I think we finally worked out what everything on my database design was meant to do. That might sounds strange, but I created it last summer, so our memory was rather foggy as to what everything on it was for. We spent lunchtime brainstorming why we did each table, and I think we've finally cracked it. Matt and I were rather impressed that we'd thought of just about everything!

For the Stargate poll that I posted the results for yesterday.. honestly I think that's the highest number of votes we've ever had in that amount of time! Current poll doesn't have quite as big a count, but also is much harder to script against.. being that it uses javascript & ajax. Well that's my theory ;)

I have made a folder with some choice images to post, but I'm fast running out! I only have images from production episode 1-4 (not air order), and we return the discs after we take the ones which are approved to go on the site. Bummer.. but I did however get my hands on some Ark of Truth pics. I don't want to post any until the movie is released.. to spoilerie of you know what I mean!

I like Joe's smile in today's pic.. although DH looks pained.. bad scene?

A previous poll's results (since they still haven't given me a place to post previous results on the official site):
Who would win in an intergalactic street brawl?
Ronon Dex 50% 7161 Votes
Teal'c 50% 7130 Votes
14291 Votes

Back to DB Redesign

Pretty quiet day, went live with the new Stargate Poll.. although it looks almost the same (minus a submit button ;))

After working on the system to pulling the downloads from the contests, I went back to the Transfer Tool. Yikes.. Found a couple cracks in the database design I made with my boss many months ago. Looks like tomorrow will be reviewing that, as things have gone quiet again on Stargate, and MGM HD is also not too noisy. American Gladiators stuff is going well as well, but more on that.. another day?

I love cheeky "candid" pics like today's.

Edit----------->

Results of the last stargate site poll for crownglass39!

Sheppard/McKay 49% 29389 Votes
Ronon Dex/Teyla Emmagan 40% 24002 Votes
Keller/Carter 11% 6881 Votes
60272 Votes in total.

Hollywood Ashes today!

The batsman is Steve Waugh!


Meat Pie and Cricket.. nuff said.

Rugby Jersey.. but the right colors!

This post is completely off topic, but today I'm going to the inaugural Hollywood Ashes Twenty20 cricket match. For the Aussie team it appears Steve Waugh and Mike Whitney will be there! Excitement.. also meat pies, which is actually the number one reason to go IMO. Pics are taken from lots of angles, with my lil point and shoot digital cam.. so not great, but pretty!

http://www.hollywoodashes.com/

Woot! Cricket in LA.. strange!

BFN

Half day today!

Thankfully today is a half day, so we're just tying up some small things before the long weekend, sadly even though my new ajax'd poll is ready to go, we never go live with any major code changes on Friday's (unless something is busted), so it won't go up until Tuesday.
I noticed someone had been messing with the last poll that was up. Honestly I'm shocked it took someone that long to work out how poorly it was coded, and take advantage of that to skew results.

A couple posts ago I mentioned Team Stargate and the results, and chevron7 asked me the following:
Why is Team Stargate only open to residents of the US and Canada?

While I don't know a "for sure" answer to this, and I've never directly asked anyone in legal, I think it's a combination of cost and law.
We have to abide very strictly to certain rules when running sweepstakes and contests. Team Stargate is considered a contest, as prizes are awarded, and every country (and sometimes state) has different laws governing these things. The marketing people who created Team Stargate have limited budgets (smaller than I'd imagined actually) and can't spend the extra money to have the contest available to other countries.

I've worked with some other large companies in the past, and they had the same challenges with running contest and sweepstakes online. Nestle only ran contests for US residents (not even Canada) and Toyota was the same. These companies have the advantage of having offices worldwide, and those parts of the companies in other countries can run local contests.

That was a much longer answer than I intended, but I wish we could do more for other countries, being that I'm not from here, and ran into the same difficulties.

I know some out there spend a lot of time finding stuff we do wrong on the site (like naming files that aren't supposed to be live a little too obviously) I ask you to please remember there's are only 4 of us.. and we can only spend a small amount of time on the Stargate site. Compassion please!

BFN!

Ajax poll and an image

As no one has specifically asked for any pics, I'm just going to randomly pick some that I like. If you'd like them emailed in the largest size I have (from gmail) you can email me at jeniimages@gmail.com.
I like this pic, the cheeky grin of a man willing to show his belly on TV!

Ark of Truth photo's went up today, just a small sampling, and I think more each week until the DVD is released. Team Stargate announced their rankings and winners, and so they are now live as well.

Writing the Ajax poll has been much simpler than I had anticipated. I think I've been avoiding doing Ajax for so long as I loathe Javascript. That's why I worked hard to become that hardcore backend programmer! No more Javascript and browser shenanigans. Until Ajax. *sigh*
Essentially all it does it capture the contents of the form, and send them via query string to a php page, which updates the DB, and shows the results. I thought it was going to be much more difficult..

BFN

Stargate site changes galore

Tons of work on Stargate site this week.. sadly to the detriment of the other sites.

I work hard to separate my love for the show, from my extreme displeasure at the marketing choices made by TPTB over what we can put on the site, what we are promoting, and the content they give us.

So pages are ready to go up (once legal approved) for Rankings and Winners of Team Stargate. This has been a major argument point over the last few days, but I won't go into it. The pages themselves are super simple, I wrote them to be database driven from the administration site, so our content person can update them as they get the ranks/winners. Along with this we have received all of the new images for Ark of Truth! Sadly I have to rewrite the stills page to accommodate these, nothing dramatic, but going to be partially hard-coded for each movie, since there will be no more SG1 seasons.

Between all these new pages, I've been rewriting the home page poll. It's just not been working the way we'd hoped. When we first wrote this site about a year ago, it was in a huge hurry (we had a month and a half!) so I cut corners where possible, and the poll was on a corner. Basically it's someone else's code, shoehorned into our administration site, and front end. It breaks when you put single apostrophes in the fields. I know.. simple to fix.. except who loves wading through someone else's code? not me! So I'm just rewriting it. Much simpler and easier for the content people to use.

That's about half of the updates just for this week. Sounds quick and easy.. but no such luck of course!

Going to a pre-screening of Cloverfield tonight.. WOOT!

BFN

Missed the fun.. nerdy cube though!

So I actually missed the fun that happened when the pics were taken. I was only at the breakfast that was had before the filming of the speech. As a result, I have no idea what they were laughing at! I will endeavor to find out though. In addition I can't get any larger images from said event.

If only I had more pics to post! Sadly no.. so you're treated to the wonderful view from my cube.



BFN