From 6695be87e82d294aa04d925b8ef880326b3352fb Mon Sep 17 00:00:00 2001
From: "Paul S. Owen" <psotfx@users.sourceforge.net>
Date: Fri, 7 Sep 2001 00:23:40 +0000
Subject: Moved signature attach toggle to DB run convert_sig to update after
 adding new field to DB

git-svn-id: file:///svn/phpbb/trunk@998 89ea8834-ac86-4346-8a33-228a782c2dd0
---
 phpBB/develop/convert_sigs.php | 81 ++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 81 insertions(+)
 create mode 100644 phpBB/develop/convert_sigs.php

(limited to 'phpBB/develop')

diff --git a/phpBB/develop/convert_sigs.php b/phpBB/develop/convert_sigs.php
new file mode 100644
index 0000000000..0ba2f22304
--- /dev/null
+++ b/phpBB/develop/convert_sigs.php
@@ -0,0 +1,81 @@
+
+<?
+
+$phpbb_root_path = "../";
+
+include($phpbb_root_path . 'extension.inc');
+include($phpbb_root_path . 'config.'.$phpEx);
+include($phpbb_root_path . 'includes/constants.'.$phpEx);
+include($phpbb_root_path . 'includes/db.'.$phpEx);
+
+$sql = "SELECT post_id, post_text 
+	FROM " . POSTS_TEXT_TABLE;
+if( $result = $db->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 "<BR>";
+
+	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 "<BR>";
+
+	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 "<BR><BR>COMPLETE<BR>";
+
+?>
-- 
cgit v1.2.1