diff options
-rwxr-xr-x | localserver/givegm.sh | 8 | ||||
-rwxr-xr-x | localserver/initdb.sh | 18 |
2 files changed, 26 insertions, 0 deletions
diff --git a/localserver/givegm.sh b/localserver/givegm.sh new file mode 100755 index 0000000..c1a9c28 --- /dev/null +++ b/localserver/givegm.sh @@ -0,0 +1,8 @@ +#!/bin/bash + +ID="$1" +if [[ -z "${ID}" ]]; then + mysql -u evol -pevol evol -e "update login set group_id=99 where account_id=2000000;" +else + mysql -u evol -pevol evol -e "update login set group_id=99 where account_id=${ID} or userid='${ID}';" +fi diff --git a/localserver/initdb.sh b/localserver/initdb.sh new file mode 100755 index 0000000..82f9257 --- /dev/null +++ b/localserver/initdb.sh @@ -0,0 +1,18 @@ +#!/bin/bash + +cd ../../server-data/sql-files + +echo Creating db and user... +echo Enter mysql root password: +mysql --force -u root -p <./init.sql + +export CMD="mysql -u evol -pevol evol" + +echo Creating tables... +$CMD <main.sql +$CMD <mob_skill_db.sql +$CMD <mob_skill_db2.sql +$CMD <logs.sql +$CMD <item_db_re.sql +$CMD <mob_db_re.sql +$CMD <mob_skill_db_re.sql |