On the Mod Problem of World of Warships(My question)
xwxslash
#0 : 04.11.2023 15:03
What software should be used to import geometry format models (game extraction)? I have tried Blender, but it has not been successful.
I heard they are all encrypted models, is that true? How should I encrypt the modules after they are completed?
May I ask everyone, can ANSYS be used to edit geometry?
Thank you very much!!! I really want to learn how to make Mod!
xwxslash
#1 : 04.11.2023 15:25
I have already opened geometry and saved it as obj, but how can I save the changed obj as geometry again......? I still need to learn more......
Мастер Моделей
#2 : 05.11.2023 06:45
Unfortunately, I'm only parsing the game files. I don’t know how to save models back, because I only get the parts I need, ignoring other information, and I don’t have complete data on model formats.
xwxslash
#3 : 05.11.2023 11:23
Unfortunately, I'm only parsing the game files. I don’t know how to save models back, because I only get the parts I need, ignoring other information, and I don’t have complete data on model formats.
Okay, thank you for replying to me,There seems to be no similar tutorial available on the internet at present...><
734526071
#4 : 08.11.2023 17:13
What software should be used to import geometry format models (game extraction)? I have tried Blender, but it has not been successful.
I heard they are all encrypted models, is that true? How should I encrypt the modules after they are completed?
May I ask everyone, can ANSYS be used to edit geometry?
Thank you very much!!! I really want to learn how to make Mod!
WOTModelMod.v0.3 . Try it
xwxslash
#5 : 11.11.2023 14:31
What software should be used to import geometry format models (game extraction)? I have tried Blender, but it has not been successful.
I heard they are all encrypted models, is that true? How should I encrypt the modules after they are completed?
May I ask everyone, can ANSYS be used to edit geometry?
Thank you very much!!! I really want to learn how to make Mod!
WOTModelMod.v0.3 . Try it
Your help was very much appreciated !!! I'll give it a try now
xwxslash
#6 : 11.11.2023 17:13
WOTModelMod.v0.3 . Try it
unfortunately, sir, it failed......
xwxslash
#7 : 11.11.2023 17:16
I will use ANSYS and Rocky DEM tomorrow to see if they can convert obj format to geometry format
xwxslash
#8 : 12.11.2023 04:41
I think I have some understanding. The geometry format seems to have to be converted using Java code
The data needs to be converted to. wkt format using Java, and then to. wkb format in the database. Finally, the spatial field type needs to be modified to. geometry type
Here is the code↓
package com.piesat.test;
import cn.hutool.poi.excel.ExcelReader;
import cn.hutool.poi.excel.ExcelUtil;
import cn.hutool.poi.excel.ExcelWriter;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.junit.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
@SpringBootTest
public class ljwTest {
@Autowired
@Test
public void test() throws IOException {
String filePath = "C:\\Users\\HTHT\\Desktop\\czt_xdcddqtglxx.xlsx";
FileInputStream inputStream = new FileInputStream(filePath);
ExcelReader reader = ExcelUtil.getReader(inputStream);
Workbook workbook = reader.getWorkbook();
Sheet sheetAt = workbook.getSheetAt(0);
int lastRowNum = sheetAt.getLastRowNum();
Row row1 = sheetAt.getRow(0);
Cell cell1 = row1.getCell(39);
String ss1 = "geom";
Cell head = row1.createCell(39);
head.setCellValue(ss1);
for (int i = 1;i<lastRowNum;i++){
Row row = sheetAt.getRow(i);
Cell cell = row.getCell(12);
String s1= "LINESTRING("+cell.toString().replace(","," ")+')';
String s2 = s1.replace(";",",");
Cell add = row.createCell(39);
add.setCellValue(s2);
}
ExcelWriter writer = reader.getWriter();
writer.flush(new File("C:\\Users\\HTHT\\Desktop\\test.xlsx"));
inputStream.close();
reader.close();
}
}
The general meaning of the code is to add a geom field after Excel, clean the latitude and longitude into wkt format, and store it in the geom field
After cleaning, import Excel into the database:
update table table_name set geom = st_geometryfromtext(geom)
Convert data to wkb format:
alter table table_name alter column field_name type geometry using field_name::geometry
Set the database fields to geometry before updating the data:
update table table_name set geom = st_geometryfromtext(geom)
xwxslash
#9 : 12.11.2023 04:51
Although it may seem unrelated to the model file, it can be used to determine the conversion program......Wait for me to study for a while before I come back
xwxslash
#10 : 12.11.2023 07:13
Great, I have found a detailed tutorial
https://www.bilibili.com/video/BV1dN411a7QN
734526071
#11 : 03.12.2023 01:26
太好了,我找到了详细的教程
https://www.bilibili.com/video/BV1dN411a7QN
lol