Re: Fahrerübersicht (mittels php und DB) - brauche Hilfe
Verfasst: 23.05.2009 11:08
leider hab ich das Problem noch nicht lösen können.
Werte werden richtig in den Feldern angezeigt, wenn man sie ändert und auf Zurücksetzen klickt, werden die auch zurück gesetzt, wenn aber auf absenden klickt, werden die neuen Werte nicht in die DB geschrieben. Wo liegt der Fehler?
Code: Alles auswählen
case 'settings':
$driver_img_klein_width = request_var('driver_img_k_width', 0 );
$driver_img_helm_width = request_var('driver_img_h_width', 0 );
$driver_img_overall_width = request_var('driver_img_o_width', 0 );
$driver_img_klein_height = request_var('driver_img_k_height', 0 );
$driver_img_overall_height = request_var('driver_img_o_height', 0 );
$driver_img_helm_height = request_var('driver_img_h_height', 0 );
$team_img_logo_width = request_var('team_img_logo_width', 0 );
$team_img_car_past_width = request_var('team_img_car_past_width', 0 );
$team_img_car1_width = request_var('team_img_c1_width', 0 );
$team_img_car2_width = request_var('team_img_c2_width', 0 );
$team_img_logo_heigth = request_var('team_img_logo_heigth', 0 );
$team_img_car_past_heigth = request_var('team_img_car_past_heigth', 0 );
$team_img_car1_heigth = request_var('team_img_c1_heigth', 0 );
$team_img_car2_heigth = request_var('team_img_c2_heigth', 0 );
$lang = 'ACP_DRIVERSTATS_SETTINGS';
$this->page_title = $lang;
// Get all config data
$driverstats_config = get_driverstats_config();
// Pull all config data
$sql = 'SELECT *
FROM ' . DRIVERSTATS_CONFIG_TABLE;
$result = $db->sql_query($sql);
while( $row = $db->sql_fetchrow($result) )
{
$config_name = $row['config_name'];
$config_value = $row['config_value'];
$default_config[$config_name] = isset($_POST['submit']) ? str_replace("'", "\'", $config_value) : $config_value;
$new[$config_name] = request_var( $config_name , $default_config[$config_name]);
if ( isset($_POST['submit']) )
{
// Is it salty ?
if (!check_form_key('acp_driverstats'))
{
trigger_error('FORM_INVALID');
}
$sql_ary = array(
'config_value' => $new[$config_name],
);
$sql = 'UPDATE ' . DRIVERSTATS_CONFIG_TABLE . '
SET ' . $db->sql_build_array('UPDATE', $sql_ary) . "
WHERE config_name = '$config_name'" ;
$db->sql_query($sql);
}
}
$db->sql_freeresult($result);
if ( isset($_POST['submit']) )
{
add_log('admin', 'LOG_DRIVERSTATS_SETTINGS');
$error = $user->lang[$lang . '_UPDATED'];
trigger_error($error . adm_back_link($this->u_action));
}
$template->assign_vars(array(
'S_SETTINGS' => true,
'ACP_DRIVERSTATS_SETTINGS_DRIVER_IMG_K_HEIGHT' => $new['driver_img_k_height'],
'ACP_DRIVERSTATS_SETTINGS_DRIVER_IMG_K_WIDTH' => $new['driver_img_k_width'],
'ACP_DRIVERSTATS_SETTINGS_DRIVER_IMG_O_HEIGHT' => $new['driver_img_o_height'],
'ACP_DRIVERSTATS_SETTINGS_DRIVER_IMG_O_WIDTH' => $new['driver_img_o_width'],
'ACP_DRIVERSTATS_SETTINGS_DRIVER_IMG_H_HEIGHT' => $new['driver_img_h_height'],
'ACP_DRIVERSTATS_SETTINGS_DRIVER_IMG_H_WIDTH' => $new['driver_img_h_width'],
'ACP_DRIVERSTATS_SETTINGS_TEAM_IMG_L_HEIGHT' => $new['team_img_logo_heigth'],
'ACP_DRIVERSTATS_SETTINGS_TEAM_IMG_L_WIDTH' => $new['team_img_logo_width'],
'ACP_DRIVERSTATS_SETTINGS_TEAM_IMG_CP_HEIGHT' => $new['team_img_car_past_heigth'],
'ACP_DRIVERSTATS_SETTINGS_TEAM_IMG_CP_WIDTH' => $new['team_img_car_past_width'],
'ACP_DRIVERSTATS_SETTINGS_TEAM_IMG_C1_HEIGHT' => $new['team_img_c1_heigth'],
'ACP_DRIVERSTATS_SETTINGS_TEAM_IMG_C1_WIDTH' => $new['team_img_c1_width'],
'ACP_DRIVERSTATS_SETTINGS_TEAM_IMG_C2_HEIGHT' => $new['team_img_c2_heigth'],
'ACP_DRIVERSTATS_SETTINGS_TEAM_IMG_C2_WIDTH' => $new['team_img_c2_width'],
));
break;