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} <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} <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
#