Addons for Aldor/Scryer reputations comparison

Aldor / Scryer reputation comparison

Moderator: titan99

Addons for Aldor/Scryer reputations comparison

Postby 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
Last edited by titan99 on Wed Feb 07, 2007 6:06 am, edited 1 time in total.
User avatar
titan99
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 129
Joined: Sat Jan 13, 2007 8:11 am
Location: Montpellier - France

Addons for Aldor/Scryer reputations comparison

Postby Nillenda » Tue Feb 06, 2007 11:28 am

thx :thumright:
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:
Nillenda
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Fri Jan 12, 2007 5:12 am

Re: Addons for Aldor/Scryer reputations comparison

Postby 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.
glacius
WR.net Apprentice
WR.net Apprentice
 
Posts: 9
Joined: Sat Jul 15, 2006 3:17 am

Re: Addons for Aldor/Scryer reputations comparison

Postby 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';
Last edited by Kaite on Tue Feb 06, 2007 12:03 pm, edited 1 time in total.
Kaite
WR.net Apprentice
WR.net Apprentice
 
Posts: 10
Joined: Fri Nov 17, 2006 2:49 am

Addons for Aldor/Scryer reputations comparison

Postby cynthetiq » Tue Feb 06, 2007 12:09 pm

thanks nice simple easy mod.
cynthetiq
WR.net Apprentice
WR.net Apprentice
 
Posts: 29
Joined: Sat Oct 21, 2006 10:09 am

Re: Addons for Aldor/Scryer reputations comparison

Postby titan99 » Tue Feb 06, 2007 12:55 pm

new version

tank for your return
Last edited by titan99 on Fri Feb 16, 2007 6:52 pm, edited 1 time in total.
User avatar
titan99
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 129
Joined: Sat Jan 13, 2007 8:11 am
Location: Montpellier - France

Addons for Aldor/Scryer reputations comparison

Postby 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
I <3 /bin/bash
User avatar
PleegWat
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 1636
Joined: Tue Jul 04, 2006 1:43 pm

Addons for Aldor/Scryer reputations comparison

Postby PleegWat » Tue Feb 06, 2007 2:26 pm

There, I think that's all.
I <3 /bin/bash
User avatar
PleegWat
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 1636
Joined: Tue Jul 04, 2006 1:43 pm

Re: Addons for Aldor/Scryer reputations comparison

Postby 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!
glacius
WR.net Apprentice
WR.net Apprentice
 
Posts: 9
Joined: Sat Jul 15, 2006 3:17 am

Addons for Aldor/Scryer reputations comparison

Postby zanix » Tue Feb 06, 2007 9:39 pm

Please submit the addon to the downloads section of the site
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Addons for Aldor/Scryer reputations comparison

Postby titan99 » Wed Feb 07, 2007 3:52 am

it's done
User avatar
titan99
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 129
Joined: Sat Jan 13, 2007 8:11 am
Location: Montpellier - France

Addons for Aldor/Scryer reputations comparison

Postby zanix » Wed Feb 07, 2007 4:41 am

Thanks a bunch...
...approved
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Addons for Aldor/Scryer reputations comparison

Postby 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: :thumright:
Image
ds
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 297
Joined: Sat Jul 08, 2006 9:58 am

Addons for Aldor/Scryer reputations comparison

Postby titan99 » Wed Feb 07, 2007 6:11 am

i'm modify the neutral for don't see faction et reputation level in v0.3
Last edited by titan99 on Wed Feb 07, 2007 7:06 am, edited 1 time in total.
User avatar
titan99
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 129
Joined: Sat Jan 13, 2007 8:11 am
Location: Montpellier - France

Re: Addons for Aldor/Scryer reputations comparison

Postby 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 ?
Last edited by SerialLover on Mon Feb 19, 2007 2:38 pm, edited 1 time in total.
SerialLover
WR.net Apprentice
WR.net Apprentice
 
Posts: 26
Joined: Tue Jul 11, 2006 2:32 pm

Next

Return to Aldor / Scryer

Who is online

Users browsing this forum: No registered users and 0 guests

cron