X-Git-Url: http://git.vanrenterghem.biz/www.vanrenterghem.biz.git/blobdiff_plain/4b1ce0d83844cfd7c55e75a60ccb239882cd62e3..83ab5456767602f2a9860a7db7247f002ec96945:/phpBB2_old/admin/admin_words.php diff --git a/phpBB2_old/admin/admin_words.php b/phpBB2_old/admin/admin_words.php deleted file mode 100644 index 52c1dcd..0000000 --- a/phpBB2_old/admin/admin_words.php +++ /dev/null @@ -1,237 +0,0 @@ -set_filenames(array( - "body" => "admin/words_edit_body.tpl") - ); - - $s_hidden_fields = ''; - - if( $mode == "edit" ) - { - if( $word_id ) - { - $sql = "SELECT * - FROM " . WORDS_TABLE . " - WHERE word_id = $word_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 .= ''; - } - else - { - message_die(GENERAL_MESSAGE, $lang['No_word_selected']); - } - } - - $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['Edit_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']) ) ? intval($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 = '" . str_replace("\'", "''", $word) . "', replacement = '" . str_replace("\'", "''", $replacement) . "' - WHERE word_id = $word_id"; - $message = $lang['Word_updated']; - } - else - { - $sql = "INSERT INTO " . WORDS_TABLE . " (word, replacement) - VALUES ('" . str_replace("\'", "''", $word) . "', '" . str_replace("\'", "''", $replacement) . "')"; - $message = $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); - } - - $message .= "

" . sprintf($lang['Click_return_wordadmin'], "", "") . "

" . sprintf($lang['Click_return_admin_index'], "", ""); - - message_die(GENERAL_MESSAGE, $message); - } - 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']; - $word_id = intval($word_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); - } - - $message = $lang['Word_removed'] . "

" . sprintf($lang['Click_return_wordadmin'], "", "") . "

" . sprintf($lang['Click_return_admin_index'], "", ""); - - message_die(GENERAL_MESSAGE, $message); - } - else - { - message_die(GENERAL_MESSAGE, $lang['No_word_selected']); - } - } -} -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); - - $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_ADD_WORD" => $lang['Add_new_word'], - "L_ACTION" => $lang['Action'], - - "S_WORDS_ACTION" => append_sid("admin_words.$phpEx"), - "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']; - - $row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2']; - $row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2']; - - $template->assign_block_vars("words", array( - "ROW_COLOR" => "#" . $row_color, - "ROW_CLASS" => $row_class, - "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