Sorry but after over 2-3 hours search in the forum ...
(i read almost everything about beta)
I didn't find anything about how main/alt shows

As long as we have many alts in my guild i would like to make my Roster like
this one --> Other Roster
Can anyone tell me how the search for alts work ? (Main/Alt relations)
Wile i was trying some change with a wrong search Regex i had damage my
database and i wasn't able to bring it back ( i just full reinstall the Roster )
Is there a list of commands that i can used ?
Sorry if already is answered somewhere else but i can't find anything that can help me ...
i am a real noob , i can't figure out what happen .

I am running v1.9.9.1337
and you can see my roster here Crimson Glory Roster

You aren't using a single rule for designating mains and alts. I'm seeing the following systems in your notes:

Mainname's alt
Mainnames alt
Mainname alt
Mainname imba alt

Make your members switch to a single system. All of the above should work fine. Also make sure your your members spell their main name correctly in their alt's notes.

Yes that's it !
Sorry ... was very stupid to ask something like that...
Now everything is working fine

Tnx for the help

You're welcome.

I hate to revive this question, but I cannot get my main/alt system to work either. We use public notes to show professions so I'm using Officer's notes for alt recognition. I used the following format:

Mainname's alt

I changed all characters with the Twink/Alt rank in our guild. I had left 'alt' in the alt-search-text. After that I got an idea and changed it to 'Mainname's alt' and that triggered this error which makes my roster no longer viewable.

Code: Select all

1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's alt%',1,0) AS 'isalt', FLOOR(`level`/10) AS label FROM `roster_members` WHERE ' at line 1
SQL:
SELECT count(`member_id`) AS `amount`, IF(`officer_note` LIKE '%Mainname's alt%',1,0) AS 'isalt', FLOOR(`level`/10) AS label FROM `roster_members` WHERE `level` >= 10 AND `guild_id` = '1' GROUP BY isalt, label;
File: lib/dbal/mysql.php
Line: 203
Backtrace (most recent call last):

    * lib/functions.lib.php
          o Line: 240
          o Function Called: backtrace
    * lib/dbal/mysql.php
          o Line: 203
          o Function Called: die_quietly
          o Arguments:
                + 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's alt%',1,0) AS 'isalt', FLOOR(`level`/10) AS label FROM `roster_members` WHERE ' at line 1
                + Database Error
                + /home/content/f/e/n/fenril/html/roster/lib/dbal/mysql.php
                + 203
                + SELECT count(`member_id`) AS `amount`, IF(`officer_note` LIKE '%Mainname's alt%',1,0) AS 'isalt', FLOOR(`level`/10) AS label FROM `roster_members` WHERE `level` >= 10 AND `guild_id` = '1' GROUP BY isalt, label;
    * lib/menu.php
          o Line: 415
          o Function Called: query
          o Arguments:
                + SELECT count(`member_id`) AS `amount`, IF(`officer_note` LIKE '%Mainname's alt%',1,0) AS 'isalt', FLOOR(`level`/10) AS label FROM `roster_members` WHERE `level` >= 10 AND `guild_id` = '1' GROUP BY isalt, label;
    * lib/menu.php
          o Line: 312
          o Function Called: makelist
          o Arguments:
                + level
                + 10
                + list
                + menu_left
    * lib/menu.php
          o Line: 40
          o Function Called: makepane
          o Arguments:
                + menu_left
    * index.php
          o Line: 130
          o Function Called: makemenu
          o Arguments:
                + Array ( [0] => util [1] => realm [2] => guild )


I looked around in a few of the files listed above but couldn't find where to revert my alt-text-search options manually. I'd like to get this cleared up so I can figure out how to work the main/alt system.

Thank You

What version of mysql do you have?

I'm sorry but I'm not sure where to pull that information up. I use godaddy.com for hosting and I know that I have the option of MySQL 4 or 5 when I create a database. I had chosen MySQL 5 for the WoWRoster database. Upon installing the newest beta of WoWRoster all test's passed. It was up and running just fine until I decided to edit the 'alt-text-search' field to "Mainname's alt". I could always reinstall it but I had everything configured nicely before I ran into this crash.

The error is in menu.php, not memberslist

First of all members list uses it's own alt string that is configured via RosterCP->Members List->Main/Alt Relations

The other alt config is in RosterCP->Configure Main Roster->Defaults Config
This is only used in the menu at the moment

You found a bug in fact!
You set this to "Mainname's alt" which is messing up the SQL string

This should be more generic, like just "alt"


To fix the bug
Open lib/menu.php
Find

Code: Select all

. "IF(`" . $roster->config['alt_location'] . "` LIKE '%" . $roster->config['alt_type'] . "%',1,0) AS 'isalt', " 

Replace with

Code: Select all

. "IF(`" . $roster->db->escape($roster->config['alt_location']) . "` LIKE '%" . $roster->db->escape($roster->config['alt_type']) . "%',1,0) AS 'isalt', " 

Well I'm glad I could be of help

But I had been using 'alt' all along and after changing all Officer's notes to "Mainname's alt" the memberlist is still showing alts separate from mains. I tried Title/Public Note/Officer Note and it won't recognize it. Do I have to set "Mainname's main" under Officer notes as well? I'm glad that my big problem is fixed....now I'm just trying to get my main/alt system working.

Thanks

Code: Select all

/([\w]+)'s alt/i

This should work for you

Remember that you need to hit "Save Settings" then "Update Relations" to apply the new setting

I dont know if this will be much help but I had to do Alt-mainname and it worked for me fine.

zanix wrote:

Code: Select all

/([\w]+)'s alt/i

This should work for you

Remember that you need to hit "Save Settings" then "Update Relations" to apply the new setting

Not exactly sure where I should put that code? Sorry I'm new to editing code, but I'm not scared to jump in and change things up. Since I've been trying to get the main/alt feature to work, on the log after updating the guild roster it has always shown:

memberslist - No main match - Main - No alts

So I know it's trying to look for them. But is it weird that it shows that message for every character on the roster, including the characters who should be mains? All main character Officer notes have not been edited at all.

I also tried the "Alt-mainname" and with no luck. This doesn't seem like a difficult thing to do as I've browsed through others' WoWRoster guild setups and they seem to be having no trouble at all. Sorry for all this bother on what seems to be a simple task, but I really don't think I'm missing anything too obvious as there aren't many settings to change.

Thanks


*EDIT*
Thanks I actually was missing something in the long run. It's late here and I had been messing with it all day. Thank you for the help and the quick replies.

Hello MiRai,

i had much problems in the begining too, than i understand what the code is doing.

In our officer note set nothing, when it's a mainchar.
If it is a twink/alt i set in the officer note:

MainChar: Bonaktar

The code is looking for the correct typing "MainChar:" all other behind is the name of the mainchar.

For working with UTF8 characters i have set

Code: Select all

/MainChar: ([\pL]+)/

and yes, it works fine. The ([\pL]+) allows you to use special characters in the names like öäüß ÖÄÜ âÂêÊôÔ áÁéÉóÓ and so on...

Please don't forget to upload the new memberlist with the admin password.
Without it will only update your characters, but not the main/alt/twink assignment.

If you like, take a look at our roster2 beta.

Hope it helps you.

TRANCY

The \pL option is listed in the AM manpage. NOte, however, this needs very recent php version (4.4 or 5.2)

I use the following

/([\pL]+)('s|') (alt|Alt)/

This takes care of several issues.

1) it allows for inconsistencies between alt and Alt
2) In English, names ending in an s, shouldn't get 's, but just ' (e.g. Ennas' alt)
3) Allows for special characters in names

I have NO idea whether this is the correct way to do it, but it works(!)