Sidonuke
Dec 12, 2008, 02:26 PM
yeah the 200 ids are for medium and then the 300 id range is for hard
VERSION 1.0
(1, 1, 1, 'Arrow I', 'Fires one arrow at a time', 12, 0, 1, 1.5, 85, 8, 0, 0, 0, 0, 0, 0, -1, 0, 0, 'tower_arrows.png', '', 'projectile_arrow_1.png', 'arrowFire.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '8000');
(2, 1, 1, 'Arrow II', 'Fires two arrows with increased range', 30, 0, 2, 1.8, 99, 13, 0, 0, 0, 0, 0, 0, -1, 0, 0, 'towerArrowUpgrade1.png', '', 'projectile_arrow_2.png', 'arrowFire.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '3800');
(3, 1, 1, 'Arrow III', 'Fires three arrows with increased range', 65, 0, 3, 2.1, 125, 25, 0, 0, 0, 0, 0, 0, -1, 0, 0, 'towerArrowUpgrade2.png', '', 'projectile_arrow_3.png', 'arrowFire.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '1080');
(4, 2, 2, 'Cannon I', 'Fires one bomb with small splash damage', 25, 0, 1, 1, 65, 12, 6, 35, 0, 0, 0, 0, -1, 0, 0, 'towerBombBase.png', 'towerBombTurret.png', 'projectile_bomb_1.png', 'CannonShot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '1880');
(5, 2, 2, 'Cannon II', 'Increased damage and splash radius', 70, 0, 2, 1, 80, 30, 20, 42, 0, 0, 0, 0, -1, 0, 0, 'towerBombUpgrade1.png', 'towerBombTurret.png', 'projectile_bomb_2.png', 'CannonShot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '8380');
(6, 2, 2, 'Cannon III', 'Increased damage, large splash radius', 160, 0, 3, 1, 95, 80, 40, 50, 0, 0, 0, 0, -1, 0, 0, 'towerBombUpgrade2.png', 'towerBombTurret.png', 'projectile_bomb_3.png', 'CannonShot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '2350');
(7, 3, 3, 'Water I', 'Slows enemies', 25, 0, 1, 1, 55, 5, 0, 0, 15, 0, 0, 0, -1, 0, 0, 'towerWaterBase.png', 'towerWaterTurret.png', 'projectile_water_1.png', 'watershot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 3, '1850');
(8, 3, 3, 'Water II', 'Enemies move even slower', 50, 0, 2, 1, 65, 25, 0, 0, 30, 0, 0, 0, -1, 0, 0, 'towerWaterUpgrade1.png', 'towerWaterTurret.png', 'projectile_water_2.png', 'watershot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 5, '6050');
(9, 3, 3, 'Water III', 'Enemies move even slower and the effect lasts longer', 190, 0, 3, 1, 75, 55, 0, 0, 50, 0, 0, 0, -1, 0, 0, 'towerWaterUpgrade2.png', 'towerWaterTurret.png', 'projectile_water_3.png', 'watershot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 7, '2200');
(10, 4, 6, 'Storm I', 'Reduces an enemy''s hitpoints by 5%', 100, 0, 1, 1, 47, 0, 0, 0, 0, 0, 5, 0, -1, 0, 0, 'tower_storm.png', '', 'projectile_storm_1.png', 'stormshot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '4200');
(11, 4, 6, 'Storm II', 'Reduces an enemy''s hitpoints by 10%', 250, 0, 2, 1.3, 62, 0, 0, 0, 0, 0, 10, 0, -1, 0, 0, 'towerStormUpgrade1.png', '', 'projectile_storm_2.png', 'stormshot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '2500');
(12, 4, 6, 'Storm III', 'Reduces an enemy''s hitpoints by 25%', 400, 0, 3, 1.6, 77, 0, 0, 0, 0, 0, 25, 0, -1, 0, 0, 'towerStormUpgrade2.png', '', 'projectile_storm_3.png', 'stormshot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '6000');
(13, 5, 5, 'Ice I', 'Shoots ice shards to completely stop an enemy', 50, 0, 1, 1.2, 55, 10, 5, 0, 60, 10, 0, 0, -1, 0, 0, 'tower_ice.png', '', 'projectile_ice_1.png', 'iceshot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 4, '3800');
(14, 5, 5, 'Ice II', 'Adds significant damage to the ice shards', 100, 0, 2, 1.2, 55, 50, 25, 10, 80, 15, 0, 0, -1, 0, 0, 'towerIceUpgrade1.png', '', 'projectile_ice_2.png', 'iceshot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 6, '1100');
(15, 5, 5, 'Ice III', 'Stops enemies for even longer', 250, 0, 3, 1.2, 55, 100, 50, 10, 90, 30, 0, 0, -1, 0, 0, 'towerIceUpgrade2.png', '', 'projectile_ice_3.png', 'iceshot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 8, '2750');
(16, 6, 4, 'Missile I', 'Shoots magic missiles with long range', 50, 0, 1, 2, 105, 15, 0, 0, 0, 0, 0, 0, -1, 0, 0, 'tower_magic.png', '', 'projectile_magic_1.png', 'missleshot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '4050');
(17, 6, 4, 'Missile II', 'More damage and more range', 100, 0, 2, 2.2, 120, 30, 0, 0, 0, 0, 0, 0, -1, 0, 0, 'towerMagicUpgrade1.png', '', 'projectile_magic_2.png', 'missleshot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '1050');
(18, 6, 4, 'Missile III', 'More damage and more range', 350, 0, 3, 2.5, 130, 70, 20, 25, 0, 0, 0, 0, -1, 0, 0, 'towerMagicUpgrade2.png', '', 'projectile_magic_3.png', 'missleshot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '3550');
(19, 7, 7, 'Earthquake I', 'Massive damage to all enemies on the field', 500, 0, 1, 0, 80, 400, 0, 0, 0, 0, 0, 1, 1, 1, 8, 'tower_earthquake.png', '', 'arrowShot0.png', 'quakeshot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '3500');
(20, 7, 7, 'Earthquake II', 'More damage! One more activation', 800, 0, 2, 0, 120, 900, 0, 0, 0, 0, 0, 1, 1, 2, 6, 'tower_earthquake_upgrade1.png', '', 'arrowShot0.png', 'quakeshot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '1000');
(21, 7, 7, 'Earthquake III', 'More damage! One more activation', 1200, 0, 3, 0, 160, 2000, 0, 0, 0, 0, 0, 1, 1, 3, 4, 'tower_earthquake_upgrade2.png', '', 'arrowShot0.png', 'quakeshot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '2000');
VERSION 1.1
(1, 1, 1, 'Arrow I', 'Fires one arrow at a time', 12, 0, 1, 1.5, 85, 8, 0, 0, 0, 0, 0, 0, -1, 0, 0, 'tower_arrows.png', '', 'projectile_arrow_1.png', 'arrowFire.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '7375');
(2, 1, 1, 'Arrow II', 'Fires two arrows with increased range', 30, 0, 2, 1.8, 99, 13, 0, 0, 0, 0, 0, 0, -1, 0, 0, 'towerArrowUpgrade1.png', '', 'projectile_arrow_2.png', 'arrowFire.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '2375');
(3, 1, 1, 'Arrow III', 'Fires three arrows with increased range', 65, 0, 3, 2.1, 125, 25, 0, 0, 0, 0, 0, 0, -1, 0, 0, 'towerArrowUpgrade2.png', '', 'projectile_arrow_3.png', 'arrowFire.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '5975');
(4, 2, 2, 'Cannon I', 'Fires one bomb with small splash damage', 25, 0, 1, 1, 65, 12, 6, 35, 0, 0, 0, 0, -1, 0, 0, 'towerBombBase.png', 'towerBombTurret.png', 'projectile_bomb_1.png', 'CannonShot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '1475');
(5, 2, 2, 'Cannon II', 'Increased damage and splash radius', 70, 0, 2, 1, 80, 30, 20, 42, 0, 0, 0, 0, -1, 0, 0, 'towerBombUpgrade1.png', 'towerBombTurret.png', 'projectile_bomb_2.png', 'CannonShot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '5275');
(6, 2, 2, 'Cannon III', 'Increased damage, large splash radius', 160, 0, 3, 1, 95, 80, 40, 50, 0, 0, 0, 0, -1, 0, 0, 'towerBombUpgrade2.png', 'towerBombTurret.png', 'projectile_bomb_3.png', 'CannonShot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '1405');
(7, 3, 3, 'Water I', 'Slows enemies', 25, 0, 1, 1, 55, 5, 0, 0, 15, 0, 0, 0, -1, 0, 0, 'towerWaterBase.png', 'towerWaterTurret.png', 'projectile_water_1.png', 'watershot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 3, '1405');
(8, 3, 3, 'Water II', 'Enemies move even slower', 50, 0, 2, 1, 65, 25, 0, 0, 30, 0, 0, 0, -1, 0, 0, 'towerWaterUpgrade1.png', 'towerWaterTurret.png', 'projectile_water_2.png', 'watershot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 5, '4105');
(9, 3, 3, 'Water III', 'Enemies move even slower and the effect lasts longer', 190, 0, 3, 1, 75, 55, 0, 0, 50, 0, 0, 0, -1, 0, 0, 'towerWaterUpgrade2.png', 'towerWaterTurret.png', 'projectile_water_3.png', 'watershot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 7, '1465');
(10, 4, 6, 'Storm I', 'Reduces an enemy''s hitpoints by 5%', 100, 0, 1, 1, 47, 0, 0, 0, 0, 0, 5, 0, -1, 0, 0, 'tower_storm.png', '', 'projectile_storm_1.png', 'stormshot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '5565');
(11, 4, 6, 'Storm II', 'Reduces an enemy''s hitpoints by 10%', 250, 0, 2, 1.3, 62, 0, 0, 0, 0, 0, 10, 0, -1, 0, 0, 'towerStormUpgrade1.png', '', 'projectile_storm_2.png', 'stormshot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '1935');
(12, 4, 6, 'Storm III', 'Reduces an enemy''s hitpoints by 25%', 400, 0, 3, 1.6, 77, 0, 0, 0, 0, 0, 25, 0, -1, 0, 0, 'towerStormUpgrade2.png', '', 'projectile_storm_3.png', 'stormshot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '4135');
(13, 5, 5, 'Ice I', 'Shoots ice shards to completely stop an enemy', 50, 0, 1, 1.2, 55, 10, 5, 0, 40, 5, 0, 0, -1, 0, 0, 'tower_ice.png', '', 'projectile_ice_1.png', 'iceshot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 4, '2835');
(14, 5, 5, 'Ice II', 'Adds significant damage to the ice shards', 100, 0, 2, 1.2, 55, 50, 25, 10, 55, 10, 0, 0, -1, 0, 0, 'towerIceUpgrade1.png', '', 'projectile_ice_2.png', 'iceshot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 6, '8335');
(15, 5, 5, 'Ice III', 'Stops enemies for even longer', 250, 0, 3, 1.2, 55, 100, 50, 10, 70, 15, 0, 0, -1, 0, 0, 'towerIceUpgrade2.png', '', 'projectile_ice_3.png', 'iceshot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 8, '2205');
(16, 6, 4, 'Missile I', 'Shoots magic missiles with long range', 50, 0, 1, 2, 105, 15, 0, 0, 0, 0, 0, 0, -1, 0, 0, 'tower_magic.png', '', 'projectile_magic_1.png', 'missleshot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '2805');
(17, 6, 4, 'Missile II', 'More damage and more range', 100, 0, 2, 2.2, 120, 30, 0, 0, 0, 0, 0, 0, -1, 0, 0, 'towerMagicUpgrade1.png', '', 'projectile_magic_2.png', 'missleshot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '8305');
(18, 6, 4, 'Missile III', 'More damage and more range', 350, 0, 3, 2.5, 130, 70, 20, 25, 0, 0, 0, 0, -1, 0, 0, 'towerMagicUpgrade2.png', '', 'projectile_magic_3.png', 'missleshot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '2755');
(19, 7, 7, 'Earthquake I', 'Massive damage to all enemies on the field', 500, 0, 1, 0, 80, 400, 0, 0, 0, 0, 0, 1, 1, 1, 8, 'tower_earthquake.png', '', 'arrowShot0.png', 'quakeshot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '2755');
(20, 7, 7, 'Earthquake II', 'More damage! One more activation', 800, 0, 2, 0, 120, 900, 0, 0, 0, 0, 0, 1, 1, 2, 6, 'tower_earthquake_upgrade1.png', '', 'arrowShot0.png', 'quakeshot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '7155');
(21, 7, 7, 'Earthquake III', 'More damage! One more activation', 1200, 0, 3, 0, 160, 2000, 0, 0, 0, 0, 0, 1, 1, 3, 4, 'tower_earthquake_upgrade2.png', '', 'arrowShot0.png', 'quakeshot.aiff', 'towerUpgraded.aiff', 'towerBuilt.aiff', 'defaultResearchSound.aiff', 50, 0, '1375');
TABLE FORMAT
CREATE TABLE TowerUpgrade (
id integer primary key autoincrement,
idTowerType integer not null,
idDamageType integer not null,
name text not null,
summary text not null,
upgradeGoldCost integer not null default 0,
upgradeHaloCost integer not null default 0, /* 0 = no halos required */
ordinal integer not null,
rateOfFire float not null default 0.0, /* 0.0 = none or not applicable */
range float not null default 0.0, /* 0.0 = none or not applicable */
damage float not null default 0.0, /* 0.0 = none or not applicable */
splashDamage float not null default 0.0, /* 0.0 = none or not applicable */
splashDamageRadius float not null default 0.0, /* 0.0 = none or not applicable */
hitSpeedModifier float not null default 0.0, /* 0.0 = none or not applicable */
splashSpeedModifier float not null default 0.0, /* 0.0 = none or not applicable */
percentageDamage float not null default 0.0, /* 0.0 = none or not applicable*/
isShakeActivated integer not null default 0, /* 0 = false */
maximumAllowedInstances integer not null default 0, /* 0 = unlimited */
maximumActivationsPerLevel integer not null default 0, /* 0 = unlimited */
shakeCooldown float not null default 0.0, /* 0.0 = unlimited or not applicable */
baseImage text not null,
turretImage text not null,
shotImage text not null,
shotSound text not null default "defaultShotSound.aiff",
upgradeSound text not null default "defaultUpgradeSound.aiff",
buildSound text not null default "defaultBuildSound.aiff",
researchSound text not null default "defaultResearchSound.aiff", effectivenessFactor float not null default 50.0, duration float not null default 0.25, sellValue int not null default 0,
FOREIGN KEY (idTowerType) REFERENCES TowerType(id),
FOREIGN KEY (idDamageType) REFERENCES DamageType(id)
);
CREATE UNIQUE INDEX TowerUpgrade_ordinal on TowerUpgrade(idTowerType, ordinal);
vBulletin® v3.8.6, Copyright ©2000-2012, Jelsoft Enterprises Ltd.