Author Topic: Whois-cache update script (Read 13714 times)

Alreadythere · « **on:** March 30, 2007, 01:29:53 pm »

This is a script that allows smart updating of the complete integrated whois cache in bebot 0.3 and higher. It will add and update the all members of all the orgs in the cache, as well as updating all orgless characters afterward. Stale entries that haven't been updated some time will be deleted.

After running the script outputs some statistical data.

To run the script put it into some directory (NOT the modules or core directories of the bot!), modify the .conf file to fit your needs and execute the script like every other php script (something along the lines of php whois-update.php. If there are entries in the cache it will update them. On empty caches it won't do anything.

The script to update the cache make sure this script is not in the modules or core directory!
Save as .php
The config file for the update script, add the infos here has to be in the same directory as the update script

PS: For a 0.2 version of this script and the cache check here

Alreadythere · « **Reply #1 on:** March 30, 2007, 01:38:20 pm »

I've commited an optimized table structure for the whois cache to SVN today. It does exactly the same as before, just uses less memory to store the entries.

To update caches created with the old version use the following SQL query, just replace whois with the tablename you use if needed. Here is the ALTER query as text file for download.

Small warning: On large existing caches this query will take several minutes to run.

Code: [Select]

ALTER TABLE whois
	DROP PRIMARY KEY,
	DROP INDEX nickname,
	ADD PRIMARY KEY (nickname),
	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',
	ADD KEY ID (ID),
	ADD KEY Profession (profession),
	ADD KEY Faction (faction),
	ADD KEY OrgID (org_id),
	ADD KEY Orgname (org_name),
	ADD KEY Level (level),
	ADD KEY Alienlevel (defender_rank_id);

Khalem · « **Reply #2 on:** April 07, 2007, 03:30:06 am »

Suggest adding this to SVN along with usage instructions.
Should go into an extras/ folder

Alreadythere · « **Reply #3 on:** April 07, 2007, 10:27:51 am »

Sure, I'll go add it with a README then.

Vhab · « **Reply #4 on:** April 07, 2007, 11:18:51 am »

There's there could be a file containing upgrade instructions and version numbers.
To upgrade your bot you just locate your own version in the file and follow all instructions from that point to the version you're upgrading to