Netplay Plus Master Thread

[Xilef]

How do I find out the ip address of the MySQL host?
I see absolutely no useful instructions on how to set this up with freemysql or what to put in the config or anything of use. We're not all as amazing as you silent alarm, you cant say: Well, it's obvious what goes in the config, because it really isn't obvious at all.

Host = "What the hell goes here?" *

Port = 50000

ServerName = "Netplay Plus Server"
ServerVersion = "3.0"
GameCode = "918302475" <--What is this? *

WebServer = "where do i find this?" *
SMTPServer = "What the hell is this?" *
AdminEmail = "Do we just put our e-mail, such as hotmail etc?" *

DB_server = "localhost"
DB_user = "is this our freemysql username?" *
DB_password ="is this our freemysql password?" *
DB_name = "how do I make a database?" *

Message = "Entering the Official Netplay Plus Server..."

I have MySQL Turbo Manager, anyone know how do I use this?

If I ever get this working (Which I doubt because I see no help being given from anyone) I bet there'll be loads of things to clear up first like in NP+1, what are they? Again, I see absolutely no instructions.
This was carried out very poorly. You can't expect all RMXP users to understand MySQL. >:|

 

[Ellie]

Your host usually should tell you, mine has it everywhere. It's not the IP address but the address.

Like mine was mysql5.freepgs.com.

There were many useful tutorials but lost when the forums were lost.

If I ever get this working (Which I doubt because I see no help being given from anyone) I bet there'll be loads of things to clear up first like in NP+1, what are they? Again, I see absolutely no instructions.
This was carried out very poorly. You can't expect all RMXP users to understand MySQL. >

Yes because of course, everything here has to be perfect. After all, they're doing it for free, it's our right for them to do everything for us! [/sarcasm]



=====

Well, if it's in C# I'm pretty sure it'll only work for PC, because C# is a .Net language which is a microsoft language. As for 1.0, no it was not in C#, it was written in C++ I believe, just the application for it, and the function files were written in Lua. This Ruby server is a complete re-write by the developers of Netplay Plus, the one in 1.0 was originally written for Multi-Netplay I believe by a guy named SuicideManic. That C++ application one is not open source, so you cannot edit it.

Shizzlerific.

 

[Icechamp11200]

ok everything works except when i try to make an account i get this erorr
its definetly a problem with the code because i set everything right in allthe settings

Field 'login_dat' doesn't have a default value

below is part of code that has the value

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO users (id, login, password, email, reg_dat, validation) VALUES ('', %s, MD5(%s), %s, UNIX_TIMESTAMP(), 0);",
                       GetSQLValueString($_POST['login'], "text"),
                       GetSQLValueString($_POST['password'], "text"),
                       GetSQLValueString($_POST['email'], "text"));

edit= and also what do i have to edit so my players dont have to validate?

 

[d3ad connection]

How do I find out the ip address of the MySQL host?
I see absolutely no useful instructions on how to set this up with freemysql or what to put in the config or anything of use. We're not all as amazing as you silent alarm, you cant say: Well, it's obvious what goes in the config, because it really isn't obvious at all.

This was carried out very poorly. You can't expect all RMXP users to understand MySQL. >:|

I have to agree. I don't know anything about SQL, and I can't find any help from Google... Someone could at least post how to set up the database.

 

[Icedmetal57]

If you're using freemysql, which I'm sure most of you aren't using your own mysql server being hosted right from your computer, so I'll just assume you guys use freemysql. The IP address, MySQL, or Database Host (they're all the same thing) would be whatever it said in the activation email. If you lost that email, just login to your account on freemysql and it'll say Your Host: ... The Database User is your user name on that site, and password is the same situation as the user name. Database name, now that involves creating one.

1. To create a database, login to your freemysql.net account, then in the control panel add a database by entering a name in the Add Database form such as netplay_plus_db or whatever you can remember it by, and for then in the second form put in your username.

2. Time to add some data. Go to PHPMyAdmin on freemysql.net, and login with your freemysql account info, same user and password. If you can't find the link to PHPMyAdmin on the side navigation bar, then just enter your mysql host into the address bar and it'll take you there. After you've logged into PHPMyAdmin, on the side there will be a navigation bar, just click the name of your newly created database. After that, there's a form that's something about Create a new Table in your database. Ignore that. On the navigation bar above that Create a new Table in your database, click SQL. On that page, there should be 2 forms, one being Run SQL query/queries..., then next being Location of the Text File. Click Browse..., and find your Netplay Plus server directory, where ever you extracted the server, and in that folder go to Library, then in that folder there should be a text file called sqlfile. Open that. This should be all done within the web browser in PHPMyAdmin, by the way. After that, click Go on the SQL page. It'll then bring you to a new page that shows the entire contents of that sqlfile, and on the navigation bar to the left you should see a bunch of new items in the list, which are all the tables, which contain all the data for the server, tables are like sub-categories within the database to contain certain data.


Now to answer Xilef's question about these things.

GameCode = "918302475" This is like a little password type thing that allows the server to only receive data from clients with this gamecode, which helps protect against hacking

WebServer = "where do i find this?" The website you use for your game *
SMTPServer = "What the hell is this?" *
AdminEmail = "Do we just put our e-mail, such as hotmail etc?"  Yes

* Not necessary

And for Icechamp's question, here's the solution. You may have to scroll a bit, depending on how you're web browser is. Anyway, there's the problem you're having. That 0 as shown in red here, should be a 1 for it to automatically validate the registrants. You'll have to manually validate those users already registered by changing that 0 to a 1 in the database in the users table.

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO users (id, login, password, email, reg_dat, validation) VALUES ('', %s, MD5(%s), %s, UNIX_TIMESTAMP(), [color=red]0[/color]);",
                       GetSQLValueString($_POST['login'], "text"),
                       GetSQLValueString($_POST['password'], "text"),
                       GetSQLValueString($_POST['email'], "text"));

Well, I hope that I helped most of you guys and cleared up a few questions as well.

 

[holloway]

Gamecode on the client MUST match the gamecode of your server or you will be kicked every time.

 

[d3ad connection]

Icedmetal57, thank you so much! I was able to set up the server very quickly and easily, and now I got Netplay working.

 

[holloway]

Icedmetal57's guide linked in first post. Thanks man.

 

[Icedmetal57]

No problem guys, it only took a few minutes out of my own life to help you guys, but hey, not everyone can figure things out on their own. I guess I'm just gifted that way.

 

[kozmonaut]

I Have a Quick Little prob, How do you set up so new users can join? On the most recent 2.0 version when you boot up the server (i set it up) and the mysql DB(its working fine) I can login with your test test login, but there is no flag or button to create a new user, or account, what do i do pleasE?

 

[S S Muu]

Well, if it's in C# I'm pretty sure it'll only work for PC, because C# is a .Net language which is a microsoft language. As for 1.0, no it was not in C#, it was written in C++ I believe, just the application for it, and the function files were written in Lua. This Ruby server is a complete re-write by the developers of Netplay Plus, the one in 1.0 was originally written for Multi-Netplay I believe by a guy named SuicideManic. That C++ application one is not open source, so you cannot edit it.

well whats wrong whit the ruby server? (2.0)

 

[kozmonaut]

Also. I really like the new interactable mouse script you guys made. Is it possible to incorporate this script into netplay pre 2.0? I use 1.0 and the jump between 1.0 and 2.0 is large, i dont want to graviate my entire game in the 2.0 direction right now, mainly because 90% of my existing combat, cocas message system and more dont really work without a huge rewrite for all the new 2.0 classes. So yeah, interacticable mouse script, possible to use as a stand alone with other dependencies?

 

[holloway]

No it isn't. The whole system was rewritten.

 

[kozmonaut]

I've noticed, do you guys got forums again? I'd like to talk about what it takes to get the guilds working, mos new ABAS and some other things.

 

[Tdata]

Is there a reason that the server drops the table data everytime it starts?

 

[holloway]

It does? Hmm...Well it's a .rb file right? I never noticed it did but it'd be possible to edit I'd assume and just remove the "DROP" SQL command.

 

[Icechamp11200]

ok but i still get the errorr message

Field 'login_dat' doesn't have a default value

 

[d3ad connection]

Any clue on how to add multiple character sprites? I tried adding a text box which has the filename to the create character window, and having it send the info in the box through the Network.create_character line. That didn't work and caused the game and server to crash.

 

[holloway]

I'm afraid not. But isn't that what different characters are for?

 

[ya200]

Ok i read and re-read your instructions about 20 times and i have the mysql thing down thats all setup so is the server settings but i cant figure out how to setup a website so that people can actuley make acounts@_@ (i do have a website:D) and i cant figure out how to put the server online or even use for my local machine please help

*i no my spelling and grammer is bad