prontera,155,155,5 script Guild manager 56,{
.@npc$ = "[ "+ strnpcinfo(1) +" ]";
.@count = query_sql( "SELECT `guild_id`, `name`, `master`, `guild_lv` FROM `guild` ORDER BY `guild_id` ASC limit 128", .@guild_id, .@name$, .@master$, .@guild_lv );
mes .@npc$;
mes " ";
mes "Total: ^FF0000"+ .@count +"^000000 guild"+ ( .@count -1 ? "s." : "." );
mes "Select a guild for more informations.";
next;
.@s = select( implode( .@name$, ":" ) ) -1;
.@size = query_sql( "SELECT `name` FROM `guild_member` WHERE `guild_id`= '"+ .@guild_id[ .@s ] +"'", .@name_m$ );
for( .@i = 0; .@i < .@size; .@i++ )
if( getcharid( 0,.@name_m$[ .@i ] ) ) .@m++;
.@size_alli = query_sql( "SELECT `opposition`, `name` FROM `guild_alliance` WHERE `guild_id`= '"+ .@guild_id[ .@s ] +"'", .@opposition, .@name_alli$ );
for( .@i = 0; .@i < .@size_alli; .@i++ ) {
if( .@opposition[.@i] )
.@good$ = .@good$ + ( getstrlen( .@good$ ) ? ", " : "" ) + .@name_alli$[.@i];
else
.@evil$ = .@evil$ + ( getstrlen( .@evil$ ) ? ", " : "" ) + .@name_alli$[.@i];
}
mes .@npc$;
mes "Guild name: ^FF0000"+ .@name$[ .@s ] +"^000000",
"Master name: ^FFCC00"+ .@master$[ .@s ] +"^000000",
"Guild lvl: ^FF00CC"+ .@guild_lv[ .@s ] +"^000000",
"Members Online: ^0000FF"+ .@m +"^000000",
"Ally: ^CC00CC"+ ( getstrlen( .@evil$ ) ? .@evil$ : "None" ) +"^000000",
"Antagonist: ^CC00CC"+ ( getstrlen( .@good$ ) ? .@good$ : "None" ) +"^000000";
close;
}
EDIT fix some mistakes thanks to caspa