Ask: How to add socket stone lower than D11?

[hoanghaihcns]

I have a D9 server, I want to engrave socket stones on D8 and D9 items. I added 3 to Param20 in Objitem but it didn't help. Anyone who knows how to solve this problem please help me. Thank you !

[Judgelemental]

Originally Posted by hoanghaihcns

I have a D9 server, I want to engrave socket stones on D8 and D9 items. I added 3 to Param20 in Objitem but it didn't help. Anyone who knows how to solve this problem please help me. Thank you !

This probably requires reverse engineering and I doubt it's only a database-side edit.

[sarkoplata]

sro_client: 0x0059F4B2
rest is database work, afaik there's no check on gs side.

[VORTEX*]

Originally Posted by hoanghaihcns

I have a D9 server, I want to engrave socket stones on D8 and D9 items. I added 3 to Param20 in Objitem but it didn't help. Anyone who knows how to solve this problem please help me. Thank you !

there's many solution , in your situation the easiest one to make new socket skills in _refSkill then control item operation from SRO_VT_SHARD.._AddLogItem

to add Require data here _BindingOptionWithItem

nOptID = RefSkill ID
nParam1 = _refobjcommon ID

But this solution will not be like original one i mean those sockets will add to item by operation not Alchemy window

[lidzy]

you can create procedure to work as original one
and use filter to use scroll system gender

[JohnDornel^]

Originally Posted by sarkoplata

sro_client: 0x0059F4B2
rest is database work, afaik there's no check on gs side.

Change the degree here.

Originally Posted by VORTEX*

there's many solution , in your situation the easiest one to make new socket skills in _refSkill then control item operation from SRO_VT_SHARD.._AddLogItem

to add Require data here _BindingOptionWithItem

nOptID = RefSkill ID
nParam1 = _refobjcommon ID

But this solution will not be like original one i mean those sockets will add to item by operation not Alchemy window

Do not do this.


Get any item 11DG that can have socket stones (chest/weapon) > ITEM_CH_SWORD_11_A_RARE, take it's link from objcommon, open objitem and use the link as ID to find the item's properties. If I remember correctly it was param20 that you have to put "3" or I guess the amount of socket stones you'd like to have on that specific item (probably 4 would be the limit). So.. Take the item you wanna test with, edit it the same way the 11dg item is and it should work (after you have done the sro_client.exe edit). When you are happy with your single item, you can group all the items you want to have sockets on by their typeids(1,2,3,4) and mass apply it.

Edit: If you want to make items that usually do not have sockets to support them, you will have to edit the socket stones as well to be able to support that item type.

[VORTEX*]

Originally Posted by JohnDornel^

Do not do this.

Get any item 11DG that can have socket stones (chest/weapon) > ITEM_CH_SWORD_11_A_RARE, take it's link from objcommon, open objitem and use the link as ID to find the item's properties. If I remember correctly it was param20 that you have to put "3" or I guess the amount of socket stones you'd like to have on that specific item (probably 4 would be the limit). So.. Take the item you wanna test with, edit it the same way the 11dg item is and it should work (after you have done the sro_client.exe edit). When you are happy with your single item, you can group all the items you want to have sockets on by their typeids(1,2,3,4) and mass apply it.

Edit: If you want to make items that usually do not have sockets to support them, you will have to edit the socket stones as well to be able to support that item type.

Lol !!! he will not edit anything the socket will be added by Procedure only !! no needed Paramtrash or anything ..

[JohnDornel^]

Originally Posted by VORTEX*

Lol !!! he will not edit anything the socket will be added by Procedure only !! no needed Paramtrash or anything ..

Why would you go out of your way to achieve something similar to the original, when you can just properly configure it and make it work as it should? Not even going to talk about performance issues...

[VORTEX*]

Originally Posted by JohnDornel^

Why would you go out of your way to achieve something similar to the original, when you can just properly configure it and make it work as it should? Not even going to talk about performance issues...

bro it's not show area , and i'm not fighting i told him there's many ways .... check my comment again .

[JohnDornel^]

Originally Posted by VORTEX*

Lol !!! he will not edit anything the socket will be added by Procedure only !! no needed Paramtrash or anything ..

Originally Posted by VORTEX*

bro it's not show area , and i'm not fighting i told him there's many ways .... check my comment again .

We are going offtopic, but if you don't want to pick fights, maybe don't disrespect other's opinion in such way. I did quote you and said to not do this and then provided a good enough argument why. Your argument is "no needed paramtrash"?

[Over56]

Originally Posted by hoanghaihcns

I have a D9 server, I want to engrave socket stones on D8 and D9 items. I added 3 to Param20 in Objitem but it didn't help. Anyone who knows how to solve this problem please help me. Thank you !

heres your needs

used query

UPDATE IT
SET Param20 = 3
FROM
SRO_VT_SHARD.._RefObjCommon co 
join _RefObjItem it on it.ID=co.Link where 
CodeName128 like '%ITEM_%_%_%_%_RARE'
AND CodeName128 NOT LIKE '%CLOTHES%'AND 
CodeName128 NOT LIKE'%LIGHT%'AND 
CodeName128 NOT LIKE'%HEAVY%'AND 
CodeName128 NOT LIKE'%RING%'AND 
CodeName128 NOT LIKE'%NECK%'
and ReqLevel1 < 100 and it.Param20=0 and co.Service = 1

used offset

0059F4B0

result in short clip

[Athena']

Originally Posted by Over56

heres your needs

used query

UPDATE IT
SET Param20 = 3
FROM
SRO_VT_SHARD.._RefObjCommon co 
join _RefObjItem it on it.ID=co.Link where 
CodeName128 like '%ITEM_%_%_%_%_RARE'
AND CodeName128 NOT LIKE '%CLOTHES%'AND 
CodeName128 NOT LIKE'%LIGHT%'AND 
CodeName128 NOT LIKE'%HEAVY%'AND 
CodeName128 NOT LIKE'%RING%'AND 
CodeName128 NOT LIKE'%NECK%'
and ReqLevel1 < 100 and it.Param20=3 and co.Service = 1

used offset

0059F4B0

result in short clip

Now that's useful, i'll try to dig a little bit into that and see if i could actually crate custom params for the sockets. For example Lucky probability and stuff like that, could be interesting, thanks for your contribution.

[nemo08]

set Param20 = 3 for items u need