Rookies Guild

Results 1 to 6 of 6
  1. #1
    Member rageupxhach is offline
    MemberRank
    Dec 2019 Join Date
    76Posts

    Rookies Guild

    Rookies Guild
    Anyone successfully made a custom rookies guild system? here's mine.

    It works but theres a problem, once you're in the guild your char name wont show in guild menu + unable to leave guild.

    ----- ROOKIES GUILD -----
    DECLARE @RegDate varchar(14)SET
    @RegDate = CONVERT(VARCHAR(14), GETDATE(), 112) + '000000'
    INSERT INTO GuildMember (GuildNo, GuildGrade, CharacterIndex, RegDate, Deleted, GroupIndex, seeOnlineOnly, GuildAxpPoint)
    VALUES (1, 0, @CharacterIdx, @RegDate,'',5, 0, 0)
    ----------------------------
    Would be nice if someone share ideas or discuss in this thread


  2. #2
    Hardcore Member HariSeldon is offline
    MemberRank
    Oct 2019 Join Date
    142Posts

    Re: Rookies Guild

    I created a beginners guild a couple of years ago. Firstly, only online players will be shown in the guild list. Secondly, when the guild overflows, your channels will crash. Scheduled cleaning in the database does not help - you need to clean it manually from the game, which is problematic due to the player display mode (see above).
    As an option, create several guilds for beginners - I think that when overflowing, the next guild will be selected and the crashes will stop. But I did not check it.

  3. #3
    Member rageupxhach is offline
    MemberRank
    Dec 2019 Join Date
    76Posts

    Re: Rookies Guild

    Quote Originally Posted by HariSeldon View Post
    I created a beginners guild a couple of years ago. Firstly, only online players will be shown in the guild list. Secondly, when the guild overflows, your channels will crash. Scheduled cleaning in the database does not help - you need to clean it manually from the game, which is problematic due to the player display mode (see above).
    As an option, create several guilds for beginners - I think that when overflowing, the next guild will be selected and the crashes will stop. But I did not check it.
    That's cool. How'd you do it? I think it will be easier to fix that overflowing once the guild is full, just need a if case statement

  4. #4
    Hardcore Member HariSeldon is offline
    MemberRank
    Oct 2019 Join Date
    142Posts

    Re: Rookies Guild

    Code:
    exec guild_create_for_beginner 'GuildName','GMcharID','0'
    After creating a guild, new players will be automatically invited to join the guild. This is all that is written in my notes. Since I usually write down all the details for myself, most likely no other actions are required.

  5. #5
    Member rageupxhach is offline
    MemberRank
    Dec 2019 Join Date
    76Posts

    Re: Rookies Guild

    Quote Originally Posted by HariSeldon View Post
    Code:
    exec guild_create_for_beginner 'GuildName','GMcharID','0'
    After creating a guild, new players will be automatically invited to join the guild. This is all that is written in my notes. Since I usually write down all the details for myself, most likely no other actions are required.
    oh damn, i didn't no that there's a procedure on it.

  6. #6
    Hardcore Member samus is offline
    MemberRank
    Aug 2014 Join Date
    Managua, NicaraLocation
    103Posts

    Re: Rookies Guild

    https://www.mediafire.com/file/x03xi2mks0btg14/GUILD.txt/file

    TRY RUN THIS



Advertisement