Guild Infos

/*
________________     ______            ________
___    |_____  /________  /______      ___  __ \_____
__  /| |  __  /_  __ \_  __ \  _ \     __  /_/ /  __ \
_  ___ / /_/ / / /_/ /  /_/ /  __/     _  _, _// /_/ /
/_/  |_\__,_/  \____//_.___/\___/      /_/ |_| \____/

*/

prontera.gat,153,193,5  script  Guild Infos 966,{
mes "Enter the ^8B0000Guild Name^000000";
input .@search_name$;
.@count = query_sql("SELECT `guild_id`,`name`,`master` FROM `guild` WHERE `name` LIKE '%"+.@search_name$+"%' LIMIT 50", .@gid,.@guild_name$,.@master_name$ );
if( !.@count ){
    mes "No guild found with ^FF0000"+.@search_name$+"^000000.";
}else{
    if( .@count > 1 ){
        mes "Found "+.@count+" guild that match your search..please select a guild.";
        .@i = select( implode( .@guild_name$,":" ) ) - 1;
        next;
        .@gid = .@gid[ .@i ];
        .@guild_name$ = .@guild_name$[ .@i ];
        .@master_name$ = .@master_name$[ .@i ];
    }
    mes "Guild : ";
    mes "^FF0000"+.@guild_name$+"^000000";
    query_sql( "SELECT COUNT(`castle_id`) FROM `guild_castle` WHERE `guild_id`='"+.@gid+"'",.@count );
    mes "Castle(s) : "+(( .@count )? "^FF0000"+.@count+" Castles":"^777777None" )+"^000000";
    mes " ";
    mes "MASTER :";
    mes " > ^FF0000"+.@master_name$+"^000000";
    mes " ";
    mes "MEMBER :";
    query_sql( "SELECT COUNT(`name`),`name` FROM `guild_member` WHERE `guild_id` = '"+.@gid+"' LIMIT 100",.@count,.@guild_member$ );
    if( .@count > 1 ){
        for( .@i = 0; .@i < .@count; .@i++ )
            if( .@guild_member$[.@i] != .@master_name$ )
                mes " > ^FF0000"+.@guild_member$[.@i]+"^000000";
    }else{
        mes "None..";
    }
}
close;
}