нужна помощь Проблема С Базой!

[STALKER1989 15]

сам бантик не хочет видеть базу, а навикат видит базу как это понять!!!!

вот бантик, может нужно указать путь к бину????

@echo off

TITLE Database Installer

 

set user=root

set pass=3131313131

set DBname=pw

set DBHost=localhost --port=3306

 

REM ######################################## :home

:home

cls

echo.Database Installer

echo.

echo.(1) Login

echo.(2) Game

echo.

echo.(3) Custom patches

echo.

echo.(0) Exit

echo.

set button=x

set /p button=cmd:

if /i %button%==1 goto login

if /i %button%==2 goto game

if /i %button%==3 goto patches

if /i %button%==0 goto exit

goto home

 

REM ######################################## :login

:login

cls

echo.Database Installer: login

echo.

echo.(1) Install.

echo.(2) Back.

echo.

echo.(0) Exit.

echo.

set button=x

set /p button=cmd:

if /i %button%==1 goto login_exe

if /i %button%==2 goto home

if /i %button%==0 goto exit

goto login

 

REM ######################################## :game

:game

cls

echo.Database Installer: game

echo.

echo.(1) Install.

echo.(2) Back.

echo.

echo.(0) Exit.

echo.

set button=x

set /p button=cmd:

if /i %button%==1 goto game_exe

if /i %button%==2 goto home

if /i %button%==0 goto exit

goto game

 

REM ######################################## :patches

:patches

cls

echo.Database Installer: patches

echo.

echo.(1) PvP Drop // Only adena, life stones, clan eggs and epic jewerly.

echo.(2) Noblesse Skill // Give Blessing of Noblesse to all characters.

echo.(3) Return Skill // Give Return to all characters.

echo.(4) 0 Adena // Sell any item to NPC with 0 adena.

echo.(9) Back.

echo.

echo.(0) Exit.

echo.

set button=x

set /p button=cmd:

if /i %button%==1 goto pvp_drop

if /i %button%==2 goto noble_skill

if /i %button%==3 goto return_skill

if /i %button%==4 goto null_prices

if /i %button%==9 goto home

if /i %button%==0 goto exit

goto patches

 

REM ######################################## :pvp_drop

:pvp_drop

echo.

echo.Database Installer: patches: install

echo.

echo Loading... pvp_drop.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < patches/pvp_drop.sql

echo...completed.

echo.

echo.pvp_drop installed!

echo.

pause

goto home

REM ######################################## :noble_skill

:noble_skill

echo.

echo.Database Installer: patches: install

echo.

echo Loading... noble_skill.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < patches/noble_skill.sql

echo...completed.

echo.

echo.noble_skill installed!

echo.

pause

goto home

REM ######################################## :return_skill

:return_skill

echo.

echo.Database Installer: patches: install

echo.

echo Loading... return_skill.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < patches/return_skill.sql

echo...completed.

echo.

echo.return_skill installed!

echo.

pause

goto home

REM ######################################## :null_prices

:null_prices

echo.

echo.Database Installer: patches: install

echo.

echo Loading... null_prices.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < patches/null_prices.sql

echo...completed.

echo.

echo.null_prices installed!

echo.

pause

goto home

 

REM ######################################## :login_exe

:login_exe

echo.

echo.Database Installer: login: install

echo.

echo Loading... accounts.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < login/accounts.sql

echo Loading... gameservers.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < login/gameservers.sql

echo...completed.

echo.

echo.login installed!

echo.

pause

goto home

 

REM ######################################## :game_exe

:game_exe

echo.

echo.Database Installer: game: install

echo.

echo General tables...

echo Loading... armor.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/armor.sql

echo Loading... armorsets.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/armorsets.sql

echo Loading... auction.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/auction.sql

echo Loading... auction_bid.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/auction_bid.sql

echo Loading... auction_watch.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/auction_watch.sql

echo Loading... auto_chat.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/auto_chat.sql

echo Loading... auto_chat_text.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/auto_chat_text.sql

echo Loading... boxaccess.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/boxaccess.sql

echo Loading... boxes.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/boxes.sql

echo Loading... buff_templates.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/buff_templates.sql

echo Loading... castle.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/castle.sql

echo Loading... castle_door.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/castle_door.sql

echo Loading... castle_doorupgrade.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/castle_doorupgrade.sql

echo Loading... castle_manor_procure.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/castle_manor_procure.sql

echo Loading... castle_manor_production.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/castle_manor_production.sql

echo Loading... castle_siege_guards.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/castle_siege_guards.sql

echo Loading... char_templates.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/char_templates.sql

echo Loading... character_friends.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/character_friends.sql

echo Loading... character_hennas.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/character_hennas.sql

echo Loading... character_macroses.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/character_macroses.sql

echo Loading... character_offline.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/character_offline.sql

echo Loading... character_quests.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/character_quests.sql

echo Loading... character_raid_points.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/character_raid_points.sql

echo Loading... character_recipebook.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/character_recipebook.sql

echo Loading... character_recommends.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/character_recommends.sql

echo Loading... character_settings.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/character_settings.sql

echo Loading... character_shortcuts.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/character_shortcuts.sql

echo Loading... character_skills.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/character_skills.sql

echo Loading... character_skills_save.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/character_skills_save.sql

echo Loading... character_subclasses.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/character_subclasses.sql

echo Loading... characters.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/characters.sql

echo Loading... clan_data.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/clan_data.sql

echo Loading... clan_privs.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/clan_privs.sql

echo Loading... clan_skills.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/clan_skills.sql

echo Loading... clan_subpledges.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/clan_subpledges.sql

echo Loading... clan_wars.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/clan_wars.sql

echo Loading... clanhall.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/clanhall.sql

echo Loading... clanhall_functions.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/clanhall_functions.sql

echo Loading... class_list.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/class_list.sql

echo Loading... connection_test_table.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/connection_test_table.sql

echo Loading... cursed_weapons.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/cursed_weapons.sql

echo Loading... dimensional_rift.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/dimensional_rift.sql

echo Loading... droplist.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/droplist.sql

echo Loading... enchant_skill_trees.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/enchant_skill_trees.sql

echo Loading... etcitem.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/etcitem.sql

echo Loading... fish.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/fish.sql

echo Loading... fishing_skill_trees.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/fishing_skill_trees.sql

echo Loading... forums.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/forums.sql

echo Loading... four_sepulchers_spawnlist.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/four_sepulchers_spawnlist.sql

echo Loading... games.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/games.sql

echo Loading... global_tasks.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/global_tasks.sql

echo Loading... grandboss_data.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/grandboss_data.sql

echo Loading... grandboss_list.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/grandboss_list.sql

echo Loading... helper_buff_list.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/helper_buff_list.sql

echo Loading... henna.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/henna.sql

echo Loading... henna_trees.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/henna_trees.sql

echo Loading... heroes.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/heroes.sql

echo Loading... imp_tomb_spawnlist.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/imp_tomb_spawnlist.sql

echo Loading... items.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/items.sql

echo Loading... itemsonground.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/itemsonground.sql

echo Loading... locations.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/locations.sql

echo Loading... lvlupgain.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/lvlupgain.sql

echo Loading... mapregion.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/mapregion.sql

echo Loading... merchant_areas_list.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/merchant_areas_list.sql

echo Loading... merchant_buylists.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/merchant_buylists.sql

echo Loading... merchant_lease.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/merchant_lease.sql

echo Loading... merchant_shopids.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/merchant_shopids.sql

echo Loading... merchants.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/merchants.sql

echo Loading... minions.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/minions.sql

echo Loading... mods_wedding.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/mods_wedding.sql

echo Loading... npc.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/npc.sql

echo Loading... npcskills.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/npcskills.sql

echo Loading... olympiad_diaries.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/olympiad_diaries.sql

echo Loading... olympiad_nobles.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/olympiad_nobles.sql

echo Loading... party_match.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/party_match.sql

echo Loading... pets.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/pets.sql

echo Loading... pets_stats.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/pets_stats.sql

echo Loading... pledge_skill_trees.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/pledge_skill_trees.sql

echo Loading... posts.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/posts.sql

echo Loading... quest_global_data.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/quest_global_data.sql

echo Loading... raidboss_points.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/raidboss_points.sql

echo Loading... raidboss_spawnlist.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/raidboss_spawnlist.sql

echo Loading... raidboss_status.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/raidboss_status.sql

echo Loading... random_spawn.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/random_spawn.sql

echo Loading... random_spawn_loc.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/random_spawn_loc.sql

echo Loading... server_variables.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/server_variables.sql

echo Loading... seven_signs.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/seven_signs.sql

echo Loading... seven_signs_festival.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/seven_signs_festival.sql

echo Loading... seven_signs_status.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/seven_signs_status.sql

echo Loading... siege_clans.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/siege_clans.sql

echo Loading... skill_learn.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/skill_learn.sql

echo Loading... skill_spellbooks.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/skill_spellbooks.sql

echo Loading... skill_trees.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/skill_trees.sql

echo Loading... spawnlist.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/spawnlist.sql

echo Loading... teleport.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/teleport.sql

echo Loading... topic.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/topic.sql

echo Loading... walker_routes.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/walker_routes.sql

echo Loading... weapon.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/weapon.sql

echo Loading... zone_vertices.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/zone_vertices.sql

echo...completed.

echo Custom tables...

echo Loading... z_donate_skills.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_donate_skills.sql

echo Loading... z_bbs_auction.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_bbs_auction.sql

echo Loading... z_bbs_mail.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_bbs_mail.sql

echo Loading... z_buff_profile.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_buff_profile.sql

echo Loading... z_char_keys.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_char_keys.sql

echo Loading... z_fc_players.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_fc_players.sql

echo Loading... z_maxonline.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_maxonline.sql

echo Loading... z_moderator.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_moderator.sql

echo Loading... z_moderator_log.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_moderator_log.sql

echo Loading... z_post_adrbook.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_post_adrbook.sql

echo Loading... z_post_in.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_post_in.sql

echo Loading... z_post_out.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_post_out.sql

echo Loading... z_post_pos.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_post_pos.sql

echo Loading... z_post_stat.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_post_stat.sql

echo Loading... z_safety_trade.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_safety_trade.sql

echo Loading... z_stock_accounts.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_stock_accounts.sql

echo Loading... z_stock_items.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_stock_items.sql

echo Loading... z_stock_logs.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_stock_logs.sql

echo Loading... z_vote_names.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_vote_names.sql

echo Loading... z_vote_logs.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/z_vote_logs.sql

echo Loading... zz_donate_log.sql

mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < game/zz_donate_log.sql

echo...completed.

echo.

echo.game installed!

pause

goto home

 

REM ######################################## :exit

:exit

Изменено 7 марта, 2014 пользователем STALKER1989

[Gatsby 269]

Хз дайте тв посмотрим, и под спойлер засуньте .

[STALKER1989 15]

я не могу понять навикат базу видит , а вот сервер туда залить не может свою базу!!! как это понимать!!!

[STALKER1989 15]

пишет типо база несуществует!!!

[SoFace 315]

О господи. Да уберите уже этого неадекватного...

[STALKER1989 15]

О господи. Да уберите уже этого неадекватного...

неадекватная это ты

[SoFace 315]

неадекватная это ты

Ага.