Scratch

Does this have anything to do with the Advanced part of Scratch or does this section reach beyond that now?

I think this may be better for MaC.

sccar3 wrote:

Is this going to be more like Runescape of Syrnia?

I've never seen Syrnai before, but from what I can tell of google images, no. 14th Century will focus on trade mainly, the idea for the game is similar to Europe 1400, but it will include many more features and put more focus on the office and ranks system.

(sorry for the double post)

Last edited by JackERY (2012-07-30 00:52:57)

Cold you login to our webhost account and familiarise yourself with the control panel interface and how the files for 14th century will be set out. The username/password as well as a link to the login page can be found HERE. Make sure you login to your account on our forums first though or you won't be able to see the thread.

JackERY wrote:

Cold you login to our webhost account and familiarise yourself with the control panel interface and how the files for 14th century will be set out. The username/password as well as a link to the login page can be found HERE. Make sure you login to your account on our forums first though or you won't be able to see the thread.

I have used cPanel before, so that should be fine.

I have been looking at PmA, and I just realised there wont be enough databases to run the game. The forum has taken up all of the required databases.

Last edited by Zeusking19 (2012-08-02 13:01:57)

bobbybee wrote:

Zeusking19 wrote:

JackERY wrote:

Cold you login to our webhost account and familiarise yourself with the control panel interface and how the files for 14th century will be set out. The username/password as well as a link to the login page can be found HERE. Make sure you login to your account on our forums first though or you won't be able to see the thread.

I have used cPanel before, so that should be fine.

I have been looking at PmA, and I just realised there wont be enough databases to run the game. The forum has taken up all of the required databases.

Set up the database to use a prefix, so you can add game stuff prefixed in the database as well. (forum_users, forum_posts, mmo_users, mmo_livechats)

Let me check to see if the forum was setup with prefixes.

I dont understand why the forum would need a community and a main database. Jack, please correct me if I am wrong.

Last edited by Zeusking19 (2012-08-03 04:06:15)

JackERY wrote:

Zeusking19 wrote:

I dont understand why the forum would need a community and a main database. Jack, please correct me if I am wrong.

The community database is for any community related things, like the forums or a highscores table. The main database is for the game.

That makes more sense. Thanks for letting me know 

Any work for me to do?

JackERY wrote:

Zeusking19 wrote:

Any work for me to do?

Could you try and make a function that retrieves data from the SQL database. The function would have to have 3 variables: the table, a field and a value. It would also have to return results as an array.

Just working on it.

That's not what I wanted, sorry for being too vague. Basically what we need is a function that gets the information from a database and then stores it in an array. The code I was thinking of looked something like this;

include("sql.class");
class loadsql {
   public function loadSQL($db,$field,$data) {
      $sql = new sql();
      $sql -> config();
      $fetchedData[] = array()      
      $i = 0;

      $result = mysql_query("SELECT * FROM $db WHERE $field = $data");
      while($row = mysql_fetch_array($result)) {
         $fetchedData[$i][$field] = $row[$field]
         $i=+1;
      }
   }
}

I'm not sure if that code works because I've not tested it, but when the I call the function it should return the results as a 2 dimensional array which can then be used very easily. For example loadsql("users","name","jack") would return the following:

$fetchedData[0][id] = 0
$fetchedData[0][name] = jack
$fetchedData[0][pass] = password

Last edited by JackERY (2012-08-04 07:35:44)

Most of the SQL code needed should be relatively simple; I can only think of 3 statements that we will ever have to use: SELECT, WHERE an SET. If you ever can't do any of the coding to go with the sql (things like functions, classes and arrays), just leave a note in a comment and I'll add them.

I forgot to say thank you for writing than code, so thanks. Also, if you're writing some code for the project, could you upload it to the "dev" folder in the Cpanel so it can be viewed and edited online.

kk. Thanks 

Apologies for the inactivity of the project, I should be able to start working on the game again tomorrow and I'll try to update the forums and possible this thread before then.

Also, I've been playing around with some Javascript libraries that enable 3d models to be displayed on a webpage and I think it would be quite a nice addition to the website. I am capable of doing all of the scripting, but my 3d modeling skills leave a lot to be desired. If anyone is moderately skilled with 3ds Max and willing to help please post on this thread.

Firedrake969 wrote:

May I help?  I know HTML and JS.

Of course, welcome aboard 

Hopefully within 3 or 4 months, maybe sooner depending on any problems we encounter with the code along the way.

---

Bump