WoWRoster Registration Check. v2.0 For WoWRoster 1 and 2 to work with phpbb3. PHPBB3 MOD by TankGirl OPEN forum/includes/constants.php AFTER *********************************** // Additional tables *********************************** ADD *note the prefix must match your roster table prefix 'roster_' is used as the default. *********************************** define('ROSTER_TABLE',roster_members); *********************************** OPEN forum/language/en/ucp.php AFTER *********************************** 'USERNAME_TAKEN_USERNAME' => 'The username you entered is already in use, please select an alternative.', *********************************** ADD *********************************** 'USERNAME_GUILDINVALID_USERNAME' => 'This username is not yet a valid Guild Member.', *********************************** OPEN forum/includes/functions_user.php AFTER *********************************** $sql = 'SELECT username FROM ' . USERS_TABLE . " WHERE username_clean = '" . $db->sql_escape($clean_username) . "'"; $result = $db->sql_query($sql); $row = $db->sql_fetchrow($result); $db->sql_freeresult($result); if ($row) { return 'USERNAME_TAKEN'; } *********************************** ADD *********************************** // //------------------- WoWRoster Check BEGIN ------------------ // $sql = 'SELECT name FROM ' . ROSTER_TABLE . " WHERE LOWER(name) = '" . $db->sql_escape($clean_username) . "'"; $result = $db->sql_query($sql); $row = $db->sql_fetchrow($result); $db->sql_freeresult($result); if ($row) { }ELSE{ return 'USERNAME_GUILDINVALID'; } // //------------------- WoWRoster Check END ------------------ // *********************************** Save and Close All.