الموقع العربي الاول للعبة Silkroad Online

الموقع العربي الاول للعبة Silkroad Online (https://silkroad4arab.com/vb/index.php)
-   قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة (https://silkroad4arab.com/vb/forumdisplay.php?f=226)
-   -   مساعدة فى Start item (https://silkroad4arab.com/vb/showthread.php?t=618385)

OoMasterOo 25-08-2017 10:05 PM
مساعدة فى Start item
 
السلام عليكم
وكل سنة وانتوا طيبين .عيد مبارك علينا جميعا
1: الاكونتات الجديدة بتنزل عندى لبسة سيت كامل دجرى 1 بس نورمال عايز اغيرة ل صن بدك النورمال
2: عايز اعرف ازاى اخلى اى حد يعمل اكونت ينزل معاة سيلك
ودا ال
اقتباس:
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 8/25/2017 9:01:20 PM ******/
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 >= 1)
BEGIN
-- ³Ê¹« ¸¹ÀÚ³ª
RETURN -2
END
-- finish by novice.

-----------------------------------------------------------------------------
-- 2. ij¸¯ÅÍ Ãß°¡Çϱâ
-----------------------------------------------------------------------------
IF (@CharScale > 68) -- 0100 0100 --> 68 ÀÌ´Ù!
BEGIN
-- ij¸¯ÅÍ »y¼º ½ÇÆ?! ½ºÄÉÀÏ °ªÀÌ ÀÌ»óÇÏ´Ù!
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, HwanLevel)
VALUES (@RefCharID, @CharName, @CharScale, 20, 20, 25000, 1012, -32.6088829, 1001, 2094, 109,
GetDate(), 1, 1, 2000000, 0, 500000, 200,200, 1, 1, 1, 1, 1)

SET @NewCharID = @@IDENTITY
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
-- ij¸¯ÅÍ »y¼º ½ÇÆ?!
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
-- Àκ¥Å丮 »y¼º ½ÇÆ?!
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

-- Start Euro Full Gear ----
if @RefCharID <=14887 And @RefCharID >=14875 And @RefMailID = '11623' -- Euro Male Germant
begin
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 12175, 39 --HAT
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 12211, 39 --SHOULDER
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 12319, 39 --HAND
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 14695, 0 --Earring
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 14731, 0 --NECKLACE
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 14659, 0 --RING
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 14659, 0 --RING
END

if @RefCharID <=14887 And @RefCharID >=14875 And @RefMailID = '11617' -- Euro Male Armor
begin
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 11671, 45 --HAT
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 11707, 45 --SHOULDER
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 11815, 45 --HAND
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 14695, 0 --Earring
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 14731, 0 --NECKLACE
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 14659, 0 --RING
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 14659, 0 --RING
END

if @RefCharID <=14887 And @RefCharID >=14875 And @RefMailID = '11620' -- Euro Male protector
begin
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 11923, 39 --HAT
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 11959, 39 --SHOULDER
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 12067, 39 --HAND
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 14695, 0 --Earring
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 14731, 0 --NECKLACE
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 14659, 0 --RING
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 14659, 0 --RING
END

--- Female Side ! ------

if @RefCharID <=14900 And @RefCharID >=14888 And @RefMailID = '11632' -- Euro female Germant
begin
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 13687, 32 --HAT
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 13723, 32 --SHOULDER
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 13831, 32 --HAND
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 14695, 0 --Earring
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 14731, 0 --NECKLACE
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 14659, 0 --RING
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 14659, 0 --RING
END

if @RefCharID <=14900 And @RefCharID >=14888 And @RefMailID = '11626' -- Euro female Armor
begin
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 13183, 45 --HAT
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 13219, 45 --SHOULDER
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 13327, 45 --HAND
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 14695, 0 --Earring
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 14731, 0 --NECKLACE
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 14659, 0 --RING
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 14659, 0 --RING
END

if @RefCharID <=14900 And @RefCharID >=14888 And @RefMailID = '11629' -- Euro female protector
begin
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 13435, 39 --HAT
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 13471, 39 --SHOULDER
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 13579, 39 --HAND
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 14695, 0 --Earring
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 14731, 0 --NECKLACE
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 14659, 0 --RING
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 14659, 0 --RING
END


-- End --

-- Start China Full Gear ----
IF @RefCharID<=1919 AND @RefCharID>=1907 and @RefMailID = '3643' -- Chinesse Male Gear CLOTHES
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 791, 39 --HAT
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 863, 39 --SHOULDER
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 971, 39 --HAND
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 1835, 0 --Earring
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 1871, 0 --NECKLACE
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 1799, 0 --RING
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 1799, 0 --RING

END
IF @RefCharID<=1919 AND @RefCharID>=1907 and @RefMailID = '3637' -- Chinesse Male Gear ARRMOR
begin
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 287, 48 --HAT
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 359, 48 --SHOULDER
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 467, 48 --HAND
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 1835, 0 --Earring
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 1871, 0 --NECKLACE
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 1799, 0 --RING
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 1799, 0 --RING
end
IF @RefCharID<=1919 AND @RefCharID>=1907 and @RefMailID = '3640' -- Chinesse Male Gear LIGHT
begin
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 539, 44 --HAT
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 611, 44 --SHOULDER
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 719, 44 --HAND
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 1835, 0 --Earring
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 1871, 0 --NECKLACE
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 1799, 0 --RING
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 1799, 0 --RING
END

--- Female Side ! ------
IF @RefCharID<=1932 AND @RefCharID>=1920 and @RefMailID = '3652' -- Chinesse Woman Gear CLOTHES
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 1547, 39 --HAT
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 1619, 39 --SHOULDER
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 1727, 39 --HAND
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 1835, 0 --Earring
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 1871, 0 --NECKLACE
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 1799, 0 --RING
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 1799, 0 --RING
END
IF @RefCharID<=1932 AND @RefCharID>=1920 and @RefMailID = '3646' -- Chinesse Woman Gear ARRMOR
begin
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 1043, 48 --HAT
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 1115, 48 --SHOULDER
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 1223, 48 --HAND
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 1835, 0 --Earring
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 1871, 0 --NECKLACE
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 1799, 0 --RING
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 1799, 0 --RING
end
IF @RefCharID<=1932 AND @RefCharID>=1920 and @RefMailID = '3649' -- Chinesse Woman Gear LIGHT
begin
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 1295, 44 --HAT
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 1367, 44 --SHOULDER
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 1475, 44 --HAND
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 1835, 0 --Earring
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 1871, 0 --NECKLACE
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 1799, 0 --RING
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 1799, 0 --RING
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
-- ¾Æ¹ÙŸ Àκ¥Å丮 »y¼º ½ÇÆ?!
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 ä¿ö³Ö±â!!!!!
-----------------------------------------------------------------------------
IF (@@ERROR <> 0)
BEGIN
-- Àκ¥Å丮 »y¼º ½ÇÆ?!
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_EVENT_HP_SUPERSET_5_BAG',1000,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_MP_SUPERSET_5_BAG',1000,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',1000,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_RETURN_SCROLL_HIGH_SPEED',100 0,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RENT_ARCHEMY_POTION_SPEED_11 ',20,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_NASRUN',1,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_SRODESIGN_SNOWSHIELD_ACTIVE', 1,0

END
else if (@RefCharID >= 1920 and @RefCharID <= 1932)
BEGIN
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HP_SUPERSET_5_BAG',1000,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_MP_SUPERSET_5_BAG',1000,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',1000,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_RETURN_SCROLL_HIGH_SPEED',100 0,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RENT_ARCHEMY_POTION_SPEED_11 ',20,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_NASRUN',1,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_SRODESIGN_SNOWSHIELD_ACTIVE', 1,0

END
else if (@RefCharID >= 14875 and @RefCharID <= 14887)
BEGIN
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HP_SUPERSET_5_BAG',1000,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_MP_SUPERSET_5_BAG',1000,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',1000,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_RETURN_SCROLL_HIGH_SPEED',100 0,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RENT_ARCHEMY_POTION_SPEED_11 ',20,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_NASRUN',1,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_SRODESIGN_SNOWSHIELD_ACTIVE', 1,0

END
else if (@RefCharID >= 14888 and @RefCharID <= 14900)
BEGIN
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HP_SUPERSET_5_BAG',1000,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_MP_SUPERSET_5_BAG',1000,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',1000,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_RETURN_SCROLL_HIGH_SPEED',100 0,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RENT_ARCHEMY_POTION_SPEED_11 ',20,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_NASRUN',1,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_SRODESIGN_SNOWSHIELD_ACTIVE', 1,0


END
else
BEGIN
return -999
END
-- Quick Slot Á¤º¸ ÀúÀå¿ë!!!
exec _AddNewClientConfig @NewCharID -- by novice...... for saving client configurations...
INSERT INTO _CharTrijob VALUES (@NewCharID, 0, 1, 0, 0, 0, 0)
COMMIT TRANSACTION

RETURN @NewCharID

Dev.Sawy 25-08-2017 11:04 PM
رد: مساعدة فى Start item
 
كل الي انت عايزوو دة كلو هتلاقية في AddNewChar

OoMasterOo 25-08-2017 11:38 PM
رد: مساعدة فى Start item
 
اقتباس:
المشاركة الأصلية كتبت بواسطة Dev.Sawy (المشاركة 5325972)
كل الي انت عايزوو دة كلو هتلاقية في AddNewChar
ما انا حاطط ال Addnewchar لانى بصراحة مش عارف هاغير اية
شكرا لى مرورك

™Ozoo-Eboda™ 27-08-2017 03:01 AM
رد: مساعدة فى Start item
 
كود PHP:
BEGIN
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HP_SUPERSET_5_BAG',1000,0 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_MP_SUPERSET_5_BAG',1000,0 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',1000,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_RETURN_SCROLL_HIGH_SPEED',100 0,0 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RENT_ARCHEMY_POTION_SPEED_11 ',20,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_NASRUN',1,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_SRODESIGN_SNOWSHIELD_ACTIVE', 1,0

END
else if (@RefCharID >= 1920 and @RefCharID <= 1932)
BEGIN
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HP_SUPERSET_5_BAG',1000,0 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_MP_SUPERSET_5_BAG',1000,0 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',1000,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_RETURN_SCROLL_HIGH_SPEED',100 0,0 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RENT_ARCHEMY_POTION_SPEED_11 ',20,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_NASRUN',1,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_SRODESIGN_SNOWSHIELD_ACTIVE', 1,0 

END
else if (@RefCharID >= 14875 and @RefCharID <= 14887)
BEGIN
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HP_SUPERSET_5_BAG',1000,0 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_MP_SUPERSET_5_BAG',1000,0 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',1000,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_RETURN_SCROLL_HIGH_SPEED',100 0,0 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RENT_ARCHEMY_POTION_SPEED_11 ',20,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_NASRUN',1,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_SRODESIGN_SNOWSHIELD_ACTIVE', 1,0

END
else if (@RefCharID >= 14888 and @RefCharID <= 14900)
BEGIN
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HP_SUPERSET_5_BAG',1000,0 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_MP_SUPERSET_5_BAG',1000,0 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',1000,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_RETURN_SCROLL_HIGH_SPEED',100 0,0 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RENT_ARCHEMY_POTION_SPEED_11 ',20,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_NASRUN',1,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_SRODESIGN_SNOWSHIELD_ACTIVE', 1,0 


END
else
BEGIN    
return -999
END 
-- Quick Slot أپ¤آ؛¸ أ€أ؛أ€أ¥آ؟ë!!! 
exec _AddNewClientConfig @NewCharID -- by novice...... for saving client configurations... 
INSERT INTO _CharTrijob VALUES (@NewCharID, 0, 1, 0, 0, 0, 0)
COMMIT TRANSACTION 

RETURN @NewCharID 
..
دا الجزء الاخير عندك.. دي عبارة عن اكواد الايتم اللي بتزل مع الكراكتر .. دي انت بتعدلها للأيتم اللي انت عاوزة

OoMasterOo 27-08-2017 04:08 PM
رد: مساعدة فى Start item
 
اقتباس:
المشاركة الأصلية كتبت بواسطة ™Ozoo-Eboda™ (المشاركة 5326029)
كود PHP:
BEGIN
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HP_SUPERSET_5_BAG',1000,0 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_MP_SUPERSET_5_BAG',1000,0 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',1000,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_RETURN_SCROLL_HIGH_SPEED',100 0,0 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RENT_ARCHEMY_POTION_SPEED_11 ',20,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_NASRUN',1,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_SRODESIGN_SNOWSHIELD_ACTIVE', 1,0

END
else if (@RefCharID >= 1920 and @RefCharID <= 1932)
BEGIN
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HP_SUPERSET_5_BAG',1000,0 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_MP_SUPERSET_5_BAG',1000,0 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',1000,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_RETURN_SCROLL_HIGH_SPEED',100 0,0 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RENT_ARCHEMY_POTION_SPEED_11 ',20,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_NASRUN',1,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_SRODESIGN_SNOWSHIELD_ACTIVE', 1,0 

END
else if (@RefCharID >= 14875 and @RefCharID <= 14887)
BEGIN
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HP_SUPERSET_5_BAG',1000,0 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_MP_SUPERSET_5_BAG',1000,0 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',1000,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_RETURN_SCROLL_HIGH_SPEED',100 0,0 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RENT_ARCHEMY_POTION_SPEED_11 ',20,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_NASRUN',1,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_SRODESIGN_SNOWSHIELD_ACTIVE', 1,0

END
else if (@RefCharID >= 14888 and @RefCharID <= 14900)
BEGIN
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HP_SUPERSET_5_BAG',1000,0 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_MP_SUPERSET_5_BAG',1000,0 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',1000,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_RETURN_SCROLL_HIGH_SPEED',100 0,0 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RENT_ARCHEMY_POTION_SPEED_11 ',20,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_NASRUN',1,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_SRODESIGN_SNOWSHIELD_ACTIVE', 1,0 


END
else
BEGIN    
return -999
END 
-- Quick Slot أپ¤آ؛¸ أ€أ؛أ€أ¥آ؟ë!!! 
exec _AddNewClientConfig @NewCharID -- by novice...... for saving client configurations... 
INSERT INTO _CharTrijob VALUES (@NewCharID, 0, 1, 0, 0, 0, 0)
COMMIT TRANSACTION 

RETURN @NewCharID 
..
دا الجزء الاخير عندك.. دي عبارة عن اكواد الايتم اللي بتزل مع الكراكتر .. دي انت بتعدلها للأيتم اللي انت عاوزة
شكرا ل اهتمام حضرتك
انا عارف دة كويس دول hp.Mp.rev.return ...ect
انا قصدى حضرتك ان الشير بتنزل لابسة ست كامل وبون وست واكسوسورى لابساهم مش ف الانفنتورى ولما دورت فى AddNewChar مش شايف الاكواد بتاعتهم عشان اقدر اغيرها

_KoNo_ 27-08-2017 05:18 PM
رد: مساعدة فى Start item
 
دي مش مشكلة انت ممكن تنزل انت مع الاكونتات الجديدة الصن اللي أنت عاوزه وهم يبقوا يبيعوا اللي هما لابسينوا لان كده كده اللي بينزل والاكونت لابسه دي تبع السيستم التقليدي بتاع اي داتا علي حد معلوماتي والله أعلم


الساعة الآن 05:03 PM.

Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2024, vBulletin Solutions, Inc.