[Release] How to add WebName from textdata_equip

[theminkman]

Hello

I saw a lot of releases for ItemName in database but nobody showed how to get your current servers items into the database. This tutorial will be step by step.

Requirements

• Notepad++
• PK2 extractor path (media/server_dep)
• file textdata_equip&skill.txt

First part
Open your database on SRO_VT_SHARD and press design table on _RefObjCommon and add WebName128 with varchar(129) and allow NULL, click table column and save after you did this.




Second part
Open your file textdata_equip&skill.txt with notepad++

Replace this



^ Repeat this for all symbols (below)

1. ?
2. (
3. )
4. '

Find what:
(^.*);(.*?$)

Replace with:
UPDATE _RefObjCommon SET WebName128 = '\2'  WHERE NameStrID128='\1'

Now when you are done and followed all images you should have a ready to use QUERY to insert into your database.



Link for all pictures used in this tutorial


My query (working)



If you have any problem feel free to contact me on discord

[MeteorSro]

Originally Posted by theminkman

Hello

I saw a lot of releases for ItemName in database but nobody showed how to get your current servers items into the database. This tutorial will be step by step.

Requirements

• Notepad++
• PK2 extractor path (media/server_dep)
• file textdata_equip&skill.txt

First part
Open your database on SRO_VT_SHARD and press design table on _RefObjCommon and add WebName128 with varchar(129) and allow NULL, click table column and save after you did this.




Second part
Open your file textdata_equip&skill.txt with notepad++

Replace this



^ Repeat this for all symbols (below)

1. ?
2. (
3. )
4. '

Find what:
(^.*);(.*?$)

Replace with:
UPDATE _RefObjCommon SET WebName128 = '\2'  WHERE NameStrID128='\1'

Now when you are done and followed all images you should have a ready to use QUERY to insert into your database.



Link for all pictures used in this tutorial


My query (working)



If you have any problem feel free to contact me on discord

what the point for that "webname" !!

[m1xawy]

very helpful bro < 3

[theminkman]

Originally Posted by MeteorSro

what the point for that "webname" !!

For website item display, you need Name of item from Media.pk2

Edit
Avatars are in txt file textdata_object.txt and not textdata_equip&skill.txt but you can use same guide for this.

Here is my avatar query: