[Pogamut-list] sqlitebot

[jcothran]

Re: sqlitebot

Author: jcothran

http://code.google.com/p/sqlitebot/wiki/sqlitebotHome#Update_June_22_2009

I've modified the bot, borrowing mostly from the 'hunter' bot example and a strafing function from the 'amis/loque' bot(many, many thanks to folks sharing their example code, which helps much with the learning/syntax curve and being able to reuse prior development). Found it helpful to display all message events to the log and then filter ones out that I wasn't interested in. The bot now records the map, location and timestamp when it kills or is killed(a database INSERT function) and uses one of these most recent 3 locations recorded in the last 45 game seconds to return to(a database SELECT function).

This database could be utilized to build additional summary tables(something like a heat/influence map) which could reflect further analysis/statistics processing based on the locational data. Also interesting would be to move beyond just the bots immediate 'recent' row-based memory and begin pattern analysis of the locational data to detect generalized trends/patterns which might recur during gameplay.

The bot could also experiment with behavioral types like 'camping/sniping' at certain locations to determine the most effective spots/regions of the map or player conditions to do so.

Would also like to move into recording of pathing and enemy predicted pathing and outcomes as might be utilized in leading or flanking maneuvers.

The current sqlite table 'obs' is organized as follows

sqlite> .schema obs
CREATE TABLE obs (
  row_id integer PRIMARY KEY,
  row_entry_date text,
  map_level text,
  map_id int,
  navpoint_id int,
  location text,
  unreal_id text,
  event_location text,
  event_time real,
  event_weight real);

sqlite> select * from obs;
1|2009-06-22 12:13:06|DM-Flux2|234|180|-1226.0,-1258.0,-319.99|DM-Flux2.PathNode
16|-255.48,1193.43,-315.15|1225.19|1.0
2|2009-06-22 12:13:15|DM-Flux2|234|180|-1226.0,-1258.0,-319.99|DM-Flux2.PathNode
16|-286.4,1357.37,-296.91|1234.79|1.0
3|2009-06-22 12:13:20|DM-Flux2|234|180|-1226.0,-1258.0,-319.99|DM-Flux2.PathNode
16|-29.54,1288.36,-296.94|1239.97|1.0