[PHPBB3] Registration Mod Allowing players to Play wow server after site registration

[iTweak]

Ok ppl, this is a very basic script made by FROSTBYTE, and edited by me a while ago to make it work with arcemu (originally designed for mangos). I've used it for my server (3.1.3) and it worked fine

This is what it will do:
If someone registers on your phpbb forum, it will add the new user to both your arcemu and phpbb database, so people won't have to register again on your forums aswell as on your main site. All users are ofcourse manageable through the phpbb admin (Will not affect your arcemu db).

1. you need to edit your includes/funtions_user.php
2. look for line (about) 293 it will look like this....

       $sql = 'SELECT group_colour
             FROM ' . GROUPS_TABLE . '
             WHERE group_id = ' . (int) $user_row['group_id'];
          $result = $db->sql_query_limit($sql, 1);
          $row = $db->sql_fetchrow($result);
          $db->sql_freeresult($result);

          set_config('newest_user_colour', $row['group_colour'], true);
       }

3. After the last bracket (shown above) put the following:
NOTE: Make sure u edit the code below to match your database / host etc..

// ////////////////////////////////////////////////////////////////////////////////////
           // PWS USER ADD FOR MANGOS
           // MOD BY FROSTBYTE JULY 2009 | EDDITED BY EGYPTIK FOR ARCEMU AUGUST 2009
           // CHANGE THE FOLLOWING TO YOUR CHARACTER ACCOUNTS DATABASE
           $email = $user_row['user_email'];         // GRAB THE PW FROM ABOVE
           $username = $user_row['username'];         // SAME WITH USERNAME
           $password = $raw_pw;                 // AND THE PASSWORD SEE UCP_REGISTER.PHP #331
           $dbhost="localhost";                  // SET VARIABLES FOR MYSQL HOST
           $dbid="root";                        // ID
           $dbpw="root";                        // AND PW
           $dbrealmd="realmdb";                     // INCASE NOT USING DEFAULT MANGOS VARIABLE
           $today  = date("Y-m-d h");               // GET TODAYS DATE (I DIDNT SEE IT UP THERE)
           $lastip = $_SERVER['REMOTE_ADDR'];            // GET THE IP, SAME DIDNT SEE IT UP THERE
           $flags = 24;                        // DEFAULT TO WOTLK, LATER I'LL MAKE IT USER SELECTABLE
           // LOAD UP THE DATABASE
           // replace with your stuff of course
           if(!$con = mysql_connect($dbhost,$dbid,$dbpw)){
              die('Unable to connect to '.$dbhost.'<br>'.mysql_error());
           }
           if(!mysql_select_db($dbrealmd,$con)){
              die('Unable to access to the realm db<br>Check the includes/funtions_users.php'.mysql_error());   
           }
           // SETUP THE PASSWORD
           
           $name = strtoupper($username);      // CHANGE USERNAME TO UPPERCASE
           $password = strtoupper($password);   // DO THE SAME WITH THE PW   
           $hashed_pw = sha1($name.':'.$password);      // SET THE NEW PW AS NAME COLON PASSORD COMBO
           
           // PUT IT ALL TOGETHER
           if(!mysql_query("INSERT INTO `accounts` (`login`,`password`,`email`,`lastip`,`gm`,`banned`,`flags`) VALUES ('$username','$password','$email','$lastip','0','0','24')")){
                 die('Unable to add user.<br>'.mysql_error());
              };
           mysql_close($con);   
           // ////////////////////////////////////////////////////////////////////////////////////

NOTE: Make sure it is above the line shown below (which will most likely NOW be #337:

return $user_id

4. Load up includes/ucp_register.php
5. and on line #331 which looks like this

$user_id = user_add($user_row, $cp_data);

Make it look like this:

$user_id = user_add($data['new_password'],$user_row, $cp_data);

This will pass the "raw" password we need to manipulate.
Now go back to includes/funtions_user.php

6. Line #152 which looks like this:

function user_add($user_row, $cp_data = false)

7. Make it look like this:

function user_add($raw_pw,$user_row, $cp_data = false)

And that's it. Just upload the files and it should work. If u have any questions just post em here..

Credits:
Frostbyte for making this script for mangos
Me for making it work with arcemu

I found this thread not to long ago and i was wondering something:

I host my website from a public host (frangle. net) and i was wondering i implemented this code onto my site wether it would allow registering users to automatically log onto my server via their wow.exe client, as long as they changed their realmlist.wtf file correctly.

thanks in advance

[Hellgawd]

It should, if you are running PHPBB3. Otherwise, no.

[iTweak]

i forgot to mention that my server runs off of a VPN (Hamachi), would i just use my VPN IP for the Database IP?

but i am buying a physical server tower next week... will it work with Hamachi? will it work with my physical server?

[iTweak]

i could really use this answered, and others may wish to know also...



sorry for double post

[Kiev]

Not with Hamachi no, the VPN would have to directly be in your hamachi server, and therefore it would not work. Why are you using hamachi anyway?

[iTweak]

i am using it for alpha testing only... and getting it as 100% blizzlike as possible before beta.

i will host closed beta on my server that i am going to purchase... with the server would i just point the ip to the server ip?

hamachi is a vpn... are you saying the database? ... as i would assume... the database is on localhost and the vpn is hosted by localhost... the website is on a host gator ftp server

[Kiev]

When you get the server, just replace everything with the hamachi ip to the server IP, and dont having hamachi require you to be in the same room? Therefore it would return connection issues?

[iTweak]

but i dont want it to be hosted using hamachi lol... im trying to get it public/dedicated using my server

[Kiev]

Then what is your trouble ? If you would like you cxan PM me and i will assist you further.