The Daily Click ::. Forums ::. Klik Coding Help ::. Sqldb?
 

Post Reply  Post Oekaki 
 

Posted By Message

Knockturnal

Nothing to see here turn back

Registered
  11/04/2008
Points
  354

VIP Member
8th June, 2008 at 15:12:35 -

How do you use the sqldb extention? Is it possible to make a... like an online game where profiles is saved to it and then retrieved from mysql using this object? I'm noob at mysql please help

 
Professional vaporware developer

axel

Crazy?

Registered
  05/02/2005
Points
  4766

Game of the Week WinnerYou've Been Circy'd!
8th June, 2008 at 18:45:21 -

It requires some knowledge of the SQL language and how SQL databases work. It's a fairly simple language though, and there's plenty of tutorials on the net (Google is your friend on this one).

There are alternatives though, if it sounds too complicated. The MooClick and MooGame extensions let you create server-side INIs that you can use to store player profiles and data, but it's not nearly as secure as using a proper SQL database.

Image Edited by the Author.

 
n/a

Knockturnal

Nothing to see here turn back

Registered
  11/04/2008
Points
  354

VIP Member
9th June, 2008 at 01:46:40 -

Well what do you do to get the object itself to work?
Thank you for answer. ^^

 
Professional vaporware developer

axel

Crazy?

Registered
  05/02/2005
Points
  4766

Game of the Week WinnerYou've Been Circy'd!
9th June, 2008 at 07:55:01 -


Originally Posted by Zatek
Well what do you do to get the object itself to work?
Thank you for answer. ^^



Download the object, and put sql.mfx in your /extensions/ and in your /data/runtime/ directory.

 
n/a

Knockturnal

Nothing to see here turn back

Registered
  11/04/2008
Points
  354

VIP Member
9th June, 2008 at 10:09:30 -

Well i kind of knew that... The REAL problem is that i dont understand what it can do... It has only "open file" and weird stuff like that.

 
Professional vaporware developer

Aptennap



Registered
  23/04/2004
Points
  916
9th June, 2008 at 10:23:50 -

Yes JonWoG please finish it!!

 
Oh sweet mary.

axel

Crazy?

Registered
  05/02/2005
Points
  4766

Game of the Week WinnerYou've Been Circy'd!
9th June, 2008 at 11:23:00 -


Originally Posted by Zatek
Well i kind of knew that... The REAL problem is that i dont understand what it can do... It has only "open file" and weird stuff like that.



It uses SQLite, which is a database system where all tables and data are stored in a file on a host computer (a server). I haven't actually used the SQLdb extension, but this is how I think it works: The "open file" command lets you specify a database file to use. Then, to get or to manipulate database data, you use the "run SQL" function to send SQL commands to the host. But for that, you naturally need to learn the SQL language first.

 
n/a

Knockturnal

Nothing to see here turn back

Registered
  11/04/2008
Points
  354

VIP Member
9th June, 2008 at 13:34:47 -

Can someone tell me how to make a much simpler thing then; A game that isn't online, but you can download anywhere and enter username/password and then get your 1p account for that game? Like having one score for money, and one for progress and one for difficulity? Even that would be awsome! Hope someone will help.

 
Professional vaporware developer
   

Post Reply



 



Advertisement

Worth A Click