Warehouse Deposit Zen more than 2kkk

Results 1 to 1 of 1
  1. #1
    Member crew is offline
    MemberRank
    May 2016 Join Date
    94Posts

    note Warehouse Deposit Zen more than 2kkk

    Good day,
    Got some problem with Warehouse. When players put more than 2,000,000,000 Zen its goes negative and lose all Zen. Bit tired of doing Query, maybe its possible to fix this by DB procedures?

    Server Files: TitanTech S6E3 12.00.01

    USE [MuOnline]GO/****** Object: StoredProcedure [dbo].[WHS_UPD_Money] Script Date: 04/26/2018 08:44:41 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER proc [dbo].[WHS_UPD_Money]@mny int,@Accountid varchar(10)asset nocount ondeclare @cknum intSELECT @cknum=ExtCKNum FROM warehouse WHERE AccountID=@accountidif @cknum=0 --主仓库 UPDATE warehouse set Money=@mny where AccountID=@accountidelse UPDATE ExtWareHouse set Money=@mny where AccountID=@accountid AND Number=@cknum--waitfor delay '00:00:10'set nocount off




Advertisement