JFD
Kathigitarkh
Database triggers; they are my new friend, and soon, they can be yours too
Why must the formatting come out looking so terrible?
The INSERT statement will update any Civilizations loaded into the database before Historical Religions, whilst the trigger will catch any added after. Takes a bit more effort and time, but much more compatible, and stops those nasty database errors when a user doesn't have the civ in question enabled:
Although you could be using UPDATE instead of DELETE >> INSERT
In summary; convert to the one true code: SQL
Code:
--Visigoths
DELETE FROM Civilization_Religions WHERE CivilizationType = 'CIVILIZATION_VISIGOTHS_MOD';
INSERT INTO Civilization_Religions
(CivilizationType, ReligionType)
SELECT Type, ('RELIGION_FORN_SIDR')
FROM Civilizations WHERE Type = 'CIVILIZATION_VISIGOTHS_MOD';
CREATE TRIGGER CivilizationVisigoths
AFTER INSERT ON Civilizations WHEN 'CIVILIZATION_VISIGOTHS_MOD' = NEW.Type
BEGIN
INSERT INTO Leader_Flavors
(LeaderType, ReligionType)
VALUES ('CIVILIZATION_VISIGOTHS_MOD', 'RELIGION_FORN_SIDR');
END;
--Sumer
DELETE FROM Civilization_Religions WHERE CivilizationType = 'CIVILIZATION_AKKADIAN_MOD';
INSERT INTO Civilization_Religions
(CivilizationType, ReligionType)
SELECT Type, ('RELIGION_CHALDEANISM')
FROM Civilizations WHERE Type = 'CIVILIZATION_AKKADIAN_MOD';
CREATE TRIGGER CivilizationSumer
AFTER INSERT ON Civilizations WHEN 'CIVILIZATION_AKKADIAN_MOD' = NEW.Type
BEGIN
INSERT INTO Leader_Flavors
(LeaderType, ReligionType)
VALUES ('CIVILIZATION_AKKADIAN_MOD', 'RELIGION_CHALDEANISM');
END;
--Benin
DELETE FROM Civilization_Religions WHERE CivilizationType = 'CIVILIZATION_BENIN_MOD';
INSERT INTO Civilization_Religions
(CivilizationType, ReligionType)
SELECT Type, ('RELIGION_ITAN')
FROM Civilizations WHERE Type = 'CIVILIZATION_BENIN_MOD';
CREATE TRIGGER CivilizationBenin
AFTER INSERT ON Civilizations WHEN 'CIVILIZATION_BENIN_MOD' = NEW.Type
BEGIN
INSERT INTO Leader_Flavors
(LeaderType, ReligionType)
VALUES ('CIVILIZATION_BENIN_MOD', 'RELIGION_ITAN');
END;
--Garamantes
DELETE FROM Civilization_Religions WHERE CivilizationType = 'CIVILIZATION_ANCIENT_LIBYA_MOD';
INSERT INTO Civilization_Religions
(CivilizationType, ReligionType)
SELECT Type, ('RELIGION_PESEDJET')
FROM Civilizations WHERE Type = 'CIVILIZATION_ANCIENT_LIBYA_MOD';
CREATE TRIGGER CivilizationGaramantes
AFTER INSERT ON Civilizations WHEN 'CIVILIZATION_ANCIENT_LIBYA_MOD' = NEW.Type
BEGIN
INSERT INTO Leader_Flavors
(LeaderType, ReligionType)
VALUES ('CIVILIZATION_ANCIENT_LIBYA_MOD', 'RELIGION_PESEDJET');
END;
--Garamantes
DELETE FROM Civilization_Religions WHERE CivilizationType = 'CIVILIZATION_HITTITE_MOD';
INSERT INTO Civilization_Religions
(CivilizationType, ReligionType)
SELECT Type, ('RELIGION_LIIM_DINGERMES')
FROM Civilizations WHERE Type = 'CIVILIZATION_HITTITE_MOD';
CREATE TRIGGER CivilizationHittites
AFTER INSERT ON Civilizations WHEN 'CIVILIZATION_HITTITE_MOD' = NEW.Type
BEGIN
INSERT INTO Leader_Flavors
(LeaderType, ReligionType)
VALUES ('CIVILIZATION_HITTITE_MOD', 'RELIGION_LIIM_DINGERMES');
END;
--Harrapa
DELETE FROM Civilization_Religions WHERE CivilizationType = 'CIVILIZATION_HARAPPA_MOD';
INSERT INTO Civilization_Religions
(CivilizationType, ReligionType)
SELECT Type, ('RELIGION_AKATTU')
FROM Civilizations WHERE Type = 'CIVILIZATION_HARAPPA_MOD';
CREATE TRIGGER CivilizationHarappa
AFTER INSERT ON Civilizations WHEN 'CIVILIZATION_HARAPPA_MOD' = NEW.Type
BEGIN
INSERT INTO Leader_Flavors
(LeaderType, ReligionType)
VALUES ('CIVILIZATION_HARAPPA_MOD', 'RELIGION_AKATTU');
END;
Why must the formatting come out looking so terrible?
The INSERT statement will update any Civilizations loaded into the database before Historical Religions, whilst the trigger will catch any added after. Takes a bit more effort and time, but much more compatible, and stops those nasty database errors when a user doesn't have the civ in question enabled:
Spoiler :
Code:
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_VISIGOTHS_MOD" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_AKKADIAN_MOD" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_TIMURIDS_MOD" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_KIEVAN_RUS_MOD" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_BENIN_MOD" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_ANCIENT_LIBYA_MOD" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_HITTITE_MOD" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_MALI_MOD" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_HARAPPA_MOD" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_CHAMPA_MOD" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_SIOUX_MOD" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_NORTE_CHICO" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_KONGO_MOD" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_NAZCA" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_PHOENICIA" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_SAMI" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_BUCCANEER" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_QULLANA" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_TIWANAKU" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_MAPUCHE" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_TUPI" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_MUISCA" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_INUIT" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_NORWAY" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_HAIDA_MOD_LS" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_UKRAINE_LS_MOD" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_SIOUX_LS_MOD" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_PHOENICIA_MOD_LS" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_ASHANTI_LS_MOD" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_GALLIA_LS_MOD" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_TAHITI_LS_MOD" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_ZIMBABWE_LS_MOD" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_OLMEC_LS_MOD" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_LITHUANIA_LS_MOD" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_BULGARIA_LS_MOD" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_NUMIDIA_LS_MOD" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_HITTITE_LS_MOD" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_CHEROKEE_LS_MOD" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_ROMANIA_LS_MOD" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_SCYTHIA_LS_MOD" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_SPARTA_LS_MOD" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_ABORIGINAL" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_LITHUANIA" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_UYGHUR" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_MITANNI" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_ICENI" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_CORNWALL" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_IRELAND" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_PICTS" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_WALES" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_SELEUCID" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_SABA" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_NABATAEA" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_KILWA" does not exist in Civilizations
[61447.796] Invalid Reference on Civilization_Religions.CivilizationType - "CIVILIZATION_OMAN" does not exist in Civilizations
Although you could be using UPDATE instead of DELETE >> INSERT
In summary; convert to the one true code: SQL