Updated lookup function with optional second parameter $nolookup, as per Wolfbiter's idea.
If you got some lookups that are don't need to check for updated information because they aren't that important do $lookup($name, true), and the cache won't try to get new information of the FC site even if the cached one is out-of-date.

Removed all references to get_tablename, get_setting and define_tablename functions, there is now one global parameter for the name of the whois table. Adapt that to your needs, it's supposed to be global over all bots anyways.
This should make it easier for new user to install the whois-cache, as no modifications to the Bot.php are needed anymore. Only the modules that use lookups have to be modified still.

Links in first post point to current updated files.

If you had an older version of the cache running, did you modifiy the table scheme as mentioned in this post?

Sorry, was an error in the code (UPDATED instead of the correct UPDATE).

Just redownload the file in first post, or edit the line manually. All you have to do then is remove the D at the end.

Updated the table structure. Main change is extensive use of enums instead of varchars where only a limited number of choices exist. Main effect is a reduction in the size of the database.

Updated files in first post, the working of the cache hasn't changed in any way.

To convert old tables to the updated structure use the following SQL code:
ALTER IGNORE TABLE whois
CHANGE ID ID int(15) NOT NULL default '0',
CHANGE nickname nickname varchar(15) NOT NULL default '',
CHANGE firstname firstname varchar(20) NOT NULL default '',
CHANGE lastname lastname varchar(20) NOT NULL default '',
CHANGE level level tinyint(3) unsigned NOT NULL default '1',
CHANGE gender gender enum('Female','Male','Neuter') NOT NULL default 'Female',
CHANGE breed breed enum('Atrox','Nano','Opifex','Solitus') NOT NULL default 'Atrox',
CHANGE faction faction enum('Clan','N/A','Neutral','Omni') NOT NULL default 'Clan',
CHANGE profession profession enum('Adventurer','Agent','Bureaucrat','Doctor','Enforcer','Engineer','Fixer','Keeper','Martial Artist','Meta-Physicist','Nano-Technician','Shade','Soldier','Trader') NOT NULL default 'Adventurer',
CHANGE defender_rank defender_rank enum('Able','Accomplished','Adept','Amateur','Backer','Beginner','Challenger','Champ','Common','Competent','Defender','Fair','Fledgling','Guardian','Hero','Intermediate','Medalist','Mediocre','Newcomer','None','Patron','Protector','Qualified','Starter','Student','Suited','Supporter','Talented','Trustworthy','Vanquisher','Vindicator') NOT NULL default 'Able',
CHANGE defender_rank_id defender_rank_id enum('0','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30') NOT NULL default '0',
CHANGE org_id org_id bigint(10) NOT NULL default '0',
CHANGE org_name org_name varchar(50) NOT NULL default '',
CHANGE org_rank org_rank varchar(20) NOT NULL default '',
CHANGE org_rank_id org_rank_id enum('0','1','2','3','4','5','6','7','8','9','10') NOT NULL default '0',
CHANGE pictureurl pictureurl varchar(100) NOT NULL default '',
CHANGE used used bigint(25) NOT NULL default '0',
CHANGE updated updated int(10) NOT NULL default '0'
Change whois to the name of your cache table.

i'm starting to get an error again.

PHP Notice: Undefined offset: 1 in C:\php\w_update.php on line 22

that line

$tmp = explode("</" . $tag . ">", $tmp[1]);

forgive me......but I have been looking at this thread for the past couple of days.......and have not been able to get this to work.....is there a step by step install guide???  or can I see/get a list of all the files that need changing to get this to work???  I am currently using 0.2.9 with PHP 5.2.0 install.

Basically you have to edit every module that uses get_site to read character information of FC.
$this -> bot -> get_site("http://www.anarchy-online.com/character/bio/d/" . $dimension . "/name/" . $user . "/bio.xml");That's every line similar to the one above.

Out of my head modules that need to be edited are:

• whois
• tower-alert
• teams
• online
• logon

I could have missed a couple still.

As posted here I am using a cache for all whois entries.

Link not working. ^^

Edit: no, wait, I think I figured it out. Nvm.

Ok, trying to get this to work on my bot, but when i try to fetch the db (when running php4 whois-update.php) i get the error:
"Query failed : Table 'aodb.whois' doesn't exist"

my database is called aodb, but it dosnt seems like the script adds any tables to it when i run it... anyone got any idea of what might be wrong?