Hi there,

I've taken a look at the Wiki and a quick search on these forums but was unable to find a post with a similar problem.

Our Guildleader had been playing his alt far more often than his main, so he thought he should swap the chars around and make his alt the Guild Leader.

Unfortunately, it seems that Roster didn't much like the change and has confused the order of the ranks with 'King' being lower than 'Queen'. King is the Guild Leader rank.

I have deleted my CharacterProfiler Lua, thinking it was probably using stored data, but that didn't fix it.

Here is our roster: http://www.theorderofhope.org/roster/index.php

Any thoughts?

K

I guess the lack of replies either indicates there is no fix, or that no-one can understand what my problem is.

Well, it's not the end of the world *shrug*.

Thanks for reading anyway.

Sorry, sometimes posts get lost and we forget about them

Look in your CP.lua file (with a text editor) and look for the ["Ranks"] section

Here is what it looks like

Code: Select all

["Ranks"] = {
   ["Index"] = {
      ["Rank5"] = {
         ["Title"] = "Class Leader",
         ["Control"] = "1:1:1:1:1:1:1:0:0:1:0:0:0",
         ["Index"] = 5,
      },
      ["Rank2"] = {
         ["Title"] = "Web Monkey",
         ["Control"] = "1:1:1:1:1:1:1:0:1:1:1:0:0",
         ["Index"] = 2,
      },
      ["Rank9"] = {
         ["Title"] = "New Recruit",
         ["Control"] = "1:1:0:0:0:0:1:0:0:1:0:0:0",
         ["Index"] = 9,
      },
      ["Rank4"] = {
         ["Title"] = "Officer",
         ["Control"] = "1:1:1:1:1:1:1:0:0:1:1:1:0",
         ["Index"] = 4,
      },
      ["Rank8"] = {
         ["Title"] = "Alt",
         ["Control"] = "1:1:0:0:0:0:1:0:0:1:0:0:0",
         ["Index"] = 8,
      },
      ["Rank6"] = {
         ["Title"] = "Banker",
         ["Control"] = "1:1:0:0:0:0:1:0:0:0:0:0:0",
         ["Index"] = 6,
      },
      ["Rank3"] = {
         ["Title"] = "Viceroy",
         ["Control"] = "1:1:1:1:1:1:1:0:1:1:1:1:0",
         ["Index"] = 3,
      },
      ["Rank1"] = {
         ["Title"] = "Guild Master",
         ["Control"] = "1:1:1:1:1:1:1:1:1:1:1:1:1",
         ["Index"] = 1,
      },
      ["Rank7"] = {
         ["Title"] = "Member",
         ["Control"] = "1:1:0:0:0:0:1:0:0:1:0:0:0",
         ["Index"] = 7,
      },
   },
   ["Headers"] = {
      ["Control7"] = "Invite Member",
      ["Control6"] = "Demote",
      ["Control5"] = "Promote",
      ["Control1"] = "Guildchat Listen",
      ["Control2"] = "Guildchat Speak",
      ["Control11"] = "View Officer Note",
      ["Control3"] = "Officerchat Listen",
      ["Control9"] = "Set MOTD",
      ["Control4"] = "Officerchat Speak",
      ["Control12"] = "Edit Officer Note",
      ["Control8"] = "Remove Member",
      ["Control10"] = "Edit Public Note",
   },

Now roster doesn't use this but it's a good indicator of what's going on with your rank sorting

How odd, it looks fine in the lua file, so I guess I'll have to take a peek at what's in the DB. I'll try and investigate further at the weekend and let you know my findings if only as a closure to this query.

Code: Select all

         ["Ranks"] = {
            ["Index"] = {
               ["Rank5"] = {
                  ["Title"] = "Baron",
                  ["Control"] = "1:1:1:1:0:0:1:0:0:1:1:0:0",
                  ["Index"] = 5,
               },
               ["Rank6"] = {
                  ["Title"] = "Vanguard",
                  ["Control"] = "1:1:0:0:0:0:0:0:0:1:1:0:0",
                  ["Index"] = 6,
               },
               ["Rank9"] = {
                  ["Title"] = "Alt",
                  ["Control"] = "1:1:0:0:0:0:0:0:0:0:0:0:0",
                  ["Index"] = 9,
               },
               ["Rank3"] = {
                  ["Title"] = "Archbishop",
                  ["Control"] = "1:1:1:1:1:1:1:1:1:1:1:1:1",
                  ["Index"] = 3,
               },
               ["Rank8"] = {
                  ["Title"] = "Knave",
                  ["Control"] = "1:1:0:0:0:0:0:0:0:0:0:0:0",
                  ["Index"] = 8,
               },
               ["Rank2"] = {
                  ["Title"] = "Queen",
                  ["Control"] = "1:1:1:1:1:1:1:1:1:1:1:1:1",
                  ["Index"] = 2,
               },
               ["Rank4"] = {
                  ["Title"] = "Duke",
                  ["Control"] = "1:1:1:1:0:0:1:1:1:1:1:1:0",
                  ["Index"] = 4,
               },
               ["Rank10"] = {
                  ["Title"] = "Page",
                  ["Control"] = "1:1:0:0:0:0:0:0:0:0:0:0:0",
                  ["Index"] = 10,
               },
               ["Rank1"] = {
                  ["Title"] = "King",
                  ["Control"] = "1:1:1:1:1:1:1:1:1:1:1:1:1",
                  ["Index"] = 1,
               },
               ["Rank7"] = {
                  ["Title"] = "Knight",
                  ["Control"] = "1:1:0:0:0:0:0:0:0:0:0:0:0",
                  ["Index"] = 7,
               },
            },


Do a sql dump of your members table and post the .sql file for me

Now I have this problem as well
http://www.luminality.com/roster/index. ... uild_title

Biglittleguy used to be "Guild Master" and is now a "Web Monkey"
Now Lejeli is the "Guild Master"

As you can see on the link, Biglittleguy still shows up on top like with your problem

I checked out my sql for roster with phpmyadmin
(check the screenshot below)
Roster sorts by 'guild_rank' and not the 'guild_title'
And looking at the screenshot, the 'guild_rank' should be 0 for the "Guild Master" but it is set as 1

I'm gonna do another export for GP and see what happens

I'm having a similar problem. We changed leadership recently, and everyone is showing up as the appropriate rank. However, when you sort by rank, it displays all the officers alphabetically above the new GM in an "Officer" block, and it displays all the officers alphabetically in another "Officer" block. Additionally, the new GM's rank is colored yellow - the same color as officer.
http://www.thehateguild.com/anetheron/?s=guild_title

I just noticed
The rank id's in my db are not maching what the ["Ranks"] section shows in CP.lua

This is my character in the ["Guild"] portion of CP.lua

Code: Select all

["Treyce"] = {
   ["Note"] = "Master of all that is <web>",
   ["Zone"] = "Ironforge",
   ["Group"] = "no",
   ["Class"] = "Hunter",
   ["Online"] = 1,
   ["RankIndex"] = 1,
   ["Status"] = "",
   ["OfficerNote"] = "I lika, do, da cha cha",
   ["Level"] = 48,
   ["Name"] = "Treyce",
   ["Rank"] = "Web Monkey",
},

And this is the rank for "Web Monkey" (thats my guild title)

Code: Select all

      ["Rank2"] = {
         ["Title"] = "Web Monkey",
         ["Control"] = "1:1:1:1:1:1:1:0:1:1:1:0:0",
         ["Index"] = 2,

Notice that the ["RankIndex"] from the member doesn't match the index in ["Ranks"] in ["Guild"]
This might be a CP bug

My fix:

Open admin/update.php

Find

Code: Select all

$guildMembers = $guild['Members']; 

After Add

Code: Select all

// Update the ranks
foreach($guild['Ranks']['Index'] as $rankinfo){
$guildRanks[$rankinfo['Title']] = $rankinfo['Index'];
} 

Find

Code: Select all

$wowdb->update_guild_member($guildId, $char_name, $char, $currentTimestamp); 

Replace with

Code: Select all

$wowdb->update_guild_member($guildId, $char_name, $char, $currentTimestamp, $guildRanks); 

Open lib/wowdb.php
Find

Code: Select all

function update_guild_member( $guildId, $name, $char, $currentTimestamp ) 

Replace with

Code: Select all

function update_guild_member( $guildId, $name, $char, $currentTimestamp, $rank ) 

Find

Code: Select all

if( !empty($char['RankIndex']) )
$this->add_value( 'guild_rank', $char['RankIndex']); 

Replace with

Code: Select all

if( !empty($rank[$char['Rank']]) )
$this->add_value( 'guild_rank', $rank[$char['Rank']]); 

Should now work. Slight problem is that all guild titles must be unique.