[HIDE]
[/HIDE]
SQL:
---------------------------------------------------------------------------------------------------------[Log_Teleport] Kguardedge en altına ekle bu prosedürü 25580 yazanlar örnek regiondur kendinize göre belirlersiniz.
if (@TargetRegionID = 25580 and @CurrentRegionID != 25580) -- To Chaos Arena
begin
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @CharName,'ITEM_SILKROADPVP_HAMMER',1,0 -- Give Chaos Hammer
insert into KGuardEDGE.._DeveloperCommands (Cmd,Data1,Data2,Data3) values ('private_sendturkishnote',@CharName,'Envanterinde gönderilen Chaos Hammeri Kullanarak rakiplerine meydan oku. Hızlı olan kazanır!','#10F280')
insert into KGuardEDGE.._DeveloperCommands (Cmd,Data1,Data2,Data3) values ('private_sendenglishnote',@CharName,'Challenge your opponents using the Chaos Hammer sent in your inventory. The fastest one wins!','#10F280')
end
else
update SRO_VT_SHARD.._Inventory set ItemID=0 where ItemID in ( select inv.ItemID from SRO_VT_SHARD.._Inventory inv inner join SRO_VT_SHARD.._Items it on inv.ItemID=it.ID64
where it.RefItemID in(select ID from SRO_VT_SHARD.._RefObjCommon where CodeName128 like 'ITEM_SILKROADPVP_HAMMER') and inv.CharID=@CharID)
Kod:
------------------------------------------------------------------------------------------------------------addlogchar a at
if @EventID in(5) ---kguardedge eventınızın eventid sini yazın 5 yazan yere
Begin
update SRO_VT_SHARD.._Inventory set ItemID=0 where ItemID in ( select inv.ItemID from SRO_VT_SHARD.._Inventory inv inner join SRO_VT_SHARD.._Items it on inv.ItemID=it.ID64
where it.RefItemID in(select ID from SRO_VT_SHARD.._RefObjCommon where CodeName128 like 'ITEM_SILKROADPVP_HAMMER') and inv.CharID=@CharID)
End
