Problem when create new char in same ID

06/01/2018 15:31 iAmAndrew#1

Hey guys, i have a little problem, when some of my players have 1 char on 1 ID, and they have like 900 silks, if they creat another char, on game they lose all silks, but only in game, cuz if they Login on the website the silks still there

Any idea?

06/01/2018 19:49 #HB#2

Check out _AddNewChar, maybe it contains something like:

Code:

UPDATE SK_Silk set silk_own...etc

if you found a line like this, delete it.

06/01/2018 20:49 iAmAndrew#3

Quote:
Originally Posted by #HB
Check out _AddNewChar, maybe it contains something like:
Code:
UPDATE SK_Silk set silk_own...etc
if you found a line like this, delete it.

i dint find it, this is my _AddNewChar

Spoiler

06/01/2018 20:59 NagySandor96#4

the line below makes your silk balance to zero everytime you create a new char - if im right. try to delete, it may help you.

Code:

INSERT INTO SRO_VT_ACCOUNT.dbo.SK_Silk (JID, silk_own, silk_gift, silk_point) VALUES [MENTION=292919]user[/MENTION]JID, 0, 0, 0);

06/01/2018 21:31 iAmAndrew#5

Quote:
Originally Posted by NagySandor96
the line below makes your silk balance to zero everytime you create a new char - if im right. try to delete, it may help you.
Code:
INSERT INTO SRO_VT_ACCOUNT.dbo.SK_Silk (JID, silk_own, silk_gift, silk_point) VALUES [MENTION=292919]user[/MENTION]JID, 0, 0, 0);

oh ok, i will try to delect and test Thanks !

06/02/2018 00:21 #HB#6

Code:

INSERT INTO SRO_VT_ACCOUNT.dbo.SK_Silk (JID, silk_own, silk_gift, silk_point) VALUES [MENTION=292919]user[/MENTION]JID, 0, 0, 0);

this line will cause a lot of bugs and maybe its related to your problem

06/02/2018 00:44 iAmAndrew#7

Quote:
Originally Posted by #HB
Code:
INSERT INTO SRO_VT_ACCOUNT.dbo.SK_Silk (JID, silk_own, silk_gift, silk_point) VALUES [MENTION=292919]user[/MENTION]JID, 0, 0, 0);
this line will cause a lot of bugs and maybe its related to your problem

thanks mate, i will delect that line and test today! apreciat that