char_create_combinations (Vah Shir)

[strugglegenerator]

Thank you chrsschb.

Since I've already removed Vah Shir, Drakkin and Froglok from the char_create_combinations table, I'm left with a lot of unnecessary ID's in the char_create_point_allocations table.

I've been trying to figure out which ID's in the char_create_point_allocations table are for Vah Shir, Drakkin and Froglok so I can remove them, but it's proving to be quite difficult.

I made a list of all the ID's that are still in use in the char_create_combinations table and compared that to the 108 rows of char_create_point_allocation ID's that are still existing and I found that the following ID's do not exist in my char_create_combinations table, so I THINK I can safely delete them from char_create_point_allocations and achieve my desired result of no selectable Vah Shir, Drakkin or Froglok during the "Random" race selection of character select:

ID's that I THINK I need to remove from char_create_point_allocations are:
0, 1, 12, 59, 65, 66, 69, 70, 71, 75, 76, 77, 78, 79, 80, 86-108

Does this sound right or am I way off? I couldn't find a good resource that cross referenced the two tables together, so this is the best I could come up with.

[strugglegenerator]

Ok I think I figured it out after looking at my original database from back in June 2019 before I removed any of the races or classes in the char_create_combinations table. My research indicates that the following ID's in the char_create_combinations table will corresponding to the correct ID's in the char_create_point_allocations table for removing Vah Shir, Drakkin, Frogloks, Berserkers and Beastlords:

Vah Shir (Race ID 130)
Remove the following ID's from char_create_point_allocations table:
75-80

Froglok (Race ID 330)
Remove the following ID's from char_create_point_allocations table:
86-93

Drakkin (Race ID 522)
Remove the following ID's from char_create_point_allocations table:
94-106

Beastlord/Berserker
Remove the following ID's from char_create_point_allocations table:
0, 1, 12, 59, 65, 70, 71, 76, 77