Nice work on the updates to Reputation.

Once problem though. The Sha'tar faction isn't populating with any members data. The previous version of Reputation populated this information (version by Cybrey).

Any ideas?

Its happening on any faction with a ' in the name

Code: Select all

SELECT m.name member, r.faction, r.name fct_name, curr_rep AS value, curr_rep, max_rep, r.standing FROM `roster_reputation` r, roster_members m WHERE r.member_id = m.member_id AND r.name='The Sha\\\'tar' ORDER BY max_rep desc, r.standing DESC, curr_rep DESC

Its overescaped.

remove the wowdb->escape call

Same problem with French faction like "L'oeil pourpre" or "L'Aldor"

removing the wowdb->escape did fix it, including for french locale.

Good tip bbj!

Is this the line you are talking about in the "membersRep.php" file as follows:

Code: Select all

    if( (isset($_REQUEST['factionfilter'])) && (($_REQUEST['factionfilter']) != 'All') )
        $query .= " AND r.name='".$wowdb->escape($_REQUEST['factionfilter'])."'";

I am not sure exactly what to remove here.

change this line

Code: Select all

    if( (isset($_REQUEST['factionfilter'])) && (($_REQUEST['factionfilter']) != 'All') )
        $query .= " AND r.name='".$wowdb->escape($_REQUEST['factionfilter'])."'";

to

Code: Select all

    if( (isset($_REQUEST['factionfilter'])) && (($_REQUEST['factionfilter']) != 'All') )
        $query .= " AND r.name='".$_REQUEST['factionfilter']."'";

Yeah, that did it for a French roster !!

Thanks.