Jeg har lavet denne opdaterings mulighed i person_ database, den virker på nogen servere men på andre tømmer den alle felterne i stedet for at ændre data.
Jeg kan ikke selv se nogen fejl, men det er ikke ensbetydende med at der ingen er.
Nogen der har et godt øje.
$step = isset($_REQUEST['step']) ? $_REQUEST['step'] : "";
$person_id = (isset($_REQUEST['person_id']) AND isnum($_REQUEST['person_id'])) ? $_REQUEST['person_id'] : "";
if (isset($_POST['edit_person'])) {
$sql = dbquery("UPDATE ".DB_PERSON_DATABASE." SET
person_summary='$person_summary', person_ponr='$person_ponr', person_bynavn='$person_bynavn', person_mobil='$person_mobil', person_vej='$person_vej', person_tele='$person_tele', person_description='$person_description', person_email='$person_email', person_nummer='$person_nummer', person_indmeldt='$person_indmeldt', person_betalt='$person_betalt', person_foto='$person_foto', person_positiv='$person_positiv', person_negativ='$person_negativ', person_opl='$person_opl', person_bommert='$person_bommert', person_hold='$person_hold', person_rygnr='$person_rygnr', person_hoj='$person_hoj', person_vag='$person_vag', person_spil='$person_spil', person_reads='$person_reads' WHERE person_id='$person_id'");
redirect(FUSION_SELF."?step=up&person_id=".$person_id."");
}
if ($step == "edit") {
if (!$person_id || !isNum($person_id)) { header("Location: ".FUSION_SELF); exit; }
opentable($locale['PERS_112']);
$sql = dbquery("SELECT * FROM ".DB_PERSON_DATABASE." WHERE person_id='".$person_id."'");
while($data = dbarray($sql)){
echo "<table border='0' width='100%' cellspacing='0' cellpadding='0'>
<tr>
<td colspan='2' class='tbl2'><b>".$locale['PERS_121']."</b></td>
</tr>
<tr>
<td width='100' class='tbl2'>".(($data['person_foto']) ? "<img src='".$data['person_foto']."' style='margin:5px' align='center' width='100' />" : "<img src='".INFUSIONS."person_database/images/no_photo.jpg' style='margin:5px' align='center' width='100' />")."</td>
<td valign='bottom' class='tbl2'><h2>".$data['person_summary']."</h2></td>
</tr>
</table>";
echo "<form name='editform' method='post' action='".FUSION_SELF."?&step=edit&person_id=".$data['person_id']."'>
<table align='center' cellspacing='2' cellpadding='2' class='tbl'>
<tr>
<td>".$locale['PERS_101']."</td>
<td><input type='text' name='person_summary' class='textbox' style='width:300px;' value='".$data['person_summary']."' /></td>
</tr>
<tr>
<td>".$locale['PERS_113']."</td>
<td><input type='text' name='person_foto' class='textbox' style='width:300px;' value='".$data['person_foto']."' /> <a href='".BASEDIR."infusions/person_database/file_uploads_admin.php' class='side' target='_blank'onClick='window.open(\"".BASEDIR."infusions/person_database/file_uploads_admin.php\", \"opload\",\"toolbar=no,scrollbars=yes,resizable=yes,width=600,height=400\"); return false;'> ".$locale['fup120']."</a></td>
</tr>
<tr>
<td>".$locale['PERS_102']."</td>
<td><input type='text' name='person_vej' class='textbox' style='width:300px;' value='".$data['person_vej']."' /></td>
</tr>
<tr>
<td>".$locale['PERS_103']."</td>
<td><input type='text' name='person_ponr' class='textbox' style='width:300px;' value='".$data['person_ponr']."' /></td>
</tr>
<tr>
<td>".$locale['PERS_104']."</td>
<td><input type='text' name='person_bynavn' class='textbox' style='width:300px;' value='".$data['person_bynavn']."' /></td>
</tr>
<tr>
<td>".$locale['PERS_105']."</td>
<td><input type='text' name='person_rygnr' class='textbox' style='width:300px;' value='".$data['person_rygnr']."' /></td>
</tr>
<tr>
<td>".$locale['PERS_116']."</td>
<td><input type='text' name='person_mobil' class='textbox' style='width:40px;' value='".$data['person_mobil']."' /></td>
</tr>
<tr>
<td>".$locale['PERS_107']."</td>
<td><input type='text' name='person_email' class='textbox' style='width:300px;' value='".$data['person_email']."' /></td>
</tr>
<tr>
<td>".$locale['PERS_106']."</td>
<td><input type='text' name='person_nummer' class='textbox' style='width:300px;' value='".$data['person_nummer']."' /></td>
</tr>
<tr>
<td>".$locale['PERS_201']."</td>
<td><input type='text' name='person_indmeldt' class='textbox' style='width:300px;' value='".$data['person_indmeldt']."' /></td>
</tr>
<tr>
<td>".$locale['PERS_202']."</td>
<td><input type='text' name='person_hold' class='textbox' style='width:300px;' value='".$data['person_hold']."' /></td>
</tr>
<tr>
<td>".$locale['PERS_109']."</td>
<td><input type='text' name='person_tele' class='textbox' style='width:300px;' value='".$data['person_tele']."' /></td>
</tr>
<tr>
<td>".$locale['PERS_110']."</td>
<td><input type='text' name='person_hoj' class='textbox' style='width:40px;' value='".$data['person_hoj']."' /></td>
</tr>
<tr>
<td>".$locale['PERS_108']."</td>
<td><input type='text' name='person_vag' class='textbox' style='width:40px;' value='".$data['person_vag']."' /></td>
</tr>
<tr>
<td valign='top'>".$locale['PERS_111']."</td>
<td><textarea name='person_opl' rows='5' class='textbox' style='width:300px;'>".nl2br(parseubb(parsesmileys($data['person_opl'])))."</textarea><br />";
echo display_bbcodes("300px", "person_opl", "editform")."</td>
</tr>
<tr>
<td valign='top'>".$locale['PERS_200']."</td>
<td><textarea name='person_bommert' rows='5' class='textbox' style='width:300px;'>".nl2br(parseubb(parsesmileys($data['person_bommert'])))."</textarea><br />";
echo display_bbcodes("300px", "person_bommert", "editform")."</td>
</tr>
<tr>
<td valign='top'>".$locale['PERS_117']."</td>
<td><textarea name='person_positiv' rows='5' class='textbox' style='width:300px;'>".nl2br(parseubb(parsesmileys($data['person_positiv'])))."</textarea><br />";
echo display_bbcodes("300px", "person_positiv", "editform")."</td>
</tr>
<tr>
<td valign='top'>".$locale['PERS_118']."</td>
<td><textarea name='person_negativ' rows='5' class='textbox' style='width:300px;'>".nl2br(parseubb(parsesmileys($data['person_negativ'])))."</textarea><br />";
echo display_bbcodes("300px", "person_negativ", "editform")."</td>
</tr>
<tr>
<td valign='top'>".$locale['PERS_119']."</td>
<td><textarea name='person_description' rows='5' class='textbox' style='width:300px;'>".nl2br(parseubb(parsesmileys($data['person_description'])))."</textarea><br />";
echo display_bbcodes("300px", "person_description", "editform")."</td>
</tr>
<tr>
<td align='center' colspan='2'>
<input type='submit' name='edit_person' value='".$locale['PERS_134']."' class='button'></td>
</tr>
</table>
</form>\n";
closetable();
}
}