**Original post removed to make finding this MOD easier.

This MOD alters the PHPBB2 registration to first check if the name is a valid Guild Member before letting them complete registration. It will reject all other name attempts to register.
Tested on WoWRoster 1 and should also work for WoWRoster 2. (tables/fields are the same.)
This MOD will NOT work if the PHPBB2 and WoWRoster tables are in seperate databases.
No coding will be done to provide cross database checking.
This has NOT been tested for DF, and no support for DF will be done by me.
DF users, implement/manipulate this mod at own risk.
REMEMBER TO BACK UP YOUR FILES BEFORE MODDING!
Enjoy!

I use anti-spam ACP 2.06

http://www.lithiumstudios.org/phpBB3/vi ... p?f=25&t=4

it works GREAT!!!!!! I have no spam registrations that are done by script or bot anymore.

That's already in the latest version phpBB, but you still get people that actually take the time to try to register. The only people that should be signing up at all, are guild members. Thus my request for the roster check.

Since the phpBB and the roster share the same database, with table prefixes to separate them.(phpbb_ and roster_) The Registration is already authenticated to the database.

It would be like a reverse version of how it checks the database if that name is already used for the forums.

You can easily get a list of the roster members with just this simple code.

Code: Select all

<?php
mysql_connect("localhost", "DATABASEUSERNAME", "PASSWORD") or die(mysql_error());
mysql_select_db("DATABASENAME") or die(mysql_error());

$result = mysql_query("SELECT * FROM roster_members") 
or die(mysql_error());  

echo "<table border='1'>";
echo "<tr> <th>Character Names</th></tr>";
while($row = mysql_fetch_array( $result )) {
    // Print out the contents of each row into a table
    echo "<tr><td>"; 
    echo $row['name'];
    echo "</td></tr>"; 
} 

echo "</table>";
?>

Now how do I get that check against the username they entered during registration? lol

If I figure it out first I'll keep you posted.
Any php guru input, to set me of in the right direction would be great too.

i did play wit a similar idea, but what about poeple wanting to apply to the guild? we have registrating set to admin approve, so the admins need to approve every regsitration anyways. no wrong signups and registrations anymore, and no need to code anything, plus approved accounts can post in the recruitement section.

I do have it set to admin activation. I then have to check the roster list manually, which I have blond moments, and I could miss someones name, and deny them. I get about 2 people a day trying to access the forums, and they are just trying to spam some porn or something. I don't like that they show as a new member either, whether I approve them or not.
We don't require an application, your initial rank IS your application.

A code is a more efficient, and accurate way of doing what I do everyday.

BTW I enjoy all the attempts to discourage me from continuing my project.
I'm a girl who has her mind set, this is what I want, and I will get it. lol

I refuse to abandon this project until I make it work.

tg,

it's a matter of effort versus gained profit. if you want to do it for the sake of seeing how it works, that is a good thing. i suppose it just depends on how a guild is run, whether a mechanism like yours is applicable or not.
regards

MOD SOLVED!

I'm going to post it, for the slim chance someone might want it.

Code: Select all

//ROSTER CHECK MOD by tankgirl
//This will check your WoWRoster for the guild member, before they can register for yout phpBB forums.
//Special thanks sneakimp from PHPBuilder for all the help!
//Only works in WoWRoster/phpBB tables sharing the same database.

OPEN
forums/language/lang_english/lang_main.php

LOOK FOR
##################################

$lang['Empty_message_email'] = 'You must enter a message to be e-mailed.';

##################################

AFTER ADD
##################################

//
//------------------- WoWRoster Check BEGIN ------------------
//

$lang['GuildMember_invalid'] = 'This username  is not yet a valid Guild Member.';

//
//------------------- WoWRoster Check END ------------------
//

##################################

OPEN
forums/includes/functions_validate.php

LOOK FOR
##################################

   $username = phpbb_clean_username($username);

##################################

AFTER ADD
##################################

//
//------------------- WoWRoster Check BEGIN ------------------
//

$rostersql=" SELECT name
        FROM roster_members
        WHERE LOWER(name)='" . strtolower($username) . "'";
    if ($result = $db->sql_query($rostersql))
    {
        if ($db->sql_numrows($result) < 1)
        {
            $db->sql_freeresult($result);
            return array('error' => true, 'error_msg' => $lang['GuildMember_invalid']);
        }
    }
    $db->sql_freeresult($result);

//
//------------------- WoWRoster Check END ------------------
//

##################################

SAVE AND CLOSE ALL

TankGirl wrote:BTW I enjoy all the attempts to discourage me from continuing my project.
I'm a girl who has her mind set, this is what I want, and I will get it. lol

I refuse to abandon this project until I make it work.

LMAO. Gratz on getting the code working. I don't use phpbb, as I've been using e107 since it's inception and am more used to it, but I love seeing someone with the perseverance to get the job done.

For those of you using the phpbb users mod.

Code: Select all

// Kick out those who do not belong
if ($userdata['username'] == "Anonymous")
   message_die(GENERAL_ERROR, "You need to be logged in to be able to access this page.");

I would like to use this code on my forum however my Roster information is in a different mySQL database to my forum information, can someone give me an idea of what I'd need to modify to get it to work for this setup?

Code: Select all

//ROSTER CHECK MOD by tankgirl
//This will check your WoWRoster for the guild member, before they can register for yout phpBB forums.
//Special thanks sneakimp from PHPBuilder for all the help!
//Only works in WoWRoster/phpBB tables sharing the same database.

OPEN
forums/language/lang_english/lang_main.php

LOOK FOR
##################################

$lang['Empty_message_email'] = 'You must enter a message to be e-mailed.';

##################################

AFTER ADD
##################################

//
//------------------- WoWRoster Check BEGIN ------------------
//

$lang['GuildMember_invalid'] = 'This username  is not yet a valid Guild Member.';

//
//------------------- WoWRoster Check END ------------------
//

##################################

OPEN
forums/includes/functions_validate.php

LOOK FOR
##################################

   $username = phpbb_clean_username($username);

##################################

AFTER ADD
##################################

//
//------------------- WoWRoster Check BEGIN ------------------
//

$rostersql=" SELECT name
        FROM roster_members
        WHERE LOWER(name)='" . strtolower($username) . "'";
    if ($result = $db->sql_query($rostersql))
    {
        if ($db->sql_numrows($result) < 1)
        {
            $db->sql_freeresult($result);
            return array('error' => true, 'error_msg' => $lang['GuildMember_invalid']);
        }
    }
    $db->sql_freeresult($result);

//
//------------------- WoWRoster Check END ------------------
//

##################################

SAVE AND CLOSE ALL

Got a problem with that mini-mod.

Guests could not post anything (in "Guild Application" forum), because posting use same validate_username() function, that we change in /includes/functions_validate.php

So, i realized that we should use different functions for posting and user registration. Solution:

---

in /includes/functions_validate.php create one more validate_username() function via copy-paste. Rename one function to smth like validate_username_roster(). Make sure renamed function have "WoWRoster check" block, and delete it from origin function (if you already installed mod).

So now you have smth like that in /includes/functions_validate.php:

Code: Select all

function validate_username($username)
{
    global $db, $lang, $userdata;

    // Remove doubled up spaces
    $username = preg_replace('#\s+#', ' ', trim($username)); 
    $username = phpbb_clean_username($username);

    $sql = "SELECT username 
        FROM " . USERS_TABLE . "
        WHERE LOWER(username) = '" . strtolower($username) . "'";
// etc, etc, etc..  till function end ----------->>>>>>>>>>>
}

function validate_username_roster($username)
{
    global $db, $lang, $userdata;

    // Remove doubled up spaces
    $username = preg_replace('#\s+#', ' ', trim($username)); 
    $username = phpbb_clean_username($username);
//
//------------------- WoWRoster Check BEGIN ------------------
//
$rostersql=" SELECT name
        FROM roster_members
        WHERE LOWER(name)='" . strtolower($username) . "'";
    if ($result = $db->sql_query($rostersql))
    {
        if ($db->sql_numrows($result) < 1)
        {
            $db->sql_freeresult($result);
            return array('error' => true, 'error_msg' => $lang['GuildMember_invalid']);
        }
    }
    $db->sql_freeresult($result); 
//
//------------------- WoWRoster Check END ------------------
//

    $sql = "SELECT username
        FROM " . USERS_TABLE . "
        WHERE LOWER(username) = '" . strtolower($username) . "'";
// etc, etc, etc..  till function end ----------->>>>>>>>>>>
} 

Then, open /includes/usercp_register.php, find line
"$result = validate_username($username);"
(aboult line #428) and replace with
"$result = validate_username_roster($username);".

---

Now, for registering we use function with wowroster check,
but for posting (/includes/functions_post.php) we use default function.

im sorry i didnt follow you ezik, i have been teaching myself php, but still not that great.

i also need guest to be able to post to recruitment forums.

what code do i need to change?

where does the function validate_username($username) end? I'm not familiar with php at all!

any ideas on how to do this in phpBB3? it's setup a little differently, and i can't figure out how to make it work >.<

would love to see this for phpbb3 also.