B
Bustra
Гость
[email protected].,ну я это и имел ввиду. Зато скачал нужные торрент файлы сиди и добавляй их в торрент
Предлагаю сделать или добавить, если user пере установил винду и не знал как сохранить торрент файлы, то заходит в допустим tracker.php ищет свои раздачи по Автору ставит галочки рядом с названием своих раздач нажимает кнопку и получает архив торрент файлов своих, которых он решил восстановить. Не знаю может кто то понял суть или нет..
CREATE TABLE IF NOT EXISTS `bb_bt_users` (
`user_id` mediumint(9) NOT NULL DEFAULT '0',
`auth_key` char(10) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`u_up_total` bigint(20) unsigned NOT NULL DEFAULT '0',
`u_down_total` bigint(20) unsigned NOT NULL DEFAULT '0',
`u_up_release` bigint(20) unsigned NOT NULL DEFAULT '0',
`u_up_bonus` bigint(20) unsigned NOT NULL DEFAULT '0',
`u_up_today` bigint(20) unsigned NOT NULL DEFAULT '0',
`u_down_today` bigint(20) unsigned NOT NULL DEFAULT '0',
`u_bonus_today` bigint(20) unsigned NOT NULL DEFAULT '0',
`u_up_yday` bigint(20) unsigned NOT NULL DEFAULT '0',
`u_down_yday` bigint(20) unsigned NOT NULL DEFAULT '0',
`u_bonus_yday` bigint(20) unsigned NOT NULL DEFAULT '0',
`max_up_speed` bigint(20) NOT NULL DEFAULT '0',
`max_down_speed` bigint(20) NOT NULL DEFAULT '0',
`u_release_today` bigint(20) NOT NULL DEFAULT '0',
`u_up_speed_today` bigint(20) NOT NULL DEFAULT '0',
`u_down_speed_today` bigint(20) NOT NULL DEFAULT '0',
`u_release_yday` bigint(20) NOT NULL DEFAULT '0',
`u_up_speed_yday` bigint(20) NOT NULL DEFAULT '0',
`u_down_speed_yday` bigint(20) NOT NULL DEFAULT '0',
`u_down_last` bigint(20) NOT NULL DEFAULT '0',
`u_up_last` bigint(20) NOT NULL DEFAULT '0',
`u_release_last` bigint(20) NOT NULL DEFAULT '0',
`u_bonus_last` bigint(20) NOT NULL DEFAULT '0',
`u_up_speed_last` bigint(20) NOT NULL DEFAULT '0',
`u_down_speed_last` bigint(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`user_id`),
UNIQUE KEY `auth_key` (`auth_key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
m_users_updates_buffer.erase(m_users_updates_buffer.size() - 1);
try
{
.
.
.
.
}
catch (Cdatabase::exception&)
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)),"
+ " u_down_last = values(u_down_total),"
+ " u_up_last = values(u_up_total),"
+ " u_release_last = values(u_up_release),"
+ " u_bonus_last = values(u_up_bonus),"
+ " u_up_speed_last = values(max_up_speed),"
+ " u_down_speed_last = values(max_down_speed)");