Ask: How to add socket stone lower than D11?

10/28/2023 10:20 hoanghaihcns#1
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 !
10/28/2023 11:11 Judgelemental#2
Quote:
Originally Posted by hoanghaihcns View Post
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.
10/29/2023 00:52 sarkoplata#3
sro_client: 0x0059F4B2
rest is database work, afaik there's no check on gs side.
10/29/2023 16:21 VORTEX*#4
Quote:
Originally Posted by hoanghaihcns View Post
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
10/30/2023 07:45 lidzy#5
you can create procedure to work as original one
and use filter to use scroll system gender
10/31/2023 10:47 JohnDornel^#6
Quote:
Originally Posted by sarkoplata View Post
sro_client: 0x0059F4B2
rest is database work, afaik there's no check on gs side.
Change the degree here.

Quote:
Originally Posted by VORTEX* View Post
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.
10/31/2023 11:23 VORTEX*#7
Quote:
Originally Posted by JohnDornel^ View Post

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 ..:)
10/31/2023 11:47 JohnDornel^#8
Quote:
Originally Posted by VORTEX* View Post
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...
10/31/2023 20:23 VORTEX*#9
Quote:
Originally Posted by JohnDornel^ View Post
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 .
10/31/2023 21:00 JohnDornel^#10
Quote:
Originally Posted by VORTEX* View Post
Lol !!! he will not edit anything the socket will be added by Procedure only !! no needed Paramtrash or anything ..:)
Quote:
Originally Posted by VORTEX* View Post
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"?
11/02/2023 00:04 Over56#11
Quote:
Originally Posted by hoanghaihcns View Post
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

Code:
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

Code:
0059F4B0
result in short clip

11/02/2023 00:07 Athena'#12
Quote:
Originally Posted by Over56 View Post
heres your needs

used query

Code:
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

Code:
0059F4B0
result in short clip

[Only registered and activated users can see links. Click Here To Register...]
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.
11/04/2023 18:35 nemo08#13
set Param20 = 3 for items u need