I haven't looked at the code in question, but if it just depends on file paths, then you're ok if both domains are hosted on the same server. If they're on different servers, then you somehow need to make the files on one appear on the other, perhaps using a NFS mount (Linux thing).

I have the mod installed and it does not give me any errors however it doesn't copy over my resists even though it says it did

http://www.warcraftvision.com


WoW Roster -> phpRaid Guild/Character Synchronization
Attempting to synchronize guilds...
Guild synchronization complete...
Attempting to synchronize characters...
Character synchronization complete...
Data synchronization complete! phpRaid characters and guilds are now synchronized with WoW Roster

You do not have max. resists installed which is a dependancy for this addon.

Think I have this setup correctly but as the other guy said, Im not getting any errors when I click submit it kind of refreshes the page, and doesn't update phpraid, I've got max resists installed also, any ideas?

http://www.shattered-shard.co.uk/roster ... me=phpRaid

http://www.shattered-shard.co.uk/raid/

Roster DB = shard_roster
Phpraid DB = shard_raid

Conf.php =

Code: Select all

<?php
$phpraid_user = 'shard_user';
$phpraid_pass = 'my password';
$phpraid_host = 'localhost';
$phpraid_name = 'shard_raid';
$phpraid_prefix = 'phpraid_';

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

Thanks

Hmm, that's odd

I'm afraid that all I can say atm is that it works for me. Unfortunately I currently don't have a lot of time to dive into these problems.

How does this addon work in a mixed-language-environment? I think I messed up my phpRaid installation due to a sync with the roster.

I am playing on a German server and my guildies are using German and English clients. So there is a mix in the roster table regarding sex, class etc. Syncing works but produces a mix in phpRaid which breaks the whole system!

This mod takes values directly from the roster_players table without any translation applied to it. I'm an English user myself and as such can't check how roster stores the properties on a German roster.
My guess is that the storage of all the data is language independent and that translation is done at display time, but if you want to make sure take phpmyadmin (of other tool of preference) and check the values in the players table.

Diska, that is exactly the problem. People using an EN client have "Priest" as class, for people using a DE client it is "Priester".

I know that this is the wrong place but I would support the internationlisation of CharacterProfiler so that the values in the db are the same nonetheless which language I use to play. Instead adjust the display of wowroster.

The problem right now is that syncing with phpRaid is impossible for international users

For now I solved the problem I had as follows:
-open /roster/addons/phpRaid/index.php
-after line 86 ($name = $char['name'];) add

Code: Select all

if ($char['clientLocale']=="enUS") { 

-after line 90 ($race = $char['race'];) add

Code: Select all

} 

-after "$shadow = $char['max_res_shad'];" add

Code: Select all

if ($char['clientLocale']=="enUS") { 

-after

Code: Select all

                  $sql = "UPDATE " . $phpraid_prefix . "chars 
                          SET class='$class',gender='$gender',race='$race',lvl='$level',
                            arcane='$arcane',fire='$fire',frost='$frost',nature='$nature',shadow='$shadow'
                          WHERE name='$name'";
 

add

Code: Select all


        }
        else {
            $sql = "UPDATE " . $phpraid_prefix . "chars 
                          SET lvl='$level', arcane='$arcane',fire='$fire',frost='$frost',nature='$nature',shadow='$shadow'
                          WHERE name='$name'";
        } 

So the whole block looks like

Code: Select all

            if($wowdb->num_rows($result_char) > 0)
            {
                // found a player name match
                // update the phpraid settings with this user
                $char = $wowdb->fetch_array($result_char);
                
                $name = $char['name'];
        if ($char['clientLocale']=="enUS") {
                  $class = $char['class'];
                  $gender = $char['sex'];
                  $race = $char['race'];
        }
                $level = $char['level'];
                $arcane = $char['max_res_arc'];
                $fire = $char['max_res_fire'];
                $frost = $char['max_res_fro'];
                $nature = $char['max_res_nat'];
                $shadow = $char['max_res_shad'];
                
        if ($char['clientLocale']=="enUS") {
                  $sql = "UPDATE " . $phpraid_prefix . "chars 
                          SET class='$class',gender='$gender',race='$race',lvl='$level',
                            arcane='$arcane',fire='$fire',frost='$frost',nature='$nature',shadow='$shadow'
                          WHERE name='$name'";
        }
        else {
            $sql = "UPDATE " . $phpraid_prefix . "chars 
                          SET lvl='$level', arcane='$arcane',fire='$fire',frost='$frost',nature='$nature',shadow='$shadow'
                          WHERE name='$name'";
        }
                $db_phpraid->sql_query($sql) or die(mysql_error());
 

This updates the resistances for every player but does not touch the class/gender/race if a non enUS locale is used.

Seems to work right now... But I have another question: how is the data calculated. I have installed max resist. but e.g. for Libussa there are all resitances added with 0. Taking a look at Libussa's character sheet shows several resistances available?!

I think I might come to a solution by using the roster localization scheme to translate the strings, but right now I don't have to time to work on this, also, my own server had a hardware failure and my website is temporarily on a friends server so I don't have access to my own "development" environment.

The max.resists values are calculated every time someone uploads their profile. If you want to know more about that I suggest we start a discussion in the appropiate forum for that

Also, please note that I am not the original author of these addons. I just picked it up as they were abandoned and needed to be ported to roster 1.7 which I did with help from others.

Hi guys..

I have my roster and raids on the same database.

i have edited the conf.php file accordingly and copyed the files into the roster addons directory (made a new one called phpraid) ** not sure if i was supposed to do this **

Two things..

Roster (latest version installed with patch) has a new option. phpriad sync when i click this it looks like it just refreshes the screen.

php raid (latest version installed) i ticked the sync with wow roster however when i click update it refreshes the screen back and takes out the tick..

i dont know if this is normal operation or if i have done something wrong..

if anyone has any ideas i would be very greatfull

***********************
SORRY GUYS!!
**********************

i just noticed a tiny little roster update password bit at the bottom of the screen ... nOOb FTW ! lol.. i'll leave this in just incase someone else has the same problem as i

type in the password and it says

The addon "phpRaid" does not exist!

Havent had any luck with this .. i am assuming its wow roster saying it cant find the adon ?


sorry i feel so dumb !

***************
Solved !!!!
****************

I'm still learning so please forgive me .. How was i to know that ...

phpraid = dont work ..
phpRaid = works... Hmm case sensitive .. will note this next time i install something !!

I have max resists installed yet, nothing moves over.

Code: Select all

WoW Roster -> phpRaid Guild/Character Synchronization
Attempting to synchronize guilds...
Guild synchronization complete...
Attempting to synchronize characters...
Character synchronization complete...
Data synchronization complete! phpRaid characters and guilds are now synchronized with WoW Roster

is what I get but nothing moves over.

Noisymisfits.com/roster

I've just uploaded a new version to the downloads section. The only thing this update adds is sql debug statements (sql debugging needs to be turned on in global wowroster config).
If you don't experience any problems this update is not needed.

If you are having problems with phpRaid synchronization please install this version, turn debugging on and try synchronizing. Check out the source of the page you get *after* entering your password and find the SQL debugging comments and see if you can find anything out of the ordinary. If you're in doubt please make a post here and attach the source and I'll have a look at it.

I found where mine is having problems...

Code: Select all

while($roster_guilds = $wowdb->fetch_row($result))

This does not return an associated array. So in the next lines it's not able to find:

Code: Select all

$guild_name = $roster_guilds['guild_name'];

Simply change fetch_row to fetch_array in index.php of this addon on line 58.

Ah, nice catch, thanks a lot! Uploaded a new version now

Is your roster configured for multiple guilds?

Diska wrote:Ah, nice catch, thanks a lot! Uploaded a new version now

Is your roster configured for multiple guilds?

Nope, just one. My Roster and phpRaid are held on different webservers though... I couldn't find a reason (in the code) that you had to know the installation directory of phpRaid.