Union Limit - Restrict it to X Guilds

Page 2 of 2 FirstFirst 12
Results 16 to 22 of 22
  1. #16
    Proficient Member Royalblade is offline
    MemberRank
    Jan 2013 Join Date
    167Posts

    Re: Union Limit - Restrict it to X Guilds

    if the removing guild = "automatic guild" -> return -1
    that way itll just give some wierd error msg...

  2. #17

    Re: Union Limit - Restrict it to X Guilds

    Please help we want to work on it

    We want a good explanation

  3. #18
    Proficient Member Royalblade is offline
    MemberRank
    Jan 2013 Join Date
    167Posts

    Re: Union Limit - Restrict it to X Guilds

    Everything you need is i the thread... what else do you need? A proper release with juse "run this query"? xD

  4. #19

    Re: Union Limit - Restrict it to X Guilds

    Quote Originally Posted by Royalblade View Post
    Everything you need is i the thread... what else do you need? A proper release with juse "run this query"? xD
    I want you the right way for me to do so

  5. #20
    Valued Member Wismo is offline
    MemberRank
    Oct 2011 Join Date
    103Posts

    Re: Union Limit - Restrict it to X Guilds

    Hello,

    I did it. Now the guilds will automatically been added.

    But the problem is, after a server restart the guilds are shown in union window and the master can remove them.
    How can we avoid that the master can remove the guild? It is not a stored procedure, the gameserver updates the table _ALLIEDCLANS like this:

    SQL:BatchStarting UPDATE _ALLIEDCLANS SET Ally1=11593,Ally2=11596,Ally3=11597,Ally4=11598,Ally5=11599,Ally6=11600,Ally7=11594,Ally8=0 WHERE ID=136
    SQL:BatchStarting UPDATE _GUILD SET Alliance=0 WHERE ID=11601
    Maybe you can give me a hint?

    Thank you

  6. #21
    Member Molten is offline
    MemberRank
    Jan 2012 Join Date
    52Posts

    Re: Union Limit - Restrict it to X Guilds

    Quote Originally Posted by Wismo View Post
    Hello,

    I did it. Now the guilds will automatically been added.

    But the problem is, after a server restart the guilds are shown in union window and the master can remove them.
    How can we avoid that the master can remove the guild? It is not a stored procedure, the gameserver updates the table _ALLIEDCLANS like this:


    Maybe you can give me a hint?

    Thank you
    Yep, you can alter the _AllianceRemove procedure, simply add an error return if the GuildID is one of the system guilds.

  7. #22
    Valued Member Wismo is offline
    MemberRank
    Oct 2011 Join Date
    103Posts

    Re: Union Limit - Restrict it to X Guilds

    Quote Originally Posted by Molten View Post
    Yep, you can alter the _AllianceRemove procedure, simply add an error return if the GuildID is one of the system guilds.
    The aliance remove procedure is not called when you remove a guild from the union. It will be called if you delete the union. so it would be useless if I change it.

    Thank you



Page 2 of 2 FirstFirst 12

Advertisement