X-Git-Url: http://git.vanrenterghem.biz/www.vanrenterghem.biz.git/blobdiff_plain/4b1ce0d83844cfd7c55e75a60ccb239882cd62e3..83ab5456767602f2a9860a7db7247f002ec96945:/phpBB2_old/admin/admin_smilies.php diff --git a/phpBB2_old/admin/admin_smilies.php b/phpBB2_old/admin/admin_smilies.php deleted file mode 100644 index 18a6515..0000000 --- a/phpBB2_old/admin/admin_smilies.php +++ /dev/null @@ -1,556 +0,0 @@ -sql_query($sql) ) - { - message_die(GENERAL_ERROR, "Couldn't delete current smilies", "", __LINE__, __FILE__, $sql); - } - } - else - { - $sql = "SELECT code - FROM ". SMILIES_TABLE; - if( !$result = $db->sql_query($sql) ) - { - message_die(GENERAL_ERROR, "Couldn't get current smilies", "", __LINE__, __FILE__, $sql); - } - - $cur_smilies = $db->sql_fetchrowset($result); - - for( $i = 0; $i < count($cur_smilies); $i++ ) - { - $k = $cur_smilies[$i]['code']; - $smiles[$k] = 1; - } - } - - $fcontents = @file($phpbb_root_path . $board_config['smilies_path'] . '/'. $smile_pak); - - if( empty($fcontents) ) - { - message_die(GENERAL_ERROR, "Couldn't read smiley pak file", "", __LINE__, __FILE__, $sql); - } - - for( $i = 0; $i < count($fcontents); $i++ ) - { - $smile_data = explode($delimeter, trim(addslashes($fcontents[$i]))); - - for( $j = 2; $j < count($smile_data); $j++) - { - // - // Replace > and < with the proper html_entities for matching. - // - $smile_data[$j] = str_replace("<", "<", $smile_data[$j]); - $smile_data[$j] = str_replace(">", ">", $smile_data[$j]); - $k = $smile_data[$j]; - - if( $smiles[$k] == 1 ) - { - if( !empty($replace_existing) ) - { - $sql = "UPDATE " . SMILIES_TABLE . " - SET smile_url = '" . str_replace("\'", "''", $smile_data[0]) . "', emoticon = '" . str_replace("\'", "''", $smile_data[1]) . "' - WHERE code = '" . str_replace("\'", "''", $smile_data[$j]) . "'"; - } - else - { - $sql = ''; - } - } - else - { - $sql = "INSERT INTO " . SMILIES_TABLE . " (code, smile_url, emoticon) - VALUES('" . str_replace("\'", "''", $smile_data[$j]) . "', '" . str_replace("\'", "''", $smile_data[0]) . "', '" . str_replace("\'", "''", $smile_data[1]) . "')"; - } - - if( $sql != '' ) - { - $result = $db->sql_query($sql); - if( !$result ) - { - message_die(GENERAL_ERROR, "Couldn't update smilies!", "", __LINE__, __FILE__, $sql); - } - } - } - } - - $message = $lang['smiley_import_success'] . "

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

" . sprintf($lang['Click_return_admin_index'], "", ""); - - message_die(GENERAL_MESSAGE, $message); - - } - else - { - // - // Display the script to get the smile_pak cfg file... - // - $smile_paks_select = ""; - - $hidden_vars = ""; - - $template->set_filenames(array( - "body" => "admin/smile_import_body.tpl") - ); - - $template->assign_vars(array( - "L_SMILEY_TITLE" => $lang['smiley_title'], - "L_SMILEY_EXPLAIN" => $lang['smiley_import_inst'], - "L_SMILEY_IMPORT" => $lang['smiley_import'], - "L_SELECT_LBL" => $lang['choose_smile_pak'], - "L_IMPORT" => $lang['import'], - "L_CONFLICTS" => $lang['smile_conflicts'], - "L_DEL_EXISTING" => $lang['del_existing_smileys'], - "L_REPLACE_EXISTING" => $lang['replace_existing'], - "L_KEEP_EXISTING" => $lang['keep_existing'], - - "S_SMILEY_ACTION" => append_sid("admin_smilies.$phpEx"), - "S_SMILE_SELECT" => $smile_paks_select, - "S_HIDDEN_FIELDS" => $hidden_vars) - ); - - $template->pparse("body"); - } -} -else if( isset($HTTP_POST_VARS['export_pack']) || isset($HTTP_GET_VARS['export_pack']) ) -{ - // - // Export our smiley config as a smiley pak... - // - if ( $HTTP_GET_VARS['export_pack'] == "send" ) - { - $sql = "SELECT * - FROM " . SMILIES_TABLE; - if( !$result = $db->sql_query($sql) ) - { - message_die(GENERAL_ERROR, "Could not get smiley list", "", __LINE__, __FILE__, $sql); - } - - $resultset = $db->sql_fetchrowset($result); - - $smile_pak = ""; - for($i = 0; $i < count($resultset); $i++ ) - { - $smile_pak .= $resultset[$i]['smile_url'] . $delimeter; - $smile_pak .= $resultset[$i]['emoticon'] . $delimeter; - $smile_pak .= $resultset[$i]['code'] . "\n"; - } - - header("Content-Type: text/x-delimtext; name=\"smiles.pak\""); - header("Content-disposition: attachment; filename=smiles.pak"); - - echo $smile_pak; - - exit; - } - - $message = sprintf($lang['export_smiles'], "", "") . "

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

" . sprintf($lang['Click_return_admin_index'], "", ""); - - message_die(GENERAL_MESSAGE, $message); - -} -else if( isset($HTTP_POST_VARS['add']) || isset($HTTP_GET_VARS['add']) ) -{ - // - // Admin has selected to add a smiley. - // - - $template->set_filenames(array( - "body" => "admin/smile_edit_body.tpl") - ); - - $filename_list = ""; - for( $i = 0; $i < count($smiley_images); $i++ ) - { - $filename_list .= ''; - } - - $s_hidden_fields = ''; - - $template->assign_vars(array( - "L_SMILEY_TITLE" => $lang['smiley_title'], - "L_SMILEY_CONFIG" => $lang['smiley_config'], - "L_SMILEY_EXPLAIN" => $lang['smile_desc'], - "L_SMILEY_CODE" => $lang['smiley_code'], - "L_SMILEY_URL" => $lang['smiley_url'], - "L_SMILEY_EMOTION" => $lang['smiley_emot'], - "L_SUBMIT" => $lang['Submit'], - "L_RESET" => $lang['Reset'], - - "SMILEY_IMG" => $phpbb_root_path . $board_config['smilies_path'] . '/' . $smiley_images[0], - - "S_SMILEY_ACTION" => append_sid("admin_smilies.$phpEx"), - "S_HIDDEN_FIELDS" => $s_hidden_fields, - "S_FILENAME_OPTIONS" => $filename_list, - "S_SMILEY_BASEDIR" => $phpbb_root_path . $board_config['smilies_path']) - ); - - $template->pparse("body"); -} -else if ( $mode != "" ) -{ - switch( $mode ) - { - case 'delete': - // - // Admin has selected to delete a smiley. - // - - $smiley_id = ( !empty($HTTP_POST_VARS['id']) ) ? $HTTP_POST_VARS['id'] : $HTTP_GET_VARS['id']; - $smiley_id = intval($smiley_id); - - $sql = "DELETE FROM " . SMILIES_TABLE . " - WHERE smilies_id = " . $smiley_id; - $result = $db->sql_query($sql); - if( !$result ) - { - message_die(GENERAL_ERROR, "Couldn't delete smiley", "", __LINE__, __FILE__, $sql); - } - - $message = $lang['smiley_del_success'] . "

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

" . sprintf($lang['Click_return_admin_index'], "", ""); - - message_die(GENERAL_MESSAGE, $message); - break; - - case 'edit': - // - // Admin has selected to edit a smiley. - // - - $smiley_id = ( !empty($HTTP_POST_VARS['id']) ) ? $HTTP_POST_VARS['id'] : $HTTP_GET_VARS['id']; - $smiley_id = intval($smiley_id); - - $sql = "SELECT * - FROM " . SMILIES_TABLE . " - WHERE smilies_id = " . $smiley_id; - $result = $db->sql_query($sql); - if( !$result ) - { - message_die(GENERAL_ERROR, 'Could not obtain emoticon information', "", __LINE__, __FILE__, $sql); - } - $smile_data = $db->sql_fetchrow($result); - - $filename_list = ""; - for( $i = 0; $i < count($smiley_images); $i++ ) - { - if( $smiley_images[$i] == $smile_data['smile_url'] ) - { - $smiley_selected = "selected=\"selected\""; - $smiley_edit_img = $smiley_images[$i]; - } - else - { - $smiley_selected = ""; - } - - $filename_list .= ''; - } - - $template->set_filenames(array( - "body" => "admin/smile_edit_body.tpl") - ); - - $s_hidden_fields = ''; - - $template->assign_vars(array( - "SMILEY_CODE" => $smile_data['code'], - "SMILEY_EMOTICON" => $smile_data['emoticon'], - - "L_SMILEY_TITLE" => $lang['smiley_title'], - "L_SMILEY_CONFIG" => $lang['smiley_config'], - "L_SMILEY_EXPLAIN" => $lang['smile_desc'], - "L_SMILEY_CODE" => $lang['smiley_code'], - "L_SMILEY_URL" => $lang['smiley_url'], - "L_SMILEY_EMOTION" => $lang['smiley_emot'], - "L_SUBMIT" => $lang['Submit'], - "L_RESET" => $lang['Reset'], - - "SMILEY_IMG" => $phpbb_root_path . $board_config['smilies_path'] . '/' . $smiley_edit_img, - - "S_SMILEY_ACTION" => append_sid("admin_smilies.$phpEx"), - "S_HIDDEN_FIELDS" => $s_hidden_fields, - "S_FILENAME_OPTIONS" => $filename_list, - "S_SMILEY_BASEDIR" => $phpbb_root_path . $board_config['smilies_path']) - ); - - $template->pparse("body"); - break; - - case "save": - // - // Admin has submitted changes while editing a smiley. - // - - // - // Get the submitted data, being careful to ensure that we only - // accept the data we are looking for. - // - $smile_code = ( isset($HTTP_POST_VARS['smile_code']) ) ? trim($HTTP_POST_VARS['smile_code']) : trim($HTTP_GET_VARS['smile_code']); - $smile_url = ( isset($HTTP_POST_VARS['smile_url']) ) ? trim($HTTP_POST_VARS['smile_url']) : trim($HTTP_GET_VARS['smile_url']); - $smile_emotion = ( isset($HTTP_POST_VARS['smile_emotion']) ) ? trim($HTTP_POST_VARS['smile_emotion']) : trim($HTTP_GET_VARS['smile_emotion']); - $smile_id = ( isset($HTTP_POST_VARS['smile_id']) ) ? intval($HTTP_POST_VARS['smile_id']) : intval($HTTP_GET_VARS['smile_id']); - - // If no code was entered complain ... - if ($smile_code == '' || $smile_url == '') - { - message_die(MESSAGE, $lang['Fields_empty']); - } - - // - // Convert < and > to proper htmlentities for parsing. - // - $smile_code = str_replace('<', '<', $smile_code); - $smile_code = str_replace('>', '>', $smile_code); - - // - // Proceed with updating the smiley table. - // - $sql = "UPDATE " . SMILIES_TABLE . " - SET code = '" . str_replace("\'", "''", $smile_code) . "', smile_url = '" . str_replace("\'", "''", $smile_url) . "', emoticon = '" . str_replace("\'", "''", $smile_emotion) . "' - WHERE smilies_id = $smile_id"; - if( !($result = $db->sql_query($sql)) ) - { - message_die(GENERAL_ERROR, "Couldn't update smilies info", "", __LINE__, __FILE__, $sql); - } - - $message = $lang['smiley_edit_success'] . "

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

" . sprintf($lang['Click_return_admin_index'], "", ""); - - message_die(GENERAL_MESSAGE, $message); - break; - - case "savenew": - // - // Admin has submitted changes while adding a new smiley. - // - - // - // Get the submitted data being careful to ensure the the data - // we recieve and process is only the data we are looking for. - // - $smile_code = ( isset($HTTP_POST_VARS['smile_code']) ) ? $HTTP_POST_VARS['smile_code'] : $HTTP_GET_VARS['smile_code']; - $smile_url = ( isset($HTTP_POST_VARS['smile_url']) ) ? $HTTP_POST_VARS['smile_url'] : $HTTP_GET_VARS['smile_url']; - $smile_emotion = ( isset($HTTP_POST_VARS['smile_emotion']) ) ? $HTTP_POST_VARS['smile_emotion'] : $HTTP_GET_VARS['smile_emotion']; - - // If no code was entered complain ... - if ($smile_code == '' || $smile_url == '') - { - message_die(MESSAGE, $lang['Fields_empty']); - } - - // - // Convert < and > to proper htmlentities for parsing. - // - $smile_code = str_replace('<', '<', $smile_code); - $smile_code = str_replace('>', '>', $smile_code); - - // - // Save the data to the smiley table. - // - $sql = "INSERT INTO " . SMILIES_TABLE . " (code, smile_url, emoticon) - VALUES ('" . str_replace("\'", "''", $smile_code) . "', '" . str_replace("\'", "''", $smile_url) . "', '" . str_replace("\'", "''", $smile_emotion) . "')"; - $result = $db->sql_query($sql); - if( !$result ) - { - message_die(GENERAL_ERROR, "Couldn't insert new smiley", "", __LINE__, __FILE__, $sql); - } - - $message = $lang['smiley_add_success'] . "

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

" . sprintf($lang['Click_return_admin_index'], "", ""); - - message_die(GENERAL_MESSAGE, $message); - break; - } -} -else -{ - - // - // This is the main display of the page before the admin has selected - // any options. - // - $sql = "SELECT * - FROM " . SMILIES_TABLE; - $result = $db->sql_query($sql); - if( !$result ) - { - message_die(GENERAL_ERROR, "Couldn't obtain smileys from database", "", __LINE__, __FILE__, $sql); - } - - $smilies = $db->sql_fetchrowset($result); - - $template->set_filenames(array( - "body" => "admin/smile_list_body.tpl") - ); - - $template->assign_vars(array( - "L_ACTION" => $lang['Action'], - "L_SMILEY_TITLE" => $lang['smiley_title'], - "L_SMILEY_TEXT" => $lang['smile_desc'], - "L_DELETE" => $lang['Delete'], - "L_EDIT" => $lang['Edit'], - "L_SMILEY_ADD" => $lang['smile_add'], - "L_CODE" => $lang['Code'], - "L_EMOT" => $lang['Emotion'], - "L_SMILE" => $lang['Smile'], - "L_IMPORT_PACK" => $lang['import_smile_pack'], - "L_EXPORT_PACK" => $lang['export_smile_pack'], - - "S_HIDDEN_FIELDS" => $s_hidden_fields, - "S_SMILEY_ACTION" => append_sid("admin_smilies.$phpEx")) - ); - - // - // Loop throuh the rows of smilies setting block vars for the template. - // - for($i = 0; $i < count($smilies); $i++) - { - // - // Replace htmlentites for < and > with actual character. - // - $smilies[$i]['code'] = str_replace('<', '<', $smilies[$i]['code']); - $smilies[$i]['code'] = str_replace('>', '>', $smilies[$i]['code']); - - $row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2']; - $row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2']; - - $template->assign_block_vars("smiles", array( - "ROW_COLOR" => "#" . $row_color, - "ROW_CLASS" => $row_class, - - "SMILEY_IMG" => $phpbb_root_path . $board_config['smilies_path'] . '/' . $smilies[$i]['smile_url'], - "CODE" => $smilies[$i]['code'], - "EMOT" => $smilies[$i]['emoticon'], - - "U_SMILEY_EDIT" => append_sid("admin_smilies.$phpEx?mode=edit&id=" . $smilies[$i]['smilies_id']), - "U_SMILEY_DELETE" => append_sid("admin_smilies.$phpEx?mode=delete&id=" . $smilies[$i]['smilies_id'])) - ); - } - - // - // Spit out the page. - // - $template->pparse("body"); -} - -// -// Page Footer -// -include('./page_footer_admin.'.$phpEx); - -?>