Adding Crimson Ring To Data Base

[Acardia]

Can anyone tell me how i can add the crimson ring to my data base so i can use give item to get it also on the sets.iff is it possible to put a whole set on the shop by hexing that file...

[MentaL]

[Tsukasa]

You can easily add the Crimson Ring with the following query:

Spoiler:

USE [Pangya_S4_TH]
GO

IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879113856 )
BEGIN
   UPDATE PANGYA_ITEM_TYPELIST
   SET NAME = N'Crimson Ring'
   , ICON = N''
   , PRICE = 1000
   , ISCASH = 0
   WHERE TYPEID = 1879113856
END
ELSE
BEGIN
   INSERT INTO PANGYA_ITEM_TYPELIST
   ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH] )
   VALUES ( 1879113856, N'Crimson Ring', N'', 1000, 0 )
END

GO

As for the clubsets: If they are already defined in the IFF file, all you need to do is change their shop properties (and set the item to active if it isn't). You can get the necessary offsets from chreadie's IFF thread in development.

Edit: Oopsie, edited the query to add the missing name value.

[shadowsfx]

since im interested in this too i tried it but it didn't work. i got this error from sms:

Msg 109, Level 15, State 1, Line 13
There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.

after that i added the item manually to the account and it worked.

[bubbastic]

You got this error because the 'name' value is missing in the INSERT command. Just add it to the previous query like this :

INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH] )
VALUES ( 1879113856, N'Crimson Ring', N'', 1000, 0 )


Then you won't get the error again o.O

Next time just look XD : 5 columns and 4 values and read carefully the error messages that say that the numbers of colums and values don't match XD

[AznSW]

Do you happen to have the item ID for Hybrid ring too? :) thanks

[Tsukasa]

You can use chreadie's FileXplorer to look up the ID yourself.

[boomboom]

Spoiler:

   INSERT INTO PANGYA_ITEM_TYPELIST
   ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH] )
   VALUES ( 1879113739, N'Mystic Ring', N'', 1000, 0 )
   VALUES ( 1879113744, N'Hybrid Ring', N'', 1000, 0 )
   VALUES ( 1879113745, N'Promise Ring', N'', 1000, 0 )
   VALUES ( 1879113856, N'Crimson Ring', N'', 1000, 0 )
   VALUES ( 1879113858, N'Ultimate Ring', N'', 1000, 0 )