From 8c023395258e35e78464155de47c03341630d288 Mon Sep 17 00:00:00 2001
From: Andrei Karas <akaras@inbox.ru>
Date: Mon, 1 Dec 2014 00:38:00 +0300
Subject: add tools for managing local server.

---
 localserver/givegm.sh |  8 ++++++++
 localserver/initdb.sh | 18 ++++++++++++++++++
 2 files changed, 26 insertions(+)
 create mode 100755 localserver/givegm.sh
 create mode 100755 localserver/initdb.sh

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
-- 
cgit v1.2.3-70-g09d2