MAGPARAM VALUES

09/11/2015 17:22 spinal2#1

Someone Know values from MAGPARAM Values for AVATAR and JOBSUITS ?

09/12/2015 00:56 WickedNite.#2

You put them on the items and find out yourself from smc? Some people are even lazy to think.

Although job suits support only 2 blues, when I get home in the morning I can share the params for str/int.

09/12/2015 01:02 spinal2#3

Quote:

Originally Posted by TheWickedNite

You put them on the items and find out yourself from smc? Some people are even lazy to think.

Although job suits support only 2 blues, when I get home in the morning I can share the params for str/int.

Thanks .. share plz .. i want too ADD blues in AVATAR FLAG.. in RefScrappackageitem take Gameserver Crash when add ...

09/12/2015 01:29 WickedNite.#4

That's because each item has its own params, not all of them work for each item.

09/12/2015 02:23 Eslam Galull#5

i didnt try add dif. blues on avatars than the basics from the smith

about Job Suits & other caps this may helps you

Code:

	    IF (@ItemRefID = 42880 ) -- JOB Suits & Caps Max Blue Scrolls
		BEGIN
		IF  (Select Level From SRO_VT_SHARD.dbo._CharTrijob Where CharID = @CharID ) = 7
		BEGIN
				UPDATE SRO_VT_SHARD.dbo._Items set MagParamNum='8',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='5583457484950',MagParam4= '5583457484962',MagParam5='257698037898',MagParam6='85899346100',MagParam7='85899346106',MagParam8='85899346088' WHERE ID64 IN (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot = '8')
				END
ELSE
BEGIN
				Declare @charN Varchar(64) = ( Select CharName16 FROM SRO_VT_SHARD.dbo._Char Where Charid = @CharID )
				 insert _PmSystem(Sent, Message, ToPlayer) values(0,'You didnt match the required Rule to use this scroll ( Job Level Must Be Level 7),You Will not get the scroll back' , @charN)
				 END
				END

09/12/2015 03:43 spinal2#6

Quote:

Originally Posted by its.soul

i didnt try add dif. blues on avatars than the basics from the smith

about Job Suits & other caps this may helps you

Code:

	    IF (@ItemRefID = 42880 ) -- JOB Suits & Caps Max Blue Scrolls
		BEGIN
		IF  (Select Level From SRO_VT_SHARD.dbo._CharTrijob Where CharID = @CharID ) = 7
		BEGIN
				UPDATE SRO_VT_SHARD.dbo._Items set MagParamNum='8',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='5583457484950',MagParam4= '5583457484962',MagParam5='257698037898',MagParam6='85899346100',MagParam7='85899346106',MagParam8='85899346088' WHERE ID64 IN (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot = '8')
				END
ELSE
BEGIN
				Declare @charN Varchar(64) = ( Select CharName16 FROM SRO_VT_SHARD.dbo._Char Where Charid = @CharID )
				 insert _PmSystem(Sent, Message, ToPlayer) values(0,'You didnt match the required Rule to use this scroll ( Job Level Must Be Level 7),You Will not get the scroll back' , @charN)
				 END
				END

What About Query to create Tab _PmSystem and Declare options to @ItemRefID ?

.

09/12/2015 05:07 Royalblade*#7

Quote:

Originally Posted by its.soul

i didnt try add dif. blues on avatars than the basics from the smith

about Job Suits & other caps this may helps you

Code:

	    IF (@ItemRefID = 42880 ) -- JOB Suits & Caps Max Blue Scrolls
		BEGIN
		IF  (Select Level From SRO_VT_SHARD.dbo._CharTrijob Where CharID = @CharID ) = 7
		BEGIN
				UPDATE SRO_VT_SHARD.dbo._Items set MagParamNum='8',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='5583457484950',MagParam4= '5583457484962',MagParam5='257698037898',MagParam6='85899346100',MagParam7='85899346106',MagParam8='85899346088' WHERE ID64 IN (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot = '8')
				END
ELSE
BEGIN
				Declare @charN Varchar(64) = ( Select CharName16 FROM SRO_VT_SHARD.dbo._Char Where Charid = @CharID )
				 insert _PmSystem(Sent, Message, ToPlayer) values(0,'You didnt match the required Rule to use this scroll ( Job Level Must Be Level 7),You Will not get the scroll back' , @charN)
				 END
				END

Dont use this. That dude is an idiot who doesn't know how to write queries. He's lower than 7th graders.

Seriously its.soul... since you are stupid, stop sharing your idiotic shit with others. Let them learn properly.

First of all.. there are tables which let you put BLUES on items right from the start.

Go for SELECT * FROM sys.objects WHERE name LIKE '%param1%' and find the table.
Then add your shitty blues there.

Learn how to learn, not simply solve ur crap on the fly.

09/12/2015 06:30 spinal2#8

Any Last SMC can add and edit AVATAR like Golden Flag and SUITS JOBS ?

Quote:

Originally Posted by Royalblade*

Dont use this. That dude is an idiot who doesn't know how to write queries. He's lower than 7th graders.

Seriously its.soul... since you are stupid, stop sharing your idiotic shit with others. Let them learn properly.

First of all.. there are tables which let you put BLUES on items right from the start.

Go for SELECT * FROM sys.objects WHERE name LIKE '%param1%' and find the table.
Then add your shitty blues there.

Learn how to learn, not simply solve ur crap on the fly.

if i add one skill type in _RefSkill with thats param like str/int 6 atk rat 60% and parry rate 60% ??

any idea how make to it work?