Oh my.... being half awake and coming to check my original post and edit it.. I deleted it! lol
So here we go again...

This is the full WoWroster addon to sync your guild ranks (from) wowroster and assign them to phpBB groups and (now) phpBB ranks!
Addon based on the phpBB Syncer Addon by robweeks.

I would like to give credit to robweeks for a very simple and effective addon.
INSTALLATION
-read the readme file for full details
-only need to change the conf.php settings
-upload phpBB folder to your wowroster addon folder
-browse to your roster and click phpBB Sync
-supply admin password and synchronize

REQUIREMENTS
1. Both the WoWRoster and phpBB tables need to share a database.
2. Names in phpBB need to be the same as the WoWRaoster.
- Suggest using the roster check MOD: http://www.wowroster.net/Forums/viewtop ... oster.html

Original:
http://www.wowroster.net/Forums/viewtop ... art=0.html

I did a rewrite of this some time ago as well but I no longer use wowroster

Thanks Malcolm!
I wasn't sure if that was the right one, because when I downloaded it, his newer version has more files.. this one only has the index.php and conf.php.
I'll have to look at his newest and see if and where my mod would still work.
I know a couple of people have been asking about this type of MOD.
The ability to have groups and ranks set automatically is a serious time saver, not to mention in a large guild keeping ranks in the forums to match the guild ranks, manually, can be difficult.
Setting access privileges based on groups and great.

Well Malcolm I see that was your newest work with the functions and triggers.
It's going to take me some time to go through all that code to see what you were doing.. maybe you can write in this MOD as an "option", since I noticed you have an option to use pointers for names... SHEESH lol
That's alot of work!
I just use my roster check, and users have to use their main character names to sign up for forums.
Hmm, maybe I should let you come up with a Malcolm version of this, with the ranks mod as an option.. lol
Sure would prevent me from a bad case of brain moosh.. lol

Basically how I went about it:
1) Select all 'roster names', with rank, from the roster database where there is an indication of 'main' character
2) Search through the pointer database and replace any 'roster names' found with the 'phpbb names'
3) Get all user IDs from the phpBB database using the username
4) Get the roster Ranks -> phpBB groups information
-- For this I let the user dynamically choose which ranks go to which groups, you can also set more then one rank to more then one group --
5) Empty all designated phpBB groups
6) Populate groups based the userID and group ID
7) Tell users all is well

A lot of the above steps can actually be compiled into one SQL query if the roster and phpBB tables are stored on the same database.

Just as a warning, my code looks very very ugly. I tried to use the wowRoster code guidelines which made all my variables an extra 30 character in length - not fun when trying to fix things Feel free to use whatever you'd like.

I doubt I'll be recoding the addon though, I've already started coding my own roster using Recipe Book. wowRoster is just too large for what my guild needs - a roster of characters/levels/classes and a trade database they can search though.

well I think I'll just stick to mine. lol
maybe one day someone will be brave enough to update my mod to a wowroster style option and configuration, for those less comp savy.

But I doubt that will be me! lmao

Although I do plan to make a trigger, once I find out all the modes or if I need one.
I have 2 things I'd like to make a trigger to run after someone updates.
This and a script related to our guild points system (unlikely anyone else could use).

2 things.

I followed your directions and still nothign came up on my roster?

http://www.noisymisfits.com/index.php?m ... age=roster

also, is there a way that their can be triggers..

IF "rostername" => "Forum Name"

stupid me, I somehow had the roster on my test db still. Damn that Conf.php lol.

However, I did get this to work with pnphpbb so if anyone wants to know how I did it, just ask.

3 problems I ran into when implementing this and the subsequent fixes.

1: The menu for the addon didn't appear. This was simply because menu.php was not included in the zip, however menu.php.bak was. Simply rename menu.php.bak to menu.php and the interface works proper.

2: The data was not connecting proper for rank assignments, while groups assigned properly.

In index.php...

Change:

Code: Select all

mysql_connect(localhost,$dbuser,$dbpasswd);


To:

Code: Select all

      // connect to DB
      include($phpbb_dir . '/db/mysql4.php');
      include($phpbb_dir . '/config.php');

      $db_phpbb = &new sql_db($dbhost,$dbuser,$dbpasswd,$dbname);

      if(!$db_phpbb->db_connect_id)
      {
         echo 'Failed to connect to your phpBB database. Verify the settings in conf.php';
         exit;
      }

That will use the same exact code to connect to the DB as the group syncing.

3: The ranks, even after it could connect to the databse were not assigning properly. This is a really simple typo.

In index.php...

Change:

Code: Select all

$sql = "UPDATE " . $table_prefix . "user SET user_rank = '$ranksync' WHERE username = '$name'";
mysql_query($sql);

To:

Code: Select all

$sql = "UPDATE " . $table_prefix . "users SET user_rank = '$ranksync' WHERE username = '$name'";
mysql_query($sql);

Edit: I have written code to clear the ranks of all guild members (this includes site admins!), but it's very specific to my sql database. I still think someone should write a bit of generic code to do this, but it is beyond my knowledge.