phpBB Guru - Официальная русская поддержка форума phpBB3

Код: Выделить всё

INSERT phpbb_reputations 
(user_id_from, user_id_to, reputation_time, reputation_item_id, reputation_comment, reputation_type_id, reputation_points)
SELECT reputation_from, reputation_to, reputation_time, reputation_post, reputation_comment, 1, CAST(reputation_type AS SIGNED) * 2 - 1
FROM phpbb_reputation


UPDATE phpbb_users u
SET user_reputation=(
	SELECT COUNT(*) FROM phpbb_reputations WHERE user_id_to=u.user_id
)

Код: Выделить всё

UPDATE phpbb_users u
SET user_reputation=(
	(SELECT SUM(reputation_points) FROM phpbb_reputations WHERE user_id_to=u.user_id)
)

Код: Выделить всё

	$sql = 'SELECT
		`phpbb_users`.`user_id` AS `user_id`,
		`phpbb_users`.`username` AS `username`,
		`phpbb_users`.`user_colour` AS `user_colour`,
		`phpbb_reputations`.`reputation_points` AS `user_reputation`,
		`phpbb_reputations`.`reputation_time`,
		`phpbb_reputations`.`user_id_from`
	FROM
		`phpbb_reputations`
		INNER JOIN `phpbb_users` ON `phpbb_reputations`.`user_id_to` =
		`phpbb_users`.`user_id`
	ORDER BY
		`phpbb_reputations`.`reputation_time` DESC';

Код: Выделить всё

UPDATE phpbb3_posts p
SET post_reputation=(
	(SELECT SUM(reputation_points) FROM phpbb3_reputations WHERE reputation_item_id=p.post_id)
)