public function installShrtnr() { $script = "\nCREATE TABLE `links` (\n `lnkID` int(11) NOT NULL AUTO_INCREMENT,\n `lnkURL` varchar(50000) NOT NULL,\n `lnkTimestamp` datetime NOT NULL,\n `lnkIP` varchar(15) NOT NULL,\n `lnkClicks` int(11) NOT NULL,\n `lnkCustomURL` varchar(10) DEFAULT NULL,\n `lnkSingleUse` tinyint(1) DEFAULT NULL,\n PRIMARY KEY (`lnkID`)\n) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; if (dbconnection::execSQLUnprepared($script) === true) { $this->success("", false, "Database was prepared successfully! You can start using shrtnr!"); } else { $this->error("Error creating shrtnr tables... maybe do it by hand?"); } exit; }