Sorry your browser is not supported!

You are using an outdated browser that does not support modern web technologies, in order to use this site please update to a new browser.

Browsers supported include Chrome, FireFox, Safari, Opera, Internet Explorer 10+ or Microsoft Edge.

DarkBASIC Professional Discussion / How do I set up mysql for a game site and access them through a IP??

Author
Message
Edson
15
Years of Service
User Offline
Joined: 21st Dec 2010
Location: Brasil
Posted: 11th Apr 2011 18:46
Link
thank you for all folks, now another question:

How do I set up mysql for a game site and access them through a IP??

My project is Phenadlax!!!
Back to top
Profile PM Email
KISTech
18
Years of Service
User Offline
Joined: 8th Feb 2008
Location: Aloha, Oregon
Posted: 11th Apr 2011 19:40
Link
Your question isn't quite clear, but if you are asking,

"How do I set up a game to access an SQL server?"

You will need to do several things.
- Pick a port to use for your game server (I currently use 4000 for testing)
- Use port forwarding on your router to forward connections to your server.
- Use one of the networking plugins to write a server application, which will serve as your SQL database application. (Never expose an SQL server directly to the internet)
- Write your game app so that it connects to your game server app and can transfer the desired data back and forth.

Back to top
Profile PM Email Website
Edson
15
Years of Service
User Offline
Joined: 21st Dec 2010
Location: Brasil
Posted: 11th Apr 2011 22:45
Link
I don't understand! The router part and the part of the door. Thank you very much.
Could you explain more detailed with good examples?
Thanks in advance!

My project is Phenadlax!!!
Back to top
Profile PM Email
KISTech
18
Years of Service
User Offline
Joined: 8th Feb 2008
Location: Aloha, Oregon
Posted: 12th Apr 2011 01:59
Link
What language do you speak?

Maybe someone who knows your native language can help us out here. There is something being lost in the translation.

Back to top
Profile PM Email Website
Edson
15
Years of Service
User Offline
Joined: 21st Dec 2010
Location: Brasil
Posted: 12th Apr 2011 16:44
Link
I am from Brazil and speak portuguese!

sorry

My project is Phenadlax!!!
Back to top
Profile PM Email
BatVink
Moderator
23
Years of Service
User Offline
Joined: 4th Apr 2003
Location: Gods own County, UK
Posted: 12th Apr 2011 17:22
Link
You could look at this thread regarding high score tables, and use the same technology to return your data

http://forum.thegamecreators.com/?m=forum_view&t=170586&b=1

Back to top
Profile PM Email
baxslash
Valued Member
Bronze Codemaster
19
Years of Service
User Offline
Joined: 26th Dec 2006
Location: Duffield
Posted: 12th Apr 2011 18:05
Link
I speak a little portuguese if you get stuck but I'd have to use babelfish to check my spelling and add hiphens in the right places

My portuguese is more conversational than technical too... for example I know all the right words for stuff like "ashtray", "beer" and "anvil" but not for the kind of stuff we discuss here on the forums

I'll try to help if I can though. Maybe it just helps to know there are people who do speak portuguese here?

Back to top
Profile PM Email
Edson
15
Years of Service
User Offline
Joined: 21st Dec 2010
Location: Brasil
Posted: 12th Apr 2011 21:16 Edited at: 12th Apr 2011 21:18
Link
ok, vamos fazer um teste então:

preciso de um tutorial completo sobre como fazer um projeto de darkbasic ficar completamente online atravez do meu site que usa o mysql!

Is a difficulty level. Isn't?

My project is Phenadlax!!!
Back to top
Profile PM Email
baxslash
Valued Member
Bronze Codemaster
19
Years of Service
User Offline
Joined: 26th Dec 2006
Location: Duffield
Posted: 13th Apr 2011 10:55 Edited at: 13th Apr 2011 10:56
Link
[English]
OK so you want a tutorial on how to set up so your game runs completely from your web site using mysql... I'm not sure if that is possible.

Does anyone else know if this is possible?
[/English]

[Portuguese]
Você gostaria de um curso em como conseguir seu jogo trabalhar completamente de seu Web site usando o mysql… Eu não sei se aquele é possível.

Qualquer um outro sabe se este é possível?
[/Portuguese]

I hope that reads OK (seems OK to me)...

EDIT: Made a slight edit to the Portuguese version.

Back to top
Profile PM Email
KISTech
18
Years of Service
User Offline
Joined: 8th Feb 2008
Location: Aloha, Oregon
Posted: 13th Apr 2011 19:23
Link
It sounds more like he wants to run the game from the web browser. While there have been attempts at this, I haven't really seen anything that achieves it in the same manner as say, Unity3D or Flash. DBPro was never designed for this.

My first response outlines how DBPro can achieve the same thing, but if the requirement is to have it run through the web server service then that makes it a bit more complicated.

For that he would have to write a web server app to handle all the SQL data transfer to the client app, and make it secure so hackers don't get to the database.

Back to top
Profile PM Email Website
Edson
15
Years of Service
User Offline
Joined: 21st Dec 2010
Location: Brasil
Posted: 15th Apr 2011 12:52
Link
ok all right!

My project is Phenadlax!!!
Back to top
Profile PM Email
Back to top

Login to post a reply

Server time is: 2026-07-18 06:41:15
Your offset time is: 2026-07-18 06:41:15