Server Help

[corvey]

I need to know which database method is prefered for my module. Would it be MYSQL, or ASSS builtin database? I need to store and retrieve hundreds of planets data for players to access and manipulate. I would prefer this be all on the server side to avoid potential cheating.

Which database would be easier to implement PLANETS, INVENTORY, PLAYERS, SHIPS, etc..

My guess is MySQL, and I will have to read up on it. How hard would it be to integrate this into ASSS for what I need?

I would also need to make an external program to be able to access planet data so that the statistics can be updated by a defined hour. Population will have to grow you know

[Mine GO BOOM]

[corvey]

[k0zy]

I'd go with MySQL.
If you're planing on having web stats later this will probably be the easyiest way.

You could also look at PostgreSQL which has a better implementation of stored procedures, triggers and transactions.
It's not something you might want to use now, but it's a fine thing to look into if you plan on doing more database related stuff later on.
_________________
It's a shark! Oh my god! Unbelievable!

[corvey]

I already have ASSS and MySQL talking, but it doesn't have much of a GUI interface to help, yes, MySQL Administrator GUI tool is installed and it isn't much help either, it's just kinda THERE, not much to do with it, and ASSS installed it's own stuff in there to get itself going. I don't know much about MySQL, but I would like to learn a little bit to get me going.


Any suggestions on how to receive from and send to MySQL database through a homemade module for ASSS?? Please be specific and detailed.

[Doc Flabby]

GUI for mysql http://www.heidisql.com/
_________________
Rediscover online gaming. Get Subspace | STF The future...prehaps

[steigerwald]

try phpmyadmin

[Cyan~Fire]

I'd take a real client over phpMyAdmin any day.
_________________
This help is informational only. No representation is made or warranty given as to its content. User assumes all risk of use. Cyan~Fire assumes no responsibility for any loss or delay resulting from such use.
Wise men STILL seek Him.

[k0zy]

There's an official MySQL gui.

http://www.mysql.com/products/tools/administrator/
http://dev.mysql.com/downloads/gui-tools/5.0.html

[BDwinsAlt]

I would also suggest MySQL. A few basic commands is all you really need to know for it anyways. I didn't know there was a GUI for it besides phpMyAdmin.

[Dr Brain]

The fact that there's already a mysql module makes it a no-brainer.
_________________
Hyperspace Owner

Smong> so long as 99% deaths feel lame it will always be hyperspace to me

[Animate Dreams]

Yeah, if you're going to use mysql, you probably shouldn't bother with a GUI at all. Since your program is going to have to access everything, you'll have to know how to do it manually anyway. It might be nice to play around and experiment with, but when it comes down to making the actual module, you'll have to do it all through commands, so it's probably best just to do it that way. Maybe a GUI would help you tell if you were doing it right a bit easier, though. I'm not sure, I don't really know anything about databases yet. >_>

[BDwinsAlt]

Here are some sample commands you can try out.

If your on windows go into the start menu> programs> mysql*> and click on the admin thing.

If your on linux you can just type: mysql -p dataBaseName
then just type in the password for it.

After you get the prompt "mysql>" then go ahead and try these commands.

Code: Show/Hide SHOW databases; USE database_name;   // [E.X.: Use asss] SHOW tables; SELECT * FROM table_name; // Notice there will be an output of everything in that table or it will say it is empty. //  Now find the names that come up with a list of data under it. SELECT what_you_found FROM table_name; SELECT * FROM table_name WHERE what_you_found = 'something'; // It will return empty or show you everything about that area.

Code: Show/Hide // Here is an example mysql> show databases; +--------------------+ | Database           | +--------------------+ | information_schema | | TCPBiller          | | asss               | | auth               | | members            | | mysql              | | php                | | tcpbiller          | +--------------------+ 8 rows in set (0.00 sec) mysql> use auth Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; +----------------+ | Tables_in_auth | +----------------+ | user           | +----------------+ 1 row in set (0.00 sec) mysql> SELECT * FROM user; +-----------+----------------------------------+ | name      | pass                             | +-----------+----------------------------------+ | brad      | 958636f23559f431b8bd2e605fdbc2f5 | | wkbmarine | 323a57bff1764b0e680478bdb006682a | +-----------+----------------------------------+ 2 rows in set (0.02 sec) mysql> SELECT name  FROM user; +-----------+ | name      | +-----------+ | brad      | | wkbmarine | +-----------+ 2 rows in set (0.00 sec) mysql> SELECT * FROM user where name = 'brad'; +------+----------------------------------+ | name | pass                             | +------+----------------------------------+ | brad | 958636f23559f431b8bd2e605fdbc2f5 | +------+----------------------------------+ 1 row in set (0.00 sec) mysql> SELECT * FROM user where name = 'bra33d'; Empty set (0.00 sec)

If you can understand how this work then you can easily update/add rows. Just google it.

[Muskrat]

Ugh I HATE MySQL and Normalization! Taking Database Theory and Practice was probably the worst mistake of my life...

[corvey]

[Dr Brain]

Uh, have you looked at the built in one I talked about in my post? Database:mysql?

[corvey]

[Mine GO BOOM]

[corvey]

ok, I'm sorry for sounding or looking ignorant to you. MySQL.C is not what I'm talking about. Please allow me to rephrase the question for the correct answer.

Does anyone have a game module coded in C for the ASSS server that uses MYSQL for it's database so that I may see for an example how they implement it into their code?

[BDwinsAlt]

Have you tried Alias.c (located in the same folder as mysql.c)?
That is a great example of how asss uses mysql.

[corvey]

[CypherJF]

I didn't really read above but the best MySQL client I've found yet to date is SQLYog (it's free / community edition). Windows only, I believe.
_________________
Performance is often the art of cheating carefully. - James Gosling