Printable View
Alright let me prepare video for you ;)Quote:
Originally Posted by blacksheep25
Here it is: (from character creation)
SQL query:
Spoiler:
Using in-game scroll:
Spoiler:
Well, I use vSRO 1.88, didn't try in other DB type.Quote:
Originally Posted by blacksheep25
There's your problem then, your server didn't log anything :), btw I'm using Evangelion 1.0.5 and set "disableLog = 0" in my misc.ini, it works like a charm.Quote:
Originally Posted by B1QB0SS
i know query works
but i want scroll how to fix LogEventitem ?!
So using SQL query works, great. Then you have problem with the Log, as you said before. Well, what version of Evangelion you use? I use Evangelion 1.0.5 by Chern0byl from this release.Quote:
Originally Posted by B1QB0SS
1.0.5 too
so maybe wrong from LOG_DB?
Did you modify the original _AddLogItem SP? if you made some modifications earlier, post it here. Perhaps we can discuss about itQuote:
Originally Posted by B1QB0SS
Here's my blackrogue _AddLogItem Procedure.
Spoiler:
Copied The SP
Paste On LOG Db Proc Addlogitem
Pressed Excute
Restarted all Server Files !
And Nothing Works !
@B1QB0SS
Your problem is with the server logging (_AddLogItem), based on what you told me, seems your server didn't log ANYTHING or there's something wrong with your _AddLogItem SP. That's entirely irrelevant matter to this item, so don't blame this item if your server didn't log anything. Now, post your _AddLogItem SP, perhaps we can discuss about it.Quote:
Originally Posted by B1QB0SS
---
@blacksheep25
Pretty much the same with vSRO :), here's mine:Quote:
Originally Posted by blacksheep25
Spoiler:
Btw, seems your put remark on the logging sequence, hence you set your server not to log any items, well, perhaps you might wanna remove the remark first, and use another item like original return scroll or something, just to see if the server really logs anything :)
Yeah i uncommented that and its now logging correctly
this does work perfectly on blackrogue 110 server files. Its the main files i used for this :ott1:Quote:
Originally Posted by blacksheep25
Yeah its logging all fine now, but i still have problems with the scroll not working on some chars. I will look tomorrow after i sleep its 1:30am atm ;)
Awesome :) And you might wanna check by doing manual query on the SP for certain chars that you notice didn't work on.Quote:
Originally Posted by blacksheep25
good luck and have fun :)
witchymoo i sent you a pm. Hope to hear from ya.
Edit: Also if set the settings to be 'A_RARE' instead. It only work with items degree 10 or higher. How come ? Any where this setting is defined at ?
Just tried this to a chinese spear character, and it worked for 10D SOS (A_RARE)+16. Not sure why its not working for you.Quote:
Originally Posted by P0kemonMast
@witchmoo
I have sent you the fixed _ADD_GM_GEAR procedure for Blackrouge 110 Database to fix euro chars ;) add it to the first post ^_^
Fixed 110 Blackrogue Database ADD_GM_GEAR Procedure
* RED text is what i had to modify.Code:USE [XEON_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_ADD_GM_GEAR] Script Date: 11/27/2013 15:38:51 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[_ADD_GM_GEAR]
@CharName AS VARCHAR(64),
@EQClass AS VARCHAR(16),
@EQDegree AS VARCHAR(2),
@EQPlus AS tinyINT
AS
/* Update 2013/11/05 */
-- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- @@@ BEGIN: SETTINGS
-- CHANGE THIS! -- CHANGE THIS! -- CHANGE THIS! (if needed)
-- (Represent ITEM_CH_BOW_11_SET_B_RARE), change as you need it
DECLARE @GearSuffix VARCHAR(16) = 'A_RARE'
-- (Represent ITEM_ETC_AVATAR_W_GM_UNIFORM), change as you need it
DECLARE @uniSuffix VARCHAR(16) = 'GM_UNIFORM'
-- (Represent ITEM_MALL_AVATAR_W_NASRUN_UNIQUE), change as you need it
DECLARE @DSSuffix VARCHAR(16) = 'NASRUN_UNIQUE'
-- Represent custom title, change as you need it
DECLARE @HwanLevel TINYINT = 6
-- Change these if you want
DECLARE @Strength INT = 10000
DECLARE @Intellect INT = 10000
DECLARE @RemainGold INT = 1000000000
DECLARE @RemainSkillPoint INT = 15000000
DECLARE @InventorySize INT = 109
-- Gift Silk
DECLARE @GiftSilk INT = 1000
-- @@@ END: SETTINGS
-- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
SET NOCOUNT ON
/* Update 2013/11/28 - Add leading '0' to single digit degree */
SET @EQDegree = CASE WHEN CAST(@EQDegree AS INT) < 10 AND LEFT(@EQDegree,1) NOT LIKE '[0]' THEN '0' + @EQDegree ELSE @EQDegree END
-- Check if character exist
DECLARE @isCharExist TINYINT
PRINT 'Validating Character...'
EXEC @isCharExist = [_IsExistingCharName] @CharNameToCheck = @CharName
IF (@isCharExist = 0)
BEGIN
RAISERROR('Character: %s does not exist. Sequence canceled!', 1, 16, @CharName)
RETURN -1
END
-- Check character and account related information (In relation with XEON_VT_ACCOUNT)
DECLARE @CharID INT
DECLARE @RefCharID INT
DECLARE @UserJID INT
DECLARE @GMLevel INT
DECLARE @AccountName VARCHAR(32)
-- Check if character assigned to Account ID
PRINT 'Validating Account ID...'
SELECT @CharID = CharID, @RefCharID = RefObjID FROM [_Char] WHERE CharName16 = @CharName
SELECT @UserJID = UserJID FROM [_User] WHERE CharID = @CharID
IF (@UserJID IS NULL OR @UserJID = 0)
BEGIN
RAISERROR('Account ID does not exist, or character: %s is not assigned to any user accounts. Sequence canceled!', 1, 16, @CharName)
RETURN -2
END
/*
-- Check GM levels (CHANGE THIS CONDITION if needed)
PRINT 'Validating GM Level...'
SELECT @GMLevel = sec_primary, @AccountName = StrUserID FROM [XEON_VT_ACCOUNT].[dbo].[TB_User] WHERE JID = @UserJID
IF (@GMLevel IS NULL OR (@GMLevel > 6 AND @GMLevel < 10))
BEGIN
RAISERROR('Account ID associated with this char: %s, does not have GM prvileges. Sequence canceled!', 1, 16, @AccountName)
RETURN -3
END
*/
-- Check character gender and race
DECLARE @CharGender VARCHAR(1)
DECLARE @CharRace VARCHAR(2)
PRINT 'Validating race and gender...'
IF (@RefCharID BETWEEN 1907 AND 1919) -- Chinesse Male
BEGIN
SET @CharRace = 'CH'
SET @CharGender = 'M'
END
IF (@RefCharID BETWEEN 1920 AND 1932) -- Chinesse Female
BEGIN
SET @CharRace = 'CH'
SET @CharGender = 'W'
END
IF (@RefCharID BETWEEN 14717 AND 14729) -- European Male
BEGIN
SET @CharRace = 'EU'
SET @CharGender = 'M'
END
IF (@RefCharID BETWEEN 14730 AND 14742) -- European Female
BEGIN
SET @CharRace = 'EU'
SET @CharGender = 'W'
END
PRINT 'Race code is: ' + @CharRace + ', gender code is: ' + @CharGender + '.'
-- Setting up equipment
-- Gears
DECLARE @CodeNameHelm VARCHAR(256)
DECLARE @CodeNameMail VARCHAR(256)
DECLARE @CodeNameShoulder VARCHAR(256)
DECLARE @CodeNameGauntlet VARCHAR(256)
DECLARE @CodeNamePants VARCHAR(256)
DECLARE @CodeNameBoots VARCHAR(256)
DECLARE @RefHelmID INT
DECLARE @RefMailID INT
DECLARE @RefShoulderID INT
DECLARE @RefGauntletID INT
DECLARE @RefPantsID INT
DECLARE @RefBootsID INT
DECLARE @RefHelmLinkID INT
DECLARE @RefMailLinkID INT
DECLARE @RefShoulderLinkID INT
DECLARE @RefGauntletLinkID INT
DECLARE @RefPantsLinkID INT
DECLARE @RefBootsLinkID INT
-- Accessories
DECLARE @CodeNameEarring VARCHAR(256)
DECLARE @CodeNameNecklace VARCHAR(256)
DECLARE @CodeNameRing VARCHAR(256)
DECLARE @RefEarringID INT
DECLARE @RefNecklaceID INT
DECLARE @RefRingID INT
DECLARE @RefEarringLinkID INT
DECLARE @RefNecklaceLinkID INT
DECLARE @RefRingLinkID INT
-- Weapon and Shield
DECLARE @CodeNameWeapon VARCHAR(256)
DECLARE @CodeNameShield VARCHAR(256)
DECLARE @RefWeaponID INT
DECLARE @RefShieldID INT
DECLARE @RefWeaponLinkID INT
DECLARE @RefShieldLinkID INT
-- GM Uniform + Devil Spirit
DECLARE @CodeNameUniform VARCHAR(256)
DECLARE @CodeNameDS VARCHAR(256)
DECLARE @RefUniformID INT
DECLARE @RefDSID INT
DECLARE @RefUniformLinkID INT
DECLARE @RefDSLinkID INT
/* Update 2013/11/05 */
-- Check for current equipped weapon/shield
PRINT 'Validating equipped weapon...'
DECLARE @OldWeaponID INT = (SELECT ItemID FROM [_Inventory] WHERE CharID=(SELECT CharID FROM [_Char] WHERE CharID = @CharID) AND Slot ='6')
IF (@OldWeaponID IS NULL OR @OldWeaponID = 0)
BEGIN
RAISERROR('Character: %s is not wearing any weapon. Sequence canceled!', 10, 1, @CharName)
RETURN -4
END
DECLARE @RefOldWeaponID INT = (SELECT RefItemID FROM [_Items] WHERE ID64 = @OldWeaponID)
DECLARE @WPClass VARCHAR(16)
SELECT @WPClass =
CASE
WHEN TypeID4 = 2 THEN 'SWORD'
WHEN TypeID4 = 3 THEN 'BLADE'
WHEN TypeID4 = 4 THEN 'SPEAR'
WHEN TypeID4 = 5 THEN 'TBLADE'
WHEN TypeID4 = 6 THEN 'BOW'
WHEN TypeID4 = 7 THEN 'SWORD'
WHEN TypeID4 = 8 THEN 'TSWORD'
WHEN TypeID4 = 9 THEN 'AXE'
WHEN TypeID4 = 10 THEN 'DARKSTAFF'
WHEN TypeID4 = 11 THEN 'TSTAFF'
WHEN TypeID4 = 12 THEN 'CROSSBOW'
WHEN TypeID4 = 13 THEN 'DAGGER'
WHEN TypeID4 = 14 THEN 'HARP'
WHEN TypeID4 = 15 THEN 'STAFF'
END
FROM [_RefObjCommon] WHERE [Service] = 1 AND ID = @RefOldWeaponID ORDER BY TypeID4 ASC
/* Update 2013/11/05 */
-- Set no shield by default, if the weapon used is 1H, then add shield automatically.
PRINT 'Checking if character is using shield...'
DECLARE @useShield TINYINT = 0
IF (@WPClass = 'SWORD' OR @WPClass = 'BLADE' OR @WPClass = 'STAFF')
BEGIN
PRINT '- 1H weapon is used, new shield will be added.'
SET @useShield = 1
END
/* Update 2013/11/05 */
-- Item codes (trailing codes are from itemSuffix settings above)
PRINT 'Setting up item codenames...'
-- Gears
SET @CodeNameHelm = 'ITEM_' + @CharRace + '_' + @CharGender + '_' + @EQClass + '_' + @EQDegree + '_CA_' + @GearSuffix
SET @CodeNameMail = 'ITEM_' + @CharRace + '_' + @CharGender + '_' + @EQClass + '_' + @EQDegree + '_BA_' + @GearSuffix
SET @CodeNameShoulder = 'ITEM_' + @CharRace + '_' + @CharGender + '_' + @EQClass + '_' + @EQDegree + '_SA_' + @GearSuffix
SET @CodeNameGauntlet = 'ITEM_' + @CharRace + '_' + @CharGender + '_' + @EQClass + '_' + @EQDegree + '_AA_' + @GearSuffix
SET @CodeNamePants = 'ITEM_' + @CharRace + '_' + @CharGender + '_' + @EQClass + '_' + @EQDegree + '_LA_' + @GearSuffix
SET @CodeNameBoots = 'ITEM_' + @CharRace + '_' + @CharGender + '_' + @EQClass + '_' + @EQDegree + '_FA_' + @GearSuffix
-- Accessories
SET @CodeNameEarring = 'ITEM_' + @CharRace + '_EARRING_' + @EQDegree + '_' + @GearSuffix
SET @CodeNameNecklace = 'ITEM_' + @CharRace + '_NECKLACE_' + @EQDegree + '_' + @GearSuffix
SET @CodeNameRing = 'ITEM_' + @CharRace + '_RING_' + @EQDegree + '_' + @GearSuffix
-- Weapon and Shield
SET @CodeNameWeapon = 'ITEM_' + @CharRace + '_' + @WPClass + '_' + @EQDegree + '_' + @GearSuffix
SET @CodeNameShield = 'ITEM_' + @CharRace + '_SHIELD_' + @EQDegree + '_' + @GearSuffix
-- GM Uniform + Devil Spirit
SET @CodeNameUniform = 'ITEM_ETC_AVATAR_' + @CharGender + '_' + @uniSuffix
SET @CodeNameDS = 'ITEM_MALL_AVATAR_' + @CharGender + '_' + @DSSuffix
-- Get Reference ID and Link ID
PRINT 'Getting item reference ID and link...'
-- Gears
SELECT @RefHelmID = ID, @RefHelmLinkID = link FROM [_RefObjCommon] WHERE [Service] = 1 AND CodeName128 = @CodeNameHelm
SELECT @RefMailID = ID, @RefMailLinkID = link FROM [_RefObjCommon] WHERE [Service] = 1 AND CodeName128 = @CodeNameMail
SELECT @RefShoulderID = ID, @RefShoulderLinkID = link FROM [_RefObjCommon] WHERE [Service] = 1 AND CodeName128 = @CodeNameShoulder
SELECT @RefGauntletID = ID, @RefGauntletLinkID = link FROM [_RefObjCommon] WHERE [Service] = 1 AND CodeName128 = @CodeNameGauntlet
SELECT @RefPantsID = ID, @RefPantsLinkID = link FROM [_RefObjCommon] WHERE [Service] = 1 AND CodeName128 = @CodeNamePants
SELECT @RefBootsID = ID, @RefBootsLinkID = link FROM [_RefObjCommon] WHERE [Service] = 1 AND CodeName128 = @CodeNameBoots
-- Accessories
SELECT @RefEarringID = ID, @RefEarringLinkID = link FROM [_RefObjCommon] WHERE [Service] = 1 AND CodeName128 = @CodeNameEarring
SELECT @RefNecklaceID = ID, @RefNecklaceLinkID = link FROM [_RefObjCommon] WHERE [Service] = 1 AND CodeName128 = @CodeNameNecklace
SELECT @RefRingID = ID, @RefRingLinkID = link FROM [_RefObjCommon] WHERE [Service] = 1 AND CodeName128 = @CodeNameRing
-- Weapon and Shield
SELECT @RefWeaponID = ID, @RefWeaponLinkID = link FROM [_RefObjCommon] WHERE [Service] = 1 AND CodeName128 = @CodeNameWeapon
SELECT @RefShieldID = ID, @RefShieldLinkID = link FROM [_RefObjCommon] WHERE [Service] = 1 AND CodeName128 = @CodeNameShield
-- GM Uniform + Devil Spirit
SELECT @RefUniformID = ID, @RefUniformLinkID = link FROM [_RefObjCommon] WHERE [Service] = 1 AND CodeName128 = @CodeNameUniform
SELECT @RefDSID = ID, @RefDSLinkID = link FROM [_RefObjCommon] WHERE [Service] = 1 AND CodeName128 = @CodeNameDS
IF (
@RefHelmID IS NULL OR @RefHelmID = 0 OR
@RefMailID IS NULL OR @RefMailID = 0 OR
@RefShoulderID IS NULL OR @RefShoulderID = 0 OR
@RefGauntletID IS NULL OR @RefGauntletID = 0 OR
@RefPantsID IS NULL OR @RefPantsID = 0 OR
@RefBootsID IS NULL OR @RefBootsID = 0 OR
@RefEarringID IS NULL OR @RefEarringID = 0 OR
@RefNecklaceID IS NULL OR @RefNecklaceID = 0 OR
@RefRingID IS NULL OR @RefRingID = 0 OR
@RefWeaponID IS NULL OR @RefWeaponID = 0 OR
@RefShieldID IS NULL OR @RefShieldID = 0 OR
@RefUniformID IS NULL OR @RefUniformID = 0 OR
@RefDSID IS NULL OR @RefDSID = 0
)
BEGIN
RAISERROR('Invalid item reference ID, check item codename (degree parameter or item suffix setting). Sequence canceled!', 1, 16)
RETURN -5
END
IF (
@RefHelmLinkID IS NULL OR @RefHelmLinkID = 0 OR
@RefMailLinkID IS NULL OR @RefMailLinkID = 0 OR
@RefShoulderLinkID IS NULL OR @RefShoulderLinkID = 0 OR
@RefGauntletLinkID IS NULL OR @RefGauntletLinkID = 0 OR
@RefPantsLinkID IS NULL OR @RefPantsLinkID = 0 OR
@RefBootsLinkID IS NULL OR @RefBootsLinkID = 0 OR
@RefEarringLinkID IS NULL OR @RefEarringLinkID = 0 OR
@RefNecklaceLinkID IS NULL OR @RefNecklaceLinkID = 0 OR
@RefRingLinkID IS NULL OR @RefRingLinkID = 0 OR
@RefWeaponLinkID IS NULL OR @RefWeaponLinkID = 0 OR
@RefShieldLinkID IS NULL OR @RefShieldLinkID = 0 OR
@RefUniformLinkID IS NULL OR @RefUniformLinkID = 0 OR
@RefDSLinkID IS NULL OR @RefDSLinkID = 0
)
BEGIN
RAISERROR('Invalid link reference ID, check item codename (degree parameter or item suffix setting). Sequence canceled!', 1, 16)
RETURN -6
END
-- Get durability for 'Data'
PRINT 'Getting items durability information...'
DECLARE @DuraHelm INT = (SELECT Dur_L from [_RefObjItem] WHERE ID = @RefHelmLinkID)
DECLARE @DuraMail INT = (SELECT Dur_L from [_RefObjItem] WHERE ID = @RefMailLinkID)
DECLARE @DuraShoulder INT = (SELECT Dur_L from [_RefObjItem] WHERE ID = @RefShoulderLinkID)
DECLARE @DuraGauntlet INT = (SELECT Dur_L from [_RefObjItem] WHERE ID = @RefGauntletLinkID)
DECLARE @DuraPants INT = (SELECT Dur_L from [_RefObjItem] WHERE ID = @RefPantsLinkID)
DECLARE @DuraBoots INT = (SELECT Dur_L from [_RefObjItem] WHERE ID = @RefBootsLinkID)
DECLARE @DuraWeapon INT = (SELECT Dur_L from [_RefObjItem] WHERE ID = @RefWeaponLinkID)
DECLARE @DuraShield INT = (SELECT Dur_L from [_RefObjItem] WHERE ID = @RefShieldLinkID)
/* Update 2013/11/05 */
-- Clear inventory (Just equipped items) ;)
PRINT 'Removing equipped items...'
DECLARE @TSlots INT
DECLARE @CharSlot INT
SET @CharSlot = 0
SELECT @TSlots = COUNT(Slot) from _Inventory WHERE CharID = @CharID
WHILE @CharSlot <= @TSlots
BEGIN
-- IF (@CharSlot < 6 OR (@CharSlot > 7 AND @CharSlot < 13))
-- IF (@CharSlot < 13)
-- BEGIN
EXEC [_STRG_DEL_ITEM_NoTX] 1, @CharID, @CharSlot
-- END
SET @CharSlot = @CharSlot + 1
END
-- Sequence begin
BEGIN TRANSACTION
PRINT 'Adding new items...'
-- Add other stuff (make sure they\'re exist in database and Media)
EXEC [_ADD_ITEM_EXTERN] @CharName, 'ITEM_ETC_E090930_SPEED_UP_SUPER_SCROLL', 50, 0
EXEC [_ADD_ITEM_EXTERN] @CharName, 'ITEM_MALL_REVERSE_RETURN_SCROLL', 50, 0
EXEC [_ADD_ITEM_EXTERN] @CharName, 'ITEM_MALL_RETURN_SCROLL_HIGH_SPEED', 50, 0
PRINT '- Cool stuff added to inventory.'
-- Add new equipment to equipment slots
DECLARE @HelmItemID64 BIGINT
DECLARE @MailItemID64 BIGINT
DECLARE @ShoulderItemID64 BIGINT
DECLARE @GauntletItemID64 BIGINT
DECLARE @PantsItemID64 BIGINT
DECLARE @BootsItemID64 BIGINT
DECLARE @EarringItemID64 BIGINT
DECLARE @NecklaceItemID64 BIGINT
DECLARE @RingLItemID64 BIGINT
DECLARE @RingRItemID64 BIGINT
DECLARE @WeaponItemID64 BIGINT
DECLARE @ShieldItemID64 BIGINT
DECLARE @UniformItemID64 BIGINT
DECLARE @DSItemID64 BIGINT
SET @HelmItemID64 = 0
SET @MailItemID64 = 0
SET @ShoulderItemID64 = 0
SET @GauntletItemID64 = 0
SET @PantsItemID64 = 0
SET @BootsItemID64 = 0
SET @EarringItemID64 = 0
SET @NecklaceItemID64 = 0
SET @RingLItemID64 = 0
SET @RingRItemID64 = 0
SET @WeaponItemID64 = 0
SET @ShieldItemID64 = 0
SET @UniformItemID64 = 0
SET @DSItemID64 = 0
-- Helm
EXEC @HelmItemID64 = [_FN_ADD_INITIAL_EQUIP] @CharID, 0, @RefHelmID, @DuraHelm
IF (@HelmItemID64 <= 0)
BEGIN
PRINT 'Problem when executing [_FN_ADD_INITIAL_EQUIP], canceling sequence and rolling back data...'
ROLLBACK TRANSACTION
RETURN -7
END
PRINT '- Helm equipped.'
-- Chest
EXEC @MailItemID64 = [_FN_ADD_INITIAL_EQUIP] @CharID, 1, @RefMailID, @DuraMail
IF (@MailItemID64 <= 0)
BEGIN
PRINT 'Problem when executing [_FN_ADD_INITIAL_EQUIP], canceling sequence and rolling back data...'
ROLLBACK TRANSACTION
RETURN -8
END
PRINT '- Chest equipped.'
-- Shoulder
EXEC @ShoulderItemID64 = [_FN_ADD_INITIAL_EQUIP] @CharID, 2, @RefShoulderID, @DuraShoulder
IF (@ShoulderItemID64 <= 0)
BEGIN
PRINT 'Problem when executing [_FN_ADD_INITIAL_EQUIP], canceling sequence and rolling back data...'
ROLLBACK TRANSACTION
RETURN -9
END
PRINT '- Shoulder equipped.'
-- Gauntlet
EXEC @GauntletItemID64 = [_FN_ADD_INITIAL_EQUIP] @CharID, 3, @RefGauntletID, @DuraGauntlet
IF (@GauntletItemID64 <= 0)
BEGIN
PRINT 'Problem when executing [_FN_ADD_INITIAL_EQUIP], canceling sequence and rolling back data...'
ROLLBACK TRANSACTION
RETURN -10
END
PRINT '- Gauntlet equipped.'
-- Pants
EXEC @PantsItemID64 = [_FN_ADD_INITIAL_EQUIP] @CharID, 4, @RefPantsID, @DuraPants
IF (@PantsItemID64 <= 0)
BEGIN
PRINT 'Problem when executing [_FN_ADD_INITIAL_EQUIP], canceling sequence and rolling back data...'
ROLLBACK TRANSACTION
RETURN -11
END
PRINT '- Pants equipped.'
-- Boots
EXEC @BootsItemID64 = [_FN_ADD_INITIAL_EQUIP] @CharID, 5, @RefBootsID, @DuraBoots
IF (@BootsItemID64 <= 0)
BEGIN
PRINT 'Problem when executing [_FN_ADD_INITIAL_EQUIP], canceling sequence and rolling back data...'
ROLLBACK TRANSACTION
RETURN -12
END
PRINT '- Boots equipped.'
-- Earring
EXEC @EarringItemID64 = [_FN_ADD_INITIAL_EQUIP] @CharID, 9, @RefEarringID, 0
IF (@EarringItemID64 <= 0)
BEGIN
PRINT 'Problem when executing [_FN_ADD_INITIAL_EQUIP], canceling sequence and rolling back data...'
ROLLBACK TRANSACTION
RETURN -13
END
PRINT '- Earring equipped.'
-- Necklace
EXEC @NecklaceItemID64 = [_FN_ADD_INITIAL_EQUIP] @CharID, 10, @RefNecklaceID, 0
IF (@NecklaceItemID64 <= 0)
BEGIN
PRINT 'Problem when executing [_FN_ADD_INITIAL_EQUIP], canceling sequence and rolling back data...'
ROLLBACK TRANSACTION
RETURN -14
END
PRINT '- Necklace equipped.'
-- Left Ring
EXEC @RingLItemID64 = [_FN_ADD_INITIAL_EQUIP] @CharID, 11, @RefRingID, 0
IF (@RingLItemID64 <= 0)
BEGIN
PRINT 'Problem when executing [_FN_ADD_INITIAL_EQUIP], canceling sequence and rolling back data...'
ROLLBACK TRANSACTION
RETURN -15
END
PRINT '- Left Ring equipped.'
-- Right Ring
EXEC @RingRItemID64 = [_FN_ADD_INITIAL_EQUIP] @CharID, 12, @RefRingID, 0
IF (@RingRItemID64 <= 0)
BEGIN
PRINT 'Problem when executing [_FN_ADD_INITIAL_EQUIP], canceling sequence and rolling back data...'
ROLLBACK TRANSACTION
RETURN -16
END
PRINT '- Right Ring equipped.'
-- Weapon
EXEC @WeaponItemID64 = [_FN_ADD_INITIAL_EQUIP] @CharID, 6, @RefWeaponID, @DuraWeapon
IF (@WeaponItemID64 <= 0)
BEGIN
PRINT 'Problem when executing [_FN_ADD_INITIAL_EQUIP], canceling sequence and rolling back data...'
ROLLBACK TRANSACTION
RETURN -17
END
PRINT '- Weapon equipped.'
-- Shield
IF (@useShield = 1)
BEGIN
EXEC @ShieldItemID64 = [_FN_ADD_INITIAL_EQUIP] @CharID, 7, @RefShieldID, @DuraShield
IF (@ShieldItemID64 <= 0)
BEGIN
PRINT 'Problem when executing [_FN_ADD_INITIAL_EQUIP], canceling sequence and rolling back data...'
ROLLBACK TRANSACTION
RETURN -18
END
PRINT '- Shield equipped.'
END
-- GM uniform
PRINT '- GM uniform added to inventory.'
EXEC @UniformItemID64 = [_ADD_ITEM_EXTERN] @CharName, @CodeNameUniform, 1, 0
IF (@UniformItemID64 <= 0)
BEGIN
PRINT 'Problem when executing [_ADD_ITEM_EXTERN], canceling sequence and rolling back data...'
ROLLBACK TRANSACTION
RETURN -19
END
-- Devil Spirit
PRINT '- Devil Spirit added to inventory.'
EXEC @DSItemID64 = [_ADD_ITEM_EXTERN] @CharName, @CodeNameDS, 1, 10
IF (@DSItemID64 <= 0)
BEGIN
PRINT 'Problem when executing [_ADD_ITEM_EXTERN], canceling sequence and rolling back data...'
ROLLBACK TRANSACTION
RETURN -20
END
-- Make 100% and FB
-- Gears
PRINT 'Updating gear attributes to +' + CAST(@EQPlus AS VARCHAR(2)) + ' FB (Str/Int 7, Parry 60%, Durability 200%)'
UPDATE _Items SET OptLevel = @EQPlus, Variance = 34359738336, MagParamNum = 4, MagParam1 = 30064771144, MagParam2 = 30064771150, MagParam3 = 858993459290, MagParam4 = 257698037898, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 = @HelmItemID64 OR ID64 = @MailItemID64 OR ID64 = @ShoulderItemID64 OR ID64 = @GauntletItemID64 OR ID64 = @PantsItemID64 OR ID64 = @BootsItemID64
PRINT '- Adding extra blue attributes to Chest: HP recovery/MP recovery 210%'
UPDATE _Items SET MagParamNum = 5, MagParam5 = 901943132463 WHERE ID64 = @MailItemID64
-- Accessories
PRINT 'Updating accessory attributes to +' + CAST(@EQPlus AS VARCHAR(2)) + ' FB (Str/Int 7, Freeze 20%, Electric Shock 20%, Burn 20%, Poison 20%, Zombie 20%)'
UPDATE _Items SET OptLevel = @EQPlus, Variance = 1073741823, MagParamNum = 7, MagParam1 = 30064771144, MagParam2 = 30064771150, MagParam3 = 85899346100, MagParam4 = 85899346094, MagParam5 = 85899346088, MagParam6 = 85899346106, MagParam7 = 85899346112, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 = @EarringItemID64 OR ID64 = @NecklaceItemID64 OR ID64 = @RingLItemID64 OR ID64 = @RingRItemID64
PRINT '- Adding extra blue attributes to Earring: CombustionProbability 50% Reduce, SleepProbability 50% Reduce'
UPDATE _Items SET MagParamNum = 9, MagParam8 = 214748365115, MagParam9 = 214748365139 WHERE ID64 = @EarringItemID64
PRINT '- Adding extra blue attributes to Necklace: StunProbability 50% Reduce'
UPDATE _Items SET MagParamNum = 8, MagParam8 = 47244640547 WHERE ID64 = @NecklaceItemID64
PRINT '- Adding extra blue attributes to Rings: DiseaseProbability 25% Reduce, FearProbability 25% Reduce'
UPDATE _Items SET MagParamNum = 9, MagParam8 = 107374182751, MagParam9 = 107374182727 WHERE ID64 = @RingLItemID64 OR ID64 = @RingRItemID64
-- Weapon
PRINT 'Updating weapon attributes to +' + CAST(@EQPlus AS VARCHAR(2)) + ' FB (Str/Int 7, Block 100, Attack Rate 60%, Durability 200%)'
UPDATE _Items SET OptLevel = @EQPlus, Variance = 34359738336, MagParamNum = 5, MagParam1 = 30064771144, MagParam2 = 30064771150, MagParam3 = 858993459290, MagParam4 = 429496729714, MagParam5 = 257698037862, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 = @WeaponItemID64
PRINT '- Adding extra blue attributes to Weapon: Critical 3'
UPDATE _Items SET MagParamNum = 6, MagParam6 = 12884902155 WHERE ID64 = @WeaponItemID64
-- Shield
IF (@ShieldItemID64 IS NOT NULL OR @ShieldItemID64 > 0)
BEGIN
PRINT 'Updating shield attributes to +' + CAST(@EQPlus AS VARCHAR(2)) + ' FB (Str/Int 7, Critical 100, Durability 200%)'
UPDATE _Items SET OptLevel = @EQPlus, Variance = 34359738336, MagParamNum = 4, MagParam1 = 30064771144, MagParam2 = 30064771150, MagParam3 = 858993459290, MagParam4 = 429496729726, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 = @ShieldItemID64
END
-- Devil Spirit
PRINT 'Updating Devil Spirit attributes to +10 FB (10% Damage increase to unique)'
UPDATE _Items SET OptLevel = 10, MagParamNum = 1, MagParam1 = 42949673313 WHERE ID64 = @DSItemID64
-- Set other attributes
PRINT 'Adding Stat, Gold, SP, Inventory size...'
UPDATE [_Char] SET Strength = @Strength, Intellect = @Intellect, RemainGold = @RemainGold, RemainSkillPoint = @RemainSkillPoint, InventorySize = @InventorySize WHERE CharID = @CharID
-- Set maximum level and mastery
PRINT 'Setting maximum level and skill masteries...'
DECLARE @CharLevel TINYINT = (SELECT TOP 1 Lvl FROM [_RefLevel] ORDER BY Lvl DESC)
DECLARE @ExpOffset BIGINT = (SELECT Exp_C FROM [XEON_VT_SHARD].[dbo].[_RefLevel] WHERE Lvl = @CharLevel)
UPDATE [_Char] SET RemainStatPoint = 0, CurLevel = @CharLevel, MaxLevel = @CharLevel, ExpOffset = @ExpOffset WHERE CharID = @CharID
UPDATE [_CharSkillMastery] SET [Level] = @CharLevel WHERE CharID = @CharID
-- Adding title
PRINT 'Adding GM title...'
UPDATE [_Char] SET HwanLevel = @HwanLevel WHERE CharID = @CharID
-- _TimedJob
PRINT 'Cleaning _TimedJob and _TimedJobForPet records...'
DELETE FROM [_TimedJob] WHERE CharID = @CharID
DELETE FROM [_TimedJobForPet] WHERE CharID = @CharID
PRINT 'Adding Gift Silk...'
UPDATE [XEON_VT_ACCOUNT].[dbo].[SK_Silk] SET [silk_gift] = @GiftSilk WHERE JID = @UserJID
COMMIT TRANSACTION
PRINT 'Sequence complete.'
RETURN 1
-- EOF
* Don't forget to change the Database name!
You can run it with EXEC [dbo].[_ADD_GM_GEAR] 'charname', 'TYPE', <degree>, <plus> <-- put degree 9 or 8 or something, it doesn't matter as long as the representative code exists, it works ;)Quote:
Originally Posted by P0kemonMast
Yes, thank you for this, but where's the fix? you forgot to put comments on the lines you modified :PQuote:
Originally Posted by blacksheep25
Or was it the remark on GM check sequence?