Addons for Aldor/Scryer reputations comparison

by **titan99** » Tue Feb 06, 2007 10:30 am

this addons allows to visualize the professions of the guild members according to the faction selected.

for example :
http://guildca.arak-arahm.org/roster/ad ... dor_Scryer

this addons is to develop in French for the other language it is necessary to check the localization file

by **Nillenda** » Tue Feb 06, 2007 11:28 am

thx

I think there is a problem on your SQLrequest.
When i am using it it's give me this message :

1054: Unknown column 'm.member' in 'order clause'
SQL:
SELECT distinct m.member_id, m.name member, r.faction, r.name fct_name, r.curr_rep, r.max_rep, r.standing FROM `roster_reputation` r, roster_members m WHERE r.member_id = m.member_id AND (r.name='L\'Aldor' OR r.name='Les Clairvoyants') ORDER BY max_rep desc, r.standing DESC, curr_rep DESC, m.member DESC
File: neutre.php
Line: 34

I've replaced m.member by m.name and it's good now

ps: sorry for my english :scratch:

by **glacius** » Tue Feb 06, 2007 11:33 am

Very nice addon! :thumright:

Good work!

Got this to work for the English version with the following tweaks done to it:

in localization.php

Code: Select all: $wordings['enUS']['title_addon'] = 'Aldor / Scryers'; $wordings['enUS']['Scryers']= 'The Scryers'; $wordings['enUS']['Aldor'] = 'The Aldor'; $wordings['enUS']['Professions'] = 'Professions'; $wordings['enUS']['rep_name'] = 'Name'; $wordings['enUS']['rep_group'] = 'Side'; $wordings['enUS']['rep_faction'] = 'Faction'; $wordings['enUS']['rep_status'] = 'Standing'; $wordings['enUS']['rep_value'] = 'Value'; $wordings['enUS']['rep_max'] = 'Max';

in neutre.php

Code: Select all: $query = "SELECT distinct m.member_id, m.name member, r.faction, r.name fct_name, r.curr_rep, r.max_rep, r.standing ". "FROM `".ROSTER_REPUTATIONTABLE."` r, ".ROSTER_MEMBERSTABLE." m ". "WHERE r.member_id = m.member_id "; $query .= "AND (r.name='".addslashes($wordings[$roster_conf['roster_lang']]['Aldor'])."' OR r.name='".addslashes($wordings[$roster_conf['roster_lang']]['Scryer'])."') "; $query .= "ORDER BY max_rep desc, r.standing DESC, curr_rep DESC, m.name DESC";

Just replace the code with the above, the query just had the m.member changed to m.name.

The localization file had the faction names corrected to what is actually saved in the database.

Thats about it. Hope this helps others out.

by **Kaite** » Tue Feb 06, 2007 12:03 pm

glacius,

Your localization is still wrong. Change the Scryers line to:

Code: Select all: $wordings['enUS']['Scryer']= 'The Scryers';

by **cynthetiq** » Tue Feb 06, 2007 12:09 pm

thanks nice simple easy mod.

by **titan99** » Tue Feb 06, 2007 12:55 pm

new version

tank for your return

by **PleegWat** » Tue Feb 06, 2007 2:16 pm

Nice addon. One comment: on your example site, characters who are neutral show up twice (once for each faction), which looks kinda messy.

Give me a couple of minutes and I'll set you up a subforum

by **PleegWat** » Tue Feb 06, 2007 2:26 pm

There, I think that's all.

by **glacius** » Tue Feb 06, 2007 5:43 pm

Kaite wrote:glacius,

Your localization is still wrong. Change the Scryers line to:

Code: Select all
$wordings['enUS']['Scryer']= 'The Scryers';

Aye I fixed it afterwards on my site ... forgot to update the post here..

Thanks!

by **zanix** » Tue Feb 06, 2007 9:39 pm

Please submit the addon to the downloads section of the site

by **titan99** » Wed Feb 07, 2007 3:52 am

it's done

by **zanix** » Wed Feb 07, 2007 4:41 am

Thanks a bunch...
...approved

by ds » Wed Feb 07, 2007 4:51 am

Very cool!

I edited the Neutral code not to double the names and excluded the column 'Faction Name'. Will post the code here but is a simple fix and I'm sure you'll do the same -- this is version 0.2 after all.

Again, handy work! :thumleft:

by **titan99** » Wed Feb 07, 2007 6:11 am

i'm modify the neutral for don't see faction et reputation level in v0.3

by **SerialLover** » Mon Feb 19, 2007 2:37 pm

Hello,

First of all, nice job.

I have a issue on my roster with your addon, we are a french guild but some of us use english version of wow, like you can see Roster Rep addon english user are not display (whirl for exemple). I have try a lot of changes but nothing works any idea ?