includes/cron/jobs/tr_cleanup_and_dlstat.php
Так правельнее
найти
// Get SUMMARIZED user's dlstat
DB()->query("
INSERT INTO ". NEW_BB_BT_LAST_USERSTAT ."
(user_id, up_add, down_add, release_add, bonus_add, speed_up, speed_down)
SELECT
user_id, SUM(up_add), SUM(down_add), SUM(release_add), SUM(bonus_add), SUM(speed_up), SUM(speed_down)
FROM ". NEW_BB_BT_LAST_TORSTAT ."
GROUP BY user_id
");
// Update TOTAL user's dlstat
DB()->query("
UPDATE
". BB_BT_USERS ." u,
". NEW_BB_BT_LAST_USERSTAT ." ub
SET
u.u_up_total = u.u_up_total + ub.up_add,
u.u_down_total = u.u_down_total + ub.down_add,
u.u_up_release = u.u_up_release + ub.release_add,
u.u_up_bonus = u.u_up_bonus + ub.bonus_add
WHERE u.user_id = ub.user_id
");
заменить на
// Get SUMMARIZED user's dlstat
DB()->query("
INSERT INTO ".NEW_BB_BT_LAST_USERSTAT."
(user_id, topics_count, up_add, down_add, release_add, bonus_add, seed_points_raw, speed_up, speed_down)
SELECT
user_id, SUM(seeder), SUM(up_add), SUM(down_add), SUM(release_add), SUM(bonus_add), ((SUM(seed_time_add)*{$bb_cfg['seed_points_per_hour']})/(3600*SUM(seeder))), SUM(speed_up), SUM(speed_down)
FROM ".NEW_BB_BT_LAST_TORSTAT."
GROUP BY user_id
");
// Update TOTAL user's dlstat
DB()->query("
UPDATE
". BB_BT_USERS ." u,
". NEW_BB_BT_LAST_USERSTAT ." ub
SET
u.u_up_total = u.u_up_total + ub.up_add,
u.u_down_total = u.u_down_total + ub.down_add,
u.u_up_release = u.u_up_release + ub.release_add,
u.u_up_bonus = u.u_up_bonus + ub.bonus_add,
u.seed_points = u.seed_points + (". get_bonus_sql_case ($bb_cfg['seed_points_f'], 'ub.topics_count', 'ub.seed_points_raw') .")
WHERE u.user_id = ub.user_id
");