#include <cflogger.h>
#include <cflogger_proto.h>
#include <sqlite3.h>
#include <stdlib.h>
#include <string.h>
#include <svnversion.h>

Include dependency graph for cflogger.c:

Macros
#define	CFLOGGER_CURRENT_FORMAT 3

#define	DO_OR_ROLLBACK(sqlstring)

#define	UPDATE_OR_ROLLBACK(tbl, newschema, select_columns)

Functions
static void	add_death (object victim, object killer)

static void	add_map_event (mapstruct map, int event_code, object pl)

static void	add_player_event (object *pl, int event_code)

CF_PLUGIN int	cflogger_globalEventListener (int *type,...)

CF_PLUGIN int	cflogger_runPluginCommand (object op, char params)

static void	check_tables (void)

static int	check_tables_callback (void param, int argc, char argv, char *azColName)

CF_PLUGIN int	closePlugin (void)

static int	do_sql (const char *sql)

CF_PLUGIN int	eventListener (int *type,...)

static int	get_living_id (object *living)

static int	get_map_id (mapstruct *map)

static int	get_region_id (region *reg)

CF_PLUGIN void *	getPluginProperty (int *type,...)

CF_PLUGIN int	initPlugin (const char *iversion, f_plug_api gethooksptr)

CF_PLUGIN int	postInitPlugin (void)

static int	store_time (void)

static int	update_table_format (const char table, const char newschema, const char *select_columns)

Variables
static sqlite3 *	database

static int	last_stored_day = -1

CF_PLUGIN char	SvnRevPlugin [] = SVN_REV

Detailed Description

This plugin will log events to an sqlite3 database named cflogger.db in the var directory.

Log includes:

players join/leave/creation/quit
map load/unload/reset/enter/leave
kills, whenever a player is concerned
ingame/real time links

Warning: The plugin will not check the database size, which can grow a lot.

Note: Thanks to sqlite's locking, it's possible to access the database through the command line even while the server is running.

Definition in file cflogger.c.

Macro Definition Documentation

◆ CFLOGGER_CURRENT_FORMAT

#define CFLOGGER_CURRENT_FORMAT 3

Current database format

Definition at line 58 of file cflogger.c.

◆ DO_OR_ROLLBACK

#define DO_OR_ROLLBACK ( sqlstring )

Value:

    if (do_sql(sqlstring) != SQLITE_OK) { \
        do_sql("rollback transaction;"); \
        cf_log(llevError, " [%s] Logger database format update failed! Couldn't upgrade from format %d to fromat %d!. Won't log.\n", PLUGIN_NAME, format, CFLOGGER_CURRENT_FORMAT);\
        sqlite3_close(database); \
        database = NULL; \
        return; \
    }

Helper macros for rolling back and returning if query failed. Used in check_tables().

Yes they are quite messy. The alternatives seemed worse.

Definition at line 181 of file cflogger.c.

◆ UPDATE_OR_ROLLBACK

#define UPDATE_OR_ROLLBACK	(	tbl,
		newschema,
		select_columns
	)

Value:

    if (update_table_format((tbl), (newschema), (select_columns)) != SQLITE_OK) { \
        do_sql("rollback transaction;"); \
        cf_log(llevError, " [%s] Logger database format update failed! Couldn't upgrade from format %d to fromat %d!. Won't log.\n", PLUGIN_NAME, format, CFLOGGER_CURRENT_FORMAT);\
        sqlite3_close(database); \
        database = NULL; \
        return; \
    }

Definition at line 190 of file cflogger.c.

Function Documentation

◆ add_death()

static void add_death	(	object *	victim,
		object *	killer
	)

static

Logs a death.

If either of the parameters is NULL, or if neither is a PLAYER, nothing is logged.

Parameters

victim	who died.
killer	who killed.

Definition at line 517 of file cflogger.c.

References cf_object_get_object_property(), CFAPI_OBJECT_PROP_OWNER, do_sql(), get_living_id(), get_map_id(), reputation::killer, PLAYER, obj::type, and reputation::victim.

Referenced by cflogger_globalEventListener().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ add_map_event()

static void add_map_event	(	mapstruct *	map,
		int	event_code,
		object *	pl
	)

static

Logs an event for a map.

Parameters

map	map for which to log an event.
event_code	arbitrary event code.
pl	object causing the event. Can be NULL.

Definition at line 493 of file cflogger.c.

References do_sql(), get_living_id(), get_map_id(), disinfect::map, and PLAYER.

Referenced by cflogger_globalEventListener().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ add_player_event()

static void add_player_event	(	object *	pl,
		int	event_code
	)

static

Logs an event for a living object.

Parameters

pl	object for which to log an event.
event_code	arbitrary event code.

Definition at line 467 of file cflogger.c.

References do_sql(), get_living_id(), and get_map_id().

Referenced by cflogger_globalEventListener().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ cflogger_globalEventListener()

CF_PLUGIN int cflogger_globalEventListener	(	int *	type,
			...
	)

Handles a global event.

Parameters

type ignored.

Returns: 0

Definition at line 626 of file cflogger.c.

References add_death(), add_map_event(), add_player_event(), make_face_from_files::args, EVENT_BORN, EVENT_CLOCK, EVENT_GKILL, EVENT_KICK, EVENT_LOGIN, EVENT_LOGOUT, EVENT_MAPENTER, EVENT_MAPLEAVE, EVENT_MAPLOAD, EVENT_MAPRESET, EVENT_MAPUNLOAD, EVENT_MUZZLE, EVENT_PLAYER_DEATH, EVENT_REMOVE, reputation::killer, disinfect::map, pl::ob, give::op, altar_valkyrie::pl, store_time(), and is_valid_types_gen::type.

Referenced by postInitPlugin().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ cflogger_runPluginCommand()

CF_PLUGIN int cflogger_runPluginCommand	(	object *	op,
		char *	params
	)

Runs a plugin command. Doesn't do anything.

Parameters

op	ignored.
params	ignored.

Returns: -1.

Definition at line 602 of file cflogger.c.

◆ check_tables()

static void check_tables ( void )

static

Checks the database format, and applies changes if old version.

Definition at line 202 of file cflogger.c.

References cf_log(), CFLOGGER_CURRENT_FORMAT, check_tables_callback(), database, DO_OR_ROLLBACK, do_sql(), llevDebug, llevError, PLUGIN_NAME, and UPDATE_OR_ROLLBACK.

Referenced by postInitPlugin().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ check_tables_callback()

static int check_tables_callback	(	void *	param,
		int	argc,
		char **	argv,
		char **	azColName
	)

static

Simple callback to get an integer from a query.

Parameters

param	user-supplied data.
argc	number of items.
argv	values.
azColName	column names.

Returns: always returns 0 to continue the execution.

Definition at line 81 of file cflogger.c.

Referenced by check_tables().

Here is the caller graph for this function:

◆ closePlugin()

CF_PLUGIN int closePlugin ( void )

Close the plugin.

Closes the sqlite database.

Returns: 0.

Definition at line 748 of file cflogger.c.

References cf_log(), database, llevInfo, and PLUGIN_VERSION.

Here is the call graph for this function:

◆ do_sql()

static int do_sql ( const char * sql )

static

Helper function to run a SQL query.

Will LOG() an error if the query fails.

Parameters

sql	query to run.

Returns: SQLITE_OK if no error, other value if error.

Note: There is most likely no need to check return value unless you need to rollback a transaction or similar.

Definition at line 103 of file cflogger.c.

References cf_log(), database, llevError, navar-midane_pickup::msg, and PLUGIN_NAME.

Referenced by add_death(), add_map_event(), add_player_event(), check_tables(), get_living_id(), get_map_id(), get_region_id(), store_time(), and update_table_format().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ eventListener()

CF_PLUGIN int eventListener	(	int *	type,
			...
	)

Handles an object-related event. Doesn't do anything.

Parameters

type ignored.

Returns: 0.

Todo:: build from current map's path, probably

Definition at line 614 of file cflogger.c.

◆ get_living_id()

static int get_living_id ( object * living )

static

Returns a unique identifier for specified object.

Will insert an item in the table if required.

If the object is a player, only name is taken into account to generate an id.

Else, the object's level is taken into account, to distinguish monsters with the same name and different levels (special monsters, and such).

Parameters

living object to get identifier for.

Returns: unique identifier in the 'living' table.

Definition at line 326 of file cflogger.c.

References database, do_sql(), diamondslots::id, is_valid_types_gen::line, and PLAYER.

Referenced by add_death(), add_map_event(), and add_player_event().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ get_map_id()

static int get_map_id ( mapstruct * map )

static

Gets the unique identifier for a map.

Will generate one if required.

Maps starting with '/random/' will all share the same identifier for the same region.

Parameters

map	map for which an id is wanted. Must not be NULL.

Returns: unique map identifier.

Definition at line 396 of file cflogger.c.

References database, do_sql(), get_region_id(), diamondslots::id, is_valid_types_gen::line, disinfect::map, and python_init::path.

Referenced by add_death(), add_map_event(), and add_player_event().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ get_region_id()

static int get_region_id ( region * reg )

static

Gets the unique identifier for a region.

Will generate one if required.

Parameters

reg	region for which an id is wanted

Returns: unique region identifier, or 0 if reg is NULL.

Definition at line 360 of file cflogger.c.

References database, do_sql(), diamondslots::id, is_valid_types_gen::line, and regiondef::name.

Referenced by get_map_id().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getPluginProperty()

CF_PLUGIN void* getPluginProperty	(	int *	type,
			...
	)

Gets a plugin property.

Parameters

type ignored.

Returns

the name, if asked for 'Identification'.
the version, if asked for 'FullName'.
NULL else.

Definition at line 566 of file cflogger.c.

References make_face_from_files::args, buf, PLUGIN_NAME, PLUGIN_VERSION, and is_valid_types_gen::type.

◆ initPlugin()

CF_PLUGIN int initPlugin	(	const char *	iversion,
		f_plug_api	gethooksptr
	)

Main plugin entry point.

Parameters

iversion	server version.
gethooksptr	function to get hooks from.

Returns: always 0.

Definition at line 550 of file cflogger.c.

References cf_init_plugin(), cf_log(), llevInfo, and PLUGIN_VERSION.

Here is the call graph for this function:

◆ postInitPlugin()

CF_PLUGIN int postInitPlugin ( void )

Plugin was initialized, now to finish.

Registers events, initializes the database.

Returns: 0.

Definition at line 697 of file cflogger.c.

References cf_get_directory(), cf_log(), cf_system_register_global_event(), cflogger_globalEventListener(), check_tables(), database, EVENT_BORN, EVENT_CLOCK, EVENT_GKILL, EVENT_KICK, EVENT_LOGIN, EVENT_LOGOUT, EVENT_MAPENTER, EVENT_MAPLEAVE, EVENT_MAPLOAD, EVENT_MAPRESET, EVENT_MAPUNLOAD, EVENT_MUZZLE, EVENT_PLAYER_DEATH, EVENT_REMOVE, llevDebug, llevError, llevInfo, python_init::path, PLUGIN_NAME, PLUGIN_VERSION, and store_time().

Here is the call graph for this function:

◆ store_time()

static int store_time ( void )

static

Stores a line to match current ingame and real time.

Returns: 1 if a line was inserted, 0 if the current ingame time was already logged.

Definition at line 429 of file cflogger.c.

References cf_get_time(), database, send::date, _timeofday::day, do_sql(), _timeofday::hour, last_stored_day, is_valid_types_gen::line, _timeofday::minute, _timeofday::month, and _timeofday::year.

Referenced by cflogger_globalEventListener(), and postInitPlugin().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ update_table_format()

static int update_table_format	(	const char *	table,
		const char *	newschema,
		const char *	select_columns
	)

static

Updates a table to a new schema, used for when ALTER TABLE doesn't work. (Such as when changing column constraints.)

Parameters

table	Name of table.
newschema	This is the new table format. Will be inserted into the parantheses of "create table table_name()".
select_columns	This is inserted into "INSERT INTO table_name SELECT _ FROM ..." to allow changing order of columns, or skipping some. Normally it should be "*".

Warning: This function should only be used in check_tables() below.

No error checking is done. Also it is expected that appending an _old on the table name won't collide with anything.

Note that columns are expected to have same (or compatible) type, and be in the same order. Further both tables should have the same number of columns.

Returns: SQLITE_OK if no error, non-zero if error. This SHOULD be rollback any transaction this function is called in.

Definition at line 144 of file cflogger.c.

References do_sql().

Here is the call graph for this function:

Variable Documentation

◆ database

sqlite3* database

static

Pointer to the logging database.

Definition at line 61 of file cflogger.c.

Referenced by check_tables(), closePlugin(), do_sql(), get_living_id(), get_map_id(), get_region_id(), postInitPlugin(), and store_time().

◆ last_stored_day

int last_stored_day = -1

static

To keep track of stored ingame/real time matching.

Definition at line 64 of file cflogger.c.

Referenced by store_time().

◆ SvnRevPlugin

CF_PLUGIN char SvnRevPlugin[] = SVN_REV

Definition at line 55 of file cflogger.c.

Macros

Functions

Variables

Detailed Description

Macro Definition Documentation

◆ CFLOGGER_CURRENT_FORMAT

◆ DO_OR_ROLLBACK

◆ UPDATE_OR_ROLLBACK

Function Documentation

◆ add_death()

◆ add_map_event()

◆ add_player_event()

◆ cflogger_globalEventListener()

◆ cflogger_runPluginCommand()

◆ check_tables()

◆ check_tables_callback()

◆ closePlugin()

◆ do_sql()

◆ eventListener()

◆ get_living_id()

◆ get_map_id()

◆ get_region_id()

◆ getPluginProperty()

◆ initPlugin()

◆ postInitPlugin()

◆ store_time()

◆ update_table_format()

Variable Documentation

◆ database

◆ last_stored_day

◆ SvnRevPlugin