case '0.5.6': // SQL queries for v0.5.6
// Get current month
- $curr = str_pad(getMonth(), 2, '0', STR_PAD_LEFT);
+ $curr = padLeftZero(getMonth());
if ($curr == '00') $curr = '12';
// Generate timemark...
$mark = mktime(0, 0, 0, $curr, 1, getYear());
// Update accounts which are not active last months
- addExtensionSql("UPDATE
+ addExtensionSql('UPDATE
`{?_MYSQL_PREFIX?}_user_data`
SET
`turbo_bonus`=0,
`bonus_stats`=0,
`bonus_ref`=0
WHERE
- `last_online` < ".$mark."
+ `last_online` < ' . $mark . '
ORDER BY
- `userid` ASC");
+ `userid` ASC');
// Update notes (these will be set as task text!)
setExtensionUpdateNotes("Ein weiterer Scriptfehler hat nur die Gewinner aus der Aktiv-Rallye genommen. Die anderen Mitglieder sind somit "nach oben gerutsch".");
// Register points data
registerExtensionPointsData('monthly_bonus', 'points', 'LOCKED', 'DIRECT');
- // This depends on ext-sql_patches
- addExtensionDependency('sql_patches');
-
// Update notes
setExtensionUpdateNotes("Monatlicher Bonus wird nun über die Tabelle <strong>{OPEN_CONFIG}_MYSQL_PREFIX{CLOSE_CONFIG}_points_data</strong> verwaltet.");
break;