sql запрос

[Kymap93 3]

Погуглил не могу найти, подскажите sql запрос для вайпа базы для IT pwsoft. То что то не где не встретился такой

[Demoncool 1110]

DELETE FROM accounts;

DELETE FROM achievements;
DELETE FROM bug_reports;
DELETE FROM char_bonus;
DELETE FROM char_daily;
DELETE FROM char_hwid;
DELETE FROM char_teleports;
DELETE FROM character_buffs;
DELETE FROM character_friends;
DELETE FROM character_hennas;
DELETE FROM character_macroses;
DELETE FROM character_offline;
DELETE FROM character_quests;
DELETE FROM character_raid_points;
DELETE FROM character_recipebook;
DELETE FROM character_recommends;
DELETE FROM character_settings;
DELETE FROM character_shortcuts;
DELETE FROM character_skills;
DELETE FROM character_subclasses;
DELETE FROM characters;
DELETE FROM clan_data;
DELETE FROM clan_privs;
DELETE FROM clan_skills;
DELETE FROM clan_subpledges;
DELETE FROM clan_wars;
UPDATE clanhall SET ownerId = 0 where ownerId >= 1;
DELETE FROM clanhall_functions;
DELETE FROM cursed_weapons;
DELETE FROM games;
DELETE FROM helper_buff_list;
DELETE FROM heroes;
DELETE FROM items;
DELETE FROM itemsonground;
DELETE FROM locations;
DELETE FROM mods_wedding;
DELETE FROM olympiad_diaries;
DELETE FROM olympiad_nobles;
DELETE FROM party_match;
DELETE FROM pets;
DELETE FROM raidboss_points;
DELETE FROM raidboss_status;
DELETE FROM seven_signs;
DELETE FROM seven_signs_status;
INSERT INTO seven_signs_status VALUES (0,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
DELETE FROM seven_signs_status;
DELETE FROM siege_clans;
DELETE FROM raidboss_status;
DELETE FROM stress_auto_rb;
DELETE FROM stress_donate_money;
DELETE FROM stress_referal;
DELETE FROM temporaryobjecttable;
DELETE FROM z_bbs_auction;
DELETE FROM z_bbs_mail;
DELETE FROM z_buff_profile;
DELETE FROM z_char_keys;
DELETE FROM z_clanscore;
DELETE FROM z_donate_skills;
DELETE FROM z_fc_players;
DELETE FROM z_moderator;
DELETE FROM z_moderator_log;
DELETE FROM z_post_adrbook;
DELETE FROM z_post_in;
DELETE FROM z_post_out;
DELETE FROM z_post_pos;
DELETE FROM z_post_stat;
DELETE FROM z_safety_trade;
DELETE FROM z_stock_accounts;
DELETE FROM z_stock_items;
DELETE FROM z_stock_logs;
DELETE FROM z_vote_logs;
DELETE FROM z_vote_names;
DELETE FROM zz_donate_log;
DELETE FROM z_clanscore;
DELETE FROM z_clanscore;
DELETE FROM z_clanscore;
DELETE FROM z_clanscore;

 

[SuperRussianMan 13]

DELETE FROM accounts;

DELETE FROM achievements;

DELETE FROM bug_reports;

DELETE FROM char_bonus;

DELETE FROM char_daily;

DELETE FROM char_hwid;

DELETE FROM char_teleports;

DELETE FROM character_buffs;

DELETE FROM character_friends;

DELETE FROM character_hennas;

DELETE FROM character_macroses;

DELETE FROM character_offline;

DELETE FROM character_quests;

DELETE FROM character_raid_points;

DELETE FROM character_recipebook;

DELETE FROM character_recommends;

DELETE FROM character_settings;

DELETE FROM character_shortcuts;

DELETE FROM character_skills;

DELETE FROM character_subclasses;

DELETE FROM characters;

DELETE FROM clan_data;

DELETE FROM clan_privs;

DELETE FROM clan_skills;

DELETE FROM clan_subpledges;

DELETE FROM clan_wars;

UPDATE clanhall SET ownerId = 0 where ownerId >= 1;

DELETE FROM clanhall_functions;

DELETE FROM cursed_weapons;

DELETE FROM games;

DELETE FROM helper_buff_list;

DELETE FROM heroes;

DELETE FROM items;

DELETE FROM itemsonground;

DELETE FROM locations;

DELETE FROM mods_wedding;

DELETE FROM olympiad_diaries;

DELETE FROM olympiad_nobles;

DELETE FROM party_match;

DELETE FROM pets;

DELETE FROM raidboss_points;

DELETE FROM raidboss_status;

DELETE FROM seven_signs;

DELETE FROM seven_signs_status;

INSERT INTO seven_signs_status VALUES (0,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

DELETE FROM seven_signs_status;

DELETE FROM siege_clans;

DELETE FROM raidboss_status;

DELETE FROM stress_auto_rb;

DELETE FROM stress_donate_money;

DELETE FROM stress_referal;

DELETE FROM temporaryobjecttable;

DELETE FROM z_bbs_auction;

DELETE FROM z_bbs_mail;

DELETE FROM z_buff_profile;

DELETE FROM z_char_keys;

DELETE FROM z_clanscore;

DELETE FROM z_donate_skills;

DELETE FROM z_fc_players;

DELETE FROM z_moderator;

DELETE FROM z_moderator_log;

DELETE FROM z_post_adrbook;

DELETE FROM z_post_in;

DELETE FROM z_post_out;

DELETE FROM z_post_pos;

DELETE FROM z_post_stat;

DELETE FROM z_safety_trade;

DELETE FROM z_stock_accounts;

DELETE FROM z_stock_items;

DELETE FROM z_stock_logs;

DELETE FROM z_vote_logs;

DELETE FROM z_vote_names;

DELETE FROM zz_donate_log;

DELETE FROM z_clanscore;

DELETE FROM z_clanscore;

DELETE FROM z_clanscore;

DELETE FROM z_clanscore;

 

 

Да ты прям шутник)))Дал пацыку на удаление всей базы)))

[Detect 618]

Да ты прям шутник)))Дал пацыку на удаление всей базы)))

это и называется вайп всей базы.

[Placebo 36]

мда...школьники уже не те

[SuperRussianMan 13]

Вайп это чистка базы от мусора а не удаление всей базы !!!Т.е удаление чаров акков и скилы от чаров и тд!!!

Изменено 1 марта, 2016 пользователем SuperRussianMan

[Tpоuka 269]

Руками удалить не судьба?

[b333ar 5]

апну человеку, какие таблицу нужно чистить?

[Demoncool 1110]

Вайп это чистка базы от мусора а не удаление всей базы !!!Т.е удаление чаров акков и скилы от чаров и тд!!!

а чего это мои закросы вайпают базу? лично у меня они чистят бд не удаляя таблицы(удаляя данные в ных)