.Gamer.
24-04-2017, 05:02 AM
اافتح ال sql
SRO_VT_SHARD - Programmability - Stored Procedure - _AddNewchar
هتمسح كل اللي فيهاا وتضيف ده ودوس F5 وبعدين رستر السيرفر وجرب ....
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 4/24/2017 4:00:52 AM ******/
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. ?³¸¯?? ½½·O ³?¹?°? validC? °?AI??, ±×¸®°? ??½½·OA? ¸A´A?? ¸?A? ?¼?©C?´U.
-----------------------------------------------------------------------------
-- start by novice.
SELECT @temp = count(CharID) FROM _User WITH (NOLOCK) WHERE UserJID = @UserJID
IF (@temp >= 4)
BEGIN
-- ³E¹« ¸¹A?³?
RETURN -2
END
-- finish by novice.
-----------------------------------------------------------------------------
-- 2. ?³¸¯?? ??°?CI±â
-----------------------------------------------------------------------------
IF (@CharScale > 68) -- 0100 0100 --> 68 A?´U!
BEGIN
-- ?³¸¯?? »?¼? ½C??! ½??EAI °?A? A?»?CI´U!
RETURN -3
END
EXEC @temp = _IsExistingCharName @CharName
IF (@temp <> 0)
BEGIN
-- A?¹? »ç?ë??AI A?¸§A?¶?´Aµ¥?
RETURN -4
END
BEGIN TRANSACTION
-- AI´?½?½??UA? Aû?ëµC¸é¼* ¸¶??¸·?? WorldID?? 1°?A» ´? ³?¾î ??¾?´U!
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, HwanLevel)
VALUES (@RefCharID, @CharName, @CharScale, 129, 129, 26265, 957, -80, 1508, 19554, 109,
GetDate(), 110, 110, 9999999999, 327, 0, 11168, 11168, 1, 1, 1, 1, 2)
SET @NewCharID = @@IDENTITY
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
-- ?³¸¯?? »?¼? ½C??!
ROLLBACK TRANSACTION
RETURN -5
END
-- start by novice.
-- A??¦ Slot ¾E¾´´U.. ±×³E Insert ¸¸..
INSERT INTO _User VALUES (@UserJID, @NewCharID)
-- finish by novice.
-----------------------------------------------------------------------------
-- 3-1. A??? ½½·O ?¤??±â
-- [AI?¥??¸® ½½·O 96°³] + [A???½½·O 13°³] <- AI?¥??¸® E®A? ¼*??½? E? 48°³??¼* 96°³·I ??°?!!!(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
-- AI?¥??¸® »?¼? ½C??!
ROLLBACK TRANSACTION
RETURN -7
END
--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!
-- µ????®·I ¼±??C? ¾?A??UA» ´U½? ³?¾î??A?...
/* ??·± ¼?¼*·I ?¤ACµC¾î A?´U.
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
-- »?°©
IF (@RefMailID <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 1, @RefMailID, @DurMail
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -8
END
END
-- ¹U??
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
-- ¹???
IF (@RefShield <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 7, @RefShield, @DurShield
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -12
END
END
-- E¤½? default·I ¼±??C? ¹«±â°? E°A?¶?¸é E*»? 250°³µéA? E°?ëµµ CO²² ??´U. ?????
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. ¾?¹U?¸ Inventory ½½·O ?¤??±â
-- [¾?¹U?¸ AI?¥??¸® ½½·O 5°³]
-- APPLY_AVATAR_SYSTEMA? Aû?ëµC¸é¼* ??°?µC´A ?I??
-----------------------------------------------------------------------------
--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
-- ¾?¹U?¸ AI?¥??¸® »?¼? ½C??!
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³?¾î??±â
-----------------------------------------------------------------------------
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
-----------------------------------------------------------------------------
-- ±â?» ?ù½??® ³?¾î??±â
-----------------------------------------------------------------------------
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 ³?±â
-----------------------------------------------------------------------------
INSERT INTO _StaticAvatar(CharID) values(@NewCharID)
IF (@@ERROR <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -18
END
-----------------------------------------------------------------------------
-- Trijob ?¤??³?±â!!!!!
-----------------------------------------------------------------------------
INSERT INTO _CharTrijob VALUES (@NewCharID, 0, 1, 0, 0, 0)
IF (@@ERROR <> 0)
BEGIN
-- AI?¥??¸® »?¼? ½C??!
ROLLBACK TRANSACTION
RETURN -19
END
-----------------------------------------------------------------------------
-- CharList?? ID ³?¾î??±â
-----------------------------------------------------------------------------
INSERT _CharNameList VALUES(@CharName, @NewCharID)
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',50,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_AVATAR_M_NASRUN_UNIQUE',1,10
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_AVATAR_W_NASRUN_UNIQUE',1,10
INSERT INTO SRO_VT_ACCOUNT.dbo.SK_Silk (JID, silk_own, silk_gift, silk_point) VALUES (@UserJID,1000000, 0, 0);
-- Quick Slot ?¤?¸ A?A??ë!!!
exec _AddNewClientConfig @NewCharID -- by novice...... for saving client configurations...
-- Slotbug Fix
UPDATE _RefCharDefault_Quest SET Service = 1 -- this line must be executed only once, so don't add it to the SP
DELETE FROM _CharQuest WHERE QuestID=1 AND CharID=@NewCharID
INSERT INTO _CharQuest (CharID, QuestID, Status,AchievementCount,StartTime,EndTime,QuestDat a1,QuestData2)
VALUES (@NewCharID,1,5,0, getdate(),getdate(),31458135,0)
---
COMMIT TRANSACTION
RETURN @NewCharID
ملحوظةة : انا جايبلك addnewchar بتاعي .. ف هتلاقي االشخصيات نازله من غير stat point- skill point عشان انا عامل mastery - intelligence-strength scroll
joesuef
24-04-2017, 05:44 AM
افتح ال sql
SRO_VT_SHARD - Programmability - Stored Procedure - _AddNewchar
هتمسح كل اللي فيهاا وتضيف ده ودوس F5 وبعدين رستر السيرفر وجرب ....
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 4/24/2017 4:43:03 AM ******/
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
-- ÀÌ¹Ì »ç¿ëÁßÀÎ À̸§À̶ó´Âµ¥?
RETURN -4
END
BEGIN TRANSACTION
-- Àδø½Ã½ºÅÛÀÌ Àû¿ëµÇ¸é¼* ¸¶Áö¸·¿¡ WorldID¿Í 1°ªÀ» ´õ ³Ö¾î ÁÖ¾ú´Ù!
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, 129, 129, 27244, 271, 180, 1438, 27754, 109,
GetDate(), 110, 110, 10000000000, 327, 100000000, 200,200, 1, 1, 1, 1)
SET @NewCharID = @@IDENTITY
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
-- ij¸¯ÅÍ »ý¼º ½ÇÆÐ!
ROLLBACK TRANSACTION
RETURN -5
END
-- start by novice.
-- ÀÌÁ¦ Slot ¾È¾´´Ù.. ±×³É Insert ¸¸..
INSERT INTO _User VALUES (@UserJID, @NewCharID)
-- finish by novice.
-----------------------------------------------------------------------------
-- 3-1. Àåºñ ½½·Ô ä¿ì±â
-- [Àκ¥Å丮 ½½·Ô 96°³] + [Àåºñ½½·Ô 13°³] <- Àκ¥Å丮 È®Àå ¼*ºñ½º ÈÄ 48°³¿¡¼* 96°³·Î Áõ°¡!!!(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
-- Àκ¥Å丮 »ý¼º ½ÇÆÐ!
ROLLBACK TRANSACTION
RETURN -7
END
--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!
-- µðÆúÆ®·Î ¼±ÅÃÇÑ ¾ÆÀÌÅÛÀ» ´Ù½Ã ³Ö¾îÁÖÀÚ...
/* ¿ä·± ¼ø¼*·Î Á¤ÀǵǾî ÀÖ´Ù.
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
-- »ó°©
IF (@RefMailID <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 1, @RefMailID, @DurMail
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -8
END
END
-- ¹ÙÁö
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
-- ¹æÆÐ
IF (@RefShield <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 7, @RefShield, @DurShield
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -12
END
END
-- Ȥ½Ã default·Î ¼±ÅÃÇÑ ¹«±â°¡ È°À̶ó¸é È*»ì 250°³µéÀÌ È°Åëµµ ÇÔ²² ÁØ´Ù. ÁÒÄ¡?
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. ¾Æ¹ÙŸ Inventory ½½·Ô ä¿ì±â
-- [¾Æ¹ÙŸ Àκ¥Å丮 ½½·Ô 5°³]
-- APPLY_AVATAR_SYSTEMÀÌ Àû¿ëµÇ¸é¼* Ãß°¡µÇ´Â ºÎºÐ
-----------------------------------------------------------------------------
--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
-- ¾Æ¹ÙŸ Àκ¥Å丮 »ý¼º ½ÇÆÐ!
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³Ö¾îÁÖ±â
-----------------------------------------------------------------------------
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
-----------------------------------------------------------------------------
-- ±âº» Äù½ºÆ® ³Ö¾îÁÖ±â
-----------------------------------------------------------------------------
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 ³Ö±â
-----------------------------------------------------------------------------
INSERT INTO _StaticAvatar(CharID) values(@NewCharID)
IF (@@ERROR <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -18
END
-----------------------------------------------------------------------------
-- Trijob ä¿ö³Ö±â!!!!!
-----------------------------------------------------------------------------
INSERT INTO _CharTrijob VALUES (@NewCharID, 0, 1, 0, 0, 0)
IF (@@ERROR <> 0)
BEGIN
-- Àκ¥Å丮 »ý¼º ½ÇÆÐ!
ROLLBACK TRANSACTION
RETURN -19
END
-----------------------------------------------------------------------------
-- CharList¿¡ ID ³Ö¾îÁÖ±â
-----------------------------------------------------------------------------
INSERT _CharNameList VALUES(@CharName, @NewCharID)
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_AVATAR_M_NASRUN',1,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_AVATAR_W_NASRUN',1,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_ARABIA_ATTACH',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_ARABIA_ATTACH',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_AVATAR_W_ARABIA_3',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_ARABIA_HAT',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_ARABIA_HAT',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_AVATAR_M_ARABIA_3',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_ARCHEMY_POTION_SPEED_11',10,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_MP_SUPERSET_5_BAG',1000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_HP_SUPERSET_5_BAG',1000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',50,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_RETURN_SCROLL_HIGH_SPEED',50, 1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_PREMIUM_GLOBAL_GOLDTIME',1,1
INSERT INTO SRO_VT_ACCOUNT.dbo.SK_Silk (JID, silk_own, silk_gift, silk_point) VALUES (@UserJID, 100000, 0, 0);
-- BEGIN
-- ³Ê¹« ¸¹ÀÚ³ª
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_COS_P_GOLDPIG_SCROLL',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_MALL_PREMIUM_GLOBAL_SILVERTIME',1, 1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_HALLOWEEN',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_HALLOWEEN_HAT',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_HALLOWEEN_ATTACH',1 ,1
-- END
SELECT @temp = count(CharID) FROM _User WITH (NOLOCK) WHERE UserJID = @UserJID
IF (@temp = 1)
BEGIN
UPDATE _Char SET RemainGold=1000000000, RemainSkillPoint=100000000 WHERE _Char.CharID = @NewCharID
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RENT_CAMPAIGN_GOLD_TIME_7D', 1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_COS_C_PEGASUS_SCROLL',5,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HP_SUPERSET_5_BAG',100,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_MP_SUPERSET_5_BAG',100,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_ARCHEMY_POTION_SPEED_11',5,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_GACHA_CARD',5,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_REVERSE_RETURN_SCROLL',5,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RESURRECTION_100P_SCROLL',5, 1
--IF @RefCharID<=14887 AND @RefCharID>=14875 -- European Male Gear
--BEGIN
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_EVENT_WINTER',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_EVENT_WINTER_ATTACH ',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_EVENT_WINTER_HAT',1 ,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_EU_M_LIGHT_HA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_EU_M_LIGHT_SA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_EU_M_LIGHT_BA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_EU_M_LIGHT_LA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_EU_M_LIGHT_AA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_EU_M_LIGHT_FA_SET',1,1
--accessories
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_NECKLACE_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_RING_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_RING_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_EARRING_10_C_RARE',1,1
--weapons
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_TSTAFF_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_TSWORD_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_SHIELD_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_STAFF_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_SWORD_09_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_DARKSTAFF_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_HARP_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_CROSSBOW_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_DAGGER_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_AXE_10_C_RARE',1,1
--END
-- IF @RefCharID<=14900 AND @RefCharID>=14888 -- European Women Gear
--BEGIN
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_EVENT_WINTER',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_EVENT_WINTER_ATTACH ',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_EVENT_WINTER_HAT',1 ,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_EU_W_LIGHT_HA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_EU_W_LIGHT_SA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_EU_W_LIGHT_BA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_EU_W_LIGHT_LA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_EU_W_LIGHT_AA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_EU_W_LIGHT_FA_SET',1,1
--accessories
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_NECKLACE_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_RING_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_RING_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_EARRING_10_C_RARE',1,1
--weapons
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_TSTAFF_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_TSWORD_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_SHIELD_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_STAFF_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_SWORD_09_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_DARKSTAFF_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_HARP_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_CROSSBOW_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_DAGGER_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_AXE_10_C_RARE',1,1
-- END
-- IF @RefCharID<=1919 AND @RefCharID>=1907 -- Chinesse Male Gear
--BEGIN
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_EVENT_WINTER',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_EVENT_WINTER_ATTACH ',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_EVENT_WINTER_HAT',1 ,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_CH_M_LIGHT_HA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_CH_M_LIGHT_SA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_CH_M_LIGHT_BA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_CH_M_LIGHT_LA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_CH_M_LIGHT_AA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_CH_M_LIGHT_FA_SET',1,1
--accesories
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_NECKLACE_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_RING_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_RING_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_EARRING_10_C_RARE',1,1
--weapons
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_BOW_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_TBLADE_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_BLADE_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_SPEAR_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_SWORD_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_SHIELD_10_C_RARE',1,1
-- END
-- IF @RefCharID<=1932 AND @RefCharID>=1920 -- Chinesse Women Gear
--BEGIN
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_EVENT_WINTER',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_EVENT_WINTER_ATTACH ',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_EVENT_WINTER_HAT',1 ,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_CH_W_LIGHT_HA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_CH_W_LIGHT_SA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_CH_W_LIGHT_BA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_CH_W_LIGHT_LA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_CH_W_LIGHT_AA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_CH_W_LIGHT_FA_SET',1,1
--accesories
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_NECKLACE_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_RING_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_RING_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_EARRING_10_C_RARE',1,1
--weapons
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_BOW_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_TBLADE_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_BLADE_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_SPEAR_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_SWORD_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_SHIELD_10_C_RARE',1,1
-- END
SET @StartRegionID = 27244
SET @StartPos_X = 271
SET @StartPos_Y = 180
SET @StartPos_Z = 1438
--Founder name For 1st char on acc
END
-- Quick Slot Á¤º¸ ÀúÀå¿ë!!!
exec _AddNewClientConfig @NewCharID -- by novice...... for saving client configurations...
COMMIT TRANSACTION
RETURN @NewCharID
IF @RefCharID < 3000 -- IF Character race Chinese
Begin
Insert InTo _Charskill (CharID,SkillID,Enable) Values (@NewCharID,33835,1)
End
افتح كل المدن من
SRO_VT_SHARD----Tables------_RefRegionBindAssocServer