From 419bb07697e65bd0ddcfbcc451611e1259fa7d6b Mon Sep 17 00:00:00 2001
From: "Paul S. Owen" <psotfx@users.sourceforge.net>
Date: Fri, 5 Jul 2002 23:52:14 +0000
Subject: Initial commit ... neither do anything, just wanted to add something
 :D

git-svn-id: file:///svn/phpbb/trunk@2652 89ea8834-ac86-4346-8a33-228a782c2dd0
---
 phpBB/admin/admin_permissions.php | 130 +++++++++++++++++++
 phpBB/admin/admin_search.php      | 255 ++++++++++++++++++++++++++++++++++++++
 2 files changed, 385 insertions(+)
 create mode 100644 phpBB/admin/admin_permissions.php
 create mode 100644 phpBB/admin/admin_search.php

(limited to 'phpBB/admin')

diff --git a/phpBB/admin/admin_permissions.php b/phpBB/admin/admin_permissions.php
new file mode 100644
index 0000000000..7dfa0b597e
--- /dev/null
+++ b/phpBB/admin/admin_permissions.php
@@ -0,0 +1,130 @@
+<?php
+/***************************************************************************
+ *                           admin_permissions.php
+ *                            -------------------
+ *   begin                : Saturday, Feb 13, 2001
+ *   copyright            : (C) 2001 The phpBB Group
+ *   email                : support@phpbb.com
+ *
+ *   $Id$
+ *
+ ***************************************************************************/
+
+/***************************************************************************
+ *
+ *   This program is free software; you can redistribute it and/or modify
+ *   it under the terms of the GNU General Public License as published by
+ *   the Free Software Foundation; either version 2 of the License, or
+ *   (at your option) any later version.
+ *
+ ***************************************************************************/
+
+if ( !empty($setmodules) )
+{
+	if ( !$acl->get_acl_admin('forums') )
+	{
+		return;
+	}
+	
+	$filename = basename(__FILE__);
+	$module['Forums']['Permissions']   = $filename . $SID . '&amp;mode=forums';
+	$module['General']['Set_Administrators']   = $filename . $SID . '&amp;mode=admins';
+
+	return;
+}
+
+define('IN_PHPBB', 1);
+//
+// Include files
+//
+$phpbb_root_path = '../';
+require($phpbb_root_path . 'extension.inc');
+require('pagestart.' . $phpEx);
+
+//
+// Do we have forum admin permissions?
+//
+if ( !$acl->get_acl_admin('forums') )
+{
+	message_die(MESSAGE, $lang['No_admin']);
+}
+
+//
+// Define some vars
+//
+if ( isset($HTTP_GET_VARS['f']) || isset($HTTP_POST_VARS['f']) )
+{
+	$forum_id = ( isset($HTTP_POST_VARS['f']) ) ? intval($HTTP_POST_VARS['f']) : intval($HTTP_GET_VARS['f']);
+
+	$forum_sql = " WHERE forum_id = $forum_id";
+}
+else
+{
+	unset($forum_id);
+	$forum_sql = '';
+}
+
+//
+// Start program proper
+//
+
+//
+// Get required information, either all forums if
+// no id was specified or just the requsted if it
+// was
+//
+if ( !empty($forum_id) )
+{
+	//
+	// Output the selection table if no forum id was
+	// specified
+	//
+	$template->set_filenames(array(
+		"body" => "admin/auth_select_body.tpl")
+	);
+
+	$select_list = '<select name=f">';
+	for($i = 0; $i < count($forum_rows); $i++)
+	{
+		$select_list .= '<option value="' . $forum_rows[$i]['forum_id'] . '">' . $forum_rows[$i]['forum_name'] . '</option>';
+	}
+	$select_list .= '</select>';
+}
+else
+{
+	$sql = "SELECT forum_id, forum_name 
+		FROM " . FORUMS_TABLE . "  
+		ORDER BY cat_id ASC, forum_order ASC";
+	$result = $db->sql_query($sql);
+
+	$select_list = '';
+	while ( $row = $db->sql_fetchrow($result) )
+	{
+		$select_list .= '<option value="' . $row['forum_id'] . '">' . $row['forum_name'] . '</option>';
+	}
+	$db->sql_freeresult($result);
+
+	page_header($lang['Forums']);
+
+?>
+
+<h1><?php echo $lang['Permissions']; ?></h1>
+
+<p><?php echo $lang['Permissions_explain']; ?></p>
+
+<form method="post" action="<?php echo "admin_permissions.$phpEx$SID"; ?>"><table cellspacing="1" cellpadding="4" border="0" align="center" bgcolor="#98AAB1">
+	<tr>
+		<th align="center"><?php echo $lang['Select_a_Forum']; ?></th>
+	</tr>
+	<tr>
+		<td class="row1" align="center">&nbsp;<select name="f"><?php echo $select_list; ?></select>&nbsp;&nbsp;<input type="submit" value="<?php echo $lang['Look_up_Forum']; ?>" class="mainoption" />&nbsp;</td>
+	</tr>
+</table></form>
+
+<?php
+
+}
+
+page_footer();
+
+?>
\ No newline at end of file
diff --git a/phpBB/admin/admin_search.php b/phpBB/admin/admin_search.php
new file mode 100644
index 0000000000..6075fe0c2d
--- /dev/null
+++ b/phpBB/admin/admin_search.php
@@ -0,0 +1,255 @@
+<?php 
+/***************************************************************************
+ *                              admin_search.php
+ *                            -------------------
+ *   begin                : Saturday, Feb 13, 2001
+ *   copyright            : (C) 2001 The phpBB Group
+ *   email                : support@phpbb.com
+ *
+ *   $Id$
+ *
+ ***************************************************************************/
+
+/***************************************************************************
+ *
+ *   This program is free software; you can redistribute it and/or modify
+ *   it under the terms of the GNU General Public License as published by
+ *   the Free Software Foundation; either version 2 of the License, or
+ *   (at your option) any later version.
+ *
+ ***************************************************************************/
+
+if ( !empty($setmodules) )
+{
+	if ( !$acl->get_acl_admin('general') )
+	{
+		return;
+	}
+
+	$filename = basename(__FILE__);
+	$module['DB']['Search_indexing'] = $filename;
+
+	return;
+}
+
+$phpbb_root_path = '../';
+require($phpbb_root_path . 'extension.inc');
+require('pagestart.' . $phpEx);
+include($phpbb_root_path . 'includes/functions_posting.'.$phpEx);
+
+//
+// Do we have forum admin permissions?
+//
+if ( !$acl->get_acl_admin('general') )
+{
+	message_die(MESSAGE, $lang['No_admin']);
+}
+
+//
+// Start indexing
+//
+if ( isset($HTTP_POST_VARS['start']) )
+{
+	//
+	// Do not change anything below this line.
+	//
+	set_time_limit(0);
+
+	$common_percent = 0.4; // Percentage of posts in which a word has to appear to be marked as common
+
+	print "<html>\n<body>\n";
+
+	//
+	// Try and load stopword and synonym files
+	//
+	// This needs fixing! Shouldn't be hardcoded to English files!
+	$stopword_array = file($phpbb_root_path . "language/lang_english/search_stopwords.txt"); 
+	$synonym_array = file($phpbb_root_path . "language/lang_english/search_synonyms.txt"); 
+
+	//
+	// Fetch a batch of posts_text entries
+	//
+	$sql = "SELECT COUNT(*) as total, MAX(post_id) as max_post_id 
+		FROM ". POSTS_TEXT_TABLE;
+	if ( !($result = $db->sql_query($sql)) ) 
+	{
+		$error = $db->sql_error();
+		die("Couldn't get maximum post ID :: " . $sql . " :: " . $error['message']);
+	}
+
+	$max_post_id = $db->sql_fetchrow($result);
+
+	$totalposts = $max_post_id['total'];
+	$max_post_id = $max_post_id['max_post_id'];
+
+	$postcounter = (!isset($HTTP_GET_VARS['batchstart'])) ? 0 : $HTTP_GET_VARS['batchstart'];
+
+	$batchsize = 200; // Process this many posts per loop
+	$batchcount = 0;
+	for(;$postcounter <= $max_post_id; $postcounter += $batchsize)
+	{
+		$batchstart = $postcounter + 1;
+		$batchend = $postcounter + $batchsize;
+		$batchcount++;
+		
+		$sql = "SELECT * 
+			FROM " . POSTS_TEXT_TABLE . " 
+			WHERE post_id 
+				BETWEEN $batchstart 
+					AND $batchend";
+		if( !($result = $db->sql_query($sql)) )
+		{
+			$error = $db->sql_error();
+			die("Couldn't get post_text :: " . $sql . " :: " . $error['message']);
+		}
+
+		$rowset = $db->sql_fetchrowset($result);
+		$db->sql_freeresult($result);
+
+		$post_rows = count($rowset);
+		
+		if( $post_rows )
+		{
+
+		//	$sql = "LOCK TABLES ".POST_TEXT_TABLE." WRITE";
+		//	$result = $db->sql_query($sql); 
+			print "\n<p>\n<a href='$PHP_SELF?batchstart=$batchstart'>Restart from posting $batchstart</a><br>\n";
+
+			// For every post in the batch:
+			for($post_nr = 0; $post_nr < $post_rows; $post_nr++ )
+			{ 
+				print ".";
+				flush();
+
+				$post_id = $rowset[$post_nr]['post_id']; 
+
+				$matches = array();
+				$matches['text'] = split_words(clean_words("post", $rowset[$post_nr]['post_text'], $stopword_array, $synonym_array));
+				$matches['title'] = split_words(clean_words("post", $rowset[$post_nr]['post_subject'], $stopword_array, $synonym_array));
+
+				while( list($match_type, $match_ary) = @each($matches) )
+				{
+					$title_match = ( $match_type == 'title' ) ? 1 : 0;
+
+					$num_matches = count($match_ary);
+
+					if ( $num_matches < 1 )
+					{
+						// Skip this post if no words where found
+						continue;
+					}
+
+					// For all words in the posting
+					$sql_in = "";
+
+					$sql_insert = '';
+					$sql_select = '';
+
+					$word = array();
+					$word_count = array();
+
+					for($j = 0; $j < $num_matches; $j++)
+					{
+						$this_word = strtolower(trim($match_ary[$j]));
+						if ( $this_word != '' )
+						{
+							$word_count[$this_word] = ( isset($word_count[$this_word]) ) ? $word_count[$this_word] + 1 : 0;
+							$comma = ($sql_insert != '')? ', ': '';
+						
+							$sql_insert .= "$comma('" . $this_word . "')";
+							$sql_select .= "$comma'" . $this_word . "'";
+						}
+					}
+
+					if ( $sql_insert == '' )
+					{
+						die("no words found");
+					}
+						
+					$sql = 'INSERT IGNORE INTO ' . SEARCH_WORD_TABLE . "
+						(word_text)
+						VALUES $sql_insert";
+					if ( !$result = $db->sql_query($sql) )
+					{
+						$error = $db->sql_error();
+						die("Couldn't INSERT words :: " . $sql . " :: " . $error['message']);
+					}
+
+					// Get the word_id's out of the DB (to see if they are already there)
+					$sql = "SELECT word_id, word_text
+						FROM " . SEARCH_WORD_TABLE . " 
+						WHERE word_text IN ($sql_select)
+						GROUP BY word_text";
+					$result = $db->sql_query($sql);
+					if ( !$result )
+					{
+						$error = $db->sql_error();
+						die("Couldn't select words :: " . $sql . " :: " . $error['message']);
+					}
+
+					$sql_insert = array();
+					while( $row = $db->sql_fetchrow($result) )
+					{
+						$sql_insert[] = "($post_id, " . $row['word_id'] . ", $title_match)";
+					}
+
+					$db->sql_freeresult($result);
+
+					$sql = "INSERT INTO " . SEARCH_MATCH_TABLE . "
+						(post_id, word_id, title_match)
+						VALUES " . implode(", ", $sql_insert);
+					$result = $db->sql_query($sql); 
+					if ( !$result )
+					{
+						$error = $db->sql_error();
+						die("Couldn't insert new word match :: " . $sql . " :: " . $error['message']);
+					}
+
+				} // All posts
+			}
+
+		//	$sql = "UNLOCK TABLES";
+		//	$result = $db->sql_query($sql); 
+
+		}
+
+		// Remove common words after the first 2 batches and after every 4th batch after that.
+		if( $batchcount % 4 == 3 )
+		{
+			print "<br>Removing common words (words that appear in more than $common_percent of the posts)<br>\n";
+			flush();
+			print "Removed ". remove_common("global", $common_percent) ." words that where too common.<br>";
+		}
+	}
+
+	echo "<br>Done";
+
+}
+else if ( isset($HTTP_POST_VARS['cancel']) )
+{
+
+
+}
+else
+{
+	page_header($lang['DB']);
+
+?>
+
+<h1><?php echo $lang['Search_indexing']; ?></h1>
+
+<p><?php echo $lang['Search_indexing_explain']; ?></p>
+
+<form method="post" action="<?php echo "admin_search.$phpEx$SID"; ?>"><table cellspacing="1" cellpadding="4" border="0" align="center" bgcolor="#98AAB1">
+	<tr>
+		<td class="cat" height="28" align="center">&nbsp;<input type="submit" name="start" value="<?php echo $lang['Start']; ?>" class="mainoption" />&nbsp;</td>
+	</tr>
+</table></form>
+
+<?php
+
+	page_footer();
+
+}
+
+?>
\ No newline at end of file
-- 
cgit v1.2.1