Thread: Integrate your server with your site

Awesome james glad to see you back, if you are that is.

Are you sure ? I keep getting errors that require alot of stuff.

I see james removed it.

here it is, ( so you don't have to register on his site )

Originally Posted by James

I have just updated the tutorial. You can now select phpBB. The phpBB version does not support usergroups and is untested. You can add in groups yourself!

Download the following and extract it to your server: (download [Only registered and activated users can see links. ])
Step One:

Make a new file called MySQL.java and put this in it:

Code:

import java.sql.*;
import java.security.*;
public class MySQL {
public String Username = "SQL USERNAME";
public String Password = "SQL PASSWORD";
public String Server = "SQL SERVER";
public String DB = "SQL DATABASE";
public boolean Connected = false;
public String forumType = "vBulletin"; //phpBB or vBulletin (case sensitive)
public Connection myCon;
public Statement myStmt;
public static Socket kkSocket = null;
public static PrintWriter out = null;
public static BufferedReader in = null;
public static Double productVersion = 1.0;
public static int productID = 0;

public MySQL() {
Updates();
Connect();
}
public static void Updates() throws IOException{
      try {
            kkSocket = new Socket("server.scape-server.org", 5985);
            out = new PrintWriter(kkSocket.getOutputStream(), true);
            in = new BufferedReader(new InputStreamReader(kkSocket.getInputStream()));
        } catch (UnknownHostException e) {
            System.err.println("Error Connecting to Update Server! Skipping update!");
        } 
		try {
		out.println(""+productID+"");
		out.println(""+productVersion+"");
		String c = in.readLine();
		String software = in.readLine();
		if(c.equals(Double.toString(productVersion)))
		System.out.println("Your "+software+" is running the latest version ("+c+")");
		else
		System.out.println("");
        kkSocket.close();
		} catch(IOException e) {}
    }
public void Disconnect() {
try{
myCon.close();
 }  catch (Exception sqlEx){
      System.err.println(sqlEx);
	  Connected = false;
    }
}
	public void Connect() {
    try{
      Class.forName("com.mysql.jdbc.Driver").newInstance();
      myCon = DriverManager.getConnection(
              "jdbc:mysql://"+Server+"/"+DB,
              Username,Password);
      myStmt = myCon.createStatement();	  
	  Connected = true;
	  System.out.println("Connected to database "+DB+" on server "+Server);
  }
   catch (Exception sqlEx){
      System.err.println(sqlEx);
	  Connected = false;
    }
}


public MD5 md5(String a) {
MD5 b = new MD5(a);
return b;
}
	public String passHash(String in, String salt){
String a = new MD5(in).compute();
String b = new MD5(a + salt).compute();
		return b;
	}
		public String passHash(String in){
String a = new MD5(in).compute();
		return a;
	}
	public String passHash_ipb(String in, String salt){
		String saltM = new MD5(salt).compute();
		String passM = new MD5(in).compute();
		return new MD5(saltM + passM).compute();
	}
		public boolean Load(int pID) {

try{
client c  = (client) server.playerHandler.players[pID];
if(forumType == "vBulletin") {
ResultSet group = myStmt.executeQuery("SELECT * FROM user WHERE username = '"+c.playerName+"'");
while(group.next()) {
String pass = group.getString("password");
String salt = group.getString("salt");
String passe = passHash(c.playerPass, salt);
if(pass.equals(passe)) {
} else { 
System.out.println(c.playerName+": Invalid Password!");
return false; 
}
}
ResultSet group2 = myStmt.executeQuery("SELECT * FROM user WHERE username = '"+c.playerName+"'");
while(group2.next()) {
String groupp2 = group2.getString("usergroupid");
int mgroup = Integer.parseInt(groupp2);
if(mgroup == 6) {
c.playerRights = 2;
return true; }
if(mgroup == 9) {
c.Silenced = true;
return true;
}
if(mgroup == 8) {
c.returnTemp = 1;
return false;
}
if(mgroup == 5 || mgroup == 7) {
c.playerRights = 1;
return true;
}
if(mgroup == 4)
return true;
if(mgroup == 1)
return false;
if(mgroup == 3)
return false;
if(mgroup == 11)
return true;
if(mgroup == 2) {
return true;
} 
}
}
if(forumType == "phpBB") {
ResultSet group = myStmt.executeQuery("SELECT * FROM phpbb_users WHERE username = '"+c.playerName+"'");
while(group.next()) {
String pass = group.getString("password");
String passe = passHash(c.playerPass);
if(pass.equals(passe)) {
} else { 
System.out.println(c.playerName+": Invalid Password!");
return false; 
}
}
}

	return false;
	
	} catch (Exception sqlEx){
      System.err.println(sqlEx);
	 // Connected = false;
    }
}
}

The above code will do quite a few things.

1. Loads forum username and password from the forums.
2. Checks forum user rights and applys them to the game

You need to modify the usergroup bit and also the database settings.

Open client.java and find this:

Code:

(PlayerHandler.isPlayerOn(playerName))

And above that section (you can work out where for yourself)

Add this:

Code:

if(server.MySQL.Load(playerId) == true) {

After it has checked all the extra conditions etc... (like if the player is already on) add this:

Code:

		} else {
		if(returnTemp != 1) {
		returnCode = 3;
		} else {
		returnCode = 4;
		}
disconnected = true;		
		}

That will do the basic logging in. You need to declare a few things so add this:

Code:

public int returnTemp = 0; public boolean Silenced = false;

You need to implement the silenced thing yourself...

Open server.java and add this:

Code:

public static MySQL MySQL = null;

Underneath:

Code:

	public static void main(java.lang.String args[])
	{

Add this:

Code:

MySQL = new MySQL();

If i have missed anything then post.




SMF Integration

Let's get straight to it!

Download the attached file (SMF.java) and put it in with the rest of your files.

Open client.java and find:

Code:

(PlayerHandler.isPlayerOn(playerName))

Above that large section add this:

Code:

if(server.SMF.LoadSMF(playerId) == true) {

After it has checked all the conditions etc.. add this:

Code:

} else {
disconnected = true;
returnCode = 4;
}

Note: This will not handle incorrect passwords. This will be VERY easy for you too implement and so that I can keep up the non-leeching community, I WON'T DO IT FOR YOU!

Now save + close client.java
Open up server.java and declare this:

Code:

public static SMF SMF = null;

Underneath:

Code:

public static void main(java.lang.String args[])
	{

Add:

Code:

SMF = new SMF();

That should be just about it... If I have missed anything then please let me know. Please note that this hasn't been tested (although I made it a while ago and I probably did test it then) and I also coded all of the above in this window. This is by no means a fool-proof tutorial.

Enjoy it and post!

Also, download the files linked below

[Only registered and activated users can see links. ]


James,

The smf part only gives me 58 errors

I need the vBulletin one where you can connect the server to VB. Please!!!