ارجو المساعده

[Hell_Boy]

انا حطيت ال TITLE وكل حاجه تمام بس في حاجه لم اضربه ميش بتعمل جاجه
https://postimg.org/image/goxzpkjwr/

[.Gamer.]

ياباشا منا قولتلك عدل علي ال procedure برقم ال title اللي انت عاوزه ! افتح textuisystem وشوف رقم ال title كام وحطه في ال procedure
او هاتلي ال textuisystem.txt بتاعتك وهات ال procedure وانا هشغلهالك !!:mfr_bl4::phone2:

[Hell_Boy]

داه _AddLogItem
IF (@Operation = 41) and (@ItemRefID = 41800)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 1 Where [CharID] = @CharID
End

IF (@Operation = 41) and (@ItemRefID = 41801)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 2 Where [CharID] = @CharID
End

IF (@Operation = 41) and (@ItemRefID = 41802)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 3 Where [CharID] = @CharID
End

IF (@Operation = 41) and (@ItemRefID = 41803)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 4 Where [CharID] = @CharID
End

IF (@Operation = 41) and (@ItemRefID = 41804)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 5 Where [CharID] = @CharID
End

IF (@Operation = 41) and (@ItemRefID = 41805)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 6 Where [CharID] = @CharID
End

IF (@Operation = 41) and (@ItemRefID = 41806)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 7 Where [CharID] = @CharID
End

IF (@Operation = 41) and (@ItemRefID = 41807)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 8 Where [CharID] = @CharID
End

IF (@Operation = 41) and (@ItemRefID = 41808)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 9 Where [CharID] = @CharID
End

IF (@Operation = 41) and (@ItemRefID = 41809)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 10 Where [CharID] = @CharID
End

IF (@Operation = 41) and (@ItemRefID = 41810)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 11 Where [CharID] = @CharID
End

IF (@Operation = 41) and (@ItemRefID = 41811)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 12 Where [CharID] = @CharID
End

IF (@Operation = 41) and (@ItemRefID = 41812)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 13 Where [CharID] = @CharID
End

IF (@Operation = 41) and (@ItemRefID = 41813)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 14 Where [CharID] = @CharID
End

IF (@Operation = 41) and (@ItemRefID = 41814)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 15 Where [CharID] = @CharID
End

وداه textuisystem.txt

UIO_SECOND_HWAN_CH_NAME_LEVEL_1 ??? 0 0 0 0 0 Captain Captain 0 0 0 0 0 0
1 UIO_SECOND_HWAN_CH_NAME_LEVEL_2 ???? 0 0 0 0 0 General General 0 0 0 0 0 0
1 UIO_SECOND_HWAN_CH_NAME_LEVEL_3 ???? 0 0 0 0 0 Senior General Senior General 0 0 0 0 0 0
1 UIO_SECOND_HWAN_CH_NAME_LEVEL_4 ???? 0 0 0 0 0 Chief General Chief General 0 0 0 0 0 0
1 UIO_SECOND_HWAN_CH_NAME_LEVEL_5 ???? 0 0 0 0 0 Vice General Lord Vice General Lord 0 0 0 0 0 0
1 UIO_SECOND_HWAN_CH_NAME_LEVEL_6 ???? 0 0 0 0 0 General Lord General Lord 0 0 0 0 0 0
1 UIO_SECOND_HWAN_CH_NAME_LEVEL_7 ???? 0 0 0 0 0 Albanian Albanian 0 0 0 0 0 0
1 UIO_SECOND_HWAN_CH_NAME_LEVEL_8 ???? 0 0 0 0 0 Algerian Algerian 0 0 0 0 0 0
1 UIO_SECOND_HWAN_CH_NAME_LEVEL_9 ???? 0 0 0 0 0 Bulgarian Bulgarian 0 0 0 0 0 0
1 UIO_SECOND_HWAN_CH_NAME_LEVEL_10 ???? 0 0 0 0 0 Greek Greek 0 0 0 0 0 0
1 UIO_SECOND_HWAN_CH_NAME_LEVEL_11 ???? 0 0 0 0 0 Italian Italian 0 0 0 0 0 0
1 UIO_SECOND_HWAN_CH_NAME_LEVEL_12 ???? 0 0 0 0 0 Serbian Serbian 0 0 0 0 0 0
1 UIO_SECOND_HWAN_CH_NAME_LEVEL_13 ???? 0 0 0 0 0 Croatian Croatian 0 0 0 0 0 0
1 UIO_SECOND_HWAN_CH_NAME_LEVEL_14 ???? 0 0 0 0 0 French French 0 0 0 0 0 0
1 UIO_SECOND_HWAN_CH_NAME_LEVEL_15 ???? 0 0 0 0 0 Portuguese Portuguese 0 0 0 0 0

[.Gamer.]

هاتلي كدا itemdata_45000.txt و Textdata_Object معلش:salut:

[Hell_Boy]

1 41800 ITEM_TITLE_01 ?? ??? xxx SN_ITEM_TITLE_01 SN_SN_ITEM_TITLE_01_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 15000 0 0 0 150 4500 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_scroll.bsr item\etc\scroll_return_03.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0
1 41801 ITEM_TITLE_02 ?? ??? xxx SN_ITEM_TITLE_02 SN_SN_ITEM_TITLE_02_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 15000 0 0 0 150 4500 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_scroll.bsr item\etc\scroll_return_03.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0
1 41802 ITEM_TITLE_03 ?? ??? xxx SN_ITEM_TITLE_03 SN_SN_ITEM_TITLE_03_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 15000 0 0 0 150 4500 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_scroll.bsr item\etc\scroll_return_03.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0
1 41803 ITEM_TITLE_04 ?? ??? xxx SN_ITEM_TITLE_04 SN_SN_ITEM_TITLE_04_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 15000 0 0 0 150 4500 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_scroll.bsr item\etc\scroll_return_03.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0
1 41804 ITEM_TITLE_05 ?? ??? xxx SN_ITEM_TITLE_05 SN_SN_ITEM_TITLE_05_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 15000 0 0 0 150 4500 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_scroll.bsr item\etc\scroll_return_03.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0
1 41805 ITEM_TITLE_06 ?? ??? xxx SN_ITEM_TITLE_06 SN_SN_ITEM_TITLE_06_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 15000 0 0 0 150 4500 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_scroll.bsr item\etc\scroll_return_03.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0
1 41806 ITEM_TITLE_07 ?? ??? xxx SN_ITEM_TITLE_07 SN_SN_ITEM_TITLE_07_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 15000 0 0 0 150 4500 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_scroll.bsr item\etc\scroll_return_03.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0
1 41807 ITEM_TITLE_08 ?? ??? xxx SN_ITEM_TITLE_08 SN_SN_ITEM_TITLE_08_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 15000 0 0 0 150 4500 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_scroll.bsr item\etc\scroll_return_03.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0
1 41808 ITEM_TITLE_09 ?? ??? xxx SN_ITEM_TITLE_09 SN_SN_ITEM_TITLE_09_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 15000 0 0 0 150 4500 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_scroll.bsr item\etc\scroll_return_03.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0
1 41809 ITEM_TITLE_10 ?? ??? xxx SN_ITEM_TITLE_10 SN_SN_ITEM_TITLE_10_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 15000 0 0 0 150 4500 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_scroll.bsr item\etc\scroll_return_03.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0
1 41810 ITEM_TITLE_11 ?? ??? xxx SN_ITEM_TITLE_11 SN_SN_ITEM_TITLE_11_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 15000 0 0 0 150 4500 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_scroll.bsr item\etc\scroll_return_03.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0
1 41811 ITEM_TITLE_12 ?? ??? xxx SN_ITEM_TITLE_12 SN_SN_ITEM_TITLE_12_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 15000 0 0 0 150 4500 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_scroll.bsr item\etc\scroll_return_03.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0
1 41812 ITEM_TITLE_13 ?? ??? xxx SN_ITEM_TITLE_13 SN_SN_ITEM_TITLE_13_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 15000 0 0 0 150 4500 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_scroll.bsr item\etc\scroll_return_03.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0
1 41813 ITEM_TITLE_14 ?? ??? xxx SN_ITEM_TITLE_14 SN_SN_ITEM_TITLE_14_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 15000 0 0 0 150 4500 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_scroll.bsr item\etc\scroll_return_03.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0
1 41814 ITEM_TITLE_15 ?? ??? xxx SN_ITEM_TITLE_15 SN_SN_ITEM_TITLE_15_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 15000 0 0 0 150 4500 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_scroll.bsr item\etc\scroll_return_03.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0


1 SN_ITEM_TITLE_01 Albanian
1 SN_ITEM_TITLE_02 Algerian
1 SN_ITEM_TITLE_03 Bulgarian
1 SN_ITEM_TITLE_04 Greek
1 SN_ITEM_TITLE_05 Italian
1 SN_ITEM_TITLE_06 Serbian
1 SN_ITEM_TITLE_07 Croatian
1 SN_ITEM_TITLE_08 French
1 SN_ITEM_TITLE_09 Portuguese
1 SN_ITEM_TITLE_10 Spanish
1 SN_ITEM_TITLE_11 Hungarian
1 SN_ITEM_TITLE_12 Austrian
1 SN_ITEM_TITLE_13 Romanian
1 SN_ITEM_TITLE_14 Ukrainian
1 SN_ITEM_TITLE_15 Slovakian

[.Gamer.]

كدا كله تمام عندك
الحل : ان زي ماقولتلك في الموضوع التاني ( شوف في الداتا بيز dbo._refhwanleveldata
وفي الميديا Hwanleveldata.txt
واعمل اخرهم 50 مثلا واعمل import للملف تاني .. وجرب:puke:

[.Gamer.]

شوف الفيديو ده وانت هتفهم ازاي تضيفها : [YOUTUBE HD]EmQYkQr0sHU[/YOUTUBE HD]

[Hell_Boy]

انا اشتغلت ب ال فيدو داه

[.Gamer.]

طب اشتغل ال title ولا ايه؟:badair:

[Hell_Boy]

طب اشتغل ال title ولا ايه؟:badair:

لا مشتغلش بس شكل المشكل من _AddLogItem

[Hell_Boy]

شكرا تم الحل

[Scrox]

##