Invision Powered Board 3.2 Compatibility

I'm an IPB forum user, so I wanted to have LA compatible with the latest IPB release which came out this month, version 3.2.0. The developers of IPB changed the way avatars and profile pictures were saved and stored compared to the previous version of IPB software. Therefore the LA default become incompatible and tonight I been testing out the means to fix this. I got a working fix which that IPB3.2 users may use.

includes/save_avatar

FIND

PHP:

// ###############################################################################
// SAVE AVATAR FOR INVISION POWER BOARD 3
// ###############################################################################

if($forum_info_arr['forum_name'] == 'IPB 3')
{
  $avatar_location = '../../living_avatars/avatars/la_' . $avatar_id . '.png';
  $avatar_size     = $avatar_width . 'x' . $avatar_height;
  $avatar_type     = 'local';

  if($avatar_exists = $DB->query_first("SELECT pp_member_id  FROM " . $forum_info_arr['forum_table_prefix'] . "profile_portal WHERE pp_member_id = $user_info[user_id]"))
  {
    $DB->query("UPDATE " . $forum_info_arr['forum_table_prefix'] . "profile_portal SET avatar_location = '$avatar_location',
                                                                          avatar_size     = '$avatar_size',
                                                                          avatar_type     = '$avatar_type'
                                                                    WHERE pp_member_id = $user_info[user_id] LIMIT 1");
  }
  else
  {
    $DB->query("INSERT INTO " . $forum_info_arr['forum_table_prefix'] . "profile_portal (pp_member_id, avatar_location, avatar_size, avatar_type)
                VALUES ($user_info[user_id], '$avatar_location', '$avatar_size', '$avatar_type')");
  }
}


REPLACE WITH

PHP:

// ###############################################################################
// SAVE AVATAR FOR INVISION POWER BOARD 3.2
// ###############################################################################

if($forum_info_arr['forum_name'] == 'IPB 3')
{
  $avatar_location = '../../living_avatars/avatars/la_' . $avatar_id . '.png';

  if($avatar_exists = $DB->query_first("SELECT pp_member_id  FROM " . $forum_info_arr['forum_table_prefix'] . "profile_portal WHERE pp_member_id = $user_info[user_id]"))
  {
    $DB->query("UPDATE " . $forum_info_arr['forum_table_prefix'] . "profile_portal SET pp_main_photo = '$avatar_location',
                                                                          pp_main_width = '$avatar_width',
                                                                          pp_main_height = '$avatar_height',
                                                                          pp_thumb_photo = '$avatar_location',
                                                                          pp_thumb_width = '100',
                                                                          pp_thumb_height = '100'
                                                                    WHERE pp_member_id = $user_info[user_id] LIMIT 1");
  }
  else
  {
    $DB->query("INSERT INTO " . $forum_info_arr['forum_table_prefix'] . "profile_portal (pp_member_id, pp_main_width, pp_main_height, pp_thumb_photo, pp_thumb_width, pp_thumb_height)
                VALUES ($user_info[user_id], '$avatar_location', '$avatar_width', '$avatar_height', '$avatar_location', '100', '100')");
  }
}

includes/session_files/session_ipb3

FIND

PHP:

// ###############################################################################
// FORUM AVATAR
// ###############################################################################    

function ForumAvatar($userid, $username)
{
  global $DB, $settings;

  $prgm_db_name = $DB->database;

  if($prgm_db_name != $settings['forum_db_name'])
  {
    $DB->select_db($settings['forum_db_name']);
  }  
  
  $avatar = '';

  if($userid > 0)
  {
    $useravatar = $DB->query_first('SELECT avatar_location, avatar_size, avatar_type
                                      FROM ' . $settings['forum_table_prefix'] . 'profile_portal
                                     WHERE pp_member_id = %d', $userid);
  }
  else
  {
    // old ipb2 code removed
  }

  if($useravatar['avatar_type'] == 'local' AND strlen($useravatar['avatar_location']))
  {
    $avatar = $settings['forum_folder_path'] . 'public/style_avatars/' . $useravatar['avatar_location'];
  }
  else if($useravatar['avatar_type'] == 'url')
  {
    $avatar = $useravatar['avatar_location'];
  }
  else if($useravatar['avatar_type'] == 'upload')
  {
    $avatar = $settings['forum_folder_path'] . 'uploads/' . $useravatar['avatar_location'];
  }

  // connect back to our main db
  if($prgm_db_name != $settings['forum_db_name'])
  {
    $DB->select_db($prgm_db_name);
  }  

  return $avatar;
}

REPLACE WITH

PHP:

// ###############################################################################
// FORUM AVATAR
// ###############################################################################    

function ForumAvatar($userid, $username)
{
  global $DB, $settings;

  $prgm_db_name = $DB->database;

  if($prgm_db_name != $settings['forum_db_name'])
  {
    $DB->select_db($settings['forum_db_name']);
  }  
  
  $avatar = '';

  if($userid > 0)
  {
    $useravatar = $DB->query_first('SELECT avatar_location, avatar_size, avatar_type, pp_main_photo, pp_main_width, pp_main_height
                                      FROM ' . $settings['forum_table_prefix'] . 'profile_portal
                                     WHERE pp_member_id = %d', $userid);
  }
  else
  {
    // old ipb2 code removed
  }

  if($useravatar['avatar_type'] == 'local' AND strlen($useravatar['avatar_location']))
  {
    $avatar = $useravatar['pp_main_photo'];
  }
  else if($useravatar['avatar_type'] == 'url')
  {
    $avatar = $useravatar['avatar_location'];
  }
  else if($useravatar['avatar_type'] == 'custom')
  {
    $avatar = $useravatar['pp_main_photo'];
  }
  else if($useravatar['avatar_type'] == 'upload')
  {
    $avatar = $settings['forum_folder_path'] . 'uploads/' . $useravatar['pp_main_photo'];
  }

  // connect back to our main db
  if($prgm_db_name != $settings['forum_db_name'])
  {
    $DB->select_db($prgm_db_name);
  }  

  return $avatar;
}

Keep in mind this version of LA was 2.3.1 PRO so I'm not sure if this helps the 1.2.1 free version but at least may help the current developer of LA understand the new sql variable changes in the latest IPB.