Hi,

I just reinstall the new roster and it works well fine ! Good job !

The only problem I have (for now) is in Spell Book
It generates an SQL Error with spell type [Magie de l'ombre]
The quote in type name breaks the sql syntax

My roster is in french and the game too

This is the link to my roster : http://www.hordeuxsf.com/roster2/
If you want to try, use Vobor (holy priest)

Open addons/info/inc/char.lib.php
Line 587

Find

Code: Select all

$query2 = "SELECT * FROM `" . $roster->db->table('spellbook') . "` WHERE `member_id` = '" . $this->data['member_id'] . "' AND `spell_type` = '$spell_type' ORDER BY `spell_name`;"; 

Replace with

Code: Select all

$query2 = "SELECT * FROM `" . $roster->db->table('spellbook') . "` WHERE `member_id` = '" . $this->data['member_id'] . "' AND `spell_type` = '" . $roster->db->escape($spell_type) . "' ORDER BY `spell_name`;"; 

Oh, and moved to the correct forum

Works perfectly, thanks

And sorry for the wrong section

Humm, this still isn't right, I think the modification didn't make it the last releases.

Code in addons/info/inc/char.lib.phpright now, line 587

Code: Select all


$query2 = "SELECT * FROM `" . $roster->db->table('spellbook') . "` WHERE `member_id` = '" . $this->data['member_id'] . "' AND `spell_type` = '$spell_type' ORDER BY `spell_name`;"; 

The error I saw :
SELECT * FROM `XXroster_spellbook` WHERE `member_id` = '735' AND `spell_type` = 'Magie de l'ombre' ORDER BY `spell_name`;

Normal, this part => 'Magie de l'ombre' is quoted and has quotes in it

The proposed $roster->db->escape($spell_type) is lost /removed again ?

But very needed

It was probably forgotten