L2J Connect

I'm contributing a new module for Drupal 7. I hope it helps you starting a fresh website for your L2J Server. The posibilities are unlimited. Like Facebook Connect building web applications but L2J :D

This module allows users to login on a Drupal website through L2J Server using a L2J account.

In the first release, L2j Connect converts your Drupal Installation in a robust Account Manager, creating and editing accounts.

L2j Connect was aproved & tested by the Drupal Community and now is under active development.

1. INSTALLATION GUIDE

1) Install Drupal 7.
2) Place the entirety of this directory in sites/all/modules/l2j_connect
3) Edit the settings.php adding the datasources (included in the step 2).
4) Navigate to administer > modules and enable L2j Connect.
5) Create a new field named "email" into your accounts table, like this *

ALTER TABLE `accounts` ADD `email` VARCHAR( 255 ) NOT NULL AFTER `password`

2. LOGINSERVER AND GAMESERVER SETTINGS

Each database connection is specified as an array of settings similar to the following:

array(
'driver' => 'mysql',
'database' => 'databasename',
'username' => 'username',
'password' => 'password',
'host' => 'localhost',
'port' => 3306,
'prefix' => 'myprefix_',
'collation' => 'utf8_general_ci',
);

Edit your settings.php file, adding the 'gameserver' and 'loginserver'.

Your datasources now must to look like this:

Line number On/Off | Expand/Contract | Select all

$databases = array (
'default' =>
array (
'default' =>
array (
'database' => 'drupal_database',
'username' => 'username',
'password' => 'password',
'host' => 'localhost',
'port' => '',
'driver' => 'mysql',
'prefix' => '',
),
),'loginserver' =>
array (
'default' =>
array (
'database' => 'l2jls',
'username' => 'root',
'password' => '',
'host' => 'localhost',
'port' => '',
'driver' => 'mysql',
'prefix' => '',
)
),'gameserver' =>
array (
'default' =>
array (
'database' => 'l2jgs',
'username' => 'root',
'password' => '',
'host' => 'localhost',
'port' => '',
'driver' => 'mysql',
'prefix' => '',
)
),
);

TODO *

- At the moment just need to create an 'email' field into the loginserver accounts table, but I'm waiting your suggestions using other methods. The different aproachs could be actively maintained in the future over different releases, in example: 7.x-1.x-dev and 7.x-2.x-dev.

3. WHAT'S THIS?

Is not just an account manager. Is a connector and useful to integrate another third party applications with your Drupal isntallation. This module could work in conjuntion with other third party modules:

An example:

l2jserver --> l2j_connect --> drupal <-- phpBB (connector for phpBB2)

Other funny example:

l2jserver --> l2j_connect --> drupal <--> services <--> rest_server / plist <--> iOs App

The objetive finally is handle the l2jserver accounts through Drupal.

Download Drupal 7
http://drupal.org/project/drupal

Download L2J Connect:
http://drupal.org/project/l2j_connect

L2J Connect Issue Queue:
http://drupal.org/project/issues/1303350