本帖最后由 chencjh 于 2009-6-24 19:49 编辑
- -- Use CREATE PROCEDURE instead of ALTER PROCEDURE if you don't already have this procedure
- ALTER PROCEDURE [dbo].[UPDATE_WAREHOUSE_PW]
- @strAccountID varchar(21),
- @strWarehousePw varchar(20),
- @Money int,
- @dwTime int,
- @strWarehouseData varchar(1600),
- @strSerial varchar(1600)
- AS
- BEGIN
- UPDATE WAREHOUSE SET strWarehousePw = @strWarehousePw, dwTime = @dwTime, nMoney = @Money, WareHouseData = @strWarehouseData, strSerial = @strSerial WHERE strAccountID = @strAccountID
- END
- ALTER PROCEDURE [dbo].[UPDATE_WAREHOUSE]
- @accountid varchar(21),
- @Money int,
- @dwTime int,
- @strItem varchar(1600),
- @strSerial varchar(1600)
- AS
- UPDATE WAREHOUSE
- Set
- nMoney = @Money,
- dwTime = @dwTime,
- WarehouseData = @strItem,
- strSerial = @strSerial
- WHERE strAccountID = @accountid
- ALTER PROCEDURE [dbo].[UPDATE_USER_DATA]
- @id varchar(21),
- @Nation tinyint,
- @Race tinyint,
- @Class smallint,
- @HairColor tinyint,
- @Rank tinyint,
- @Title tinyint,
- @Level tinyint,
- @Exp int,
- @Loyalty int,
- @Face tinyint,
- @City tinyint,
- @Knights smallint,
- @Fame tinyint,
- @Hp smallint,
- @Mp smallint,
- @Sp smallint,
- @Str tinyint,
- @Sta tinyint,
- @Dex tinyint,
- @Intel tinyint,
- @Cha tinyint,
- @Authority tinyint,
- @Points tinyint,
- @Gold int,
- @Zone tinyint,
- @Bind smallint,
- @PX int,
- @PZ int,
- @PY int,
- @dwTime int,
- @QuestTotal smallint,
- @strSkill varchar(20),
- @strItem varchar(400),
- @strSerial varchar(400),
- @strQuest varchar(400),
- @MannerPoint int,
- @LoyaltyMonthly int
- AS
- DECLARE @KnightsIndex smallint
- IF @Zone > 2 -- battle zone user
- BEGIN
- SELECT @KnightsIndex=Knights FROM USERDATA WHERE strUserId=@id
- IF @KnightsIndex = -1 -- expel user
- BEGIN
- SET @Knights = 0
- SET @Fame = 0
- END
- END
- UPDATE USERDATA
- Set
- Nation = @Nation,
- Race = @Race,
- Class = @Class,
- HairColor = @HairColor,
- Rank = @Rank,
- Title = @Title,
- [Level] = @Level,
- [Exp] = @Exp,
- Loyalty = @Loyalty,
- Face = @Face,
- City = @City,
- Knights = @Knights,
- Fame = @Fame,
- Hp = @Hp,
- Mp = @Mp,
- Sp = @Sp,
- Strong = @Str,
- Sta = @Sta,
- Dex = @Dex,
- Intel = @Intel,
- Cha = @Cha,
- Authority = @Authority,
- Points = @Points,
- Gold = @Gold,
- [Zone] = @Zone,
- Bind = @Bind,
- PX = @PX,
- PZ = @PZ,
- PY = @PY,
- dwTime = @dwTime,
- strSkill = @strSkill,
- strItem = @strItem,
- strSerial = @strSerial, -- 2002 11. 12
- sQuestCount = @QuestTotal, -- 2003.04.09
- strQuest = @strQuest, -- 2003.04.09
- MannerPoint = @MannerPoint, -- 2004.01.30
- LoyaltyMonthly = @LoyaltyMonthly, -- 2004.04.22
- UpdateTime = getdate()
- WHERE strUserId = @id
复制代码 |