[SQL] Tutorial Fix

This query fixes the tutorial.

Quote:

---

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

---

Works like a charm.
Nice release.

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

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

Thanks, im glad i can help!

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

Anyway, great find and thanks :)

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

Quote:

---

Originally Posted by 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

---

thanks very much :thumbup1:

nice job chreadie.
;)

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

Quote:

---

Originally Posted by PHOENIXXXX

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.

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

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

Silly question...how to add this?

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

thx chreadie
works fine !!!

nice job chreadie.
confirm it work. :D