phpBB.de

<?PHP

/***************************************************************************
* IP_Track_Install.php
* --------------------
* Version : 2.1
*
***************************************************************************/

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);

define('SHOW_ONLINE', true);
$page_title = "IP Tracking Install v2.0";
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
echo "<br><br><br>";

$step = $_GET['step'];

$is_admin = $userdata['user_level'];

if($is_admin <> "1")
{
message_die(CRITICAL_ERROR, "Sorry ". $userdata['username'] .", You're not authorized to run installs on this board.", "Not Authorized");
}
else
{
if(!$step)
{
echo "<META HTTP-EQUIV=\"refresh\" content=\"5;URL=install.php?step=1\">";
message_die(GENERAL_MESSAGE, "Welcome ".$userdata['username'].", The Install Will Begin In 5 Seconds. ", "Authorized");
}
elseif($step == "1")
{
echo "<table width='100%' border='1' cellspacing='2' align='center' valign='middle'>";
echo " <tr>";
echo " <th class='thHead' colspan='2'>";
echo " <center>";
echo " IP Tracking Install: Step One.";
echo " </center>";
echo " </th>";
echo " </tr>";
echo "</table>";
echo "<br><br>";
echo "<table width='100%' cellspacing='2' align='center' valign='top' border='1'>";
echo " <tr>";
echo " <td align='center' valign='top'>";
echo " <span class='gensmall'>";
echo " <b>In This Step, We Will Be Installing The Config Table & Fields.</b>";
echo " </span>";
echo " </td>";
echo " </tr>";
echo "</table>";
echo "<br><br><br>";

$sql = array();
$sql[] = "DROP TABLE IF EXISTS ". $table_prefix ."ip_tracking_config";
$sql[] = "CREATE TABLE `". $table_prefix ."ip_tracking_config` (
`max` varchar(15) NOT NULL default ''
) TYPE=MyISAM;";

$sql[] = "INSERT INTO `". $table_prefix ."ip_tracking_config` VALUES ('25000');";

echo "<table width='100%' cellspacing='2' align='center' valign='top' border='1'>";
echo " <tr>";
echo " <td align='center' valign='top'>";
echo " <span class='gensmall'>";
echo " <b>Step One Finished. Please Log All Errors If There Are Any. Step Two Will Begin In 5 Seconds.</b>";
echo " </span>";
echo " </td>";
echo " </tr>";
echo "</table>";

for( $b = 0; $b < count($sql); $b++ )
{
if( !$result = $db->sql_query ($sql[$b]) )
{
$error = $db->sql_error();
echo "<META HTTP-EQUIV=\"refresh\" content=\"5;URL=install.php?step=2\">";
echo "<table width='100%' cellspacing='2' align='center' valign='top' border='1'>";
echo " <tr>";
echo " <td align='center' valign='top'>";
echo " <span class='gensmall'>";
echo " ". $sql[$b]."<br><br><b>Error: </b>".$error['message']."<br>";
echo " </span>";
echo " </td>";
echo " </tr>";
echo "</table>";
}
else
{
echo "<META HTTP-EQUIV=\"refresh\" content=\"5;URL=install.php?step=2\">";
echo "<table width='100%' cellspacing='2' align='center' valign='top' border='1'>";
echo " <tr>";
echo " <td align='center' valign='top'>";
echo " <span class='gensmall'>";
echo " ".$sql[$b]."<br><br><b>Successfully Completed.</b>";
echo " </span>";
echo " </td>";
echo " </tr>";
echo "</table>";
}
}
}
elseif($step == "2")
{
echo "<table width='100%' border='1' cellspacing='2' align='center' valign='middle'>";
echo " <tr>";
echo " <th class='thHead' colspan='2'>";
echo " <center>";
echo " IP Tracking Install: Step Two.";
echo " </center>";
echo " </th>";
echo " </tr>";
echo "</table>";
echo "<br><br>";
echo "<table width='100%' cellspacing='2' align='center' valign='top' border='1'>";
echo " <tr>";
echo " <td align='center' valign='top'>";
echo " <span class='gensmall'>";
echo " <b>In This Step, We Will Be Installing The Tracking Table & Fields.</b>";
echo " </span>";
echo " </td>";
echo " </tr>";
echo "</table>";
echo "<br><br><br>";

$sql = array();
$sql[] = "DROP TABLE IF EXISTS ". $table_prefix ."ip_tracking";
$sql[] = "CREATE TABLE `". $table_prefix ."ip_tracking` (
`ip` varchar(15) NOT NULL default '',
`time` int(11) NOT NULL default '0',
`located` varchar(255) NOT NULL default '',
`referer` text NOT NULL,
`username` varchar(50) NOT NULL default '',
`browser` varchar(255) NOT NULL default ''
) TYPE=MyISAM;";

echo "<table width='100%' cellspacing='2' align='center' valign='top' border='1'>";
echo " <tr>";
echo " <td align='center' valign='top'>";
echo " <span class='gensmall'>";
echo " <b>Step Two Finished. Please Log All Errors If There Are Any. Step Three Will Begin In 5 Seconds.</b>";
echo " </span>";
echo " </td>";
echo " </tr>";
echo "</table>";

for( $b = 0; $b < count($sql); $b++ )
{
if( !$result = $db->sql_query ($sql[$b]) )
{
$error = $db->sql_error();
echo "<META HTTP-EQUIV=\"refresh\" content=\"5;URL=install.php?step=3\">";
echo "<table width='100%' cellspacing='2' align='center' valign='top' border='1'>";
echo " <tr>";
echo " <td align='center' valign='top'>";
echo " <span class='gensmall'>";
echo " ". $sql[$b] ."<br><br><b>Error: </b>".$error['message']."<br>";
echo " </span>";
echo " </td>";
echo " </tr>";
echo "</table>";
}
else
{
echo "<META HTTP-EQUIV=\"refresh\" content=\"5;URL=install.php?step=3\">";
echo "<table width='100%' cellspacing='2' align='center' valign='top' border='1'>";
echo " <tr>";
echo " <td align='center' valign='top'>";
echo " <span class='gensmall'>";
echo " ". $sql[$b] ."<br><br><b>Successfully Completed.</b>";
echo " </span>";
echo " </td>";
echo " </tr>";
echo "</table>";
}
}
}
elseif($step == "3")
{
message_die(GENERAL_ERROR, "Well ". $userdata['username'] .", The install is finished. ", "Install Complete");
}
else
{
message_die(GENERAL_ERROR, "Sorry ". $userdata['username'] .", An error has occured.", "Install Error");
}
}

echo "<table width='100%' cellspacing='2' align='center' valign='bottom'>";
echo " <tr>";
echo " <td align='center' valign='top'>";
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
echo " </td>";
echo " </tr>";
echo "</table>";
?>