YourWBB

ALTER TABLE `bb1_users` ADD `user_nation` NOT NULL ;

$nation = $users['userpage_nation'];

<tr bgcolor="{tablecolora}" id="tablea">
    <td><smallfont><b>Nation:</b></font></td>
    <td><input type="text" class="input" name="Nation" value="$userpage[userpage_nation]" maxlength="20"></td>
</tr>

    <tr>
      <td width="50%" valign="top" bgcolor="$spalte1"><font size="$schrift_groese" color="$text"><b>Nation:</b></font></td>
      <td width="50%" valign="top" bgcolor="$spalte2"><font size="$schrift_groese" color="$text">$nation</font></td>
    </tr>

if($action=="userpage_design_edit") { if(isset($_POST['send'])) { $db->query("DELETE FROM bb".$n."_userpage_userdesign WHERE userid='$wbbuserdata[userid]'"); $db->query("INSERT INTO `bb".$n."_userpage_userdesign` (`userid` , `textfarbe` , `hintergrundfarbe` , `ueberschriftfarbe` , `Tabellenkopf` , `spaltenfarbe_1` , `spaltenfarbe_2` , `schriftart` , `font_size` , `innere_hintergrund` , `ganz_innen_tabelle` ) VALUES ( '$wbbuserdata[userid]', '$_POST[textfarbe]', '$_POST[hintergrund]', '$_POST[u_textfarbe]', '$_POST[tabellenkopf]', '$_POST[spalte1]', '$_POST[spalte2]', '$_POST[schriftart]', '$_POST[schriftgroese]', '$_POST[innere_hintergrund]', '$_POST[innerste_hintergrund]');"); header("Location: usercp.php?action=userpage_design_edit&sid=$session[hash]"); } $design = $db->query_first("SELECT * FROM bb".$n."_userpage_userdesign WHERE userid='$wbbuserdata[userid]'"); $config = $db->query_first("SELECT own_design FROM bb".$n."_userpage_config"); if($config['own_design']=="0") access_error(); $hintergrund = $design['hintergrundfarbe']; $innere_hintergrund = $design['innere_hintergrund']; $innerste_hintergrund = $design['ganz_innen_tabelle']; $textfarbe = $design['textfarbe']; $schriftart = $design['schriftart']; $schriftgroese = $design['font_size']; $u_textfarbe = $design['ueberschriftfarbe']; $tabellenkopf = $design['Tabellenkopf']; $spalte1 = $design['spaltenfarbe_1']; $spalte2 = $design['spaltenfarbe_2']; eval("\$tpl->output(\"".$tpl->get("usercp_userpage_design")."\");"); } if($action=="userpage_details_edit") { if(isset($_POST['send'])) { $userpage_userbild_url = $_POST[Userbild_URL]; $userpage_userbild_url = str_replace("'", "\'", $userpage_userbild_url); $userpage_single = $_POST[Single]; $userpage_single = str_replace("'", "\'", $userpage_single); $beschreibung = $_POST[Beschreibung]; $beschreibung = str_replace("'", "\'", $beschreibung); $db->query("UPDATE bb".$n."_users SET userbild_auswahl='$_POST[Userbild]', userpage_userbild_url='$userpage_userbild_url', userpage_single='$userpage_single', userpage_beschreibung='$beschreibung' WHERE userid='".$wbbuserdata['userid']."'"); header("Location: usercp.php?action=userpage_details_edit&sid=$session[hash]"); exit; } $userpage = $db->query_first("SELECT * FROM bb".$n."_users WHERE userid='$wbbuserdata[userid]'"); If ($userpage[userbild_auswahl] == '0') { $auswahl_0=" selected"; } else { If ($userpage[userbild_auswahl] == '1') { $auswahl_1=" selected"; } else { If ($userpage[userbild_auswahl] == '2') { $auswahl_2=" selected"; } } } $message = $userpage['userpage_beschreibung']; $beschreibung=parse::convertHTML($message); eval("\$tpl->output(\"".$tpl->get("usercp_userpage_details")."\");"); }