树立金像的方法

在Extra00001.rme中加入以下代码
;角色名称 金像代码 事件号 坐标(X1,Y1,X2,Y2) 移动类型
;菲拉洛 1000
;阿基拉 1001
;撒达得 1002
;邓斯帝诺 1003
;朴真熙 1004
;凯诺 1005
;韩智华 1006
;露娜莉娜 1007
;罗贝塔 1008
角色ID1 1000 0 114 130 114 130 2
角色ID2 1001 0 118 126 118 126 2
角色ID3 1002 0 110 130 110 130 2
角色ID4 1003 0 108 123 108 123 2
角色ID5 1004 0 112 132 112 132 2
角色ID6 1005 0 108 128 108 128 2
角色ID7 1006 0 106 126 106 126 2
角色ID8 1007 0 116 123 116 123 2
角色ID9 1008 0 116 128 116 128 2－－－－－－－－－－－－－－－－－－－－－

新建立的角色的等级为500级！

CREATE TRIGGER TR_INSERTZ_TBLGAMEID1 ON TBLGAMEID1
FOR INSERT
AS
UPDATE TBLGAMEID1 SET Lvl=500 WHERE GAMEID IN (SELECT GAMEID FROM INSERTED)

以上代码是针对新建立玩家的,用查询分析器执行

－－－－－－－－－－－－－－－－－－－－－－－

丹药属性控制

CREATE PROCEDURE RMS_USEMYSTERYPILL
@GameID varchar(14),
@WindowKind int,
@WindowIndex int
AS
set nocount on
declare @RemoveMysteryPillError int, @IncreaseBonusError int, @InsertLogError int,@STotalBonus int
set @RemoveMysteryPillError = 1
set @IncreaseBonusError = 1
set @InsertLogError = 1
begin transaction
select @STotalBonus=STotalBonus from tblGameID1 where GameID = @GameID
if @STotalBonus<15000
delete tblSpecialItem1 where ID in (select top 1 ID from tblSpecialItem1 where ItemKind = 6 AND ItemIndex = 66 AND Position = 1 AND GameID = @GameID AND WindowKind = @WindowKind AND WindowIndex = @WindowIndex)
if @@ROWCOUNT >0 and @@ERROR = 0
begin
set @RemoveMysteryPillError = 0
end
update tblGameID1 set Bonus2 = Bonus2 + 4, STotalBonus = STotalBonus + 4 where GameID = @GameID
set @IncreaseBonusError = @@ERROR
set @STotalBonus = 0
select @STotalBonus = STotalBonus from tblGameID1 where GameID = @GameID
insert tblBonus2Log1 (GameID, STotalBonus, Kind) values (@GameID, @STotalBonus, 4)
set @InsertLogError = @@ERROR
if @RemoveMysteryPillError = 0 AND @IncreaseBonusError = 0 AND @InsertLogError = 0
begin
commit transaction
end
else
begin
rollback transaction
end
GO