teris2 Posted January 24, 2010 Posted January 24, 2010 Re paidia deixte m ekei pou kaneis Confing ti mysql_instal deixte m pou prepei na balw to Version #!/bin/bash ############################################ ## WARNING! WARNING! WARNING! WARNING! ## ## ## ## DON'T USE NOTEPAD TO CHANGE THIS FILE ## ## INSTEAD USE SOME DECENT TEXT EDITOR. ## ## NEWLINE CHARACTERS DIFFER BETWEEN DOS/ ## ## WINDOWS AND UNIX. ## ## ## ## USING NOTEPAD TO SAVE THIS FILE WILL ## ## LEAVE IT IN A BROKEN STATE!!! ## ############################################ ## Writen by DrLecter ## ## License: GNU GPL ## ## Based on Tiago Tagliaferri's script ## ## E-mail: tiago_tagliaferri@msn.com ## ## From "L2J-DataPack" ## ## Bug reports: http://l2jdp.com/trac ## ############################################ trap finish 2 configure() { echo "#############################################" echo "# You entered script configuration area #" echo "# No change will be performed in your DB #" echo "# I will just ask you some questions about #" echo "# your hosts and DB. #" echo "#############################################" MYSQLDUMPPATH=`which -a mysqldump 2>/dev/null` MYSQLPATH=`which -a mysql 2>/dev/null` if [ $? -ne 0 ]; then echo "We were unable to find MySQL binaries on your path" while : do echo -ne "\nPlease enter MySQL binaries directory (no trailing slash): " read MYSQLBINPATH if [ -e "$MYSQLBINPATH" ] && [ -d "$MYSQLBINPATH" ] && \ [ -e "$MYSQLBINPATH/mysqldump" ] && [ -e "$MYSQLBINPATH/mysql" ]; then MYSQLDUMPPATH="$MYSQLBINPATH/mysqldump" MYSQLPATH="$MYSQLBINPATH/mysql" break else echo "The data you entered is invalid. Please verify and try again." exit 1 fi done fi #LS echo -ne "\nPlease enter MySQL Login Server hostname (default localhost): " read LSDBHOST if [ -z "$LSDBHOST" ]; then LSDBHOST="localhost" fi echo -ne "\nPlease enter MySQL Login Server database name (default l2jdb): " read LSDB if [ -z "$LSDB" ]; then LSDB="l2jdb" fi echo -ne "\nPlease enter MySQL Login Server user (default root): " read LSUSER if [ -z "$LSUSER" ]; then LSUSER="root" fi echo -ne "\nPlease enter MySQL Login Server $LSUSER's password (won't be displayed) :" stty -echo read LSPASS stty echo echo "" if [ -z "$LSPASS" ]; then echo "Hum.. I'll let it be but don't be stupid and avoid empty passwords" elif [ "$LSUSER" == "$LSPASS" ]; then echo "You're not too brilliant choosing passwords huh?" fi #GS echo -ne "\nPlease enter MySQL Game Server hostname (default $LSDBHOST): " read GSDBHOST if [ -z "$GSDBHOST" ]; then GSDBHOST="$LSDBHOST" fi echo -ne "\nPlease enter MySQL Game Server database name (default $LSDB): " read GSDB if [ -z "$GSDB" ]; then GSDB="$LSDB" fi echo -ne "\nPlease enter MySQL Game Server user (default $LSUSER): " read GSUSER if [ -z "$GSUSER" ]; then GSUSER="$LSUSER" fi echo -ne "\nPlease enter MySQL Game Server $GSUSER's password (won't be displayed): " stty -echo read GSPASS stty echo echo "" if [ -z "$GSPASS" ]; then echo "Hum.. I'll let it be but don't be stupid and avoid empty passwords" elif [ "$GSUSER" == "$GSPASS" ]; then echo "You're not too brilliant choosing passwords huh?" fi save_config $1 } save_config() { if [ -n "$1" ]; then CONF="$1" else CONF="database_installer.rc" fi echo "" echo "With these data I can generate a configuration file which can be read" echo "on future updates. WARNING: this file will contain clear text passwords!" echo -ne "Shall I generate config file $CONF? (Y/n):" read SAVE if [ "$SAVE" == "y" -o "$SAVE" == "Y" -o "$SAVE" == "" ];then cat <<EOF>$CONF #Configuration settings for L2J-Datapack database installer script MYSQLDUMPPATH=$MYSQLDUMPPATH MYSQLPATH=$MYSQLPATH LSDBHOST=$LSDBHOST LSDB=$LSDB LSUSER=$LSUSER LSPASS=$LSPASS GSDBHOST=$GSDBHOST GSDB=$GSDB GSUSER=$GSUSER GSPASS=$GSPASS EOF chmod 600 $CONF echo "Configuration saved as $CONF" echo "Permissions changed to 600 (rw- --- ---)" elif [ "$SAVE" != "n" -a "$SAVE" != "N" ]; then save_config fi } load_config() { if [ -n "$1" ]; then CONF="$1" else CONF="database_installer.rc" fi if [ -e "$CONF" ] && [ -f "$CONF" ]; then . $CONF else echo "Settings file not found: $CONF" echo "You can specify an alternate settings filename:" echo $0 config_filename echo "" echo "If file doesn't exist it can be created" echo "If nothing is specified script will try to work with ./database_installer.rc" echo "" configure $CONF fi } asklogin(){ echo "#############################################" echo "# WARNING: This section of the script CAN #" echo "# destroy your characters and accounts #" echo "# information. Read questions carefully #" echo "# before you reply. #" echo "#############################################" echo "" echo "Choose full (f) if you don't have and 'accounts' table or would" echo "prefer to erase the existing accounts information." echo "Choose skip (s) to skip loginserver DB installation and go to" echo "gameserver DB installation/upgrade." echo -ne "LOGINSERVER DB install type: (f) full, (s) skip or (q) quit? " read LOGINPROMPT case "$LOGINPROMPT" in "f"|"F") logininstall; loginupgrade; gsbackup; asktype;; "s"|"S") gsbackup; asktype;; "q"|"Q") finish;; *) asklogin;; esac } logininstall(){ echo "Deleting loginserver tables for new content." $MYL < login_install.sql &> /dev/null } loginupgrade(){ echo "Installling new loginserver content." $MYL < ../sql/accounts.sql &> /dev/null $MYL < ../sql/account_data.sql &> /dev/null $MYL < ../sql/gameservers.sql &> /dev/null } gsbackup(){ while : do echo "" echo -ne "Do you want to make a backup copy of your GSDB? (y/n): " read LSB if [ "$LSB" == "Y" -o "$LSB" == "y" ]; then echo "Making a backup of the original gameserver database." $MYSQLDUMPPATH --add-drop-table -h $GSDBHOST -u $GSUSER --password=$GSPASS $GSDB > gameserver_backup.sql if [ $? -ne 0 ];then echo "" echo "There was a problem accesing your GS database, either it wasnt created or authentication data is incorrect." exit 1 fi break elif [ "$LSB" == "n" -o "$LSB" == "N" ]; then break fi done } lsbackup(){ while : do echo "" echo -ne "Do you want to make a backup copy of your LSDB? (y/n): " read LSB if [ "$LSB" == "Y" -o "$LSB" == "y" ]; then echo "Making a backup of the original loginserver database." $MYSQLDUMPPATH --add-drop-table -h $LSDBHOST -u $LSUSER --password=$LSPASS $LSDB > loginserver_backup.sql if [ $? -ne 0 ];then echo "" echo "There was a problem accesing your LS database, either it wasnt created or authentication data is incorrect." exit 1 fi break elif [ "$LSB" == "n" -o "$LSB" == "N" ]; then break fi done } asktype(){ echo "" echo "" echo "WARNING: A full install (f) will destroy all existing character data." echo -ne "GAMESERVER DB install type: (f) full install, (u) upgrade, (s) skip or (q) quit? " read INSTALLTYPE case "$INSTALLTYPE" in "f"|"F") fullinstall; upgradeinstall I; custom;; "u"|"U") upgradeinstall U; custom;; "s"|"S") custom;; "q"|"Q") finish;; *) asktype;; esac } fullinstall(){ echo "Deleting all gameserver tables for new content." $MYG < full_install.sql &> /dev/null } upgradeinstall(){ if [ "$1" == "I" ]; then echo "Installling new gameserver content." else echo "Upgrading gameserver content" fi if [ "$1" == "I" ]; then $MYG < ../sql/access_levels.sql &> /dev/null $MYG < ../sql/auction.sql &> /dev/null $MYG < ../sql/castle.sql &> /dev/null $MYG < ../sql/clanhall.sql &> /dev/null $MYG < ../sql/fort.sql &> /dev/null $MYG < ../sql/forums.sql &> /dev/null $MYG < ../sql/grandboss_data.sql &> /dev/null $MYG < ../sql/npc_buffer.sql &> /dev/null $MYG < ../sql/seven_signs_festival.sql &> /dev/null $MYG < ../sql/seven_signs_status.sql &> /dev/null fi $MYG < ../sql/admin_command_access_rights.sql &> /dev/null $MYG < ../sql/armor.sql &> /dev/null $MYG < ../sql/armorsets.sql &> /dev/null $MYG < ../sql/auction_bid.sql &> /dev/null $MYG < ../sql/auction_watch.sql &> /dev/null $MYG < ../sql/auto_announcements.sql &> /dev/null $MYG < ../sql/auto_chat.sql &> /dev/null $MYG < ../sql/auto_chat_text.sql &> /dev/null $MYG < ../sql/castle_door.sql &> /dev/null $MYG < ../sql/castle_doorupgrade.sql &> /dev/null $MYG < ../sql/castle_functions.sql &> /dev/null $MYG < ../sql/castle_manor_procure.sql &> /dev/null $MYG < ../sql/castle_manor_production.sql &> /dev/null $MYG < ../sql/castle_siege_guards.sql &> /dev/null $MYG < ../sql/char_templates.sql &> /dev/null $MYG < ../sql/char_creation_items.sql &> /dev/null $MYG < ../sql/character_friends.sql &> /dev/null $MYG < ../sql/character_hennas.sql &> /dev/null $MYG < ../sql/character_instance_time.sql &> /dev/null $MYG < ../sql/character_macroses.sql &> /dev/null $MYG < ../sql/character_quest_global_data.sql &> /dev/null $MYG < ../sql/character_quests.sql &> /dev/null $MYG < ../sql/character_raid_points.sql &> /dev/null $MYG < ../sql/character_recipebook.sql &> /dev/null $MYG < ../sql/character_recommends.sql &> /dev/null $MYG < ../sql/character_shortcuts.sql &> /dev/null $MYG < ../sql/character_skills.sql &> /dev/null $MYG < ../sql/character_skills_save.sql &> /dev/null $MYG < ../sql/character_subclasses.sql &> /dev/null $MYG < ../sql/character_tpbookmark.sql &> /dev/null $MYG < ../sql/characters.sql &> /dev/null $MYG < ../sql/clan_data.sql &> /dev/null $MYG < ../sql/clan_notices.sql &> /dev/null $MYG < ../sql/clan_privs.sql &> /dev/null $MYG < ../sql/clan_skills.sql &> /dev/null $MYG < ../sql/clan_subpledges.sql &> /dev/null $MYG < ../sql/clan_wars.sql &> /dev/null $MYG < ../sql/clanhall_functions.sql &> /dev/null $MYG < ../sql/class_list.sql &> /dev/null $MYG < ../sql/cursed_weapons.sql &> /dev/null $MYG < ../sql/dimensional_rift.sql &> /dev/null $MYG < ../sql/droplist.sql &> /dev/null $MYG < ../sql/enchant_skill_trees.sql &> /dev/null $MYG < ../sql/etcitem.sql &> /dev/null $MYG < ../sql/fish.sql &> /dev/null $MYG < ../sql/fishing_skill_trees.sql &> /dev/null $MYG < ../sql/fort_doorupgrade.sql &> /dev/null $MYG < ../sql/fort_functions.sql &> /dev/null $MYG < ../sql/fort_siege_guards.sql &> /dev/null $MYG < ../sql/fort_spawnlist.sql &> /dev/null $MYG < ../sql/fort_staticobjects.sql &> /dev/null $MYG < ../sql/fortsiege_clans.sql &> /dev/null $MYG < ../sql/four_sepulchers_spawnlist.sql &> /dev/null $MYG < ../sql/games.sql &> /dev/null $MYG < ../sql/global_tasks.sql &> /dev/null $MYG < ../sql/grandboss_list.sql &> /dev/null $MYG < ../sql/helper_buff_list.sql &> /dev/null $MYG < ../sql/henna.sql &> /dev/null $MYG < ../sql/henna_trees.sql &> /dev/null $MYG < ../sql/heroes.sql &> /dev/null $MYG < ../sql/item_attributes.sql &> /dev/null $MYG < ../sql/items.sql &> /dev/null $MYG < ../sql/itemsonground.sql &> /dev/null $MYG < ../sql/locations.sql &> /dev/null $MYG < ../sql/lvlupgain.sql &> /dev/null $MYG < ../sql/mapregion.sql &> /dev/null $MYG < ../sql/merchant_areas_list.sql &> /dev/null $MYG < ../sql/merchant_buylists.sql &> /dev/null $MYG < ../sql/merchant_lease.sql &> /dev/null $MYG < ../sql/merchant_shopids.sql &> /dev/null $MYG < ../sql/merchants.sql &> /dev/null $MYG < ../sql/minions.sql &> /dev/null $MYG < ../sql/npc.sql &> /dev/null $MYG < ../sql/npcskills.sql &> /dev/null $MYG < ../sql/olympiad_data.sql &> /dev/null $MYG < ../sql/olympiad_nobles.sql&> /dev/null $MYG < ../sql/olympiad_nobles_eom.sql&> /dev/null $MYG < ../sql/pets.sql &> /dev/null $MYG < ../sql/pets_skills.sql &> /dev/null $MYG < ../sql/pets_stats.sql &> /dev/null $MYG < ../sql/pledge_skill_trees.sql &> /dev/null $MYG < ../sql/posts.sql &> /dev/null $MYG < ../sql/quest_global_data.sql &> /dev/null $MYG < ../sql/raidboss_spawnlist.sql &> /dev/null $MYG < ../sql/random_spawn.sql &> /dev/null $MYG < ../sql/random_spawn_loc.sql &> /dev/null $MYG < ../sql/seven_signs.sql &> /dev/null $MYG < ../sql/siege_clans.sql &> /dev/null $MYG < ../sql/skill_learn.sql &> /dev/null $MYG < ../sql/skill_spellbooks.sql &> /dev/null $MYG < ../sql/skill_trees.sql &> /dev/null $MYG < ../sql/skill_residential.sql &> /dev/null $MYG < ../sql/spawnlist.sql &> /dev/null $MYG < ../sql/special_skill_trees.sql &> /dev/null $MYG < ../sql/teleport.sql &> /dev/null $MYG < ../sql/topic.sql &> /dev/null $MYG < ../sql/transform_skill_trees.sql &> /dev/null $MYG < ../sql/walker_routes.sql &> /dev/null $MYG < ../sql/weapon.sql &> /dev/null $MYG < ../sql/zone_vertices.sql &> /dev/null newbie_helper } custom(){ echo "" echo "" echo -ne "Install custom gameserver DB tables: (y) yes or (n) no or (q) quit?" read ASKCS case "$ASKCS" in "y"|"Y") cstinstall;; "n"|"N") finish;; "q"|"Q") finish;; *) custom;; esac finish } cstinstall(){ while : do echo "" echo -ne "Do you want to make another backup of GSDB before applying custom contents? (y/N): " read LSB if [ "$LSB" == "Y" -o "$LSB" == "y" ]; then echo "Making a backup of the default gameserver tables." $MYSQLDUMPPATH --add-drop-table -h $GSDBHOST -u $GSUSER --password=$GSPASS $GSDB > custom_backup.sql 2> /dev/null if [ $? -ne 0 ];then echo "" echo "There was a problem accesing your GS database, server down?." exit 1 fi break elif [ "$LSB" == "n" -o "$LSB" == "N" -o "$LSB" == "" ]; then break fi done echo "Installing custom content." for custom in $(ls ../sql/custom/*.sql);do $MYG < $custom &> /dev/null done # L2J mods that needed extra tables to work properly, should be # listed here. To do so copy & paste the following 6 lines and # change them properly: # MOD: Wedding. echo -ne "Install "Wedding Mod" tables? (y/N): " read modprompt if [ "$modprompt" == "Y" -o "$LSB" == "y" ]; then $MYG < ../sql/mods/mods_wedding.sql &> /dev/null fi finish } finish(){ echo "" echo "Script execution finished." exit 0 } newbie_helper(){ while : do echo "" echo -ne "If you're not that skilled applying changes within 'updates' folder, i can try to do it for you (y). If you wish to do it on your own, choose (n). Should i parse updates files? (Y/n)" read NOB if [ "$NOB" == "Y" -o "$NOB" == "y" -o "$NOB" == "" ]; then echo "" echo "There we go, it may take some time..." echo "updates parser results. Last run: "`date` >database_installer.log for file in $(ls ../sql/updates/*sql);do echo $file|cut -d/ -f4 >> database_installer.log $MYG < $file 2>> database_installer.log if [ $? -eq 0 ];then echo "no errors">> database_installer.log fi done echo "" echo "Log available at $(pwd)/database_installer.log" echo "" break elif [ "$NOB" == "n" -o "$NOB" == "N" ]; then break fi done } clear load_config $1 MYL="$MYSQLPATH -h $LSDBHOST -u $LSUSER --password=$LSPASS -D $LSDB" MYG="$MYSQLPATH -h $GSDBHOST -u $GSUSER --password=$GSPASS -D $GSDB" lsbackup asklogin
0 Commodus Posted January 24, 2010 Posted January 24, 2010 Den to eipes kala alla epidi ego sou eipa na to kaneis auto , katalaba ti thes. Pigene sto database_installer kai pata deksi click. Bres auth thn grammh : set mysqlBinPath=C:\Program Files\MySQL\MySQL Server 5.0\bin Kai bale to path tou mysql sou . An einai auto , apla alakse to version.
0 teris2 Posted January 24, 2010 Author Posted January 24, 2010 re file gia des esy mia edo kanto copy kai xromatise mou tin grami giati den tin briskw #!/bin/bash ############################################ ## WARNING! WARNING! WARNING! WARNING! ## ## ## ## DON'T USE NOTEPAD TO CHANGE THIS FILE ## ## INSTEAD USE SOME DECENT TEXT EDITOR. ## ## NEWLINE CHARACTERS DIFFER BETWEEN DOS/ ## ## WINDOWS AND UNIX. ## ## ## ## USING NOTEPAD TO SAVE THIS FILE WILL ## ## LEAVE IT IN A BROKEN STATE!!! ## ############################################ ## Writen by DrLecter ## ## License: GNU GPL ## ## Based on Tiago Tagliaferri's script ## ## E-mail: tiago_tagliaferri@msn.com ## ## From "L2J-DataPack" ## ## Bug reports: http://l2jdp.com/trac ## ############################################ trap finish 2 configure() { echo "#############################################" echo "# You entered script configuration area #" echo "# No change will be performed in your DB #" echo "# I will just ask you some questions about #" echo "# your hosts and DB. #" echo "#############################################" MYSQLDUMPPATH=`which -a mysqldump 2>/dev/null` MYSQLPATH=`which -a mysql 2>/dev/null` if [ $? -ne 0 ]; then echo "We were unable to find MySQL binaries on your path" while : do echo -ne "\nPlease enter MySQL binaries directory (no trailing slash): " read MYSQLBINPATH if [ -e "$MYSQLBINPATH" ] && [ -d "$MYSQLBINPATH" ] && \ [ -e "$MYSQLBINPATH/mysqldump" ] && [ -e "$MYSQLBINPATH/mysql" ]; then MYSQLDUMPPATH="$MYSQLBINPATH/mysqldump" MYSQLPATH="$MYSQLBINPATH/mysql" break else echo "The data you entered is invalid. Please verify and try again." exit 1 fi done fi #LS echo -ne "\nPlease enter MySQL Login Server hostname (default localhost): " read LSDBHOST if [ -z "$LSDBHOST" ]; then LSDBHOST="localhost" fi echo -ne "\nPlease enter MySQL Login Server database name (default l2jdb): " read LSDB if [ -z "$LSDB" ]; then LSDB="l2jdb" fi echo -ne "\nPlease enter MySQL Login Server user (default root): " read LSUSER if [ -z "$LSUSER" ]; then LSUSER="root" fi echo -ne "\nPlease enter MySQL Login Server $LSUSER's password (won't be displayed) :" stty -echo read LSPASS stty echo echo "" if [ -z "$LSPASS" ]; then echo "Hum.. I'll let it be but don't be stupid and avoid empty passwords" elif [ "$LSUSER" == "$LSPASS" ]; then echo "You're not too brilliant choosing passwords huh?" fi #GS echo -ne "\nPlease enter MySQL Game Server hostname (default $LSDBHOST): " read GSDBHOST if [ -z "$GSDBHOST" ]; then GSDBHOST="$LSDBHOST" fi echo -ne "\nPlease enter MySQL Game Server database name (default $LSDB): " read GSDB if [ -z "$GSDB" ]; then GSDB="$LSDB" fi echo -ne "\nPlease enter MySQL Game Server user (default $LSUSER): " read GSUSER if [ -z "$GSUSER" ]; then GSUSER="$LSUSER" fi echo -ne "\nPlease enter MySQL Game Server $GSUSER's password (won't be displayed): " stty -echo read GSPASS stty echo echo "" if [ -z "$GSPASS" ]; then echo "Hum.. I'll let it be but don't be stupid and avoid empty passwords" elif [ "$GSUSER" == "$GSPASS" ]; then echo "You're not too brilliant choosing passwords huh?" fi save_config $1 } save_config() { if [ -n "$1" ]; then CONF="$1" else CONF="database_installer.rc" fi echo "" echo "With these data I can generate a configuration file which can be read" echo "on future updates. WARNING: this file will contain clear text passwords!" echo -ne "Shall I generate config file $CONF? (Y/n):" read SAVE if [ "$SAVE" == "y" -o "$SAVE" == "Y" -o "$SAVE" == "" ];then cat <<EOF>$CONF #Configuration settings for L2J-Datapack database installer script MYSQLDUMPPATH=$MYSQLDUMPPATH MYSQLPATH=$MYSQLPATH LSDBHOST=$LSDBHOST LSDB=$LSDB LSUSER=$LSUSER LSPASS=$LSPASS GSDBHOST=$GSDBHOST GSDB=$GSDB GSUSER=$GSUSER GSPASS=$GSPASS EOF chmod 600 $CONF echo "Configuration saved as $CONF" echo "Permissions changed to 600 (rw- --- ---)" elif [ "$SAVE" != "n" -a "$SAVE" != "N" ]; then save_config fi } load_config() { if [ -n "$1" ]; then CONF="$1" else CONF="database_installer.rc" fi if [ -e "$CONF" ] && [ -f "$CONF" ]; then . $CONF else echo "Settings file not found: $CONF" echo "You can specify an alternate settings filename:" echo $0 config_filename echo "" echo "If file doesn't exist it can be created" echo "If nothing is specified script will try to work with ./database_installer.rc" echo "" configure $CONF fi } asklogin(){ echo "#############################################" echo "# WARNING: This section of the script CAN #" echo "# destroy your characters and accounts #" echo "# information. Read questions carefully #" echo "# before you reply. #" echo "#############################################" echo "" echo "Choose full (f) if you don't have and 'accounts' table or would" echo "prefer to erase the existing accounts information." echo "Choose skip (s) to skip loginserver DB installation and go to" echo "gameserver DB installation/upgrade." echo -ne "LOGINSERVER DB install type: (f) full, (s) skip or (q) quit? " read LOGINPROMPT case "$LOGINPROMPT" in "f"|"F") logininstall; loginupgrade; gsbackup; asktype;; "s"|"S") gsbackup; asktype;; "q"|"Q") finish;; *) asklogin;; esac } logininstall(){ echo "Deleting loginserver tables for new content." $MYL < login_install.sql &> /dev/null } loginupgrade(){ echo "Installling new loginserver content." $MYL < ../sql/accounts.sql &> /dev/null $MYL < ../sql/account_data.sql &> /dev/null $MYL < ../sql/gameservers.sql &> /dev/null } gsbackup(){ while : do echo "" echo -ne "Do you want to make a backup copy of your GSDB? (y/n): " read LSB if [ "$LSB" == "Y" -o "$LSB" == "y" ]; then echo "Making a backup of the original gameserver database." $MYSQLDUMPPATH --add-drop-table -h $GSDBHOST -u $GSUSER --password=$GSPASS $GSDB > gameserver_backup.sql if [ $? -ne 0 ];then echo "" echo "There was a problem accesing your GS database, either it wasnt created or authentication data is incorrect." exit 1 fi break elif [ "$LSB" == "n" -o "$LSB" == "N" ]; then break fi done } lsbackup(){ while : do echo "" echo -ne "Do you want to make a backup copy of your LSDB? (y/n): " read LSB if [ "$LSB" == "Y" -o "$LSB" == "y" ]; then echo "Making a backup of the original loginserver database." $MYSQLDUMPPATH --add-drop-table -h $LSDBHOST -u $LSUSER --password=$LSPASS $LSDB > loginserver_backup.sql if [ $? -ne 0 ];then echo "" echo "There was a problem accesing your LS database, either it wasnt created or authentication data is incorrect." exit 1 fi break elif [ "$LSB" == "n" -o "$LSB" == "N" ]; then break fi done } asktype(){ echo "" echo "" echo "WARNING: A full install (f) will destroy all existing character data." echo -ne "GAMESERVER DB install type: (f) full install, (u) upgrade, (s) skip or (q) quit? " read INSTALLTYPE case "$INSTALLTYPE" in "f"|"F") fullinstall; upgradeinstall I; custom;; "u"|"U") upgradeinstall U; custom;; "s"|"S") custom;; "q"|"Q") finish;; *) asktype;; esac } fullinstall(){ echo "Deleting all gameserver tables for new content." $MYG < full_install.sql &> /dev/null } upgradeinstall(){ if [ "$1" == "I" ]; then echo "Installling new gameserver content." else echo "Upgrading gameserver content" fi if [ "$1" == "I" ]; then $MYG < ../sql/access_levels.sql &> /dev/null $MYG < ../sql/auction.sql &> /dev/null $MYG < ../sql/castle.sql &> /dev/null $MYG < ../sql/clanhall.sql &> /dev/null $MYG < ../sql/fort.sql &> /dev/null $MYG < ../sql/forums.sql &> /dev/null $MYG < ../sql/grandboss_data.sql &> /dev/null $MYG < ../sql/npc_buffer.sql &> /dev/null $MYG < ../sql/seven_signs_festival.sql &> /dev/null $MYG < ../sql/seven_signs_status.sql &> /dev/null fi $MYG < ../sql/admin_command_access_rights.sql &> /dev/null $MYG < ../sql/armor.sql &> /dev/null $MYG < ../sql/armorsets.sql &> /dev/null $MYG < ../sql/auction_bid.sql &> /dev/null $MYG < ../sql/auction_watch.sql &> /dev/null $MYG < ../sql/auto_announcements.sql &> /dev/null $MYG < ../sql/auto_chat.sql &> /dev/null $MYG < ../sql/auto_chat_text.sql &> /dev/null $MYG < ../sql/castle_door.sql &> /dev/null $MYG < ../sql/castle_doorupgrade.sql &> /dev/null $MYG < ../sql/castle_functions.sql &> /dev/null $MYG < ../sql/castle_manor_procure.sql &> /dev/null $MYG < ../sql/castle_manor_production.sql &> /dev/null $MYG < ../sql/castle_siege_guards.sql &> /dev/null $MYG < ../sql/char_templates.sql &> /dev/null $MYG < ../sql/char_creation_items.sql &> /dev/null $MYG < ../sql/character_friends.sql &> /dev/null $MYG < ../sql/character_hennas.sql &> /dev/null $MYG < ../sql/character_instance_time.sql &> /dev/null $MYG < ../sql/character_macroses.sql &> /dev/null $MYG < ../sql/character_quest_global_data.sql &> /dev/null $MYG < ../sql/character_quests.sql &> /dev/null $MYG < ../sql/character_raid_points.sql &> /dev/null $MYG < ../sql/character_recipebook.sql &> /dev/null $MYG < ../sql/character_recommends.sql &> /dev/null $MYG < ../sql/character_shortcuts.sql &> /dev/null $MYG < ../sql/character_skills.sql &> /dev/null $MYG < ../sql/character_skills_save.sql &> /dev/null $MYG < ../sql/character_subclasses.sql &> /dev/null $MYG < ../sql/character_tpbookmark.sql &> /dev/null $MYG < ../sql/characters.sql &> /dev/null $MYG < ../sql/clan_data.sql &> /dev/null $MYG < ../sql/clan_notices.sql &> /dev/null $MYG < ../sql/clan_privs.sql &> /dev/null $MYG < ../sql/clan_skills.sql &> /dev/null $MYG < ../sql/clan_subpledges.sql &> /dev/null $MYG < ../sql/clan_wars.sql &> /dev/null $MYG < ../sql/clanhall_functions.sql &> /dev/null $MYG < ../sql/class_list.sql &> /dev/null $MYG < ../sql/cursed_weapons.sql &> /dev/null $MYG < ../sql/dimensional_rift.sql &> /dev/null $MYG < ../sql/droplist.sql &> /dev/null $MYG < ../sql/enchant_skill_trees.sql &> /dev/null $MYG < ../sql/etcitem.sql &> /dev/null $MYG < ../sql/fish.sql &> /dev/null $MYG < ../sql/fishing_skill_trees.sql &> /dev/null $MYG < ../sql/fort_doorupgrade.sql &> /dev/null $MYG < ../sql/fort_functions.sql &> /dev/null $MYG < ../sql/fort_siege_guards.sql &> /dev/null $MYG < ../sql/fort_spawnlist.sql &> /dev/null $MYG < ../sql/fort_staticobjects.sql &> /dev/null $MYG < ../sql/fortsiege_clans.sql &> /dev/null $MYG < ../sql/four_sepulchers_spawnlist.sql &> /dev/null $MYG < ../sql/games.sql &> /dev/null $MYG < ../sql/global_tasks.sql &> /dev/null $MYG < ../sql/grandboss_list.sql &> /dev/null $MYG < ../sql/helper_buff_list.sql &> /dev/null $MYG < ../sql/henna.sql &> /dev/null $MYG < ../sql/henna_trees.sql &> /dev/null $MYG < ../sql/heroes.sql &> /dev/null $MYG < ../sql/item_attributes.sql &> /dev/null $MYG < ../sql/items.sql &> /dev/null $MYG < ../sql/itemsonground.sql &> /dev/null $MYG < ../sql/locations.sql &> /dev/null $MYG < ../sql/lvlupgain.sql &> /dev/null $MYG < ../sql/mapregion.sql &> /dev/null $MYG < ../sql/merchant_areas_list.sql &> /dev/null $MYG < ../sql/merchant_buylists.sql &> /dev/null $MYG < ../sql/merchant_lease.sql &> /dev/null $MYG < ../sql/merchant_shopids.sql &> /dev/null $MYG < ../sql/merchants.sql &> /dev/null $MYG < ../sql/minions.sql &> /dev/null $MYG < ../sql/npc.sql &> /dev/null $MYG < ../sql/npcskills.sql &> /dev/null $MYG < ../sql/olympiad_data.sql &> /dev/null $MYG < ../sql/olympiad_nobles.sql&> /dev/null $MYG < ../sql/olympiad_nobles_eom.sql&> /dev/null $MYG < ../sql/pets.sql &> /dev/null $MYG < ../sql/pets_skills.sql &> /dev/null $MYG < ../sql/pets_stats.sql &> /dev/null $MYG < ../sql/pledge_skill_trees.sql &> /dev/null $MYG < ../sql/posts.sql &> /dev/null $MYG < ../sql/quest_global_data.sql &> /dev/null $MYG < ../sql/raidboss_spawnlist.sql &> /dev/null $MYG < ../sql/random_spawn.sql &> /dev/null $MYG < ../sql/random_spawn_loc.sql &> /dev/null $MYG < ../sql/seven_signs.sql &> /dev/null $MYG < ../sql/siege_clans.sql &> /dev/null $MYG < ../sql/skill_learn.sql &> /dev/null $MYG < ../sql/skill_spellbooks.sql &> /dev/null $MYG < ../sql/skill_trees.sql &> /dev/null $MYG < ../sql/skill_residential.sql &> /dev/null $MYG < ../sql/spawnlist.sql &> /dev/null $MYG < ../sql/special_skill_trees.sql &> /dev/null $MYG < ../sql/teleport.sql &> /dev/null $MYG < ../sql/topic.sql &> /dev/null $MYG < ../sql/transform_skill_trees.sql &> /dev/null $MYG < ../sql/walker_routes.sql &> /dev/null $MYG < ../sql/weapon.sql &> /dev/null $MYG < ../sql/zone_vertices.sql &> /dev/null newbie_helper } custom(){ echo "" echo "" echo -ne "Install custom gameserver DB tables: (y) yes or (n) no or (q) quit?" read ASKCS case "$ASKCS" in "y"|"Y") cstinstall;; "n"|"N") finish;; "q"|"Q") finish;; *) custom;; esac finish } cstinstall(){ while : do echo "" echo -ne "Do you want to make another backup of GSDB before applying custom contents? (y/N): " read LSB if [ "$LSB" == "Y" -o "$LSB" == "y" ]; then echo "Making a backup of the default gameserver tables." $MYSQLDUMPPATH --add-drop-table -h $GSDBHOST -u $GSUSER --password=$GSPASS $GSDB > custom_backup.sql 2> /dev/null if [ $? -ne 0 ];then echo "" echo "There was a problem accesing your GS database, server down?." exit 1 fi break elif [ "$LSB" == "n" -o "$LSB" == "N" -o "$LSB" == "" ]; then break fi done echo "Installing custom content." for custom in $(ls ../sql/custom/*.sql);do $MYG < $custom &> /dev/null done # L2J mods that needed extra tables to work properly, should be # listed here. To do so copy & paste the following 6 lines and # change them properly: # MOD: Wedding. echo -ne "Install "Wedding Mod" tables? (y/N): " read modprompt if [ "$modprompt" == "Y" -o "$LSB" == "y" ]; then $MYG < ../sql/mods/mods_wedding.sql &> /dev/null fi finish } finish(){ echo "" echo "Script execution finished." exit 0 } newbie_helper(){ while : do echo "" echo -ne "If you're not that skilled applying changes within 'updates' folder, i can try to do it for you (y). If you wish to do it on your own, choose (n). Should i parse updates files? (Y/n)" read NOB if [ "$NOB" == "Y" -o "$NOB" == "y" -o "$NOB" == "" ]; then echo "" echo "There we go, it may take some time..." echo "updates parser results. Last run: "`date` >database_installer.log for file in $(ls ../sql/updates/*sql);do echo $file|cut -d/ -f4 >> database_installer.log $MYG < $file 2>> database_installer.log if [ $? -eq 0 ];then echo "no errors">> database_installer.log fi done echo "" echo "Log available at $(pwd)/database_installer.log" echo "" break elif [ "$NOB" == "n" -o "$NOB" == "N" ]; then break fi done } clear load_config $1 MYL="$MYSQLPATH -h $LSDBHOST -u $LSUSER --password=$LSPASS -D $LSDB" MYG="$MYSQLPATH -h $GSDBHOST -u $GSUSER --password=$GSPASS -D $GSDB" lsbackup asklogin
0 Commodus Posted January 24, 2010 Posted January 24, 2010 Den tin exei . Alla mporei na eine to default path . Anikse to database installer kai kane install tin database sou.
0 teris2 Posted January 24, 2010 Author Posted January 24, 2010 Mou leei to systima den einai se kathorismeni thesi ... #!/bin/bash <-------- Mhpws einai auto????? ############################################ ## WARNING! WARNING! WARNING! WARNING! ## ## ## ## DON'T USE NOTEPAD TO CHANGE THIS FILE ## ## INSTEAD USE SOME DECENT TEXT EDITOR. ## ## NEWLINE CHARACTERS DIFFER BETWEEN DOS/ ## ## WINDOWS AND UNIX. ## ## ## ## USING NOTEPAD TO SAVE THIS FILE WILL ## ## LEAVE IT IN A BROKEN STATE!!! ## ############################################ ## Writen by DrLecter ## ## License: GNU GPL ## ## Based on Tiago Tagliaferri's script ## ## E-mail: tiago_tagliaferri@msn.com ## ## From "L2J-DataPack" ## ## Bug reports: http://l2jdp.com/trac ## #################################
0 Lucky Dice Posted January 24, 2010 Posted January 24, 2010 Mou leei to systima den einai se kathorismeni thesi ... #!/bin/bash <-------- Mhpws einai auto????? ############################################ ## WARNING! WARNING! WARNING! WARNING! ## ## ## ## DON'T USE NOTEPAD TO CHANGE THIS FILE ## ## INSTEAD USE SOME DECENT TEXT EDITOR. ## ## NEWLINE CHARACTERS DIFFER BETWEEN DOS/ ## ## WINDOWS AND UNIX. ## ## ## ## USING NOTEPAD TO SAVE THIS FILE WILL ## ## LEAVE IT IN A BROKEN STATE!!! ## ############################################ ## Writen by DrLecter ## ## License: GNU GPL ## ## Based on Tiago Tagliaferri's script ## ## E-mail: tiago_tagliaferri@msn.com ## ## From "L2J-DataPack" ## ## Bug reports: http://l2jdp.com/trac ## ################################# lol oxi. kane Install k ama sou bgalei error post.
0 Commodus Posted January 24, 2010 Posted January 24, 2010 Bale to path tou mysql sou ekei kai ksanadokimase. lol oxi. kane Install k ama sou bgalei error post. auto pige na kanei kai tou ebgale auto to error.
0 teris2 Posted January 24, 2010 Author Posted January 24, 2010 Nai file sou eipa to kano install kai pata f opos prepei kai mou leei to systima den einai se kathorismeni thesi
0 Yakamoto Posted January 24, 2010 Posted January 24, 2010 Adenas: 801.00 View Inventory Send Money to teris2 View Profile Email Personal Message (Online) Re: Pos na kanw instal ti Mysql « Reply #2 on: Today at 09:34:16 PM » Reply with quoteQuote re file gia des esy mia edo kanto copy kai xromatise mou tin grami giati den tin briskw #!/bin/bash ############################################ ## WARNING! WARNING! WARNING! WARNING! ## ## ## ## DON'T USE NOTEPAD TO CHANGE THIS FILE ## ## INSTEAD USE SOME DECENT TEXT EDITOR. ## ## NEWLINE CHARACTERS DIFFER BETWEEN DOS/ ## ## WINDOWS AND UNIX. ## ## ## ## USING NOTEPAD TO SAVE THIS FILE WILL ## ## LEAVE IT IN A BROKEN STATE!!! ## ############################################ ## Writen by DrLecter ## ## License: GNU GPL ## ## Based on Tiago Tagliaferri's script ## ## E-mail: tiago_tagliaferri@msn.com ## ## From "L2J-DataPack" ## ## Bug reports: http://l2jdp.com/trac ## ############################################ trap finish 2 configure() { echo "#############################################" echo "# You entered script configuration area #" echo "# No change will be performed in your DB #" echo "# I will just ask you some questions about #" echo "# your hosts and DB. #" echo "#############################################" MYSQLDUMPPATH=`which -a mysqldump 2>/dev/null` MYSQLPATH=`which -a mysql 2>/dev/null` if [ $? -ne 0 ]; then echo "We were unable to find MySQL binaries on your path" while : do echo -ne "\nPlease enter MySQL binaries directory (no trailing slash): " read MYSQLBINPATH if [ -e "$MYSQLBINPATH" ] && [ -d "$MYSQLBINPATH" ] && \ [ -e "$MYSQLBINPATH/mysqldump" ] && [ -e "$MYSQLBINPATH/mysql" ]; then MYSQLDUMPPATH="$MYSQLBINPATH/mysqldump" MYSQLPATH="$MYSQLBINPATH/mysql" break
0 Commodus Posted January 24, 2010 Posted January 24, 2010 file mia erotisi me " ????? Nai. Auto edw prepei na alakseis : $MYSQLBINPATH/mysql ti pack xrisimopheis? Fenetai sto database_installer tou. Den xriazotan na kaneis auto to post. L2J xrhsimopoiei.
0 teris2 Posted January 24, 2010 Author Posted January 24, 2010 MYSQLPATH="C:\Program Files\MySQL\MySQL Server 6.0\bin\mysql.exe" file etc prepei na eiani Verison 6.0 exw
0 Yakamoto Posted January 24, 2010 Posted January 24, 2010 C:\Program Files\MySQL\MySQL Server 6.0\bin etc prepei na einai
0 Lucky Dice Posted January 24, 2010 Posted January 24, 2010 MYSQLPATH="C:\Program Files\MySQL\MySQL Server 6.0\bin\mysql.exe" file etc prepei na eiani Verison 6.0 exw nai. btw @Commodus den to eixa dei.
0 Yakamoto Posted January 24, 2010 Posted January 24, 2010 nai. btw @Commodus den to eixa dei. den einai etc re min les malakies C:\Program Files\MySQL\MySQL Server 6.0\bin etc prepei na to exei
Question
teris2
Re paidia deixte m ekei pou kaneis Confing ti mysql_instal deixte m pou prepei na balw to Version
24 answers to this question
Recommended Posts