phpRaid Synchronization Addon [roster 1.7 addon]

This addon will synchronize the resistances of your guild with phpRaid

Moderator: Diska

phpRaid Synchronization Addon [roster 1.7 addon]

Postby 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.
Last edited by Diska on Fri Sep 29, 2006 3:28 pm, edited 2 times in total.
User avatar
Diska
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 179
Joined: Tue Jul 04, 2006 2:05 pm

phpRaid Synchronization Addon [roster 1.7 addon]

Postby Squiggle » Tue Jul 04, 2006 2:48 pm

Yay.
Squiggle
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Tue Jul 04, 2006 1:41 pm

phpRaid Synchronization Addon [roster 1.7 addon]

Postby 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?
Last edited by Zovyn on Tue Jul 04, 2006 5:58 pm, edited 1 time in total.
-Zovyn
User avatar
Zovyn
WR.net Apprentice
WR.net Apprentice
 
Posts: 12
Joined: Tue Jul 04, 2006 5:29 pm

Re: phpRaid Synchronization Addon [roster 1.7 addon]

Postby 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?
User avatar
Diska
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 179
Joined: Tue Jul 04, 2006 2:05 pm

Re: phpRaid Synchronization Addon [roster 1.7 addon]

Postby 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..
-Zovyn
User avatar
Zovyn
WR.net Apprentice
WR.net Apprentice
 
Posts: 12
Joined: Tue Jul 04, 2006 5:29 pm

Re: phpRaid Synchronization Addon [roster 1.7 addon]

Postby 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...
User avatar
Diska
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 179
Joined: Tue Jul 04, 2006 2:05 pm

Re: phpRaid Synchronization Addon [roster 1.7 addon]

Postby 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... :scratch:

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. :)
Last edited by Zovyn on Tue Jul 04, 2006 8:49 pm, edited 1 time in total.
-Zovyn
User avatar
Zovyn
WR.net Apprentice
WR.net Apprentice
 
Posts: 12
Joined: Tue Jul 04, 2006 5:29 pm

phpRaid Synchronization Addon [roster 1.7 addon]

Postby 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 :/
User avatar
Diska
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 179
Joined: Tue Jul 04, 2006 2:05 pm

Re: phpRaid Synchronization Addon [roster 1.7 addon]

Postby tonk » Tue Jul 04, 2006 9:31 pm

I tried it out I get no errors whatsoever However it doesn't update the data?
User avatar
tonk
WR.net Apprentice
WR.net Apprentice
 
Posts: 6
Joined: Tue Jul 04, 2006 4:47 pm

Re: phpRaid Synchronization Addon [roster 1.7 addon]

Postby 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"
-Zovyn
User avatar
Zovyn
WR.net Apprentice
WR.net Apprentice
 
Posts: 12
Joined: Tue Jul 04, 2006 5:29 pm

phpRaid Synchronization Addon [roster 1.7 addon]

Postby 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.
Last edited by Diska on Wed Jul 05, 2006 2:16 pm, edited 1 time in total.
User avatar
Diska
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 179
Joined: Tue Jul 04, 2006 2:05 pm

Re: phpRaid Synchronization Addon [roster 1.7 addon]

Postby 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
-Zovyn
User avatar
Zovyn
WR.net Apprentice
WR.net Apprentice
 
Posts: 12
Joined: Tue Jul 04, 2006 5:29 pm

Re: phpRaid Synchronization Addon [roster 1.7 addon]

Postby 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.
User avatar
Diska
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 179
Joined: Tue Jul 04, 2006 2:05 pm

phpRaid Synchronization Addon [roster 1.7 addon]

Postby 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
User avatar
Brakdûr
WR.net Apprentice
WR.net Apprentice
 
Posts: 4
Joined: Tue Jul 04, 2006 4:07 pm

Re: phpRaid Synchronization Addon [roster 1.7 addon]

Postby 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.
User avatar
Diska
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 179
Joined: Tue Jul 04, 2006 2:05 pm

Next

Return to phpRaid Synchronization

Who is online

Users browsing this forum: No registered users and 0 guests

cron