View guild members

[TiMz]

Hello. Can someone help me make an NPC that will show a list of all member names of guild_id==100? Just a simple npc with just that.

 

Thank you!

 

 

Hoping it will look something like this.

 

[Poring Guild]    //which is guild_id 100

Members:

Aba

Baba

Caba

Edited February 12, 2014 by Isaiah

[Euphy]

Added the Getguildmember command in eba1539. Please update (or cherry-pick the commit) to be able to use the command.

set .@gid, 100;

mes "[ " + getguildname(.@gid) + " ]";
mes "Members:";
getguildmember .@gid;
if ($@guildmembercount == 0)
	mes "- none - ";
else {
	for (.@i = 0; .@i < $@guildmembercount; .@i++)
		mes $@guildmembername$[.@i];
}
close;

[TiMz]

@euphy Thanks for responding. I can't seem to compile with the new code. I'm guessing my svn is far too outdated for it. (attached error screenie)

 

Thanks though!

Edited February 12, 2014 by Isaiah

[Emistry]

.@guild_id = 100;

query_sql( "SELECT `name`,`position` FROM `guild_member` WHERE `guild_id` = "+.@guild_id+" ORDER BY `position` ",.@name$,.@position );

.@name_size = getarraysize( .@name$ );

for( .@i = 0; .@i < .@name_size; .@i++ )

mes .@name$[.@i]+" | Position: "+.@position[.@i];

close;