· 7 years ago · Oct 19, 2018, 11:30 AM
1USE [master]
2GO
3/****** Object: Database [Pangya] Script Date: 19/10/2018 08:23:23 ******/
4CREATE DATABASE [Pangya]
5 CONTAINMENT = NONE
6 ON PRIMARY
7( NAME = N'Pangya', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL14.SQL\MSSQL\DATA\Pangya.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
8 LOG ON
9( NAME = N'Pangya_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL14.SQL\MSSQL\DATA\Pangya_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
10GO
11IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
12begin
13EXEC [Pangya].[dbo].[sp_fulltext_database] @action = 'enable'
14end
15GO
16ALTER DATABASE [Pangya] SET ANSI_NULL_DEFAULT OFF
17GO
18ALTER DATABASE [Pangya] SET ANSI_NULLS OFF
19GO
20ALTER DATABASE [Pangya] SET ANSI_PADDING OFF
21GO
22ALTER DATABASE [Pangya] SET ANSI_WARNINGS OFF
23GO
24ALTER DATABASE [Pangya] SET ARITHABORT OFF
25GO
26ALTER DATABASE [Pangya] SET AUTO_CLOSE OFF
27GO
28ALTER DATABASE [Pangya] SET AUTO_SHRINK OFF
29GO
30ALTER DATABASE [Pangya] SET AUTO_UPDATE_STATISTICS ON
31GO
32ALTER DATABASE [Pangya] SET CURSOR_CLOSE_ON_COMMIT OFF
33GO
34ALTER DATABASE [Pangya] SET CURSOR_DEFAULT GLOBAL
35GO
36ALTER DATABASE [Pangya] SET CONCAT_NULL_YIELDS_NULL OFF
37GO
38ALTER DATABASE [Pangya] SET NUMERIC_ROUNDABORT OFF
39GO
40ALTER DATABASE [Pangya] SET QUOTED_IDENTIFIER OFF
41GO
42ALTER DATABASE [Pangya] SET RECURSIVE_TRIGGERS OFF
43GO
44ALTER DATABASE [Pangya] SET DISABLE_BROKER
45GO
46ALTER DATABASE [Pangya] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
47GO
48ALTER DATABASE [Pangya] SET DATE_CORRELATION_OPTIMIZATION OFF
49GO
50ALTER DATABASE [Pangya] SET TRUSTWORTHY OFF
51GO
52ALTER DATABASE [Pangya] SET ALLOW_SNAPSHOT_ISOLATION OFF
53GO
54ALTER DATABASE [Pangya] SET PARAMETERIZATION SIMPLE
55GO
56ALTER DATABASE [Pangya] SET READ_COMMITTED_SNAPSHOT OFF
57GO
58ALTER DATABASE [Pangya] SET HONOR_BROKER_PRIORITY OFF
59GO
60ALTER DATABASE [Pangya] SET RECOVERY SIMPLE
61GO
62ALTER DATABASE [Pangya] SET MULTI_USER
63GO
64ALTER DATABASE [Pangya] SET PAGE_VERIFY CHECKSUM
65GO
66ALTER DATABASE [Pangya] SET DB_CHAINING OFF
67GO
68ALTER DATABASE [Pangya] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
69GO
70ALTER DATABASE [Pangya] SET TARGET_RECOVERY_TIME = 60 SECONDS
71GO
72ALTER DATABASE [Pangya] SET DELAYED_DURABILITY = DISABLED
73GO
74USE [Pangya]
75GO
76/****** Object: UserDefinedFunction [dbo].[UDF_ITEM_SERIAL] Script Date: 19/10/2018 08:23:23 ******/
77SET ANSI_NULLS ON
78GO
79SET QUOTED_IDENTIFIER ON
80GO
81
82
83CREATE FUNCTION [dbo].[UDF_ITEM_SERIAL] (
84 @TID INT
85)
86RETURNS INT
87--
88AS
89
90/********************************************************
91** ITEM ì˜ SERIAL NO. 를 리턴함(ìºë””, í´ëŸ½)
92********************************************************/
93BEGIN
94 RETURN @TID - (DBO.UDF_PARTS_GROUP(@TID)* POWER(2, 26))
95END
96
97
98GO
99/****** Object: UserDefinedFunction [dbo].[UDF_PARTS_GROUP] Script Date: 19/10/2018 08:23:23 ******/
100SET ANSI_NULLS ON
101GO
102SET QUOTED_IDENTIFIER ON
103GO
104
105
106CREATE FUNCTION [dbo].[UDF_PARTS_GROUP] (
107 @TID INT
108)
109RETURNS INT
110--
111AS
112
113BEGIN
114 RETURN (@TID & (0xfc000000)) / POWER(2, 26)
115END
116
117
118GO
119/****** Object: UserDefinedFunction [dbo].[UNIX_TIMESTAMP] Script Date: 19/10/2018 08:23:23 ******/
120SET ANSI_NULLS ON
121GO
122SET QUOTED_IDENTIFIER ON
123GO
124CREATE FUNCTION [dbo].[UNIX_TIMESTAMP] (
125 @DATETIME DATETIME
126)
127RETURNS INTEGER
128AS
129BEGIN
130 DECLARE @Return INTEGER
131
132 SELECT @Return = DATEDIFF(SECOND,{TS '1970-01-01 07:00:00'}, @DATETIME)
133
134 RETURN @Return
135END
136GO
137/****** Object: Table [dbo].[Achievement_Counter_Data] Script Date: 19/10/2018 08:23:23 ******/
138SET ANSI_NULLS ON
139GO
140SET QUOTED_IDENTIFIER ON
141GO
142CREATE TABLE [dbo].[Achievement_Counter_Data](
143 [ID] [int] IDENTITY(1,1) NOT NULL,
144 [Enable] [tinyint] NOT NULL,
145 [Name] [varchar](500) NOT NULL,
146 [TypeID] [int] NOT NULL,
147 CONSTRAINT [PK_Achievement_Counter_Data] PRIMARY KEY CLUSTERED
148(
149 [ID] ASC
150)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
151) ON [PRIMARY]
152GO
153/****** Object: Table [dbo].[Achievement_Data] Script Date: 19/10/2018 08:23:23 ******/
154SET ANSI_NULLS ON
155GO
156SET QUOTED_IDENTIFIER ON
157GO
158CREATE TABLE [dbo].[Achievement_Data](
159 [ID] [int] IDENTITY(1,1) NOT NULL,
160 [ACHIEVEMENT_ENABLE] [tinyint] NOT NULL,
161 [ACHIEVEMENT_TYPEID] [int] NOT NULL,
162 [ACHIEVEMENT_NAME] [varchar](500) NOT NULL,
163 [ACHIEVEMENT_QUEST_TYPEID] [int] NOT NULL
164) ON [PRIMARY]
165GO
166/****** Object: Index [IX_Achievement_Data] Script Date: 19/10/2018 08:23:23 ******/
167CREATE CLUSTERED INDEX [IX_Achievement_Data] ON [dbo].[Achievement_Data]
168(
169 [ACHIEVEMENT_QUEST_TYPEID] ASC
170)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
171GO
172/****** Object: Table [dbo].[Achievement_QuestItem] Script Date: 19/10/2018 08:23:23 ******/
173SET ANSI_NULLS ON
174GO
175SET QUOTED_IDENTIFIER ON
176GO
177CREATE TABLE [dbo].[Achievement_QuestItem](
178 [ID] [int] IDENTITY(1,1) NOT NULL,
179 [TypeID] [int] NULL,
180 [Name] [varchar](255) NULL,
181 [QuestTypeID] [int] NULL
182) ON [PRIMARY]
183GO
184/****** Object: Table [dbo].[Achievement_QuestStuffs] Script Date: 19/10/2018 08:23:23 ******/
185SET ANSI_NULLS ON
186GO
187SET QUOTED_IDENTIFIER ON
188GO
189CREATE TABLE [dbo].[Achievement_QuestStuffs](
190 [ID] [int] IDENTITY(1,1) NOT NULL,
191 [Enable] [tinyint] NOT NULL,
192 [TypeID] [int] NOT NULL,
193 [Name] [varchar](500) NOT NULL,
194 [CounterTypeID] [int] NOT NULL,
195 [CounterQuantity] [int] NOT NULL
196) ON [PRIMARY]
197GO
198/****** Object: Index [IX_Achievement_QuestStuffs_1] Script Date: 19/10/2018 08:23:23 ******/
199CREATE CLUSTERED INDEX [IX_Achievement_QuestStuffs_1] ON [dbo].[Achievement_QuestStuffs]
200(
201 [TypeID] ASC
202)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
203GO
204/****** Object: Table [dbo].[ATEST] Script Date: 19/10/2018 08:23:23 ******/
205SET ANSI_NULLS ON
206GO
207SET QUOTED_IDENTIFIER ON
208GO
209CREATE TABLE [dbo].[ATEST](
210 [test1] [varchar](255) NULL,
211 [test2] [varchar](255) NULL,
212 [test3] [varchar](255) NULL
213) ON [PRIMARY]
214GO
215/****** Object: Table [dbo].[Daily_Quest] Script Date: 19/10/2018 08:23:23 ******/
216SET ANSI_NULLS ON
217GO
218SET QUOTED_IDENTIFIER ON
219GO
220CREATE TABLE [dbo].[Daily_Quest](
221 [ID] [int] IDENTITY(1,1) NOT NULL,
222 [QuestTypeID1] [int] NOT NULL,
223 [QuestTypeID2] [int] NOT NULL,
224 [QuestTypeID3] [int] NOT NULL,
225 [RegDate] [datetime] NULL,
226 [Day] [tinyint] NULL
227) ON [PRIMARY]
228GO
229/****** Object: Table [dbo].[Pangya_Achievement] Script Date: 19/10/2018 08:23:23 ******/
230SET ANSI_NULLS ON
231GO
232SET QUOTED_IDENTIFIER ON
233GO
234CREATE TABLE [dbo].[Pangya_Achievement](
235 [UID] [int] NOT NULL,
236 [TypeID] [int] NOT NULL,
237 [ID] [int] IDENTITY(1,1) NOT NULL,
238 [Type] [tinyint] NOT NULL,
239 [Valid] [tinyint] NULL,
240 CONSTRAINT [PK__Pangya_A__0E4FF547FE082235] PRIMARY KEY CLUSTERED
241(
242 [ID] ASC,
243 [UID] ASC,
244 [Type] ASC
245)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
246) ON [PRIMARY]
247GO
248/****** Object: Table [dbo].[Pangya_Achievement_Counter] Script Date: 19/10/2018 08:23:23 ******/
249SET ANSI_NULLS ON
250GO
251SET QUOTED_IDENTIFIER ON
252GO
253CREATE TABLE [dbo].[Pangya_Achievement_Counter](
254 [ID] [int] IDENTITY(1,1) NOT NULL,
255 [UID] [int] NOT NULL,
256 [TypeID] [int] NOT NULL,
257 [Quantity] [int] NOT NULL,
258PRIMARY KEY CLUSTERED
259(
260 [ID] ASC,
261 [UID] ASC
262)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
263) ON [PRIMARY]
264GO
265/****** Object: Table [dbo].[Pangya_Achievement_Quest] Script Date: 19/10/2018 08:23:23 ******/
266SET ANSI_NULLS ON
267GO
268SET QUOTED_IDENTIFIER ON
269GO
270CREATE TABLE [dbo].[Pangya_Achievement_Quest](
271 [ID] [int] IDENTITY(1,1) NOT NULL,
272 [UID] [int] NOT NULL,
273 [Achievement_Index] [int] NOT NULL,
274 [Achivement_Quest_TypeID] [int] NOT NULL,
275 [Counter_Index] [int] NOT NULL,
276 [SuccessDate] [datetime] NULL,
277 [Count] [int] NOT NULL,
278 CONSTRAINT [PK__Pangya_A__0E4FF5475F9FCA8B] PRIMARY KEY CLUSTERED
279(
280 [ID] ASC,
281 [UID] ASC,
282 [Achievement_Index] ASC
283)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
284) ON [PRIMARY]
285GO
286/****** Object: Table [dbo].[Pangya_Caddie] Script Date: 19/10/2018 08:23:23 ******/
287SET ANSI_NULLS ON
288GO
289SET QUOTED_IDENTIFIER ON
290GO
291CREATE TABLE [dbo].[Pangya_Caddie](
292 [CID] [int] IDENTITY(1,1) NOT NULL,
293 [UID] [int] NOT NULL,
294 [TYPEID] [int] NOT NULL,
295 [EXP] [int] NOT NULL,
296 [cLevel] [tinyint] NOT NULL,
297 [SKIN_TYPEID] [int] NULL,
298 [RentFlag] [tinyint] NULL,
299 [RegDate] [datetime] NULL,
300 [END_DATE] [datetime] NULL,
301 [SKIN_END_DATE] [datetime] NULL,
302 [TriggerPay] [tinyint] NULL,
303 [VALID] [tinyint] NOT NULL,
304 CONSTRAINT [PK_Pangya_Caddie] PRIMARY KEY CLUSTERED
305(
306 [CID] ASC,
307 [UID] ASC
308)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
309) ON [PRIMARY]
310GO
311/****** Object: Table [dbo].[Pangya_Card] Script Date: 19/10/2018 08:23:23 ******/
312SET ANSI_NULLS ON
313GO
314SET QUOTED_IDENTIFIER ON
315GO
316CREATE TABLE [dbo].[Pangya_Card](
317 [CARD_IDX] [int] IDENTITY(1,1) NOT NULL,
318 [UID] [int] NOT NULL,
319 [CARD_TYPEID] [int] NOT NULL,
320 [QTY] [int] NOT NULL,
321 [RegData] [datetime] NULL,
322 [VALID] [tinyint] NULL,
323 CONSTRAINT [PK_Pangya_Card] PRIMARY KEY CLUSTERED
324(
325 [CARD_IDX] ASC
326)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
327) ON [PRIMARY]
328GO
329/****** Object: Table [dbo].[Pangya_Card_Equip] Script Date: 19/10/2018 08:23:23 ******/
330SET ANSI_NULLS ON
331GO
332SET QUOTED_IDENTIFIER ON
333GO
334CREATE TABLE [dbo].[Pangya_Card_Equip](
335 [ID] [int] IDENTITY(1,1) NOT NULL,
336 [UID] [int] NOT NULL,
337 [CID] [int] NOT NULL,
338 [CHAR_TYPEID] [int] NULL,
339 [CARD_TYPEID] [int] NULL,
340 [SLOT] [int] NULL,
341 [REGDATE] [datetime] NULL,
342 [ENDDATE] [datetime] NULL,
343 [FLAG] [tinyint] NULL,
344 [VALID] [tinyint] NULL,
345 CONSTRAINT [PK__Pangya_C__A690D8C0177C89E1] PRIMARY KEY CLUSTERED
346(
347 [UID] ASC,
348 [ID] ASC
349)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
350) ON [PRIMARY]
351GO
352/****** Object: Table [dbo].[Pangya_Character] Script Date: 19/10/2018 08:23:23 ******/
353SET ANSI_NULLS ON
354GO
355SET QUOTED_IDENTIFIER ON
356GO
357CREATE TABLE [dbo].[Pangya_Character](
358 [CID] [int] IDENTITY(1,1) NOT NULL,
359 [UID] [int] NOT NULL,
360 [TYPEID] [int] NOT NULL,
361 [GIFT_FLAG] [tinyint] NULL,
362 [HAIR_COLOR] [tinyint] NULL,
363 [POWER] [tinyint] NULL,
364 [CONTROL] [tinyint] NULL,
365 [IMPACT] [tinyint] NULL,
366 [SPIN] [tinyint] NULL,
367 [CURVE] [tinyint] NULL,
368 [CUTIN] [int] NULL,
369 [AUX_1] [int] NULL,
370 [AUX_2] [int] NULL,
371PRIMARY KEY CLUSTERED
372(
373 [CID] ASC
374)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
375) ON [PRIMARY]
376GO
377/****** Object: Table [dbo].[Pangya_Character_Equip] Script Date: 19/10/2018 08:23:23 ******/
378SET ANSI_NULLS ON
379GO
380SET QUOTED_IDENTIFIER ON
381GO
382CREATE TABLE [dbo].[Pangya_Character_Equip](
383 [EQUIP_IDX] [int] IDENTITY(1,1) NOT NULL,
384 [UID] [int] NOT NULL,
385 [CHAR_IDX] [int] NOT NULL,
386 [PART_TYPEID_1] [int] NULL,
387 [PART_TYPEID_2] [int] NULL,
388 [PART_TYPEID_3] [int] NULL,
389 [PART_TYPEID_4] [int] NULL,
390 [PART_TYPEID_5] [int] NULL,
391 [PART_TYPEID_6] [int] NULL,
392 [PART_TYPEID_7] [int] NULL,
393 [PART_TYPEID_8] [int] NULL,
394 [PART_TYPEID_9] [int] NULL,
395 [PART_TYPEID_10] [int] NULL,
396 [PART_TYPEID_11] [int] NULL,
397 [PART_TYPEID_12] [int] NULL,
398 [PART_TYPEID_13] [int] NULL,
399 [PART_TYPEID_14] [int] NULL,
400 [PART_TYPEID_15] [int] NULL,
401 [PART_TYPEID_16] [int] NULL,
402 [PART_TYPEID_17] [int] NULL,
403 [PART_TYPEID_18] [int] NULL,
404 [PART_TYPEID_19] [int] NULL,
405 [PART_TYPEID_20] [int] NULL,
406 [PART_TYPEID_21] [int] NULL,
407 [PART_TYPEID_22] [int] NULL,
408 [PART_TYPEID_23] [int] NULL,
409 [PART_TYPEID_24] [int] NULL,
410 [PART_IDX_1] [int] NULL,
411 [PART_IDX_2] [int] NULL,
412 [PART_IDX_3] [int] NULL,
413 [PART_IDX_4] [int] NULL,
414 [PART_IDX_5] [int] NULL,
415 [PART_IDX_6] [int] NULL,
416 [PART_IDX_7] [int] NULL,
417 [PART_IDX_8] [int] NULL,
418 [PART_IDX_9] [int] NULL,
419 [PART_IDX_10] [int] NULL,
420 [PART_IDX_11] [int] NULL,
421 [PART_IDX_12] [int] NULL,
422 [PART_IDX_13] [int] NULL,
423 [PART_IDX_14] [int] NULL,
424 [PART_IDX_15] [int] NULL,
425 [PART_IDX_16] [int] NULL,
426 [PART_IDX_17] [int] NULL,
427 [PART_IDX_18] [int] NULL,
428 [PART_IDX_19] [int] NULL,
429 [PART_IDX_20] [int] NULL,
430 [PART_IDX_21] [int] NULL,
431 [PART_IDX_22] [int] NULL,
432 [PART_IDX_23] [int] NULL,
433 [PART_IDX_24] [int] NULL,
434PRIMARY KEY CLUSTERED
435(
436 [CHAR_IDX] ASC
437)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
438) ON [PRIMARY]
439GO
440/****** Object: Table [dbo].[Pangya_Club_Info] Script Date: 19/10/2018 08:23:23 ******/
441SET ANSI_NULLS ON
442GO
443SET QUOTED_IDENTIFIER ON
444GO
445CREATE TABLE [dbo].[Pangya_Club_Info](
446 [ITEM_ID] [int] NOT NULL,
447 [C0_SLOT] [smallint] NULL,
448 [C1_SLOT] [smallint] NULL,
449 [C2_SLOT] [smallint] NULL,
450 [C3_SLOT] [smallint] NULL,
451 [C4_SLOT] [smallint] NULL,
452 [CLUB_POINT] [int] NULL,
453 [CLUB_WORK_COUNT] [int] NULL,
454 [CLUB_SLOT_CANCEL] [int] NULL,
455 [CLUB_POINT_TOTAL_LOG] [int] NULL,
456 [CLUB_UPGRADE_PANG_LOG] [int] NULL,
457 CONSTRAINT [PK_Pangya_Club_Info_1] PRIMARY KEY CLUSTERED
458(
459 [ITEM_ID] ASC
460)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
461) ON [PRIMARY]
462GO
463/****** Object: Table [dbo].[Pangya_Daily_Quest] Script Date: 19/10/2018 08:23:23 ******/
464SET ANSI_NULLS ON
465GO
466SET QUOTED_IDENTIFIER ON
467GO
468CREATE TABLE [dbo].[Pangya_Daily_Quest](
469 [ID] [int] IDENTITY(1,1) NOT NULL,
470 [UID] [int] NOT NULL,
471 [QuestID1] [int] NULL,
472 [QuestID2] [int] NULL,
473 [QuestID3] [int] NULL,
474 [LastAccept] [datetime] NULL,
475 [LastCancel] [datetime] NULL,
476 [RegDate] [datetime] NULL,
477PRIMARY KEY CLUSTERED
478(
479 [UID] ASC
480)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
481) ON [PRIMARY]
482GO
483/****** Object: Table [dbo].[Pangya_Exception_Log] Script Date: 19/10/2018 08:23:23 ******/
484SET ANSI_NULLS ON
485GO
486SET QUOTED_IDENTIFIER ON
487GO
488CREATE TABLE [dbo].[Pangya_Exception_Log](
489 [ExceptionID] [int] IDENTITY(1,1) NOT NULL,
490 [UID] [int] NULL,
491 [Username] [varchar](50) NULL,
492 [ExceptionMessage] [varchar](2000) NULL,
493 [Server] [varchar](50) NULL,
494 [CreateDate] [datetime] NULL
495) ON [PRIMARY]
496GO
497/****** Object: Table [dbo].[Pangya_Friend] Script Date: 19/10/2018 08:23:23 ******/
498SET ANSI_NULLS ON
499GO
500SET QUOTED_IDENTIFIER ON
501GO
502CREATE TABLE [dbo].[Pangya_Friend](
503 [Owner] [varchar](50) NOT NULL,
504 [Friend] [varchar](50) NOT NULL,
505 [IsAccept] [tinyint] NOT NULL,
506 [GroupName] [varchar](50) NOT NULL,
507 [IsAgree] [tinyint] NOT NULL,
508 [IsDeleted] [tinyint] NOT NULL,
509 [Memo] [varchar](20) NOT NULL,
510 [IsBlock] [tinyint] NOT NULL
511) ON [PRIMARY]
512GO
513/****** Object: Table [dbo].[Pangya_Game_Macro] Script Date: 19/10/2018 08:23:23 ******/
514SET ANSI_NULLS ON
515GO
516SET QUOTED_IDENTIFIER ON
517GO
518CREATE TABLE [dbo].[Pangya_Game_Macro](
519 [UID] [int] NOT NULL,
520 [Macro1] [varchar](45) NULL,
521 [Macro2] [varchar](45) NULL,
522 [Macro3] [varchar](45) NULL,
523 [Macro4] [varchar](45) NULL,
524 [Macro5] [varchar](45) NULL,
525 [Macro6] [varchar](45) NULL,
526 [Macro7] [varchar](45) NULL,
527 [Macro8] [varchar](45) NULL,
528 [Macro9] [varchar](45) NULL,
529 [Macro10] [varchar](45) NULL
530) ON [PRIMARY]
531GO
532/****** Object: Table [dbo].[Pangya_Guild_Emblem] Script Date: 19/10/2018 08:23:23 ******/
533SET ANSI_NULLS ON
534GO
535SET QUOTED_IDENTIFIER ON
536GO
537CREATE TABLE [dbo].[Pangya_Guild_Emblem](
538 [EMBLEM_IDX] [int] IDENTITY(1,1) NOT NULL,
539 [GUILD_ID] [int] NOT NULL,
540 [GUILD_MARK_IMG] [varchar](50) NULL,
541 [GUILD_MARK_ISVALID] [tinyint] NULL,
542 CONSTRAINT [PK_Pangya_Guild_Emblem] PRIMARY KEY CLUSTERED
543(
544 [GUILD_ID] ASC
545)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
546) ON [PRIMARY]
547GO
548/****** Object: Table [dbo].[Pangya_Guild_Info] Script Date: 19/10/2018 08:23:23 ******/
549SET ANSI_NULLS ON
550GO
551SET QUOTED_IDENTIFIER ON
552GO
553CREATE TABLE [dbo].[Pangya_Guild_Info](
554 [GUILD_INDEX] [int] IDENTITY(1,1) NOT NULL,
555 [GUILD_NAME] [varchar](255) NOT NULL,
556 [GUILD_INTRODUCING] [varchar](255) NULL,
557 [GUILD_NOTICE] [varchar](255) NULL,
558 [GUILD_LEADER_UID] [int] NOT NULL,
559 [GUILD_POINT] [int] NULL,
560 [GUILD_PANG] [int] NULL,
561 [GUILD_IMAGE] [varchar](10) NULL,
562 [GUILD_IMAGE_KEY_UPLOAD] [int] NULL,
563 [GUILD_CREATE_DATE] [datetime] NULL,
564 [GUILD_VALID] [tinyint] NULL,
565 CONSTRAINT [PK_Pangya_Guild_Info] PRIMARY KEY CLUSTERED
566(
567 [GUILD_INDEX] ASC
568)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
569) ON [PRIMARY]
570GO
571/****** Object: Table [dbo].[Pangya_Guild_Log] Script Date: 19/10/2018 08:23:23 ******/
572SET ANSI_NULLS ON
573GO
574SET QUOTED_IDENTIFIER ON
575GO
576CREATE TABLE [dbo].[Pangya_Guild_Log](
577 [UID] [int] NOT NULL,
578 [GUILD_ID] [int] NOT NULL,
579 [GUILD_NAME] [varchar](32) NULL,
580 [GUILD_ACTION] [tinyint] NOT NULL,
581 [GUILD_ACTION_DATE] [datetime] NULL
582) ON [PRIMARY]
583GO
584/****** Object: Table [dbo].[Pangya_Guild_Member] Script Date: 19/10/2018 08:23:23 ******/
585SET ANSI_NULLS ON
586GO
587SET QUOTED_IDENTIFIER ON
588GO
589CREATE TABLE [dbo].[Pangya_Guild_Member](
590 [GUILD_ID] [int] NOT NULL,
591 [GUILD_MEMBER_UID] [int] NOT NULL,
592 [GUILD_POSITION] [tinyint] NULL,
593 [GUILD_MESSAGE] [varchar](255) NULL,
594 [GUILD_ENTERED_TIME] [datetime] NULL,
595 [GUILD_MEMBER_STATUS] [tinyint] NULL,
596 CONSTRAINT [PK_Pangya_Guild_Member] PRIMARY KEY CLUSTERED
597(
598 [GUILD_ID] ASC,
599 [GUILD_MEMBER_UID] ASC
600)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
601) ON [PRIMARY]
602GO
603/****** Object: Table [dbo].[Pangya_Item_Daily] Script Date: 19/10/2018 08:23:23 ******/
604SET ANSI_NULLS ON
605GO
606SET QUOTED_IDENTIFIER ON
607GO
608CREATE TABLE [dbo].[Pangya_Item_Daily](
609 [ID] [int] IDENTITY(1,1) NOT NULL,
610 [ItemTypeID] [int] NOT NULL,
611 [Quantity] [int] NULL,
612 [DATE] [date] NULL
613) ON [PRIMARY]
614GO
615/****** Object: Table [dbo].[Pangya_Item_Daily_Log] Script Date: 19/10/2018 08:23:23 ******/
616SET ANSI_NULLS ON
617GO
618SET QUOTED_IDENTIFIER ON
619GO
620CREATE TABLE [dbo].[Pangya_Item_Daily_Log](
621 [ID] [int] IDENTITY(1,1) NOT NULL,
622 [UID] [int] NOT NULL,
623 [ItemTypeID] [int] NOT NULL,
624 [Quantity] [int] NOT NULL,
625 [Date] [date] NULL
626) ON [PRIMARY]
627GO
628/****** Object: Table [dbo].[Pangya_Locker_Item] Script Date: 19/10/2018 08:23:23 ******/
629SET ANSI_NULLS ON
630GO
631SET QUOTED_IDENTIFIER ON
632GO
633CREATE TABLE [dbo].[Pangya_Locker_Item](
634 [INVEN_ID] [int] IDENTITY(1,1) NOT NULL,
635 [UID] [int] NOT NULL,
636 [TypeID] [int] NULL,
637 [Name] [varchar](255) NULL,
638 [FROM_ID] [int] NULL,
639 [Valid] [tinyint] NULL,
640PRIMARY KEY CLUSTERED
641(
642 [UID] ASC,
643 [INVEN_ID] ASC
644)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
645) ON [PRIMARY]
646GO
647/****** Object: Table [dbo].[Pangya_Mail] Script Date: 19/10/2018 08:23:23 ******/
648SET ANSI_NULLS ON
649GO
650SET QUOTED_IDENTIFIER ON
651GO
652CREATE TABLE [dbo].[Pangya_Mail](
653 [Mail_Index] [int] IDENTITY(1,1) NOT NULL,
654 [UID] [int] NOT NULL,
655 [Sender] [varchar](20) NULL,
656 [Sender_UID] [int] NULL,
657 [Receiver] [varchar](20) NULL,
658 [Receiver_UID] [int] NULL,
659 [Subject] [varchar](200) NULL,
660 [Msg] [varchar](2500) NULL,
661 [ReadDate] [smalldatetime] NULL,
662 [ReceiveDate] [smalldatetime] NULL,
663 [DeleteDate] [smalldatetime] NULL,
664 [RegDate] [datetime] NULL,
665 CONSTRAINT [PK_Pangya_Mail] PRIMARY KEY CLUSTERED
666(
667 [Mail_Index] ASC
668)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
669) ON [PRIMARY]
670GO
671/****** Object: Table [dbo].[Pangya_Mail_Item] Script Date: 19/10/2018 08:23:23 ******/
672SET ANSI_NULLS ON
673GO
674SET QUOTED_IDENTIFIER ON
675GO
676CREATE TABLE [dbo].[Pangya_Mail_Item](
677 [Mail_Index] [int] NOT NULL,
678 [TYPEID] [int] NOT NULL,
679 [SETTYPEID] [int] NULL,
680 [QTY] [int] NULL,
681 [DAY] [smallint] NULL,
682 [UCC_UNIQUE] [varchar](8) NULL,
683 [ITEM_GRP] [tinyint] NULL,
684 [TO_UID] [int] NULL,
685 [IN_DATE] [datetime] NULL,
686 [RELEASE_DATE] [datetime] NULL,
687 [APPLY_ITEM_ID] [int] NULL,
688 CONSTRAINT [PK_Pangya_Mail_Item] PRIMARY KEY CLUSTERED
689(
690 [Mail_Index] ASC,
691 [TYPEID] ASC
692)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
693) ON [PRIMARY]
694GO
695/****** Object: Table [dbo].[Pangya_Mail_SetItem] Script Date: 19/10/2018 08:23:23 ******/
696SET ANSI_NULLS ON
697GO
698SET QUOTED_IDENTIFIER ON
699GO
700CREATE TABLE [dbo].[Pangya_Mail_SetItem](
701 [MAIL_IDX] [int] NOT NULL,
702 [TYPE_ID] [int] NULL,
703 [QTY] [int] NULL,
704 [DAY] [smallint] NULL,
705 [IN_DATE] [datetime] NULL,
706 CONSTRAINT [PK_Pangya_Mail_SetItem] PRIMARY KEY CLUSTERED
707(
708 [MAIL_IDX] ASC
709)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
710) ON [PRIMARY]
711GO
712/****** Object: Table [dbo].[Pangya_Map_Statistics] Script Date: 19/10/2018 08:23:23 ******/
713SET ANSI_NULLS ON
714GO
715SET QUOTED_IDENTIFIER ON
716GO
717CREATE TABLE [dbo].[Pangya_Map_Statistics](
718 [ID] [int] IDENTITY(1,1) NOT NULL,
719 [UID] [int] NOT NULL,
720 [Map] [smallint] NOT NULL,
721 [Drive] [int] NOT NULL,
722 [Putt] [int] NOT NULL,
723 [Hole] [int] NOT NULL,
724 [Fairway] [int] NOT NULL,
725 [Holein] [int] NOT NULL,
726 [PuttIn] [int] NOT NULL,
727 [TotalScore] [int] NOT NULL,
728 [BestScore] [smallint] NOT NULL,
729 [MaxPang] [int] NOT NULL,
730 [CharTypeId] [int] NOT NULL,
731 [EventScore] [tinyint] NOT NULL,
732 [Assist] [tinyint] NOT NULL,
733 [REGDATE] [smalldatetime] NULL,
734 CONSTRAINT [PK__Pangya_M__59C8E1BEBE7D7FE0] PRIMARY KEY CLUSTERED
735(
736 [UID] ASC,
737 [Map] ASC
738)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
739) ON [PRIMARY]
740GO
741/****** Object: Table [dbo].[Pangya_Mascot] Script Date: 19/10/2018 08:23:23 ******/
742SET ANSI_NULLS ON
743GO
744SET QUOTED_IDENTIFIER ON
745GO
746CREATE TABLE [dbo].[Pangya_Mascot](
747 [MID] [int] IDENTITY(1,1) NOT NULL,
748 [UID] [int] NOT NULL,
749 [MASCOT_TYPEID] [int] NOT NULL,
750 [MESSAGE] [varchar](50) NULL,
751 [DateEnd] [datetime] NULL,
752 [VALID] [tinyint] NULL
753) ON [PRIMARY]
754GO
755/****** Object: Table [dbo].[Pangya_Member] Script Date: 19/10/2018 08:23:23 ******/
756SET ANSI_NULLS ON
757GO
758SET QUOTED_IDENTIFIER ON
759GO
760CREATE TABLE [dbo].[Pangya_Member](
761 [UID] [int] IDENTITY(1,1) NOT NULL,
762 [Username] [varchar](16) NOT NULL,
763 [Password] [varchar](50) NOT NULL,
764 [IDState] [tinyint] NULL,
765 [FirstSet] [tinyint] NULL,
766 [LastLogonTime] [datetime] NULL,
767 [Logon] [tinyint] NULL,
768 [Nickname] [varchar](16) NULL,
769 [Sex] [tinyint] NULL,
770 [IPAddress] [varchar](50) NULL,
771 [LogonCount] [int] NULL,
772 [Capabilities] [tinyint] NULL,
773 [RegDate] [datetime] NULL,
774 [AuthKey_Login] [varchar](7) NULL,
775 [AuthKey_Game] [varchar](7) NULL,
776 [GUILDINDEX] [int] NULL,
777 [DailyLoginCount] [int] NULL,
778 CONSTRAINT [PK_pangya_member] PRIMARY KEY CLUSTERED
779(
780 [UID] ASC
781)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
782) ON [PRIMARY]
783GO
784/****** Object: Table [dbo].[Pangya_Memorial_Log] Script Date: 19/10/2018 08:23:23 ******/
785SET ANSI_NULLS ON
786GO
787SET QUOTED_IDENTIFIER ON
788GO
789CREATE TABLE [dbo].[Pangya_Memorial_Log](
790 [LogID] [int] IDENTITY(1,1) NOT NULL,
791 [UID] [int] NULL,
792 [ItemName] [varchar](255) NULL,
793 [Quantity] [int] NULL,
794 [DateIN] [datetime] NULL,
795PRIMARY KEY CLUSTERED
796(
797 [LogID] ASC
798)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
799) ON [PRIMARY]
800GO
801/****** Object: Table [dbo].[Pangya_Personal] Script Date: 19/10/2018 08:23:23 ******/
802SET ANSI_NULLS ON
803GO
804SET QUOTED_IDENTIFIER ON
805GO
806CREATE TABLE [dbo].[Pangya_Personal](
807 [UID] [int] NOT NULL,
808 [CookieAmt] [int] NULL,
809 [PangLockerAmt] [int] NULL,
810 [LockerPwd] [varchar](4) NULL,
811PRIMARY KEY CLUSTERED
812(
813 [UID] ASC
814)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
815) ON [PRIMARY]
816GO
817/****** Object: Table [dbo].[Pangya_Personal_Log] Script Date: 19/10/2018 08:23:23 ******/
818SET ANSI_NULLS ON
819GO
820SET QUOTED_IDENTIFIER ON
821GO
822CREATE TABLE [dbo].[Pangya_Personal_Log](
823 [LogID] [int] IDENTITY(1,1) NOT NULL,
824 [ActionType] [varchar](255) NOT NULL,
825 [Amount] [int] NULL,
826 [UID] [int] NOT NULL,
827 [LockerPang] [int] NULL
828) ON [PRIMARY]
829GO
830/****** Object: Table [dbo].[Pangya_SelfDesign] Script Date: 19/10/2018 08:23:23 ******/
831SET ANSI_NULLS ON
832GO
833SET QUOTED_IDENTIFIER ON
834GO
835CREATE TABLE [dbo].[Pangya_SelfDesign](
836 [UID] [int] NOT NULL,
837 [ITEM_ID] [int] NOT NULL,
838 [UCC_UNIQE] [varchar](8) NOT NULL,
839 [TYPEID] [int] NOT NULL,
840 [UCC_STATUS] [tinyint] NULL,
841 [UCC_KEY] [varchar](50) NULL,
842 [UCC_NAME] [varchar](20) NULL,
843 [UCC_DRAWER] [int] NULL,
844 [UCC_COPY_COUNT] [int] NULL,
845 [IN_DATE] [datetime] NULL,
846 CONSTRAINT [PK_Pangya_SelfDesign] PRIMARY KEY CLUSTERED
847(
848 [UID] ASC,
849 [ITEM_ID] ASC,
850 [UCC_UNIQE] ASC
851)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
852) ON [PRIMARY]
853GO
854/****** Object: Table [dbo].[Pangya_Server] Script Date: 19/10/2018 08:23:23 ******/
855SET ANSI_NULLS ON
856GO
857SET QUOTED_IDENTIFIER ON
858GO
859CREATE TABLE [dbo].[Pangya_Server](
860 [ServerID] [int] IDENTITY(1,1) NOT NULL,
861 [Name] [varchar](50) NOT NULL,
862 [IP] [varchar](50) NOT NULL,
863 [Port] [smallint] NOT NULL,
864 [ImgNo] [tinyint] NOT NULL,
865 [ImgEvent] [smallint] NOT NULL,
866 [ServerType] [tinyint] NOT NULL,
867 CONSTRAINT [PK_Pangya_Server] PRIMARY KEY CLUSTERED
868(
869 [ServerID] ASC
870)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
871) ON [PRIMARY]
872GO
873/****** Object: Table [dbo].[Pangya_String] Script Date: 19/10/2018 08:23:23 ******/
874SET ANSI_NULLS ON
875GO
876SET QUOTED_IDENTIFIER ON
877GO
878CREATE TABLE [dbo].[Pangya_String](
879 [Id] [int] IDENTITY(1,1) NOT NULL,
880 [str] [varchar](8000) NOT NULL
881) ON [PRIMARY]
882GO
883/****** Object: Table [dbo].[Pangya_Transaction_Log] Script Date: 19/10/2018 08:23:23 ******/
884SET ANSI_NULLS ON
885GO
886SET QUOTED_IDENTIFIER ON
887GO
888CREATE TABLE [dbo].[Pangya_Transaction_Log](
889 [ID] [int] IDENTITY(1,1) NOT NULL,
890 [UID] [int] NULL,
891 [String] [varchar](4096) NULL,
892 [ERROR_NUMBER] [int] NULL,
893 [ERROR_SEVERITY] [int] NULL,
894 [ERROR_STATE] [int] NULL,
895 [ERROR_PROCEDURE] [varchar](1024) NULL,
896 [ERROR_LINE] [int] NULL,
897 [ERROR_MESSAGE] [varchar](1024) NULL
898) ON [PRIMARY]
899GO
900/****** Object: Table [dbo].[Pangya_User_Equip] Script Date: 19/10/2018 08:23:23 ******/
901SET ANSI_NULLS ON
902GO
903SET QUOTED_IDENTIFIER ON
904GO
905CREATE TABLE [dbo].[Pangya_User_Equip](
906 [UID] [int] NOT NULL,
907 [CHARACTER_ID] [int] NULL,
908 [CLUB_ID] [int] NULL,
909 [BALL_ID] [int] NULL,
910 [MASCOT_ID] [int] NULL,
911 [CADDIE] [int] NULL,
912 [TITLE_TYPEID] [int] NULL,
913 [ITEM_SLOT_1] [int] NULL,
914 [ITEM_SLOT_2] [int] NULL,
915 [ITEM_SLOT_3] [int] NULL,
916 [ITEM_SLOT_4] [int] NULL,
917 [ITEM_SLOT_5] [int] NULL,
918 [ITEM_SLOT_6] [int] NULL,
919 [ITEM_SLOT_7] [int] NULL,
920 [ITEM_SLOT_8] [int] NULL,
921 [ITEM_SLOT_9] [int] NULL,
922 [ITEM_SLOT_10] [int] NULL,
923 [POSTER_1] [int] NULL,
924 [POSTER_2] [int] NULL,
925PRIMARY KEY CLUSTERED
926(
927 [UID] ASC
928)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
929) ON [PRIMARY]
930GO
931/****** Object: Table [dbo].[Pangya_User_MatchHistory] Script Date: 19/10/2018 08:23:23 ******/
932SET ANSI_NULLS ON
933GO
934SET QUOTED_IDENTIFIER ON
935GO
936CREATE TABLE [dbo].[Pangya_User_MatchHistory](
937 [UID] [int] NOT NULL,
938 [UID1] [int] NOT NULL,
939 [UID2] [int] NOT NULL,
940 [UID3] [int] NOT NULL,
941 [UID4] [int] NOT NULL,
942 [UID5] [int] NOT NULL
943) ON [PRIMARY]
944GO
945/****** Object: Table [dbo].[Pangya_User_Statistics] Script Date: 19/10/2018 08:23:23 ******/
946SET ANSI_NULLS ON
947GO
948SET QUOTED_IDENTIFIER ON
949GO
950CREATE TABLE [dbo].[Pangya_User_Statistics](
951 [UID] [int] NOT NULL,
952 [Drive] [int] NOT NULL,
953 [Putt] [int] NOT NULL,
954 [Playtime] [int] NOT NULL,
955 [Longest] [real] NOT NULL,
956 [Distance] [int] NOT NULL,
957 [Pangya] [int] NOT NULL,
958 [Hole] [int] NOT NULL,
959 [TeamHole] [int] NOT NULL,
960 [Holeinone] [int] NOT NULL,
961 [OB] [int] NOT NULL,
962 [Bunker] [int] NOT NULL,
963 [Fairway] [int] NOT NULL,
964 [Albatross] [int] NOT NULL,
965 [Holein] [int] NOT NULL,
966 [Pang] [int] NOT NULL,
967 [Timeout] [int] NOT NULL,
968 [Game_Level] [smallint] NOT NULL,
969 [Game_Point] [int] NOT NULL,
970 [PuttIn] [int] NOT NULL,
971 [LongestPuttIn] [real] NOT NULL,
972 [LongestChipIn] [real] NOT NULL,
973 [NoMannerGameCount] [int] NOT NULL,
974 [ShotTime] [int] NOT NULL,
975 [GameCount] [int] NOT NULL,
976 [DisconnectGames] [int] NOT NULL,
977 [wTeamWin] [int] NOT NULL,
978 [wTeamGames] [int] NOT NULL,
979 [LadderPoint] [smallint] NOT NULL,
980 [LadderWin] [smallint] NOT NULL,
981 [LadderLose] [smallint] NOT NULL,
982 [LadderDraw] [smallint] NOT NULL,
983 [ComboCount] [int] NOT NULL,
984 [MaxComboCount] [int] NOT NULL,
985 [TotalScore] [int] NOT NULL,
986 [BestScore0] [smallint] NOT NULL,
987 [BestScore1] [smallint] NOT NULL,
988 [BestScore2] [smallint] NOT NULL,
989 [BestScore3] [smallint] NOT NULL,
990 [BESTSCORE4] [smallint] NOT NULL,
991 [MaxPang0] [int] NULL,
992 [MaxPang1] [int] NULL,
993 [MaxPang2] [int] NULL,
994 [MaxPang3] [int] NULL,
995 [MAXPANG4] [int] NULL,
996 [SumPang] [int] NOT NULL,
997 [LadderHole] [smallint] NOT NULL,
998 [GameCountSeason] [int] NOT NULL,
999 [SkinsPang] [bigint] NOT NULL,
1000 [SkinsWin] [int] NOT NULL,
1001 [SkinsLose] [int] NOT NULL,
1002 [SkinsRunHoles] [int] NOT NULL,
1003 [SkinsStrikePoint] [int] NOT NULL,
1004 [SkinsAllinCount] [int] NOT NULL,
1005 [EventValue] [int] NOT NULL,
1006 [EventFlag] [int] NOT NULL
1007) ON [PRIMARY]
1008GO
1009/****** Object: Table [dbo].[Pangya_Warehouse] Script Date: 19/10/2018 08:23:23 ******/
1010SET ANSI_NULLS ON
1011GO
1012SET QUOTED_IDENTIFIER ON
1013GO
1014CREATE TABLE [dbo].[Pangya_Warehouse](
1015 [item_id] [int] IDENTITY(1,1) NOT NULL,
1016 [UID] [int] NOT NULL,
1017 [TYPEID] [int] NOT NULL,
1018 [C0] [smallint] NULL,
1019 [C1] [smallint] NULL,
1020 [C2] [smallint] NULL,
1021 [C3] [smallint] NULL,
1022 [C4] [smallint] NULL,
1023 [RegDate] [datetime] NULL,
1024 [DateEnd] [datetime] NULL,
1025 [VALID] [tinyint] NOT NULL,
1026 [ItemType] [tinyint] NULL,
1027 [Flag] [tinyint] NULL,
1028 CONSTRAINT [PK_Pangya_Warehouse] PRIMARY KEY CLUSTERED
1029(
1030 [item_id] ASC,
1031 [UID] ASC
1032)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1033) ON [PRIMARY]
1034GO
1035/****** Object: Table [dbo].[TD_ROOM_DATA] Script Date: 19/10/2018 08:23:23 ******/
1036SET ANSI_NULLS ON
1037GO
1038SET QUOTED_IDENTIFIER ON
1039GO
1040CREATE TABLE [dbo].[TD_ROOM_DATA](
1041 [IDX] [int] IDENTITY(1,1) NOT NULL,
1042 [UID] [int] NOT NULL,
1043 [TYPEID] [int] NOT NULL,
1044 [POS_X] [numeric](10, 4) NULL,
1045 [POS_Y] [numeric](10, 4) NULL,
1046 [POS_Z] [numeric](10, 4) NULL,
1047 [POS_R] [numeric](10, 4) NULL,
1048 [VALID] [tinyint] NULL,
1049 [GETDATE] [datetime] NULL
1050) ON [PRIMARY]
1051GO
1052SET ANSI_PADDING ON
1053GO
1054/****** Object: Index [IX_Pangya_Guild_Info] Script Date: 19/10/2018 08:23:23 ******/
1055CREATE NONCLUSTERED INDEX [IX_Pangya_Guild_Info] ON [dbo].[Pangya_Guild_Info]
1056(
1057 [GUILD_NAME] ASC
1058)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1059GO
1060ALTER TABLE [dbo].[Achievement_Data] ADD CONSTRAINT [DF_Achievement_Data_ACHIEVEMENT_TYPEID] DEFAULT ((0)) FOR [ACHIEVEMENT_TYPEID]
1061GO
1062ALTER TABLE [dbo].[Daily_Quest] ADD DEFAULT (getdate()) FOR [RegDate]
1063GO
1064ALTER TABLE [dbo].[Daily_Quest] ADD DEFAULT ((0)) FOR [Day]
1065GO
1066ALTER TABLE [dbo].[Pangya_Achievement] ADD CONSTRAINT [DF__Pangya_Ach__Type__32B6742D] DEFAULT ((3)) FOR [Type]
1067GO
1068ALTER TABLE [dbo].[Pangya_Achievement] ADD DEFAULT ((1)) FOR [Valid]
1069GO
1070ALTER TABLE [dbo].[Pangya_Achievement_Quest] ADD CONSTRAINT [DF_Table_1_SuccessTimestamp] DEFAULT ((0)) FOR [SuccessDate]
1071GO
1072ALTER TABLE [dbo].[Pangya_Caddie] ADD CONSTRAINT [DF_Pangya_Caddie_UID] DEFAULT ((0)) FOR [UID]
1073GO
1074ALTER TABLE [dbo].[Pangya_Caddie] ADD CONSTRAINT [DF_Pangya_Caddie_TYPEID] DEFAULT ((0)) FOR [TYPEID]
1075GO
1076ALTER TABLE [dbo].[Pangya_Caddie] ADD CONSTRAINT [DF_Pangya_Caddie_EXP] DEFAULT ((0)) FOR [EXP]
1077GO
1078ALTER TABLE [dbo].[Pangya_Caddie] ADD CONSTRAINT [DF_Table_1_Level] DEFAULT ((0)) FOR [cLevel]
1079GO
1080ALTER TABLE [dbo].[Pangya_Caddie] ADD CONSTRAINT [DF_Pangya_Caddie_SKIN_TYPEID] DEFAULT ((0)) FOR [SKIN_TYPEID]
1081GO
1082ALTER TABLE [dbo].[Pangya_Caddie] ADD CONSTRAINT [DF_Table_1_SKIN_TYPEID] DEFAULT ((0)) FOR [RentFlag]
1083GO
1084ALTER TABLE [dbo].[Pangya_Caddie] ADD CONSTRAINT [DF_Pangya_Caddie_RegDate] DEFAULT (getdate()) FOR [RegDate]
1085GO
1086ALTER TABLE [dbo].[Pangya_Caddie] ADD CONSTRAINT [DF_Pangya_Caddie_TriggerPay] DEFAULT ((0)) FOR [TriggerPay]
1087GO
1088ALTER TABLE [dbo].[Pangya_Caddie] ADD CONSTRAINT [DF_Pangya_Caddie_VALID] DEFAULT ((1)) FOR [VALID]
1089GO
1090ALTER TABLE [dbo].[Pangya_Card] ADD CONSTRAINT [DF_Pangya_Card_RegData] DEFAULT (getdate()) FOR [RegData]
1091GO
1092ALTER TABLE [dbo].[Pangya_Card] ADD CONSTRAINT [DF_Pangya_Card_VALID] DEFAULT ((1)) FOR [VALID]
1093GO
1094ALTER TABLE [dbo].[Pangya_Card_Equip] ADD CONSTRAINT [DF__Pangya_Card__CID__3B16B004] DEFAULT ((0)) FOR [CID]
1095GO
1096ALTER TABLE [dbo].[Pangya_Card_Equip] ADD CONSTRAINT [DF__Pangya_Ca__REGDA__392E6792] DEFAULT (getdate()) FOR [REGDATE]
1097GO
1098ALTER TABLE [dbo].[Pangya_Card_Equip] ADD CONSTRAINT [DF__Pangya_Car__FLAG__477C86E9] DEFAULT ((0)) FOR [FLAG]
1099GO
1100ALTER TABLE [dbo].[Pangya_Card_Equip] ADD CONSTRAINT [DF__Pangya_Ca__VALID__3A228BCB] DEFAULT ((1)) FOR [VALID]
1101GO
1102ALTER TABLE [dbo].[Pangya_Character] ADD CONSTRAINT [DF_Pangya_Character_GIFT_FLAG] DEFAULT ((0)) FOR [GIFT_FLAG]
1103GO
1104ALTER TABLE [dbo].[Pangya_Character] ADD CONSTRAINT [DF_Pangya_Character_HAIR_COLOR] DEFAULT ((0)) FOR [HAIR_COLOR]
1105GO
1106ALTER TABLE [dbo].[Pangya_Character] ADD CONSTRAINT [DF_Pangya_Character_POWER] DEFAULT ((0)) FOR [POWER]
1107GO
1108ALTER TABLE [dbo].[Pangya_Character] ADD CONSTRAINT [DF_Table_1_POWER4] DEFAULT ((0)) FOR [CONTROL]
1109GO
1110ALTER TABLE [dbo].[Pangya_Character] ADD CONSTRAINT [DF_Table_1_POWER3] DEFAULT ((0)) FOR [IMPACT]
1111GO
1112ALTER TABLE [dbo].[Pangya_Character] ADD CONSTRAINT [DF_Table_1_POWER2] DEFAULT ((0)) FOR [SPIN]
1113GO
1114ALTER TABLE [dbo].[Pangya_Character] ADD CONSTRAINT [DF_Table_1_POWER1] DEFAULT ((0)) FOR [CURVE]
1115GO
1116ALTER TABLE [dbo].[Pangya_Character] ADD CONSTRAINT [DF_Pangya_Character_CUTIN] DEFAULT ((0)) FOR [CUTIN]
1117GO
1118ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_TYPEID_1] DEFAULT ((0)) FOR [PART_TYPEID_1]
1119GO
1120ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_TYPEID_2] DEFAULT ((0)) FOR [PART_TYPEID_2]
1121GO
1122ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_TYPEID_3] DEFAULT ((0)) FOR [PART_TYPEID_3]
1123GO
1124ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_TYPEID_4] DEFAULT ((0)) FOR [PART_TYPEID_4]
1125GO
1126ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_TYPEID_5] DEFAULT ((0)) FOR [PART_TYPEID_5]
1127GO
1128ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_TYPEID_6] DEFAULT ((0)) FOR [PART_TYPEID_6]
1129GO
1130ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_TYPEID_7] DEFAULT ((0)) FOR [PART_TYPEID_7]
1131GO
1132ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_TYPEID_8] DEFAULT ((0)) FOR [PART_TYPEID_8]
1133GO
1134ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_TYPEID_9] DEFAULT ((0)) FOR [PART_TYPEID_9]
1135GO
1136ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_TYPEID_10] DEFAULT ((0)) FOR [PART_TYPEID_10]
1137GO
1138ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_TYPEID_11] DEFAULT ((0)) FOR [PART_TYPEID_11]
1139GO
1140ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_TYPEID_12] DEFAULT ((0)) FOR [PART_TYPEID_12]
1141GO
1142ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_TYPEID_13] DEFAULT ((0)) FOR [PART_TYPEID_13]
1143GO
1144ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_TYPEID_14] DEFAULT ((0)) FOR [PART_TYPEID_14]
1145GO
1146ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_TYPEID_15] DEFAULT ((0)) FOR [PART_TYPEID_15]
1147GO
1148ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_TYPEID_16] DEFAULT ((0)) FOR [PART_TYPEID_16]
1149GO
1150ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_TYPEID_17] DEFAULT ((0)) FOR [PART_TYPEID_17]
1151GO
1152ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_TYPEID_18] DEFAULT ((0)) FOR [PART_TYPEID_18]
1153GO
1154ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_TYPEID_19] DEFAULT ((0)) FOR [PART_TYPEID_19]
1155GO
1156ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_TYPEID_20] DEFAULT ((0)) FOR [PART_TYPEID_20]
1157GO
1158ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_TYPEID_21] DEFAULT ((0)) FOR [PART_TYPEID_21]
1159GO
1160ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_TYPEID_22] DEFAULT ((0)) FOR [PART_TYPEID_22]
1161GO
1162ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_TYPEID_23] DEFAULT ((0)) FOR [PART_TYPEID_23]
1163GO
1164ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_TYPEID_24] DEFAULT ((0)) FOR [PART_TYPEID_24]
1165GO
1166ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_IDX_1] DEFAULT ((0)) FOR [PART_IDX_1]
1167GO
1168ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_IDX_2] DEFAULT ((0)) FOR [PART_IDX_2]
1169GO
1170ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_IDX_3] DEFAULT ((0)) FOR [PART_IDX_3]
1171GO
1172ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_IDX_4] DEFAULT ((0)) FOR [PART_IDX_4]
1173GO
1174ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_IDX_5] DEFAULT ((0)) FOR [PART_IDX_5]
1175GO
1176ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_IDX_6] DEFAULT ((0)) FOR [PART_IDX_6]
1177GO
1178ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_IDX_7] DEFAULT ((0)) FOR [PART_IDX_7]
1179GO
1180ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_IDX_8] DEFAULT ((0)) FOR [PART_IDX_8]
1181GO
1182ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_IDX_9] DEFAULT ((0)) FOR [PART_IDX_9]
1183GO
1184ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_IDX_10] DEFAULT ((0)) FOR [PART_IDX_10]
1185GO
1186ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_IDX_11] DEFAULT ((0)) FOR [PART_IDX_11]
1187GO
1188ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_IDX_12] DEFAULT ((0)) FOR [PART_IDX_12]
1189GO
1190ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_IDX_13] DEFAULT ((0)) FOR [PART_IDX_13]
1191GO
1192ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_IDX_14] DEFAULT ((0)) FOR [PART_IDX_14]
1193GO
1194ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_IDX_15] DEFAULT ((0)) FOR [PART_IDX_15]
1195GO
1196ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_IDX_16] DEFAULT ((0)) FOR [PART_IDX_16]
1197GO
1198ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_IDX_17] DEFAULT ((0)) FOR [PART_IDX_17]
1199GO
1200ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_IDX_18] DEFAULT ((0)) FOR [PART_IDX_18]
1201GO
1202ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_IDX_19] DEFAULT ((0)) FOR [PART_IDX_19]
1203GO
1204ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_IDX_20] DEFAULT ((0)) FOR [PART_IDX_20]
1205GO
1206ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_IDX_21] DEFAULT ((0)) FOR [PART_IDX_21]
1207GO
1208ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_IDX_22] DEFAULT ((0)) FOR [PART_IDX_22]
1209GO
1210ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_IDX_23] DEFAULT ((0)) FOR [PART_IDX_23]
1211GO
1212ALTER TABLE [dbo].[Pangya_Character_Equip] ADD CONSTRAINT [DF_Pangya_Character_Equip_PART_IDX_24] DEFAULT ((0)) FOR [PART_IDX_24]
1213GO
1214ALTER TABLE [dbo].[Pangya_Club_Info] ADD CONSTRAINT [DF_Pangya_Club_Info_C0_SLOT] DEFAULT ((0)) FOR [C0_SLOT]
1215GO
1216ALTER TABLE [dbo].[Pangya_Club_Info] ADD CONSTRAINT [DF_Table_1_C0_SLOT1] DEFAULT ((0)) FOR [C1_SLOT]
1217GO
1218ALTER TABLE [dbo].[Pangya_Club_Info] ADD CONSTRAINT [DF_Table_1_C0_SLOT2] DEFAULT ((0)) FOR [C2_SLOT]
1219GO
1220ALTER TABLE [dbo].[Pangya_Club_Info] ADD CONSTRAINT [DF_Table_1_C0_SLOT3] DEFAULT ((0)) FOR [C3_SLOT]
1221GO
1222ALTER TABLE [dbo].[Pangya_Club_Info] ADD CONSTRAINT [DF_Table_1_C0_SLOT4] DEFAULT ((0)) FOR [C4_SLOT]
1223GO
1224ALTER TABLE [dbo].[Pangya_Club_Info] ADD CONSTRAINT [DF_Pangya_Club_Info_CLUB_POINT] DEFAULT ((0)) FOR [CLUB_POINT]
1225GO
1226ALTER TABLE [dbo].[Pangya_Club_Info] ADD CONSTRAINT [DF_Pangya_Club_Info_CLUB_WORK_COUNT] DEFAULT ((0)) FOR [CLUB_WORK_COUNT]
1227GO
1228ALTER TABLE [dbo].[Pangya_Club_Info] ADD CONSTRAINT [DF_Pangya_Club_Info_CLUB_SLOT_CANCEL] DEFAULT ((0)) FOR [CLUB_SLOT_CANCEL]
1229GO
1230ALTER TABLE [dbo].[Pangya_Club_Info] ADD CONSTRAINT [DF_Pangya_Club_Info_CLUB_POINT_TOTAL_LOG] DEFAULT ((0)) FOR [CLUB_POINT_TOTAL_LOG]
1231GO
1232ALTER TABLE [dbo].[Pangya_Club_Info] ADD CONSTRAINT [DF_Pangya_Club_Info_CLUB_UPGRADE_PANG_LOG] DEFAULT ((0)) FOR [CLUB_UPGRADE_PANG_LOG]
1233GO
1234ALTER TABLE [dbo].[Pangya_Daily_Quest] ADD DEFAULT ((0)) FOR [UID]
1235GO
1236ALTER TABLE [dbo].[Pangya_Daily_Quest] ADD DEFAULT ((0)) FOR [QuestID1]
1237GO
1238ALTER TABLE [dbo].[Pangya_Daily_Quest] ADD DEFAULT ((0)) FOR [QuestID2]
1239GO
1240ALTER TABLE [dbo].[Pangya_Daily_Quest] ADD DEFAULT ((0)) FOR [QuestID3]
1241GO
1242ALTER TABLE [dbo].[Pangya_Daily_Quest] ADD DEFAULT (getdate()) FOR [RegDate]
1243GO
1244ALTER TABLE [dbo].[Pangya_Exception_Log] ADD CONSTRAINT [DF_Pangya_Exception_Log_CreateDate] DEFAULT (getdate()) FOR [CreateDate]
1245GO
1246ALTER TABLE [dbo].[Pangya_Friend] ADD CONSTRAINT [DF_Pangya_Friend_IsAccept] DEFAULT ((0)) FOR [IsAccept]
1247GO
1248ALTER TABLE [dbo].[Pangya_Friend] ADD CONSTRAINT [DF_Pangya_Friend_GroupName] DEFAULT ('Friend') FOR [GroupName]
1249GO
1250ALTER TABLE [dbo].[Pangya_Friend] ADD CONSTRAINT [DF_Pangya_Friend_IsAgree] DEFAULT ((0)) FOR [IsAgree]
1251GO
1252ALTER TABLE [dbo].[Pangya_Friend] ADD CONSTRAINT [DF_Pangya_Friend_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]
1253GO
1254ALTER TABLE [dbo].[Pangya_Friend] ADD CONSTRAINT [DF_Pangya_Friend_Memo] DEFAULT ('Friend') FOR [Memo]
1255GO
1256ALTER TABLE [dbo].[Pangya_Friend] ADD CONSTRAINT [DF_Pangya_Friend_IsBlock] DEFAULT ((0)) FOR [IsBlock]
1257GO
1258ALTER TABLE [dbo].[Pangya_Game_Macro] ADD CONSTRAINT [DF_Pangya_Game_Macro_Macro1] DEFAULT ('Pangya!') FOR [Macro1]
1259GO
1260ALTER TABLE [dbo].[Pangya_Game_Macro] ADD CONSTRAINT [DF_Pangya_Game_Macro_Macro2] DEFAULT ('Pangya!') FOR [Macro2]
1261GO
1262ALTER TABLE [dbo].[Pangya_Game_Macro] ADD CONSTRAINT [DF_Pangya_Game_Macro_Macro3] DEFAULT ('Pangya!') FOR [Macro3]
1263GO
1264ALTER TABLE [dbo].[Pangya_Game_Macro] ADD CONSTRAINT [DF_Pangya_Game_Macro_Macro4] DEFAULT ('Pangya!') FOR [Macro4]
1265GO
1266ALTER TABLE [dbo].[Pangya_Game_Macro] ADD CONSTRAINT [DF_Pangya_Game_Macro_Macro5] DEFAULT ('Pangya!') FOR [Macro5]
1267GO
1268ALTER TABLE [dbo].[Pangya_Game_Macro] ADD CONSTRAINT [DF_Pangya_Game_Macro_Macro6] DEFAULT ('Pangya!') FOR [Macro6]
1269GO
1270ALTER TABLE [dbo].[Pangya_Game_Macro] ADD CONSTRAINT [DF_Pangya_Game_Macro_Macro7] DEFAULT ('Pangya!') FOR [Macro7]
1271GO
1272ALTER TABLE [dbo].[Pangya_Game_Macro] ADD CONSTRAINT [DF_Pangya_Game_Macro_Macro8] DEFAULT ('Pangya!') FOR [Macro8]
1273GO
1274ALTER TABLE [dbo].[Pangya_Game_Macro] ADD CONSTRAINT [DF_Pangya_Game_Macro_Macro9] DEFAULT ('Pangya!') FOR [Macro9]
1275GO
1276ALTER TABLE [dbo].[Pangya_Game_Macro] ADD CONSTRAINT [DF_Pangya_Game_Macro_Macro10] DEFAULT ('Pangya!') FOR [Macro10]
1277GO
1278ALTER TABLE [dbo].[Pangya_Guild_Emblem] ADD CONSTRAINT [DF_Pangya_Guild_Emblem_GUILD_MARK_ISVALID] DEFAULT ((1)) FOR [GUILD_MARK_ISVALID]
1279GO
1280ALTER TABLE [dbo].[Pangya_Guild_Info] ADD CONSTRAINT [DF_Pangya_Guild_Info_GUILD_POINT] DEFAULT ((0)) FOR [GUILD_POINT]
1281GO
1282ALTER TABLE [dbo].[Pangya_Guild_Info] ADD CONSTRAINT [DF_Pangya_Guild_Info_GUILD_PANG] DEFAULT ((0)) FOR [GUILD_PANG]
1283GO
1284ALTER TABLE [dbo].[Pangya_Guild_Info] ADD CONSTRAINT [DF_Pangya_Guild_Info_GUILD_IMAGE] DEFAULT ('GUILDMARK') FOR [GUILD_IMAGE]
1285GO
1286ALTER TABLE [dbo].[Pangya_Guild_Info] ADD CONSTRAINT [DF_Pangya_Guild_Info_GUILD_IMAGE_KEY_UPLOAD] DEFAULT ((-1)) FOR [GUILD_IMAGE_KEY_UPLOAD]
1287GO
1288ALTER TABLE [dbo].[Pangya_Guild_Info] ADD CONSTRAINT [DF_Pangya_Guild_Info_GUILD_CREATE_DATE] DEFAULT (getdate()) FOR [GUILD_CREATE_DATE]
1289GO
1290ALTER TABLE [dbo].[Pangya_Guild_Info] ADD CONSTRAINT [DF_Pangya_Guild_Info_GUILD_VALID] DEFAULT ((1)) FOR [GUILD_VALID]
1291GO
1292ALTER TABLE [dbo].[Pangya_Guild_Log] ADD CONSTRAINT [DF_Pangya_Guild_Log_GUILD_ACTION_DATE] DEFAULT (getdate()) FOR [GUILD_ACTION_DATE]
1293GO
1294ALTER TABLE [dbo].[Pangya_Guild_Member] ADD CONSTRAINT [DF_Pangya_Guild_Member_GUILD_POSITION] DEFAULT ((3)) FOR [GUILD_POSITION]
1295GO
1296ALTER TABLE [dbo].[Pangya_Guild_Member] ADD CONSTRAINT [DF_Pangya_Guild_Member_GUILD_ENTERED_TIME] DEFAULT (getdate()) FOR [GUILD_ENTERED_TIME]
1297GO
1298ALTER TABLE [dbo].[Pangya_Guild_Member] ADD CONSTRAINT [DF_Pangya_Guild_Member_GUILD_MEMBER_STATUS] DEFAULT ((0)) FOR [GUILD_MEMBER_STATUS]
1299GO
1300ALTER TABLE [dbo].[Pangya_Item_Daily] ADD CONSTRAINT [DF_Pangya_Item_Daily_Quantity] DEFAULT ((1)) FOR [Quantity]
1301GO
1302ALTER TABLE [dbo].[Pangya_Item_Daily] ADD CONSTRAINT [DF_Pangya_Item_Daily_DATE] DEFAULT (getdate()) FOR [DATE]
1303GO
1304ALTER TABLE [dbo].[Pangya_Item_Daily_Log] ADD CONSTRAINT [DF_Pangya_Item_Daily_Log_Date] DEFAULT (getdate()) FOR [Date]
1305GO
1306ALTER TABLE [dbo].[Pangya_Locker_Item] ADD DEFAULT ((0)) FOR [UID]
1307GO
1308ALTER TABLE [dbo].[Pangya_Locker_Item] ADD DEFAULT ((0)) FOR [TypeID]
1309GO
1310ALTER TABLE [dbo].[Pangya_Locker_Item] ADD DEFAULT ('Name') FOR [Name]
1311GO
1312ALTER TABLE [dbo].[Pangya_Locker_Item] ADD DEFAULT ((0)) FOR [FROM_ID]
1313GO
1314ALTER TABLE [dbo].[Pangya_Locker_Item] ADD DEFAULT ((1)) FOR [Valid]
1315GO
1316ALTER TABLE [dbo].[Pangya_Mail] ADD CONSTRAINT [DF_Pangya_Mail_RegDate] DEFAULT (getdate()) FOR [RegDate]
1317GO
1318ALTER TABLE [dbo].[Pangya_Mail_Item] ADD CONSTRAINT [DF_Pangya_Mail_Item_SetTypeID] DEFAULT ((0)) FOR [SETTYPEID]
1319GO
1320ALTER TABLE [dbo].[Pangya_Mail_Item] ADD CONSTRAINT [DF_Pangya_Mail_Item_DAY] DEFAULT ((0)) FOR [DAY]
1321GO
1322ALTER TABLE [dbo].[Pangya_Mail_Item] ADD CONSTRAINT [DF_Pangya_Mail_Item_IN_DATE] DEFAULT (getdate()) FOR [IN_DATE]
1323GO
1324ALTER TABLE [dbo].[Pangya_Mail_SetItem] ADD CONSTRAINT [DF_Pangya_Mail_SetItem_DAY] DEFAULT ((0)) FOR [DAY]
1325GO
1326ALTER TABLE [dbo].[Pangya_Mail_SetItem] ADD CONSTRAINT [DF_Pangya_Mail_SetItem_IN_DATE] DEFAULT (getdate()) FOR [IN_DATE]
1327GO
1328ALTER TABLE [dbo].[Pangya_Map_Statistics] ADD CONSTRAINT [DF__Pangya_Map___Map__53584DE9] DEFAULT ((0)) FOR [Map]
1329GO
1330ALTER TABLE [dbo].[Pangya_Map_Statistics] ADD CONSTRAINT [DF__Pangya_Ma__Drive__544C7222] DEFAULT ((0)) FOR [Drive]
1331GO
1332ALTER TABLE [dbo].[Pangya_Map_Statistics] ADD CONSTRAINT [DF__Pangya_Map__Putt__5540965B] DEFAULT ((0)) FOR [Putt]
1333GO
1334ALTER TABLE [dbo].[Pangya_Map_Statistics] ADD CONSTRAINT [DF__Pangya_Map__Hole__5634BA94] DEFAULT ((0)) FOR [Hole]
1335GO
1336ALTER TABLE [dbo].[Pangya_Map_Statistics] ADD CONSTRAINT [DF__Pangya_Ma__Fairw__5728DECD] DEFAULT ((0)) FOR [Fairway]
1337GO
1338ALTER TABLE [dbo].[Pangya_Map_Statistics] ADD CONSTRAINT [DF__Pangya_Ma__Holei__581D0306] DEFAULT ((0)) FOR [Holein]
1339GO
1340ALTER TABLE [dbo].[Pangya_Map_Statistics] ADD CONSTRAINT [DF__Pangya_Ma__PuttI__5911273F] DEFAULT ((0)) FOR [PuttIn]
1341GO
1342ALTER TABLE [dbo].[Pangya_Map_Statistics] ADD CONSTRAINT [DF__Pangya_Ma__Total__5A054B78] DEFAULT ((0)) FOR [TotalScore]
1343GO
1344ALTER TABLE [dbo].[Pangya_Map_Statistics] ADD CONSTRAINT [DF__Pangya_Ma__BestS__5AF96FB1] DEFAULT ((127)) FOR [BestScore]
1345GO
1346ALTER TABLE [dbo].[Pangya_Map_Statistics] ADD CONSTRAINT [DF__Pangya_Ma__MaxPa__5BED93EA] DEFAULT ((0)) FOR [MaxPang]
1347GO
1348ALTER TABLE [dbo].[Pangya_Map_Statistics] ADD CONSTRAINT [DF__Pangya_Ma__CharT__5CE1B823] DEFAULT ((0)) FOR [CharTypeId]
1349GO
1350ALTER TABLE [dbo].[Pangya_Map_Statistics] ADD CONSTRAINT [DF__Pangya_Ma__Event__5DD5DC5C] DEFAULT ((0)) FOR [EventScore]
1351GO
1352ALTER TABLE [dbo].[Pangya_Map_Statistics] ADD CONSTRAINT [DF__Pangya_Ma__Assis__629A9179] DEFAULT ((0)) FOR [Assist]
1353GO
1354ALTER TABLE [dbo].[Pangya_Map_Statistics] ADD CONSTRAINT [DF__Pangya_Ma__REGDA__5ECA0095] DEFAULT (getdate()) FOR [REGDATE]
1355GO
1356ALTER TABLE [dbo].[Pangya_Mascot] ADD CONSTRAINT [DF_Pangya_Mascot_MESSAGE] DEFAULT ('PANGYA!') FOR [MESSAGE]
1357GO
1358ALTER TABLE [dbo].[Pangya_Mascot] ADD CONSTRAINT [DF_Pangya_Mascot_VALID] DEFAULT ((1)) FOR [VALID]
1359GO
1360ALTER TABLE [dbo].[Pangya_Member] ADD CONSTRAINT [DF_pangya_member_IDState] DEFAULT ((0)) FOR [IDState]
1361GO
1362ALTER TABLE [dbo].[Pangya_Member] ADD CONSTRAINT [DF_pangya_member_FirstSet] DEFAULT ((0)) FOR [FirstSet]
1363GO
1364ALTER TABLE [dbo].[Pangya_Member] ADD CONSTRAINT [DF_pangya_member_Sex] DEFAULT ((0)) FOR [Sex]
1365GO
1366ALTER TABLE [dbo].[Pangya_Member] ADD CONSTRAINT [DF_pangya_member_LogonCount] DEFAULT ((0)) FOR [LogonCount]
1367GO
1368ALTER TABLE [dbo].[Pangya_Member] ADD CONSTRAINT [DF_pangya_member_Capabilities] DEFAULT ((0)) FOR [Capabilities]
1369GO
1370ALTER TABLE [dbo].[Pangya_Member] ADD DEFAULT (getdate()) FOR [RegDate]
1371GO
1372ALTER TABLE [dbo].[Pangya_Member] ADD CONSTRAINT [DF_Pangya_Member_GuildID] DEFAULT ((0)) FOR [GUILDINDEX]
1373GO
1374ALTER TABLE [dbo].[Pangya_Member] ADD CONSTRAINT [DF_Pangya_Member_DailyLoginCount] DEFAULT ((0)) FOR [DailyLoginCount]
1375GO
1376ALTER TABLE [dbo].[Pangya_Memorial_Log] ADD DEFAULT ((1)) FOR [Quantity]
1377GO
1378ALTER TABLE [dbo].[Pangya_Memorial_Log] ADD DEFAULT (getdate()) FOR [DateIN]
1379GO
1380ALTER TABLE [dbo].[Pangya_Personal] ADD DEFAULT ((0)) FOR [CookieAmt]
1381GO
1382ALTER TABLE [dbo].[Pangya_Personal] ADD DEFAULT ((0)) FOR [PangLockerAmt]
1383GO
1384ALTER TABLE [dbo].[Pangya_Personal] ADD DEFAULT ((0)) FOR [LockerPwd]
1385GO
1386ALTER TABLE [dbo].[Pangya_Personal_Log] ADD DEFAULT ((0)) FOR [Amount]
1387GO
1388ALTER TABLE [dbo].[Pangya_Personal_Log] ADD DEFAULT ((0)) FOR [UID]
1389GO
1390ALTER TABLE [dbo].[Pangya_Personal_Log] ADD DEFAULT ((0)) FOR [LockerPang]
1391GO
1392ALTER TABLE [dbo].[Pangya_SelfDesign] ADD CONSTRAINT [DF_Pangya_SelfDesign_UCC_STATUS] DEFAULT ((0)) FOR [UCC_STATUS]
1393GO
1394ALTER TABLE [dbo].[Pangya_SelfDesign] ADD CONSTRAINT [DF_Pangya_SelfDesign_UCC_DRAWER] DEFAULT ((0)) FOR [UCC_DRAWER]
1395GO
1396ALTER TABLE [dbo].[Pangya_SelfDesign] ADD CONSTRAINT [DF_Pangya_SelfDesign_UCC_COPY_COUNT] DEFAULT ((1)) FOR [UCC_COPY_COUNT]
1397GO
1398ALTER TABLE [dbo].[Pangya_SelfDesign] ADD CONSTRAINT [DF_Pangya_SelfDesign_IN_DATE] DEFAULT (getdate()) FOR [IN_DATE]
1399GO
1400ALTER TABLE [dbo].[Pangya_Server] ADD CONSTRAINT [DF_Pangya_Server_Port] DEFAULT ((0)) FOR [Port]
1401GO
1402ALTER TABLE [dbo].[Pangya_Server] ADD CONSTRAINT [DF_Pangya_Server_ImgNo] DEFAULT ((0)) FOR [ImgNo]
1403GO
1404ALTER TABLE [dbo].[Pangya_Server] ADD CONSTRAINT [DF_Pangya_Server_ImgEvent] DEFAULT ((0)) FOR [ImgEvent]
1405GO
1406ALTER TABLE [dbo].[Pangya_Server] ADD CONSTRAINT [DF_Pangya_Server_ServerType] DEFAULT ((0)) FOR [ServerType]
1407GO
1408ALTER TABLE [dbo].[Pangya_User_Equip] ADD CONSTRAINT [DF_Pangya_User_Equip_CHARACTER_ID] DEFAULT ((0)) FOR [CHARACTER_ID]
1409GO
1410ALTER TABLE [dbo].[Pangya_User_Equip] ADD CONSTRAINT [DF_Pangya_User_Equip_CLUB_ID] DEFAULT ((0)) FOR [CLUB_ID]
1411GO
1412ALTER TABLE [dbo].[Pangya_User_Equip] ADD CONSTRAINT [DF_Pangya_User_Equip_BALL_ID] DEFAULT ((0)) FOR [BALL_ID]
1413GO
1414ALTER TABLE [dbo].[Pangya_User_Equip] ADD CONSTRAINT [DF_Pangya_User_Equip_MASCOT_ID] DEFAULT ((0)) FOR [MASCOT_ID]
1415GO
1416ALTER TABLE [dbo].[Pangya_User_Equip] ADD CONSTRAINT [DF_Pangya_User_Equip_CADDIE] DEFAULT ((0)) FOR [CADDIE]
1417GO
1418ALTER TABLE [dbo].[Pangya_User_Equip] ADD CONSTRAINT [DF_Pangya_User_Equip_ITEM_SLOT_1] DEFAULT ((0)) FOR [ITEM_SLOT_1]
1419GO
1420ALTER TABLE [dbo].[Pangya_User_Equip] ADD CONSTRAINT [DF_Pangya_User_Equip_ITEM_SLOT_2] DEFAULT ((0)) FOR [ITEM_SLOT_2]
1421GO
1422ALTER TABLE [dbo].[Pangya_User_Equip] ADD CONSTRAINT [DF_Pangya_User_Equip_ITEM_SLOT_3] DEFAULT ((0)) FOR [ITEM_SLOT_3]
1423GO
1424ALTER TABLE [dbo].[Pangya_User_Equip] ADD CONSTRAINT [DF_Pangya_User_Equip_ITEM_SLOT_4] DEFAULT ((0)) FOR [ITEM_SLOT_4]
1425GO
1426ALTER TABLE [dbo].[Pangya_User_Equip] ADD CONSTRAINT [DF_Pangya_User_Equip_ITEM_SLOT_5] DEFAULT ((0)) FOR [ITEM_SLOT_5]
1427GO
1428ALTER TABLE [dbo].[Pangya_User_Equip] ADD CONSTRAINT [DF_Pangya_User_Equip_ITEM_SLOT_6] DEFAULT ((0)) FOR [ITEM_SLOT_6]
1429GO
1430ALTER TABLE [dbo].[Pangya_User_Equip] ADD CONSTRAINT [DF_Pangya_User_Equip_ITEM_SLOT_7] DEFAULT ((0)) FOR [ITEM_SLOT_7]
1431GO
1432ALTER TABLE [dbo].[Pangya_User_Equip] ADD CONSTRAINT [DF_Pangya_User_Equip_ITEM_SLOT_8] DEFAULT ((0)) FOR [ITEM_SLOT_8]
1433GO
1434ALTER TABLE [dbo].[Pangya_User_Equip] ADD CONSTRAINT [DF_Pangya_User_Equip_ITEM_SLOT_9] DEFAULT ((0)) FOR [ITEM_SLOT_9]
1435GO
1436ALTER TABLE [dbo].[Pangya_User_Equip] ADD CONSTRAINT [DF_Pangya_User_Equip_ITEM_SLOT_10] DEFAULT ((0)) FOR [ITEM_SLOT_10]
1437GO
1438ALTER TABLE [dbo].[Pangya_User_Equip] ADD DEFAULT ((0)) FOR [POSTER_1]
1439GO
1440ALTER TABLE [dbo].[Pangya_User_Equip] ADD DEFAULT ((0)) FOR [POSTER_2]
1441GO
1442ALTER TABLE [dbo].[Pangya_User_MatchHistory] ADD DEFAULT ((0)) FOR [UID1]
1443GO
1444ALTER TABLE [dbo].[Pangya_User_MatchHistory] ADD DEFAULT ((0)) FOR [UID2]
1445GO
1446ALTER TABLE [dbo].[Pangya_User_MatchHistory] ADD DEFAULT ((0)) FOR [UID3]
1447GO
1448ALTER TABLE [dbo].[Pangya_User_MatchHistory] ADD DEFAULT ((0)) FOR [UID4]
1449GO
1450ALTER TABLE [dbo].[Pangya_User_MatchHistory] ADD DEFAULT ((0)) FOR [UID5]
1451GO
1452ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_Drive] DEFAULT ((0)) FOR [Drive]
1453GO
1454ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_Putt] DEFAULT ((0)) FOR [Putt]
1455GO
1456ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_Playtime] DEFAULT ((0)) FOR [Playtime]
1457GO
1458ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_Longest] DEFAULT ((0)) FOR [Longest]
1459GO
1460ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_Distance] DEFAULT ((0)) FOR [Distance]
1461GO
1462ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_Pangya] DEFAULT ((0)) FOR [Pangya]
1463GO
1464ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_Hole] DEFAULT ((0)) FOR [Hole]
1465GO
1466ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_TeamHole] DEFAULT ((0)) FOR [TeamHole]
1467GO
1468ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_Holeinone] DEFAULT ((0)) FOR [Holeinone]
1469GO
1470ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_OB] DEFAULT ((0)) FOR [OB]
1471GO
1472ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_Bunker] DEFAULT ((0)) FOR [Bunker]
1473GO
1474ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_Fairway] DEFAULT ((0)) FOR [Fairway]
1475GO
1476ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_Albatross] DEFAULT ((0)) FOR [Albatross]
1477GO
1478ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_Holein] DEFAULT ((0)) FOR [Holein]
1479GO
1480ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_Pang] DEFAULT ((3000)) FOR [Pang]
1481GO
1482ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_Timeout] DEFAULT ((0)) FOR [Timeout]
1483GO
1484ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_Game_level] DEFAULT ((0)) FOR [Game_Level]
1485GO
1486ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_Game_point] DEFAULT ((0)) FOR [Game_Point]
1487GO
1488ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_PuttIn] DEFAULT ((0)) FOR [PuttIn]
1489GO
1490ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_LongestPuttIn] DEFAULT ((0)) FOR [LongestPuttIn]
1491GO
1492ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_LongestChipIn] DEFAULT ((0)) FOR [LongestChipIn]
1493GO
1494ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_NoMannerGameCount] DEFAULT ((0)) FOR [NoMannerGameCount]
1495GO
1496ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_ShotTime] DEFAULT ((0)) FOR [ShotTime]
1497GO
1498ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_GameCount] DEFAULT ((0)) FOR [GameCount]
1499GO
1500ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_DisconnectGames] DEFAULT ((0)) FOR [DisconnectGames]
1501GO
1502ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_wTeamWin] DEFAULT ((0)) FOR [wTeamWin]
1503GO
1504ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_wTeamGames] DEFAULT ((0)) FOR [wTeamGames]
1505GO
1506ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_LadderPoint] DEFAULT ((1000)) FOR [LadderPoint]
1507GO
1508ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_LadderWin] DEFAULT ((0)) FOR [LadderWin]
1509GO
1510ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_LadderLose] DEFAULT ((0)) FOR [LadderLose]
1511GO
1512ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_LadderDraw] DEFAULT ((0)) FOR [LadderDraw]
1513GO
1514ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_ComboCount] DEFAULT ((0)) FOR [ComboCount]
1515GO
1516ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_MaxComboCount] DEFAULT ((0)) FOR [MaxComboCount]
1517GO
1518ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_TotalScore] DEFAULT ((0)) FOR [TotalScore]
1519GO
1520ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_BestScore0] DEFAULT ((127)) FOR [BestScore0]
1521GO
1522ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_BestScore1] DEFAULT ((127)) FOR [BestScore1]
1523GO
1524ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_BestScore2] DEFAULT ((127)) FOR [BestScore2]
1525GO
1526ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_BestScore3] DEFAULT ((127)) FOR [BestScore3]
1527GO
1528ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF__Pangya_Us__BESTS__5F94D2F3] DEFAULT ((127)) FOR [BESTSCORE4]
1529GO
1530ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_MaxPang0] DEFAULT ((0)) FOR [MaxPang0]
1531GO
1532ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_MaxPang1] DEFAULT ((0)) FOR [MaxPang1]
1533GO
1534ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_MaxPang2] DEFAULT ((0)) FOR [MaxPang2]
1535GO
1536ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_MaxPang3] DEFAULT ((0)) FOR [MaxPang3]
1537GO
1538ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF__Pangya_Us__MAXPA__4297D63B] DEFAULT ((0)) FOR [MAXPANG4]
1539GO
1540ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_SumPang] DEFAULT ((0)) FOR [SumPang]
1541GO
1542ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF_PangYa_User_Statistics_LadderHole] DEFAULT ((0)) FOR [LadderHole]
1543GO
1544ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF__PangYa_Us__GameC__123F82FA] DEFAULT ((0)) FOR [GameCountSeason]
1545GO
1546ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF__PangYa_Us__Skins__1333A733] DEFAULT ((0)) FOR [SkinsPang]
1547GO
1548ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF__PangYa_Us__Skins__1427CB6C] DEFAULT ((0)) FOR [SkinsWin]
1549GO
1550ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF__PangYa_Us__Skins__151BEFA5] DEFAULT ((0)) FOR [SkinsLose]
1551GO
1552ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF__PangYa_Us__Skins__161013DE] DEFAULT ((0)) FOR [SkinsRunHoles]
1553GO
1554ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF__PangYa_Us__Skins__17043817] DEFAULT ((0)) FOR [SkinsStrikePoint]
1555GO
1556ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF__PangYa_Us__Skins__17F85C50] DEFAULT ((0)) FOR [SkinsAllinCount]
1557GO
1558ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF__PangYa_Us__Event__18EC8089] DEFAULT ((0)) FOR [EventValue]
1559GO
1560ALTER TABLE [dbo].[Pangya_User_Statistics] ADD CONSTRAINT [DF__PangYa_Us__Event__19E0A4C2] DEFAULT ((0)) FOR [EventFlag]
1561GO
1562ALTER TABLE [dbo].[Pangya_Warehouse] ADD CONSTRAINT [DF_Pangya_Warehouse_UID] DEFAULT ((0)) FOR [UID]
1563GO
1564ALTER TABLE [dbo].[Pangya_Warehouse] ADD CONSTRAINT [DF_Pangya_Warehouse_C0] DEFAULT ((0)) FOR [C0]
1565GO
1566ALTER TABLE [dbo].[Pangya_Warehouse] ADD CONSTRAINT [DF_Pangya_Warehouse_C01] DEFAULT ((0)) FOR [C1]
1567GO
1568ALTER TABLE [dbo].[Pangya_Warehouse] ADD CONSTRAINT [DF_Pangya_Warehouse_C02] DEFAULT ((0)) FOR [C2]
1569GO
1570ALTER TABLE [dbo].[Pangya_Warehouse] ADD CONSTRAINT [DF_Pangya_Warehouse_C03] DEFAULT ((0)) FOR [C3]
1571GO
1572ALTER TABLE [dbo].[Pangya_Warehouse] ADD CONSTRAINT [DF_Pangya_Warehouse_C04] DEFAULT ((0)) FOR [C4]
1573GO
1574ALTER TABLE [dbo].[Pangya_Warehouse] ADD CONSTRAINT [DF_Pangya_Warehouse_RegDate] DEFAULT (getdate()) FOR [RegDate]
1575GO
1576ALTER TABLE [dbo].[Pangya_Warehouse] ADD CONSTRAINT [DF_Pangya_Warehouse_DateEnd] DEFAULT (getdate()) FOR [DateEnd]
1577GO
1578ALTER TABLE [dbo].[Pangya_Warehouse] ADD CONSTRAINT [DF_Pangya_Warehouse_VALID] DEFAULT ((1)) FOR [VALID]
1579GO
1580ALTER TABLE [dbo].[Pangya_Warehouse] ADD CONSTRAINT [DF_Pangya_Warehouse_ItemType] DEFAULT ((0)) FOR [ItemType]
1581GO
1582ALTER TABLE [dbo].[Pangya_Warehouse] ADD CONSTRAINT [DF_Pangya_Warehouse_Flag] DEFAULT ((0)) FOR [Flag]
1583GO
1584ALTER TABLE [dbo].[TD_ROOM_DATA] ADD DEFAULT ((0)) FOR [UID]
1585GO
1586ALTER TABLE [dbo].[TD_ROOM_DATA] ADD DEFAULT ((0)) FOR [TYPEID]
1587GO
1588ALTER TABLE [dbo].[TD_ROOM_DATA] ADD DEFAULT ((0)) FOR [POS_X]
1589GO
1590ALTER TABLE [dbo].[TD_ROOM_DATA] ADD DEFAULT ((0)) FOR [POS_Y]
1591GO
1592ALTER TABLE [dbo].[TD_ROOM_DATA] ADD DEFAULT ((0)) FOR [POS_Z]
1593GO
1594ALTER TABLE [dbo].[TD_ROOM_DATA] ADD DEFAULT ((0)) FOR [POS_R]
1595GO
1596ALTER TABLE [dbo].[TD_ROOM_DATA] ADD DEFAULT ((1)) FOR [VALID]
1597GO
1598ALTER TABLE [dbo].[TD_ROOM_DATA] ADD DEFAULT (getdate()) FOR [GETDATE]
1599GO
1600ALTER TABLE [dbo].[Pangya_User_Statistics] WITH NOCHECK ADD CONSTRAINT [CK_PangYa_User_Statistics] CHECK NOT FOR REPLICATION (([pang]>=(0)))
1601GO
1602ALTER TABLE [dbo].[Pangya_User_Statistics] CHECK CONSTRAINT [CK_PangYa_User_Statistics]
1603GO
1604/****** Object: StoredProcedure [dbo].[ProcAddItem] Script Date: 19/10/2018 08:23:23 ******/
1605SET ANSI_NULLS ON
1606GO
1607SET QUOTED_IDENTIFIER ON
1608GO
1609-- =============================================
1610-- Author: TOP
1611-- Create date:
1612-- Description:
1613-- =============================================
1614CREATE PROCEDURE [dbo].[ProcAddItem]
1615 @UID INT,
1616 @IFFTYPEID INT,
1617 @QUANTITY INT,
1618 @ISUCC TINYINT,
1619 @ITEM_TYPE TINYINT,
1620 @DAY INT
1621AS
1622BEGIN
1623 SET NOCOUNT ON;
1624
1625 DECLARE @ITEM_GRP INT = 0
1626 DECLARE @ITEM_ID BIGINT
1627 DECLARE @UCC_KEY VARCHAR(8) = '';
1628 -- FOR CADDIE
1629 DECLARE @DATETIME DATETIME
1630
1631 SET @ITEM_GRP = [dbo].UDF_PARTS_GROUP(@IFFTYPEID)
1632
1633 /********************
1634 * 1. CHARACTER
1635 ********************/
1636 IF (@ITEM_GRP = 1) BEGIN
1637 SET @ITEM_ID = (SELECT CID FROM [DBO].Pangya_Character WHERE UID = @UID AND TYPEID = @IFFTYPEID)
1638 IF (@ITEM_ID <= 0) OR (@ITEM_ID IS NULL) BEGIN
1639 INSERT INTO [DBO].Pangya_Character(UID, TYPEID) VALUES (@UID, @IFFTYPEID)
1640 SET @ITEM_ID = SCOPE_IDENTITY()
1641 IF (@ITEM_ID > 0) BEGIN
1642 INSERT INTO [DBO].Pangya_Character_Equip(UID, CHAR_IDX) VALUES (@UID, @ITEM_ID)
1643 END
1644 END
1645 END
1646
1647 /********************
1648 * 2. PART
1649 ********************/
1650 IF (@ITEM_GRP = 2) BEGIN -- PART ITEM
1651 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES(@UID, @IFFTYPEID, 0)
1652 SET @ITEM_ID = SCOPE_IDENTITY()
1653 -- CHECK IF UCC
1654 IF @ISUCC = 1 BEGIN
1655 WHILE (1=1) BEGIN
1656 SELECT @UCC_KEY = UPPER(LEFT(NEWID(), 8))
1657 IF NOT EXISTS(SELECT 1 FROM DBO.Pangya_SelfDesign WHERE UID = @UID AND UCC_UNIQE = @UCC_KEY) BEGIN
1658 BREAK
1659 END
1660 END
1661 INSERT INTO [dbo].Pangya_SelfDesign(UID, ITEM_ID, UCC_UNIQE, TYPEID) VALUES (@UID, @ITEM_ID, @UCC_KEY, @IFFTYPEID)
1662 END
1663 -- END IF UCC
1664 END
1665
1666 /********************
1667 * 5,6. ITEM, BALL
1668 ********************/
1669 IF (@ITEM_GRP = 6) OR (@ITEM_GRP = 5) BEGIN -- {NORMAL ITEM} AND {BALL}
1670 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES(@UID, @IFFTYPEID, @QUANTITY)
1671 SET @ITEM_ID = SCOPE_IDENTITY()
1672 END
1673
1674 /********************
1675 * 7. CADDIE
1676 ********************/
1677 IF (@ITEM_GRP = 7) BEGIN -- CADDIE
1678 -- CHECK CADDIE
1679 IF @ITEM_TYPE = 2 BEGIN
1680 SET @DATETIME = DATEADD(DAY, 30, GETDATE())
1681 END ELSE BEGIN
1682 SET @DATETIME = GETDATE()
1683 END
1684 -- END
1685 INSERT INTO DBO.Pangya_Caddie(UID, TYPEID, RentFlag, END_DATE) VALUES (@UID, @IFFTYPEID, @ITEM_TYPE, @DATETIME)
1686 SET @ITEM_ID = SCOPE_IDENTITY()
1687 END
1688
1689 /********************
1690 * 14. SKIN
1691 ********************/
1692 IF (@ITEM_GRP = 14) BEGIN -- SKIN
1693 -- TO CHECK
1694 IF @ITEM_TYPE = 0 BEGIN
1695 SET @DATETIME = GETDATE()
1696 END ELSE BEGIN
1697 SET @DATETIME = DATEADD(DAY, ISNULL(@DAY, 1), GETDATE())
1698 END
1699 -- END CHECK
1700 INSERT INTO [dbo].Pangya_Warehouse(UID, TYPEID, C0, DateEnd, Flag) VALUES(@UID, @IFFTYPEID, 0, @DATETIME, @ITEM_TYPE)
1701 SET @ITEM_ID = SCOPE_IDENTITY()
1702 END
1703
1704 /********************
1705 * 31. CARD
1706 ********************/
1707 IF (@ITEM_GRP = 31) BEGIN -- CARD
1708 INSERT INTO DBO.Pangya_Card(UID, CARD_TYPEID, QTY, VALID) VALUES (@UID, @IFFTYPEID, @QUANTITY, 1)
1709 SET @ITEM_ID = SCOPE_IDENTITY()
1710 END
1711
1712 /********************
1713 * 4. CLUB SET
1714 ********************/
1715 IF (@ITEM_GRP = 4) BEGIN -- Club Set
1716 INSERT INTO DBO.Pangya_Warehouse(UID, TYPEID) VALUES (@UID, @IFFTYPEID)
1717 SET @ITEM_ID = SCOPE_IDENTITY()
1718 INSERT INTO DBO.Pangya_Club_Info(ITEM_ID) VALUES (@ITEM_ID)
1719 END
1720
1721 /*******************
1722 Send Result
1723 *******************/
1724 IF (@ITEM_ID > 0) BEGIN
1725 SELECT @ITEM_ID AS IDX,
1726 @IFFTYPEID AS iffTypeId,
1727 @QUANTITY AS Quantity,
1728 @UCC_KEY AS UCC_KEY,
1729 @ITEM_GRP AS GROUPS,
1730 @ITEM_TYPE AS Flag,
1731 @DATETIME AS END_DATE
1732 END
1733END
1734GO
1735/****** Object: StoredProcedure [dbo].[ProcAddRent] Script Date: 19/10/2018 08:23:23 ******/
1736SET ANSI_NULLS ON
1737GO
1738SET QUOTED_IDENTIFIER ON
1739GO
1740CREATE PROCEDURE [dbo].[ProcAddRent]
1741 @UID INT,
1742 @TYPEID INT,
1743 @DAY_IN INT = 7
1744AS
1745BEGIN
1746 SET NOCOUNT ON
1747
1748 DECLARE @DATEEND DATETIME = GETDATE()
1749
1750 INSERT INTO [dbo].Pangya_Warehouse(UID, TYPEID, C0, Flag, DateEnd) VALUES(@UID, @TYPEID, 0, 0x60, DATEADD(DAY, @DAY_IN, @DATEEND) )
1751
1752 SELECT ITEM_INDEX = SCOPE_IDENTITY(),
1753 ITEM_TYPEID = @TYPEID,
1754 ITEM_FLAG = 96,
1755 ITEM_DATE_END = DATEADD(DAY, @DAY_IN, @DATEEND)
1756END
1757GO
1758/****** Object: StoredProcedure [dbo].[ProcAlterAchievement] Script Date: 19/10/2018 08:23:23 ******/
1759SET ANSI_NULLS ON
1760GO
1761SET QUOTED_IDENTIFIER ON
1762GO
1763-- =============================================
1764-- Author: Name
1765-- Create date:
1766-- Description:
1767-- =============================================
1768CREATE PROCEDURE [dbo].[ProcAlterAchievement]
1769 @UID INT,
1770 @AchievementTypeID INT,
1771 @Quantity INT
1772 AS
1773BEGIN
1774 SET NOCOUNT ON;
1775
1776 DECLARE @QID INT
1777 DECLARE @QINDEX INT
1778 DECLARE @QTYPEID INT
1779 DECLARE @QCOUNTERTYPEID INT
1780 DECLARE @QCOUNTERQTY INT
1781 DECLARE @QACHIEVEMENTTYPEID INT
1782
1783 DECLARE @CounterID INT = 0
1784 DECLARE @CounterQTY INT = 0
1785 DECLARE @CounterTypeID INT = 0
1786
1787 DECLARE @LastInsertID INT = 0
1788
1789 -- FETCH COUNTER THAT MATCH ACIEVEMENT TYPE ID
1790 ;WITH AchievementUpdate(ID, TypeID,Quantity) AS(
1791 SELECT A.ID,
1792 A.TypeID,
1793 A.Quantity
1794 FROM DBO.Pangya_Achievement_Counter A
1795 CROSS APPLY(
1796 SELECT ID
1797 FROM DBO.Pangya_Achievement
1798 WHERE UID = @UID AND TypeID = @AchievementTypeID
1799 ) B
1800 CROSS APPLY (
1801 SELECT TOP 1 Counter_Index
1802 FROM DBO.Pangya_Achievement_Quest
1803 WHERE Achievement_Index = B.ID AND SuccessDate IS NULL
1804 ) C
1805 WHERE A.ID = C.Counter_Index)
1806
1807 -- UPDATE THAT FECHED
1808 UPDATE AchievementUpdate
1809 SET Quantity += @Quantity,
1810 -- HACK WAY
1811 @CounterTypeID = TypeID,
1812 @CounterID = ID,
1813 @CounterQTY = Quantity;
1814
1815 IF (@@ROWCOUNT > 0)
1816 BEGIN
1817 -- DECLARE COUNTER TABLE
1818 DECLARE @CounterTable TABLE (CounterID INT, CounterTypeID INT, CounterOld INT, CounterNew INT, CounterAdd INT)
1819
1820 -- QUEST UPDATE
1821 DECLARE @QuestUpdate TABLE (ID INT IDENTITY(1,1), QuestIndex INT, QuestTypeID INT, CounterTypeID INT, CounterQTY INT, AchievementTypeID INT)
1822
1823 -- QUEST TRIGGER
1824 DECLARE @QuestTrigger TABLE (AchievementTypeID INT, QuestTypeID INT)
1825
1826 -- INSERT COUNTER UPDATE
1827 INSERT INTO @CounterTable(CounterID, CounterTypeID, CounterOld, CounterNew, CounterAdd)
1828 VALUES(@CounterID, @CounterTypeID, @CounterQTY, @CounterQTY + @Quantity, @Quantity)
1829
1830 -- INSERT INTO QUEST TO BE UPDATE
1831 INSERT INTO @QuestUpdate(QuestIndex, QuestTypeID, CounterTypeID, CounterQTY, AchievementTypeID)
1832 SELECT A.ID, A.Achivement_Quest_TypeID, B.TypeID, A.Count, C.TypeID
1833 FROM DBO.Pangya_Achievement_Quest A
1834 INNER JOIN DBO.Pangya_Achievement_Counter B
1835 ON B.ID = A.Counter_Index
1836 INNER JOIN DBO.Pangya_Achievement C
1837 ON C.ID = A.Achievement_Index
1838 WHERE A.UID = @UID AND B.Quantity >= A.Count AND A.SuccessDate IS NULL
1839
1840 WHILE EXISTS (SELECT 1 FROM @QuestUpdate)
1841 BEGIN
1842 -- GET TOP 1 FROM TEMP TABLE
1843 SELECT TOP 1
1844 @QID = ID,
1845 @QINDEX = QuestIndex,
1846 @QTYPEID = QuestTypeID,
1847 @QCOUNTERTYPEID = CounterTypeID,
1848 @QCOUNTERQTY = CounterQTY,
1849 @QACHIEVEMENTTYPEID = AchievementTypeID
1850 FROM @QuestUpdate
1851
1852 -- FIRST INSERT INTO COUNTER
1853 INSERT INTO DBO.Pangya_Achievement_Counter(UID, TypeID, Quantity) VALUES (@UID, @QCOUNTERTYPEID, @QCOUNTERQTY)
1854 SET @LastInsertID = SCOPE_IDENTITY()
1855
1856 -- UPDATE THE OLD ONE
1857 UPDATE [DBO].Pangya_Achievement_Quest
1858 SET Counter_Index = @LastInsertID,
1859 SuccessDate = GETDATE()
1860 WHERE UID = @UID AND
1861 ID = @QINDEX
1862
1863 -- INSERT INTO TEMP COUNTER
1864 INSERT INTO @CounterTable(CounterID, CounterTypeID, CounterOld, CounterNew, CounterAdd)
1865 VALUES(@LastInsertID, @QCOUNTERTYPEID, 0, @QCOUNTERQTY, @QCOUNTERQTY)
1866
1867 -- INSERT INTO TRIGGER
1868 INSERT INTO @QuestTrigger(AchievementTypeID, QuestTypeID) VALUES (@QACHIEVEMENTTYPEID, @QTYPEID)
1869
1870 -- SELECT THE QUEST THAT'S BEEN PROGRESSED
1871 DELETE FROM @QuestUpdate WHERE ID = @QID
1872 END
1873 END
1874
1875 SELECT * FROM @CounterTable FOR JSON AUTO, ROOT ('Counters')
1876 SELECT * FROM @QuestTrigger FOR JSON AUTO, ROOT ('Quests')
1877
1878
1879 SELECT A.TypeID, A.ID, QuestData.* FROM
1880 ( SELECT ID, TypeID
1881 FROM DBO.Pangya_Achievement
1882 WHERE UID = @UID AND TypeID = @AchievementTypeID
1883 ) A
1884 CROSS APPLY (
1885 SELECT B.Achivement_Quest_TypeID, C.TypeID, C.ID, C.Quantity, ISNULL(DBO.UNIX_TIMESTAMP(B.SuccessDate), 0) AS SuccessDate
1886 FROM DBO.Pangya_Achievement_Quest B
1887 INNER JOIN DBO.Pangya_Achievement_Counter C
1888 ON C.ID = B.Counter_Index
1889 WHERE B.Achievement_Index = A.ID
1890 ) QuestData
1891 FOR JSON AUTO, ROOT ('QuestData')
1892
1893END
1894GO
1895/****** Object: StoredProcedure [dbo].[ProcAlterDaily] Script Date: 19/10/2018 08:23:23 ******/
1896SET ANSI_NULLS ON
1897GO
1898SET QUOTED_IDENTIFIER ON
1899GO
1900-- =============================================
1901-- Author: TOP
1902-- Create date: 12/7/2560 13:15
1903-- Description:
1904-- =============================================
1905CREATE PROCEDURE [dbo].[ProcAlterDaily]
1906 @UID INT,
1907 @TYPE TINYINT = 0
1908AS
1909BEGIN
1910 SET NOCOUNT ON;
1911
1912 DECLARE @DATENOW DATE = CONVERT (DATE, GETDATE())
1913
1914 DECLARE @ItemTypeID INT = 0
1915 DECLARE @ItemQuantity INT = 0
1916 DECLARE @MailString VARCHAR(255)
1917
1918 SELECT @ItemTypeID = ItemTypeID, @ItemQuantity = Quantity FROM [DBO].Pangya_Item_Daily WHERE DATE = @DATENOW
1919
1920 IF NOT EXISTS (SELECT 1 FROM [DBO].Pangya_Item_Daily_Log WHERE UID = @UID AND DATE = @DATENOW)
1921 BEGIN
1922 IF (@TYPE = 1)
1923 BEGIN
1924 UPDATE [DBO].Pangya_Member SET DailyLoginCount = DailyLoginCount + 1 WHERE UID = @UID
1925 INSERT INTO [DBO].Pangya_Item_Daily_Log(UID, ItemTypeID, Quantity) VALUES(@UID, @ItemTypeID, @ItemQuantity)
1926 SELECT @MailString = FORMATMESSAGE('^%d^%d,', @ItemTypeID, @ItemQuantity)
1927 --EXEC [dbo].[USP_MAIL_INSERT] @UID, 'System', 'ได้เข้าร่วมรางวัลà¹à¸¥à¹‰à¸§', @ItemTypeID, @ItemQuantity, @MailString
1928 END
1929
1930 SELECT
1931 CASE WHEN @TYPE = 1 THEN 1 ELSE 0 END AS CODE
1932 ,A.ItemTypeID
1933 ,A.Quantity
1934 ,C.ItemTypeID AS ItemTypeIDTmr
1935 ,C.Quantity AS ItemQuantityTmr
1936 ,ISNULL(B.DailyLoginCount, 0) AS DailyCount
1937 FROM
1938 (SELECT @ItemTypeID AS ItemTypeID, @ItemQuantity AS Quantity) A
1939 INNER JOIN [DBO].Pangya_Member B ON UID = @UID
1940 LEFT JOIN [DBO].Pangya_Item_Daily C ON C.DATE = DATEADD(DAY, 1, @DATENOW)
1941 END ELSE BEGIN
1942 SELECT
1943 CODE = 1,
1944 A.ItemTypeID,
1945 A.Quantity,
1946 C.ItemTypeID AS ItemTypeIDTmr,
1947 C.Quantity AS ItemQuantityTmr,
1948 ISNULL(B.DailyLoginCount, 0) AS DailyCount
1949 FROM
1950 (SELECT @ItemTypeID AS ItemTypeID, @ItemQuantity AS Quantity) A
1951 INNER JOIN [DBO].Pangya_Member B ON UID = @UID
1952 LEFT JOIN [DBO].Pangya_Item_Daily C ON C.DATE = DATEADD(DAY, 1, @DATENOW)
1953 END
1954END
1955GO
1956/****** Object: StoredProcedure [dbo].[ProcCheckUsername] Script Date: 19/10/2018 08:23:23 ******/
1957SET ANSI_NULLS ON
1958GO
1959SET QUOTED_IDENTIFIER ON
1960GO
1961-- =============================================
1962-- Author: TOP
1963-- Create date:
1964-- Description:
1965-- =============================================
1966CREATE PROCEDURE [dbo].[ProcCheckUsername]
1967 @USERNAME VARCHAR(32)
1968AS
1969BEGIN
1970 SET NOCOUNT ON;
1971
1972 SELECT UID, Username, Nickname FROM [dbo].Pangya_Member WHERE Username = LTRIM(RTRIM(@USERNAME))
1973END
1974GO
1975/****** Object: StoredProcedure [dbo].[ProcCreateAchievement] Script Date: 19/10/2018 08:23:23 ******/
1976SET ANSI_NULLS ON
1977GO
1978SET QUOTED_IDENTIFIER ON
1979GO
1980-- =============================================
1981-- Author: TOP
1982-- Create date:
1983-- Description:
1984-- =============================================
1985CREATE PROCEDURE [dbo].[ProcCreateAchievement]
1986 @UID INT
1987AS
1988BEGIN
1989 SET NOCOUNT ON;
1990
1991 DECLARE @TypeID INT
1992 DECLARE @CounterTypeID INT
1993 DECLARE @AchivementIndex INT
1994 DECLARE @CounterIndex INT
1995
1996 IF (OBJECT_ID('TEMPDB..#Achievement') IS NOT NULL)
1997 DROP TABLE #Achievement
1998
1999 CREATE TABLE #Achievement (AchievementTypeID INT, CounterTypeID INT ,QuestTypeID INT, CounterQuantity INT)
2000
2001 INSERT INTO #Achievement(AchievementTypeID, CounterTypeID, QuestTypeID, CounterQuantity)
2002 SELECT A.ACHIEVEMENT_TYPEID, B.CounterTypeID, B.TypeID, b.CounterQuantity
2003 FROM [DBO].Achievement_Data A
2004 INNER JOIN [DBO].Achievement_QuestStuffs B
2005 ON B.TypeID = A.ACHIEVEMENT_QUEST_TYPEID
2006
2007 -- CREATE INDEX
2008 CREATE CLUSTERED INDEX IDX_READ_ACH ON #Achievement (AchievementTypeID)
2009
2010 WHILE EXISTS (SELECT 1 FROM #Achievement) BEGIN
2011 SELECT TOP 1 @TypeID = AchievementTypeID, @CounterTypeID = CounterTypeID FROM #Achievement ORDER BY AchievementTypeID ASC
2012
2013 INSERT INTO [DBO].Pangya_Achievement(UID, TypeID) SELECT @UID, @TypeID
2014 SET @AchivementIndex = SCOPE_IDENTITY()
2015
2016 -- INSERT INTO COUNTER
2017 INSERT INTO [DBO].Pangya_Achievement_Counter(UID, TypeID, Quantity) VALUES (@UID, @CounterTypeID, 0)
2018 SET @CounterIndex = SCOPE_IDENTITY()
2019
2020 -- INSERT INTO QUEST
2021 INSERT INTO [DBO].Pangya_Achievement_Quest(UID, Achievement_Index, Achivement_Quest_TypeID, Counter_Index, Count, SuccessDate)
2022 SELECT @UID, @AchivementIndex, QuestTypeID, @CounterIndex, CounterQuantity, Null
2023 FROM #Achievement WHERE AchievementTypeID = @TypeID
2024
2025 DELETE FROM #Achievement WHERE AchievementTypeID = @TypeID
2026 END
2027END
2028GO
2029/****** Object: StoredProcedure [dbo].[ProcDeleteRentItem] Script Date: 19/10/2018 08:23:23 ******/
2030SET ANSI_NULLS ON
2031GO
2032SET QUOTED_IDENTIFIER ON
2033GO
2034CREATE PROCEDURE [dbo].[ProcDeleteRentItem]
2035 @UID INT
2036AS
2037BEGIN
2038 SET NOCOUNT ON;
2039
2040 DECLARE @CURRTIME SMALLDATETIME
2041 SELECT @CURRTIME = GETDATE()
2042
2043 UPDATE [DBO].Pangya_Warehouse
2044 SET VALID = 0
2045 WHERE UID = @UID AND
2046 ItemType = 2 AND
2047 DATEDIFF(DAY, @CURRTIME, DateEnd) < 0 AND
2048 DATEDIFF(HOUR, @CURRTIME, DateEnd) < 0 AND
2049 VALID = 1
2050END
2051GO
2052/****** Object: StoredProcedure [dbo].[ProcDelMail] Script Date: 19/10/2018 08:23:23 ******/
2053SET ANSI_NULLS ON
2054GO
2055SET QUOTED_IDENTIFIER ON
2056GO
2057-- =============================================
2058-- Author: TOP
2059-- Create date:
2060-- Description:
2061-- =============================================
2062CREATE PROCEDURE [dbo].[ProcDelMail]
2063 @UID INT,
2064 @JASONData NVARCHAR(MAX)
2065AS
2066BEGIN
2067 SET NOCOUNT ON;
2068
2069 BEGIN TRY
2070 BEGIN TRAN
2071
2072 UPDATE DBO.Pangya_Mail
2073 SET DeleteDate = GETDATE()
2074 FROM OPENJSON(@JASONData, '$.MailDelete')
2075 WITH (
2076 MailIndex INT
2077 ) AS A
2078 WHERE UID = @UID AND
2079 Mail_Index = A.MailIndex
2080
2081 IF @@ERROR = 0
2082 BEGIN
2083 COMMIT TRAN
2084 SELECT RET = 1
2085 END ELSE BEGIN
2086 ROLLBACK TRAN
2087 SELECT RET = 0
2088 END
2089 END TRY
2090 BEGIN CATCH
2091
2092 END CATCH
2093END
2094GO
2095/****** Object: StoredProcedure [dbo].[ProcGet_UserInfo] Script Date: 19/10/2018 08:23:23 ******/
2096SET ANSI_NULLS ON
2097GO
2098SET QUOTED_IDENTIFIER ON
2099GO
2100CREATE PROCEDURE [dbo].[ProcGet_UserInfo]
2101 @UID INT
2102AS
2103BEGIN
2104 SET NOCOUNT ON
2105
2106 /* BASIC USER INFO */
2107 SELECT
2108 A.UID,
2109 A.Username,
2110 A.Nickname,
2111 A.Sex,
2112 A.GUILDINDEX,
2113 B.GUILD_NAME,
2114 ISNULL( B.GUILD_IMAGE, 'guildmark' ) AS GUILD_IMAGE
2115 FROM
2116 DBO.Pangya_Member A
2117 LEFT JOIN [DBO].Pangya_Guild_Info AS B ON B.GUILD_INDEX = A.GUILDINDEX
2118 WHERE
2119 UID = @UID
2120
2121 /* CHARACTER INFO */
2122 SELECT
2123 B.TYPEID,
2124 B.CID,
2125 B.GIFT_FLAG,
2126 B.HAIR_COLOR,
2127 B.POWER,
2128 B.CONTROL,
2129 B.IMPACT,
2130 B.SPIN,
2131 B.CURVE,
2132 B.CUTIN,
2133 C.PART_TYPEID_1,
2134 C.PART_TYPEID_2,
2135 C.PART_TYPEID_3,
2136 C.PART_TYPEID_4,
2137 C.PART_TYPEID_5,
2138 C.PART_TYPEID_6,
2139 C.PART_TYPEID_7,
2140 C.PART_TYPEID_8,
2141 C.PART_TYPEID_9,
2142 C.PART_TYPEID_10,
2143 C.PART_TYPEID_11,
2144 C.PART_TYPEID_12,
2145 C.PART_TYPEID_13,
2146 C.PART_TYPEID_14,
2147 C.PART_TYPEID_15,
2148 C.PART_TYPEID_16,
2149 C.PART_TYPEID_17,
2150 C.PART_TYPEID_18,
2151 C.PART_TYPEID_19,
2152 C.PART_TYPEID_20,
2153 C.PART_TYPEID_21,
2154 C.PART_TYPEID_22,
2155 C.PART_TYPEID_23,
2156 C.PART_TYPEID_24,
2157 C.PART_IDX_1,
2158 C.PART_IDX_2,
2159 C.PART_IDX_3,
2160 C.PART_IDX_4,
2161 C.PART_IDX_5,
2162 C.PART_IDX_6,
2163 C.PART_IDX_7,
2164 C.PART_IDX_8,
2165 C.PART_IDX_9,
2166 C.PART_IDX_10,
2167 C.PART_IDX_11,
2168 C.PART_IDX_12,
2169 C.PART_IDX_13,
2170 C.PART_IDX_14,
2171 C.PART_IDX_15,
2172 C.PART_IDX_16,
2173 C.PART_IDX_17,
2174 C.PART_IDX_18,
2175 C.PART_IDX_19,
2176 C.PART_IDX_20,
2177 C.PART_IDX_21,
2178 C.PART_IDX_22,
2179 C.PART_IDX_23,
2180 C.PART_IDX_24
2181 FROM
2182 DBO.Pangya_User_Equip A
2183 INNER JOIN DBO.Pangya_Character B ON B.CID = A.CHARACTER_ID
2184 INNER JOIN DBO.Pangya_Character_Equip C ON C.CHAR_IDX = B.CID
2185 WHERE
2186 A.UID = @UID
2187
2188
2189END
2190GO
2191/****** Object: StoredProcedure [dbo].[ProcGetAchievement] Script Date: 19/10/2018 08:23:23 ******/
2192SET ANSI_NULLS ON
2193GO
2194SET QUOTED_IDENTIFIER ON
2195GO
2196-- =============================================
2197-- Author: TOP
2198-- Create date:
2199-- Description:
2200-- =============================================
2201CREATE PROCEDURE [dbo].[ProcGetAchievement]
2202 @UID INT
2203AS
2204BEGIN
2205 SET NOCOUNT ON;
2206
2207 -- 1. GET TABLE Pangya_Achievement
2208 SELECT ID, TypeID, Type
2209 FROM DBO.Pangya_Achievement
2210 WHERE UID = @UID AND Valid = 1
2211
2212 -- 2. GET TABLE Pangya_Achievement_Counter
2213 SELECT ID, TypeID, Quantity
2214 FROM DBO.Pangya_Achievement_Counter
2215 WHERE UID = @UID
2216
2217 -- 3. GET TABLE Pangya_Achievement_Quest
2218 SELECT ID, Achievement_Index, Achivement_Quest_TypeID, Counter_Index, ISNULL(DBO.UNIX_TIMESTAMP(SuccessDate), 0) AS SuccessDate, Count
2219 FROM DBO.Pangya_Achievement_Quest
2220 WHERE UID = @UID
2221 ORDER BY Count ASC
2222
2223 /*SELECT
2224 B.*
2225 FROM
2226 (
2227 SELECT A.TypeID AS AchTypeID,
2228 A.ID AS AchID,
2229 QuestData.Achivement_Quest_TypeID,
2230 CounterData.TypeID AS CounterTypeID,
2231 CounterData.ID AS CounterID,
2232 CounterData.Quantity,
2233 ISNULL(DBO.UNIX_TIMESTAMP(QuestData.SuccessDate), 0) AS SuccessDate,
2234 QuestData.Count
2235 FROM [DBO].Pangya_Achievement A
2236 INNER JOIN [DBO].Pangya_Achievement_Quest QuestData
2237 ON QuestData.Achievement_Index = A.ID
2238 INNER JOIN [DBO].Pangya_Achievement_Counter CounterData
2239 ON CounterData.ID = QuestData.Counter_Index
2240 WHERE A.UID = @UID
2241 ) B
2242 ORDER BY B.AchTypeID ASC, B.Count ASC --, QuestData.Count ASC FOR JSON AUTO , ROOT ('Achievement')*/
2243END
2244GO
2245/****** Object: StoredProcedure [dbo].[ProcGetCaddies] Script Date: 19/10/2018 08:23:23 ******/
2246SET ANSI_NULLS ON
2247GO
2248SET QUOTED_IDENTIFIER ON
2249GO
2250
2251-- =============================================
2252-- Author: TOP
2253-- Create date:
2254-- Description:
2255-- =============================================
2256CREATE PROCEDURE [dbo].[ProcGetCaddies]
2257 @UID INT
2258AS
2259BEGIN
2260 SET NOCOUNT ON;
2261
2262 UPDATE [dbo].Pangya_Caddie SET SKIN_TYPEID = 0 , SKIN_END_DATE = NULL WHERE UID = @UID AND SKIN_END_DATE < GETDATE()
2263
2264 SELECT CID
2265 ,TYPEID
2266 ,EXP
2267 ,SKIN_TYPEID
2268 ,TriggerPay
2269 ,cLevel
2270 ,DATEDIFF(HOUR, GETDATE(), SKIN_END_DATE) AS SKIN_HOUR_LEFT
2271 ,DATEDIFF(DAY, GETDATE(), END_DATE) AS DAY_LEFT
2272 ,END_DATE
2273 ,RentFlag
2274 ,SKIN_END_DATE
2275 FROM [dbo].Pangya_Caddie
2276 WHERE UID = @UID
2277END
2278GO
2279/****** Object: StoredProcedure [dbo].[ProcGetCard] Script Date: 19/10/2018 08:23:23 ******/
2280SET ANSI_NULLS ON
2281GO
2282SET QUOTED_IDENTIFIER ON
2283GO
2284
2285-- =============================================
2286-- Author: TOP
2287-- Create date:
2288-- Description:
2289-- =============================================
2290CREATE PROCEDURE [dbo].[ProcGetCard] @UID INT
2291AS
2292BEGIN
2293 SET NOCOUNT ON;
2294
2295 SELECT CARD_IDX
2296 ,CARD_TYPEID
2297 ,QTY
2298 ,VALID
2299 FROM [dbo].Pangya_Card
2300 WHERE UID = @UID
2301 AND VALID = 1
2302 AND QTY > 0
2303END
2304GO
2305/****** Object: StoredProcedure [dbo].[ProcGetCardEquip] Script Date: 19/10/2018 08:23:23 ******/
2306SET ANSI_NULLS ON
2307GO
2308SET QUOTED_IDENTIFIER ON
2309GO
2310CREATE PROCEDURE [dbo].[ProcGetCardEquip]
2311 @UID INT
2312AS
2313BEGIN
2314 SET NOCOUNT ON
2315
2316 UPDATE DBO.Pangya_Card_Equip
2317 SET VALID = 0
2318 WHERE UID = @UID
2319 AND FLAG = 1
2320 AND GETDATE() > ENDDATE
2321
2322 SELECT ID
2323 , CID
2324 , CHAR_TYPEID
2325 , CARD_TYPEID
2326 , SLOT
2327 , FLAG
2328 , REGDATE
2329 , ENDDATE
2330 FROM Pangya_Card_Equip
2331 WHERE UID = @UID
2332 AND VALID = 1
2333 -- OR GETDATE() BETWEEN REGDATE AND ENDDATE
2334END
2335GO
2336/****** Object: StoredProcedure [dbo].[ProcGetCharacter] Script Date: 19/10/2018 08:23:23 ******/
2337SET ANSI_NULLS ON
2338GO
2339SET QUOTED_IDENTIFIER ON
2340GO
2341-- =============================================
2342-- Author: TOP
2343-- Create date:
2344-- Description:
2345-- =============================================
2346CREATE PROCEDURE [dbo].[ProcGetCharacter]
2347 @UID INT
2348AS
2349BEGIN
2350 SET NOCOUNT ON;
2351
2352 SELECT A.*
2353 ,B.PART_TYPEID_1
2354 ,B.PART_TYPEID_2
2355 ,B.PART_TYPEID_3
2356 ,B.PART_TYPEID_4
2357 ,B.PART_TYPEID_5
2358 ,B.PART_TYPEID_6
2359 ,B.PART_TYPEID_7
2360 ,B.PART_TYPEID_8
2361 ,B.PART_TYPEID_9
2362 ,B.PART_TYPEID_10
2363 ,B.PART_TYPEID_11
2364 ,B.PART_TYPEID_12
2365 ,B.PART_TYPEID_13
2366 ,B.PART_TYPEID_14
2367 ,B.PART_TYPEID_15
2368 ,B.PART_TYPEID_16
2369 ,B.PART_TYPEID_17
2370 ,B.PART_TYPEID_18
2371 ,B.PART_TYPEID_19
2372 ,B.PART_TYPEID_20
2373 ,B.PART_TYPEID_21
2374 ,B.PART_TYPEID_22
2375 ,B.PART_TYPEID_23
2376 ,B.PART_TYPEID_24
2377 ,B.PART_IDX_1
2378 ,B.PART_IDX_2
2379 ,B.PART_IDX_3
2380 ,B.PART_IDX_4
2381 ,B.PART_IDX_5
2382 ,B.PART_IDX_6
2383 ,B.PART_IDX_7
2384 ,B.PART_IDX_8
2385 ,B.PART_IDX_9
2386 ,B.PART_IDX_10
2387 ,B.PART_IDX_11
2388 ,B.PART_IDX_12
2389 ,B.PART_IDX_13
2390 ,B.PART_IDX_14
2391 ,B.PART_IDX_15
2392 ,B.PART_IDX_16
2393 ,B.PART_IDX_17
2394 ,B.PART_IDX_18
2395 ,B.PART_IDX_19
2396 ,B.PART_IDX_20
2397 ,B.PART_IDX_21
2398 ,B.PART_IDX_22
2399 ,B.PART_IDX_23
2400 ,B.PART_IDX_24
2401 FROM (
2402 SELECT UID
2403 ,TYPEID
2404 ,CID
2405 ,HAIR_COLOR
2406 ,GIFT_FLAG
2407 ,POWER
2408 ,CONTROL
2409 ,IMPACT
2410 ,SPIN
2411 ,CURVE
2412 ,CUTIN
2413 FROM [dbo].Pangya_Character
2414 WHERE UID = @UID
2415 ) A
2416 LEFT JOIN [dbo].Pangya_Character_Equip B ON B.CHAR_IDX = A.CID
2417END
2418GO
2419/****** Object: StoredProcedure [dbo].[ProcGetGameServer] Script Date: 19/10/2018 08:23:23 ******/
2420SET ANSI_NULLS ON
2421GO
2422SET QUOTED_IDENTIFIER ON
2423GO
2424
2425CREATE PROCEDURE [dbo].[ProcGetGameServer]
2426
2427AS
2428BEGIN
2429 SET NOCOUNT ON;
2430
2431 SELECT ServerID,
2432 Name,
2433 IP,
2434 Port,
2435 ImgNo,
2436 ImgEvent
2437 FROM
2438 [dbo].Pangya_Server
2439 WHERE
2440 ServerType = 0;
2441END
2442GO
2443/****** Object: StoredProcedure [dbo].[ProcGetItemWarehouse] Script Date: 19/10/2018 08:23:23 ******/
2444SET ANSI_NULLS ON
2445GO
2446SET QUOTED_IDENTIFIER ON
2447GO
2448-- =============================================
2449-- Author: TOP
2450-- Create date:
2451-- Description:
2452-- =============================================
2453CREATE PROCEDURE [dbo].[ProcGetItemWarehouse] @UID INT
2454AS
2455BEGIN
2456 SET NOCOUNT ON;
2457
2458 /*
2459 0x20 = PERIOD
2460 0x21 = SKIN PERIOD
2461 0x60 = RENT PART IS ACTIVATE
2462 0x62 = RENT PART END
2463 */
2464
2465 -- UPDATE TEMPORARY ITEM
2466 -- PERIOD ITEM
2467 UPDATE DBO.Pangya_Warehouse
2468 SET VALID = 0
2469 WHERE UID = @UID AND
2470 VALID = 1 AND
2471 Flag IN (0x20, 0x21) AND
2472 DATEDIFF(MINUTE, GETDATE(), DateEnd) < 0
2473
2474 -- RENTAL ITEM
2475 UPDATE DBO.Pangya_Warehouse
2476 SET Flag = 0x62
2477 WHERE UID = @UID AND
2478 VALID = 1 AND
2479 Flag = 0x60 AND
2480 DATEDIFF(MINUTE, GETDATE(), DateEnd) < 0
2481
2482 SELECT A.*
2483 ,B.UCC_UNIQE
2484 ,B.UCC_STATUS
2485 ,B.UCC_COPY_COUNT
2486 ,B.UCC_NAME
2487 ,B.Nickname AS UCC_DRAWER
2488 ,B.UCC_DRAWER AS UCC_DRAWER_UID
2489 ,Q.CLUB_POINT
2490 ,Q.CLUB_WORK_COUNT
2491 ,Q.C0_SLOT
2492 ,Q.C1_SLOT
2493 ,Q.C2_SLOT
2494 ,Q.C3_SLOT
2495 ,Q.C4_SLOT
2496 ,Q.CLUB_SLOT_CANCEL
2497 ,Q.CLUB_POINT_TOTAL_LOG
2498 ,Q.CLUB_UPGRADE_PANG_LOG
2499 FROM (
2500 SELECT item_id AS IDX
2501 ,TYPEID
2502 ,C0
2503 ,C1
2504 ,C2
2505 ,C3
2506 ,C4
2507 ,Flag
2508 ,CASE
2509 WHEN (Flag in (0x60, 0x20, 0x21) )
2510 THEN DATEDIFF(HOUR, GETDATE(), DateEnd)
2511 ELSE NULL
2512 END AS HOURLEFT
2513 ,CASE
2514 WHEN (Flag in (0x60, 0x20, 0x21) )
2515 THEN RegDate
2516 ELSE NULL
2517 END AS RegDate
2518 ,CASE
2519 WHEN (Flag in (0x60, 0x20, 0x21) )
2520 THEN DateEnd
2521 ELSE NULL
2522 END AS DateEnd
2523 FROM [dbo].Pangya_Warehouse
2524 WHERE UID = @UID
2525 AND VALID = 1
2526 ) A
2527 OUTER APPLY (
2528 SELECT M.UID
2529 ,S.UCC_UNIQE
2530 ,S.UCC_STATUS
2531 ,S.UCC_COPY_COUNT
2532 ,S.UCC_NAME
2533 ,S.UCC_DRAWER
2534 ,M.Nickname
2535 FROM DBO.Pangya_SelfDesign S
2536 LEFT JOIN DBO.Pangya_Member M ON M.UID = S.UCC_DRAWER
2537 WHERE S.ITEM_ID = A.IDX
2538 ) B
2539 OUTER APPLY (
2540 SELECT C0_SLOT,
2541 C1_SLOT,
2542 C2_SLOT,
2543 C3_SLOT,
2544 C4_SLOT,
2545 CLUB_POINT,
2546 CLUB_WORK_COUNT,
2547 CLUB_SLOT_CANCEL,
2548 CLUB_POINT_TOTAL_LOG,
2549 CLUB_UPGRADE_PANG_LOG
2550 FROM [DBO].Pangya_Club_Info WHERE ITEM_ID = A.IDX
2551 ) Q
2552END
2553GO
2554/****** Object: StoredProcedure [dbo].[ProcGetLockerItem] Script Date: 19/10/2018 08:23:23 ******/
2555SET ANSI_NULLS ON
2556GO
2557SET QUOTED_IDENTIFIER ON
2558GO
2559CREATE PROCEDURE [dbo].[ProcGetLockerItem]
2560 @UID INT,
2561 @PAGE INT = 1,
2562 @PAGE_TOTAL INT = 20
2563AS
2564BEGIN
2565 SET NOCOUNT ON
2566
2567 IF OBJECT_ID('TEMPDB..#TMP_INVEN') IS NOT NULL
2568 DROP TABLE #TMP_INVEN
2569
2570 SELECT A.INVEN_ID
2571 , TypeID
2572 , FROM_ID
2573 INTO #TMP_INVEN
2574 FROM (
2575 SELECT * FROM DBO.Pangya_Locker_Item WHERE UID = @UID AND Valid = 1
2576 ) A
2577
2578 SELECT TOTAL_PAGE = CEILING(@@ROWCOUNT/(@PAGE_TOTAL * 1.0))
2579
2580 SELECT A.INVEN_ID
2581 , A.TypeID
2582 , B.UCC_UNIQE
2583 , ISNULL(B.UCC_STATUS, 0) AS UCC_STATUS
2584 , B.UCC_NAME
2585 , B.UCC_COPY_COUNT
2586 , B.NICKNAME
2587 FROM (
2588 SELECT * FROM #TMP_INVEN
2589 ORDER BY INVEN_ID DESC OFFSET (@PAGE - 1) * @PAGE_TOTAL ROW FETCH NEXT @PAGE_TOTAL ROWS ONLY
2590 ) A
2591 OUTER APPLY (
2592 SELECT UCC_UNIQE
2593 , UCC_STATUS
2594 , UCC_NAME
2595 , UCC_COPY_COUNT
2596 , Y.NICKNAME
2597 FROM DBO.Pangya_SelfDesign X
2598 LEFT JOIN DBO.Pangya_Member Y
2599 ON Y.UID = X.UCC_DRAWER
2600
2601 WHERE ITEM_ID = A.FROM_ID
2602 ) B
2603
2604END
2605GO
2606/****** Object: StoredProcedure [dbo].[ProcGetMacro] Script Date: 19/10/2018 08:23:23 ******/
2607SET ANSI_NULLS ON
2608GO
2609SET QUOTED_IDENTIFIER ON
2610GO
2611-- =============================================
2612-- Author: <Author,,Name>
2613-- Create date: <Create Date,,>
2614-- Description: <Description,,>
2615-- =============================================
2616CREATE PROCEDURE [dbo].[ProcGetMacro]
2617 @UID INT
2618AS
2619BEGIN
2620 SET NOCOUNT ON;
2621
2622 SELECT Macro1,
2623 Macro2,
2624 Macro3,
2625 Macro4,
2626 Macro5,
2627 Macro6,
2628 Macro7,
2629 Macro8,
2630 Macro9
2631 FROM
2632 [dbo].Pangya_Game_Macro
2633 WHERE
2634 UID = @UID
2635
2636END
2637GO
2638/****** Object: StoredProcedure [dbo].[ProcGetMail] Script Date: 19/10/2018 08:23:23 ******/
2639SET ANSI_NULLS ON
2640GO
2641SET QUOTED_IDENTIFIER ON
2642GO
2643-- =============================================
2644-- Author: TOP
2645-- Create date:
2646-- Description:
2647-- =============================================
2648CREATE PROCEDURE [dbo].[ProcGetMail]
2649 @UID INT,
2650 @PAGE INT,
2651 @TOTAL INT,
2652 @READ TINYINT -- 1 ONLY NOT READ , 2 ALL
2653AS
2654BEGIN
2655 SET NOCOUNT ON;
2656
2657 DECLARE @PAGE_TOTAL INT = 0
2658
2659 SELECT @PAGE_TOTAL = CEILING(Q.QTY * 1.0 / @TOTAL)
2660 FROM (
2661 SELECT QTY = COUNT(1)
2662 FROM [dbo].Pangya_Mail
2663 WHERE UID = @UID
2664 AND DeleteDate IS NULL
2665 ) Q
2666
2667 SELECT @PAGE_TOTAL AS PAGE_TOTAL
2668
2669 SELECT A.*,
2670 B.*,
2671 --C.QTY AS Mail_Item_Count,
2672 (CASE WHEN [DBO].UDF_PARTS_GROUP(B.TYPEID) = 9 THEN 1 ELSE C.QTY END) AS Mail_Item_Count
2673 FROM
2674 (
2675 SELECT
2676 Mail_Index,
2677 Sender,
2678 IsRead = CASE WHEN ReadDate IS NULL THEN 0 ELSE 1 END
2679 FROM DBO.Pangya_Mail
2680 WHERE UID = @UID AND
2681 DeleteDate IS NULL
2682 ORDER BY Mail_Index DESC OFFSET (@PAGE - 1) * @TOTAL ROW FETCH NEXT @TOTAL ROWS ONLY
2683 ) A
2684 OUTER APPLY(
2685 SELECT TOP 1
2686 (CASE WHEN SETTYPEID > 0 THEN SETTYPEID ELSE TYPEID END) AS TYPEID,
2687 (CASE WHEN [DBO].UDF_PARTS_GROUP(SETTYPEID) = 9 THEN 1 ELSE QTY END) AS QTY,
2688 (CASE WHEN DAY > 0 THEN 1 ELSE 0 END) AS IsTimer,
2689 DAY,
2690 UCC_UNIQUE
2691 FROM DBO.Pangya_Mail_Item
2692 WHERE Mail_Index = A.Mail_Index AND
2693 RELEASE_DATE IS NULL
2694 ) B
2695 OUTER APPLY(
2696 SELECT QTY = COUNT(*)
2697 FROM DBO.Pangya_Mail_Item
2698 WHERE Mail_Index = A.Mail_Index AND
2699 RELEASE_DATE IS NULL
2700 ) C
2701 WHERE A.IsRead BETWEEN 0 AND (CASE WHEN @READ = 1 THEN 0 ELSE 1 END)
2702
2703END
2704GO
2705/****** Object: StoredProcedure [dbo].[ProcGetMapStatistics] Script Date: 19/10/2018 08:23:23 ******/
2706SET ANSI_NULLS ON
2707GO
2708SET QUOTED_IDENTIFIER ON
2709GO
2710CREATE PROCEDURE [dbo].[ProcGetMapStatistics]
2711 @UID INT,
2712 @MAP INT,
2713 @ASSIST INT
2714AS
2715BEGIN
2716 SET NOCOUNT ON;
2717
2718 SELECT *
2719 FROM DBO.Pangya_Map_Statistics
2720 WHERE UID = @UID AND Map = @MAP AND Assist = @ASSIST
2721
2722END
2723GO
2724/****** Object: StoredProcedure [dbo].[ProcGetMascot] Script Date: 19/10/2018 08:23:23 ******/
2725SET ANSI_NULLS ON
2726GO
2727SET QUOTED_IDENTIFIER ON
2728GO
2729-- =============================================
2730-- Author: TOP
2731-- Create date:
2732-- Description:
2733-- =============================================
2734CREATE PROCEDURE [dbo].[ProcGetMascot]
2735 @UID INT
2736AS
2737BEGIN
2738 SET NOCOUNT ON;
2739
2740 SELECT MID
2741 ,MASCOT_TYPEID
2742 ,MESSAGE
2743 ,DateEnd
2744 ,DATEDIFF(DAY, GETDATE(), DateEnd) AS END_DATE_INT
2745 FROM [dbo].Pangya_Mascot
2746 WHERE UID = @UID AND DateEnd > GETDATE()
2747END
2748GO
2749/****** Object: StoredProcedure [dbo].[ProcGetMatchHistory] Script Date: 19/10/2018 08:23:23 ******/
2750SET ANSI_NULLS ON
2751GO
2752SET QUOTED_IDENTIFIER ON
2753GO
2754CREATE PROCEDURE [dbo].[ProcGetMatchHistory]
2755 @UID INT
2756AS
2757BEGIN
2758 SET NOCOUNT ON
2759
2760 DECLARE @UID_R1 INT
2761 DECLARE @UID_R2 INT
2762 DECLARE @UID_R3 INT
2763 DECLARE @UID_R4 INT
2764 DECLARE @UID_R5 INT
2765
2766 DECLARE @MATCHHISTORY TABLE (
2767 UID INT,
2768 SEX INT,
2769 NICKNAME VARCHAR(20),
2770 USERID VARCHAR(20)
2771 )
2772
2773 SELECT @UID_R1 = UID1,
2774 @UID_R2 = UID2,
2775 @UID_R3 = UID3,
2776 @UID_R4 = UID4,
2777 @UID_R5 = UID5
2778 FROM DBO.Pangya_User_MatchHistory
2779 WHERE UID = @UID
2780
2781 IF (@UID_R1 > 0) BEGIN
2782 INSERT INTO @MATCHHISTORY(UID, SEX, NICKNAME, USERID)
2783 SELECT UID, SEX, NICKNAME, USERNAME FROM DBO.Pangya_Member WHERE UID = @UID_R1
2784 END
2785
2786 IF (@UID_R2 > 0) BEGIN
2787 INSERT INTO @MATCHHISTORY(UID, SEX, NICKNAME, USERID)
2788 SELECT UID, SEX, NICKNAME, USERNAME FROM DBO.Pangya_Member WHERE UID = @UID_R2
2789 END
2790
2791 IF (@UID_R3 > 0) BEGIN
2792 INSERT INTO @MATCHHISTORY(UID, SEX, NICKNAME, USERID)
2793 SELECT UID, SEX, NICKNAME, USERNAME FROM DBO.Pangya_Member WHERE UID = @UID_R3
2794 END
2795
2796 IF (@UID_R4 > 0) BEGIN
2797 INSERT INTO @MATCHHISTORY(UID, SEX, NICKNAME, USERID)
2798 SELECT UID, SEX, NICKNAME, USERNAME FROM DBO.Pangya_Member WHERE UID = @UID_R4
2799 END
2800
2801 IF (@UID_R5 > 0) BEGIN
2802 INSERT INTO @MATCHHISTORY(UID, SEX, NICKNAME, USERID)
2803 SELECT UID, SEX, NICKNAME, USERNAME FROM DBO.Pangya_Member WHERE UID = @UID_R5
2804 END
2805
2806 SELECT * FROM @MATCHHISTORY
2807
2808END
2809GO
2810/****** Object: StoredProcedure [dbo].[ProcGetMessengerServer] Script Date: 19/10/2018 08:23:23 ******/
2811SET ANSI_NULLS ON
2812GO
2813SET QUOTED_IDENTIFIER ON
2814GO
2815-- =============================================
2816-- Author: TOP
2817-- Create date:
2818-- Description:
2819-- =============================================
2820CREATE PROCEDURE [dbo].[ProcGetMessengerServer]
2821
2822AS
2823BEGIN
2824 SET NOCOUNT ON;
2825
2826 SELECT ServerID,
2827 Name,
2828 IP,
2829 Port,
2830 ImgNo,
2831 ImgEvent
2832 FROM
2833 [dbo].Pangya_Server
2834 WHERE
2835 ServerType = 3
2836END
2837GO
2838/****** Object: StoredProcedure [dbo].[ProcGetRoomData] Script Date: 19/10/2018 08:23:23 ******/
2839SET ANSI_NULLS ON
2840GO
2841SET QUOTED_IDENTIFIER ON
2842GO
2843CREATE PROCEDURE [dbo].[ProcGetRoomData]
2844 @UID INT
2845AS
2846BEGIN
2847 SET NOCOUNT ON
2848
2849 SELECT IDX, TYPEID, POS_X, POS_Y, POS_Z, POS_R
2850 FROM DBO.TD_ROOM_DATA
2851 WHERE UID = @UID AND VALID = 1
2852END
2853GO
2854/****** Object: StoredProcedure [dbo].[ProcGetStatistic] Script Date: 19/10/2018 08:23:23 ******/
2855SET ANSI_NULLS ON
2856GO
2857SET QUOTED_IDENTIFIER ON
2858GO
2859CREATE PROCEDURE [dbo].[ProcGetStatistic]
2860 @UID INT
2861AS
2862BEGIN
2863 SET NOCOUNT ON
2864
2865 SELECT
2866 Drive
2867 , Putt
2868 , Playtime
2869 , Longest
2870 , Distance
2871 , Pangya
2872 , Hole
2873 , TeamHole
2874 , Holeinone
2875 , OB
2876 , Bunker
2877 , Fairway
2878 , Albatross
2879 , Holein
2880 , Pang
2881 , Timeout
2882 , Game_Level
2883 , Game_Point
2884 , PuttIn
2885 , LongestPuttin
2886 , LongestChipIn
2887 , NoMannerGameCount
2888 , ShotTime
2889 , GameCount
2890 , DisconnectGames
2891 , wTeamWin
2892 , wTeamGames
2893 , LadderPoint
2894 , LadderWin
2895 , LadderLose
2896 , LadderDraw
2897 , ComboCount
2898 , MaxComboCount
2899 , TotalScore
2900 , BestScore0
2901 , BestScore1
2902 , BestScore2
2903 , BestScore3
2904 , BESTSCORE4
2905 , MaxPang0
2906 , MaxPang1
2907 , MaxPang2
2908 , MaxPang3
2909 , MaxPang4
2910 , SumPang
2911 , LadderHole
2912 , GameCountSeason
2913 , SkinsPang
2914 , SkinsWin
2915 , SkinsLose
2916 , SkinsRunHoles
2917 , SkinsStrikePoint
2918 , SkinsAllinCount
2919 , EventValue
2920 , EventFlag
2921 FROM DBO.Pangya_User_Statistics
2922 WHERE UID = @UID
2923END
2924GO
2925/****** Object: StoredProcedure [dbo].[ProcGetToolbar] Script Date: 19/10/2018 08:23:23 ******/
2926SET ANSI_NULLS ON
2927GO
2928SET QUOTED_IDENTIFIER ON
2929GO
2930-- =============================================
2931-- Author: TOP
2932-- Create date:
2933-- Description:
2934-- =============================================
2935CREATE PROCEDURE [dbo].[ProcGetToolbar] @UID INT
2936AS
2937BEGIN
2938 SET NOCOUNT ON
2939
2940 SELECT CADDIE
2941 ,CHARACTER_ID
2942 ,CLUB_ID
2943 ,BALL_ID
2944 ,MASCOT_ID
2945 ,ITEM_SLOT_1
2946 ,ITEM_SLOT_2
2947 ,ITEM_SLOT_3
2948 ,ITEM_SLOT_4
2949 ,ITEM_SLOT_5
2950 ,ITEM_SLOT_6
2951 ,ITEM_SLOT_7
2952 ,ITEM_SLOT_8
2953 ,ITEM_SLOT_9
2954 ,ITEM_SLOT_10
2955 ,POSTER_1
2956 ,POSTER_2
2957 FROM [dbo].Pangya_User_Equip
2958 WHERE UID = @UID
2959END
2960GO
2961/****** Object: StoredProcedure [dbo].[ProcGetUCCData] Script Date: 19/10/2018 08:23:23 ******/
2962SET ANSI_NULLS ON
2963GO
2964SET QUOTED_IDENTIFIER ON
2965GO
2966
2967-- =============================================
2968-- Author: TOP
2969-- Create date:
2970-- Description:
2971-- =============================================
2972CREATE PROCEDURE [dbo].[ProcGetUCCData] @UCC_INDEX INT
2973AS
2974BEGIN
2975 SET NOCOUNT ON;
2976
2977 SELECT B.TYPEID
2978 ,B.item_id
2979 ,A.UCC_UNIQE
2980 ,A.UCC_NAME
2981 ,A.UCC_STATUS
2982 ,A.UCC_COPY_COUNT
2983 ,C.Nickname
2984 FROM DBO.Pangya_SelfDesign A
2985 INNER JOIN DBO.Pangya_Warehouse B ON B.item_id = A.ITEM_ID
2986 OUTER APPLY (
2987 SELECT Nickname
2988 FROM DBO.Pangya_Member
2989 WHERE UID = A.UCC_DRAWER
2990 ) C
2991 WHERE A.ITEM_ID = @UCC_INDEX
2992END
2993GO
2994/****** Object: StoredProcedure [dbo].[ProcGuildGetData] Script Date: 19/10/2018 08:23:23 ******/
2995SET ANSI_NULLS ON
2996GO
2997SET QUOTED_IDENTIFIER ON
2998GO
2999
3000-- =============================================
3001-- Author: TOP
3002-- Create date:
3003-- Description:
3004-- =============================================
3005CREATE PROCEDURE [dbo].[ProcGuildGetData]
3006 @GUILDID INT
3007 ,@PAGE INT = 1
3008 ,@TOTAL INT = 15
3009AS
3010BEGIN
3011 SET NOCOUNT ON;
3012
3013 SELECT COUNT(*) AS GUILD_TOTAL_MEMBER
3014 FROM [dbo].Pangya_Guild_Member
3015 WHERE GUILD_ID = @GUILDID
3016
3017 SELECT B.*
3018 ,C.GUILD_NAME
3019 ,D.Nickname AS PLAYER_NICKNAME
3020 ,D.Logon
3021 FROM (
3022 SELECT GUILD_ID
3023 ,GUILD_MEMBER_UID
3024 ,GUILD_POSITION
3025 ,GUILD_MESSAGE
3026 FROM [dbo].Pangya_Guild_Member
3027 WHERE GUILD_ID = @GUILDID
3028 ORDER BY GUILD_ENTERED_TIME DESC OFFSET(@PAGE - 1) * @TOTAL ROWS FETCH NEXT @TOTAL ROWS ONLY
3029 ) B
3030 INNER JOIN [dbo].Pangya_Guild_Info C ON C.GUILD_INDEX = B.GUILD_ID AND C.GUILD_VALID = 1
3031 INNER JOIN [dbo].Pangya_Member D ON D.UID = B.GUILD_MEMBER_UID
3032END
3033GO
3034/****** Object: StoredProcedure [dbo].[ProcGuildGetList] Script Date: 19/10/2018 08:23:23 ******/
3035SET ANSI_NULLS ON
3036GO
3037SET QUOTED_IDENTIFIER ON
3038GO
3039
3040-- =============================================
3041-- Author: TOP
3042-- Create date:
3043-- Description:
3044-- =============================================
3045CREATE PROCEDURE [dbo].[ProcGuildGetList]
3046 @PAGE INT = 1
3047 ,@TOTAL INT = 15
3048 ,@SEARCH VARCHAR(255) = '%'
3049AS
3050BEGIN
3051 SET NOCOUNT ON;
3052
3053 SELECT COUNT(*) AS GUILD_TOTAL
3054 FROM [dbo].Pangya_Guild_Info
3055 WHERE GUILD_NAME LIKE '%' + @SEARCH + '%' AND GUILD_VALID = 1
3056
3057 SELECT A.*
3058 ,B.*
3059 ,C.*
3060 ,ISNULL(D.GUILD_MARK_IMG, 'GUILDMARK') AS GUILD_IMAGE
3061 FROM (
3062 SELECT GUILD_INDEX
3063 ,GUILD_NAME
3064 ,GUILD_INTRODUCING
3065 ,GUILD_LEADER_UID
3066 ,GUILD_POINT
3067 ,GUILD_PANG
3068 ,GUILD_CREATE_DATE
3069 FROM [dbo].Pangya_Guild_Info
3070 WHERE GUILD_NAME LIKE '%' + @SEARCH + '%'
3071 AND GUILD_VALID = 1
3072 ORDER BY GUILD_INDEX DESC OFFSET(@PAGE - 1) * @TOTAL ROWS FETCH NEXT @TOTAL ROWS ONLY
3073 ) A
3074 OUTER APPLY (
3075 SELECT NICKNAME AS GUILD_LEADER_NICKNAME
3076 FROM [dbo].Pangya_Member
3077 WHERE A.GUILD_LEADER_UID = UID
3078 ) B
3079 OUTER APPLY (
3080 SELECT COUNT(*) AS GUILD_TOTAL_MEMBER
3081 FROM [dbo].Pangya_Guild_Member
3082 WHERE A.GUILD_INDEX = GUILD_ID
3083 ) C
3084 OUTER APPLY (
3085 SELECT GUILD_MARK_IMG
3086 FROM [dbo].Pangya_Guild_Emblem
3087 WHERE GUILD_ID = A.GUILD_INDEX
3088 ) D
3089END
3090GO
3091/****** Object: StoredProcedure [dbo].[ProcGuildGetLog] Script Date: 19/10/2018 08:23:23 ******/
3092SET ANSI_NULLS ON
3093GO
3094SET QUOTED_IDENTIFIER ON
3095GO
3096-- =============================================
3097-- Author: TOP
3098-- Create date:
3099-- Description:
3100-- =============================================
3101CREATE PROCEDURE [dbo].[ProcGuildGetLog]
3102 @UID INT
3103AS
3104BEGIN
3105 SET NOCOUNT ON;
3106
3107 SELECT * FROM [dbo].Pangya_Guild_Log WHERE UID = @UID
3108 ORDER BY GUILD_ACTION_DATE
3109 DESC OFFSET 0 ROWS
3110 FETCH NEXT 5 ROWS ONLY
3111END
3112GO
3113/****** Object: StoredProcedure [dbo].[ProcGuildGetPlayerData] Script Date: 19/10/2018 08:23:23 ******/
3114SET ANSI_NULLS ON
3115GO
3116SET QUOTED_IDENTIFIER ON
3117GO
3118
3119-- =============================================
3120-- Author: TOP
3121-- Create date:
3122-- Description:
3123-- =============================================
3124CREATE PROCEDURE [dbo].[ProcGuildGetPlayerData]
3125 @UID INT
3126 ,@GUILDID INT = 0
3127AS
3128BEGIN
3129 SET NOCOUNT ON;
3130
3131 DECLARE @GUID INT
3132
3133 IF (@GUILDID <= 0)
3134 BEGIN
3135 SELECT @GUID = GUILD_ID
3136 FROM [DBO].Pangya_Guild_Member
3137 WHERE GUILD_MEMBER_UID = @UID
3138 END ELSE
3139 BEGIN
3140 SELECT @GUID = @GUILDID
3141 END
3142
3143 SELECT
3144 ISNULL(B.GUILD_INDEX, 0) AS GUILD_INDEX
3145 ,B.GUILD_NAME
3146 ,B.GUILD_INTRODUCING
3147 ,B.GUILD_NOTICE
3148 ,ISNULL(B.GUILD_LEADER_UID, 0) AS GUILD_LEADER_UID
3149 ,B.GUILD_CREATE_DATE
3150 ,ISNULL(C.GUILD_TOTAL_MEMBER, 0) AS GUILD_TOTAL_MEMBER
3151 ,D.GUILD_LEADER_NICKNAME
3152 ,ISNULL(E.GUILD_POSITION, 0) AS GUILD_POSITION
3153 ,ISNULL(F.GUILD_MARK_IMG, 'GUILDMARK') AS GUILD_IMAGE
3154 FROM (
3155 SELECT GUILD_ID = @GUID
3156 ) A
3157 OUTER APPLY (
3158 SELECT GUILD_INDEX
3159 ,GUILD_NAME
3160 ,GUILD_INTRODUCING
3161 ,GUILD_NOTICE
3162 ,GUILD_LEADER_UID
3163 ,GUILD_CREATE_DATE
3164 FROM [dbo].Pangya_Guild_Info
3165 WHERE GUILD_INDEX = A.GUILD_ID
3166 AND GUILD_VALID = 1
3167 ) B
3168 OUTER APPLY (
3169 SELECT COUNT(*) AS GUILD_TOTAL_MEMBER
3170 FROM [dbo].Pangya_Guild_Member
3171 WHERE GUILD_ID = A.GUILD_ID
3172 ) C
3173 OUTER APPLY (
3174 SELECT Nickname AS GUILD_LEADER_NICKNAME
3175 FROM [dbo].Pangya_Member
3176 WHERE UID = B.GUILD_LEADER_UID
3177 ) D
3178 OUTER APPLY (
3179 SELECT GUILD_POSITION
3180 FROM [dbo].Pangya_Guild_Member
3181 WHERE GUILD_ID = A.GUILD_ID
3182 AND GUILD_MEMBER_UID = @UID
3183 ) E
3184 OUTER APPLY (
3185 SELECT GUILD_MARK_IMG
3186 FROM [dbo].Pangya_Guild_Emblem
3187 WHERE GUILD_ID = A.GUILD_ID
3188 ) F
3189END
3190GO
3191/****** Object: StoredProcedure [dbo].[ProcGuildNameAvailable] Script Date: 19/10/2018 08:23:23 ******/
3192SET ANSI_NULLS ON
3193GO
3194SET QUOTED_IDENTIFIER ON
3195GO
3196-- =============================================
3197-- Author: TOP
3198-- Create date:
3199-- Description:
3200-- =============================================
3201CREATE PROCEDURE [dbo].[ProcGuildNameAvailable]
3202 @GUILDNAME VARCHAR(32)
3203AS
3204BEGIN
3205 SET NOCOUNT ON;
3206
3207 DECLARE @FGUILD_NAME VARCHAR(32)
3208 SELECT @FGUILD_NAME = LTRIM(RTRIM(@GUILDNAME))
3209
3210 IF EXISTS ( SELECT 1
3211 FROM [dbo].Pangya_Guild_Info
3212 WHERE GUILD_NAME = @FGUILD_NAME AND GUILD_VALID = 1
3213 ) BEGIN
3214 SELECT CODE = 1
3215 END ELSE BEGIN
3216 SELECT CODE = 0
3217 END
3218END
3219GO
3220/****** Object: StoredProcedure [dbo].[ProcInsertDailyQuest] Script Date: 19/10/2018 08:23:23 ******/
3221SET ANSI_NULLS ON
3222GO
3223SET QUOTED_IDENTIFIER ON
3224GO
3225CREATE PROCEDURE [dbo].[ProcInsertDailyQuest]
3226 @IN_UID INT,
3227 @QUESTID INT,
3228 @DAILYQUEST INT
3229AS
3230BEGIN
3231 SET NOCOUNT ON
3232
3233 INSERT INTO [DBO].Pangya_Achievement_Quest(UID, Achievement_Index, Achivement_Quest_TypeID, Counter_Index, SuccessDate, Count)
3234 SELECT @IN_UID, @QUESTID, A.QuestTypeID, 0, Null, B.CounterQuantity
3235 FROM [DBO].Achievement_QuestItem A
3236 INNER JOIN [DBO].Achievement_QuestStuffs B
3237 ON B.TypeID = A.QuestTypeID
3238 WHERE A.TypeID = @DAILYQUEST
3239
3240END
3241GO
3242/****** Object: StoredProcedure [dbo].[ProcLogMemorial] Script Date: 19/10/2018 08:23:23 ******/
3243SET ANSI_NULLS ON
3244GO
3245SET QUOTED_IDENTIFIER ON
3246GO
3247CREATE PROCEDURE [dbo].[ProcLogMemorial]
3248 @UID AS int ,
3249 @ItemName AS varchar(255) ,
3250 @Quantity AS int
3251AS
3252BEGIN
3253 SET NOCOUNT ON;
3254
3255 INSERT INTO DBO.Pangya_Memorial_Log(UID, ItemName, Quantity) VALUES (@UID, @ItemName, @Quantity)
3256END
3257GO
3258/****** Object: StoredProcedure [dbo].[ProcMailInsert] Script Date: 19/10/2018 08:23:23 ******/
3259SET ANSI_NULLS ON
3260GO
3261SET QUOTED_IDENTIFIER ON
3262GO
3263-- =============================================
3264-- Author: TOP
3265-- Create date:
3266-- Description:
3267-- =============================================
3268CREATE PROCEDURE [dbo].[ProcMailInsert]
3269 @UID INT,
3270 @JSONData NVARCHAR(MAX)
3271AS
3272BEGIN
3273 SET NOCOUNT ON;
3274
3275 DECLARE @MAIL_INDEX INT = 0
3276
3277 IF EXISTS (SELECT 1 FROM DBO.Pangya_Member WHERE UID = @UID)
3278 BEGIN
3279 -- INSERT TO MAIL
3280 INSERT INTO [DBO].Pangya_Mail(UID, Sender, Msg)
3281 SELECT @UID, Sender, Messages
3282 FROM OPENJSON (@JSONData)
3283 WITH (
3284 Sender VARCHAR(MAX),
3285 Messages VARCHAR(MAX)
3286 )
3287
3288 SET @MAIL_INDEX = SCOPE_IDENTITY()
3289
3290 -- IF MAIL ITEM EXISTS
3291 INSERT INTO DBO.Pangya_Mail_Item(Mail_Index, TYPEID, SETTYPEID, QTY, DAY, ITEM_GRP, TO_UID)
3292 SELECT
3293 @MAIL_INDEX,
3294 ISNULL(TypeID, 0),
3295 ISNULL(SetTypeID, 0),
3296 ISNULL(Quantity, 0),
3297 CASE WHEN DBO.UDF_PARTS_GROUP(TypeID) = 16 AND Quantity > 1 THEN Quantity ELSE 0 END,
3298 -- ISNULL(Day, 0),
3299 ISNULL(ItemGroup, 0),
3300 ISNULL(@UID, 0)
3301 FROM OPENJSON(@JSONData, '$.Items')
3302 WITH (
3303 TypeID INT,
3304 SetTypeID INT,
3305 Quantity INT,
3306 Day INT,
3307 ItemGroup INT
3308 )
3309 END
3310END
3311GO
3312/****** Object: StoredProcedure [dbo].[ProcMailItem] Script Date: 19/10/2018 08:23:23 ******/
3313SET ANSI_NULLS ON
3314GO
3315SET QUOTED_IDENTIFIER ON
3316GO
3317-- =============================================
3318-- Author: TOP
3319-- Create date:
3320-- Description:
3321-- =============================================
3322CREATE PROCEDURE [dbo].[ProcMailItem]
3323 @UID INT,
3324 @Mail_Index INT
3325AS
3326BEGIN
3327 SET NOCOUNT ON;
3328
3329 SELECT B.Mail_Index,
3330 B.TYPEID,
3331 B.QTY
3332 FROM DBO.Pangya_Mail A
3333 INNER JOIN DBO.Pangya_Mail_Item B
3334 ON B.Mail_Index = A.Mail_Index AND B.RELEASE_DATE IS NULL
3335 WHERE A.UID = @UID
3336 AND A.Mail_Index = @Mail_Index
3337 AND A.ReceiveDate IS NULL
3338 AND A.DeleteDate IS NULL
3339
3340END
3341GO
3342/****** Object: StoredProcedure [dbo].[ProcReadMail] Script Date: 19/10/2018 08:23:23 ******/
3343SET ANSI_NULLS ON
3344GO
3345SET QUOTED_IDENTIFIER ON
3346GO
3347-- =============================================
3348-- Author: TOP
3349-- Create date:
3350-- Description:
3351-- =============================================
3352CREATE PROCEDURE [dbo].[ProcReadMail]
3353 @UID INT,
3354 @Mail_Index INT
3355AS
3356BEGIN
3357 SET NOCOUNT ON;
3358
3359 UPDATE DBO.Pangya_Mail
3360 SET ReadDate = GETDATE()
3361 WHERE Mail_Index = @Mail_Index
3362
3363 SELECT A.Mail_Index,
3364 A.[Sender],
3365 A.RegDate,
3366 A.[Msg]
3367 FROM DBO.Pangya_Mail A
3368 WHERE A.UID = @UID
3369 AND A.Mail_Index = @Mail_Index
3370
3371 SELECT TYPEID,
3372 QTY,
3373 CASE WHEN DAY > 0 THEN 1 ELSE 0 END AS IsTime,
3374 DAY
3375 FROM DBO.Pangya_Mail_Item
3376 WHERE Mail_Index = @Mail_Index
3377 AND RELEASE_DATE IS NULL
3378END
3379GO
3380/****** Object: StoredProcedure [dbo].[ProcSaveCaddies] Script Date: 19/10/2018 08:23:23 ******/
3381SET ANSI_NULLS ON
3382GO
3383SET QUOTED_IDENTIFIER ON
3384GO
3385CREATE PROCEDURE [dbo].[ProcSaveCaddies]
3386 @UID INT,
3387 @JSONData NVARCHAR(MAX)
3388AS
3389BEGIN
3390 SET NOCOUNT ON;
3391
3392 UPDATE [DBO].Pangya_Caddie
3393 SET SKIN_TYPEID = JSON.CaddieSkin,
3394 SKIN_END_DATE = JSON.CaddieSkinEndDate,
3395 TriggerPay = ISNULL(JSON.CaddieAutoPay, 0)
3396 FROM OPENJSON(@JSONData, '$.Caddies')
3397 WITH (
3398 CaddieIndex INT,
3399 CaddieSkin INT,
3400 CaddieSkinEndDate DATETIME,
3401 CaddieAutoPay TINYINT
3402 ) AS JSON
3403 WHERE UID = @UID AND
3404 CID = JSON.CaddieIndex
3405END
3406GO
3407/****** Object: StoredProcedure [dbo].[ProcSaveCard] Script Date: 19/10/2018 08:23:23 ******/
3408SET ANSI_NULLS ON
3409GO
3410SET QUOTED_IDENTIFIER ON
3411GO
3412CREATE PROCEDURE [dbo].[ProcSaveCard]
3413 @UID INT,
3414 @JSONData NVARCHAR(MAX)
3415AS
3416BEGIN
3417 SET NOCOUNT ON;
3418
3419 UPDATE DBO.Pangya_Card
3420 SET QTY = JSON.CardQty ,
3421 VALID = JSON.CardValid
3422 FROM OPENJSON(@JSONData, '$.Cards')
3423 WITH (
3424 CardIndex INT
3425 , CardQty INT
3426 , CardValid INT
3427 ) AS JSON
3428 WHERE UID = @UID
3429 AND CARD_IDX = JSON.CardIndex
3430
3431END
3432GO
3433/****** Object: StoredProcedure [dbo].[ProcSaveCardEquip] Script Date: 19/10/2018 08:23:23 ******/
3434SET ANSI_NULLS ON
3435GO
3436SET QUOTED_IDENTIFIER ON
3437GO
3438CREATE PROCEDURE [dbo].[ProcSaveCardEquip]
3439 @UID INT,
3440 @JSData NVARCHAR(MAX)
3441AS
3442BEGIN
3443 SET NOCOUNT ON
3444
3445 UPDATE DBO.Pangya_Card_Equip
3446 SET CARD_TYPEID = A.CARDTYPEID
3447 , ENDDATE = A.ENDDATE
3448 , VALID = A.VALID
3449 FROM OPENJSON(@JSData, '$.CARDEQUIP')
3450 WITH (
3451 UNID INT
3452 , CARDTYPEID INT
3453 , ENDDATE DATETIME
3454 , VALID INT
3455 ) A
3456 WHERE UID = @UID
3457 AND ID = A.UNID
3458
3459END
3460GO
3461/****** Object: StoredProcedure [dbo].[ProcSaveCharacter] Script Date: 19/10/2018 08:23:23 ******/
3462SET ANSI_NULLS ON
3463GO
3464SET QUOTED_IDENTIFIER ON
3465GO
3466CREATE PROCEDURE [dbo].[ProcSaveCharacter]
3467 @UID INT,
3468 @JSONData NVARCHAR(MAX)
3469AS
3470BEGIN
3471 SET NOCOUNT ON;
3472
3473 UPDATE [DBO].Pangya_Character_Equip
3474 SET
3475 -- UPDATE TYPEID
3476 PART_TYPEID_1 = ISNULL(A.EquipTypeID0, 0),
3477 PART_TYPEID_2 = ISNULL(A.EquipTypeID1, 0),
3478 PART_TYPEID_3 = ISNULL(A.EquipTypeID2, 0),
3479 PART_TYPEID_4 = ISNULL(A.EquipTypeID3, 0),
3480 PART_TYPEID_5 = ISNULL(A.EquipTypeID4, 0),
3481 PART_TYPEID_6 = ISNULL(A.EquipTypeID5, 0),
3482 PART_TYPEID_7 = ISNULL(A.EquipTypeID6, 0),
3483 PART_TYPEID_8 = ISNULL(A.EquipTypeID7, 0),
3484 PART_TYPEID_9 = ISNULL(A.EquipTypeID8, 0),
3485 PART_TYPEID_10 = ISNULL(A.EquipTypeID9, 0),
3486 PART_TYPEID_11 = ISNULL(A.EquipTypeID10, 0),
3487 PART_TYPEID_12 = ISNULL(A.EquipTypeID11, 0),
3488 PART_TYPEID_13 = ISNULL(A.EquipTypeID12, 0),
3489 PART_TYPEID_14 = ISNULL(A.EquipTypeID13, 0),
3490 PART_TYPEID_15 = ISNULL(A.EquipTypeID14, 0),
3491 PART_TYPEID_16 = ISNULL(A.EquipTypeID15, 0),
3492 PART_TYPEID_17 = ISNULL(A.EquipTypeID16, 0),
3493 PART_TYPEID_18 = ISNULL(A.EquipTypeID17, 0),
3494 PART_TYPEID_19 = ISNULL(A.EquipTypeID18, 0),
3495 PART_TYPEID_20 = ISNULL(A.EquipTypeID19, 0),
3496 PART_TYPEID_21 = ISNULL(A.EquipTypeID20, 0),
3497 PART_TYPEID_22 = ISNULL(A.EquipTypeID21, 0),
3498 PART_TYPEID_23 = ISNULL(A.EquipTypeID22, 0),
3499 PART_TYPEID_24 = ISNULL(A.EquipTypeID23, 0),
3500 -- UPDATE ITEM INDEX
3501 PART_IDX_1 = ISNULL(A.EquipIndex0, 0),
3502 PART_IDX_2 = ISNULL(A.EquipIndex1, 0),
3503 PART_IDX_3 = ISNULL(A.EquipIndex2, 0),
3504 PART_IDX_4 = ISNULL(A.EquipIndex3, 0),
3505 PART_IDX_5 = ISNULL(A.EquipIndex4, 0),
3506 PART_IDX_6 = ISNULL(A.EquipIndex5, 0),
3507 PART_IDX_7 = ISNULL(A.EquipIndex6, 0),
3508 PART_IDX_8 = ISNULL(A.EquipIndex7, 0),
3509 PART_IDX_9 = ISNULL(A.EquipIndex8, 0),
3510 PART_IDX_10 = ISNULL(A.EquipIndex9, 0),
3511 PART_IDX_11 = ISNULL(A.EquipIndex10, 0),
3512 PART_IDX_12 = ISNULL(A.EquipIndex11, 0),
3513 PART_IDX_13 = ISNULL(A.EquipIndex12, 0),
3514 PART_IDX_14 = ISNULL(A.EquipIndex13, 0),
3515 PART_IDX_15 = ISNULL(A.EquipIndex14, 0),
3516 PART_IDX_16 = ISNULL(A.EquipIndex15, 0),
3517 PART_IDX_17 = ISNULL(A.EquipIndex16, 0),
3518 PART_IDX_18 = ISNULL(A.EquipIndex17, 0),
3519 PART_IDX_19 = ISNULL(A.EquipIndex18, 0),
3520 PART_IDX_20 = ISNULL(A.EquipIndex19, 0),
3521 PART_IDX_21 = ISNULL(A.EquipIndex20, 0),
3522 PART_IDX_22 = ISNULL(A.EquipIndex21, 0),
3523 PART_IDX_23 = ISNULL(A.EquipIndex22, 0),
3524 PART_IDX_24 = ISNULL(A.EquipIndex23, 0)
3525 FROM OPENJSON(@JSONData, '$.Char')
3526 WITH (
3527 -- CHAR INDEX
3528 CharIndex INT,
3529 -- EQUIP TYPEID
3530 EquipTypeID0 INT,
3531 EquipTypeID1 INT,
3532 EquipTypeID2 INT,
3533 EquipTypeID3 INT,
3534 EquipTypeID4 INT,
3535 EquipTypeID5 INT,
3536 EquipTypeID6 INT,
3537 EquipTypeID7 INT,
3538 EquipTypeID8 INT,
3539 EquipTypeID9 INT,
3540 EquipTypeID10 INT,
3541 EquipTypeID11 INT,
3542 EquipTypeID12 INT,
3543 EquipTypeID13 INT,
3544 EquipTypeID14 INT,
3545 EquipTypeID15 INT,
3546 EquipTypeID16 INT,
3547 EquipTypeID17 INT,
3548 EquipTypeID18 INT,
3549 EquipTypeID19 INT,
3550 EquipTypeID20 INT,
3551 EquipTypeID21 INT,
3552 EquipTypeID22 INT,
3553 EquipTypeID23 INT,
3554 -- EQUIP INDEX
3555 EquipIndex0 INT,
3556 EquipIndex1 INT,
3557 EquipIndex2 INT,
3558 EquipIndex3 INT,
3559 EquipIndex4 INT,
3560 EquipIndex5 INT,
3561 EquipIndex6 INT,
3562 EquipIndex7 INT,
3563 EquipIndex8 INT,
3564 EquipIndex9 INT,
3565 EquipIndex10 INT,
3566 EquipIndex11 INT,
3567 EquipIndex12 INT,
3568 EquipIndex13 INT,
3569 EquipIndex14 INT,
3570 EquipIndex15 INT,
3571 EquipIndex16 INT,
3572 EquipIndex17 INT,
3573 EquipIndex18 INT,
3574 EquipIndex19 INT,
3575 EquipIndex20 INT,
3576 EquipIndex21 INT,
3577 EquipIndex22 INT,
3578 EquipIndex23 INT,
3579 -- STATUS
3580 C0 TINYINT,
3581 C1 TINYINT,
3582 C2 TINYINT,
3583 C3 TINYINT,
3584 C4 TINYINT
3585 ) AS A
3586 WHERE UID = @UID AND CHAR_IDX = A.CharIndex
3587
3588 UPDATE DBO.Pangya_Character
3589 SET POWER = A.C0
3590 , CONTROL = A.C1
3591 , IMPACT = A.C2
3592 , SPIN = A.C3
3593 , CURVE = A.C4
3594 FROM OPENJSON(@JSONData, '$.Char')
3595 WITH (
3596 CharIndex INT,
3597 C0 TINYINT,
3598 C1 TINYINT,
3599 C2 TINYINT,
3600 C3 TINYINT,
3601 C4 TINYINT
3602 ) A
3603 WHERE UID = @UID AND CID = A.CharIndex
3604
3605END
3606GO
3607/****** Object: StoredProcedure [dbo].[ProcSaveExceptionLog] Script Date: 19/10/2018 08:23:23 ******/
3608SET ANSI_NULLS ON
3609GO
3610SET QUOTED_IDENTIFIER ON
3611GO
3612-- =============================================
3613-- Author: TOP
3614-- Create date:
3615-- Description:
3616-- =============================================
3617CREATE PROCEDURE [dbo].[ProcSaveExceptionLog]
3618 @UID INT,
3619 @USER VARCHAR(50),
3620 @EXCEPTIONMESSAGE VARCHAR(2000),
3621 @SERVER VARCHAR(50)
3622AS
3623BEGIN
3624 SET NOCOUNT ON;
3625
3626 INSERT INTO [DBO].Pangya_Exception_Log(UID, Username, ExceptionMessage, Server)
3627 VALUES (@UID, @USER, @EXCEPTIONMESSAGE, @SERVER)
3628END
3629GO
3630/****** Object: StoredProcedure [dbo].[ProcSaveItem] Script Date: 19/10/2018 08:23:23 ******/
3631SET ANSI_NULLS ON
3632GO
3633SET QUOTED_IDENTIFIER ON
3634GO
3635-- =============================================
3636-- Author: TOP
3637-- Create date:
3638-- Description:
3639-- =============================================
3640CREATE PROCEDURE [dbo].[ProcSaveItem]
3641 @UID INT,
3642 @JSONData NVARCHAR(MAX)
3643AS
3644BEGIN
3645 SET NOCOUNT ON;
3646
3647 -- UPDATE TO WAREHOUSE
3648 UPDATE DBO.Pangya_Warehouse
3649 SET C0 = A.ItemC0,
3650 C1 = A.ItemC1,
3651 C2 = A.ItemC2,
3652 C3 = A.ItemC3,
3653 C4 = A.ItemC4,
3654 VALID = A.ItemValid,
3655 DateEnd = A.ItemEndDate,
3656 Flag = A.ItemFlag
3657 FROM OPENJSON(@JSONData, '$.Items')
3658 WITH (
3659 ItemIndex INT,
3660 ItemC0 INT,
3661 ItemC1 INT,
3662 ItemC2 INT,
3663 ItemC3 INT,
3664 ItemC4 INT,
3665 ItemValid INT,
3666 ItemEndDate DATETIME,
3667 ItemFlag INT
3668 ) AS A
3669 WHERE UID = @UID
3670 AND item_id = A.ItemIndex
3671
3672 -- UPDATE UCC
3673 UPDATE DBO.Pangya_SelfDesign
3674 SET UCC_STATUS = A.ItemUCCStatus,
3675 UCC_UNIQE = A.ItemUCCUnique
3676 FROM OPENJSON(@JSONData, '$.Items')
3677 WITH (
3678 ItemIndex INT,
3679 ItemC0 INT,
3680 ItemValid TINYINT,
3681 IsSelfDesign TINYINT,
3682 ItemUCCStatus TINYINT,
3683 ItemUCCUnique VARCHAR (10)
3684 ) AS A
3685 WHERE UID = @UID
3686 AND ITEM_ID = A.ItemIndex
3687 AND A.IsSelfDesign = 1
3688
3689 -- UPDATE CLUBSET
3690 UPDATE DBO.Pangya_Club_Info
3691 SET C0_SLOT = A.C0Slot,
3692 C1_SLOT = A.C1Slot,
3693 C2_SLOT = A.C2Slot,
3694 C3_SLOT = A.C3Slot,
3695 C4_SLOT = A.C4Slot,
3696 CLUB_POINT = A.ClubPoint,
3697 CLUB_WORK_COUNT = A.WorkCount,
3698 CLUB_SLOT_CANCEL = A.CancelCount,
3699 CLUB_POINT_TOTAL_LOG = A.PointLog,
3700 CLUB_UPGRADE_PANG_LOG = A.PangLog
3701 FROM OPENJSON(@JSONData, '$.Items')
3702 WITH (
3703 ItemIndex INT,
3704 ClubPoint INT,
3705 WorkCount INT,
3706 PointLog INT,
3707 PangLog INT,
3708 C0Slot TINYINT,
3709 C1Slot TINYINT,
3710 C2Slot TINYINT,
3711 C3Slot TINYINT,
3712 C4Slot TINYINT,
3713 CancelCount TINYINT,
3714 IsClubset TINYINT
3715 ) A
3716 WHERE ITEM_ID = A.ItemIndex
3717 AND IsClubSet = 1
3718
3719END
3720GO
3721/****** Object: StoredProcedure [dbo].[ProcSaveMacro] Script Date: 19/10/2018 08:23:23 ******/
3722SET ANSI_NULLS ON
3723GO
3724SET QUOTED_IDENTIFIER ON
3725GO
3726
3727-- =============================================
3728-- Author: TOP
3729-- Create date:
3730-- Description:
3731-- =============================================
3732CREATE PROCEDURE [dbo].[ProcSaveMacro] @UID INT
3733 ,@Macro1 VARCHAR(45) = 'Pangya!'
3734 ,@Macro2 VARCHAR(45) = 'Pangya!'
3735 ,@Macro3 VARCHAR(45) = 'Pangya!'
3736 ,@Macro4 VARCHAR(45) = 'Pangya!'
3737 ,@Macro5 VARCHAR(45) = 'Pangya!'
3738 ,@Macro6 VARCHAR(45) = 'Pangya!'
3739 ,@Macro7 VARCHAR(45) = 'Pangya!'
3740 ,@Macro8 VARCHAR(45) = 'Pangya!'
3741 ,@Macro9 VARCHAR(45) = 'Pangya!'
3742 ,@Macro10 VARCHAR(45) = 'Pangya!'
3743AS
3744BEGIN
3745 SET NOCOUNT ON;
3746
3747 UPDATE [dbo].Pangya_Game_Macro
3748 SET Macro1 = @Macro1
3749 ,Macro2 = @Macro2
3750 ,Macro3 = @Macro3
3751 ,Macro4 = @Macro4
3752 ,Macro5 = @Macro5
3753 ,Macro6 = @Macro6
3754 ,Macro7 = @Macro7
3755 ,Macro8 = @Macro8
3756 ,Macro9 = @Macro9
3757 ,Macro10 = @Macro10
3758 WHERE UID = @UID
3759END
3760GO
3761/****** Object: StoredProcedure [dbo].[ProcSavePersonalLog] Script Date: 19/10/2018 08:23:23 ******/
3762SET ANSI_NULLS ON
3763GO
3764SET QUOTED_IDENTIFIER ON
3765GO
3766CREATE PROCEDURE [dbo].[ProcSavePersonalLog]
3767 @UID INT,
3768 @PROCESS TINYINT,
3769 @AMOUNT BIGINT
3770AS
3771BEGIN
3772 SET NOCOUNT ON
3773
3774END
3775GO
3776/****** Object: StoredProcedure [dbo].[ProcSaveToolbar] Script Date: 19/10/2018 08:23:23 ******/
3777SET ANSI_NULLS ON
3778GO
3779SET QUOTED_IDENTIFIER ON
3780GO
3781-- =============================================
3782-- Author: TOP
3783-- Create date:
3784-- Description:
3785-- =============================================
3786CREATE PROCEDURE [dbo].[ProcSaveToolbar]
3787 @UID INT,
3788 @JSONData NVARCHAR(MAX)
3789AS
3790BEGIN
3791 SET NOCOUNT ON;
3792
3793 IF EXISTS (SELECT 1 FROM DBO.Pangya_User_Equip WHERE UID = @UID)
3794 BEGIN
3795 UPDATE DBO.Pangya_User_Equip
3796 SET CHARACTER_ID = A.CharIndex,
3797 CADDIE = A.CaddieIndex,
3798 MASCOT_ID = A.MascotIndex,
3799 BALL_ID = A.BallTypeID,
3800 CLUB_ID = A.ClubIndex,
3801 ITEM_SLOT_1 = A.SLOT1,
3802 ITEM_SLOT_2 = A.SLOT2,
3803 ITEM_SLOT_3 = A.SLOT3,
3804 ITEM_SLOT_4 = A.SLOT4,
3805 ITEM_SLOT_5 = A.SLOT5,
3806 ITEM_SLOT_6 = A.SLOT6,
3807 ITEM_SLOT_7 = A.SLOT7,
3808 ITEM_SLOT_8 = A.SLOT8,
3809 ITEM_SLOT_9 = A.SLOT9,
3810 ITEM_SLOT_10 = A.SLOT10
3811 FROM OPENJSON (@JSONData)
3812 WITH (
3813 CharIndex INT,
3814 CaddieIndex INT,
3815 MascotIndex INT,
3816 BallTypeID INT,
3817 ClubIndex INT,
3818 SLOT1 INT,
3819 SLOT2 INT,
3820 SLOT3 INT,
3821 SLOT4 INT,
3822 SLOT5 INT,
3823 SLOT6 INT,
3824 SLOT7 INT,
3825 SLOT8 INT,
3826 SLOT9 INT,
3827 SLOT10 INT
3828 ) A
3829 WHERE UID = @UID
3830 END
3831END
3832GO
3833/****** Object: StoredProcedure [dbo].[ProcSaveUCC] Script Date: 19/10/2018 08:23:23 ******/
3834SET ANSI_NULLS ON
3835GO
3836SET QUOTED_IDENTIFIER ON
3837GO
3838-- =============================================
3839-- Author: TOP
3840-- Create date:
3841-- Description:
3842-- =============================================
3843CREATE PROCEDURE [dbo].[ProcSaveUCC]
3844 @UID INT,
3845 @UCC_ITEMID INT,
3846 @UCC_NAME VARCHAR(20),
3847 @UCC_STATUS SMALLINT,
3848 @UCC_DRAWER_UID INT
3849
3850AS
3851BEGIN
3852 SET NOCOUNT ON;
3853
3854 UPDATE DBO.Pangya_SelfDesign SET UCC_NAME = RTRIM(LTRIM(@UCC_NAME)), UCC_STATUS = @UCC_STATUS, UCC_DRAWER = @UCC_DRAWER_UID
3855 WHERE UID = @UID AND ITEM_ID = @UCC_ITEMID AND UCC_STATUS NOT IN(1)
3856
3857END
3858GO
3859/****** Object: StoredProcedure [dbo].[ProcSaveUCCCopy] Script Date: 19/10/2018 08:23:23 ******/
3860SET ANSI_NULLS ON
3861GO
3862SET QUOTED_IDENTIFIER ON
3863GO
3864-- =============================================
3865-- Author: TOP
3866-- Create date:
3867-- Description:
3868-- =============================================
3869CREATE PROCEDURE [dbo].[ProcSaveUCCCopy]
3870 @UID INT,
3871 @TYPEID INT = 0, -- TYPE ORIGINAL
3872 @UCC_UNIQUE VARCHAR(10),-- ORIGINAL
3873 @UCC_IDX INT -- TO COPY IDX
3874 AS
3875BEGIN
3876 SET NOCOUNT ON;
3877
3878 DECLARE @UCC_COPY_COUNT SMALLINT
3879
3880 IF EXISTS ( SELECT 1 FROM DBO.Pangya_SelfDesign WHERE UID = @UID AND UCC_UNIQE = @UCC_UNIQUE AND UCC_STATUS = 1 )
3881 BEGIN
3882 SELECT @UCC_COPY_COUNT = MAX(UCC_COPY_COUNT)
3883 FROM DBO.Pangya_SelfDesign
3884 WHERE UID = @UID AND
3885 UCC_UNIQE = @UCC_UNIQUE
3886 GROUP BY UID
3887
3888 UPDATE DBO.Pangya_SelfDesign
3889 SET UCC_STATUS = 1,
3890 UCC_COPY_COUNT = @UCC_COPY_COUNT + 1,
3891 UCC_UNIQE = @UCC_UNIQUE,
3892 UCC_NAME = B.UCC_NAME,
3893 UCC_DRAWER = B.UCC_DRAWER
3894 FROM DBO.Pangya_SelfDesign A
3895 CROSS APPLY
3896 (
3897 SELECT UCC_NAME,
3898 UCC_DRAWER
3899 FROM DBO.Pangya_SelfDesign
3900 WHERE UID = @UID AND
3901 UCC_UNIQE = @UCC_UNIQUE AND
3902 UCC_STATUS = 1
3903 ) B
3904 WHERE A.ITEM_ID = @UCC_IDX AND
3905 A.UCC_STATUS = 0
3906
3907 IF @@ROWCOUNT > 0
3908 BEGIN
3909 SELECT 1 AS Code,
3910 ITEM_ID,
3911 TYPEID,
3912 UCC_UNIQE,
3913 UCC_COPY_COUNT
3914 FROM DBO.Pangya_SelfDesign
3915 WHERE ITEM_ID = @UCC_IDX END
3916 ELSE
3917 BEGIN
3918 SELECT 0 AS Code
3919 END
3920 END
3921 ELSE
3922 BEGIN
3923 SELECT 0 AS Code END
3924END
3925GO
3926/****** Object: StoredProcedure [dbo].[ProcSetLockerPwd] Script Date: 19/10/2018 08:23:23 ******/
3927SET ANSI_NULLS ON
3928GO
3929SET QUOTED_IDENTIFIER ON
3930GO
3931CREATE PROCEDURE [dbo].[ProcSetLockerPwd]
3932 @UID INT,
3933 @PWD VARCHAR(4)
3934AS
3935BEGIN
3936 SET NOCOUNT ON
3937
3938 UPDATE DBO.Pangya_Personal
3939 SET LockerPwd = @PWD
3940 WHERE UID = @UID
3941
3942 IF (@@ROWCOUNT > 0) BEGIN
3943 SELECT 1 AS Code
3944 END ELSE BEGIN
3945 SELECT 0 AS Code
3946 END
3947END
3948GO
3949/****** Object: StoredProcedure [dbo].[ProcUpdateAuth] Script Date: 19/10/2018 08:23:23 ******/
3950SET ANSI_NULLS ON
3951GO
3952SET QUOTED_IDENTIFIER ON
3953GO
3954CREATE PROCEDURE [dbo].[ProcUpdateAuth]
3955 @UID INT
3956AS
3957BEGIN
3958 SET NOCOUNT ON;
3959
3960 DECLARE @KEY_GAME VARCHAR(7)
3961
3962 SET @KEY_GAME = LOWER(LEFT(NEWID(), 7))
3963
3964 UPDATE DBO.Pangya_Member SET AuthKey_Game = @KEY_GAME WHERE UID = @UID
3965
3966 SELECT @KEY_GAME AS KEY_GAME
3967END
3968GO
3969/****** Object: StoredProcedure [dbo].[ProcUpdateMail] Script Date: 19/10/2018 08:23:23 ******/
3970SET ANSI_NULLS ON
3971GO
3972SET QUOTED_IDENTIFIER ON
3973GO
3974-- =============================================
3975-- Author: TOP
3976-- Create date:
3977-- Description:
3978-- =============================================
3979CREATE PROCEDURE [dbo].[ProcUpdateMail]
3980 @UID INT,
3981 @MailIndex INT,
3982 @JSONData NVARCHAR(MAX)
3983AS
3984BEGIN
3985 SET NOCOUNT ON;
3986
3987 UPDATE DBO.Pangya_Mail
3988 SET ReceiveDate = GETDATE(),
3989 ReadDate = GETDATE()
3990 WHERE UID = @UID AND Mail_Index = @MailIndex
3991
3992 UPDATE DBO.Pangya_Mail_Item
3993 SET RELEASE_DATE = GETDATE() ,
3994 APPLY_ITEM_ID = ItemAddedIndex
3995 FROM OPENJSON(@JSONData, '$.MailUpdate')
3996 WITH (
3997 MailIndex INT,
3998 ItemTypeID INT,
3999 ItemAddedIndex INT
4000 ) AS A
4001 WHERE Mail_Index = @MailIndex AND TYPEID = ItemTypeID
4002END
4003GO
4004/****** Object: StoredProcedure [dbo].[ProcUpdateMapStatistics] Script Date: 19/10/2018 08:23:23 ******/
4005SET ANSI_NULLS ON
4006GO
4007SET QUOTED_IDENTIFIER ON
4008GO
4009CREATE PROCEDURE [dbo].[ProcUpdateMapStatistics]
4010 @UID INT,
4011 @MAP SMALLINT,
4012 @DRIVE INT,
4013 @PUTT INT,
4014 @HOLE INT,
4015 @FAIRWAY INT,
4016 @HOLEIN INT,
4017 @PUTTIN INT,
4018 @SCORE_IN INT,
4019 @MAXPANG INT,
4020 @CHARTYPEID INT,
4021 @ASSIST INT, -- 1 = ENABLE , 0 = DISABLE
4022 @EVENTSCORE INT = 0
4023AS
4024BEGIN
4025 SET NOCOUNT ON
4026
4027 DECLARE @A_BESTSCORE SMALLINT
4028 DECLARE @A_MAXPANG INT
4029
4030 DECLARE @NEWRECORD INT = 0
4031
4032 IF NOT EXISTS ( SELECT 1 FROM DBO.Pangya_Map_Statistics WHERE UID = @UID AND Map = @MAP AND Assist = @ASSIST ) BEGIN
4033
4034 INSERT INTO DBO.Pangya_Map_Statistics
4035 (UID, Map, Drive, Putt, Hole, Fairway, Holein, Puttin, TotalScore, BestScore, MaxPang, CharTypeID, EventScore, Assist)
4036 VALUES (@UID, @MAP, @DRIVE, @PUTT, @HOLE, @FAIRWAY, @HOLEIN, @PUTTIN, @SCORE_IN, @SCORE_IN, @MAXPANG, @CHARTYPEID, @EVENTSCORE, @ASSIST)
4037
4038 -- SET NEWRECORD = 1
4039 SET @NEWRECORD = 1
4040
4041 END ELSE BEGIN
4042
4043 -- FETCH OLD DATA
4044 SELECT @A_BESTSCORE = BestScore,
4045 @A_MAXPANG = MaxPang
4046 FROM
4047 DBO.Pangya_Map_Statistics
4048 WHERE
4049 UID = @UID AND Map = @MAP AND Assist = @ASSIST
4050
4051
4052 -- UPDATE SCORE
4053 IF (@SCORE_IN <= @A_BESTSCORE) AND (@MAXPANG >= @A_MAXPANG) BEGIN
4054
4055 UPDATE DBO.Pangya_Map_Statistics
4056 SET BestScore = @SCORE_IN,
4057 MaxPang = @MAXPANG,
4058 CharTypeId = @CHARTYPEID
4059 WHERE
4060 UID = @UID AND
4061 Map = @MAP AND
4062 Assist = @ASSIST
4063
4064 END
4065
4066 -- UPDATE MAP STATISTIC
4067 UPDATE DBO.Pangya_Map_Statistics
4068 SET Drive += @DRIVE,
4069 Putt += @PUTT,
4070 Hole += @HOLE,
4071 Fairway += @FAIRWAY,
4072 Holein += (@HOLE - @HOLEIN),
4073 PuttIn += @PUTTIN,
4074 TotalScore += @SCORE_IN,
4075 EventScore += @EventScore
4076 WHERE UID = @UID AND Map = @MAP AND Assist = @ASSIST
4077
4078 END
4079
4080 -- SELECT IF IT IS NEW RECORD
4081 SELECT @NEWRECORD AS ISNEWRECORD
4082
4083END
4084GO
4085/****** Object: StoredProcedure [dbo].[ProcUpdateNickname] Script Date: 19/10/2018 08:23:23 ******/
4086SET ANSI_NULLS ON
4087GO
4088SET QUOTED_IDENTIFIER ON
4089GO
4090-- =============================================
4091-- Author: TOP
4092-- Create date:
4093-- Description: Change Player Nickname
4094-- =============================================
4095CREATE PROCEDURE [dbo].[ProcUpdateNickname]
4096 @UID int,
4097 @NICKNAME varchar(20)
4098AS
4099BEGIN
4100 SET NOCOUNT ON;
4101
4102 DECLARE @NICK VARCHAR(20)
4103 SELECT @NICK = RTRIM(LTRIM(@NICKNAME))
4104
4105 IF EXISTS ( SELECT 1
4106 FROM [dbo].Pangya_Member
4107 WHERE Nickname = @NICK COLLATE Latin1_General_CS_AS
4108 )
4109 BEGIN
4110 SELECT Code = 2
4111 END ELSE BEGIN
4112 UPDATE [dbo].Pangya_Member SET Nickname = @NICK WHERE UID = @UID
4113 SELECT Code = 1
4114 END
4115END
4116GO
4117/****** Object: StoredProcedure [dbo].[USP_ADD_CARD_EQUIP] Script Date: 19/10/2018 08:23:23 ******/
4118SET ANSI_NULLS ON
4119GO
4120SET QUOTED_IDENTIFIER ON
4121GO
4122CREATE PROCEDURE [dbo].[USP_ADD_CARD_EQUIP]
4123 @UID INT,
4124 @CID INT,
4125 @CHARTYPEID INT,
4126 @CARDTYPEID INT,
4127 @SLOT TINYINT,
4128 @FLAG TINYINT,
4129 @TIME TINYINT
4130AS
4131BEGIN
4132 SET NOCOUNT ON
4133
4134 DECLARE @ID_OUT INT = 0
4135 DECLARE @IN_ENDDATE DATETIME = NULL
4136
4137 -- MAP END DATE
4138 IF (@FLAG = 0) BEGIN
4139 SET @IN_ENDDATE = GETDATE()
4140 END ELSE BEGIN
4141 SET @IN_ENDDATE = DATEADD(N, @TIME, GETDATE())
4142 END
4143
4144 IF EXISTS (SELECT 1 FROM DBO.Pangya_Member WHERE UID = @UID) BEGIN
4145
4146 INSERT INTO DBO.Pangya_Card_Equip(UID, CID, CHAR_TYPEID, CARD_TYPEID, SLOT, ENDDATE, FLAG)
4147 VALUES (@UID, @CID, @CHARTYPEID, @CARDTYPEID, @SLOT, @IN_ENDDATE, @FLAG)
4148
4149 SET @ID_OUT = SCOPE_IDENTITY()
4150
4151 IF ( @ID_OUT > 0 )
4152 BEGIN
4153 SELECT 0 AS CODE
4154 , @ID_OUT AS OUT_INDEX
4155 , @CID AS CID
4156 , @CHARTYPEID AS CHARTYPEID
4157 , @CARDTYPEID AS CARDTYPEID
4158 , @SLOT AS SLOT
4159 , GETDATE() AS REGDATE
4160 , @IN_ENDDATE AS ENDDATE
4161 , @FLAG AS FLAG
4162 END ELSE BEGIN
4163 SELECT 1 AS CODE
4164 END
4165 END ELSE BEGIN
4166 SELECT 1 CODE
4167 END
4168
4169END
4170GO
4171/****** Object: StoredProcedure [dbo].[USP_DAILYQUEST_ACCEPT] Script Date: 19/10/2018 08:23:23 ******/
4172SET ANSI_NULLS ON
4173GO
4174SET QUOTED_IDENTIFIER ON
4175GO
4176CREATE PROCEDURE [dbo].[USP_DAILYQUEST_ACCEPT]
4177 @UID INT,
4178 @QUESTSTR NVARCHAR(MAX)
4179AS
4180BEGIN
4181 SET NOCOUNT ON
4182
4183 DECLARE @COUNTER_ID INT = 0
4184 DECLARE @COUNTER_TYPEID INT = 0
4185 DECLARE @QUESTPROCESS INT = 0
4186
4187 DECLARE @NEW_COUNTER TABLE (
4188 TypeID INT,
4189 ID INT
4190 )
4191
4192 DECLARE @QUEST_PROCESS TABLE (
4193 QuestID INT,
4194 Valid TINYINT
4195 )
4196
4197 DECLARE @QUEST_ID TABLE (
4198 QuestID INT
4199 )
4200
4201 INSERT INTO @QUEST_PROCESS(QuestID, Valid)
4202 SELECT A.QuestID, 1
4203 FROM OPENJSON(@QUESTSTR, '$.QuestIDs')
4204 WITH (
4205 QuestID INT
4206 ) A
4207
4208
4209 WHILE EXISTS (SELECT 1 FROM @QUEST_PROCESS WHERE Valid = 1) BEGIN
4210 /* GET QUEST */
4211 SELECT TOP 1 @QUESTPROCESS = QuestID FROM @QUEST_PROCESS WHERE Valid = 1
4212 /* QUEST 1 ADD COUNTER */
4213 IF EXISTS (SELECT 1 FROM [DBO].Pangya_Achievement WHERE UID = @UID AND ID = @QUESTPROCESS AND Type = 1) BEGIN
4214 /* GET COUNTER TYPEID */
4215 SELECT @COUNTER_TYPEID = B.CounterTypeID
4216 FROM [DBO].Pangya_Achievement_Quest A
4217 INNER JOIN [DBO].Achievement_QuestStuffs B
4218 ON A.Achivement_Quest_TypeID = B.TypeID
4219 WHERE A.Achievement_Index = @QUESTPROCESS
4220
4221 /* INSERT COUNTER */
4222 INSERT INTO [DBO].Pangya_Achievement_Counter(UID, TypeID, Quantity)
4223 SELECT @UID, @COUNTER_TYPEID, 0
4224
4225 /* GET ID */
4226 SET @COUNTER_ID = SCOPE_IDENTITY()
4227
4228 /* UPDATE QUEST */
4229 UPDATE DBO.Pangya_Achievement_Quest
4230 SET Counter_Index = @COUNTER_ID
4231 WHERE Achievement_Index = @QUESTPROCESS
4232
4233 /* SET QUEST TO ACTIVE */
4234 UPDATE [DBO].Pangya_Achievement
4235 SET Type = 3
4236 WHERE ID = @QUESTPROCESS
4237
4238 /* INSERT INTO COUNTER UPDATE */
4239 INSERT INTO @NEW_COUNTER(TypeID, ID) SELECT @COUNTER_TYPEID, @COUNTER_ID
4240
4241 /* UPDATE */
4242 INSERT INTO @QUEST_ID(QuestID) SELECT @QUESTPROCESS
4243 END
4244
4245 /* UPDATE */
4246 UPDATE @QUEST_PROCESS SET Valid = 0 WHERE QuestID = @QUESTPROCESS
4247 END
4248
4249 SELECT *
4250 FROM @NEW_COUNTER
4251
4252 SELECT *
4253 FROM @QUEST_PROCESS
4254
4255END
4256GO
4257/****** Object: StoredProcedure [dbo].[USP_DAILYQUEST_LOAD] Script Date: 19/10/2018 08:23:23 ******/
4258SET ANSI_NULLS ON
4259GO
4260SET QUOTED_IDENTIFIER ON
4261GO
4262CREATE PROCEDURE [dbo].[USP_DAILYQUEST_LOAD]
4263 @UID INT
4264AS
4265BEGIN
4266 SET NOCOUNT ON
4267
4268 DECLARE @LAST_ID INT = 0
4269 DECLARE @QUEST_TYPEID1 INT = 0
4270 DECLARE @QUEST_TYPEID2 INT = 0
4271 DECLARE @QUEST_TYPEID3 INT = 0
4272 DECLARE @QUEST_TIME INT = 0
4273
4274 DECLARE @NEW_QUEST TABLE (
4275 TypeID INT,
4276 QuestIndex INT,
4277 Quantity INT
4278 )
4279
4280 DECLARE @OLD_QUEST TABLE (
4281 TypeID INT,
4282 QuestIndex INT,
4283 Quantity INT
4284 )
4285
4286 DECLARE @QUESTS TABLE (
4287 ID INT,
4288 TypeID INT,
4289 Type TINYINT
4290 )
4291
4292 SELECT @QUEST_TYPEID1 = QuestTypeID1,
4293 @QUEST_TYPEID2 = QuestTypeID2,
4294 @QUEST_TYPEID3 = QuestTypeID3,
4295 @QUEST_TIME = ISNULL(DBO.UNIX_TIMESTAMP(RegDate), 0)
4296 FROM DBO.Daily_Quest
4297 WHERE Day = 1 -- DAY(GETDATE())
4298
4299 /* GET ALL QUESTS */
4300 INSERT INTO @QUESTS(ID, TypeID, Type) SELECT ID, TypeID, Type FROM [DBO].Pangya_Achievement WHERE UID = @UID AND VALID = 1
4301
4302 /* INSERT INTO SOON DELETE QUEST */
4303 INSERT INTO @OLD_QUEST(TypeID, QuestIndex, Quantity)
4304 SELECT TypeID, ID, 0 FROM @QUESTS WHERE Type = 1 AND TypeID NOT IN (@QUEST_TYPEID1, @QUEST_TYPEID2, @QUEST_TYPEID3)
4305
4306 /* CLEAR OLD QUEST */
4307 UPDATE A
4308 SET A.Valid = 0
4309 FROM [DBO].Pangya_Achievement A
4310 JOIN @OLD_QUEST B
4311 ON A.ID = B.QuestIndex
4312
4313 IF NOT EXISTS (SELECT 1 FROM [DBO].Pangya_Daily_Quest WHERE UID = @UID) BEGIN
4314 INSERT INTO [DBO].Pangya_Daily_Quest(UID) SELECT @UID
4315 END
4316
4317 /* QUEST 1 CHECK */
4318 IF NOT EXISTS ( SELECT 1 FROM @QUESTS WHERE TypeID = @QUEST_TYPEID1 ) BEGIN
4319 INSERT INTO [DBO].Pangya_Achievement( UID, TypeID, Type ) VALUES ( @UID, @QUEST_TYPEID1, 1 )
4320 SELECT @LAST_ID = SCOPE_IDENTITY()
4321 EXEC [DBO].ProcInsertDailyQuest @IN_UID = @UID, @QUESTID = @LAST_ID, @DAILYQUEST = @QUEST_TYPEID1
4322 INSERT INTO @NEW_QUEST VALUES (@QUEST_TYPEID1, @LAST_ID, 1)
4323 END
4324
4325 /* QUEST 2 CHECK */
4326 IF NOT EXISTS ( SELECT 1 FROM @QUESTS WHERE TypeID = @QUEST_TYPEID2 ) BEGIN
4327 INSERT INTO [DBO].Pangya_Achievement( UID, TypeID, Type ) VALUES ( @UID, @QUEST_TYPEID2, 1 )
4328 SELECT @LAST_ID = SCOPE_IDENTITY()
4329 EXEC [DBO].ProcInsertDailyQuest @IN_UID = @UID, @QUESTID = @LAST_ID, @DAILYQUEST = @QUEST_TYPEID2
4330 INSERT INTO @NEW_QUEST VALUES (@QUEST_TYPEID2, @LAST_ID, 1)
4331 END
4332
4333 /* QUEST 3 CHECK */
4334 IF NOT EXISTS ( SELECT 1 FROM @QUESTS WHERE TypeID = @QUEST_TYPEID3 ) BEGIN
4335 INSERT INTO [DBO].Pangya_Achievement( UID, TypeID, Type ) VALUES ( @UID, @QUEST_TYPEID3, 1 )
4336 SELECT @LAST_ID = SCOPE_IDENTITY()
4337 EXEC [DBO].ProcInsertDailyQuest @IN_UID = @UID, @QUESTID = @LAST_ID, @DAILYQUEST = @QUEST_TYPEID3
4338 INSERT INTO @NEW_QUEST VALUES (@QUEST_TYPEID3, @LAST_ID, 1)
4339 END
4340
4341 /* NEW QUEST */
4342 SELECT * FROM @NEW_QUEST
4343
4344 /* DAILY DETAIL */
4345 SELECT @QUEST_TYPEID1 AS Quest1,
4346 @QUEST_TYPEID2 AS Quest2,
4347 @QUEST_TYPEID3 AS Quest3,
4348 @QUEST_TIME AS QuestRegDate,
4349 CASE WHEN (LastCancel > LastAccept) OR (LastAccept IS NULL)
4350 THEN DBO.UNIX_TIMESTAMP(RegDate)
4351 ELSE DBO.UNIX_TIMESTAMP(LastAccept) END AS ActivityDate
4352 FROM [DBO].Pangya_Daily_Quest
4353 WHERE UID = @UID
4354
4355 /* OLD QUEST */
4356 SELECT * FROM @OLD_QUEST
4357END
4358GO
4359/****** Object: StoredProcedure [dbo].[USP_FIRST_CREATION] Script Date: 19/10/2018 08:23:23 ******/
4360SET ANSI_NULLS ON
4361GO
4362SET QUOTED_IDENTIFIER ON
4363GO
4364
4365CREATE PROCEDURE [dbo].[USP_FIRST_CREATION]
4366 @UID INT,
4367 @CHAR_TYPEID INT,
4368 @HAIRCOLOUR TINYINT,
4369 @NICKNAME VARCHAR(50)
4370AS
4371BEGIN
4372 SET NOCOUNT ON;
4373
4374 DECLARE @CODE TINYINT
4375 DECLARE @DATETIME DATETIME
4376 DECLARE @ITEM_ID BIGINT
4377 DECLARE @CID INT = 0
4378 DECLARE @MAIL_INDEX INT = 0
4379 DECLARE @DATENOW DATE = CONVERT (DATE, GETDATE())
4380 -- NICKNAME
4381 DECLARE @NICK VARCHAR(20)
4382 SELECT @NICK = RTRIM(LTRIM(@NICKNAME))
4383
4384 DECLARE @CLUB_INDEX INT = 0
4385 DECLARE @CHAR_INDEX INT = 0
4386
4387 IF EXISTS (SELECT 1 FROM [dbo].Pangya_Member WHERE UID = @UID AND FirstSet = 0) BEGIN
4388 UPDATE [dbo].Pangya_Member SET FirstSet = 1, Nickname = @NICK WHERE UID = @UID
4389
4390 -- Pangya Equip
4391 INSERT INTO [dbo].Pangya_User_Equip(UID) VALUES (@UID)
4392
4393 -- Insert Default Item
4394 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436207622, 50); -- Lucky Necklace
4395 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 402653188, 50);
4396 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 402653189, 50);
4397 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 402653195, 50);
4398 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 402653194, 50);
4399 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 402653185, 50);
4400 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 402653184, 50);
4401 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 402653190, 50);
4402 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 402653193, 50);
4403 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 467664918, 1); -- Assist
4404
4405 -- Insert Ball
4406 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 335544320, 1);
4407
4408 -- Insert Club
4409 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 268435541, 1);
4410 SELECT @CLUB_INDEX = SCOPE_IDENTITY()
4411
4412 -- Insert Character
4413
4414 INSERT INTO [dbo].Pangya_Character(UID,TYPEID,HAIR_COLOR,GIFT_FLAG) VALUES (@UID, 67108864, @HAIRCOLOUR, 1)
4415 INSERT INTO [dbo].Pangya_Character(UID,TYPEID,HAIR_COLOR,GIFT_FLAG) VALUES (@UID, 67108865, @HAIRCOLOUR, 1)
4416 INSERT INTO [dbo].Pangya_Character(UID,TYPEID,HAIR_COLOR,GIFT_FLAG) VALUES (@UID, 67108866, @HAIRCOLOUR, 1)
4417 INSERT INTO [dbo].Pangya_Character(UID,TYPEID,HAIR_COLOR,GIFT_FLAG) VALUES (@UID, 67108867, @HAIRCOLOUR, 1)
4418 INSERT INTO [dbo].Pangya_Character(UID,TYPEID,HAIR_COLOR,GIFT_FLAG) VALUES (@UID, 67108868, @HAIRCOLOUR, 1)
4419 INSERT INTO [dbo].Pangya_Character(UID,TYPEID,HAIR_COLOR,GIFT_FLAG) VALUES (@UID, 67108869, @HAIRCOLOUR, 1)
4420 INSERT INTO [dbo].Pangya_Character(UID,TYPEID,HAIR_COLOR,GIFT_FLAG) VALUES (@UID, 67108870, @HAIRCOLOUR, 1)
4421 INSERT INTO [dbo].Pangya_Character(UID,TYPEID,HAIR_COLOR,GIFT_FLAG) VALUES (@UID, 67108871, @HAIRCOLOUR, 1)
4422 INSERT INTO [dbo].Pangya_Character(UID,TYPEID,HAIR_COLOR,GIFT_FLAG) VALUES (@UID, 67108872, @HAIRCOLOUR, 1)
4423 INSERT INTO [dbo].Pangya_Character(UID,TYPEID,HAIR_COLOR,GIFT_FLAG) VALUES (@UID, 67108873, @HAIRCOLOUR, 1)
4424 INSERT INTO [dbo].Pangya_Character(UID,TYPEID,HAIR_COLOR,GIFT_FLAG) VALUES (@UID, 67108874, @HAIRCOLOUR, 1)
4425 INSERT INTO [dbo].Pangya_Character(UID,TYPEID,HAIR_COLOR,GIFT_FLAG) VALUES (@UID, 67108875, @HAIRCOLOUR, 1)
4426 INSERT INTO [dbo].Pangya_Character(UID,TYPEID,HAIR_COLOR,GIFT_FLAG) VALUES (@UID, 67108876, @HAIRCOLOUR, 1)
4427 INSERT INTO [dbo].Pangya_Character(UID,TYPEID,HAIR_COLOR,GIFT_FLAG) VALUES (@UID, 67108878, @HAIRCOLOUR, 1)
4428 SET @CHAR_INDEX = SCOPE_IDENTITY()
4429
4430 SET @CID = (SELECT CID FROM [dbo].Pangya_Character WHERE UID = @UID AND TYPEID = @CHAR_TYPEID)
4431 INSERT INTO [dbo].Pangya_Character_Equip(UID, CHAR_IDX) VALUES(@UID, @CID)
4432
4433 -- ADICIONA OS ITENS DO NURI
4434 IF(@CHAR_TYPEID = 67108864) BEGIN
4435 -- ELF = High Elfen Ears (N)
4436 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 134359054);
4437 -- ASA = Corrupt Demonic Wings(N)
4438 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 134309904);
4439 END
4440
4441 -- ADICIONA OS ITENS DA HANA
4442 IF(@CHAR_TYPEID = 67108865) BEGIN
4443 -- ELF
4444 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 134621198);
4445 -- ASA
4446 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 134580240);
4447 END
4448
4449 -- ADICIONA OS ITENS DA CECILIA
4450 IF(@CHAR_TYPEID = 67108867) BEGIN
4451 -- ELF
4452 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135145486);
4453 -- ASA
4454 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135120912);
4455 END
4456
4457 -- ADICIONA OS ITENS DO AZER
4458 IF(@CHAR_TYPEID = 67108866) BEGIN
4459 -- ELF
4460 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 134899726);
4461 -- ASA
4462 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 134842384);
4463 END
4464
4465 -- ADICIONA OS ITENS DO MAX
4466 IF(@CHAR_TYPEID = 67108868) BEGIN
4467 -- ELF
4468 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135432206);
4469 -- ASA
4470 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135366672);
4471 ---Jolly Roger Pirate Set (M)
4472 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 608206867);
4473 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 608206893);
4474 END
4475
4476 -- ADICIONA OS ITENS DA KOOH
4477 IF(@CHAR_TYPEID = 67108869) BEGIN
4478 -- ELF
4479 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135702542);
4480 -- ASA
4481 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135661584);
4482 --- Passionate Training Set (K)
4483 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135545034);
4484 --- blazing track Shorts (K)
4485 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135569467);
4486 --- Boost running Shoes
4487 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135585973);
4488 -- cabelo passionate
4489 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135692332);
4490
4491 END
4492
4493 -- ADICIONA OS ITENS DA ARIN
4494 IF(@CHAR_TYPEID = 67108870) BEGIN
4495 -- ELF
4496 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135923726);
4497 -- ASA
4498 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135858192);
4499 END
4500
4501 -- ADICIONA OS ITENS DO KAZ
4502 IF(@CHAR_TYPEID = 67108871) BEGIN
4503 -- ELF
4504 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136210446);
4505 -- ASA
4506 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136194064);
4507 END
4508
4509 -- ADICIONA OS ITENS DA LUCIA
4510 IF(@CHAR_TYPEID = 67108872) BEGIN
4511 -- ELF
4512 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136456206);
4513 -- ASA
4514 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136398864);
4515 -- Magical Costume Set(L)
4516 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 608239622);
4517 END
4518
4519 -- ADICIONA OS ITENS DA NELL
4520 IF(@CHAR_TYPEID = 67108873) BEGIN
4521 -- ELF
4522 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136718350);
4523 -- ASA
4524 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136661008);
4525 END
4526
4527 -- ADICIONA OS ITENS DA SPIKA
4528 IF(@CHAR_TYPEID = 67108874) BEGIN
4529 -- ELF
4530 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136980494);
4531 -- ASA
4532 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136923154);
4533 END
4534
4535 -- ADICIONA OS ITENS DO NURI (R)
4536 IF(@CHAR_TYPEID = 67108875) BEGIN
4537 -- ELF
4538 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 137234437);
4539 -- ASA
4540 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 137185283);
4541 END
4542
4543 -- ADICIONA OS ITENS DA HANA (R)
4544 IF(@CHAR_TYPEID = 67108876) BEGIN
4545 -- ELF
4546 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 137488393);
4547 -- ASA
4548 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 137447437);
4549 END
4550
4551 -- ADICIONA OS ITENS DA CECILIA (R)
4552 IF(@CHAR_TYPEID = 67108878) BEGIN
4553 -- ELF
4554 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 138029062);
4555 -- ASA
4556 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 138004493);
4557 END
4558
4559 -- Update Equip
4560 UPDATE DBO.Pangya_User_Equip
4561 SET BALL_ID = 335544320,
4562 CLUB_ID = @CLUB_INDEX,
4563 CHARACTER_ID = @CID
4564 WHERE UID = @UID
4565
4566 -- Insert User Statistic
4567 INSERT INTO [DBO].Pangya_User_Statistics(UID, Pang, Game_Level) VALUES (@UID, 1500000, 31)
4568
4569 -- Insert Into Macro
4570 INSERT INTO [dbo].Pangya_Game_Macro(UID) VALUES (@UID)
4571
4572 -- Insert Personal
4573 INSERT INTO [DBO].Pangya_Personal(UID, CookieAmt) VALUES (@UID, 250000)
4574
4575 -- Calliper
4576 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436207680, 500);
4577
4578 -- Scratchy Card
4579 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436207779, 20);
4580
4581 -- Booster
4582 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436207633, 500);
4583
4584 -- Auto comander
4585 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208031, 200);
4586
4587 -- Card Remover
4588 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436207810, 5);
4589
4590 -- SSC Ticket
4591 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436207863, 50);
4592
4593 -- Moeda do Memorial Premium
4594 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208242, 120);
4595
4596 -- Orchid Blossom
4597 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208036, 1);
4598 --INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208037, 50);
4599
4600 -- Abacus Blossom
4601 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208038, 1);
4602 --INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208039, 50);
4603
4604 -- Wind Mill Key
4605 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208040, 1);
4606 --INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208041, 50);
4607
4608 -- Lumines Coral
4609 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208042, 1);
4610 --INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208043, 50);
4611
4612 -- Tropical Palm Tree
4613 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208044, 1);
4614 --INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208045, 50);
4615
4616 -- Mon Mirror
4617 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208046, 1);
4618 --INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208047, 50);
4619
4620 -- Marsh Wrench
4621 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208048, 1);
4622 --INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208049, 50);
4623
4624 -- Silvia Carrier
4625 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208050, 1);
4626 --INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208051, 50);
4627
4628 -- Wicked Brew
4629 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208052, 1);
4630 --INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208053, 50);
4631
4632 -- Theo Wright Ore
4633 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208054, 1);
4634 --INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208055, 50);
4635
4636 -- Wiz Red Berry
4637 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208056, 1);
4638 --INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208057, 50);
4639
4640 -- Mark Your Flower
4641 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208058, 1);
4642 --INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208059, 50);
4643
4644 -- Steering Roger K
4645 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208060, 1);
4646 --INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208061, 50);
4647
4648 -- Rainbow Magic Hat
4649 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208062, 1);
4650 --INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208063, 50);
4651
4652 -- Four God Figure
4653 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208064, 1);
4654 --INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208065, 50);
4655
4656 -- Zephyr Mechanical Totem
4657 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208066, 1);
4658 --INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208067, 50);
4659 -- Acievement
4660 EXEC DBO.ProcCreateAchievement @UID
4661
4662 -- Crinsom Ring
4663 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 1879113856, 1);
4664 -- Anel da direita
4665 INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 1881210881, 1);
4666 UPDATE [dbo].Pangya_Character SET AUX_1 = 1879113856 WHERE UID = @UID
4667 UPDATE [dbo].Pangya_Character SET AUX_2 = 1881210881 WHERE UID = @UID
4668 -- Mascot Fire Spirit
4669 SET @DATETIME = DATEADD(DAY, 30, GETDATE())
4670 INSERT INTO DBO.Pangya_Mascot(UID, MASCOT_TYPEID, DateEnd) VALUES (@UID, 1073741854, @DATETIME)
4671 SET @ITEM_ID = SCOPE_IDENTITY()
4672 INSERT INTO DBO.Pangya_Caddie(UID, TYPEID, END_DATE) VALUES (@UID, 469762068, @DATETIME)
4673 UPDATE [dbo].Pangya_User_Equip SET MASCOT_ID = @ITEM_ID WHERE UID = @UID
4674 UPDATE [DBO].Pangya_User_Equip SET CADDIE = @ITEM_ID WHERE UID = @UID
4675 SET @CODE = 1;
4676 END ELSE BEGIN
4677 SET @CODE = 5;
4678 END
4679
4680 SELECT @CODE AS CODE
4681
4682END
4683GO
4684/****** Object: StoredProcedure [dbo].[USP_GAME_LOGIN] Script Date: 19/10/2018 08:23:23 ******/
4685SET ANSI_NULLS ON
4686GO
4687SET QUOTED_IDENTIFIER ON
4688GO
4689CREATE PROCEDURE [dbo].[USP_GAME_LOGIN]
4690 @USERID VARCHAR(20),
4691 @UID INT,
4692 @Code1 VARCHAR(10),
4693 @Code2 VARCHAR(10)
4694AS
4695BEGIN
4696 SET NOCOUNT ON;
4697
4698 IF EXISTS (
4699 SELECT 1
4700 FROM [dbo].Pangya_Member
4701 WHERE UID = @UID
4702 AND Username = @USERID COLLATE Latin1_General_CS_AS
4703 AND AuthKey_Login = @Code1 COLLATE Latin1_General_CS_AS
4704 AND AuthKey_Game = @Code2 COLLATE Latin1_General_CS_AS
4705 )
4706 BEGIN
4707 SELECT 1 AS Code,
4708 A.Username,
4709 A.Nickname,
4710 A.Sex,
4711 A.Capabilities,
4712 C.LockerPwd,
4713 -- A.GUILDINDEX,
4714 B.Game_Level,
4715 B.Game_Point,
4716 -- B.Pang,
4717 C.CookieAmt AS Cookie,
4718 C.PangLockerAmt
4719 FROM [dbo].Pangya_Member A
4720 INNER JOIN [DBO].Pangya_User_Statistics B
4721 ON B.UID = A.UID
4722 INNER JOIN [DBO].Pangya_Personal C
4723 ON C.UID = A.UID
4724 WHERE A.UID = @UID
4725 -- UPDATE
4726 UPDATE [dbo].Pangya_Member SET Logon = 1, LogonCount = LogonCount + 1, LastLogonTime = GETDATE() WHERE UID = @UID
4727 END ELSE BEGIN
4728 SELECT 0 AS Code
4729 END
4730
4731END
4732GO
4733/****** Object: StoredProcedure [dbo].[USP_GAME_LOGOUT] Script Date: 19/10/2018 08:23:23 ******/
4734SET ANSI_NULLS ON
4735GO
4736SET QUOTED_IDENTIFIER ON
4737GO
4738CREATE PROCEDURE [dbo].[USP_GAME_LOGOUT]
4739 @UID INT
4740AS
4741BEGIN
4742
4743 SET NOCOUNT ON;
4744
4745 UPDATE [dbo].Pangya_Member SET Logon = 0 WHERE UID = @UID
4746END
4747GO
4748/****** Object: StoredProcedure [dbo].[USP_GET_ACHIEVEMENT] Script Date: 19/10/2018 08:23:23 ******/
4749SET ANSI_NULLS ON
4750GO
4751SET QUOTED_IDENTIFIER ON
4752GO
4753-- =============================================
4754-- Author: TOP
4755-- Create date:
4756-- Description:
4757-- =============================================
4758CREATE PROCEDURE [dbo].[USP_GET_ACHIEVEMENT]
4759 @UID INT
4760AS
4761BEGIN
4762 SET NOCOUNT ON;
4763
4764 SELECT ID,TypeID FROM [DBO].Pangya_Achievement WHERE UID = @UID
4765END
4766GO
4767/****** Object: StoredProcedure [dbo].[USP_GET_COUNTER] Script Date: 19/10/2018 08:23:23 ******/
4768SET ANSI_NULLS ON
4769GO
4770SET QUOTED_IDENTIFIER ON
4771GO
4772-- =============================================
4773-- Author: TOP
4774-- Create date:
4775-- Description:
4776-- =============================================
4777CREATE PROCEDURE [dbo].[USP_GET_COUNTER]
4778 @UID INT
4779AS
4780BEGIN
4781 SET NOCOUNT ON;
4782
4783 SELECT ID, TypeID, Quantity From [DBO].Pangya_Achievement_Counter WHERE UID = @UID
4784END
4785GO
4786/****** Object: StoredProcedure [dbo].[USP_GUILD_ACTION] Script Date: 19/10/2018 08:23:23 ******/
4787SET ANSI_NULLS ON
4788GO
4789SET QUOTED_IDENTIFIER ON
4790GO
4791
4792-- =============================================
4793-- Author: TOP
4794-- Create date:
4795-- Description:
4796-- =============================================
4797CREATE PROCEDURE [dbo].[USP_GUILD_ACTION]
4798 @UID INT
4799 ,@GUILDID INT
4800 ,@GUILDACTION INT
4801 ,@GUILDVALUE INT = 0
4802 ,@GUILDVALUE2 INT = 0
4803 ,@GUILDVALUE3 VARCHAR(255) = ''
4804AS
4805BEGIN
4806 SET NOCOUNT ON;
4807
4808 DECLARE @StatCode INT = -1
4809
4810 /********************
4811 1. Accept Player
4812 0 = Succesfully Accept Player
4813 1 = Unsuccessfully Accept Player
4814 2 = You are not guild master
4815 ********************/
4816 IF (@GUILDACTION = 1)
4817 BEGIN
4818 IF EXISTS (SELECT 1 FROM [dbo].Pangya_Guild_Member WHERE GUILD_ID = @GUILDID AND GUILD_MEMBER_UID = @UID AND GUILD_POSITION IN (1,2))
4819 BEGIN
4820 -- BEGIN TRAN
4821 BEGIN TRANSACTION
4822 BEGIN TRY
4823 UPDATE [dbo].Pangya_Guild_Member SET GUILD_POSITION = 3 WHERE GUILD_ID = @GUILDID AND GUILD_MEMBER_UID = @GUILDVALUE AND GUILD_POSITION = 9
4824 IF (@@ROWCOUNT > 0)
4825 BEGIN
4826 -- INSERT LOG 3 = ACCPET
4827 INSERT INTO [DBO].Pangya_Guild_Log(UID, GUILD_ID, GUILD_NAME, GUILD_ACTION)
4828 SELECT @GUILDVALUE, GUILD_INDEX, GUILD_NAME, 3 FROM [DBO].Pangya_Guild_Info WHERE GUILD_INDEX = @GUILDID AND GUILD_VALID = 1
4829 UPDATE [DBO].Pangya_Member SET GUILDINDEX = @GUILDID WHERE UID = @GUILDVALUE
4830 SET @StatCode = 0
4831 END ELSE BEGIN
4832 SET @StatCode = 1
4833 END
4834 -- COMMIT TRAN
4835 COMMIT TRANSACTION
4836 END TRY
4837 BEGIN CATCH
4838 -- ROLLBACK TRAN
4839 ROLLBACK TRANSACTION
4840 SET @StatCode = 1
4841 END CATCH
4842 END ELSE BEGIN
4843 SET @StatCode = 2
4844 END
4845 END
4846
4847 /********************
4848 2. Kick Player
4849 0 = Successfully Delete
4850 1 = Unsuccessfully Delete
4851 2 = Player is not Master
4852 ********************/
4853 IF (@GUILDACTION = 2)
4854 BEGIN
4855 IF EXISTS(SELECT 1 FROM [dbo].Pangya_Guild_Member WHERE GUILD_ID = @GUILDID AND GUILD_MEMBER_UID = @UID AND GUILD_POSITION IN (1,2))
4856 BEGIN
4857 -- BEGIN TRAN
4858 BEGIN TRANSACTION
4859 BEGIN TRY
4860 DELETE [DBO].Pangya_Guild_Member WHERE GUILD_ID = @GUILDID AND GUILD_MEMBER_UID = @GUILDVALUE AND GUILD_POSITION IN (2,3,9)
4861 IF (@@ROWCOUNT > 0)
4862 BEGIN
4863 UPDATE [DBO].Pangya_Member SET GUILDINDEX = 0 WHERE UID = @GUILDVALUE
4864 IF (@@ROWCOUNT > 0)
4865 BEGIN
4866 -- INSERT LOG 6 = KICK
4867 INSERT INTO [DBO].Pangya_Guild_Log(UID, GUILD_ID, GUILD_NAME, GUILD_ACTION)
4868 SELECT @GUILDVALUE, GUILD_INDEX, GUILD_NAME, 6 FROM [DBO].Pangya_Guild_Info WHERE GUILD_INDEX = @GUILDID AND GUILD_VALID = 1
4869
4870 SET @StatCode = 0
4871 END ELSE BEGIN
4872 SET @StatCode = 1
4873 END
4874 END ELSE BEGIN
4875 SET @StatCode = 1
4876 END
4877 -- COMMIT
4878 COMMIT TRANSACTION
4879 END TRY
4880 BEGIN CATCH
4881 -- ROLLBACK
4882 ROLLBACK TRANSACTION
4883 SET @StatCode = 1
4884 END CATCH
4885 END ELSE BEGIN
4886 SET @StatCode = 2
4887 END
4888 END
4889
4890 /********************
4891 3. Promote Player
4892 0 = Successfully Promote
4893 8 = Unsuccessfully Promote
4894 9 = You are not admin
4895 10 = Bad Value
4896 ********************/
4897 IF (@GUILDACTION = 3)
4898 BEGIN
4899 IF NOT @GUILDVALUE2 IN (2,3)
4900 BEGIN
4901 SET @StatCode = 10
4902 END ELSE BEGIN
4903 IF EXISTS (SELECT 1 FROM [dbo].Pangya_Guild_Member WHERE GUILD_ID = @GUILDID AND GUILD_MEMBER_UID = @UID AND GUILD_POSITION = 1)
4904 BEGIN
4905 -- BEGIN TRAN
4906 BEGIN TRANSACTION
4907 BEGIN TRY
4908 UPDATE [dbo].Pangya_Guild_Member SET GUILD_POSITION = @GUILDVALUE2 WHERE GUILD_ID = @GUILDID AND GUILD_MEMBER_UID = @GUILDVALUE AND GUILD_POSITION IN (2,3)
4909 IF (@@ROWCOUNT > 0)
4910 BEGIN
4911 -- INSERT LOG 0C=Secondary Admin, 0D=As Member
4912 INSERT INTO [DBO].Pangya_Guild_Log(UID, GUILD_ID, GUILD_NAME, GUILD_ACTION)
4913 SELECT @GUILDVALUE, GUILD_INDEX, GUILD_NAME,
4914 CASE WHEN @GUILDVALUE2 = 2 THEN 12 WHEN @GUILDVALUE2 = 3 THEN 13 ELSE 0 END
4915 FROM [DBO].Pangya_Guild_Info WHERE GUILD_INDEX = @GUILDID AND GUILD_VALID = 1
4916
4917 SET @StatCode = 0
4918 END ELSE BEGIN
4919 SET @StatCode = 8
4920 END
4921 -- COMMIT
4922 COMMIT TRANSACTION
4923 END TRY
4924 BEGIN CATCH
4925 -- ROLLBACK
4926 ROLLBACK TRANSACTION
4927 SET @StatCode = 8
4928 END CATCH
4929 END ELSE BEGIN
4930 SET @StatCode = 9
4931 END
4932 END
4933 END
4934
4935 /********************
4936 4. Change Intro
4937 0 = Successfully Change
4938 8 = Unsuccessfully Change
4939 9 = You are not admin
4940 * This is not need to be in transaction because it's less important
4941 ********************/
4942 IF (@GUILDACTION = 4)
4943 BEGIN
4944 IF EXISTS (SELECT 1 FROM [dbo].Pangya_Guild_Member WHERE GUILD_ID = @GUILDID AND GUILD_MEMBER_UID = @UID AND GUILD_POSITION IN(1,2)) AND LEN(@GUILDVALUE3) > 0
4945 BEGIN
4946 UPDATE [DBO].Pangya_Guild_Info SET GUILD_INTRODUCING = @GUILDVALUE3 WHERE GUILD_INDEX = @GUILDID AND GUILD_VALID = 1
4947 IF (@@ROWCOUNT > 0)
4948 BEGIN
4949 SET @StatCode = 0
4950 END ELSE BEGIN
4951 SET @StatCode = 8
4952 END
4953 END ELSE BEGIN
4954 SET @StatCode = 9
4955 END
4956 END
4957
4958 /********************
4959 5. Change Notice
4960 0 = Successfully Change
4961 8 = Unsuccessfully Change
4962 9 = You are not admin
4963 * This is not need to be in transaction because it's less important
4964 ********************/
4965 IF (@GUILDACTION = 5)
4966 BEGIN
4967 IF EXISTS (SELECT 1 FROM [dbo].Pangya_Guild_Member WHERE GUILD_ID = @GUILDID AND GUILD_MEMBER_UID = @UID AND GUILD_POSITION IN(1,2)) AND LEN(@GUILDVALUE3) > 0
4968 BEGIN
4969 UPDATE [DBO].Pangya_Guild_Info SET GUILD_NOTICE = @GUILDVALUE3 WHERE GUILD_INDEX = @GUILDID AND GUILD_VALID = 1
4970 IF (@@ROWCOUNT > 0)
4971 BEGIN
4972 SET @StatCode = 0
4973 END ELSE BEGIN
4974 SET @StatCode = 8
4975 END
4976 END ELSE BEGIN
4977 SET @StatCode = 9
4978 END
4979 END
4980
4981 /********************
4982 * 6. Change Player Intro
4983 0 = Successfully Change
4984 8 = Unsuccessfully Change
4985 * This is not need to be in transaction because it's less important
4986 ********************/
4987 IF (@GUILDACTION = 6)
4988 BEGIN
4989 IF EXISTS (SELECT 1 FROM [dbo].Pangya_Guild_Member WHERE GUILD_ID = @GUILDID AND GUILD_MEMBER_UID = @UID AND GUILD_POSITION IN(1,2)) AND LEN(@GUILDVALUE3) > 0
4990 BEGIN
4991 UPDATE DBO.Pangya_Guild_Member SET GUILD_MESSAGE = @GUILDVALUE3 WHERE GUILD_ID = @GUILDID AND GUILD_MEMBER_UID = @GUILDVALUE
4992 IF (@@ROWCOUNT > 0)
4993 BEGIN
4994 SET @StatCode = 0
4995 END ELSE BEGIN
4996 SET @StatCode = 8
4997 END
4998 END ELSE BEGIN
4999 SET @StatCode = 9
5000 END
5001 END
5002
5003 /********************
5004 * 7. Player Leave Guild
5005 0 = Successfully Change
5006 8 = Unsuccessfully Change
5007 ********************/
5008 IF (@GUILDACTION = 7)
5009 BEGIN
5010 IF EXISTS (SELECT 1 FROM [DBO].Pangya_Guild_Member WHERE GUILD_ID = @GUILDID AND GUILD_MEMBER_UID = @UID AND GUILD_POSITION IN (2,3))
5011 BEGIN
5012 -- BEGIN TRAN
5013 BEGIN TRANSACTION
5014 BEGIN TRY
5015 DELETE FROM [DBO].Pangya_Guild_Member WHERE GUILD_ID = @GUILDID AND GUILD_MEMBER_UID = @UID AND GUILD_POSITION IN (2,3)
5016 IF (@@ROWCOUNT > 0)
5017 BEGIN
5018 UPDATE [DBO].Pangya_Member SET GUILDINDEX = 0 WHERE UID = @UID
5019 IF (@@ROWCOUNT > 0) BEGIN
5020 -- INSERT LOG 6 = LEAVE
5021 INSERT INTO [DBO].Pangya_Guild_Log(UID, GUILD_ID, GUILD_NAME, GUILD_ACTION)
5022 SELECT @UID, GUILD_INDEX, GUILD_NAME, 7 FROM [DBO].Pangya_Guild_Info WHERE GUILD_INDEX = @GUILDID AND GUILD_VALID = 1
5023 SET @StatCode = 0
5024 END ELSE BEGIN
5025 SET @StatCode = 8
5026 END
5027 END ELSE BEGIN
5028 SET @StatCode = 8
5029 END
5030 -- COMMIT
5031 COMMIT TRANSACTION
5032 END TRY
5033 BEGIN CATCH
5034 -- ROLLBACK
5035 ROLLBACK TRANSACTION
5036 SET @StatCode = 8
5037 END CATCH
5038 END ELSE BEGIN
5039 SET @StatCode = 8
5040 END
5041 END
5042
5043 -- SELECT RESULT CODE
5044 SELECT @StatCode AS CODE
5045END
5046GO
5047/****** Object: StoredProcedure [dbo].[USP_GUILD_CANCELJOIN] Script Date: 19/10/2018 08:23:23 ******/
5048SET ANSI_NULLS ON
5049GO
5050SET QUOTED_IDENTIFIER ON
5051GO
5052-- ========================â™ =====================
5053-- Author: TOP
5054-- Create date:
5055-- Description:
5056-- =============================================
5057CREATE PROCEDURE [dbo].[USP_GUILD_CANCELJOIN]
5058 @UID INT,
5059 @GUILDID INT
5060AS
5061BEGIN
5062 SET NOCOUNT ON;
5063
5064 -- CODE = 10 NOT WAITING FOR ACCEPT OR PLAYER IS ALREADY A MEMBER IN GUILD
5065 -- CODE = 9 GUILD IS NOT EXISTING
5066 -- CODE = 8 PLAYER IS NOT IN GUILD
5067 -- CODE = 0 Successfully cancelled joined
5068 -- CODE = 2 UNKNOWN ERROR IN TRANSACTION
5069
5070 DECLARE @StatCode INT
5071 DECLARE @FGNAME VARCHAR(32) -- GUILD NAME
5072
5073 IF NOT EXISTS (SELECT 1 FROM [dbo].Pangya_Guild_Info WHERE GUILD_INDEX = @GUILDID AND GUILD_VALID = 1) BEGIN
5074 SET @StatCode = 9
5075 END ELSE BEGIN
5076 IF EXISTS (SELECT 1 FROM [dbo].Pangya_Guild_Member WHERE GUILD_ID = @GUILDID AND GUILD_MEMBER_UID = @UID) BEGIN
5077 -- GET GUILD NAME
5078 SELECT @FGNAME = GUILD_NAME FROM [dbo].Pangya_Guild_Info WHERE GUILD_INDEX = @GUILDID AND GUILD_VALID = 1
5079 -- BEGIN TRAN
5080 BEGIN TRANSACTION
5081 BEGIN TRY
5082 -- DELETE INTO GUILD MEMBER
5083 DELETE [dbo].Pangya_Guild_Member WHERE GUILD_ID = @GUILDID AND GUILD_MEMBER_UID = @UID AND GUILD_POSITION = 9
5084 IF @@ROWCOUNT > 0 BEGIN
5085 -- INSERT TO LOG
5086 INSERT INTO [dbo].Pangya_Guild_Log(UID, GUILD_ID, GUILD_NAME, GUILD_ACTION) VALUES(@UID, @GUILDID, @FGNAME, 2)
5087 -- SELECT ALL
5088 SET @StatCode = 0
5089 END ELSE BEGIN
5090 SET @StatCode = 10
5091 END
5092 -- COMMIT
5093 COMMIT TRANSACTION
5094 END TRY
5095 BEGIN CATCH
5096 -- ROLLBACK
5097 ROLLBACK TRANSACTION
5098 SET @StatCode = 2
5099 END CATCH
5100 END ELSE BEGIN
5101 SET @StatCode = 8
5102 END
5103 END
5104
5105 -- SELECT CODE RESULT
5106 SELECT @StatCode AS CODE
5107END
5108GO
5109/****** Object: StoredProcedure [dbo].[USP_GUILD_CREATE] Script Date: 19/10/2018 08:23:23 ******/
5110SET ANSI_NULLS ON
5111GO
5112SET QUOTED_IDENTIFIER ON
5113GO
5114-- =============================================
5115-- Author: TOP
5116-- Create date:
5117-- Description:
5118-- =============================================
5119CREATE PROCEDURE [dbo].[USP_GUILD_CREATE]
5120 @UID INT,
5121 @GUILDNAME VARCHAR(32),
5122 @GUILDINTRO VARCHAR(255)
5123AS
5124BEGIN
5125 SET NOCOUNT ON;
5126 -- CODE 10 = PLAYER IS IN GUILD
5127 -- CODE 0 = SUCCESSFULLY CREATED GUILD
5128 -- CODE 9 = GUILD NAME IS ALREADY EXISTED
5129 -- CODE 2 = TRANSACTION ERROR
5130
5131 DECLARE @GUILDINDEX INT
5132 DECLARE @GUILDINDEX_OUTPUT INT
5133 DECLARE @StatCode TINYINT
5134
5135 SET @GUILDNAME = LTRIM(RTRIM(@GUILDNAME))
5136
5137 IF EXISTS (SELECT 1 FROM [dbo].Pangya_Guild_Info WHERE GUILD_NAME = @GUILDNAME AND GUILD_VALID = 1) BEGIN
5138 SET @StatCode = 9
5139 END ELSE BEGIN
5140 IF NOT EXISTS (SELECT 1 FROM [dbo].Pangya_Guild_Member WHERE GUILD_MEMBER_UID = @UID) BEGIN
5141 -- START TRAN
5142 BEGIN TRANSACTION
5143 BEGIN TRY
5144 -- INSERT INTO GUILD LIST
5145 INSERT INTO [dbo].Pangya_Guild_Info(GUILD_NAME, GUILD_INTRODUCING, GUILD_LEADER_UID) VALUES(@GUILDNAME, @GUILDINTRO, @UID)
5146 -- GET GUILD INDEX
5147 SET @GUILDINDEX_OUTPUT = SCOPE_IDENTITY()
5148 -- UPDATE TO PROFILE
5149 UPDATE [dbo].Pangya_Member SET GUILDINDEX = @GUILDINDEX_OUTPUT WHERE UID = @UID
5150 -- INSERT INTO GUILD MEMBER
5151 INSERT INTO [dbo].Pangya_Guild_Member(GUILD_ID, GUILD_MEMBER_UID, GUILD_POSITION) VALUES(@GUILDINDEX_OUTPUT, @UID, 1 /* 1 = Admin */)
5152 -- INSERT EMBLEM
5153 INSERT INTO [dbo].Pangya_Guild_Emblem(GUILD_ID, GUILD_MARK_IMG) VALUES (@GUILDINDEX_OUTPUT, 'GUILDMARK')
5154 -- INSERT INTO LOG
5155 INSERT INTO [dbo].Pangya_Guild_Log(UID, GUILD_ID, GUILD_NAME, GUILD_ACTION) VALUES (@UID, @GUILDINDEX_OUTPUT, @GUILDNAME, 8)
5156 -- OUTPUT
5157 SET @StatCode = 0
5158 -- COMMIT TRAN
5159 COMMIT TRANSACTION
5160 END TRY
5161 BEGIN CATCH
5162 -- ROLLBACK
5163 ROLLBACK TRANSACTION
5164 SET @StatCode = 2
5165 END CATCH
5166 END ELSE BEGIN
5167 -- CODE = 10 KNOWN AS PLAYER IS ALREADY IN THE GUILD
5168 SET @StatCode = 10
5169 END
5170 END
5171
5172 -- SELECT RESULT
5173 SELECT @StatCode AS CODE
5174
5175END
5176GO
5177/****** Object: StoredProcedure [dbo].[USP_GUILD_EMBLEM] Script Date: 19/10/2018 08:23:23 ******/
5178SET ANSI_NULLS ON
5179GO
5180SET QUOTED_IDENTIFIER ON
5181GO
5182-- =============================================
5183-- Author: TOP
5184-- Create date:
5185-- Description:
5186-- =============================================
5187CREATE PROCEDURE [dbo].[USP_GUILD_EMBLEM]
5188 @UID INT,
5189 @GUILDID INT
5190AS
5191BEGIN
5192 SET NOCOUNT ON;
5193
5194 DECLARE @GuildEmblem VARCHAR(20)
5195
5196 -- 1 = Succesfully
5197 -- 2 = Unsuccesfully
5198
5199 IF EXISTS ( SELECT 1 FROM [dbo].Pangya_Guild_Member WHERE GUILD_ID = @GUILDID AND GUILD_MEMBER_UID = @UID AND GUILD_POSITION = 1 )
5200 BEGIN
5201
5202 WHILE (1=1) BEGIN
5203 SELECT @GuildEmblem = LOWER(LEFT(NEWID(), 8))
5204 IF NOT EXISTS(SELECT 1 FROM DBO.Pangya_Guild_Emblem WHERE GUILD_ID = @GUILDID AND GUILD_MARK_IMG = @GuildEmblem) BEGIN
5205 BREAK
5206 END
5207 END
5208
5209 UPDATE [dbo].Pangya_Guild_Emblem SET GUILD_MARK_IMG = @GuildEmblem WHERE GUILD_ID = @GUILDID
5210 IF (@@ROWCOUNT > 0)
5211 BEGIN
5212 SELECT CODE = 1, EMBLEM_IDX, GUILD_MARK_IMG FROM [DBO].Pangya_Guild_Emblem WHERE GUILD_ID = @GUILDID
5213 END ELSE BEGIN
5214 SELECT CODE = 2
5215 END
5216
5217 END ELSE BEGIN
5218 SELECT CODE = 2
5219 END
5220END
5221GO
5222/****** Object: StoredProcedure [dbo].[USP_GUILD_JOIN] Script Date: 19/10/2018 08:23:23 ******/
5223SET ANSI_NULLS ON
5224GO
5225SET QUOTED_IDENTIFIER ON
5226GO
5227-- =============================================
5228-- Author: TOP
5229-- Create date:
5230-- Description:
5231-- =============================================
5232CREATE PROCEDURE [dbo].[USP_GUILD_JOIN]
5233 @UID INT
5234 ,@GUILDID INT
5235 ,@INTRO VARCHAR(255)
5236AS
5237BEGIN
5238 SET NOCOUNT ON;
5239
5240 -- CODE 9 = GUILD NOT FOUND
5241 -- CODE 8 = PLAYER IS IN GUILD
5242 -- CODE 0 = SUCCESSFULLY JOINED TO GUILD
5243 -- CODE 10 = WAIT 24
5244 -- CODE 2 = TRAN ERROR
5245 DECLARE @FGNAME VARCHAR(32) -- GUILD NAME
5246 DECLARE @StatCode TINYINT
5247
5248 IF EXISTS (SELECT TOP 1 1 FROM [DBO].Pangya_Guild_Log WHERE UID = @UID AND GUILD_ACTION IN (7,9) AND GUILD_ACTION_DATE >= DATEADD(HOUR, -24, GETDATE()))
5249 BEGIN
5250 SET @StatCode = 10
5251 END ELSE IF NOT EXISTS (SELECT 1 FROM [dbo].Pangya_Guild_Info WHERE GUILD_INDEX = @GUILDID AND GUILD_VALID = 1)
5252 BEGIN
5253 SET @StatCode = 9
5254 END ELSE
5255 BEGIN
5256 IF NOT EXISTS (SELECT 1 FROM [dbo].Pangya_Guild_Member WHERE GUILD_MEMBER_UID = @UID )
5257 BEGIN
5258 -- GET GUILD DATA
5259 SELECT @FGNAME = GUILD_NAME FROM [dbo].Pangya_Guild_Info WHERE GUILD_INDEX = @GUILDID AND GUILD_VALID = 1
5260 -- BEGIN TRAN
5261 BEGIN TRANSACTION
5262 BEGIN TRY
5263 -- INSERT INTO GUILD MEMBER
5264 INSERT INTO [dbo].Pangya_Guild_Member (GUILD_ID ,GUILD_MEMBER_UID ,GUILD_POSITION ,GUILD_MESSAGE) VALUES (@GUILDID ,@UID ,9 ,@INTRO)
5265 -- INSERT TO LOG
5266 INSERT INTO [dbo].Pangya_Guild_Log (UID, GUILD_ID ,GUILD_NAME ,GUILD_ACTION) VALUES (@UID, @GUILDID, @FGNAME, 1)
5267 -- SUCESS
5268 SET @StatCode = 0
5269 -- COMMIT
5270 COMMIT TRANSACTION
5271 END TRY
5272 BEGIN CATCH
5273 -- ROLLBACK
5274 ROLLBACK TRANSACTION
5275 SET @StatCode = 2
5276 END CATCH
5277 END ELSE
5278 BEGIN
5279 SET @StatCode = 8
5280 END
5281 END
5282
5283 -- SELECT RESULT
5284 SELECT @StatCode AS CODE
5285END
5286GO
5287/****** Object: StoredProcedure [dbo].[USP_INVEN_POP] Script Date: 19/10/2018 08:23:23 ******/
5288SET ANSI_NULLS ON
5289GO
5290SET QUOTED_IDENTIFIER ON
5291GO
5292CREATE PROCEDURE [dbo].[USP_INVEN_POP]
5293 @UID INT,
5294 @INV_ID INT
5295AS
5296BEGIN
5297 SET NOCOUNT ON
5298
5299 DECLARE @ITEM_FROM_ID INT = 0
5300 DECLARE @SUC_COUNT TINYINT = 0
5301
5302 IF EXISTS (
5303 SELECT 1
5304 FROM DBO.Pangya_Locker_Item
5305 WHERE UID = @UID
5306 AND INVEN_ID = @INV_ID
5307 AND VALID = 1
5308 ) BEGIN
5309
5310 SELECT @ITEM_FROM_ID = FROM_ID
5311 FROM DBO.Pangya_Locker_Item
5312 WHERE UID = @UID
5313 AND INVEN_ID = @INV_ID
5314 AND VALID = 1
5315
5316 IF (@ITEM_FROM_ID IS NOT NULL) AND (@ITEM_FROM_ID > 0) BEGIN
5317
5318 BEGIN TRANSACTION
5319 BEGIN TRY
5320
5321 UPDATE DBO.Pangya_Warehouse
5322 SET VALID = 1
5323 WHERE UID = @UID
5324 AND ITEM_ID = @ITEM_FROM_ID
5325 AND VALID = 0
5326
5327 IF (@@ROWCOUNT > 0)
5328 SET @SUC_COUNT = @SUC_COUNT + 1
5329
5330 UPDATE DBO.Pangya_Locker_Item
5331 SET VALID = 0
5332 WHERE UID = @UID
5333 AND INVEN_ID = @INV_ID
5334 AND VALID = 1
5335
5336 IF (@@ROWCOUNT > 0)
5337 SET @SUC_COUNT = @SUC_COUNT + 1
5338
5339 IF (@@ERROR = 0) AND (@SUC_COUNT = 2) BEGIN
5340 COMMIT TRANSACTION
5341
5342 -- RETURN SUC
5343 SELECT ERROR = 0
5344
5345 -- RETURN ITEM DATA
5346 SELECT A.ITEM_ID
5347 , A.TYPEID
5348 , A.C0
5349 , A.C1
5350 , A.C2
5351 , A.C3
5352 , A.C4
5353 -- , A.RegDate
5354 , A.DateEnd
5355 -- , A.ITEMTYPE
5356 , A.FLAG
5357 , B.UCC_UNIQE
5358 , B.UCC_STATUS
5359 , B.UCC_NAME
5360 , B.UCC_DRAWER_UID
5361 , B.UCC_DRAWER_NICKNAME
5362 , B.UCC_COPY_COUNT
5363 FROM DBO.Pangya_Warehouse A
5364 OUTER APPLY (
5365 SELECT X.UCC_UNIQE
5366 , X.UCC_STATUS
5367 , X.UCC_NAME
5368 , X.UCC_DRAWER AS UCC_DRAWER_UID
5369 , X.UCC_COPY_COUNT
5370 , Y.NICKNAME AS UCC_DRAWER_NICKNAME
5371 FROM DBO.Pangya_SelfDesign X
5372 LEFT JOIN DBO.Pangya_Member Y
5373 ON Y.UID = X.UCC_DRAWER
5374 WHERE X.ITEM_ID = A.ITEM_ID
5375 ) B
5376 WHERE A.UID = @UID
5377 AND A.item_id = @ITEM_FROM_ID
5378 AND A.VALID = 1
5379
5380
5381 END ELSE BEGIN
5382 ROLLBACK TRANSACTION
5383 SELECT ERROR = 1
5384 END
5385 END TRY
5386 BEGIN CATCH
5387 ROLLBACK TRANSACTION
5388 SELECT ERROR = 1
5389 END CATCH
5390 END ELSE BEGIN
5391 SELECT ERROR = 1
5392 END
5393 END ELSE BEGIN
5394 SELECT ERROR = 1
5395 END
5396
5397END
5398GO
5399/****** Object: StoredProcedure [dbo].[USP_INVEN_PUSH] Script Date: 19/10/2018 08:23:23 ******/
5400SET ANSI_NULLS ON
5401GO
5402SET QUOTED_IDENTIFIER ON
5403GO
5404CREATE PROCEDURE [dbo].[USP_INVEN_PUSH]
5405 @UID INT,
5406 @TYPEID INT,
5407 @NAME VARCHAR(255),
5408 @FROM_ID INT
5409AS
5410BEGIN
5411 SET NOCOUNT ON
5412
5413 BEGIN TRANSACTION
5414 BEGIN TRY
5415
5416 INSERT INTO DBO.Pangya_Locker_Item(UID, TypeID, Name, FROM_ID)
5417 VALUES (@UID, @TYPEID, @NAME, @FROM_ID)
5418
5419 UPDATE DBO.Pangya_Warehouse
5420 SET VALID = 0
5421 WHERE item_id = @FROM_ID
5422 AND VALID = 1
5423
5424 IF (@@ROWCOUNT > 0) BEGIN
5425 COMMIT TRANSACTION
5426 SELECT 0 AS CODE
5427 END ELSE BEGIN
5428 ROLLBACK TRANSACTION
5429 SELECT 1 AS CODE
5430 END
5431
5432 END TRY
5433 BEGIN CATCH
5434 ROLLBACK TRANSACTION
5435 SELECT 1 AS CODE
5436 END CATCH
5437
5438END
5439GO
5440/****** Object: StoredProcedure [dbo].[USP_LOGIN_SERVER] Script Date: 19/10/2018 08:23:23 ******/
5441SET ANSI_NULLS ON
5442GO
5443SET QUOTED_IDENTIFIER ON
5444GO
5445CREATE PROCEDURE [dbo].[USP_LOGIN_SERVER]
5446 @User VARCHAR(20),
5447 @Pwd VARCHAR(20),
5448 @IPAddress VARCHAR(20),
5449 @Auth1 VARCHAR(7),
5450 @Auth2 VARCHAR(7)
5451 AS
5452BEGIN
5453 SET NOCOUNT ON;
5454
5455 IF EXISTS(SELECT 1 FROM [dbo].Pangya_Member WHERE Username = @User COLLATE Latin1_General_CS_AS)
5456 BEGIN
5457 IF EXISTS(SELECT 1 FROM [dbo].Pangya_Member WHERE Username = @User COLLATE Latin1_General_CS_AS AND Password = @Pwd COLLATE Latin1_General_CS_AS)
5458 BEGIN
5459 SELECT 1 AS CODE, UID, Nickname, FirstSet, IDState, Logon FROM [dbo].Pangya_Member WHERE Username = @User COLLATE Latin1_General_CS_AS
5460 -- UPDATE KEY TO USE IN GAME SERVER
5461 UPDATE [dbo].Pangya_Member SET AuthKey_Login = @Auth1, AuthKey_Game = @Auth2, IPAddress = @IPAddress
5462 WHERE Username = @User COLLATE Latin1_General_CS_AS
5463 END ELSE
5464 BEGIN
5465 -- CASE OF PASSWORD ERROR
5466 SELECT CODE = 6;
5467 END
5468 END ELSE
5469 BEGIN
5470 -- CASE OF USERNAME NOT FOUND
5471 SELECT CODE = 5;
5472 END
5473
5474END
5475GO
5476/****** Object: StoredProcedure [dbo].[USP_MESSENGER_1PLAYER_GUILD] Script Date: 19/10/2018 08:23:23 ******/
5477SET ANSI_NULLS ON
5478GO
5479SET QUOTED_IDENTIFIER ON
5480GO
5481CREATE PROCEDURE [dbo].[USP_MESSENGER_1PLAYER_GUILD]
5482 @UID INT,
5483 @GUILDID INT
5484 AS
5485BEGIN
5486 SET NOCOUNT ON;
5487
5488 -- This procedure uses for get only one player information
5489
5490 SELECT A.GUILD_MEMBER_UID,
5491 A.GUILD_ID,
5492 B.Username,
5493 B.Nickname,
5494 C.Game_Level,
5495 B.Logon
5496 FROM (
5497 SELECT GUILD_ID,
5498 GUILD_MEMBER_UID
5499 FROM [DBO].Pangya_Guild_Member
5500 WHERE GUILD_ID = @GUILDID AND
5501 GUILD_MEMBER_UID = @UID AND
5502 GUILD_POSITION IN (1, 2, 3)
5503 ) A
5504 INNER JOIN [DBO].Pangya_Member B ON B.UID = A.GUILD_MEMBER_UID
5505 INNER JOIN [DBO].Pangya_User_Statistics C ON C.UID = A.GUILD_MEMBER_UID
5506END
5507GO
5508/****** Object: StoredProcedure [dbo].[USP_MESSENGER_LOGIN] Script Date: 19/10/2018 08:23:23 ******/
5509SET ANSI_NULLS ON
5510GO
5511SET QUOTED_IDENTIFIER ON
5512GO
5513CREATE PROCEDURE [dbo].[USP_MESSENGER_LOGIN]
5514 @UID INT,
5515 @NICKNAME VARCHAR(50)
5516AS
5517BEGIN
5518 SET NOCOUNT ON;
5519
5520 -- Login
5521 -- Nickname
5522 -- UID
5523 -- GUILD ID
5524
5525 DECLARE @USERNAME VARCHAR(50)
5526 DECLARE @USER_NICKNAME VARCHAR(50)
5527 DECLARE @USER_UID INT
5528 DECLARE @GUILD_ID INT
5529
5530 SELECT @USERNAME = Username,
5531 @USER_NICKNAME = Nickname,
5532 @USER_UID = UID,
5533 @GUILD_ID = GUILDINDEX
5534 FROM [DBO].Pangya_Member
5535 WHERE UID = @UID AND Nickname = @Nickname
5536
5537 IF (@USER_UID > 0)
5538 BEGIN
5539 SELECT Code = 0, @USERNAME AS Username, @USER_NICKNAME AS Nickname, @USER_UID AS UID, @GUILD_ID AS GUILD_ID
5540
5541 /* GET FRIEND LIST */
5542 SELECT TOP 50
5543 B.Nickname,
5544 C.Game_Level,
5545 A.Memo,
5546 B.UID,
5547 A.IsAccept,
5548 B.Sex,
5549 A.IsAgree,
5550 B.Logon,
5551 A.IsBlock,
5552 0 AS Status,
5553 1 AS Position
5554 FROM (
5555 SELECT DISTINCT Friend,
5556 Owner,
5557 IsAccept,
5558 -- GroupName,
5559 IsAgree,
5560 Memo,
5561 ISNULL(IsBlock, 'N') AS IsBlock
5562 FROM [DBO].Pangya_Friend
5563 WHERE Owner = @USERNAME AND
5564 IsDeleted = 0
5565 ) A
5566 INNER JOIN DBO.Pangya_Member B ON B.Username = A.Friend
5567 INNER JOIN DBO.Pangya_User_Statistics C ON C.UID = B.UID
5568 /* END GET FRIEND LIST */
5569
5570 /* GET GUILD PLAYER LIST */
5571 SELECT
5572 B.Nickname,
5573 C.Game_Level,
5574 Memo = '',
5575 A.GUILD_MEMBER_UID AS UID,
5576 IsAccept = 0,
5577 B.Sex,
5578 IsAgree = 0,
5579 B.Logon,
5580 IsBlock = 0,
5581 0 AS Status,
5582 2 AS Position
5583 FROM (
5584 SELECT GUILD_MEMBER_UID
5585 FROM DBO.Pangya_Guild_Member
5586 WHERE GUILD_ID = @GUILD_ID AND
5587 GUILD_POSITION IN (1,2,3)
5588 ) A
5589 INNER JOIN [DBO].Pangya_Member B ON B.UID = A.GUILD_MEMBER_UID
5590 INNER JOIN [DBO].Pangya_User_Statistics C ON C.UID = A.GUILD_MEMBER_UID
5591 /* END */
5592 END ELSE
5593 BEGIN
5594 SELECT Code = 10
5595 END
5596END
5597GO
5598/****** Object: StoredProcedure [dbo].[USP_MESSENGER_PLAYER_GUILD] Script Date: 19/10/2018 08:23:23 ******/
5599SET ANSI_NULLS ON
5600GO
5601SET QUOTED_IDENTIFIER ON
5602GO
5603CREATE PROCEDURE [dbo].[USP_MESSENGER_PLAYER_GUILD]
5604 @UID INT
5605 AS
5606BEGIN
5607 SET NOCOUNT ON;
5608
5609 -- This procedure uses to get information of player except who calls
5610
5611 DECLARE @GUILD_INDEX INT = 0
5612
5613 SELECT @GUILD_INDEX = GUILDINDEX
5614 FROM [DBO].Pangya_Member
5615 WHERE UID = @UID
5616
5617 SELECT @GUILD_INDEX AS GUILD_ID
5618
5619 SELECT A.GUILD_MEMBER_UID,
5620 A.GUILD_ID,
5621 B.Username,
5622 B.Nickname,
5623 C.Game_Level,
5624 B.Logon
5625 FROM (
5626 SELECT GUILD_ID,
5627 GUILD_MEMBER_UID
5628 FROM [DBO].Pangya_Guild_Member
5629 WHERE GUILD_ID = @GUILD_INDEX AND
5630 GUILD_POSITION IN (1,2,3) AND
5631 GUILD_MEMBER_UID != @UID
5632 ) A
5633 INNER JOIN [DBO].Pangya_Member B ON B.UID = A.GUILD_MEMBER_UID
5634 INNER JOIN [DBO].Pangya_User_Statistics C ON C.UID = A.GUILD_MEMBER_UID
5635END
5636GO
5637/****** Object: StoredProcedure [dbo].[USP_NICKNAME_CHECK] Script Date: 19/10/2018 08:23:23 ******/
5638SET ANSI_NULLS ON
5639GO
5640SET QUOTED_IDENTIFIER ON
5641GO
5642-- =============================================
5643-- Author: <Author,,Name>
5644-- Create date: <Create Date,,>
5645-- Description: <Description,,>
5646-- =============================================
5647CREATE PROCEDURE [dbo].[USP_NICKNAME_CHECK]
5648 @NICKNAME VARCHAR(20)
5649AS
5650BEGIN
5651 SET NOCOUNT ON;
5652
5653 DECLARE @REP_NICKNAME VARCHAR(32)
5654 SELECT @REP_NICKNAME = LTRIM(RTRIM(@NICKNAME))
5655
5656 IF EXISTS ( SELECT 1
5657 FROM ( SELECT NICKNAME
5658 FROM DBO.Pangya_Member
5659 WHERE Nickname = @REP_NICKNAME COLLATE Latin1_General_CS_AS) C
5660 ) BEGIN
5661 SELECT Code = 2
5662 END ELSE BEGIN
5663 SELECT Code = 1
5664 END
5665
5666
5667END
5668GO
5669/****** Object: StoredProcedure [dbo].[USP_SAVE_CADDIE] Script Date: 19/10/2018 08:23:23 ******/
5670SET ANSI_NULLS ON
5671GO
5672SET QUOTED_IDENTIFIER ON
5673GO
5674
5675-- =============================================
5676-- Author: TOP
5677-- Create date:
5678-- Description:
5679-- =============================================
5680CREATE PROCEDURE [dbo].[USP_SAVE_CADDIE]
5681 @UID INT,
5682 @ITEMSTR VARCHAR(5000)
5683AS
5684BEGIN
5685 SET NOCOUNT ON;
5686
5687 INSERT INTO DBO.Pangya_String(str) VALUES(@ITEMSTR)
5688
5689 DECLARE @TEMP TABLE (STRING VARCHAR(2000), ID INT IDENTITY(1,1))
5690 DECLARE @sSQL VARCHAR(1000)
5691 DECLARE @sID INT
5692 -- THE ITEM DETAIL
5693 DECLARE @CADDIE_IDX VARCHAR(20)
5694 DECLARE @SKIN_TYPEID VARCHAR(20)
5695 DECLARE @SKIN_DATE_END VARCHAR(20)
5696 DECLARE @CHECK_PAY VARCHAR(20)
5697
5698 -- SPLIT
5699 INSERT INTO @TEMP(STRING) SELECT * FROM STRING_SPLIT(@ITEMSTR, ',') WHERE LEN(VALUE) > 0
5700
5701 -- INSERT IF EXISTS
5702 WHILE EXISTS (SELECT * FROM @TEMP) BEGIN
5703 SELECT TOP 1 @sSQL = REPLACE(STRING, '^', ' ^'), @sID = ID FROM @TEMP
5704 select @sSQL
5705 EXEC XP_SSCANF @sSQL,' ^%s ^%s ^%s ^%s', @CADDIE_IDX OUTPUT , @SKIN_TYPEID OUTPUT, @SKIN_DATE_END OUTPUT, @CHECK_PAY OUTPUT
5706 -- UPDATE ITEM
5707 UPDATE DBO.Pangya_Caddie SET SKIN_TYPEID = @SKIN_TYPEID,
5708 SKIN_END_DATE = @SKIN_DATE_END,
5709 TriggerPay = ISNULL(@CHECK_PAY, 0)
5710 WHERE UID = @UID AND CID = @CADDIE_IDX
5711 SELECT @SKIN_DATE_END
5712 DELETE FROM @TEMP WHERE ID = @sID
5713 END
5714END
5715GO
5716/****** Object: StoredProcedure [dbo].[USP_SAVE_EQUIP] Script Date: 19/10/2018 08:23:23 ******/
5717SET ANSI_NULLS ON
5718GO
5719SET QUOTED_IDENTIFIER ON
5720GO
5721
5722-- =============================================
5723-- Author: TOP
5724-- Create date:
5725-- Description:
5726-- =============================================
5727CREATE PROCEDURE [dbo].[USP_SAVE_EQUIP]
5728 @UID INT,
5729 @EQUIPSTR VARCHAR(5000)
5730AS
5731BEGIN
5732 SET NOCOUNT ON;
5733
5734 DECLARE @TEMP TABLE (STRING VARCHAR(2000), ID INT IDENTITY(1,1))
5735 DECLARE @sSQL VARCHAR(1000)
5736 DECLARE @sID INT
5737 -- UPDATE DETAIL
5738 DECLARE @CHARINDEX VARCHAR(20)
5739
5740 DECLARE @EQUIPTYPEID1 VARCHAR(20)
5741 DECLARE @EQUIPTYPEID2 VARCHAR(20)
5742 DECLARE @EQUIPTYPEID3 VARCHAR(20)
5743 DECLARE @EQUIPTYPEID4 VARCHAR(20)
5744 DECLARE @EQUIPTYPEID5 VARCHAR(20)
5745 DECLARE @EQUIPTYPEID6 VARCHAR(20)
5746 DECLARE @EQUIPTYPEID7 VARCHAR(20)
5747 DECLARE @EQUIPTYPEID8 VARCHAR(20)
5748 DECLARE @EQUIPTYPEID9 VARCHAR(20)
5749 DECLARE @EQUIPTYPEID10 VARCHAR(20)
5750 DECLARE @EQUIPTYPEID11 VARCHAR(20)
5751 DECLARE @EQUIPTYPEID12 VARCHAR(20)
5752 DECLARE @EQUIPTYPEID13 VARCHAR(20)
5753 DECLARE @EQUIPTYPEID14 VARCHAR(20)
5754 DECLARE @EQUIPTYPEID15 VARCHAR(20)
5755 DECLARE @EQUIPTYPEID16 VARCHAR(20)
5756 DECLARE @EQUIPTYPEID17 VARCHAR(20)
5757 DECLARE @EQUIPTYPEID18 VARCHAR(20)
5758 DECLARE @EQUIPTYPEID19 VARCHAR(20)
5759 DECLARE @EQUIPTYPEID20 VARCHAR(20)
5760 DECLARE @EQUIPTYPEID21 VARCHAR(20)
5761 DECLARE @EQUIPTYPEID22 VARCHAR(20)
5762 DECLARE @EQUIPTYPEID23 VARCHAR(20)
5763 DECLARE @EQUIPTYPEID24 VARCHAR(20)
5764
5765 DECLARE @EQUIPINDEX1 VARCHAR(20)
5766 DECLARE @EQUIPINDEX2 VARCHAR(20)
5767 DECLARE @EQUIPINDEX3 VARCHAR(20)
5768 DECLARE @EQUIPINDEX4 VARCHAR(20)
5769 DECLARE @EQUIPINDEX5 VARCHAR(20)
5770 DECLARE @EQUIPINDEX6 VARCHAR(20)
5771 DECLARE @EQUIPINDEX7 VARCHAR(20)
5772 DECLARE @EQUIPINDEX8 VARCHAR(20)
5773 DECLARE @EQUIPINDEX9 VARCHAR(20)
5774 DECLARE @EQUIPINDEX10 VARCHAR(20)
5775 DECLARE @EQUIPINDEX11 VARCHAR(20)
5776 DECLARE @EQUIPINDEX12 VARCHAR(20)
5777 DECLARE @EQUIPINDEX13 VARCHAR(20)
5778 DECLARE @EQUIPINDEX14 VARCHAR(20)
5779 DECLARE @EQUIPINDEX15 VARCHAR(20)
5780 DECLARE @EQUIPINDEX16 VARCHAR(20)
5781 DECLARE @EQUIPINDEX17 VARCHAR(20)
5782 DECLARE @EQUIPINDEX18 VARCHAR(20)
5783 DECLARE @EQUIPINDEX19 VARCHAR(20)
5784 DECLARE @EQUIPINDEX20 VARCHAR(20)
5785 DECLARE @EQUIPINDEX21 VARCHAR(20)
5786 DECLARE @EQUIPINDEX22 VARCHAR(20)
5787 DECLARE @EQUIPINDEX23 VARCHAR(20)
5788 DECLARE @EQUIPINDEX24 VARCHAR(20)
5789
5790 -- SPLIT
5791 INSERT INTO @TEMP(STRING) SELECT * FROM STRING_SPLIT(@EQUIPSTR, ',') WHERE LEN(VALUE) > 0
5792
5793 -- UPDATE
5794 WHILE EXISTS (SELECT * FROM @TEMP) BEGIN
5795 SELECT TOP 1 @sSQL = REPLACE(STRING, '^', ' ^'), @sID = ID FROM @TEMP
5796 EXEC XP_SSCANF @sSQL,' ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s ^%s',
5797 @CHARINDEX OUTPUT ,
5798 @EQUIPTYPEID1 OUTPUT, @EQUIPINDEX1 OUTPUT,
5799 @EQUIPTYPEID2 OUTPUT, @EQUIPINDEX2 OUTPUT,
5800 @EQUIPTYPEID3 OUTPUT, @EQUIPINDEX3 OUTPUT,
5801 @EQUIPTYPEID4 OUTPUT, @EQUIPINDEX4 OUTPUT,
5802 @EQUIPTYPEID5 OUTPUT, @EQUIPINDEX5 OUTPUT,
5803 @EQUIPTYPEID6 OUTPUT, @EQUIPINDEX6 OUTPUT,
5804 @EQUIPTYPEID7 OUTPUT, @EQUIPINDEX7 OUTPUT,
5805 @EQUIPTYPEID8 OUTPUT, @EQUIPINDEX8 OUTPUT,
5806 @EQUIPTYPEID9 OUTPUT, @EQUIPINDEX9 OUTPUT,
5807 @EQUIPTYPEID10 OUTPUT, @EQUIPINDEX10 OUTPUT,
5808 @EQUIPTYPEID11 OUTPUT, @EQUIPINDEX11 OUTPUT,
5809 @EQUIPTYPEID12 OUTPUT, @EQUIPINDEX12 OUTPUT,
5810 @EQUIPTYPEID13 OUTPUT, @EQUIPINDEX13 OUTPUT,
5811 @EQUIPTYPEID14 OUTPUT, @EQUIPINDEX14 OUTPUT,
5812 @EQUIPTYPEID15 OUTPUT, @EQUIPINDEX15 OUTPUT,
5813 @EQUIPTYPEID16 OUTPUT, @EQUIPINDEX16 OUTPUT,
5814 @EQUIPTYPEID17 OUTPUT, @EQUIPINDEX17 OUTPUT,
5815 @EQUIPTYPEID18 OUTPUT, @EQUIPINDEX18 OUTPUT,
5816 @EQUIPTYPEID19 OUTPUT, @EQUIPINDEX19 OUTPUT,
5817 @EQUIPTYPEID20 OUTPUT, @EQUIPINDEX20 OUTPUT,
5818 @EQUIPTYPEID21 OUTPUT, @EQUIPINDEX21 OUTPUT,
5819 @EQUIPTYPEID22 OUTPUT, @EQUIPINDEX22 OUTPUT,
5820 @EQUIPTYPEID23 OUTPUT, @EQUIPINDEX23 OUTPUT,
5821 @EQUIPTYPEID24 OUTPUT, @EQUIPINDEX24 OUTPUT
5822 -- UPDATE ITEM
5823 UPDATE [DBO].Pangya_Character_Equip
5824 SET
5825 -- TYPEID -- PART INDEX
5826 PART_TYPEID_1 = ISNULL(@EQUIPTYPEID1, 0), PART_IDX_1 = ISNULL(@EQUIPINDEX1, 0),
5827 PART_TYPEID_2 = ISNULL(@EQUIPTYPEID2, 0), PART_IDX_2 = ISNULL(@EQUIPINDEX2, 0),
5828 PART_TYPEID_3 = ISNULL(@EQUIPTYPEID3, 0), PART_IDX_3 = ISNULL(@EQUIPINDEX3, 0),
5829 PART_TYPEID_4 = ISNULL(@EQUIPTYPEID4, 0), PART_IDX_4 = ISNULL(@EQUIPINDEX4, 0),
5830 PART_TYPEID_5 = ISNULL(@EQUIPTYPEID5, 0), PART_IDX_5 = ISNULL(@EQUIPINDEX5, 0),
5831 PART_TYPEID_6 = ISNULL(@EQUIPTYPEID6, 0), PART_IDX_6 = ISNULL(@EQUIPINDEX6, 0),
5832 PART_TYPEID_7 = ISNULL(@EQUIPTYPEID7, 0), PART_IDX_7 = ISNULL(@EQUIPINDEX7, 0),
5833 PART_TYPEID_8 = ISNULL(@EQUIPTYPEID8, 0), PART_IDX_8 = ISNULL(@EQUIPINDEX8, 0),
5834 PART_TYPEID_9 = ISNULL(@EQUIPTYPEID9, 0), PART_IDX_9 = ISNULL(@EQUIPINDEX9, 0),
5835 PART_TYPEID_10 = ISNULL(@EQUIPTYPEID10, 0), PART_IDX_10 = ISNULL(@EQUIPINDEX10, 0),
5836 PART_TYPEID_11 = ISNULL(@EQUIPTYPEID11, 0), PART_IDX_11 = ISNULL(@EQUIPINDEX11, 0),
5837 PART_TYPEID_12 = ISNULL(@EQUIPTYPEID12, 0), PART_IDX_12 = ISNULL(@EQUIPINDEX12, 0),
5838 PART_TYPEID_13 = ISNULL(@EQUIPTYPEID13, 0), PART_IDX_13 = ISNULL(@EQUIPINDEX13, 0),
5839 PART_TYPEID_14 = ISNULL(@EQUIPTYPEID14, 0), PART_IDX_14 = ISNULL(@EQUIPINDEX14, 0),
5840 PART_TYPEID_15 = ISNULL(@EQUIPTYPEID15, 0), PART_IDX_15 = ISNULL(@EQUIPINDEX15, 0),
5841 PART_TYPEID_16 = ISNULL(@EQUIPTYPEID16, 0), PART_IDX_16 = ISNULL(@EQUIPINDEX16, 0),
5842 PART_TYPEID_17 = ISNULL(@EQUIPTYPEID17, 0), PART_IDX_17 = ISNULL(@EQUIPINDEX17, 0),
5843 PART_TYPEID_18 = ISNULL(@EQUIPTYPEID18, 0), PART_IDX_18 = ISNULL(@EQUIPINDEX18, 0),
5844 PART_TYPEID_19 = ISNULL(@EQUIPTYPEID19, 0), PART_IDX_19 = ISNULL(@EQUIPINDEX19, 0),
5845 PART_TYPEID_20 = ISNULL(@EQUIPTYPEID20, 0), PART_IDX_20 = ISNULL(@EQUIPINDEX20, 0),
5846 PART_TYPEID_21 = ISNULL(@EQUIPTYPEID21, 0), PART_IDX_21 = ISNULL(@EQUIPINDEX21, 0),
5847 PART_TYPEID_22 = ISNULL(@EQUIPTYPEID22, 0), PART_IDX_22 = ISNULL(@EQUIPINDEX22, 0),
5848 PART_TYPEID_23 = ISNULL(@EQUIPTYPEID23, 0), PART_IDX_23 = ISNULL(@EQUIPINDEX23, 0),
5849 PART_TYPEID_24 = ISNULL(@EQUIPTYPEID24, 0), PART_IDX_24 = ISNULL(@EQUIPINDEX24, 0)
5850 WHERE CHAR_IDX = @CHARINDEX
5851
5852 DELETE FROM @TEMP WHERE ID = @sID
5853 END
5854
5855END
5856GO
5857/****** Object: StoredProcedure [dbo].[USP_SAVE_ITEM] Script Date: 19/10/2018 08:23:23 ******/
5858SET ANSI_NULLS ON
5859GO
5860SET QUOTED_IDENTIFIER ON
5861GO
5862
5863-- =============================================
5864-- Author: TOP
5865-- Create date:
5866-- Description:
5867-- =============================================
5868CREATE PROCEDURE [dbo].[USP_SAVE_ITEM]
5869 @UID INT,
5870 @ITEMSTR VARCHAR(8000)
5871AS
5872BEGIN
5873 SET NOCOUNT ON;
5874
5875 -- INSERT INTO DBO.Pangya_String(str) VALUES(@ITEMSTR)
5876
5877 DECLARE @TEMP TABLE (STRING VARCHAR(5000), ID INT IDENTITY(1,1))
5878 DECLARE @sSQL VARCHAR(2000)
5879 DECLARE @sID INT
5880 -- THE ITEM DETAIL
5881 DECLARE @ITEM_IDX VARCHAR(20)
5882 DECLARE @ITEM_QUANTITY VARCHAR(20)
5883 DECLARE @ITEM_VALID VARCHAR(20)
5884 DECLARE @ISUCC VARCHAR(20)
5885 DECLARE @UCCSTATUS VARCHAR(20)
5886 DECLARE @UCCUNIQUE VARCHAR(20)
5887
5888 -- SPLIT
5889 INSERT INTO @TEMP(STRING) SELECT * FROM STRING_SPLIT(@ITEMSTR, ',') WHERE LEN(VALUE) > 0
5890
5891 BEGIN TRANSACTION
5892 BEGIN TRY
5893 -- INSERT IF EXISTS
5894 WHILE EXISTS (SELECT * FROM @TEMP) BEGIN
5895 SELECT TOP 1 @sSQL = REPLACE(STRING, '^', ' ^'), @sID = ID FROM @TEMP
5896 EXEC XP_SSCANF @sSQL,' ^%s ^%s ^%s ^%s ^%s ^%s',
5897 @ITEM_IDX OUTPUT ,
5898 @ITEM_QUANTITY OUTPUT,
5899 @ITEM_VALID OUTPUT,
5900 @ISUCC OUTPUT,
5901 @UCCSTATUS OUTPUT,
5902 @UCCUNIQUE OUTPUT
5903 -- SELECT @ITEM_IDX,@ITEM_QUANTITY,@ITEM_VALID,@ISUCC,@UCCSTATUS,@UCCUNIQUE
5904 -- UPDATE ITEM
5905 UPDATE DBO.Pangya_Warehouse SET C0 = @ITEM_QUANTITY, VALID = @ITEM_VALID WHERE UID = @UID AND item_id = @ITEM_IDX
5906 IF @ISUCC = 1 BEGIN
5907 UPDATE DBO.Pangya_SelfDesign SET UCC_STATUS = @UCCSTATUS, UCC_UNIQE = @UCCUNIQUE WHERE UID = @UID AND ITEM_ID = @ITEM_IDX
5908 END
5909 DELETE FROM @TEMP WHERE ID = @sID
5910 END
5911 -- COMMIT
5912 COMMIT TRANSACTION
5913 END TRY
5914 BEGIN CATCH
5915 -- ROLLBACK
5916 ROLLBACK TRANSACTION
5917
5918 INSERT INTO [DBO].Pangya_Transaction_Log(UID, String, ERROR_NUMBER, ERROR_SEVERITY, ERROR_STATE, ERROR_PROCEDURE, ERROR_LINE, ERROR_MESSAGE)
5919 SELECT @UID, @ITEMSTR, ERROR_NUMBER(), ERROR_SEVERITY(), ERROR_STATE(), ERROR_PROCEDURE(), ERROR_LINE(), ERROR_MESSAGE()
5920 END CATCH
5921
5922END
5923GO
5924/****** Object: StoredProcedure [dbo].[USP_UCC_REQUEST_UPLOAD] Script Date: 19/10/2018 08:23:23 ******/
5925SET ANSI_NULLS ON
5926GO
5927SET QUOTED_IDENTIFIER ON
5928GO
5929
5930-- =============================================
5931-- Author: TOP
5932-- Create date:
5933-- Description:
5934-- =============================================
5935CREATE PROCEDURE [dbo].[USP_UCC_REQUEST_UPLOAD]
5936 @UID INT
5937 ,@ITEMID INT
5938AS
5939BEGIN
5940 SET NOCOUNT ON;
5941
5942 DECLARE @KEY VARCHAR(50)
5943
5944 IF EXISTS (SELECT 1 FROM [DBO].Pangya_SelfDesign WHERE UID = @UID AND ITEM_ID = @ITEMID AND UCC_STATUS IN (0,2))
5945 BEGIN
5946 SET @KEY = UPPER(LEFT(REPLACE(NEWID(), '-', ''), 20))
5947 UPDATE [DBO].Pangya_SelfDesign SET UCC_KEY = @KEY WHERE UID = @UID AND ITEM_ID = @ITEMID
5948 IF @@ROWCOUNT > 0
5949 BEGIN
5950 SELECT 1 AS CODE, @KEY AS UCCKEY, @ITEMID AS ITEM_ID
5951 END ELSE BEGIN
5952 SELECT 0 AS CODE
5953 END
5954 END ELSE BEGIN
5955 SELECT 0 AS CODE
5956 END
5957END
5958GO
5959/****** Object: StoredProcedure [dbo].[WEB_GUILD_CHECK] Script Date: 19/10/2018 08:23:23 ******/
5960SET ANSI_NULLS ON
5961GO
5962SET QUOTED_IDENTIFIER ON
5963GO
5964-- =============================================
5965-- Author: TOP
5966-- Create date:
5967-- Description:
5968-- =============================================
5969CREATE PROCEDURE [dbo].[WEB_GUILD_CHECK]
5970 @UID INT,
5971 @GUILDID INT,
5972 @EMBLEM_IDX INT,
5973 @EMBLEM VARCHAR(20)
5974AS
5975BEGIN
5976 SET NOCOUNT ON;
5977 -- CODE = 1 SUCCESS
5978 -- CODE = 0 FAIL
5979 IF EXISTS (
5980 SELECT 1
5981 FROM [dbo].Pangya_Guild_Emblem A
5982 INNER JOIN [dbo].Pangya_Guild_Member B ON B.GUILD_ID = A.GUILD_ID AND B.GUILD_MEMBER_UID = @UID AND GUILD_POSITION = 1
5983 WHERE A.GUILD_ID = @GUILDID AND A.EMBLEM_IDX = @EMBLEM_IDX AND A.GUILD_MARK_IMG = @EMBLEM
5984 )
5985 BEGIN
5986 SELECT CODE = 1
5987 END ELSE BEGIN
5988 SELECT CODE = 0
5989 END
5990END
5991GO
5992/****** Object: StoredProcedure [dbo].[WEB_UCC_CHECK] Script Date: 19/10/2018 08:23:23 ******/
5993SET ANSI_NULLS ON
5994GO
5995SET QUOTED_IDENTIFIER ON
5996GO
5997-- =============================================
5998-- Author: TOP
5999-- Create date:
6000-- Description:
6001-- =============================================
6002CREATE PROCEDURE [dbo].[WEB_UCC_CHECK]
6003 @UID INT,
6004 @UCCKEY VARCHAR(20),
6005 @ITEMID INT
6006AS
6007BEGIN
6008 SET NOCOUNT ON;
6009
6010 IF EXISTS (SELECT 1 FROM [dbo].Pangya_SelfDesign WHERE UID = @UID AND ITEM_ID = @ITEMID AND UCC_KEY = @UCCKEY AND LEN(UCC_KEY) >= 20) BEGIN
6011 UPDATE [dbo].Pangya_SelfDesign SET UCC_KEY = 0 WHERE UID = @UID AND ITEM_ID = @ITEMID
6012 SELECT 1 AS Code
6013 END ELSE BEGIN
6014 SELECT 0 AS Code
6015 END
6016END
6017GO
6018EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'90 = Pang
601991 = EXP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Pangya_Mail_Item', @level2type=N'COLUMN',@level2name=N'APPLY_ITEM_ID'
6020GO
6021USE [master]
6022GO
6023ALTER DATABASE [Pangya] SET READ_WRITE
6024GO