Here's a checkers game written in T-SQL that you can play in the sql
query analyzer.
Enjoy :-)
query analyzer.
Enjoy :-)
-
-
Re: SQL Game
On 4 Jul 2004 09:34:47 -0700, swint002@yahoo. com wrote:
[color=blue]
> Here's a checkers game written in T-SQL that you can play in the sql
> query analyzer.
> http://www.geocities.com/swint002/checkers.txt
>
> Enjoy :-)[/color]
Now that's SQL abuse. :)
I remember about 2 years ago, there was discussion in
rec.games.rogue like.misc about the possibility of doing a roguelike game in
SQL.
-
Re: SQL Game
Ross Presser <rpresser@imtek .com> wrote in message news:<14jwymd88 bfc3$.mgmelml0e q1e$.dlg@40tude .net>...[color=blue]
> On 4 Jul 2004 09:34:47 -0700, swint002@yahoo. com wrote:
>[color=green]
> > Here's a checkers game written in T-SQL that you can play in the sql
> > query analyzer.
> > http://www.geocities.com/swint002/checkers.txt
> >
> > Enjoy :-)[/color]
>
> Now that's SQL abuse. :)
>
> I remember about 2 years ago, there was discussion in
> rec.games.rogue like.misc about the possibility of doing a roguelike game in
> SQL.[/color]
BTW - there's a bug in the game. If you promote a piece to a King,
then try to 'take' a piece backwards in a move that would result in a
double-take, you get a "stored procedure not found" error. Shame
really, because it's a very neat game. If I understood the code well
enough I might even try to debug it, but I ain't that clever and I
don't have the time! :-)
Comment
-
Re: SQL Game
>> Here's a checkers game written in T-SQL <<
Part of me is delighted with this because I love weird programming
tricks. Another part of me is thinking "I hope he gets a job soon" :)
Instead of using T-SQL for this, try to use more pure SQL in a game.
The following is a damn good exercise.
I happen to like Pai Gow Tiles for two reasons: (1) it is cool to be
the only white guy looking a like James Bond in a three piece suit at
an Asian game table (2) The traditional house way is statistical
flawed.
You have a set of 32 Chinese dominoes. These dominoes are based on the
toss of two dice seen as a total and not as a pair, so there are no
blanks like western dominoes and there are duplicates in the set.
The players get a hand of four tiles, which they arrange into two
hands (high and low) of two tiles. For you to win, both your hands
must beat the bank;
For the banker to win, both his hands must beat both your hands;
otherwise, the bet is a push (tie).
There are three ways to arrange the four tiles of a hand; the banker's
hand has to be drawn from the remainging tiles. Basically, it is a
combinatorics and probability problem.
The real trick is to do the data mining to come up with rules for
playing the game.
Google it!
Comment
Comment