From ad8c8ed6bf539fabf10c00d34c8a24ee02c3e0ca Mon Sep 17 00:00:00 2001
From: "Paul S. Owen" <psotfx@users.sourceforge.net>
Date: Sun, 2 Sep 2001 13:33:23 +0000
Subject: Split words into separate file, various updates, fix for wrong
 template action name

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

(limited to 'phpBB/admin/admin_words.php')

diff --git a/phpBB/admin/admin_words.php b/phpBB/admin/admin_words.php
new file mode 100644
index 0000000000..0c242bdfc9
--- /dev/null
+++ b/phpBB/admin/admin_words.php
@@ -0,0 +1,204 @@
+<?php
+/***************************************************************************
+ *                              admin_words.php
+ *                            -------------------
+ *   begin                : Thursday, Jul 12, 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($setmodules == 1)
+{
+	$file = basename(__FILE__);
+	$module['General']['Word Censor'] = "$file";
+	return;
+}
+
+//
+// Include required files, get $phpEx and check permissions
+//
+require('pagestart.inc');
+
+if( isset($HTTP_GET_VARS['mode']) || isset($HTTP_POST_VARS['mode']) )
+{
+	$mode = ($HTTP_GET_VARS['mode']) ? $HTTP_GET_VARS['mode'] : $HTTP_POST_VARS['mode'];
+}
+else
+{
+	$mode = "";
+}
+
+if( $mode != "" )
+{
+	if( $mode == "edit" || $mode == "add" )
+	{
+		$template->set_filenames(array(
+			"body" => "admin/words_edit_body.tpl")
+		);
+
+		$s_hidden_fields = '<input type="hidden" name="mode" value="save" />';
+
+		if( $mode == "edit" )
+		{
+			$sql = "SELECT * 
+				FROM " . WORDS_TABLE . " 
+				WHERE word_id = " . $HTTP_GET_VARS['id'];
+			if(!$result = $db->sql_query($sql))
+			{
+				message_die(GENERAL_ERROR, "Could not query words table", "Error", __LINE__, __FILE__, $sql);
+			}
+
+			$word_info = $db->sql_fetchrow($result);
+			$s_hidden_fields .= '<input type="hidden" name="id" value="' . $word_info['word_id'] . '" />';
+		}
+
+		$template->assign_vars(array(
+			"WORD" => $word_info['word'],
+			"REPLACEMENT" => $word_info['replacement'],
+
+			"L_WORDS_TITLE" => $lang['Words_title'],
+			"L_WORDS_TEXT" => $lang['Words_explain'],
+			"L_WORD_CENSOR" => $lang['Word_censor'],
+			"L_WORD" => $lang['Word'],
+			"L_REPLACEMENT" => $lang['Replacement'],
+			"L_SUBMIT" => $lang['Submit'],
+
+			"S_WORDS_ACTION" => append_sid("admin_words.$phpEx"),
+			"S_HIDDEN_FIELDS" => $s_hidden_fields)
+		);
+
+		$template->pparse("body");
+
+		include('page_footer_admin.'.$phpEx);
+	}
+	else if( $mode == "save" )
+	{
+		$word_id = ( isset($HTTP_POST_VARS['id']) ) ? $HTTP_POST_VARS['id'] : 0;
+		$word = ( isset($HTTP_POST_VARS['word']) ) ? trim($HTTP_POST_VARS['word']) : "";
+		$replacement = ( isset($HTTP_POST_VARS['replacement']) ) ? trim($HTTP_POST_VARS['replacement']) : "";
+
+		if($word == ""|| $replacement == "")
+		{
+			message_die(GENERAL_MESSAGE, $lang['Must_enter_word']);
+		}
+
+		if( $word_id )
+		{
+			$sql = "UPDATE " . WORDS_TABLE . " 
+				SET word = '$word', replacement = '$replacement' 
+				WHERE word_id = $word_id";
+			$message_success = $lang['Word_updated'];
+		}
+		else
+		{
+			$sql = "INSERT INTO " . WORDS_TABLE . " (word, replacement) 
+				VALUES ('$word', '$replacement')";
+			$message_success = $lang['Word_added'];
+		}
+
+		if(!$result = $db->sql_query($sql))
+		{
+			message_die(GENERAL_ERROR, "Could not insert data into words table", $lang['Error'], __LINE__, __FILE__, $sql);
+		}
+		else
+		{
+			message_die(GENERAL_MESSAGE, $message_success);
+		}
+	}
+	else if( $mode == "delete" )
+	{
+		if( isset($HTTP_POST_VARS['id']) ||  isset($HTTP_GET_VARS['id']) )
+		{
+			$word_id = ( isset($HTTP_POST_VARS['id']) ) ? $HTTP_POST_VARS['id'] : $HTTP_GET_VARS['id'];
+		}
+		else
+		{
+			$word_id = 0;
+		}
+
+		if( $word_id )
+		{
+			$sql = "DELETE FROM " . WORDS_TABLE . " 
+				WHERE word_id = $word_id";
+
+			if(!$result = $db->sql_query($sql))
+			{
+				message_die(GENERAL_ERROR, "Could not remove data from words table", $lang['Error'], __LINE__, __FILE__, $sql);
+			}
+			else
+			{
+				message_die(GENERAL_MESSAGE, $lang['Word_removed']);
+			}
+		}
+		else
+		{
+			message_die(GENERAL_MESSAGE, $lang['Must_specify_word']);
+		}
+	}
+}
+else
+{
+	$template->set_filenames(array(
+		"body" => "admin/words_list_body.tpl")
+	);
+
+	$sql = "SELECT * 
+		FROM " . WORDS_TABLE . " 
+		ORDER BY word";
+	if( !$result = $db->sql_query($sql) )
+	{
+		message_die(GENERAL_ERROR, "Could not query words table", $lang['Error'], __LINE__, __FILE__, $sql);
+	}
+
+	$word_rows = $db->sql_fetchrowset($result);
+	$word_count = count($word_rows);
+
+	$s_hidden_fields = '<input type="hidden" name="mode" value="' . $mode . '" />';
+
+	$template->assign_vars(array(
+		"L_WORDS_TITLE" => $lang['Words_title'],
+		"L_WORDS_TEXT" => $lang['Words_explain'],
+		"L_WORD" => $lang['Word'],
+		"L_REPLACEMENT" => $lang['Replacement'],
+		"L_EDIT" => $lang['Edit'],
+		"L_DELETE" => $lang['Delete'],
+		"L_WORD_ADD" => $lang['Add_word_censor'],
+		"L_ACTION" => $lang['Action'],
+
+		"S_WORDS_ACTION" => append_sid("admin_words.$phpEx"),
+		"S_HIDDEN_FIELDS" => $s_hidden_fields)
+	);
+
+	for($i = 0; $i < $word_count; $i++)
+	{
+		$word = $word_rows[$i]['word'];
+		$replacement = $word_rows[$i]['replacement'];
+		$word_id = $word_rows[$i]['word_id'];
+
+		$template->assign_block_vars("words", array(
+			"WORD" => $word,
+			"REPLACEMENT" => $replacement,
+			"U_WORD_EDIT" => append_sid("admin_words.$phpEx?mode=edit&id=$word_id"),
+			"U_WORD_DELETE" => append_sid("admin_words.$phpEx?mode=delete&id=$word_id"))
+		);
+	}
+}
+
+$template->pparse("body");
+
+include('page_footer_admin.'.$phpEx);
+
+?>
\ No newline at end of file
-- 
cgit v1.2.1