hercules: convert to char_reg_num_db.sql

2 files changed, 36 insertions, 2 deletions

diff --git a/hercules/code/server/db/charregnumdb.py b/hercules/code/server/db/charregnumdb.py
new file mode 100644
index 0000000..b1446e3
--- /dev/null
+++ b/hercules/code/server/db/charregnumdb.py
@@ -0,0 +1,32 @@
+# -*- coding: utf8 -*-
+#
+# Copyright (C) 2015  Evol Online
+# Author: Andrei Karas (4144)
+
+from code.fileutils import *
+from code.stringutils import *
+
+def saveCharRegNumDbTable(users):
+    dstFile = "newdb/char_reg_num_db.sql"
+    firstLine = True
+    tpl = readFile("templates/char_reg_num_db.sql")
+    with open(dstFile, "w") as w:
+        w.write(tpl)
+        w.write("INSERT INTO `char_reg_num_db` VALUES ")
+        for userId in users:
+            user = users[userId]
+            for varKey in user.variables:
+                varValue = user.variables[varKey]
+
+                if firstLine == False:
+                    w.write(",\n")
+                else:
+                    firstLine = False
+
+                w.write(("({char_id},'{key}',{index},{value})").format(
+                    char_id = user.char_id,
+                    key = varKey,
+                    index = "0",
+                    value = varValue
+                ))
+        w.write("\n")
diff --git a/hercules/code/server/evol/main.py b/hercules/code/server/evol/main.py
index 6014e05..577c868 100644
--- a/hercules/code/server/evol/main.py
+++ b/hercules/code/server/evol/main.py
@@ -6,6 +6,7 @@
 
 from code.server.account import *
 from code.server.db.char import *
+from code.server.db.charregnumdb import *
 from code.server.evol.athena import *
 from code.server.evol.consts import *
 from code.server.evol.itemdb import *
@@ -28,5 +29,6 @@ def serverEvolMain():
 
 def dbEvolMain():
     convertAccount()
-    users = readAthena();
-    saveCharTable(users);
+    users = readAthena()
+    saveCharTable(users)
+    saveCharRegNumDbTable(users)