memberinst.php (Keylist) not multi-server aware

Roster modified to work with multiple guilds, or characters with no guild
WoWRoster v2.0.0 and later now includes this feature

memberinst.php (Keylist) not multi-server aware

Postby [PUPPETS]Gonzo » Tue Aug 22, 2006 2:39 am

in line 315 it says
Code: Select all
print '<a href="char.php?name='.$row['name'].'&amp;server='.$roster_conf['server_name'].'">'.$row['name'].'</a><br />'.$row['class'].' ('.$row['level'
].')</td>'."\n";

which doesn't help to get a working playerlink :)

Realmname should be displayed together with the charname, too


second: Chars with the same name on different realms seem to bug, too. This is due to "GROUP BY name" in about line 155
User avatar
[PUPPETS]Gonzo
WR.net Apprentice
WR.net Apprentice
 
Posts: 50
Joined: Tue Aug 22, 2006 12:46 am
Location: Frankfurt, Germany

Re: memberinst.php (Keylist) not multi-server aware

Postby [PUPPETS]Gonzo » Tue Aug 22, 2006 2:54 am

a quick hack is to change
Code: Select all
print '<a href="char.php?name='.$row['name'].'&amp;server='.$roster_conf['server_name'].'">'.$row['name'].'</a><br />'.$row['class'].' ('.$row['level'
].')</td>'."\n";


to

Code: Select all
        $snamequery = "SELECT server FROM `".ROSTER_MEMBERSTABLE."` WHERE member_id = '".$row['member_id']."'";
        $snameresult = $wowdb->query($snamequery) or die_quietly($wowdb->error(),'Database Error',basename(__FILE__),__LINE__,$snamequery);
        $snamerow = $wowdb->fetch_array($snameresult);
        print '<a href="char.php?name='.$row['name'].'&amp;server='.$wowdb->escape($snamerow['server']).'">'.$row['name'].'<BR>('.$snamerow['server'].')</a><b
r />'.$row['class'].' ('.$row['level'].')</td>'."\n";

User avatar
[PUPPETS]Gonzo
WR.net Apprentice
WR.net Apprentice
 
Posts: 50
Joined: Tue Aug 22, 2006 12:46 am
Location: Frankfurt, Germany


Return to Public Roster

Who is online

Users browsing this forum: No registered users and 1 guest