Posted By
|
Message
|
Knockturnal Nothing to see here turn back
Registered 11/04/2008
Points 354
|
20th May, 2009 at 17:50:13 -
So I have set up a sql database, and I have made a form in my app. Now what I want is when I press login it checks with the sql table if the login is correct. If it is, then it should load character position, skills and inventory. If it isn't echo no. If you register you just enter username and password to create a blank slot in the sql. It must offcourse also save progress. Any idea how to do this?? I think it's fully possible I just don't know how.
tl;dr:
Need login help in app using sql
Professional vaporware developer
|
Cecilectomy noPE
Registered 19/03/2005
Points 305
|
20th May, 2009 at 20:59:40 -
as of right now there is not way to access a MySQL database directly from within mmf. you have to use an extension that can access web pages like .asp and .php (i recommend using .php) and indirectly access the database through scripts.
the most common extension to access anything and all network based is moo api (mooclick, moogame, moosock). once oinc comes out and it fully supports stuff like this you would use that.
ok so using moosock from the moo api you would ask for a webpage which basically returns all the html. you would then use richtextobject to receive and store all the html. then use string parser to parse through the html to get any important and usuable data/information from it, like the login status, player stats, ranking, etc.
here are some great tutorials on online highscore tables and moosock to get you going. if you dont know php then thats where youre gonna have trouble.
http://www.create-games.com/article.asp?id=1405 - by Flava
http://www.create-games.com/article.asp?id=1439 - by Tigerworks
http://clickteam.com/eng/resources/online_score/onlinescoreboards.html - by David Newton
now i found that none of these are substantial on their own. meaning none of them worked in mmf2 as standalone tutorials. you'll notice that i said use "richtextobject" previously yet most of these will tell you to use a "edit object". i found that this doesn't work for some reason. also the method used in flava's and David's tuts to request a page are outdated. what i did to get things working was combine flava's and david's tutorials with the methods described in tigerworks' http tutorial using moosock to request web pages along with the richtextobject instead of edit object.
good luck.
Edited by Cecilectomy
n/a
|
Knockturnal Nothing to see here turn back
Registered 11/04/2008
Points 354
|
20th May, 2009 at 23:06:51 -
That sounds great! Now I know some http but I'm as green as can be to php so I guess i'll start there. Then again MMF doesn't really seem suited for online capabilities. I was wondering if I should use Adobe Flash or C# instead? Anyone have any experience on those platforms who can tell me which is better for mmo's? And yes for gods sake I'm willing to learn. EVEN C#.
Professional vaporware developer
|
Cecilectomy noPE
Registered 19/03/2005
Points 305
|
20th May, 2009 at 23:14:46 -
i have no experience in flash so i dont know what its capabilities are for online connectability.
in C#, unless youre going to be developing with XNA, getting online capabilities without using "Games For Windows Live" is going to be probably more than you can handle, especially if you have no experience with the actual programming language. direct x, and the new windows OS's like Vista and 7 do not support directplay anymore. so get ready to learn some complicated api's like winsock2.
i started on some scalable netcode in c++ and it took me about a month to get it working properly.
using mmf extensions is about as simple as its gonna get. so i would start learning php
http://w3schools.com/php/default.asp
Edited by Cecilectomy
n/a
|
Knockturnal Nothing to see here turn back
Registered 11/04/2008
Points 354
|
21st May, 2009 at 10:27:02 -
Ok thanks. I'm gonna learn C# sometime soon but not now then. Um... php goddamn I have no time for that right now but I'll get to it. Thanks!
Professional vaporware developer
|
X_Sheep I had a custom rating before it was cool
Registered 01/03/2004
Points 1313
|
21st May, 2009 at 10:47:47 -
The Live Receiver Object should be able to communicate with PHP files.
http://ext.neatwares.ath.cx/ext/Live_Receiver
a/n
|
|
|