AS OF SVN REV. 5901, WE ARE NOW USING TRUNK. ALL UNTESTED BUGFIXES/FEATURES GO INTO TRUNK.

IF YOU HAVE A WORKING AND TESTED BUGFIX PUT IT INTO STABLE AS WELL AS TRUNK.  EVERYTHING ELSE
GOES INTO TRUNK AND WILL BE MERGED INTO STABLE BY VALARIS AND WIZPUTER. -- VALARIS


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

1 files changed, 956 insertions, 0 deletions

diff --git a/src/map/log.c b/src/map/log.c
new file mode 100644
index 000000000..0879023fa
--- /dev/null
+++ b/src/map/log.c
@@ -0,0 +1,956 @@
+// Copyright (c) Athena Dev Teams - Licensed under GNU GPL

+// For more information, see LICENCE in the main folder

+

+// Logging functions by Azndragon & Codemaster

+#include <stdlib.h>

+#include <stdio.h>

+#include <string.h>

+

+#include "../common/strlib.h"

+#include "../common/nullpo.h"

+#include "../common/showmsg.h"

+#include "itemdb.h"

+#include "map.h"

+#include "log.h"

+

+#ifndef SQL_DEBUG

+

+#define mysql_query(_x, _y) mysql_real_query(_x, _y, strlen(_y)) //supports ' in names and runs faster [Kevin]

+

+#else 

+

+#define mysql_query(_x, _y) debug_mysql_query(__FILE__, __LINE__, _x, _y)

+

+#endif

+

+struct Log_Config log_config;

+

+char timestring[255];

+time_t curtime;

+

+//FILTER OPTIONS

+//0 = Don't log

+//1 = Log any item

+//Bits: ||

+//2 - Healing items (0)

+//3 - Etc Items(3) + Arrows (10)

+//4 - Usable Items(2) + Scrolls,Lures(11)

+//5 - Weapon(4)

+//6 - Shields,Armor,Headgears,Accessories,etc(5)

+//7 - Cards(6)

+//8 - Pet Accessories(8) + Eggs(7) (well, monsters don't drop 'em but we'll use the same system for ALL logs)

+//9 - Log expensive items ( >= price_log)

+//10 - Log big amount of items ( >= amount_log)

+//11 - Log refined items (if their refine >= refine_log )

+//12 - Log rare items (if their drop chance <= rare_log )

+

+//check if this item should be logged according the settings

+int should_log_item(int filter, int nameid, int amount) {

+	struct item_data *item_data;

+	if (nameid<501 || (item_data= itemdb_search(nameid)) == NULL) return 0;

+	if ( (filter&1) || // Filter = 1, we log any item

+		(filter&2 && item_data->type == 0 ) ||	//healing items

+		(filter&4 && (item_data->type == 3 || item_data->type == 10) ) ||	//etc+arrows

+		(filter&8 && (item_data->type == 2 || item_data->type == 11) ) ||	//usable

+		(filter&16 && item_data->type == 4 ) ||	//weapon

+		(filter&32 && item_data->type == 5 ) ||	//armor

+		(filter&64 && item_data->type == 6 ) ||	//cards

+		(filter&128 && (item_data->type == 7 || item_data->type == 8) ) ||	//eggs+pet access

+		(filter&256 && item_data->value_buy >= log_config.price_items_log ) ||		//expensive items

+		(filter&512 && amount >= log_config.amount_items_log ) ||			//big amount of items

+		(filter&2048 && ((item_data->maxchance <= log_config.rare_items_log) || item_data->nameid == 714) ) //Rare items or Emperium

+	) return item_data->nameid;

+

+	return 0;

+}

+

+int log_branch(struct map_session_data *sd)

+{

+#ifndef TXT_ONLY

+		char t_name[NAME_LENGTH*2];

+#endif

+	FILE *logfp;

+

+	if(log_config.enable_logs <= 0)

+		return 0;

+	nullpo_retr(0, sd);

+#ifndef TXT_ONLY

+	if(log_config.sql_logs > 0)

+	{

+		sprintf(tmp_sql, "INSERT DELAYED INTO `%s` (`branch_date`, `account_id`, `char_id`, `char_name`, `map`) VALUES (NOW(), '%d', '%d', '%s', '%s')",

+			log_config.log_branch_db, sd->status.account_id, sd->status.char_id, jstrescapecpy(t_name, sd->status.name), mapindex_id2name(sd->mapindex));

+		if(mysql_query(&logmysql_handle, tmp_sql))

+		{

+			ShowSQL("DB error - %s\n",mysql_error(&logmysql_handle));

+			ShowDebug("at %s:%d - %s\n", __FILE__,__LINE__,tmp_sql);

+		}

+	} else {

+#endif

+		if((logfp=fopen(log_config.log_branch,"a+")) != NULL) {

+			time(&curtime);

+			strftime(timestring, 254, "%m/%d/%Y %H:%M:%S", localtime(&curtime));

+			fprintf(logfp,"%s - %s[%d:%d]\t%s%s", timestring, sd->status.name, sd->status.account_id, sd->status.char_id, mapindex_id2name(sd->mapindex), RETCODE);

+			fclose(logfp);

+		}

+#ifndef TXT_ONLY

+	}

+#endif

+	return 0;

+}

+

+

+int log_pick(struct map_session_data *sd, char *type, int mob_id, int nameid, int amount, struct item *itm)

+{

+	FILE *logfp;

+	char *mapname;

+	int obj_id;

+

+	if(log_config.enable_logs <= 0)

+		return 0;

+	nullpo_retr(0, sd);

+	//Should we log this item? [Lupus]

+	if (!should_log_item(log_config.pick,nameid, amount))

+		return 0; //we skip logging this items set - they doesn't met our logging conditions [Lupus]

+

+	//either PLAYER or MOB (here we get map name and objects ID)

+	if(mob_id) {

+		struct mob_data *md = (struct mob_data*)sd;

+		obj_id = mob_id;

+		mapname = map[md->m].name;

+	} else {

+		obj_id = sd->char_id;

+		mapname = (char*)mapindex_id2name(sd->mapindex);

+	}

+	if(mapname==NULL)

+		mapname="";

+

+#ifndef TXT_ONLY

+	if(log_config.sql_logs > 0)

+	{

+		if (itm==NULL) {

+		//We log common item

+			sprintf(tmp_sql, "INSERT DELAYED INTO `%s` (`time`, `char_id`, `type`, `nameid`, `amount`, `map`) VALUES (NOW(), '%d', '%s', '%d', '%d', '%s')",

+			 log_config.log_pick_db, obj_id, type, nameid, amount, mapname);

+		} else {

+		//We log Extended item

+			sprintf(tmp_sql, "INSERT DELAYED INTO `%s` (`time`, `char_id`, `type`, `nameid`, `amount`, `refine`, `card0`, `card1`, `card2`, `card3`, `map`) VALUES (NOW(), '%d', '%s', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%s')",

+			 log_config.log_pick_db, obj_id, type, itm->nameid, amount, itm->refine, itm->card[0], itm->card[1], itm->card[2], itm->card[3], mapname);

+		}

+

+		if(mysql_query(&logmysql_handle, tmp_sql))

+		{

+			ShowSQL("DB error - %s\n",mysql_error(&logmysql_handle));

+			ShowDebug("at %s:%d - %s\n", __FILE__,__LINE__,tmp_sql);

+		}

+	} else {

+#endif

+		if((logfp=fopen(log_config.log_pick,"a+")) != NULL) {

+			time_t curtime;

+			time(&curtime);

+			strftime(timestring, 254, "%m/%d/%Y %H:%M:%S", localtime(&curtime));

+

+			if (itm==NULL) {

+			//We log common item

+				fprintf(logfp,"%s - %d\t%s\t%d,%d,%s%s",

+					timestring, obj_id, type, nameid, amount, mapname, RETCODE);

+

+			} else {

+			//We log Extended item

+				fprintf(logfp,"%s - %d\t%s\t%d,%d,%d,%d,%d,%d,%d,%s%s",

+					timestring, obj_id, type, itm->nameid, amount, itm->refine, itm->card[0], itm->card[1], itm->card[2], itm->card[3], mapname, RETCODE);

+			}

+			fclose(logfp);

+		}

+#ifndef TXT_ONLY

+	}

+#endif

+	return 1; //Logged

+}

+

+int log_zeny(struct map_session_data *sd, char *type, struct map_session_data *src_sd, int amount)

+{

+//	FILE *logfp;

+	if(log_config.enable_logs <= 0 || (log_config.zeny!=1 && abs(amount)<log_config.zeny))

+		return 0;

+

+	nullpo_retr(0, sd);

+#ifndef TXT_ONLY

+	if(log_config.sql_logs > 0)

+	{

+		sprintf(tmp_sql, "INSERT DELAYED INTO `%s` (`time`, `char_id`, `src_id`, `type`, `amount`, `map`) VALUES (NOW(), '%d', '%d', '%s', '%d', '%s')",

+			 log_config.log_zeny_db, sd->char_id, src_sd->char_id, type, amount, mapindex_id2name(sd->mapindex));

+		if(mysql_query(&logmysql_handle, tmp_sql))

+		{

+			ShowSQL("DB error - %s\n",mysql_error(&logmysql_handle));

+			ShowDebug("at %s:%d - %s\n", __FILE__,__LINE__,tmp_sql);

+		}

+	} else {

+#endif

+//		if((logfp=fopen(log_config.log_zeny,"a+")) != NULL) {

+//			time(&curtime);

+//			strftime(timestring, 254, "%m/%d/%Y %H:%M:%S", localtime(&curtime));

+//			fprintf(logfp,"%s - %s[%d]\t%s[%d]\t%d\t%s", timestring, sd->status.name, sd->status.account_id, target_sd->status.name, target_sd->status.account_id, sd->deal.zeny, RETCODE);

+//			fclose(logfp);

+//		}

+#ifndef TXT_ONLY

+	}

+#endif

+	return 0;

+}

+

+

+int log_drop(struct map_session_data *sd, int monster_id, int *log_drop)

+{

+	FILE *logfp;

+	int i,flag = 0;

+

+	if(log_config.enable_logs <= 0)

+		return 0;

+	nullpo_retr(0, sd);

+	for (i = 0; i<10; i++) { //Should we log these items? [Lupus]

+		flag += should_log_item(log_config.drop,log_drop[i],1);

+	}

+	if (flag==0) return 0; //we skip logging this items set - they doesn't met our logging conditions [Lupus]

+

+#ifndef TXT_ONLY

+	if(log_config.sql_logs > 0)

+	{

+		sprintf(tmp_sql, "INSERT DELAYED INTO `%s` (`drop_date`, `kill_char_id`, `monster_id`, `item1`, `item2`, `item3`, `item4`, `item5`, `item6`, `item7`, `item8`, `item9`, `itemCard`, `map`) VALUES (NOW(), '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%s') ", log_config.log_drop_db, sd->status.char_id, monster_id, log_drop[0], log_drop[1], log_drop[2], log_drop[3], log_drop[4], log_drop[5], log_drop[6], log_drop[7], log_drop[8], log_drop[9], mapindex_id2name(sd->mapindex));

+		if(mysql_query(&logmysql_handle, tmp_sql))

+		{

+			ShowSQL("DB error - %s\n",mysql_error(&logmysql_handle));

+			ShowDebug("at %s:%d - %s\n", __FILE__,__LINE__,tmp_sql);

+		}

+	} else {

+#endif

+		if((logfp=fopen(log_config.log_drop,"a+")) != NULL) {

+			

+

+			time_t curtime;

+			time(&curtime);

+			strftime(timestring, 254, "%m/%d/%Y %H:%M:%S", localtime(&curtime));

+			fprintf(logfp,"%s - %s[%d:%d]\t%d\t%d,%d,%d,%d,%d,%d,%d,%d,%d,%d%s", timestring, sd->status.name, sd->status.account_id, sd->status.char_id, monster_id, log_drop[0], log_drop[1], log_drop[2], log_drop[3], log_drop[4], log_drop[5], log_drop[6], log_drop[7], log_drop[8], log_drop[9], RETCODE);

+			fclose(logfp);

+		}

+#ifndef TXT_ONLY

+	}

+#endif

+	return 1; //Logged

+}

+

+int log_mvpdrop(struct map_session_data *sd, int monster_id, int *log_mvp)

+{

+	FILE *logfp;

+

+	if(log_config.enable_logs <= 0)

+		return 0;

+	nullpo_retr(0, sd);

+#ifndef TXT_ONLY

+	if(log_config.sql_logs > 0)

+	{

+		sprintf(tmp_sql, "INSERT DELAYED INTO `%s` (`mvp_date`, `kill_char_id`, `monster_id`, `prize`, `mvpexp`, `map`) VALUES (NOW(), '%d', '%d', '%d', '%d', '%s') ", log_config.log_mvpdrop_db, sd->status.char_id, monster_id, log_mvp[0], log_mvp[1], mapindex_id2name(sd->mapindex));

+		if(mysql_query(&logmysql_handle, tmp_sql))

+		{

+			ShowSQL("DB error - %s\n",mysql_error(&logmysql_handle));

+			ShowDebug("at %s:%d - %s\n", __FILE__,__LINE__,tmp_sql);

+		}

+	} else {

+#endif

+		if((logfp=fopen(log_config.log_mvpdrop,"a+")) != NULL) {

+			time(&curtime);

+			strftime(timestring, 254, "%m/%d/%Y %H:%M:%S", localtime(&curtime));

+			fprintf(logfp,"%s - %s[%d:%d]\t%d\t%d,%d%s", timestring, sd->status.name, sd->status.account_id, sd->status.char_id, monster_id, log_mvp[0], log_mvp[1], RETCODE);

+			fclose(logfp);

+		}

+#ifndef TXT_ONLY

+	}

+#endif

+	return 0;

+}

+

+int log_present(struct map_session_data *sd, int source_type, int nameid)

+{

+	FILE *logfp;

+#ifndef TXT_ONLY

+		char t_name[NAME_LENGTH*2];

+#endif

+

+	if(log_config.enable_logs <= 0)

+		return 0;

+	nullpo_retr(0, sd);

+	if(!should_log_item(log_config.present,nameid,1)) return 0;	//filter [Lupus]

+#ifndef TXT_ONLY

+	if(log_config.sql_logs > 0)

+	{

+		sprintf(tmp_sql, "INSERT DELAYED INTO `%s` (`present_date`, `src_id`, `account_id`, `char_id`, `char_name`, `nameid`, `map`) VALUES (NOW(), '%d', '%d', '%d', '%s', '%d', '%s') ",

+			log_config.log_present_db, source_type, sd->status.account_id, sd->status.char_id, jstrescapecpy(t_name, sd->status.name), nameid, mapindex_id2name(sd->mapindex));

+		if(mysql_query(&logmysql_handle, tmp_sql))

+		{	

+			ShowSQL("DB error - %s\n",mysql_error(&logmysql_handle));

+			ShowDebug("at %s:%d - %s\n", __FILE__,__LINE__,tmp_sql);

+		}

+	} else {

+#endif

+		if((logfp=fopen(log_config.log_present,"a+")) != NULL) {

+			time(&curtime);

+			strftime(timestring, 254, "%m/%d/%Y %H:%M:%S", localtime(&curtime));

+			fprintf(logfp,"%s - %s[%d:%d]\t%d\t%d%s", timestring, sd->status.name, sd->status.account_id, sd->status.char_id, source_type, nameid, RETCODE);

+			fclose(logfp);

+		}

+#ifndef TXT_ONLY

+	}

+#endif

+	return 0;

+}

+

+int log_produce(struct map_session_data *sd, int nameid, int slot1, int slot2, int slot3, int success)

+{

+	FILE *logfp;

+#ifndef TXT_ONLY

+		char t_name[NAME_LENGTH*2];

+#endif

+

+	if(log_config.enable_logs <= 0)

+		return 0;

+	nullpo_retr(0, sd);

+	if(!should_log_item(log_config.produce,nameid,1)) return 0;	//filter [Lupus]

+#ifndef TXT_ONLY

+	if(log_config.sql_logs > 0)

+	{

+		sprintf(tmp_sql, "INSERT DELAYED INTO `%s` (`produce_date`, `account_id`, `char_id`, `char_name`, `nameid`, `slot1`, `slot2`, `slot3`, `map`, `success`) VALUES (NOW(), '%d', '%d', '%s', '%d', '%d', '%d', '%d', '%s', '%d') ",

+			log_config.log_produce_db, sd->status.account_id, sd->status.char_id, jstrescapecpy(t_name, sd->status.name), nameid, slot1, slot2, slot3, mapindex_id2name(sd->mapindex), success);

+		if(mysql_query(&logmysql_handle, tmp_sql))

+		{

+			ShowSQL("DB error - %s\n",mysql_error(&logmysql_handle));

+			ShowDebug("at %s:%d - %s\n", __FILE__,__LINE__,tmp_sql);

+		}

+	} else {

+#endif

+		if((logfp=fopen(log_config.log_produce,"a+")) != NULL) {

+			time(&curtime);

+			strftime(timestring, 254, "%m/%d/%Y %H:%M:%S", localtime(&curtime));

+			fprintf(logfp,"%s - %s[%d:%d]\t%d\t%d,%d,%d\t%d%s", timestring, sd->status.name, sd->status.account_id, sd->status.char_id, nameid, slot1, slot2, slot3, success, RETCODE);

+			fclose(logfp);

+		}

+#ifndef TXT_ONLY

+	}

+#endif

+	return 0;

+}

+

+int log_refine(struct map_session_data *sd, int n, int success)

+{

+	FILE *logfp;

+	int log_card[MAX_SLOTS];

+	int item_level;

+	int i;

+#ifndef TXT_ONLY

+		char t_name[NAME_LENGTH*2];

+#endif

+

+	if(log_config.enable_logs <= 0)

+		return 0;

+

+	nullpo_retr(0, sd);

+

+	if(success == 0)

+		item_level = sd->status.inventory[n].refine; //leaving there 0 wasn't informative! we have SUCCESS field anyways

+	else

+		item_level = sd->status.inventory[n].refine + 1;

+	if(!should_log_item(log_config.refine,sd->status.inventory[n].nameid,1) || log_config.refine_items_log<item_level) return 0;	//filter [Lupus]

+	for(i=0;i<MAX_SLOTS;i++)

+		log_card[i] = sd->status.inventory[n].card[i];

+

+#ifndef TXT_ONLY

+	if(log_config.sql_logs > 0)

+	{

+		char *str_p = tmp_sql;

+		str_p += sprintf(str_p, "INSERT DELAYED INTO `%s` (`refine_date`, `account_id`, `char_id`, `char_name`, `nameid`, `refine`"

+			", `map`, `success`, `item_level`", log_config.log_refine_db);

+		

+		for (i=0; i < MAX_SLOTS; i++)

+			str_p += sprintf(str_p, ", `card%d`", i);

+		

+		str_p += sprintf(str_p, ") VALUES (NOW(), '%d', '%d', '%s', '%d', '%d', '%s', '%d', '%d'",

+			sd->status.account_id, sd->status.char_id, jstrescapecpy(t_name, sd->status.name),

+			sd->status.inventory[n].nameid, sd->status.inventory[n].refine, mapindex_id2name(sd->mapindex), success, item_level);

+		

+		for(i=0; i<MAX_SLOTS; i++)

+			str_p += sprintf(str_p, ", '%d'", log_card[i]);

+

+		strcat(tmp_sql,")");

+

+		if(mysql_query(&logmysql_handle, tmp_sql))

+		{

+			ShowSQL("DB error - %s\n",mysql_error(&logmysql_handle));

+			ShowDebug("at %s:%d - %s\n", __FILE__,__LINE__,tmp_sql);

+		}

+	} else {

+#endif

+		if((logfp=fopen(log_config.log_refine,"a+")) != NULL) {

+			time(&curtime);

+			strftime(timestring, 254, "%m/%d/%Y %H:%M:%S", localtime(&curtime));

+			fprintf(logfp,"%s - %s[%d:%d]\t%d,%d\t",

+				timestring, sd->status.name, sd->status.account_id, sd->status.char_id,

+				sd->status.inventory[n].nameid, sd->status.inventory[n].refine);

+

+			for (i=0; i<MAX_SLOTS; i++)

+				fprintf(logfp,"%d,",log_card[i]);

+		

+			fprintf(logfp,"\t%d,%d%s", success, item_level, RETCODE);

+			fclose(logfp);

+		}

+#ifndef TXT_ONLY

+	}

+#endif

+	return 0;

+}

+

+int log_tostorage(struct map_session_data *sd,int n, int guild) 

+{

+  FILE *logfp;

+  int i;

+

+  if(log_config.enable_logs <= 0 || log_config.storage == 0 || log_config.log_storage[0] == '\0')

+    return 0;

+

+  nullpo_retr(0, sd);

+  if(sd->status.inventory[n].nameid==0 || sd->inventory_data[n] == NULL)

+    return 1;

+

+  if(sd->status.inventory[n].amount < 0)

+    return 1;

+

+  if((logfp=fopen(log_config.log_trade,"a+")) != NULL) {

+		time(&curtime);

+		strftime(timestring, 254, "%m/%d/%Y %H:%M:%S", localtime(&curtime));

+		fprintf(logfp,"%s - to %s: %s[%d:%d]\t%d\t%d\t%d\t",

+		timestring, guild ? "guild_storage": "storage", sd->status.name, sd->status.account_id, sd->status.char_id, 

+      sd->status.inventory[n].nameid, sd->status.inventory[n].amount, sd->status.inventory[n].refine);

+	 

+	 for (i=0; i<MAX_SLOTS; i++)

+		 fprintf(logfp, "%d,", sd->status.inventory[n].card[i]);

+	

+	 fprintf(logfp, "%s", RETCODE);

+    fclose(logfp);

+  }

+  return 0;

+}

+

+int log_fromstorage(struct map_session_data *sd,int n, int guild) 

+{

+  FILE *logfp;

+  int i;

+

+  if(log_config.enable_logs <= 0 || log_config.storage == 0 || log_config.log_storage[0] == '\0')

+    return 0;

+

+  nullpo_retr(0, sd);

+

+  if(sd->status.inventory[n].nameid==0 || sd->inventory_data[n] == NULL)

+    return 1;

+

+  if(sd->status.inventory[n].amount < 0)

+    return 1;

+

+  if((logfp=fopen(log_config.log_trade,"a+")) != NULL) {

+	time(&curtime);

+	fprintf(logfp,"%s - from %s: %s[%d:%d]\t%d\t%d\t%d\t",

+		timestring, guild ? "guild_storage": "storage", sd->status.name, sd->status.account_id, sd->status.char_id, 

+      sd->status.inventory[n].nameid, sd->status.inventory[n].amount, sd->status.inventory[n].refine);

+	 

+	 for (i=0; i<MAX_SLOTS; i++)

+		 fprintf(logfp, "%d,", sd->status.inventory[n].card[i]);

+	

+	 fprintf(logfp, "%s", RETCODE);

+

+    fclose(logfp);

+  }

+  return 0;

+}

+

+int log_trade(struct map_session_data *sd, struct map_session_data *target_sd, int n,int amount)

+{

+	FILE *logfp;

+	int log_nameid, log_amount, log_refine, log_card[MAX_SLOTS];

+	int i;

+#ifndef TXT_ONLY

+		char t_name[NAME_LENGTH*2],t_name2[NAME_LENGTH*2];

+#endif

+

+	if(log_config.enable_logs <= 0)

+		return 0;

+

+	nullpo_retr(0, sd);

+

+	if(sd->status.inventory[n].nameid==0 || amount <= 0 || sd->status.inventory[n].amount<amount || sd->inventory_data[n] == NULL)

+		return 1;

+

+	if(sd->status.inventory[n].amount < 0)

+		return 1;

+	if(!should_log_item(log_config.trade,sd->status.inventory[n].nameid,sd->status.inventory[n].amount)) return 0;	//filter [Lupus]

+	log_nameid = sd->status.inventory[n].nameid;

+	log_amount = sd->status.inventory[n].amount;

+	log_refine = sd->status.inventory[n].refine;

+

+	for(i=0;i<MAX_SLOTS;i++)

+		log_card[i] = sd->status.inventory[n].card[i];

+

+#ifndef TXT_ONLY

+	if(log_config.sql_logs > 0)

+	{

+		char *str_p = tmp_sql;

+		str_p += sprintf(str_p, "INSERT DELAYED INTO `%s` (`trade_date`, `src_account_id`, `src_char_id`, `src_char_name`, `des_account_id`, `des_char_id`, `des_char_name`, `nameid`, `amount`, `refine`, `map`",

+			log_config.log_trade_db);

+

+		for (i=0; i < MAX_SLOTS; i++)

+			str_p += sprintf(str_p, ", `card%d`", i);

+		

+		str_p += sprintf(str_p, ") VALUES (NOW(), '%d', '%d', '%s', '%d', '%d', '%s', '%d', '%d', '%d', '%s'",

+			sd->status.account_id, sd->status.char_id, jstrescapecpy(t_name, sd->status.name),

+			target_sd->status.account_id, target_sd->status.char_id, jstrescapecpy(t_name2, target_sd->status.name),

+			log_nameid, log_amount, log_refine, mapindex_id2name(sd->mapindex));

+		

+		for(i=0; i<MAX_SLOTS; i++)

+			str_p += sprintf(str_p, ", '%d'", log_card[i]);

+

+		strcat(tmp_sql, ")");

+		

+		if(mysql_query(&logmysql_handle, tmp_sql))

+		{

+			ShowSQL("DB error - %s\n",mysql_error(&logmysql_handle));

+			ShowDebug("at %s:%d - %s\n", __FILE__,__LINE__,tmp_sql);

+		}

+	} else {

+#endif

+		if((logfp=fopen(log_config.log_trade,"a+")) != NULL) {

+			time(&curtime);

+			strftime(timestring, 254, "%m/%d/%Y %H:%M:%S", localtime(&curtime));

+			fprintf(logfp,"%s - %s[%d:%d]\t%s[%d:%d]\t%d\t%d\t%d\t",

+				timestring, sd->status.name, sd->status.account_id, sd->status.char_id,

+				target_sd->status.name, target_sd->status.account_id, target_sd->status.char_id,

+				log_nameid, log_amount, log_refine);

+

+			for (i=0; i<MAX_SLOTS; i++)

+				fprintf(logfp, "%d,", sd->status.inventory[n].card[i]);

+	

+			fprintf(logfp, "%s", RETCODE);

+

+			fclose(logfp);

+		}

+#ifndef TXT_ONLY

+	}

+#endif

+	return 0;

+}

+

+int log_vend(struct map_session_data *sd,struct map_session_data *vsd,int n,int amount, int zeny)

+{

+	FILE *logfp;

+	int log_nameid, log_amount, log_refine, log_card[MAX_SLOTS];

+	int i;

+#ifndef TXT_ONLY

+		char t_name[NAME_LENGTH*2],t_name2[NAME_LENGTH*2];

+#endif

+

+	if(log_config.enable_logs <= 0)

+		return 0;

+	nullpo_retr(0, sd);

+

+	if(sd->status.inventory[n].nameid==0 || amount <= 0 || sd->status.inventory[n].amount<amount || sd->inventory_data[n] == NULL)

+		return 1;

+	if(sd->status.inventory[n].amount< 0)

+		return 1;

+	if(!should_log_item(log_config.vend,sd->status.inventory[n].nameid,sd->status.inventory[n].amount)) return 0;	//filter [Lupus]

+	log_nameid = sd->status.inventory[n].nameid;

+	log_amount = sd->status.inventory[n].amount;

+	log_refine = sd->status.inventory[n].refine;

+	for(i=0;i<MAX_SLOTS;i++)

+		log_card[i] = sd->status.inventory[n].card[i];

+

+#ifndef TXT_ONLY

+	if(log_config.sql_logs > 0)

+	{

+		char *str_p = tmp_sql;

+		str_p += sprintf(str_p, "INSERT DELAYED INTO `%s` (`vend_date`, `vend_account_id`, `vend_char_id`, `vend_char_name`, `buy_account_id`, `buy_char_id`, `buy_char_name`, `nameid`, `amount`, `refine`, `map`, `zeny`",

+			log_config.log_vend_db); 	

+

+		for (i=0; i < MAX_SLOTS; i++)

+			str_p += sprintf(str_p, ", `card%d`", i);

+

+		str_p += sprintf(str_p, ") VALUES (NOW(), '%d', '%d', '%s', '%d', '%d', '%s', '%d', '%d', '%d', '%s', '%d'",

+			sd->status.account_id, sd->status.char_id, jstrescapecpy(t_name, sd->status.name),

+			vsd->status.account_id, vsd->status.char_id, jstrescapecpy(t_name2, vsd->status.name),

+			log_nameid, log_amount, log_refine, mapindex_id2name(sd->mapindex), zeny);

+		

+		for(i=0; i<MAX_SLOTS; i++)

+			str_p += sprintf(str_p, ", '%d'", log_card[i]);

+

+		strcat(tmp_sql, ")");

+		

+		if(mysql_query(&logmysql_handle, tmp_sql))

+		{

+			ShowSQL("DB error - %s\n",mysql_error(&logmysql_handle));

+			ShowDebug("at %s:%d - %s\n", __FILE__,__LINE__,tmp_sql);

+		}

+	} else {

+#endif

+		if((logfp=fopen(log_config.log_vend,"a+")) != NULL) {

+			time(&curtime);

+			strftime(timestring, 254, "%m/%d/%Y %H:%M:%S", localtime(&curtime));

+			fprintf(logfp,"%s - %s[%d:%d]\t%s[%d:%d]\t%d\t%d\t%d\t",

+				timestring, sd->status.name, sd->status.account_id, sd->status.char_id,

+				vsd->status.name, vsd->status.account_id, vsd->status.char_id,

+				log_nameid, log_amount, log_refine);

+

+			for(i=0; i<MAX_SLOTS; i++)

+				fprintf(logfp, "%d,", sd->status.inventory[n].card[i]);

+			

+			fprintf(logfp, "\t%d%s", zeny, RETCODE);

+			fclose(logfp);

+		}

+#ifndef TXT_ONLY

+	}

+#endif

+	return 0;

+}

+

+int log_atcommand(struct map_session_data *sd, const char *message)

+{

+	FILE *logfp;

+#ifndef TXT_ONLY

+		char t_name[NAME_LENGTH*2];

+		char t_msg[MESSAGE_SIZE*2+1]; //These are the contents of an @ call, so there shouldn't be overflow danger here?

+#endif

+

+	if(log_config.enable_logs <= 0)

+		return 0;

+	nullpo_retr(0, sd);

+#ifndef TXT_ONLY

+	if(log_config.sql_logs > 0)

+	{

+		sprintf(tmp_sql, "INSERT DELAYED INTO `%s` (`atcommand_date`, `account_id`, `char_id`, `char_name`, `map`, `command`) VALUES(NOW(), '%d', '%d', '%s', '%s', '%s') ",

+			log_config.log_gm_db, sd->status.account_id, sd->status.char_id, jstrescapecpy(t_name, sd->status.name), mapindex_id2name(sd->mapindex), jstrescapecpy(t_msg, (char *)message));

+		if(mysql_query(&logmysql_handle, tmp_sql))

+		{

+			ShowSQL("DB error - %s\n",mysql_error(&logmysql_handle));

+			ShowDebug("at %s:%d - %s\n", __FILE__,__LINE__,tmp_sql);

+		}

+	} else {

+#endif

+		if((logfp=fopen(log_config.log_gm,"a+")) != NULL) {

+			time(&curtime);

+			strftime(timestring, 254, "%m/%d/%Y %H:%M:%S", localtime(&curtime));

+			fprintf(logfp,"%s - %s[%d]: %s%s",timestring,sd->status.name,sd->status.account_id,message,RETCODE);

+			fclose(logfp);

+		}

+#ifndef TXT_ONLY

+	}

+#endif

+	return 0;

+}

+

+int log_npc(struct map_session_data *sd, const char *message)

+{	//[Lupus]

+	FILE *logfp;

+	#ifndef TXT_ONLY

+		char t_name[NAME_LENGTH*2];

+		char t_msg[255+1]; //it's 255 chars MAX. 

+	#endif

+

+	if(log_config.enable_logs <= 0)

+		return 0;

+	nullpo_retr(0, sd);

+#ifndef TXT_ONLY

+	if(log_config.sql_logs > 0)

+	{

+		sprintf(tmp_sql, "INSERT DELAYED INTO `%s` (`npc_date`, `account_id`, `char_id`, `char_name`, `map`, `mes`) VALUES(NOW(), '%d', '%d', '%s', '%s', '%s') ",

+			log_config.log_npc_db, sd->status.account_id, sd->status.char_id, jstrescapecpy(t_name, sd->status.name), mapindex_id2name(sd->mapindex), jstrescapecpy(t_msg, (char *)message));

+		if(mysql_query(&logmysql_handle, tmp_sql))

+		{

+			ShowSQL("DB error - %s\n",mysql_error(&logmysql_handle));

+			ShowDebug("at %s:%d - %s\n", __FILE__,__LINE__,tmp_sql);

+		}

+	} else {

+#endif

+		if((logfp=fopen(log_config.log_npc,"a+")) != NULL) {

+			time(&curtime);

+			strftime(timestring, 254, "%m/%d/%Y %H:%M:%S", localtime(&curtime));

+			fprintf(logfp,"%s - %s[%d]: %s%s",timestring,sd->status.name,sd->status.account_id,message,RETCODE);

+			fclose(logfp);

+		}

+#ifndef TXT_ONLY

+	}

+#endif

+	return 0;

+}

+

+//ChatLogging

+// Log CHAT (currently only: Party, Guild, Whisper)

+// LOGGING FILTERS [Lupus]

+//=============================================================

+//0 = Don't log at all

+//1 = Log any chat messages

+//Advanced Filter Bits: ||

+//2 - Log Whisper messages

+//3 - Log Party messages

+//4 - Log Guild messages

+//5 - Log Common messages (not implemented)

+//6 - Don't log when WOE is on

+//Example:

+//log_chat: 1	= logs ANY messages

+//log_chat: 6	= logs both Whisper & Party messages

+//log_chat: 8	= logs only Guild messages

+//log_chat: 18	= logs only Whisper, when WOE is off

+

+int log_chat(char *type, int type_id, int src_charid, int src_accid, char *map, int x, int y, char *dst_charname, char *message){

+#ifndef TXT_ONLY

+	char t_msg[MESSAGE_SIZE*2+1]; //Chat line fully escaped, with an extra space just in case.

+#else

+	FILE *logfp;

+#endif

+	

+	//Check ON/OFF

+	if(log_config.chat <= 0)

+		return 0; //Deactivated

+

+#ifndef TXT_ONLY

+	if(log_config.sql_logs > 0){

+		sprintf(tmp_sql, "INSERT DELAYED INTO `%s` (`time`, `type`, `type_id`, `src_charid`, `src_accountid`, `src_map`, `src_map_x`, `src_map_y`, `dst_charname`, `message`) VALUES (NOW(), '%s', '%d', '%d', '%d', '%s', '%d', '%d', '%s', '%s')", 

+		 	log_config.log_chat_db, type, type_id, src_charid, src_accid, map, x, y, dst_charname, jstrescapecpy(t_msg, (char *)message));

+	

+		if(mysql_query(&logmysql_handle, tmp_sql)){

+			ShowSQL("DB error - %s\n",mysql_error(&logmysql_handle));

+			ShowDebug("at %s:%d - %s\n", __FILE__,__LINE__,tmp_sql);

+			return -1;	

+		}else{

+			return 0;

+		}

+	}			

+#endif

+

+#ifdef TXT_ONLY

+	if((logfp = fopen(log_config.log_chat, "a+")) != NULL){

+		time(&curtime);

+		strftime(timestring, 254, "%m/%d/%Y %H:%M:%S", localtime(&curtime));

+		//DATE - type,type_id,src_charid,src_accountid,src_map,src_x,src_y,dst_charname,message

+		fprintf(logfp, "%s - %s,%d,%d,%d,%s,%d,%d,%s,%s%s", 

+			timestring, type, type_id, src_charid, src_accid, map, x, y, dst_charname, message, RETCODE);

+		fclose(logfp);

+		return 0;

+	}else{

+		return -1;

+	}

+#endif

+return -1;

+}

+

+

+void log_set_defaults(void)

+{

+	memset(&log_config, 0, sizeof(log_config));

+

+	//LOG FILTER Default values

+	log_config.refine_items_log = 5; //log refined items, with refine >= +7

+	log_config.rare_items_log = 100; //log rare items. drop chance <= 1%

+	log_config.price_items_log = 1000; //1000z

+	log_config.amount_items_log = 100;	

+}

+

+int log_config_read(char *cfgName)

+{

+	static int count = 0;

+	char line[1024], w1[1024], w2[1024];

+	FILE *fp;

+

+	if ((count++) == 0)

+		log_set_defaults();		

+

+	if((fp = fopen(cfgName, "r")) == NULL)

+	{

+		ShowError("Log configuration file not found at: %s\n", cfgName);

+		return 1;

+	}	

+

+	while(fgets(line, sizeof(line) -1, fp))

+	{

+		if(line[0] == '/' && line[1] == '/')

+			continue;

+

+		if(sscanf(line, "%[^:]: %[^\r\n]", w1, w2) == 2)

+		{

+			if(strcmpi(w1,"enable_logs") == 0) {

+				log_config.enable_logs = (atoi(w2));

+			} else if(strcmpi(w1,"sql_logs") == 0) {

+				log_config.sql_logs = (atoi(w2));

+//start of common filter settings

+			} else if(strcmpi(w1,"rare_items_log") == 0) {

+				log_config.rare_items_log = (atoi(w2));

+			} else if(strcmpi(w1,"refine_items_log") == 0) {

+				log_config.refine_items_log = (atoi(w2));

+			} else if(strcmpi(w1,"price_items_log") == 0) {

+				log_config.price_items_log = (atoi(w2));

+			} else if(strcmpi(w1,"amount_items_log") == 0) {

+				log_config.amount_items_log = (atoi(w2));

+//end of common filter settings

+			} else if(strcmpi(w1,"log_branch") == 0) {

+				log_config.branch = (atoi(w2));

+			} else if(strcmpi(w1,"log_pick") == 0) {

+				log_config.pick = (atoi(w2));

+			} else if(strcmpi(w1,"log_drop") == 0) {

+				log_config.drop = (atoi(w2));

+			} else if(strcmpi(w1,"log_steal") == 0) {

+				log_config.steal = (atoi(w2));

+			} else if(strcmpi(w1,"log_mvpdrop") == 0) {

+				log_config.mvpdrop = (atoi(w2));

+			} else if(strcmpi(w1,"log_present") == 0) {

+				log_config.present = (atoi(w2));

+			} else if(strcmpi(w1,"log_produce") == 0) {

+				log_config.produce = (atoi(w2));

+			} else if(strcmpi(w1,"log_refine") == 0) {

+				log_config.refine = (atoi(w2));

+			} else if(strcmpi(w1,"log_trade") == 0) {

+				log_config.trade = (atoi(w2));

+			} else if(strcmpi(w1,"log_storage") == 0) {

+				log_config.storage = (atoi(w2));

+			} else if(strcmpi(w1,"log_vend") == 0) {

+				log_config.vend = (atoi(w2));

+			} else if(strcmpi(w1,"log_zeny") == 0) {

+				log_config.zeny = (atoi(w2));

+			} else if(strcmpi(w1,"log_gm") == 0) {

+				log_config.gm = (atoi(w2));

+			} else if(strcmpi(w1,"log_npc") == 0) {

+				log_config.npc = (atoi(w2));

+			} else if(strcmpi(w1, "log_chat") == 0) {

+				log_config.chat = (atoi(w2));

+			}

+

+#ifndef TXT_ONLY

+			else if(strcmpi(w1, "log_branch_db") == 0) {

+				strcpy(log_config.log_branch_db, w2);

+				if(log_config.branch == 1)

+					ShowNotice("Logging Dead Branch Usage to table `%s`\n", w2);

+			} else if(strcmpi(w1, "log_pick_db") == 0) {

+				strcpy(log_config.log_pick_db, w2);

+				if(log_config.pick == 1)

+					ShowNotice("Logging Item Picks to table `%s`\n", w2);

+			} else if(strcmpi(w1, "log_zeny_db") == 0) {

+				strcpy(log_config.log_zeny_db, w2);

+				if(log_config.zeny == 1)

+					ShowNotice("Logging Zeny to table `%s`\n", w2);

+			} else if(strcmpi(w1, "log_drop_db") == 0) {

+				strcpy(log_config.log_drop_db, w2);

+				if(log_config.drop == 1)

+					ShowNotice("Logging Item Drops to table `%s`\n", w2);

+			} else if(strcmpi(w1, "log_mvpdrop_db") == 0) {

+				strcpy(log_config.log_mvpdrop_db, w2);

+				if(log_config.mvpdrop == 1)

+					ShowNotice("Logging MVP Drops to table `%s`\n", w2);

+			} else if(strcmpi(w1, "log_present_db") == 0) {

+				strcpy(log_config.log_present_db, w2);

+				if(log_config.present == 1)

+					ShowNotice("Logging Present Usage & Results to table `%s`\n", w2);

+			} else if(strcmpi(w1, "log_produce_db") == 0) {

+				strcpy(log_config.log_produce_db, w2);

+				if(log_config.produce == 1)

+					ShowNotice("Logging Producing to table `%s`\n", w2);

+			} else if(strcmpi(w1, "log_refine_db") == 0) {

+				strcpy(log_config.log_refine_db, w2);

+				if(log_config.refine == 1)

+					ShowNotice("Logging Refining to table `%s`\n", w2);

+			} else if(strcmpi(w1, "log_trade_db") == 0) {

+				strcpy(log_config.log_trade_db, w2);

+				if(log_config.trade == 1)

+					ShowNotice("Logging Item Trades to table `%s`\n", w2);

+//			} else if(strcmpi(w1, "log_storage_db") == 0) {

+//				strcpy(log_config.log_storage_db, w2);

+//				if(log_config.storage == 1)

+//				{

+//					printf("Logging Item Storages");

+//					printf(" to table `%s`\n", w2);

+//				}

+			} else if(strcmpi(w1, "log_vend_db") == 0) {

+				strcpy(log_config.log_vend_db, w2);

+				if(log_config.vend == 1)

+					ShowNotice("Logging Vending to table `%s`\n", w2);

+			} else if(strcmpi(w1, "log_gm_db") == 0) {

+				strcpy(log_config.log_gm_db, w2);

+				if(log_config.gm > 0)

+					ShowNotice("Logging GM Level %d Commands to table `%s`\n", log_config.gm, w2);

+			} else if(strcmpi(w1, "log_npc_db") == 0) {

+				strcpy(log_config.log_npc_db, w2);

+				if(log_config.npc > 0)

+					ShowNotice("Logging NPC 'logmes' to table `%s`\n", w2);

+			} else if(strcmpi(w1, "log_chat_db") == 0) {

+				strcpy(log_config.log_chat_db, w2);

+				if(log_config.chat > 0)

+					ShowNotice("Logging CHAT to table `%s`\n", w2);

+			}

+#endif

+

+			else if(strcmpi(w1, "log_branch_file") == 0) {

+				strcpy(log_config.log_branch, w2);

+				if(log_config.branch > 0 && log_config.sql_logs < 1)

+					ShowNotice("Logging Dead Branch Usage to file `%s`.txt\n", w2);

+			} else if(strcmpi(w1, "log_drop_file") == 0) {

+				strcpy(log_config.log_drop, w2);

+				if(log_config.drop > 0 && log_config.sql_logs < 1)

+					ShowNotice("Logging Item Drops to file `%s`.txt\n", w2);

+			} else if(strcmpi(w1, "log_pick_file") == 0) {

+				strcpy(log_config.log_pick, w2);

+				if(log_config.pick > 0 && log_config.sql_logs < 1)

+					ShowNotice("Logging Item Picks to file `%s`.txt\n", w2);

+			} else if(strcmpi(w1, "log_zeny_file") == 0) {

+				strcpy(log_config.log_zeny, w2);

+				if(log_config.zeny > 0 && log_config.sql_logs < 1)

+					ShowNotice("Logging Zeny to file `%s`.txt\n", w2);

+			} else if(strcmpi(w1, "log_mvpdrop_file") == 0) {

+				strcpy(log_config.log_mvpdrop, w2);

+				if(log_config.mvpdrop > 0 && log_config.sql_logs < 1)

+					ShowNotice("Logging MVP Drops to file `%s`.txt\n", w2);

+			} else if(strcmpi(w1, "log_present_file") == 0) {

+				strcpy(log_config.log_present, w2);

+				if(log_config.present > 0 && log_config.sql_logs < 1)

+					ShowNotice("Logging Present Usage & Results to file `%s`.txt\n", w2);

+			} else if(strcmpi(w1, "log_produce_file") == 0) {

+				strcpy(log_config.log_produce, w2);

+				if(log_config.produce > 0 && log_config.sql_logs < 1)

+					ShowNotice("Logging Producing to file `%s`.txt\n", w2);

+			} else if(strcmpi(w1, "log_refine_file") == 0) {

+				strcpy(log_config.log_refine, w2);

+				if(log_config.refine > 0 && log_config.sql_logs < 1)

+					ShowNotice("Logging Refining to file `%s`.txt\n", w2);

+			} else if(strcmpi(w1, "log_trade_file") == 0) {

+				strcpy(log_config.log_trade, w2);

+				if(log_config.trade > 0 && log_config.sql_logs < 1)

+					ShowNotice("Logging Item Trades to file `%s`.txt\n", w2);

+			} else if(strcmpi(w1, "log_storage_file") == 0) {

+				strcpy(log_config.log_storage, w2);

+				if(log_config.storage > 0 && log_config.sql_logs < 1)

+					ShowNotice("Logging Item Storages to file `%s`.txt\n", w2);

+			} else if(strcmpi(w1, "log_vend_file") == 0) {

+				strcpy(log_config.log_vend, w2);

+				if(log_config.vend > 0  && log_config.sql_logs < 1)

+					ShowNotice("Logging Vending to file `%s`.txt\n", w2);

+			} else if(strcmpi(w1, "log_gm_file") == 0) {

+				strcpy(log_config.log_gm, w2);

+				if(log_config.gm > 0 && log_config.sql_logs < 1)

+					ShowNotice("Logging GM Level %d Commands to file `%s`.txt\n", log_config.gm, w2);

+			} else if(strcmpi(w1, "log_npc_file") == 0) {

+				strcpy(log_config.log_npc, w2);

+				if(log_config.npc > 0 && log_config.sql_logs < 1)

+					ShowNotice("Logging NPC 'logmes' to file `%s`.txt\n", w2);

+			} else if(strcmpi(w1, "log_chat_file") == 0) {

+				strcpy(log_config.log_chat, w2);

+				if(log_config.chat > 0 && log_config.sql_logs < 1)					

+					ShowNotice("Logging CHAT to file `%s`.txt\n", w2);

+			//support the import command, just like any other config

+			} else if(strcmpi(w1,"import") == 0) {

+				log_config_read(w2);

+			}

+		}

+	}

+

+	fclose(fp);

+	return 0;

+}