Problem with NCDB, Giving rep to whoever helps me through this

[Xeneth]

:confused:

Alright, I just got the latest NCDB revision off of SVN

NCDB r780

And something's up with the "Tool.sh"

Everytime I edit it to my settings. I keep getting the same error

[FAILURE] You did not change the proper directives in this file.
[FAILURE] Please Edit this script and fill in the proper MYSQL Information.
[FAILURE] When the information is correct: Please Try Again.
Press any key to continue . . .

Here's my Tool.sh file.

#!/bin/bash
# Academico's tool for NCDB
user="root"
pass="ascent"
wdb="ascent_world"
cdb="ascent_logon"
server="127.0.0.1"
devpath=Development/Database
pubpath=Releases

until [ $letter == x ]
do

clear
echo           "####################################"
echo           "#######     Next Chapter     #######"
echo           "######        Database        ######"
echo           "#######     Import Tool      #######"
echo           "####################################"
echo
echo        "Please type the letter for the option:"

echo         "w = Install NCDB World Database"
echo         "c = Install NCDB Clean Character Database"
echo
echo         "b - Backup Characters/Acounts Data"
echo         "r - Restore Characters/Accounts Data"
echo
echo         "d - Debug"
echo         "x - Exit"

read -p "Enter option:  " letter

if [ ! $letter ]; then    
echo    
echo "Enter correct option... "    
read -p "Press any key to try again..."
echo    
else
   if [ $letter == w ]; then
    echo "[Importing] Started..."
    for i in $( ls $devpath/tables_world/*.sql -C -1 | cut -d'.' -f1 );
    do
          if [ $i != "Development/Database/tables_world/character_tables" ]; then
              echo "[Importing]" $i.sql...
              mysql -h $server --user=$user --password=$pass $wdb < $i.sql
          fi
    done
    echo "Importing Finished..."
   fi

   if [ $letter == c  ]; then
       clear
       echo        "! ! !   W A R N I N G   ! ! !"
       echo
        echo
       echo        "This will DELETE all existing Character data"
       echo        "from the database!"
       echo
       echo        "Are you sure you want to:"
       echo        "Install clean Character Database?"
       echo
        echo         "'yes' or 'no'"
       read -p "Enter option: " resp
       if [ $resp != "yes"  ]; then
        echo "Aborting..."
        exit
       else
        echo "[Importing] Started..."
        echo "[Importing] Importing Character/Account tables..."
        mysql -h $server --user=$user --password=$pass $cdb < $pubpath/character.sql
        echo "[Importing] Finished"
        echo                    
    fi           
   fi
   
   if [ $letter == b  ]; then
    echo "[Backing Up] Started..."
    echo "[Backing Up] User Accounts and Characters..."
    mysqldump -h $server --user=$user --password=$pass $cdb accounts auctions characters charters corpses gm_tickets guilds guild_ranks instances ipbans mailbox playeritems playerpets playerpetspells playersummonspells questlog playercooldownitems playercooldownsecurity social tutorials > $pubpath/Backups/characters_backup.sql
    echo "[Backing Up] Finished"    
   fi

   if [ $letter == r  ]; then
       clear
       echo        "! ! !   W A R N I N G   ! ! !"
    echo
       echo
       echo        "This will DELETE all existing Character data"
       echo        "from the database!"
       echo
       echo        "Are you sure you want to:"
       echo        "Restore Character Database from a file?"
       echo
       echo        "'yes' or 'no'"
       read -p "Enter option: " resp
       if [ $resp != "yes"  ]; then
           echo "Aborting..."
               exit
        else
           echo "[Restoring] Started..."
               echo "[Restoring] User Accounts and Characters..."
               mysql -h $server --user=$user --password=$pass $cdb < $pubpath/Backups/characters_backup.sql
               echo "[Restoring] Finished"
               echo
       fi
   fi

   if [ $letter == d  ]; then 
       clear 
       echo    "####################################" 
       echo     "######     Next Chapter       ######" 
       echo    "#####        Database          #####" 
       echo    "######      Debug Tool        ######"
       echo    "####################################" 
       echo 
       echo    "User = $user"
       echo    "Password = $pass" 
       echo    "World DB = $wdb" 
       echo    "Char DB = $cdb"
       echo    "Server = $server" 
       echo    "Development Directory Path = $devpath"
       echo    "Releases Directory Path = $pubpath"
   fi

fi
if [ $letter != x ]; then
echo
read -p "press a key to continue..."
echo
fi
echo "Thanks for using NCDB tool!!"
done

This is all I have to change right?!

Plus Rep to anyone who helps

[Steph]

Use tool.bat:

@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=password
REM  wdb  -  is the World Database
REM  cdb -  is the Character Database
REM If you do not have them seperated then set them to the same values
set wdb=ncdbclean
set cdb=ncdb
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
set devpath=.DevelopmentDatabase
set pubpath=.Releases
set mysqlpath=.DevelopmentDatabaseMYSQL
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% == CHANGEME GOTO id10t
if %pass% == CHANGEME GOTO id10t
:menu
cls
ECHO.
ECHO.
ECHO		####################################
ECHO		#######     Next Chapter     #######
ECHO		######        Database        ######
ECHO		#######     Import Tool      #######
ECHO		####################################
ECHO.
ECHO		Please type the letter for the option:
ECHO.
ECHO		 w = Install NCDB World Database.
ECHO.
ECHO		 b - Backup Characters/Acounts Data.
ECHO		 r - Restore Characters/Accounts Data.
ECHO.
ECHO		 d - Debug
ECHO		 x - Exit
ECHO.
set /p l=            Enter Letter:
if %l%==* goto error
if %l%==w goto world
if %l%==W goto world
if %l%==b goto backup
if %l%==B goto backup
if %l%==r goto check2
if %l%==R goto check2
if %l%==d goto debug
if %l%==D goto debug
if %l%==x goto quit
if %l%==X goto quit
goto error
:check2
CLS
ECHO.
ECHO.
ECHO		! ! !   W A R N I N G   ! ! !
ECHO.
ECHO.
ECHO		This will DELETE all existing Character data
ECHO		from the database!
ECHO.
ECHO		Are you sure you want to:
ECHO		Restore Character Database from a file?
ECHO.
ECHO		 y - Yes
ECHO		 n - No
ECHO.
set /p r=            Enter Letter:
if %l%==* goto menu
if %r%==y goto restore
if %r%==Y goto restore
goto menu
:world
CLS
ECHO.
ECHO.
ECHO [Importing] Started...
ECHO [Importing] Creature/NPC tables
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldai_agents.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldai_threattospellid.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldcreature_formations.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldcreature_names.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldcreature_proto.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldpetdefaultspells.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldnpc_gossip_textid.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldnpc_monstersay.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldnpc_text.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldauctionhouse.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldItemPetFood.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldTransport_creatures.sql
ECHO [Importing] Loot tables
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldcreatureloot.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldfishingloot.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worlditemloot.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worlditem_randomprop_groups.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worlditem_randomsuffix_groups.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldobjectloot.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldprospectingloot.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldpickpocketingloot.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldskinningloot.sql
ECHO [Importing] Items tables
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worlditempages.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worlditems.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldvendors.sql
ECHO [Importing] Quests tables
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldgameobject_quest_finisher.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldgameobject_quest_starter.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldcreature_quest_finisher.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldcreature_quest_starter.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldquests.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldgameobject_quest_item_binding.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldgameobject_quest_pickup_binding.sql
ECHO [Importing] Reputation On Kill Tables
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldreputation_creature_onkill.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldreputation_faction_onkill.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldreputation_instance_onkill.sql
ECHO [Importing] PlayerCreateInfo Tables
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldplayercreateinfo.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldplayercreateinfo_bars.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldplayercreateinfo_items.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldplayercreateinfo_skills.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldplayercreateinfo_spells.sql
ECHO [Importing] Spawns Tables
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldcreature_spawns.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldcreature_staticspawns.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldcreature_waypoints.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldfishing.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldgameobject_spawns.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldgameobject_staticspawns.sql
ECHO [Importing] World Related Tables
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldbanned_names.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldbanned_pharses.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldweather.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldworldmap_info.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldzoneguards.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldtransport_data.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldareatriggers.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldrecall.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldgraveyards.sql
ECHO [Importing] Trainer and Spells Related Tables
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldspellextra.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldspelloverride.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldspells112.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldspell_disable.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldspell_disable_trainers.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldteleport_coords.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldtotemspells.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldtrainer_defs.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldtrainer_spells.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldspell_proc_data.sql
ECHO [Importing] Gameobjects 
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldgameobject_names.sql
ECHO [Importing] Localize Tables
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldcreature_names_localized.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldgameobject_names_localized.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worlditempages_localized.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worlditems_localized.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldnpc_text_localized.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldquests_localized.sql
ECHO [Importing] Client Addons
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldclientaddons.sql
ECHO [Importing] Command System
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldcommand_overrides.sql
ECHO [Importing] Map Checkpoint
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldmap_checkpoint.sql
ECHO [Importing] Name filters
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldwordfilter_character_names.sql
ECHO [Importing] Chat Filters
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldwordfilter_chat.sql
ECHO [Importing] Finished
ECHO.
PAUSE    
GOTO menu
:backup
CLS
ECHO.
ECHO.
ECHO [Backing Up] Started...
ECHO [Backing Up] User Accounts and Characters...
%mysqlpath%mysqldump -h %server% --user=%user% --password=%pass% --port=%port% %cdb% account_overrides accounts arenateams auctions banned_phrases banned_names characters charters corpses gm_tickets guilds guild_ranks instances ipbans mailbox playeritems playerpets playerpetspells playersummonspells questlog playercooldownitems playercooldownsecurity social tutorials > %pubpath%Backupscharacters_backup.sql
ECHO [Backing Up] Finished
ECHO.
PAUSE    
GOTO menu
:restore
CLS
ECHO.
ECHO.
ECHO [Restoring] Started...
ECHO [Restoring] User Accounts and Characters...
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %cdb% < %pubpath%Backupscharacters_backup.sql
ECHO [Restoring] Finished
ECHO.
PAUSE    
GOTO menu  
:debug
cls
ECHO.
ECHO.
ECHO		####################################
ECHO		######     Next Chapter     ######
ECHO		#####        Database        #####
ECHO		######      Debug Tool      ######
ECHO		####################################
ECHO.
ECHO   User = %user%
ECHO   Password = %pass%
ECHO   World DB = %wdb%
ECHO   Char DB = %cdb%
ECHO   Port = %port%
ECHO   Server = %server%
ECHO   Development Directory Path = %devpath%
ECHO   Releases Directory Path = %pubpath%
ECHO   MySQL Bin Path = %mysqlpath%
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 [FAILURE] You did not change the proper directives in this file.
ECHO [FAILURE] Please edit this script and fill in the proper MYSQL Information.
ECHO [FAILURE] When the information is correct: Please Try Again.
PAUSE    
GOTO quit  
:quit

Only modify tool.bat, not tool.sh - tool.sh should not be modified!!!

[Tom_2001]

no no dude

wait there ill post a pic of myn

nvm steph beat me there pm me if you want further help?

[Steph]

He's changed the information in tool.sh, but not in tool.bat. Therefore when he runs tool.bat, there's conflicting database names, because you arent supposed to change tool.sh, ONLY change tool.bat.

[Xeneth]

I don't have a tool.bat

And what do you mean "he" >=/

[Steph]

Sorry xeneth, I apologise if you are a lady. Your name doesnt give anything away

NCDB from the SVN should look like this:

http://img210.imageshack.us/img210/900/ncdbby2.jpg

You modify the tool.bat with your database information and the batch file autoinserts the information into your chosen database.

This is just the standard way that is usually used to insert NCDB, I thought this was what you would be using, apologies if I got it wrong ><

If your tool.bat is missing, Ive uploaded mine, and the default tool.sh.

Filebeam - Free Fast File Hosting

[Xeneth]

Thanks so much +rep in advanced, I'm going to bed, but I'll try this asap and get back to you guys on this

Have a fancy night ^_^

[Xeneth]

Worked flawlessly, +rep to steph after I spread some around

[Steph]

Good morning

Glad it worked.