Reklam alanı

[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.
Kilitli
Kullanıcı avatarı
Dn_35
Kayıtlı Kullanıcı
Mesajlar: 3400
Kayıt: 08.04.2006, 22:02
İletişim:
İletişim Dn_35

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.
Başa dön
DirenJK
Kayıtlı Kullanıcı
Mesajlar: 10
Kayıt: 17.03.2007, 16:38
İletişim:
İletişim DirenJK

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 :(
Başa dön
Kullanıcı avatarı
FataL_RhymE
Kayıtlı Kullanıcı
Mesajlar: 43
Kayıt: 22.12.2006, 16:56
İletişim:
İletişim FataL_RhymE

Mesaj gönderen FataL_RhymE »

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

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.
Başa dön
alone_man
Kayıtlı Kullanıcı
Mesajlar: 36
Kayıt: 21.06.2006, 18:47
İletişim:
İletişim alone_man

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:
Başa dön
Kullanıcı avatarı
pikachu
Kayıtlı Kullanıcı
Mesajlar: 3062
Kayıt: 16.07.2006, 15:32
Konum: ağandon /
İletişim:
İletişim pikachu

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
Başa dön
Kullanıcı avatarı
Nightmare
Kayıtlı Kullanıcı
Mesajlar: 69
Kayıt: 09.04.2007, 16:45
Konum: code-maker
İletişim:
İletişim Nightmare

Mesaj gönderen Nightmare »

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

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?
Başa dön
Kullanıcı avatarı
megaplatform
Kayıtlı Kullanıcı
Mesajlar: 818
Kayıt: 25.08.2006, 19:23
Konum: izmir
İletişim:
İletişim megaplatform

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
Başa dön
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 0 misafir