Guild limit script

[Fresh prince]

Hello rathena!

Im requesting a script that will check the number of your guild members and if it's over 30 members when entering a castle, you will be warped in prontera saying that "your guild members are over the limit".

Can you please include and array for certain castles like gondul and sacre altar to be restricted only for my request.

Thank you masters!

[Patskie]

- query_sql "SELECT `connect_member` FROM `guild` WHERE `guild_id` = '" +getcharid(2)+ "'",.@c;

+ query_sql "SELECT `guild_lv` FROM `guild` WHERE `guild_id` = '" +getcharid(2)+ "'",.@c;

- if ( .@c > 30 ) {

+ if ( .@c > 11 ) {

[Shio Devs]

Prince this topic has already been discussed, Search is your best tutor ever. You can't do it with just script, you need some sql in there too. Check the link for more info.

 

http://rathena.org/board/topic/57869-guild-level-check/

Edited December 16, 2013 by Shio Devs

[-SkittleNugget-]

You could edit the source to change the max members to 30, unless this is for a one off castle of course.

[Fresh prince]

A script that contains a sql query i understand that of course.

Your link did not exactly hit home but gave me an idea in how to make one.

I saw the source edit as well but didn't need to go that far. Planned just for an event or so.

Thanks masters for your attention and directions!

[Patskie]

This will check the online member only and if the online members are > 30 then they can't enter the castle : http://pastebin.com/raw.php?i=j716V4Ru

[Fresh prince]

Sir pats you mean the first 30 can get in but the 31st above will get warp out?

Thanks a lot!!

[Patskie]

No it's not. You want it that way? My script will check if online members of your guild is > 30. In the castle or not. If so, all guild members who enters the guild_vs1 will be warped out. 

[Fresh prince]

It it possible tht instead of checking whos online,

It check for the guild level instead like say it should be equal or less than guild level 11. If your guild level is above 11, you will be warp away once you get in. That way the guild was set to 30 people automatically.

The concern about your script master pat is say woe is about to end for example and a guild has been defending a castle for an hour already (30 members) then the last seconds the 31st member logs in O.O

Disaster >.< Thanks master pat!

[Fresh prince]

Thanks master!

[Fresh prince]

Sir pats I just tested this it doesn't wok.

 

: http://pastebin.com/raw.php?i=j716V4Ru

 

please help

[AnnieRuru]

don't use query_sql here

use attachrid-on-all-accounts addrid better

[paste=dbdfw23gsxm]