- Joined
- Oct 25, 2007
- Messages
- 120
- Reaction score
- 16
was able to get my server workin and it is because of you people so i am sharing this for those who are struggling to activate 12D on there servers
-make a backup on your original text datas just in case
-copy data.pk2 and particles.pk2 from isro and paste it to your vsro folder*
-open pk2 editor and import all three files to server_dep\silkroad\textdata*
-and make sure you activated the files server side*
(go to SRO_VT_SHARD - dbo._RefObjCommon and put "1" on service column on all 12D item)
-*and last, make sure import icons to your media.pk2 as well.. you can find the icons inside media pk2... i believe all of you can take it from here..
and here is a query where you can automatically update your services from "0" to "1"
right click on SRO_VT_SHARD and then New Query
Query Script: (i know it's a noob script but it will help some)
please tell me if i missed somthing..
To view the content, you need to sign in or register
OR
To view the content, you need to sign in or register
(password: ragezone)v5 update:
complete itemdata with all normal/Sox 12 Degree items
note: incase it doesnt work u can overwrite it with v4.. havnt tested it if it will work SMC..
all you need to do isv4 update:
-should fix everything now, but i havnt tested on each item, dont have much time xD
-should work with both SMC and media.pk2
-just tell me if you're still having errors because everything is working fine on my end
-make a backup on your original text datas just in case
-copy data.pk2 and particles.pk2 from isro and paste it to your vsro folder*
-open pk2 editor and import all three files to server_dep\silkroad\textdata*
-and make sure you activated the files server side*
(go to SRO_VT_SHARD - dbo._RefObjCommon and put "1" on service column on all 12D item)
-*and last, make sure import icons to your media.pk2 as well.. you can find the icons inside media pk2... i believe all of you can take it from here..

and here is a query where you can automatically update your services from "0" to "1"
right click on SRO_VT_SHARD and then New Query
Query Script: (i know it's a noob script but it will help some)
UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU%'
UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH%'
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 8994 AND 9005
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9008 AND 9025
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9028 AND 9045
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9048 AND 9065
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9068 AND 9085
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9088 AND 9105
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9114 AND 9125
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9134 AND 9145
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9154 AND 9225
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID = 38620
SET Service = 1
WHERE CodeName128 like '%ITEM_EU%'
UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH%'
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 8994 AND 9005
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9008 AND 9025
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9028 AND 9045
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9048 AND 9065
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9068 AND 9085
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9088 AND 9105
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9114 AND 9125
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9134 AND 9145
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9154 AND 9225
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID = 38620

please tell me if i missed somthing..
Last edited: