add tools for managing local server.

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