47 lines
2.2 KiB
MySQL
47 lines
2.2 KiB
MySQL
|
-- LegacyWorlds Beta 5
|
||
|
|
-- PostgreSQL database scripts
|
||
|
|
--
|
||
|
|
-- beta5/00-beta5.sql
|
||
|
|
--
|
||
|
|
-- Install the Beta 5-specific data into the main database
|
||
|
|
--
|
||
|
|
-- Copyright(C) 2004-2007, DeepClone Development
|
||
|
|
-- --------------------------------------------------------
|
||
|
|
|
||
|
|
|
||
|
|
\c legacyworlds legacyworlds_admin
|
||
|
|
|
||
|
|
SET search_path=main;
|
||
|
|
|
||
|
|
COPY ranking_def (version, name, more) FROM STDIN;
|
||
|
|
beta5 p_general FALSE
|
||
|
|
beta5 a_general TRUE
|
||
|
|
beta5 p_financial FALSE
|
||
|
|
beta5 p_military FALSE
|
||
|
|
beta5 p_civ FALSE
|
||
|
|
beta5 p_round FALSE
|
||
|
|
beta5 p_idr FALSE
|
||
|
|
\.
|
||
|
|
|
||
|
|
|
||
|
|
SELECT add_ranking_description('beta5', 'p_general', 'en', 'General Ranking',
|
||
|
|
'This ranking corresponds to a combination of civilisation, military and financial rankings. It represents a ' ||
|
||
|
|
'player''s current overall advancement and strength in the game.');
|
||
|
|
SELECT add_ranking_description('beta5', 'a_general', 'en', 'Alliance Ranking',
|
||
|
|
'An alliance''s ranking indicates its overall strength; the points for an alliance are the sum of the general ' ||
|
||
|
|
'ranking points for all of its members.');
|
||
|
|
SELECT add_ranking_description('beta5', 'p_financial', 'en', 'Financial Ranking',
|
||
|
|
'This ranking corresponds to the economic health of a player''s empire. It takes into account the player''s ' ||
|
||
|
|
'banked cash, his income and the number of industrial factories he owns.');
|
||
|
|
SELECT add_ranking_description('beta5', 'p_military', 'en', 'Military Ranking',
|
||
|
|
'This ranking allows to assess the military strength of a player''s empire. Its calculation is based on the ' ||
|
||
|
|
'number of turrets and military factories the player owns along with his fleet fire power.');
|
||
|
|
SELECT add_ranking_description('beta5', 'p_civ', 'en', 'Civilization Ranking',
|
||
|
|
'This ranking represents the advancement level of the society in a player''s empire. It takes into account ' ||
|
||
|
|
'technology level, population and happiness.');
|
||
|
|
SELECT add_ranking_description('beta5', 'p_round', 'en', 'Overall Round Ranking',
|
||
|
|
'This ranking is calculated based on players'' previous general rankings for the top 15 players. It allows ' ||
|
||
|
|
'for a long term estimate of the bets players'' accomplishments.');
|
||
|
|
SELECT add_ranking_description('beta5', 'p_idr', 'en', 'Inflicted Damage Ranking',
|
||
|
|
'This ranking represents the amount of damage a player has inflicted on other players'' fleets.');
|