- Nov 7, 2007
- 3,811
- 116
- 300
Update: HUM_INFO_UpDate
Engine and DBserver update.
Download Update
Update will stop human magic database from adding new data every login.
Code:
USE [CHERODB]
GO
/****** Object: StoredProcedure [dbo].[HUM_INFO_UpDate] Script Date: 05/14/2014 23:17:30 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[HUM_INFO_UpDate]
@ACCOUNT varchar(15) ,
@NAME varchar(15) ,
@YSMaster varchar(15),
@Hair tinyint ,
@Sex tinyint ,
@Job tinyint ,
@wCurX smallint,
@wCurY smallint,
@nGold int,
@nlevel smallint,
@dir tinyint ,
@wTRJJ smallint ,
@wTRFL tinyint ,
@BinaryData binary(1647)
AS
update D_HUM_INFO set ACCOUNT=@ACCOUNT,Name=@Name,YsMaster=@ysmaster,hair=@hair,sex=@sex,job=@job,Dir=@Dir,wCurX=@wCurx,wCurY=@wCurY,Gold=@nGold,
nlevel=@nLevel,wTRJJ=@wTRJJ,wTRFL=@wTRFL,BinaryData=@BinaryData,UpDateTime=GetDate() where Name=@Name
Delete D_HUM_ITEM where charid=@Name
RETURN(0)Engine and DBserver update.
Download Update
Update will stop human magic database from adding new data every login.
