· 8 years ago · Jan 25, 2018, 06:32 PM
1USE [CHARACTER_01_DBF]
2GO
3IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_GuildHouse_Grade_Update]') AND type in (N'P', N'PC'))
4DROP PROCEDURE [dbo].[usp_GuildHouse_Grade_Update]
5GO
6IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_GuildHouse_Name_Update]') AND type in (N'P', N'PC'))
7DROP PROCEDURE [dbo].[usp_GuildHouse_Name_Update]
8GO
9IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_GuildHouse_Tender_Insert]') AND type in (N'P', N'PC'))
10DROP PROCEDURE [dbo].[usp_GuildHouse_Tender_Insert]
11GO
12IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_GuildHouse_Tender_Load]') AND type in (N'P', N'PC'))
13DROP PROCEDURE [dbo].[usp_GuildHouse_Tender_Load]
14GO
15IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_GuildHouse_MaxTender_Load]') AND type in (N'P', N'PC'))
16DROP PROCEDURE [dbo].[usp_GuildHouse_MaxTender_Load]
17GO
18IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_GuildHouse_Tender_Update]') AND type in (N'P', N'PC'))
19DROP PROCEDURE [dbo].[usp_GuildHouse_Tender_Update]
20GO
21IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_GuildHouse_Level_Update]') AND type in (N'P', N'PC'))
22DROP PROCEDURE [dbo].[usp_GuildHouse_Level_Update]
23GO
24/****** Object: StoredProcedure [dbo].[usp_GuildHouse_Grade_Update] Script Date: 04/21/2011 16:52:36 ******/
25SET ANSI_NULLS ON
26GO
27SET QUOTED_IDENTIFIER ON
28GO
29IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_GuildHouse_Grade_Update]') AND type in (N'P', N'PC'))
30BEGIN
31EXEC dbo.sp_executesql @statement = N'/*============================================================
321. ÀÛ¼ºÀÚ : ¹ÚÇý¹Î
332. ÀÛ¼ºÀà : 2010.05.06
343. ½ºÅ©¸³Æ® ¸à : usp_GuildHouse_Grade_Update
354. ½ºÅ©¸³Æ® ¸ñÀû : ±æµå Çÿ콺 ¾÷±×·¹ÀÌÆ®
365. ¸Å°³º¯¼ö
37 serverindex char(2) ¼Â¹ö±º
38 m_idGuild char(6) ±æµå ID
39 dwWorldID int ±æµå Çÿ콺 ±¸ºÃ(¼ÒÇü : 212, Ãခ : 213, ´ëÇü : 213)
40 tKeepTime int ±æµå Çÿ콺 ¸¸·á½Ã°¢
41 dwGuildHouseId int °¢ ¸¶À» º° ±æµå Çÿ콺 ID
42 nAreaIndex int ±æµå Çÿ콺 ¸¶À» À§Ä¡
43 nGuildHouseLevel int ±æµå Çÿ콺 ·¹º§ (ÃßÇüÀö§¸¸ »ç¿ëµÊ)
44 szGuildHouseName varchar(64) ±æµå Çÿ콺 Alias
456. ¸®Åðª
467. ¼öä ³»¿ª
478. »ùÇà ½ÇÇà ÄÚµå
48 EXEC usp_GuildHouse_Grade_Update ''05'', ''123456'', 213, 123456, 1, 1, 2, ''''
499. öȸ ¹× ident °ª ÃʱâÈÂ
50 select * from tblGuildHouse
51 delete tblGuildHouse
52============================================================*/
53
54CREATE proc [dbo].[usp_GuildHouse_Grade_Update]
55 @serverindex char(2)
56 ,@m_idGuild char(6)
57 ,@dwWorldID int
58 ,@tKeepTime int
59 ,@dwGuildHouseId int
60 ,@nAreaIndex int
61 ,@nGuildHouseLevel int
62 ,@szGuildHouseName varchar(64)
63
64as
65
66set nocount on
67set xact_abort on
68
69 if exists ( select * from tblGuildHouse (nolock) where serverindex = @serverindex and m_idGuild = @m_idGuild)
70 begin
71 update tblGuildHouse
72 set dwWorldID = @dwWorldID,
73 tKeepTime = @tKeepTime,
74 dwGuildHouseId = @dwGuildHouseId,
75 nAreaIndex = @nAreaIndex,
76 nGuildHouseLevel = @nGuildHouseLevel,
77 szGuildHouseName = @szGuildHouseName
78 where serverindex = @serverindex and m_idGuild = @m_idGuild
79 end
80
81-- ver.16 usp_GuildHouse_Name_Update Create
82'
83END
84GO
85SET ANSI_NULLS ON
86GO
87SET QUOTED_IDENTIFIER ON
88GO
89IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_GuildHouse_Name_Update]') AND type in (N'P', N'PC'))
90BEGIN
91EXEC dbo.sp_executesql @statement = N'
92
93/*============================================================
941. ÀÛ¼ºÀÚ : ¹ÚÇý¹Î
952. ÀÛ¼ºÀà : 2010.05.06
963. ½ºÅ©¸³Æ® ¸à : usp_GuildHouse_Name_Update
974. ½ºÅ©¸³Æ® ¸ñÀû : ±æµå Çÿ콺 º°Äª ¾÷µ¥ÀÌÆ®
985. ¸Å°³º¯¼ö
99 serverindex char(2) ¼Â¹ö±º
100 m_idGuild char(6) ±æµå ID
101 szGuildHouseName varchar(64) ±æµå Çÿ콺 Alias
1026. ¸®Åðª
1037. ¼öä ³»¿ª
1048. »ùÇà ½ÇÇà ÄÚµå
105 EXEC usp_GuildHouse_Name_Update ''05'', ''123456'', ''¹Ì´Ã·ë''
1069. öȸ ¹× ident °ª ÃʱâÈÂ
107 select * from tblGuildHouse
108 delete tblGuildHouse
109============================================================*/
110
111CREATE proc [dbo].[usp_GuildHouse_Name_Update]
112 @serverindex char(2)
113 ,@m_idGuild char(6)
114 ,@szGuildHouseName varchar(64)
115
116as
117
118set nocount on
119set xact_abort on
120
121 if exists ( select * from tblGuildHouse (nolock) where serverindex = @serverindex and m_idGuild = @m_idGuild)
122 begin
123 update tblGuildHouse
124 set szGuildHouseName = @szGuildHouseName
125 where serverindex = @serverindex and m_idGuild = @m_idGuild
126 end
127
128'
129END
130GO
131SET ANSI_NULLS ON
132GO
133SET QUOTED_IDENTIFIER ON
134GO
135IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_GuildHouse_Tender_Insert]') AND type in (N'P', N'PC'))
136BEGIN
137EXEC dbo.sp_executesql @statement = N'
138/*============================================================
1391. ÀÛ¼ºÀÚ : ¹ÚÇý¹Î
1402. ÀÛ¼ºÀà : 2010.05.06
1413. ½ºÅ©¸³Æ® ¸à : usp_GuildHouse_Tender_Insert
1424. ½ºÅ©¸³Æ® ¸ñÀû : ±æµå Çÿ콺 ÀÔÂû ±â·Ã
1435. ¸Å°³º¯¼ö
144 nTenderId int ÀÔÂû ȸÂ÷
145 nTenderArea int ÀÔÂû Ãö¿ª
146 serverindex char(2) ¼Â¹ö±º
147 m_idGuild char(6) ±æµå ID
148 dwGuildHouseId int ±æµåÇÿ콺 Id
149 nTenderPerin int ÀÔÂû ½Åû Æ丰
150 nTenderPenya int ÀÔÂû ½Åû Æä³Ä
151 chState char(1) ÀÔÂû »óÅÂ
1526. ¸®Åðª
1537. ¼öä ³»¿ª
1548. »ùÇà ½ÇÇà ÄÚµå
155 EXEC usp_GuildHouse_Tender_Insert 1, 123, ''02'', ''000000'', 1, 1, 221214, ''T''
1569. öȸ ¹× ident °ª ÃʱâÈÂ
157 select * from tblGuildHouse_Tender
158 truncate table tblGuildHouse_Tender
159============================================================*/
160
161CREATE proc [dbo].[usp_GuildHouse_Tender_Insert]
162 @nTenderId int
163 ,@nTenderArea int
164 ,@serverindex char(2)
165 ,@m_idGuild char(6)
166 ,@dwGuildHouseId int
167 ,@nTenderPerin int
168 ,@nTenderPenya int
169 ,@chState char(1)
170as
171
172set nocount on
173set xact_abort on
174
175 if exists ( select * from tblGuildHouse (nolock)
176 where serverindex = @serverindex and m_idGuild = @m_idGuild)
177 begin
178 insert into tblGuildHouse_Tender (nTenderId, nTenderArea, serverindex, m_idGuild, dwGuildHouseId,
179 nTenderPerin, nTenderPenya,tTenderTime, chState)
180 values (@nTenderId, @nTenderArea, @serverindex, @m_idGuild, @dwGuildHouseId,
181 @nTenderPerin, @nTenderPenya, getdate(), @chState)
182 end
183
184
185'
186END
187GO
188SET ANSI_NULLS ON
189GO
190SET QUOTED_IDENTIFIER ON
191GO
192IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_GuildHouse_Tender_Load]') AND type in (N'P', N'PC'))
193BEGIN
194EXEC dbo.sp_executesql @statement = N'
195/*============================================================
1961. ÀÛ¼ºÀÚ : ¹ÚÇý¹Î
1972. ÀÛ¼ºÀà : 2010.05.06
1983. ½ºÅ©¸³Æ® ¸à : usp_GuildHouse_Tender_Load
1994. ½ºÅ©¸³Æ® ¸ñÀû : ±æµå Çÿ콺 ÀÔÂû ·Îµå
2005. ¸Å°³º¯¼ö
201 nTenderId int ÀÔÂû ȸÂ÷
202 serverindex char(2) ¼Â¹ö±º
203 chState char(1) ÀÔÂû »óÅÂ
2046. ¸®Åðª
2057. ¼öä ³»¿ª
2068. »ùÇà ½ÇÇà ÄÚµå
207 EXEC usp_GuildHouse_Tender_Load 1, ''01'', ''T''
2089. öȸ ¹× ident °ª ÃʱâÈÂ
209 select * from tblGuildHouse_Tender
210 truncate table tblGuildHouse_Tender
211============================================================*/
212
213CREATE proc [dbo].[usp_GuildHouse_Tender_Load]
214 @nTenderId int
215 ,@serverindex char(2)
216 ,@chState char(1)
217as
218
219set nocount on
220set xact_abort on
221
222 select serverindex, m_idGuild, nTenderId, nTenderArea, dwGuildHouseId, nTenderPerin, nTenderPenya, tTenderTime, chState
223 from tblGuildHouse_Tender (nolock)
224 where nTenderId = @nTenderId and serverindex = @serverindex and chState = @chState
225
226
227'
228END
229GO
230SET ANSI_NULLS ON
231GO
232SET QUOTED_IDENTIFIER ON
233GO
234IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_GuildHouse_MaxTender_Load]') AND type in (N'P', N'PC'))
235BEGIN
236EXEC dbo.sp_executesql @statement = N'CREATE proc [dbo].[usp_GuildHouse_MaxTender_Load]
237 @serverindex char(2)
238as
239
240set nocount on
241set xact_abort on
242
243
244 if exists (select top 10 * from tblGuildHouse_Tender (nolock) where serverindex = @serverindex)
245 begin
246 declare @nTenderId int
247
248 select @nTenderId = isnull(max(nTenderId),0)
249 from tblGuildHouse_Tender (nolock)
250 where serverindex = @serverindex
251
252 select nTenderId, nTenderArea from tblGuildHouse_Tender (nolock)
253 where nTenderId = @nTenderId and serverindex = @serverindex
254
255 return
256 end
257
258 select 0 as nTenderId, 0 as nTenderArea'
259END
260GO
261GO
262/****** Object: StoredProcedure [dbo].[usp_GuildHouse_Tender_Update] Script Date: 04/21/2011 16:52:38 ******/
263SET ANSI_NULLS ON
264GO
265SET QUOTED_IDENTIFIER ON
266GO
267IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_GuildHouse_Tender_Update]') AND type in (N'P', N'PC'))
268BEGIN
269EXEC dbo.sp_executesql @statement = N'
270/*============================================================
2711. ÀÛ¼ºÀÚ : ¹ÚÇý¹Î
2722. ÀÛ¼ºÀà : 2010.05.06
2733. ½ºÅ©¸³Æ® ¸à : usp_GuildHouse_Tender_Update
2744. ½ºÅ©¸³Æ® ¸ñÀû : ±æµå Çÿ콺 ÀÔÂû³»¿ª »óÅ°ª ¾÷µ¥ÀÌÆ®
2755. ¸Å°³º¯¼ö
276 nTenderId int ÀÔÂû ȸÂ÷
277 serverindex char(2) ¼Â¹ö±º
278 m_idGuild char(6) ±æµå ID
279 chState char(1) ÀÔÂû »óÅÂ
2806. ¸®Åðª
2817. ¼öä ³»¿ª
2828. »ùÇà ½ÇÇà ÄÚµå
283 EXEC usp_GuildHouse_Tender_Update 1, ''01'', ''000000'', ''T''
2849. öȸ ¹× ident °ª ÃʱâÈÂ
285 select * from tblGuildHouse_Tender
286 truncate table tblGuildHouse_Tender
287============================================================*/
288
289CREATE proc [dbo].[usp_GuildHouse_Tender_Update]
290 @nTenderId int
291 ,@serverindex char(2)
292 ,@m_idGuild char(6)
293 ,@chState char(1)
294as
295
296set nocount on
297set xact_abort on
298
299 if exists ( select * from tblGuildHouse_Tender (nolock)
300 where serverindex = @serverindex and m_idGuild = @m_idGuild and nTenderId = @nTenderId)
301 begin
302 update tblGuildHouse_Tender
303 set chState = @chState
304 where serverindex = @serverindex and m_idGuild = @m_idGuild and nTenderId = @nTenderId
305 end
306
307'
308END
309GO
310SET ANSI_NULLS ON
311GO
312SET QUOTED_IDENTIFIER ON
313GO
314IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_GuildHouse_Level_Update]') AND type in (N'P', N'PC'))
315BEGIN
316EXEC dbo.sp_executesql @statement = N'
317/*============================================================
3181. ÀÛ¼ºÀÚ : ¹ÚÇý¹Î
3192. ÀÛ¼ºÀà : 2010.05.06
3203. ½ºÅ©¸³Æ® ¸à : usp_GuildHouse_Level_Update
3214. ½ºÅ©¸³Æ® ¸ñÀû : ±æµå Çÿ콺 ·¹º§ ¾÷µ¥ÀÌÆ®
3225. ¸Å°³º¯¼ö
323 serverindex char(2) ¼Â¹ö±º
324 m_idGuild char(6) ±æµå ID
325 nGuildHouseLevel int ÀÔÂû »óÅÂ
3266. ¸®Åðª
3277. ¼öä ³»¿ª
3288. »ùÇà ½ÇÇà ÄÚµå
329 EXEC usp_GuildHouse_Level_Update 1, ''01'', ''000000'', ''T''
3309. öȸ ¹× ident °ª ÃʱâÈÂ
331 select * from tblGuildHouse
332 truncate table tblGuildHouse
333============================================================*/
334
335CREATE proc [dbo].[usp_GuildHouse_Level_Update]
336 @serverindex char(2)
337 ,@m_idGuild char(6)
338 ,@nGuildHouseLevel int
339as
340
341set nocount on
342set xact_abort on
343
344 if exists ( select * from tblGuildHouse (nolock)
345 where serverindex = @serverindex and m_idGuild = @m_idGuild)
346 begin
347 update tblGuildHouse
348 set nGuildHouseLevel = @nGuildHouseLevel
349 where serverindex = @serverindex and m_idGuild = @m_idGuild
350 end
351
352'
353END
354GO
355IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblGuildHouse_Tender]') AND type in (N'U'))
356DROP TABLE [dbo].[tblGuildHouse_Tender]
357GO
358SET ANSI_NULLS ON
359GO
360SET QUOTED_IDENTIFIER ON
361GO
362SET ANSI_PADDING ON
363GO
364IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblGuildHouse_Tender]') AND type in (N'U'))
365BEGIN
366CREATE TABLE [dbo].[tblGuildHouse_Tender](
367 [serverindex] [char](2) NOT NULL,
368 [m_idGuild] [char](6) NOT NULL,
369 [nTenderId] [int] NOT NULL,
370 [nTenderArea] [int] NOT NULL,
371 [dwGuildHouseId] [int] NOT NULL CONSTRAINT [DF_tblGuildHouse_Tender_dwGuildHouseId] DEFAULT ((0)),
372 [nTenderPerin] [int] NULL CONSTRAINT [DF_tblGuildHouse_Tender_nTenderPerin] DEFAULT ((0)),
373 [nTenderPenya] [int] NULL,
374 [tTenderTime] [datetime] NULL CONSTRAINT [DF_tblGuildHouse_Tender_tTenderTime] DEFAULT (getdate()),
375 [chState] [char](1) NULL
376) ON [PRIMARY]
377END
378GO