phpBB.de

##################################################
## Hack Titel: Signatur anderer User anzeigen/nicht anzeigen
## Hack Version: 1.0
## Author: Acid < acid_junky@web.de >
## Description: Jeder User kann in seinem Profil einstellen, ob er die Signaturen
## von anderen Usern sehen will oder nicht.
##
## Dateien zu ändern: 4
## language/lang_xxx/lang_main.php
## includes/usercp_register.php
## viewtopic.php
## templates/xxx/profile_add_body.tpl
##
#####################################################################################
##
## Installationsnotiz:
## Vor jeglichen Änderungen an Dateien oder Datenbank, solltest Du diese vorher
## sichern.
##
## Mit diesem Hack wird ein neues Feld in die 'users' Tabelle eingefügt.
################################################

>>SQL QUERY: (Du solltest den Prefix angleichen.)

ALTER TABLE test_users ADD user_sig_disable TINYINT(1) AFTER user_sig;

>>alternativ kannst Du auch die db_install.php benutzen, um die Datenbank
>>anzugleichen (einfach hochladen und ausführen).

#################################################
#-----[ ÖFFNEN ]------------------------------------------
#
# language/lang_xxx/lang_main.php

>>FINDE:
$lang['No_send_account_inactive'] = "Sorry, aber ein neues Passwort kann im Moment nicht gesendet werden, da Dein Account derzeit noch inaktiv ist. Bitte kontaktiere den Administrator für weitere Informationen.";

>>DARUNTER EINFÜGEN:
$lang['User_sig_disable'] = "Signatur anderer User anzeigen";

#################################################
#-----[ ÖFFNEN ]------------------------------------------
#
# includes/usercp_register.php

>>FINDE:
if ( $mode == 'register' )
{
$attachsig = ( isset($HTTP_POST_VARS['attachsig']) ) ? ( ($HTTP_POST_VARS['attachsig']) ? TRUE : 0 ) : $board_config['allow_sig'];

>>DANACH EINFÜGEN:
$user_sig_disable = ( isset($HTTP_POST_VARS['user_sig_disable']) ) ? ( ($HTTP_POST_VARS['user_sig_disable']) ? TRUE : 0 ) : '';

--------------------------------------------------------------------------------------------------

>>FINDE:
else
{
$attachsig = ( isset($HTTP_POST_VARS['attachsig']) ) ? ( ($HTTP_POST_VARS['attachsig']) ? TRUE : 0 ) : 0;

>>DANACH EINFÜGEN:
$user_sig_disable = ( isset($HTTP_POST_VARS['user_sig_disable']) ) ? ( ($HTTP_POST_VARS['user_sig_disable']) ? TRUE : 0 ) : $userdata['user_sig_disable'];

--------------------------------------------------------------------------------------------------

>>FINDE:
$sql = "UPDATE " . USERS_TABLE . "
SET " . $username_sql . $passwd_sql . "user_email = '" . str_replace("\'", "''", $email) ."', user_icq = '" . str_replace("\'", "''", $icq) . "', user_website = '" . str_replace("\'", "''", $website) . "', user_occ = '" . str_replace("\'", "''", $occupation) . "', user_from = '" . str_replace("\'", "''", $location) . "', user_interests = '" . str_replace("\'", "''", $interests) . "', user_sig = '" . str_replace("\'", "''", $signature) . "', user_sig_bbcode_uid = '$signature_bbcode_uid', user_viewemail = $viewemail, user_aim = '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', user_yim = '" . str_replace("\'", "''", $yim) . "', user_msnm = '" . str_replace("\'", "''", $msn) . "', user_attachsig = $attachsig, user_allowsmile = $allowsmilies, user_allowhtml = $allowhtml, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_notify_pm = $notifypm, user_popup_pm = $popuppm, user_timezone = $user_timezone, user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "', user_lang = '" . str_replace("\'", "''", $user_lang) . "', user_style = $user_style, user_active = $user_active, user_actkey = '" . str_replace("\'", "''", $user_actkey) . "'" . $avatar_sql . "

>>FINDE IN DIESER ZEILE:
user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "'

>>DANACH EINFÜGEN:
, user_sig_disable = '" . str_replace("\'", "''", $user_sig_disable) . "'

--------------------------------------------------------------------------------------------------

>>FINDE:
$sql = "INSERT INTO " . USERS_TABLE . " (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey)
VALUES ($user_id, '" . str_replace("\'", "''", $username) . "', " . time() . ", '" . str_replace("\'", "''", $new_password) . "', '" . str_replace("\'", "''", $email) . "', '" . str_replace("\'", "''", $icq) . "', '" . str_replace("\'", "''", $website) . "', '" . str_replace("\'", "''", $occupation) . "', '" . str_replace("\'", "''", $location) . "', '" . str_replace("\'", "''", $interests) . "', '" . str_replace("\'", "''", $signature) . "', '$signature_bbcode_uid', $avatar_sql, $viewemail, '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', '" . str_replace("\'", "''", $yim) . "', '" . str_replace("\'", "''", $msn) . "', $attachsig, $allowsmilies, $allowhtml, $allowbbcode, $allowviewonline, $notifyreply, $notifypm, $popuppm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, 0, 1, ";

>>FINDE IN DIESER ZEILE:
user_dateformat

>>DANACH EINFÜGEN:
, user_sig_disable

>>FINDE IN DIESER ZEILE:
'" . str_replace("\'", "''", $user_dateformat) . "'

>>DANACH EINFÜGEN:
, '" . str_replace("\'", "''", $user_sig_disable) . "'

--------------------------------------------------------------------------------------------------

>>FINDE:
'ALWAYS_ALLOW_SMILIES_NO' => ( !$allowsmilies ) ? 'checked="checked"' : '',

>>DARUNTER EINFÜGEN:
'USER_SIG_ENABLE' => ( !$user_sig_disable ) ? 'checked="checked"' : '',
'USER_SIG_DISABLE' => ( $user_sig_disable ) ? 'checked="checked"' : '',

--------------------------------------------------------------------------------------------------

>>FINDE:
$allowviewonline = $userdata['user_allow_viewonline'];

>>DARUNTER EINFÜGEN:
$user_sig_disable = $userdata['user_sig_disable'];

--------------------------------------------------------------------------------------------------

>>FINDE:
'L_ALWAYS_ALLOW_HTML' => $lang['Always_html'],

>>DARUNTER EINFÜGEN:
'L_USER_SIG_DISABLE' => $lang['User_sig_disable'],

#################################################
#-----[ ÖFFNEN ]------------------------------------------
#
# viewtopic.php

>>FINDE:
$user_sig = ( $postrow[$i]['enable_sig'] && $postrow[$i]['user_sig'] != '' && $board_config['allow_sig'] ) ? $postrow[$i]['user_sig'] : '';

>>MIT FOLGENDEM ERSETZEN:
$user_sig = ( $userdata['user_sig_disable'] && $postrow[$i]['enable_sig'] && $postrow[$i]['user_sig'] != '' && $board_config['allow_sig'] ) ? $postrow[$i]['user_sig'] : '';

#################################################
#-----[ ÖFFNEN ]------------------------------------------
#
# templates/xxx/profile_add_body.tpl

>>FINDE:
<input type="radio" name="allowsmilies" value="0" {ALWAYS_ALLOW_SMILIES_NO} />
<span class="gen">{L_NO}</span></td>
</tr>

>>DARUNTER EINFÜGEN:
<tr>
<td class="row1"><span class="gen">{L_USER_SIG_DISABLE}:</span></td>
<td class="row2">
<input type="radio" name="user_sig_disable" value="1" {USER_SIG_ENABLE} />
<span class="gen">{L_YES}</span>&nbsp;&nbsp;
<input type="radio" name="user_sig_disable" value="0" {USER_SIG_DISABLE} />
<span class="gen">{L_NO}</span></td>
</tr>

################################################

Could not update users table

DEBUG MODE

SQL Error : 1054 Unknown column 'user_sig_disable' in 'field list'

UPDATE phpbb_1users SET user_email = 'sean.john@gmx.de', user_icq = '213263731', user_website = 'http://www.clan-tbd.de', user_occ = 'Schüler (11. Klasse)', user_from = 'Quakenbrück', user_interests = 'Basketball, Parties, I-Net', user_viewemail = 0, user_aim = '', user_yim = '', user_msnm = 'sean.john@gmx.de', user_attachsig = 1, user_allowsmile = 1, user_allowhtml = 0, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = 1, user_timezone = 1, user_dateformat = 'd.m.Y, H:i', user_sig_disable = '0' , user_lang = 'german', user_style = 2, user_active = 1, user_actkey = '' WHERE user_id = 3

Line : 461
File : /home/www/web182/html/www-board/includes/usercp_register.php