Server Website Register?

Legoboy0215 · May 4, 2015

Hello, I need some help with my server website.
1. A website to ONLY register accounts. (I have a website, but I do not know how to play with the MySQL stuff from SimpleAuth.
2. Manage all the accounts. (Again, the MySQL and phpmyadmin stuff.)
I know I can use html forms and send it to a php file to process, but I do not know how to write in php! Also, I think I also need to access the SimpleAuth MySQL database. How do I do that?
Thanks for the help!

Lambo · May 4, 2015

This seems like a pretty complicated project. I would recommend to learn PHP or (probably best) hire a developer.

Legoboy0215 · May 4, 2015

Ok, then how can set my own MySQL database for SimpleAuth?

Andrey Nazarchuk · May 5, 2015

Legoboy0215 said: ↑

Ok, then how can set my own MySQL database for SimpleAuth?
Click to expand...

https://forums.pocketmine.net/threads/simpleauth.225/page-16

DALTONTASTIC · May 5, 2015

I can help you out with logins, but when it comes to registrations I never integrated that directly on my site. I find that only allowing registrations in-game cuts down on spam.

Anyhow you are going to make a file called session.php (This will need to be included on every page you want people to be logged into to see)

PHP:

<?php // Establishing Connection with Server by passing server_name, user_id and password as a parameter $connection = mysql_connect("host", "user", "password"); // Selecting Database $db = mysql_select_db("database", $connection); session_start();// Starting Session // Storing Session $user_check=$_SESSION['login_user']; // SQL Query To Fetch Complete Information Of User $ses_sql=mysql_query("select name from tablename where name='$user_check'", $connection); $row = mysql_fetch_assoc($ses_sql); $login_session =$row['name']; if(!isset($login_session)){ mysql_close($connection); // Closing Connection header('Location: login.php'); // Redirecting To Home Page } ?>

Then you are going to create a file called authenticate.php (This handles the logins)

PHP:

<?php session_start(); // Starting Session $error=''; // Variable To Store Error Message if (isset($_POST['submit'])) { if (empty($_POST['username']) || empty($_POST['password'])) { $error = "UNABLE TO PROCESS YOUR REQUEST. CHECK YOUR PASSWORD."; } else { // Define $username and $password $username=$_POST['username']; $password=$_POST['password']; // Establishing Connection with Server by passing server_name, user_id and password as a parameter $connection = mysql_connect("host", "user", "password"); // To protect MySQL injection for Security purpose $username = stripslashes($username); $password = stripslashes($password); $username = mysql_real_escape_string($username); $password = mysql_real_escape_string($password); // Selecting Database $db = mysql_select_db("database", $connection); function hashME($player, $password) { return bin2hex(hash("sha512", $password . strtolower($player), true) ^ hash("whirlpool", strtolower($player) . $password, true)); } $password1 = hashME($username, $password); // SQL query to fetch information of registerd users and finds user match. $query = mysql_query("select * from tablename where hash='$password1' AND name='$username'", $connection); $rows = mysql_num_rows($query); if ($rows == 1) { $_SESSION['login_user']=$username; // Initializing Session header("location: account.php"); // Redirecting To Other Page } else { $error = "UNABLE TO PROCESS YOUR REQUEST. CHECK YOUR PASSWORD."; } mysql_close($connection); // Closing Connection } } ?>

Okay here's the fun part! This is the login page! I named mine login.php
HTML:
<?php
   include('authenticate.php');

   if(isset($_SESSION['login_user'])){
   header("location: page-to-redirect-to-after-logging-in.php");
   }
   ?>
<head>
   <title>LOGIN</title>
   <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css">
</head>
<body>
   <div class="col-md-6">
      <h3>LOGIN</h3>
      <form action="" id="material" method="post">
         <?php
            if(empty($error)){
            }
            else {
            echo '<div class="alert alert-danger">';
            echo $error;
            echo '</div>';
            }
            ?>
         <div class="group">
            <input id="name" type="text" name="username" placeholder="USERNAME" autocomplete="off">
            <input id="password" type="password" name="password" placeholder="PASSWORD">
         </div>
         <center><input name="submit" type="submit" value="LOGIN" class="load-more"></a></center>
   </div>
   </form>
   </div>
   </div>
   <div class="col-md-6">
      <h3>THIS IS A BOOTSTRAP TEMPLATE</h3>
      <div id="material">
         <h2>SOOOOO</h2>
         WRITE SOMETHING INFORMATIVE HERE.
         <BR>
      </div>
   </div>
   <BR>
   <BR>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/js/bootstrap.min.js">
</body>
</html>
If you tried you could probably tweak this into a functioning registration page, but here's a good start.

Andrey Nazarchuk · May 5, 2015

DALTONTASTIC said: ↑
I can help you out with logins, but when it comes to registrations I never integrated that directly on my site. I find that only allowing registrations in-game cuts down on spam.

Anyhow you are going to make a file called session.php (This will need to be included on every page you want people to be logged into to see)

PHP:

<?php // Establishing Connection with Server by passing server_name, user_id and password as a parameter $connection = mysql_connect("host", "user", "password"); // Selecting Database $db = mysql_select_db("database", $connection); session_start();// Starting Session // Storing Session $user_check=$_SESSION['login_user']; // SQL Query To Fetch Complete Information Of User $ses_sql=mysql_query("select name from engine where name='$user_check'", $connection); $row = mysql_fetch_assoc($ses_sql); $login_session =$row['name']; if(!isset($login_session)){ mysql_close($connection); // Closing Connection header('Location: login.php'); // Redirecting To Home Page } ?>

Then you are going to create a file called authenticate.php (This handles the logins)

PHP:

<?php session_start(); // Starting Session $error=''; // Variable To Store Error Message if (isset($_POST['submit'])) { if (empty($_POST['username']) || empty($_POST['password'])) { $error = "UNABLE TO PROCESS YOUR REQUEST. CHECK YOUR PASSWORD."; } else { // Define $username and $password $username=$_POST['username']; $password=$_POST['password']; // Establishing Connection with Server by passing server_name, user_id and password as a parameter $connection = mysql_connect("host", "user", "password"); // To protect MySQL injection for Security purpose $username = stripslashes($username); $password = stripslashes($password); $username = mysql_real_escape_string($username); $password = mysql_real_escape_string($password); // Selecting Database $db = mysql_select_db("database", $connection); function hashME($player, $password) { return bin2hex(hash("sha512", $password . strtolower($player), true) ^ hash("whirlpool", strtolower($player) . $password, true)); } $password1 = hashME($username, $password); // SQL query to fetch information of registerd users and finds user match. $query = mysql_query("select * from engine where hash='$password1' AND name='$username'", $connection); $rows = mysql_num_rows($query); if ($rows == 1) { $_SESSION['login_user']=$username; // Initializing Session header("location: account.php"); // Redirecting To Other Page } else { $error = "UNABLE TO PROCESS YOUR REQUEST. CHECK YOUR PASSWORD."; } mysql_close($connection); // Closing Connection } } ?>

Okay here's the fun part! This is the login page! I named mine login.php
HTML:
<?php
   include('authenticate.php');

   if(isset($_SESSION['login_user'])){
   header("location: page-to-redirect-to-after-logging-in.php");
   }
   ?>
<head>
   <title>LOGIN</title>
   <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css">
</head>
<body>
   <div class="col-md-6">
      <h3>LOGIN</h3>
      <form action="" id="material" method="post">
         <?php
            if(empty($error)){
            }
            else {
            echo '<div class="alert alert-danger">';
            echo $error;
            echo '</div>';
            }
            ?>
         <div class="group">
            <input id="name" type="text" name="username" placeholder="USERNAME" autocomplete="off">
            <input id="password" type="password" name="password" placeholder="PASSWORD">
         </div>
         <center><input name="submit" type="submit" value="LOGIN" class="load-more"></a></center>
   </div>
   </form>
   </div>
   </div>
   <div class="col-md-6">
      <h3>THIS IS A BOOTSTRAP TEMPLATE</h3>
      <div id="material">
         <h2>SOOOOO</h2>
         WRITE SOMETHING INFORMATIVE HERE.
         <BR>
      </div>
   </div>
   <BR>
   <BR>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/js/bootstrap.min.js">
</body>
</html>
If you tried you could probably tweak this into a functioning registration page, but here's a good start.
Click to expand...
How do you get a MySQL server to connect to SimpleAuth, I cant get it to work
Please Help!

DALTONTASTIC · May 5, 2015

Do you currently have a MySQL instance running? This is my config.yml I've used for SimpleAuth in the past. Just interchange the values.

Code:

dataProvider: mysql

#For MySQL:
dataProviderSettings:
host: "IP"
port: 3306
user: "user"
password: "password"
database: "database"

#dataProviderSettings: []

#If enabled, existing logged-in accounts won't be kicked if a new player joins with the same name
forceSingleSession: true

#Sets the minimum amount of characters to be used when registering a new account
minPasswordLength: 8

#If enabled, accounts that are using the same IP when logging in again will be automatically authenticated
authenticateByLastIP: false

#If enabled, will set all the permissions for simleauth.command.register to false
disableRegister: false

#If enabled, will set all the permissions for simleauth.command.login to false
disableLogin: false

#Number of seconds to wait for a player to be authenticated. If false, disables the timeout
#TODO
authenticateTimeout: 120

Andrey Nazarchuk · May 5, 2015

If you look on page 16 of the SimpleAuth thread, I have tried many things, can I pm you the login credentials so you can set it up?

DALTONTASTIC · May 5, 2015

Andrey Nazarchuk said: ↑

If you look on page 16 of the SimpleAuth thread, I have tried many things, can I pm you the login credentials so you can set it up?
Click to expand...

Hm I guess so. Keep in mind that by default MySQL doesn't allow external connections.

Andrey Nazarchuk · May 5, 2015

I went into the my.cnf, (it looked different then the first time, which almost worked but I deleted it) and allowed connecting from everything and it still did not work.

Andrey Nazarchuk · May 5, 2015

Alright, I will make a quick server and send you the credentials, OK?

Lambo · May 5, 2015

Stop going off topic. If you need help with a different subject, create a new thread.

Lambo · May 5, 2015

DALTONTASTIC said: ↑
I can help you out with logins, but when it comes to registrations I never integrated that directly on my site. I find that only allowing registrations in-game cuts down on spam.

Anyhow you are going to make a file called session.php (This will need to be included on every page you want people to be logged into to see)

PHP:

<?php // Establishing Connection with Server by passing server_name, user_id and password as a parameter $connection = mysql_connect("host", "user", "password"); // Selecting Database $db = mysql_select_db("database", $connection); session_start();// Starting Session // Storing Session $user_check=$_SESSION['login_user']; // SQL Query To Fetch Complete Information Of User $ses_sql=mysql_query("select name from tablename where name='$user_check'", $connection); $row = mysql_fetch_assoc($ses_sql); $login_session =$row['name']; if(!isset($login_session)){ mysql_close($connection); // Closing Connection header('Location: login.php'); // Redirecting To Home Page } ?>

Then you are going to create a file called authenticate.php (This handles the logins)

PHP:

<?php session_start(); // Starting Session $error=''; // Variable To Store Error Message if (isset($_POST['submit'])) { if (empty($_POST['username']) || empty($_POST['password'])) { $error = "UNABLE TO PROCESS YOUR REQUEST. CHECK YOUR PASSWORD."; } else { // Define $username and $password $username=$_POST['username']; $password=$_POST['password']; // Establishing Connection with Server by passing server_name, user_id and password as a parameter $connection = mysql_connect("host", "user", "password"); // To protect MySQL injection for Security purpose $username = stripslashes($username); $password = stripslashes($password); $username = mysql_real_escape_string($username); $password = mysql_real_escape_string($password); // Selecting Database $db = mysql_select_db("database", $connection); function hashME($player, $password) { return bin2hex(hash("sha512", $password . strtolower($player), true) ^ hash("whirlpool", strtolower($player) . $password, true)); } $password1 = hashME($username, $password); // SQL query to fetch information of registerd users and finds user match. $query = mysql_query("select * from tablename where hash='$password1' AND name='$username'", $connection); $rows = mysql_num_rows($query); if ($rows == 1) { $_SESSION['login_user']=$username; // Initializing Session header("location: account.php"); // Redirecting To Other Page } else { $error = "UNABLE TO PROCESS YOUR REQUEST. CHECK YOUR PASSWORD."; } mysql_close($connection); // Closing Connection } } ?>

Okay here's the fun part! This is the login page! I named mine login.php
HTML:
<?php
   include('authenticate.php');

   if(isset($_SESSION['login_user'])){
   header("location: page-to-redirect-to-after-logging-in.php");
   }
   ?>
<head>
   <title>LOGIN</title>
   <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css">
</head>
<body>
   <div class="col-md-6">
      <h3>LOGIN</h3>
      <form action="" id="material" method="post">
         <?php
            if(empty($error)){
            }
            else {
            echo '<div class="alert alert-danger">';
            echo $error;
            echo '</div>';
            }
            ?>
         <div class="group">
            <input id="name" type="text" name="username" placeholder="USERNAME" autocomplete="off">
            <input id="password" type="password" name="password" placeholder="PASSWORD">
         </div>
         <center><input name="submit" type="submit" value="LOGIN" class="load-more"></a></center>
   </div>
   </form>
   </div>
   </div>
   <div class="col-md-6">
      <h3>THIS IS A BOOTSTRAP TEMPLATE</h3>
      <div id="material">
         <h2>SOOOOO</h2>
         WRITE SOMETHING INFORMATIVE HERE.
         <BR>
      </div>
   </div>
   <BR>
   <BR>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/js/bootstrap.min.js">
</body>
</html>
If you tried you could probably tweak this into a functioning registration page, but here's a good start.
Click to expand...
You should try using MySQLi, it has a lot of new useful features like an object-oriented interface, support for prepared statements etc.

Andrey Nazarchuk · May 5, 2015

Sorry

Legoboy0215 · May 5, 2015

DALTONTASTIC said: ↑
I can help you out with logins, but when it comes to registrations I never integrated that directly on my site. I find that only allowing registrations in-game cuts down on spam.

Anyhow you are going to make a file called session.php (This will need to be included on every page you want people to be logged into to see)

PHP:

<?php // Establishing Connection with Server by passing server_name, user_id and password as a parameter $connection = mysql_connect("host", "user", "password"); // Selecting Database $db = mysql_select_db("database", $connection); session_start();// Starting Session // Storing Session $user_check=$_SESSION['login_user']; // SQL Query To Fetch Complete Information Of User $ses_sql=mysql_query("select name from tablename where name='$user_check'", $connection); $row = mysql_fetch_assoc($ses_sql); $login_session =$row['name']; if(!isset($login_session)){ mysql_close($connection); // Closing Connection header('Location: login.php'); // Redirecting To Home Page } ?>

Then you are going to create a file called authenticate.php (This handles the logins)

PHP:

<?php session_start(); // Starting Session $error=''; // Variable To Store Error Message if (isset($_POST['submit'])) { if (empty($_POST['username']) || empty($_POST['password'])) { $error = "UNABLE TO PROCESS YOUR REQUEST. CHECK YOUR PASSWORD."; } else { // Define $username and $password $username=$_POST['username']; $password=$_POST['password']; // Establishing Connection with Server by passing server_name, user_id and password as a parameter $connection = mysql_connect("host", "user", "password"); // To protect MySQL injection for Security purpose $username = stripslashes($username); $password = stripslashes($password); $username = mysql_real_escape_string($username); $password = mysql_real_escape_string($password); // Selecting Database $db = mysql_select_db("database", $connection); function hashME($player, $password) { return bin2hex(hash("sha512", $password . strtolower($player), true) ^ hash("whirlpool", strtolower($player) . $password, true)); } $password1 = hashME($username, $password); // SQL query to fetch information of registerd users and finds user match. $query = mysql_query("select * from tablename where hash='$password1' AND name='$username'", $connection); $rows = mysql_num_rows($query); if ($rows == 1) { $_SESSION['login_user']=$username; // Initializing Session header("location: account.php"); // Redirecting To Other Page } else { $error = "UNABLE TO PROCESS YOUR REQUEST. CHECK YOUR PASSWORD."; } mysql_close($connection); // Closing Connection } } ?>

Okay here's the fun part! This is the login page! I named mine login.php
HTML:
<?php
   include('authenticate.php');

   if(isset($_SESSION['login_user'])){
   header("location: page-to-redirect-to-after-logging-in.php");
   }
   ?>
<head>
   <title>LOGIN</title>
   <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css">
</head>
<body>
   <div class="col-md-6">
      <h3>LOGIN</h3>
      <form action="" id="material" method="post">
         <?php
            if(empty($error)){
            }
            else {
            echo '<div class="alert alert-danger">';
            echo $error;
            echo '</div>';
            }
            ?>
         <div class="group">
            <input id="name" type="text" name="username" placeholder="USERNAME" autocomplete="off">
            <input id="password" type="password" name="password" placeholder="PASSWORD">
         </div>
         <center><input name="submit" type="submit" value="LOGIN" class="load-more"></a></center>
   </div>
   </form>
   </div>
   </div>
   <div class="col-md-6">
      <h3>THIS IS A BOOTSTRAP TEMPLATE</h3>
      <div id="material">
         <h2>SOOOOO</h2>
         WRITE SOMETHING INFORMATIVE HERE.
         <BR>
      </div>
   </div>
   <BR>
   <BR>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/js/bootstrap.min.js">
</body>
</html>
If you tried you could probably tweak this into a functioning registration page, but here's a good start.
Click to expand...
Ok Thanks! I will try it so if there are any problems I will ask you via PM

PEMapModder · May 5, 2015

In addition (since this is in the Plugin Development forum), I would like to point out that the mysql extension doesn't (necessarily) exist in PocketMine-distributed PHP binaries.

Legoboy0215 · May 5, 2015

DALTONTASTIC said: ↑
I can help you out with logins, but when it comes to registrations I never integrated that directly on my site. I find that only allowing registrations in-game cuts down on spam.

Anyhow you are going to make a file called session.php (This will need to be included on every page you want people to be logged into to see)

PHP:

<?php // Establishing Connection with Server by passing server_name, user_id and password as a parameter $connection = mysql_connect("host", "user", "password"); // Selecting Database $db = mysql_select_db("database", $connection); session_start();// Starting Session // Storing Session $user_check=$_SESSION['login_user']; // SQL Query To Fetch Complete Information Of User $ses_sql=mysql_query("select name from tablename where name='$user_check'", $connection); $row = mysql_fetch_assoc($ses_sql); $login_session =$row['name']; if(!isset($login_session)){ mysql_close($connection); // Closing Connection header('Location: login.php'); // Redirecting To Home Page } ?>

Then you are going to create a file called authenticate.php (This handles the logins)

PHP:

<?php session_start(); // Starting Session $error=''; // Variable To Store Error Message if (isset($_POST['submit'])) { if (empty($_POST['username']) || empty($_POST['password'])) { $error = "UNABLE TO PROCESS YOUR REQUEST. CHECK YOUR PASSWORD."; } else { // Define $username and $password $username=$_POST['username']; $password=$_POST['password']; // Establishing Connection with Server by passing server_name, user_id and password as a parameter $connection = mysql_connect("host", "user", "password"); // To protect MySQL injection for Security purpose $username = stripslashes($username); $password = stripslashes($password); $username = mysql_real_escape_string($username); $password = mysql_real_escape_string($password); // Selecting Database $db = mysql_select_db("database", $connection); function hashME($player, $password) { return bin2hex(hash("sha512", $password . strtolower($player), true) ^ hash("whirlpool", strtolower($player) . $password, true)); } $password1 = hashME($username, $password); // SQL query to fetch information of registerd users and finds user match. $query = mysql_query("select * from tablename where hash='$password1' AND name='$username'", $connection); $rows = mysql_num_rows($query); if ($rows == 1) { $_SESSION['login_user']=$username; // Initializing Session header("location: account.php"); // Redirecting To Other Page } else { $error = "UNABLE TO PROCESS YOUR REQUEST. CHECK YOUR PASSWORD."; } mysql_close($connection); // Closing Connection } } ?>

Okay here's the fun part! This is the login page! I named mine login.php
HTML:
<?php
   include('authenticate.php');

   if(isset($_SESSION['login_user'])){
   header("location: page-to-redirect-to-after-logging-in.php");
   }
   ?>
<head>
   <title>LOGIN</title>
   <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css">
</head>
<body>
   <div class="col-md-6">
      <h3>LOGIN</h3>
      <form action="" id="material" method="post">
         <?php
            if(empty($error)){
            }
            else {
            echo '<div class="alert alert-danger">';
            echo $error;
            echo '</div>';
            }
            ?>
         <div class="group">
            <input id="name" type="text" name="username" placeholder="USERNAME" autocomplete="off">
            <input id="password" type="password" name="password" placeholder="PASSWORD">
         </div>
         <center><input name="submit" type="submit" value="LOGIN" class="load-more"></a></center>
   </div>
   </form>
   </div>
   </div>
   <div class="col-md-6">
      <h3>THIS IS A BOOTSTRAP TEMPLATE</h3>
      <div id="material">
         <h2>SOOOOO</h2>
         WRITE SOMETHING INFORMATIVE HERE.
         <BR>
      </div>
   </div>
   <BR>
   <BR>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/js/bootstrap.min.js">
</body>
</html>
If you tried you could probably tweak this into a functioning registration page, but here's a good start.
Click to expand...
Umm.... Do I need to set the MySQL database?

Log in or Sign up

Plugins

Server Website Register?

Legoboy0215 Notable Member

Lambo Notable Member Plugin Developer

Legoboy0215 Notable Member

Andrey Nazarchuk Active Member

DALTONTASTIC New Member

Andrey Nazarchuk Active Member

DALTONTASTIC New Member

Andrey Nazarchuk Active Member

DALTONTASTIC New Member

Andrey Nazarchuk Active Member

Andrey Nazarchuk Active Member

Lambo Notable Member Plugin Developer

Lambo Notable Member Plugin Developer

Andrey Nazarchuk Active Member

Legoboy0215 Notable Member

PEMapModder Notable Member Plugin Developer

Legoboy0215 Notable Member

Share This Page

Log in or Sign up

Useful Searches

Server Website Register?

Legoboy0215 Notable Member

Lambo Notable Member Plugin Developer

Legoboy0215 Notable Member

Andrey Nazarchuk Active Member

DALTONTASTIC New Member

Andrey Nazarchuk Active Member

DALTONTASTIC New Member

Andrey Nazarchuk Active Member

DALTONTASTIC New Member

Andrey Nazarchuk Active Member

Andrey Nazarchuk Active Member

Lambo Notable Member Plugin Developer

Lambo Notable Member Plugin Developer

Andrey Nazarchuk Active Member

Legoboy0215 Notable Member

PEMapModder Notable Member Plugin Developer

Legoboy0215 Notable Member

Share This Page