Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - JohnH

Pages: 1 ... 29 30 31 32 33 [34] 35 36 37 38 39 ... 41
496
Watto's Junk Yard / Re: PHP / MySQL...who here knows it?
« on: May 11, 2006, 09:33 PM »
What exactly are the issues you're having? More details please  :)

I thought I'd leave that to the PMs, but hey...why not?  ;)

The site in progress is at www.toytraderz.com, which I hope to have live by June some time.   One feature of the site is a Toy Database, the main page of which can be found here:

http://www.toytraderz.com/index.php?name=ttgallery

The structure of this CMS's image gallery is like so.  First there are categories, which can have related subcategories.  Then the albums (which hold images and info) are attached to the applicable category or subcategory.  Examples you’ll see on the site now are:

Star Wars
Star Wars > Modern
Star Wars > Modern > Hasbro – Saga (2006-present)
Star Wars > Modern > Hasbro – Saga (2006-present) > Figures

These categories then have albums which hold each item’s details and images.  For instance, the Hasbro – Saga 2006 category > Figures category has a subcategory of albums for each item in that line, shown here:

http://www.toytraderz.com/index.php?name=ttgallery&cat=28

Each album then has a set of images.  So data is pulled from a categories table, an albums table, and a pictures table.

You can see on the main gallery page what one of the problems is.  The main Star Wars category, when you total up everything in the applicable subcategories, has 751 items and 341 images.  But as you can see it doesn’t show this aggregate count in the main gallery menu or sub categories – it only shows “0” unless the next level down is the album itself.  Example can be seen here:

http://www.toytraderz.com/index.php?name=ttgallery&cat=25

Where all these categories have subcategories except Kubrick, so they're all showing 0 except Kubrick's count of 2.

The second issue is the search.  It appears to be using an “or” operator to search rather than an “and”.  Here is the search page:

http://www.toytraderz.com/index.php?name=ttgallery&file=search

Let’s say I type in “Alien”.  I get 43 items.  I type in “game” and I get 6 items.  Now, if I want to put in “Alien Game”, I should only get the 6 items, but instead I’m getting 43 because it’s searching to see if the keywords has game *or* Alien, not game *and* Alien.  I know what the issue is here, I just don't know how to fix it.  :)

I really didn't want to show this until it was ready to launch, but no biggie...anyone bored enough is welcome to get in there and make some posts in the forum to get things going.  :P

Coincidentally, if anyone feels like contributing to the site, let me know.  There's a ton of work to do in the toy database and I know there are some knowledgable collectors out there that would loooove to help.  ;)

John

497
Watto's Junk Yard / PHP / MySQL...who here knows it?
« on: May 11, 2006, 06:11 PM »
Does anyone here know a bit about PHP and MySQL?  I'm working on developing a website and there are a couple of issues I'm having - one with a search page and another involving an aggregate count of categories, subcategories and content of each.  The support for the CMS I'm using isn't getting me anywhere regarding these problems and I was hoping maybe there was a developer or two here that might be willing to help.  I can probably even pay a couple of bucks if it need be (or buy you a pizza or something).  :) 

Thanks for looking.  Please PM or e-mail if you think you might be able to help.

John

498
Saga Collection '06 / Re: Ordering TSC Cases?
« on: April 19, 2006, 11:11 PM »
I've been considering doing this myself with EE.  $80 for a case isn't bad at all, especially when you considering the extra cash spent on gas and the time wasted.  Based on everyone's experience, are there often times where you find the stuff in a store before you receive your case from EE?  I'm sure it's bound to happen from time to time, I'm just wondering if it can be a regular event.

John

499
JD Sports Forum! / Re: JD Fantasy Baseball 2006
« on: April 16, 2006, 08:51 AM »
I never thought I'd say this about anyone, but your arrogance makes me cringe almost as much as MisterKenobi's.  Almost.

Food for thought.

John

500
Watto's Junk Yard / Re: Top 5 Hotties
« on: April 12, 2006, 07:08 PM »
First of all, she's a little skinny for my tastes.  Not horrible, but a bit too skinny.  Second of all, and most importantly, I'm sick of seeing her *everywhere*. 

John

501
JD Sports Forum! / Re: MLB 2006
« on: April 12, 2006, 01:52 PM »
Oh man...the Royals are ******* KILLING me.  Take a 3-0 lead in the first only to lose it after 3 batters.  And that's after a pair of 3-run homers yesterday.  It's gonna be another rough year.   :'(

John

502
JD Sports Forum! / Re: JD Fantasy Baseball 2006
« on: April 10, 2006, 12:43 AM »
Right.  If one guy gave up 2 runs in 6 innings (3.00 ERA) and another gave up 4 runs in no innings (Inf ERA), your team ERA is 9.00.

John

503
JD Sports Forum! / Re: MLB 2006
« on: April 8, 2006, 12:28 AM »
Taveras, what a classy player.  I'd love to see Taveras and Bruce Bowen locked in the same room to fight to the death.

Then I'd like to see the winner devoured by a rabid tiger.

John

504
JD Sports Forum! / Re: JD Fantasy Baseball 2006
« on: April 5, 2006, 11:50 AM »
Guys, sorry about my disappearance from the league.  Long story, but to summarize it was just a stupid move on my part.  I was in a public league, decided to leave it, and left JD instead.  I realized it not long after, deleted myself from the public league, then forgot to sign back up for JD.  :(  Hope I didn't screw anything up, though it looks like everything worked out OK.

John

505
JD Sports Forum! / 2006 NCAA Tourney - Brackets on Yahoo
« on: March 12, 2006, 09:12 PM »
The field has been set, so it's time for the obligiatory online Star Wars Fans Hoops Bracket.  I've just set one up on Yahoo, so for those interested here's the info:

http://fantasysports.yahoo.com/

Sign up for the College Hoops league, join a custom league, and use the following league info:

League: 54899
PW:  swhoops

Should be an interesting tourney as always.

GO JAYHAWKS!!!!   :)

John

506
JD Sports Forum! / Re: JD Fantasy Baseball 2006
« on: March 7, 2006, 03:22 PM »
Only 7 people are interested?

507
JD Sports Forum! / Re: JD Fantasy Baseball 2006
« on: February 23, 2006, 02:33 PM »
I'm in and working on getting a friend or two (Chris Elliott and Broc from RS) to sign up.  We should try Shawn Tierney (EZ) from the hoops league as well.

John

508
JD Sports Forum! / Re: JD Fantasy Baseball 2006
« on: February 13, 2006, 07:03 PM »
Are there any slots left?

John

509
JD Sports Forum! / Re: JD Fantasy Baseball 2006
« on: February 6, 2006, 12:55 AM »
I'm in, so long as there's a real draft and not one that's forum-based.  Scott, where are you seeing that we can't do a draft in a free league?

As far as scoring goes, I've always been a big fan of the rotisserie scoring over a points-based system.

John

510
Watto's Junk Yard / Re: It's good enough for me...The Goonies
« on: January 8, 2006, 01:00 AM »
This movie has one of the best deliveries of a line in the history of cinema.  Chunk's "Oh ****, what?" after Mrs. Walsh asks about the potato chip mess is an absolute classic.

Doesn't matter how many times I see this movie, it never gets old.  I can't believe it's over 20 years old now.   :-\

John

Pages: 1 ... 29 30 31 32 33 [34] 35 36 37 38 39 ... 41