Wednesday, July 6, 2011

SmartFoxServer Tutorial: How to Make a Virtual World / MMO - Part 2 (1): Logging Into the Game From a Database


The SQL coding is in the video description on YouTube (as well as the source code), so in case you don't want to go to YouTube to get the SQL code, here it is:

CREATE TABLE MMOUSERS(ID INT AUTO_INCREMENT PRIMARY KEY, USERNAME VARCHAR(20) NOT NULL UNIQUE, PASSWORD VARCHAR(255) NOT NULL, EMAIL VARCHAR(60) NOT NULL DEFAULT '', COINS VARCHAR(9000) NOT NULL DEFAULT '5000', INVENTORYLIST VARCHAR(9000) NOT NULL DEFAULT '', SAVEDITEMS VARCHAR(9000) NOT NULL DEFAULT '', ITEMSON VARCHAR(9000) NOT NULL DEFAULT '', ISBANNED VARCHAR(3) NOT NULL DEFAULT 'No', WARNINGS VARCHAR(4) NOT NULL DEFAULT '0', ISMODERATOR VARCHAR(3) NOT NULL DEFAULT 'No');

8 comments:

  1. You should put all of this in a .zip files. To make it easier for your fans.

    ReplyDelete
  2. @Drake: They actually have already been put into a zipped folder so everyone can download the source code. Go here to view this video's source code: http://www.youtube.com/watch?v=7xVOn--CUfY&feature=player_embedded

    ReplyDelete
  3. Hi
    You are the king of how you can do everything when you keep this manual?

    PS
    Sorry for my English I'm from Israel

    ReplyDelete
    Replies
    1. Thank you!
      Please read the update to the newest post! Specify SFS2X or SFS1X!

      Delete
  4. Hey are there more tutorials comming?

    ReplyDelete
    Replies
    1. Please read the update to the newest post! Specify SFS2X or SFS1X!

      Delete
  5. Replies
    1. Please read the update to the newest post! Specify SFS2X or SFS1X!

      Delete