|
You last visited: Today at 13:54
Advertisement
Simple query for union limit
Discussion on Simple query for union limit within the SRO PServer Guides & Releases forum part of the SRO Private Server category.
06/14/2014, 16:05
|
#1
|
elite*gold: 0
Join Date: Feb 2014
Posts: 73
Received Thanks: 30
|
Simple query for union limit
;Hello epvp.
I thought would work for you, because I share it with you
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
/* Credits by Apollo : Skype apollo1337_1*/
PHP Code:
skype; apollo1337_1
|
|
|
06/18/2014, 03:34
|
#2
|
Chat Killer In Duty
elite*gold: 5
Join Date: May 2008
Posts: 16,309
Received Thanks: 6,470
|
#Approved
|
|
|
|
Similar Threads
|
simple +255 gears + attire/casual +255 query
03/28/2020 - EO PServer Guides & Releases - 14 Replies
+255 gears & attire/casual +255 query
-- ----------------------------
-- +255 With elements equipments
-- ----------------------------
update cq_item set eudemon_attack1 ='255', eudemon_attack2 ='255', eudemon_attack3 ='255', eudemon_attack4 ='255', magic3 = '255' , special_effect= '8' where player_id=10000001 and position=1;
update cq_item set eudemon_attack1 ='255', eudemon_attack2 ='255', eudemon_attack3 ='255', eudemon_attack4 ='255', magic3 = '255' , special_effect= '8' where...
|
[Release] Simple Query to Fix F1 Skills bug
12/29/2017 - SRO PServer Guides & Releases - 5 Replies
Since it happens in almost everyserver , i would like to this query |
UPDATE _RefCharDefault_Quest SET Service = 1delete from _CHARQUEST where QuestID = 1
INSERT INTO _CharQuest (CharID, QuestID, Status,AchievementCount,StartTime,EndTime,QuestDat a1,QuestData2) SELECT CharID, 1,5,0, '2012-04-13 20:44:00','2012-04-13 20:44:00',31458135,0 FROM _CHAR where CharID > 0
|
[Request]How to make Job reward coin / Guild limit & union limit
02/12/2014 - SRO Private Server - 1 Replies
Hello everybody hope you are all fine
i want to ask how to add gold coins as a reward from jobbing if trader hunter thief sell their goods they receive the gold coin in guild storage or inventory doesn't matter , waiting for any hints or help :D
&
asking about how to set guild members limit if i want guild to be 32 member only
& union limit to be 4 guilds only
i know it seems big requests but HELPPPPPPPPPPPP xD spam ftw
thanks for reading this
my regards be safe :D
|
[QUESTION] About Union Limit
10/28/2013 - SRO Private Server - 6 Replies
Hello dear friends, I want to know where I can edit to change the union limit of 8 to 4, in sr_gameserver or sro_client!
Can someone please explain me?
|
All times are GMT +2. The time now is 13:54.
|
|