[Release] 2 small queries

[Anonymous-6723]

Adding total 254 lines in _RefHWANLevel

DECLARE @lvl varchar(5),
		@titlech varchar(100),
		@titleeu varchar(100)
SET @lvl = 7
WHILE (@lvl < 255)
BEGIN
SET @titlech = 'UIO_SECOND_HWAN_CH_NAME_LEVEL_' + @lvl
SET @titleeu = 'UIO_SECOND_HWAN_EU_NAME_LEVEL_' + @lvl
INSERT INTO _RefHwanLevel (HwanLevel, ParamFourcc1, ParamValue1, ParamFourcc2, ParamValue2, ParamFourcc3, ParamValue3, ParamFourcc4, ParamValue4, ParamFourcc5, ParamValue5, AssocFileObj128, Title_CH70, Title_EU70)
VALUES (@lvl, 1397769301, 200, 1145127506, 35,0,0,0,0,0,0,'xxx',@titlech,@titleeu)
SET @lvl = @lvl + 1
END

Item to mob drop

DECLARE @RefMonsterID INT,
		@RefItemID INT,
		@DropMin INT,
		@DropMax INT,
		@DropRatio INT,
		@MobCodeName varchar(128),
		@ItemCodeName varchar(128);
-- SETTINGS --
SET @MobCodeName = 'MonsterCodeName' --Which monster will drop the item
SET @ItemCodeName = 'ItemCodeName' --Which item you want to be dropped
SET @DropMin = 0 --Minimum items if it has to drop how many of them they will be
SET @DropMax = 0 --Maximum items if it has to drop how many of them they can be
SET @DropRatio = 1 -- Drop rate (based on % success/fail if it will drop or not the item that is added) 1 = 100% / 0.05 = 5% / 0.5 = 50%
-- SETTINGS --
SELECT @RefMonsterID = ID FROM _RefObjCommon with(NOLOCK) where CodeName128 = @MobCodeName
SELECT @RefItemID = ID FROM _RefObjCommon with(NOLOCK) where codename128 = @ItemCodeName
INSERT INTO _RefMonster_AssignedItemDrop (RefMonsterID,RefItemID,DropGroupType,OptLevel,DropAmountMin,DropAmountMax,DropRatio,RefMagicOptionID1,CustomValue1,RefMagicOptionID2,CustomValue2,RefMagicOptionID3,CustomValue3,RefMagicOptionID4,CustomValue4,RefMagicOptionID5,CustomValue5,RefMagicOptionID6,CustomValue6,RefMagicOptionID7,CustomValue7,RefMagicOptionID8,CustomValue8,RefMagicOptionID9,CustomValue9,RentCodeName) VALUES
(@RefMonsterID,@RefItemID,0,0,@DropMin,@DropMax,@DropRatio,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')

Might add more later..

[PortalDark]

#Approved

[Kaizen_]

krall release bro keep going till you hit the wall tralalala
love you menz MUAAAAAA
hahahaha :P

[Justin1337*]

Originally Posted by Kaizen_

krall release bro keep going till you hit the wall tralalala
love you menz MUAAAAAA
hahahaha :P

qay.

[Anonymous-6723]

Trolls.. I am trying here to help the "community". But dats hopeless I swear.. :/

[sarkoplata]

wow the code bbcode is updated while i wasnt here

[Anonymous-6723]

Originally Posted by sarkoplata

wow the code bbcode is updated while i wasnt here

Glad you are back WB

[jhoan3d]

i need query remove spaw mobs from jupiter etc city please help

[Anonymous-6723]

Originally Posted by jhoan3d

i need query remove spaw mobs from jupiter etc city please help

delete from Tab_refnest where dwTacticsID in (SELECT dwTacticsID FROM Tab_Reftactics where dwobjid in (select ID from _refobjcommon where codename128 like 'MOB_ARABIA%'))

this should work, if we assume that all the arabian mobs start with MOB_ARABIA

[Kadhras_TR]

Great

[​Exo]

Originally Posted by jhoan3d

i need query remove spaw mobs from jupiter etc city please help

PHP Code:

Use this to remove anyshit from RefNest

USE SRO_VT_SHARD
DECLARE      @RefID int
SELECT       @RefID = R.dwTacticsID
FROM   Tab_RefTactics R
JOIN    _RefObjCommon O
ON           O.ID = R.dwObjID
WHERE O.CodeName128 LIKE 'CodeName128'

DELETE FROM Tab_RefNest WHERE dwTacticsID = @RefID 


[Syloxx]

Originally Posted by xExorcist

Use this to remove anyshit from RefNest

USE SRO_VT_SHARD
DECLARE @RefID int
SELECT @RefID = R.dwTacticsID
FROM Tab_RefTactics R
JOIN _RefObjCommon O
ON O.ID = R.dwObjID
WHERE O.CodeName128 LIKE 'CodeName128'
DELETE FROM Tab_RefNest WHERE dwTacticsID = @RefID

never used DELETE and JOIN in 1 statement?

DECLARE	@CodeName VARCHAR(129) = 'INSERT_CODENAME_HERE'

DELETE	TRN
FROM	Tab_RefTactics TRT
JOIN	_RefObjCommon ROC
ON		TRT.dwObjID = ROC.ID
JOIN	Tab_RefNest TRN
ON		TRT.dwTacticsID = TRN.dwTacticsID
WHERE	ROC.CodeName128 LIKE @CodeName

[​Exo]

Originally Posted by Syloxx

never used DELETE and JOIN in 1 statement?

DECLARE	@CodeName VARCHAR(129) = 'INSERT_CODENAME_HERE'

DELETE	TRN
FROM	Tab_RefTactics TRT
JOIN	_RefObjCommon ROC
ON		TRT.dwObjID = ROC.ID
JOIN	Tab_RefNest TRN
ON		TRT.dwTacticsID = TRN.dwTacticsID
WHERE	ROC.CodeName128 LIKE @CodeName

***** please -_- , since there's only 1 ID for every codename there's no problem in using it..

[Syloxx]

Originally Posted by xExorcist

***** please -_- , since there's only 1 ID for every codename there's no problem in using it..

yes but why u use like then?

if i place something like MOB_CH% your query will give a error

smt like "a variable can only contain one value"

[​Exo]

Originally Posted by Syloxx

yes but why u use like then?

if i place something like MOB_CH% your query will give a error

smt like "a variable can only contain one value"

Okay then use = instead of like [problem solved] wasn't meant to be used for more than a value, why like? cuz I didn't remember any npc code so i used it @ mine while testing cuz i had a npc with smth like ;****; so i used LIKE '%****%', laziness ftw!