MOD wieder deinstallieren

DreamPromise · Beitrag von **DreamPromise** » 25.04.2006 08:53

Moin moin

ich hatte mir vor Monaten mal den "Advanced IP Tracking"- MOD installiert.
Er hat lange funktioniert.
Doch aus keinem erkennbaren Grund funktioniert er nun nicht mehr.
Leider konnte mir auch hier niemand helfen um das Problem zu lösen.....

Nun hab ich diesen MOD wieder ausgebaut.
Nur frage ich mich wie ich nun die Tabellen lösche.

In der Installsteht folgende SQL:

<?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>";
?>

Kann mir jemand helfen die entsprechenden Tabellen zu löschen ??

1000 Dank

JENS

IPB_Flüchtling · Beitrag von **IPB_Flüchtling** » 25.04.2006 19:01

Hallo Jens,

hast Du phpMyAdmin (es geht aber auch über den SQL-Browser von MySQLDumper.de)?

Dann lösche mit einem dieser Tools einfach folgende 2 Tabellen:

phpBB_ip_tracking_config
phpBB_ip_tracking

Wenn Du einen anderen Präfix als phpBB hast, wird der Namen der beiden Tabellen halt etwas anders heißen.

Anleitung zum Umgang mit phpMyAdmin:

http://www.phpbb.de/doku/kb/artikel.php?artikel=pma_faq

Mach vorher ein Backup der Datenbank!

LG, IPB_Flüchtling

DreamPromise · Beitrag von **DreamPromise** » 25.04.2006 21:10

Moin moin

hab schon viele Tabellen mittels phpMyAdmin gelöscht.
Nur konnte ich nicht erkennen ob diese MOD noch in anderen Tabellen was angelegt hat.

1000 Dank...

DP