Guild leveler NPC

[kemids18]

hi i would like to request a Guild leveler Npc Via Quest item Exp. TCG

[Euphy]

atcommand "@glevel "+countitem(7227);
delitem 7227, countitem(7227);

You'll probably need an SQL query to check guild level, in case it ever hits the max.

[kemids18]

thank you master Euphy..how can i make the SQL query to whether the guild Level hits Max?

What happen if there is no SQL query to check max guild level?

[Euphy]

query_sql("SELECT `guild_lv` FROM `guild` WHERE `guild_id` = "+getcharid(2)+";", .@guildlevel);
if (.@guildlevel > 49) {
   dispbottom "This guild has already reached the maximum level.";
   end; }

[kemids18]

Thank You So much!!