PHPBB2 Username Check to WoWRoster 1&2 - PHPBB2-MOD

phpBB integration forum

Re: phpBB registration check to roster

Postby TankGirl » Wed Mar 19, 2008 3:51 am

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.
User avatar
TankGirl
WR.net Apprentice
WR.net Apprentice
 
Posts: 51
Joined: Mon Apr 30, 2007 2:14 pm
Location: The bad place in my mind.

phpBB registration check to roster

Postby TankGirl » Sat Apr 12, 2008 11:46 pm

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.
User avatar
TankGirl
WR.net Apprentice
WR.net Apprentice
 
Posts: 51
Joined: Mon Apr 30, 2007 2:14 pm
Location: The bad place in my mind.

phpBB registration check to roster

Postby zanix » Sun Apr 13, 2008 6:26 am

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
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: phpBB registration check to roster

Postby TankGirl » Sun Apr 13, 2008 5:53 pm

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.
User avatar
TankGirl
WR.net Apprentice
WR.net Apprentice
 
Posts: 51
Joined: Mon Apr 30, 2007 2:14 pm
Location: The bad place in my mind.

phpBB registration check to roster

Postby zanix » Mon Apr 14, 2008 2:53 am

Oh ok
I was just trying to be helpful :roll:
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: phpBB registration check to roster

Postby jaffa » Tue Apr 15, 2008 3:51 pm

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.
User avatar
jaffa
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 49
Joined: Thu Jan 10, 2008 11:35 pm

Re: phpBB registration check to roster

Postby wacoede » Tue Apr 15, 2008 4:26 pm

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
User avatar
wacoede
WR.net Apprentice
WR.net Apprentice
 
Posts: 49
Joined: Sat Sep 02, 2006 2:07 am

Re: phpBB registration check to roster

Postby TankGirl » Wed Apr 16, 2008 7:49 pm

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.
User avatar
TankGirl
WR.net Apprentice
WR.net Apprentice
 
Posts: 51
Joined: Mon Apr 30, 2007 2:14 pm
Location: The bad place in my mind.

Re: phpBB registration check to roster

Postby wacoede » Wed Apr 16, 2008 8:36 pm

or better yet switch to Dragonfly :D
User avatar
wacoede
WR.net Apprentice
WR.net Apprentice
 
Posts: 49
Joined: Sat Sep 02, 2006 2:07 am

Re: phpBB registration check to roster

Postby TankGirl » Fri Apr 18, 2008 10:21 pm

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?
Last edited by TankGirl on Fri Apr 18, 2008 10:22 pm, edited 1 time in total.
User avatar
TankGirl
WR.net Apprentice
WR.net Apprentice
 
Posts: 51
Joined: Mon Apr 30, 2007 2:14 pm
Location: The bad place in my mind.

Re: phpBB registration check to roster

Postby TankGirl » Tue Apr 22, 2008 1:05 am

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.
User avatar
TankGirl
WR.net Apprentice
WR.net Apprentice
 
Posts: 51
Joined: Mon Apr 30, 2007 2:14 pm
Location: The bad place in my mind.

Previous

Return to phpBB

Who is online

Users browsing this forum: No registered users and 0 guests

cron