Arcemu Phpbb registration

**egyptik** · 10-24-2009

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....

Code:

       $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..

Code:

// ////////////////////////////////////////////////////////////////////////////////////
           // 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:

Code:

return $user_id

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

Code:

$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:

Code:

function user_add($user_row, $cp_data = false)

7. Make it look like this:

Code:

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