[AndrewD]

Originally Posted by AndrewD

You're right - get_hotlinks.php is only used for an integration of this hack with VBindex/VBadvanced developed by Natch. I'd forgotten that the code was a subdirectory deep. I'll update the instructions accordingly.

On the second point, I'll have a look how to adjust the installation script to deal with MySQL 4.1

It should be sufficient to add one line in the local_links_install.php script. Can you test and let me know? (you'll have to uninstall and reinstall)

	echo "--- Creating ".THIS_TABLE."linkslink if it does not exist<br />";

	$asb = $DB_site->query("
	CREATE TABLE IF NOT EXISTS ".THIS_TABLE."linkslink (
		 linkid int(11) NOT NULL auto_increment,
		 linkname varchar(255) NOT NULL,
		 linkdesc text NOT NULL,
		 linkurl text NOT NULL,
		 linkhits mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
		 linkforum smallint(5) NOT NULL,
		 linkcheck int(10) unsigned NOT NULL,
		 linkstatus int(10) DEFAULT '0' NOT NULL,
		 linkdate int(10) NOT NULL,
		 linkusername text NOT NULL,
		 linkuserid int(10) NOT NULL,
		 linkmoderate int(2) NOT NULL,
		 linkmoddate int(10) DEFAULT '0' NOT NULL,
		 linkreviewfreq smallint(5) DEFAULT '0' NOT NULL,
		 PRIMARY KEY (linkid),
		 FULLTEXT KEY namedesc (linkname,linkdesc)
	)
	TYPE = MYISAM
	");