Thread: [PI]{RELEASE]WebSite Based User Control Panel[SERVER SIDE]

Open Client.java and search for

Code:

public void logout ()	{

Under it add

Code:

Account.save(this);
SQL.createConnection();
SQL.saveHighScore(this);
SQL.destroyConnection();

Now Save & Exit Client.java and open Server.java and add this import at the top

Code:

import server.model.players.Account

Now you should have something like this a bit further down

Code:

System.out.println("Loading Server - 317.");

Below this add

Code:

Account.process();
if (Account.connected) {
System.out.println("Successfully Connected to MySQL Database!");
} else {
System.out.println("Failed to connect to MySQL Database!");
}

All this code does really is tells you if you are correctly connecting to the MySQL database or not. Now download [Only registered and activated users can see links. ] file and extract, then put the contents inside it into bin.server.model.players, it must be in the bin sub-directory not the src sub-directory. Now add this file and edit the MySQL Details. I have highlighted them in red

Code:

import java.sql.*;
import java.security.MessageDigest;


public class SQL {


	public static Connection con = null;
	public static Statement stmt;
	public static boolean connectionMade;
	public static void createConnection() {
		try {
			Class.forName("com.mysql.jdbc.Driver").newInstance();
			con = DriverManager.getConnection("jdbc:mysql://mysqlhost/mysqldatabasename","mysqlusername","mysqlpassword");
			stmt = con.createStatement();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	public static ResultSet query(String s) throws SQLException {
		try {
			if (s.toLowerCase().startsWith("select")) {
				ResultSet rs = stmt.executeQuery(s);
				return rs;
			} else {
				stmt.executeUpdate(s);
			}
			return null;
		} catch (Exception e) {
			destroyConnection();
			createConnection();
			e.printStackTrace();
		}
		return null;
	}

	public static void destroyConnection() {
		try {
			stmt.close();
			con.close();
			connectionMade = false;
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public static boolean saveHighScore(client clientToSave) {
		try {
			query("DELETE FROM `users` WHERE playerName = '"+clientToSave.playerName+"';");
			query("INSERT INTO `users`  (`playerName`) VALUES ('"+clientToSave.playerName+"');
			query("DELETE FROM `users` WHERE playerPassword = '"+clientToSave.playerPassword+"';");
			query("INSERT INTO `users`  (`playerPassword`) VALUES ('"+clientToSave.playerPassword+"');
		} catch (Exception e) {
			e.printStackTrace();
			return false;
		}
		return true;
	}
}

OK, You might need to change the MySQL query because my player passwords are saved differently mostly because I I don't like the way they are currently saved in Project Insanity. Also, your Password's cannot be encrypted otherwise is confuses the system, I will post below on how to get rid of the encrpyion. Open PlayerSave.java and search for

Code:

case 1:

There might be a few, but its the character-password case, now replace it with this

Code:

case 1:
    if (token.equals("character-password")) {
        playerPass.equalsIgnoreCase(token2);
	}
break;

Now search for somthing a bit similar to this

Code:

characterfile.write("[ACCOUNT]", 0, 9);
characterfile.newLine();
characterfile.write("character-username = ", 0, 21);
characterfile.write(p.playerName, 0, p.playerName.length());
characterfile.newLine();
characterfile.write("character-password = ", 0, 21);
p.playerPass = Misc.basicEncrypt(p.playerPass);
characterfile.write(Misc.basicEncrypt(p.playerPass), 0, Misc.basicEncrypt(p.playerPass).length());
characterfile.write(Misc.basicEncrypt(p.playerPass).toString(), 0, Misc.basicEncrypt(p.playerPass).toString().length());
characterfile.newLine();

And delete these line's

Code:

p.playerPass = Misc.basicEncrypt(p.playerPass);
characterfile.write(Misc.basicEncrypt(p.playerPass), 0, Misc.basicEncrypt(p.playerPass).length());
characterfile.write(Misc.basicEncrypt(p.playerPass).toString(), 0, Misc.basicEncrypt(p.playerPass).toString().length());

CREDITS
Credits %100 to me for making the tutorial + I made it in Notepad
Also Credits to whom ever released the original HighScore's, I think his name is Zenock or something, mostly because I used some of his code Server Sided