phpRaid Synchronization Addon [roster 1.7 addon]

by **Diska** » Tue Jul 04, 2006 2:39 pm

This addon will synchronise the resistances of your guild with phpRaid

This addon is only usefull if you use phpraid which can be found here: http://www.spiffyjr.com/

This addon depends on the addon Max. Resists, which is available at the WoWroster site as well.

The original mod was written by SpiffyJr, the author of phpRaid. I have simply ported this mod to Roster 1.7

Download can be found in the download section of the WoWroster site.

Setup instructions:

Unpack in your roster addon folder and open conf.php with a text editor and fill in the databsase details of your phpraid database.

by **Squiggle** » Tue Jul 04, 2006 2:48 pm

by **Zovyn** » Tue Jul 04, 2006 5:48 pm

Hiya,

I'm getting an error, any ideas?

WoW Roster -> phpRaid Guild/Character Synchronization
1146: Table 'myhost1_phpraid.roster_guild' doesn't exist

It acts like it expects to find phpraid and roster in the same DB?

by **Diska** » Tue Jul 04, 2006 6:10 pm

What is the name of your roster db?
What is the name of your phpraid db?
What is the content of the conf.php in the phpraid addon dir?

by **Zovyn** » Tue Jul 04, 2006 6:14 pm

Diska wrote:What is the name of your roster db?
What is the name of your phpraid db?
What is the content of the conf.php in the phpraid addon dir?

roster DB = myhost1_roster
phpraid DB = myhost1_phpraid
Conf =
$phpraid_user = 'myhost1_root';
$phpraid_pass = 'mypass';
$phpraid_host = 'localhost';
$phpraid_name = 'myhost1_phpraid';
$phpraid_prefix = 'phpraid_';

// location of phpRaid directory relative to roster
// DO NOT include a trailing slash
$phpraid_dir = '../phpraid';

Hope this helps..

by **Diska** » Tue Jul 04, 2006 8:25 pm

Hmm, that's odd, all queries to roster information are made through the $wowdb object and therefor should use the correct database as far as I know... :scratch:

I hope one of the real devs could give me a hand here...

by **Zovyn** » Tue Jul 04, 2006 8:48 pm

Diska wrote:Hmm, that's odd, all queries to roster information are made through the $wowdb object and therefor should use the correct database as far as I know...

I hope one of the real devs could give me a hand here...

A lot of times I find the addons written in such a way that on a hosted site where you have a DB structure that supports multiple websites that the mod acts funny.

On a dedicated site my DB would simply be phpraid and on a hosted site it has a prefix myhost1_phpraid.

I'm no dev and certainly new to php and mysql so I lack the knowledge to correct the lookups so that they do not assume a common DB or a dedicated structure.

Of course this is just a guess as to whats going one.

Thanks for trying Diska.

by **Diska** » Tue Jul 04, 2006 9:26 pm

Well actually this addon works just fine with different databases. I have phpraid and roster in different databases using different usernames and passwords.

It ought to work :/

by **tonk** » Tue Jul 04, 2006 9:31 pm

I tried it out I get no errors whatsoever However it doesn't update the data?

by **Zovyn** » Wed Jul 05, 2006 1:02 am

Diska wrote:Well actually this addon works just fine with different databases. I have phpraid and roster in different databases using different usernames and passwords.

It ought to work :/

Do your DB's have prefixes on a shared system?

Ex. "myhost1_phpraid"

Or are they dedicated?

Ex. "phpraid"

by **Diska** » Wed Jul 05, 2006 2:15 pm

My databases are named by the following scheme: guildsql1, guildsql2, guildsql3, but that should not matter as they are set names in variables.

by **Zovyn** » Wed Jul 05, 2006 2:40 pm

Diska wrote:My databases are named by the following scheme: guildsql1, guildsql2, guildsql3, but that should not matter as they are set names in variables.

Ahh well, from the error I get it is appending the phpraid DB to the front of what should be my roster DB. I have no idea why it is doing it, I guess I just cant run this mod for whatever reason. /shrug

I appreciate the help,

-Z

by **Diska** » Wed Jul 05, 2006 3:51 pm

Agreed, it should not access the phpraid database for that and I have absolutely no clue why it does that. The $wowdb object is a function from roster itself and should always work on your roster database. That's why I'm hoping that Zanix, AnthonyB, Mathos or another dev could shed some light on this, as I'm afraid my php knowledge is not sufficient to solve this problem.

by **Brakdûr** » Wed Jul 05, 2006 5:23 pm

My question is:

The Roster and the phpRaid are in differnt sub domains (roster.xxx.de and forum.xxx.de/planer/).
So what do I have to use in field

Code: Select all: // location of phpRaid directory relative to roster // DO NOT include a trailing slash $phpraid_dir = '../phpraid';

Thanks for your help

by **Diska** » Wed Jul 05, 2006 6:49 pm

Brakdûr wrote:My question is:

The Roster and the phpRaid are in differnt sub domains (roster.xxx.de and forum.xxx.de/planer/).
So what do I have to use in field
Code: Select all
// location of phpRaid directory relative to roster // DO NOT include a trailing slash $phpraid_dir = '../phpraid';

Thanks for your help

I'm afraid that won't be possible. The php code needs access to php files of your phpraid installation. It has nothing to do with domain names but is about file paths on your server.