diff options
Diffstat (limited to 'src/char_sql')
| -rw-r--r-- | src/char_sql/char.c | 4 | ||||
| -rw-r--r-- | src/char_sql/itemdb.c | 22 | ||||
| -rw-r--r-- | src/char_sql/itemdb.h | 2 |
3 files changed, 12 insertions, 16 deletions
diff --git a/src/char_sql/char.c b/src/char_sql/char.c index d5d1395a7..3a21f2ebb 100644 --- a/src/char_sql/char.c +++ b/src/char_sql/char.c @@ -4016,6 +4016,10 @@ void sql_config_read(const char *cfgName){ /* Kalaspuff, to get login_db */ }else if(strcmpi(w1,"use_sql_db")==0){ // added for sql item_db read for char server [Valaris]
db_use_sqldbs = config_switch(w2);
ShowStatus("Using SQL dbs: %s\n",w2);
+ }else if(strcmpi(w1,"item_db_db")==0){
+ strcpy(item_db_db,w2);
+ }else if(strcmpi(w1,"item_db2_db")==0){
+ strcpy(item_db2_db,w2);
} else if(strcmpi(w1,"connection_ping_interval")==0) {
connection_ping_interval = config_switch(w2);
//custom columns for login database
diff --git a/src/char_sql/itemdb.c b/src/char_sql/itemdb.c index f2f38efb5..a8148f866 100644 --- a/src/char_sql/itemdb.c +++ b/src/char_sql/itemdb.c @@ -19,6 +19,7 @@ //#define ITEMDB_OVERRIDE_NAME_VERBOSE 1
char item_db_db[256]="item_db"; // added to specify item_db sql table [Valaris]
+char item_db2_db[256]="item_db2";
static struct dbt* item_db;
@@ -168,8 +169,8 @@ static int itemdb_read_sqldb(void) // sql item_db read, shortened version of map sprintf(tmp_sql, "SELECT * FROM `%s`", item_db_name[i]);
// Execute the query; if the query execution succeeded...
- if (mysql_query(&mmysql_handle, tmp_sql) == 0) {
- sql_res = mysql_store_result(&mmysql_handle);
+ if (mysql_query(&mysql_handle, tmp_sql) == 0) {
+ sql_res = mysql_store_result(&mysql_handle);
// If the storage of the query result succeeded...
if (sql_res) {
@@ -203,14 +204,14 @@ static int itemdb_read_sqldb(void) // sql item_db read, shortened version of map ShowStatus("Done reading '"CL_WHITE"%lu"CL_RESET"' entries in '"CL_WHITE"%s"CL_RESET"'.\n", ln, item_db_name[i]);
ln = 0;
} else {
- ShowSQL("DB error (%s) - %s\n",item_db_name[i], mysql_error(&mmysql_handle));
+ ShowSQL("DB error (%s) - %s\n",item_db_name[i], mysql_error(&mysql_handle));
ShowDebug("at %s:%d - %s\n", __FILE__,__LINE__,tmp_sql);
}
// Free the query result
mysql_free_result(sql_res);
} else {
- ShowSQL("DB error (%s) - %s\n",item_db_name[i], mysql_error(&mmysql_handle));
+ ShowSQL("DB error (%s) - %s\n",item_db_name[i], mysql_error(&mysql_handle));
ShowDebug("at %s:%d - %s\n", __FILE__,__LINE__,tmp_sql);
}
}
@@ -218,17 +219,6 @@ static int itemdb_read_sqldb(void) // sql item_db read, shortened version of map return 0;
}
-static int itemdb_final(DBKey key,void *data,va_list ap)
-{
- struct item_data *id = (struct item_data*)data;
- if(id->use_script)
- aFree(id->use_script);
- if(id->equip_script)
- aFree(id->equip_script);
- return 0;
-}
-
-
/*==========================================
*
*------------------------------------------
@@ -236,7 +226,7 @@ static int itemdb_final(DBKey key,void *data,va_list ap) void do_final_itemdb(void)
{
if(item_db){
- item_db->destroy(item_db,itemdb_final);
+ item_db->destroy(item_db,NULL);
item_db=NULL;
}
}
diff --git a/src/char_sql/itemdb.h b/src/char_sql/itemdb.h index 972df5385..d19dd498c 100644 --- a/src/char_sql/itemdb.h +++ b/src/char_sql/itemdb.h @@ -29,6 +29,8 @@ struct item_data { int type;
};
+extern char item_db_db[256];
+extern char item_db2_db[256];
struct item_data* itemdb_search(int nameid);
#define itemdb_type(n) itemdb_search(n)->type
|