[MOD] ACP Site Announcement Centre/ YKP Duyuru merkezi

[url=http://www.phpbbturkey.com/mods.html:34cnv4ga]phpBB 2.0.x MOD Veritabanımızda[/url:34cnv4ga] yayınlanan ve tarafınızca eklenen tüm yeni phpBB 2.0.x sürümleri için MODların duyuruları buradan yapılmaktadır. MODlar hakkında ihtiyacınız olan desteği lütfen [b:34cnv4ga]2.0.x MOD Destek[/b:34cnv4ga] forumuna başlık açarak sorunuz.
Kullanıcı avatarı
Dn_35
Kayıtlı Kullanıcı
Mesajlar: 3400
Kayıt: 08.04.2006, 22:02
İletişim:

Mesaj gönderen Dn_35 »

mod kurulum makalesininde anlatılıyor sql sorgusu nasıl yapılıyor.
Site Kuralları | Mod Kurulum Makalesi | MODX Formatlı Modların Kurulumu

Lütfen özel mesaj ile yardım istemeyiniz, kurallarımız gereği özel mesajlara cevap vermiyoruz.
DirenJK
Kayıtlı Kullanıcı
Mesajlar: 10
Kayıt: 17.03.2007, 16:38
İletişim:

Mesaj gönderen DirenJK »

Kod: Tümünü seç

phpBB : Critical Error 

Could not query announcement information in admin_announcement_centre

DEBUG MODE

SQL Error : 1146 Table 'unibjk_mersin.unibjk_mersin' doesn't exist

SELECT * FROM unibjk_mersin

Line : 38
File : admin_announcement_centre.php 
Bu Seferde Hata bu Çıkamadım işin içinden :(
Kullanıcı avatarı
FataL_RhymE
Kayıtlı Kullanıcı
Mesajlar: 43
Kayıt: 22.12.2006, 16:56
İletişim:

Mesaj gönderen FataL_RhymE »

Duyuruyu kayan yazı şeklinde verebiliyo muyuz bu modda ?
alone_man
Kayıtlı Kullanıcı
Mesajlar: 36
Kayıt: 21.06.2006, 18:47
İletişim:

Mesaj gönderen alone_man »

--------SORUN ÇÖZÜLDÜ------------- çözüm için bir sonraki mesaja bakın

arkadaşlar modu sorunsuz kurdum ancak admin panelinden bi değişiklik yapamıyorum. duyuruda değişiklik yapıp gönder dediğimde "SECURITY ALERT" alıyorum. Debug modunu aktif ettim. önerilen çözümü uygulayamıyorum. lütfen yardım edin. verilen çözüm budur:

Kod: Tümünü seç

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Script-Filename: /\forum\phpbb2\admin\admin_announcement_centre.php
----------------

Request-Method: POST

Matching rule: cp 
In variable:   announcement_text_draft

Possible solution:
------------------

#
#-----[ OPEN ]------------------------------------------
#
/\forum\phpbb2\admin\admin_announcement_centre.php

#
#-----[ FIND ]------------------------------------------
#
include($phpbb_root_path . 'common.'.$phpEx);

#
#-----[ BEFORE, ADD ]------------------------------------------
#
define('CT_SECLEVEL', 'MEDIUM');
$ct_ignorepvar = array('announcement_text_draft');

#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM
ancak ben

Kod: Tümünü seç

admin_announcement_centre.php 
sayfasında

Kod: Tümünü seç

include($phpbb_root_path . 'common.'.$phpEx);
kodunu bulamıyorum.

aşağıdada

Kod: Tümünü seç

admin_announcement_centre.php 
sayfasını veriyorum. yardım edin lütfen.

Kod: Tümünü seç

<?php
/***************************************************************************
 *                              admin_announcement_centre.php
 *                            -------------------
 *   begin                : Sunday, Feb 25, 2007
 *   copyright         : (C) lefty74
 *   email                : lefty@lefty74.com
 *
 *  
 *
 *
 ***************************************************************************/

define('IN_PHPBB', 1);

if( !empty($setmodules) )
{
	$file = basename(__FILE__);
	$module['General']['Announcements'] = $file;
	return;
}

//
// Let's set the root dir for phpBB
//
$phpbb_root_path = "./../";
require($phpbb_root_path . 'extension.inc');
require('./pagestart.' . $phpEx);
include($phpbb_root_path . 'includes/bbcode.'.$phpEx);

//
// Pull all announcement data
//
$sql = "SELECT *
	FROM " . ANNOUNCEMENTS_LEFTY74_TABLE;
if(!$result = $db->sql_query($sql))
{
	message_die(CRITICAL_ERROR, "Could not query announcement information in admin_announcement_centre", "", __LINE__, __FILE__, $sql);
}
else
{
	while( $row = $db->sql_fetchrow($result) )
	{
		$announcement_desc = $row['announcement_desc'];
		$announcement_value = $row['announcement_value'];
		$default_announcement[$announcement_desc] = isset($HTTP_POST_VARS['submit']) ? str_replace("'", "\'", $announcement_value) : $announcement_value;
		
		$new[$announcement_desc] = ( isset($HTTP_POST_VARS[$announcement_desc]) ) ? $HTTP_POST_VARS[$announcement_desc] : $default_announcement[$announcement_desc];

		if( isset($HTTP_POST_VARS['submit']) )
		{
				$sql = "UPDATE " . ANNOUNCEMENTS_LEFTY74_TABLE . " SET
				announcement_value = '" . str_replace("\'", "''", $new[$announcement_desc]) . "'
				WHERE announcement_desc = '$announcement_desc'";
			if( !$db->sql_query($sql) )
			{
				message_die(GENERAL_ERROR, "Failed to update general configuration for $announcement_desc", "", __LINE__, __FILE__, $sql);
			}
					}

	}
	if( isset($HTTP_POST_VARS['preview']) )
	{
			$sql = "UPDATE " . ANNOUNCEMENTS_LEFTY74_TABLE . " SET
				announcement_value = '" . str_replace("\'", "''", $new['announcement_text_draft']) . "'
				WHERE announcement_desc = 'announcement_text_draft'";
								
			if( !$db->sql_query($sql) )
			{
				message_die(GENERAL_ERROR, "Failed to update general configuration for announcement_text_draft", "", __LINE__, __FILE__, $sql);
			}
	redirect(append_sid("admin/admin_announcement_centre.$phpEx"));		
	}
	
	if( isset($HTTP_POST_VARS['submit']) )
	{
		$message = $lang['announcement_updated'] . "<br /><br />" . sprintf($lang['Click_return_announcement'], "<a href=\"" . append_sid("admin_announcement_centre.$phpEx") . "\">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>");
		message_die(GENERAL_MESSAGE, $message);
	}
}
$announcement_status_yes = ( $new['announcement_status'] == ANNOUNCEMENTS_LEFTY74_SHOW_YES ) ? "checked=\"checked\"" : "";
$announcement_status_no = ( $new['announcement_status'] == ANNOUNCEMENTS_LEFTY74_SHOW_NO ) ? "checked=\"checked\"" : "";

$show_announcement_all = ( $new['announcement_access'] == ANNOUNCEMENTS_LEFTY74_SHOW_ALL ) ? "checked=\"checked\"" : "";
$show_announcement_reg = ( $new['announcement_access'] == ANNOUNCEMENTS_LEFTY74_SHOW_REG ) ? "checked=\"checked\"" : "";
$show_announcement_mod = ( $new['announcement_access'] == ANNOUNCEMENTS_LEFTY74_SHOW_MOD ) ? "checked=\"checked\"" : "";
$show_announcement_adm = ( $new['announcement_access'] == ANNOUNCEMENTS_LEFTY74_SHOW_ADM ) ? "checked=\"checked\"" : "";

$announcement_guestannouncement_status_yes = ( $new['announcement_guest_status'] == ANNOUNCEMENTS_LEFTY74_GUEST_YES ) ? "checked=\"checked\"" : "";
$announcement_guestannouncement_status_no = ( $new['announcement_guest_status'] == ANNOUNCEMENTS_LEFTY74_GUEST_NO ) ? "checked=\"checked\"" : "";

$announcement_forum_topic_latest = ( $new['announcement_forum_topic_first_latest'] == ANNOUNCEMENTS_LEFTY74_FORUM_TOPIC_LATEST ) ? "checked=\"checked\"" : "";
$announcement_forum_topic_first = ( $new['announcement_forum_topic_first_latest'] == ANNOUNCEMENTS_LEFTY74_FORUM_TOPIC_FIRST ) ? "checked=\"checked\"" : "";


//
// Send smilies to template
//
	$mode = 'inline';
	$inline_columns = 4;
	$inline_rows = 5;
	$window_columns = 8;


	$sql = "SELECT emoticon, code, smile_url   
		FROM " . SMILIES_TABLE . " 
		ORDER BY smilies_id";
	if ($result = $db->sql_query($sql))
	{
		$num_smilies = 0;
		$rowset = array();
		while ($row = $db->sql_fetchrow($result))
		{
			if (empty($rowset[$row['smile_url']]))
			{
				$rowset[$row['smile_url']]['code'] = str_replace("'", "\\'", str_replace('\\', '\\\\', $row['code']));
				$rowset[$row['smile_url']]['emoticon'] = $row['emoticon'];
				$num_smilies++;
			}
		}

		if ($num_smilies)
		{
			$smilies_count = ($mode == 'inline') ? min(19, $num_smilies) : $num_smilies;
			$smilies_split_row = ($mode == 'inline') ? $inline_columns - 1 : $window_columns - 1;

			$s_colspan = 0;
			$row = 0;
			$col = 0;

			while (list($smile_url, $data) = @each($rowset))
			{
				if (!$col)
				{
					$template->assign_block_vars('smilies_row', array());
				}

				$template->assign_block_vars('smilies_row.smilies_col', array(
					'SMILEY_CODE' => $data['code'],
					'SMILEY_IMG' => '../' . $board_config['smilies_path'] . '/' . $smile_url,
					'SMILEY_DESC' => $data['emoticon'])
				);

				$s_colspan = max($s_colspan, $col + 1);

				if ($col == $smilies_split_row)
				{
					if ($mode == 'inline' && $row == $inline_rows - 1)
					{
						break;
					}
					$col = 0;
					$row++;
				}
				else
				{
					$col++;
				}
			}

			if ($mode == 'inline' && $num_smilies > $inline_rows * $inline_columns)
			{
				$template->assign_block_vars('switch_smilies_extra', array());

				$template->assign_vars(array(
					'L_MORE_SMILIES' => $lang['More_emoticons'], 
					'U_MORE_SMILIES_ANNOUNCEMENT_TEXT' => append_sid("../posting.$phpEx?mode=smilies_announcement_text"))


				);
			}

			$template->assign_vars(array(
				'L_EMOTICONS' => $lang['Emoticons'], 
				'L_CLOSE_WINDOW' => $lang['Close_window'], 
				'S_SMILIES_COLSPAN' => $s_colspan)
			);
		}
	}
$template->set_filenames(array(
	"body" => "admin/announcement_centre_config_body.tpl")
);

//
// Escape any quotes in the site description for proper display in the text
// box on the Announcement Box page 
//
$new['announcement_text'] = str_replace('"', '"', $new['announcement_text']); 
$new['announcement_guest_text'] = str_replace('"', '"', $new['announcement_guest_text']); 
$new['announcement_text_draft'] = str_replace('"', '"', $new['announcement_text_draft']); 


$preview_announcement = $new['announcement_text_draft'];
$preview_announcement_uid  	= make_bbcode_uid();
$preview_announcement	= bbencode_first_pass( $preview_announcement, $preview_announcement_uid );
$preview_announcement	= bbencode_second_pass ( $preview_announcement, $preview_announcement_uid );
$preview_announcement	= smilies_pass($preview_announcement, './../');
$preview_announcement	= str_replace("\n", "\n<br />\n", $preview_announcement);

$template->assign_vars(array(
	"S_ANNOUNCEMENT_ACTION" => append_sid("admin_announcement_centre.$phpEx"),
	"L_BBCODE_B_HELP" => $lang['bbcode_b_help'], 
	"L_BBCODE_I_HELP" => $lang['bbcode_i_help'], 
	"L_BBCODE_U_HELP" => $lang['bbcode_u_help'], 
	"L_BBCODE_Q_HELP" => $lang['bbcode_q_help'], 
	"L_BBCODE_C_HELP" => $lang['bbcode_c_help'], 
	"L_BBCODE_L_HELP" => $lang['bbcode_l_help'], 
	"L_BBCODE_O_HELP" => $lang['bbcode_o_help'], 
	"L_BBCODE_P_HELP" => $lang['bbcode_p_help'], 
	"L_BBCODE_W_HELP" => $lang['bbcode_w_help'], 
	"L_BBCODE_A_HELP" => $lang['bbcode_a_help'], 
	"L_BBCODE_S_HELP" => $lang['bbcode_s_help'], 
	"L_BBCODE_F_HELP" => $lang['bbcode_f_help'], 
	"L_EMPTY_MESSAGE" => $lang['Empty_message'],
	"L_FONT_COLOR" => $lang['Font_color'], 
	"L_COLOR_DEFAULT" => $lang['color_default'], 
	"L_COLOR_DARK_RED" => $lang['color_dark_red'], 
	"L_COLOR_RED" => $lang['color_red'], 
	"L_COLOR_ORANGE" => $lang['color_orange'], 
	"L_COLOR_BROWN" => $lang['color_brown'], 
	"L_COLOR_YELLOW" => $lang['color_yellow'], 
	"L_COLOR_GREEN" => $lang['color_green'], 
	"L_COLOR_OLIVE" => $lang['color_olive'], 
	"L_COLOR_CYAN" => $lang['color_cyan'], 
	"L_COLOR_BLUE" => $lang['color_blue'], 
	"L_COLOR_DARK_BLUE" => $lang['color_dark_blue'], 
	"L_COLOR_INDIGO" => $lang['color_indigo'], 
	"L_COLOR_VIOLET" => $lang['color_violet'], 
	"L_COLOR_WHITE" => $lang['color_white'], 
	"L_COLOR_BLACK" => $lang['color_black'], 
	"L_FONT_SIZE" => $lang['Font_size'], 
	"L_FONT_TINY" => $lang['font_tiny'], 
	"L_FONT_SMALL" => $lang['font_small'], 
	"L_FONT_NORMAL" => $lang['font_normal'], 
	"L_FONT_LARGE" => $lang['font_large'], 
	"L_FONT_HUGE" => $lang['font_huge'], 
	"L_BBCODE_CLOSE_TAGS" => $lang['Close_Tags'], 
	"L_STYLES_TIP" => $lang['Styles_tip'], 
    "L_ANNOUNCEMENT_MAIN_TITLE" => $lang['Announcement_main_title'],	
    "L_ANNOUNCEMENT_MAIN_TITLE_EXPLAIN" => $lang['Announcement_main_title_explain'],	
	"L_ANNOUNCEMENT_BLOCK_TITLE" => $lang['Announcement_block_title'],	
    "L_ANNOUNCEMENT_DRAFT_TEXT" => $lang['Announcement_draft_text'],
	"L_ANNOUNCEMENT_DRAFT_TEXT_EXPLAIN" => $lang['Announcement_draft_text_explain'],	
	"L_SHOW_ANNOUNCEMENT_TEXT" => $lang['Show_announcement_text'],
	"L_ANNOUNCEMENT_TEXT" => $lang['Announcement_text'],	
	"L_ANNOUNCEMENT_TEXT_EXPLAIN" => $lang['Announcement_text_explain'],	
	"L_FORUM_ID" => $lang['Forum_ID'],	
	"L_TOPIC_ID" => $lang['Topic_ID'],	
	"L_ANNOUNCEMENT_FORUM_TOPIC_LATEST" => $lang['announcement_forum_topic_latest'],	
	"L_ANNOUNCEMENT_FORUM_TOPIC_FIRST" => $lang['announcement_forum_topic_first'],	
    "L_ANNOUNCEMENT_GUEST_TEXT" => $lang['Announcement_guest_text'],
	"L_SELECT_ALL" => $lang['Select_all'],
	"L_COPY_TO_ANNOUNCEMENT" => $lang['Copy_to_Announcement'],
	"L_COPY_TO_GUEST_ANNOUNCEMENT" => $lang['Copy_to_Guest_Announcement'],
	"L_SUBMIT" => $lang['Submit'],
	"L_PREVIEW" => $lang['Preview'],
	"L_RESET" => $lang['Reset'], 
	"L_YES" => $lang['Yes'],
	"L_NO" => $lang['No'],
	"ANNOUNCEMENT_VERSION" => sprintf($announcement_centre_config['announcement_mod_version']),
	"L_SHOW_ANNOUNCEMENT_ALL" => $lang['Show_announcement_all'],
	"L_SHOW_ANNOUNCEMENT_REG" => $lang['Show_announcement_reg'],
	"L_SHOW_ANNOUNCEMENT_MOD" => $lang['Show_announcement_mod'],
	"L_SHOW_ANNOUNCEMENT_ADM" => $lang['Show_announcement_adm'],
	"L_SHOW_ANNOUNCEMENT_WHO" => $lang['Show_announcement_who'],
	"L_ANNOUNCEMENT_GUESTS_ONLY" => $lang['Announcement_guests_only'],
	"L_ANNOUNCEMENT_GUESTS_ONLY_EXPLAIN" => $lang['Announcement_guests_only_explain'],
 	"ANNOUNCEMENT_FORUM_ID" => $new['announcement_forum_id'],
 	"ANNOUNCEMENT_TOPIC_ID" => $new['announcement_topic_id'],
	"ANNOUNCEMENT_TEXT" => $new['announcement_text'],
	"ANNOUNCEMENT_GUEST_TEXT" => $new['announcement_guest_text'],
	"ANNOUNCEMENT_TEXT_DRAFT" => $new['announcement_text_draft'],
	"ANNOUNCEMENT_PREVIEW" => $preview_announcement,
	"S_ANNOUNCEMENT_STATUS_YES" => $announcement_status_yes,
	"SHOW_ANNOUNCEMENT_YES" => ANNOUNCEMENTS_LEFTY74_SHOW_YES,
	"S_ANNOUNCEMENT_STATUS_NO" => $announcement_status_no,
	"SHOW_ANNOUNCEMENT_NO" => ANNOUNCEMENTS_LEFTY74_SHOW_NO,
	"S_ANNOUNCEMENT_FORUM_TOPIC_LATEST" => $announcement_forum_topic_latest,
	"ANNOUNCEMENT_FORUM_TOPIC_LATEST" => ANNOUNCEMENTS_LEFTY74_FORUM_TOPIC_LATEST,
	"S_ANNOUNCEMENT_FORUM_TOPIC_FIRST" => $announcement_forum_topic_first,
	"ANNOUNCEMENT_FORUM_TOPIC_FIRST" => ANNOUNCEMENTS_LEFTY74_FORUM_TOPIC_FIRST,

	"ANNOUNCEMENT_GUEST_SEPARATE_STATUS_YES" => ANNOUNCEMENTS_LEFTY74_GUEST_YES,
	"S_ANNOUNCEMENT_GUEST_SEPARATE_STATUS_YES" => $announcement_guestannouncement_status_yes,
	"ANNOUNCEMENT_GUEST_SEPARATE_STATUS_NO" => ANNOUNCEMENTS_LEFTY74_GUEST_NO,
	"S_ANNOUNCEMENT_GUEST_SEPARATE_STATUS_NO" => $announcement_guestannouncement_status_no,
	"SHOW_ANNOUNCEMENT_ALL" => ANNOUNCEMENTS_LEFTY74_SHOW_ALL,
	"S_SHOW_ANNOUNCEMENT_ALL_CHECKED" => $show_announcement_all,
	"SHOW_ANNOUNCEMENT_REG" => ANNOUNCEMENTS_LEFTY74_SHOW_REG,
	"S_SHOW_ANNOUNCEMENT_REG_CHECKED" => $show_announcement_reg,
	"SHOW_ANNOUNCEMENT_MOD" => ANNOUNCEMENTS_LEFTY74_SHOW_MOD,
	"S_SHOW_ANNOUNCEMENT_MOD_CHECKED" => $show_announcement_mod,
	"SHOW_ANNOUNCEMENT_ADM" => ANNOUNCEMENTS_LEFTY74_SHOW_ADM,
	"S_SHOW_ANNOUNCEMENT_ADM_CHECKED" => $show_announcement_adm,
	
	
));

$template->pparse("body");

include('./page_footer_admin.'.$phpEx);

?>
En son alone_man tarafından 18.04.2007, 12:59 tarihinde düzenlendi, toplamda 1 kere düzenlendi.
alone_man
Kayıtlı Kullanıcı
Mesajlar: 36
Kayıt: 21.06.2006, 18:47
İletişim:

Mesaj gönderen alone_man »

tamam arkadaşlar sorunu hallettim.
çözüm için verilen bu kodu

Kod: Tümünü seç

define('CT_SECLEVEL', 'MEDIUM');
$ct_ignorepvar = array('announcement_text_draft');
şu şekilde eklemeliyiz.

Kod: Tümünü seç

find

//
// Let's set the root dir for phpBB
//

after add

define('CT_SECLEVEL', 'MEDIUM');
$ct_ignorepvar = array('announcement_text_draft');
yanlış yere ekliyormuşum :lol:
Kullanıcı avatarı
pikachu
Kayıtlı Kullanıcı
Mesajlar: 3062
Kayıt: 16.07.2006, 15:32
Konum: ağandon /
İletişim:

Mesaj gönderen pikachu »

modun 1.2.0 versiyonu çıkmış. linkten bakıp indirebilirsiniz. sanırsam bi hata düzeltilmiş.

http://www.phpbbhacks.com/download/7645
Kullanıcı avatarı
Nightmare
Kayıtlı Kullanıcı
Mesajlar: 69
Kayıt: 09.04.2007, 16:45
Konum: code-maker
İletişim:

Mesaj gönderen Nightmare »

kolay kurulabilen iyi bir mod teşekkurler
ENGEL
KarGoManiA
Kayıtlı Kullanıcı
Mesajlar: 80
Kayıt: 25.10.2006, 03:37
İletişim:

Re: [MOD] ACP Site Announcement Centre/ YKP Duyuru merkezi

Mesaj gönderen KarGoManiA »

Bu sadece index.php'de görünüyor fakat ben yerde görünmesini istitorum..

overall headera koydum tpl kodlarını çalışmadı...Ne yapmak lazım?
Kullanıcı avatarı
megaplatform
Kayıtlı Kullanıcı
Mesajlar: 818
Kayıt: 25.08.2006, 19:23
Konum: izmir
İletişim:

Re: [MOD] ACP Site Announcement Centre/ YKP Duyuru merkezi

Mesaj gönderen megaplatform »

ovrell header da çalışması için index.php de yapılan eklemeleri inculdes klasörü içindeki page_header a uyarlaman gerekir
Kilitli

“2.0.x MOD Duyuruları” sayfasına dön

Kimler çevrimiçi

Bu forumu görüntüleyen kullanıcılar: Hiç bir kayıtlı kullanıcı yok ve 2 misafir