setup_notes.txt

TODOs:

# Fix acore/tcore and classic characters! Drop and import from other sql
# files, issue with updates then? Would be so nice if I could just import
# all characters instead for all servers... sql diff somehow?
# Fix wow_classic config.wtf etc if needed...

# wotlk-simulationscraft (MY) compile and test!

******************************************
TODO:
blpconverter, wowmapview broken compiles?...

###############################################################
###
# vmangos install notes
###

cd $HOME/Documents/my_notes/sql/wow
mysql -u root -p
source vmangos.sql

cd $HOME/Code2/C++/core/sql
mysql -u root -p
use vmangos_logs
source logs.sql

use vmangos_characters
source characters.sql

use vmangos_realmd
source logon.sql

exit and cd to $HOME/Code2/C++/vmangos_db
sudo apt-get install p7zip-full
7z x world_full_14_june_2021.7z
use vmangos_mangos
source world_full_14_june_2021.sql

cd $HOME/Code2/C++/core/sql/migrations
run merge.sh

Then do:
use vmangos_logs
source logs_db_updates.sql

use vmangos_characters
source characters_db_updates.sql

use vmangos_realmd
source logon_db_updates.sql

use vmangos_mangos
source world_db_updates.sql

Also execute this in vmangos_realmd:
INSERT INTO realmlist (name, address) VALUES ('vmangos', '127.0.0.1');

account create vmangos 123
account set gmlevel vmangos 6

###
# cmangos install notes
###

cd $HOME/Documents/my_notes/sql/wow
source cmangos_create.sql

cd $HOME/Code2/C++/classic-db
run ./InstallFullDB.sh once and quit to generate config

Edit config with this:
MYSQL_USERNAME="cmangos"
MYSQL_PASSWORD="cmangos"
AHBOT="YES"
PLAYERBOTS_DB="YES"

run ./InstallFullDB.sh again and press 4. enter root and pass press 1 (Full
default...)

account create cmangos 123
account set gmlevel cmangos 3

###
# mangoszero install notes
###

When running install script in mangoszero_db, press n at start and then only
change password default

account create mangoszero 123
account set gmlevel mangoszero 3

###
# TrinityCore (manual installation)
###

Download latest 3.3.5 db from: https://github.com/TrinityCore/TrinityCore/releases
Place in ~/tcore/bin
source create_mysql.sl in $HOME/Code2/C++/Trinitycore-3.3.5-with-NPCBots/sql/create
cp authserver.conf.dist authserver.conf
cp worldserver.conf.dist worldserver.conf
start worldserver

mkdir -p $HOME/Code2/Wow/general
cd $HOME/Code2/Wow/general
git clone --recurse-submodules https://github.com/trickerer/Trinity-Bots
cd $HOME/Code2/Wow/general/Trinity-Bots/SQL

wow_classic: prevent message about restore default settings...
Also fix one wow startup script and call classic / 3.3.5 depending on server...

Trinity-Bots setup:
mysql -u root -p
use world
source 1_world_bot_appearance.sql
source 2_world_bot_extras.sql
source 3_world_bots.sql
source 4_world_generate_bot_equips.sql
source 5_world_botgiver.sql
use characters
source characters_bots.sql

chmod +x merge_sqls_world_unix.sh
./merge_sqls_world_unix.sh

chmod +x merge_sqls_characters_unix.sh
./merge_sqls_characters_unix.sh

chmod +x merge_sqls_auth_unix.sh
./merge_sqls_auth_unix.sh

mysql -u root -p
use world
source ALL_word.sql

use characters
source ALL_characters.sql

use auth
source ALL_auth.sql

Some updates were missing from trinity-bots repo so I had to install the two
updates (1 character and 1 world) in rewow repo updates...). Source the ones
later than 2024_03_19...
Copy overwrite.py and gdb.conf to $HOME/tcore/bin

###
# AzerothCore (manual installation)
###

cd $HOME/Code2/C++/AzerothCore-wotlk-with-NPCBots/data/sql/create
mysql -u root -p
source create_mysql.sql
cp authserver.conf.dist authserver.conf
cp worldserver.conf.dist worldserver.conf
Run worldserver...
Apply customworldboss sql ($HOME/Code2/Wow/lua/azerothcore_lua_scripts/Acore_eventScripts/database/world/customWorldboss.sql)

###############################################################

###
# To test after compilations
###

# openmw
./openmw-launcher and select game data path
run ./openmw from: /usr/local/bin (should be in path)

# OpenJK
.openjk

# re3
cp $HOME/Code/c++/re3/bin/linux-amd64-librw_gl3_glfw-oal/Release/re3 to $DOWNLOADS_DIR/gta3/

# re3_vice
cp $HOME/Code/c++/re3_vice/bin/linux-amd64-librw_gl3_glfw-oal/Release/reVC to $DOWNLOADS_DIR/gta_vice

# ioq3
.ioq3

# stk
.stk

# OpenJKDF2
cp openjkdf2 $HOME/.local/share/OpenJKDF2/openjkdf2/
Run in $HOME/.local/share/OpenJKDF2/openjkdf2/

# japp
.japp

# reone
TODO...

# JediKnightGalaxies
copy base dir to:
$HOME/Downloads/ja_data/JediAcademy
then copy: cp JKGalaxies/JKG_Defaults.cfg $HOME/Downloads/ja_data/JediAcademy

# jk2mv, not compiled??? source build-and-install.sh
Copy pk3 (jo) to $HOME/Code/c++/jk2mv/build/Linux-x86_64-install/out/Release
run from: /usr/local/bin (should be in path)

# Unvanquished
$HOME/Code/c++/Unvanquished/build

# KotOR
$HOME/Code/js/KotOR.js

# small_games
$HOME/Code2/C++/small_games/BirdGame
$HOME/Code2/C++/small_games/CPP_FightingGame/FightingGameProject
$HOME/Code2/C++/small_games/Craft
$HOME/Code2/C++/small_games/pacman/build
$HOME/Code2/C++/small_games/space-shooter/build

# devilutionX
$HOME/Code2/C++/devilutionX/build

# crispy:
$HOME/Code2/C++/crispy-doom/src

# dhewm3
$HOME/Code2/C++/dhewm3/build

# simc
$HOME/Code2/C++/simc/build/qt
or:
$HOME/Code2/C++/simc/build

# Svea
TODO...

# utils
TODO...

# wotlk-sim
$HOME/Code2/Go/wotlk-sim
./wowsimwotlk
Maybe also do: Make host

# OpenDiablo2
$HOME/Code2/Go/OpenDiablo2

# my_js
$HOME/Code2/Javascript/my_js/Testing/mysql
$HOME/Code2/Javascript/my_js/Testing/navigation/ffi-napi

# wander_nodes_util
TODO: Compile wander nodes!

# azeroth-web
Run script in my_notes
proxy: npm start
web: npm install -g typescript
npm run dev

# spelunker
Run $HOME/Documents/my_notes/scripts/wow/spelunker/setup.sh
start file server and do:
source ../../.envrc && npm start in both spelunker-api and spelunker-web

# wowser
Run script in my_notes
npm run serve
npm run web-dev

# wowmapview
./wowmapview -gamepath /mnt/new/wow_classic/

# wowmapviewer
./wowmapview -gamepath /mnt/new/cata/Data/

# WebWoWViewer
start file server
npm run start

# WebWoWViewercpp
./AWebWoWViewerCpp