SQL Game

Jul 20, 2005

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

View 3 Replies

Update Game Schedule

Apr 1, 2015

Before the start of each season, the various clubs/teams compile an initial game schedule using Excel. Once the master schedule is complete, it is sent to me. The initial master schedule is loaded into the database [MatchSchedule] from the Excel spreadsheet using the SQL Server Import/Export Wizard. This works well enough. However, during the season there are frequent small changes to dates & times, venues, etc. These changes are sent to me in Excel spreadsheets.

I need an efficient & ERROR FREE method of getting the new game details into the master schedule. I thought perhaps the easiest way to accomplish updates to the table MatchSchedule t1 was to use a temporary table MatchSchedule_Updates_temp t2 to hold the new game details (obtained from Excel spreadsheets) and then use UPDATE to update MatchSchedule with those games that have changed. The primary key is Match_Id.

Unfortunately, I keep getting the following error messages which I have been unable to correct!

Msg 102, Level 15, State 1, Line 4
Incorrect syntax near 't1'.
Msg 156, Level 15, State 1, Line 5
Incorrect syntax near the keyword 'SET'.
Msg 156, Level 15, State 1, Line 41
Incorrect syntax near the keyword 'WHERE'.

Here is my code:-

USE [database]
GO
UPDATE dbo.MatchSchedule t1
SET (
t1.MatchDate
,t1.MatchTime
,t1.Venue

[code]....

View 2 Replies View Related

A Game Company In Trouble

Jul 20, 2005

My Name is Nick Soutter, I am the owner of a small game company, Aepox Games(We're in the middle of a name change from "Lamar Games"),www.lamargames.net.Our first commercial game, Andromeda Online (www.andromedaonline.net) isgoing into beta soon. It runs on an evaluation edition of SQL Server 2000(our intention is, when it launches, we earn the money to buy a copy beforethe evaluation expires).We have been testing Andromeda Online, and found that saves to the databasetake about 10 seconds (we were anticipating less than 1). We felt we needsomebody experienced in optimizing sql databases to help us optimize thedatabase, and get it running in the best method for our particularapplication.Our program accesses the database in Java, and people with understanding inhow to optimize java connections would be a tremendous help.My company is small, and we honestly cant afford much. Everybody on thisproject, from the sound guys to the graphic artist, has worked for 1/10 to1/100 of the value of the job. We're simply a starting company looking fordedicated people who are willing to work more for credit than money.We can offer credit on our website(http://www.andromedaonline.net/credits.html) to anybody who helps us, butlittle more (maybe $100, but we're very over budget, and in desperate needof help). Because of how we intend the game to run (with maybe 100-200concurrent games running online), a 10 second save time is simplyunacceptable.Anybody who would be willing to help us, please send a resume toJoin Bytes!. Experience would be nice, but not a requirement.We're looking for someone who can talk with our programmer about the typesof calls made to our SQL database, and then can log into the DB and optimizeit to run as fast as possible considering our specific needs.Thank you for your time.Nick SoutterAepox (Lamar) Games

View 14 Replies View Related

Mising Dll To Play A Pc Game

Jul 30, 2007

hi cant i receive de direct page to downloads or upgrade de d3dx9_29.dll

View 1 Replies View Related

Creating A DB To Query Game Server

Mar 3, 2008

Im just wondering if it is possible to use a SQL DB to query game servers, Im very new to SQL, an if it is possible please lead me in the right direction on start this.

Thanks,

View 8 Replies View Related

Efficient Way To Store Game Data: Help?

Jun 22, 2007

Hello everyone!

So I am trying to wrap my head around the most efficient way to store some game data in sql server 2005.

I wont list all of my tables or columns as there would just be too many, but will try to post as exact as I can.

Basically lets say I have 3000 monsters in my game, and over 8000 items some of which are monster loot.

Each monster could have 1 drop item or they could have 200 different item drops all depending on the monster.

So I am just trying to find the best method of creating a loot table.

So I have the following in mind.

[MonsterTable]

monsterID;

monsterName;

etc...

[ItemTable]

itemID;

itemName;

etc..

[LootTable]

lootTableID;

refMonsterID;

refItemID;

So I'm not worried about how I would get all of the data in there, I'm just wondering if this simple method of using Ref. ID's between tables would provide the best method for extracting the data when needed.

Any ideas or thoughts are more then welcome, any questions just ask, and thanks for any guidance or information you can provide on a more efficient manner.

View 1 Replies View Related

Openings In An Online Game Company For Sql Coders

Jul 23, 2005

Those who is interested in computers, games can check out a freemassive online strategy scifi game at http://www.spacefederation.netThis game is also looking for staff, especially those in the computerline like programming, development, it and Internet security. to apply,goto the game and click on jobs, or click on contact to send them anemail to apply. they are always on the lookout for talented andpassionate people, if there is no such post available they will makeone for you.Cowly the Game playerVisit some of the games I playhttp://www.gamestotal.comhttp://mmorpg.gamestotal.comhttp://www.gamestotal.com/news/http://free_mmorpg.gamestotal.comhttp://strategy_games.gamestotal.comhttp://www.gamestotal.com/strategygames/http://free_strategy_games.gamestotal.com

View 1 Replies View Related