Pilot Center Problem with Database

[xhubix]

Hello Community,

I added in the following Database phpvms_pilots eight new Fields called "vatsimid, ivaoid, msn, icq, skype, nearest aiport as nearest and birthday" so far so good.

My Pilot_main.tpl looks like this

<table id="profile" width="550" border="0" cellspacing="1" cellpadding="3">

<tr>

<td colspan="3" bgcolor="#666666"><center><strong><font color="#FFFFFF">Member Details</font></strong></center></div></td>

</tr>

<tr>

<td align="right" bgcolor="#CCCCCC">Name</td>

<td bgcolor="#CCCCCC"><?php echo $userinfo->firstname . ' ' . $userinfo->lastname; ?></td>

<td valign="top" align="center" rowspan="12" bgcolor="#CCCCCC"><img src="<?php echo PilotData::getPilotAvatar($pilotcode); ?>" /><br /> <br /><strong><?php echo $userinfo->rank;?></strong><br />

<img src="<?php echo $userinfo->rankimage ?>" /><br /> <br />  <br />

<strong>OPTIONEN</strong><br /> <br /><a href="<?php echo url('/profile/editprofile'); ?>">Profil editieren</a><br />

<a href="<?php echo url('/profile/changepassword'); ?>">Passwort ändern</a><br />

<a href="<?php echo url('/profile/badge'); ?>">Signatur anzeigen</a></td>

</tr>

<tr>

<td align="right" bgcolor="#EEEEEE">Piloten ID </td>

<td bgcolor="#EEEEEE"><?php echo $pilotcode; ?></td>

</tr>

<tr>

<td align="right" bgcolor="#CCCCCC">Mitglied seit</td>

<td bgcolor="#CCCCCC"><?php echo $userinfo->joindate;?></td>

</tr>

<tr>

<td align="right" bgcolor="#EEEEEE">letzter Login</td>

<td bgcolor="#EEEEEE"><?php echo $userinfo->lastlogin;?></td>

</tr>

<tr>

<td align="right" bgcolor="#CCCCCC">Nächster Flughafen</td>

<td bgcolor="#CCCCCC"><?php echo $userinfo->airport;?></td>

</tr>

<tr>

<td align="right" bgcolor="#EEEEEE">Geburtstag</td>

<td bgcolor="#EEEEEE"><?php echo $userinfo->birthday;?></td>

</tr>

<tr>

<td align="right" bgcolor="#CCCCCC">eMail</td>

<td bgcolor="#CCCCCC"><?php echo $userinfo->email;?></td>

</tr>

<tr>

<td align="right" bgcolor="#EEEEEE">ICQ</td>

<td bgcolor="#EEEEEE"><?php echo $userinfo->icq;?></td>

</tr>

<tr>

<td align="right" bgcolor="#CCCCCC">MSN</td>

<td bgcolor="#CCCCCC"><?php echo $userinfo->msn;?></td>

</tr>

<tr>

<td align="right" bgcolor="#EEEEEE">Skype</td>

<td bgcolor="#EEEEEE"><?php echo $userinfo->skype;?></td>

</tr>

<tr>

<td align="right" bgcolor="#CCCCCC">IVAO-ID</td>

<td bgcolor="#CCCCCC"><?php echo $userinfo->ivao;?></td>

</tr>

<tr>

<td align="right" bgcolor="#EEEEEE">VATSIM-ID</td>

<td bgcolor="#EEEEEE"><?php echo $userinfo->vatsim;?></td>

</tr>

</table>

<br />

<table id="profile" width="550" border="0" cellspacing="1" cellpadding="3">

<tr>

<td bgcolor="#666666"><center><font style="font-weight:bold; color:#FFFFFF;">Fortschritt</font></center></td>

</tr>

<tr>

<td bgcolor="#CCCCCC">Du brauchst noch <?php echo ($nextrank->minhours - $pilot_hours)?> Stunden bis zu deinem Aufstieg zum <strong><?php echo $nextrank->rank?></strong></td>

</tr>

</table>

So far so good, but when i would like to Edit this new rows, i press the submit button and came back to my profile, there are no changes submitted

Can anyone gave me an Code to get this .tpl Working ?

Greets from Austria

xhubix

[Parkho]

In order to submit changes you'll need to pass those values to a function that eventually stores those values in the db table.

Also for your pilots to be able to fill those fields you'll need to modify the codes to store those field values as well unless you have used the add field feature which is a lot easier.

[xhubix]

okay thanks , i try my best. i let you know when i have found a way to solve this