The Daily Click ::. Forums ::. Klik Coding Help ::. Login System
 

Post Reply  Post Oekaki 
 

Posted By Message

Knockturnal

Nothing to see here turn back

Registered
  11/04/2008
Points
  352

VIP Member
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

Has Donated, Thank You!VIP MemberWeekly Picture Me This Winner!Cardboard BoxGhostbuster!Pokemon Ball!ComputerBox RedSanta HatSnowman
I am an April Fool
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
  352

VIP Member
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

Has Donated, Thank You!VIP MemberWeekly Picture Me This Winner!Cardboard BoxGhostbuster!Pokemon Ball!ComputerBox RedSanta HatSnowman
I am an April Fool
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
  352

VIP Member
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

VIP MemberPicture Me This -Round 23- Winner!Dos Rules!
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
   

Post Reply



 



Advertisement

Worth A Click