下面的sql是烈焰私服开区清空数据用的
truncate table account_data;
truncate table account_forced_permissions;
truncate table achievement_data;
truncate table arenateams;
truncate table auctionhouse;
truncate table auctions;
truncate table banned_names;
truncate table banned_phrases;
truncate table battlemasters;
truncate table characters;
truncate table characters_insert_queue;
truncate table character_achievement;
truncate table character_achievement_progress;
truncate table charters;
truncate table clientaddons;
truncate table command_overrides;
truncate table clientaddons;
truncate table corpses;
truncate table creature_names;
truncate table creature_quest_finisher;
truncate table creature_quest_starter;
truncate table creature_summon;
truncate table creature_timed_emotes;
truncate table equipmentsets;
truncate table gamecards;
truncate table gameobject_quest_finisher;
truncate table gameobject_quest_item_binding;
truncate table gameobject_quest_pickup_binding;
truncate table gameobject_quest_starter;
truncate table gameobject_staticspawns;
truncate table gameobject_teleports;
truncate table gm_tickets;
truncate table graveyards;
truncate table groups;
truncate table guilds;
truncate table guild_ally;
truncate table guild_application;
truncate table guild_data;
truncate table guild_gifts;
truncate table guild_items;
truncate table guild_logs;
truncate table guild_ranks;
truncate table instanceids;
truncate table instance_bosses;
truncate table itemnames;
truncate table itempages;
truncate table itempetfood;
truncate table items_extendedcost;
truncate table item_quest_association;
truncate table item_randomprop_groups;
truncate table item_randomsuffix_groups;
truncate table loot_gameobjects;
truncate table loot_items;
truncate table loot_skinning;
truncate table mailbox;
truncate table mailitems;
truncate table map_checkpoint;
truncate table npc_gossip_textid;
truncate table npc_monstersay;
truncate table npc_text;
truncate table paylog;
truncate table pay_rank;
truncate table petdefaultspells;
truncate table playerbugreports;
truncate table playercashlog;
truncate table playercooldowns;
truncate table playercreateinfo_items;
truncate table playercreateinfo_skills;
truncate table playercreateinfo_spells;
truncate table playerdeletedspells;
truncate table playeritemslog;
truncate table playeritems_insert_queue;
truncate table playermagics;
truncate table playermarriage;
truncate table playeronlinecount;
truncate table playerpets;
truncate table playerpetspells;
truncate table playerreputations;
truncate table playerskills;
truncate table playerspells;
truncate table playersummons;
truncate table playersummonspells;
truncate table playervip;
truncate table professiondiscoveries;
truncate table questlog;
truncate table quests;
truncate table quests_localized;
truncate table quest_poi;
truncate table quest_poi_points;
truncate table siege_warfare_award;
truncate table social_enemys;
truncate table social_friends;
truncate table social_ignores;
truncate table spell_info;
truncate table spell_train_info;
truncate table teleport_coords;
truncate table trainerspelloverride;
truncate table transport_creatures;
truncate table transport_data;
truncate table warsonggulch;
truncate table warsonggulchtimetable;
truncate table worldstring_tables_localized;
下面的方法是IIS做烈焰资源服务器时的步骤
1、网站属性--http头--mime类型--新建
a、.data 类型application/data or application/octet-stream
b、.config 类型application/config or application/octet-stream
2、网站属性--主目录--配置--映射
删除扩展名.config那一项