Getting the guild master from database

[allocen]

As title says, does anyone have an ideea or some tips how can i get the guild master character idx/name from a specific guild?

Update
I solved, so in case anyone needs something like that here is the query:

SELECT CharacterIndex FROM dbo.GuildMember A INNER JOIN GUILDGROUP B ON (A.GUILDNO = B.GUILDNO) AND (A.GROUPINDEX = B.GROUPINDEX) WHERE A.GUILDNO = 1 AND B.GROUPPERMISSION = 495

To get your Guild Master Character Idx you change that bold number in red, your guild number.

 

[LedZeppelin]

or maybe just use:

EXEC SERVER01..[cabal_tool_GetGuildMaster] 1

change 1 to desired guild number.

 

[allocen]

or maybe just use:

EXEC SERVER01..[cabal_tool_GetGuildMaster] 1

change 1 to desired guild number.

Nee, i needed more for a php code and it does work perfectly.

 

[magraopb]

yes, it work