Return of the Pharaohs▣Cap 110▣PvE▣Fresh opening 01.08.2014▣Join us!

Quote:

Originally Posted by wayback what about sun's fron npc are fb?or clean?

Quote:

Originally Posted by hyjdla12 Did the server already start (I don't mean beta)? I'd like to play a nice SRO server finally! :)

Quote:

Originally Posted by oXo™ I wish we knew how to limit the union.

Quote:

Originally Posted by megam oXo what did you add in Holy Water Temple i wish you added gold coins for fair play

Quote:

Originally Posted by oXo™ Yes added gold coins and silver coins.

Quote:

Originally Posted by oame1993 You can make the system add automatically 2 guilds when that person creates a guild and make the system to give an error whenever he tries to ban them

Quote:

Originally Posted by oXo™ I wish we knew how to limit the union.

USE [SRO_VT_SHARD]

GO
/****** Object:  StoredProcedure [dbo].[_Guild_Create]    Script Date: 14.06.2014 16:53:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO




--
ALTER PROCEDURE [dbo].[_Guild_Create]
    @guildName    varchar(64),
    @CreaterID    int
as
    if (exists (select id from _Guild where Name = @guildName))
    begin
        return -1000
    end
    if (exists (select CharID from _GuildMember where CharID = @CreaterID))
    begin
        return -1001
    end
begin transaction
    
    declare @guildID    int
    declare @FoundationDate  smalldatetime
    
    set @FoundationDate = GetDate()
    insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_1', 1, 0, @FoundationDate,0,0)
    insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_2', 1, 0, @FoundationDate,0,0)
    insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_3', 1, 0, @FoundationDate,0,0)
    insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_4', 1, 0, @FoundationDate,0,0)
    insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_5', 1, 0, @FoundationDate,0,0)


    insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName, 5, 0, @FoundationDate,0,0)
    set @guildID = @@identity
    
    if (@@error <> 0 or @@rowcount = 0 or @guildID = 0)
    begin
        rollback transaction
        return -5
    end


    --길드장은 퍼미션이 0xffffffff !!
    declare @rvalue int
    exec @rvalue = _Guild_FnAddMember @guildID, @CreaterID, 0, @FoundationDate,0xffffffff
    if (@@error <> 0 or @rvalue <= 0)
    begin
        rollback transaction
        return @rvalue
    end
    
    -- 길드 창고를 생성하자
    exec @rvalue = _Guild_CreateChest_NoTX @guildID
    if (@@error <> 0 or @rvalue <= 0)
    begin
        rollback transaction
        return @rvalue
    end


commit transaction
    return @guildID

Quote:

Originally Posted by Kevin1337* Code: USE [SRO_VT_SHARD] GO /****** Object: StoredProcedure [dbo].[_Guild_Create] Script Date: 14.06.2014 16:53:19 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ALTER PROCEDURE [dbo].[_Guild_Create] @guildName varchar(64), @CreaterID int as if (exists (select id from _Guild where Name = @guildName)) begin return -1000 end if (exists (select CharID from _GuildMember where CharID = @CreaterID)) begin return -1001 end begin transaction declare @guildID int declare @FoundationDate smalldatetime set @FoundationDate = GetDate() insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_1', 1, 0, @FoundationDate,0,0) insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_2', 1, 0, @FoundationDate,0,0) insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_3', 1, 0, @FoundationDate,0,0) insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_4', 1, 0, @FoundationDate,0,0) insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_5', 1, 0, @FoundationDate,0,0) insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName, 5, 0, @FoundationDate,0,0) set @guildID = @@identity if (@@error <> 0 or @@rowcount = 0 or @guildID = 0) begin rollback transaction return -5 end --길드장은 퍼미션이 0xffffffff !! declare @rvalue int exec @rvalue = _Guild_FnAddMember @guildID, @CreaterID, 0, @FoundationDate,0xffffffff if (@@error <> 0 or @rvalue <= 0) begin rollback transaction return @rvalue end -- 길드 창고를 생성하자 exec @rvalue = _Guild_CreateChest_NoTX @guildID if (@@error <> 0 or @rvalue <= 0) begin rollback transaction return @rvalue end commit transaction return @guildID here you go the query make it 2 as union limit

Quote:

Originally Posted by megam About people who asks for vote4silks it will be disable becasue who has dynamic IP can get huge silks with alot of accounts he will add 2silk/hour to prevent cheats in vote4silks