phpBB.de

phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/

WArning Mod SQL Problem

https://www.phpbb.de/community/viewtopic.php?t=74147

Seite 1 von 1

WArning Mod SQL Problem

Verfasst: 29.12.2004 13:58
von SimpsonFan
Also ich kappier das nicht mit dem SQL Befehl mit der Warning Mod kann mir einer erklären wie ich des machen muss damit des mit dem SQL funktioniert ?!?!!?

Code: Alles auswählen

# 
#-----[ SQL ]------------------------------------------ 
# 
CREATE TABLE `phpbb_user_warn` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`warn_desc` TEXT NOT NULL ,
`warn_user` SMALLINT( 11 ) DEFAULT '0' NOT NULL ,
`warn_points` SMALLINT( 11 ) DEFAULT '0' NOT NULL ,
`warn_warner` SMALLINT( 11 ) DEFAULT '0' NOT NULL ,
`warn_post` INT( 11 ) DEFAULT '0' NOT NULL ,
`warn_date` INT( 11 ) DEFAULT '0' NOT NULL ,
PRIMARY KEY ( `id` ) 
);


INSERT INTO `phpbb_config` ( `config_name` , `config_value` , `config_static` ) 
VALUES (
'jr_admin_warn', '1', '0'
);

ALTER TABLE `phpbb_users` ADD `user_warnings` SMALLINT( 5 ) DEFAULT '0' ;
ALTER TABLE `phpbb_auth_access` ADD `auth_warn` TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER `auth_attachments` ;
ALTER TABLE `phpbb_forums` ADD `auth_warn` TINYINT( 2 ) DEFAULT '0' NOT NULL AFTER `auth_attachments` ;
Danke schon ma

Verfasst: 29.12.2004 13:59
von kratzer54847
in phpmyadmin ausführen

http://www.phpbb.de/doku/kb/artikel.php ... phpmyadmin

Verfasst: 29.12.2004 14:20
von SimpsonFan
also der oberste und der letzte abschnitt hab ich jetzt hinbekommen nur wie bekomm ich jetzt den Text in die Tabelle

Code: Alles auswählen

INSERT INTO `phpbb_config` ( `config_name` , `config_value` , `config_static` ) 
VALUES (
'jr_admin_warn', '1', '0'
);
Immer wenn ich in die "phpbb_config" reingehe und den Befehl ausführen will bekomm ich die Meldung

Code: Alles auswählen

SQL-Befehl:

INSERT INTO `phpbb_config` ( `config_name` , `config_value` , `config_static` )
VALUES (
'jr_admin_warn', '1', '0'
)

MySQL meldet: 

#1054 - Unknown column 'config_static' in 'field list'
Kann mir einer helfen ?!?!

Verfasst: 29.12.2004 14:28
von kratzer54847
waren das wirklich alle SQL Queries,die auszuführen sind?
da fehlt eine Spalte "config_static" in der phpbb_config

Verfasst: 29.12.2004 14:32
von SimpsonFan
Jup das war alles hier nochmal die ganze Anleitung

Code: Alles auswählen

############################################################## 
## MOD Title: Warn User
## MOD Author: Dave < webmaster@shadow-dragon.org >
## MOD Description: Mit diesem Mod kann man User verwarnen
## MOD Version: 0.0.1
## 
## Installation Level: Easy
## Installation Time: 2 Minutes 
## Files To Edit: viewtopic.php 
## 		  includes/constants.php
## 		  templates/subSilver/viewtopic_body.tpl
## 		  templates/subSilver/subSilver.cfg
## 		  language/lang_german/lang_main.php
## Included Files: warning.php
##                 templates/subSilver/warning_popup.tpl
## 		   templates/subSilver/warning_user_body.tpl
## 		   templates/subSilver/images/icon_rcard.gif
############################################################## 
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
############################################################## 
# 
#-----[ SQL ]------------------------------------------ 
# 
CREATE TABLE `phpbb_user_warn` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`warn_desc` TEXT NOT NULL ,
`warn_user` SMALLINT( 11 ) DEFAULT '0' NOT NULL ,
`warn_points` SMALLINT( 11 ) DEFAULT '0' NOT NULL ,
`warn_warner` SMALLINT( 11 ) DEFAULT '0' NOT NULL ,
`warn_post` INT( 11 ) DEFAULT '0' NOT NULL ,
`warn_date` INT( 11 ) DEFAULT '0' NOT NULL ,
PRIMARY KEY ( `id` ) 
);


INSERT INTO `phpbb_config` ( `config_name` , `config_value` , `config_static` ) 
VALUES (
'jr_admin_warn', '1', '0'
);

ALTER TABLE `phpbb_users` ADD `user_warnings` SMALLINT( 5 ) DEFAULT '0' ;
ALTER TABLE `phpbb_auth_access` ADD `auth_warn` TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER `auth_attachments` ;
ALTER TABLE `phpbb_forums` ADD `auth_warn` TINYINT( 2 ) DEFAULT '0' NOT NULL AFTER `auth_attachments` ;

# 
#-----[ COPY ]------------------------------------------ 
#
copy warning.php to warning.php
copy templates/subSilver/warning_popup.tpl to copy templates/subSilver/warning_popup.tpl
copy templates/subSilver/warning_user_body.tpl to templates/subSilver/warning_user_body.tpl
copy templates/subSilver/images/icon_rcard.gif to copy templates/subSilver/images/icon_rcard.gif

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

#
#-----[ FIND ]------------------------------------------
#
$prune_yes = ( $new['prune_enable'] ) ? "checked=\"checked\"" : "";
$prune_no = ( !$new['prune_enable'] ) ? "checked=\"checked\"" : "";

#
#-----[ AFTER, ADD ]------------------------------------------
#
$warn_junior_yes = ( $new['jr_admin_warn'] ) ? "checked=\"checked\"" : "";
$warn_junior_no = ( !$new['jr_admin_warn'] ) ? "checked=\"checked\"" : "";

#
#-----[ FIND ]------------------------------------------
#
	"PRUNE_YES" => $prune_yes,
	"PRUNE_NO" => $prune_no, 

#
#-----[ AFTER, ADD ]------------------------------------------
#
	"WARN_JUNIOR_YES" => $warn_junior_yes,
	"WARN_JUNIOR_NO" => $warn_junior_no, 

#
#-----[ FIND ]------------------------------------------
#
	"L_RESET" => $lang['Reset'], 
#
#-----[ AFTER, ADD ]------------------------------------------
# 
"L_WARN_JUNIOR_ALLOW" => $lang['warn_junior_allow'],

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

#
#-----[ FIND ]------------------------------------------
#
	?>

#
#-----[ BEFORE, ADD ]-----------------------------------------
#
define('USER_WARN', $table_prefix.'user_warn');
define('USER_WARN_CONFIG', $table_prefix.'user_warn_config');

#
#-----[ OPEN ]------------------------------------------
#
viewtopic.php

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

#
#-----[ AFTER, ADD ]------------------------------------------
#
	if ( $is_auth['auth_warn'] )
	{
		if ( $poster_id != ANONYMOUS && $postrow[$i]['user_level'] != ADMIN )
		{ 
			$temp_url = "warning.$phpEx?m=warning&u=" . $postrow[$i]['user_id'] . "&p=" . $postrow[$i]['post_id'];
			$warn_img = '<a href="' . $temp_url . '" ><img src="' . $images['icon_warn'] . '" alt="User Verwarnen" title="User Verwarnen" border="0" /></a>';
		}
		else
		{
			$warn_img = '';
		}
	}
	else
	{
		$warn_img = '';
	}

#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/viewtopic_body.tpl

#
#-----[ FIND ]------------------------------------------
#
				<td valign="middle" nowrap="nowrap">{postrow.PROFILE_IMG} {postrow.PM_IMG} {postrow.EMAIL_IMG} {postrow.WWW_IMG} {postrow.AIM_IMG} {postrow.YIM_IMG} {postrow.MSN_IMG}<script language="JavaScript" type="text/javascript"><!-- 

	if ( navigator.userAgent.toLowerCase().indexOf('mozilla') != -1 && navigator.userAgent.indexOf('5.') == -1 && navigator.userAgent.indexOf('6.') == -1 )
		document.write(' {postrow.ICQ_IMG}');
	else
		document.write('</td><td>&nbsp;</td><td valign="top" nowrap="nowrap"><div style="position:relative"><div style="position:absolute">{postrow.ICQ_IMG}</div><div style="position:absolute;left:3px;top:-1px">{postrow.ICQ_STATUS_IMG}</div></div>');
				
				//--></script><noscript>{postrow.ICQ_IMG}</noscript></td>

#
#-----[ AFTER, ADD ]------------------------------------------
#
				<td valign="right" nowrap="nowrap"><div align="right" class="gensmall">{postrow.POSTER_WARN}</div></td>

#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/subSilver.cfg

#
#-----[ FIND ]------------------------------------------
#
?>

#
#-----[ AFTER, ADD ]------------------------------------------
#
$images['icon_warn'] = "$current_template_images/icon_rcard.gif";

#
#-----[ OPEN ]------------------------------------------
#
language/lang_german/lang_main.php

#
#-----[ FIND ]------------------------------------------
#
//
// That's all Folks!
// -------------------------------------------------

?>

#
#-----[ BEFORE, ADD ]-----------------------------------------
#
$lang['warn_warner'] 			= "Verwarner";
$lang['warn_posting'] 			= "Tatort";
$lang['warn_reason'] 			= "Verwarnungsgrund";
$lang['warn_user'] 				= "User";
$lang['warn_info'] 				= "Informationen";
$lang['warn_points'] 			= "Punkte";
$lang['warn_last_visit'] 		= "Letzter Besuch";
$lang['warn_place'] 			= "*klick*";
$lang['warn_delete'] 			= "Die Verwarnung wurde erfolgreich gelöscht.<br />%sHier%s gehts weiter.";
$lang['warn_warn']				= "Verwarnen";
$lang['warn_admin_error'] 		= "Nur Admins dürfen Verwarnungen löschen.<br />%sHier%s gehts weiter.";
$lang['warn_insert']			= "User wurde erfolgreich verwarnt.<br />%sHier%s gehts weiter.";
$lang['warn_user_post_error']	= "User und Beitrag passen nicht zusammen.<br />%sHier%s gehts weiter.";
$lang['warn_no_admin_error']	= "Admins können nicht verwarnt werden.<br />%sHier%s gehts weiter.";
$lang['warn_no_mod_error']		= "Du bist kein Moderator in diesem Bereich.<br />%sHier%s gehts weiter.";
$lang['warn_user_error']		= "Diesen User gibts es nicht.<br />%sHier%s gehts weiter.";
$lang['warn_no_access']			= "Du hast hier nix zu suchen.<br />%sHier%s gehts weiter.";
$lang['warn_email']				= "Verwarnung";
$lang['warn_empty_msg']			= "Du hast keine Begründung für die Verwarnung angegeben.<br />%sHier%s gehts weiter.";
$lang['warn_empty_points']		= "Du hast keine Punkte angegeben.<br />%sHier%s gehts weiter.";

#
#-----[ OPEN ]------------------------------------------
#
language/lang_german/lang_admin.php

#
#-----[ FIND ]------------------------------------------
#
//
// That's all Folks!
// -------------------------------------------------

?>

#
#-----[ BEFORE, ADD ]-----------------------------------------
#
$lang['auth_warn'] = 'User Verwarnen';
$lang['warn_junior_allow'] = 'Junior Admins dürfen Verwarnungen löschen?';

# 
#-----[ OPEN ]------------------------------------------------ 
# 
admin/admin_forumauth.php

# 
#-----[ FIND ]------------------------------------------------ 
# 
//                View

# 
#-----[ IN-LINE FIND ]---------------------------------------- 
# 
Poll

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

# 
#-----[ FIND ]------------------------------------------------ 
# 
$simple_auth_ary = array(
0  => array(

# 
#-----[ IN-LINE FIND ]---------------------------------------- 
# 
),

# 
#-----[ IN-LINE BEFORE, ADD ]--------------------------------- 
#
, AUTH_MOD

# 
#-----[ FIND ]------------------------------------------------ 
# 
1  => array(

# 
#-----[ IN-LINE FIND ]---------------------------------------- 
# 
),

# 
#-----[ IN-LINE BEFORE, ADD ]--------------------------------- 
#
, AUTH_MOD

# 
#-----[ FIND ]------------------------------------------------ 
# 
2  => array(

# 
#-----[ IN-LINE FIND ]---------------------------------------- 
# 
),

# 
#-----[ IN-LINE BEFORE, ADD ]--------------------------------- 
#
, AUTH_MOD
# 
#-----[ FIND ]------------------------------------------------ 
# 
3  => array(

# 
#-----[ IN-LINE FIND ]---------------------------------------- 
# 
),

# 
#-----[ IN-LINE BEFORE, ADD ]--------------------------------- 
#
, AUTH_MOD
# 
#-----[ FIND ]------------------------------------------------ 
# 
4  => array(

# 
#-----[ IN-LINE FIND ]---------------------------------------- 
# 
),

# 
#-----[ IN-LINE BEFORE, ADD ]--------------------------------- 
#
, AUTH_MOD
# 
#-----[ FIND ]------------------------------------------------ 
# 
5  => array(

# 
#-----[ IN-LINE FIND ]---------------------------------------- 
# 
),

# 
#-----[ IN-LINE BEFORE, ADD ]--------------------------------- 
#
, AUTH_MOD
# 
#-----[ FIND ]------------------------------------------------ 
# 
6  => array(

# 
#-----[ IN-LINE FIND ]---------------------------------------- 
# 
),

# 
#-----[ IN-LINE BEFORE, ADD ]--------------------------------- 
#
, AUTH_MOD

# 
#-----[ FIND ]------------------------------------------------ 
# 
$forum_auth_fields = array(

# 
#-----[ IN-LINE FIND ]---------------------------------------- 
# 
);

# 
#-----[ IN-LINE BEFORE, ADD ]--------------------------------- 
#
, 'auth_warn'

# 
#-----[ FIND ]------------------------------------------------ 
# 
']);

# 
#-----[ IN-LINE FIND ]---------------------------------------- 
# 
);

# 
#-----[ IN-LINE REPLACE WITH ]-------------------------------- 
#
,

# 
#-----[ AFTER, ADD ]------------------------------------------ 
#
'auth_warn' => $lang['auth_warn']);

# 
#-----[ OPEN ]------------------------------------------------ 
# 
admin/admin_forums.php

# 
#-----[ FIND ]------------------------------------------------ 
# 
"auth_pollcreate" =>

# 
#-----[ IN-LINE FIND ]---------------------------------------- 
# 
AUTH_REG

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

# 
#-----[ AFTER, ADD ]------------------------------------------ 
#

"auth_bluecard" => AUTH_MOD

# 
#-----[ OPEN ]------------------------------------------------ 
# 
admin/admin_ug_auth.php

# 
#-----[ FIND ]------------------------------------------------ 
# 
$forum_auth_fields = array(

# 
#-----[ IN-LINE FIND ]---------------------------------------- 
# 
);

# 
#-----[ IN-LINE BEFORE, ADD ]--------------------------------- 
#
, 'auth_warn'

# 
#-----[ FIND ]------------------------------------------------ 
# 
); 

# 
#-----[ IN-LINE FIND ]---------------------------------------- 
# 
);

# 
#-----[ IN-LINE REPLACE WITH ]-------------------------------- 
#
,

# 
#-----[ AFTER, ADD ]------------------------------------------ 
#
'auth_warn' => AUTH_WARN);

# 
#-----[ FIND ]------------------------------------------------ 
# 
']); 

# 
#-----[ IN-LINE FIND ]---------------------------------------- 
# 
);

# 
#-----[ IN-LINE REPLACE WITH ]-------------------------------- 
#
,

# 
#-----[ AFTER, ADD ]------------------------------------------ 
#
'auth_warn' => $lang['auth_warn']);

# 
#-----[ FIND ]------------------------------------------------ 
# 
SET auth_view = 0,
WHERE

# 
#-----[ IN-LINE FIND ]---------------------------------------- 
# 
 WHERE

# 
#-----[ IN-LINE BEFORE, ADD ]---------------------------------- 
#
, auth_warn = 0
# 
#-----[ OPEN ]------------------------------------------------ 
# 
includes/auth.php

# 
#-----[ FIND ]------------------------------------------------ 
# 
, POLLCREATE

# 
#-----[ AFTER, ADD ]---------------------------------- 
# 
  WARN

# 
#-----[ FIND ]------------------------------------------------ 
# 
case AUTH_ALL:
$a_sql =

# 
#-----[ IN-LINE FIND ]---------------------------------------- 
# 
';

# 
#-----[ IN-LINE BEFORE, ADD ]--------------------------------- 
#
, a.auth_warn

# 
#-----[ FIND ]------------------------------------------------ 
# 
$auth_fields =

# 
#-----[ IN-LINE FIND ]---------------------------------------- 
# 
);


# 
#-----[ IN-LINE BEFORE, ADD ]--------------------------------- 
#
, 'auth_warn'

# 
#-----[ FIND ]------------------------------------------ 
# 
default:
break;

# 
#-----[ BEFORE, ADD ]------------------------------------------ 
#
case AUTH_WARN: 
   $a_sql = 'a.auth_warn'; 
   $auth_fields = array('auth_warn'); 
   break;

#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/admin/board_config.tpl

#
#-----[ FIND ]------------------------------------------
#
	<tr>
		<td class="row1">{L_ENABLE_PRUNE}</td>
		<td class="row2"><input type="radio" name="prune_enable" value="1" {PRUNE_YES} /> {L_YES}&nbsp;&nbsp;<input type="radio" name="prune_enable" value="0" {PRUNE_NO} /> {L_NO}</td>
	</tr>

#
#-----[ AFTER, ADD ]------------------------------------------
#
	<tr>
		<td class="row1">{L_WARN_JUNIOR_ALLOW}</td>
		<td class="row2"><input type="radio" name="jr_admin_warn" value="1" {WARN_JUNIOR_YES} /> {L_YES}&nbsp;&nbsp;<input type="radio" name="jr_admin_warn" value="0" {WARN_JUNIOR_NO} /> {L_NO}</td>
	</tr>

#
#-----[ SAFE & Close all files]------------------------------------------
#EoM

Verfasst: 29.12.2004 14:35
von kratzer54847
am besten sprichst du mal den Autor des Mods an,da die Configtabelle eigentlich nur config_name und config_value enthält :roll:

Verfasst: 29.12.2004 14:38
von SimpsonFan
Hab ich schon gemacht das war einer vom Board hier hab im Thread den Fehler mal gepostet

Verfasst: 29.12.2004 14:40
von kratzer54847
alles klar
Alle Zeiten sind UTC+02:00
Seite 1 von 1

Powered by phpBB® Forum Software © phpBB Limited

Deutsche Übersetzung durch phpBB.de