[Question] Gold Rollback

[yetb0]

guys what is the limit of gold?
if my gold reach to 9b it will rollback to 3b

[MentaL]

[I'm Not MentaL]

Do you put any Trigger to your database? If yes, then disable it.

[yetb0]

i dont have any trigger in my DB sir qiangqiang101

[I'm Not MentaL]

Are you sure only Gold rollback?? Level, Item, Map no rollback?

[yetb0]

yes sir qiangqiang101 only the gold
i dont have any problem except for the gold rollback

[Jolin88]

gold going to 3b is a trigger, search for it, inside the chainfo table, you'll see, even if you didn't install it yourself

[NaMiSwAn]

i think, you are using backup data base..go to RanGame1 -> Table -> dbo. chainfo -> triggers, then delete the files in trigger.

[yetb0]

yeah there's a 2 trigger alright
i delete the gold trigger now its working fine

there's another thing
what is the use of this trigger

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[TRI_ChaInfo_1] ON [dbo].[ChaInfo]
FOR INSERT
AS
INSERT INTO ChaNameInfo( ChaNum, ChaName ) Select ChaNum, ChaName From INSERTED

[NaMiSwAn]

No Use..just delete it.