AAC Myaac - Maximum guild members

[_M4G0_]

Hello
I want to add maximum number of members in guild in myaac,
Can someone help ?

 

[_M4G0_]

bump

 

[Pedrook]

I don't understand the right php syntax, and the functions of myaac, but I think it's very simple, you will count how many people you already have in the guild_membership, and you will make a condition if it is bigger than you want, don't invite and send an error message.

 

[_M4G0_]

i don't know if it works perfectly ...

if(empty($errors))  {
    $guild_mermrers_invite = $db->query('select player_id, count(player_id) from ' . GUILD_MEMBERS_TABLE . ' WHERE `guild_id` = ' . $guild->getId() . ' group by player_id having count(player_id)');
    if($guild_mermrers_invite->rowCount() >= 15) {
        $errors[] = 'The guild reached maximum  members.';
        }
    }

if someone more experienced can help

 

[slaw]

Almost!

I would do this this way:

if(empty($errors))  {
    $query = $db->query('select count(player_id) as how_much from ' . GUILD_MEMBERS_TABLE . ' WHERE `guild_id` = ' . $guild->getId());
    if($query && $query->rowCount() == 1 && $query->fetch()['how_much'] >= 15) {
        $errors[] = 'The guild reached maximum  members.';
        }
    }

 

[_M4G0_]

Almost!

I would do this this way:

if(empty($errors))  {
    $query = $db->query('select count(player_id) as how_much from ' . GUILD_MEMBERS_TABLE . ' WHERE `guild_id` = ' . $guild->getId());
    if($query && $query->rowCount() == 1 && $query->fetch()['how_much'] >= 15) {
        $errors[] = 'The guild reached maximum  members.';
        }
    }

thanks for reply

 

[matheusmitobr]

Almost!

I would do this this way:

if(empty($errors))  {
    $query = $db->query('select count(player_id) as how_much from ' . GUILD_MEMBERS_TABLE . ' WHERE `guild_id` = ' . $guild->getId());
    if($query && $query->rowCount() == 1 && $query->fetch()['how_much'] >= 15) {
        $errors[] = 'The guild reached maximum  members.';
        }
    }

where do i put it?

 

[matheusjp2]

Almost!

I would do this this way:

if(empty($errors))  {
    $query = $db->query('select count(player_id) as how_much from ' . GUILD_MEMBERS_TABLE . ' WHERE `guild_id` = ' . $guild->getId());
    if($query && $query->rowCount() == 1 && $query->fetch()['how_much'] >= 15) {
        $errors[] = 'The guild reached maximum  members.';
        }
    }