Gamestudio Links
Zorro Links
Newest Posts
Help with plotting multiple ZigZag
by degenerate_762. 04/30/24 23:23
M1 Oversampling
by 11honza11. 04/30/24 08:16
Trading Journey
by howardR. 04/28/24 09:55
Zorro Trader GPT
by TipmyPip. 04/27/24 13:50
AUM Magazine
Latest Screens
The Bible Game
A psychological thriller game
SHADOW (2014)
DEAD TASTE
Who's Online Now
3 registered members (vicknick, 7th_zorro, 1 invisible), 890 guests, and 2 spiders.
Key: Admin, Global Mod, Mod
Newest Members
firatv, wandaluciaia, Mega_Rod, EternallyCurious, howardR
19050 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
connecting to mysql database #148021
08/15/07 12:29
08/15/07 12:29
Joined: Jun 2007
Posts: 28
D
Doriel Offline OP
Newbie
Doriel  Offline OP
Newbie
D

Joined: Jun 2007
Posts: 28
Hello,

I don't think this is the right place for this post but since i'm not sure where else to post it, please accept my apologies.

Ok. So what I need to do is be able to connect my game to a database (preferrably one that is free, such as mysql). I want to keep statistics for each user, such as how many games they played, what their game statistics were, how many times they failed, etc. I want them to be able to log into a website (that also connects to the same database) and be able to view these statistics. Administrators would also be able to track the users' progress, being able to consult with them about certain statistics. (it's a nursing training game). Now, I am very familiar with how to create database tables, stored procedures, SQL, etc. However, I am a novice when it comes to Game Studio.

So my questions are as follows:

In Game Studio...

1. How do I open and close a connection to the database? How do I set the connection string?

2. How do I run my update, insert, and select statements? Are there datasets and data reader classes that I can use?

3. Are there any tutorials/examples I can look at?


I took a look at the manual and didn't find anything helpful. Any ideas?



Thanks in advance,

Doriel

Re: connecting to mysql database [Re: Doriel] #148022
08/15/07 19:52
08/15/07 19:52
Joined: Aug 2003
Posts: 7,439
Red Dwarf
Michael_Schwarz Offline
Senior Expert
Michael_Schwarz  Offline
Senior Expert

Joined: Aug 2003
Posts: 7,439
Red Dwarf
1/2/3. Look in user contributions for a mysql dll from "destop"(no, not desktop)


"Sometimes JCL reminds me of Notch, but more competent" ~ Kiyaku
Re: connecting to mysql database [Re: Michael_Schwarz] #148023
08/16/07 19:39
08/16/07 19:39
Joined: Aug 2003
Posts: 63
UK
ptrc1c Offline
Junior Member
ptrc1c  Offline
Junior Member

Joined: Aug 2003
Posts: 63
UK
Hi Doriel heres the link.
http://www.coniserver.net/ubbthreads/showflat.php/Cat/0/Number/489090/page/0/fpart/2/vc/1
I have just downloaded MySQL and have it working, now I am going to try the A6 code. It seems to be what you are looking for


Gamestudio download | chip programmers | Zorro platform | shop | Data Protection Policy

oP group Germany GmbH | Birkenstr. 25-27 | 63549 Ronneburg / Germany | info (at) opgroup.de

Powered by UBB.threads™ PHP Forum Software 7.7.1