OMG you're not kidding!! ME TOO!
I'm trying to wrap my head around the new phpbb3.
I swear EVERY function requires about 4-5 other pages! lol
If I get it worked out first I promise an update for both roster1 AND roster2.

I've become so desperate for this and completely clueless with the very complex and confusing phpbb3 code, I've posted this both at the phpbb forum and phpbuilder.
I'm also offering $100 for a solution.

I dunno what exactly you are looking for, but here is an addon for roster 2.0 called phpbb sync
http://www.wowroster.net/Forums/viewforum/f=125.html

Thanks Zanix, but that just syncs up the groups/ranks to DF phpbb. Although I'm waiting for the to go fully phpbb3 compatible.. That's not what we need here.

We need phpbb3 to check if a person is in the WoWRoster (1 or 2) database, BEFORE letting them complete registration.
PHPBBsync was not designed for that, although Jaffa is doing a fantastic job on it.

Oh ok
I was just trying to be helpful

TankGirl wrote:Thanks Zanix, but that just syncs up the groups/ranks to DF phpbb. Although I'm waiting for the to go fully phpbb3 compatible.. That's not what we need here.

We need phpbb3 to check if a person is in the WoWRoster (1 or 2) database, BEFORE letting them complete registration.
PHPBBsync was not designed for that, although Jaffa is doing a fantastic job on it.

I'm touched

I realise that it's not what you want, but you will be able to set it so it suspends anyone not in the guild. The way I imagine it working is that new users get no rights until phpBBSync gives them a usergroup, at which point they get access to whichever rights that group has.

Tankgirl what your looking for is more of a phpBB hack rather than a roster addon it is possible (if complicated)

but you would be better off asking over at the phpBB3 MOD Request forums as they will know what needs to be modified within their code for this to work

Hope this helps

Been there done that.. they are about worthless. I can't even find PHP programmer to HIRE.
Getting a little frustrated with this, and almost about to dump phpbb3 and go back to phpbb2.

or better yet switch to Dragonfly

This is what i have THUS far.
usernames are checked in /includes/functions_user.php of phpbb3.

This is the piece of script check if the name is open in phpbb3.

Code: Select all

   $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';
   }


I've been trying a roster check before and after with less than desirable result.

Been trying to add this to the script, but it just goes white screen when it goes to run it.

Code: Select all

$sql = "SELECT name
        FROM roster_members
        WHERE LOWER(name) = '" . $db->sql_escape($clean_username) . "'";
    if ($result = $db->sql_query($sql))
    {
        if ($db->sql_numrows($result) < 1)
        {
            $db->sql_freeresult($result);
      return 'USERNAME_TAKEN';
        }
    }
    $db->sql_freeresult($result);


Any Ideas?

I've solved this issue. (PHPBB3)
Never underestimate the determination of a desperate girl! lol
I've posted this to a new topic, and should work with both roster 1 and 2.

http://www.wowroster.net/Forums/viewtop ... html#33294

Thanks for all the input, and I hope you enjoy.