المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : كل سنه وانتو طيبين

nset
17-07-2015, 11:23 PM
https://upload.wikimedia.org/wikipedia/ar/c/c6/%D8%A8%D8%B3%D9%85_%D8%A7%D9%84%D9%84%D9%87_%D8%A7 %D9%84%D8%B1%D8%AD%D9%85%D9%86_%D8%A7%D9%84%D8%B1% D8%AD%D9%8A%D9%85.png

http://www2.0zz0.com/2012/10/22/16/593531309.png


السلام عليكم ورحمة الله وبركاتو
وكل سنه وانتم طيبين
يا جماعه دى اول مشاركه ليه انا الحمد لله عملت سيرفر بفضل الله والشروحات اللى فى المنتدى واى مشكله كنت بقبلها كنت بلاقيلها حل على المنتدى هنا ^_^ والله وى اول مره اشارك فيها انا اخدت خبره كبيره من كتر ما انا قرية فى المنتدى مشاكل وحلول الاعضاء
بس فى حاجه معايه دلوقتى انا بنذل بزيرك لونو ازرق من غيرما اعمل المهمه انا عاوز ينزل بزيرك احمر واللى يعمل المهمه بتاعت الزيرك يبقا ازرق
http://www5.0zz0.com/2015/07/17/23/434234192.jpg
وحاجا تانى بينزل بتيتل جنب الاسم وهو لسه لفل 1 انا عاوزو ينزل من غير تيتل خالص من فين دى
وشكرا ^_^
Spicoo
18-07-2015, 02:45 AM
بالنسبه للي بينزل بتتل نيم
Sro_VT_SHARD>>Programability>>>AddNewCher
>>>HwanLevel شوف رقم التيتل الي بتنزل بيه الشخصيه كام وخليه 0
nset
18-07-2015, 03:01 AM
اولا شكرا على ردك ثانين ممكن صوره للتوضيح معلش انا ضورت فى الSHARD كولها ومش لاقى
hwanlevel
معلش لو هتقل عليك
Dev. iLegend
18-07-2015, 09:47 AM
بص يا باشا هات كدا Procedure أسمه dbo._AddNewChar هتلاقيه فى SHARD > Programmability > Stored Procedures
إضغط عليه كليك يمين واختار Modify وانسخ كل اللى هيظهرلك وحطه هنا فى php code وانا اظبطهولك إنشاء الله ،،
nset
18-07-2015, 06:20 PM
اهو

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 18/07/2015 04:18:00 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
　
　
　
ALTER PROCEDURE [dbo].[_AddNewChar]
@UserJID INT,
--@CharSlot INT,
@RefCharID INT,
@CharName varchar (64),
@CharScale tinyINT,
@StartRegionID INT,
@StartPos_X real,
@StartPos_Y real,
@StartPos_Z real,
@DefaultTeleport INT,
@RefMailID INT,
@RefPantsID INT,
@RefBootsID INT,
@RefWeaponID INT,
@RefShield INT,
@DurMail tinyINT,
@DurPants tinyINT,
@DurBoots tinyINT,
@DurWeapon tinyINT,
@DurShield tinyINT,
@DefaultArrow INT
AS

SET NOCOUNT ON
DECLARE @Slot INT
DECLARE @temp INT

DECLARE @NewCharID INT
SET @NewCharID = 0


-----------------------------------------------------------------------------
-- 1. ij¸¯ÅÍ ½½·Ô ³Ñ¹ö°¡ validÇÑ °ÍÀÎÁö, ±×¸®°í ºó½½·ÔÀÌ ¸Â´ÂÁö ¸ÕÀú üũÇÑ´Ù.
-----------------------------------------------------------------------------

-- start by novice.
SELECT @temp = count(CharID) FROM _User WITH (NOLOCK) WHERE UserJID = @UserJID

IF (@temp >= 4)
BEGIN
-- ³Ê¹« ¸¹ÀÚ³ª
RETURN -2
END
-- finish by novice.

-----------------------------------------------------------------------------
-- 2. ij¸¯ÅÍ Ãß°¡Çϱâ
-----------------------------------------------------------------------------
IF (@CharScale > 68) -- 0100 0100 --> 68 ÀÌ´Ù!
BEGIN
-- ij¸¯ÅÍ »ý¼º ½ÇÆÐ! ½ºÄÉÀÏ °ªÀÌ ÀÌ»óÇÏ´Ù!
RETURN -3
END

EXEC @temp = _IsExistingCharName @CharName
IF (@temp <> 0)
BEGIN
-- &Agrave;&Igrave;¹&Igrave; »ç&iquest;ë&Aacute;&szlig;&Agrave;&Icirc; &Agrave;&Igrave;¸§&Agrave;&Igrave;¶&oacute;´&Acirc;µ¥?
RETURN -4
END

BEGIN TRANSACTION

-- &Agrave;&Icirc;´&oslash;½&Atilde;½&ordm;&Aring;&Ucirc;&Agrave;&Igrave; &Agrave;û&iquest;ëµ&Ccedil;¸é¼­ ¸¶&Aacute;&ouml;¸·&iquest;&iexcl; WorldID&iquest;&Iacute; 1°&ordf;&Agrave;» ´&otilde; ³&Ouml;¾î &Aacute;&Ouml;¾&uacute;´&Ugrave;!
INSERT INTO _Char (RefObjID, CharName16, Scale, Strength, Intellect, LatestRegion,PosX, PosY, PosZ, AppointedTeleport, InventorySize,
LastLogout, CurLevel, MaxLevel, RemainGold, RemainStatPoint, RemainSkillPoint, HP, MP, JobLvl_Trader, JobLvl_Hunter, JobLvl_Robber, WorldID)
VALUES (@RefCharID, @CharName, @CharScale, 20, 20, @StartRegionID, @StartPos_X, @StartPos_Y, @StartPos_Z, @DefaultTeleport, 45,
GetDate(), 1, 1, 0, 0, 0, 200,200, 1, 1, 1, 1)

SET @NewCharID = @@IDENTITY
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
-- &Auml;³¸¯&Aring;&Iacute; »&yacute;¼&ordm; ½&Ccedil;&AElig;&ETH;!
ROLLBACK TRANSACTION
RETURN -5
END


-- start by novice.
-- &Agrave;&Igrave;&Aacute;¦ Slot ¾&Egrave;¾´´&Ugrave;.. ±×³&Eacute; Insert ¸¸..
INSERT INTO _User VALUES (@UserJID, @NewCharID)
-- finish by novice.


-----------------------------------------------------------------------------
-- 3-1. &Agrave;&aring;&ordm;&ntilde; ½½·&Ocirc; &Atilde;¤&iquest;&igrave;±â
-- [&Agrave;&Icirc;&ordm;¥&Aring;&auml;¸® ½½·&Ocirc; 96°³] + [&Agrave;&aring;&ordm;&ntilde;½½·&Ocirc; 13°³] <- &Agrave;&Icirc;&ordm;¥&Aring;&auml;¸® &Egrave;®&Agrave;&aring; ¼­&ordm;&ntilde;½&ordm; &Egrave;&Auml; 48°³&iquest;&iexcl;¼­ 96°³·&Icirc; &Aacute;&otilde;°&iexcl;!!!(woos0)
-----------------------------------------------------------------------------
--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!
INSERT INTO _Inventory(CharID, Slot, ItemID)
SELECT @NewCharID, cnt, 0
FROM _RefDummySlot with( nolock )
WHERE cnt < 109

IF (@@ERROR <> 0)
BEGIN
-- &Agrave;&Icirc;&ordm;¥&Aring;&auml;¸® »&yacute;¼&ordm; ½&Ccedil;&AElig;&ETH;!
ROLLBACK TRANSACTION
RETURN -7
END
--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!

-- µ&eth;&AElig;&uacute;&AElig;®·&Icirc; ¼±&Aring;&Atilde;&Ccedil;&Ntilde; ¾&AElig;&Agrave;&Igrave;&Aring;&Ucirc;&Agrave;» ´&Ugrave;½&Atilde; ³&Ouml;¾î&Aacute;&Ouml;&Agrave;&Uacute;...
/* &iquest;&auml;·± ¼&oslash;¼­·&Icirc; &Aacute;¤&Agrave;&Ccedil;µ&Ccedil;¾î &Agrave;&Ouml;´&Ugrave;.
0: EQUIP_SLOT_HELM
1: EQUIP_SLOT_MAIL,
2: EQUIP_SLOT_SHOULDERGUARD,
3: EQUIP_SLOT_GAUNTLET,
4: EQUIP_SLOT_PANTS,
5: EQUIP_SLOT_BOOTS,
6: EQUIP_SLOT_WEAPON,
7: EQUIP_SLOT_SHIELD or ARROW,
8: EQUIP_SLOT_EARRING,
9: EQUIP_SLOT_NECKLACE,
10: EQUIP_SLOT_L_RING,
11: EQUIP_SLOT_R_RING,
*/

DECLARE @ItemID BIGINT
SET @ItemID = 0
-- »&oacute;°©
IF (@RefMailID <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 1, @RefMailID, @DurMail
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -8
END
END
-- ¹&Ugrave;&Aacute;&ouml;
IF (@RefPantsID <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 4, @RefPantsID, @DurPants
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -9
END
END
-- Boots
IF (@RefBootsID <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 5, @RefBootsID, @DurBoots
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -10
END
END
-- Weapon
IF (@RefWeaponID <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 6, @RefWeaponID, @DurWeapon
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -11
END
END
-- ¹&aelig;&AElig;&ETH;
IF (@RefShield <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 7, @RefShield, @DurShield
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -12
END
END
-- &Egrave;¤½&Atilde; default·&Icirc; ¼±&Aring;&Atilde;&Ccedil;&Ntilde; ¹«±â°&iexcl; &Egrave;°&Agrave;&Igrave;¶&oacute;¸é &Egrave;­»&igrave; 250°³µé&Agrave;&Igrave; &Egrave;°&Aring;ëµµ &Ccedil;&Ocirc;²² &Aacute;&Oslash;´&Ugrave;. &Aacute;&Ograve;&Auml;&iexcl;?
IF (@DefaultArrow <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 7, @DefaultArrow, 250
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -13
END
END
　
-----------------------------------------------------------------------------
-- 3-2. ¾&AElig;¹&Ugrave;&Aring;¸ Inventory ½½·&Ocirc; &Atilde;¤&iquest;&igrave;±â
-- [¾&AElig;¹&Ugrave;&Aring;¸ &Agrave;&Icirc;&ordm;¥&Aring;&auml;¸® ½½·&Ocirc; 5°³]
-- APPLY_AVATAR_SYSTEM&Agrave;&Igrave; &Agrave;û&iquest;ëµ&Ccedil;¸é¼­ &Atilde;&szlig;°&iexcl;µ&Ccedil;´&Acirc; &ordm;&Icirc;&ordm;&ETH;
-----------------------------------------------------------------------------
--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!
INSERT INTO _InventoryForAvatar(CharID, Slot, ItemID)
SELECT @NewCharID, cnt, 0
FROM _RefDummySlot with( nolock )
WHERE cnt < 5

IF (@@ERROR <> 0)
BEGIN
-- ¾&AElig;¹&Ugrave;&Aring;¸ &Agrave;&Icirc;&ordm;¥&Aring;&auml;¸® »&yacute;¼&ordm; ½&Ccedil;&AElig;&ETH;!
ROLLBACK TRANSACTION
RETURN -14
END
--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!

-----------------------------------------------------------------------------
-- default skill³&Ouml;¾î&Aacute;&Ouml;±â
-----------------------------------------------------------------------------
DECLARE @country tinyINT
EXEC @country = _GetObjCountry @RefCharID

INSERT INTO _CharSkillMastery (CharID, MasteryID, Level)
SELECT @NewCharID, MasteryID, 0
FROM _RefCharDefault_SkillMastery with(nolock)
WHERE Race = @country or Race = 3
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -15
END
INSERT INTO _CharSkill (CharID,SkillID,Enable)
SELECT @NewCharID, SkillID, 1
FROM _RefCharDefault_Skill with(nolock)
WHERE Race = @country or Race = 3
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -16
END
-----------------------------------------------------------------------------
-- ±â&ordm;» &Auml;ù½&ordm;&AElig;® ³&Ouml;¾î&Aacute;&Ouml;±â
-----------------------------------------------------------------------------
INSERT INTO _CharQuest (CharID, QuestID, Status, AchievementCount, StartTime, EndTime, QuestData1, QuestData2)
SELECT @NewCharID, ID, 1, 0, getdate(), getdate(), 0, 0
FROM _RefQuest
WHERE CodeName in (SELECT CodeName FROM _RefCharDefault_Quest with(nolock) WHERE (Race = @country or Race = 3) and RequiredLevel = 1 and Service = 1)
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -17
END
-----------------------------------------------------------------------------
-- Static Avatar Initial Record ³&Ouml;±â
-----------------------------------------------------------------------------
INSERT INTO _StaticAvatar(CharID) values(@NewCharID)
IF (@@ERROR <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -18
END

-----------------------------------------------------------------------------
-- Trijob &Atilde;¤&iquest;&ouml;³&Ouml;±â!!!!!
-----------------------------------------------------------------------------
INSERT INTO _CharTrijob VALUES (@NewCharID, 0, 1, 0, 0, 0)
IF (@@ERROR <> 0)
BEGIN
-- &Agrave;&Icirc;&ordm;¥&Aring;&auml;¸® »&yacute;¼&ordm; ½&Ccedil;&AElig;&ETH;!
ROLLBACK TRANSACTION
RETURN -19
END

-----------------------------------------------------------------------------
-- CharList&iquest;&iexcl; ID ³&Ouml;¾î&Aacute;&Ouml;±â
-----------------------------------------------------------------------------
INSERT _CharNameList VALUES(@CharName, @NewCharID)

exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E060118_60EXP_HELP',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E060118_100EXP_HELP',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_HP_SUPERSET_5_BAG',1000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_MP_SUPERSET_5_BAG',1000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_SCROLL_RETURN_NEWBIE_01',20,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_REVERSE_RETURN_SCROLL',50,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E090930_HIT_SUPER_SCROLL',10,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E090930_EVATION_SUPER_SCROLL', 10,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E090930_SPEED_UP_SUPER_SCROLL' ,10,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_SILSAMO_M',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_SILSAMO_F',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_NASRUN',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_NASRUN',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_E081126_SILKROAD_PLAG_M',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_E081126_SILKROAD_PLAG_W',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_PET2_SCROLL_ENC_CAT_A',1,1

-- Quick Slot &Aacute;¤&ordm;¸ &Agrave;&uacute;&Agrave;&aring;&iquest;ë!!!
exec _AddNewClientConfig @NewCharID -- by novice...... for saving client configurations...
COMMIT TRANSACTION

RETURN @NewCharID
nset
19-07-2015, 10:54 PM
ايه يا رجالا
sobhe_wizard
20-07-2015, 02:53 PM
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 18/07/2015 04:18:00 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
　
　
　
ALTER PROCEDURE [dbo].[_AddNewChar]
@UserJID INT,
--@CharSlot INT,
@RefCharID INT,
@CharName varchar (64),
@CharScale tinyINT,
@StartRegionID INT,
@StartPos_X real,
@StartPos_Y real,
@StartPos_Z real,
@DefaultTeleport INT,
@RefMailID INT,
@RefPantsID INT,
@RefBootsID INT,
@RefWeaponID INT,
@RefShield INT,
@DurMail tinyINT,
@DurPants tinyINT,
@DurBoots tinyINT,
@DurWeapon tinyINT,
@DurShield tinyINT,
@DefaultArrow INT
AS

SET NOCOUNT ON
DECLARE @Slot INT
DECLARE @temp INT

DECLARE @NewCharID INT
SET @NewCharID = 0


-----------------------------------------------------------------------------
-- 1. &Auml;³¸¯&Aring;&Iacute; ½½·&Ocirc; ³&Ntilde;¹&ouml;°&iexcl; valid&Ccedil;&Ntilde; °&Iacute;&Agrave;&Icirc;&Aacute;&ouml;, ±×¸®°&iacute; &ordm;&oacute;½½·&Ocirc;&Agrave;&Igrave; ¸&Acirc;´&Acirc;&Aacute;&ouml; ¸&Otilde;&Agrave;&uacute; &Atilde;¼&Aring;©&Ccedil;&Ntilde;´&Ugrave;.
-----------------------------------------------------------------------------

-- start by novice.
SELECT @temp = count(CharID) FROM _User WITH (NOLOCK) WHERE UserJID = @UserJID

IF (@temp >= 4)
BEGIN
-- ³&Ecirc;¹« ¸¹&Agrave;&Uacute;³&ordf;
RETURN -2
END
-- finish by novice.

-----------------------------------------------------------------------------
-- 2. &Auml;³¸¯&Aring;&Iacute; &Atilde;&szlig;°&iexcl;&Ccedil;&Iuml;±â
-----------------------------------------------------------------------------
IF (@CharScale > 68) -- 0100 0100 --> 68 &Agrave;&Igrave;´&Ugrave;!
BEGIN
-- &Auml;³¸¯&Aring;&Iacute; »&yacute;¼&ordm; ½&Ccedil;&AElig;&ETH;! ½&ordm;&Auml;&Eacute;&Agrave;&Iuml; °&ordf;&Agrave;&Igrave; &Agrave;&Igrave;»&oacute;&Ccedil;&Iuml;´&Ugrave;!
RETURN -3
END

EXEC @temp = _IsExistingCharName @CharName
IF (@temp <> 0)
BEGIN
-- &Agrave;&Igrave;¹&Igrave; »ç&iquest;ë&Aacute;&szlig;&Agrave;&Icirc; &Agrave;&Igrave;¸§&Agrave;&Igrave;¶&oacute;´&Acirc;µ¥?
RETURN -4
END

BEGIN TRANSACTION

-- &Agrave;&Icirc;´&oslash;½&Atilde;½&ordm;&Aring;&Ucirc;&Agrave;&Igrave; &Agrave;û&iquest;ëµ&Ccedil;¸é¼­ ¸¶&Aacute;&ouml;¸·&iquest;&iexcl; WorldID&iquest;&Iacute; 1°&ordf;&Agrave;» ´&otilde; ³&Ouml;¾î &Aacute;&Ouml;¾&uacute;´&Ugrave;!
INSERT INTO _Char (RefObjID, CharName16, Scale, Strength, Intellect, LatestRegion,PosX, PosY, PosZ, AppointedTeleport, InventorySize,
LastLogout, CurLevel, MaxLevel, RemainGold, RemainStatPoint, RemainSkillPoint, HP, MP, JobLvl_Trader, JobLvl_Hunter, JobLvl_Robber, WorldID)
VALUES (@RefCharID, @CharName, @CharScale, 20, 20, @StartRegionID, @StartPos_X, @StartPos_Y, @StartPos_Z, @DefaultTeleport, 45,
GetDate(), 1, 1, 0, 0, 0, 200,200, 1, 1, 1, 0)

SET @NewCharID = @@IDENTITY
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
-- &Auml;³¸¯&Aring;&Iacute; »&yacute;¼&ordm; ½&Ccedil;&AElig;&ETH;!
ROLLBACK TRANSACTION
RETURN -5
END


-- start by novice.
-- &Agrave;&Igrave;&Aacute;¦ Slot ¾&Egrave;¾´´&Ugrave;.. ±×³&Eacute; Insert ¸¸..
INSERT INTO _User VALUES (@UserJID, @NewCharID)
-- finish by novice.


-----------------------------------------------------------------------------
-- 3-1. &Agrave;&aring;&ordm;&ntilde; ½½·&Ocirc; &Atilde;¤&iquest;&igrave;±â
-- [&Agrave;&Icirc;&ordm;¥&Aring;&auml;¸® ½½·&Ocirc; 96°³] + [&Agrave;&aring;&ordm;&ntilde;½½·&Ocirc; 13°³] <- &Agrave;&Icirc;&ordm;¥&Aring;&auml;¸® &Egrave;®&Agrave;&aring; ¼­&ordm;&ntilde;½&ordm; &Egrave;&Auml; 48°³&iquest;&iexcl;¼­ 96°³·&Icirc; &Aacute;&otilde;°&iexcl;!!!(woos0)
-----------------------------------------------------------------------------
--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!
INSERT INTO _Inventory(CharID, Slot, ItemID)
SELECT @NewCharID, cnt, 0
FROM _RefDummySlot with( nolock )
WHERE cnt < 109

IF (@@ERROR <> 0)
BEGIN
-- &Agrave;&Icirc;&ordm;¥&Aring;&auml;¸® »&yacute;¼&ordm; ½&Ccedil;&AElig;&ETH;!
ROLLBACK TRANSACTION
RETURN -7
END
--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!

-- µ&eth;&AElig;&uacute;&AElig;®·&Icirc; ¼±&Aring;&Atilde;&Ccedil;&Ntilde; ¾&AElig;&Agrave;&Igrave;&Aring;&Ucirc;&Agrave;» ´&Ugrave;½&Atilde; ³&Ouml;¾î&Aacute;&Ouml;&Agrave;&Uacute;...
/* &iquest;&auml;·± ¼&oslash;¼­·&Icirc; &Aacute;¤&Agrave;&Ccedil;µ&Ccedil;¾î &Agrave;&Ouml;´&Ugrave;.
0: EQUIP_SLOT_HELM
1: EQUIP_SLOT_MAIL,
2: EQUIP_SLOT_SHOULDERGUARD,
3: EQUIP_SLOT_GAUNTLET,
4: EQUIP_SLOT_PANTS,
5: EQUIP_SLOT_BOOTS,
6: EQUIP_SLOT_WEAPON,
7: EQUIP_SLOT_SHIELD or ARROW,
8: EQUIP_SLOT_EARRING,
9: EQUIP_SLOT_NECKLACE,
10: EQUIP_SLOT_L_RING,
11: EQUIP_SLOT_R_RING,
*/

DECLARE @ItemID BIGINT
SET @ItemID = 0
-- »&oacute;°©
IF (@RefMailID <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 1, @RefMailID, @DurMail
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -8
END
END
-- ¹&Ugrave;&Aacute;&ouml;
IF (@RefPantsID <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 4, @RefPantsID, @DurPants
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -9
END
END
-- Boots
IF (@RefBootsID <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 5, @RefBootsID, @DurBoots
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -10
END
END
-- Weapon
IF (@RefWeaponID <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 6, @RefWeaponID, @DurWeapon
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -11
END
END
-- ¹&aelig;&AElig;&ETH;
IF (@RefShield <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 7, @RefShield, @DurShield
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -12
END
END
-- &Egrave;¤½&Atilde; default·&Icirc; ¼±&Aring;&Atilde;&Ccedil;&Ntilde; ¹«±â°&iexcl; &Egrave;°&Agrave;&Igrave;¶&oacute;¸é &Egrave;­»&igrave; 250°³µé&Agrave;&Igrave; &Egrave;°&Aring;ëµµ &Ccedil;&Ocirc;²² &Aacute;&Oslash;´&Ugrave;. &Aacute;&Ograve;&Auml;&iexcl;?
IF (@DefaultArrow <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 7, @DefaultArrow, 250
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -13
END
END
　
-----------------------------------------------------------------------------
-- 3-2. ¾&AElig;¹&Ugrave;&Aring;¸ Inventory ½½·&Ocirc; &Atilde;¤&iquest;&igrave;±â
-- [¾&AElig;¹&Ugrave;&Aring;¸ &Agrave;&Icirc;&ordm;¥&Aring;&auml;¸® ½½·&Ocirc; 5°³]
-- APPLY_AVATAR_SYSTEM&Agrave;&Igrave; &Agrave;û&iquest;ëµ&Ccedil;¸é¼­ &Atilde;&szlig;°&iexcl;µ&Ccedil;´&Acirc; &ordm;&Icirc;&ordm;&ETH;
-----------------------------------------------------------------------------
--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!
INSERT INTO _InventoryForAvatar(CharID, Slot, ItemID)
SELECT @NewCharID, cnt, 0
FROM _RefDummySlot with( nolock )
WHERE cnt < 5

IF (@@ERROR <> 0)
BEGIN
-- ¾&AElig;¹&Ugrave;&Aring;¸ &Agrave;&Icirc;&ordm;¥&Aring;&auml;¸® »&yacute;¼&ordm; ½&Ccedil;&AElig;&ETH;!
ROLLBACK TRANSACTION
RETURN -14
END
--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!

-----------------------------------------------------------------------------
-- default skill³&Ouml;¾î&Aacute;&Ouml;±â
-----------------------------------------------------------------------------
DECLARE @country tinyINT
EXEC @country = _GetObjCountry @RefCharID

INSERT INTO _CharSkillMastery (CharID, MasteryID, Level)
SELECT @NewCharID, MasteryID, 0
FROM _RefCharDefault_SkillMastery with(nolock)
WHERE Race = @country or Race = 3
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -15
END
INSERT INTO _CharSkill (CharID,SkillID,Enable)
SELECT @NewCharID, SkillID, 1
FROM _RefCharDefault_Skill with(nolock)
WHERE Race = @country or Race = 3
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -16
END
-----------------------------------------------------------------------------
-- ±â&ordm;» &Auml;ù½&ordm;&AElig;® ³&Ouml;¾î&Aacute;&Ouml;±â
-----------------------------------------------------------------------------
INSERT INTO _CharQuest (CharID, QuestID, Status, AchievementCount, StartTime, EndTime, QuestData1, QuestData2)
SELECT @NewCharID, ID, 1, 0, getdate(), getdate(), 0, 0
FROM _RefQuest
WHERE CodeName in (SELECT CodeName FROM _RefCharDefault_Quest with(nolock) WHERE (Race = @country or Race = 3) and RequiredLevel = 1 and Service = 1)
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -17
END
-----------------------------------------------------------------------------
-- Static Avatar Initial Record ³&Ouml;±â
-----------------------------------------------------------------------------
INSERT INTO _StaticAvatar(CharID) values(@NewCharID)
IF (@@ERROR <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -18
END

-----------------------------------------------------------------------------
-- Trijob &Atilde;¤&iquest;&ouml;³&Ouml;±â!!!!!
-----------------------------------------------------------------------------
INSERT INTO _CharTrijob VALUES (@NewCharID, 0, 1, 0, 0, 0)
IF (@@ERROR <> 0)
BEGIN
-- &Agrave;&Icirc;&ordm;¥&Aring;&auml;¸® »&yacute;¼&ordm; ½&Ccedil;&AElig;&ETH;!
ROLLBACK TRANSACTION
RETURN -19
END

-----------------------------------------------------------------------------
-- CharList&iquest;&iexcl; ID ³&Ouml;¾î&Aacute;&Ouml;±â
-----------------------------------------------------------------------------
INSERT _CharNameList VALUES(@CharName, @NewCharID)

exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E060118_60EXP_HELP',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E060118_100EXP_HELP',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_HP_SUPERSET_5_BAG',1000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_MP_SUPERSET_5_BAG',1000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_SCROLL_RETURN_NEWBIE_01',20,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_REVERSE_RETURN_SCROLL',50,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E090930_HIT_SUPER_SCROLL',10,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E090930_EVATION_SUPER_SCROLL', 10,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E090930_SPEED_UP_SUPER_SCROLL' ,10,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_SILSAMO_M',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_SILSAMO_F',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_NASRUN',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_NASRUN',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_E081126_SILKROAD_PLAG_M',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_E081126_SILKROAD_PLAG_W',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_PET2_SCROLL_ENC_CAT_A',1,1

-- Quick Slot &Aacute;¤&ordm;¸ &Agrave;&uacute;&Agrave;&aring;&iquest;ë!!!
exec _AddNewClientConfig @NewCharID -- by novice...... for saving client configurations...
COMMIT TRANSACTION

RETURN @NewCharID
اتفضل