Быстрое удаление акков...
7 ответов172 просмотровСейчас просматривают: 1
· 15.12.2008, 20:51
Прива! Скажите есть ли какая утилитка, способная быстро почистить базу от ненужных акков ???
0
· 15.12.2008, 21:22
вопрос не понятен. Что такое "ненужные акки" ?
Запрос удаляющий всё нафиг:
Код
DELETE FROM [lin2db].[dbo].[user_auth]
DELETE FROM [lin2db].[dbo].[user_account]
DELETE FROM [lin2db].[dbo].[user_info]
DELETE FROM [lin2world].[dbo].[user_data]
DELETE FROM [lin2world].[dbo].[pet_data]
DELETE FROM [lin2world].[dbo].[user_journal]
DELETE FROM [lin2world].[dbo].[user_log]
DELETE FROM [lin2world].[dbo].[user_macro]
DELETE FROM [lin2world].[dbo].[user_macroinfo]
DELETE FROM [lin2world].[dbo].[user_mail]
DELETE FROM [lin2world].[dbo].[user_mail_info]
DELETE FROM [lin2world].[dbo].[user_mail_receiver]
DELETE FROM [lin2world].[dbo].[user_mail_sender]
DELETE FROM [lin2world].[dbo].[user_name_color]
DELETE FROM [lin2world].[dbo].[user_newbie]
DELETE FROM [lin2world].[dbo].[user_nobless]
DELETE FROM [lin2world].[dbo].[user_skill]
DELETE FROM [lin2world].[dbo].[user_warehouse]
DELETE FROM [lin2world].[dbo].[user_mail_subjob]
DELETE FROM [lin2world].[dbo].[user_mail_sociality]
DELETE FROM [lin2world].[dbo].[user_mail_surrender]
DELETE FROM [lin2world].[dbo].[user_mail_history]
DELETE FROM [lin2world].[dbo].[user_mail_item]
DELETE FROM [lin2world].[dbo].[user_mail_ban]
DELETE FROM [lin2world].[dbo].[user_mail_blacklist]
DELETE FROM [lin2world].[dbo].[user_mail_deleted]
DELETE FROM [lin2world].[dbo].[user_mail_henna]
DELETE FROM [lin2world].[dbo].[user_mail_comment]
DELETE FROM [lin2world].[dbo].[sms_payments]
DELETE FROM [lin2world].[dbo].[petitionmsg]
DELETE FROM [lin2world].[dbo].[pledge_skill]
DELETE FROM [lin2world].[dbo].[pledge_crest]
DELETE FROM [lin2world].[dbo].[alliance]
DELETE FROM [lin2db].[dbo].[user_account]
DELETE FROM [lin2db].[dbo].[user_info]
DELETE FROM [lin2world].[dbo].[user_data]
DELETE FROM [lin2world].[dbo].[pet_data]
DELETE FROM [lin2world].[dbo].[user_journal]
DELETE FROM [lin2world].[dbo].[user_log]
DELETE FROM [lin2world].[dbo].[user_macro]
DELETE FROM [lin2world].[dbo].[user_macroinfo]
DELETE FROM [lin2world].[dbo].[user_mail]
DELETE FROM [lin2world].[dbo].[user_mail_info]
DELETE FROM [lin2world].[dbo].[user_mail_receiver]
DELETE FROM [lin2world].[dbo].[user_mail_sender]
DELETE FROM [lin2world].[dbo].[user_name_color]
DELETE FROM [lin2world].[dbo].[user_newbie]
DELETE FROM [lin2world].[dbo].[user_nobless]
DELETE FROM [lin2world].[dbo].[user_skill]
DELETE FROM [lin2world].[dbo].[user_warehouse]
DELETE FROM [lin2world].[dbo].[user_mail_subjob]
DELETE FROM [lin2world].[dbo].[user_mail_sociality]
DELETE FROM [lin2world].[dbo].[user_mail_surrender]
DELETE FROM [lin2world].[dbo].[user_mail_history]
DELETE FROM [lin2world].[dbo].[user_mail_item]
DELETE FROM [lin2world].[dbo].[user_mail_ban]
DELETE FROM [lin2world].[dbo].[user_mail_blacklist]
DELETE FROM [lin2world].[dbo].[user_mail_deleted]
DELETE FROM [lin2world].[dbo].[user_mail_henna]
DELETE FROM [lin2world].[dbo].[user_mail_comment]
DELETE FROM [lin2world].[dbo].[sms_payments]
DELETE FROM [lin2world].[dbo].[petitionmsg]
DELETE FROM [lin2world].[dbo].[pledge_skill]
DELETE FROM [lin2world].[dbo].[pledge_crest]
DELETE FROM [lin2world].[dbo].[alliance]
— 127.0.0.1 hacker!!1
0
· 17.12.2008, 21:29
rexi777, наверное имел виду запрос удаляющий из базы все аки которые не используют уже более n кол-ва времени!....
Ктулху зохавывает всех (;,;)
Lineage 2: C4 - online / C5,IT,Kamael - offline>
0
· 18.12.2008, 20:10
Stalkerok: rexi777, наверное имел виду запрос удаляющий из базы все аки которые не используют уже более n кол-ва времени!....
Совершенно верно :)
P.S А есть какая прога-админка, которая может удалять акки?
marsh12: вопрос не понятен. Что такое "ненужные акки" ?
Запрос удаляющий всё нафиг:КодDELETE FROM [lin2db].[dbo].[user_auth]
DELETE FROM [lin2db].[dbo].[user_account]
DELETE FROM [lin2db].[dbo].[user_info]
DELETE FROM [lin2world].[dbo].[user_data]
DELETE FROM [lin2world].[dbo].[pet_data]
DELETE FROM [lin2world].[dbo].[user_journal]
DELETE FROM [lin2world].[dbo].[user_log]
DELETE FROM [lin2world].[dbo].[user_macro]
DELETE FROM [lin2world].[dbo].[user_macroinfo]
DELETE FROM [lin2world].[dbo].[user_mail]
DELETE FROM [lin2world].[dbo].[user_mail_info]
DELETE FROM [lin2world].[dbo].[user_mail_receiver]
DELETE FROM [lin2world].[dbo].[user_mail_sender]
DELETE FROM [lin2world].[dbo].[user_name_color]
DELETE FROM [lin2world].[dbo].[user_newbie]
DELETE FROM [lin2world].[dbo].[user_nobless]
DELETE FROM [lin2world].[dbo].[user_skill]
DELETE FROM [lin2world].[dbo].[user_warehouse]
DELETE FROM [lin2world].[dbo].[user_mail_subjob]
DELETE FROM [lin2world].[dbo].[user_mail_sociality]
DELETE FROM [lin2world].[dbo].[user_mail_surrender]
DELETE FROM [lin2world].[dbo].[user_mail_history]
DELETE FROM [lin2world].[dbo].[user_mail_item]
DELETE FROM [lin2world].[dbo].[user_mail_ban]
DELETE FROM [lin2world].[dbo].[user_mail_blacklist]
DELETE FROM [lin2world].[dbo].[user_mail_deleted]
DELETE FROM [lin2world].[dbo].[user_mail_henna]
DELETE FROM [lin2world].[dbo].[user_mail_comment]
DELETE FROM [lin2world].[dbo].[sms_payments]
DELETE FROM [lin2world].[dbo].[petitionmsg]
DELETE FROM [lin2world].[dbo].[pledge_skill]
DELETE FROM [lin2world].[dbo].[pledge_crest]
DELETE FROM [lin2world].[dbo].[alliance]
Ой, какой адскЫй запрос :) Он лишнего ничего не удалит??? :)
0
· 18.12.2008, 20:19
Он удалит все ))
— Ålderdom - ingen glädje..
0
Тема закрыта для ответов