473,573 Members | 2,946 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Can someone please create some MySQL to create the first table: the players table.

This is not for a class, I have a group on SourceForge, this is what
one of the Developers is asking; the more advanced you can make it
right off all the better!:
Can someone please create some MySQL to create the first table: the
players table.

It will need to include (as a minimum):
- ID (unique)
- Name
- Health / HP
- LastSeen (integer or date?)

Perhaps it's a good idea to keep things minimal for now. I'd just like
to see how fast something like this small task will get done :)
Please email me at mlauzon (AT) gmail DOT com
Jul 20 '05 #1
3 2023
Michael Lauzon wrote:
This is not for a class, I have a group on SourceForge, this is what
one of the Developers is asking; the more advanced you can make it
right off all the better!:
You mean this project?
http://sourceforge.net/projects/lamyle/
Can someone please create some MySQL to create the first table: the
players table.

It will need to include (as a minimum):
- ID (unique)
- Name
- Health / HP
- LastSeen (integer or date?)


create table player(
id int unsigned primary key auto_increment,
name varchar(255),
health int,
last_seen datetime
);

But are you seriously doing a php+mysql game, without any knowledge in sql?
Jul 20 '05 #2
Aggro <sp**********@y ahoo.com> wrote in message news:<QR******* *****@read3.ine t.fi>...
Michael Lauzon wrote:
This is not for a class, I have a group on SourceForge, this is what
one of the Developers is asking; the more advanced you can make it
right off all the better!:
You mean this project?
http://sourceforge.net/projects/lamyle/


How did you know that?


But are you seriously doing a php+mysql game, without any knowledge in sql?


Yes, I've posted on numerous places looking for MySQL Developers.

I am better at leading, because I cannot program.
Jul 20 '05 #3
Michael Lauzon wrote:
How did you know that?
I searched people from sourceforge with the name Michael Lauzon, which
you are using here in the newsgroups. I found two persons with that name
and there was only one project which looked like a game.

I didn't mean to spy on you, but if I'm helping someone, I will check
their story before doing so ;)
Yes, I've posted on numerous places looking for MySQL Developers.
The project seemed to have something like 10 developers. Doesn't anyone
of them know SQL? Or are the developers in idle-state?

You can actually design and implement a large project with only 1
database programmer. You do it so that you have one or many
database-related php files where you do all the queries and then you
just return the results as arrays and take the required search
parameters as arrays also. This is also recommended, logical and clean
way to do it.

But if you are looking for developers, why did you ask for SQL-code? It
is no use for you unless you also know how to insert data, how to run
queries, how to update and delete data.
I am better at leading, because I cannot program.


I hope I don't sound mean, but from my experience, if you don't know how
to program, you won't be very good leading programmers. People who can't
program can however write specifications for the project. In that they
are usually pretty good, but again not as good as programmers.

Let's use you as an example. From your first post:

"Perhaps it's a good idea to keep things minimal for now. I'd just like
to see how fast something like this small task will get done"

This is wrong approach. If you design a database, you should try to have
all required things there at the very beginning. The more you have to
modify it later, the more job you will need to do in total, and the more
complex the database will propably get. Also, if you have the database
design ready, you can design the database-related functions. And when
you have the functions designed, the coders can start working on the
applications.

So if you are able, try to design all required tables and all required
columns for those tables. Also try to deside what type the columns
should be.

For example if you they are text, should they have 10 characters, 255
characters or unlimited amount of characters. If you are using numbers,
deside should numbers be always >= 0 or do you need negative numbers
also. (For example I set the health to be int, assuming that player can
be also dead, when health could be -1 to indicate this).

And if using numbers, what range of numbers should be used? 32-bit
unsigned integer can only be a number between 0 - 4294967295, so if you
need for example larger amounts of health to be saved, you will need to
use 64-bit integers, or save the health in two columns, or save it as
text (which doesn't sound like a smart idea except in some special cases).

If you have somekind of database design, there are all the table names,
columns with names and types. Creating the database is very trivial task
and takes only something like 10 minutes (assuming the types are already
in format the database understands). Even if the format is something
like (text, 20 characters / number between 10 to 20), it won't take very
long to create the database from that.

But the catch is.. If you are not experienced database designer, you
will propably do a poor design. I had lately a database design at work,
made by non-programmers. There was originally 2 tables. Now there is
something like 12 tables. Also some columns in original table has bee
transferred into different table, some columns are added into original
tables etc.

But the poor design is usually a good start. It gives the experieced
programmer a good start and idea what information the system should
hold. So doing the "bad design" is a lot better idea rather than not
doing it.
Jul 20 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
3934
by: Boefje | last post by:
Hello, I need to get all records from a table where a for a given playerid no field enddate exists with value NULL. table player_team: id, playerid, startdate, enddate 1, 277, 2003-09-14 00:00:00, NULL
5
3482
by: duikboot | last post by:
Hi all, I'm trying to export a view tables from a Oracle database to a Mysql database. I create insert statements (they look alright), but it all goes wrong when I try to execute them in Mysql, because the dates must have quotes on each side. I just don't know how make the dates right. Well I'll just show you the code and some insert...
0
1487
by: Mike Chirico | last post by:
Hopefully this will help someone... Helpful Things to Know about MySQL Mike Chirico (mchirico@users.sourceforge.net) Last Updated: Fri Apr 16 11:47:34 EDT 2004 The latest version of this document can be found at: http://prdownloads.sourceforge.net/souptonuts/README_mysql.txt?download Format is better on the above link. I'm looking for...
1
3182
by: Gregory.Spencer | last post by:
Hi there, Using PHPMyAdmin and it is very usefully reporting problems with my MySQL DB. "PRIMARY and INDEX keys should not both be set for column `column_name`" and
1
9610
by: David Van D | last post by:
Hi there, A few weeks until I begin my journey towards a degree in Computer Science at Canterbury University in New Zealand, Anyway the course tutors are going to be teaching us JAVA wth bluej and I was wondering if anyone here would be able to give me some tips for young players such as myself, for learning the language. Is this the...
6
1489
by: ojorus | last post by:
Hi! My company make several flash-based games, and I use php to communicate with mysql to provide highscore-lists. My problem is this: When I save a player's score in the mysql-table, I want to find which place the player got with his score (today). To get this I have tried two different solutions, which both works, but are very...
3
2375
by: Choronzon | last post by:
what kind of PHP operation am i looking for when i am trying to do something like this: I have a player table, and a location table. Each player is unique, each location is unique, therefore having an auto_increment(id and lid) field in each table to give each player and location a unique identifier. Each location can be associated with a...
1
3038
by: bull.titan | last post by:
Hi all, i'd like to start writing an MMORPG in PHP/MySQL (like www.world-of-dungeons.com) but i wonder something simple : how to i manage to create and allocate items ? (armour, axes etc..) i mean, i think : one item = one database entry (in an item table, with many fields for each item, such as name, desc, name of dungeon where it...
2
4357
by: djnokturnal | last post by:
Hey guys / gals, First time posting and of course I am sure it is something that has been answered 100 times but for some reason I just cant find the answer :) First off here is the structure of the xml: <Stats> <Structure> <Column DisplayName="GP" FieldName="GamesPlayed" Priority="1" /> <Column DisplayName="G"...
0
7780
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
8021
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8202
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7787
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8065
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6419
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5291
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3732
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
2213
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.