Jump to content

Tato123

Members
 View Profile  See their activity

  • Posts

    150

  • Joined

  • Last visited

 Content Type 

Posts posted by Tato123

  3. Table with Row in multiple column

    in Skinning

    Posted

    Hi, thanks for help

    I try with this code:

    <?php
if(!$allawardtpes)
{
echo 'Non sono disponibili Spille!';
return;
}
foreach($allawardtpes as $type)
{
?>
<h3><?php echo $type->typ_name;?></h3>
 <?php
$allissuedawards = vAwardsData::GetAllIssuedAward($pilotid, $type->typ_id);
if(!$allissuedawards)
{
 echo 'Nessuna Spilla Assegnata';
 $allissuedawards = array();
}
foreach($allissuedawards as $award)
{
?>
 <?php if(!empty($award->awd_image))
{
?>
<br />
<table>
<div id="awards" style="float:left;text-align:left;"><img src="<?php echo $award->awd_image;?>" /></div>
</table>
 <?php
}
else
{
?>
 Immagine Spilla non disponibile
 <?php
}
?>
<?php
}
?>
<?php
}
?>

    But the result is not good

    error1.jpeg

    Do yuo have any suggestion?

    Thanks

  4. Table with Row in multiple column

    in Skinning

    Posted

    Hi Guys,

    i have a problem

    <?php
if(!$allawardtpes)
{
echo 'Non sono disponibili Spille!';
return;
}
foreach($allawardtpes as $type)
{
?>
<h3><?php echo $type->typ_name;?></h3>
<p>
<?php
$allissuedawards = vAwardsData::GetAllIssuedAward($pilotid, $type->typ_id);
if(!$allissuedawards)
{
echo 'Nessuna Spilla Assegnata';
$allissuedawards = array();
}
foreach($allissuedawards as $award)
{
?>
<?php if(!empty($award->awd_image))
{
?>
<br />
<table>
<th><img src="<?php echo $award->awd_image;?>" /><th>
<th><?php echo $award->awd_name;?></th>
</table>
<?php
}
else
{
?>
Immagine Spilla non disponibile
<?php
}
?>
</p>
<?php
}
?>
<?php
}
?>

    With this code, I create a table where each row corresponds to a given award

    example:

    A award

    B award

    C award

    D award

    E award

    F award

    I would like to create the table in this way:

    Aaward Baward Caward

    Daward Eaward Faward

    Can anyone help me?

  6. Function "New Pilots"

    in Support Forum

    Posted

    Hello guys,

    I wanted your help because I do not work correctly the "new pilots"

    If a pilot is enrolled in my company, but it is still not accepted, I do not see this pilot in the "new pilots."

    If you confirm the pilot from admin pannel, this form disappears from the "new riders" and it makes me see dpilots registered for a long time and not in order of date of registration.

    Do you have any suggestions?

    Regards

    Alberto

  7. how to show only pilots with a custom fields in pilot list

    in Development Help

    Posted

    Hello Guys,

    I am creating 3 different pages called pilot list

    The first shows me the hours reported by the company kacars

    The second with the hours VATSIM

    The third with hours of IVAO

    I wanted to ask if you can see my page number 2 or 3 in which only the pilots IVAO (custom field) is populated by the number of VID?

    Or show the pilots by Group members

    I also created the appropriate module for each page

    I would like to see on the second page only drivers with custom field VATSIM populated,

    only in the third IVAO pilots with custom field populated.

    is it possible?

    • Like 1

  9. Echo multiple value

    in Development Help

    Posted

    I would add the suffix VAR pilot in front of the id. (VAR901)

    I can not use the code because the pilot is in another table.

    Second thing, I wish id pilot was seen in three digits. Now I show 1 instead of 001

    I find this way but I do not know how to apply it to my query

    {

    # Make sure values ​​are Entered

    if (Config :: Get ('PILOTID_LENGTH') =='')

    Config :: Set ('PILOTID_LENGTH', 4);

    if (Config :: Get ('PILOTID_OFFSET') =='')

    Config :: Set ('PILOTID_OFFSET', 0);

    $ pilotid pilotid + = $ Config :: Get ('PILOTID_OFFSET');

    return $ code. str_pad ($ pilotid, Config :: Get ('PILOTID_LENGTH'), '0 ', STR_PAD_LEFT);

    }

    Do you have any suggestions?

    Thanks

  11. Echo multiple value

    in Development Help

    Posted

    Thanks Tom for you repley.

    I put the query

    $query = "SELECT *, GROUP_CONCAT(grt_pilotid) as pilots_list FROM vawards_awards f

    LEFT JOIN vawards_grants p ON p.grt_awdid = f.awd_id

    WHERE f.typ_id = '1'

    GROUP BY f.awd_id";

    $list=DB::get_results($query);

    foreach ( $list as $ist)

    {

    ?>

    <tr>

    <th><img src="<?php echo $ist->awd_image ?>"</th>

    <th><div align="left"><?php echo $ist->awd_name ?> </div></th>

    <th><?php echo $ist->grt_pilotid ?></th>

    </tr>

    <?php

    }

    ?>

    </table>

    <br />

    But i show only 1 grt_pilot id and not the all pilots.

    If you wont see here:

    http://www.virtualir...x.php/allawards

    Is correct no change the line <th><?php echo $ist->grt_pilotid ?></th> ???

    I need to show in the same column all the pilots id for that award

  12. Echo multiple value

    in Development Help

    Posted

    ?>

    </br>

    <table id="tabledlist" class="tablevar">

    <td>Spilla</td>

    <td>Nome</td>

    <td>Piloti</td>

    </tr>

    <?php

    $query="SELECT * FROM vawards_awards f

    LEFT JOIN vawards_grants p ON p.grt_awdid = f.awd_id

    WHERE f.typ_id = '1'";

    $list=DB::get_results($query);

    foreach ( $list as $ist)

    {

    ?>

    <tr>

    <th><img src="<?php echo $ist->awd_image ?>"</th>

    <th><div align="left"><?php echo $ist->awd_name ?> </div></th>

    <th><?php echo $ist->grt_pilotid ?></th>

    </tr>

    <?php

    }

    ?>

    </table>

    <br />

    Hallo Guy,

    i have a little problem.

    When i use the echo function : <th><?php echo $ist->grt_pilotid ?></th> the system dublicate any row for each record.

    Is possible have a column with multiple value separated from ; or ,

    Example:

    the quaery sort all awards in dbase splitted for category.

    I need for all award the pilots list.

    Category

    Airline

    Image Award - Description, And the pilots VAR901, VAR902, VAR 505

    Now i see a row for pilots

    http://www.virtualir...x.php/allawards

    I need only one row for award and the column Piloti multiple value

    • Like 1

  14. vAwards

    in KJRDev Addons

    Posted

    Hi

    Can I ask a little help?

    I need to post on a page, all the drivers that have a specific award

    for example

    categories:

    Neuro Flight

    Airline

    etc etc

    Award:

    Neuro Flight to Canefield

    IFR Tour 2013

    etc etc

    I need to compile a table showing:

    Pilot 1> Neuro Flight to Canefield

    Pilor 2> Neuro Flight to Canefield

    another table

    Pilot 1> IFR Tour 2013

    Pilot 3> IFR Tour 2013

    Can you please tell me how to structure the query?

    Thanks and Happy New Year

  25. Please help me !

    in Skinning

    Posted

    I would like to place the logo of the company, but the skin "Vairline" will not let me. Do you have any idea on how to maintain the shape and character and adapt my top for the site?

    Second problem, if I use chrome everything is ok, with IE and Firefox tables in CSS are not displayed.

×
×
  • Create New...