DB ubdates

[furion03 0]

Stiahol som takyto instalator (nazvy si nevsimajte) ale potrebujem to pozmenit na to aby sa tu dala nakonfigurovat aj databaza

ako sa nastavuje mysql meno a pass, prosim napiste ako to prerobim aby som mohol menit db-name lebo tu je prednastavena databaza world a to samozrejme nechcem

 

 

@ECHO off

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

REM #

REM # B A S I C U S E R C O N F I G U R A T I O N A R E A

REM #

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

set user=root

set pass=ascent

REM WorldDB - world

REM If you do not have them seperated then set them to the same values

set WorldDB=ascent

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

REM #

REM # A D V A N C E D U S E R C O N F I G U R A T I O N A R E A

REM #

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

set port=3306

set server=localhost

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

REM #

REM # D O N O T M O D I F Y B E Y O N D T H I S P O I N T

REM #

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

if %user% == Write correct username

if %pass% == Write correct password

:menu

cls

ECHO.

ECHO.

ECHO

ECHO #HEROIC DB UBDATES#

ECHO

ECHO

ECHO

ECHO.

ECHO Please type the letter for the option, then enter:

ECHO.

ECHO Starting Queries:

ECHO a = Install Query: Players start with all spells!

ECHO b = Install Query: Players start with a mooncloth bag!

ECHO c = Install Query: Players start with mounts!

ECHO Other Queries:

ECHO d = Install/Fix Query: Aszhara Crater and Eye of the Storm!

ECHO e = Removing all requirements for mounts!

ECHO.

ECHO Credits to Succy, Chrispee, Latruwski and Illidan1

ECHO.

ECHO.

ECHO x - Exit

ECHO.

set /p l= Enter Letter:

if %l%==* goto error

if %l%==a goto spell

if %l%==A goto spell

if %l%==b goto mooncloth

if %l%==B goto mooncloth

if %l%==c goto mounts

if %l%==C goto mounts

if %l%==d goto ae

if %l%==D goto ae

if %l%==e goto nor

if %l%==E goto nor

if %l%==x goto quit

if %l%==X goto quit

goto error

:spell

CLS

ECHO.

ECHO.

ECHO [importing] Query for: Players start with all spells! ...

mysql -h %server% --user=%user% --password=%pass% --port=%port% %WorldDB% < startspells.sql

ECHO [importing] Finished! You can now restart your server!

ECHO.

PAUSE

GOTO menu

:mooncloth

CLS

ECHO.

ECHO.

ECHO [importing] Query for: Players start with a mooncloth bag! ...

mysql -h %server% --user=%user% --password=%pass% --port=%port% %WorldDB% < mooncloth.sql

ECHO [importing] Finished! You can now restart your server!

ECHO.

PAUSE

GOTO menu

:mounts

CLS

ECHO.

ECHO.

ECHO [importing] Query for: Players start with mounts! ...

mysql -h %server% --user=%user% --password=%pass% --port=%port% %WorldDB% < mounts.sql

ECHO [importing] Finished! You can now restart your server!

ECHO.

PAUSE

GOTO menu

:ae

CLS

ECHO.

ECHO.

ECHO [Fixing/Installing] Azshara Crater and Eye of the Storm accessable!

mysql -h %server% --user=%user% --password=%pass% --port=%port% %WorldDB% < eots.sql

mysql -h %server% --user=%user% --password=%pass% --port=%port% %WorldDB% < Azsharacrater.sql

ECHO [Fixed/Installed] Finished! You can now restart your server and then access Azshara Crater and Eye of the Storm

ECHO [info] Recall for Eye of the Storm: .recall port eots, Recall for Azshara: .recall port Crater!

ECHO.

PAUSE

GOTO menu

:nor

CLS

ECHO.

ECHO.

ECHO [importing] Query for: Removing requirements for mounts!

mysql -h %server% --user=%user% --password=%pass% --port=%port% %WorldDB% < norequire.sql

ECHO [importing] Finished! You can now restart your server!

ECHO.

PAUSE

GOTO menu

:error

CLS

ECHO.

ECHO.

ECHO [ERROR] An error has occured, you will be directed back to the

ECHO [ERROR] main menu.

PAUSE

GOTO menu

:id10t

CLS

ECHO.

ECHO.

ECHO [FAIL] You did not change the proper directives in this file.

ECHO [FAIL] Please edit this script and fill in the proper MYSQL Information.

ECHO [FAIL] When the information is correct: Please Try Again.

PAUSE

GOTO quit

:quit

 

 

 

Inak snazime sa robit ubdaty na databazy ak ma niekto chut budeme radi ak pomoze.

 

[.eLhomer0. 12]

set user=root
set pass=ascent
REM WorldDB - world
REM If you do not have them seperated then set them to the same values
set WorldDB=ascent

 

Tady to máš..