|
You last visited: Today at 06:10
Advertisement
How to disable start item Hwan level?
Discussion on How to disable start item Hwan level? within the SRO Private Server forum part of the Silkroad Online category.
05/04/2016, 19:33
|
#1
|
elite*gold: 1
Join Date: Apr 2016
Posts: 198
Received Thanks: 64
|
How to disable start item Hwan level?
how title say i don;t know how to disable the start hwan level i start at 3 level Senior at Ch and baron at Eu , how can disabled it?
|
|
|
05/05/2016, 03:50
|
#2
|
elite*gold: 70
Join Date: May 2014
Posts: 206
Received Thanks: 20
|
SQL > SRO_VT_SHARD > Programmability >Stored Procedures > AddNewChar
scroll down till u find this :
PHP Code:
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, [COLOR="red"]HwanLevel[/COLOR]) VALUES (@RefCharID, [MENTION=3898309]charname[/MENTION], [MENTION=2018236]chars[/MENTION]cale, 20, 20, [MENTION=351783]start[/MENTION]RegionID, [MENTION=351783]start[/MENTION]Pos_X, [MENTION=351783]start[/MENTION]Pos_Y, [MENTION=351783]start[/MENTION]Pos_Z, [MENTION=312108]DeFauLt[/MENTION]Teleport, 109, GetDate(), 1, 1, 10000000, 0, 10000, 200,200, 1, 1, 1, 1, [COLOR="Red"]3[/COLOR])
The red one edit it to 0 if u wanna make your players start without titles
|
|
|
05/05/2016, 14:47
|
#3
|
elite*gold: 1
Join Date: Apr 2016
Posts: 198
Received Thanks: 64
|
loock what i have
PHP Code:
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, DailyPK) VALUES (@RefCharID, [MENTION=3898309]charname[/MENTION], [MENTION=2018236]chars[/MENTION]cale, 20, 20, [MENTION=351783]start[/MENTION]RegionID, [MENTION=351783]start[/MENTION]Pos_X, [MENTION=351783]start[/MENTION]Pos_Y, [MENTION=351783]start[/MENTION]Pos_Z, [MENTION=312108]DeFauLt[/MENTION]Teleport, 45, GetDate(), 1, 1, 1000000, 0, 1000000, 200,200, 1, 1, 1, 1, 50)
where i can cange no go't hwan at start?
|
|
|
05/05/2016, 18:32
|
#4
|
elite*gold: 70
Join Date: May 2014
Posts: 206
Received Thanks: 20
|
could u show me the fill procedure ?
|
|
|
05/05/2016, 18:58
|
#5
|
elite*gold: 1
Join Date: Apr 2016
Posts: 198
Received Thanks: 64
|
yea loock here .
PHP Code:
[SPOILER]USE [SRO_VT_SHARD] GO /****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 5/5/2016 7:15:00 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO ALTER PROCEDURE [dbo].[_AddNewChar] [MENTION=292919]user[/MENTION]JID INT, --@CharSlot INT, @RefCharID INT, @CharName varchar (64), @CharScale tinyINT, [MENTION=351783]start[/MENTION]RegionID INT, [MENTION=351783]start[/MENTION]Pos_X real, [MENTION=351783]start[/MENTION]Pos_Y real, [MENTION=351783]start[/MENTION]Pos_Z real, @DefaultTeleport INT, @RefMailID INT, @RefPantsID INT, @RefBootsID INT, @RefWeaponID INT, [MENTION=1830489]refs[/MENTION]hield INT, @DurMail tinyINT, @DurPants tinyINT, @DurBoots tinyINT, @DurWeapon tinyINT, @DurShield tinyINT, @DefaultArrow INT AS SET NOCOUNT ON DECLARE [MENTION=303108]slot[/MENTION] INT DECLARE [MENTION=337901]temp[/MENTION] INT DECLARE @NewCharID INT SET @NewCharID = 0 -- Initial Equip Edit by LemoniscooL DECLARE @RefHandID INT DECLARE @RefHatID INT DECLARE [MENTION=1830489]refs[/MENTION]houlderID INT DECLARE @RefEarringID INT DECLARE @RefRingID INT DECLARE @RefNeckID INT DECLARE @DurHand INT DECLARE @DurHat INT DECLARE @DurShoulder INT DECLARE @DurEarring INT DECLARE @DurRing INT DECLARE @DurNeck INT --Male Clothes Chinese IF (@RefMailID = 3643) BEGIN SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_01_AA_C_RARE') SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_01_BA_C_RARE') SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_01_FA_C_RARE') SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_01_HA_C_RARE') SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_01_LA_C_RARE') SET [MENTION=1830489]refs[/MENTION]houlderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_01_SA_C_RARE') SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_01_C_RARE') SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_01_C_RARE') SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_01_C_RARE') END --Male Heavy Armor Chinese IF (@RefMailID = 3637) BEGIN SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_01_AA_C_RARE') SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_01_BA_C_RARE') SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_01_FA_C_RARE') SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_01_HA_C_RARE') SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_01_LA_C_RARE') SET [MENTION=1830489]refs[/MENTION]houlderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_01_SA_C_RARE') SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_01_C_RARE') SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_01_C_RARE') SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_01_C_RARE') END --Male Light Armor Chinese IF (@RefMailID = 3640) BEGIN SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_01_AA_C_RARE') SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_01_BA_C_RARE') SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_01_FA_C_RARE') SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_01_HA_C_RARE') SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_01_LA_C_RARE') SET [MENTION=1830489]refs[/MENTION]houlderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_01_SA_C_RARE') SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_01_C_RARE') SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_01_C_RARE') SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_01_C_RARE') END --Female Clothes Chinese IF (@RefMailID = 3652) BEGIN SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_01_AA_C_RARE') SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_01_BA_C_RARE') SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_01_FA_C_RARE') SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_01_HA_C_RARE') SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_01_LA_C_RARE') SET [MENTION=1830489]refs[/MENTION]houlderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_01_SA_C_RARE') SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_01_C_RARE') SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_01_C_RARE') SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_01_C_RARE') END --Female Heavy Armor Chinese IF (@RefMailID = 3646) BEGIN SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_01_AA_C_RARE') SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_01_BA_C_RARE') SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_01_FA_C_RARE') SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_01_HA_C_RARE') SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_01_LA_C_RARE') SET [MENTION=1830489]refs[/MENTION]houlderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_01_SA_C_RARE') SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_01_C_RARE') SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_01_C_RARE') SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_01_C_RARE') END --Female Light Armor Chinese IF (@RefMailID = 3649) BEGIN SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_01_AA_C_RARE') SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_01_BA_C_RARE') SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_01_FA_C_RARE') SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_01_HA_C_RARE') SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_01_LA_C_RARE') SET [MENTION=1830489]refs[/MENTION]houlderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_01_SA_C_RARE') SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_01_C_RARE') SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_01_C_RARE') SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_01_C_RARE') END --Male Clothes Europe IF (@RefMailID = 11623) BEGIN SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_01_AA_C_RARE') SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_01_BA_C_RARE') SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_01_FA_C_RARE') SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_01_HA_C_RARE') SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_01_LA_C_RARE') SET [MENTION=1830489]refs[/MENTION]houlderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_01_SA_C_RARE') SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_01_C_RARE') SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_01_C_RARE') SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_01_C_RARE') END --Male Heavy Armor Europe IF (@RefMailID = 11617) BEGIN SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_01_AA_C_RARE') SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_01_BA_C_RARE') SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_01_FA_C_RARE') SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_01_HA_C_RARE') SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_01_LA_C_RARE') SET [MENTION=1830489]refs[/MENTION]houlderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_01_SA_C_RARE') SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_01_C_RARE') SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_01_C_RARE') SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_01_C_RARE') END --Male Light Armor Europe IF (@RefMailID = 11620) BEGIN SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_01_AA_C_RARE') SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_01_BA_C_RARE') SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_01_FA_C_RARE') SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_01_HA_C_RARE') SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_01_LA_C_RARE') SET [MENTION=1830489]refs[/MENTION]houlderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_01_SA_C_RARE') SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_01_C_RARE') SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_01_C_RARE') SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_01_C_RARE') END --Female Clothes Europe IF (@RefMailID = 11632) BEGIN SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_01_AA_C_RARE') SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_01_BA_C_RARE') SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_01_FA_C_RARE') SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_01_HA_C_RARE') SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_01_LA_C_RARE') SET [MENTION=1830489]refs[/MENTION]houlderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_01_SA_C_RARE') SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_01_C_RARE') SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_01_C_RARE') SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_01_C_RARE') END --Female Heavy Armor Europe IF (@RefMailID = 11626) BEGIN SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_01_AA_C_RARE') SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_01_BA_C_RARE') SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_01_FA_C_RARE') SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_01_HA_C_RARE') SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_01_LA_C_RARE') SET [MENTION=1830489]refs[/MENTION]houlderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_01_SA_C_RARE') SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_01_C_RARE') SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_01_C_RARE') SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_01_C_RARE') END --Female Light Armor Europe IF (@RefMailID = 11629) BEGIN SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_01_AA_C_RARE') SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_01_BA_C_RARE') SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_01_FA_C_RARE') SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_01_HA_C_RARE') SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_01_LA_C_RARE') SET [MENTION=1830489]refs[/MENTION]houlderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_01_SA_C_RARE') SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_01_C_RARE') SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_01_C_RARE') SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_01_C_RARE') END --Shield Chinese IF [MENTION=1830489]refs[/MENTION]hield = 10886) BEGIN SET [MENTION=1830489]refs[/MENTION]hield = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_SHIELD_01_C_RARE') END --Shield Europe IF [MENTION=1830489]refs[/MENTION]hield = 10896) BEGIN SET [MENTION=1830489]refs[/MENTION]hield = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_SHIELD_01_C_RARE') END --Blade Chinese IF (@RefWeaponID = 3633) BEGIN SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_BLADE_01_C_RARE') END --Bow Chinese IF (@RefWeaponID = 3636) BEGIN SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_BOW_01_C_RARE') END --Spear Chinese IF (@RefWeaponID = 3634) BEGIN SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_SPEAR_01_C_RARE') END --Sword Chinese IF (@RefWeaponID = 3632) BEGIN SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_SWORD_01_C_RARE') END --Glavie Chinese IF (@RefWeaponID = 3635) BEGIN SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_TBLADE_01_C_RARE') END --Axe Europe IF (@RefWeaponID = 10890) BEGIN SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_AXE_01_C_RARE') END --XBow Europe IF (@RefWeaponID = 10891) BEGIN SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_CROSSBOW_01_C_RARE') END --Dagger Europe IF (@RefWeaponID = 10887) BEGIN SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_DAGGER_01_C_RARE') END --Darkstaff Europe IF (@RefWeaponID = 10892) BEGIN SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_DARKSTAFF_01_C_RARE') END --Harp Europe IF (@RefWeaponID = 10894) BEGIN SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_HARP_01_C_RARE') END --Cleric Rod Europe IF (@RefWeaponID = 10895) BEGIN SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_STAFF_01_C_RARE') END --Sword Europe IF (@RefWeaponID = 10888) BEGIN SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_SWORD_01_C_RARE') END --Staff Europe IF (@RefWeaponID = 10893) BEGIN SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_TSTAFF_01_C_RARE') END --Twohand Sword Europe IF (@RefWeaponID = 10889) BEGIN SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_TSWORD_01_C_RARE') END --Select Durability SET @DurHand = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefHandID)) SET @DurMail = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefMailID)) SET @DurBoots = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefBootsID)) SET @DurHat = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefHatID)) SET @DurPants = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefPantsID)) SET @DurShoulder = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = [MENTION=1830489]refs[/MENTION]houlderID)) SET @DurWeapon = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefWeaponID)) SET @DurShield = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = [MENTION=1830489]refs[/MENTION]hield)) SET @DurEarring = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefEarringID)) SET @DurRing = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefRingID)) SET @DurNeck = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefNeckID)) -- Initial Equip Edit by LemoniscooL --set [MENTION=351783]start[/MENTION]RegionID=25000 ----------------------------------------------------------------------------- -- 1. ??? ?? ??? valid? ???, ??? ???? ??? ?? ????. ----------------------------------------------------------------------------- -- start by novice. SELECT [MENTION=337901]temp[/MENTION] = count(CharID) FROM _User WITH (NOLOCK) WHERE UserJID = [MENTION=292919]user[/MENTION]JID IF [MENTION=337901]temp[/MENTION] >= 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 [MENTION=337901]temp[/MENTION] = _IsExistingCharName @CharName IF [MENTION=337901]temp[/MENTION] <> 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, DailyPK) VALUES (@RefCharID, @CharName, @CharScale, 20, 20, [MENTION=351783]start[/MENTION]RegionID, [MENTION=351783]start[/MENTION]Pos_X, [MENTION=351783]start[/MENTION]Pos_Y, [MENTION=351783]start[/MENTION]Pos_Z, @DefaultTeleport, 45, GetDate(), 1, 1, 1000000, 0, 1000000, 200,200, 1, 1, 1, 1, 50) 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 [MENTION=292919]user[/MENTION]JID, @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!!! -- ???? ??? ???? ?? ????... /* ?? ??? ???? ??. 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, */ -- Initial Equip Edit by LemoniscooL DECLARE @ItemID BIGINT SET @ItemID = 0 -- Chest IF (@RefMailID <> 0) BEGIN EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 1, @RefMailID, @DurMail IF (@ItemID <= 0) BEGIN ROLLBACK TRANSACTION RETURN -8 END END -- Hand IF (@RefHandID <> 0) BEGIN EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 3, @RefHandID, @DurHand IF (@ItemID <= 0) BEGIN ROLLBACK TRANSACTION RETURN -8 END END -- Hat IF (@RefHatID <> 0) BEGIN EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 0, @RefHatID, @DurHat IF (@ItemID <= 0) BEGIN ROLLBACK TRANSACTION RETURN -8 END END -- Shoulder IF [MENTION=1830489]refs[/MENTION]houlderID <> 0) BEGIN EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 2, [MENTION=1830489]refs[/MENTION]houlderID, @DurShoulder IF (@ItemID <= 0) BEGIN ROLLBACK TRANSACTION RETURN -8 END END -- Pants 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 -- Shield IF [MENTION=1830489]refs[/MENTION]hield <> 0) BEGIN EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 7, [MENTION=1830489]refs[/MENTION]hield, @DurShield IF (@ItemID <= 0) BEGIN ROLLBACK TRANSACTION RETURN -12 END END -- Arror/Bolt IF (@DefaultArrow <> 0) BEGIN EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 7, @DefaultArrow, 250 IF (@ItemID <= 0) BEGIN ROLLBACK TRANSACTION RETURN -13 END END -- Earring IF (@RefEarringID <> 0) BEGIN EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 9, @RefEarringID, @DurEarring IF (@ItemID <= 0) BEGIN ROLLBACK TRANSACTION RETURN -8 END END -- Ring 1 IF (@RefRingID <> 0) BEGIN EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 11, @RefRingID, @DurRing IF (@ItemID <= 0) BEGIN ROLLBACK TRANSACTION RETURN -8 END END -- Ring 2 IF (@RefRingID <> 0) BEGIN EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 12, @RefRingID, @DurRing IF (@ItemID <= 0) BEGIN ROLLBACK TRANSACTION RETURN -8 END END -- Necklace IF (@RefNeckID <> 0) BEGIN EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 10, @RefNeckID, @DurNeck IF (@ItemID <= 0) BEGIN ROLLBACK TRANSACTION RETURN -8 END END -- Initial Equip Edit by LemoniscooL ----------------------------------------------------------------------------- -- 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_ETC_E060118_60EXP_HELP',1,1 exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E060118_100EXP_HELP',1,1 exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RETURN_SCROLL_HIGH_SPEED',20,1 exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HWAN_POTION',5,1 exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_REVERSE_RETURN_SCROLL',10,1 exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E090930_SPEED_UP_SUPER_SCROLL',10,1 exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RENT_DAMAGE_ABS_20P_SCROLL',3,1 exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RENT_DAMAGE_INC_20P_SCROLL',3,1 exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_COS_P_MYOWON_SCROLL',1,1 exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_NASRUN',3,1 exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_NASRUN',3,1 exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_ANGEL_WING_DRESS',1,1 exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_ANGEL_WING_DRESS',1,1 exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_MP_POTION_05',1000,1 exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_HP_POTION_05',1000,1 -- Quick Slot ?¤?¸ A?A??ë!!! exec _AddNewClientConfig @NewCharID -- by novice...... for saving client configurations... COMMIT TRANSACTION RETURN @NewCharID[/SPOILER]
|
|
|
05/05/2016, 19:16
|
#6
|
elite*gold: 70
Join Date: May 2014
Posts: 206
Received Thanks: 20
|
bro on txt and upload it please -_-
there are forum codes on the your PHP Code
|
|
|
05/05/2016, 19:58
|
#7
|
elite*gold: 1
Join Date: Apr 2016
Posts: 198
Received Thanks: 64
|
i no understand , put here or tell me here what happaned or what i have to change or to do Thanks you.
|
|
|
05/08/2016, 01:11
|
#8
|
elite*gold: 1
Join Date: Apr 2016
Posts: 198
Received Thanks: 64
|
UP!
up !!
|
|
|
05/08/2016, 01:41
|
#9
|
elite*gold: 0
Join Date: May 2016
Posts: 113
Received Thanks: 13
|
Use This and You Done
PHP Code:
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, DailyPK, HwanLevel) VALUES (@RefCharID, [MENTION=3898309]charname[/MENTION], [MENTION=2018236]chars[/MENTION]cale, 20, 20, [MENTION=351783]start[/MENTION]RegionID, [MENTION=351783]start[/MENTION]Pos_X, [MENTION=351783]start[/MENTION]Pos_Y, [MENTION=351783]start[/MENTION]Pos_Z, [MENTION=312108]DeFauLt[/MENTION]Teleport, 45, GetDate(), 1, 1, 1000000, 0, 1000000, 200,200, 1, 1, 1, 1, 50, 0)
|
|
|
05/08/2016, 01:43
|
#10
|
elite*gold: 1
Join Date: Apr 2016
Posts: 198
Received Thanks: 64
|
Thankkss now work !! Thankss you
|
|
|
Similar Threads
|
[HELP] How Disable ADV ELIX In a specific Item
07/21/2015 - SRO Private Server - 6 Replies
Hello All ..
Can someone Ask me How i can Disable ADVANCE ELIXIRS to use in a Specific Item . ?
I Want Disable ELixir to Use in ALL D10 SUNs Weap e Set ..
Someone know if is in _RefSkill and what Parameter ??
|
item disable
12/21/2014 - Flyff Private Server - 7 Replies
hi epvpers i have some problem when i create character and also when i login ingame
this is my problem
the equipment set is disable
thanks in advance
|
How to disable Item Mall ?
11/07/2013 - Shaiya Private Server - 3 Replies
Hey people :)
I'd like to know if there's a way to delete/disable the item mall in game.
(not being able to click on it and use it)
Thanks in advance. (i didn't find anything on elitepvpers)
Greetings c(=
|
All times are GMT +2. The time now is 06:10.
|
|