Нужна Помощь Installer.bat

[sneik 0]

Доброго времени суток!

 

Сделали на заказ сервер

 

Но там установщик таблиц (installer.bat) непонятный для меня

Вот такого он вида:

@echo off

TITLE Database Installer

 

set user=root

set pass=

set DBname=

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_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

 

 

 

Объясните что где там заполнять нечего не пойму,

Или можно переделать его в такой вид?

@echo off

REM ##############################################

REM ##-----------------------------##

REM ##############################################

REM Default values:

set mysqlBinPath=C:\AppServ\MySQL\bin

 

REM LOGINSERVER

set lsuser=root

set lspass=

set lsdb=

set lshost=localhost

 

REM GAMESERVER

set gsuser=root

set gspass=

set gsdb=

set gshost=localhost

 

Изменено 29 марта, 2013 пользователем sneik

[taste 501]

set user=root

set pass=

set DBname=

set DBHost=localhost --port=3306

вроде все понятно

[sneik 0]

Я зополняю эти строки но когда запускаю его выдает это

Изменено 29 марта, 2013 пользователем sneik

[sneik 0]

set user=root

set pass=

set DBname=

set DBHost=localhost --port=3306

вроде все понятно

 

Я зополняю эти строки но когда запускаю его выдает это

Изменено 29 марта, 2013 пользователем sneik

[taste 501]

ну так нажми 1 а потом 2 xD

[sneik 0]

ну так нажми 1 а потом 2 xD

 

во олень я :D

Спасибо !

[Lider 233]

я все больше ох**ю от новых людей, которые на макси появляются и пытаюстся запустить шаровые сборки. Ну ладно бы хоть серьёные вопросы были, но дошло до того, что базу не могут поставить, Telnet Сервер путают с настоящим сервером и я да же не знаю какие вопросы скоро будут!

[Gans 6]

Изменено 29 марта, 2013 пользователем Gans