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 / Write to online database

Author
Message
CumQuaT
AGK Master
16
Years of Service
User Offline
Joined: 28th Apr 2010
Location: Tasmania, Australia
Posted: 14th Oct 2012 08:23
Link
Does anyone have any experience with any sort of online registration code? Say if I only wanted registered users to be able to run my game, and only allow each user to have one instance of the game running at any given time, how would I do that from within DBP?

Any ideas would be great!


Back to top
Profile PM Email
GreenDixy
17
Years of Service
User Offline
Joined: 24th Jul 2008
Location: Toronto
Posted: 14th Oct 2012 13:44
Link
there is a couple options use multisync plugin to make a client and server registration or use mysql plugin its on the rofurms someware

======================================
My software never has bugs. It just develops random features.
Back to top
Profile PM Email
CumQuaT
AGK Master
16
Years of Service
User Offline
Joined: 28th Apr 2010
Location: Tasmania, Australia
Posted: 14th Oct 2012 14:32
Link
Oooh, that sounds perfect. I'll take a look around! Thanks GreenDixy!


Back to top
Profile PM Email
MrValentine
AGK Backer
15
Years of Service
User Offline
Joined: 5th Dec 2010
Playing: FFVII
Posted: 15th Oct 2012 03:37
Link
Umm set up a MySQL database and use PHP to communicate with it...

NEVER DIRECTLY LINK TO A WEB DATABASE FROM WITHIN AN APPLICATION

I plan to create a project which allows users to utilise a web database and provide the DBP code with a single PHP page to process all the transactions...

I hope to get this completed before the end of the year... [Sorting out SSL related things first... not a cheap endeavour]

Back to top
Profile PM
Dar13
18
Years of Service
User Offline
Joined: 12th May 2008
Location: Microsoft VisualStudio 2010 Professional
Posted: 15th Oct 2012 03:52
Link
Quote: "NEVER DIRECTLY LINK TO A WEB DATABASE FROM WITHIN AN APPLICATION"

Why? The library I use allows the use of parameterized queries, is that acceptable?

Follow WTLD's progress on Twitter
Git repository for WasTeLanD
Back to top
Profile PM Email
MrValentine
AGK Backer
15
Years of Service
User Offline
Joined: 5th Dec 2010
Playing: FFVII
Posted: 15th Oct 2012 04:10
Link
Is your login information submitted by the application?

Is so, then this login information is traceable via the end users local network... unless you are using some form of secure connection... like SSL...

Back to top
Profile PM
Dar13
18
Years of Service
User Offline
Joined: 12th May 2008
Location: Microsoft VisualStudio 2010 Professional
Posted: 15th Oct 2012 05:42
Link
Ah, I see your point MrValentine. I'll get on implementing SSL log-in right away.

Follow WTLD's progress on Twitter
Git repository for WasTeLanD
Back to top
Profile PM Email
CumQuaT
AGK Master
16
Years of Service
User Offline
Joined: 28th Apr 2010
Location: Tasmania, Australia
Posted: 15th Oct 2012 06:35
Link
Good tip.


Back to top
Profile PM Email
GreenDixy
17
Years of Service
User Offline
Joined: 24th Jul 2008
Location: Toronto
Posted: 15th Oct 2012 06:41
Link
i have my setup like this

client sends info to server then my server sends that to my database that way nothing is passed from the client its self

======================================
My software never has bugs. It just develops random features.
Back to top
Profile PM Email
CumQuaT
AGK Master
16
Years of Service
User Offline
Joined: 28th Apr 2010
Location: Tasmania, Australia
Posted: 15th Oct 2012 07:41
Link
I am useless at PHP, so I'm gonna have to do quite a bit of reading, it seems...


Back to top
Profile PM Email
MrValentine
AGK Backer
15
Years of Service
User Offline
Joined: 5th Dec 2010
Playing: FFVII
Posted: 15th Oct 2012 07:57
Link
I wrote somewhere earlier that I have plans for a solution for everyone on here looking for a database solution with PHP and DBP code... I am having a hard time with the DBP code... but hopefully someone can suss that bit out... but I reckon an SSL certificate will fix the issue... [just cost issues holding me back... they are not cheap...]

PHP is not overly complicated really...

Grab the basics over at http://w3schools.com/php/default.asp I have some decent books but most of what you need should be there...

If you require hosting, just ask anytime

Back to top
Profile PM
CumQuaT
AGK Master
16
Years of Service
User Offline
Joined: 28th Apr 2010
Location: Tasmania, Australia
Posted: 15th Oct 2012 08:29
Link
I've got the hosting all sorted, but thanks for the offer! And thank you for the link! That should help out greatly!


Back to top
Profile PM Email
MrValentine
AGK Backer
15
Years of Service
User Offline
Joined: 5th Dec 2010
Playing: FFVII
Posted: 15th Oct 2012 20:08 Edited at: 15th Oct 2012 20:08
Link
Glad I could help

Back to top
Profile PM
Back to top

Login to post a reply

Server time is: 2026-07-07 21:31:54
Your offset time is: 2026-07-07 21:31:54