stormdeveloper, так правильнее
http://torrentpier.com/threads/Установка-xbtt-аля-debian-5.313/page-6#post-42565
Alexander.S, приведу что на что поправить исходя с последней ревизии, где хобот был (R550) с учетом таблички скорости
server.cpp
Найти:
m_database.query("INSERT INTO " + table_name(table_users) + " (u_down_total, u_up_total, " + column_name(column_users_uid) + ", u_up_release, u_up_bonus, max_up_speed, max_down_speed) VALUES "
+ m_users_updates_buffer
+ " on duplicate key update"
+ " u_down_total = u_down_total + values(u_down_total),"
+ " u_up_total = u_up_total + values(u_up_total),"
+ " u_up_release = u_up_release + values(u_up_release),"
+ " u_up_bonus = u_up_bonus + values(u_up_bonus),"
+ " max_up_speed = GREATEST(max_up_speed, values(max_up_speed)),"
+ " max_down_speed = GREATEST(max_down_speed, values(max_down_speed)),"
+ " u_down_today = u_down_today + values(u_down_total),"
+ " u_up_today = u_up_today + values(u_up_total),"
+ " u_release_today = u_release_today + values(u_up_release),"
+ " u_bonus_today = u_bonus_today + values(u_up_bonus),"
+ " u_up_speed_today = GREATEST(u_up_speed_today, values(max_up_speed)),"
+ " u_down_speed_today = GREATEST(u_down_speed_today, values(max_down_speed))");Заменить на:
m_database.query("INSERT INTO " + table_name(table_users) + " (" + column_name(column_users_uid) + ", u_down_total, u_up_total, u_up_release, u_up_bonus, max_up_speed, max_down_speed) VALUES "
+ m_users_updates_buffer
+ " ON DUPLICATE KEY UPDATE"
+ " u_down_total = u_down_total + values(u_down_total),"
+ " u_up_total = u_up_total + values(u_up_total),"
+ " u_up_release = u_up_release + values(u_up_release),"
+ " u_up_bonus = u_up_bonus + values(u_up_bonus),"
+ " down_today = down_today + values(u_down_total),"
+ " up_today = up_today + values(u_up_total),"
+ " up_release_today = up_release_today + values(u_up_release),"
+ " up_bonus_today = up_bonus_today + values(u_up_bonus),"
+ " u_up_speed_today = GREATEST(u_up_speed_today, values(max_up_speed)),"
+ " u_down_speed_today = GREATEST(u_down_speed_today, values(max_down_speed))");
Найти:
Csql_query q(m_database, "(?,?,?,?,?,?,?),");
q.p(downloaded_db);
q.p(uploaded);
q.p(user->uid);
q.p(rel);
q.p(bonus ? uploaded / bonus : 0);
q.p(upspeed);
q.p(downspeed);
m_users_updates_buffer += q.read();
Заменить на:
Csql_query q(m_database, "(?,?,?,?,?,?,?),");
q.p(user->uid);
q.p(downloaded_db);
q.p(uploaded);
q.p(rel);
q.p(bonus ? uploaded/bonus : 0);
q.p(upspeed);
q.p(downspeed);
m_users_updates_buffer += q.read();
SQL:
ALTER TABLE `bb_bt_users` ADD `max_up_speed` mediumint(8) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `bb_bt_users` ADD `max_down_speed` mediumint(8) unsigned NOT NULL DEFAULT '0';
После чего снова надо копилировать хобот.
Если скорость не нужна и выводить ты ее не собираешься на трекере, то дай знать, подправлю пост