Crossfire Server, Trunk  R21041
cflogger.c File Reference
#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:

Go to the source code of this file.

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.

Referenced by check_tables().

◆ 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; \
}
static sqlite3 * database
Definition: cflogger.c:61
static int do_sql(const char *sql)
Definition: cflogger.c:103
#define PLUGIN_NAME
Definition: cfanim.h:32
#define CFLOGGER_CURRENT_FORMAT
Definition: cflogger.c:58

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.

Referenced by check_tables().

◆ 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; \
}
static sqlite3 * database
Definition: cflogger.c:61
static int update_table_format(const char *table, const char *newschema, const char *select_columns)
Definition: cflogger.c:144
#define PLUGIN_NAME
Definition: cfanim.h:32
#define CFLOGGER_CURRENT_FORMAT
Definition: cflogger.c:58

Definition at line 190 of file cflogger.c.

Referenced by check_tables().

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
victimwho died.
killerwho 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(), obj::level, obj::map, PLAYER, and obj::type.

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
mapmap for which to log an event.
event_codearbitrary event code.
plobject causing the event. Can be NULL.

Definition at line 493 of file cflogger.c.

References do_sql(), get_living_id(), get_map_id(), PLAYER, and obj::type.

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
plobject for which to log an event.
event_codearbitrary event code.

Definition at line 467 of file cflogger.c.

References do_sql(), get_living_id(), get_map_id(), and obj::map.

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
typeignored.
Returns
0

Definition at line 626 of file cflogger.c.

References add_death(), add_map_event(), add_player_event(), 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, pl::ob, and store_time().

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
opignored.
paramsignored.
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
paramuser-supplied data.
argcnumber of items.
argvvalues.
azColNamecolumn 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:

◆ 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
sqlquery 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, 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:

◆ 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
livingobject to get identifier for.
Returns
unique identifier in the 'living' table.

Definition at line 326 of file cflogger.c.

References database, do_sql(), obj::level, obj::name, PLAYER, and obj::type.

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
mapmap 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(), mapdef::path, and mapdef::region.

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
regregion 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(), and regiondef::name.

Referenced by get_map_id().

+ Here is the call graph for this function:
+ Here is the caller 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, _timeofday::day, do_sql(), _timeofday::hour, last_stored_day, _timeofday::minute, _timeofday::month, snprintf, 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
tableName of table.
newschemaThis is the new table format. Will be inserted into the parantheses of "create table table_name()".
select_columnsThis 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.