Dietrich

take a look at smartymangos svn http://svn2.assembla.com/svn/smartymangos

its an old abandoned project, but has phpbb integrated, with functions u guys are implementing and many more like forum acc syncing with existing game acc and vice versa, etc

its possible that u can find some usefull info

Thanks for the link!

Atm, I've found out that Frostbyte's mod doesn't work well with xeross's bridge...

I'm now looking how the users are registered in phpbb so the realmd account is created too.

Password and email change in the profile

Open includes/ucp/ucp_profile.php

Search for this part:

if (sizeof($sql_ary))
                       {
                           $sql = 'UPDATE ' . USERS_TABLE . '
                               SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '
                               WHERE user_id = ' . $user->data['user_id'];
                           $db->sql_query($sql);
                       }

Before the last bracket add this:

                           $con = mysql_connect('host','hostid','hostpass');
                           mysql_select_db('realmdb',$con);

                              $email = $data['email']; 
                              $username = $data['username']; 
                              $password = $data['new_password'];
                              $name = strtoupper($username);
                              $password = strtoupper($password);  
                              $hashed_pw = sha1($name.':'.$password);  
                           mysql_query("UPDATE account set sha_pass_hash='".$hashed_pw."', email='".$email."' where  username='".$username."'");
                           mysql_select_db('forumsdb',$con);

Don't forget to change the database connection info. I know there might be a better way to do this by using phpbb functions, if you can improve it please do and share it.

Great work xeross155!

As for me I'm doing a research on how the users are added in phpbb... so when someone registers at the forums he'll automatically get an account on the server. Same for password changes/email changes at the forum. Just need to find those insert/update functions....

P.S.: This worked great on 3.0.6 and 3.0.7 Phpbb btw.

Edit: Atm I've figured out how to add the account into realmd db after registration, but still dunno about password change function...

Edit2: Password and email changes in profile now are also applied into the realmd accounts.

Edit3: If someone forgots his password, the new generated password is also applied to realmd account.

I can post the changes I've made to the phpbb files, the original idea was Frostbyte's.

try this:

if(_player && _player->m_mover && _player->m_mover->GetGUID() != guid)

That will prevent the crash of that GetGUID call, but it will crash in other functions

Bump.

http://pastebin.com/m77f0735f

Same here.

Only _proper_ data collection and calculation by each level base at armory data will accepted.

Like fast fix will not accepted.

All proper data collection was made for the last 11 levels, anything more needed?

Quoted from WoWWiki:

It has a standard spell power coefficient of 120%, as predicted by the 18 second duration of the effect.

Maxing out these two talents will increase the overall spell power coefficient to 120% base + 36% Empowered Corruption + 30% Everlasting Affliction = 186% total.

As base it should have 0.2

bulek, you are wrong. Worked for all characters base stats.

Indeed, works as intended.

There you got some info about Season 6: hxxp://www.wowwiki.com/Arena_PvP_system

Wowwiki:

The first time the Arena Team is created, it starts with 1500 Team Rating that you must raise by fighting against other groups; however, as of season 6 newly formed teams have their Team Rating set to 0 (Patch 3.1).

In that post there are team rating calculations and other sorta useful formulas.

Confirmed in 7219+

Tried Alex's sql fix as I don't have a 2.4.3 backup and it ruins up the data field of the items : / Any other proposals of fixes?