help my server silk problem

05/13/2018 08:26 Elite Sro-#1

hello everyone
i have a problem in my server
when I give someone silk he takes it
but if he creat ane character silk is disappear
this the only problem with me can anyone help and this is the first post

05/13/2018 22:35 NorseGodTyr#2

check silk table is not double line btw ID
if you have double line check in SRO_VT_SHARD on Procedure AddNewChar
some ppl adding for fun or so some line also if you create a new char that added again in silk table the ID

05/13/2018 23:57 Elite Sro-#3

i will upload to you a photo of silk tape
[Only registered and activated users can see links. Click Here To Register...]

05/14/2018 00:22 ahmed metwali#4

i have the same problem

05/14/2018 02:00 White Ros3#5

Frist Of All Make Clean Database , Or Delete Duplicated Lines In SK_Silk
Then Put This At _AddNewChar Blow Start Items

Code:

 IF Not Exists (Select * From SRO_VT_ACCOUNT.dbo.SK_Silk Where JID =    [MENTION=292919]user[/MENTION]JID)
Begin
INSERT INTO SRO_VT_ACCOUNT.dbo.SK_Silk (JID, silk_own, silk_gift, silk_point) VALUES     [MENTION=292919]user[/MENTION]JID, 0, 0, 0);
End

Notice : Edit " MENTION=292919user[/MENTION]JID" To @[Only registered and activated users can see links. Click Here To Register...]JID"

05/14/2018 11:36 ahmed metwali#6

thanxs i will try