Reklam alanı

Default Sig Modu Sorun

phpBB 2.0.x kurulum ve çalıştırılmasında meydana gelen sorun ve problemler için buradan yardım alabilirsiniz.
Kilitli
hunter_turk
Kayıtlı Kullanıcı
Mesajlar: 24
Kayıt: 14.04.2008, 18:51

Default Sig Modu Sorun

Mesaj gönderen hunter_turk »

Merhaba arkadaşlar siteme default sig modu kurdum ama sql sorgusunda sql hata veriyor sorgulanmıyor.
Sorgunun ilk sırasında (table_prefix) is table prefix of your board diye bir yazı var ne demek onunlamı alakalı acaba yardımcı olursanız sevinirim sql kodu aşağıdadır.

Kod: Tümünü seç

OBS.: (table_prefix) is table prefix of your board

INSERT INTO (table_prefix)config values('allow_default','1');
CREATE TABLE (table_prefix)default (sig_name varchar(255),sig_value text);
INSERT INTO (table_prefix)default values('default_sig','Default Signature Installed');

İşte Mod

Kod: Tümünü seç

#################################################################
## Title: Default Signature MOD
## Version: 1.0.0
## Author: Yuri Menzl Celaschi <yurimenzl@yahoo.com.br> - http://www.rpgwitchschools.net/dkstudios/yurimenzl
## Description: This MOD will allow admin set a default signature to user who don't     ##              have one.
##
## Installation Level: 	Easy
## Installation Time: 	10 Minutes
##
## Files To Edit:  6
##		   admin/admin_board.php
##		   includes/constants.php
##		   language/lang_*/lang_admin.php
##		   templates/subSilver/admin/board_config_body.tpl
##		   index.php
##		   login.php
##
## Included Files: 1
##		   root/ds_install.php
##
#################################################################
##
## Author Note:
##
##	Copyright © Yuri Menzl Celaschi, 2007
##
##	For any concerns please contact me at http://www.rpgwitchschools.net/phpBB2
##	Thx to Sephiroth from phpBB Brasil Support for the help and tips.
##	You should unintall last version, then install this new version.
##
#################################################################
##
## Version History
##
## 01/17/2007
##		- Released 
##
#################################################################
##
## If you don't wan't run default_sig_install.php, open install_sql.txt
## and add comands in phpMyAdmin.
##
#################################################################

#
#-----[ RUN ]----------------------------------------------------
#
ds_install.php

#
#------[ OPEN ]--------------------------------------------------
#
admin_board.php

#
#-----[ FIND ]---------------------------------------------------
#
				message_die(GENERAL_ERROR, "Failed to update general configuration for $config_name", "", __LINE__, __FILE__, $sql);
			}
		}
	}

#
#------[ AFTER ADD ]----------------------------------------------
#
$sql = "SELECT *
	FROM " . DEFAULT_TABLE;
if(!$result = $db->sql_query($sql))
{
	message_die(CRITICAL_ERROR, "Could not query config information in admin_board", "", __LINE__, __FILE__, $sql);
}
else
{
	while( $row = $db->sql_fetchrow($result) )
	{
		$sig_name = $row['sig_name'];
		$sig_value = $row['sig_value'];
		$sig_default[$sig_name] = isset($HTTP_POST_VARS['submit']) ? str_replace("'", "\'", $sig_value) : $sig_value;
		
		$new2[$sig_name] = ( isset($HTTP_POST_VARS[$sig_name]) ) ? $HTTP_POST_VARS[$sig_name] : $sig_default[$sig_name];

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

#
#-----[ FIND ]---------------------------------------------------
#
$sig_no = ( !$new['allow_sig'] ) ? "checked=\"checked\"" : "";

#
#-----[ AFTER ADD ]----------------------------------------------
#
$default_sig_yes = ( $new['allow_default'] ) ? "checked=\"checked\"" : "";
$default_sig_no = ( !$new['allow_default'] ) ? "checked=\"checked\"" : "";

#
#-----[ FIND ]---------------------------------------------------
#
"L_ALLOW_SIG" => $lang['Allow_sig'],

#
#-----[ AFTER ADD ]----------------------------------------------
#
"L_ALLOW_SIG_DEFAULT" => $lang['Allow_default_sig'],
"L_DEFAULT_SIG" => $lang['Default_sig'],
"L_DEFAULT_SIG_EXPLAIN" => $lang['Default_sig_explain'],

#
#-----[ FIND ]---------------------------------------------------
#
"SIG_NO" => $sig_no,

#
#-----[ AFTER ADD ]----------------------------------------------
#
"DEFAULT_SIG_YES" => $default_sig_yes,
"DEFAULT_SIG_NO" => $default_sig_no,
"DEFAULT_SIG" => $new2['default_sig'],

#
#-----[ OPEN ]---------------------------------------------------
#
includes/constants.php

#
#-----[ FIND ]---------------------------------------------------
#
define('CONFIG_TABLE', $table_prefix.'config');

#
#-----[ AFTER ADD ]----------------------------------------------
#
define('DEFAULT_TABLE', $table_prefix.'default');

#
#-----[ OPEN ]---------------------------------------------------
#
includes/usercp_register.php

#
#-----[ FIND ]---------------------------------------------------
#
	if ( $signature != '' )
	{
		if ( strlen($signature) > $board_config['max_sig_chars'] )
		{
			$error = TRUE;
			$error_msg .= ( ( isset($error_msg) ) ? '<br />' : '' ) . $lang['Signature_too_long'];
		}

		if ( !isset($signature_bbcode_uid) || $signature_bbcode_uid == '' )
		{
			$signature_bbcode_uid = ( $allowbbcode ) ? make_bbcode_uid() : '';
		}
		$signature = prepare_message($signature, $allowhtml, $allowbbcode, $allowsmilies, $signature_bbcode_uid);
	}

#
#-----[ REPLACE WITH ]-------------------------------------------
#
if ( $signature != '' )
	{
		$allow_default_signature = 0;
		if ( strlen($signature) > $board_config['max_sig_chars'] )
		{
			$error = TRUE;
			$error_msg .= ( ( isset($error_msg) ) ? '<br />' : '' ) . $lang['Signature_too_long'];
		}

		if ( !isset($signature_bbcode_uid) || $signature_bbcode_uid == '' )
		{
			$signature_bbcode_uid = ( $allowbbcode ) ? make_bbcode_uid() : '';
		}
		$signature = prepare_message($signature, $allowhtml, $allowbbcode, $allowsmilies, $signature_bbcode_uid);
	} else
	{
		$signature = $default_sig['default_sig'];
		$allow_default_signature = 1;
		if ( !isset($signature_bbcode_uid) || $signature_bbcode_uid == '' )
		{
			$signature_bbcode_uid = ( $allowbbcode ) ? make_bbcode_uid() : '';
		}
		$signature = prepare_message($signature, $allowhtml, $allowbbcode, $allowsmilies, $signature_bbcode_uid);
	}

#
#-----[ FIND ]---------------------------------------------------
#
user_viewemail = $viewemail,

#
#-----[ IN-LINE AFTER ADD ]--------------------------------------
#
allow_default = $allow_default_signature, 

#
#-----[ FIND ]---------------------------------------------------
#
user_viewemail,

#
#-----[ IN-LINE AFTER ADD ]--------------------------------------
#
allow_default, 

#
#-----[ FIND ]---------------------------------------------------
#
$viewemail,

#
#-----[ IN-LINE AFTER ADD ]--------------------------------------
#
$allow_default_signature,

#
#-----[ OPEN ]---------------------------------------------------
#
language/lang_*/lang_admin.php

#
#-----[ FIND ]---------------------------------------------------
#
$lang['Allow_sig'] = 'Allow Signatures';

#
#-----[ AFTER ADD ]----------------------------------------------
#
$lang['Allow_default_sig'] = 'Allow Default Signature';
$lang['Default_sig'] = 'Default Signature';
$lang['Default_sig_explain'] = 'Default signature to users who don\'t have signature. bbCode Allowed.

#
#-----[ OPEN ]---------------------------------------------------
#
templates/*/admin/board_config_body.tpl

#
#-----[ FIND ]---------------------------------------------------
#
<tr>
		<td class="row1">{L_ALLOW_SIG}</td>
		<td class="row2"><input type="radio" name="allow_sig" value="1" {SIG_YES} /> {L_YES}&nbsp;&nbsp;<input type="radio" name="allow_sig" value="0" {SIG_NO} /> {L_NO}</td>
	</tr>

#
#-----[ AFTER ADD ]----------------------------------------------
#
<tr>
		<td class="row1">{L_ALLOW_SIG_DEFAULT}</td>
		<td class="row2"><input type="radio" name="allow_default" value="1" {DEFAULT_SIG_YES} /> {L_YES}&nbsp;&nbsp;<input type="radio" name="allow_default" value="0" {DEFAULT_SIG_NO} /> {L_NO}</td>
	</tr>
	<tr>
	<td class="row1">{L_DEFAULT_SIG}<br /><span class="gensmall">{L_DEFAULT_SIG_EXPLAIN}</span></td>
		<td class="row2"><textarea name="default_sig" rows="5" cols="30" wrap="yes">{DEFAULT_SIG}</textarea></td>
	</tr>

#
#-----[ OPEN ]---------------------------------------------------
#
commom.php

#
#-----[ FIND ]---------------------------------------------------
#
$board_config = array();

#
#-----[ AFTER ADD ]----------------------------------------------
#
$default_sig = array();

#
#-----[ FIND ]---------------------------------------------------
#
while ( $row = $db->sql_fetchrow($result) )
{
	$board_config[$row['config_name']] = $row['config_value'];
}

#
#-----[ AFTER ADD ]----------------------------------------------
#
$sql = "SELECT *
	FROM " . DEFAULT_TABLE;
if( !($result = $db->sql_query($sql)) )
{
	message_die(CRITICAL_ERROR, "Could not query default signature information", "", __LINE__, __FILE__, $sql);
}

while ( $row = $db->sql_fetchrow($result) )
{
	$default_sig[$row['sig_name']] = $row['sig_value'];
}

#
#-----[ OPEN ]---------------------------------------------------
#
index.php

#
#-----[ FIND ]---------------------------------------------------
#
else
{
	$l_total_user_s = $lang['Registered_users_total'];
}

#
#-----[ AFTER ADD ]----------------------------------------------
#
$sql = "SELECT * FROM " . USERS_TABLE . " WHERE allow_default = 1";
$result = $db->sql_query($sql);
	$numrows = $db->sql_fetchrowset($result); 
	$rows = $db->sql_numrows($result);
for ($i=-1;$i < $rows; $i++)
{
	$id = $numrows[$i]['user_id'];
	$uid = $numrows[$i]['user_sig_bbcode_uid'];
	
	if ($uid == '' )
		{
			$signature_bbcode_uid = make_bbcode_uid();
			$sql = "UPDATE " . USERS_TABLE . " SET user_sig_bbcode_uid = '" . $signature_bbcode_uid . "' WHERE user_id = " .$id;
	$result = $db->sql_query($sql);
		}
	$signature = $default_sig['default_sig'];
	$signature_bbcode_uid = $uid;
	$signature = htmlspecialchars(stripslashes($signature));
	$signature = bbencode_first_pass($signature, $signature_bbcode_uid);
	$signature = str_replace("<a href=\"", "[url=", $signature);
	$signature = str_replace("\" target=\"_blank\" class=\"postlink\">", "]", $signature);
	$signature = str_replace("</a>", "[/url]", $signature);
	$sql = "UPDATE " . USERS_TABLE . " SET user_sig = '" . $signature . "' WHERE user_id = " .$id;
	$result = $db->sql_query($sql);
}

#
#-----[ OPEN ]---------------------------------------------------
#
login.php

#
#-----[ FIND ]---------------------------------------------------
#
else
{
	$sid = '';
}

#
#-----[ AFTER ADD ]----------------------------------------------
#
if ($userdata['allow_default'] == 1 && $board_config['allow_default'] == 1)
{
	$signature = $default_sig['default_sig'];
	$signature_bbcode_uid = $userdata['user_sig_bbcode_uid'];
	$signature = htmlspecialchars(stripslashes($signature));
	$signature = bbencode_first_pass($signature, $signature_bbcode_uid);
	$signature = str_replace("<a href=\"", "[url=", $signature);
	$signature = str_replace("\" target=\"_blank\" class=\"postlink\">", "]", $signature);
	$signature = str_replace("</a>", "[/url]", $signature);
	$sql = "UPDATE " . USERS_TABLE . " SET user_sig = '" . $signature . "' WHERE user_id = " .$userdata['user_id'];
	$result = $db->sql_query($sql);
}

#
#------[ SAVE AND CLOSE ALL FILES ]-------------------------------
#
# EoM
#
Başa dön
Kullanıcı avatarı
Mirach
Destek Ekibi Lideri
Destek Ekibi Lideri
Mesajlar: 1664
Kayıt: 27.03.2006, 01:06
Konum: İstanbul

Re: Default Sig Modu Sorun

Mesaj gönderen Mirach »

OBS.: (table_prefix) is table prefix of your board
(table_prefix) kısmını kullandığın prefix ile değiştirmelisin. herhangi bir değişik yapmadıysan bu "phpbb_" dir.
Profilinde phpBB forumunun adresini girmemiş üyelere ve kurallara aykırı şekilde açılmış başlıklara destek verilmez.
Resim Resim Resim
Başa dön
hunter_turk
Kayıtlı Kullanıcı
Mesajlar: 24
Kayıt: 14.04.2008, 18:51

Re: Default Sig Modu Sorun

Mesaj gönderen hunter_turk »

teşekkürler deniyeceğim
Başa dön
PuM@X
Kayıtlı Kullanıcı
Mesajlar: 26
Kayıt: 09.08.2007, 16:10
İletişim:
İletişim PuM@X

Re: Default Sig Modu Sorun

Mesaj gönderen PuM@X »

able_prefix veritabanı öneki diye hatırlıyorum
eğer kurulumda bir oynama yapmadıysan table_prefixleri bulup phpbb_ ile değiştireceksin
ama farklı bi ön ek kullandıysan kurulum sırasında onu yazacaksın ;)
http://www.The-Pensieve.Net - Gerçek Sihiri Hisset
Harry Potter Role Playing Game powered by phpBB
Başa dön
Kilitli

“2.0.x Destek Forumu” 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