aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB
diff options
context:
space:
mode:
authorPaul S. Owen <psotfx@users.sourceforge.net>2002-05-09 14:08:36 +0000
committerPaul S. Owen <psotfx@users.sourceforge.net>2002-05-09 14:08:36 +0000
commitab8d9f197830d0787bb448128d77c141147176aa (patch)
treec3d0b70ba1401107914bc7529810a293e8396515 /phpBB
parent8043f50781f84390aea612e0f2e0e516f64decde (diff)
downloadforums-ab8d9f197830d0787bb448128d77c141147176aa.tar
forums-ab8d9f197830d0787bb448128d77c141147176aa.tar.gz
forums-ab8d9f197830d0787bb448128d77c141147176aa.tar.bz2
forums-ab8d9f197830d0787bb448128d77c141147176aa.tar.xz
forums-ab8d9f197830d0787bb448128d77c141147176aa.zip
IP related updates NOTE this is just MySQL! Do not run this if you are using other DB's or the necessary IP changes will not be implemented in future
git-svn-id: file:///svn/phpbb/trunk@2559 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB')
-rw-r--r--phpBB/update_script.php170
1 files changed, 164 insertions, 6 deletions
diff --git a/phpBB/update_script.php b/phpBB/update_script.php
index d1ae12fdd2..01ad6ffcd9 100644
--- a/phpBB/update_script.php
+++ b/phpBB/update_script.php
@@ -2,6 +2,16 @@
<body>
<?php
+// --------------------------------
+//
+function decode_ip($int_ip)
+{
+ $hexipbang = explode('.', chunk_split($int_ip, 2, '.'));
+ return hexdec($hexipbang[0]). '.' . hexdec($hexipbang[1]) . '.' . hexdec($hexipbang[2]) . '.' . hexdec($hexipbang[3]);
+}
+//
+// --------------------------------
+
define('IN_PHPBB', 1);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
@@ -34,8 +44,6 @@ if ( $row = $db->sql_fetchrow($result) )
VALUES ('session_last_gc', '0')";
echo '<span style="color:green">DONE</span><br /><br />';
- break;
-
case '.1.0 [20020420]':
switch ( SQL_LAYER )
{
@@ -58,7 +66,6 @@ if ( $row = $db->sql_fetchrow($result) )
die("No DB LAYER found!");
break;
}
- break;
case '.1.0 [20020421]':
$user_data_sql = "SELECT COUNT(user_id) AS total_users, MAX(user_id) AS newest_user_id FROM " . USERS_TABLE . " WHERE user_id <> " . ANONYMOUS;
if($result = $db->sql_query($user_data_sql))
@@ -86,7 +93,43 @@ if ( $row = $db->sql_fetchrow($result) )
VALUES ('newest_username', '$newest_username')";
$sql[] = "INSERT INTO " . CONFIG_TABLE . " (config_name, config_value)
VALUES ('num_users', $user_count)";
- break;
+ case '.1.0 [20020430]':
+ switch ( SQL_LAYER )
+ {
+ case 'mysql':
+ case 'mysql4':
+ $sql[] = "ALTER TABLE " . BANLIST_TABLE . "
+ MODIFY ban_email char(60) NULL,
+ MODIFY ban_ip char(40) NULL";
+ $sql[] = "ALTER TABLE " . DISALLOW_TABLE . "
+ MODIFY disallow_username char(30) NOT NULL";
+ $sql[] = "ALTER TABLE " . POSTS_TABLE . "
+ MODIFY poster_ip char(40) NOT NULL,
+ MODIFY post_username char(30) NULL";
+ $sql[] = "ALTER TABLE " . PRIVMSGS_TABLE . "
+ MODIFY privmsgs_subject char(60) NOT NULL,
+ MODIFY privmsgs_ip char(40) NOT NULL";
+ $sql[] = "ALTER TABLE " . SESSIONS_TABLE . "
+ MODIFY session_ip char(40) NOT NULL";
+ $sql[] = "ALTER TABLE " . USERS_TABLE . "
+ ADD COLUMN user_ip char(40) NOT NULL";
+ $sql[] = "ALTER TABLE " . VOTE_USERS_TABLE . "
+ MODIFY COLUMN vote_user_ip char(40) NOT NULL";
+ break;
+
+ case 'mssql-odbc':
+ case 'mssql':
+ $sql[] = "";
+ break;
+
+ case 'postgresql':
+ $sql[] = "";
+ default:
+ die("No DB LAYER found!");
+ break;
+ }
+
+ break;
default;
echo 'No updates made<br /><br />';
}
@@ -95,16 +138,131 @@ if ( $row = $db->sql_fetchrow($result) )
{
for($i = 0; $i < count($sql); $i++)
{
- if ( !($result = $db->sql_query($sql[$i])) )
+ if ( !$db->sql_query($sql[$i]) )
{
die("Couldn't run update >> " . $sql[$i]);
}
}
}
+
+ $sql_update = array();
+
+ switch ( $row['config_value'] )
+ {
+ case '.1.0 [20020430]':
+
+ $sql = "SELECT ban_id, ban_ip
+ FROM " . BANLIST_TABLE;
+ if ( !($result = $db->sql_query($sql)) )
+ {
+ die("Couldn't select data >> " . $sql);
+ }
+
+ if ( $row = $db->sql_fetchrow($result) )
+ {
+ do
+ {
+ $sql_update[] = "UPDATE " . BANLIST_TABLE . "
+ SET ban_ip = '" . decode_ip($row['ban_ip']) . "'
+ WHERE ban_id = " . $row['ban_id'];
+ }
+ while ( $row = $db->sql_fetchrow($result) );
+ }
+
+ $sql = "SELECT post_id, poster_ip
+ FROM " . POSTS_TABLE;
+ if ( !($result = $db->sql_query($sql)) )
+ {
+ die("Couldn't select data >> " . $sql);
+ }
+
+ if ( $row = $db->sql_fetchrow($result) )
+ {
+ do
+ {
+ $sql_update[] = "UPDATE " . POSTS_TABLE . "
+ SET poster_ip = '" . decode_ip($row['poster_ip']) . "'
+ WHERE post_id = " . $row['post_id'];
+ }
+ while ( $row = $db->sql_fetchrow($result) );
+ }
+
+ $sql = "SELECT privmsgs_id, privmsgs_ip
+ FROM " . PRIVMSGS_TABLE;
+ if ( !($result = $db->sql_query($sql)) )
+ {
+ die("Couldn't select data >> " . $sql);
+ }
+
+ if ( $row = $db->sql_fetchrow($result) )
+ {
+ do
+ {
+ $sql_update[] = "UPDATE " . PRIVMSGS_TABLE . "
+ SET privmsgs_ip = '" . decode_ip($row['privmsgs_ip']) . "'
+ WHERE privmsgs_id = " . $row['privmsgs_id'];
+ }
+ while ( $row = $db->sql_fetchrow($result) );
+ }
+
+ $sql = "SELECT session_id, session_ip
+ FROM " . SESSIONS_TABLE;
+ if ( !($result = $db->sql_query($sql)) )
+ {
+ die("Couldn't select data >> " . $sql);
+ }
+
+ if ( $row = $db->sql_fetchrow($result) )
+ {
+ do
+ {
+ $sql_update[] = "UPDATE " . SESSIONS_TABLE . "
+ SET session_ip = '" . decode_ip($row['session_ip']) . "'
+ WHERE session_id = '" . $row['session_id'] . "'";
+ }
+ while ( $row = $db->sql_fetchrow($result) );
+ }
+
+ $sql = "SELECT vote_id, vote_user_id, vote_user_ip
+ FROM " . VOTE_USERS_TABLE;
+ if ( !($result = $db->sql_query($sql)) )
+ {
+ die("Couldn't select data >> " . $sql);
+ }
+
+ if ( $row = $db->sql_fetchrow($result) )
+ {
+ do
+ {
+ $sql_update[] = "UPDATE " . VOTE_USERS_TABLE . "
+ SET vote_user_ip = '" . decode_ip($row['vote_user_ip']) . "'
+ WHERE vote_id = " . $row['vote_id'] . "
+ AND vote_user_id = " . $row['vote_user_id'];
+ }
+ while ( $row = $db->sql_fetchrow($result) );
+ }
+ break;
+ }
+
+ if ( count($sql_update) )
+ {
+ echo 'Updating existing data :: ';
+ flush();
+
+ for($i = 0; $i < count($sql_update); $i++)
+ {
+ if ( !$db->sql_query($sql_update[$i]) )
+ {
+ die("Couldn't run update >> " . $sql_update[$i]);
+ }
+ }
+
+ echo "DONE<br /><br />\n";
+ }
}
$sql = "UPDATE " . CONFIG_TABLE . "
- SET config_value = '.1.0 [20020430]'
+ SET config_value = '.1.0 [20020905]'
WHERE config_name = 'version'";
if ( !($result = $db->sql_query($sql)) )
{
generated by cgit v1.2.1 (git 2.21.0) at 2025-03-25 14:18:06 +0000