Author Topic: Using official art?  (Read 507 times)

owen_a

  • Traveller
  • *
  • Posts: 27
    • View Profile
Using official art?
« on: November 16, 2011, 05:47:19 pm »
Hello all,

I've tried using the official art for my work server, and I've not had success. Character creating shows a black outline of the character you pick, but does not display the model, and if you do pick someone, you show as a dwarf in-game.
Any ideas?

Thanks!

Talad

  • Administrator
  • Hydlaa Notable
  • *
  • Posts: 798
    • View Profile
Re: Using official art?
« Reply #1 on: November 16, 2011, 08:35:53 pm »
By official art you mean the one taken from the released client? if you see a dwarf means it's using it, because svn art doesn't contain the dwarf but just a dummy boxed char. I'm not sure svn contains the proper definitions for char creation. You can join #planeshift-build and ask there.

Aiwendil

  • Hydlaa Citizen
  • *
  • Posts: 463
    • View Profile
Re: Using official art?
« Reply #2 on: November 17, 2011, 08:15:41 am »
The table "race_info" has several different races setup in the SVN version....but all have the same "cstr_mesh" set: "stonebm". In case you want different races to use different models you have to adjust this table and setup the correct mesh for each race (Also this table contains a lot of other mesh relevant infos like what helm mesh should be used).
Quote from: src/server/database/mysql/race_info.sql
CREATE TABLE `race_info` (
...
  `cstr_mesh` varchar(200) NOT NULL DEFAULT '',
...
INSERT INTO `race_info` VALUES (0,'StoneBreaker','stonebm','M',0.8,1.2,0.6,'',100,50,50,50,50,50,50,1.5,1,10,10,0,0,'','','','','',0,-1,1);
INSERT INTO `race_info` VALUES (1,'Enkidukai','stonebm','M',0.8,1.4,0.6,'',100,50,50,50,50,50,50,1.5,1,10,10,0,0,'','','','','',1,-1,1);
INSERT INTO `race_info` VALUES (2,'Ynnwn','stonebm','M',0.8,1.4,0.6,'',100,50,50,50,50,50,50,1.5,1,10,10,0,0,'','','','','',2,-1,1);
INSERT INTO `race_info` VALUES (3,'Ylian','stonebm','M',0.8,1.4,0.6,'',100,50,50,50,50,50,50,1.5,1,10,10,0,0,'','','','','',3,-1,1);
INSERT INTO `race_info` VALUES (4,'Xacha','stonebm','M',0.8,1.4,0.6,'',100,50,50,50,50,50,50,1.5,1,10,10,0,0,'','','','','',4,-1,1);
...

The table "characters" defines the race for each char in "racegender_id" (Using the IDs from the "race_info" table). But still the correct mesh will only show up if you specified it in "race_info".
Quote from: src/server/database/mysql/characters.sql
...
CREATE TABLE `characters` (
...
  `racegender_id` smallint(5) unsigned NOT NULL default '0',
...
INSERT INTO `characters` VALUES (1,'Guest','Char','',0,0,144.00,40.00,44.00,40.00,40.00,40.00,0.00,100.00,0.00,100.00,216.00,200.00,34,40,10,134,100,100,100,100,0,3,-43.86,-0.01,-152.30,1.50,0,0,0,0,0,NULL,NULL,0,'0000-00-00 00:00:00','',0,0,'N',3,2604,0,180,18,'Was born in a jar','','','',10,'',0,'0000-00-00 00:00:00',0,0);
INSERT INTO `characters` VALUES (2,'Vengeance','IsMine','',0,0,300.00,60.00,60.00,60.00,60.00,60.00,0.00,280.00,0.00,120.00,200.00,200.00,34,40,10,134,0,0,0,0,0,3,-32.03,0.00,-154.36,0.49,0,0,0,0,0,NULL,NULL,0,'2006-11-29 21:55:15','',0,0,'N',1,14985,0,150,10,'Grew up on a ice mountain','','','',10,'<category attribute=\"Lifecycle\" name=\"Daylight\" value=\"10\" /><category attribute=\"Type\" name=\"Animal\" value=\"5\" />',3,'0000-00-00 00:00:00',0,0);
INSERT INTO `characters` VALUES (3,'Acraig','Newfie','',2,0,144.00,40.00,44.00,40.00,40.00,40.00,0.00,100.00,0.00,100.00,216.00,200.00,34,40,10,134,100,100,100,100,0,3,-61.32,-0.01,-187.16,0.00,0,0,0,0,0,NULL,NULL,0,'0000-00-00 00:00:00','',0,0,'N',5,3798,0,150,1000,'description','','','',1000,'',0,'0000-00-00 00:00:00',0,0);
...

Sorry, can't say anything about having "black" chars at the login screen...never had this problem. In general the content of the DB in SVN is not really very useful and will need a lot of adjustments to just get some basic things to work.

owen_a

  • Traveller
  • *
  • Posts: 27
    • View Profile
Re: Using official art?
« Reply #3 on: November 17, 2011, 01:24:45 pm »
Ok, I see what you mean about the database. However, what are the several different meshes I can choose from, If I'm using the SVN?

Aiwendil

  • Hydlaa Citizen
  • *
  • Posts: 463
    • View Profile
Re: Using official art?
« Reply #4 on: November 17, 2011, 01:46:51 pm »
That's a little bit more tricky question. First have a look in art/meshes.zip. (Always assuming now you use the offical PS art)

This file contains all meshes used by the client in a "compilied" formart. In case you are interested how these files really look like make yourself comfortable with the "doccomp" program from Crystal Space (http://www.crystalspace3d.org/docs/online/manual/Binary-XML.html). That program allows you to create XML files from the compilied PS meshes again.

But as you only want to know what meshes are available for character the filenames in meshes.zip should already help you enough. It's just a bit hard to make out what are char models and what just item models (btw..you can ignore the stuff in bindata for now). From a quick glance I get:
  • dermf
  • dermm
  • diabolif
  • diabolim
  • enkif
  • enkim
  • fynnwn
  • hammerwf
  • hammerwm
  • klyrosm
  • klyrosf
  • kran
  • lemurf
  • lemurm
  • nolthrirf
  • nolthrirm
  • stonebf
  • stonebm
  • ylianf
  • ylianm
  • ynnwnm
for chars.

Some other models like trepor, rogue or vulbar might also work with chars...no clue if missing animations are a problem there. And I guess models like diabolif and diabolim are just wrappers for the ynnwn models.

owen_a

  • Traveller
  • *
  • Posts: 27
    • View Profile
Re: Using official art?
« Reply #5 on: November 17, 2011, 02:30:14 pm »
Thank you very much. If I were to edit the race_info in the database with one of those names instead of stonebm, would I be able to see the char i selected if i selected it in-game? Oh, and which ones would be female?

EDIT: Oh, the ones with the f at the end are females if i'm correct?
« Last Edit: November 17, 2011, 02:33:49 pm by owen_a »

Aiwendil

  • Hydlaa Citizen
  • *
  • Posts: 463
    • View Profile
Re: Using official art?
« Reply #6 on: November 17, 2011, 02:33:56 pm »
Sorry, have to try it out. I think so....but not that sure. Long time since I used to offical art for my experiments.

owen_a

  • Traveller
  • *
  • Posts: 27
    • View Profile
Re: Using official art?
« Reply #7 on: November 17, 2011, 02:45:30 pm »
Yes, just tested it. It's female and male.

By the way, check your pm :P