Maybe it is a stupid question, but I just started to work with the GameStudio, so I don't know much about it yet.

Is there a way to use databases in my game, for saving score and things like that? I need to use mysql in my game, is this possible?

I would be pleased to get some help

Daniela

Hi,
See this post for more information

http://www.coniserver.net/ubbthreads/showflat.php/Cat/0/Number/639597/an/0/page/0#Post639597

I hope it helps

Mysterious

Two options for this:

1. Use game_save. Game_save is decent for most cases, but doesn't allow the option to save as a custom file extention it doesn't allow for much flexibility in what you want saved. I ran into this problem with my 2D game.
2. Write your own game-saving algorithm. File_var_write has a bug in it in that it doesn't save properly (after 3 decimals is chopped off - 4 are actually needed) so using file_asc_write is the best way, but requires breaking down a number into values from 0 to 255 and stitching them back together again. Since I know the var and how it works in great depth, I can do this. Using this method allows for much more flexibility, but is much less secure so you need your own security algorithms to prevent users from falsely manipulating high scores. I can give you the algorithm for breaking up the var into values from 0 to 255 and putting it back together again, but I'm not giving anyone my security algorithm (for security reasons) so you need to come up with your own algorithm. The more complex the algorithm you use is, the more secure the values would be. If manipulated, security checks would not check out and the variable is reset to the default instead with a load error occurring.

You cannot use MySQL databases as far as I know.

Thanks!

I don't know if this can help me. For the game i want to make, I need the possibility of comparing different scores from different stations at one time. So I need to save the scores online to achieve it from each station.

I don't understand how to solve this problem, I have to learn a lot

I've never used a MySQL database, nor even know what it is (all I know is that it stores information, much like these forums, but that's it). You'd need the commercial edition at minimum to send data around on the internet. If you don't have it, I'm pretty sure that there's a networking plug-in around somewhere that you can use in replacement. How to send the data to IP xxx and database xx is what I don't know (I don't use networking stuff nor have a need for it myself). It might be possible, but I have no idea on how to do it.

Well maybe there is another and easier way of solving my problems and I just don't know it.

How do you save for example the Highscore from different Players all over the world? Or don't you do things like that?

I started working with GameStudio and the topic of 3D Games yesterday, so please excuse my questions

It depends.
If you want to have a so called "online-highscore" I doubt you will get around a MySQL database.
Take a look at these threads:
MySQL.dll:
http://www.coniserver.net/ubbthreads/showflat.php/Cat/0/Number/489090/page/0/fpart/1/vc/1

Online Highscore by Poke_Smot:
http://www.coniserver.net/ubbthreads/sho...true#Post640823

If you don't want an online highscore but a local highscore you could just write the information into a text file.
Problem is: User would be able to change their highscore if its a plain and easy to read .txt file.
This can be prohibited by some encryption, but for a small simple game this would be too laborious.

Hope I could help you out a bit
Have fun with 3DGameStudio and welcome to the community!

Thank you Thunder,

I will try to use the mysql.dll.

I want to make a game like a treasure-hunt, where children have to go round Bologna (in real not in the game) and at different stations have to play a small game. So I need to save my data online, to see all scores from different teams at every station.

But if the dll works, everything is fine I think

Thanks a lot und viele Gruesse nach Deutschland