From a944acfba95c28ca273729c128a1fc0f5629910d Mon Sep 17 00:00:00 2001
From: louisplag <42522191+louisplag@users.noreply.github.com>
Date: Sat, 30 Mar 2019 15:47:34 +0300
Subject: update db2sql

fixed bug load mob_skill_db.sql
https://github.com/HerculesWS/Hercules/pull/2407#issuecomment-475771443
---
 src/plugins/db2sql.c | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'src/plugins')

diff --git a/src/plugins/db2sql.c b/src/plugins/db2sql.c
index 2ece501b2..159d4e2a6 100644
--- a/src/plugins/db2sql.c
+++ b/src/plugins/db2sql.c
@@ -956,6 +956,7 @@ bool mobskilldb2sql_sub(struct config_setting_t *it, int n, int mob_id)
 	struct mob_db *md = mob->db(mob_id);
 	char valname[15];
 	const char *name = config_setting_name(it);
+	char e_name[NAME_LENGTH*2+1];
 
 	nullpo_retr(false, it);
 	Assert_retr(false, mob_id <= 0 || md != mob->dummy);
@@ -966,7 +967,8 @@ bool mobskilldb2sql_sub(struct config_setting_t *it, int n, int mob_id)
 	StrBuf->Printf(&buf, "%d,", mob_id);
 
 	// Info
-	StrBuf->Printf(&buf, "'%s@%s',", md->name, name);
+	SQL->EscapeString(NULL, e_name, md->name);
+	StrBuf->Printf(&buf, "'%s@%s',", e_name, name);
 
 	if (mob->lookup_const(it, "SkillState", &i32) && (i32 < MSS_ANY || i32 > MSS_ANYTARGET)) {
 		ShowWarning("mob_skill_db_libconfig_sub_skill: Invalid skill state %d for skill '%s' in monster %d, defaulting to MSS_ANY.\n", i32, name, mob_id);
-- 
cgit v1.2.3-60-g2f50