Changeset 374 for minimanager/scripts/backup_tab.php
- Timestamp:
- Sep 11, 2008, 9:10:27 AM (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
minimanager/scripts/backup_tab.php
r364 r374 11 11 //list of tables in realmd db will be saved on Global backup 12 12 $tables_backup_realmd = Array( 13 14 15 16 17 13 "account", 14 "ip_banned", 15 "realmcharacters", 16 "account_banned", 17 "realmlist" 18 18 ); 19 19 20 20 //list of tables in characters db will be saved on Global backup 21 21 $tables_backup_characters = Array( 22 "auctionhouse", 23 "arena_team", 24 "arena_team_member", 25 "characters", 26 "character_action", 27 "character_aura", 28 "character_gifts", 29 "character_homebind", 30 "character_instance", 31 "character_inventory", 32 "character_kill", 33 "character_pet", 34 "character_queststatus", 35 "character_reputation", 36 "character_ticket", 37 "character_social", 38 "character_spell", 39 "character_spell_cooldown", 40 "character_tutorial", 41 "corpse", 42 "groups", 43 "group_member", 44 "guild", 45 "guild_member", 46 "guild_rank", 47 "petition", 48 "petition_sign", 49 "item_instance", 50 "mail", 51 "item_text" 22 "arena_team", 23 "arena_team_member", 24 "arena_team_stats", 25 "auctionhouse", 26 "characters", 27 "character_action", 28 "character_aura", 29 "character_gifts", 30 "character_homebind", 31 "character_instance", 32 "character_inventory", 33 "character_pet", 34 "character_queststatus", 35 "character_reputation", 36 "character_ticket", 37 "character_social", 38 "character_spell", 39 "character_spell_cooldown", 40 "character_tutorial", 41 "corpse", 42 "groups", 43 "group_member", 44 "guild", 45 "guild_bank_eventlog", 46 "guild_bank_item", 47 "guild_bank_right", 48 "guild_bank_tab", 49 "guild_member", 50 "guild_rank", 51 "instance", 52 "item_instance", 53 "item_text", 54 "mail", 55 "mail_items", 56 "petition", 57 "petition_sign", 58 "pet_aura", 59 "pet_spell", 60 "pet_spell_cooldown", 52 61 ); 53 62 54 63 //list of tables in realmd db you need to delete data on user deletion 55 64 $tab_del_user_realmd = Array( 56 57 65 Array("realmcharacters","acctid"), 66 Array("account_banned","id"), 58 67 Array("account","id") 59 68 ); … … 61 70 //list of tables in characters db you need to delete data from on user deletion 62 71 $tab_del_user_characters = Array( 63 Array("auctionhouse","itemowner"), 64 Array("character_action","guid"), 65 Array("character_aura","guid"), 66 Array("character_homebind","guid"), 67 Array("character_inventory","guid"), 68 // Array("character_kill","guid"), 69 Array("character_pet","owner"), 70 Array("character_queststatus","guid"), 71 Array("character_reputation","guid"), 72 Array("character_social","guid"), 73 Array("character_spell","guid"), 74 Array("character_spell_cooldown","guid"), 75 Array("character_ticket","guid"), 76 Array("character_tutorial","guid"), 77 Array("guild_member","guid"), 78 Array("corpse","guid"), 79 Array("groups","leaderGuid"), 80 Array("group_member","memberGuid"), 81 Array("group_member","leaderGuid"), 82 Array("mail","receiver"), 83 Array("item_instance","owner_guid"), 84 Array("character_gifts","guid"), 85 Array("character_instance","guid"), 86 Array("arena_team_member","guid"), 87 Array("petition","ownerguid"), 88 Array("petition_sign","ownerguid"), 89 Array("petition_sign","playerguid"), 90 Array("`characters`","guid") 72 Array("arena_team_member","guid"), 73 Array("auctionhouse","itemowner"), 74 Array("character_action","guid"), 75 Array("character_aura","guid"), 76 Array("character_gifts","guid"), 77 Array("character_homebind","guid"), 78 Array("character_instance","guid"), 79 Array("character_inventory","guid"), 80 Array("character_pet","owner"), 81 Array("character_queststatus","guid"), 82 Array("character_reputation","guid"), 83 Array("character_social","guid"), 84 Array("character_social","friend"), 85 Array("character_spell","guid"), 86 Array("character_spell_cooldown","guid"), 87 Array("character_ticket","guid"), 88 Array("character_tutorial","guid"), 89 Array("corpse","player"), 90 Array("groups","leaderGuid"), 91 Array("group_member","memberGuid"), 92 Array("group_member","leaderGuid"), 93 Array("guild_member","guid"), 94 Array("item_instance","owner_guid"), 95 Array("mail","receiver"), 96 Array("mail_items","receiver"), 97 Array("petition","ownerguid"), 98 Array("petition_sign","ownerguid"), 99 Array("petition_sign","playerguid"), 100 Array("characters","guid") 91 101 ); 92 102 93 103 //list of tables in realmd db you need to backup data on single user backup 94 104 $tab_backup_user_realmd = Array( 95 96 105 Array("realmcharacters","acctid"), 106 Array("account_banned","id"), 97 107 Array("account","id") 98 108 ); … … 100 110 //list of tables in characters db you need to backup data from on single user backup 101 111 $tab_backup_user_characters = Array( 102 Array("character_action","guid"), 103 Array("character_aura","guid"), 104 Array("character_homebind","guid"), 105 Array("character_inventory","guid"), 106 // Array("character_kill","guid"), 107 Array("character_pet","owner"), 108 Array("character_queststatus","guid"), 109 Array("character_reputation","guid"), 110 Array("character_social","guid"), 111 Array("character_spell","guid"), 112 Array("character_spell_cooldown","guid"), 113 Array("character_ticket","guid"), 114 Array("character_tutorial","guid"), 115 Array("corpse","guid"), 116 Array("item_instance","owner_guid"), 117 Array("character_gifts","guid"), 118 Array("character_instance","guid"), 119 Array("characters","guid") 112 Array("arena_team_member","guid"), 113 Array("auctionhouse","itemowner"), 114 Array("character_action","guid"), 115 Array("character_aura","guid"), 116 Array("character_gifts","guid"), 117 Array("character_homebind","guid"), 118 Array("character_inventory","guid"), 119 Array("character_pet","owner"), 120 Array("character_queststatus","guid"), 121 Array("character_reputation","guid"), 122 Array("character_social","guid"), 123 Array("character_social","friend"), 124 Array("character_spell","guid"), 125 Array("character_spell_cooldown","guid"), 126 Array("character_ticket","guid"), 127 Array("character_tutorial","guid"), 128 Array("corpse","player"), 129 Array("groups","leaderGuid"), 130 Array("group_member","memberGuid"), 131 Array("group_member","leaderGuid"), 132 Array("guild_member","guid"), 133 Array("item_instance","owner_guid"), 134 Array("mail","receiver"), 135 Array("mail_items","receiver"), 136 Array("petition","ownerguid"), 137 Array("petition_sign","ownerguid"), 138 Array("petition_sign","playerguid"), 139 Array("characters","guid") 120 140 ); 121 141 ?>
Note:
See TracChangeset
for help on using the changeset viewer.