I'm Back
|
|
• الانـتـسـاب » Dec 2015
|
|
• رقـم العـضـويـة » 128556
|
|
• المشـــاركـات » 1,335
|
|
• الـدولـة » 3mrany
|
|
• الـهـوايـة » Design-MySQL-C#-HTML-CSS3-WinServer-More
|
|
• اسـم الـسـيـرفـر » Aquarius
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 47
|
|
|
|
.gif)
C-SRO F1 Fix Bug
C-SRO F1 FIX BUG
للاسف مش هعرف اجيب صورة من المشكلة عشان انا حلتها عندى  بس انت لو عندك مشكلة فى F1 لما بتدوس عليه بيجيلك DC اعمل ال Query دى
كود PHP:
USE [SRO_FEIER_SHARDDB]GO
/****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 01/05/2015 08:20:51 ******/
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, @temp INT, @NewCharID INT;
SET @NewCharID = 0;
-----------------------------------------------------------------------------
-- 1. ¼ valid , º .
-----------------------------------------------------------------------------
-- start by novice.
SELECT @temp = count(CharID) FROM _User WITH (NOLOCK) WHERE UserJID = @userJID
IF @temp >= 4) -- ID
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, 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
select @NewCharID --HJ
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)
-----------------------------------------------------------------------------
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
-- ...
/* .
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
IF @refBootsID <> 0) -- Boots
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 5, @refBootsID, @DurBoots
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -10
END
END
IF @refWeaponID <> 0) -- Weapon
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
IF (@DefaultArrow <> 0) -- default ® 250 . ?
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 Í
-----------------------------------------------------------------------------
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
-----------------------------------------------------------------------------
-- 3-3.
-- [ Í 50]
-- Define ADD_TRADE_BAG_INVENTORY Í
-----------------------------------------------------------------------------
-- PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!
INSERT INTO _TradeBagInventory(CharID, Slot, ItemID)
SELECT @NewCharID, cnt, 0
FROM _RefDummySlot with( nolock )
WHERE cnt < 50
IF (@@ERROR <> 0)
BEGIN
-- !
ROLLBACK TRANSACTION
RETURN -20
END
-- PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!
-----------------------------------------------------------------------------
-- 3-4.
-- [ Í 11]
-- Define ADD_TRADE_EQUIP_INVENTORY Í
-----------------------------------------------------------------------------
-- PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!
INSERT INTO _TradeEquipInventory(CharID, Slot, ItemID)
SELECT @NewCharID, cnt, 0
FROM _RefDummySlot with( nolock )
WHERE cnt < 11
IF (@@ERROR <> 0)
BEGIN
-- !
ROLLBACK TRANSACTION
RETURN -21
END
-----------------------------------------------------------------------------
-- default skill
-----------------------------------------------------------------------------
DECLARE @country tinyINT
EXEC @country = _GetObjCountry @refCharID
SELECT @NewCharID, MasteryID, 0 FROM _RefCharDefault_SkillMastery with(nolock) WHERE Race = @country or Race = 3; --HJ
select @NewCharID, @country
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
UPDATE _CharQuest set Status = 5 , QuestData1 = 77594711 where CharID = @NewCharID and QuestID = 1
UPDATE _CharQuest set Status = 5 where CharID = @NewCharID and QuestID = 2
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
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- Í
-----------------------------------------------------------------------------
INSERT _FriendGroup Values @NewCharID, 0, '') -- Í by bkh
IF (@@ERROR <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -20 -- Í !
END
-----------------------------------------------------------------------------
-- TradeConflictJob !!!!!
-----------------------------------------------------------------------------
INSERT INTO _CharTradeConflictJob VALUES @NewCharID, GetDate(), 1, 0, 0, 0, 0, 0 ,0)
IF (@@ERROR <> 0)
BEGIN
-- Å ...!
ROLLBACK TRANSACTION
RETURN -22
END
-----------------------------------------------------------------------------
-- NewTrade !!!!!
-----------------------------------------------------------------------------
INSERT INTO _CharNewTrade VALUES @NewCharID, 0, 0)
IF (@@ERROR <> 0)
BEGIN
-- Å ...!
ROLLBACK TRANSACTION
RETURN -23
END
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- Í
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- !!!
-----------------------------------------------------------------------------
-- ReqType 1
INSERT _CharAlchemy_MK_Recipe
SELECT @NewCharID, MR.RC_ID FROM _RefLearnRecipeByReqType AS LR
JOIN _RefAlchemy_MK_Recipe AS MR ON LR.RecipeCodeName = MR.RC_CodeName128
WHERE LR.ReqType = 1 AND LR.ReqValue = 1 AND LR.Service = 1
IF (@@ERROR <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -21 -- Í
END
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-----------------------------------------------------------------------------
-- CharList ID
-----------------------------------------------------------------------------
INSERT _CharNameList VALUES @charname, @NewCharID);
COMMIT TRANSACTION
if @refCharID>=14961 and @refCharID<=14973)
begin
insert into _CharAlchemy_MK_Recipe select @NewCharID,b.RC_ID from _RefAlchemy_MK_Recipe as b
where b.RC_CodeName128 like 'MK[_]RC[_]CM[_]EU[_]W[_]%'
or (b.RC_CodeName128 like 'MK[_]RC[_]CM[_]EU[_]%'
and b.RC_CodeName128 not like '%[_]W[_]%'
and b.RC_CodeName128 not like '%[_]M[_]%')
or (b.RC_CodeName128 like 'MK[_]RC[_]CM[_]%'
and b.RC_CodeName128 not like '%[_]CH[_]%'
and b.RC_CodeName128 not like '%[_]EU[_]%')
end
if @refCharID>=14948 and @refCharID<=14960)
begin
insert into _CharAlchemy_MK_Recipe select @NewCharID,b.RC_ID from _RefAlchemy_MK_Recipe as b
where b.RC_CodeName128 like 'MK[_]RC[_]CM[_]EU[_]M[_]%'
or (b.RC_CodeName128 like 'MK[_]RC[_]CM[_]EU[_]%'
and b.RC_CodeName128 not like '%[_]W[_]%'
and b.RC_CodeName128 not like '%[_]M[_]%')
or (b.RC_CodeName128 like 'MK[_]RC[_]CM[_]%'
and b.RC_CodeName128 not like '%[_]CH[_]%'
and b.RC_CodeName128 not like '%[_]EU[_]%')
end
if @refCharID>=1920 and @refCharID<=1932)
begin
insert into _CharAlchemy_MK_Recipe select @NewCharID,b.RC_ID from _RefAlchemy_MK_Recipe as b
where b.RC_CodeName128 like 'MK[_]RC[_]CM[_]CH[_]W[_]%'
or (b.RC_CodeName128 like 'MK[_]RC[_]CM[_]CH[_]%'
and b.RC_CodeName128 not like '%[_]W[_]%'
and b.RC_CodeName128 not like '%[_]M[_]%')
or (b.RC_CodeName128 like 'MK[_]RC[_]CM[_]%'
and b.RC_CodeName128 not like '%[_]CH[_]%'
and b.RC_CodeName128 not like '%[_]EU[_]%')
end
if @refCharID>=1907 and @refCharID<=1919)
begin
insert into _CharAlchemy_MK_Recipe select @NewCharID,b.RC_ID from _RefAlchemy_MK_Recipe as b
where
b.RC_CodeName128 like 'MK[_]RC[_]CM[_]CH[_]M[_]%'
or (b.RC_CodeName128 like 'MK[_]RC[_]CM[_]CH[_]%'
and b.RC_CodeName128 not like '%[_]W[_]%'
and b.RC_CodeName128 not like '%[_]M[_]%')
or (b.RC_CodeName128 like 'MK[_]RC[_]CM[_]%'
and b.RC_CodeName128 not like '%[_]CH[_]%'
and b.RC_CodeName128 not like '%[_]EU[_]%')
end
IF @refShield <> 0)
begin
if @refShield=10927
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_CH_SHIELD_12_A_RARE',1,0
end
else if @refShield=10937
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_EU_SHIELD_12_A_RARE',1,0
end
end
if @refWeaponID=3632
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_CH_SWORD_12_A_RARE',1,0
end
else if @refWeaponID=3633
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_CH_BLADE_12_A_RARE',1,0
end
else if @refWeaponID=3636
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_CH_BOW_12_A_RARE',1,0
end
else if @refWeaponID=3634
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_CH_SPEAR_12_A_RARE',1,0
end
else if @refWeaponID=3635
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_CH_TBLADE_12_A_RARE',1,0
end
else if @refWeaponID=10928
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_EU_DAGGER_12_A_RARE',1,0
end
else if @refWeaponID=10929
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_EU_SWORD_12_A_RARE',1,0
end
else if @refWeaponID=10930
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_EU_TSWORD_12_A_RARE',1,0
end
else if @refWeaponID=10931
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_EU_AXE_12_A_RARE',1,0
end
else if @refWeaponID=10932
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_EU_CROSSBOW_12_A_RARE',1,0
end
else if @refWeaponID=10933
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_EU_DARKSTAFF_12_A_RARE',1,0
end
else if @refWeaponID=10934
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_EU_TSTAFF_12_A_RARE',1,0
end
else if @refWeaponID=10935
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_EU_HARP_12_A_RARE',1,0
end
else if @refWeaponID=10936
begin
exec _ADD_ITEM_EXTERN @charname, 'ITEM_EU_STAFF_12_A_RARE',1,0
end
if @refCharID>=1907 and @refCharID<=1919--
begin
if @refMailID >=3637 and @refMailID <=3639--
begin
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_HEAVY_12_AA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_HEAVY_12_BA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_HEAVY_12_FA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_HEAVY_12_HA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_HEAVY_12_LA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_HEAVY_12_SA_A_RARE',1,0
end
if @refMailID >=3640 and @refMailID <=3642--
begin
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_LIGHT_12_AA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_LIGHT_12_BA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_LIGHT_12_FA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_LIGHT_12_HA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_LIGHT_12_LA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_LIGHT_12_SA_A_RARE',1,0
end
if @refMailID >=3643 and @refMailID <=3645--
begin
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_CLOTHES_12_AA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_CLOTHES_12_BA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_CLOTHES_12_FA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_CLOTHES_12_HA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_CLOTHES_12_LA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_M_CLOTHES_12_SA_A_RARE',1,0
end
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_EARRING_12_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_NECKLACE_12_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_RING_12_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_RING_12_A_RARE',1,0
end
if @refCharID>=1920 and @refCharID<=1932--
begin
if @refMailID >=3646 and @refMailID <=3648--
begin
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_HEAVY_12_AA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_HEAVY_12_BA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_HEAVY_12_FA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_HEAVY_12_HA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_HEAVY_12_LA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_HEAVY_12_SA_A_RARE',1,0
end
if @refMailID >=3649 and @refMailID <=3651--
begin
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_LIGHT_12_AA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_LIGHT_12_BA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_LIGHT_12_FA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_LIGHT_12_HA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_LIGHT_12_LA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_LIGHT_12_SA_A_RARE',1,0
end
if @refMailID >=3652 and @refMailID <=3654--
begin
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_CLOTHES_12_AA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_CLOTHES_12_BA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_CLOTHES_12_FA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_CLOTHES_12_HA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_CLOTHES_12_LA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_W_CLOTHES_12_SA_A_RARE',1,0
end
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_EARRING_12_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_NECKLACE_12_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_RING_12_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_CH_RING_12_A_RARE',1,0
end
if @refCharID>=14948 and @refCharID<=14960--
begin
if @refMailID >=11658 and @refMailID <=11660--
begin
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_HEAVY_12_AA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_HEAVY_12_BA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_HEAVY_12_FA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_HEAVY_12_HA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_HEAVY_12_LA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_HEAVY_12_SA_A_RARE',1,0
end
if @refMailID >=11661 and @refMailID <=11663--
begin
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_LIGHT_12_AA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_LIGHT_12_BA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_LIGHT_12_FA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_LIGHT_12_HA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_LIGHT_12_LA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_LIGHT_12_SA_A_RARE',1,0
end
if @refMailID >=11664 and @refMailID <=11666--
begin
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_CLOTHES_12_AA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_CLOTHES_12_BA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_CLOTHES_12_FA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_CLOTHES_12_HA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_CLOTHES_12_LA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_M_CLOTHES_12_SA_A_RARE',1,0
end
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_EARRING_12_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_NECKLACE_12_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_RING_12_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_RING_12_A_RARE',1,0
end
if @refCharID>=14961 and @refCharID<=14973--
begin
if @refMailID >=11667 and @refMailID <=11669--
begin
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_HEAVY_12_AA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_HEAVY_12_BA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_HEAVY_12_FA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_HEAVY_12_HA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_HEAVY_12_LA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_HEAVY_12_SA_A_RARE',1,0
end
if @refMailID >=11670 and @refMailID <=11672--
begin
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_LIGHT_12_AA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_LIGHT_12_BA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_LIGHT_12_FA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_LIGHT_12_HA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_LIGHT_12_LA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_LIGHT_12_SA_A_RARE',1,0
end
if @refMailID >=11673 and @refMailID <=11675--
begin
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_CLOTHES_12_AA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_CLOTHES_12_BA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_CLOTHES_12_FA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_CLOTHES_12_HA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_CLOTHES_12_LA_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_W_CLOTHES_12_SA_A_RARE',1,0
end
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_EARRING_12_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_NECKLACE_12_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_RING_12_A_RARE',1,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_EU_RING_12_A_RARE',1,0
end
exec _ADD_ITEM_EXTERN @charname,'ITEM_ETC_LEVEL_TOKEN_02',1200,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_ETC_LEVEL_TOKEN_03',5600,0
exec _ADD_ITEM_EXTERN @charname,'ITEM_ETC_LEVEL_TOKEN_01',750,0
declare @updateitemid int
declare cur cursor fast_forward for select itemid from dbo._Inventory with(nolock) where charid @NewCharID and slot in(6,7)
open cur
fetch next from cur into @updateitemid
while(@@fetch_status=0)
begin
if @updateitemid<>0
begin
update _items set optlevel=77 where id64=@updateitemid
end
fetch next from cur into @updateitemid
end
close cur
deallocate cur
-- Quick Slot !!!
exec _AddNewClientConfig @NewCharID -- by novice...... for saving client configurations...
RETURN @NewCharID
من مجهودى الخاص يعنى مش منقول و تنسيق الموضوع متاخد من العضو عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] 
|
شـريـط الاهـداءات
07-12-2016, 01:57 PM
.gif){kind=icon}
العرض العادي
