[SQL] Tutorial Fix

[chreadie]

This query fixes the tutorial.

USE [Pangya_S4_TH]
GO
INSERT [dbo].[TA_TUTORIAL_ACC] ([SEQ], [USER_LEVEL], [STEP], [IN_DATE], [USE_YN], [DESC]) VALUES (0, 0, 1, CAST(0x00009D1400000000 AS DateTime), N'Y', N'Quest 0 Step 1')
INSERT [dbo].[TA_TUTORIAL_ACC] ([SEQ], [USER_LEVEL], [STEP], [IN_DATE], [USE_YN], [DESC]) VALUES (1, 0, 2, CAST(0x00009D1400000000 AS DateTime), N'Y', N'Quest 0 Step 2')
INSERT [dbo].[TA_TUTORIAL_ACC] ([SEQ], [USER_LEVEL], [STEP], [IN_DATE], [USE_YN], [DESC]) VALUES (2, 0, 4, CAST(0x00009D1400000000 AS DateTime), N'Y', N'Quest 0 Step 3')
INSERT [dbo].[TA_TUTORIAL_ACC] ([SEQ], [USER_LEVEL], [STEP], [IN_DATE], [USE_YN], [DESC]) VALUES (3, 0, 8, CAST(0x00009D1400000000 AS DateTime), N'Y', N'Quest 0 Step 4')
INSERT [dbo].[TA_TUTORIAL_ACC] ([SEQ], [USER_LEVEL], [STEP], [IN_DATE], [USE_YN], [DESC]) VALUES (4, 0, 16, CAST(0x00009D1400000000 AS DateTime), N'Y', N'Quest 0 Step 5')
INSERT [dbo].[TA_TUTORIAL_ACC] ([SEQ], [USER_LEVEL], [STEP], [IN_DATE], [USE_YN], [DESC]) VALUES (5, 0, 32, CAST(0x00009D1400000000 AS DateTime), N'Y', N'Quest 0 Step 6')
INSERT [dbo].[TA_TUTORIAL_ACC] ([SEQ], [USER_LEVEL], [STEP], [IN_DATE], [USE_YN], [DESC]) VALUES (6, 0, 64, CAST(0x00009D1400000000 AS DateTime), N'Y', N'Quest 0 Step 7')
INSERT [dbo].[TA_TUTORIAL_ACC] ([SEQ], [USER_LEVEL], [STEP], [IN_DATE], [USE_YN], [DESC]) VALUES (7, 0, 128, CAST(0x00009D1400000000 AS DateTime), N'Y', N'Quest 0 Step 8')
INSERT [dbo].[TA_TUTORIAL_ACC] ([SEQ], [USER_LEVEL], [STEP], [IN_DATE], [USE_YN], [DESC]) VALUES (8, 1, 256, CAST(0x00009D1400000000 AS DateTime), N'Y', N'Quest 1 Step 1')
INSERT [dbo].[TA_TUTORIAL_ACC] ([SEQ], [USER_LEVEL], [STEP], [IN_DATE], [USE_YN], [DESC]) VALUES (9, 1, 512, CAST(0x00009D1400000000 AS DateTime), N'Y', N'Quest 1 Step 2')
INSERT [dbo].[TA_TUTORIAL_ACC] ([SEQ], [USER_LEVEL], [STEP], [IN_DATE], [USE_YN], [DESC]) VALUES (10, 1, 1024, CAST(0x00009D1400000000 AS DateTime), N'Y', N'Quest 1 Step 3')
INSERT [dbo].[TA_TUTORIAL_ACC] ([SEQ], [USER_LEVEL], [STEP], [IN_DATE], [USE_YN], [DESC]) VALUES (11, 1, 2048, CAST(0x00009D1400000000 AS DateTime), N'Y', N'Quest 1 Step 4')
INSERT [dbo].[TA_TUTORIAL_ACC] ([SEQ], [USER_LEVEL], [STEP], [IN_DATE], [USE_YN], [DESC]) VALUES (12, 1, 4096, CAST(0x00009D1400000000 AS DateTime), N'Y', N'Quest 1 Step 5')
INSERT [dbo].[TA_TUTORIAL_ACC] ([SEQ], [USER_LEVEL], [STEP], [IN_DATE], [USE_YN], [DESC]) VALUES (13, 1, 8192, CAST(0x00009D1400000000 AS DateTime), N'Y', N'Quest 1 Step 6')

[MentaL]

[X_Sarah_X]

Works like a charm.
Nice release.

[malcomtidus]

chreadie, you pull through for the Ragezone Pangya forum once more!

Thank you very much for the fix, tutorial works completely! :)

[chreadie]

Thanks, im glad i can help!

[hvdaedalus]

Your work on this makes me think you don't have a real life chreadie :)

Anyway, great find and thanks :)

[chreadie]

Hehe, well during the days i work with similar tasks and when i get home i take care of my son. After that im usually exploring the database :)
Posted via Mobile Device

[o800920]

Hehe, well during the days i work with similar tasks and when i get home i take care of my son. After that im usually exploring the database :)
Posted via Mobile Device

thanks very much

[swdl]

nice job chreadie.
;)

[PHOENIXXXX]

thx chreadie
works fine but they are some gifts you cannot transfert to your inventory
strengh boost
miracle sign
lucky star
tranquilizer

[chreadie]

thx chreadie
works fine but they are some gifts you cannot transfert to your inventory
strengh boost
miracle sign
lucky star
tranquilizer

As said in the USP_MAIL_SEND thread, you need to fill TA_PARTS_GRP_LIMIT with values. As for the Pang Pocket im working on a fix for it.

[PHOENIXXXX]

Thx
btw, do you know what are the other groups and which id they get ?

[chreadie]

search the forum (or look in Pangya Development) on how to get the item group

[hikkifan17]

Silly question...how to add this?

[chreadie]

copy whats in the quote and paste in sql query analyzer then choose "Execute"

[langtucamtieu]

thx chreadie
works fine !!!