phpbb avatar

phpBB integration forum

phpbb avatar

Postby snakou » Sun Apr 01, 2007 5:25 pm

bonjour,
j'ai un petit probleme avec le mod phpbb2 rosterintegrationmod_1.0.4a.
j'ai bien le nom et le level de mon perso qui apparait mais la class et la race n'apparait pas,vous savez pourquoi?
merci de votre aide
http://franck.charlet1.free.fr/roster/phpBB2/

hi,
I have a small problem with the MOD rosterintegrationmod_1.0.4a.
I have the name and it well level of my player who appears but class or race does not appear .
thank you for your assistance
http://franck.charlet1.free.fr/roster/phpBB2/
snakou
WR.net Apprentice
WR.net Apprentice
 
Posts: 36
Joined: Fri Jan 12, 2007 2:02 pm

phpbb avatar

Postby sapphiron » Tue Apr 03, 2007 7:58 pm

Ok, sorry for the delay but Im traveling this week and Im overwhelmed with work and studies.
The first question I must ask is if you can use roster correctly, I mean, if you can upload characters and then watch them.
The second thing I need, is to know if you have correctly set up your roster information in the integration config.
Please post your database name, table prefix and how did you set them up in the mod config.
User avatar
sapphiron
WR.net Apprentice
WR.net Apprentice
 
Posts: 23
Joined: Wed Jan 24, 2007 4:09 pm

phpbb avatar

Postby snakou » Tue Apr 03, 2007 10:23 pm

oki not of problem
here my config.roster
Code: Select all
//roster config file
$roster_table_prefix 'roster_';      //usually roster_
$rosterdbhost 'sql.free.fr';
$rosterdbuser 'franck.charlet1';
$rosterdbpswd '.............';
$rosterdbname 'franck_charlet1';
 

the roster walk well here information http://franck.charlet1.free.fr/roster/c ... entinelles
thank you for your assistance
snakou
WR.net Apprentice
WR.net Apprentice
 
Posts: 36
Joined: Fri Jan 12, 2007 2:02 pm

phpbb avatar

Postby sapphiron » Tue Apr 03, 2007 11:10 pm

ok, are you using a language pack ? please, post a select from the database where you search for player class, sex etc.
User avatar
sapphiron
WR.net Apprentice
WR.net Apprentice
 
Posts: 23
Joined: Wed Jan 24, 2007 4:09 pm

phpbb avatar

Postby snakou » Wed Apr 04, 2007 1:27 am

non using a language pack
snakou
WR.net Apprentice
WR.net Apprentice
 
Posts: 36
Joined: Fri Jan 12, 2007 2:02 pm

phpbb avatar

Postby sapphiron » Wed Apr 04, 2007 1:35 am

enter to your roster database and do:
"SELECT race,sex,level,class FROM roster_players LIMIT 5" (I belive this is the correct query) and post what it shows
Last edited by sapphiron on Wed Apr 04, 2007 1:37 am, edited 1 time in total.
User avatar
sapphiron
WR.net Apprentice
WR.net Apprentice
 
Posts: 23
Joined: Wed Jan 24, 2007 4:09 pm

phpbb avatar

Postby snakou » Wed Apr 04, 2007 1:57 am

here the result
Image
snakou
WR.net Apprentice
WR.net Apprentice
 
Posts: 36
Joined: Fri Jan 12, 2007 2:02 pm

phpbb avatar

Postby snakou » Wed Apr 04, 2007 7:44 pm

no the solution has my problem ?
snakou
WR.net Apprentice
WR.net Apprentice
 
Posts: 36
Joined: Fri Jan 12, 2007 2:02 pm

phpbb avatar

Postby sapphiron » Wed Apr 04, 2007 8:17 pm

sure there is a solution. You have to change my code to match what you see in your screenshot.

In my code change:
Code: Select all
switch($sex)
        {
            case 
"Male":
                
$mainImg $mainImg "0-";
                break;
            case 
'Female':
                
$mainImg $mainImg "1-";
                break;        
        }
        
        switch(
$race)
        {
            case 
'Human':
                
$mainImg $mainImg "1-";
                break;
            case 
'Orc':
                
$mainImg $mainImg "2-";
                break;
            case 
'Dwarf':
                
$mainImg $mainImg "3-";
                break;
            case 
'Night Elf':
                
$mainImg $mainImg "4-";
                break;
            case 
'Undead':
                
$mainImg $mainImg "5-";
                break;
            case 
'Tauren':
                
$mainImg $mainImg "6-";
                break;
            case 
'Gnome':
                
$mainImg $mainImg "7-";
                break;
            case 
'Troll':
                
$mainImg $mainImg "8-";
                break;
            case 
'Blood Elf':
                
$mainImg $mainImg "10-";
                break;
            case 
'Draenei':
                
$mainImg $mainImg "11-";
                break;
        }
        
        switch(
$class)
        {
            case 
'Warrior':
                
$mainImg $mainImg "1";
                
$classImg $classImg "1.gif";
                break;
            case 
'Paladin':
                
$mainImg $mainImg "2";
                
$classImg $classImg "2.gif";
                break;
            case 
'Hunter':
                
$mainImg $mainImg "3";
                
$classImg $classImg "3.gif";
                break;
            case 
'Priest':
                
$mainImg $mainImg "5";
                
$classImg $classImg "5.gif";
                break;
            case 
'Mage':
                
$mainImg $mainImg "8";
                
$classImg $classImg "8.gif";
                break;
            case 
'Shaman':
                
$mainImg $mainImg "7";
                
$classImg $classImg "7.gif";
                break;
            case 
'Rogue':
                
$mainImg $mainImg "4";
                
$classImg $classImg "4.gif";
                break;
            case 
'Warlock':
                
$mainImg $mainImg "9";
                
$classImg $classImg "9.gif";
                break;
            case 
'Druid':
                
$mainImg $mainImg "11";
                
$classImg $classImg "11.gif";
                break;
        }
 


with the correct translation. For example, Male is Homme, Warrior is Guerrier. Watch the CAPS, variables must be the same way they are stored in database.
Example:

Code: Select all
        switch($sex)
        {
            case 
"Homme":
                
$mainImg $mainImg "0-";
                break;
            case 
'Femme':
                
$mainImg $mainImg "1-";
                break;        
        } 


This is usefull for everyone having problems with different languages version of wowroster
User avatar
sapphiron
WR.net Apprentice
WR.net Apprentice
 
Posts: 23
Joined: Wed Jan 24, 2007 4:09 pm

phpbb avatar

Postby snakou » Wed Apr 04, 2007 9:58 pm

is good thx
Mon statue hotmail est : Image
snakou
WR.net Apprentice
WR.net Apprentice
 
Posts: 36
Joined: Fri Jan 12, 2007 2:02 pm


Return to phpBB

Who is online

Users browsing this forum: No registered users and 0 guests

cron