From ca791961aa9664a6138954015f48bd417d372150 Mon Sep 17 00:00:00 2001 From: "Paul S. Owen" Date: Tue, 25 Feb 2003 15:46:36 +0000 Subject: Not relevant to the 2.2 branch git-svn-id: file:///svn/phpbb/trunk@3523 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/develop/convert_sigs.php | 93 ------------------------------------------ 1 file changed, 93 deletions(-) delete mode 100644 phpBB/develop/convert_sigs.php (limited to 'phpBB/develop/convert_sigs.php') diff --git a/phpBB/develop/convert_sigs.php b/phpBB/develop/convert_sigs.php deleted file mode 100644 index 501106fc10..0000000000 --- a/phpBB/develop/convert_sigs.php +++ /dev/null @@ -1,93 +0,0 @@ -sql_query($sql) ) -{ - $rowset = $db->sql_fetchrowset($result); - - $attach_sql = ""; - $non_attach_sql = ""; - - for($i = 0; $i < count($rowset); $i++) - { - if( ereg("\[addsig]$", $rowset[$i]['post_text'])) - { - if( $attach_sql != "" ) - { - $attach_sql .= ", "; - } - $attach_sql .= $rowset[$i]['post_id']; - - $sql = "UPDATE " . POSTS_TEXT_TABLE . " - SET post_text = '" . addslashes(preg_replace("/\[addsig\]/is", "", $rowset[$i]['post_text'])) . "' - WHERE post_id = " . $rowset[$i]['post_id']; - if( !$result = $db->sql_query($sql) ) - { - die("Couldn't update post_text - " . $i); - } - - } - else - { - if( $non_attach_sql != "" ) - { - $non_attach_sql .= ", "; - } - $non_attach_sql .= $rowset[$i]['post_id']; - } - } - - echo "
"; - - if( $attach_sql != "" ) - { - echo $sql = "UPDATE " . POSTS_TABLE . " - SET enable_sig = 1 - WHERE post_id IN ($attach_sql)"; - if( !$result = $db->sql_query($sql) ) - { - die("Couldn't update post table attach_sig - "); - } - } - - echo "
"; - - if( $non_attach_sql != "" ) - { - echo $sql = "UPDATE " . POSTS_TABLE . " - SET enable_sig = 0 - WHERE post_id IN ($non_attach_sql)"; - if( !$result = $db->sql_query($sql) ) - { - die("Couldn't update post table non_attach_sig - "); - } - } - -} - -$db->sql_close(); - - echo "

COMPLETE
"; - -?> -- cgit v1.2.1