مشكله صغيره كده [الأرشيف] - الموقع العربي الاول للعبة Silkroad Online

magic99

08-08-2012, 06:01 AM

اولا :السلام عليكم
يا جماعه كنت عاوز اعرف ازاي اخد نسخه من ال DB اللي عندي وازاي لو غيرتها ومعايا نسخه ارجعها تاني

وازاي انزل الشخصيات لفل 120 علي طول انا لما باجي اعملها بلغبط ال MP و HP كنت عاوز اعرف اخلي ال MP و HP كام منAddNewChar

مملك الجنه

08-08-2012, 06:44 AM

عشان تأخذ نسخه من ال DB زى ما بتعمل ريستور بظبط هتلقى فوقيها backup وكده يبقى أخذت نسخه

Mr Z!dane

08-08-2012, 11:07 AM

اضافه [GM] لاسم الكراكتر
كيفيه تزويد الاستر و الانت للجى ام
كيفية تغيير مكان نزول الكراكتر الجديده
حجم الشنطه للكراكتر 3صفحات و الجراب بيت 5 صفحات
اضافه جولد و سكل بوينت لكل كراكتر جديد
نزول الكراكتر 110
اضافه ايتمز للكركتر الجديده
اضافه سلك لكل اكونت جديد (http://jumbofiles.com/06jfobdnrla3)

magic99

08-08-2012, 01:28 PM

عشان تأخذ نسخه من ال db زى ما بتعمل ريستور بظبط هتلقى فوقيها backup وكده يبقى أخذت نسخه

ممكن تقولي دي موجوده فين بالظبط

shasha800

08-08-2012, 03:07 PM

حضرتك هتعلم علي داتابيز ولنفرض SRO_VT_SHARD

هتدوس Right Click ---->Tasks ----->Back Up

أعمل الباك أب Expire بعد 9999 يوم

و دوس أوك

أما عن نزول الشخصيات 120

ده كويري تنزيل الاكونتات 120 مع أيتمز نوفا +5 ( حسب نوع الاكونت )

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 06/20/2012 15:22:31 ******/
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. Ä³¸¯ÅÍ ½½·Ô ³Ñ¹ö°¡ 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. Ä³¸¯ÅÍ Ãß°¡ÇÏ±â
-----------------------------------------------------------------------------
IF (@CharScale > 68) -- 0100 0100 --> 68 ÀÌ´Ù!
BEGIN
-- Ä³¸¯ÅÍ »ý¼º ½ÇÆÐ! ½ºÄÉÀÏ °ªÀÌ ÀÌ»óÇÏ´Ù!
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, ExpOffset, HwanLevel, 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, 4000000000, 3, 25000, 979, -32.60888, 1238, 2094, 109,
GetDate(), 120, 120, 10000000, 327, 10000000, 200,200, 1, 1, 1, 1)

SET @NewCharID = @@IDENTITY
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
-- Ä³¸¯ÅÍ »ý¼º ½ÇÆÐ!
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,
12: 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 -12
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
-----------------------------------------------------------------------------
-- 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)

if (@RefCharID >= 1907 and @RefCharID <= 1919)
BEGIN
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_12_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_12_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_12_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_12_SA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_12_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_12_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_12_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_12_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_12_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_12_SA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_12_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_12_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_12_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_12_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_12_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_12_SA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_12_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_12_FA_A_RARE',1,5
END
else if (@RefCharID >= 1920 and @RefCharID <= 1932)
BEGIN
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_12_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_12_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_12_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_12_SA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_12_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_12_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_12_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_12_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_12_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_12_SA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_12_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_12_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_12_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_12_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_12_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_12_SA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_12_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_12_FA_A_RARE',1,5
END
else if (@RefCharID >= 14875 and @RefCharID <= 14887)
BEGIN
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_12_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_12_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_12_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_12_SA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_12_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_12_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_12_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_12_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_12_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_12_SA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_12_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_12_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_12_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_12_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_12_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_12_SA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_12_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_12_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_12_A_RARE',1,5
END
else if (@RefCharID >= 14888 and @RefCharID <= 14900)
BEGIN
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_12_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_12_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_12_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_12_SA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_12_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_12_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_12_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_12_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_12_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_12_SA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_12_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_12_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_12_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_12_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_12_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_12_SA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_12_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_12_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_12_A_RARE',1,5
END
else
BEGIN
return -999
END
-- Quick Slot Á¤º¸ ÀúÀå¿ë!!!
exec _AddNewClientConfig @NewCharID -- by novice...... for saving client configurations...

COMMIT TRANSACTION

RETURN @NewCharID

مع العلم أن بالكويري ده كل الاكونتات هتنزل في جانجان حتي الاوروبي

●♥ Marwan1337 ♥●

08-08-2012, 05:04 PM

تم الرد .. !!
Closed
#