Database/ Databank

Code junkies hangout here

Moderators: ChrisThornett, LXF moderators

RE: Database/ Databank

Postby A-Wing » Tue Aug 02, 2005 4:38 pm

if it is open source why not use something like postgres or similar, or use parts of the code. Or you could base it on a type of XML.
Andrew Hutchings, Linux Jedi
http://www.a-wing.co.uk
User avatar
A-Wing
LXF regular
 
Posts: 460
Joined: Tue Jul 05, 2005 7:25 pm
Location: Wellingborough

RE: Database/ Databank

Postby Nigel » Tue Aug 02, 2005 4:51 pm

Hudzilla did a series on writing interactive RPG games in his PHP tutorials - see LXF issues 57 through 62. He used PHP and MySQL.
Hope this helps,

Nigel.
User avatar
Nigel
LXF regular
 
Posts: 1141
Joined: Fri Apr 08, 2005 8:03 pm
Location: Gloucestershire, UK

RE: Database/ Databank

Postby A-Wing » Tue Aug 02, 2005 4:52 pm

To explain it would be writing a book on databases.
Andrew Hutchings, Linux Jedi
http://www.a-wing.co.uk
User avatar
A-Wing
LXF regular
 
Posts: 460
Joined: Tue Jul 05, 2005 7:25 pm
Location: Wellingborough

RE: Database/ Databank

Postby grogoreo » Tue Aug 02, 2005 4:57 pm

hi

I think I've played an MMORPG game, called Kings of Caos but am not into them. What programming language are you using? If all you need to do is get data into the database, then you could firstly use MySQL (i know A-Wing has said use Postres but I've never used it), and have a query (a message sent to the database asking for certain rows and columns) for specific data such as usernames, points/credits etc. Then have another one for putting in data, so lets say 'Jim' attacked 'Benny' with 5000 attack points then this data could be automatically put into the database after Benny was attacked. So 5000 could be taken away from his life credits by just having a query seeing how many points he has there then deducting 5000 and altering the current life credits.

You basically have a database with tables in them. If you think of a table as a spreadsheet with rows and columns and the query is selecting the rows and/or columns that you have told the database to search for.

Sorry if I'm talking about a completely different game, but this is sort of what you could do. I'm not an expert but still a learner. Once you get the idea of queries and databases it gets quite easy and from your 'team of codes', they should be able to get into the SQL syntax.

Hope this helps,
Greg
grogoreo
 
Posts: 11
Joined: Tue Apr 12, 2005 6:46 pm
Location: www.grogoreo.co.uk


Return to Programming

Who is online

Users browsing this forum: No registered users and 0 guests

cron