mob_read_sqlskilldb func [CalciumKid]

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15155 54d463be-8e91-2dee-dedb-b68131a5f0ec

3 files changed, 73 insertions, 5 deletions

diff --git a/src/map/map.c b/src/map/map.c
index 1f8c066ad..3800cb992 100644
--- a/src/map/map.c
+++ b/src/map/map.c
@@ -71,6 +71,8 @@ char item_db2_db[32] = "item_db2";
 char item_db_re_db[32] = "item_db_re";
 char mob_db_db[32] = "mob_db";
 char mob_db2_db[32] = "mob_db2";
+char mob_skill_db_db[32] = "mob_skill_db";
+char mob_skill_db2_db[32] = "mob_skill_db2";
 
 // log database
 char log_db_ip[32] = "127.0.0.1";
diff --git a/src/map/map.h b/src/map/map.h
index 9b31c39b6..ff1250348 100644
--- a/src/map/map.h
+++ b/src/map/map.h
@@ -733,6 +733,8 @@ extern char item_db2_db[32];
 extern char item_db_re_db[32];
 extern char mob_db_db[32];
 extern char mob_db2_db[32];
+extern char mob_skill_db_db[32];
+extern char mob_skill_db2_db[32];
 
 #endif /* not TXT_ONLY */
 
diff --git a/src/map/mob.c b/src/map/mob.c
index 45a400c5b..3732f4ab3 100644
--- a/src/map/mob.c
+++ b/src/map/mob.c
@@ -4266,6 +4266,66 @@ static void mob_readskilldb(void)
 		sv_readdb(db_path, filename[fi], ',', 19, 19, -1, &mob_parse_row_mobskilldb);
 	}
 }
+
+#ifndef TXT_ONLY
+/**
+ * mob_skill_db table reading [CalciumKid]
+ * not overly sure if this is all correct
+ * seems to work though...
+ */
+static int mob_read_sqlskilldb(void)
+{
+	const char* mob_skill_db_name[] = { mob_skill_db_db, mob_skill_db2_db };
+	int fi;
+	
+	if( battle_config.mob_skill_rate == 0 )
+	{
+		ShowStatus("Mob skill use disabled. Not reading mob skills.\n");
+		return 0;
+	}
+
+
+	for( fi = 0; fi < ARRAYLENGTH(mob_skill_db_name); ++fi )
+	{
+		uint32 lines = 0, count = 0;
+		
+		// retrieve all rows from the mob skill database
+		if( SQL_ERROR == Sql_Query(mmysql_handle, "SELECT * FROM `%s`", mob_skill_db_name[fi]) )
+		{
+			Sql_ShowDebug(mmysql_handle);
+			continue;
+		}
+		
+		// process rows one by one
+		while( SQL_SUCCESS == Sql_NextRow(mmysql_handle) )
+		{
+			// wrap the result into a TXT-compatible format
+			char* str[19];
+			char* dummy = "";
+			int i;
+			++lines;
+			for( i = 0; i < 19; ++i )
+			{
+				Sql_GetData(mmysql_handle, i, &str[i], NULL);
+				if( str[i] == NULL ) str[i] = dummy; // get rid of NULL columns
+			}
+			
+			if (!mob_parse_row_mobskilldb(str, 19, count))
+				continue;
+				
+			count++;
+		}
+		
+		// free the query result
+		Sql_FreeResult(mmysql_handle);
+		
+		ShowStatus("Done reading '"CL_WHITE"%lu"CL_RESET"' entries in '"CL_WHITE"%s"CL_RESET"'.\n", count, mob_skill_db_name[fi]);
+		count = 0;
+	}
+	return 0;
+}
+#endif /* not TXT_ONLY */
+
 /*==========================================
  * mob_race2_db.txt reading
  *------------------------------------------*/
@@ -4294,19 +4354,23 @@ static bool mob_readdb_race2(char* fields[], int columns, int current)
 	return true;
 }
 
+/**
+ * read all mob-related databases
+ */
 static void mob_load(void)
 {
 #ifndef TXT_ONLY
-	if(db_use_sqldbs)
+	if(db_use_sqldbs) {
 		mob_read_sqldb();
-	else
+		mob_read_sqlskilldb();
+	} else {
 #endif /* TXT_ONLY */
-	mob_readdb();
-
+		mob_readdb();
+		mob_readskilldb();
+	}	
 	sv_readdb(db_path, "mob_avail.txt", ',', 2, 12, -1, &mob_readdb_mobavail);
 	mob_read_randommonster();
 	mob_readchatdb();
-	mob_readskilldb();
 	sv_readdb(db_path, "mob_race2_db.txt", ',', 2, 20, -1, &mob_readdb_race2);
 }