sqlitebot/squads/schema for UT2004 Thread

Hi,

I'm a programmer/developer who's working up an AI bot/squad/strategy support system based out of my previous work in winning the Botprize.org contest this year.  The AI is centered around the logging and utilization of gameplay status and event history to a sqlite Sqlite.org relational database(a lightweight file-based database embedded in most mobile phones for example).  The table schema developed thus far is at Code.google.com which allows myself or an AI-automated program to assign bots to squads and carry out some basic commands like hunt or follow a target with bots on the same squad sharing/utilizing table information like enemies last seen location.

Would be interested if this might be a useful tool for modders, the idea being to provide a ready-made library of squad/unit commands and controlled/filtered behaviors to simplify the mod effort so that the game development can focus more on interesting artistic content and strategy algorithms that utilize the available gameplay information/commands/behaviors.  Would be interested to see this developed as a general AI-support model than something engine/company specific as well.  Also interested if such similar professional tools already exist and examples of their effectiveness.

The general flow of development is described at Code.google.com and includes a simple map generator Code.google.com for testing the AI in a more controlled/configured test map environment.

Also have posted some beginning analysis graphs of map influence/hotspots at Code.google.com

The AI currently runs separately from UT2004 as a java based thread (Pogamut  Artemis.ms.mff.cuni.cz which communicates with Gamebot API)  Unfortunately, with each bot thread consuming 5-10% of my desktop CPU
running at highest(realtime) priority - 6 to 10 units/bots at once would be the max recommended in realtime. Slowing the gamespeed down dramatically, folks might be able to run simulations with larger numbers of bots.

Questions/feedback welcome,

Cheers
Jeremy

Ralph and LLoyd follow target Barry

Good question that I don't really know the answer to at this point, my guess is that it is because its an independent java thread instead of engine internal/optimized C, C++ code.  Not sure that unrealscript(running faster internally) by itself would support a sqlite database call with the same ease of the java sqlite class library I'm using.  I believe there are many RTS games that use long-term memory influence maps, etc, but would be interested to see more open/common solutions where thats applicable.

Also meant to add that I started a few basic gametypes - a 'survival' mode could be effected simply by increasing or reducing the spawned number/types of enemies based on the kill/death stats kept on the kill_score lookup table and a 'tide' mode where when a player kills a bot, the bot becomes part of his squad/gang to attack other players/gangs.

Jeremy

what has that to do with it if i might ask?
2 different engines, one witouth tools (DM, even tho a part of the source sdk can be used, but no code) and one where you can acces the script (unreal)