[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')

 

[X_Sarah_X]

Re: [Release] Tutorial fix

Works like a charm.
Nice release.

 

[malcomtidus]

Re: [Release] Tutorial fix

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

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

 

[chreadie]

Re: [Release] Tutorial fix

Thanks, im glad i can help!

 

[hvdaedalus]

Re: [Release] Tutorial fix

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

Anyway, great find and thanks

 

[chreadie]

Re: [Release] Tutorial fix

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

 

[o800920]

Re: [Release] Tutorial fix

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

thanks very much

 

[swdl]

Re: [Release] Tutorial fix

nice job chreadie.

 

[PHOENIXXXX]

Re: [Release] Tutorial fix

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

 

[chreadie]

Re: [Release] Tutorial fix

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]

Re: [Release] Tutorial fix

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

 

[chreadie]

Re: [Release] Tutorial fix

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

 

[hikkifan17]

Re: [Release] Tutorial fix

Silly question...how to add this?

 

[chreadie]

Re: [Release] Tutorial fix

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

 

[langtucamtieu]

thx chreadie
works fine !!!

 

[jonehua]

nice job chreadie.
confirm it work.