phpRaid Synchronization Addon [roster 1.7 addon]

This addon will synchronize the resistances of your guild with phpRaid

Moderator: Diska

Re: phpRaid Synchronization Addon [roster 1.7 addon]

Postby acethecase » Sat Sep 23, 2006 12:17 am

hi all.
Installation went well, then when I click on phpRaid sync in roster
another page come up where I have to add roster PW: when I do that I get this error?

WoW Roster -> phpRaid Guild/Character Synchronization

Warning: include(addons/phpraid/db/mysql.php) [function.include]: failed to open stream: No such file or directory in C:\Program\xampp\htdocs\roster\addons\phpRaid\index.php on line 33

Warning: include() [function.include]: Failed opening 'addons/phpraid/db/mysql.php' for inclusion (include_path='.;C:\Program\xampp\php\pear\') in C:\Program\xampp\htdocs\roster\addons\phpRaid\index.php on line 33

Fatal error: Class 'sql_db' not found in C:\Program\xampp\htdocs\roster\addons\phpRaid\index.php on line 35

...thanx...
acethecase
WR.net Apprentice
WR.net Apprentice
 
Posts: 4
Joined: Sun Sep 17, 2006 6:40 am

Re: phpRaid Synchronization Addon [roster 1.7 addon]

Postby Diska » Fri Sep 29, 2006 2:04 pm

Sahasrahla wrote:I couldn't find a reason (in the code) that you had to know the installation directory of phpRaid. :scratch:


Code: Select all
include($phpraid_dir . '/db/mysql.php');

$db_phpraid = &new sql_db($phpraid_host,$phpraid_user,$phpraid_pass,$phpraid_name);


Spiffy (the original author of this addon and author of phpRaid) used his own db connecting functions and therefor this dependency exists. After the port for roster 1.7 quite a few calls to those functions were replaced with $wowdb object calls, but not the lines of code accessing the phpRaid database. It wouldn't be too difficult to recode this so it no longer depends on the phpraid but up till now I've been too lazy for that :)
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 Diska » Fri Sep 29, 2006 2:06 pm

acethecase wrote:hi all.
Installation went well, then when I click on phpRaid sync in roster
another page come up where I have to add roster PW: when I do that I get this error?

WoW Roster -> phpRaid Guild/Character Synchronization

Warning: include(addons/phpraid/db/mysql.php) [function.include]: failed to open stream: No such file or directory in C:\Program\xampp\htdocs\roster\addons\phpRaid\index.php on line 33

Warning: include() [function.include]: Failed opening 'addons/phpraid/db/mysql.php' for inclusion (include_path='.;C:\Program\xampp\php\pear\') in C:\Program\xampp\htdocs\roster\addons\phpRaid\index.php on line 33

Fatal error: Class 'sql_db' not found in C:\Program\xampp\htdocs\roster\addons\phpRaid\index.php on line 35

...thanx...


Edit C:\Program\xampp\htdocs\roster\addons\phpRaid\conf.php and set $phpraid_dir correctly.
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 Splash » Mon Dec 04, 2006 7:24 pm

Another one with

"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 "

Nothing odd in the SQL debug that I can see and max.resists (latest version) has been installed. Do guildies need to re-upload the data for it to be seen in phpRaid?

Ok, looked like the problem might have been that roster and phpraid were using different databases, so I changed the config and reinstalled so that they share the same database - now I get

"WoW Roster -> phpRaid Guild/Character Synchronization<br>
<!-- SELECT * FROM roster_guild -->
Attempting to synchronize guilds...<br>

<!-- SELECT * FROM phpraid_guilds WHERE guild_name='Seeds of Glory' -->

<!-- INSERT INTO phpraid_guilds VALUES('0','None','Seeds of Glory','See') -->
Guild synchronization complete...<br>
<!-- SELECT * FROM phpraid_chars -->
Attempting to synchronize characters...<br>Character synchronization complete...<br>Data synchronization complete! phpRaid characters and guilds are now synchronized with WoW Roster
<!-- Begin Roster Footer -->"

So it now looks in the right place and finds the guild name, but then seems to be looking in the phpraid_guilds table for data - isn't this the table we're trying to populate?
Last edited by Splash on Tue Dec 05, 2006 12:52 am, edited 1 time in total.
Splash
WR.net Apprentice
WR.net Apprentice
 
Posts: 14
Joined: Mon Aug 21, 2006 9:47 pm

phpRaid Synchronization Addon [roster 1.7 addon]

Postby drianna » Thu May 10, 2007 10:58 pm

OK some i must be a bit thick but could someone please tell me where to confirm the name of my phpraid.

Code: Select all
<?php
$phpraid_user = 'user';
$phpraid_pass = 'pass';
$phpraid_host = 'localhost';
$phpraid_name = 'theprop3_nuke1';
$phpraid_prefix = 'phpraid_';

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


I am getting the following after entering the password

WoW Roster -> phpRaid Guild/Character Synchronization
Failed to connect to your phpRaid database. Verify the settings in conf.php

Thanks in advance and I apologise for the noob question but we all have to start somewhere. ;-)
Last edited by drianna on Thu May 10, 2007 10:59 pm, edited 1 time in total.
Image
User avatar
drianna
WR.net Apprentice
WR.net Apprentice
 
Posts: 8
Joined: Mon Oct 23, 2006 8:06 pm

phpRaid Synchronization Addon [roster 1.7 addon]

Postby balador » Wed Aug 08, 2007 10:57 pm

For everyone that doesnt get any error, but also cant get it to synch, here is the solution!
Click submit instead of pressing enter........
Worked for me.
balador
WR.net Apprentice
WR.net Apprentice
 
Posts: 10
Joined: Thu Jul 13, 2006 6:51 pm

Previous

Return to phpRaid Synchronization

Who is online

Users browsing this forum: No registered users and 1 guest

cron