vSRO Çözüldü Prosedür isteği

USE [MaxiGuard_User]
GO
/****** Object: StoredProcedure [dbo].[_OnSpawnComplete_EDIT] Script Date: 18.04.2021 12:30:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_OnSpawnComplete_EDIT]
@CharID int,
@Charname varchar(25),
@RegionID int,
@WorldID smallint,
@JobType tinyint,
@InParty bit,
@FirstSpawn bit
AS

/*
Bu prosedürü düzenleyerek karakter spawn olduktan sonra herhangi bir işlem yapabilirsiniz.
Bu prosedür, _AddLogChardakinin spawn işlemi tamamen bittikten sonra çağırılır. Bu sebeple pvp moduna almak gibi işlemler için güvenlidir.

@CharID = 222138
@Charname = [GM]Byferoo
@RegionID = 26264
@WorldID = 1
@JobType = 0
>> 0 = Job Modunda değil
>> 1 = Trader Suiti takılı
>> 2 = Thief Suiti takılı
>> 3 = Hunter Suiti takılı
@InParty = 1
@FirstSpawn = 1

Bu veritabanındaki diğer prosedürlerin aksine bu prosedür her restartta orjinal haline döndürülmeyecektir. Dikkatli düzenleyiniz!
*/

/*
You may modify this procedure to do any action you like after character spawns.
This procedure, compared to _AddLogChar, executes after the spawn is fully complete. That means it's safe to use for things like setting free pvp state.

@CharID = CharID of the character which just spawned.
@Charname = Charname of the character which just spawned.
@RegionID = The RegionID of character which just spawned.
@WorldID = The WorldID of which character which just spawned
@JobType = Job Status of the spawned character.
>> 0 = Not Jobbing
>> 1 = Trader Suit Equipped
>> 2 = Thief Suit Equipped
>> 3 = Hunter Suit Equipped
@InParty = Indicates whether the character is in a Party or not.
@FirstSpawn = Indicates whether the character is spawned for the first time after logging in or not.

Unlike other Stored Procedures in this database, this stored procedure will not be restored back to default on restarts. Modify it carefully!
*/


bunu nasıl prosedür yapabilirim