#!/bin/sh # Importeur WhyDB FR linux server="127.0.0.1" devpath=Developpement/Monde mysqlpath=Developpement/Divers/MySQL user=root echo " Bienvenue dans l'importeur." echo " Veuillez inserer :" read -p " Nom d'Utilisation MySQL : " user read -p " Mot de Passe MySQL : " pass read -p " Le nom de la BDD Monde : " db read -p " Le nom de la BDD des Perso/Comptes : " acc until [ $option == quitter ] do clear echo " ==========================================================" echo " | |" echo " | WHYDB FR, BDD FRANCOPHONE |" echo " | |" echo " ==========================================================" echo echo " 1 - Importer la Base de Données Monde" echo " 2 - Importer la Base de Données des Comptes et Personnages" echo echo " Taper simplement sur Entrée pour fermer le programme." echo option=quitter read -p " Entrez un chiffre : " option if [ $option == 1 ]; then echo echo " Suppression de la Base de Données Monde et création de celle-ci." $mysqlpath\mysqldump -h $server --user=$user --password=$pass --add-drop-table --no-data $db | grep ^DROP | $mysqlpath\mysql -h $server --user=$user --password=$pass $db echo " Début de l'importation de la Base de Données Monde." echo " Importation de la table ai_agents (1/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/ai_agents.sql" echo " Importation de la table ai_threattospellid (2/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/ai_threattospellid.sql" echo " Importation de la table areatriggers (3/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/areatriggers.sql" echo " Importation de la table auctionhouse (4/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/auctionhouse.sql" echo " Importation de la table banned_phrases (5/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/banned_phrases.sql" echo " Importation de la table clientaddons (6/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/clientaddons.sql" echo " Importation de la table command_overrides (7/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/command_overrides.sql" echo " Importation de la table creature_formations (8/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/creature_formations.sql" echo " Importation de la table creature_names (9/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/creature_names.sql" echo " Importation de la table creature_names_localized (10/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/creature_names_localized.sql" echo " Importation de la table creature_proto (11/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/creature_proto.sql" echo " Importation de la table creature_quest_finisher (12/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/creature_quest_finisher.sql" echo " Importation de la table creature_quest_starter (13/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/creature_quest_starter.sql" echo " Importation de la table creature_spawns (14/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/creature_spawns.sql" echo " Importation de la table creature_staticspawns (15/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/creature_staticspawns.sql" echo " Importation de la table creature_timed_emotes (16/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/creature_timed_emotes.sql" echo " Importation de la table creature_waypoints (17/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/creature_waypoints.sql" echo " Importation de la table creatureloot (18/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/creatureloot.sql" echo " Importation de la table disenchantingloot (19/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/disenchantingloot.sql" echo " Importation de la table fishing (20/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/fishing.sql" echo " Importation de la table fishingloot (21/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/fishingloot.sql" echo " Importation de la table gameobject_names (22/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/gameobject_names.sql" echo " Importation de la table gameobject_names_localized (23/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/gameobject_names_localized.sql" echo " Importation de la table gameobject_quest_finisher (24/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/gameobject_quest_finisher.sql" echo " Importation de la table gameobject_quest_item_binding (25/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/gameobject_quest_item_binding.sql" echo " Importation de la table gameobject_quest_pickup_binding (26/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/gameobject_quest_pickup_binding.sql" echo " Importation de la table gameobject_quest_starter (27/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/gameobject_quest_starter.sql" echo " Importation de la table gameobject_spawns (28/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/gameobject_spawns.sql" echo " Importation de la table gameobject_staticspawns (29/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/gameobject_staticspawns.sql" echo " Importation de la table graveyards (30/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/graveyards.sql" echo " Importation de la table instance_bosses (31/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/instance_bosses.sql" echo " Importation de la table item_quest_association (32/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/item_quest_association.sql" echo " Importation de la table item_randomprop_groups (33/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/item_randomprop_groups.sql" echo " Importation de la table item_randomsuffix_groups (34/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/item_randomsuffix_groups.sql" echo " Importation de la table itemloot (35/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/itemloot.sql" echo " Importation de la table itempages (36/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/itempages.sql" echo " Importation de la table itempages_localized (37/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/itempages_localized.sql" echo " Importation de la table itempetfood (38/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/itempetfood.sql" echo " Importation de la table items (39/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/items.sql" echo " Importation de la table items_localized (40/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/items_localized.sql" echo " Importation de la table map_checkpoint (41/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/map_checkpoint.sql" echo " Importation de la table npc_gossip_textid (42/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/npc_gossip_textid.sql" echo " Importation de la table npc_monstersay (43/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/npc_monstersay.sql" echo " Importation de la table npc_text (44/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/npc_text.sql" echo " Importation de la table npc_text_localized (45/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/npc_text_localized.sql" echo " Importation de la table objectloot (46/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/objectloot.sql" echo " Importation de la table petdefaultspells (47/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/petdefaultspells.sql" echo " Importation de la table pickpocketingloot (48/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/pickpocketingloot.sql" echo " Importation de la table playercreateinfo (49/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/playercreateinfo.sql" echo " Importation de la table playercreateinfo_bars (50/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/playercreateinfo_bars.sql" echo " Importation de la table playercreateinfo_items (51/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/playercreateinfo_items.sql" echo " Importation de la table playercreateinfo_skills (52/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/playercreateinfo_skills.sql" echo " Importation de la table playercreateinfo_spells (53/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/playercreateinfo_spells.sql" echo " Importation de la table professiondiscoveries (54/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/professiondiscoveries.sql" echo " Importation de la table prospectingloot (55/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/prospectingloot.sql" echo " Importation de la table quests (56/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/quests.sql" echo " Importation de la table quests_localized (57/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/quests_localized.sql" echo " Importation de la table recall (58/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/recall.sql" echo " Importation de la table reputation_creature_onkill (59/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/reputation_creature_onkill.sql" echo " Importation de la table reputation_faction_onkill (60/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/reputation_faction_onkill.sql" echo " Importation de la table reputation_instance_onkill (61/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/reputation_instance_onkill.sql" echo " Importation de la table skinningloot (62/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/skinningloot.sql" echo " Importation de la table spell_coef_override (63/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/spell_coef_override.sql" echo " Importation de la table spell_disable (64/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/spell_disable.sql" echo " Importation de la table spell_disable_trainers (65/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/spell_disable_trainers.sql" echo " Importation de la table spell_effects_override (66/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/spell_effects_override.sql" echo " Importation de la table spell_proc (67/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/spell_proc.sql" echo " Importation de la table spellfixes (68/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/spellfixes.sql" echo " Importation de la table spelloverride (69/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/spelloverride.sql" echo " Importation de la table teleport_coords (70/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/teleport_coords.sql" echo " Importation de la table totemspells (71/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/totemspells.sql" echo " Importation de la table trainer_defs (72/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/trainer_defs.sql" echo " Importation de la table trainer_spells (73/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/trainer_spells.sql" echo " Importation de la table trainerspelloverride (74/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/trainerspelloverride.sql" echo " Importation de la table transport_creatures (75/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/transport_creatures.sql" echo " Importation de la table transport_data (76/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/transport_data.sql" echo " Importation de la table unit_display_sizes (77/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/unit_display_sizes.sql" echo " Importation de la table vendors (78/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/vendors.sql" echo " Importation de la table weather (79/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/weather.sql" echo " Importation de la table wordfilter_character_names (80/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/wordfilter_character_names.sql" echo " Importation de la table wordfilter_chat (81/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/wordfilter_chat.sql" echo " Importation de la table worldmap_info (82/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/worldmap_info.sql" echo " Importation de la table worldmap_info_localized (83/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/worldmap_info_localized.sql" echo " Importation de la table worldstring_tables (84/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/worldstring_tables.sql" echo " Importation de la table worldstring_tables_localized (85/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/worldstring_tables_localized.sql" echo " Importation de la table zoneguards (86/86)" $mysqlpath\mysql -h $server --user=$user --password=$pass $db < "./Developpement/Monde/zoneguards.sql" echo " Importation terminée." echo read -p " Appuyez sur une touche pour continuer..." fi if [ $option == 2 ]; then echo echo " Suppression de la Base de Données des Comptes/Personnages et création de celle-ci." $mysqlpath\mysqldump -h $server --user=$user --password=$pass --add-drop-table --no-data $acc | grep ^DROP | $mysqlpath\mysql -h $server --user=$user --password=$pass $acc echo " Début de l'importation de la Base de Données des Comptes et Personnages." echo echo " Importation de la table account_data (1/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/account_data.sql" echo " Importation de la table account_forced_permissions (2/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/account_forced_permissions.sql" echo " Importation de la table accounts (3/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Comptes/accounts.sql" echo " Importation de la table arenateams (4/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/arenateams.sql" echo " Importation de la table auctions (5/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/auctions.sql" echo " Importation de la table banned_names (6/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/banned_names.sql" echo " Importation de la table characters (7/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/characters.sql" echo " Importation de la table characters_insert_queue (8/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/characters_insert_queue.sql" echo " Importation de la table charters (9/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/charters.sql" echo " Importation de la table clientaddons (10/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/clientaddons.sql" echo " Importation de la table command_overrides (11/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/command_overrides.sql" echo " Importation de la table corpses (12/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/corpses.sql" echo " Importation de la table gm_tickets (13/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/gm_tickets.sql" echo " Importation de la table groups (14/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/groups.sql" echo " Importation de la table guild_bankitems (15/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/guild_bankitems.sql" echo " Importation de la table guild_banklogs (16/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/guild_banklogs.sql" echo " Importation de la table guild_banktabs (17/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/guild_banktabs.sql" echo " Importation de la table guild_data (18/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/guild_data.sql" echo " Importation de la table guild_logs (19/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/guild_logs.sql" echo " Importation de la table guild_ranks (20/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/guild_ranks.sql" echo " Importation de la table guilds (21/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/guilds.sql" echo " Importation de la table instanceids (22/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/instanceids.sql" echo " Importation de la table instances (23/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/instances.sql" echo " Importation de la table ipbans (24/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Comptes/ipbans.sql" echo " Importation de la table mailbox (25/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/mailbox.sql" echo " Importation de la table mailbox_insert_queue (26/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/mailbox_insert_queue.sql" echo " Importation de la table playercooldowns (27/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/playercooldowns.sql" echo " Importation de la table playeritems (28/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/playeritems.sql" echo " Importation de la table playeritems_insert_queue (29/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/playeritems_insert_queue.sql" echo " Importation de la table playerpets (30/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/playerpets.sql" echo " Importation de la table playerpetspells (31/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/playerpetspells.sql" echo " Importation de la table playersummons (32/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/playersummons.sql" echo " Importation de la table playersummonspells (33/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/playersummonspells.sql" echo " Importation de la table questlog (34/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/questlog.sql" echo " Importation de la table server_settings (35/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/server_settings.sql" echo " Importation de la table social_friends (36/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/social_friends.sql" echo " Importation de la table social_ignores (37/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/social_ignores.sql" echo " Importation de la table tutorials (38/38)" $mysqlpath\mysql -h $server --user=$user --password=$pass $acc < "./Developpement/Personnages/tutorials.sql" echo " Importation terminée." echo read -p " Appuyez sur une touche pour continuer..." fi if [ $option != quitter ]; then echo read -p " Appuyez sur une touche pour continuer..." echo fi done