Easy Scrolling Message umgebaut - funktioniert nicht

Slytherin · Beitrag von **Slytherin** » 10.04.2006 19:33

Hi,
ich habe soeben die Easy Scrolling Message ein- und etwas umgebaut, doch die Konfiguration durch das ACP funktioniert leider noch nicht ganz.
Leider fehlt mir die Zeit, das Problem selbst zu lösen und deshalb wäre ich froh, wenn mir jemand dabei helfen würde.
Wahrscheinlich ist es nur ein kleiner, einfach Fehler, doch leider fehlt mir die Zeit und ich bin überarbeitet und müde ...
Hier meine admin_rpg.php, in der sich der Fehler befindet.

Natürlich wurden die anderen Dateien angepasst.

Sql-Befehl, den ich ausführte, war demnach folgender:

Code: Alles auswählen

INSERT INTO phpbb2_config  (config_name, config_value) values ('P_GRYFFINDOR', 'Punktestand Gryffindor');
INSERT INTO phpbb2_config  (config_name, config_value) values ('P_HUFFLEPUFF', 'Punktestand Hufflepuff');
INSERT INTO phpbb2_config  (config_name, config_value) values ('P_RAVENCLAW', 'Punktestand Ravenclaw');
INSERT INTO phpbb2_config  (config_name, config_value) values ('P_SLYTHERIN', 'Punktestand Slytherin');
INSERT INTO phpbb2_config  (config_name, config_value) values ('P_DATUM', 'Sonntag, 24.06.96');
INSERT INTO phpbb2_config  (config_name, config_value) values ('P_ZEIT', '11.40 - 13.30');
INSERT INTO phpbb2_config  (config_name, config_value) values ('P_EREIGNISSE', 'Mittagessen');
INSERT INTO phpbb2_config  (config_name, config_value) values ('P_WETTER', 'Sonnig, 21°');

Mein Präfix ist natürlich phpbb2_.

Slytherin

Slytherin · Beitrag von **Slytherin** » 13.04.2006 12:38

Also, hier mal die gesamte Anleitung, was ich gemacht habe:

Code: Alles auswählen

# 
#-----[ COPY ]------------------------------------------------ 
#
copy admin/admin_ESM.php to admin/admin_rpg.php -> umbenannt
copy templates/subSilver/admin/ESM_config.tpl to templates/subSilver/admin/rpg_config.tpl -> umbenannt, admin_rpg.php entsprechend angepasst
copy language/lang_english/lang_ESM.php to language/lang_english/lang_rpg.php -> umbenannt und angepasst

# 
#-----[ SQL ]------------------------------------------ 
#
# Upload , run then delete the file ESM_install.php - Don't forget you have to first modify your files !
# Or run the following SQL requests :
#

INSERT INTO phpbb2_config  (config_name, config_value) values ('P_GRYFFINDOR', 'Punktestand Gryffindor'); 
INSERT INTO phpbb2_config  (config_name, config_value) values ('P_HUFFLEPUFF', 'Punktestand Hufflepuff'); 
INSERT INTO phpbb2_config  (config_name, config_value) values ('P_RAVENCLAW', 'Punktestand Ravenclaw'); 
INSERT INTO phpbb2_config  (config_name, config_value) values ('P_SLYTHERIN', 'Punktestand Slytherin'); 
INSERT INTO phpbb2_config  (config_name, config_value) values ('P_DATUM', 'Sonntag, 24.06.96'); 
INSERT INTO phpbb2_config  (config_name, config_value) values ('P_ZEIT', '11.40 - 13.30'); 
INSERT INTO phpbb2_config  (config_name, config_value) values ('P_EREIGNISSE', 'Mittagessen'); 
INSERT INTO phpbb2_config  (config_name, config_value) values ('P_WETTER', 'Sonnig, 21°');

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

# 
#-----[ FIND ]------------------------------------------ 
#
$template->assign_vars(array(
	'SITENAME' => $board_config['sitename'],
# 
#-----[ AFTER, ADD ]------------------------------------------ 
#
        'P_GRYFFINDOR' => $board_config["P_GRYFFINDOR"],
        'P_HUFFLEPUFF' => $board_config["P_HUFFLEPUFF"],
        'P_RAVENCLAW' => $board_config["P_RAVENCLAW"],
        'P_SLYTHERIN' => $board_config["P_SLYTHERIN"],
# 
#-----[ OPEN ]------------------------------------------ 
#
index.php

# 
#-----[ FIND ]------------------------------------------ 
#
$template->assign_vars(array(
	'SITENAME' => $board_config['sitename'],
# 
#-----[ AFTER, ADD ]------------------------------------------ 
#
        'P_DATUM' => $board_config["P_DATUM"],
        'P_ZEIT' => $board_config["P_ZEIT"],
        'P_EREIGNISSE' => $board_config["P_EREIGNISSE"],
        'P_WETTER' => $board_config["P_WETTER"],
# 
#-----[ OPEN ]------------------------------------------ 
#
templates/subSilver/xyz.tpl
[...]
Änderungen an den Templates-Dateien
[...]
# 
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ 
# 
# EoM

Ausserdem Änderungen an admin_rpg.php vorgenommen.

Code: Alles auswählen

if ($_POST['process'] == 'Submit') {
	if ($_POST['P_GRYFFINDOR'] != NULL) {
		$sql = "update " . CONFIG_TABLE . " set config_value='{$_POST['P_GRYFFINDOR']}' where config_name='P_GRYFFINDOR'";
		if ( !($db->sql_query($sql)) ) { message_die(GENERAL_MESSAGE, 'Fatal Error ESM message<br>'.mysql_error()); }
	}
	if ($_POST['P_HUFFLEPUFF'] != NULL) {
		$sql = "update " . CONFIG_TABLE . " set config_value='{$_POST['P_HUFFLEPUFF']}' where config_name='P_HUFFLEPUFF'";
		if ( !($db->sql_query($sql)) ) { message_die(GENERAL_MESSAGE, 'Fatal Error ESM message<br>'.mysql_error()); }
	}
	if ($_POST['P_RAVENCLAW'] != NULL) {
		$sql = "update " . CONFIG_TABLE . " set config_value='{$_POST['P_RAVENCLAW']}' where config_name='P_RAVENCLAW'";
		if ( !($db->sql_query($sql)) ) { message_die(GENERAL_MESSAGE, 'Fatal Error ESM message<br>'.mysql_error()); }
	}
	if ($_POST['P_SLYTHERIN'] != NULL) {
		$sql = "update " . CONFIG_TABLE . " set config_value='{$_POST['P_SLYTHERIN']}' where config_name='P_SLYTHERIN'";
		if ( !($db->sql_query($sql)) ) { message_die(GENERAL_MESSAGE, 'Fatal Error ESM message<br>'.mysql_error()); }
	}
	if ($_POST['P_DATUM'] != NULL) {
		$sql = "update " . CONFIG_TABLE . " set config_value='{$_POST['P_DATUM']}' where config_name='P_DATUM'";
		if ( !($db->sql_query($sql)) ) { message_die(GENERAL_MESSAGE, 'Fatal Error ESM message<br>'.mysql_error()); }
	}
	if ($_POST['P_ZEIT'] != NULL) {
		$sql = "update " . CONFIG_TABLE . " set config_value='{$_POST['P_ZEIT']}' where config_name='P_ZEIT'";
		if ( !($db->sql_query($sql)) ) { message_die(GENERAL_MESSAGE, 'Fatal Error ESM message<br>'.mysql_error()); }
	}
	if ($_POST['P_EREIGNISSE'] != NULL) {
		$sql = "update " . CONFIG_TABLE . " set config_value='{$_POST['P_EREIGNISSE']}' where config_name='P_EREIGNISSE'";
		if ( !($db->sql_query($sql)) ) { message_die(GENERAL_MESSAGE, 'Fatal Error ESM message<br>'.mysql_error()); }
	}
	if ($_POST['P_WETTER'] != NULL) {
		$sql = "update " . CONFIG_TABLE . " set config_value='{$_POST['P_WETTER']}' where config_name='P_WETTER'";
		if ( !($db->sql_query($sql)) ) { message_die(GENERAL_MESSAGE, 'Fatal Error ESM message<br>'.mysql_error()); }
	}
	
	$overall =

Hier glaube ich, dass sich irgendwo der Fehler befindet.

Slytherin

Slytherin · Beitrag von **Slytherin** » 18.04.2006 20:18

Ein nächster Versuch ...
Hier muss der Fehler liegen. Meine Frage: wo?

Code: Alles auswählen

if ($_POST['submit'] != 'submit') {

	$overall = '<form method="POST" action="'.append_sid("admin_rpg.$phpEx").'">
	<table width="100%" cellpadding="4" cellspacing="1" border="0">
	  <tr>
		<th width="50%"  class="thHead" colspan="2"><center>RPG-Konfiguration</center></th>
	  </tr>
	  <tr>
		<th width="50%"  class="thHead" colspan="2"><b>Punktegläser</b></th>
	  </tr>
	  <tr>
		<td width="40%" class="row1">Gryffindor</td>
		<td width="60%" class="row2"><input type="text" name="P_GRYFFINDOR" size="10" value="'.$board_config['P_GRYFFINDOR'].'"></td>
	  </tr>
	  <tr>
		<td width="40%" class="row1">Hufflepuff</td>
		<td width="60%" class="row2"><input type="text" name="P_HUFFLEPUFF" size="10" value="'.$board_config['P_HUFFLEPUFF'].'"></td>
	  </tr>
	  <tr>
		<td width="40%" class="row1">Ravenclaw</td>
		<td width="60%" class="row2"><input type="text" name="P_RAVENCLAW" size="10" value="'.$board_config['P_RAVENCLAW'].'"></td>
	  </tr>
	  <tr>
		<td width="40%" class="row1">Slytherin</td>
		<td width="60%" class="row2"><input type="text" name="P_SLYTHERIN" size="10" value="'.$board_config['P_SLYTHERIN'].'"></td>
	  </tr>
	  <tr>
		<th width="50%"  class="thHead" colspan="2"><b>Zeitangaben & Wetterbedingungen</b></th>
	  </tr>
	  <tr>
		<td width="40%" class="row1">Datum</td>
		<td width="60%" class="row2"><input type="text" name="P_DATUM" size="10" value="'.$board_config['P_DATUM'].'"></td>
	  </tr>
	  <tr>
		<td width="40%" class="row1">Zeit</td>
		<td width="60%" class="row2"><input type="text" name="P_ZEIT" size="10" value="'.$board_config['P_ZEIT'].'"></td>
	  </tr>
	  <tr>
		<td width="40%" class="row1">Ereignisse</td>
		<td width="60%" class="row2"><input type="text" name="P_EREIGNISSE" size="10" value="'.$board_config['P_EREIGNISSE'].'"></td>
	  </tr>
	  <tr>
		<td width="40%" class="row1">Wetter/Klima</td>
		<td width="60%" class="row2"><input type="text" name="P_WETTER" size="10" value="'.$board_config['P_WETTER'].'"></td>
	  </tr>
	  <tr>
		<td width="50%"  class="catBottom" colspan="2"><center><input type="submit" value="'.$lang['admin_submit'].'" name="submit" size="20" class="button"></form></center></td>
	  </tr>
	</table>
';
}
if ($_POST['submit'] == 'submit') {
	if ($_POST['P_GRYFFINDOR'] != NULL) {
		$sql = "UPDATE " . CONFIG_TABLE . " set config_value='{$_POST['Gryffindor']}' where config_name='P_GRYFFINDOR'";
		if ( !($db->sql_query($sql)) ) { message_die(GENERAL_MESSAGE, 'Fatal Error ESM message<br>'.mysql_error()); }
	}
	if ($_POST['P_HUFFLEPUFF'] != NULL) {
		$sql = "UPDATE " . CONFIG_TABLE . " set config_value='{$_POST['Hufflepuff']}' where config_name='P_HUFFLEPUFF'";
		if ( !($db->sql_query($sql)) ) { message_die(GENERAL_MESSAGE, 'Fatal Error ESM message<br>'.mysql_error()); }
	}
	if ($_POST['P_RAVENCLAW'] != NULL) {
		$sql = "UPDATE " . CONFIG_TABLE . " set config_value='{$_POST['Ravenclaw']}' where config_name='P_RAVENCLAW'";
		if ( !($db->sql_query($sql)) ) { message_die(GENERAL_MESSAGE, 'Fatal Error ESM message<br>'.mysql_error()); }
	}
	if ($_POST['P_SLYTHERIN'] != NULL) {
		$sql = "UPDATE " . CONFIG_TABLE . " set config_value='{$_POST['Slytherin']}' where config_name='P_SLYTHERIN'";
		if ( !($db->sql_query($sql)) ) { message_die(GENERAL_MESSAGE, 'Fatal Error ESM message<br>'.mysql_error()); }
	}
	if ($_POST['P_DATUM'] != NULL) {
		$sql = "update " . CONFIG_TABLE . " set config_value='{$_POST['Datum']}' where config_name='P_DATUM'";
		if ( !($db->sql_query($sql)) ) { message_die(GENERAL_MESSAGE, 'Fatal Error ESM message<br>'.mysql_error()); }
	}
	if ($_POST['P_ZEIT'] != NULL) {
		$sql = "UPDATE " . CONFIG_TABLE . " set config_value='{$_POST['Zeit']}' where config_name='P_ZEIT'";
		if ( !($db->sql_query($sql)) ) { message_die(GENERAL_MESSAGE, 'Fatal Error ESM message<br>'.mysql_error()); }
	}
	if ($_POST['P_EREIGNISSE'] != NULL) {
		$sql = "UPDATE " . CONFIG_TABLE . " set config_value='{$_POST['Ereignisse']}' where config_name='P_EREIGNISSE'";
		if ( !($db->sql_query($sql)) ) { message_die(GENERAL_MESSAGE, 'Fatal Error ESM message<br>'.mysql_error()); }
	}
	if ($_POST['P_WETTER'] != NULL) {
		$sql = "UPDATE " . CONFIG_TABLE . " set config_value='{$_POST['Wetter']}' where config_name='P_WETTER'";
		if ( !($db->sql_query($sql)) ) { message_die(GENERAL_MESSAGE, 'Fatal Error ESM message<br>'.mysql_error()); }
	}
	
	$overall = '
	<table width="100%" cellpadding="4" cellspacing="1" border="0">
	  <tr>
		<th width="50%"  class="thHead" colspan="2"><center>'.$lang['admin_title'].'</center></th>
	  </tr>
	  <tr>
		<td class="row1" width="100%">'.$lang['admin_updated'].'. | <b><a href="'.append_sid("admin_rpg.$phpEx").'">'.$lang['admin_return'].'</a></b></td>
	  </tr>
	</table>';

}