11 Commits

Author SHA1 Message Date
Catalin Novgorodschi 1b66ce2139 Fix oasis regeneration
Fix a bug that appear when you attack an unoccupied oasis and not conquer and remain 0 units. After that troops not regenerate.
2026-05-14 08:42:12 +03:00
haki99 0f083fe4ed Refactor SQL 2025-12-19 23:54:38 +01:00
haki99 6a555c7f39 Fix SQL syntax by removing parentheses 2025-12-19 23:53:06 +01:00
haki99 510421e4ed Refactor oasis regeneration SQL script
Refactor oasis regeneration SQL script to improve clarity and maintainability.
2025-12-19 22:57:21 +01:00
haki99 4e30e49475 Update SQL queries for player count and progression 2025-12-19 22:17:21 +01:00
haki99 3b359d6f85 Adjust unit growth calculations with player metrics
Updated unit growth calculations based on player progression and growth factor.
2025-12-17 17:10:11 +01:00
Martin Kalabek e61177614e fix missing prefixes for oasis troops regen sql 2024-10-10 20:05:14 +02:00
Martin Ambrus 1525771ee9 fix: correction in generation of units in oasis 2017-10-28 15:15:30 +02:00
Martin Ambrus 5a967055f4 refactor: using indexed temporary table as array works speed wonders :) 2017-10-27 21:04:16 +02:00
Martin Ambrus 0d84b5f3b4 fix: MySQL variables can't be used inside IN statements as such
So, if we want to do something like "WHERE abc IN ( @ids )", where @ids
would contain a string of "1,2,3", we can't and would need to use
FIND_IN_SET() function instead.
2017-10-27 19:36:27 +02:00
Martin Ambrus 1066fff9a2 refactor: installation happens at MySQL side
A lot has happened here. Here's the list:

1. autoloader was added that should prevent various "failed to open
stream" errors when trying to load new classes

2. PHP-based data generation was replaced by MySQL-based one, hopefully
fixing the installation problems when insert payload it too high and the
DB wouldn't populate with some users

3. thanks to step 2, the installation should be really almost
instantenious, instead of waiting a long time for many SQL connections
and queries to populate the world

4. World Data & Oasis generation and population is done in 1 step now
2017-10-27 18:27:03 +02:00