[Release] PHPBB3 Intergrate To Your Accounts Database

[Nick]

Open:
phpbb3/config.php

Then look for:
$ load_extensions ='';

After add:

$ sql_server_host = "adresse_ip_de_votre_serveur_sql";
$ sql_server_user = "login_de_votre_serveur_sql";
$ sql_server_pass = "password_de_votre_serveur_sql";



Close config.php

-------------------------------------------------- -----------------------

Open:
phpbb3/includes/functions.php



search:
reapply_sid $ redirect = ($ redirect);

After add:

if ($ user-> data [ 'user_lastvisit'] == 0)
(
server_userlogin $ = $ user-> data [ 'username'];
$ sql = "UPDATE accounts SET banned ='0 'WHERE login =' $ server_userlogin";
$ result = mysql_query ($ sql, sql_server_connect (realm));
)



INFO: watched this line $ result = mysql_query ($ sql, sql_server_connect ( 'realm'));
REALM by replacing the name of your SQL database contains the

Then look at the very end:
>

Before add:

sql_server_connect function ($ sql_server_db) (

global $ sql_server_host, $ sql_server_user, $ sql_server_pass;

$ sql_cont = mysql_connect ($ sql_server_host, $ sql_server_user, $ sql_server_pass) or die (mysql_error ());
mysql_select_db ($ sql_server_db, $ sql_cont) or die (mysql_error ());

return $ sql_cont;
)



Close functions.php

-------------------------------------------------- -----------------------

Open:
phpbb3/includes/ucp/ucp_register.php

Then look for:
user_add $ user_id = ($ user_row, $ cp_data);

After add:

server_userlogin $ = $ data [ 'username'];
server_userpass $ = $ data [ 'new_password'];
$ server_userencodpass = sha1 (strtoupper ($ server_userlogin ).":". strtoupper ($ server_userpass));
server_usermail $ = $ data [ 'email'];
server_userip $ = $ user_row [ 'user_ip'];

$ sql = "INSERT INTO accounts (login, password, encrypted_password, gm, banned, email, flags, lastip)
VALUES ( '$ server_userlogin', '$ server_userpass',' $ server_userencodpass','0 ','1', '$ server_usermail','8 ',' $ server_userip ') ";

$ result = mysql_query ($ sql, sql_server_connect (realm));



INFO: watched this line $ result = mysql_query ($ sql, sql_server_connect ( 'realm'));
REALM by replacing the name of your SQL database contains the

Close ucp_register.php

-------------------------------------------------- -----------------------

Open:
phpbb3/includes/ucp/ucp_profile.php

Then look for:
add_log ( 'user', $ user-> data [ 'user_id'], 'LOG_USER_NEW_PASSWORD', $ data [ 'username']);

After add:

server_userlogin $ = $ data [ 'username'];
server_userpass $ = $ data [ 'new_password'];
$ server_userencodpass = sha1 (strtoupper ($ server_userlogin ).":". strtoupper ($ server_userpass));

$ sql = "UPDATE accounts SET password = '$ server_userpass', encrypted_password =' $ server_userencodpass' WHERE login = '$ server_userlogin";
$ result = mysql_query ($ sql, sql_server_connect ( 'realm'));



INFO: watched this line $ result = mysql_query ($ sql, sql_server_connect ( 'realm'));
REALM by replacing the name of your SQL database contains the

Then look for:
add_log ( 'user', $ user-> data [ 'user_id'], 'LOG_USER_UPDATE_EMAIL', $ data [ 'username'], $ user-> data [ 'user_email'], $ data [ 'email']);

After add:

server_userlogin $ = $ data [ 'username'];
server_usermail $ = $ data [ 'email'];
$ sql = "UPDATE accounts SET email = '$ server_usermail' WHERE login = '$ server_userlogin";
$ result = mysql_query ($ sql, sql_server_connect ( 'realm'));



INFO: watched this line $ result = mysql_query ($ sql, sql_server_connect ( 'realm'));
REALM by replacing the name of your SQL database contains the

Close ucp_profile.php

--------------------------------------------------

[computerwiz656]

Will try it out thank you.
Doesn't work. I fixed the config part but then you get problems with the functions area. Plus I had to search partial strings as they were not exactly the same string.

[Nell]

Would be nice if you supplied which version of PHPBB3 you edited... Since there's a difference between each of them ;)

[Nick]

I'l post a PHPBB2 version and PHPBB3 version, later tonight just got a high ammount of work to complete etc.

[Merlino]

THis is for Arcemu or MAngos??

[Nick]

its old, and for previous versions of phpbb with hacks etc so no point installing it was for arcemu.

[Merlino]

a ok tnx

[Nick]

i got a phpbb mod for arcemu and mangos though, login with your acc's etc and tools and u can pic a character to rep u on the forum, but iam not releasing it.

[whirusion]

does it work or not?

[Nick]

obv you dont read.

[Ultimate]

now if you can come up with the same thing for Simple Machines Forums(SMF) and offsite hosting..that would be pwn

Computer hosting Server(wow)======> Godaddy Hosted Website(smf)

[whirusion]

is there any way to use the pserver account on a phpbb3 forum?