VATSIM Airline

[JackPlumb]

Dear All,

As a requirement of VATSIM airline I need to have the ability to place the User I.D on the roster. Is there anyway I can do this at all?

[cale250]

Use the custom fields option in the administration panel under Site & Settings/ Profile Fields.

[JackPlumb]

I have done this, but i need to know how it could be placed on the 'pilots' page.

[Wayne]

What exactly do you mean the pilots page? The pilot center in phpVMS or somewhere for VATSIM?

[Strider]

He means to show on the roster, and not have people go into the public profiles.

Cheers

Dan C

[cale250]

That's not all that hard either. Check what Nabeel already added into the template for the pilot list:

/* 
	To include a custom field, use the following example:

	<td>
		<?php echo PilotData::GetFieldValue($pilot->pilotid, 'VATSIM ID'); ?>
	</td>

	For instance, if you added a field called "IVAO Callsign":

		echo PilotData::GetFieldValue($pilot->pilotid, 'IVAO Callsign');		
 */

You can find this in the your core/templates/pilots_list.tpl.

[JackPlumb]

I have done this and have abit of problem, the vatsim id is on the table. Concluding from this the actual I.D isn't showing, even though it has been inserted on the profile of every pilot.

[Nabeel]

Hey,

Can you try this real quick, where you put the GetFieldValue();, immediately after, if you put DB::debug(), what's the result?:

<?php echo PilotData::GetFieldValue($pilot->pilotid, 'VATSIM ID'); DB::debug() ?>

Can you paste it in?

Thanks!

[JackPlumb]

I get this reply:

ezSQL (v2.03) Debug..

Query [7] -- [sELECT v.value FROM phpvms_customfields f, phpvms_fieldvalues v WHERE f.fieldid=v.fieldid AND f.title='VATSIM ID' AND v.pilotid=4]

Query Result..

    (row)	string 0
    value
    No Results

[Strider]

What code would i need to put the vataware link and graphic onto the roster?

Cheers

Dan C

[Nabeel]

What did you call that field in the admin panel?

[JackPlumb]

The feild is VATSIM I.D

[Leiserson]

If its really has the dot between the I and the D you must include it in the query because as you add it in the admin panel it inserts it in the DB as you wrote it.

[Nabeel]

Then you would do:

<?php echo PilotData::GetFieldValue($pilot->pilotid, 'VATSIM.ID'); DB::debug() ?>

That field name must be exactly as you entered it