Member list Main/Alt

Posts from previous Beta sessions

Member list Main/Alt

Postby Sizuka » Fri Sep 21, 2007 1:29 pm

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 . :oops:

I am running v1.9.9.1337
and you can see my roster here Crimson Glory Roster
User avatar
Sizuka
WR.net Apprentice
WR.net Apprentice
 
Posts: 5
Joined: Thu Feb 22, 2007 8:40 am

Member list Main/Alt

Postby PleegWat » Fri Sep 21, 2007 2:11 pm

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.
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

Member list Main/Alt

Postby Sizuka » Sun Sep 23, 2007 5:23 am

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

Tnx for the help :)
Last edited by Sizuka on Sun Sep 23, 2007 5:24 am, edited 1 time in total.
User avatar
Sizuka
WR.net Apprentice
WR.net Apprentice
 
Posts: 5
Joined: Thu Feb 22, 2007 8:40 am

Member list Main/Alt

Postby PleegWat » Sun Sep 23, 2007 6:27 pm

You're welcome.
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: Member list Main/Alt

Postby MiRai » Thu Oct 11, 2007 9:05 am

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
MiRai
WR.net Apprentice
WR.net Apprentice
 
Posts: 4
Joined: Mon Jan 08, 2007 8:59 am

Member list Main/Alt

Postby zanix » Thu Oct 11, 2007 9:24 am

What version of mysql do you have?
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

Re: Member list Main/Alt

Postby MiRai » Thu Oct 11, 2007 9:44 am

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.
MiRai
WR.net Apprentice
WR.net Apprentice
 
Posts: 4
Joined: Mon Jan 08, 2007 8:59 am

Member list Main/Alt

Postby zanix » Thu Oct 11, 2007 9:56 am

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', " 
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

Re: Member list Main/Alt

Postby MiRai » Thu Oct 11, 2007 10:08 am

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
MiRai
WR.net Apprentice
WR.net Apprentice
 
Posts: 4
Joined: Mon Jan 08, 2007 8:59 am

Member list Main/Alt

Postby zanix » Thu Oct 11, 2007 10:29 am

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
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

Re: Member list Main/Alt

Postby Gator81 » Thu Oct 11, 2007 11:16 am

I dont know if this will be much help but I had to do Alt-mainname and it worked for me fine.
Gator81
WR.net Journeyman
WR.net Journeyman
 
Posts: 115
Joined: Fri Jun 01, 2007 4:44 am

Re: Member list Main/Alt

Postby MiRai » Thu Oct 11, 2007 1:04 pm

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.
Last edited by MiRai on Thu Oct 11, 2007 2:11 pm, edited 1 time in total.
MiRai
WR.net Apprentice
WR.net Apprentice
 
Posts: 4
Joined: Mon Jan 08, 2007 8:59 am

Member list Main/Alt

Postby TRANCEMANIAC » Thu Oct 11, 2007 4:28 pm

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
Guildmaster: Bonaktar (Orc Hunter)
Guild: Die Faust der Verdammnis
Realm: Zirkel des Cenarius [DE]
User avatar
TRANCEMANIAC
WR.net Apprentice
WR.net Apprentice
 
Posts: 11
Joined: Tue Sep 26, 2006 3:01 pm
Location: Germany

Member list Main/Alt

Postby PleegWat » Thu Oct 11, 2007 4:59 pm

The \pL option is listed in the AM manpage. NOte, however, this needs very recent php version (4.4 or 5.2)
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

Member list Main/Alt

Postby Keviel » Fri Nov 09, 2007 9:57 pm

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(!)
Keviel
WR.net Apprentice
WR.net Apprentice
 
Posts: 60
Joined: Fri Oct 19, 2007 7:53 pm
Location: Copenhagen, Denmark

Next

Return to Archived

Who is online

Users browsing this forum: No registered users and 0 guests

cron