<?php
///////////////////////////////////////
// Example to show how to Obtain the
// insert ID of the Last Record
// inserted into the database table
///////////////////////////////////////
include "dbclass.php";
$a = new dbClass('localhost', 'test', 'root', 'password');
// Open database connection -------------------------------------------------------------------------
$a->openConnection();
// Execute an SQL command like INSERT or UPDATE ----------------------------------------------
$a->execCommand("INSERT INTO `test1` (column1,column2,column3,column4) VALUES ('1','2','3','4');");
$LastInsertID = $a->getLastInsertID();
echo "The Last Record ID you Inserted was: " . $LastInsertID;
$a->closeConnection();
?>
echo "Who Is Online Security:<br>Please Remve <b>install.php</b>.";
exit;
}
$db1 = new dbClass();
$db1->setDBVars($dbhost, $dbname, $dbuser, $dbpass);
$db1->openConnection();
$ip = $_SERVER['REMOTE_ADDR'];
$sql = "SELECT COUNT(*) FROM `{$dbname}`.`{$dbtable}` WHERE `ip`='{$ip}';";
$rowOut = $db1->queryRowArray($sql);
$ip_exists = $rowOut[0];
if ($ip_exists > 0) {
$sql = "SELECT COUNT(*) FROM `{$dbname}`.`{$dbtable}`";
$rowOut = $db1->queryRowArray($sql);
$count = $rowOut[0];
} else {
$db1->execCommand("INSERT INTO `{$dbname}`.`{$dbtable}` (`ip`) VALUES ('{$ip}');");
$sql = "SELECT COUNT(*) FROM `{$dbname}`.`{$dbtable}`;";
$rowOut = $db1->queryRowArray($sql);
$count = $rowOut[0];
}
echo "<table>";
echo "<tr><td>" . $txtVisitors . "</td><td>" . $count . "</td></tr>";
echo "<tr><td>" . $txtYourIP . "</td><td>" . $ip . "</td></tr>";
echo "</table>";
if (ago($_SESSION['entrytime']) > 600) {
// -------------- REMOVE OLD IP ENTRIES ------------------------------------------------------------------------
$db1->execCommand("DELETE FROM `{$dbname}`.`{$dbtable}` WHERE modified < (now() - INTERVAL {$purge_length} MINUTE);");
// -------------------------------------------------------------------------------------------------------------
$_SESSION['entrytime'] = time();
echo "Purged Rows";
}
$dbpass = $_POST['txtdbpass'];
//echo "Inside The Installer<br>";
//echo "$dbhost-$dbname-$dbtable-$dbuser-$dbpass";
$sql1 = "CREATE DATABASE IF NOT EXISTS `{$dbname}`;";
$sql2 = "CREATE TABLE IF NOT EXISTS `{$dbname}`.`{$dbtable}` (`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,`ip` VARCHAR(20) NOT NULL,`modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,PRIMARY KEY(`id`));";
$cfgsettings = '<?php $dbhost="' . $dbhost . '"; $dbname="' . $dbname . '"; $dbtable="' . $dbtable . '"; $dbuser="******"; $dbpass="******"; $purge_length=10; $txtVisitors="Visitors:"; $txtYourIP="Your IP:"; ?>';
echo "<center>";
echo "SQL Statement Database: <br><textarea cols=\"45\" rows=\"2\">{$sql1}</textarea><br><br>";
echo "SQL Statement TABLE: <br><textarea cols=\"45\" rows=\"8\">{$sql2}</textarea><br><br>";
echo "Configuration Setting: <br><textarea cols=\"45\" rows=\"8\">{$cfgsettings}</textarea><br>";
// Table Creation SQL Statement -------------------
include "dbclass.php";
$db1 = new dbClass();
$db1->setDBVars($dbhost, $dbname, $dbuser, $dbpass);
$db1->openConnection();
$db1->execCommand($sql1);
$db1->execCommand($sql2);
$db1->closeConnection();
echo "<br><br>Installation Completed!";
echo "</center>";
} else {
?>
<!-- HTML Form -->
<form name="whoisonlineinstall" action="<?php
echo $_SERVER['PHP_SELF'];
?>
" method="post">
<table border="0" cellpadding="0" cellspacing="2" align="center">
<tr>
<td>
