Available Kingdoms with no assigned regions

[Enoc-GitHub]

When creating a character, one can choose from many Kingdoms, but some of those Kingdoms have no assigned regions.

This was tested with Kingdom of Scotland.

Map status:

Database situation:

Kingdom is created

Capital Region is not properly assigned to Kingdom (assigned to 37 "Independant")

====================== List of broken Kingdoms.

[Enoc-GitHub]

SOLUTION:

Assign to Kingdom of Scotland: UPDATE regions SET kingdom_id = '19' WHERE name = 'regions.lothian';

It takes a few seconds/minutes but at some point DB refreshes and changes are visible in the game.

SQL Statements to fix all Kingdoms: UPDATE regions SET kingdom_id = '19' WHERE name = 'regions.lothian'; UPDATE regions SET kingdom_id = '28' WHERE name = 'regions.lisboa'; UPDATE regions SET kingdom_id = '18' WHERE name = 'regions.london'; UPDATE regions SET kingdom_id = '34' WHERE name = 'regions.sjaelland'; UPDATE regions SET kingdom_id = '39' WHERE name = 'regions.konigsberg'; UPDATE regions SET kingdom_id = '45' WHERE name = 'regions.bursa'; UPDATE regions SET kingdom_id = '25' WHERE name = 'regions.brugge';

[jeffreypicard]

Fixed.