Repack Publisher - dbupdate #2141
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
name: Repack Publisher - dbupdate | |
# reoacker-*.yml has to be modified at same time | |
on: | |
workflow_run: #this approach needs to be done on the default branch, does not support multiple trigger | |
workflows: ["vmangos Development DB Dump"] | |
types: | |
- completed | |
# This is what will cancel the previous workflow | |
concurrency: | |
group: ${{ github.workflow }}-${{ github.ref }} | |
cancel-in-progress: true | |
jobs: | |
on-success: | |
runs-on: windows-2019 | |
steps: | |
#git checkout | |
- uses: actions/checkout@v3 | |
#download latest bin # folder after extract: Release | |
- uses: robinraju/[email protected] | |
with: | |
repository: "vmangos/core" | |
tag: "latest" | |
fileName: "*" | |
#download latest map, # folder after extract: data | |
- uses: robinraju/[email protected] | |
with: | |
repository: "coolzoom/w1x-vmcore" | |
tag: "data-latest" | |
fileName: "*" | |
#download latest db # folder after extract: db_dump | |
- uses: robinraju/[email protected] | |
with: | |
repository: "coolzoom/w1x-vmcore" | |
tag: "db_latest" | |
fileName: "*" | |
#extract bin(Release) and database(db_dump) | |
- name: extract bin and database | |
run: | | |
fsutil volume diskfree C: | |
fsutil volume diskfree D: | |
7z x *anticheat.zip | |
7z x data.zip | |
7z x db-*.zip | |
del *.zip | |
dir | |
#extract repacker and remove old zip, folder after extract MaNGOS | |
- name: extract repacker | |
run: | | |
cd ${{github.workspace}}/contrib/repack | |
7z x *.7z | |
del *.7z | |
mkdir junk | |
#stop mysql and start portable mysql and import data | |
- name: import database | |
run: | | |
#net stop mysql | |
#taskkill /f /t /im mysqld.exe | |
cd ${{github.workspace}}/contrib/repack/MaNGOS | |
start mysql5/bin/mysqld.exe --max_allowed_packet=128M | |
- name: Create tables | |
run: | | |
cd ${{github.workspace}}/contrib/repack/MaNGOS/mysql5/bin | |
./mysql.exe -u root -proot -e "CREATE DATABASE IF NOT EXISTS realmd DEFAULT CHARSET utf8 COLLATE utf8_general_ci;" | |
./mysql.exe -u root -proot -e "CREATE DATABASE IF NOT EXISTS characters DEFAULT CHARSET utf8 COLLATE utf8_general_ci;" | |
./mysql.exe -u root -proot -e "CREATE DATABASE IF NOT EXISTS mangos DEFAULT CHARSET utf8 COLLATE utf8_general_ci;" | |
./mysql.exe -u root -proot -e "CREATE DATABASE IF NOT EXISTS logs DEFAULT CHARSET utf8 COLLATE utf8_general_ci;" | |
- name: Import data | |
run: | | |
cd ${{github.workspace}}/contrib/repack/MaNGOS/mysql5/bin | |
./mysql.exe -u root -proot realmd -e "source ${{github.workspace}}/db_dump/logon.sql" | |
./mysql.exe -u root -proot logs -e "source ${{github.workspace}}/db_dump/logs.sql" | |
./mysql.exe -u root -proot mangos -e "source ${{github.workspace}}/db_dump/mangos.sql" | |
./mysql.exe -u root -proot characters -e "source ${{github.workspace}}/db_dump/characters.sql" | |
cd ${{github.workspace}}/contrib/repack/MaNGOS | |
./"Stop MySQL.bat" | |
- name: Remove junk dir | |
uses: JesseTG/[email protected] | |
with: | |
path: ${{github.workspace}}/junk | |
- name: copy bin files | |
run: | | |
cd ${{github.workspace}} | |
copy ${{github.workspace}}/Release/realmd.exe ${{github.workspace}}/contrib/repack/MaNGOS/realmd.exe | |
copy ${{github.workspace}}/Release/mangosd.exe ${{github.workspace}}/contrib/repack/MaNGOS/mangosd.exe | |
copy ${{github.workspace}}/Release/tbb.dll ${{github.workspace}}/contrib/repack/MaNGOS/tbb.dll | |
copy ${{github.workspace}}/Release/tbb_debug.dll ${{github.workspace}}/contrib/repack/MaNGOS/tbb_debug.dll | |
copy ${{github.workspace}}/Release/tbb_preview.dll ${{github.workspace}}/contrib/repack/MaNGOS/tbb_preview.dll | |
copy ${{github.workspace}}/Release/tbb_preview_debug.dll ${{github.workspace}}/contrib/repack/MaNGOS/tbb_preview_debug.dll | |
copy ${{github.workspace}}/Release/tbbmalloc.dll ${{github.workspace}}/contrib/repack/MaNGOS/tbbmalloc.dll | |
copy ${{github.workspace}}/Release/tbbmalloc_debug.dll ${{github.workspace}}/contrib/repack/MaNGOS/tbbmalloc_debug.dll | |
copy ${{github.workspace}}/Release/tbbmalloc_proxy.dll ${{github.workspace}}/contrib/repack/MaNGOS/tbbmalloc_proxy.dll | |
copy ${{github.workspace}}/Release/tbbmalloc_proxy_debug.dll ${{github.workspace}}/contrib/repack/MaNGOS/tbbmalloc_proxy_debug.dll | |
copy ${{github.workspace}}/Release/ACE.dll ${{github.workspace}}/contrib/repack/MaNGOS/ACE.dll | |
copy ${{github.workspace}}/Release/libmysql.dll ${{github.workspace}}/contrib/repack/MaNGOS/libmysql.dll | |
# copy ${{github.workspace}}/Release/libssl-1_1-x64.dll ${{github.workspace}}/contrib/repack/MaNGOS/libssl-1_1-x64.dll | |
# copy ${{github.workspace}}/Release/libcrypto-1_1-x64.dll ${{github.workspace}}/contrib/repack/MaNGOS/libcrypto-1_1-x64.dll | |
copy ${{github.workspace}}/Release/libeay32.dll ${{github.workspace}}/contrib/repack/MaNGOS/libeay32.dll | |
- name: copy data files | |
run: | | |
cd ${{github.workspace}} | |
move ${{github.workspace}}/data/maps ${{github.workspace}}/contrib/repack/MaNGOS/data/maps | |
move ${{github.workspace}}/data/vmaps ${{github.workspace}}/contrib/repack/MaNGOS/data/vmaps | |
move ${{github.workspace}}/data/mmaps ${{github.workspace}}/contrib/repack/MaNGOS/data/mmaps | |
- name: make repack zip | |
run: | | |
fsutil volume diskfree D: | |
cd ${{github.workspace}}/contrib/repack | |
7z a -tzip repack.zip MaNGOS | |
- name: Archive this artefact | |
uses: actions/upload-artifact@v2 | |
with: | |
name: snapshot-repack | |
path: "${{github.workspace}}/contrib/repack/repack.zip" | |
- name: Download artifact snapshot-datapackage | |
uses: actions/download-artifact@v1 | |
with: | |
name: snapshot-repack | |
path: all_snapshots | |
- name: Get current date | |
id: date | |
run: echo "::set-output name=date::$(date +'%Y-%m-%d')" | |
- name: Upload snapshot | |
uses: "marvinpinto/action-automatic-releases@latest" | |
with: | |
repo_token: "${{ secrets.GITHUB_TOKEN }}" | |
automatic_release_tag: "repack-latest" | |
prerelease: true | |
title: "Repack (${{ steps.date.outputs.date }})" | |
files: all_snapshots |