Как восстановить платежи

[kkadd]

Здравствуйте.
utm 5 009
Есть две БД. Нужно восстановить из одной в другую все платежи пользователей. Три таблицы payments_* я перелил, платежи появились в истории но на баланс деньги не вернулись, есть ли варианты это исправить, т.е. какие еще нужно таблицы перелить.
Спасибо.

[MaxDM]

Баланс хранится в таблице accounts.

[kkadd]

Ок. нашел.
Скажите а смена тарифов где хранится? Т.е. какой у кого был выставлен на след месяц?

[kkadd]

На ней то и ошибки.


-- ERROR User 130 have basic account 130, but account 130 not exist
-- SQL DESC delete broken user (NOT RECOMMENDED)
-- UPDATE users SET is_deleted=1 WHERE id='130';

-- ERROR User 368 have basic account 368, but account 368 not exist
-- SQL DESC delete broken user (NOT RECOMMENDED)
-- UPDATE users SET is_deleted=1 WHERE id='368';

-- ERROR User 571 have basic account 571, but account 571 not exist
-- SQL DESC delete broken user (NOT RECOMMENDED)
-- UPDATE users SET is_deleted=1 WHERE id='571';

-- ERROR account 331 not blocked, but where is entry with id 628 in blocks_info
-- SQL DESC delete entry in blocks_info
UPDATE blocks_info SET is_deleted=1 WHERE account_id='331' AND start_date<='1356513896' AND expire_date>='1356513896' AND is_deleted=0;

-- ERROR account 348 not blocked, but where is entry with id 867 in blocks_info
-- SQL DESC delete entry in blocks_info
UPDATE blocks_info SET is_deleted=1 WHERE account_id='348' AND start_date<='1356513896' AND expire_date>='1356513896' AND is_deleted=0;

-- ERROR account 444 not blocked, but where is entry with id 896 in blocks_info
-- SQL DESC delete entry in blocks_info
UPDATE blocks_info SET is_deleted=1 WHERE account_id='444' AND start_date<='1356513896' AND expire_date>='1356513896' AND is_deleted=0;

-- ERROR account 479 not blocked, but where is entry with id 1172 in blocks_info
-- SQL DESC delete entry in blocks_info
UPDATE blocks_info SET is_deleted=1 WHERE account_id='479' AND start_date<='1356513896' AND expire_date>='1356513896' AND is_deleted=0;

-- ERROR account 578 not blocked, but where is entry with id 1191 in blocks_info
-- SQL DESC delete entry in blocks_info
UPDATE blocks_info SET is_deleted=1 WHERE account_id='578' AND start_date<='1356513896' AND expire_date>='1356513896' AND is_deleted=0;

-- ERROR account 450 not blocked, but where is entry with id 1196 in blocks_info
-- SQL DESC delete entry in blocks_info
UPDATE blocks_info SET is_deleted=1 WHERE account_id='450' AND start_date<='1356513896' AND expire_date>='1356513896' AND is_deleted=0;

-- 21 errors
-- 11 warnings
-- affected tables: account_tariff_link blocks_info dtagg_iptraffic dtagg_periodic iptraffic_service_links periodic_service_links users
-- RESTART utm5_core!


Вливаешь верификатор и толку ноль.

[MaxDM]

Ок. нашел.
Скажите а смена тарифов где хранится? Т.е. какой у кого был выставлен на след месяц?

account_tariff_link