[Release] How to add WebName from textdata_equip

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

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

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

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

Quote:

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. [Only registered and activated users can see links. Click Here To Register...] Second part Open your file textdata_equip&skill.txt with notepad++ Replace this [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] ^ Repeat this for all symbols (below) ? ( ) ' [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] Code: Find what: (^.*);(.*?$) Replace with: UPDATE _RefObjCommon SET WebName128 = '\2' WHERE NameStrID128='\1' [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] Now when you are done and followed all images you should have a ready to use QUERY to insert into your database. [Only registered and activated users can see links. Click Here To Register...] Link for all pictures used in this tutorial [Only registered and activated users can see links. Click Here To Register...] My query (working) [Only registered and activated users can see links. Click Here To Register...] If you have any problem feel free to contact me on discord :feelsgoodman:

Quote:

Originally Posted by MeteorSro what the point for that "webname" !!