lucky 
my artist has done one days art in the last 150 days.
needless to say that project is on the backburner. crisping up to a black ball of burnt ideas. [import]uid: 34945 topic_id: 11800 reply_id: 43573[/import]
New message on GDN called An Infinite Number of Horses that includes a short video showing the progress I made today:
http://gamedevnation.com/game-development/horse-crazy-an-infinite-number-of-horses/
Jay
[import]uid: 9440 topic_id: 11800 reply_id: 43998[/import]
Latest update on Horse Crazy is on the GDN site, including some artwork sketches.
Here’s a peek:
To see more and find out what’s happening with the project, see the post here:
http://gamedevnation.com/?p=377
Jay
[import]uid: 9440 topic_id: 11800 reply_id: 45737[/import]
Four days left and Dwayne has been shooting me artwork that I’m resizing and putting in the app (I told him to give me large sizes and I’d scale them down). I wrote the “select a piece of tack and put it on the horse” code a couple weeks ago, but now that I have multiple pieces of art to work with I’m finding some, well, let’s call them deficiencies. 
I have all the tack in a database table called tack (if nothing else, I am *terribly* creative). Some of the tack is already on a horse, some is still in the tack shed. Differentiating between the two is where I’m balled up at the moment.
The problem is that I was going to allow a horse blanket, for example, to be used on all three horses – without having three blankets showing up in the picker. So I need to keep track of which piece of tack has already been used on which horse.
In a recent blog post (An Infinite Number of Horses) I talked about how I’d decided to do that – create a TackOnHorses table and keep that updated when you take tack off and on a horse.
The problem I’m running into is one of queries – I need to be able to get all the tack available for a given horse, not including the tack already being used.
Something like:
[mysql]
select * from tack where (tack does not appear in tackonhorses table where horseid is X)
[/mysql]
If you’re a DBA (or play one on TV) who knows SQLite, feel free to knock out that query and post it. I know there’s a join or something in there, but I’ve never been a DBA and the days when I played in SQL Server often enough that I could figure it out are long past.
That’s what’s happening tonight in Wasilla, Alaska. Horse and tack databases for everyone!
Jay
[import]uid: 9440 topic_id: 11800 reply_id: 47254[/import]
We’re coming down to the wire, but I think we’re gonna win by a nose.
Looking like a beta version of Plan C should be ready late Wednesday or early Thursday. (We already gave up on Plans A and B for this release.)
Below is a clip of the main menu – question: is the font too stylized for kids? For a “fancy” font it’s fairly tame, but just wondering if kids will know what the buttons say. Any thoughts?
Thanks!
Jay
[import]uid: 9440 topic_id: 11800 reply_id: 47416[/import]
My eight year old can read it fine [import]uid: 34945 topic_id: 11800 reply_id: 47418[/import]
Thank goodness that the English language has 26 letters and does not stop at C
[import]uid: 3826 topic_id: 11800 reply_id: 47419[/import]
If you still need a query for excluding existing tack, try this:
[mysql]
select *
from tack
where tack not in (select tack from tackonhorses where horseid = x)
[/mysql] [import]uid: 22492 topic_id: 11800 reply_id: 47604[/import]
Okay, I’ll come clean on what happened when the Horse Crazy deadline came along:
http://gamedevnation.com/game-development/horse-crazy-the-final-not-really/
Use it as a cautionary tale so it doesn’t happen to you!
Jay
[import]uid: 9440 topic_id: 11800 reply_id: 50301[/import]
D’oh!
I still think you’re cool! [import]uid: 34945 topic_id: 11800 reply_id: 50309[/import]