Non-Player Race Types

[Jabantiz]

Committed the code I have, basically just to load the stuff from the DB, commented out for now until a table is decided on, currently I just renamed John's and added a field

Code: Select all

CREATE TABLE `race_types` (
	`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	`category` VARCHAR(64) NULL DEFAULT NULL COLLATE 'latin1_general_ci',
	`subcategory` VARCHAR(64) NULL DEFAULT NULL COLLATE 'latin1_general_ci',
	`model_type` INT(10) UNSIGNED NOT NULL,
	`model_name` VARCHAR(250) NULL DEFAULT NULL COLLATE 'latin1_general_ci',
	`race_id` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
	PRIMARY KEY (`id`),
	INDEX `NewIndex1` (`model_type`)
)
COLLATE='latin1_general_ci'
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
CHECKSUM=1;

Haven't put it or the data on the patcher until we determine a table. FYI, only info the code uses from the table is model_type and race_id

[John Adams]

That's fine, my table is only for eq2 DB editor stuff. it can remain a project-only table and we use yours.

Do you need Download Enabled on that race data?

[Jabantiz]

Yea, this data will be mostly static I think, just getting it all set up correctly in the first place is going to suck.

[Jabantiz]

Added the table in my last post to the DB patcher, no data yet though. Also added all 3 of the lua functions.

[thefoof]

woot